{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Gambaran Keseluruhan Majlis","Senarai Tetamu","Makanan & Minuman","Lain-lain Yang Penting","Grid Susunan Tempat Duduk"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Gambaran Keseluruhan Majlis","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"merged":[[6,3,6,4],[6,5,6,6],[9,1,9,2]]}
[]
[]
[null,"Gambaran Keseluruhan Majlis"]
[]
[]
[null,"ACARA",null,"RINGKASAN TETAMU",{"$nulls":3},{"$f":"\"JAWAPAN YANG BELUM DITERIMA:  \"&OutstandingRSVPs","v":"JAWAPAN YANG BELUM DITERIMA:  2"}]
[null,"Hari Lahir Nenek yang ke-75",null,"GAMBARAN KESELURUHAN JAWAPAN",null,"KOS PER TETAMU",null,"AMAUN BAJET"]
[{"$nulls":3},"Tetamu yang Pasti","Jumlah Yang Pasti","Makanan","Lain","Jumlah"]
[null,"TARIKH",null,"ORANG DEWASA",{"$f":"SUMIF(GuestTable[HADIR?],\"=Ya\",GuestTable[ORANG DEWASA])","v":26},{"$f":"FoodTable[[#Totals],[KOS PER ORANG DEWASA]]","v":{"v":12.690089084110037,"d":"RM12.69"}},{"$f":"EssentialCostPerGuest","v":{"v":18.695652173913043,"d":"RM18.70"}},{"$f":"(AttendeeSummary[[#This Row],[Makanan]]+AttendeeSummary[[#This Row],[Lain]])*AdultTotal","v":{"v":816.0292727086002,"d":"RM816.03"}}]
[null,"2011-06-14",null,"Anak-anak",{"$f":"SUMIF(GuestTable[HADIR?],\"=Ya\",GuestTable[KANAK-KANAK])","v":20},{"$f":"FoodTable[[#Totals],[KOS PER KANAK-KANAK]]","v":{"v":7.252884190656953,"d":"RM7.25"}},{"$f":"EssentialCostPerGuest","v":{"v":18.695652173913043,"d":"RM18.70"}},{"$f":"(AttendeeSummary[[#This Row],[Makanan]]+AttendeeSummary[[#This Row],[Lain]])*ChildrenTotal","v":{"v":518.9707272914,"d":"RM518.97"}}]
[{"$nulls":3},"Jumlah",{"$f":"SUBTOTAL(109,AttendeeSummary[Jumlah Yang Pasti])","v":46},{"$f":"\"Purata     \"&TEXT(SUBTOTAL(101,AttendeeSummary[Makanan]),\"RM#,##0.00\")","v":"Purata     RM9.97"},{"$f":"\"Purata     \"&TEXT(SUBTOTAL(101,AttendeeSummary[Lain]),\"RM#,##0.00\")","v":"Purata     RM18.70"},{"$f":"SUBTOTAL(109,AttendeeSummary[Jumlah])","v":{"v":1335,"d":"RM1,335.00"}}]
[null,"MASA"]
[null,"2 pm hingga 4 pm"]
[]
[null,"LOKASI",null,"RINGKASAN BAJET"]
[null,"Rumah Mak Cik Kim",null,"ITEM","KIRAAN","AMAUN BAJET","JUMLAH KOS","PERBEZAAN"]
[{"$nulls":3},"Makanan dan Minuman",{"$f":"COUNTA(FoodTable[ITEM MAKANAN ATAU MINUMAN])","v":18},{"v":500,"d":"RM500.00"},{"$f":"FoodTable[[#Totals],[JUMLAH KOS]]","v":{"v":475,"d":"RM475.00"}},{"$f":"BudgetOverview[[#This Row],[AMAUN BAJET]]-BudgetOverview[[#This Row],[JUMLAH KOS]]","v":{"v":25,"d":"RM25.00"}}]
[{"$nulls":3},{"$f":"Table1Header","v":"Peralatan & Bekalan"},{"$f":"COUNTA(BajetJadual1[Peralatan & Bekalan])","v":7},{"v":400,"d":"RM400.00"},{"$f":"BajetJadual1[[#Totals],[Kos]]","v":{"v":400,"d":"RM400.00"}},{"$f":"BudgetOverview[[#This Row],[AMAUN BAJET]]-BudgetOverview[[#This Row],[JUMLAH KOS]]","v":{"v":0,"d":"RM0.00"}}]
[{"$nulls":3},{"$f":"Table2Header","v":"Perhiasan"},{"$f":"COUNTA(BajetJadual2[Perhiasan])","v":4},{"v":150,"d":"RM150.00"},{"$f":"BajetJadual2[[#Totals],[Kos]]","v":{"v":175,"d":"RM175.00"}},{"$f":"BudgetOverview[[#This Row],[AMAUN BAJET]]-BudgetOverview[[#This Row],[JUMLAH KOS]]","v":{"v":-25,"d":"(RM25.00)"}}]
[{"$nulls":3},{"$f":"Table3Header","v":"Lain"},{"$f":"COUNTA(BajetJadual3[Lain])","v":4},{"v":300,"d":"RM300.00"},{"$f":"BajetJadual3[[#Totals],[Kos]]","v":{"v":285,"d":"RM285.00"}},{"$f":"BudgetOverview[[#This Row],[AMAUN BAJET]]-BudgetOverview[[#This Row],[JUMLAH KOS]]","v":{"v":15,"d":"RM15.00"}}]
[{"$nulls":3},"Jumlah",{"$f":"SUBTOTAL(109,BudgetOverview[KIRAAN])","v":33},{"$f":"SUBTOTAL(109,BudgetOverview[AMAUN BAJET])","v":{"v":1350,"d":"RM1,350.00"}},{"$f":"SUBTOTAL(109,BudgetOverview[JUMLAH KOS])","v":{"v":1335,"d":"RM1,335.00"}},{"$f":"BudgetOverview[[#Totals],[AMAUN BAJET]]-BudgetOverview[[#Totals],[JUMLAH KOS]]","v":{"v":15,"d":"RM15.00"}}]

{"sheet":"Senarai Tetamu","index":1,"n_rows":22,"n_cols":12,"rows_kept":22}
[]
[]
[null,"Senarai Tetamu"]
[]
[]
[]
[null,"NAMA","ALAMAT","BANDAR","NEGERI","POSKOD","TELEFON","E-MEL","HADIR?","KANAK-KANAK","ORANG DEWASA","JUMLAH"]
[null,"Keluarga 1","Alamat 1","Bandar 1","Negeri 1","Poskod 1","Telefon 1","E-mel1","Tidak",2,2,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":4}]
[null,"Keluarga 2","Alamat 2","Bandar 2","Negeri 2","Poskod 2","Telefon 2","E-mel2","Ya",1,1,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":2}]
[null,"Keluarga 3","Alamat 3","Bandar 3","Negeri 3","Poskod 3","Telefon 3","E-mel3","Ya",3,3,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":6}]
[null,"Keluarga 4","Alamat 4","Bandar 4","Negeri 4","Poskod 4","Telefon 4","E-mel4",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":2}]
[null,"Keluarga 5","Alamat 5","Bandar 5","Negeri 5","Poskod 5","Telefon 5","E-mel5","Ya",4,3,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":7}]
[null,"Keluarga 6","Alamat 6","Bandar 6","Negeri 6","Poskod 6","Telefon 6","E-mel6","Ya",2,2,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":4}]
[null,"Keluarga 7","Alamat 7","Bandar 7","Negeri 7","Poskod 7","Telefon 7","E-mel7","Ya",1,4,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":5}]
[null,"Keluarga 8","Alamat 8","Bandar 8","Negeri 8","Poskod 8","Telefon 8","E-mel8","Tidak",5,3,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":8}]
[null,"Keluarga 9","Alamat 9","Bandar 9","Negeri 9","Poskod 9","Telefon 9","E-mel9","Ya",3,2,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":5}]
[null,"Keluarga 10","Alamat 10","Bandar 10","Negeri 10","Poskod 10","Telefon 10","E-mel10","Ya",null,4,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":4}]
[null,"Keluarga 11","Alamat 11","Bandar 11","Negeri 11","Poskod 11","Telefon 11","E-mel11","Ya",3,5,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":8}]
[null,"Keluarga 12","Alamat 12","Bandar 12","Negeri 12","Poskod 12","Telefon 12","E-mel12","Tidak",2,3,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":5}]
[null,"Keluarga 13","Alamat 13","Bandar 13","Negeri 13","Poskod 13","Telefon 13","E-mel13","Ya",3,2,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":5}]
[null,"Keluarga 14","Alamat 14","Bandar 14","Negeri 14","Poskod 14","Telefon 14","E-mel14","Tidak",null,1,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":1}]
[null,"Keluarga 15","Alamat 15","Bandar 15","Negeri 15","Poskod 15","Telefon 15","E-mel15",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[KANAK-KANAK]:[ORANG DEWASA]])","v":2}]

{"sheet":"Makanan & Minuman","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"Makanan & Minuman"]
[]
[null,"Masukkan kos dan hidangan anggaran untuk mengira jumlah dan kos per hidangan berdasarkan jumlah kehadiran"]
[null,"ITEM MAKANAN ATAU MINUMAN","JUMLAH KOS","HIDANGAN PER KANAK-KANAK","HIDANGAN PER ORANG DEWASA","JUMLAH HIDANGAN","KOS PER HIDANGAN","KOS PER KANAK-KANAK","KOS PER ORANG DEWASA","NOTA"]
[null,"Soda",{"v":15,"d":"RM15.00"},0.5,2,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":62},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.24193548387096775,"d":"RM0.24"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.12096774193548387,"d":"RM0.12"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.4838709677419355,"d":"RM0.48"}},"Botol 2 liter"]
[null,"Kotak jus",{"v":15,"d":"RM15.00"},2,0,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":40},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.375,"d":"RM0.38"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.75,"d":"RM0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0,"d":"RM0.00"}},"Epal dan anggur"]
[null,"Wain",{"v":50,"d":"RM50.00"},0,2,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":52},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.9615384615384616,"d":"RM0.96"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0,"d":"RM0.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":1.9230769230769231,"d":"RM1.92"}}]
[null,"Kek",{"v":75,"d":"RM75.00"},1,1,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":46},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":1.6304347826086956,"d":"RM1.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":1.6304347826086956,"d":"RM1.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":1.6304347826086956,"d":"RM1.63"}},"Pesan daripada kedai kek tempatan"]
[null,"Aiskrim",{"v":20,"d":"RM20.00"},1,1.5,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":59},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.3389830508474576,"d":"RM0.34"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.3389830508474576,"d":"RM0.34"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.5084745762711864,"d":"RM0.51"}}]
[null,"Cawan puding",{"v":15,"d":"RM15.00"},1,0,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":20},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.75,"d":"RM0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.75,"d":"RM0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0,"d":"RM0.00"}},"Beli cawan pakej: vanila dan coklat"]
[null,"Cendawan berisi",{"v":32,"d":"RM32.00"},1,2,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.4444444444444444,"d":"RM0.44"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.4444444444444444,"d":"RM0.44"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.8888888888888888,"d":"RM0.89"}},"Cendawan diisi dengan keju krim dan sosej"]
[null,"Bruschetta",{"v":22,"d":"RM22.00"},0,3,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":78},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.28205128205128205,"d":"RM0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0,"d":"RM0.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.8461538461538461,"d":"RM0.85"}},"Tomato dan basil "]
[null,"Ikan Salmon Salai",{"v":50,"d":"RM50.00"},1,2,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.6944444444444444,"d":"RM0.69"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.6944444444444444,"d":"RM0.69"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":1.3888888888888888,"d":"RM1.39"}}]
[null,"Roti bagel mini",{"v":20,"d":"RM20.00"},1,2,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.2777777777777778,"d":"RM0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.2777777777777778,"d":"RM0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.5555555555555556,"d":"RM0.56"}},"4 beg - pelbagai"]
[null,"Keju krim",{"v":10,"d":"RM10.00"},1,2,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.1388888888888889,"d":"RM0.14"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.1388888888888889,"d":"RM0.14"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.2777777777777778,"d":"RM0.28"}},"2 besen besar"]
[null,"Kaper",{"v":12,"d":"RM12.00"},1,2,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.16666666666666666,"d":"RM0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.16666666666666666,"d":"RM0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.3333333333333333,"d":"RM0.33"}},"3 balang"]
[null,"Kepak ayam",{"v":45,"d":"RM45.00"},2,4,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":144},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.3125,"d":"RM0.31"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.625,"d":"RM0.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":1.25,"d":"RM1.25"}},"Dibeli dari kedai kepak tempatan"]
[null,"Hummus",{"v":10,"d":"RM10.00"},4,6,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.0423728813559322,"d":"RM0.04"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.1694915254237288,"d":"RM0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.2542372881355932,"d":"RM0.25"}},"Sediakan pada malam sebelumnya"]
[null,"Kerepek pita parmesan",{"v":14,"d":"RM14.00"},4,6,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.059322033898305086,"d":"RM0.06"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.23728813559322035,"d":"RM0.24"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.3559322033898305,"d":"RM0.36"}},"Sediakan pada malam sebelumnya"]
[null,"Pelbagai sayuran",{"v":30,"d":"RM30.00"},4,10,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":340},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.08823529411764706,"d":"RM0.09"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.35294117647058826,"d":"RM0.35"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.8823529411764707,"d":"RM0.88"}},"Lobak merah, saderi, kubis bunga, lada merah dan hijau"]
[null,"Bebola keju",{"v":15,"d":"RM15.00"},5,10,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.041666666666666664,"d":"RM0.04"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.20833333333333331,"d":"RM0.21"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.41666666666666663,"d":"RM0.42"}},"Pelbagai: keju krim, keju dengan kacang"]
[null,"Biskut",{"v":25,"d":"RM25.00"},5,10,{"$f":"(FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]]*ChildrenTotal)+(FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[JUMLAH KOS]]/FoodTable[[#This Row],[JUMLAH HIDANGAN]],\"\")","v":{"v":0.06944444444444445,"d":"RM0.07"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER KANAK-KANAK]],\"\")","v":{"v":0.3472222222222222,"d":"RM0.35"}},{"$f":"IFERROR(FoodTable[[#This Row],[KOS PER HIDANGAN]]*FoodTable[[#This Row],[HIDANGAN PER ORANG DEWASA]],\"\")","v":{"v":0.6944444444444444,"d":"RM0.69"}},"Pelbagai"]
[null,"Jumlah",{"$f":"SUBTOTAL(109,FoodTable[JUMLAH KOS])","v":{"v":475,"d":"RM475.00"}},{"$f":"SUBTOTAL(109,FoodTable[HIDANGAN PER KANAK-KANAK])","v":34.5},{"$f":"SUBTOTAL(109,FoodTable[HIDANGAN PER ORANG DEWASA])","v":65.5},{"$f":"SUBTOTAL(109,FoodTable[JUMLAH HIDANGAN])","v":2393},{"$f":"SUBTOTAL(109,FoodTable[KOS PER HIDANGAN])","v":{"v":6.915706603622084,"d":"RM6.92"}},{"$f":"SUBTOTAL(109,FoodTable[KOS PER KANAK-KANAK])","v":{"v":7.252884190656953,"d":"RM7.25"}},{"$f":"SUBTOTAL(109,FoodTable[KOS PER ORANG DEWASA])","v":{"v":12.690089084110037,"d":"RM12.69"}}]

{"sheet":"Lain-lain Yang Penting","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[14,1,14,4],[22,1,22,4]]}
[]
[]
[null,"Lain-lain Yang Penting"]
[]
[]
[null,"Peralatan & Bekalan","Kos","Dibeli","Nota"]
[null,"Sewaan bilik/dewan",{"v":250,"d":"RM250.00"},"Ya"]
[null,"Linen",{"v":30,"d":"RM30.00"},"Ya","Sewa"]
[null,"Meja dan kerusi",{"v":0,"d":"RM0.00"},null,"Termasuk dalam sewaan dewan"]
[null,"Napkin minuman",{"v":25,"d":"RM25.00"}]
[null,"Napkin meja",{"v":20,"d":"RM20.00"},null,"Sewa"]
[null,"Khidmat meja",{"v":50,"d":"RM50.00"},null,"Sewa"]
[null,"Alat kaca",{"v":25,"d":"RM25.00"},null,"Sewa"]
[null,"Jumlah",{"$f":"SUBTOTAL(109,BajetJadual1[Kos])","v":{"v":400,"d":"RM400.00"}}]
[]
[]
[null,"Perhiasan","Kos","Dibeli","Nota"]
[null,"Belon",{"v":25,"d":"RM25.00"}]
[null,"Tangki helium",{"v":50,"d":"RM50.00"},null,"Sewa"]
[null,"Hiasan tengah meja",{"v":100,"d":"RM100.00"},"Ya","10 jumlah"]
[null,"Pasu bunga gelas",{"v":0,"d":"RM0.00"},null,"Pinjam daripada Sandy"]
[null,"Jumlah",{"$f":"SUBTOTAL(109,BajetJadual2[Kos])","v":{"v":175,"d":"RM175.00"}}]
[]
[]
[null,"Lain","Kos","Dibeli","Nota"]
[null,"Jemputan",{"v":50,"d":"RM50.00"},"Ya"]
[null,"Bayaran Pos",{"v":60,"d":"RM60.00"},"Ya"]
[null,"Jurugambar",{"v":125,"d":"RM125.00"},null,"2 jam (2 pm - 4 pm)"]
[null,"Kemudahan majlis",{"v":50,"d":"RM50.00"}]
[null,"Jumlah",{"$f":"SUBTOTAL(109,BajetJadual3[Kos])","v":{"v":285,"d":"RM285.00"}}]

{"sheet":"Grid Susunan Tempat Duduk","index":4,"n_rows":43,"n_cols":34,"rows_kept":43,"merged":[[35,0,35,17],[35,19,35,33]]}
["Susunan Tempat Duduk"]
{"$rows_empty":33}
[{"$nulls":33},"*1 persegi= anggaran 1 kaki persegi"]
["Nota",{"$nulls":18},{"$f":"\" Jumlah tetamu yang pasti: \"&ConfirmedGuests","v":" Jumlah tetamu yang pasti: 46"}]
[{"$nulls":19},"Anda boleh menggunakan sebarang persediaan meja berikut:"]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)&\" meja bulat 54 inci (6 tempat duduk)\"","v":"8 meja bulat 54 inci (6 tempat duduk)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0) &\" meja bulat 60 inci (8 tempat duduk)\"","v":"6 meja bulat 60 inci (8 tempat duduk)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/10,0)&\" meja bulat 72 inci (10 tempat duduk)\"","v":"5 meja bulat 72 inci (10 tempat duduk)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)& \" meja segi empat 30 inci x 72 inci (6 tempat duduk)\"","v":"8 meja segi empat 30 inci x 72 inci (6 tempat duduk)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0)&\" meja segi empat 30 inci x 96 inci (8 tempat duduk)\"","v":"6 meja segi empat 30 inci x 96 inci (8 tempat duduk)"}]
[{"$nulls":19},"(Ruang di antara meja yang diinginkan: 42 inci)"]