{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Invoice","Invoice Register","Customers","Products","Setup"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"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":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[43,5,43,6],[44,5,44,6],[45,5,45,6]]}
[]
[]
[]
[]
[null,"Your Company",null,null,null,null,"DATE:","2019-05-14"]
[null,"Phone: 555-555-5555",null,null,null,null,"INVOICE:",1]
[null,"Email: YourEmailAddress@domain.com"]
[null,"Website: YourWebsiteDomain.com"]
[]
[]
[]
[null,"BILL TO:"]
[null,"COMPANY NAME",null,null,null,null,"Total Invoice:",{"$f":"H47","v":64.790000000000006}]
[null,"ADDRESS"]
[null,"CITY, STATE, ZIP"]
[]
[null,"DESCRIPTION","QUANTITY","UNIT PRICE","TAXABLE","SUB TOTAL","TAX","TOTAL"]
[null,"2x4x8 Pine",15,3.99,"a",{"$f":"IF(AND(C18<>\"\",D18<>\"\"),C18*D18,\"\")","v":59.85},{"$f":"IF(AND(F18<>\"\",E18=\"a\"),ROUND(F18*$E$45,2),IF(AND(F18<>\"\",E18<>\"a\"),0,\"\"))","v":4.9400000000000004},{"$f":"IF(G18<>\"\",F18+G18,IF(F18<>\"\",F18,\"\"))","v":64.790000000000006}]
[null,null,null,null,null,{"$f":"IF(AND(C19<>\"\",D19<>\"\"),C19*D19,\"\")","v":""},{"$f":"IF(AND(F19<>\"\",E19=\"a\"),ROUND(F19*$E$45,2),IF(AND(F19<>\"\",E19<>\"a\"),0,\"\"))","v":""},{"$f":"IF(G19<>\"\",F19+G19,IF(F19<>\"\",F19,\"\"))","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,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,"Payment can be made via YourWebsite.com",null,null,null,"Sub Total:",null,{"$f":"SUM(F18:F42)","v":59.85}]
[null,"Send payment to: Email@MyDomainWebsite.com",null,"Tax Rate:",8.2500000000000004E-2,"Tax:",null,{"$f":"SUM(G18:G42)","v":4.9400000000000004}]
[null,null,null,null,null,"Other Fees:",null,0]
[null,null,null,null,null,null,"TOTAL:",{"$f":"H44+H45+H46","v":64.790000000000006}]

{"sheet":"Invoice Register","index":1,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL BALANCE:",{"$f":"SUM(N5:N999999)","v":0}]
[null,null,"INVOICE #"]
[null,"BILLED TO","INVOICE #     ","DATE      ","INV AMOUNT       ","AMT PD 1","DATE PD 1","AMT PD 2","DATE PD 2","AMT PD 3","DATE PD 3","AMT PD 4","DATE PD 4","BALANCE","NOTES"]

{"sheet":"Customers","index":2,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"CUSTOMER ID","CUSTOMER","ADDRESS","CITY","STATE","ZIP","PHONE","FAX","EMAIL","CONTACT PERSON"]
[null,1,"John Smith","123 Smith Rd","Houston","Tx",77008,"555-555-5555",null,null,"John"]
[null,2,"Jan Doe","456 Doe Rd","Houston","Tx",77008,"555-555-5454",null,null,"Jan"]

{"sheet":"Products","index":3,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"B18","D18","B",18,"E18","C18"]
[null,"Product ID","PRODUCT","UNIT PRICE"]
[null,1,"3/4 Pine Plywood",23.99]
[null,2,"3/4 Treated Pine Plywood",48]
[null,3,"2x4x8 Pine",3.99]
[null,4,"LABOR (Per Hour)",68.989999999999995]
[null,5,"1/2 Sheetrock",19.989999999999998]
[null,6,"1/4 Pine Plywood",16.989999999999998]
[null,7,"Lump Sum Price"]
[null,8,"Rate Per Hour",90]
[null,9,"Rate Per Hour (Rush Order)",135]

{"sheet":"Setup","index":4,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Invoice Register'!C5:C999999)+1","v":1},null,"YES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,null,null,null,null,"ENTER FOLDER NAME TO SAVE TO:"]
[null,null,null,null,null,"Invoice Saves"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,"Mark All Items Taxable By Default?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,"YES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,"Add A Default Quantity Per Item",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,"YES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,"If Qnty = Yes, Select Default Qnty #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]