{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sample Inventory List","Purchase"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Sample Inventory List","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
[]
["Result"]
[null,8000]
["Material",357000,"Change the material number according to your need"]
["Total Stock",13,8]
["BUn"]
["Total Value",1725588.7199999997,{"$f":"Purchase!G16*Purchase!I16+Purchase!G15*Purchase!I15+Purchase!G12*Purchase!I12+Purchase!G11*Purchase!I11+Purchase!G10*Purchase!I10+Purchase!G9*Purchase!I9+Purchase!G8*Purchase!I8+Purchase!G7*Purchase!I7","v":534612.3949999999}]
["Crcy","INR"]
["Material Description","Pm357 O2 Measuring Cell"]
["<30 Days",5,5]
["Over 31 days but less than 60 days",0]
["Over 60 days but less than 90 days",0]
["Over 90 days but less than 120 days",0]
["Over 120 days but less than 182 days",1,1]
["Over 182 days but less than 365 days",0]
["Over 365 days",7,2]
["Over 730 days",0]
["Over 1095 days",0]

{"sheet":"Purchase","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Mat. doc.","Vendor_Acc_No","Purch.doc.","Item","Material","Short text","Quantity","OUn","Rate","Value in local currency","Doc Date","Ageing ","Ageing"]
[5105602684,1000,8145000116,10,357000,"Pm357 O2 Measuring Cell",1,"EA",63733.375,{"$f":"G2*I2","v":63733.375},"2013-06-10","2014-11-30",150]
[5105602701,1000,8145001754,60,357000,"Pm357 O2 Measuring Cell",1,"EA",65000,{"$f":"G3*I3","v":65000},"2013-06-26","2014-11-30",15]
[5105613256,1000,8145001877,40,357000,"Pm357 O2 Measuring Cell",1,"EA",70715.214999999997,70715.214999999997,"2014-02-14","2014-11-30",455]
[5105602684,1000,8145000116,10,357000,"Pm357 O2 Measuring Cell",1,"EA",63733.375,63733.375,"2013-06-10","2014-11-30",{"$f":"L5-K5","v":538}]
[5105602701,1000,8145001754,60,357000,"Pm357 O2 Measuring Cell",1,"EA",65000,65000,"2013-06-26","2014-11-30",15]
[5105613256,1000,8145001877,40,357000,"Pm357 O2 Measuring Cell",1,"EA",70715.214999999997,70715.214999999997,"2014-02-14","2014-11-30",455]
[5105602684,1000,8145000116,10,357000,"Pm357 O2 Measuring Cell",1,"EA",63733.375,63733.375,"2013-06-10","2014-11-30",{"$f":"L8-K8","v":538}]
[5105602701,1000,8145001754,60,357000,"Pm357 O2 Measuring Cell",1,"EA",65000,65000,"2013-06-26","2014-11-30",15]
[5105613256,1000,8145001877,40,357000,"Pm357 O2 Measuring Cell",1,"EA",70715.214999999997,70715.214999999997,"2014-02-14","2014-11-30",455]
[5105602684,1000,8145000116,10,357000,"Pm357 O2 Measuring Cell",1,"EA",63733.375,63733.375,"2013-06-10","2014-11-30",{"$f":"L11-K11","v":538}]
[5105602701,1000,8145001754,60,357000,"Pm357 O2 Measuring Cell",1,"EA",65000,65000,"2013-06-26","2014-11-30",15]
[5105613256,1000,8145001877,40,45,"Pm357 O2 Measuring Cell",1,"EA",70715.214999999997,141430.43,"2014-02-14","2014-11-30",455]
[5105602684,1000,8145000116,10,22,"Pm357 O2 Measuring Cell",1,"EA",63733.375,127466.75,"2013-06-10","2014-11-30",{"$f":"L14-K14","v":538}]
[5105602701,1000,8145001754,60,357000,"Pm357 O2 Measuring Cell",1,"EA",65000,{"$f":"G15*I15","v":65000},"2013-06-26","2014-11-30",15]
[5105613256,1000,8145001877,40,357000,"Pm357 O2 Measuring Cell",1,"EA",70715.214999999997,70715.214999999997,"2014-02-14","2014-11-30",455]