{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["BILLING STATEMENT"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"BILLING STATEMENT","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[1,2,1,3],[1,6,1,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7],[8,6,8,7],[9,6,9,7],[18,1,18,7],[19,1,19,7]]}
[null,"COMPANY NAME"]
[null,"Street Address",{"$nulls":3},"Phone Number:"]
[null,"Address 2",{"$nulls":3},"Fax number:"]
[null,"City, County/Region, Postcode",{"$nulls":3},"Email Address:"]
[null,"STATEMENT"]
[null,"Statement no.:",null,null,"Invoice to:","Name"]
[null,"Date:",{"$nulls":3},"Company Name"]
[null,"Customer ID:",{"$nulls":3},"Street Address"]
[{"$nulls":5},"Address 2"]
[{"$nulls":5},"City, County/Region, Postcode"]
[]
[null,"DATE","TYPE","INVOICE NO.","DESCRIPTION","AMOUNT","PAYMENT","BALANCE"]
[null,{"$f":"TODAY()","v":"2018-07-26"},"Sales",123,"Products",{"v":200,"d":"£200.00"},{"v":100,"d":"£100.00"},{"$f":"IF(Data[[#This Row],[AMOUNT]]>0,Data[[#This Row],[AMOUNT]]-Data[[#This Row],[PAYMENT]],\"\")","v":{"v":100,"d":"£100.00"}}]
[{"$nulls":7},{"$f":"IF(Data[[#This Row],[AMOUNT]]>0,Data[[#This Row],[AMOUNT]]-Data[[#This Row],[PAYMENT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Data[[#This Row],[AMOUNT]]>0,Data[[#This Row],[AMOUNT]]-Data[[#This Row],[PAYMENT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Data[[#This Row],[AMOUNT]]>0,Data[[#This Row],[AMOUNT]]-Data[[#This Row],[PAYMENT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Data[[#This Row],[AMOUNT]]>0,Data[[#This Row],[AMOUNT]]-Data[[#This Row],[PAYMENT]],\"\")","v":""}]
[{"$nulls":6},"TOTAL",{"$f":"SUBTOTAL(109,Data[BALANCE])","v":{"v":100,"d":"£100.00"}}]
[null,"Reminder: Please include the statement number on your cheque."]
[null,"Terms: Balance due in 30 days."]
[null,"REMITTANCE"]
[null,"Customer name:"]
[null,"Customer ID:"]
[null,"Statement no.:"]
[null,"Date:"]
[null,"Amount due:",{"$f":"Data[[#Totals],[BALANCE]]","v":{"v":100,"d":"£100.00"}}]
[null,"Amount Enclosed:"]