{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Ringkasan","Daftar Hadiah"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Ringkasan","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,2,1],[0,2,2,3]]}
[null,"liburan","PENCATAT HADIAH",null,"TOTAL ANGGARAN",{"v":500,"d":"Rp500.00"}]
[{"$nulls":4},"DIGUNAKAN",{"$f":"IFERROR(SUMIFS(Hadiah[BIAYA],Hadiah[DIBELI],\"Ya\"),\"\")","v":{"v":283,"d":"Rp283.00"}}]
[{"$nulls":4},"SISA ANGGARAN",{"$f":"IFERROR(TotalAnggaran-F2,\"\")","v":{"v":217,"d":"Rp217.00"}}]
[null,"Sesuaikan anggaran jika Anggaran dalam % melebihi 100% (Ya/Tidak)?",null,"Ya"]
[null,"PENERIMA","ANGGARAN DALAM %","SISA ALOKASI DANA","RENCANA JUMLAH HADIAH","SISA HADIAH"]
[null,"Adam",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Sesuaikan_Anggaran=\"Ya\",Sisa_Alokasi_Dana-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]),(TotalAnggaran*Penerima[[#This Row],[ANGGARAN DALAM %]])-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]])),\"\")","v":{"v":45,"d":"Rp45.00"}},3,{"$f":"IFERROR(Penerima[[#This Row],[RENCANA JUMLAH HADIAH]]-COUNTIFS(Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]), \"\")","v":1}]
[null,"Jeni",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Sesuaikan_Anggaran=\"Ya\",Sisa_Alokasi_Dana-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]),(TotalAnggaran*Penerima[[#This Row],[ANGGARAN DALAM %]])-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]])),\"\")","v":{"v":54,"d":"Rp54.00"}},3,{"$f":"IFERROR(Penerima[[#This Row],[RENCANA JUMLAH HADIAH]]-COUNTIFS(Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]), \"\")","v":1}]
[null,"Brian",{"v":0.2,"d":"20%"},{"$f":"IFERROR(IF(Sesuaikan_Anggaran=\"Ya\",Sisa_Alokasi_Dana-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]),(TotalAnggaran*Penerima[[#This Row],[ANGGARAN DALAM %]])-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]])),\"\")","v":{"v":11,"d":"Rp11.00"}},2,{"$f":"IFERROR(Penerima[[#This Row],[RENCANA JUMLAH HADIAH]]-COUNTIFS(Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]), \"\")","v":1}]
[null,"Susi",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Sesuaikan_Anggaran=\"Ya\",Sisa_Alokasi_Dana-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]),(TotalAnggaran*Penerima[[#This Row],[ANGGARAN DALAM %]])-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]])),\"\")","v":{"v":-1,"d":"-Rp1.00"}},1,{"$f":"IFERROR(Penerima[[#This Row],[RENCANA JUMLAH HADIAH]]-COUNTIFS(Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]), \"\")","v":0}]
[null,"Maria",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Sesuaikan_Anggaran=\"Ya\",Sisa_Alokasi_Dana-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]),(TotalAnggaran*Penerima[[#This Row],[ANGGARAN DALAM %]])-SUMIFS(Hadiah[BIAYA],Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]])),\"\")","v":{"v":0,"d":"Rp0.00"}},1,{"$f":"IFERROR(Penerima[[#This Row],[RENCANA JUMLAH HADIAH]]-COUNTIFS(Hadiah[PENERIMA],Penerima[[#This Row],[PENERIMA]]), \"\")","v":0}]
[null,"Total",{"$f":"SUM(Penerima[ANGGARAN DALAM %])","v":{"v":1,"d":"100%"}},{"$f":"IFERROR(SUM(Penerima[SISA ALOKASI DANA]),\"\")","v":{"v":109,"d":"Rp109.00"}},{"$f":"SUM(Penerima[RENCANA JUMLAH HADIAH])","v":10},{"$f":"SUM(Penerima[SISA HADIAH])","v":3}]

{"sheet":"Daftar Hadiah","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[null,"liburan","DAFTAR HADIAH"]
[null,"PENERIMA","HADIAH","BIAYA","DIBELI","DIBUNGKUS"]
[null,"Jeni","Rumah Boneka",{"v":36,"d":"Rp36.00"},"Ya","Ya"]
[null,"Brian","Sepeda",{"v":89,"d":"Rp89.00"},"Ya"]
[null,"Susi","Materi Scrapbook",{"v":51,"d":"Rp51.00"},"Ya","Ya"]
[null,"Adam","Kereta Api Mainan",{"v":48,"d":"Rp48.00"}]
[null,"Adam","Sweter",{"v":57,"d":"Rp57.00"},"Ya"]
[null,"Maria","Kartu Hadiah",{"v":50,"d":"Rp50.00"},"Ya","Ya"]
[null,"Jeni","Gaun",{"v":60,"d":"Rp60.00"}]