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

{"sheet":"Sales Receipt","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[0,1,1,3],[0,5,1,6],[8,1,8,2],[9,1,9,2],[25,1,25,3],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[33,1,33,3]]}
[null,"MODERN DESIGN CO.",{"$nulls":3},"SALES RECEIPT"]
[]
[null,"ELEGANT SOLUTIONS FOR THE MODERN ARTIST"]
[null,"BILL TO",null,"INVOICE NO.","DATE"]
[null,"Saara Teinemaa",null,"XYZ123","01/01/XX"]
[null,"COMPANY",null,"ADDRESS","PHONE"]
[null,"Create & Co.",null,"321 Sycamore","(415) 555-0123"]
[{"$nulls":3},"Albany, NY 12345","(415) 555-0124"]
[null,"PAYMENT METHOD",null,"CHECK NO.","JOB"]
[null,"Wire transfer",null,987654,"Design studio shoot"]
[]
[null,"QUANTITY","ITEM NO.","DESCRIPTION","UNIT PRICE","DISCOUNT","LINE TOTAL"]
[null,3,"N/A","Photo shoot (in hours)",{"v":100,"d":"$100.00"},{"v":0.1,"d":"10%"},{"$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":{"v":270,"d":"$270.00"}}]
[null,1,100,"Thumb drive of photos",{"v":45,"d":"$45.00"},null,{"$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":{"v":45,"d":"$45.00"}}]
[null,2.5,"N/A","Edits (in hours)",{"v":35,"d":"$35.00"},null,{"$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":{"v":87.5,"d":"$87.50"}}]
[{"$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":""}]
[]
[null,"IF YOU HAVE ANY QUESTIONS CONCERNING THIS INVOICE, USE THE FOLLOWING CONTACT INFORMATION:",null,null,"TOTAL DISCOUNT"]
[null,"Nathan Rigby | (123) 456-7890 | nathan@example.com",null,null,"SUBTOTAL",null,{"$f":"SUM(Table_SalesReceiptDetails[LINE TOTAL])","v":{"v":402.5,"d":"$402.50"}}]
[{"$nulls":4},"SALES TAX",null,{"v":0.06,"d":"6.00%"}]
[null,"THANK YOU FOR YOUR BUSINESS!",null,null,"TOTAL",null,{"$f":"(G27-(G27*G26))*(1+G28)","v":{"v":426.65000000000003,"d":"$426.65"}}]