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

{"sheet":"Invoice","index":0,"n_rows":44,"n_cols":12,"rows_kept":44,"merged":[[0,1,0,8],[3,1,3,2],[3,4,3,5],[3,7,3,8],[4,1,4,2],[4,4,4,5],[4,7,4,8],[7,2,7,4],[7,6,7,8],[8,2,8,4],[8,6,8,8],[9,2,9,4],[9,6,9,8],[11,1,11,10],[13,2,13,6],[13,8,13,9],[14,2,14,6],[14,8,14,9],[15,2,15,6],[15,8,15,9],[16,2,16,6],[16,8,16,9],[17,2,17,6],[17,8,17,9],[18,2,18,6],[18,8,18,9],[19,2,19,6],[19,8,19,9],[20,2,20,6],[20,8,20,9],[21,2,21,6],[21,8,21,9],[22,2,22,6],[22,8,22,9],[23,2,23,6],[23,8,23,9],[24,2,24,6],[24,8,24,9],[25,2,25,6],[25,8,25,9],[26,2,26,6],[26,8,26,9],[27,2,27,6],[27,8,27,9],[28,2,28,6],[28,8,28,9],[29,2,29,6],[29,8,29,9],[30,2,30,6],[30,8,30,9],[31,2,31,6],[31,8,31,9],[32,2,32,6],[32,8,32,9],[33,2,33,6],[33,8,33,9],[34,2,34,6],[34,8,34,9],[35,2,35,6],[35,8,35,9],[36,2,36,6],[36,8,36,9],[37,2,37,6],[37,8,37,9],[42,1,42,8],[43,1,43,8]]}
[null,"Company Name"]
[]
[]
[null,"Street Address",null,"P:","Phone Number",null,null,"Email"]
[null,"City, State, ZIP Code",null,"F:","Fax Number",null,null,"Website"]
[]
[]
[null,"Bill To:",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,#REF!,2),#REF!,3,FALSE),\"\")","v":""},null,null,"Phone:",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,#REF!,2),#REF!,9,FALSE),\"\")","v":""},{"$nulls":3},"Invoice #:"]
[null,"Address:",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,#REF!,2),#REF!,5,FALSE),\"\")","v":""},null,null,"Fax:",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,#REF!,2),#REF!,11,FALSE),\"\")","v":""},{"$nulls":3},"Invoice Date:",{"$f":"IFERROR(VLOOKUP(rngInvoice,#REF!,3,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,#REF!,2),#REF!,6,FALSE)&\" \"& VLOOKUP(VLOOKUP(L8,#REF!,2,FALSE),#REF!,7,FALSE)&\", \"&VLOOKUP(VLOOKUP(L8,#REF!,2,FALSE),#REF!,8,FALSE),\"\")","v":""},null,null,"Email:",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,#REF!,2),#REF!,10,FALSE),\"\")","v":""}]
[]
[null,{"$f":"\"Invoice For: \"&IFERROR(VLOOKUP(rngInvoice,#REF!,4),\"\")","v":"Invoice For: "}]
[null,"Item #","Description",{"$nulls":4},"Qty","Unit Price",null,"Discount","Price"]
[]
[{"$nulls":11},{"$f":"IFERROR(IF((H15*I15)<=0,\"\",(H15*I15)-K15),\"\")","v":""}]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":10},"Invoice Subtotal",{"$f":"SUM(L14:L38)","v":0}]
[{"$nulls":10},"Tax Rate"]
[{"$nulls":10},"Sales Tax",{"$f":"IFERROR(L39*L40,\"\")","v":0}]
[{"$nulls":10},"Other"]
[null,{"$f":"\"Make all checks payable to \"&CompanyName&\".\"","v":"Make all checks payable to Company Name."},{"$nulls":8},"Deposit Received"]
[null,"Total due in <#> days. Overdue accounts subject to a service charge of <#>% per month.",{"$nulls":8},"TOTAL",{"$f":"(L39+L41+L42)-L43","v":0}]