{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Pengeluaran","Pendapatan","Ringkasan"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Pengeluaran","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[0,6,0,8],[1,6,1,7],[2,1,2,8],[3,7,3,8]]}
[]
[]
[null,"Anggaran Acara untuk \n[Nama Acara]"]
[{"$nulls":7}," Pengeluaran"]
[]
[{"$nulls":7},"Estimasi","Aktual"]
[null,null,"Total Pengeluaran",{"$nulls":4},{"$f":"SUM(D14,D22,D28,D35,H14,H22,H27)","v":{"v":1145,"d":"Rp1,145.00"}},{"$f":"SUM(E14,E22,E28,E35,I14,I22,I27)","v":{"v":395,"d":"Rp395.00"}}]
[]
[null,null,"Lokasi","Estimasi","Aktual",null,"Makanan Ringan","Estimasi","Aktual"]
[null,null,"Biaya ruangan dan aula",{"v":500,"d":"Rp500.00"},{"v":250,"d":"Rp250.00"},null,"Makanan"]
[null,null,"Staf lokasi",{"v":400,"d":"Rp400.00"},{"v":50,"d":"Rp50.00"},null,"Minuman"]
[null,null,"Peralatan",{"$nulls":3},"Taplak"]
[null,null,"Meja dan kursi",{"$nulls":3},"Staf dan tip"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Tabel1[Estimasi])","v":{"v":900,"d":"Rp900.00"}},{"$f":"SUBTOTAL(109,Tabel1[Aktual])","v":{"v":300,"d":"Rp300.00"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel5[Estimasi])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel5[Aktual])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,null,"Dekorasi","Estimasi","Aktual",null,"Program","Estimasi","Aktual"]
[null,null,"Bunga",{"v":200,"d":"Rp200.00"},{"v":50,"d":"Rp50.00"},null,"Hiburan"]
[null,null,"Lilin",{"$nulls":3},"Pembicara"]
[null,null,"Lampu",{"$nulls":3},"Perjalanan"]
[null,null,"Balon",{"$nulls":3},"Hotel"]
[null,null,"Perlengkapan kertas",{"$nulls":3},"Lainnya"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Tabel2[Estimasi])","v":{"v":200,"d":"Rp200.00"}},{"$f":"SUBTOTAL(109,Tabel2[Aktual])","v":{"v":50,"d":"Rp50.00"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel6[Estimasi])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel6[Aktual])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,null,"Publikasi","Estimasi","Aktual",null,"Hadiah","Estimasi","Aktual"]
[null,null,"Karya grafis",{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},null,"Pita/Plakat/Piala"]
[null,null,"Fotokopi/Percetakan",{"$nulls":3},"Hadiah"]
[null,null,"Ongkos kirim",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,Tabel7[Estimasi])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel7[Aktual])","v":{"v":0,"d":"Rp0.00"}}]
[null,null,"Total",{"$f":"SUBTOTAL(109,Tabel3[Estimasi])","v":{"v":45,"d":"Rp45.00"}},{"$f":"SUBTOTAL(109,Tabel3[Aktual])","v":{"v":45,"d":"Rp45.00"}}]
[]
[null,null,"Lain-lain","Estimasi","Aktual"]
[null,null,"Telepon"]
[null,null,"Transportasi"]
[null,null,"Perlengkapan alat tulis"]
[null,null,"Layanan faks"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Tabel4[Estimasi])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel4[Aktual])","v":{"v":0,"d":"Rp0.00"}}]

{"sheet":"Pendapatan","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"merged":[[2,1,2,6],[3,5,3,6],[14,1,14,6],[21,1,21,6],[28,1,28,6]]}
[]
[]
[null,"Anggaran Acara untuk \n[Nama Acara]"]
[{"$nulls":5}," Pendapatan"]
[]
[{"$nulls":5},"Estimasi","Aktual"]
[null,"Total Pendapatan",{"$nulls":3},{"$f":"SUM(F14,F21,F28,F36)","v":{"v":1936,"d":"Rp1,936.00"}},{"$f":"SUM(G14,G21,G28,G36)","v":{"v":1831,"d":"Rp1,831.00"}}]
[]
[null,"Karcis Masuk"]
[null,"Estimasi","Aktual",null,null,"Estimasi","Aktual"]
[null,300,278,"Dewasa @",{"v":5,"d":"Rp5.00"},{"$f":"B11*E11","v":{"v":1500,"d":"Rp1,500.00"}},{"$f":"C11*E11","v":{"v":1390,"d":"Rp1,390.00"}}]
[null,197,195,"Anak-anak @",{"v":2,"d":"Rp2.00"},{"$f":"B12*E12","v":{"v":394,"d":"Rp394.00"}},{"$f":"C12*E12","v":{"v":390,"d":"Rp390.00"}}]
[null,42,51,"Lainnya @",{"v":1,"d":"Rp1.00"},{"$f":"B13*E13","v":{"v":42,"d":"Rp42.00"}},{"$f":"C13*E13","v":{"v":51,"d":"Rp51.00"}}]
[{"$nulls":5},{"$f":"SUM(F11:F13)","v":{"v":1936,"d":"Rp1,936.00"}},{"$f":"SUM(G11:G13)","v":{"v":1831,"d":"Rp1,831.00"}}]
[]
[null,"Iklan dalam program"]
[null,"Estimasi","Aktual",null,null,"Estimasi","Aktual"]
[{"$nulls":3},"Sampul @",null,{"$f":"B18*E18","v":{"v":0,"d":"Rp0.00"}},{"$f":"C18*E18","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},"Setengah halaman @",null,{"$f":"B19*E19","v":{"v":0,"d":"Rp0.00"}},{"$f":"C19*E19","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},"Seperempat halaman @",null,{"$f":"B20*E20","v":{"v":0,"d":"Rp0.00"}},{"$f":"C20*E20","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":5},{"$f":"SUM(F18:F20)","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUM(G18:G20)","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Peserta pameran/vendor"]
[null,"Estimasi","Aktual",null,null,"Estimasi","Aktual"]
[{"$nulls":3},"Stan besar @",null,{"$f":"B25*E25","v":{"v":0,"d":"Rp0.00"}},{"$f":"C25*E25","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},"Stan sedang @",null,{"$f":"B26*E26","v":{"v":0,"d":"Rp0.00"}},{"$f":"C26*E26","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},"Stan kecil @",null,{"$f":"B27*E27","v":{"v":0,"d":"Rp0.00"}},{"$f":"C27*E27","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":5},{"$f":"SUM(F25:F27)","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUM(G25:G27)","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Penjualan item"]
[null,"Estimasi","Aktual",null,null,"Estimasi","Aktual"]
[{"$nulls":3},"Item @",null,{"$f":"B32*E32","v":{"v":0,"d":"Rp0.00"}},{"$f":"C32*E32","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},"Item @",null,{"$f":"B33*E33","v":{"v":0,"d":"Rp0.00"}},{"$f":"C33*E33","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},"Item @",null,{"$f":"B34*E34","v":{"v":0,"d":"Rp0.00"}},{"$f":"C34*E34","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},"Item @",null,{"$f":"B35*E35","v":{"v":0,"d":"Rp0.00"}},{"$f":"C35*E35","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":5},{"$f":"SUM(F32:F35)","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUM(G32:G35)","v":{"v":0,"d":"Rp0.00"}}]

{"sheet":"Ringkasan","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[2,1,2,6],[3,5,3,6]]}
[]
[]
[null,"Anggaran Acara untuk \n[Nama Acara]"]
[{"$nulls":5},"Ringkasan Laba-Rugi"]
[]
[{"$nulls":5},"Estimasi","Aktual"]
[null,"Total pendapatan",{"$nulls":3},{"$f":"Pendapatan!F7","v":{"v":1936,"d":"Rp1,936.00"}},{"$f":"Pendapatan!G7","v":{"v":1831,"d":"Rp1,831.00"}}]
[null,"Total pengeluaran",{"$nulls":3},{"$f":"Pengeluaran!H7","v":{"v":1145,"d":"Rp1,145.00"}},{"$f":"Pengeluaran!I7","v":{"v":395,"d":"Rp395.00"}}]
[null,"Total laba (atau rugi)",{"$nulls":3},{"$f":"F7-F8","v":{"v":791,"d":"Rp791.00"}},{"$f":"G7-G8","v":{"v":1436,"d":"Rp1,436.00"}}]