{"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":201990,"d":"¥201,990.00"},{"$f":"IF(invoices[[#This Row],[付款到期日期]]>=invoices[[#This Row],[支付日期]],,50)","v":0},{"v":201990,"d":"¥201,990.00"},{"$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":157000,"d":"¥157,000.00"},{"$f":"IF(invoices[[#This Row],[付款到期日期]]>=invoices[[#This Row],[支付日期]],,50)","v":{"v":50,"d":"¥50.00"}},{"v":75000,"d":"¥75,000.00"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2019-04-10"},{"$f":"invoices[[#This Row],[金额]]-invoices[[#This Row],[支付总额]]+invoices[[#This Row],[滞纳金]]","v":{"v":82050,"d":"¥82,050.00"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2019-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2019-04-15"},"康浦公司",{"v":137990,"d":"¥137,990.00"},{"$f":"IF(invoices[[#This Row],[付款到期日期]]>=invoices[[#This Row],[支付日期]],,50)","v":0},{"v":55000,"d":"¥55,000.00"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2019-03-17"},{"$f":"invoices[[#This Row],[金额]]-invoices[[#This Row],[支付总额]]+invoices[[#This Row],[滞纳金]]","v":{"v":82990,"d":"¥82,990.00"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2019-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2019-04-01"},"韩乔山",{"v":1200,"d":"¥1,200.00"},{"$f":"IF(invoices[[#This Row],[付款到期日期]]>=invoices[[#This Row],[支付日期]],,50)","v":{"v":50,"d":"¥50.00"}},{"v":750,"d":"¥750.00"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2019-04-16"},{"$f":"invoices[[#This Row],[金额]]-invoices[[#This Row],[支付总额]]+invoices[[#This Row],[滞纳金]]","v":{"v":500,"d":"¥500.00"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2019-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2019-04-30"},"康浦公司",{"v":1500,"d":"¥1,500.00"},{"$f":"IF(invoices[[#This Row],[付款到期日期]]>=invoices[[#This Row],[支付日期]],,50)","v":0},{"v":750,"d":"¥750.00"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2019-04-11"},{"$f":"invoices[[#This Row],[金额]]-invoices[[#This Row],[支付总额]]+invoices[[#This Row],[滞纳金]]","v":{"v":750,"d":"¥750.00"}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2019-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2019-06-01"},"韩晶",{"v":14750,"d":"¥14,750.00"},{"$f":"IF(invoices[[#This Row],[付款到期日期]]>=invoices[[#This Row],[支付日期]],,50)","v":0},{"v":12000,"d":"¥12,000.00"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2019-04-28"},{"$f":"invoices[[#This Row],[金额]]-invoices[[#This Row],[支付总额]]+invoices[[#This Row],[滞纳金]]","v":{"v":2750,"d":"¥2,750.00"}}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[付款到期日期]]>=invoices[[#This Row],[支付日期]],,50)","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],[支付日期]],,50)","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],[支付日期]],,50)","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],[支付日期]],,50)","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],[支付日期]],,50)","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],[支付日期]],,50)","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],[支付日期]],,50)","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],[支付日期]],,50)","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":514430,"d":"¥514,430.00"}},null,{"$f":"SUBTOTAL(109,invoices[支付总额])","v":{"v":345490,"d":"¥345,490.00"}},null,{"$f":"SUBTOTAL(109,invoices[未偿付])","v":{"v":169040,"d":"¥169,040.00"}}]