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

{"sheet":"Anggaran Pengeluaran","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[0,1,0,4],[0,5,0,6],[16,1,16,6],[47,1,47,6]]}
[null,"Anggaran Pengeluaran",{"$nulls":3},"CONTOSO, 2013"]
[]
[]
[null," ANGGARAN PERSONIL"]
{"$rows_empty":7}
[null,"STATUS","PERSONIL","ANGGARAN","AKTUAL","SELISIH ($)","SELISIH (%)"]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[AKTUAL]]/tblPersonnelExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":1.13,"d":"$1.13"}},"Kantor",{"v":500,"d":"Rp500.00"},{"v":565,"d":"Rp565.00"},{"$f":"tblPersonnelExpenses[[#This Row],[ANGGARAN]]-tblPersonnelExpenses[[#This Row],[AKTUAL]]","v":{"v":-65,"d":"-Rp65.00"}},{"$f":"IFERROR(tblPersonnelExpenses[SELISIH ($)]/tblPersonnelExpenses[ANGGARAN],\"\")","v":{"v":-0.13,"d":"-13%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[AKTUAL]]/tblPersonnelExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Toko",{"v":125,"d":"Rp125.00"},{"v":150,"d":"Rp150.00"},{"$f":"tblPersonnelExpenses[[#This Row],[ANGGARAN]]-tblPersonnelExpenses[[#This Row],[AKTUAL]]","v":{"v":-25,"d":"-Rp25.00"}},{"$f":"IFERROR(tblPersonnelExpenses[SELISIH ($)]/tblPersonnelExpenses[ANGGARAN],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[AKTUAL]]/tblPersonnelExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":1,"d":"$1.00"}},"Tenaga Penjualan",{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"$f":"tblPersonnelExpenses[[#This Row],[ANGGARAN]]-tblPersonnelExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblPersonnelExpenses[SELISIH ($)]/tblPersonnelExpenses[ANGGARAN],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[AKTUAL]]/tblPersonnelExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Lainnya",{"v":100,"d":"Rp100.00"},{"v":90,"d":"Rp90.00"},{"$f":"tblPersonnelExpenses[[#This Row],[ANGGARAN]]-tblPersonnelExpenses[[#This Row],[AKTUAL]]","v":{"v":10,"d":"Rp10.00"}},{"$f":"IFERROR(tblPersonnelExpenses[SELISIH ($)]/tblPersonnelExpenses[ANGGARAN],\"\")","v":{"v":0.1,"d":"10%"}}]
[]
[]
[null,"ANGGARAN OPERASIONAL"]
{"$rows_empty":7}
[null,"STATUS","OPERASI","ANGGARAN","AKTUAL","SELISIH ($)","SELISIH (%)"]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":0.98,"d":"$0.98"}},"Iklan",{"v":250,"d":"Rp250.00"},{"v":245,"d":"Rp245.00"},{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":5,"d":"Rp5.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":0.02,"d":"2%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Utang",{"v":125,"d":"Rp125.00"},{"v":150,"d":"Rp150.00"},{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":-25,"d":"-Rp25.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":1,"d":"$1.00"}},"Manfaat",{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Persediaan",{"v":100,"d":"Rp100.00"},{"v":90,"d":"Rp90.00"},{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":10,"d":"Rp10.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":{"v":0.1,"d":"10%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Ongkos kirim",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Sewa atau hipotek",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Pengeluaran penjualan",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Pajak",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Kebutuhan umum",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Lainnya",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Asuransi",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Bunga",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Telepon",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Pemeliharaan dan perbaikan",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Biaya hukum",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Penyusutan",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Pengiriman",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Penyimpanan",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[AKTUAL]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""},"Lainnya",null,null,{"$f":"tblOperatingExpenses[[#This Row],[ANGGARAN]]-tblOperatingExpenses[[#This Row],[AKTUAL]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[SELISIH ($)]]/tblOperatingExpenses[[#This Row],[ANGGARAN]],\"\")","v":""}]
[null,null,"Total Pengeluaran",{"$f":"SUBTOTAL(109,tblOperatingExpenses[ANGGARAN],tblPersonnelExpenses[ANGGARAN])","v":{"v":1400,"d":"Rp1,400.00"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[AKTUAL],tblPersonnelExpenses[AKTUAL])","v":{"v":1490,"d":"Rp1,490.00"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[SELISIH ($)],tblPersonnelExpenses[SELISIH ($)])","v":{"v":-90,"d":"-Rp90.00"}},{"$f":"IFERROR(SUM(tblOperatingExpenses[[#Totals],[SELISIH ($)]]/tblOperatingExpenses[[#Totals],[ANGGARAN]]),\"\")","v":{"v":-0.06428571428571428,"d":"-6%"}}]