{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Ringkasan","Aset","Utang dan Modal Pemilik"],"not_rendered":{"charts":2,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Ringkasan","index":0,"n_rows":7,"n_cols":5,"rows_kept":7}
[{"$nulls":4}," "]
[null,null,{"$f":"\"Tahun \" & YEAR(TODAY())-1","v":"Tahun 2018"},{"$f":"\"Tahun \" & YEAR(TODAY())","v":"Tahun 2019"}]
[]
[null,"Rangkuman Saldo","Tahun 1","Tahun 2"]
[null,"Total Aset",{"$f":"Tabel_AsetLancar[[#Totals],[Tahun 1]]+Tabel_AsetTetap[[#Totals],[Tahun 1]]+Tabel_AsetLainnya[[#Totals],[Tahun 1]]","v":{"v":9545,"d":"Rp9,545.00"}},{"$f":"Tabel_AsetLancar[[#Totals],[Tahun 2]]+Tabel_AsetTetap[[#Totals],[Tahun 2]]+Tabel_AsetLainnya[[#Totals],[Tahun 2]]","v":{"v":12735,"d":"Rp12,735.00"}}]
[null,"Total Utang dan Ekuitas Pemilik",{"$f":"Tabel_UtangJangkaPendek[[#Totals],[Tahun 1]]+Tabel_UtangJangkaPanjang[[#Totals],[Tahun 1]]+Tabel_ModalPemilik[[#Totals],[Tahun 1]]","v":{"v":8540,"d":"Rp8,540.00"}},{"$f":"Tabel_UtangJangkaPendek[[#Totals],[Tahun 2]]+Tabel_UtangJangkaPanjang[[#Totals],[Tahun 2]]+Tabel_ModalPemilik[[#Totals],[Tahun 2]]","v":{"v":6227,"d":"Rp6,227.00"}}]
[null,"Saldo",{"$f":"C5-C6","v":{"v":1005,"d":"Rp1,005.00"}},{"$f":"D5-D6","v":{"v":6508,"d":"Rp6,508.00"}}]

{"sheet":"Aset","index":1,"n_rows":21,"n_cols":5,"rows_kept":21}
[{"$nulls":4}," "]
[null,null,{"$f":"Tahun_Sebelumnya","v":"Tahun 2018"},{"$f":"Tahun_Saat_Ini","v":"Tahun 2019"}]
[null,"Aset Saat Ini","Tahun 1","Tahun 2"]
[null,"Tunai",{"v":1000,"d":"Rp1,000.00"},{"v":1700,"d":"Rp1,700.00"}]
[null,"Investasi",{"v":1500,"d":"Rp1,500.00"},{"v":2550,"d":"Rp2,550.00"}]
[null,"Inventaris",{"v":650,"d":"Rp650.00"},{"v":1250,"d":"Rp1,250.00"}]
[null,"Piutang dagang",{"v":150,"d":"Rp150.00"},{"v":230,"d":"Rp230.00"}]
[null,"Pengeluaran yang dibayar di muka",{"v":1230,"d":"Rp1,230.00"},{"v":950,"d":"Rp950.00"}]
[null,"Lainnya",{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"}]
[null,"Total Aset Saat Ini",{"$f":"SUBTOTAL(109,Tabel_AsetLancar[Tahun 1])","v":{"v":4650,"d":"Rp4,650.00"}},{"$f":"SUBTOTAL(109,Tabel_AsetLancar[Tahun 2])","v":{"v":6800,"d":"Rp6,800.00"}}]
[]
[null,"Aset Tetap","Tahun 1","Tahun 2"]
[null,"Properti dan perlengkapan",{"v":2500,"d":"Rp2,500.00"},{"v":2500,"d":"Rp2,500.00"}]
[null,"Penyempurnaan penyewaan",{"v":450,"d":"Rp450.00"},{"v":350,"d":"Rp350.00"}]
[null,"Ekuitas dan investasi lain",{"v":1250,"d":"Rp1,250.00"},{"v":1600,"d":"Rp1,600.00"}]
[null,"Depresiasi yang kurang terakumulasi",{"v":545,"d":"Rp545.00"},{"v":1295,"d":"Rp1,295.00"}]
[null,"Total Aset Tetap",{"$f":"SUBTOTAL(109,Tabel_AsetTetap[Tahun 1])","v":{"v":4745,"d":"Rp4,745.00"}},{"$f":"SUBTOTAL(109,Tabel_AsetTetap[Tahun 2])","v":{"v":5745,"d":"Rp5,745.00"}}]
[]
[null,"Aset Lainnya","Tahun 1","Tahun 2"]
[null,"Goodwill",{"v":150,"d":"Rp150.00"},{"v":190,"d":"Rp190.00"}]
[null,"Total Aset Lainnya",{"$f":"SUBTOTAL(109,Tabel_AsetLainnya[Tahun 1])","v":{"v":150,"d":"Rp150.00"}},{"$f":"SUBTOTAL(109,Tabel_AsetLainnya[Tahun 2])","v":{"v":190,"d":"Rp190.00"}}]

{"sheet":"Utang dan Modal Pemilik","index":2,"n_rows":19,"n_cols":5,"rows_kept":19}
[{"$nulls":4}," "]
[null,null,{"$f":"Tahun_Sebelumnya","v":"Tahun 2018"},{"$f":"Tahun_Saat_Ini","v":"Tahun 2019"}]
[null,"Utang Saat Ini","Tahun 1","Tahun 2"]
[null,"Utang dagang",{"v":180,"d":"Rp180.00"},{"v":252,"d":"Rp252.00"}]
[null,"Gaji aktual",{"v":250,"d":"Rp250.00"},{"v":370,"d":"Rp370.00"}]
[null,"Kompensasi aktual",{"v":240,"d":"Rp240.00"},{"v":190,"d":"Rp190.00"}]
[null,"Utang pajak penghasilan",{"v":120,"d":"Rp120.00"},{"v":130,"d":"Rp130.00"}]
[null,"Pendapatan yang diterima di muka",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"}]
[null,"Lainnya",{"v":250,"d":"Rp250.00"},{"v":235,"d":"Rp235.00"}]
[null,"Total Utang Saat Ini",{"$f":"SUBTOTAL(109,Tabel_UtangJangkaPendek[Tahun 1])","v":{"v":1040,"d":"Rp1,040.00"}},{"$f":"SUBTOTAL(109,Tabel_UtangJangkaPendek[Tahun 2])","v":{"v":1177,"d":"Rp1,177.00"}}]
[]
[null,"Utang Jangka Panjang","Tahun 1","Tahun 2"]
[null,"Utang hipotek",{"v":1500,"d":"Rp1,500.00"},{"v":1900,"d":"Rp1,900.00"}]
[null,"Total Utang Jangka Panjang",{"$f":"SUBTOTAL(109,Tabel_UtangJangkaPanjang[Tahun 1])","v":{"v":1500,"d":"Rp1,500.00"}},{"$f":"SUBTOTAL(109,Tabel_UtangJangkaPanjang[Tahun 2])","v":{"v":1900,"d":"Rp1,900.00"}}]
[]
[null,"Ekuitas Pemilik","Tahun 1","Tahun 2"]
[null,"Modal investasi",{"v":5500,"d":"Rp5,500.00"},{"v":2500,"d":"Rp2,500.00"}]
[null,"Laba ditahan",{"v":500,"d":"Rp500.00"},{"v":650,"d":"Rp650.00"}]
[null,"Total Ekuitas Pemilik",{"$f":"SUBTOTAL(109,Tabel_ModalPemilik[Tahun 1])","v":{"v":6000,"d":"Rp6,000.00"}},{"$f":"SUBTOTAL(109,Tabel_ModalPemilik[Tahun 2])","v":{"v":3150,"d":"Rp3,150.00"}}]