{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Faktur Komersial","Pelanggan"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Faktur Komersial","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,1,3],[0,6,0,7],[1,6,1,7]]}
[null,"TAILSPIN TOYS",null,null,"Jl. Mahakam no. 123","T: 123-555-0123","tailspin@interestingsite.com",null,null,"Pelanggan"]
[{"$nulls":4},"Tanjung Priok,  JAKARTA 12345","F: 123-555-0124","www.tailspintoys.com"]
[]
[null,"Tagihan kepada:","Ulfa Azzahra","Telepon:",{"$f":"IFERROR(VLOOKUP(NamaTagihan,DaftarPelanggan[],8,FALSE),\"\")","v":"432-555-0178"},null,"No. Faktur:",34567]
[null,"Alamat:",{"$f":"IFERROR(VLOOKUP(NamaTagihan,DaftarPelanggan[],3,FALSE),\"\")","v":"Jl. Rinjani no. 345"},"Faks:",{"$f":"IFERROR(VLOOKUP(NamaTagihan,DaftarPelanggan[],10,FALSE),\"\")","v":"432-555-0187"},null,"Tanggal Faktur:",{"$f":"TODAY()","v":"2022-12-14"}]
[null,null,{"$f":"IF(VLOOKUP(NamaTagihan,DaftarPelanggan[],4,FALSE)<>\"\",VLOOKUP(NamaTagihan,DaftarPelanggan[],4,FALSE),IF(VLOOKUP(NamaTagihan,DaftarPelanggan[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(NamaTagihan,DaftarPelanggan[],5,FALSE),\", \",VLOOKUP(NamaTagihan,DaftarPelanggan[],6,FALSE),\" \",VLOOKUP(NamaTagihan,DaftarPelanggan[],7,FALSE)),CONCATENATE(VLOOKUP(NamaTagihan,DaftarPelanggan[],6,FALSE),\" \",VLOOKUP(NamaTagihan,DaftarPelanggan[],7,FALSE))))","v":"Jl. Kenanga no. 123"},"Email:",{"$f":"IFERROR(VLOOKUP(NamaTagihan,DaftarPelanggan[],9,FALSE),\"\")","v":"mario@excellentwebsite.com"},null,"Hubungi:",{"$f":"IFERROR(VLOOKUP(NamaTagihan,DaftarPelanggan[],2,FALSE),\"\")","v":"Mario Simatupang"}]
[null,null,{"$f":"IF(VLOOKUP(NamaTagihan,DaftarPelanggan[],4,FALSE)=\"\",\"\",IF(VLOOKUP(NamaTagihan,DaftarPelanggan[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(NamaTagihan,DaftarPelanggan[],5,FALSE),\", \",VLOOKUP(NamaTagihan,DaftarPelanggan[],6,FALSE),\" \",VLOOKUP(NamaTagihan,DaftarPelanggan[],7,FALSE)),CONCATENATE(VLOOKUP(NamaTagihan,DaftarPelanggan[],6,FALSE),\" \",VLOOKUP(NamaTagihan,DaftarPelanggan[],7,FALSE))))","v":"Jakarta, DKI Jakarta 12345"}]
[null,"TANGGAL","ITEM #","DESKRIPSI","JML","HARGA SATUAN","DISKON","TOTAL"]
[null,{"$f":"TODAY()","v":"2022-12-14"},789807,"Blok Kayu",4,{"v":10,"d":"Rp10.00"},{"v":2,"d":"Rp2.00"},{"$f":"IF(AND(ItemFaktur[[#This Row],[JML]]<>\"\",ItemFaktur[[#This Row],[HARGA SATUAN]]<>\"\"),(ItemFaktur[[#This Row],[JML]]*ItemFaktur[[#This Row],[HARGA SATUAN]])-ItemFaktur[[#This Row],[DISKON]],\"\")","v":{"v":38,"d":"Rp38.00"}}]
[{"$nulls":7},{"$f":"IF(AND(ItemFaktur[[#This Row],[JML]]<>\"\",ItemFaktur[[#This Row],[HARGA SATUAN]]<>\"\"),(ItemFaktur[[#This Row],[JML]]*ItemFaktur[[#This Row],[HARGA SATUAN]])-ItemFaktur[[#This Row],[DISKON]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(ItemFaktur[[#This Row],[JML]]<>\"\",ItemFaktur[[#This Row],[HARGA SATUAN]]<>\"\"),(ItemFaktur[[#This Row],[JML]]*ItemFaktur[[#This Row],[HARGA SATUAN]])-ItemFaktur[[#This Row],[DISKON]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(ItemFaktur[[#This Row],[JML]]<>\"\",ItemFaktur[[#This Row],[HARGA SATUAN]]<>\"\"),(ItemFaktur[[#This Row],[JML]]*ItemFaktur[[#This Row],[HARGA SATUAN]])-ItemFaktur[[#This Row],[DISKON]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(ItemFaktur[[#This Row],[JML]]<>\"\",ItemFaktur[[#This Row],[HARGA SATUAN]]<>\"\"),(ItemFaktur[[#This Row],[JML]]*ItemFaktur[[#This Row],[HARGA SATUAN]])-ItemFaktur[[#This Row],[DISKON]],\"\")","v":""}]
[{"$nulls":6},"Subtotal faktur",{"$f":"SUM(ItemFaktur[TOTAL])","v":{"v":38,"d":"Rp38.00"}}]
[{"$nulls":6},"Tarif pajak",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"Pajak penjualan",{"$f":"SubtotalFaktur*TarifPajakPenjualan","v":{"v":3.3819999999999997,"d":"Rp3.38"}}]
[{"$nulls":6},"Pengiriman",{"v":5,"d":"Rp5.00"}]
[null,{"$f":"\"Jadikan semua cek dibayarkan kepada \"&UPPER(NamaPerusahaan)&\".\"","v":"Jadikan semua cek dibayarkan kepada TAILSPIN TOYS."},{"$nulls":4},"Deposito diterima",{"v":0,"d":"Rp0.00"}]
[null,"Total tagihan yang harus dibayar dalam waktu 10 hari. Pembayaran setelah jatuh tempo akan dikenai biaya bunga sebesar 2% per bulan.",{"$nulls":4},"Total",{"$f":"SubtotalFaktur+PajakPenjualan+Pengiriman-Deposit","v":{"v":46.382,"d":"Rp46.38"}}]

{"sheet":"Pelanggan","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"PELANGGAN",{"$nulls":10},"Faktur Komersial"]
[null,"NAMA PERUSAHAAN","INFORMASI KONTAK","ALAMAT","ALAMAT2","KOTA","PROVINSI","KODE POS","TELEPON","EMAIL","FAKS"]
[null,"Ulfa Azzahra","Mario Simatupang","Jl. Rinjani no. 345","Jl. Kenanga no. 123","Jakarta","DKI Jakarta",12345,"432-555-0178","mario@excellentwebsite.com","432-555-0187"]
[null,"Contoso, Ltd","Arum Citraloka","Jl. Kerinci no. 567",null,"Bandung","Jawa Barat","09876","432-555-0189","contoso@websitegoeshere.com","432-555-0123"]