{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Gambaran Umum Pesta","Daftar Tamu","Makanan & Minuman","Barang Lainnya yang Diperlukan ","Pengaturan Tempat Duduk"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Gambaran Umum Pesta","index":0,"n_rows":21,"n_cols":8,"rows_kept":21}
[]
[]
[null,"Gambaran Umum Pesta"]
[]
[]
[null,"ACARA",null,"RINGKASAN TAMU",{"$nulls":3},{"$f":"\"RSVP YANG BELUM MENGONFIRMASI: \"&OutstandingRSVPs","v":"RSVP YANG BELUM MENGONFIRMASI: 2"}]
[null,"Ulang Tahun Nenek Ke-75",null,"GAMBARAN UMUM RSVP",null,"BIAYA PER TAMU",null,"JUMLAH ANGGARAN"]
[{"$nulls":3},"Tamu yang akan datang","Total Sudah Mengonfirmasi","Makanan","Lainnya","Total"]
[null,"TANGGAL",null,"Dewasa",{"$f":"SUMIF(GuestTable[AKAN HADIR?],\"=Ya\",GuestTable[DEWASA])","v":26},{"$f":"FoodTable[[#Totals],[BIAYA PER ORANG DEWASA]]","v":{"v":12.690089084110037,"d":"Rp12.69"}},{"$f":"EssentialCostPerGuest","v":{"v":18.695652173913043,"d":"Rp18.70"}},{"$f":"(AttendeeSummary[[#This Row],[Makanan]]+AttendeeSummary[[#This Row],[Lainnya]])*AdultTotal","v":{"v":816.0292727086002,"d":"Rp816.03"}}]
[null,"14 Juni 2011",null,"Anak-anak",{"$f":"SUMIF(GuestTable[AKAN HADIR?],\"=Ya\",GuestTable[ANAK-ANAK])","v":20},{"$f":"FoodTable[[#Totals],[BIAYA PER ANAK]]","v":{"v":7.252884190656953,"d":"Rp7.25"}},{"$f":"EssentialCostPerGuest","v":{"v":18.695652173913043,"d":"Rp18.70"}},{"$f":"(AttendeeSummary[[#This Row],[Makanan]]+AttendeeSummary[[#This Row],[Lainnya]])*ChildrenTotal","v":{"v":518.9707272914,"d":"Rp518.97"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,AttendeeSummary[Total Sudah Mengonfirmasi])","v":46},{"$f":"\"Rata-rata    \"&TEXT(SUBTOTAL(101,AttendeeSummary[Makanan]),\"Rp#,##0.00\")","v":"Rata-rata    Rp9.97"},{"$f":"\"Rata-rata     \"&TEXT(SUBTOTAL(101,AttendeeSummary[Lainnya]),\"Rp#,##0.00\")","v":"Rata-rata     Rp18.70"},{"$f":"SUBTOTAL(109,AttendeeSummary[Total])","v":{"v":1335,"d":"Rp1,335.00"}}]
[null,"WAKTU"]
[null,"14:00 hingga 16:00"]
[]
[null,"LOKASI",null,"RINGKASAN ANGGARAN"]
[null,"Rumah Tante Kim",null,"ITEM","JUMLAH","JUMLAH ANGGARAN","TOTAL BIAYA","SELISIH"]
[{"$nulls":3},"Makanan dan Minuman",{"$f":"COUNTA(FoodTable[ITEM MAKANAN ATAU MINUMAN])","v":18},{"v":500,"d":"Rp500.00"},{"$f":"FoodTable[[#Totals],[TOTAL BIAYA]]","v":{"v":475,"d":"Rp475.00"}},{"$f":"BudgetOverview[[#This Row],[JUMLAH ANGGARAN]]-BudgetOverview[[#This Row],[TOTAL BIAYA]]","v":{"v":25,"d":"Rp25.00"}}]
[{"$nulls":3},{"$f":"Table1Header","v":"Perlengkapan & Persediaan"},{"$f":"COUNTA(Table1Budget[Perlengkapan & Persediaan])","v":7},{"v":400,"d":"Rp400.00"},{"$f":"Table1Budget[[#Totals],[Biaya]]","v":{"v":400,"d":"Rp400.00"}},{"$f":"BudgetOverview[[#This Row],[JUMLAH ANGGARAN]]-BudgetOverview[[#This Row],[TOTAL BIAYA]]","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},{"$f":"Table2Header","v":"Dekorasi"},{"$f":"COUNTA(Table2Budget[Dekorasi])","v":4},{"v":150,"d":"Rp150.00"},{"$f":"Table2Budget[[#Totals],[Biaya]]","v":{"v":175,"d":"Rp175.00"}},{"$f":"BudgetOverview[[#This Row],[JUMLAH ANGGARAN]]-BudgetOverview[[#This Row],[TOTAL BIAYA]]","v":{"v":-25,"d":"Rp25.00"}}]
[{"$nulls":3},{"$f":"Table3Header","v":"Lainnya"},{"$f":"COUNTA(Table3Budget[Lainnya])","v":4},{"v":300,"d":"Rp300.00"},{"$f":"Table3Budget[[#Totals],[Biaya]]","v":{"v":285,"d":"Rp285.00"}},{"$f":"BudgetOverview[[#This Row],[JUMLAH ANGGARAN]]-BudgetOverview[[#This Row],[TOTAL BIAYA]]","v":{"v":15,"d":"Rp15.00"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,BudgetOverview[JUMLAH])","v":33},{"$f":"SUBTOTAL(109,BudgetOverview[JUMLAH ANGGARAN])","v":{"v":1350,"d":"Rp1,350.00"}},{"$f":"SUBTOTAL(109,BudgetOverview[TOTAL BIAYA])","v":{"v":1335,"d":"Rp1,335.00"}},{"$f":"BudgetOverview[[#Totals],[JUMLAH ANGGARAN]]-BudgetOverview[[#Totals],[TOTAL BIAYA]]","v":{"v":15,"d":"Rp15.00"}}]

{"sheet":"Daftar Tamu","index":1,"n_rows":22,"n_cols":12,"rows_kept":22}
[]
[]
[null,"Daftar Tamu"]
[]
[]
[]
[null,"NAMA","ALAMAT","KOTA","NEGARA BAGIAN","KODE POS","TELEPON","EMAIL","AKAN HADIR?","ANAK-ANAK","DEWASA","TOTAL"]
[null,"Keluarga 1","Alamat 1","Kota 1","Provinsi 1","Kode Pos 1","Telepon 1","Email1","Tidak",2,2,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":4}]
[null,"Keluarga 2","Alamat 2","Kota 2","Provinsi 2","Kode Pos 2","Telepon 2","Email2","Ya",1,1,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":2}]
[null,"Keluarga 3","Alamat 3","Kota 3","Provinsi 3","Kode Pos 3","Telepon 3","Email3","Ya",3,3,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":6}]
[null,"Keluarga 4","Alamat 4","Kota 4","Provinsi 4","Kode Pos 4","Telepon 4","Email4",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":2}]
[null,"Keluarga 5","Alamat 5","Kota 5","Provinsi 5","Kode Pos 5","Telepon 5","Email5","Ya",4,3,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":7}]
[null,"Keluarga 6","Alamat 6","Kota 6","Provinsi 6","Kode Pos 6","Telepon 6","Email6","Ya",2,2,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":4}]
[null,"Keluarga 7","Alamat 7","Kota 7","Provinsi 7","Kode Pos 7","Telepon 7","Email7","Ya",1,4,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":5}]
[null,"Keluarga 8","Alamat 8","Kota 8","Provinsi 8","Kode Pos 8","Telepon 8","Email8","Tidak",5,3,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":8}]
[null,"Keluarga 9","Alamat 9","Kota 9","Provinsi 9","Kode Pos 9","Telepon 9","Email9","Ya",3,2,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":5}]
[null,"Keluarga 10","Alamat 10","Kota 10","Provinsi 10","Kode Pos 10","Telepon 10","Email10","Ya",null,4,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":4}]
[null,"Keluarga 11","Alamat 11","Kota 11","Provinsi 11","Kode Pos 11","Telepon 11","Email11","Ya",3,5,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":8}]
[null,"Keluarga 12","Alamat 12","Kota 12","Provinsi 12","Kode Pos 12","Telepon 12","Email12","Tidak",2,3,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":5}]
[null,"Keluarga 13","Alamat 13","Kota 13","Provinsi 13","Kode Pos 13","Telepon 13","Email13","Ya",3,2,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":5}]
[null,"Keluarga 14","Alamat 14","Kota 14","Provinsi 14","Kode Pos 14","Telepon 14","Email14","Tidak",null,1,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":1}]
[null,"Keluarga 15","Alamat 15","Kota 15","Provinsi 15","Kode Pos 15","Telepon 15","Email15",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[ANAK-ANAK]:[DEWASA]])","v":2}]

{"sheet":"Makanan & Minuman","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"Makanan & Minuman"]
[]
[null,"Masukkan biaya dan perkiraan porsi untuk menghitung secara otomatis jumlah total porsi dan biaya per porsi berdasarkan total kehadiran"]
[null,"ITEM MAKANAN ATAU MINUMAN","TOTAL BIAYA","PORSI PER ANAK","PORSI PER ORANG DEWASA","TOTAL PORSI","BIAYA PER PORSI","BIAYA PER ANAK","BIAYA PER ORANG DEWASA","CATATAN"]
[null,"Soda",{"v":15,"d":"Rp15"},0.5,2,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":62},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.24193548387096775,"d":"Rp0.24"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.12096774193548387,"d":"Rp0.12"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.4838709677419355,"d":"Rp0.48"}},"Botol 2 liter"]
[null,"Jus kemasan kotak",{"v":15,"d":"Rp15"},2,0,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":40},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.375,"d":"Rp0.38"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.75,"d":"Rp0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0,"d":"Rp0.00"}},"Apel dan anggur putih"]
[null,"Anggur",{"v":50,"d":"Rp50"},0,2,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":52},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.9615384615384616,"d":"Rp0.96"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":1.9230769230769231,"d":"Rp1.92"}}]
[null,"Kue",{"v":75,"d":"Rp75"},1,1,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":46},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":1.6304347826086956,"d":"Rp1.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":1.6304347826086956,"d":"Rp1.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":1.6304347826086956,"d":"Rp1.63"}},"Pesan dari toko kue setempat"]
[null,"Es krim",{"v":20,"d":"Rp20"},1,1.5,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":59},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.3389830508474576,"d":"Rp0.34"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.3389830508474576,"d":"Rp0.34"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.5084745762711864,"d":"Rp0.51"}}]
[null,"Puding dalam mangkuk",{"v":15,"d":"Rp15"},1,0,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":20},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.75,"d":"Rp0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.75,"d":"Rp0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0,"d":"Rp0.00"}},"Beli puding dalam kemasan mangkuk: vanilla dan coklat"]
[null,"Jamur isi",{"v":32,"d":"Rp32"},1,2,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.4444444444444444,"d":"Rp0.44"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.4444444444444444,"d":"Rp0.44"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.8888888888888888,"d":"Rp0.89"}},"Jamur kunci diisi dengan krim keju dan sosis"]
[null,"Bruschetta",{"v":22,"d":"Rp22"},0,3,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":78},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.28205128205128205,"d":"Rp0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.8461538461538461,"d":"Rp0.85"}},"Tomat dan basil "]
[null,"Salmon asap",{"v":50,"d":"Rp50"},1,2,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.6944444444444444,"d":"Rp0.69"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.6944444444444444,"d":"Rp0.69"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":1.3888888888888888,"d":"Rp1.39"}}]
[null,"Bagel mini",{"v":20,"d":"Rp20"},1,2,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.2777777777777778,"d":"Rp0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.2777777777777778,"d":"Rp0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.5555555555555556,"d":"Rp0.56"}},"4 kantong - aneka rasa"]
[null,"Krim keju",{"v":10,"d":"Rp10"},1,2,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.1388888888888889,"d":"Rp0.14"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.1388888888888889,"d":"Rp0.14"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.2777777777777778,"d":"Rp0.28"}},"2 mangkuk besar"]
[null,"Caper",{"v":12,"d":"Rp12"},1,2,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.16666666666666666,"d":"Rp0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.16666666666666666,"d":"Rp0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.3333333333333333,"d":"Rp0.33"}},"3 toples"]
[null,"Sayap ayam",{"v":45,"d":"Rp45"},2,4,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":144},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.3125,"d":"Rp0.31"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.625,"d":"Rp0.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":1.25,"d":"Rp1.25"}},"Beli dari toko sayap ayam setempat"]
[null,"Hummus",{"v":10,"d":"Rp10"},4,6,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.0423728813559322,"d":"Rp0.04"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.1694915254237288,"d":"Rp0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.2542372881355932,"d":"Rp0.25"}},"Buat malam sebelumnya"]
[null,"Keripik parmesan pita",{"v":14,"d":"Rp14"},4,6,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.059322033898305086,"d":"Rp0.06"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.23728813559322035,"d":"Rp0.24"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.3559322033898305,"d":"Rp0.36"}},"Buat malam sebelumnya"]
[null,"Aneka sayuran",{"v":30,"d":"Rp30"},4,10,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":340},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.08823529411764706,"d":"Rp0.09"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.35294117647058826,"d":"Rp0.35"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.8823529411764707,"d":"Rp0.88"}},"Potongan wortel, seledri, brokoli, kembang kol, paprika merah dan hijau"]
[null,"Bola keju",{"v":15,"d":"Rp15"},5,10,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.041666666666666664,"d":"Rp0.04"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.20833333333333331,"d":"Rp0.21"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.41666666666666663,"d":"Rp0.42"}},"Aneka rasa: krim keju, keju cita rasa tajam dengan kacang"]
[null,"Kerupuk",{"v":25,"d":"Rp25"},5,10,{"$f":"(FoodTable[[#This Row],[PORSI PER ANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[PORSI PER ORANG DEWASA]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL BIAYA]]/FoodTable[[#This Row],[TOTAL PORSI]],\"\")","v":{"v":0.06944444444444445,"d":"Rp0.07"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ANAK]],\"\")","v":{"v":0.3472222222222222,"d":"Rp0.35"}},{"$f":"IFERROR(FoodTable[[#This Row],[BIAYA PER PORSI]]*FoodTable[[#This Row],[PORSI PER ORANG DEWASA]],\"\")","v":{"v":0.6944444444444444,"d":"Rp0.69"}},"Aneka rasa"]
[null,"Total",{"$f":"SUBTOTAL(109,FoodTable[TOTAL BIAYA])","v":{"v":475,"d":"Rp475"}},{"$f":"SUBTOTAL(109,FoodTable[PORSI PER ANAK])","v":34.5},{"$f":"SUBTOTAL(109,FoodTable[PORSI PER ORANG DEWASA])","v":65.5},{"$f":"SUBTOTAL(109,FoodTable[TOTAL PORSI])","v":2393},{"$f":"SUBTOTAL(109,FoodTable[BIAYA PER PORSI])","v":{"v":6.915706603622084,"d":"Rp6.92"}},{"$f":"SUBTOTAL(109,FoodTable[BIAYA PER ANAK])","v":{"v":7.252884190656953,"d":"Rp7.25"}},{"$f":"SUBTOTAL(109,FoodTable[BIAYA PER ORANG DEWASA])","v":{"v":12.690089084110037,"d":"Rp12.69"}}]

{"sheet":"Barang Lainnya yang Diperlukan ","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[14,1,14,4],[22,1,22,4]]}
[]
[]
[null,"Barang Lainnya yang Diperlukan"]
[]
[]
[null,"Perlengkapan & Persediaan","Biaya","Dibeli","Catatan"]
[null,"Sewa ruangan/aula",{"v":250,"d":"Rp250.00"},"Ya"]
[null,"Linen",{"v":30,"d":"Rp30.00"},"Ya","Sewa"]
[null,"Meja dan kursi",{"v":0,"d":"Rp0.00"},null,"Termasuk dalam sewa aula"]
[null,"Serbet minuman",{"v":25,"d":"Rp25.00"}]
[null,"Serbet makan malam",{"v":20,"d":"Rp20.00"},null,"Sewa"]
[null,"Layanan meja",{"v":50,"d":"Rp50.00"},null,"Sewa"]
[null,"Barang Pecah Belah",{"v":25,"d":"Rp25.00"},null,"Sewa"]
[null,"Total",{"$f":"SUBTOTAL(109,Table1Budget[Biaya])","v":{"v":400,"d":"Rp400.00"}}]
[]
[]
[null,"Dekorasi","Biaya","Dibeli","Catatan"]
[null,"Balon",{"v":25,"d":"Rp25.00"}]
[null,"Tabung helium",{"v":50,"d":"Rp50.00"},null,"Sewa"]
[null,"Hiasan di tengah meja",{"v":100,"d":"Rp100.00"},"Ya","Total 10"]
[null,"Vas kaca",{"v":0,"d":"Rp0.00"},null,"Pinjam dari Sandy"]
[null,"Total",{"$f":"SUBTOTAL(109,Table2Budget[Biaya])","v":{"v":175,"d":"Rp175.00"}}]
[]
[]
[null,"Lainnya","Biaya","Dibeli","Catatan"]
[null,"Undangan",{"v":50,"d":"Rp50.00"},"Ya"]
[null,"Ongkos kirim",{"v":60,"d":"Rp60.00"},"Ya"]
[null,"Fotografer",{"v":125,"d":"Rp125.00"},null,"2 jam (14:00 - 16:00)"]
[null,"Pernak-pernik pesta",{"v":50,"d":"Rp50.00"}]
[null,"Total",{"$f":"SUBTOTAL(109,Table3Budget[Biaya])","v":{"v":285,"d":"Rp285.00"}}]

{"sheet":"Pengaturan Tempat Duduk","index":4,"n_rows":43,"n_cols":34,"rows_kept":43,"merged":[[35,0,35,17],[35,19,35,33]]}
["Pengaturan Tempat Duduk"]
{"$rows_empty":33}
[{"$nulls":33},"*1 kotak= kira-kira 1 kaki persegi"]
["Catatan",{"$nulls":18},{"$f":"\"Total tamu yang sudah mengonfirmasi: \"&ConfirmedGuests","v":"Total tamu yang sudah mengonfirmasi: 46"}]
[{"$nulls":19},"Anda bisa menggunakan salah satu tataan meja berikut:"]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)&\" meja bulat 54 inci (6 kursi)\"","v":"8 meja bulat 54 inci (6 kursi)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0) &\" meja bulat 60 inci (8 kursi)\"","v":"6 meja bulat 60 inci (8 kursi)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/10,0)&\" meja bulat 72 inci (10 kursi)\"","v":"5 meja bulat 72 inci (10 kursi)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)& \" meja persegi 30-inci x 72-inci (6 kursi)\"","v":"8 meja persegi 30-inci x 72-inci (6 kursi)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0)&\" meja persegi 30-inci x 96-inci (8 kursi)\"","v":"6 meja persegi 30-inci x 96-inci (8 kursi)"}]
[{"$nulls":19}," (Pilihan jarak antar meja: 42 inci)"]