{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Laporan"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Laporan","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[0,1,0,7],[2,2,2,3],[3,2,3,3],[4,2,4,3],[6,1,6,7],[8,2,8,3],[8,6,8,7],[9,2,9,3],[9,6,9,7],[10,2,10,3],[10,6,10,7],[11,6,11,7],[12,1,12,2],[12,3,12,4],[12,6,12,7],[25,3,25,7],[26,3,26,7],[27,3,27,7]]}
[null,"Nama Perusahaan Anda"]
[]
[null,"Alamat:","Alamat",null,"Telepon:","Nomor telepon"]
[null,null,"Alamat 2",null,"Faks:","Nomor faks"]
[null,null,"Kota, Provinsi, Kode Pos",null,"Email:","Alamat email"]
[]
[null,"Laporan"]
[]
[null,"No. Laporan:","Nomor laporan",null,null,"Tagihan Kepada:","Nama"]
[null,"Tanggal:","Tanggal",{"$nulls":3},"Nama Perusahaan"]
[null,"ID Pelanggan:","ID Pelanggan",{"$nulls":3},"Alamat"]
[{"$nulls":6},"Alamat 2"]
[null,"Jumlah Remitansi Terlampir:",null,"Jumlah remitansi",null,null,"Kota, Provinsi, Kode Pos"]
[]
[null,"Tanggal","Tipe","Faktur #","Deskripsi","Jumlah","Pembayaran","Saldo"]
[{"$nulls":7},{"$f":"IFERROR(IF(F16>0,F16-G16,\"\"), \"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":6},"Total",{"$f":"SUBTOTAL(109,Faktur[Saldo])","v":0}]
[null,"Pengingat: Sertakan nomor laporan dalam cek Anda."]
[null,"Ketentuan: Saldo jatuh tempo dalam 30 hari."]
[]
[null,"REMITANSI"]
[null,"Nama Pelanggan:",null,{"$f":"Nama_Pelanggan","v":"Nama"}]
[null,"ID Pelanggan:",null,{"$f":"ID_Pelanggan","v":"ID Pelanggan"}]
[null,"No. Laporan:",null,{"$f":"Nomor_Laporan","v":"Nomor laporan"}]
[null,"Tanggal:",null,{"$f":"Tanggal_Laporan","v":"Tanggal"}]
[null,"Jumlah Terutang:",null,{"$f":"Total_Due","v":0}]
[null,"Jumlah Bayar:",null,{"$f":"Jumlah_remitansi","v":"Jumlah remitansi"}]