{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Service invoice","Customers"],"not_rendered":{"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Service invoice","index":0,"n_rows":28,"n_cols":10,"rows_kept":28,"merged":[[3,6,3,7],[12,6,15,7],[13,1,15,1],[25,1,25,5],[26,1,26,5],[27,1,27,5]]}
[null,"SERVICE INVOICE",{"$nulls":7},"Customers"]
[null,"GRAPHIC DESIGN INSTITUTE"]
[null,"123 Main Street","P: 123-555-0123","tailspintoys@interestingsite.com"]
[null,"Ocean View, MO 12345","F: 123-555-0124","www.interestingsite.com"]
[]
[]
[]
[null,"INVOICE DATE:",{"$f":"TODAY()","v":"2023-01-01"}]
[null,"DATE DUE:",{"$f":"TODAY()+30","v":"2023-01-31"}]
[]
[]
[]
[null,"BILL TO:","Trey Research","PHONE:",{"$f":"VLOOKUP(BillName,CustomerList[],8,FALSE)","v":"432-555-0178"},"INVOICE FOR:","New branding research & development"]
[null,"ADDRESS:",{"$f":"VLOOKUP(BillName,CustomerList[],3,FALSE)","v":"345 Cherry Street"},"FAX:",{"$f":"VLOOKUP(BillName,CustomerList[],10,FALSE)","v":"432-555-0124"}]
[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"},"E-MAIL:",{"$f":"VLOOKUP(BillName,CustomerList[],9,FALSE)","v":"trey@interestingsite.com"}]
[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"},"CONTACT:",{"$f":"VLOOKUP(BillName,CustomerList[],2,FALSE)","v":"Mike Gragg"}]
[]
[]
[null,"DATE","DESCRIPTION","RATE PER HOUR","HOURS","FLAT FEE","DISCOUNT","TOTAL"]
[null,{"$f":"TODAY()","v":"2023-01-01"},"Logo designs",{"v":100,"d":"$100.00"},6,null,{"v":75,"d":"$75.00"},{"$f":"IF(OR(InvoiceItems[[#This Row],[FLAT FEE]]<>\"\",AND(InvoiceItems[[#This Row],[RATE PER HOUR]]<>\"\",InvoiceItems[[#This Row],[HOURS]]<>\"\")),(InvoiceItems[[#This Row],[RATE PER HOUR]]*InvoiceItems[[#This Row],[HOURS]])+InvoiceItems[[#This Row],[FLAT FEE]]-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":{"v":525,"d":"$525.00"}}]
[null,{"$f":"TODAY()+1","v":"2023-01-02"},"Focus group costs",{"v":75,"d":"$75.00"},3,null,null,{"$f":"IF(OR(InvoiceItems[[#This Row],[FLAT FEE]]<>\"\",AND(InvoiceItems[[#This Row],[RATE PER HOUR]]<>\"\",InvoiceItems[[#This Row],[HOURS]]<>\"\")),(InvoiceItems[[#This Row],[RATE PER HOUR]]*InvoiceItems[[#This Row],[HOURS]])+InvoiceItems[[#This Row],[FLAT FEE]]-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":{"v":225,"d":"$225.00"}}]
[null,{"$f":"TODAY()+2","v":"2023-01-03"},"Rental space for focus group",null,null,{"v":275,"d":"$275.00"},null,{"$f":"IF(OR(InvoiceItems[[#This Row],[FLAT FEE]]<>\"\",AND(InvoiceItems[[#This Row],[RATE PER HOUR]]<>\"\",InvoiceItems[[#This Row],[HOURS]]<>\"\")),(InvoiceItems[[#This Row],[RATE PER HOUR]]*InvoiceItems[[#This Row],[HOURS]])+InvoiceItems[[#This Row],[FLAT FEE]]-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":{"v":275,"d":"$275.00"}}]
[{"$nulls":7},{"$f":"IF(OR(InvoiceItems[[#This Row],[FLAT FEE]]<>\"\",AND(InvoiceItems[[#This Row],[RATE PER HOUR]]<>\"\",InvoiceItems[[#This Row],[HOURS]]<>\"\")),(InvoiceItems[[#This Row],[RATE PER HOUR]]*InvoiceItems[[#This Row],[HOURS]])+InvoiceItems[[#This Row],[FLAT FEE]]-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(OR(InvoiceItems[[#This Row],[FLAT FEE]]<>\"\",AND(InvoiceItems[[#This Row],[RATE PER HOUR]]<>\"\",InvoiceItems[[#This Row],[HOURS]]<>\"\")),(InvoiceItems[[#This Row],[RATE PER HOUR]]*InvoiceItems[[#This Row],[HOURS]])+InvoiceItems[[#This Row],[FLAT FEE]]-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(OR(InvoiceItems[[#This Row],[FLAT FEE]]<>\"\",AND(InvoiceItems[[#This Row],[RATE PER HOUR]]<>\"\",InvoiceItems[[#This Row],[HOURS]]<>\"\")),(InvoiceItems[[#This Row],[RATE PER HOUR]]*InvoiceItems[[#This Row],[HOURS]])+InvoiceItems[[#This Row],[FLAT FEE]]-InvoiceItems[[#This Row],[DISCOUNT]],\"\")","v":""}]
[{"$nulls":6},"Invoice Subtotal",{"$f":"SUM(InvoiceItems[TOTAL])","v":{"v":1025,"d":"$1,025.00"}}]
[null,{"$f":"\"Make all checks payable to \"&CompanyName&\".\"","v":"Make all checks payable to GRAPHIC DESIGN INSTITUTE."},{"$nulls":4},"Deposit Amount",{"v":200,"d":"$200.00"}]
[null,"Total due in <#> days. Overdue accounts subject to a service charge of <#>% per month.",{"$nulls":4},"TOTAL",{"$f":"InvoiceSubtotal-Deposit","v":{"v":825,"d":"$825.00"}}]

{"sheet":"Customers","index":1,"n_rows":5,"n_cols":13,"rows_kept":5}
[null,"CUSTOMERS",{"$nulls":10},"Service Invoice"]
[]
[null,"COMPANY NAME","CONTACT NAME","ADDRESS","ADDRESS 2","CITY","STATE","ZIP CODE","PHONE","E-MAIL","FAX"]
[null,"Trey Research","Mike Gragg","345 Cherry Street","Suite 123","Albany","SD",12345,"432-555-0178","trey@interestingsite.com","432-555-0124"]
[null,"Contoso, Ltd","Janine Mendoza","567 Walnut Lane",null,"Moline","MO",{"v":9876,"d":"09876"},"432-555-0189","janine@contoso.com","432-555-0123"]