{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Stocks","Dashboard","Summary","Purchased Items","Purchase Order List","Sold Items Details"],"not_rendered":{"charts":0,"images":11,"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":"Stocks","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,8,1,9]]}
[null,"Current Stocks"]
[null,"Sr.#","Item Name","Item Code","Pur./Unit (₹)","Sale/Unit(₹)","Units(Quantities)","Stock Values In (₹)","Back To Home"]
[]
[null,1,"Refrigerator","SP001",7362,{"$f":"E4+E4*10%","v":8098.2},{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D4,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D4,'Sold Items Details'!$G$2:$G$43)","v":0},{"$f":"E4*G4","v":0}]
[null,2,"Air Conditioner","SP002",13668,{"$f":"E5+E5*10%","v":15034.8},{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D5,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D5,'Sold Items Details'!$G$2:$G$43)","v":0},{"$f":"E5*G5","v":0}]
[null,3,"Computer","SP003",15178,16695.8,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D6,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D6,'Sold Items Details'!$G$2:$G$43)","v":10},151780]
[null,4,"Air Purifier","SP004",14666,16132.6,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D7,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D7,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,5,"Speaker","SP005",6122,6734.2,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D8,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D8,'Sold Items Details'!$G$2:$G$43)","v":3},18366]
[null,6,"Televisions","SP006",23706,26076.6,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D9,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D9,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,7,"Blender","SP007",15308,16838.8,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D10,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D10,'Sold Items Details'!$G$2:$G$43)","v":3},45924]
[null,8,"Bread Maker","SP008",11298,12427.8,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D11,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D11,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,9,"Water Purifier","SP009",19626,21588.6,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D12,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D12,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,10,"Kettle","SP010",13869,15255.9,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D13,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D13,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,11,"Water Coolers","SP011",21250,23375,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D14,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D14,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,12,"Refrigerators","SP012",14254,15679.4,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D15,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D15,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,13,"Freezers","SP013",18348,20182.8,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D16,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D16,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,14,"Kitchen Stoves","SP014",18381,20219.099999999999,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D17,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D17,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,15,"Rice Cookers","SP015",15382,16920.2,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D18,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D18,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,16,"Steamer Ovens","SP016",15409,16949.900000000001,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D19,'Purchased Items'!$G$2:$G$72)-SUMIF('Sold Items Details'!$D$2:$D$33,Stocks!D19,'Sold Items Details'!$G$2:$G$43)","v":0},0]
[null,17," Microwaves","SP017",11471,12618.1,{"$f":"SUMIF('Purchased Items'!$D$2:$D$62,Stocks!D20,'Purchased Items'!$G$2:$G$72)","v":0},0]

{"sheet":"Dashboard","index":1,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null," Sale-Purchase Dashboard",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C6,Stocks!$D$2:$G$20,4,FALSE)","v":10}]
[]
[null,"Select Pur/Sale","Sale"]
[]
[null,"Date",{"$f":"TODAY()","v":"2024-01-08"}]
[null,"Item Code",{"$f":"VLOOKUP(C7,Stocks!$C$2:$D$20,2,FALSE)","v":"SP003"}]
[null,"Item Name","Computer","Select Item"]
[null,"Price/Unit (₹)",{"$f":"IF(C3=\"Purchase\",VLOOKUP(C7,Stocks!$C$2:$E$20,3,FALSE),VLOOKUP(C7,Stocks!$C$2:$F$20,4,FALSE))","v":16695.8},{"$f":"VLOOKUP(C6,Stocks!$D$2:$G$20,4,FALSE)","v":10},"Items"]
[null,"Units(Qty.)",5,{"$f":"IF(AND(C3=\"Purchase\",C9>0),\"P\",\"\")","v":""},{"$f":"IF(AND(C3=\"Sale\",C9>D8),\"Sorry!Outof stocks.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Purchase",null,"Sale"]

{"sheet":"Summary","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Sale/Purchase Details"]
[null,null,null,null,null,null,"Purchase Units","Purchase Amounts(₹)","Sales Units","S.Amounts(₹)"]
[null,null,null,"Date",{"$f":"TODAY()","v":"2024-01-08"},null,{"$f":"SUM(E7:E23)","v":0},{"$f":"SUM(F7:F23)","v":0},{"$f":"SUM(G7:G23)","v":0},{"$f":"SUM(H7:H23)","v":0}]
[]
[null,"Sr.#","Item Name","Item Code","Purchase Units (₹)","Pur. Amounts(₹)","Sale Units (₹)","Sales  Amount(₹)"]
[null,1,"Refrigerator","SP001",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D7,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D7,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D7,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D7,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,2,"Air Conditioner","SP002",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D8,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D8,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D8,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D8,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,3,"Computer","SP003",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D9,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D9,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D9,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D9,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0},"Back To Home"]
[null,4,"Air Purifier","SP004",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D10,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D10,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D10,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D10,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,5,"Speaker","SP005",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D11,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D11,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D11,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D11,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,6,"Televisions","SP006",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D12,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D12,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D12,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D12,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,7,"Blender","SP007",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D13,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D13,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D13,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D13,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,8,"Bread Maker","SP008",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D14,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D14,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D14,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D14,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,9,"Water Purifier","SP009",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D15,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D15,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D15,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D15,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,10,"Kettle","SP010",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D16,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D16,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D16,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D16,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,11,"Water Coolers","SP011",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D17,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D17,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D17,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D17,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,12,"Refrigerators","SP012",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D18,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D18,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D18,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D18,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,13,"Freezers","SP013",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D19,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D19,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D19,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D19,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,14,"Kitchen Stoves","SP014",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D20,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D20,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D20,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D20,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,15,"Rice Cookers","SP015",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D21,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D21,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D21,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D21,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,16,"Steamer Ovens","SP016",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D22,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D22,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D22,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D22,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]
[null,17," Microwaves","SP017",{"$f":"SUMIFS('Purchased Items'!$G:$G,'Purchased Items'!$D:$D,Summary!D23,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Purchased Items'!$H:$H,'Purchased Items'!$D:$D,Summary!D23,'Purchased Items'!$C:$C,Summary!$E$4)","v":0},{"$f":"SUMIFS('Sold Items Details'!$G:$G,'Sold Items Details'!$D:$D,Summary!D23,'Sold Items Details'!$C:$C,Summary!$E$4)","v":0},{"$f":"IFERROR(SUMIFS('Sold Items Details'!$H:$H,'Sold Items Details'!$D:$D,Summary!D23,'Sold Items Details'!$C:$C,Summary!$E$4),\"\")","v":0}]

{"sheet":"Purchased Items","index":3,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
[null,"Purchased Items Detail",null,null,null,null,null,null,"Back To Home"]
[null,"Sr.#","Date","Item Code","Item Name","Price/Unit (₹)","Units(Quantities)","Total Stock Values In (₹)"]
[]
[null,{"$f":"IF(C4<>\"\",ROW()-4,\"\")","v":""},null,null,null,null,null,{"$f":"F4*G4","v":0}]
[null,{"$f":"IF(C5<>\"\",ROW()-4,\"\")","v":1},"2023-12-31","SP007","Blender",15308,5,{"$f":"F5*G5","v":76540}]
[null,{"$f":"IF(C6<>\"\",ROW()-4,\"\")","v":2},"2023-12-31","SP003","Computer",15178,15,{"$f":"F6*G6","v":227670}]
[null,{"$f":"IF(C7<>\"\",ROW()-4,\"\")","v":3},"2023-12-31","SP005","Speaker",6122,7,{"$f":"F7*G7","v":42854}]

{"sheet":"Purchase Order List","index":4,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,7,1,8]]}
[null,"Purchase Order List"]
[null,"Sr.#","Item Code","Item Name","Cur. Price/Unit (₹)","Current Stock","Status","Back To Home"]
[null,1,"Refrigerator","SP001",7362,{"$f":"VLOOKUP(D3,Stocks!$D$2:$G$20,4,FALSE)","v":0},{"$f":"IF(F3<5,\"Items are outside the stock limit\",\"Stock is maintain\")","v":"Items are outside the stock limit"}]
[null,2,"Air Conditioner","SP002",13668,{"$f":"VLOOKUP(D4,Stocks!$D$2:$G$20,4,FALSE)","v":0},{"$f":"IF(F4<5,\"Items are outside the stock limit\",\"Stock is maintain\")","v":"Items are outside the stock limit"}]
[null,3,"Computer","SP003",15178,{"$f":"VLOOKUP(D5,Stocks!$D$2:$G$20,4,FALSE)","v":10},"Stock is maintain"]
[null,4,"Air Purifier","SP004",14666,{"$f":"VLOOKUP(D6,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,5,"Speaker","SP005",6122,{"$f":"VLOOKUP(D7,Stocks!$D$2:$G$20,4,FALSE)","v":3},"Items are outside the stock limit"]
[null,6,"Televisions","SP006",23706,{"$f":"VLOOKUP(D8,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,7,"Blender","SP007",15308,{"$f":"VLOOKUP(D9,Stocks!$D$2:$G$20,4,FALSE)","v":3},"Items are outside the stock limit"]
[null,8,"Bread Maker","SP008",11298,{"$f":"VLOOKUP(D10,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,9,"Water Purifier","SP009",19626,{"$f":"VLOOKUP(D11,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,10,"Kettle","SP010",13869,{"$f":"VLOOKUP(D12,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,11,"Water Coolers","SP011",21250,{"$f":"VLOOKUP(D13,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,12,"Refrigerators","SP012",14254,{"$f":"VLOOKUP(D14,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,13,"Freezers","SP013",18348,{"$f":"VLOOKUP(D15,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,14,"Kitchen Stoves","SP014",18381,{"$f":"VLOOKUP(D16,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,15,"Rice Cookers","SP015",15382,{"$f":"VLOOKUP(D17,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,16,"Steamer Ovens","SP016",15409,{"$f":"VLOOKUP(D18,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]
[null,17," Microwaves","SP017",11471,{"$f":"VLOOKUP(D19,Stocks!$D$2:$G$20,4,FALSE)","v":0},"Items are outside the stock limit"]

{"sheet":"Sold Items Details","index":5,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
[null,"Sold Items Detail",null,null,null,null,null,null,"Back To Home"]
[null,"Sr.#","Date","Item Code","Item Name","Price/Unit (₹)","Units(Quantities)","Total Stock Values In (₹)"]
[]
[null,{"$f":"IF(C4<>\"\",ROW()-4,\"\")","v":""},null,null,null,null,null,{"$f":"F4*G4","v":0}]
[null,{"$f":"IF(C5<>\"\",ROW()-4,\"\")","v":1},"2023-12-31","SP007","Blender",16838.8,2,{"$f":"F5*G5","v":33677.599999999999}]
[null,{"$f":"IF(C6<>\"\",ROW()-4,\"\")","v":2},"2023-12-31","SP003","Computer",16695.8,5,{"$f":"F6*G6","v":83479}]
[null,{"$f":"IF(C7<>\"\",ROW()-4,\"\")","v":3},"2023-12-31","SP005","Speaker",6734.2,4,{"$f":"F7*G7","v":26936.799999999999}]