{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Quotation"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Quotation","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"merged":[[1,3,4,5],[25,3,25,5],[26,3,26,5],[27,3,27,5],[29,3,30,4],[29,5,29,6],[30,5,30,6]]}
[]
[{"$nulls":3},"QUOTATION",{"$nulls":3},"Date",{"$f":"TODAY()","v":"2022-12-15"}]
[{"$nulls":7},"Quotation #",100]
[{"$nulls":7},"Customer ID","ABC123"]
[]
[{"$nulls":3},"Contoso Pharmaceuticals ",null,"Quotation for:"]
[]
[{"$nulls":3},"123 Ave. A",null,"Nathan Rigby"]
[{"$nulls":3},"Metropolis, USA 54321",null,"Kind Dental"]
[{"$nulls":3},"Phone: (123) 456-7890 ",null,"456 Anyroad"]
[{"$nulls":3},"Fax: (123) 456-7891",null,"Anywhere, USA 12345"]
[{"$nulls":5},"(000) 123-4567"]
[]
[]
[{"$nulls":3},"Salesperson","P.O. Number","Ship Date","Ship Via","F.O.B. Point","Terms"]
[{"$nulls":3},"Robin Zupanc",657,"2023-01-13","Air express","Warehouse","Due on receipt"]
[]
[{"$nulls":3},"Quantity","Description"," ","Unit Price","Taxable?","Amount"]
[{"$nulls":3},34,"Anesthesia masks",null,{"v":44,"d":"$44.00"},"T",{"$f":"IFERROR(IF(D19,D19*G19,\"\"), \"\")","v":{"v":1496,"d":"$1,496.00"}}]
[{"$nulls":8},{"$f":"IFERROR(IF(D20,D20*G20,\"\"), \"\")","v":""}]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":7},"Subtotal",{"$f":"SUBTOTAL(109,Quotation[Amount])","v":{"v":1496,"d":"$1,496.00"}}]
[{"$nulls":7},"Tax Rate",{"v":0.086,"d":"8.60%"}]
[{"$nulls":3},"If you have any questions concerning this quotation contact Robin:",{"$nulls":3},"Sales Tax",{"$f":"IFERROR(I25*SUMIF(H19:H23,\"T\",I19:I23), \"\")","v":{"v":128.65599999999998,"d":"$128.66"}}]
[{"$nulls":3},"(123) 456-7890 or contoso@example.com.",{"$nulls":3},"Other",0]
[{"$nulls":7},"Total",{"$f":"IFERROR(Quotation[[#Totals],[Amount]]+I26+I27, \"\")","v":{"v":1624.656,"d":"$1,624.66"}}]
[]
[{"$nulls":3},"Thank you!"]