{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Start","Service invoice"],"not_rendered":{"images":2,"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 Service invoice."]
[null,"Fill in Invoice number, Date, Company name, Address, Slogan and Bill to details."]
[null,"Enter information 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 colour."]
[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":43,"n_cols":5,"rows_kept":43,"merged":[[0,1,0,2],[0,3,0,4],[1,1,1,4],[2,1,2,3],[3,1,3,3],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[41,1,41,2],[41,3,41,4],[42,1,42,4]]}
["Create a Service invoice in this worksheet. Enter Company logo in cell to the right and title of this worksheet in cell D1. Helpful instructions on how to use this worksheet are in the cells in this column. Next instruction is in cell A3.","Logo placeholder is in this cell.",null,"INVOICE"]
[]
["Enter Company name in cell to the right.","Your Company Name"]
["Enter Company slogan in cell to the right.","Your company slogan"]
["Enter Company street address in cell to the right and Invoice number in cell E5.","Street address",null,"INVOICE NO.","No."]
["Enter City, County/Region and Postcode in cell to the right, and Date in cell E6.","City, County/Region, Postcode",null,"DATE ",{"$f":"TODAY()","v":"2019-04-18"}]
["Enter Phone and Fax numbers in cell to the right and ID in cell E7.","Phone Fax",null,"CUSTOMER ID ","ID"]
["Enter Email address in cell to the right.","Email"]
["To label is in cell to the right. Enter bill To details such as Name, Company name, Address, and Phone number in cells C9 to C13. Next instruction is in cell A14.","TO","Name"]
[null,null,"Company name"]
[null,null,"Street address"]
[null,null,"City, County/Region, Postcode"]
[null,null,"Phone"]
["Enter information in Sales details table starting in cell to the right. Next instruction is in cell A17.","SALESPERSON","JOB","PAYMENT TERMS","DUE DATE"]
[{"$nulls":3},"Due upon receipt"]
[]
["Enter information in Invoice table starting in cell to the right. Subtotal and Total are auto-calculated. Next instruction is in cell A42.","QUANTITY","DESCRIPTION","UNIT PRICE","LINE TOTAL"]
[{"$nulls":4},{"$f":"IF(SUM(B18)>0,SUM(B18*'Service invoice'!$D18),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B19)>0,SUM(B19*'Service invoice'!$D19),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B20)>0,SUM(B20*'Service invoice'!$D20),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B21)>0,SUM(B21*'Service invoice'!$D21),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B22)>0,SUM(B22*'Service invoice'!$D22),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B23)>0,SUM(B23*'Service invoice'!$D23),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B24)>0,SUM(B24*'Service invoice'!$D24),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B25)>0,SUM(B25*'Service invoice'!$D25),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B26)>0,SUM(B26*'Service invoice'!$D26),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B27)>0,SUM(B27*'Service invoice'!$D27),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B28)>0,SUM(B28*'Service invoice'!$D28),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B29)>0,SUM(B29*'Service invoice'!$D29),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B30)>0,SUM(B30*'Service invoice'!$D30),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B31)>0,SUM(B31*'Service invoice'!$D31),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B32)>0,SUM(B32*'Service invoice'!$D32),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B33)>0,SUM(B33*'Service invoice'!$D33),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B34)>0,SUM(B34*'Service invoice'!$D34),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B35)>0,SUM(B35*'Service invoice'!$D35),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B36)>0,SUM(B36*'Service invoice'!$D36),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B37)>0,SUM(B37*'Service invoice'!$D37),\"\")","v":""}]
[{"$nulls":3},"SUBTOTAL",{"$f":"IF(SUM(E18:E37)>0,SUM(E18:E37),\"\")","v":""}]
[{"$nulls":3},"VAT"]
[{"$nulls":3},"TOTAL",{"$f":"IF(SUM(E38)>0,SUM((E38*E39)+E38),\"\")","v":""}]
[]
["Company name is auto-updated in cell D42.","Make all cheques payable to",null,{"$f":"B3","v":"Your Company Name"}]
["Thank-you message is in cell to the right.","THANK YOU FOR YOUR BUSINESS."]