{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["見積書"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"見積書","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[14,1,14,5]]}
[]
[null,"見積書"]
[null,"Noa Vidal Designs",{"$nulls":4},"   "]
[null,"他にないジュエリー"]
[null,"会社住所",null,null,"日付",{"$f":"TODAY()","v":"2023-04-03"}]
[null,"123 Main St. Seattle, WA 12345",null,null,"見積書番号",1234]
[null,"電話:(123) 456-7890   Fax:(123) 456-7891",null,null,"顧客 ID","ABC123"]
[null,"見積先"]
[null,"Chetana Hegde",null,null,"見積の有効期限",{"$f":"F5+30","v":"2023-05-03"}]
[null,"14K Jewels",null,null,"作成者","Sam"]
[null,"321 Sycamore St. Albany, NY 54321"]
[null,"(000) 123-4567"]
[null,"備考"]
[]
[null,"なし"]
[]
[null,"担当者名","発注書番号","出荷日","F.O.B.ポイント","期日"]
[null,"Sam",1000985,"2023-01-10","配送日","請求書受領時"]
[]
[null,"数量","内容","単価","課税対象","金額"]
[null,{"v":120,"d":"120 "},"純金チェーン",{"v":33.3,"d":"¥33.30"},"はい",{"$f":"IFERROR(IF(OR(販売品目_テーブル[[#This Row],[数量]]=\"\",販売品目_テーブル[[#This Row],[単価]]=\"\"),\"\",販売品目_テーブル[[#This Row],[数量]]*販売品目_テーブル[[#This Row],[単価]]),\"\")","v":{"v":3995.9999999999995,"d":"¥3,996.00"}}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(販売品目_テーブル[[#This Row],[数量]]=\"\",販売品目_テーブル[[#This Row],[単価]]=\"\"),\"\",販売品目_テーブル[[#This Row],[数量]]*販売品目_テーブル[[#This Row],[単価]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(販売品目_テーブル[[#This Row],[数量]]=\"\",販売品目_テーブル[[#This Row],[単価]]=\"\"),\"\",販売品目_テーブル[[#This Row],[数量]]*販売品目_テーブル[[#This Row],[単価]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(販売品目_テーブル[[#This Row],[数量]]=\"\",販売品目_テーブル[[#This Row],[単価]]=\"\"),\"\",販売品目_テーブル[[#This Row],[数量]]*販売品目_テーブル[[#This Row],[単価]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(販売品目_テーブル[[#This Row],[数量]]=\"\",販売品目_テーブル[[#This Row],[単価]]=\"\"),\"\",販売品目_テーブル[[#This Row],[数量]]*販売品目_テーブル[[#This Row],[単価]]),\"\")","v":""}]
[]
[{"$nulls":4},"小計",{"$f":"SUM(販売品目_テーブル[金額])","v":{"v":3995.9999999999995,"d":"¥3,996.00"}}]
[null,"この見積書に関して不明な点がある場合の連絡先:  ",null,null,"税率",{"v":0.086,"d":"8.60%"}]
[null,"Sam、(123) 456-7890。",null,null,"消費税",{"$f":"IFERROR(税率*SUMIF(販売品目_テーブル[課税対象],\"はい\",販売品目_テーブル[金額]), \"\")","v":{"v":343.65599999999995,"d":"¥343.66"}}]
[{"$nulls":4},"その他"]
[null,"ご利用ありがとうございます。",null,null,"集計",{"$f":"SUM(F27:F30)","v":{"v":4339.741999999999,"d":"¥4,339.74"}}]