{"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":8,"rows_kept":29,"merged":[[0,7,8,7],[10,4,10,5],[11,4,11,5],[25,2,25,3],[26,2,28,3]]}
[null,"Sold To",{"$nulls":5},"Invoice #:12345678910"]
[null,"Kristen Solstad"]
[null,"Ark Ceramics"]
[null,"987 6th Ave"]
[null,"Santa Fe, NM 11121"]
[null,"490-555-0155"]
[]
[null,"POTTERY & CO.\nMade from clay, everyday"]
[]
[]
[null,"SALES RECEIPT","Payment method",null,"Check no.",null,null,"Job"]
[null,{"$f":"\"Date: \" & TEXT(TODAY(),\"m/d/yyyy\")","v":"Date: 10/9/2023"},"Check",null,63576,null,null,"Ark Ceramics"]
[]
[null,null,"Qty","Item #","Description","Unit price","Discount","Line total"]
[null,null,50,354,"Earthenware plates",3,20,{"$f":"IF(SUM(C15)>0,SUM((C15*F15)-G15),\"\")","v":130}]
[null,null,75,123,"Porcelain vases",5.25,null,393.75]
[null,null,100,635,"Fire clay bowls",1.15,null,114.99999999999999]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[]
[null,null,"Thank you for your business!",{"$nulls":3},"Total discount",{"$f":"SUM(Sales[Discount])","v":{"v":20,"d":"$20.00"}}]
[null,null,"Pottery & Co.\n678 Vine Street\nCincinnati, OH 10987\n602-555-0162",{"$nulls":3},"Subtotal",{"$f":"IF(SUM(Sales[Line total])>0,SUM(Sales[Line total]),\"\")-H26","v":{"v":618.75,"d":"$618.75"}}]
[{"$nulls":6},"Sales tax"]
[{"$nulls":6},"Total",{"$f":"IF(SUM(H27)>0,SUM((H27*H28)+H27),\"\")","v":{"v":618.75,"d":"$618.75"}}]