{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Invoice","Archive","Setup","ArchiveLines","Help"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":41,"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":"Invoice","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,32,5]]}
[]
[null,{"$f":"SetupCompany","v":"[Company Name]"},null,null,"INVOICE"]
[null,{"$f":"SetupAddress","v":"[Your Address]"}]
[null,{"$f":"SetupAddress2","v":"[Your Address 2]"},null,null,"Invoice Number:","AA00001"]
[null,{"$f":"SetupAddress3","v":"[Your Address 3]"},null,null,"Invoice Date:","15/03/2016"]
[null,{"$f":"SetupPostcode","v":"[Your Postcode]"}]
[null,{"$f":"SetupPhone","v":"[Your Phone number]"}]
[null,{"$f":"SetupTaxNumber","v":"[VAT number]"}]
[]
[null,"Invoice To:",null,"Ship To:"]
[null,"[Person name]",null,"[Person name]"]
[null,"[Company name]",null,"[Company name]"]
[null,"[Company address 1]",null,"[Company address 1]"]
[null,"[Company address 2]",null,"[Company address 2]"]
[null,"[Company address 3]",null,"[Company address 3]"]
[null,"[Company Postcode]",null,"[Company Postcode]"]
[]
[]
[null,"Description","Quantity","Unit Cost (excl. VAT)","VAT %","Total \n(excl. VAT)"]
[null,null,null,null,{"$f":"VATPercentage","v":0.2},{"$f":"D20*C20","v":0}]
[null,null,null,null,{"$f":"VATPercentage","v":0.2},{"$f":"D21*C21","v":0}]
[null,null,null,null,{"$f":"VATPercentage","v":0.2},{"$f":"D22*C22","v":0}]
[null,null,null,null,{"$f":"VATPercentage","v":0.2},{"$f":"D23*C23","v":0}]
[null,null,null,null,""]
[null,null,null,null,"Total (excl. VAT)",{"$f":"SUM(DataEntryTotalExclVAT)","v":0}]
[null,null,null,null,"Total VAT",{"$f":"SUMPRODUCT(DataEntryTotalExclVAT,DataEntryVAT)","v":0}]
[]
[null,null,null,null,"Total (inc. VAT)",{"$f":"TotalExclVAT+VAT","v":0}]
[]
[null,{"$f":"SetupComments","v":"Please make cheques payable to [company name] If you have any questions concerning this invoice, contact [name] on [number] / [email address]Thank you for your business"}]

{"sheet":"Archive","index":1,"n_rows":1,"n_cols":32,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Invoice Number","Invoice Date","Company Name","Company Address 1","Company Address 2","Company Address 3","Company Postcode","Company Phone","Company VAT","Invoice To Person","Invoice To Company","Invoice To Address 1","Invoice To Address 2","Invoice To Address 3","Invoice To Postcode","Ship To Person","Ship To Company","Ship To Address 1","Ship To Address 2","Ship To Address 3","Ship To Postcode","Total Excl. VAT","VAT","Total Inc. VAT","Comments","Status","Amount Paid","Amount to Pay",null,null,null,{"$f":"Invoice!F4","v":"AA00001"}]

{"sheet":"Setup","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Invoice number prefix","AA"]
[null,"Invoice number starting figure",1]
[]
[null,"VAT Percentage to apply",0.2]
[]
[]
[]
[null,"Your company name","[Company Name]"]
[null,"Your Address","[Your Address]"]
[null,"Your Address 2","[Your Address 2]"]
[null,"Your Address 3","[Your Address 3]"]
[null,"Your Postcode","[Your Postcode]"]
[null,"Your Phone number","[Your Phone number]"]
[null,"VAT number","[VAT number]"]
[]
[null,"Comments (shown at the bottom of the invoice)","Please make cheques payable to [company name] If you have any questions concerning this invoice, contact [name] on [number] / [email address]Thank you for your business"]

{"sheet":"ArchiveLines","index":3,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Invoice Number","Description","Quantity","Unit Cost (excl. VAT)","VAT %","Total \n(excl. VAT)"]

{"sheet":"Help","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Invoice v1.0"]
[]
[]
[]
[null,null,"This free Excel tool was brought to you by:"]
[null,null,"http://www.excel-macros.co.uk/"]
[]
[null,null,"There is a short training video available on YouTube which explains how to use it: "]
[]
[null,null,"https://www.youtube.com/channel/UCvEnfhjNXvtVf9g9pAczbqQ"]
[]
[]
[null,null,"We really hope you enjoy using this tool and get great benefit from it."]
[]
[]
[null,null,"If you need any help or advice please contact us on:"]
[]
[null,null,"Great@Excel-Macros.co.uk"]