{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Faktur Tagihan","Pengaturan Perusahaan"],"not_rendered":{"images":1,"defined_names":27},"read":"whole","date_system":"1900"}

{"sheet":"Faktur Tagihan","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"merged":[[1,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3]]}
[null,"FAKTUR","0005"]
[null,{"$f":"TODAY()","v":"2022-04-01"},null,{"$f":"TotalFaktur","v":79.65},null," ","Pengaturan Perusahaan"]
[null,"PEMBAYARAN JATUH TEMPO PADA:",{"$f":"TODAY()+15","v":"2022-04-16"},null,null," "]
[null,"KIRANA ARIANI",null,"ADVENTURE WORKS"]
[null,"Fabrikam, Inc.",null,"Jln. Kenanga 234"]
[null,"Jln. Sisingamangaraja 123",null,"Semarang, Jawa Tengah 09876"]
[null,"Bandung, Jawa Barat 12345"]
[null,"KUANTITAS","DETAIL","HARGA SATUAN","TOTAL"]
[null,2,"Widget",14.95,{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":{"v":29.9,"d":"29.90"}}]
[null,5,"Ring pelat",9.95,{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":49.75}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(DetailFaktur[[#This Row],[HARGA SATUAN]]*DetailFaktur[[#This Row],[KUANTITAS]],\"\")","v":0}]
[null,"Diskon"]
[null,"Total Bersih",null,null,{"$f":"SUM(DetailFaktur[TOTAL])-E24","v":{"v":79.65,"d":"Rp79.65"}}]
[null,"Pajak"]
[null,{"$f":"REPT(PengaturanPerusahaan_SingkatanMataUangAnda,LEN(PengaturanPerusahaan_SingkatanMataUangAnda)>0) & \" TOTAL\"","v":"IDR TOTAL"},null,null,{"$f":"IFERROR(E25+E26, \"\")","v":{"v":79.65,"d":"Rp79.65"}}]
[null,"DETAIL PEMBAYARAN",null,null,"INFORMASI LAIN"]
[null,"Nama Penerima Dana:",{"$f":" PengaturanPerusahaan_NamaPenerimaBank","v":"Adventure Works"},null,{"$f":"IFERROR(PengaturanPerusahaan_NamaAnda,\"\")","v":"Ginanjar Angkasa"}]
[null,"Nama Bank:",{"$f":"PengaturanPerusahaan_NamaBank","v":"Woodgrove Bank"},null,{"$f":"IFERROR(\"Telepon: \" & PengaturanPerusahaan_TeleponAnda,\"\")","v":"Telepon: 425-555-0150"}]
[null,"Alamat Bank:",{"$f":"PengaturanPerusahaan_AlamatBank","v":"Jln. Damai 234, Semarang, Jawa Tengah 09876"},null,{"$f":"IFERROR(\"Faksimile: \" & PengaturanPerusahaan_FaksAnda,\"\")","v":"Faksimile: 425-555-0151"}]
[null,"Nomor Rekening:",{"$f":"PengaturanPerusahaan_RekeningBank","v":1234567},null,{"$f":"IFERROR(PengaturanPerusahaan_URLAnda,\"\")","v":"Adventure-Works.com"}]
[null,"Nomor Perutean (Kode SWIFT)",{"$f":"PengaturanPerusahaan_PeruteanBank","v":9876543210},null,{"$f":"IFERROR(PengaturanPerusahaan_EmailAnda,\"\")","v":"Accounting@Adventure-Works.com"}]
[null,"Referensi Pembayaran:",{"$f":"TampilanNomorFaktur","v":"0005"},null,{"$f":"IFERROR(IF(LEN(Client_PO),\"Kontrak/PO: \" & Client_PO,\"\"),\"\")","v":""}]
[null,{"$f":"UPPER(\"Pembayaran harus dilakukan melalui transfer bank atau cek yang dapat dibayarkan kepada \" & PengaturanPerusahaan_PenerimaPembayaran & \".\")","v":"PEMBAYARAN HARUS DILAKUKAN MELALUI TRANSFER BANK ATAU CEK YANG DAPAT DIBAYARKAN KEPADA ADVENTURE WORKS."}]

{"sheet":"Pengaturan Perusahaan","index":1,"n_rows":20,"n_cols":5,"rows_kept":20}
[null,"PENGATURAN PERUSAHAAN"]
[null,"DETAIL PERUSAHAAN PENERBIT FAKTUR","NILAI",null,"Faktur Tagihan"]
[null,"Nama","Ginanjar Angkasa"]
[null,"Nama Perusahaan","ADVENTURE WORKS"]
[null,"Baris Alamat 1","Jln. Kenanga 234"]
[null,"Baris Alamat 2","Semarang, Jawa Tengah 09876"]
[null,"Baris Alamat 3"]
[null,"Baris Alamat 4"]
[null,"Baris Alamat 5"]
[null,"Telepon","425-555-0150"]
[null,"Faksimile","425-555-0151"]
[null,"Situs web","Adventure-Works.com"]
[null,"Email","Accounting@Adventure-Works.com"]
[null,"Singkatan Mata Uang","IDR"]
[null,"Nama Penerima Dana untuk Transfer Bank","Adventure Works"]
[null,"Nama Bank","Woodgrove Bank"]
[null,"Alamat Bank","Jln. Damai 234, Semarang, Jawa Tengah 09876"]
[null,"Nomor Rekening",1234567]
[null,"Nomor Perutean (Kode SWIFT)",9876543210]
[null,"Cek Terutang Dibayarkan Kepada","Adventure Works"]