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

{"sheet":"Service invoice","index":0,"n_rows":33,"n_cols":5,"rows_kept":33,"merged":[[1,4,4,4],[30,1,30,4],[31,1,31,4],[32,1,32,4]]}
[]
[null,null,"Happiest Valley Farms",null,"Invoice"]
[null,null,"Happy plants means happy people"]
[]
[]
[]
[null,"To:","Maria Sullivan","Date:",{"$f":"TODAY()","v":"2023-09-27"}]
[null,null,"The Palm Tree Nursery","Invoice #:",100]
[null,null,"987 6th Ave","Customer ID:","AAA"]
[null,null,"Santa Fe, NM 11121"]
[null,null,"201-555-0122"]
[]
[null,"Salesperson","Job","Payment Terms","Due Date"]
[null,"Sonu Jain","Sales","Due upon receipt","TBD"]
[]
[null,"Qty","Description","Unit Price","Line Total"]
[null,{"v":20,"d":"20.00"},"Areca palm",{"v":2.5,"d":"$2.50"},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":{"v":50,"d":"$50.00"}}]
[null,{"v":35,"d":"35.00"},"Majesty palm",{"v":3,"d":"$3.00"},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":{"v":105,"d":"$105.00"}}]
[null,{"v":15,"d":"15.00"},"Bismarck palm",{"v":2.5,"d":"$2.50"},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":{"v":37.5,"d":"$37.50"}}]
[{"$nulls":4},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(InvoiceDetails[[#This Row],[Qty]]=\"\",\"\",InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit Price]]), \"\")","v":""}]
[{"$nulls":3},"Subtotal",{"$f":"IF(SUM(InvoiceDetails[Line Total])>0,SUM(InvoiceDetails[Line Total]),\"\")","v":{"v":192.5,"d":"$192.50"}}]
[{"$nulls":3},"Sales Tax"]
[{"$nulls":3},"Total",{"$f":"IF(E27=0,\"\",E27*(1+E28))","v":{"v":192.5,"d":"$192.50"}}]
[]
[null,{"$f":"\"Make all checks payable to \" & $C$2","v":"Make all checks payable to Happiest Valley Farms"}]
[null,"Thank you for your business!"]
[null,"4321 Maplewood Ave | Nashville, TN | 10105 | happiestvalley@example.com"]