{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Settings","Sample"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Settings","index":0,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Transaction Description",null,"Pd"]
[null,null,1,"Buy Inventory",null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[]
[]
[]
[]
[]
[null,{"$f":"$C$11","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(C12)),VLOOKUP(C12,$C$2:$F$6,4,FALSE),\"\")","v":""},null,{"$f":"$I$11","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(I12)),VLOOKUP(I12,$C$2:$F$6,4,FALSE),\"\")","v":""},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,0,null,null,null,"",null,0,null,null,null,"",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,0,null,null,null,"",null,0,null,null,null,"",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,0,null,null,null,"",null,0,null,null,null,"",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,0,null,null,null,"",null,0,null,null,null,"",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,0,null,null,null,"",null,0,null,null,null,"",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,0,null,null,null,"",null,0,null,null,null,"",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,0,null,null,null,"",null,0,null,null,null,"",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"SUM(D12:D19)","v":0},0,null,null,null,null,{"$f":"SUM(J12:J19)","v":0},0]
[null,null,null,{"$f":"IF(D20>E20,D20-E20,0)","v":0},{"$f":"IF(E20>D20,E20-D20,0)","v":0},null,null,null,null,{"$f":"IF(J20>K20,J20-K20,0)","v":0},{"$f":"IF(K20>J20,K20-J20,0)","v":0}]
[]
[]
[]
[null,null,null,"Transaction Count:",5]
[null,null,null,"Height:",8]
[null,null,null,"Tall:",3]
[null,null,null,"Wide:",4]
[null,null,null,"Periods:",1]
[]
[]
[null,null,null,null,"Generate"]

{"sheet":"Sample","index":1,"n_rows":45,"n_cols":33,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Transaction Description",null,"Pd"]
[null,null,1,"Buy Inventory",null,1]
[null,null,2,"Sell inventory",null,1]
[null,null,3]
[null,null,4]
[null,null,5]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"SUM(AG10)","v":250},{"$f":"SUMPRODUCT(($B$11:$B$1010=$AE10)*($F$11:$F$1010=AG$9)*($G$11:$G$1010))+SUMPRODUCT(($I$11:$I$1010=$AE10)*($M$11:$M$1010=AG$9)*($N$11:$N$1010))+SUMPRODUCT(($P$11:$P$1010=$AE10)*($T$11:$T$1010=AG$9)*($U$11:$U$1010))+SUMPRODUCT(($W$11:$W$1010=$AE10)*($AA$11:$AA$1010=AG$9)*($AB$11:$AB$1010))","v":250}]
[null,null,"L","A/P",null,null,null,null,null,"A","Inventory",null,null,null,null,null,"A","A/R",null,null,null,null,null,"S","Sales",null,null,null,null,null,"L",-200,-200]
[null,{"$f":"$C$11","v":"L"},1,null,200,{"$f":"IF(NOT(ISBLANK(C12)),VLOOKUP(C12,$C$2:$F$6,4,FALSE),\"\")","v":1},{"$f":"D12-E12","v":-200},null,{"$f":"$J$11","v":"A"},1,200,null,{"$f":"IF(NOT(ISBLANK(J12)),VLOOKUP(J12,$C$2:$F$6,4,FALSE),\"\")","v":1},{"$f":"K12-L12","v":200},null,{"$f":"$Q$11","v":"A"},2,250,null,{"$f":"IF(NOT(ISBLANK(Q12)),VLOOKUP(Q12,$C$2:$F$6,4,FALSE),\"\")","v":1},{"$f":"R12-S12","v":250},null,{"$f":"$X$11","v":"S"},null,null,null,{"$f":"IF(NOT(ISBLANK(X12)),VLOOKUP(X12,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"Y12-Z12","v":0},null,null,"E",0,0]
[null,"L",null,null,null,"",0,null,"A",2,null,200,1,-200,null,"A",null,null,null,"",0,null,"S",2,null,250,1,-250,null,null,"Bal Sht",50,{"$f":"SUM(AG10:AG12)","v":50}]
[null,"L",null,null,null,"",0,null,"A",null,null,null,"",0,null,"A",null,null,null,"",0,null,"S",null,null,null,"",0]
[null,"L",null,null,null,"",0,null,"A",null,null,null,"",0,null,"A",null,null,null,"",0,null,"S",null,null,null,"",0,null,null,"S",-250,-250]
[null,"L",null,null,null,"",0,null,"A",null,null,null,"",0,null,"A",null,null,null,"",0,null,"S",null,null,null,"",0,null,null,"C",200,200]
[null,"L",null,null,null,"",0,null,"A",null,null,null,"",0,null,"A",null,null,null,"",0,null,"S",null,null,null,"",0,null,null,"E",0,0]
[null,"L",null,null,null,"",0,null,"A",null,null,null,"",0,null,"A",null,null,null,"",0,null,"S",null,null,null,"",0,null,null,"I",0,0]
[null,"L",null,null,null,"",0,null,"A",null,null,null,"",0,null,"A",null,null,null,"",0,null,"S",null,null,null,"",0,null,null,"Inc Stmt",-50,{"$f":"SUM(AG15:AG18)","v":-50}]
[null,null,null,{"$f":"SUM(D12:D19)","v":0},200,null,null,null,null,null,{"$f":"SUM(K12:K19)","v":200},200,null,null,null,null,null,{"$f":"SUM(R12:R19)","v":250},0,null,null,null,null,null,{"$f":"SUM(Y12:Y19)","v":0},250]
[null,null,null,{"$f":"IF(D20>E20,D20-E20,0)","v":0},{"$f":"IF(E20>D20,E20-D20,0)","v":200},null,null,null,null,null,{"$f":"IF(K20>L20,K20-L20,0)","v":0},{"$f":"IF(L20>K20,L20-K20,0)","v":0},null,null,null,null,null,{"$f":"IF(R20>S20,R20-S20,0)","v":250},{"$f":"IF(S20>R20,S20-R20,0)","v":0},null,null,null,null,null,{"$f":"IF(Y20>Z20,Y20-Z20,0)","v":0},{"$f":"IF(Z20>Y20,Z20-Y20,0)","v":250}]
[]
[null,null,"C","COGS"]
[null,{"$f":"$C$23","v":"C"},null,null,null,{"$f":"IF(NOT(ISBLANK(C24)),VLOOKUP(C24,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"D24-E24","v":0},null,{"$f":"$J$23","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(J24)),VLOOKUP(J24,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"K24-L24","v":0},null,{"$f":"$Q$23","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(Q24)),VLOOKUP(Q24,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"R24-S24","v":0},null,{"$f":"$X$23","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(X24)),VLOOKUP(X24,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"Y24-Z24","v":0}]
[null,"C",2,200,null,1,200,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,null,"Tran #","Total"]
[null,"C",null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,null,1,{"$f":"SUMPRODUCT(($C$11:$C$1010=$AE26)*($G$11:$G$1010))+SUMPRODUCT(($J$11:$J$1010=$AE26)*($N$11:$N$1010))+SUMPRODUCT(($Q$11:$Q$1010=$AE26)*($U$11:$U$1010))+SUMPRODUCT(($X$11:$X$1010=$AE26)*($AB$11:$AB$1010))","v":0}]
[null,"C",null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,null,2,0]
[null,"C",null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,null,3,0]
[null,"C",null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,null,4,0]
[null,"C",null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,null,5,0]
[null,"C",null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0]
[null,null,null,{"$f":"SUM(D24:D31)","v":200},0,null,null,null,null,null,{"$f":"SUM(K24:K31)","v":0},0,null,null,null,null,null,{"$f":"SUM(R24:R31)","v":0},0,null,null,null,null,null,{"$f":"SUM(Y24:Y31)","v":0},0]
[null,null,null,{"$f":"IF(D32>E32,D32-E32,0)","v":200},{"$f":"IF(E32>D32,E32-D32,0)","v":0},null,null,null,null,null,{"$f":"IF(K32>L32,K32-L32,0)","v":0},{"$f":"IF(L32>K32,L32-K32,0)","v":0},null,null,null,null,null,{"$f":"IF(R32>S32,R32-S32,0)","v":0},{"$f":"IF(S32>R32,S32-R32,0)","v":0},null,null,null,null,null,{"$f":"IF(Y32>Z32,Y32-Z32,0)","v":0},{"$f":"IF(Z32>Y32,Z32-Y32,0)","v":0}]
[]
[]
[null,{"$f":"$C$35","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(C36)),VLOOKUP(C36,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"D36-E36","v":0},null,{"$f":"$J$35","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(J36)),VLOOKUP(J36,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"K36-L36","v":0},null,{"$f":"$Q$35","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(Q36)),VLOOKUP(Q36,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"R36-S36","v":0},null,{"$f":"$X$35","v":0},null,null,null,{"$f":"IF(NOT(ISBLANK(X36)),VLOOKUP(X36,$C$2:$F$6,4,FALSE),\"\")","v":""},{"$f":"Y36-Z36","v":0}]
[null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0]
[null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0]
[null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0]
[null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0]
[null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0]
[null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0]
[null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0,null,0,null,null,null,"",0]
[null,null,null,{"$f":"SUM(D36:D43)","v":0},0,null,null,null,null,null,{"$f":"SUM(K36:K43)","v":0},0,null,null,null,null,null,{"$f":"SUM(R36:R43)","v":0},0,null,null,null,null,null,{"$f":"SUM(Y36:Y43)","v":0},0]
[null,null,null,{"$f":"IF(D44>E44,D44-E44,0)","v":0},{"$f":"IF(E44>D44,E44-D44,0)","v":0},null,null,null,null,null,{"$f":"IF(K44>L44,K44-L44,0)","v":0},{"$f":"IF(L44>K44,L44-K44,0)","v":0},null,null,null,null,null,{"$f":"IF(R44>S44,R44-S44,0)","v":0},{"$f":"IF(S44>R44,S44-R44,0)","v":0},null,null,null,null,null,{"$f":"IF(Y44>Z44,Y44-Z44,0)","v":0},{"$f":"IF(Z44>Y44,Z44-Y44,0)","v":0}]