{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Daftar Belanjaan","perhitungan"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Daftar Belanjaan","index":0,"n_rows":21,"n_cols":13,"rows_kept":21,"merged":[[0,1,0,11],[0,12,1,12],[1,1,1,11],[4,12,5,12],[7,12,8,12],[10,12,11,12],[13,12,14,12]]}
[{"$nulls":12},{"$f":"perhitungan!M9","v":"PRODUK SUSU TOTAL"}]
[null," Daftar Belanjaan"]
[null,null,"Selesai","ITEM","TOKO","KATEGORI","JML","SATUAN","HARGA SATUAN","TOTAL","KOMENTAR",null,{"$f":"perhitungan!L9","v":37}]
[null,null,1,"Jeruk","Bahan makanan","Hasil bumi",2,"pon",{"v":2.99,"d":"Rp2.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":5.98,"d":"Rp5.98"}},null,null,{"$f":"perhitungan!M8","v":"HASIL BUMI TOTAL"}]
[{"$nulls":3},"Apel","Kebun Buah-buahan","Hasil bumi",3,"pon",{"v":1.99,"d":"Rp1.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":5.97,"d":"Rp5.97"}},"Ada kupon",null,{"$f":"perhitungan!L8","v":45}]
[{"$nulls":3},"Pisang","Bahan makanan","Hasil bumi",1,"sejumlah",{"v":3.99,"d":"Rp3.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":3.99,"d":"Rp3.99"}}]
[{"$nulls":3},"Selada","Pasar","Hasil bumi",2,"kepala",{"v":2.29,"d":"Rp2.29"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":4.58,"d":"Rp4.58"}},null,null,{"$f":"perhitungan!M7","v":"DAGING TOTAL"}]
[{"$nulls":3},"Tomat","Pasar","Hasil bumi",4,"pon",{"v":3.49,"d":"Rp3.49"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":13.96,"d":"Rp13.96"}},null,null,{"$f":"perhitungan!L7","v":80}]
[{"$nulls":3},"Labu","Pasar","Hasil bumi",2,"setiap",{"v":1.5,"d":"Rp1.50"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":3,"d":"Rp3.00"}}]
[{"$nulls":3},"Seledri","Bahan makanan","Hasil bumi",2,"sejumlah",{"v":1.99,"d":"Rp1.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":3.98,"d":"Rp3.98"}},null,null,{"$f":"perhitungan!M6","v":"MAKANAN LAUT TOTAL"}]
[{"$nulls":3},"Mentimun","Pasar","Hasil bumi",1,"pon",{"v":2.29,"d":"Rp2.29"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":2.29,"d":"Rp2.29"}},null,null,{"$f":"perhitungan!L6","v":109}]
[{"$nulls":3},"Jamur","Bahan makanan","Hasil bumi",0.5,"pon",{"v":2.25,"d":"Rp2.25"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":1.125,"d":"Rp1.13"}},"Jamur kancing besar"]
[{"$nulls":3},"Susu ","Dikirim ke Rumah","Produk susu",2,"gal",{"v":3.99,"d":"Rp3.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":7.98,"d":"Rp7.98"}},null,null,{"$f":"perhitungan!M3","v":"TOTAL LAINNYA"}]
[{"$nulls":3},"Keju","Dikirim ke Rumah","Produk susu",1,"pon",{"v":9.99,"d":"Rp9.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":9.99,"d":"Rp9.99"}},"Keju blok aneka jenis",null,{"$f":"perhitungan!L3","v":0}]
[{"$nulls":3},"Telur","Dikirim ke Rumah","Produk susu",2,"lusin",{"v":3.5,"d":"Rp3.50"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":7,"d":"Rp7.00"}}]
[{"$nulls":3},"Keju lembut","Dikirim ke Rumah","Produk susu",1,"16 ons",{"v":3.89,"d":"Rp3.89"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":3.89,"d":"Rp3.89"}},null,null,{"$f":"perhitungan!M4","v":"TOTAL BELANJAAN"}]
[{"$nulls":3},"Krim asam","Dikirim ke Rumah","Produk susu",1,"8 ons",{"v":2.99,"d":"Rp2.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":2.99,"d":"Rp2.99"}},null,null,{"$f":"TotalBelanjaan","v":271}]
[{"$nulls":3},"Yogurt","Bahan makanan","Produk susu",1,"16 ons",{"v":4.99,"d":"Rp4.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":4.99,"d":"Rp4.99"}},"Greek dengan madu"]
[{"$nulls":3},"Daging sapi","Pasar","Daging",10,"pon",{"v":7.99,"d":"Rp7.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":79.9,"d":"Rp79.90"}},"Filet yang dibungkus daging babi asap"]
[{"$nulls":3},"Wild Salmon","Pasar Ikan","Makanan laut",6,"pon",{"v":8.99,"d":"Rp8.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":53.94,"d":"Rp53.94"}}]
[{"$nulls":3},"Kaki Kepiting Raja Alaska","Pasar Ikan","Makanan laut",5,"pon",{"v":10.99,"d":"Rp10.99"},{"$f":"IFERROR(Daftar[JML]*Daftar[HARGA SATUAN],\"\")","v":{"v":54.95,"d":"Rp54.95"}}]

{"sheet":"perhitungan","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"hidden":true}
["*** Lembar harus tetap tersembunyi ***"]
[]
[{"$nulls":10},{"$f":"SUM(Daftar[TOTAL])-SUM(K6:K9)","v":{"v":0,"d":"Rp0.00"}},{"$f":"ROUND(K3,0)","v":{"v":0,"d":"Rp0"}},"TOTAL LAINNYA"]
[{"$nulls":11},{"$f":"ROUNDUP(SUM(Daftar[TOTAL]),0)","v":{"v":271,"d":"Rp271"}},"TOTAL BELANJAAN"]
[]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E5,Daftar[KATEGORI]),)),\"\")","v":"Hasil bumi"},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[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":"Rp108.89"}},{"$f":"ROUND(K6,0)","v":{"v":109,"d":"Rp109"}},{"$f":"UPPER(J6) & \" TOTAL\"","v":"MAKANAN LAUT TOTAL"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E6,Daftar[KATEGORI]),)),\"\")","v":"Produk susu"},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[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":"Rp79.90"}},{"$f":"ROUND(K7,0)","v":{"v":80,"d":"Rp80"}},{"$f":"UPPER(J7) & \" TOTAL\"","v":"DAGING TOTAL"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E7,Daftar[KATEGORI]),)),\"\")","v":"Daging"},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[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 bumi"},{"$f":"INDEX($F$6:$F$21,$I8)","v":{"v":44.875,"d":"Rp44.88"}},{"$f":"ROUND(K8,0)","v":{"v":45,"d":"Rp45"}},{"$f":"UPPER(J8) & \" TOTAL\"","v":"HASIL BUMI TOTAL"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E8,Daftar[KATEGORI]),)),\"\")","v":"Makanan laut"},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[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":"Produk susu"},{"$f":"INDEX($F$6:$F$21,$I9)","v":{"v":36.84,"d":"Rp36.84"}},{"$f":"ROUND(K9,0)","v":{"v":37,"d":"Rp37"}},{"$f":"UPPER(J9) & \" TOTAL\"","v":"PRODUK SUSU TOTAL"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E9,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E10)","v":0},1e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E10,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E11)","v":0},1.1E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E11,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E12)","v":0},1.2E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E12,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E13)","v":0},1.3e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E13,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E14)","v":0},1.4E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E14,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E15)","v":0},1.5E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E15,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E16)","v":0},1.6e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E16,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E17)","v":0},1.7E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E17,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E18)","v":0},1.8E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E18,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E19)","v":0},1.9e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E19,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E20)","v":0},2e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(Daftar[KATEGORI],MATCH(,COUNTIF($E$5:E20,Daftar[KATEGORI]),)),\"\")","v":""},{"$f":"SUMIFS(Daftar[TOTAL],Daftar[KATEGORI],E21)","v":0},2.1e-05]