{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Pengeluaran","Pendapatan","Laporan Laba - Rugi"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Pengeluaran","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"Anggaran Acara untuk [Nama Acara] ",{"$nulls":5},"PENGELUARAN"]
[]
[null,"TOTAL PENGELUARAN",{"$nulls":4},"Estimasi","Aktual"]
[{"$nulls":6},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":882,"d":"Rp882.00"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":333,"d":"Rp333.00"}}]
[]
[null,"Lokasi","Estimasi","Aktual",null,"Makanan Ringan","Estimasi","Aktual"]
[null,"Biaya ruangan dan aula",{"v":500,"d":"Rp500.00"},null,null,"Makanan"]
[null,"Staf lokasi",{"$nulls":3},"Minuman",{"v":20,"d":"Rp20.00"}]
[null,"Peralatan",{"$nulls":3},"Taplak",null,{"v":20,"d":"Rp20.00"}]
[null,"Meja dan kursi",{"$nulls":3},"Staf dan tip"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel1[Estimasi])","v":{"v":500,"d":"Rp500.00"}},{"$f":"SUBTOTAL(109,Tabel1[Aktual])","v":{"v":0,"d":"Rp0.00"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel3[Estimasi])","v":{"v":20,"d":"Rp20.00"}},{"$f":"SUBTOTAL(109,Tabel3[Aktual])","v":{"v":20,"d":"Rp20.00"}}]
[]
[null,"Dekorasi","Estimasi","Aktual",null,"Program","Estimasi","Aktual"]
[null,"Bunga",{"v":200,"d":"Rp200.00"},{"v":300,"d":"Rp300.00"},null,"Hiburan"]
[null,"Lilin",{"$nulls":3},"Pembicara",{"v":30,"d":"Rp30.00"}]
[null,"Lampu",{"$nulls":3},"Perjalanan"]
[null,"Balon",{"$nulls":3},"Hotel"]
[null,"Perlengkapan kertas",{"$nulls":3},"Lainnya"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel4[Estimasi])","v":{"v":200,"d":"Rp200.00"}},{"$f":"SUBTOTAL(109,Tabel4[Aktual])","v":{"v":300,"d":"Rp300.00"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel5[Estimasi])","v":{"v":30,"d":"Rp30.00"}},{"$f":"SUBTOTAL(109,Tabel5[Aktual])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Publikasi","Estimasi","Aktual",null,"Hadiah","Estimasi","Aktual"]
[null,"Karya grafis",{"$nulls":3},"Pita/Plakat/Piala"]
[null,"Fotokopi/Percetakan",{"v":20,"d":"Rp20.00"},null,null,"Hadiah",{"v":100,"d":"Rp100.00"}]
[null,"Ongkos kirim",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,Tabel7[Estimasi])","v":{"v":100,"d":"Rp100.00"}},{"$f":"SUBTOTAL(109,Tabel7[Aktual])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel6[Estimasi])","v":{"v":20,"d":"Rp20.00"}},{"$f":"SUBTOTAL(109,Tabel6[Aktual])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Lain-lain","Estimasi","Aktual"]
[null,"Telepon",null,{"v":13,"d":"Rp13.00"}]
[null,"Transportasi",{"v":12,"d":"Rp12.00"}]
[null,"Perlengkapan alat tulis"]
[null,"Layanan faks"]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel8[Estimasi])","v":{"v":12,"d":"Rp12.00"}},{"$f":"SUBTOTAL(109,Tabel8[Aktual])","v":{"v":13,"d":"Rp13.00"}}]

{"sheet":"Pendapatan","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"Anggaran Acara untuk [Nama Acara] ",{"$nulls":4},"PENDAPATAN"]
[]
[null,"TOTAL PENDAPATAN",{"$nulls":3},"Estimasi","Aktual"]
[{"$nulls":5},{"$f":"SUM(F11, F18, F25, F33)","v":{"v":1936,"d":"Rp1,936.00"}},{"$f":"SUM(G11,G18,G25, G33)","v":{"v":1831,"d":"Rp1,831.00"}}]
[]
[null,"TIKET MASUK"]
[null,"Jumlah Estimasi","Jumlah Aktual","Tipe","Harga","Estimasi Pendapatan","Pendapatan Aktual"]
[null,300,278,"Dewasa @",{"v":5,"d":"Rp5.00"},{"$f":"B8*E8","v":{"v":1500,"d":"Rp1,500.00"}},{"$f":"C8*E8","v":{"v":1390,"d":"Rp1,390.00"}}]
[null,197,195,"Anak-anak @",{"v":2,"d":"Rp2.00"},{"$f":"B9*E9","v":{"v":394,"d":"Rp394.00"}},{"$f":"C9*E9","v":{"v":390,"d":"Rp390.00"}}]
[null,42,51,"Lainnya @",{"v":1,"d":"Rp1.00"},{"$f":"B10*E10","v":{"v":42,"d":"Rp42.00"}},{"$f":"C10*E10","v":{"v":51,"d":"Rp51.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel9[Estimasi Pendapatan])","v":{"v":1936,"d":"Rp1,936.00"}},{"$f":"SUBTOTAL(109,Tabel9[Pendapatan Aktual])","v":{"v":1831,"d":"Rp1,831.00"}}]
[]
[null,"IKLAN DALAM PROGRAM"]
[null,"Jumlah Estimasi","Jumlah Aktual","Tipe","Harga","Estimasi Pendapatan","Pendapatan Aktual"]
[null,12,null,"Sampul @",null,{"$f":"B15*E15","v":{"v":0,"d":"Rp0.00"}},{"$f":"C15*E15","v":{"v":0,"d":"Rp0.00"}}]
[null,null,158,"Setengah halaman @",null,{"$f":"B16*E16","v":{"v":0,"d":"Rp0.00"}},{"$f":"C16*E16","v":{"v":0,"d":"Rp0.00"}}]
[null,4,null,"Seperempat halaman @",null,{"$f":"B17*E17","v":{"v":0,"d":"Rp0.00"}},{"$f":"C17*E17","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel10[Estimasi Pendapatan])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel10[Pendapatan Aktual])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"PESERTA PAMERAN/VENDOR"]
[null,"Jumlah Estimasi","Jumlah Aktual","Tipe","Harga","Estimasi Pendapatan","Pendapatan Aktual"]
[null,23,null,"Stan besar @",null,{"$f":"B22*E22","v":{"v":0,"d":"Rp0.00"}},{"$f":"C22*E22","v":{"v":0,"d":"Rp0.00"}}]
[null,354,null,"Stan sedang @",null,{"$f":"B23*E23","v":{"v":0,"d":"Rp0.00"}},{"$f":"C23*E23","v":{"v":0,"d":"Rp0.00"}}]
[null,56,null,"Stan kecil @",null,{"$f":"B24*E24","v":{"v":0,"d":"Rp0.00"}},{"$f":"C24*E24","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel11[Estimasi Pendapatan])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel11[Pendapatan Aktual])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"PENJUALAN ITEM"]
[null,"Jumlah Estimasi","Jumlah Aktual","Tipe","Harga","Estimasi Pendapatan","Pendapatan Aktual"]
[{"$nulls":3},"Item @",null,{"$f":"B29*E29","v":{"v":0,"d":"Rp0.00"}},{"$f":"C29*E29","v":{"v":0,"d":"Rp0.00"}}]
[null,123,null,"Item @",null,{"$f":"B30*E30","v":{"v":0,"d":"Rp0.00"}},{"$f":"C30*E30","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":3},"Item @",null,{"$f":"B31*E31","v":{"v":0,"d":"Rp0.00"}},{"$f":"C31*E31","v":{"v":0,"d":"Rp0.00"}}]
[null,13,null,"Item @",null,{"$f":"B32*E32","v":{"v":0,"d":"Rp0.00"}},{"$f":"C32*E32","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel12[Estimasi Pendapatan])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,Tabel12[Pendapatan Aktual])","v":{"v":0,"d":"Rp0.00"}}]

{"sheet":"Laporan Laba - Rugi","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,3]]}
[null,"Anggaran Acara untuk [Nama Acara] ",{"$nulls":4},"LABA "]
[{"$nulls":6},"Ringkasan Rugi"]
[]
[]
[null,null,"Estimasi","Aktual"]
[null,"Total pendapatan",{"$f":"Pendapatan!F4","v":{"v":1936,"d":"Rp1,936.00"}},{"$f":"Pendapatan!G4","v":{"v":1831,"d":"Rp1,831.00"}}]
[null,"Total pengeluaran",{"$f":"Pengeluaran!G4","v":{"v":882,"d":"Rp882.00"}},{"$f":"Pengeluaran!H4","v":{"v":333,"d":"Rp333.00"}}]
[]
[null,"Total laba              (atau rugi)",{"$f":"C6-C7","v":{"v":1054,"d":"Rp1,054.00"}},{"$f":"D6-D7","v":{"v":1498,"d":"Rp1,498.00"}}]