{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Invoice Tracker"],"read":"whole","date_system":"1900"}

{"sheet":"Invoice Tracker","index":0,"n_rows":18,"n_cols":10,"rows_kept":18,"merged":[[0,1,0,2]]}
[null,"Invoice Tracker"]
[]
[null,"Invoice #","Date","Payment Due","Customer Name","Amount ","Late Fee ","Total Paid","Date Paid","Outstanding"]
[null,1001,"2009-01-15","2009-02-15","Smith",{"v":20199,"d":"$20,199.00"},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},{"v":20199,"d":"$20,199.00"},"2009-02-01",{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[null,1002,"2009-02-11","2009-04-01","Smith",{"v":15700,"d":"$15,700.00"},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":{"v":5,"d":"$5.00"}},{"v":7500,"d":"$7,500.00"},"2009-04-10",{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":{"v":8205,"d":"$8,205.00"}}]
[null,1003,"2009-02-17","2009-04-15","Contoso",{"v":13799,"d":"$13,799.00"},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},{"v":5500,"d":"$5,500.00"},"2009-03-17",{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":{"v":8299,"d":"$8,299.00"}}]
[null,1004,"2009-03-08","2009-04-01","Jonathon Haas",{"v":120,"d":"$120.00"},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":{"v":5,"d":"$5.00"}},{"v":75,"d":"$75.00"},"2009-04-16",{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":{"v":50,"d":"$50.00"}}]
[null,1005,"2009-03-17","4/31/2009","Contoso",{"v":150,"d":"$150.00"},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},{"v":75,"d":"$75.00"},"2009-04-11",{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":{"v":75,"d":"$75.00"}}]
[null,1006,"2009-04-01","2009-06-01","Stephanie Bourne",{"v":1475,"d":"$1,475.00"},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},{"v":1200,"d":"$1,200.00"},"2009-04-28",{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":{"v":275,"d":"$275.00"}}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},null,null,{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},null,null,{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},null,null,{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},null,null,{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},null,null,{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},null,null,{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},null,null,{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[{"$nulls":6},{"$f":"IF(invoices[[#This Row],[Payment Due]]>=invoices[[#This Row],[Date Paid]],,5)","v":0},null,null,{"$f":"invoices[[#This Row],[Amount ]]-invoices[[#This Row],[Total Paid]]+invoices[[#This Row],[Late Fee ]]","v":0}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[[Amount ]])","v":{"v":51443,"d":"$51,443.00"}},null,{"$f":"SUBTOTAL(109,[Total Paid])","v":{"v":34549,"d":"$34,549.00"}},null,{"$f":"SUBTOTAL(109,[Outstanding])","v":{"v":16904,"d":"$16,904.00"}}]