{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Senarai Barang Runcit","pengiraan"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Senarai Barang Runcit","index":0,"n_rows":22,"n_cols":11,"rows_kept":22}
[]
[null," Senarai Barang Runcit"]
[]
[null,null," ","ITEM","KEDAI","KATEGORI","KTT","UNIT","HARGA UNIT","JUMLAH","KOMEN"]
[null,null,{"$f":"\"c\"","v":"c"},"Oren","Barang Runcit","Hasil",2,"lbs",{"v":2.99,"d":"RM2.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":5.98,"d":"RM5.98"}}]
[null,null,{"$f":"\"c\"","v":"c"},"Epal","Dusun","Hasil",3,"lbs",{"v":1.99,"d":"RM1.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":5.97,"d":"RM5.97"}},"Ada kupon"]
[null,null,{"$f":"\"c\"","v":"c"},"Pisang","Barang Runcit","Hasil",1,"sikat",{"v":3.99,"d":"RM3.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":3.99,"d":"RM3.99"}}]
[null,null,"c","Salad","Pasar","Hasil",2,"biji",{"v":2.29,"d":"RM2.29"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":4.58,"d":"RM4.58"}}]
[null,null,"c","Tomato","Pasar","Hasil",4,"lbs",{"v":3.49,"d":"RM3.49"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":13.96,"d":"RM13.96"}}]
[null,null,"c","Labu","Pasar","Hasil",2,"setiap",{"v":1.5,"d":"RM1.50"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":3,"d":"RM3.00"}}]
[null,null,"c","Saderi","Barang Runcit","Hasil",2,"sikat",{"v":1.99,"d":"RM1.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":3.98,"d":"RM3.98"}}]
[null,null,"c","Timun","Pasar","Hasil",1,"lbs",{"v":2.29,"d":"RM2.29"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":2.29,"d":"RM2.29"}}]
[null,null,"c","Cendawan","Barang Runcit","Hasil",0.5,"lbs",{"v":2.25,"d":"RM2.25"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":1.125,"d":"RM1.13"}},"Portabella besar"]
[null,null,"c","Susu ","Hantar ke Rumah","Tenusu",2,"gal",{"v":3.99,"d":"RM3.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":7.98,"d":"RM7.98"}}]
[null,null,"c","Keju","Hantar ke Rumah","Tenusu",1,"lbs",{"v":9.99,"d":"RM9.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":9.99,"d":"RM9.99"}},"Pelbagai keju blok"]
[null,null,"c","Telur","Hantar ke Rumah","Tenusu",2,"doz",{"v":3.5,"d":"RM3.50"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":7,"d":"RM7.00"}}]
[null,null,"c","Keju kotej","Hantar ke Rumah","Tenusu",1,"453.59 g",{"v":3.89,"d":"RM3.89"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":3.89,"d":"RM3.89"}}]
[null,null,"c","Krim masam","Hantar ke Rumah","Tenusu",1,"226.80 g",{"v":2.99,"d":"RM2.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":2.99,"d":"RM2.99"}}]
[null,null,"c","Yogurt","Barang Runcit","Tenusu",1,"453.59 g",{"v":4.99,"d":"RM4.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":4.99,"d":"RM4.99"}},"Greek dengan madu"]
[null,null,"c","Daging Lembu","Pasar","Daging",10,"lbs",{"v":7.99,"d":"RM7.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":79.9,"d":"RM79.90"}},"Filet dibalut bakon"]
[null,null,"c","Salmon","Pasar Ikan","Makanan Laut",6,"lbs",{"v":8.99,"d":"RM8.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":53.94,"d":"RM53.94"}}]
[null,null,"c","Ketam Alaska","Pasar Ikan","Makanan Laut",5,"lbs",{"v":10.99,"d":"RM10.99"},{"$f":"IFERROR(List[KTT]*List[HARGA UNIT],\"\")","v":{"v":54.95,"d":"RM54.95"}}]

{"sheet":"pengiraan","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"hidden":true}
["***  Helaian perlu kekal tersembunyi ***"]
[]
[{"$nulls":10},{"$f":"SUM(List[JUMLAH])-SUM(K6:K9)","v":{"v":0,"d":"RM0"}},{"$f":"ROUND(K3,0)","v":{"v":0,"d":"RM0"}},"JUMLAH LAIN"]
[{"$nulls":11},{"$f":"ROUNDUP(SUM(List[JUMLAH]),0)","v":{"v":271,"d":"RM271"}},"JUMLAH BARANG RUNCIT"]
[]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E5,List[KATEGORI]),)),\"\")","v":"Hasil"},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E6)","v":44.875},{"$f":"F6+ROW()/1000000","v":44.875006},{"$f":"LARGE($G$6:$G$21,1)","v":108.890009},{"$f":"MATCH(H6,$G$6:$G$21,0)","v":4},{"$f":"INDEX($E$6:$E$21,$I6)","v":"Makanan Laut"},{"$f":"INDEX($F$6:$F$21,$I6)","v":{"v":108.89,"d":"RM109"}},{"$f":"ROUND(K6,0)","v":{"v":109,"d":"RM109"}},{"$f":"\"JUMLAH \" & UPPER(J6)","v":"JUMLAH MAKANAN LAUT"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E6,List[KATEGORI]),)),\"\")","v":"Tenusu"},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E7)","v":36.84},{"$f":"F7+ROW()/1000000","v":36.840007},{"$f":"LARGE($G$6:$G$21,2)","v":79.900008},{"$f":"MATCH(H7,$G$6:$G$21,0)","v":3},{"$f":"INDEX($E$6:$E$21,$I7)","v":"Daging"},{"$f":"INDEX($F$6:$F$21,$I7)","v":{"v":79.9,"d":"RM80"}},{"$f":"ROUND(K7,0)","v":{"v":80,"d":"RM80"}},{"$f":"\"JUMLAH \" & UPPER(J7)","v":"JUMLAH DAGING"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E7,List[KATEGORI]),)),\"\")","v":"Daging"},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E8)","v":79.9},79.900008,{"$f":"LARGE($G$6:$G$21,3)","v":44.875006},{"$f":"MATCH(H8,$G$6:$G$21,0)","v":1},{"$f":"INDEX($E$6:$E$21,$I8)","v":"Hasil"},{"$f":"INDEX($F$6:$F$21,$I8)","v":{"v":44.875,"d":"RM45"}},{"$f":"ROUND(K8,0)","v":{"v":45,"d":"RM45"}},"JUMLAH HASIL"]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E8,List[KATEGORI]),)),\"\")","v":"Makanan Laut"},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E9)","v":108.89},108.890009,{"$f":"LARGE($G$6:$G$21,4)","v":36.840007},{"$f":"MATCH(H9,$G$6:$G$21,0)","v":2},{"$f":"INDEX($E$6:$E$21,$I9)","v":"Tenusu"},{"$f":"INDEX($F$6:$F$21,$I9)","v":{"v":36.84,"d":"RM37"}},{"$f":"ROUND(K9,0)","v":{"v":37,"d":"RM37"}},"JUMLAH TENUSU"]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E9,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E10)","v":0},1e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E10,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E11)","v":0},1.1E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E11,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E12)","v":0},1.2E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E12,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E13)","v":0},1.3e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E13,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E14)","v":0},1.4E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E14,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E15)","v":0},1.5E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E15,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E16)","v":0},1.6e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E16,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E17)","v":0},1.7E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E17,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E18)","v":0},1.8E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E18,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E19)","v":0},1.9e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E19,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E20)","v":0},2e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[KATEGORI],MATCH(,COUNTIF($E$5:E20,List[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(List[JUMLAH],List[KATEGORI],E21)","v":0},2.1e-05]