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

{"sheet":"Sales invoice","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[1,1,3,3],[11,5,11,7],[12,5,13,7],[13,2,13,3],[23,1,25,4],[28,7,28,8],[30,1,30,7]]}
[]
[null,"INVOICE"]
[{"$nulls":5},"Shadow Beauty"]
[{"$nulls":5},"Be Uniquely You"]
[]
[]
[null,"To Jenns Martennson",{"$nulls":3},"Date:",{"$f":"TODAY()","v":"2023-09-14"}]
[null,"Central Beauty",{"$nulls":3},"Invoice #:",54167]
[null,"916-555-0123",{"$nulls":3},"Customer ID:","BKO6948"]
[]
[]
[null,"Shipping Address:",{"$nulls":3},"Make all checks payable to Shadow Beauty"]
[null,"321 Sycamore, Albany, NY 34567",{"$nulls":3},"Street Address, City, ST  ZIP Code,  Phone,  Fax,  E-mail"]
[]
[null,"Salesperson","Job","Shipping method","Shipping terms","Delivery date","Payment terms","Due date"]
[null,"Kendall Collins","Sales","Air express","N/A",{"$f":"TODAY()","v":"2023-09-14"},"On delivery",{"$f":"'Sales invoice'!$F16+7","v":"2023-09-21"}]
[]
[null,"Qty","Item #","Description","Custom column","Unit price","Discount","Line total"]
[null,50,2452,"Liquid foundation","Assorted shades",2.75,{"v":0,"d":"0.00"},{"$f":"IF(Items[[#This Row],[Qty]]=\"\",\"\",Items[[#This Row],[Qty]]*Items[[#This Row],[Unit price]]-Items[[#This Row],[Discount]])","v":{"v":137.5,"d":"137.50"}}]
[null,30,6235,"Eyeshadow palette","Assorted shades",1.24,{"v":0,"d":"0.00"},{"$f":"IF(Items[[#This Row],[Qty]]=\"\",\"\",Items[[#This Row],[Qty]]*Items[[#This Row],[Unit price]]-Items[[#This Row],[Discount]])","v":{"v":37.2,"d":"37.20"}}]
[null,100,425,"Lipstick","Assorted shades",0.75,0.25,{"$f":"IF(Items[[#This Row],[Qty]]=\"\",\"\",Items[[#This Row],[Qty]]*Items[[#This Row],[Unit price]]-Items[[#This Row],[Discount]])","v":74.75}]
[null,20,2562,"Makeup brush set","Assorted sizes",3.23,0.15,{"$f":"IF(Items[[#This Row],[Qty]]=\"\",\"\",Items[[#This Row],[Qty]]*Items[[#This Row],[Unit price]]-Items[[#This Row],[Discount]])","v":{"v":64.44999999999999,"d":"64.45"}}]
[]
[{"$nulls":6},"Total Discount",{"$f":"IF(SUM(Items[Discount])>0,SUM(Items[Discount]),\"\")","v":{"v":0.4,"d":"$0.40"}}]
[{"$nulls":6},"Subtotal",{"$f":"IF(SUM(Items[Line total])>0,SUM(Items[Line total]),\"\")","v":{"v":313.9,"d":"$313.90"}}]
[{"$nulls":6},"Sales tax",{"v":0,"d":"$0.00"}]
[]
[]
[{"$nulls":6},"Total",{"$f":"IF(SUM(H25)>0,SUM((H25*H26)+H25),\"\")","v":{"v":313.9,"d":"$313.90"}}]
[]
[null,"Thank you for your business!"]