{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Topics","MacroNotes","M1.1","M1.2","M1.3","M2.1","M2.2","M2.3","M3.1","M3.2","M3.3","M3.4","M3.5","M3.6","M4","M5","M6","ProperDataSet"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Topics","index":0,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2016 Class Video 26: Macro Recorder Basics"]
[]
["Topics:"]
["1)    Absolute Reference Macro: Format report that always has the same number of columns and rows"]
["2)    Absolute & Relative Reference Macro: Format report that that has an unknown number of rows"]
["3)    Relative Reference Macro to convert vertical records into a proper data set with horizontal records"]
["4)    Search for VBA Code online: Function to spell out numbers as words"]
["5)    Search for VBA Code online: Add or count cells with red fill"]
["6)    Form Control Button to Add Record to Existing Proper Data Set"]
[]
["Short Notes:"]
["Macro = Code = VBA (Visual Basic Application) = you can type it out or use \"Macro Recorder\""]
["Show Developer Ribbon"]
["Must use .xlsm (m means Macro)"]
["Macro Recorder is like tape recorder:"]
["You click the Macro Record Button and as you do stuff in Excel it writes code for you."]
["Using code is good for two basic reasons:"]
["Automate repetitive tasks"]
["Accomplish task where there is no built-in feature to accomplish task"]
["Relative / Absolute Button:"]
["Relative Macros record Relative movement of the selected cell (OFFSET function.."]
["Absolute Macros record Absolute movement of the selected cell (RANGE function)."]
["Turn on Macro Recorder"]
["Security Level: \"Disable all Macros with notification\""]
["Keyboards: 1) Alt + F11 (VBA Editor)     2) Alt + F8 (list of Macros)"]
["Store Macro: if you store in Personal you can use Macro anytime you use the Excel on your computer"]

{"sheet":"MacroNotes","index":1,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["What is a Macro?"]
[{"$f":"COUNTA(A$1:A1)&\")\"","v":"1)"},"Code in Excel is called VBA (Visual Basic Application)"]
[null,"Macro is a synonym for VBA"]
[null,"VBA = Visual Basic Application = Macro = written code that executes commands to do things in Excel."]
[{"$f":"COUNTA(A$1:A4)&\")\"","v":"2)"},"If you do not know how to write code, you can use the Macro Recorder."]
[null,"When you hit the Record Macro button:"]
[null,"1) It is like a tape recorder"]
[null,"2) Whatever you do in Excel, the Macro Recorder writes the VBA Code for you."]
[{"$f":"COUNTA(A$1:A8)&\")\"","v":"3)"},"Code is good for two reasons:"]
[null,"1) If you have repetitive tasks that you want to automate (like formatting a month report)."]
[null,"That way you can just click a button and the report is formatted"]
[null,"2) There are some things you want to do (like have a function spell out a word), that the commands in the ribbons can't do."]
[null,"For us, non-code writers, we can search Google for the code."]
[{"$f":"COUNTA(A$1:A13)&\")\"","v":"4)"},"You must use the \".xlsm\" extension in order to use Macros. "]
[null,"File extension: use \".xlsm\". \"m\" means Macro"]
[null,"File extension \"xlsx\" will not allow Macros."]
[null,"In Excel 2003, the file extension .xls works with VBA or without VBA."]
[{"$f":"COUNTA(A$1:A17)&\")\"","v":"5)"},"Must show Developer Ribbon: Right-click ribbon, Customize Ribbon, check box for Developer tab."]
[null,"To turn on the Macro Recorder use the \"Record Macro button in the Code group in the Developer Ribbon (or the Record Macro button on the left side of the Status Bar)."]
[null,"Be sure to Turn off the Macro Recorder when you are done"]
[null,"Relative Macros record Relative movement of the selected cell (OFFSET function.."]
[null,"Absolute Macros record Absolute movement of the selected cell (RANGE function)."]
[null,"The \"Use Relative Reference\" button in the Code Group in the Developer Ribbon. The \"Use Relative Reference\" button is a toggle that toggles between Absolution and Relative References.  When the button is yellow/orange in color, the Marco is recording Relative Cell References in the Macro. When it is not yellow/orange, it is recording Absolute References."]
[null,"You must also set the security level in the Code Group in the Developer Ribbon to \"Disable all Macros with notification\"; then each time you open the workbook, click the \"Options\" button that appears when you open the workbook, then click \"Enable\"."]
[{"$f":"COUNTA(A$1:A24)&\")\"","v":"6)"},"Keyboards:"]
[null,"Alt + F11: opens VBA Editor Window so you can write code."]
[null,"In the VBA editor:\nLeft side shows: 1) \"Project Explorer\" (Ctrl + R), which sows objects such as Workbook, Worksheets and Modules (Macros). 2) Properties (F4 key)"]
[null,"If you copy code from internet, when you are in VBA editor, Alt I + P, name Macro, Paste Code on right side, go  back to Excel, Alt + F8 to open Macro List, Select Macro, click Options, assign keyboard shortcut"]
[null,"Alt + F8: Opens list of macros you can run. You can select a Macro and then click the Edit button to see the code that the Macro recorder recorded. Use \"Options\" button toassign a keyboard."]
[{"$f":"COUNTA(A$1:A29)&\")\"","v":"7)"},"Where to store your Macro:"]
[null,"If you store Macros in \"This workbook\", they are only available in this workbook"]
[null,"If you store Macros in \"Personal workbook\", they are stored in the hidden workbook named \"Personal\" and the Macros will be available in all workbooks on your computer. To edit a Macro in a Personal workbook, you must unhide the workbook using the \"Unhide\" button in the Window Group on the View Ribbon."]

{"sheet":"M1.1","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset",null,null,null,null,"1)    Absolute Reference Macro: Format report that always has the same number of columns and rows"]
["Audrey  Davis",336811,343547]
["Kay  Stokes",973876,1149174]
["Irene  Greene",112982,115242]
["Tim  Gordon",53374,51773]
["Darnell  Porter",322859,339002]
["Irma  Boone",987206,957590]
["Bertha  Montgomery",886223,1001432]
["Jeanne  Gray",19057,21916]
["Lorene  Mason",770301,878143]
["Marcos  Lee",313418,294613]

{"sheet":"M1.2","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset"]
["Audrey  Davis",336811,343547]
["Kay  Stokes",973876,1149174]
["Irene  Greene",112982,115242]
["Tim  Gordon",53374,51773]
["Darnell  Porter",322859,339002]
["Irma  Boone",987206,957590]
["Bertha  Montgomery",886223,1001432]
["Jeanne  Gray",19057,21916]
["Lorene  Mason",770301,878143]
["Marcos  Lee",313418,294613]

{"sheet":"M1.3","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset"]
["Audrey  Davis",336811,343547]
["Kay  Stokes",973876,1149174]
["Irene  Greene",112982,115242]
["Tim  Gordon",53374,51773]
["Darnell  Porter",322859,339002]
["Irma  Boone",987206,957590]
["Bertha  Montgomery",886223,1001432]
["Jeanne  Gray",19057,21916]
["Lorene  Mason",770301,878143]
["Marcos  Lee",313418,294613]

{"sheet":"M2.1","index":5,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset",null,null,null,null,"2)    Absolute & Relative Reference Macro: Format report that that has an unknown number of rows"]
["Audrey  Davis",336811,343547]
["Kay  Stokes",973876,1149174]
["Irene  Greene",112982,115242]
["Tim  Gordon",53374,51773]

{"sheet":"M2.2","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset"]
["Audrey  Davis",336811,343547]
["Kay  Stokes",973876,1149174]
["Irene  Greene",112982,115242]
["Tim  Gordon",53374,51773]
["Darnell  Porter",322859,339002]
["Irma  Boone",987206,957590]

{"sheet":"M2.3","index":7,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset"]
["Audrey  Davis",336811,343547]
["Kay  Stokes",973876,1149174]
["Irene  Greene",112982,115242]
["Tim  Gordon",53374,51773]
["Darnell  Porter",322859,339002]
["Irma  Boone",987206,957590]
["Bertha  Montgomery",886223,1001432]
["Jeanne  Gray",19057,21916]
["Lorene  Mason",770301,878143]
["Marcos  Lee",313418,294613]
["Sue  Owen",242303,264110]
["Raquel  Hamilton",609327,578861]
["Katrina  Bowman",22784,20506]
["Helen  Byrd",946323,984176]
["Ebony  Anderson",46880,47349]
["Christy  Griffith",392492,388567]
["Jenny  Fields",408653,441345]
["Juan  Hunt",780152,756747]
["Dixie  Barnett",734984,734984]
["Antoinette  Crawford",129592,111449]

{"sheet":"M3.1","index":8,"n_rows":141,"n_cols":12,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["First","Last","Address","City","State","Zip","Phone","E1","E2",null,null,"3)    Relative Reference Macro to convert vertical records into a proper data set with horizontal records"]
[]
["Steve"]
["Chin"]
["14 17th St."]
["Seattle"]
["WA"]
[98104]
["206-572-3409"]
[{"$f":"A3&\"_\"&A4&\"@notaol.com\"","v":"Steve_Chin@notaol.com"}]
[{"$f":"A4&\"_\"&A5&\"@notaol.com\"","v":"Chin_14 17th St.@notaol.com"}]
[]
["Troun"]
["Tenn"]
["6 19th St."]
["Seattle"]
["WA"]
[98106]
["206-667-3154"]
[{"$f":"A13&\"_\"&A14&\"@notaol.com\"","v":"Troun_Tenn@notaol.com"}]
[{"$f":"A14&\"_\"&A15&\"@notaol.com\"","v":"Tenn_6 19th St.@notaol.com"}]
[]
["Rhond"]
["Tradfren"]
["10 13th St."]
["Seattle"]
["WA"]
[98117]
["206-574-1265"]
[{"$f":"A23&\"_\"&A24&\"@notaol.com\"","v":"Rhond_Tradfren@notaol.com"}]
[{"$f":"A24&\"_\"&A25&\"@notaol.com\"","v":"Tradfren_10 13th St.@notaol.com"}]
[]
["Sheli"]
["Das"]
["2 15th St."]
["Seattle"]
["WA"]
[98111]
["206-637-4014"]
[{"$f":"A33&\"_\"&A34&\"@notaol.com\"","v":"Sheli_Das@notaol.com"}]
[{"$f":"A34&\"_\"&A35&\"@notaol.com\"","v":"Das_2 15th St.@notaol.com"}]
[]
["Jon"]
["Teddy"]
["3 17th St."]
["Seattle"]
["WA"]
[98114]
["206-515-5102"]
[{"$f":"A43&\"_\"&A44&\"@notaol.com\"","v":"Jon_Teddy@notaol.com"}]
[{"$f":"A44&\"_\"&A45&\"@notaol.com\"","v":"Teddy_3 17th St.@notaol.com"}]
[]
["Jeri"]
["Yessler"]
["12 16th St."]
["Seattle"]
["WA"]
[98114]
["206-583-2943"]
[{"$f":"A53&\"_\"&A54&\"@notaol.com\"","v":"Jeri_Yessler@notaol.com"}]
[{"$f":"A54&\"_\"&A55&\"@notaol.com\"","v":"Yessler_12 16th St.@notaol.com"}]
[]
["Luke"]
["Suix"]
["8 19th St."]
["Seattle"]
["WA"]
[98113]
["206-774-4449"]
[{"$f":"A63&\"_\"&A64&\"@notaol.com\"","v":"Luke_Suix@notaol.com"}]
[{"$f":"A64&\"_\"&A65&\"@notaol.com\"","v":"Suix_8 19th St.@notaol.com"}]
[]
["Luke"]
["Red"]
["15 16th St."]
["Seattle"]
["WA"]
[98108]
["206-685-2311"]
[{"$f":"A73&\"_\"&A74&\"@notaol.com\"","v":"Luke_Red@notaol.com"}]
[{"$f":"A74&\"_\"&A75&\"@notaol.com\"","v":"Red_15 16th St.@notaol.com"}]
[]
["Jeri"]
["Smythe"]
["14 19th St."]
["Seattle"]
["WA"]
[98112]
["206-574-6156"]
[{"$f":"A83&\"_\"&A84&\"@notaol.com\"","v":"Jeri_Smythe@notaol.com"}]
[{"$f":"A84&\"_\"&A85&\"@notaol.com\"","v":"Smythe_14 19th St.@notaol.com"}]
[]
["Luke"]
["Rad"]
["3 16th St."]
["Seattle"]
["WA"]
[98106]
["206-599-3338"]
[{"$f":"A93&\"_\"&A94&\"@notaol.com\"","v":"Luke_Rad@notaol.com"}]
[{"$f":"A94&\"_\"&A95&\"@notaol.com\"","v":"Rad_3 16th St.@notaol.com"}]
[]
["Jon"]
["Dap"]
["5 19th St."]
["Seattle"]
["WA"]
[98116]
["206-679-1485"]
[{"$f":"A103&\"_\"&A104&\"@notaol.com\"","v":"Jon_Dap@notaol.com"}]
[{"$f":"A104&\"_\"&A105&\"@notaol.com\"","v":"Dap_5 19th St.@notaol.com"}]
[]
["Steve"]
["Gupis"]
["6 17th St."]
["Seattle"]
["WA"]
[98111]
["206-609-1507"]
[{"$f":"A113&\"_\"&A114&\"@notaol.com\"","v":"Steve_Gupis@notaol.com"}]
[{"$f":"A114&\"_\"&A115&\"@notaol.com\"","v":"Gupis_6 17th St.@notaol.com"}]
[]
["Jon"]
["Summi"]
["4 14th St."]
["Seattle"]
["WA"]
[98104]
["206-733-4318"]
[{"$f":"A123&\"_\"&A124&\"@notaol.com\"","v":"Jon_Summi@notaol.com"}]
[{"$f":"A124&\"_\"&A125&\"@notaol.com\"","v":"Summi_4 14th St.@notaol.com"}]
[]
["Sheli"]
["Fun"]
["7 15th St."]
["Seattle"]
["WA"]
[98110]
["206-691-7629"]
[{"$f":"A133&\"_\"&A134&\"@notaol.com\"","v":"Sheli_Fun@notaol.com"}]
[{"$f":"A134&\"_\"&A135&\"@notaol.com\"","v":"Fun_7 15th St.@notaol.com"}]

{"sheet":"M3.2","index":9,"n_rows":141,"n_cols":9,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["First","Last","Address","City","State","Zip","Phone","E1","E2"]
[]
["Steve"]
["Chin"]
["14 17th St."]
["Seattle"]
["WA"]
[98104]
["206-572-3409"]
[{"$f":"A3&\"_\"&A4&\"@notaol.com\"","v":"Steve_Chin@notaol.com"}]
[{"$f":"A4&\"_\"&A5&\"@notaol.com\"","v":"Chin_14 17th St.@notaol.com"}]
[]
["Troun"]
["Tenn"]
["6 19th St."]
["Seattle"]
["WA"]
[98106]
["206-667-3154"]
[{"$f":"A13&\"_\"&A14&\"@notaol.com\"","v":"Troun_Tenn@notaol.com"}]
[{"$f":"A14&\"_\"&A15&\"@notaol.com\"","v":"Tenn_6 19th St.@notaol.com"}]
[]
["Rhond"]
["Tradfren"]
["10 13th St."]
["Seattle"]
["WA"]
[98117]
["206-574-1265"]
[{"$f":"A23&\"_\"&A24&\"@notaol.com\"","v":"Rhond_Tradfren@notaol.com"}]
[{"$f":"A24&\"_\"&A25&\"@notaol.com\"","v":"Tradfren_10 13th St.@notaol.com"}]
[]
["Sheli"]
["Das"]
["2 15th St."]
["Seattle"]
["WA"]
[98111]
["206-637-4014"]
[{"$f":"A33&\"_\"&A34&\"@notaol.com\"","v":"Sheli_Das@notaol.com"}]
[{"$f":"A34&\"_\"&A35&\"@notaol.com\"","v":"Das_2 15th St.@notaol.com"}]
[]
["Jon"]
["Teddy"]
["3 17th St."]
["Seattle"]
["WA"]
[98114]
["206-515-5102"]
[{"$f":"A43&\"_\"&A44&\"@notaol.com\"","v":"Jon_Teddy@notaol.com"}]
[{"$f":"A44&\"_\"&A45&\"@notaol.com\"","v":"Teddy_3 17th St.@notaol.com"}]
[]
["Jeri"]
["Yessler"]
["12 16th St."]
["Seattle"]
["WA"]
[98114]
["206-583-2943"]
[{"$f":"A53&\"_\"&A54&\"@notaol.com\"","v":"Jeri_Yessler@notaol.com"}]
[{"$f":"A54&\"_\"&A55&\"@notaol.com\"","v":"Yessler_12 16th St.@notaol.com"}]
[]
["Luke"]
["Suix"]
["8 19th St."]
["Seattle"]
["WA"]
[98113]
["206-774-4449"]
[{"$f":"A63&\"_\"&A64&\"@notaol.com\"","v":"Luke_Suix@notaol.com"}]
[{"$f":"A64&\"_\"&A65&\"@notaol.com\"","v":"Suix_8 19th St.@notaol.com"}]
[]
["Luke"]
["Red"]
["15 16th St."]
["Seattle"]
["WA"]
[98108]
["206-685-2311"]
[{"$f":"A73&\"_\"&A74&\"@notaol.com\"","v":"Luke_Red@notaol.com"}]
[{"$f":"A74&\"_\"&A75&\"@notaol.com\"","v":"Red_15 16th St.@notaol.com"}]
[]
["Jeri"]
["Smythe"]
["14 19th St."]
["Seattle"]
["WA"]
[98112]
["206-574-6156"]
[{"$f":"A83&\"_\"&A84&\"@notaol.com\"","v":"Jeri_Smythe@notaol.com"}]
[{"$f":"A84&\"_\"&A85&\"@notaol.com\"","v":"Smythe_14 19th St.@notaol.com"}]
[]
["Luke"]
["Rad"]
["3 16th St."]
["Seattle"]
["WA"]
[98106]
["206-599-3338"]
[{"$f":"A93&\"_\"&A94&\"@notaol.com\"","v":"Luke_Rad@notaol.com"}]
[{"$f":"A94&\"_\"&A95&\"@notaol.com\"","v":"Rad_3 16th St.@notaol.com"}]
[]
["Jon"]
["Dap"]
["5 19th St."]
["Seattle"]
["WA"]
[98116]
["206-679-1485"]
[{"$f":"A103&\"_\"&A104&\"@notaol.com\"","v":"Jon_Dap@notaol.com"}]
[{"$f":"A104&\"_\"&A105&\"@notaol.com\"","v":"Dap_5 19th St.@notaol.com"}]
[]
["Steve"]
["Gupis"]
["6 17th St."]
["Seattle"]
["WA"]
[98111]
["206-609-1507"]
[{"$f":"A113&\"_\"&A114&\"@notaol.com\"","v":"Steve_Gupis@notaol.com"}]
[{"$f":"A114&\"_\"&A115&\"@notaol.com\"","v":"Gupis_6 17th St.@notaol.com"}]
[]
["Jon"]
["Summi"]
["4 14th St."]
["Seattle"]
["WA"]
[98104]
["206-733-4318"]
[{"$f":"A123&\"_\"&A124&\"@notaol.com\"","v":"Jon_Summi@notaol.com"}]
[{"$f":"A124&\"_\"&A125&\"@notaol.com\"","v":"Summi_4 14th St.@notaol.com"}]
[]
["Sheli"]
["Fun"]
["7 15th St."]
["Seattle"]
["WA"]
[98110]
["206-691-7629"]
[{"$f":"A133&\"_\"&A134&\"@notaol.com\"","v":"Sheli_Fun@notaol.com"}]
[{"$f":"A134&\"_\"&A135&\"@notaol.com\"","v":"Fun_7 15th St.@notaol.com"}]

{"sheet":"M3.3","index":10,"n_rows":141,"n_cols":9,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["First","Last","Address","City","State","Zip","Phone","E1","E2"]
[]
["Steve"]
["Chin"]
["14 17th St."]
["Seattle"]
["WA"]
[98104]
["206-572-3409"]
[{"$f":"A3&\"_\"&A4&\"@notaol.com\"","v":"Steve_Chin@notaol.com"}]
[{"$f":"A4&\"_\"&A5&\"@notaol.com\"","v":"Chin_14 17th St.@notaol.com"}]
[]
["Troun"]
["Tenn"]
["6 19th St."]
["Seattle"]
["WA"]
[98106]
["206-667-3154"]
[{"$f":"A13&\"_\"&A14&\"@notaol.com\"","v":"Troun_Tenn@notaol.com"}]
[{"$f":"A14&\"_\"&A15&\"@notaol.com\"","v":"Tenn_6 19th St.@notaol.com"}]
[]
["Rhond"]
["Tradfren"]
["10 13th St."]
["Seattle"]
["WA"]
[98117]
["206-574-1265"]
[{"$f":"A23&\"_\"&A24&\"@notaol.com\"","v":"Rhond_Tradfren@notaol.com"}]
[{"$f":"A24&\"_\"&A25&\"@notaol.com\"","v":"Tradfren_10 13th St.@notaol.com"}]
[]
["Sheli"]
["Das"]
["2 15th St."]
["Seattle"]
["WA"]
[98111]
["206-637-4014"]
[{"$f":"A33&\"_\"&A34&\"@notaol.com\"","v":"Sheli_Das@notaol.com"}]
[{"$f":"A34&\"_\"&A35&\"@notaol.com\"","v":"Das_2 15th St.@notaol.com"}]
[]
["Jon"]
["Teddy"]
["3 17th St."]
["Seattle"]
["WA"]
[98114]
["206-515-5102"]
[{"$f":"A43&\"_\"&A44&\"@notaol.com\"","v":"Jon_Teddy@notaol.com"}]
[{"$f":"A44&\"_\"&A45&\"@notaol.com\"","v":"Teddy_3 17th St.@notaol.com"}]
[]
["Jeri"]
["Yessler"]
["12 16th St."]
["Seattle"]
["WA"]
[98114]
["206-583-2943"]
[{"$f":"A53&\"_\"&A54&\"@notaol.com\"","v":"Jeri_Yessler@notaol.com"}]
[{"$f":"A54&\"_\"&A55&\"@notaol.com\"","v":"Yessler_12 16th St.@notaol.com"}]
[]
["Luke"]
["Suix"]
["8 19th St."]
["Seattle"]
["WA"]
[98113]
["206-774-4449"]
[{"$f":"A63&\"_\"&A64&\"@notaol.com\"","v":"Luke_Suix@notaol.com"}]
[{"$f":"A64&\"_\"&A65&\"@notaol.com\"","v":"Suix_8 19th St.@notaol.com"}]
[]
["Luke"]
["Red"]
["15 16th St."]
["Seattle"]
["WA"]
[98108]
["206-685-2311"]
[{"$f":"A73&\"_\"&A74&\"@notaol.com\"","v":"Luke_Red@notaol.com"}]
[{"$f":"A74&\"_\"&A75&\"@notaol.com\"","v":"Red_15 16th St.@notaol.com"}]
[]
["Jeri"]
["Smythe"]
["14 19th St."]
["Seattle"]
["WA"]
[98112]
["206-574-6156"]
[{"$f":"A83&\"_\"&A84&\"@notaol.com\"","v":"Jeri_Smythe@notaol.com"}]
[{"$f":"A84&\"_\"&A85&\"@notaol.com\"","v":"Smythe_14 19th St.@notaol.com"}]
[]
["Luke"]
["Rad"]
["3 16th St."]
["Seattle"]
["WA"]
[98106]
["206-599-3338"]
[{"$f":"A93&\"_\"&A94&\"@notaol.com\"","v":"Luke_Rad@notaol.com"}]
[{"$f":"A94&\"_\"&A95&\"@notaol.com\"","v":"Rad_3 16th St.@notaol.com"}]
[]
["Jon"]
["Dap"]
["5 19th St."]
["Seattle"]
["WA"]
[98116]
["206-679-1485"]
[{"$f":"A103&\"_\"&A104&\"@notaol.com\"","v":"Jon_Dap@notaol.com"}]
[{"$f":"A104&\"_\"&A105&\"@notaol.com\"","v":"Dap_5 19th St.@notaol.com"}]
[]
["Steve"]
["Gupis"]
["6 17th St."]
["Seattle"]
["WA"]
[98111]
["206-609-1507"]
[{"$f":"A113&\"_\"&A114&\"@notaol.com\"","v":"Steve_Gupis@notaol.com"}]
[{"$f":"A114&\"_\"&A115&\"@notaol.com\"","v":"Gupis_6 17th St.@notaol.com"}]
[]
["Jon"]
["Summi"]
["4 14th St."]
["Seattle"]
["WA"]
[98104]
["206-733-4318"]
[{"$f":"A123&\"_\"&A124&\"@notaol.com\"","v":"Jon_Summi@notaol.com"}]
[{"$f":"A124&\"_\"&A125&\"@notaol.com\"","v":"Summi_4 14th St.@notaol.com"}]
[]
["Sheli"]
["Fun"]
["7 15th St."]
["Seattle"]
["WA"]
[98110]
["206-691-7629"]
[{"$f":"A133&\"_\"&A134&\"@notaol.com\"","v":"Sheli_Fun@notaol.com"}]
[{"$f":"A134&\"_\"&A135&\"@notaol.com\"","v":"Fun_7 15th St.@notaol.com"}]

{"sheet":"M3.4","index":11,"n_rows":141,"n_cols":9,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["First","Last","Address","City","State","Zip","Phone","E1","E2"]
[]
["Steve"]
["Chin"]
["14 17th St."]
["Seattle"]
["WA"]
[98104]
["206-572-3409"]
[{"$f":"A3&\"_\"&A4&\"@notaol.com\"","v":"Steve_Chin@notaol.com"}]
[{"$f":"A4&\"_\"&A5&\"@notaol.com\"","v":"Chin_14 17th St.@notaol.com"}]
[]
["Troun"]
["Tenn"]
["6 19th St."]
["Seattle"]
["WA"]
[98106]
["206-667-3154"]
[{"$f":"A13&\"_\"&A14&\"@notaol.com\"","v":"Troun_Tenn@notaol.com"}]
[{"$f":"A14&\"_\"&A15&\"@notaol.com\"","v":"Tenn_6 19th St.@notaol.com"}]
[]
["Rhond"]
["Tradfren"]
["10 13th St."]
["Seattle"]
["WA"]
[98117]
["206-574-1265"]
[{"$f":"A23&\"_\"&A24&\"@notaol.com\"","v":"Rhond_Tradfren@notaol.com"}]
[{"$f":"A24&\"_\"&A25&\"@notaol.com\"","v":"Tradfren_10 13th St.@notaol.com"}]
[]
["Sheli"]
["Das"]
["2 15th St."]
["Seattle"]
["WA"]
[98111]
["206-637-4014"]
[{"$f":"A33&\"_\"&A34&\"@notaol.com\"","v":"Sheli_Das@notaol.com"}]
[{"$f":"A34&\"_\"&A35&\"@notaol.com\"","v":"Das_2 15th St.@notaol.com"}]
[]
["Jon"]
["Teddy"]
["3 17th St."]
["Seattle"]
["WA"]
[98114]
["206-515-5102"]
[{"$f":"A43&\"_\"&A44&\"@notaol.com\"","v":"Jon_Teddy@notaol.com"}]
[{"$f":"A44&\"_\"&A45&\"@notaol.com\"","v":"Teddy_3 17th St.@notaol.com"}]
[]
["Jeri"]
["Yessler"]
["12 16th St."]
["Seattle"]
["WA"]
[98114]
["206-583-2943"]
[{"$f":"A53&\"_\"&A54&\"@notaol.com\"","v":"Jeri_Yessler@notaol.com"}]
[{"$f":"A54&\"_\"&A55&\"@notaol.com\"","v":"Yessler_12 16th St.@notaol.com"}]
[]
["Luke"]
["Suix"]
["8 19th St."]
["Seattle"]
["WA"]
[98113]
["206-774-4449"]
[{"$f":"A63&\"_\"&A64&\"@notaol.com\"","v":"Luke_Suix@notaol.com"}]
[{"$f":"A64&\"_\"&A65&\"@notaol.com\"","v":"Suix_8 19th St.@notaol.com"}]
[]
["Luke"]
["Red"]
["15 16th St."]
["Seattle"]
["WA"]
[98108]
["206-685-2311"]
[{"$f":"A73&\"_\"&A74&\"@notaol.com\"","v":"Luke_Red@notaol.com"}]
[{"$f":"A74&\"_\"&A75&\"@notaol.com\"","v":"Red_15 16th St.@notaol.com"}]
[]
["Jeri"]
["Smythe"]
["14 19th St."]
["Seattle"]
["WA"]
[98112]
["206-574-6156"]
[{"$f":"A83&\"_\"&A84&\"@notaol.com\"","v":"Jeri_Smythe@notaol.com"}]
[{"$f":"A84&\"_\"&A85&\"@notaol.com\"","v":"Smythe_14 19th St.@notaol.com"}]
[]
["Luke"]
["Rad"]
["3 16th St."]
["Seattle"]
["WA"]
[98106]
["206-599-3338"]
[{"$f":"A93&\"_\"&A94&\"@notaol.com\"","v":"Luke_Rad@notaol.com"}]
[{"$f":"A94&\"_\"&A95&\"@notaol.com\"","v":"Rad_3 16th St.@notaol.com"}]
[]
["Jon"]
["Dap"]
["5 19th St."]
["Seattle"]
["WA"]
[98116]
["206-679-1485"]
[{"$f":"A103&\"_\"&A104&\"@notaol.com\"","v":"Jon_Dap@notaol.com"}]
[{"$f":"A104&\"_\"&A105&\"@notaol.com\"","v":"Dap_5 19th St.@notaol.com"}]
[]
["Steve"]
["Gupis"]
["6 17th St."]
["Seattle"]
["WA"]
[98111]
["206-609-1507"]
[{"$f":"A113&\"_\"&A114&\"@notaol.com\"","v":"Steve_Gupis@notaol.com"}]
[{"$f":"A114&\"_\"&A115&\"@notaol.com\"","v":"Gupis_6 17th St.@notaol.com"}]
[]
["Jon"]
["Summi"]
["4 14th St."]
["Seattle"]
["WA"]
[98104]
["206-733-4318"]
[{"$f":"A123&\"_\"&A124&\"@notaol.com\"","v":"Jon_Summi@notaol.com"}]
[{"$f":"A124&\"_\"&A125&\"@notaol.com\"","v":"Summi_4 14th St.@notaol.com"}]
[]
["Sheli"]
["Fun"]
["7 15th St."]
["Seattle"]
["WA"]
[98110]
["206-691-7629"]
[{"$f":"A133&\"_\"&A134&\"@notaol.com\"","v":"Sheli_Fun@notaol.com"}]
[{"$f":"A134&\"_\"&A135&\"@notaol.com\"","v":"Fun_7 15th St.@notaol.com"}]

{"sheet":"M3.5","index":12,"n_rows":141,"n_cols":9,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["First","Last","Address","City","State","Zip","Phone","E1","E2"]
[]
["Steve"]
["Chin"]
["14 17th St."]
["Seattle"]
["WA"]
[98104]
["206-572-3409"]
[{"$f":"A3&\"_\"&A4&\"@notaol.com\"","v":"Steve_Chin@notaol.com"}]
[{"$f":"A4&\"_\"&A5&\"@notaol.com\"","v":"Chin_14 17th St.@notaol.com"}]
[]
["Troun"]
["Tenn"]
["6 19th St."]
["Seattle"]
["WA"]
[98106]
["206-667-3154"]
[{"$f":"A13&\"_\"&A14&\"@notaol.com\"","v":"Troun_Tenn@notaol.com"}]
[{"$f":"A14&\"_\"&A15&\"@notaol.com\"","v":"Tenn_6 19th St.@notaol.com"}]
[]
["Rhond"]
["Tradfren"]
["10 13th St."]
["Seattle"]
["WA"]
[98117]
["206-574-1265"]
[{"$f":"A23&\"_\"&A24&\"@notaol.com\"","v":"Rhond_Tradfren@notaol.com"}]
[{"$f":"A24&\"_\"&A25&\"@notaol.com\"","v":"Tradfren_10 13th St.@notaol.com"}]
[]
["Sheli"]
["Das"]
["2 15th St."]
["Seattle"]
["WA"]
[98111]
["206-637-4014"]
[{"$f":"A33&\"_\"&A34&\"@notaol.com\"","v":"Sheli_Das@notaol.com"}]
[{"$f":"A34&\"_\"&A35&\"@notaol.com\"","v":"Das_2 15th St.@notaol.com"}]
[]
["Jon"]
["Teddy"]
["3 17th St."]
["Seattle"]
["WA"]
[98114]
["206-515-5102"]
[{"$f":"A43&\"_\"&A44&\"@notaol.com\"","v":"Jon_Teddy@notaol.com"}]
[{"$f":"A44&\"_\"&A45&\"@notaol.com\"","v":"Teddy_3 17th St.@notaol.com"}]
[]
["Jeri"]
["Yessler"]
["12 16th St."]
["Seattle"]
["WA"]
[98114]
["206-583-2943"]
[{"$f":"A53&\"_\"&A54&\"@notaol.com\"","v":"Jeri_Yessler@notaol.com"}]
[{"$f":"A54&\"_\"&A55&\"@notaol.com\"","v":"Yessler_12 16th St.@notaol.com"}]
[]
["Luke"]
["Suix"]
["8 19th St."]
["Seattle"]
["WA"]
[98113]
["206-774-4449"]
[{"$f":"A63&\"_\"&A64&\"@notaol.com\"","v":"Luke_Suix@notaol.com"}]
[{"$f":"A64&\"_\"&A65&\"@notaol.com\"","v":"Suix_8 19th St.@notaol.com"}]
[]
["Luke"]
["Red"]
["15 16th St."]
["Seattle"]
["WA"]
[98108]
["206-685-2311"]
[{"$f":"A73&\"_\"&A74&\"@notaol.com\"","v":"Luke_Red@notaol.com"}]
[{"$f":"A74&\"_\"&A75&\"@notaol.com\"","v":"Red_15 16th St.@notaol.com"}]
[]
["Jeri"]
["Smythe"]
["14 19th St."]
["Seattle"]
["WA"]
[98112]
["206-574-6156"]
[{"$f":"A83&\"_\"&A84&\"@notaol.com\"","v":"Jeri_Smythe@notaol.com"}]
[{"$f":"A84&\"_\"&A85&\"@notaol.com\"","v":"Smythe_14 19th St.@notaol.com"}]
[]
["Luke"]
["Rad"]
["3 16th St."]
["Seattle"]
["WA"]
[98106]
["206-599-3338"]
[{"$f":"A93&\"_\"&A94&\"@notaol.com\"","v":"Luke_Rad@notaol.com"}]
[{"$f":"A94&\"_\"&A95&\"@notaol.com\"","v":"Rad_3 16th St.@notaol.com"}]
[]
["Jon"]
["Dap"]
["5 19th St."]
["Seattle"]
["WA"]
[98116]
["206-679-1485"]
[{"$f":"A103&\"_\"&A104&\"@notaol.com\"","v":"Jon_Dap@notaol.com"}]
[{"$f":"A104&\"_\"&A105&\"@notaol.com\"","v":"Dap_5 19th St.@notaol.com"}]
[]
["Steve"]
["Gupis"]
["6 17th St."]
["Seattle"]
["WA"]
[98111]
["206-609-1507"]
[{"$f":"A113&\"_\"&A114&\"@notaol.com\"","v":"Steve_Gupis@notaol.com"}]
[{"$f":"A114&\"_\"&A115&\"@notaol.com\"","v":"Gupis_6 17th St.@notaol.com"}]
[]
["Jon"]
["Summi"]
["4 14th St."]
["Seattle"]
["WA"]
[98104]
["206-733-4318"]
[{"$f":"A123&\"_\"&A124&\"@notaol.com\"","v":"Jon_Summi@notaol.com"}]
[{"$f":"A124&\"_\"&A125&\"@notaol.com\"","v":"Summi_4 14th St.@notaol.com"}]
[]
["Sheli"]
["Fun"]
["7 15th St."]
["Seattle"]
["WA"]
[98110]
["206-691-7629"]
[{"$f":"A133&\"_\"&A134&\"@notaol.com\"","v":"Sheli_Fun@notaol.com"}]
[{"$f":"A134&\"_\"&A135&\"@notaol.com\"","v":"Fun_7 15th St.@notaol.com"}]

{"sheet":"M3.6","index":13,"n_rows":141,"n_cols":9,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["First","Last","Address","City","State","Zip","Phone","E1","E2"]
[]
["Steve"]
["Chin"]
["14 17th St."]
["Seattle"]
["WA"]
[98104]
["206-572-3409"]
[{"$f":"A3&\"_\"&A4&\"@notaol.com\"","v":"Steve_Chin@notaol.com"}]
[{"$f":"A4&\"_\"&A5&\"@notaol.com\"","v":"Chin_14 17th St.@notaol.com"}]
[]
["Troun"]
["Tenn"]
["6 19th St."]
["Seattle"]
["WA"]
[98106]
["206-667-3154"]
[{"$f":"A13&\"_\"&A14&\"@notaol.com\"","v":"Troun_Tenn@notaol.com"}]
[{"$f":"A14&\"_\"&A15&\"@notaol.com\"","v":"Tenn_6 19th St.@notaol.com"}]
[]
["Rhond"]
["Tradfren"]
["10 13th St."]
["Seattle"]
["WA"]
[98117]
["206-574-1265"]
[{"$f":"A23&\"_\"&A24&\"@notaol.com\"","v":"Rhond_Tradfren@notaol.com"}]
[{"$f":"A24&\"_\"&A25&\"@notaol.com\"","v":"Tradfren_10 13th St.@notaol.com"}]
[]
["Sheli"]
["Das"]
["2 15th St."]
["Seattle"]
["WA"]
[98111]
["206-637-4014"]
[{"$f":"A33&\"_\"&A34&\"@notaol.com\"","v":"Sheli_Das@notaol.com"}]
[{"$f":"A34&\"_\"&A35&\"@notaol.com\"","v":"Das_2 15th St.@notaol.com"}]
[]
["Jon"]
["Teddy"]
["3 17th St."]
["Seattle"]
["WA"]
[98114]
["206-515-5102"]
[{"$f":"A43&\"_\"&A44&\"@notaol.com\"","v":"Jon_Teddy@notaol.com"}]
[{"$f":"A44&\"_\"&A45&\"@notaol.com\"","v":"Teddy_3 17th St.@notaol.com"}]
[]
["Jeri"]
["Yessler"]
["12 16th St."]
["Seattle"]
["WA"]
[98114]
["206-583-2943"]
[{"$f":"A53&\"_\"&A54&\"@notaol.com\"","v":"Jeri_Yessler@notaol.com"}]
[{"$f":"A54&\"_\"&A55&\"@notaol.com\"","v":"Yessler_12 16th St.@notaol.com"}]
[]
["Luke"]
["Suix"]
["8 19th St."]
["Seattle"]
["WA"]
[98113]
["206-774-4449"]
[{"$f":"A63&\"_\"&A64&\"@notaol.com\"","v":"Luke_Suix@notaol.com"}]
[{"$f":"A64&\"_\"&A65&\"@notaol.com\"","v":"Suix_8 19th St.@notaol.com"}]
[]
["Luke"]
["Red"]
["15 16th St."]
["Seattle"]
["WA"]
[98108]
["206-685-2311"]
[{"$f":"A73&\"_\"&A74&\"@notaol.com\"","v":"Luke_Red@notaol.com"}]
[{"$f":"A74&\"_\"&A75&\"@notaol.com\"","v":"Red_15 16th St.@notaol.com"}]
[]
["Jeri"]
["Smythe"]
["14 19th St."]
["Seattle"]
["WA"]
[98112]
["206-574-6156"]
[{"$f":"A83&\"_\"&A84&\"@notaol.com\"","v":"Jeri_Smythe@notaol.com"}]
[{"$f":"A84&\"_\"&A85&\"@notaol.com\"","v":"Smythe_14 19th St.@notaol.com"}]
[]
["Luke"]
["Rad"]
["3 16th St."]
["Seattle"]
["WA"]
[98106]
["206-599-3338"]
[{"$f":"A93&\"_\"&A94&\"@notaol.com\"","v":"Luke_Rad@notaol.com"}]
[{"$f":"A94&\"_\"&A95&\"@notaol.com\"","v":"Rad_3 16th St.@notaol.com"}]
[]
["Jon"]
["Dap"]
["5 19th St."]
["Seattle"]
["WA"]
[98116]
["206-679-1485"]
[{"$f":"A103&\"_\"&A104&\"@notaol.com\"","v":"Jon_Dap@notaol.com"}]
[{"$f":"A104&\"_\"&A105&\"@notaol.com\"","v":"Dap_5 19th St.@notaol.com"}]
[]
["Steve"]
["Gupis"]
["6 17th St."]
["Seattle"]
["WA"]
[98111]
["206-609-1507"]
[{"$f":"A113&\"_\"&A114&\"@notaol.com\"","v":"Steve_Gupis@notaol.com"}]
[{"$f":"A114&\"_\"&A115&\"@notaol.com\"","v":"Gupis_6 17th St.@notaol.com"}]
[]
["Jon"]
["Summi"]
["4 14th St."]
["Seattle"]
["WA"]
[98104]
["206-733-4318"]
[{"$f":"A123&\"_\"&A124&\"@notaol.com\"","v":"Jon_Summi@notaol.com"}]
[{"$f":"A124&\"_\"&A125&\"@notaol.com\"","v":"Summi_4 14th St.@notaol.com"}]
[]
["Sheli"]
["Fun"]
["7 15th St."]
["Seattle"]
["WA"]
[98110]
["206-691-7629"]
[{"$f":"A133&\"_\"&A134&\"@notaol.com\"","v":"Sheli_Fun@notaol.com"}]
[{"$f":"A134&\"_\"&A135&\"@notaol.com\"","v":"Fun_7 15th St.@notaol.com"}]

{"sheet":"M4","index":14,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Numbers","Words"]
[12.23]
[64537.23]
[857564]
[1]
[]
[]
[]
["4)    Search for VBA Code online: Function to spell out numbers as words"]

{"sheet":"M5","index":15,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Numbers",null,"Add",null,"Color"]
[3]
[4,null,null,null,null,null,"Update:"]
[5,null,null,null,null,null,"Ctrl + Shift + Alt + F9"]
[3]
[5]
[8]
[9]
[5]
[4]
[7]
[5]
[4]
[]
[]
[]
["5)    Search for VBA Code online: Add or count cells with red fill"]

{"sheet":"M6","index":16,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Date","Customer","Product","Sales"]
[]
[]
[]
[]
[]
[]
["6)    Form Control Button to Add Record to Existing Proper Data Set"]

{"sheet":"ProperDataSet","index":17,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Date","Customer","Product","Sales"]
["2016-07-07","SeaTac BMX","Quad",198]