{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Ringkasan","Aset","Kewajiban","Kategori"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Ringkasan","index":0,"n_rows":12,"n_cols":4,"rows_kept":12}
[null,"Lembar Saldo"]
[null,null,{"$f":"\"FY-\"&YEAR(TODAY())-1","v":"FY-2016"},{"$f":"\"FY-\"&YEAR(TODAY())","v":"FY-2017"}]
[null,"Tipe Aset","Tahun Sebelumnya","Tahun Saat Ini"]
[null,"Aset Saat Ini",{"$f":"SUMIFS(Aset[Tahun Sebelumnya],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Sebelumnya],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":600,"d":"600 "}},{"$f":"SUMIFS(Aset[Tahun Saat Ini],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Saat Ini],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":600,"d":"600 "}}]
[null,"Aset Tetap",{"$f":"SUMIFS(Aset[Tahun Sebelumnya],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Sebelumnya],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":-100,"d":"(100)"}},{"$f":"SUMIFS(Aset[Tahun Saat Ini],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Saat Ini],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":-85,"d":"(85)"}}]
[null,"Aset Lain",{"$f":"SUMIFS(Aset[Tahun Sebelumnya],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Sebelumnya],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Aset[Tahun Saat Ini],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Saat Ini],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":0,"d":"0 "}}]
[null,"Kewajiban Saat Ini",{"$f":"SUMIFS(Aset[Tahun Sebelumnya],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Sebelumnya],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":500,"d":"500 "}},{"$f":"SUMIFS(Aset[Tahun Saat Ini],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Saat Ini],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":350,"d":"350 "}}]
[null,"Kewajiban Jangka Panjang",{"$f":"SUMIFS(Aset[Tahun Sebelumnya],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Sebelumnya],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Aset[Tahun Saat Ini],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Saat Ini],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":0,"d":"0 "}}]
[null,"Ekuitas Pemilik",{"$f":"SUMIFS(Aset[Tahun Sebelumnya],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Sebelumnya],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Aset[Tahun Saat Ini],Aset[Tipe Aset],Dasbor[[#This Row],[Tipe Aset]])+SUMIFS(Kewajiban[Tahun Saat Ini],Kewajiban[Tipe Kewajiban],Dasbor[[#This Row],[Tipe Aset]])","v":{"v":350,"d":"350 "}}]
[null,"Total Aset",{"$f":"Aset[[#Totals],[Tahun Sebelumnya]]","v":{"v":500,"d":"500 "}},{"$f":"Aset[[#Totals],[Tahun Saat Ini]]","v":{"v":515,"d":"515 "}}]
[null,"Jumlah Ekuitas Pemegang Saham & Kewajiban",{"$f":"Kewajiban[[#Totals],[Tahun Sebelumnya]]","v":{"v":500,"d":"500 "}},{"$f":"Kewajiban[[#Totals],[Tahun Saat Ini]]","v":{"v":700,"d":"700 "}}]
[null,"Saldo",{"$f":"C10-C11","v":{"v":0,"d":"0 "}},{"$f":"D10-D11","v":{"v":-185,"d":"(185)"}}]

{"sheet":"Aset","index":1,"n_rows":14,"n_cols":5,"rows_kept":14}
[null,"Aset"]
[{"$nulls":3},{"$f":"TAHUN_FISKAL","v":"FY-2016"},{"$f":"TAHUN_FISKAL_2","v":"FY-2017"}]
[null,"Tipe Aset","Deskripsi","Tahun Sebelumnya","Tahun Saat Ini"]
[null,"Aset Saat Ini","Kas",{"v":600,"d":"600 "},{"v":600,"d":"600 "}]
[null,"Aset Saat Ini","Investasi"]
[null,"Aset Saat Ini","Inventaris"]
[null,"Aset Saat Ini","Piutang dagang"]
[null,"Aset Saat Ini","Pengeluaran prabayar"]
[null,"Aset Tetap","Properti dan perlengkapan"]
[null,"Aset Tetap","Penyempurnaan penyewaan"]
[null,"Aset Tetap","Ekuitas dan investasi lain"]
[null,"Aset Tetap","Depresiasi yang kurang terakumulasi (Nilai Negatif)",{"v":-100,"d":"(100)"},{"v":-85,"d":"(85)"}]
[null,"Aset Lain","Amal"]
[null,"Total Aset",null,{"$f":"SUBTOTAL(109,Aset[Tahun Sebelumnya])","v":{"v":500,"d":"500 "}},{"$f":"SUBTOTAL(109,Aset[Tahun Saat Ini])","v":{"v":515,"d":"515 "}}]

{"sheet":"Kewajiban","index":2,"n_rows":12,"n_cols":5,"rows_kept":12}
[null,"Kewajiban"]
[{"$nulls":3},{"$f":"TAHUN_FISKAL","v":"FY-2016"},{"$f":"TAHUN_FISKAL_2","v":"FY-2017"}]
[null,"Tipe Kewajiban","Deskripsi","Tahun Sebelumnya","Tahun Saat Ini"]
[null,"Kewajiban Saat Ini","Utang dagang",null,{"v":350,"d":"350 "}]
[null,"Kewajiban Saat Ini","Gaji aktual"]
[null,"Kewajiban Saat Ini","Kompensasi aktual",{"v":500,"d":"500 "}]
[null,"Kewajiban Saat Ini","Utang pajak penghasilan"]
[null,"Kewajiban Saat Ini","Pendapatan yang belum diterima"]
[null,"Kewajiban Jangka Panjang","Utang hipotek"]
[null,"Ekuitas Pemilik","Modal investasi",null,{"v":350,"d":"350 "}]
[null,"Ekuitas Pemilik","Laba saldo terakumulasi"]
[null,"Jumlah Ekuitas Pemegang Saham & Kewajiban",null,{"$f":"SUBTOTAL(109,Kewajiban[Tahun Sebelumnya])","v":{"v":500,"d":"500 "}},{"$f":"SUBTOTAL(109,Kewajiban[Tahun Saat Ini])","v":{"v":700,"d":"700 "}}]

{"sheet":"Kategori","index":3,"n_rows":9,"n_cols":2,"rows_kept":9}
[null,"Kategori"]
[]
[null,"Kategori"]
[null,"Aset Saat Ini"]
[null,"Aset Tetap"]
[null,"Aset Lain"]
[null,"Kewajiban Saat Ini"]
[null,"Kewajiban Jangka Panjang"]
[null,"Ekuitas Pemilik"]