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

{"sheet":"Ringkasan Anggaran","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"TOTAL ANGGARAN PERNIKAHAN",{"v":20000,"d":"Rp20,000"}]
[]
[null,"PENGELUARAN","Alokasi \n%","Alokasi Anggaran","Estimasi \nBiaya","Aktual \nBiaya"]
[null,"Resepsi",{"v":0.5,"d":"50%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C6","v":{"v":10000,"d":"Rp10,000"}},{"$f":"Tabel_Resepsi[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Resepsi[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Busana",{"v":0.1,"d":"10%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C7","v":{"v":2000,"d":"Rp2,000"}},{"$f":"Tabel_Busana[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Busana[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Bunga dan Dekorasi",{"v":0.1,"d":"10%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C8","v":{"v":2000,"d":"Rp2,000"}},{"$f":"Tabel_BungaDanDekorasi[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_BungaDanDekorasi[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Musik",{"v":0.1,"d":"10%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C9","v":{"v":2000,"d":"Rp2,000"}},{"$f":"Tabel_Musik[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Musik[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Foto dan Video",{"v":0.1,"d":"10%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C10","v":{"v":2000,"d":"Rp2,000"}},{"$f":"Tabel_FotoDanVideo[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_FotoDanVideo[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Suvenir dan Hadiah",{"v":0.03,"d":"3%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C11","v":{"v":600,"d":"Rp600"}},{"$f":"Tabel_SuvenirDanHadiah[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_SuvenirDanHadiah[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Upacara",{"v":0.02,"d":"2%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C12","v":{"v":400,"d":"Rp400"}},{"$f":"Tabel_Upacara[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Upacara[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Alat Tulis",{"v":0.02,"d":"2%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C13","v":{"v":400,"d":"Rp400"}},{"$f":"Tabel_AlatTulis[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_AlatTulis[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Cincin Pernikahan",{"v":0.02,"d":"2%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C14","v":{"v":400,"d":"Rp400"}},{"$f":"Tabel_CincinPernikahan[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_CincinPernikahan[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Transportasi",{"v":0.01,"d":"1%"},{"$f":"Tabel_Anggaran_Pernikahan*'Ringkasan Anggaran'!$C15","v":{"v":200,"d":"Rp200"}},{"$f":"Tabel_Transportasi[[#Totals],[Perkiraan Biaya]]","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Transportasi[[#Totals],[Biaya Sebenarnya]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUM(C6:C15)","v":{"v":1,"d":"100%"}},{"$f":"SUM(D6:D15)","v":{"v":20000,"d":"Rp20,000"}},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"}]
[]
[null,"KONTRIBUSI"]
[null,"Sumber Dana","Kontribusi"]
[null,"Tabungan",{"v":10000,"d":"Rp10,000"}]
[null,"Ibu & Ayah dari Mitra 1",{"v":4000,"d":"Rp4,000"}]
[null,"Kakek-nenek dari Mitra 1",{"v":2000,"d":"Rp2,000"}]
[null,"Ibu & Ayah dari Mitra 2",{"v":4000,"d":"Rp4,000"}]
[null,"Kakek-nenek dari Mitra 2",{"v":4000,"d":"Rp4,000"}]
[null,"Kontribusi lainnya",{"v":2000,"d":"Rp2,000"}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_Kontribusi[Kontribusi])","v":{"v":26000,"d":"Rp26,000"}}]
[]
[null,{"$f":"IF(Tabel_Kontribusi[[#Totals],[Kontribusi]]<Tabel_Anggaran_Pernikahan,\"Selisih yang diperlukan\",\"Dana tambahan yang tersedia\")","v":"Dana tambahan yang tersedia"},{"$f":"IF(Tabel_Kontribusi[[#Totals],[Kontribusi]]<Tabel_Anggaran_Pernikahan,Tabel_Anggaran_Pernikahan-Tabel_Kontribusi[[#Totals],[Kontribusi]],Tabel_Kontribusi[[#Totals],[Kontribusi]]-Tabel_Anggaran_Pernikahan)","v":{"v":6000,"d":"Rp6,000"}}]

{"sheet":"Detail Anggaran","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"RESEPSI","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Tempat dan sewa"]
[null,"Makanan dan pelayanan"]
[null,"Minuman"]
[null,"Kue"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_Resepsi[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_Resepsi[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"BUSANA","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Tuksedo, jas, dan/atau gaun"]
[null,"Perubahan"]
[null,"Hiasan kepala dan kerudung"]
[null,"Aksesori"]
[null,"Rias wajah dan rambut"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_Busana[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_Busana[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"BUNGA DAN DEKORASI","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Pengaturan bunga untuk upacara"]
[null,"Kuntum bunga dan keranjang untuk pengiring pengantin"]
[null,"Bantal Cincin"]
[null,"Buket"]
[null,"Bunga Dekorasi"]
[null,"Korsase"]
[null,"Dekorasi resepsi"]
[null,"Lampu"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_BungaDanDekorasi[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_BungaDanDekorasi[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"MUSIK","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Musisi upacara"]
[null,"Musisi jamuan malam"]
[null,"Band, DJ, atau hiburan resepsi"]
[null,"Sewa sistem suara atau lantai dansa"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_Musik[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_Musik[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"FOTO DAN VIDEO","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Fotografi"]
[null,"Videografi"]
[null,"Cetak dan album tambahan"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_FotoDanVideo[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_FotoDanVideo[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"SUVENIR DAN HADIAH","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Hadiah sambutan"]
[null,"Hadiah pesta"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_SuvenirDanHadiah[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_SuvenirDanHadiah[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"UPACARA","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Biaya lokasi"]
[null,"Biaya resmi atau donasi gereja"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_Upacara[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_Upacara[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"ALAT TULIS","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Kartu undangan"]
[null,"Undangan dan RSVP"]
[null,"Susunan Acara"]
[null,"Tempat duduk dan kartu tempat"]
[null,"Kartu menu"]
[null,"Kartu ucapan terima kasih"]
[null,"Ongkos kirim"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_AlatTulis[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_AlatTulis[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"CINCIN PERNIKAHAN","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Cincin pernikahan"]
[null,"Aksesori cincin"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_CincinPernikahan[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_CincinPernikahan[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"TRANSPORTASI","Perkiraan Biaya","Biaya Sebenarnya"]
[null,"Rental mobil utama"]
[null,"Rental mobil tamu"]
[null,"Transportasi untuk tamu darii luar kota"]
[null,"Parkir valet"]
[null,"Biaya lain-lain"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel_Transportasi[Perkiraan Biaya])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel_Transportasi[Biaya Sebenarnya])","v":{"v":0,"d":"Rp0.00"}}]