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

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this template to create a sales invoice."]
[null,"Fill in basic information like your company name, bill to, and ship to details."]
[null,"Enter invoice details in tables."]
[null,"Total is auto-calculated for you."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in SERVICE INVOICE worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font color."]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"Service invoice","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"merged":[[3,6,6,8],[40,2,40,8],[41,2,41,8],[43,2,43,8]]}
[]
[]
[]
[{"$nulls":6},"INVOICE"]
[null,null,"INVOICE NO.","DATE","CUSTOMER ID"]
[null,null,1111,"2022-11-18","440F"]
[]
[]
[]
[{"$nulls":4},"SAND + POLISH CONTRACTORS",null,null,"BILL TO","SHIP TO"]
[{"$nulls":4},"World's finest finishing touches",null,null,"Ashley Schroeder","Ashley Schroeder"]
[{"$nulls":4},"123 45th Ave.",null,null,"The Rosehip Hotel","The Rosehip Hotel"]
[{"$nulls":4},"Chicago, IL 67890",null,null,"12 3rd St.","12 3rd St."]
[{"$nulls":4},"(987) 654-3210",null,null,"Boston, MA 12345","Boston, MA 12345"]
[{"$nulls":4},"sand@example.com",null,null,"(123) 456-7890","(123) 456-7890"]
[]
[null,null,"SALESPERSON","JOB","SHIPPING METHOD","SHIPPING TERMS","DELIVERY DATE","PAYMENT TERMS","DUE DATE"]
[null,null,"Danielle Brasseur",null,"N/A","FRAGILE","2022-12-01","Due upon receipt","2022-12-01"]
[null,null,"QTY","ITEM #","DESCRIPTION","Blank column","UNIT PRICE","DISCOUNT","LINE TOTAL"]
[null,null,12,"af709qa","Custom ceiling fans",null,200,{"v":0.12,"d":"12%"},{"$f":"IF(SUM(C20)>0,SUM(C20*G20-H20),\"\")","v":2399.88}]
[{"$nulls":8},{"$f":"IF(SUM(C21)>0,SUM(C21*G21-H21),\"\")","v":""}]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":6},"TOTAL DISCOUNT",{"$f":"IF(SUM(H20:H34)>0,SUM(H20:H34),\"\")","v":0.12}]
[{"$nulls":7},"SUBTOTAL",{"$f":"IF(SUM(I20:I34)>0,SUM(I20:I34),\"\")","v":2399.88}]
[{"$nulls":7},"SALES TAX %",0.05]
[{"$nulls":7},"TOTAL",{"$f":"IF(SUM(I36)>0,SUM((I36*I37)+I36),\"\")","v":2519.8740000000003}]
[]
[]
[null,null,"Make all checks payable to"]
[null,null,{"$f":"E10","v":"SAND + POLISH CONTRACTORS"}]
[]
[null,null,"THANK YOU FOR YOUR BUSINESS!"]