{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Documentation","Customers","Products","Invoice Form","Invoice Form 2","Invoice List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":32,"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":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,1,21,2],[22,1,22,2],[0,1,0,2],[20,1,20,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,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","A worksheet that can be set to create an invoice"]
[null,"Invoice Form 2","The completed worksheet for creating an invoice"]
[null,"Invoice List","Lists the invoices that have been created"]
[]
[null,"Skills required to complete the Invoice Form worksheet:"]
[null,"  - Create formulas using the VLOOKUP function"]
[null,"  - Record a Macro"]
[null,"  - Write a Macro"]
[null,"  - Create a Form Button to run a Macro"]
[null,"The completed version of Invoice Form is shown in Invoice Form 2."]
[]
[null,"Created by: Tech Help Today, www.techhelptoday.com"]
[null,"Revised: 6/23/17"]

{"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","44223"]
["Bains","Bains","Burt","2 Brown Blvd.","Bridgeport","CT","06601","bbains3x7z@aol.com"]
["CrainC","Crain","Carla","3 Cain Ct.","Cos Cob","CT","06807"]
["Doe","Doe","Don","4 Dowd Dr.","Denver","CO","80014"]
["EwenE","Ewen","Eve","5 Elm St.","Essex","MA","01929"]

{"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":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,3,26,4],[28,3,28,4],[22,7,22,11],[23,7,23,11],[26,7,26,11],[27,7,27,11],[24,7,24,11],[25,7,25,11]]}
["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":"Not 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-23",null,"Order ID",7003,null,null,"First Name",{"$f":"VLOOKUP($I$7,tblCustomers[],J8,FALSE)","v":"Carla"},3]
[null,null,null,null,null,null,null,"Last Name",{"$f":"VLOOKUP($I$7,tblCustomers[],J9,FALSE)","v":"Crain"},2]
["Bill to:",{"$f":"I8&\" \"&I9","v":"Carla Crain"},null,null,null,null,null,"Street",null,4]
[null,null,null,null,null,null,null,"City",null,5]
[null,null,null,null,null,null,null,"State",null,6]
[null,null,null,null,null,null,null,"Zip",null,7]
[]
["Product ID","Description","Quant","Price","Total",null,null,"Save Date",{"$f":"TODAY()","v":"2017-06-23"}]
["TropicOJ56oz",{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A16,tblProducts[],2,FALSE),\"\")","v":"Tropicana Orange Juice, 56 oz."},3,null,{"$f":"IFERROR(C16*D16,\"\")","v":0},null,null,"Filename",{"$f":"\"Invoice-\"&E8&\"-\"&I7&\"-\"&TEXT(I15,\"yy-mm-dd\")","v":"Invoice-7003-CrainC-17-06-23"}]
["BumBTuna5.3oz",{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A17,tblProducts[],2,FALSE),\"\")","v":"Bumble Bee Prem. Tuna, 5 oz."},3,null,{"$f":"IFERROR(C17*D17,\"\")","v":0}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A18,tblProducts[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(C18*D18,\"\")","v":0},null,null,null,"Order Num","Ord Date","Cust.","Total"]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A19,tblProducts[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(C19*D19,\"\")","v":0},null,null,"Order Data:",{"$f":"E8","v":7003},{"$f":"InvoiceDate","v":"2017-06-23"},{"$f":"I7","v":"CrainC"},{"$f":"D29","v":0}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A20,tblProducts[],2,FALSE),\"\")","v":""},null,null,0]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A21,tblProducts[],2,FALSE),\"\")","v":""},null,null,0]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A22,tblProducts[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(C22*D22,\"\")","v":0},null,null,"Instructions:"]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A23,tblProducts[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(C23*D23,\"\")","v":0},null,null,"1. Add the appropriate VLOOKUP functions in the green cells."]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A24,tblProducts[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(C24*D24,\"\")","v":0},null,null,"2. Record a Macro called PrintInvoice to print the worksheet."]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A25,tblProducts[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(C25*D25,\"\")","v":0},null,null,"3. Record a Macro called RecordTodaysDate that put today's"]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A26,tblProducts[],2,FALSE),\"\")","v":""},null,null,null,null,null,"     date into cell B8."]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A27,tblProducts[],2,FALSE),\"\")","v":""},"Subtotal",{"$f":"SUM(E16:E25)","v":0},null,null,null,"4. Use the Macros Edit command to change the RecordTodaysDate"]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form'!$A28,tblProducts[],2,FALSE),\"\")","v":""},"Sales tax",6.3500000000000001E-2,{"$f":"ROUND(D27*D28,2)","v":0},null,null,"     RecordTodaysDate macro so that it looks like the code below."]
[null,null,"Total",{"$f":"D27+E28","v":0},null,null,null,"5. Create a Print button for the PrintInvoice macro."]
[null,null,null,null,null,null,null,"6. Create a Today button for the RecordTodaysDate macro."]

{"sheet":"Invoice Form 2","index":4,"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","Bains","← Select Customer"]
["Invoice Date","2017-06-23",null,"Order ID",7002,null,null,"First Name",{"$f":"VLOOKUP($I$7,tblCustomers[],J8,FALSE)","v":"Burt"},3]
[null,null,null,null,null,null,null,"Last Name",{"$f":"VLOOKUP($I$7,tblCustomers[],J9,FALSE)","v":"Bains"},2]
["Bill to:",{"$f":"I8&\" \"&I9","v":"Burt Bains"},null,null,null,null,null,"Street",{"$f":"VLOOKUP($I$7,tblCustomers[],J10,FALSE)","v":"2 Brown Blvd."},4]
[null,{"$f":"I10","v":"2 Brown Blvd."},null,null,null,null,null,"City",{"$f":"VLOOKUP($I$7,tblCustomers[],J11,FALSE)","v":"Bridgeport"},5]
[null,{"$f":"I11&\", \"&I12&\" \"&I13","v":"Bridgeport, CT 06601"},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":"06601"},7]
[]
["Product ID","Description","Quant","Price","Total",null,null,"Save Date",{"$f":"TODAY()","v":"2017-06-23"}]
["OreoReg12oz",{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A16,tblProducts[],2,FALSE),\"\")","v":"Oreos, Regular, 12 oz. pckg."},2,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A16,tblProducts[],3,FALSE),\"\")","v":3.49},{"$f":"IFERROR(C16*D16,\"\")","v":6.98},null,null,"Filename",{"$f":"\"Invoice-\"&E8&\"-\"&I7&\"-\"&TEXT(I15,\"yy-mm-dd\")","v":"Invoice-7002-Bains-17-06-23"}]
["LayPotChRg6oz",{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A17,tblProducts[],2,FALSE),\"\")","v":"Lays Potato Chips, 6 oz."},2,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A17,tblProducts[],3,FALSE),\"\")","v":3.58},{"$f":"IFERROR(C17*D17,\"\")","v":7.16}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A18,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$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 2'!$A19,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A19,tblProducts[],3,FALSE),\"\")","v":""},"",null,null,"Order Data:",{"$f":"E8","v":7002},{"$f":"InvoiceDate2","v":"2017-06-23"},{"$f":"I7","v":"Bains"},{"$f":"D29","v":15.040000000000001}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A20,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A20,tblProducts[],3,FALSE),\"\")","v":""},""]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A21,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A21,tblProducts[],3,FALSE),\"\")","v":""},""]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A22,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A22,tblProducts[],3,FALSE),\"\")","v":""},""]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A23,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A23,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C23*D23,\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A24,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A24,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C24*D24,\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A25,tblProducts[],2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A25,tblProducts[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(C25*D25,\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A26,tblProducts[],2,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A27,tblProducts[],2,FALSE),\"\")","v":""},"Subtotal",{"$f":"SUM(E16:E25)","v":14.14}]
[null,{"$f":"IFERROR(VLOOKUP('Invoice Form 2'!$A28,tblProducts[],2,FALSE),\"\")","v":""},"Sales tax",6.3500000000000001E-2,{"$f":"ROUND(D27*D28,2)","v":0.9}]
[null,null,"Total",{"$f":"D27+E28","v":15.040000000000001}]

{"sheet":"Invoice List","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Invoice List"]
[]
["Last Order:",{"$f":"MAX(tblInvoiceList[Invoice ID])","v":7002}]
["Num Invoices:",{"$f":"COUNT(tblInvoiceList[Invoice ID])","v":2}]
["Next Row:",{"$f":"InvListNumInvoices+9","v":11}]
["Total:",{"$f":"SUBTOTAL(109,tblInvoiceList[Total])","v":56.910000000000004}]
[]
["Invoice ID","Date","Cust ID","Total"]
[7001,"2017-06-18","AmesA",41.870000000000005]
[7002,"2017-06-23","Bains",15.040000000000001]