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

{"sheet":"Sales invoice","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[6,2,6,3],[7,2,7,3],[11,2,11,3],[12,2,12,3],[30,1,30,3],[30,4,30,6],[31,1,31,6]]}
[]
[null,"INVOICE"]
[]
[null,"SHADOW BEAUTY",null,null,"Make all checks payable to"]
[null,"Be uniquely you",null,null,"Street Address, City, State, Zip Code"]
[]
[null,"TO","Jens Martensson",null,"DATE",{"$f":"TODAY()","v":"2023-09-14"}]
[null,null,"Central Beauty"]
[]
[]
[]
[null,"CUSTOMER ID","BK06948",null,"SHIP TO","321 Sycamore, Albany, NY 34567"]
[null,"INVOICE #",54167,null,"PHONE NUMBER","916-555-0123"]
[]
[]
[null,"SALESPERSON","JOB","SHIPPING METHOD","DELIVERY DATE","PAYMENT TERMS","DUE DATE"]
[null,"Kendall Collins","Sales","Air express",{"$f":"F7","v":"2023-09-14"},"On Delivery",{"$f":"F7+30","v":"2023-10-14"}]
[]
[null,"QTY","ITEM #","DESCRIPTION","UNIT PRICE","DISCOUNT","LINE TOTAL"]
[null,50,2452,"Liquid foundation",{"v":2.75,"d":"$2.75"},{"v":0,"d":"$0.00"},{"$f":"IF(SUM(B20)>0,SUM((B20*E20)-F20),\"\")","v":{"v":137.5,"d":"$137.50"}}]
[null,30,6235,"Eyeshadow palette",{"v":1.24,"d":"$1.24"},{"v":0,"d":"$0.00"},{"$f":"IF(SUM(B21)>0,SUM((B21*E21)-F21),\"\")","v":{"v":37.2,"d":"$37.20"}}]
[null,100,425,"Lipstick",{"v":0.75,"d":"$0.75"},{"v":0.25,"d":"$0.25"},{"$f":"IF(SUM(B22)>0,SUM((B22*E22)-F22),\"\")","v":{"v":74.75,"d":"$74.75"}}]
[null,20,2562,"Makeup brush set",{"v":3.23,"d":"$3.23"},{"v":0.15,"d":"$0.15"},{"$f":"IF(SUM(B23)>0,SUM((B23*E23)-F23),\"\")","v":{"v":64.44999999999999,"d":"$64.45"}}]
[]
[{"$nulls":5},"TOTAL DISCOUNT",{"$f":"SUM(Items[DISCOUNT])","v":{"v":0.4,"d":"$0.40"}}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUM(Items[LINE TOTAL])","v":{"v":313.9,"d":"$313.90"}}]
[{"$nulls":5},"SALES TAX",{"v":0,"d":"$0.00"}]
[]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G26:G27)","v":{"v":313.9,"d":"$313.90"}}]
[]
[]
[null,"THANK YOU FOR YOUR BUSINESS"]