{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Start","Sales Invoice"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this template to create a Sales Invoice with simple lines design."]
[null,"Fill in basic information like Company Name, Bill To, and Ship 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 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":"Sales Invoice","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,1,3,3],[13,1,13,7],[42,1,42,7],[39,1,39,7],[1,1,1,2],[1,3,1,7],[40,1,40,4],[40,5,40,7],[41,1,41,7],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[2,1,2,3]]}
["Create a Sales Invoice in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Enter Company Logo in cell at right. Title of this worksheet is in cell D2.","Logo placeholder is in this cell.",null,"Invoice"]
["Enter Company Name in cell at right and Date in cell H3.","Your Company Name",null,null,null,null,"Date:",{"$f":"TODAY()","v":"2019-03-04"}]
["Enter Company Slogan in cell at right and Invoice number in cell H4."," Your Company Slogan Here",null,null,null,null,"Invoice #:","No."]
["Enter Customer ID in cell H5.",null,null,null,null,null,"Customer ID:","ID"]
["To label is in cell at right and Ship to label in cell E6. Enter bill To details such as Name, Company Name, Address, and Phone number in cells C6 through C10, and Ship To details in cells F6 through F10. Next instruction is in cell A12.","To:","Name",null,"Ship to:","Name"]
[null,null,"Company Name",null,null,"Company Name"]
[null,null,"Street Address",null,null,"Street Address"]
[null,null,"City, ST  ZIP Code",null,null,"City, ST  ZIP Code"]
[null,null,"Phone",null,null,"Phone"]
[]
["Enter information in Sales Information table starting in cell at right. Next instruction is in cell A15.","Salesperson","Job","Shipping Method","Shipping Terms","Delivery Date","Payment Terms","Due Date"]
[]
[]
["Enter information in Invoice table starting in cell at right. Total Discount, Subtotal, and Total are auto calculated. Next instruction is in cell A41.","Qty","Item #","Description","Custom column","Unit Price","Discount","Line Total"]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(B16)>0,SUM((B16*F16)-G16),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(B17)>0,SUM((B17*F17)-G17),\"\")","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(B22)>0,SUM((B22*F22)-G22),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(B23)>0,SUM((B23*F23)-G23),\"\")","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Total Discount",{"$f":"IF(SUM(G16:G35)>0,SUM(G16:G35),\"\")","v":""}]
[null,null,null,null,null,null,"Subtotal",{"$f":"IF(SUM(H16:H35)>0,SUM(H16:H35),\"\")","v":""}]
[null,null,null,null,null,null,"Sales Tax"]
[null,null,null,null,null,null,"Total",{"$f":"IF(SUM(H37)>0,SUM((H37*H38)+H37),\"\")","v":""}]
[]
["Company Name is auto updated in cell F41.","Make all checks payable to ",null,null,null,{"$f":"B3","v":"Your Company Name"}]
["Thank You message is in cell at right.","Thank you for your business!"]
["Enter Company Street Address, City, State, ZIP Code, Phone and Fax numbers, and E-mail address in cell at right.","Street Address, City, ST  ZIP Code,  Phone,  Fax,  E-mail"]