{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Commercial Invoice","Customers"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Commercial Invoice","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,1,3],[0,6,0,7],[1,6,1,7]]}
[null,"TAILSPIN TOYS",null,null,"123 Main Street","P: 123-555-0123","tailspin@interestingsite.com",null,null,"Customers"]
[{"$nulls":4},"Ocean View,  MO 12345","F: 123-555-0124","www.tailspintoys.com"]
[]
[null,"Bill to:","Lilli Allik","Phone:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],8,FALSE),\"\")","v":"432-555-0178"},null,"Invoice #:",34567]
[null,"Address:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],3,FALSE),\"\")","v":"345 Cherry Street"},"Fax:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],10,FALSE),\"\")","v":"432-555-0187"},null,"Invoice Date:",{"$f":"TODAY()","v":"2022-12-20"}]
[null,null,{"$f":"IF(VLOOKUP(BillName,CustomerList[],4,FALSE)<>\"\",VLOOKUP(BillName,CustomerList[],4,FALSE),IF(VLOOKUP(BillName,CustomerList[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(BillName,CustomerList[],5,FALSE),\", \",VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE)),CONCATENATE(VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE))))","v":"Suite 123"},"Email:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"Contact:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],2,FALSE),\"\")","v":"Mike Gragg"}]
[null,null,{"$f":"IF(VLOOKUP(BillName,CustomerList[],4,FALSE)=\"\",\"\",IF(VLOOKUP(BillName,CustomerList[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(BillName,CustomerList[],5,FALSE),\", \",VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE)),CONCATENATE(VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE))))","v":"Albany, SD 12345"}]
[null,"DATE","ITEM #","DESCRIPTION","QTY","UNIT PRICE","DISCOUNT","TOTAL"]
[null,{"$f":"TODAY()","v":"2022-12-20"},789807,"Wooden Blocks",4,{"v":10,"d":"$10.00"},{"v":2,"d":"$2.00"},{"$f":"IF(AND(InvoiceItems[[#This Row],[QTY]]<>\"\",InvoiceItems[[#This Row],[UNIT PRICE]]<>\"\"),(InvoiceItems[[#This Row],[QTY]]*InvoiceItems[[#This Row],[UNIT PRICE]])-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":{"v":38,"d":"$38.00"}}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[QTY]]<>\"\",InvoiceItems[[#This Row],[UNIT PRICE]]<>\"\"),(InvoiceItems[[#This Row],[QTY]]*InvoiceItems[[#This Row],[UNIT PRICE]])-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[QTY]]<>\"\",InvoiceItems[[#This Row],[UNIT PRICE]]<>\"\"),(InvoiceItems[[#This Row],[QTY]]*InvoiceItems[[#This Row],[UNIT PRICE]])-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[QTY]]<>\"\",InvoiceItems[[#This Row],[UNIT PRICE]]<>\"\"),(InvoiceItems[[#This Row],[QTY]]*InvoiceItems[[#This Row],[UNIT PRICE]])-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[QTY]]<>\"\",InvoiceItems[[#This Row],[UNIT PRICE]]<>\"\"),(InvoiceItems[[#This Row],[QTY]]*InvoiceItems[[#This Row],[UNIT PRICE]])-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":""}]
[{"$nulls":6},"Invoice subtotal",{"$f":"SUM(InvoiceItems[TOTAL])","v":{"v":38,"d":"$38.00"}}]
[{"$nulls":6},"Tax rate",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"Sales tax",{"$f":"InvoiceSubtotal*SalesTaxRate","v":{"v":3.3819999999999997,"d":"$3.38"}}]
[{"$nulls":6},"Shipping",{"v":5,"d":"$5.00"}]
[null,{"$f":"\"Make all checks payable to \"&UPPER(CompanyName)&\".\"","v":"Make all checks payable to TAILSPIN TOYS."},{"$nulls":4},"Deposit received",{"v":0,"d":"$0.00"}]
[null,"Total due in 10 days. Overdue accounts are subject to and interest charge of 2% per month.",{"$nulls":4},"Total",{"$f":"InvoiceSubtotal+SalesTax+Shipping-Deposit","v":{"v":46.382,"d":"$46.38"}}]

{"sheet":"Customers","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"CUSTOMERS",{"$nulls":10},"Commercial Invoice"]
[null,"COMPANY NAME","CONTACT INFO","ADDRESS","ADDRESS2","CITY","STATE","ZIP CODE","PHONE","EMAIL","FAX"]
[null,"Lilli Allik","Mike Gragg","345 Cherry Street","Suite 123","Albany","SD",12345,"432-555-0178","mike@excellentwebsite.com","432-555-0187"]
[null,"Contoso, Ltd","Janine Mendoza","567 Walnut Lane",null,"Moline","MO","09876","432-555-0189","contoso@websitegoeshere.com","432-555-0123"]