{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Settings","Product_Master","Sale_Purchase","Sale_Purchase_Display","Inventory","Inventory_Display","Report"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Product_Master","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["ID","Items Name","Size","serial number"]
[{"$f":"ROW()-1","v":1},"item1",36,"a1"]
[{"$f":"ROW()-1","v":2},"item2",27,"a2"]
[3,"item3",29,"a3"]
[4,"item4",28.35,"a4"]
[5,"item5",39,"a5"]
[6,"item6",26,"a6"]
[7,"item7",34,"a7"]
[8,"item8",36,"a8"]
[9,"item9",21,"a9"]
[10,"item10",22,"a10"]
[11,"item11",38,"a11"]
[12,"item12",21,"a12"]
[13,"item13",37,"a13"]
[14,"item14",21,"a14"]
[{"$f":"ROW()-1","v":15},"item15",13.55,"a15"]
[16,"item16",55,"a16"]
[17,"item17",77,"a17"]
[18,"item18",44,"a18"]
[19,"item19",55,"a19"]
[20,"item20",22,"a20"]

{"sheet":"Sale_Purchase","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["S.No","Items Name","Type","Quantity","Send from","Send via","Date"]
[{"$f":"ROW()-1","v":1},"item1","send",12,"aa","ss",{"$f":"ROW()-1","v":"1900-01-01"}]
[2,"item2","receive",32,"qq","ww",{"$f":"ROW()-1","v":"1900-01-02"}]
[3,"item2","receive",32,"rr","yy",{"$f":"ROW()-1","v":"1900-01-03"}]
[4,"item2","send",11,"aa","sss","2022-02-11"]
[5,"item4","receive",33,"WWW","SAA","2022-02-11"]
[6,"item10","receive",13,"HHH","GGG","2022-02-12"]

{"sheet":"Sale_Purchase_Display","index":3,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["S.No","Items Name","Type","Quantity","Send from","Send via","Date"]
[6,"item10","receive",13,"HHH","GGG","2022-02-12"]

{"sheet":"Inventory","index":4,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Items Name","receive","send","Remaining quantity"]
["item2",64,11,53]
["item4",33,0,33]
["item10",13,0,13]
["item3",0,0,0]
["item5",0,0,0]
["item6",0,0,0]
["item7",0,0,0]
["item8",0,0,0]
["item9",0,0,0]
["item11",0,0,0]
["item12",0,0,0]
["item13",0,0,0]
["item14",0,0,0]
["item15",0,0,0]
["item16",0,0,0]
["item17",0,0,0]
["item18",0,0,0]
["item19",0,0,0]
["item20",0,0,0]
["item1",0,12,-12]

{"sheet":"Inventory_Display","index":5,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Items Name","receive","send","Remaining quantity"]
["item2",64,11,53]
["item4",33,0,33]
["item10",13,0,13]
["item3",0,0,0]
["item5",0,0,0]
["item6",0,0,0]
["item7",0,0,0]
["item8",0,0,0]
["item9",0,0,0]
["item11",0,0,0]
["item12",0,0,0]
["item13",0,0,0]
["item14",0,0,0]
["item15",0,0,0]
["item16",0,0,0]
["item17",0,0,0]
["item18",0,0,0]
["item19",0,0,0]
["item20",0,0,0]
["item1",0,12,-12]

{"sheet":"Report","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,"Start Date","2022-02-09"]
[null,"End Date","2022-02-10"]
[]
[null,"Type","Amount"]
[null,"Purchase",{"$f":"SUMIFS(Sale_Purchase!F:F,Sale_Purchase!C:C,Report!B5,Sale_Purchase!G:G,\">=\"&$C$1,Sale_Purchase!G:G,\"<=\"&$C$2)","v":0}]
[null,"Sale",{"$f":"SUMIFS(Sale_Purchase!F:F,Sale_Purchase!C:C,Report!B6,Sale_Purchase!G:G,\">=\"&$C$1,Sale_Purchase!G:G,\"<=\"&$C$2)","v":0}]
[null,"Profit",{"$f":"SUMIFS(Sale_Purchase!H:H,Sale_Purchase!G:G,\">=\"&$C$1,Sale_Purchase!G:G,\"<=\"&$C$2)","v":0}]
[null,"Inventory Quantity",{"$f":"SUM(Inventory!D:D)","v":87}]
[null,"Inventory Value",{"$f":"SUM(Inventory!E:E)","v":0}]