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

{"sheet":"Quotation","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[14,1,14,5]]}
[]
[null,"QUOTATION"]
[null,"Noa Vidal Designs",{"$nulls":4},"   "]
[null,"Jewelry as unique as you are"]
[null,"Company Address",null,null,"Date",{"$f":"TODAY()","v":"2022-12-15"}]
[null,"123 Main St. Seattle, WA 12345",null,null,"Quotation #",1234]
[null,"Phone: (123) 456-7890   Fax: (123) 456-7891",null,null,"Customer ID","ABC123"]
[null,"Quotation For"]
[null,"Chetana Hegde",null,null,"Quotation valid until",{"$f":"F5+30","v":"2023-01-14"}]
[null,"14K Jewels",null,null,"Prepared by","Sam"]
[null,"321 Sycamore St. Albany, NY 54321"]
[null,"(000) 123-4567"]
[null,"Comments or Special Instructions"]
[]
[null,"None"]
[]
[null,"Salesperson","P.O. Number","Ship Date","F.O.B. Point","Terms"]
[null,"Sam",1000985,"2023-01-10","Shipping dock","Due on receipt"]
[]
[null,"Quantity","Description","Unit Price","Taxable?","Amount"]
[null,{"v":120,"d":"120 "},"Fine gold chains",{"v":33.3,"d":"$33.30"},"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":3995.9999999999995,"d":"$3,996.00"}}]
[{"$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":3995.9999999999995,"d":"$3,996.00"}}]
[null,"If you have any questions concerning this quotation, please contact: ",null,null,"Tax Rate",{"v":0.086,"d":"8.60%"}]
[null,"Sam at (123) 456-7890.",null,null,"Sales Tax",{"$f":"IFERROR(Tax_Rate*SUMIF(SaleItems_Table[Taxable?],\"Yes\",SaleItems_Table[Amount]), \"\")","v":{"v":343.65599999999995,"d":"$343.66"}}]
[{"$nulls":4},"Other"]
[null,"Thank you for your business!",null,null,"TOTAL",{"$f":"SUM(F27:F30)","v":{"v":4339.741999999999,"d":"$4,339.74"}}]