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

{"sheet":"LAPORAN TAGIHAN","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[1,2,1,3],[1,6,1,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7],[8,6,8,7],[9,6,9,7],[18,1,18,7],[19,1,19,7]]}
[null,"NAMA PERUSAHAAN"]
[null,"Alamat",{"$nulls":3},"Telepon:"]
[null,"Alamat 2",{"$nulls":3},"Faks:"]
[null,"Kota, Provinsi  Kode Pos",{"$nulls":3},"Email:"]
[null,"LAPORAN"]
[null,"No. Laporan:",null,null,"Kirim Tagihan Kepada:","Nama"]
[null,"Tanggal:",{"$nulls":3},"Nama Perusahaan"]
[null,"ID Pelanggan:",{"$nulls":3},"Alamat"]
[{"$nulls":5},"Alamat 2"]
[{"$nulls":5},"Kota, Provinsi  Kode Pos"]
[]
[null,"TANGGAL","TIPE","NO. FAKTUR","DESKRIPSI","JUMLAH","PEMBAYARAN","SALDO"]
[null,{"$f":"TODAY()","v":"2018-07-26"},"Penjualan",123,"Produk",{"v":200,"d":"Rp200.00"},{"v":100,"d":"Rp100.00"},{"$f":"IF(Data[[#This Row],[JUMLAH]]>0,Data[[#This Row],[JUMLAH]]-Data[[#This Row],[PEMBAYARAN]],\"\")","v":{"v":100,"d":"Rp100.00"}}]
[{"$nulls":7},{"$f":"IF(Data[[#This Row],[JUMLAH]]>0,Data[[#This Row],[JUMLAH]]-Data[[#This Row],[PEMBAYARAN]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Data[[#This Row],[JUMLAH]]>0,Data[[#This Row],[JUMLAH]]-Data[[#This Row],[PEMBAYARAN]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Data[[#This Row],[JUMLAH]]>0,Data[[#This Row],[JUMLAH]]-Data[[#This Row],[PEMBAYARAN]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Data[[#This Row],[JUMLAH]]>0,Data[[#This Row],[JUMLAH]]-Data[[#This Row],[PEMBAYARAN]],\"\")","v":""}]
[{"$nulls":6},"TOTAL",{"$f":"SUBTOTAL(109,Data[SALDO])","v":{"v":100,"d":"Rp100.00"}}]
[null,"Pengingat: Sertakan nomor laporan dalam cek Anda."]
[null,"Ketentuan: Saldo jatuh tempo dalam 30 hari."]
[null,"REMITANSI"]
[null,"Nama Pelanggan:"]
[null,"ID Pelanggan:"]
[null,"No. Laporan:"]
[null,"Tanggal:"]
[null,"Jumlah Terutang:",{"$f":"Data[[#Totals],[SALDO]]","v":{"v":100,"d":"Rp100.00"}}]
[null,"Jumlah Bayar:"]