{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Billing invoice","Company setup"],"not_rendered":{"images":1,"defined_names":27},"read":"whole","date_system":"1900"}

{"sheet":"Billing invoice","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"merged":[[1,1,1,2],[1,3,2,4],[1,6,2,6],[3,3,3,4],[4,3,4,4],[5,3,5,4],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[34,1,34,4]]}
[null,"INVOICE","0005"]
[null,{"$f":"TODAY()","v":"2018-07-04"},null,{"$f":"InvoiceTotal","v":79.65},null," ","Company setup"]
[null,"PAYMENT DUE BY:",{"$f":"TODAY()+15","v":"2018-07-19"},null,null," "]
[null,"KIM ABERCROMBIE",null,"ADVENTURE WORKS"]
[null,"Fabrikam, Inc.",null,"89 Yewtree Crescent"]
[null,"456 Elm Road",null,"Sheffield, South Yorkshire S03 4LD"]
[null,"Birmingham, West Midlands, B01 2HM"]
[null,"QUANTITY","DETAILS","UNIT PRICE","LINE TOTAL"]
[null,2,"Widgets",14.95,{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":{"v":29.9,"d":"29.90"}}]
[null,5,"Washers",9.95,{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":49.75}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(InvoiceDetails[[#This Row],[UNIT PRICE]]*InvoiceDetails[[#This Row],[QUANTITY]],\"\")","v":0}]
[null,"Discount"]
[null,"Net total",null,null,{"$f":"SUM(InvoiceDetails[LINE TOTAL])-E24","v":{"v":79.65,"d":"£79.65"}}]
[null,"Insurance"]
[null,{"$f":"REPT(CompanySetup_YourCurrencyAbbreviation,LEN(CompanySetup_YourCurrencyAbbreviation)>0) & \" TOTAL\"","v":"GBP TOTAL"},null,null,{"$f":"IFERROR(E25+E26, \"\")","v":{"v":79.65,"d":"£79.65"}}]
[null,"PAYMENT DETAILS",null,null,"OTHER INFORMATION"]
[null,"Name of beneficiary:",{"$f":" CompanySetup_BankBeneficiaryName","v":"Adventure Works"},null,{"$f":"IFERROR(CompanySetup_YourName,\"\")","v":""}]
[null,"Name of bank:",{"$f":"CompanySetup_BankName","v":"Woodgrove Bank"},null,{"$f":"IFERROR(\"Phone number: \" & CompanySetup_YourPhone,\"\")","v":"Phone number: 0114 496 0345"}]
[null,"Address of bank:",{"$f":"CompanySetup_BankAddress","v":"1 Palm Grove, Sheffield, South Yorkshire S04 5LD"},null,{"$f":"IFERROR(\"Facsimile: \" & CompanySetup_YourFax,\"\")","v":"Facsimile: 0114 496 0765"}]
[null,"Account number:",{"$f":"CompanySetup_BankAccount","v":1234567},null,{"$f":"IFERROR(CompanySetup_YourURL,\"\")","v":"Adventure-Works.com"}]
[null,"Sort code (BIC code):",{"$f":"CompanySetup_BankSort","v":9876543210},null,{"$f":"IFERROR(CompanySetup_YourEmail,\"\")","v":"Accounting@Adventure-Works.com"}]
[null,"Payment reference:",{"$f":"InvoiceNumberDisplay","v":"0005"},null,{"$f":"IFERROR(IF(LEN(Client_PO),\"Contract/PO: \" & Client_PO,\"\"),\"\")","v":""}]
[null,{"$f":"UPPER(\"Payment should be made by bank transfer or check made payable to \" & CompanySetup_ChequePayee& \".\")","v":"PAYMENT SHOULD BE MADE BY BANK TRANSFER OR CHECK MADE PAYABLE TO ADVENTURE WORKS."}]

{"sheet":"Company setup","index":1,"n_rows":20,"n_cols":5,"rows_kept":20}
[null,"COMPANY SETUP"]
[null,"INVOICING COMPANY DETAILS","Value",null,"Billing invoice"]
[null,"Name","Greg Anderson"]
[null,"Company name","ADVENTURE WORKS"]
[null,"Address line 1","89 Yewtree Crescent"]
[null,"Address line 2","Sheffield, South Yorkshire S03 4LD"]
[null,"Address line 3"]
[null,"Address line 4"]
[null,"Address line 5"]
[null,"Phone number","0114 496 0345"]
[null,"Facsimile","0114 496 0765"]
[null,"Website","Adventure-Works.com"]
[null,"Email address","Accounting@Adventure-Works.com"]
[null,"Currency abbreviation","GBP"]
[null,"Name of beneficiary for bank transfer","Adventure Works"]
[null,"Name of bank","Woodgrove Bank"]
[null,"Address of bank","1 Palm Grove, Sheffield, South Yorkshire S04 5LD"]
[null,"Account number",1234567]
[null,"Sort code (BIC code)",9876543210]
[null,"Make cheques payable to","Adventure Works"]