{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Pengeluaran","Kategori"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Pengeluaran","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,"ANGGARAN PENGELUARAN",{"$nulls":4},{"$f":"TODAY()","v":{"v":44579,"d":"4457900.00%"}}]
[null,"Nama Perusahaan"]
[null,"Pengeluaran","Kategori","Anggaran","Aktual","Selisih ($)","Selisih (%)"]
[null,"Iklan","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Utang","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Keuntungan","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Persediaan","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Biaya kirim","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Sewa atau hipotek","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Pengeluaran penjualan","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Pajak","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Utilitas","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Lainnya","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Asuransi","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Bunga","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Telepon","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Pemeliharaan dan perbaikan","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Biaya hukum","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Penyusutan nilai","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Pengiriman","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Penyimpanan","Operasional",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Toko","Pribadi",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Penjual","Pribadi",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Lainnya","Pribadi",null,null,{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Anggaran]]-Pengeluaran[[#This Row],[Aktual]]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Selisih ($)]]/Pengeluaran[[#This Row],[Anggaran]]),\"\")","v":""}]
[null,"Total Pengeluaran",null,{"$f":"IFERROR(SUM(Pengeluaran[Anggaran]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[Aktual]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[Selisih ($)]), \"\")","v":0},{"$f":"IFERROR(SUM(Pengeluaran[[#Totals],[Selisih ($)]]/Pengeluaran[[#Totals],[Anggaran]]),\"\")","v":""}]

{"sheet":"Kategori","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"Pencarian Kategori"]
[null,"Kategori"]
[null,"Operasional"]
[null,"Pribadi"]