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

{"sheet":"Service invoice","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"merged":[[2,2,3,3],[33,4,33,5],[35,4,37,7]]}
[]
[]
[null,null,"THE HAPPY TOOTH"]
[{"$nulls":5},"Invoice #5465"]
[null,null,"Make all checks payable to Utu Linna",null,null,{"$f":"TODAY()","v":"2023-09-27"}]
[]
[]
[]
[null,null,"TO","CUSTOMER ID","ADDRESS","PHONE"]
[]
[null,null,"Utu Linna\nKendall Collins DDS","ABK967","234 5th Ave\nMadison, WI 12131","640-555-0146"]
[]
[]
[null,null,"SALESPERSON","JOB","PAYMENT TERMS","DUE DATE"]
[]
[null,null,"Jane","Dental Instrument \nResupply","Due upon receipt"]
[]
[]
[null,null,"QTY","DESCRIPTION","UNIT PRICE","LINE TOTAL"]
[{"$nulls":5},{"$f":"IF(Items[[#This Row],[QTY]]=\"\",\"\",Items[[#This Row],[QTY]]*Items[[#This Row],[UNIT PRICE]])","v":""}]
[null,null,100,"Mouth mirror",{"v":0.25,"d":"$0.25"},{"$f":"IF(Items[[#This Row],[QTY]]=\"\",\"\",Items[[#This Row],[QTY]]*Items[[#This Row],[UNIT PRICE]])","v":{"v":25,"d":"$25.00"}}]
[null,null,6,"Dental drill",{"v":645.23,"d":"$645.23"},{"$f":"IF(Items[[#This Row],[QTY]]=\"\",\"\",Items[[#This Row],[QTY]]*Items[[#This Row],[UNIT PRICE]])","v":{"v":3871.38,"d":"$3,871.38"}}]
[null,null,100,"Curette",{"v":0.12,"d":"$0.12"},{"$f":"IF(Items[[#This Row],[QTY]]=\"\",\"\",Items[[#This Row],[QTY]]*Items[[#This Row],[UNIT PRICE]])","v":{"v":12,"d":"$12.00"}}]
[null,null,25,"Syringe",{"v":1.33,"d":"$1.33"},{"$f":"IF(Items[[#This Row],[QTY]]=\"\",\"\",Items[[#This Row],[QTY]]*Items[[#This Row],[UNIT PRICE]])","v":{"v":33.25,"d":"$33.25"}}]
[null,null,100,"Periodontal probe",{"v":0.22,"d":"$0.22"},{"$f":"IF(Items[[#This Row],[QTY]]=\"\",\"\",Items[[#This Row],[QTY]]*Items[[#This Row],[UNIT PRICE]])","v":{"v":22,"d":"$22.00"}}]
[{"$nulls":5},{"$f":"IF(Items[[#This Row],[QTY]]=\"\",\"\",Items[[#This Row],[QTY]]*Items[[#This Row],[UNIT PRICE]])","v":""}]
[]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(Items[LINE TOTAL])","v":{"v":3963.63,"d":"$3,963.63"}}]
[]
[{"$nulls":4},"SALES TAX",{"v":0.06,"d":"6.0%"}]
[]
[{"$nulls":4},"TOTAL",{"$f":"F28*(1+F30)","v":{"v":4201.4478,"d":"$4,201.45"}}]
[]
[]
[]
[null,null,"236-555-0126",null,"THANK YOU"]
[null,null,"happytooth@example.com"]
[null,null,"4321 Maplewood Ave| Nashville, TN 13141"]