{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Anggaran Pernikahan","Detail Anggaran"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Anggaran Pernikahan","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[{"$nulls":6}," "]
[null,"LINDA + DIMAS\nMENIKAH"]
[{"$nulls":7}," "]
[]
[null,"KATEGORI","BIAYA PERKIRAAN","BIAYA AKTUAL","SELISIH","% ANGGARAN",{"$nulls":3},"Tidak diurutkan","Perkiraan Biaya","Biaya Aktual","Biaya Perkiraan - Beri Peringkat Nilai","Peringkat","#","Diurutkan"]
[null,{"$f":"P6","v":"Resepsi"},{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"Rp14,500"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"Rp12,800"}},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":{"v":1700,"d":"Rp1,700"}},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"Resepsi",{"$f":"TBL_Resepsi[[#Totals],[PERKIRAAN]]","v":14500},{"$f":"TBL_Resepsi[[#Totals],[AKTUAL]]","v":12800},{"$f":"K6-O6/100","v":14499.99},{"$f":"_xlfn.RANK.AVG(M6,$M$6:$M$15)","v":1},1,{"$f":"INDEX(TBL_RankingData,MATCH(O6,$N$6:$N$15,0),1)","v":"Resepsi"}]
[null,{"$f":"P7","v":"Busana"},{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"Rp4,000"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"Rp2,900"}},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":{"v":1100,"d":"Rp1,100"}},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"Busana",{"$f":"TBL_Busana[[#Totals],[PERKIRAAN]]","v":4000},{"$f":"TBL_Busana[[#Totals],[AKTUAL]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"Busana"]
[null,"Bunga dan dekorasi",{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"Rp3,000"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":""},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"Bunga dan dekorasi",{"$f":"TBL_BungaDanDekorasi[[#Totals],[PERKIRAAN]]","v":3000},{"$f":"TBL_BungaDanDekorasi[[#Totals],[AKTUAL]]","v":0},2999.97,3,3,"Bunga dan dekorasi"]
[null,"Foto dan video",{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"Rp2,500"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":""},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"Musik",{"$f":"TBL_Musik[[#Totals],[PERKIRAAN]]","v":1800},{"$f":"TBL_Musik[[#Totals],[AKTUAL]]","v":0},1799.96,5,4,"Foto dan video"]
[null,"Musik",{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"Rp1,800"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":""},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"Foto dan video",{"$f":"TBL_FotoDanVideo[[#Totals],[PERKIRAAN]]","v":2500},{"$f":"TBL_FotoDanVideo[[#Totals],[AKTUAL]]","v":0},2499.95,4,5,"Musik"]
[null,"Suvenir dan hadiah",{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"Rp1,100"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":""},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Suvenir dan hadiah",{"$f":"TBL_SuvenirDanHadiah[[#Totals],[PERKIRAAN]]","v":1100},{"$f":"TBL_SuvenirDanHadiah[[#Totals],[AKTUAL]]","v":0},1099.94,6,6,"Suvenir dan hadiah"]
[null,{"$f":"P12","v":"Cincin pernikahan"},{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"Rp1,100"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":""},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Perayaan",{"$f":"TBL_Upacara[[#Totals],[PERKIRAAN]]","v":800},{"$f":"TBL_Upacara[[#Totals],[AKTUAL]]","v":0},799.93,8,7,"Cincin pernikahan"]
[null,"Perayaan",{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"Rp800"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":""},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"Alat tulis",{"$f":"TBL_AlatTulis[[#Totals],[PERKIRAAN]]","v":500},{"$f":"TBL_AlatTulis[[#Totals],[AKTUAL]]","v":0},499.92,9,8,"Perayaan"]
[null,"Alat tulis",{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"Rp500"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":""},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"Cincin pernikahan",{"$f":"TBL_CincinPernikahan[[#Totals],[PERKIRAAN]]","v":1100},{"$f":"TBL_CincinPernikahan[[#Totals],[AKTUAL]]","v":0},1099.91,7,9,"Alat tulis"]
[null,"Transportasi",{"$f":"VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"Rp450"}},{"$f":"IF(VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Ringkasan[[#This Row],[KATEGORI]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]=\"\",TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]]=\"\"),\"\",TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#This Row],[BIAYA AKTUAL]])","v":""},{"$f":"TBL_Ringkasan[[#This Row],[BIAYA PERKIRAAN]]/SUM(TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"Transportasi",{"$f":"TBL_Transportasi[[#Totals],[PERKIRAAN]]","v":450},{"$f":"TBL_Transportasi[[#Totals],[AKTUAL]]","v":0},449.9,10,10,"Transportasi"]
[null,"Total",{"$f":"SUBTOTAL(109,TBL_Ringkasan[BIAYA PERKIRAAN])","v":{"v":29750,"d":"Rp29,750"}},{"$f":"SUBTOTAL(109,TBL_Ringkasan[BIAYA AKTUAL])","v":{"v":15700,"d":"Rp15,700"}},{"$f":"TBL_Ringkasan[[#Totals],[BIAYA PERKIRAAN]]-TBL_Ringkasan[[#Totals],[BIAYA AKTUAL]]","v":{"v":14050,"d":"Rp14,050"}},{"$f":"SUBTOTAL(109,TBL_Ringkasan[% ANGGARAN])","v":{"v":1,"d":"100%"}}]

{"sheet":"Detail Anggaran","index":1,"n_rows":91,"n_cols":6,"rows_kept":91}
[{"$nulls":5}," "]
[null,"DETAIL ANGGARAN"]
[]
[null,"RESEPSI","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Tempat dan sewa",{"v":8000,"d":"Rp8,000.00"},{"v":7800,"d":"Rp7,800.00"},{"$f":"IF(OR(TBL_Resepsi[[#This Row],[PERKIRAAN]]=\"\",TBL_Resepsi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Resepsi[[#This Row],[PERKIRAAN]]-TBL_Resepsi[[#This Row],[AKTUAL]])","v":{"v":200,"d":"Rp200.00"}}]
[null,"Makanan dan pelayanan",{"v":4000,"d":"Rp4,000.00"},{"v":4200,"d":"Rp4,200.00"},{"$f":"IF(OR(TBL_Resepsi[[#This Row],[PERKIRAAN]]=\"\",TBL_Resepsi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Resepsi[[#This Row],[PERKIRAAN]]-TBL_Resepsi[[#This Row],[AKTUAL]])","v":{"v":-200,"d":"-Rp200.00"}}]
[null,"Minuman",{"v":1000,"d":"Rp1,000.00"},{"v":800,"d":"Rp800.00"},{"$f":"IF(OR(TBL_Resepsi[[#This Row],[PERKIRAAN]]=\"\",TBL_Resepsi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Resepsi[[#This Row],[PERKIRAAN]]-TBL_Resepsi[[#This Row],[AKTUAL]])","v":{"v":200,"d":"Rp200.00"}}]
[null,"Kue",{"v":1000,"d":"Rp1,000.00"},null,{"$f":"IF(OR(TBL_Resepsi[[#This Row],[PERKIRAAN]]=\"\",TBL_Resepsi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Resepsi[[#This Row],[PERKIRAAN]]-TBL_Resepsi[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":500,"d":"Rp500.00"},null,{"$f":"IF(OR(TBL_Resepsi[[#This Row],[PERKIRAAN]]=\"\",TBL_Resepsi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Resepsi[[#This Row],[PERKIRAAN]]-TBL_Resepsi[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL RESEPSI",{"$f":"SUBTOTAL(109,TBL_Resepsi[PERKIRAAN])","v":{"v":14500,"d":"Rp14,500.00"}},{"$f":"SUBTOTAL(109,TBL_Resepsi[AKTUAL])","v":{"v":12800,"d":"Rp12,800.00"}},{"$f":"TBL_Resepsi[[#Totals],[PERKIRAAN]]-TBL_Resepsi[[#Totals],[AKTUAL]]","v":{"v":1700,"d":"Rp1,700.00"}}]
[]
[]
[null,"BUSANA","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Tuksedo, jas, dan/atau gaun",{"v":3000,"d":"Rp3,000.00"},{"v":2900,"d":"Rp2,900.00"},{"$f":"IF(OR(TBL_Busana[[#This Row],[PERKIRAAN]]=\"\",TBL_Busana[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Busana[[#This Row],[PERKIRAAN]]-TBL_Busana[[#This Row],[AKTUAL]])","v":{"v":100,"d":"Rp100.00"}}]
[null,"Perubahan",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_Busana[[#This Row],[PERKIRAAN]]=\"\",TBL_Busana[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Busana[[#This Row],[PERKIRAAN]]-TBL_Busana[[#This Row],[AKTUAL]])","v":""}]
[null,"Hiasan kepala dan kerudung",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_Busana[[#This Row],[PERKIRAAN]]=\"\",TBL_Busana[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Busana[[#This Row],[PERKIRAAN]]-TBL_Busana[[#This Row],[AKTUAL]])","v":""}]
[null,"Aksesori",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_Busana[[#This Row],[PERKIRAAN]]=\"\",TBL_Busana[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Busana[[#This Row],[PERKIRAAN]]-TBL_Busana[[#This Row],[AKTUAL]])","v":""}]
[null,"Rias wajah dan rambut",{"v":500,"d":"Rp500.00"},null,{"$f":"IF(OR(TBL_Busana[[#This Row],[PERKIRAAN]]=\"\",TBL_Busana[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Busana[[#This Row],[PERKIRAAN]]-TBL_Busana[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_Busana[[#This Row],[PERKIRAAN]]=\"\",TBL_Busana[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Busana[[#This Row],[PERKIRAAN]]-TBL_Busana[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL BUSANA",{"$f":"SUBTOTAL(109,TBL_Busana[PERKIRAAN])","v":{"v":4000,"d":"Rp4,000.00"}},{"$f":"SUBTOTAL(109,TBL_Busana[AKTUAL])","v":{"v":2900,"d":"Rp2,900.00"}},{"$f":"TBL_Busana[[#Totals],[PERKIRAAN]]-TBL_Busana[[#Totals],[AKTUAL]]","v":{"v":1100,"d":"Rp1,100.00"}}]
[]
[]
[null,"BUNGA & DEKORASI","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Rangkaian bunga untuk upacara",{"v":1000,"d":"Rp1,000.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Kuntum bunga dan keranjang untuk pengiring pengantin",{"v":500,"d":"Rp500.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Bantal Cincin",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Buket",{"v":500,"d":"Rp500.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Bunga Dekorasi",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Korsase",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Dekorasi resepsi",{"v":300,"d":"Rp300.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Lampu",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]=\"\",TBL_BungaDanDekorasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_BungaDanDekorasi[[#This Row],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL BUNGA & DEKORASI",{"$f":"SUBTOTAL(109,TBL_BungaDanDekorasi[PERKIRAAN])","v":{"v":3000,"d":"Rp3,000.00"}},{"$f":"SUBTOTAL(109,TBL_BungaDanDekorasi[AKTUAL])","v":{"v":0,"d":"Rp0.00"}},{"$f":"TBL_BungaDanDekorasi[[#Totals],[PERKIRAAN]]-TBL_BungaDanDekorasi[[#Totals],[AKTUAL]]","v":{"v":3000,"d":"Rp3,000.00"}}]
[]
[]
[null,"MUSIK","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Musisi upacara",{"v":700,"d":"Rp700.00"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[PERKIRAAN]]=\"\",TBL_Musik[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Musik[[#This Row],[PERKIRAAN]]-TBL_Musik[[#This Row],[AKTUAL]])","v":""}]
[null,"Musisi jamuan malam",{"v":300,"d":"Rp300.00"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[PERKIRAAN]]=\"\",TBL_Musik[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Musik[[#This Row],[PERKIRAAN]]-TBL_Musik[[#This Row],[AKTUAL]])","v":""}]
[null,"Band, DJ, atau hiburan resepsi",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[PERKIRAAN]]=\"\",TBL_Musik[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Musik[[#This Row],[PERKIRAAN]]-TBL_Musik[[#This Row],[AKTUAL]])","v":""}]
[null,"Sewa sistem suara atau lantai dansa",{"v":400,"d":"Rp400.00"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[PERKIRAAN]]=\"\",TBL_Musik[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Musik[[#This Row],[PERKIRAAN]]-TBL_Musik[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[PERKIRAAN]]=\"\",TBL_Musik[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Musik[[#This Row],[PERKIRAAN]]-TBL_Musik[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL MUSIK",{"$f":"SUBTOTAL(109,TBL_Musik[PERKIRAAN])","v":{"v":1800,"d":"Rp1,800.00"}},{"$f":"SUBTOTAL(109,TBL_Musik[AKTUAL])","v":{"v":0,"d":"Rp0.00"}},{"$f":"TBL_Musik[[#Totals],[PERKIRAAN]]-TBL_Musik[[#Totals],[AKTUAL]]","v":{"v":1800,"d":"Rp1,800.00"}}]
[]
[]
[null,"FOTOGRAFI & VIDEO","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Fotografi",{"v":1000,"d":"Rp1,000.00"},null,{"$f":"IF(OR(TBL_FotoDanVideo[[#This Row],[PERKIRAAN]]=\"\",TBL_FotoDanVideo[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_FotoDanVideo[[#This Row],[PERKIRAAN]]-TBL_FotoDanVideo[[#This Row],[AKTUAL]])","v":""}]
[null,"Videografi",{"v":800,"d":"Rp800.00"},null,{"$f":"IF(OR(TBL_FotoDanVideo[[#This Row],[PERKIRAAN]]=\"\",TBL_FotoDanVideo[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_FotoDanVideo[[#This Row],[PERKIRAAN]]-TBL_FotoDanVideo[[#This Row],[AKTUAL]])","v":""}]
[null,"Cetak dan album tambahan",{"v":500,"d":"Rp500.00"},null,{"$f":"IF(OR(TBL_FotoDanVideo[[#This Row],[PERKIRAAN]]=\"\",TBL_FotoDanVideo[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_FotoDanVideo[[#This Row],[PERKIRAAN]]-TBL_FotoDanVideo[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_FotoDanVideo[[#This Row],[PERKIRAAN]]=\"\",TBL_FotoDanVideo[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_FotoDanVideo[[#This Row],[PERKIRAAN]]-TBL_FotoDanVideo[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL FOTOGRAFI & VIDEO",{"$f":"SUBTOTAL(109,TBL_FotoDanVideo[PERKIRAAN])","v":{"v":2500,"d":"Rp2,500.00"}},{"$f":"SUBTOTAL(109,TBL_FotoDanVideo[AKTUAL])","v":{"v":0,"d":"Rp0.00"}},{"$f":"TBL_FotoDanVideo[[#Totals],[PERKIRAAN]]-TBL_FotoDanVideo[[#Totals],[AKTUAL]]","v":{"v":2500,"d":"Rp2,500.00"}}]
[]
[]
[null,"SUVENIR & HADIAH","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Hadiah sambutan",{"v":700,"d":"Rp700.00"},null,{"$f":"IF(OR(TBL_SuvenirDanHadiah[[#This Row],[PERKIRAAN]]=\"\",TBL_SuvenirDanHadiah[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_SuvenirDanHadiah[[#This Row],[PERKIRAAN]]-TBL_SuvenirDanHadiah[[#This Row],[AKTUAL]])","v":""}]
[null,"Hadiah pesta",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_SuvenirDanHadiah[[#This Row],[PERKIRAAN]]=\"\",TBL_SuvenirDanHadiah[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_SuvenirDanHadiah[[#This Row],[PERKIRAAN]]-TBL_SuvenirDanHadiah[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_SuvenirDanHadiah[[#This Row],[PERKIRAAN]]=\"\",TBL_SuvenirDanHadiah[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_SuvenirDanHadiah[[#This Row],[PERKIRAAN]]-TBL_SuvenirDanHadiah[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL SUVENIR & HADIAH",{"$f":"SUBTOTAL(109,TBL_SuvenirDanHadiah[PERKIRAAN])","v":{"v":1100,"d":"Rp1,100.00"}},{"$f":"SUBTOTAL(109,TBL_SuvenirDanHadiah[AKTUAL])","v":{"v":0,"d":"Rp0.00"}},{"$f":"TBL_SuvenirDanHadiah[[#Totals],[PERKIRAAN]]-TBL_SuvenirDanHadiah[[#Totals],[AKTUAL]]","v":{"v":1100,"d":"Rp1,100.00"}}]
[]
[]
[null,"UPACARA","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Biaya lokasi",{"v":500,"d":"Rp500.00"},null,{"$f":"IF(OR(TBL_Upacara[[#This Row],[PERKIRAAN]]=\"\",TBL_Upacara[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Upacara[[#This Row],[PERKIRAAN]]-TBL_Upacara[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya resmi atau donasi gereja",{"v":200,"d":"Rp200.00"},null,{"$f":"IF(OR(TBL_Upacara[[#This Row],[PERKIRAAN]]=\"\",TBL_Upacara[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Upacara[[#This Row],[PERKIRAAN]]-TBL_Upacara[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_Upacara[[#This Row],[PERKIRAAN]]=\"\",TBL_Upacara[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Upacara[[#This Row],[PERKIRAAN]]-TBL_Upacara[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL UPACARA",{"$f":"SUBTOTAL(109,TBL_Upacara[PERKIRAAN])","v":{"v":800,"d":"Rp800.00"}},{"$f":"SUBTOTAL(109,TBL_Upacara[AKTUAL])","v":{"v":0,"d":"Rp0.00"}},{"$f":"TBL_Upacara[[#Totals],[PERKIRAAN]]-TBL_Upacara[[#Totals],[AKTUAL]]","v":{"v":800,"d":"Rp800.00"}}]
[]
[]
[null,"ALAT TULIS","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Kartu undangan",{"v":50,"d":"Rp50.00"},null,{"$f":"IF(OR(TBL_AlatTulis[[#This Row],[PERKIRAAN]]=\"\",TBL_AlatTulis[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_AlatTulis[[#This Row],[PERKIRAAN]]-TBL_AlatTulis[[#This Row],[AKTUAL]])","v":""}]
[null,"Undangan dan RSVP",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_AlatTulis[[#This Row],[PERKIRAAN]]=\"\",TBL_AlatTulis[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_AlatTulis[[#This Row],[PERKIRAAN]]-TBL_AlatTulis[[#This Row],[AKTUAL]])","v":""}]
[null,"Susunan Acara",{"v":50,"d":"Rp50.00"},null,{"$f":"IF(OR(TBL_AlatTulis[[#This Row],[PERKIRAAN]]=\"\",TBL_AlatTulis[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_AlatTulis[[#This Row],[PERKIRAAN]]-TBL_AlatTulis[[#This Row],[AKTUAL]])","v":""}]
[null,"Tempat duduk dan kartu tempat",{"v":50,"d":"Rp50.00"},null,{"$f":"IF(OR(TBL_AlatTulis[[#This Row],[PERKIRAAN]]=\"\",TBL_AlatTulis[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_AlatTulis[[#This Row],[PERKIRAAN]]-TBL_AlatTulis[[#This Row],[AKTUAL]])","v":""}]
[null,"Kartu menu",{"v":50,"d":"Rp50.00"},null,{"$f":"IF(OR(TBL_AlatTulis[[#This Row],[PERKIRAAN]]=\"\",TBL_AlatTulis[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_AlatTulis[[#This Row],[PERKIRAAN]]-TBL_AlatTulis[[#This Row],[AKTUAL]])","v":""}]
[null,"Kartu ucapan terima kasih",{"v":50,"d":"Rp50.00"},null,{"$f":"IF(OR(TBL_AlatTulis[[#This Row],[PERKIRAAN]]=\"\",TBL_AlatTulis[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_AlatTulis[[#This Row],[PERKIRAAN]]-TBL_AlatTulis[[#This Row],[AKTUAL]])","v":""}]
[null,"Ongkos kirim",{"v":50,"d":"Rp50.00"},null,{"$f":"IF(OR(TBL_AlatTulis[[#This Row],[PERKIRAAN]]=\"\",TBL_AlatTulis[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_AlatTulis[[#This Row],[PERKIRAAN]]-TBL_AlatTulis[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_AlatTulis[[#This Row],[PERKIRAAN]]=\"\",TBL_AlatTulis[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_AlatTulis[[#This Row],[PERKIRAAN]]-TBL_AlatTulis[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL ALAT TULIS",{"$f":"SUBTOTAL(109,TBL_AlatTulis[PERKIRAAN])","v":{"v":500,"d":"Rp500.00"}},{"$f":"SUBTOTAL(109,TBL_AlatTulis[AKTUAL])","v":{"v":0,"d":"Rp0.00"}},{"$f":"TBL_AlatTulis[[#Totals],[PERKIRAAN]]-TBL_AlatTulis[[#Totals],[AKTUAL]]","v":{"v":500,"d":"Rp500.00"}}]
[]
[]
[null,"CINCIN PERNIKAHAN","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Cincin pernikahan",{"v":1000,"d":"Rp1,000.00"},null,{"$f":"IF(OR(TBL_CincinPernikahan[[#This Row],[PERKIRAAN]]=\"\",TBL_CincinPernikahan[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_CincinPernikahan[[#This Row],[PERKIRAAN]]-TBL_CincinPernikahan[[#This Row],[AKTUAL]])","v":""}]
[null,"Aksesori cincin",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_CincinPernikahan[[#This Row],[PERKIRAAN]]=\"\",TBL_CincinPernikahan[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_CincinPernikahan[[#This Row],[PERKIRAAN]]-TBL_CincinPernikahan[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL CINCIN PERNIKAHAN",{"$f":"SUBTOTAL(109,TBL_CincinPernikahan[PERKIRAAN])","v":{"v":1100,"d":"Rp1,100.00"}},{"$f":"SUBTOTAL(109,TBL_CincinPernikahan[AKTUAL])","v":{"v":0,"d":"Rp0.00"}},{"$f":"TBL_CincinPernikahan[[#Totals],[PERKIRAAN]]-TBL_CincinPernikahan[[#Totals],[AKTUAL]]","v":{"v":1100,"d":"Rp1,100.00"}}]
[]
[]
[null,"TRANSPORTASI  ","PERKIRAAN","AKTUAL","SELISIH"]
[null,"Rental mobil utama",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_Transportasi[[#This Row],[PERKIRAAN]]=\"\",TBL_Transportasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Transportasi[[#This Row],[PERKIRAAN]]-TBL_Transportasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Rental mobil tamu",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_Transportasi[[#This Row],[PERKIRAAN]]=\"\",TBL_Transportasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Transportasi[[#This Row],[PERKIRAAN]]-TBL_Transportasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Transportasi untuk tamu darii luar kota",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_Transportasi[[#This Row],[PERKIRAAN]]=\"\",TBL_Transportasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Transportasi[[#This Row],[PERKIRAAN]]-TBL_Transportasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Parkir valet",{"v":50,"d":"Rp50.00"},null,{"$f":"IF(OR(TBL_Transportasi[[#This Row],[PERKIRAAN]]=\"\",TBL_Transportasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Transportasi[[#This Row],[PERKIRAAN]]-TBL_Transportasi[[#This Row],[AKTUAL]])","v":""}]
[null,"Biaya lain-lain",{"v":100,"d":"Rp100.00"},null,{"$f":"IF(OR(TBL_Transportasi[[#This Row],[PERKIRAAN]]=\"\",TBL_Transportasi[[#This Row],[AKTUAL]]=\"\"),\"\",TBL_Transportasi[[#This Row],[PERKIRAAN]]-TBL_Transportasi[[#This Row],[AKTUAL]])","v":""}]
[null,"TOTAL TRANSPORTASI",{"$f":"SUBTOTAL(109,TBL_Transportasi[PERKIRAAN])","v":{"v":450,"d":"Rp450.00"}},{"$f":"SUBTOTAL(109,TBL_Transportasi[AKTUAL])","v":{"v":0,"d":"Rp0.00"}},{"$f":"TBL_Transportasi[[#Totals],[PERKIRAAN]]-TBL_Transportasi[[#Totals],[AKTUAL]]","v":{"v":450,"d":"Rp450.00"}}]