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

{"sheet":"Sales receipt","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[7,1,7,2],[7,4,7,6],[8,1,8,2],[8,4,8,6]]}
[{"$nulls":7}," "]
[null,"Sold to","Name",null,null,"Invoice No.","Invoice number"]
[null,null,"Company name",null,null,"Date","Invoice date"]
[null,null,"Street address"]
[null,null,"City, County/Region, Postcode"]
[null,null,"Phone | Fax"]
[]
[null,"Payment method",null,"Cheque No.","Job"]
[]
[]
[null,"Quantity","Item No.","Description","Unit price","Discount","Line total"]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[Quantity]]=\"\",Table_SalesReceiptDetails[[#This Row],[Unit price]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[Quantity]]*(1-Table_SalesReceiptDetails[[#This Row],[Discount]])*Table_SalesReceiptDetails[[#This Row],[Unit price]]),\"\")","v":""}]
[]
[{"$nulls":5},"Total discount"]
[null,"If you have any questions concerning this invoice, use the following contact information:",{"$nulls":3},"Subtotal",{"$f":"SUM(Table_SalesReceiptDetails[Line total])","v":{"v":0,"d":"£0.00"}}]
[null,"Contact name, Phone number, Email address",{"$nulls":3},"VAT",{"v":0,"d":"0.00%"}]
[null,"Thank you for your business!",{"$nulls":3},"Total",{"$f":"(G26-(G26*G25))*(1+G27)","v":{"v":0,"d":"£0.00"}}]