{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["发票跟踪表"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"发票跟踪表","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"发票跟踪表"]
[null,"发票编号","日期","付款期限","客户姓名","金额 ","滞纳金 ","付款总额","付款日期","未付款金额"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},"Smith",{"v":201990,"d":"¥201,990.00"},{"$f":"IFERROR(IF(发票[[#This Row],[付款期限]]>=发票[[#This Row],[付款日期]],,5), \"\")","v":0},{"v":201990,"d":"¥201,990.00"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2018-02-01"},{"$f":"IFERROR(发票[[#This Row],[金额 ]]-发票[[#This Row],[付款总额]]+发票[[#This Row],[滞纳金 ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2018-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Smith",{"v":157000,"d":"¥157,000.00"},{"$f":"IFERROR(IF(发票[[#This Row],[付款期限]]>=发票[[#This Row],[付款日期]],,5), \"\")","v":{"v":5,"d":"¥5.00"}},{"v":75000,"d":"¥75,000.00"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2018-04-10"},{"$f":"IFERROR(发票[[#This Row],[金额 ]]-发票[[#This Row],[付款总额]]+发票[[#This Row],[滞纳金 ]], \"\")","v":{"v":82005,"d":"¥82,005.00"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2018-04-15"},"Contoso",{"v":137990,"d":"¥137,990.00"},{"$f":"IFERROR(IF(发票[[#This Row],[付款期限]]>=发票[[#This Row],[付款日期]],,5), \"\")","v":0},{"v":55000,"d":"¥55,000.00"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"IFERROR(发票[[#This Row],[金额 ]]-发票[[#This Row],[付款总额]]+发票[[#This Row],[滞纳金 ]], \"\")","v":{"v":82990,"d":"¥82,990.00"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2018-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Jonathon Haas",{"v":1200,"d":"¥1,200.00"},{"$f":"IFERROR(IF(发票[[#This Row],[付款期限]]>=发票[[#This Row],[付款日期]],,5), \"\")","v":{"v":5,"d":"¥5.00"}},{"v":750,"d":"¥750.00"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2018-04-16"},{"$f":"IFERROR(发票[[#This Row],[金额 ]]-发票[[#This Row],[付款总额]]+发票[[#This Row],[滞纳金 ]], \"\")","v":{"v":455,"d":"¥455.00"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2018-04-30"},"Contoso",{"v":1500,"d":"¥1,500.00"},{"$f":"IFERROR(IF(发票[[#This Row],[付款期限]]>=发票[[#This Row],[付款日期]],,5), \"\")","v":0},{"v":750,"d":"¥750.00"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2018-04-11"},{"$f":"IFERROR(发票[[#This Row],[金额 ]]-发票[[#This Row],[付款总额]]+发票[[#This Row],[滞纳金 ]], \"\")","v":{"v":750,"d":"¥750.00"}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Stephanie Bourne",{"v":14750,"d":"¥14,750.00"},{"$f":"IFERROR(IF(发票[[#This Row],[付款期限]]>=发票[[#This Row],[付款日期]],,5), \"\")","v":0},{"v":12000,"d":"¥12,000.00"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2018-04-28"},{"$f":"IFERROR(发票[[#This Row],[金额 ]]-发票[[#This Row],[付款总额]]+发票[[#This Row],[滞纳金 ]], \"\")","v":{"v":2750,"d":"¥2,750.00"}}]
[null,"总计",{"$nulls":3},{"$f":"SUBTOTAL(109,发票[[金额 ]])","v":{"v":514430,"d":"¥514,430.00"}},null,{"$f":"SUBTOTAL(109,发票[付款总额])","v":{"v":345490,"d":"¥345,490.00"}},null,{"$f":"SUBTOTAL(109,发票[未付款金额])","v":{"v":168950,"d":"¥168,950.00"}}]