{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Documentation","Customers","Products","Invoice Form","Invoice List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":"Documentation","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Invoice with Macros & Simple Database"]
[]
[null,"Procedure:"]
[null,"1. Add customers to the customer list."]
[null,"2. Add products to the product list."]
[null,"3. Create an invoice by selecting customer & products"]
[null,"4. Save and print or create a PDF file"]
[]
[null,"Description"]
[null,"Worksheet","Function"]
[null,"Customers","Lists customers"]
[null,"Products","Lists products available"]
[null,"Invoice Form","Create an invoice"]
[null,"Invoice List","Lists the invoices created"]
[]
[null,"Created by: Tech Help Today, www.techhelptoday.com"]

{"sheet":"Customers","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Customer List"]
[]
["Add customers and alphabetize by Cust ID."]
[]
["Cust ID","Last Name","First Name","Street","City","State","Zip","Email","Phone"]
["AmesA","Ames","Alicia","1 Adams Ave.","Akron","OH","05321"]
["Bains","Bains","Burt","2 Brown Blvd.","Bridgeport","CT","06845","bbains374@aol.com"]
["CrainC","Crain","Carla","3 Cain Ct.","Cos Cob","CT","06823"]
["Doe","Doe","Don","4 Dowd Dr.","Denver","CO","03456"]
["EwenE","Ewen","Eve","5 Elm St.","Eaton","Co","02591"]

{"sheet":"Products","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Product List"]
[]
["Add products and alphabetize by Product ID."]
[]
["Product ID","Product","Price"]
["Cheeri12oz","Cheerios, 12 oz.",3.87]
["OreoReg12oz","Oreos, Regular, 12 oz. pckg.",3.49]
["TropicOJ56oz","Tropicana Orange Juice, 56 oz.",4.24]
["LayPotChRg6oz","Lays Potato Chips, 6 oz.",3.58]
["Coke12oz6pk","Coca Cola, 12 oz can, 6-pack",4.9800000000000004]
["BumBTuna5.3oz","Bumble Bee Prem. Tuna, 5 oz.",3.11]

{"sheet":"Invoice Form","index":3,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,3,26,4],[28,3,28,4]]}
["Invoice",null,null,null,"[logo]"]
[]
["[Company Name]",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(E8,tblInvoiceList[Invoice ID],1,FALSE)), \"Not Saved\", \"Saved\")","v":"Saved"}]
["[Address 1]",null,null,null,"[website]"]
["[Address 2]",null,null,null,"[phone]"]
["[City, State Zip]"]
[null,null,null,null,null,null,null,"Customer ID","CrainC","← Select Customer"]
["Invoice Date","2017-06-19",null,"Order ID",7003,null,null,"First Name",{"$f":"VLOOKUP($I$7,tblCustomers[],J9,FALSE)","v":"Carla"},2]
[null,null,null,null,null,null,null,"Last Name",{"$f":"VLOOKUP($I$7,tblCustomers[],J8,FALSE)","v":"Crain"},3]
["Bill to:",{"$f":"I8&\" \"&I9","v":"Carla Crain"},null,null,null,null,null,"Street",{"$f":"VLOOKUP($I$7,tblCustomers[],J10,FALSE)","v":"3 Cain Ct."},4]
[null,{"$f":"I10","v":"3 Cain Ct."},null,null,null,null,null,"City",{"$f":"VLOOKUP($I$7,tblCustomers[],J11,FALSE)","v":"Cos Cob"},5]
[null,{"$f":"I11&\", \"&I12&\" \"&I13","v":"Cos Cob, CT 06823"},null,null,null,null,null,"State",{"$f":"VLOOKUP($I$7,tblCustomers[],J12,FALSE)","v":"CT"},6]
[null,null,null,null,null,null,null,"Zip",{"$f":"VLOOKUP($I$7,tblCustomers[],J13,FALSE)","v":"06823"},7]
[]
["Product ID","Description","Quant","Price","Total",null,null,"Save Date",{"$f":"TODAY()","v":"2017-06-19"}]
["LayPotChRg6oz",{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A16,tblProducts[],2,FALSE),\"\")","v":"Lays Potato Chips, 6 oz."},3,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A16,tblProducts[],3,FALSE),\"\")","v":3.58},{"$f":"IFERROR(C16*D16,\"\")","v":10.74},null,null,"Filename",{"$f":"\"Invoice-\"&E8&\"-\"&I7&\"-\"&TEXT(I15,\"yy-mm-dd\")","v":"Invoice-7003-CrainC-17-06-19"}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A17,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A17,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C17*D17,\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A18,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A18,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C18*D18,\"\")","v":""},null,null,null,"Order Num","Ord Date","Cust.","Total"]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A19,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A19,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C19*D19,\"\")","v":""},null,null,"Order Data:",{"$f":"E8","v":7003},{"$f":"InvoiceDate","v":"2017-06-19"},{"$f":"I7","v":"CrainC"},{"$f":"D29","v":11.42}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A20,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A20,tblProducts[],3,FALSE),\"\")","v":""},""]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A21,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A21,tblProducts[],3,FALSE),\"\")","v":""},""]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A22,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A22,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C22*D22,\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A23,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A23,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C23*D23,\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A24,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A24,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C24*D24,\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A25,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A25,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C25*D25,\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A26,tblProducts[],2,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A27,tblProducts[],2,FALSE),\"\")","v":""},"Subtotal",{"$f":"SUM(E16:E25)","v":10.74}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A28,tblProducts[],2,FALSE),\"\")","v":""},"Sales tax",6.3500000000000001E-2,{"$f":"ROUND(D27*D28,2)","v":0.68}]
[null,null,"Total",{"$f":"D27+E28","v":11.42}]

{"sheet":"Invoice List","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Invoice List"]
[]
["Last Order:",{"$f":"MAX(tblInvoiceList[Invoice ID])","v":7003}]
["Num Invoices:",{"$f":"COUNT(tblInvoiceList[Invoice ID])","v":3}]
["Next Row:",{"$f":"InvListNumInvoices+9","v":12}]
["Total:",{"$f":"SUBTOTAL(109,tblInvoiceList[Total])","v":78.850000000000009}]
[]
["Invoice ID","Date","Cust ID","Total"]
[7001,"2017-06-18","AmesA",41.870000000000005]
[7002,"2017-06-19","Bains",25.560000000000002]
[7003,"2017-06-19","CrainC",11.42]