{"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]]}
[null,"Central Beauty"]
[null,"Street Address","4321 Maplewood Ave",null,null,"Phone:","(555) 555-5555"]
[null,"Address 2","Suite #123",null,null,"Fax:","(555) 555-5550"]
[null,"City, ST  ZIP Code","Nashville, TN 24680",null,null,"E-mail:","central@interestingsite.com"]
[null,"STATEMENT"]
[null,"Statement #:",567,null,"Bill To:","Name","Andre Lawson"]
[null,"Date:","2022-11-01",null,null,"Company Name","Seattle Salon"]
[null,"Customer ID:",8675309,null,null,"Street Address","123 Main Street"]
[{"$nulls":5},"Address 2","Bldg A"]
[{"$nulls":5},"City, ST  ZIP Code","Seattle, WA 78901"]
[]
[null,"DATE","TYPE","INVOICE #","DESCRIPTION","AMOUNT","PAYMENT","BALANCE"]
[null,{"$f":"TODAY()","v":"2022-11-06"},"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 check."]
[null,"Terms: Balance due in 30 days."]
[null,"REMITTANCE"]
[null,"Customer Name:","Andre Lawson"]
[null,"Customer ID:",1011]
[null,"Statement #:",567]
[null,"Date:","2022-11-01"]
[null,"Amount Due:",{"$f":"Data[[#Totals],[BALANCE]]","v":{"v":100,"d":"$100.00"}}]
[null,"Amount Enclosed:",{"v":100,"d":"$100.00"}]