{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Start","Sales 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 simple Sales invoice."]
[null,"Fill in basic information such as Company name, Bill to and Dispatch to details."]
[null,"Enter details in tables."]
[null,"Total is auto-calculated for you."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in SALES 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, then select ALTERNATIVE TEXT."]

{"sheet":"Sales invoice","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"merged":[[1,1,1,3],[1,4,1,7],[2,1,2,4],[2,5,2,6],[3,1,4,4],[3,5,3,6],[4,5,4,6],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6],[7,2,7,3],[7,5,7,6],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[13,1,13,7],[40,1,40,7],[41,1,41,3],[41,4,41,7],[42,1,42,7],[43,1,43,7]]}
["Create a simple Sales invoice in this worksheet. Helpful instructions on how to use this worksheet are in the cells in this column. Arrow down to get started."]
["Enter Company logo in cell to the right. Title of this worksheet is in cell E2.","Logo placeholder is in this cell.",null,null,"Invoice"]
["Enter Company name in cell to the right and Date in cell H3.","Your Company Name",{"$nulls":3},"Date:",null,{"$f":"TODAY()","v":"2019-05-06"}]
["Enter Company slogan in cell to the right and Invoice number in cell H4."," Your Company Slogan Here",{"$nulls":3},"Invoice no.:",null,"No."]
["Enter Customer ID in cell H5.",{"$nulls":4},"Customer ID:",null,"ID"]
["To label is in cell to the right and Ship-to label in cell E6. Enter Bill to details such as Name, Company name, Address and Phone number in cells C6 to C10, and Ship to details in cells F6 to F10. Next instruction is in cell A12.","To:","Name",null,"Deliver to:","Name"]
[null,null,"Company name",null,null,"Company name"]
[null,null,"Street address",null,null,"Street address"]
[null,null,"City, County/Region, Postcode",null,null,"City, County/Region, Postcode"]
[null,null,"Phone number",null,null,"Phone number"]
[]
["Enter information in Sales details table starting in cell to the right. Next instruction is in cell A15.","Salesperson","Job","Delivery method","Delivery Terms","Delivery date","Payment Terms","Due date"]
[]
[]
["Enter information in Invoice table starting in cell to the right. Total Discount, Subtotal and Total are auto-calculated at the end. Next instruction is in cell A42.","Qty","Item no.","Description","Custom column","Unit price","Discount","Line total"]
[{"$nulls":7},{"$f":"IF(SUM(B16)>0,SUM((B16*F16)-G16),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(SUM(B17)>0,SUM((B17*F17)-G17),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF(SUM(B34)>0,SUM((B34*F34)-G34),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":5},"Total discount",{"$f":"IF(SUM(G16:G36)>0,SUM(G16:G36),\"\")","v":""}]
[{"$nulls":6},"Subtotal",{"$f":"IF(SUM(H16:H36)>0,SUM(H16:H36),\"\")","v":""}]
[{"$nulls":6},"VAT"]
[{"$nulls":6},"Total",{"$f":"IF(SUM(H38)>0,SUM((H38*H39)+H38),\"\")","v":""}]
[]
["Company Name is auto-updated in cell E42.","Make all cheques payable to",null,null,{"$f":"B3","v":"Your Company Name"}]
["Thank-you message is in cell to the right.","Thank you for your business."]
["Enter Company street address, City, County/Region, Postcode, Phone and Fax numbers, and Email address in cell to the right.","Street Address, City, County/Region, Postcode, Phone number, Fax number, Email address"]