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

{"sheet":"Quotation","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[11,1,11,5]]}
[{"$nulls":6},"   "]
[null,"Company Address",null,null,"Date",{"$f":"TODAY()","v":"2022-01-26"}]
[null,"Street Address, City, Postcode",null,null,"Quotation #",1234]
[null,"Phone: Enter Phone number here   Fax: Enter Fax number here",null,null,"Customer ID","ABC123"]
[null,"Quotation For"]
[null,"Customer Name",null,null,"Quotation valid until:",{"$f":"F2+30","v":"2022-02-25"}]
[null,"Company Name",null,null,"Prepared by:","Name"]
[null,"Street Address, City, Postcode"]
[null,"Phone, Fax Number"]
[null,"Comments or Special Instructions"]
[]
[null,"None"]
[]
[null,"Salesperson","P.O. Number","Ship Date","F.O.B. Point","Terms"]
[{"$nulls":5},"Due on receipt"]
[]
[null,"Quantity","Description","Unit Price","Taxable?","Amount"]
[null,{"v":1234,"d":"1,234"},"Item 1",{"v":12.34,"d":"£12.34"},"Yes",{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Quantity]]=\"\",SaleItems_Table[[#This Row],[Unit Price]]=\"\"),\"\",SaleItems_Table[[#This Row],[Quantity]]*SaleItems_Table[[#This Row],[Unit Price]]),\"\")","v":{"v":15227.56,"d":"£15,227.56"}}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Quantity]]=\"\",SaleItems_Table[[#This Row],[Unit Price]]=\"\"),\"\",SaleItems_Table[[#This Row],[Quantity]]*SaleItems_Table[[#This Row],[Unit Price]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Quantity]]=\"\",SaleItems_Table[[#This Row],[Unit Price]]=\"\"),\"\",SaleItems_Table[[#This Row],[Quantity]]*SaleItems_Table[[#This Row],[Unit Price]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Quantity]]=\"\",SaleItems_Table[[#This Row],[Unit Price]]=\"\"),\"\",SaleItems_Table[[#This Row],[Quantity]]*SaleItems_Table[[#This Row],[Unit Price]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Quantity]]=\"\",SaleItems_Table[[#This Row],[Unit Price]]=\"\"),\"\",SaleItems_Table[[#This Row],[Quantity]]*SaleItems_Table[[#This Row],[Unit Price]]),\"\")","v":""}]
[]
[{"$nulls":4},"Subtotal",{"$f":"SUM(SaleItems_Table[Amount])","v":{"v":15227.56,"d":"£15,227.56"}}]
[null,"If you have any questions concerning this quotation, please contact: ",null,null,"Tax Rate",{"v":0.086,"d":"8.60%"}]
[null,"Enter your contact details",null,null,"Sales Tax",{"$f":"IFERROR(Tax_Rate*SUMIF(SaleItems_Table[Taxable?],\"Yes\",SaleItems_Table[Amount]), \"\")","v":{"v":1309.5701599999998,"d":"£1,309.57"}}]
[{"$nulls":4},"Other"]
[null,"Thank you for your business!",null,null,"TOTAL",{"$f":"SUM(F24:F27)","v":{"v":16537.21616,"d":"£16,537.22"}}]