{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ITEM RECEIVED","ITEM LIST","SUPPLIER LIST","AVIL ITEM"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"ITEM RECEIVED","index":0,"n_rows":10,"n_cols":32,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["DATE","INVOICE NO","SUPPLIER NAME","ITEM CODE","ITEM NAME","QTY","UNIT PRICE","ITEM CODE","ITEM NAME","QTY","UNIT PRICE","ITEM CODE","ITEM NAME","QTY","UNIT PRICE","ITEM CODE","ITEM NAME","QTY","UNIT PRICE","ITEM CODE","ITEM NAME","QTY","UNIT PRICE","ITEM CODE","ITEM NAME","QTY","UNIT PRICE","SUB TOTAL","TAX","VALUE INCL TAX","DISC","INVOICE VALUE"]
["2022-01-01",1234,"BANGUR","AB1","ABCD",64,87,null,null,null,null,null,null,null,null,"AB6","UVWX",55,89,null,null,null,null,"AB5","QRST",41,46,{"$f":"SUM(PRODUCT(F3,G3),PRODUCT(J3,K3),PRODUCT(N3,O3),PRODUCT(R3,S3),PRODUCT(V3,W3),PRODUCT(Z3,AA3))","v":12349},0.06,{"$f":"SUM(AB3,PRODUCT(AB3,AC3))","v":13089.94},null,{"$f":"(AD3-AE3)","v":13089.94}]
["2022-02-14",5678,"KOLKATA","AB2","EFGH",23,47,null,null,null,null,"AB4","MNOP",77,11,"AB3","IJKL",29,51,"AB1","ABCD",51,87,null,null,null,null,{"$f":"SUM(PRODUCT(F4,G4),PRODUCT(J4,K4),PRODUCT(N4,O4),PRODUCT(R4,S4),PRODUCT(V4,W4),PRODUCT(Z4,AA4))","v":7844},0.06,{"$f":"SUM(AB4,PRODUCT(AB4,AC4))","v":8314.64},null,{"$f":"(AD4-AE4)","v":8314.64}]
["2022-03-24",2468,"BARASAT","AB3","IJKL",39,51,"AB1","ABCD",56,87,"AB2","EFGH",23,47,"AB5","QRST",29,46,"AB6","UVWX",43,89,null,null,null,null,{"$f":"SUM(PRODUCT(F5,G5),PRODUCT(J5,K5),PRODUCT(N5,O5),PRODUCT(R5,S5),PRODUCT(V5,W5),PRODUCT(Z5,AA5))","v":13103},0.06,13889.18,null,13889.18]
["2022-03-29",2486,"BARASAT","AB3","IJKL",39,51,"AB1","ABCD",56,87,"AB2","EFGH",23,47,"AB5","QRST",29,46,"AB6","UVWX",43,89,null,null,null,null,{"$f":"SUM(PRODUCT(F6,G6),PRODUCT(J6,K6),PRODUCT(N6,O6),PRODUCT(R6,S6),PRODUCT(V6,W6),PRODUCT(Z6,AA6))","v":13103},0.06,{"$f":"SUM(AB6,PRODUCT(AB6,AC6))","v":13889.18},null,{"$f":"(AD6-AE6)","v":13889.18}]
[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,0,null,0,null,0]
[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,0,null,0,null,0]
[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,0,null,{"$f":"SUM(AB9,PRODUCT(AB9,AC9))","v":0},null,{"$f":"(AD9-AE9)","v":0}]
[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,0,null,{"$f":"SUM(AB10,PRODUCT(AB10,AC10))","v":0},null,{"$f":"(AD10-AE10)","v":0}]

{"sheet":"ITEM LIST","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Sr. No","ITEM CODE","ITEM NAME","Item Qty"]
[null,"AB1","ABCD",{"$f":"SUM(IF(('ITEM RECEIVED'!$D$3:$X$10000=B2)*('ITEM RECEIVED'!$E$3:$Y$10000=C2),'ITEM RECEIVED'!$F$3:$Z$10000))","v":227}]
[null,"AB2","EFGH",{"$f":"SUM(IF(('ITEM RECEIVED'!$D$3:$X$10000=B3)*('ITEM RECEIVED'!$E$3:$Y$10000=C3),'ITEM RECEIVED'!$F$3:$Z$1000))","v":69}]
[null,"AB3","IJKL",{"$f":"SUM(IF(('ITEM RECEIVED'!$D$3:$X$10000=B4)*('ITEM RECEIVED'!$E$3:$Y$10000=C4),'ITEM RECEIVED'!$F$3:$Z$1000))","v":107}]
[null,"AB4","MNOP",{"$f":"SUM(IF(('ITEM RECEIVED'!$D$3:$X$10000=B5)*('ITEM RECEIVED'!$E$3:$Y$10000=C5),'ITEM RECEIVED'!$F$3:$Z$1000))","v":77}]
[null,"AB6","UVWX",{"$f":"SUM(IF(('ITEM RECEIVED'!$D$3:$X$10000=B6)*('ITEM RECEIVED'!$E$3:$Y$10000=C6),'ITEM RECEIVED'!$F$3:$Z$1000))","v":141}]
[null,"AB5","QRST",{"$f":"SUM(IF(('ITEM RECEIVED'!$D$3:$X$10000=B7)*('ITEM RECEIVED'!$E$3:$Y$10000=C7),'ITEM RECEIVED'!$F$3:$Z$1000))","v":99}]

{"sheet":"SUPPLIER LIST","index":2,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Sr. No","Date","Invoice No","Supplier Name","Item Name","Qty","Item Name","Qty","Item Name","Qty","Item Name","Qty","Item Name","Qty","Item Name","Qty","Invoice Value"]
[null,"2022-01-01",1234,"BANGUR","ABCD",64,null,null,null,null,"UVWX",55,null,null,"QRST",41,13089.94]
[null,"2022-02-14",5678,"KOLKATA","EFGH",23,null,null,"MNOP",77,"IJKL",29,"ABCD",51,null,null,8314.64]
[null,"2022-03-24",2468,"BARASAT","IJKL",39,"ABCD",56,"EFGH",23,"QRST",29,"UVWX",43,null,null,13889.18]
[null,"2022-03-29",2486,"BARASAT","IJKL",39,"ABCD",56,"EFGH",23,"QRST",29,"UVWX",43,null,null,13889.18]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"SUMIF(('SUPPLIERLIST'!$a$1:$q$10),h18,('SUPPLIERLIST'!($e$2:$e$10,$g$2:$g$10,$i$2:$i$10,$k$2:$k$10,$m$2:$m$10,$o$2:$o$10)))"]

{"sheet":"AVIL ITEM","index":3,"n_rows":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["ITEM CODE","ITEM NAME","SUPPLIER","LAST ORDER DATE","OPENING STOCK","OPENING STOCK VALUE","ITEM IN QTY","ITEM IN VALUE","PURCHASE RETURN ITEM CODE","PURCHASE RETURN ITEM QTY","PURCHASE RETURN VALUE","STOCK OUT ITEM CODE","STOCK OUT ITEM QTY","SALES RETURN ITEM CODE","SALES RETURN ITEM QTY","AVAILABLE STOCK QTY","AVAILABLE STOCK VALUE","ITEM NEW VALUE PER UNIT"]
["AB1","ABCD"]
["AB2","EFGH"]
["AB3","IJKL"]
["AB4","MNOP"]
["AB6","UVWX"]
["AB5","QRST"]