{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["商業請求書","顧客"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"商業請求書","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,"123 Main Street","電話:123-555-0123","tailspin@interestingsite.com",null,null,"顧客"]
[{"$nulls":4},"Ocean View,  MO 12345","FAX:123-555-0124","www.tailspintoys.com"]
[]
[null,"請求先:","Lilli Allik","電話:",{"$f":"IFERROR(VLOOKUP(BillName,顧客リスト[],8,FALSE),\"\")","v":"432-555-0178"},null,"請求書番号:",34567]
[null,"住所:",{"$f":"IFERROR(VLOOKUP(BillName,顧客リスト[],3,FALSE),\"\")","v":"345 Cherry Street"},"FAX:",{"$f":"IFERROR(VLOOKUP(BillName,顧客リスト[],10,FALSE),\"\")","v":"432-555-0187"},null,"請求日:",{"$f":"TODAY()","v":"2022-12-12"}]
[null,null,{"$f":"IF(VLOOKUP(BillName,顧客リスト[],4,FALSE)<>\"\",VLOOKUP(BillName,顧客リスト[],4,FALSE),IF(VLOOKUP(BillName,顧客リスト[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(BillName,顧客リスト[],5,FALSE),\", \",VLOOKUP(BillName,顧客リスト[],6,FALSE),\" \",VLOOKUP(BillName,顧客リスト[],7,FALSE)),CONCATENATE(VLOOKUP(BillName,顧客リスト[],6,FALSE),\" \",VLOOKUP(BillName,顧客リスト[],7,FALSE))))","v":"Suite 123"},"メール アドレス:",{"$f":"IFERROR(VLOOKUP(BillName,顧客リスト[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"連絡先:",{"$f":"IFERROR(VLOOKUP(BillName,顧客リスト[],2,FALSE),\"\")","v":"Mike Gragg"}]
[null,null,{"$f":"IF(VLOOKUP(BillName,顧客リスト[],4,FALSE)=\"\",\"\",IF(VLOOKUP(BillName,顧客リスト[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(BillName,顧客リスト[],5,FALSE),\", \",VLOOKUP(BillName,顧客リスト[],6,FALSE),\" \",VLOOKUP(BillName,顧客リスト[],7,FALSE)),CONCATENATE(VLOOKUP(BillName,顧客リスト[],6,FALSE),\" \",VLOOKUP(BillName,顧客リスト[],7,FALSE))))","v":"Albany, SD 12345"}]
[null,"日付","品目番号","説明","数量","単価","割引額","合計"]
[null,{"$f":"TODAY()","v":"2022-12-12"},789807,"Wooden Blocks",4,{"v":10,"d":"¥10.00"},{"v":2,"d":"¥2.00"},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[単価]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[単価]])-InvoiceItems[[#This Row],[割引額]],\"\")","v":{"v":38,"d":"¥38.00"}}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[単価]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[単価]])-InvoiceItems[[#This Row],[割引額]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[単価]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[単価]])-InvoiceItems[[#This Row],[割引額]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[単価]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[単価]])-InvoiceItems[[#This Row],[割引額]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[単価]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[単価]])-InvoiceItems[[#This Row],[割引額]],\"\")","v":""}]
[{"$nulls":6},"請求書小計",{"$f":"SUM(InvoiceItems[合計])","v":{"v":38,"d":"¥38.00"}}]
[{"$nulls":6},"税率",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"消費税",{"$f":"請求書小計*SalesTaxRate","v":{"v":3.3819999999999997,"d":"¥3.38"}}]
[{"$nulls":6},"送料",{"v":5,"d":"¥5.00"}]
[null,{"$f":"\"すべての支払先を次に指定してください \"&UPPER(会社名)&\".\"","v":"すべての支払先を次に指定してください TAILSPIN TOYS."},{"$nulls":4},"前金受領済み",{"v":0,"d":"¥0.00"}]
[null,"10 日以内に全額をお支払いください。期限を過ぎた残高には、1 か月あたり 2% の利子が課せられます。",{"$nulls":4},"合計",{"$f":"請求書小計+消費税+配送費-預金","v":{"v":46.382,"d":"¥46.38"}}]

{"sheet":"顧客","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"顧客",{"$nulls":10},"商業請求書"]
[null,"会社名","連絡先情報","住所","住所2","市","都道府県","郵便番号","電話","メール","FAX"]
[null,"Lilli Allik","Mike Gragg","345 Cherry Street","Suite 123","Albany","SD",12345,"432-555-0178","mike@excellentwebsite.com","432-555-0187"]
[null,"Contoso 株式会社","Janine Mendoza","567 Walnut Lane",null,"Moline","MO","09876","432-555-0189","contoso@websitegoeshere.com","432-555-0123"]