{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["RINGKASAN ANGGARAN","DETAIL PENGELUARAN","DataBagan"],"not_rendered":{"charts":1,"images":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"RINGKASAN ANGGARAN","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3]]}
[{"$nulls":3},"Detail Pengeluaran"]
[null,"ANGGARAN","PEMBANGUNAN \nRUMAH"]
[null,"INFORMASI PROYEK"]
[null,"Nama Proyek","Perombakan Dapur"]
[null,"Deskripsi Proyek","Mengangkat lantai lama, mengganti dengan ubin baru.  Menyelesaikan dan merapikan semua lantai baru.  Mengganti lemari dengan gaya yang lebih modern.  Menyelesaikan dan merapikan semua lemari."]
[null,"Kontraktor","Alpine Ski House"]
[null,"Nomor Lisensi/Ikatan","C#12345678"]
[null,"Nama Kontak","Miko Maulana"]
[null,"Situs web","http://www.alpineskihouse.com/"]
[null,"Telepon",6035550198]
[null,"Alamat","Jalan Besi no. 789, Bandung, Jawa Barat 40111"]
[null,"STATUS KEUANGAN"]
[null,"Jumlah Kas",{"v":3500,"d":"Rp3,500"}]
[null,"Jumlah yang Dibiayai",{"v":0,"d":"Rp0"}]
[null,"Total Dana yang Dialokasikan",{"$f":"SUM(C13:C14)","v":{"v":3500,"d":"Rp3,500"}}]
[null,"Dana Digunakan Sampai Sekarang",{"$f":"SUM(Data[Jumlah])","v":{"v":2810,"d":"Rp2,810"}}]
[null,"Dana Tersisa",{"$f":"C15-C16","v":{"v":690,"d":"Rp690"}}]

{"sheet":"DETAIL PENGELUARAN","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"merged":[[1,3,1,4]]}
[{"$nulls":4},"Ringkasan Anggaran"]
[null,"DAFTAR","JUMLAH \nPENGELUARAN"]
[null,"ALOKSAI DANA PROYEK","DANA DIGUNAKAN SAMPAI SEKARANG","DANA TERSISA"]
[null,{"$f":"DanaDialokasikan","v":{"v":3500,"d":"Rp3,500.00"}},{"$f":"SUM(Data[Jumlah])","v":{"v":2810,"d":"Rp2,810.00"}},{"$f":"DanaTersisa","v":{"v":690,"d":"Rp690.00"}}]
[null,"Item","Kategori","Jumlah"]
[null,"Lantai ubin","Material",{"v":350,"d":"Rp350.00"}]
[null,"Lem lantai","Material",{"v":75,"d":"Rp75.00"}]
[null,"Lantai","Material",{"v":400,"d":"Rp400.00"}]
[null,"Dempul lantai","Material",{"v":20,"d":"Rp20.00"}]
[null,"Trim lantai","Material",{"v":40,"d":"Rp40.00"}]
[null,"Lemari baru","Material",{"v":250,"d":"Rp250.00"}]
[null,"Pelapisan lemari","Material",{"v":200,"d":"Rp200.00"}]
[null,"Perlengkapan lemari","Material",{"v":100,"d":"Rp100.00"}]
[null,"Mencopot ubin lantai","Tenaga Kerja",{"v":150,"d":"Rp150.00"}]
[null,"Memasang lem lantai","Tenaga Kerja",{"v":50,"d":"Rp50.00"}]
[null,"Ampelas lantai","Tenaga Kerja",{"v":50,"d":"Rp50.00"}]
[null,"Mempersiapkan lantai","Tenaga Kerja",{"v":100,"d":"Rp100.00"}]
[null,"Memasang lantai","Tenaga Kerja",{"v":200,"d":"Rp200.00"}]
[null,"Mendempul lantai","Tenaga Kerja",{"v":25,"d":"Rp25.00"}]
[null,"Merapikan lantai","Tenaga Kerja",{"v":50,"d":"Rp50.00"}]
[null,"Mencopot lemari lama","Tenaga Kerja",{"v":150,"d":"Rp150.00"}]
[null,"Mempersiapkan area lemari","Tenaga Kerja",{"v":50,"d":"Rp50.00"}]
[null,"Memasang lemari baru","Tenaga Kerja",{"v":300,"d":"Rp300.00"}]
[null,"Mendempul lemari","Tenaga Kerja",{"v":100,"d":"Rp100.00"}]
[null,"Melapisi lemari","Tenaga Kerja",{"v":100,"d":"Rp100.00"}]
[null,"Memasang perlengkapan lemari","Tenaga Kerja",{"v":50,"d":"Rp50.00"}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Data[Jumlah])","v":{"v":2810,"d":"Rp2,810.00"}}]

{"sheet":"DataBagan","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"hidden":true}
["Lembar ini harus tetap tersembunyi."]
["Label Bagan"]
[{"$f":"LabelDanaDigunakan&\": \"&TEXT(DanaDigunakan,\"Rp#.##0,00\")&\" (\"&TEXT(DanaDigunakan/SUM(DanaDigunakan:DanaTersisa),\"0%\")&\")\"","v":"Dana Digunakan Sampai Sekarang: Rp2810.000 (80%)"}]
[{"$f":"LabelDanaTersisa&\": \"&TEXT(DanaTersisa,\"Rp#.##0,00\")&\" (\"&TEXT(DanaTersisa/SUM(DanaDigunakan:DanaTersisa),\"0%\")&\")\"","v":"Dana Tersisa: Rp690.000 (20%)"}]