{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["請求書記録"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"請求書記録","index":0,"n_rows":18,"n_cols":10,"rows_kept":18,"merged":[[0,1,0,2]]}
[null,"請求書記録"]
[]
[null,"請求書番号","日付","支払期日","取引先名","金額","遅延損害金","支払合計","支払日","未払残高"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2019-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2019-02-15"},"西野ストアー",{"v":2019900,"d":"¥2,019,900"},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},{"v":2019900,"d":"¥2,019,900"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2019-02-01"},{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2019-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2019-04-01"},"西野ストアー",{"v":1570000,"d":"¥1,570,000"},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":{"v":500,"d":"¥500"}},{"v":750000,"d":"¥750,000"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2019-04-10"},{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":{"v":820500,"d":"¥820,500"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2019-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2019-04-15"},"蓬莱堂",{"v":1379900,"d":"¥1,379,900"},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},{"v":550000,"d":"¥550,000"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2019-03-17"},{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":{"v":829900,"d":"¥829,900"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2019-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2019-04-01"},"パーラーえんとつ",{"v":12000,"d":"¥12,000"},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":{"v":500,"d":"¥500"}},{"v":7500,"d":"¥7,500"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2019-04-16"},{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":{"v":5000,"d":"¥5,000"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2019-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2019-04-30"},"蓬莱堂",{"v":15000,"d":"¥15,000"},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},{"v":7500,"d":"¥7,500"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2019-04-11"},{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":{"v":7500,"d":"¥7,500"}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2019-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2019-06-01"},"ポム・ド・テール",{"v":147500,"d":"¥147,500"},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},{"v":120000,"d":"¥120,000"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2019-04-28"},{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":{"v":27500,"d":"¥27,500"}}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},null,null,{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},null,null,{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},null,null,{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},null,null,{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},null,null,{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},null,null,{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},null,null,{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[支払期日]]>=invoices[[#This Row],[支払日]],,500)","v":0},null,null,{"$f":"invoices[[#This Row],[金額]]-invoices[[#This Row],[支払合計]]+invoices[[#This Row],[遅延損害金]]","v":0}]
[null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,invoices[金額])","v":{"v":5144300,"d":"¥5,144,300"}},null,{"$f":"SUBTOTAL(109,invoices[支払合計])","v":{"v":3454900,"d":"¥3,454,900"}},null,{"$f":"SUBTOTAL(109,invoices[未払残高])","v":{"v":1690400,"d":"¥1,690,400"}}]