{"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,3,2,4],[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]]}
[null,"INVOICE","0005"]
[null,{"$f":"TODAY()","v":"2022-11-06"},null,{"$f":"InvoiceTotal","v":79.65},null," ","Company Setup"]
[null,"PAYMENT DUE BY:",{"$f":"TODAY()+15","v":"2022-11-21"},null,null," "]
[null,"Kristin Orav",null,"ADVENTURE WORKS"]
[null,"Fabrikam, Inc.",null,"23456 Maple Street"]
[null,"1234 First Street",null,"Orange Grove, CA 09876"]
[null,"Forest,  OR 12345"]
[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,"Tax"]
[null,{"$f":"REPT(CompanySetup_YourCurrencyAbbreviation,LEN(CompanySetup_YourCurrencyAbbreviation)>0) & \" TOTAL\"","v":"USD $ 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: \" & CompanySetup_YourPhone,\"\")","v":"Phone: 123-555-0150"}]
[null,"Address of Bank:",{"$f":"CompanySetup_BankAddress","v":"234 Main St. Orange Grove, CA 09876"},null,{"$f":"IFERROR(\"Fax: \" & CompanySetup_YourFax,\"\")","v":"Fax: 123-555-0151"}]
[null,"Account Number:",{"$f":"CompanySetup_BankAccount","v":1234567},null,"interestingsite.com"]
[null,"Routing Number (SWIFT Code)",{"$f":"CompanySetup_BankRouting","v":9876543210},null,"accounting@interestingsite.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_CheckPayee & \".\")","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","Gaurav Cheema"]
[null,"Company Name","ADVENTURE WORKS"]
[null,"Address Line 1","23456 Maple Street"]
[null,"Address Line 2","Orange Grove, CA 09876"]
[null,"Address Line 3"]
[null,"Address Line 4"]
[null,"Address Line 5"]
[null,"Phone","123-555-0150"]
[null,"Facsimile","123-555-0151"]
[null,"Website","interestingsite.com"]
[null,"Email","accounting@interestingsite.com"]
[null,"Currency Abbreviation","USD $"]
[null,"Name of Beneficiary for Bank Wire","Adventure Works"]
[null,"Name of Bank","Woodgrove Bank"]
[null,"Address of Bank","234 Main St. Orange Grove, CA 09876"]
[null,"Account Number",1234567]
[null,"Routing Number (SWIFT Code)",9876543210]
[null,"Make Checks Payable To","Adventure Works"]