{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Welcome","Info","Macro recording basics","Macro recording","Record with calculations"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":31,"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":"Welcome","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,13],[15,6,15,9],[11,6,13,9],[3,2,3,3],[1,0,1,13],[4,0,5,13],[6,0,6,13],[8,6,9,9]]}
[]
["Introduction to Excel VBA"]
[]
[]
["This document is for training purposes only. Financial Edge accepts no responsibility or liability for any other purpose or usage."]
[]
[{"$f":"\"© \"&YEAR(TODAY())&\" Financial Edge Training\"","v":"© 2023 Financial Edge Training"}]

{"sheet":"Info","index":1,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,1,16,2],[3,11,3,15],[3,1,3,8],[12,1,12,11],[17,1,17,2],[16,3,16,11],[17,3,17,11],[4,13,4,16],[5,13,5,16],[6,13,6,16],[7,13,7,16],[8,13,8,16],[9,13,9,16],[12,14,12,16]]}
[{"$f":"Welcome!A2","v":"Introduction to Excel VBA"}]
["Workout Information"]
[]
[null,"Features",null,null,null,null,null,null,null,null,null,"Model Details"]
[null,"◦","Macro recording",null,null,null,null,null,null,null,null,"Company name",null,"ABC Incorporated"]
[null,null,null,null,null,null,null,null,null,null,null,"Date",null,"2015-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,"Currency",null,"USD"]
[null,null,null,null,null,null,null,null,null,null,null,"Units",null,"Millions"]
[null,null,null,null,null,null,null,null,null,null,null,"Analyst Name",null,"Firstname Lastname"]
[null,null,null,null,null,null,null,null,null,null,null,"Circular Switch",null,0]
[]
[]
[null,"Tab Structure",null,null,null,null,null,null,null,null,null,null,null,null,"Formatting"]
[null,"Macro recording basics"]
[null,"Macro recording",null,null,null,null,null,null,null,null,null,null,null,null,null,"Input"]
[null,"Record with calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hard coded"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas"]

{"sheet":"Macro recording basics","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Info!A1","v":"Introduction to Excel VBA"}]
[{"$f":"Info!B14","v":"Macro recording basics"}]
[]
["Workout 1"]
[null,"Record a macro to enter your name in cell B8"]
[]
[null,"Enter Name","See Module 1, EnterName1 macro"]
[]
[]
["Workout 2"]
[null,"Record a macro to enter your name in cell B15."]
[null,"Use Releatives references should be switched on.  Start the macro recrding with cell A15 selected."]
[]
[null,"Enter Name","See Module 1, EnterName2 macro"]

{"sheet":"Macro recording","index":3,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Info!A1","v":"Introduction to Excel VBA"}]
[{"$f":"Info!B15","v":"Macro recording"}]
[]
["Workout 3"]
[null,"Use Record Macro to record the following:",null,"See Module 1, CopyPaste macro"]
[null,"Copy cells C10:D22 to cell F10",null,"Macro assigned to Form Control button"]
[null,"Select cells G11:G22, format bold and align text to centre"]
[]
[]
[null,null,null,"Net income"]
[null,null,"January",125]
[null,null,"February",350]
[null,null,"March",475]
[null,null,"April",325]
[null,null,"May",120]
[null,null,"June",250]
[null,null,"July",160]
[null,null,"August",250]
[null,null,"September",310]
[null,null,"October",160]
[null,null,"November",190]
[null,null,"December",80]
[]
["Workout 4"]
[null,"Step into the code recorded in Workout 3",null,"See Module 1, CopyPasteEdited macro"]
[null,"Edit the code to remove superfluous instructions"]
[null,"Check the macro still carries out the requirements given in Workout 3"]

{"sheet":"Record with calculations","index":4,"n_rows":248,"n_cols":11,"rows_kept":248,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Welcome!A2","v":"Introduction to Excel VBA"}]
[{"$f":"Info!B16","v":"Record with calculations"}]
[]
[null,"Order Date","Region","City","Category","Product","Quantity","Unit Price",null,null,"See Module 2, AddTotalsAndFormat macro"]
[null,"2020-01-01","East","Boston","Bars","Carrot",33,1.7699999999999998]
[null,"2020-01-04","East","Boston","Crackers","Whole Wheat",87,3.4899999999999998]
[null,"2020-01-07","West","Los Angeles","Cookies","Chocolate Chip",58,1.8699999999999999]
[null,"2020-01-10","East","New York","Cookies","Chocolate Chip",82,1.87]
[null,"2020-01-13","East","Boston","Cookies","Arrowroot",38,2.1800000000000002]
[null,"2020-01-16","East","Boston","Bars","Carrot",54,1.77]
[null,"2020-01-19","East","Boston","Crackers","Whole Wheat",149,3.4899999999999998]
[null,"2020-01-22","West","Los Angeles","Bars","Carrot",51,1.77]
[null,"2020-01-25","East","New York","Bars","Carrot",100,1.77]
[null,"2020-01-28","East","New York","Snacks","Potato Chips",28,1.35]
[null,"2020-01-31","East","Boston","Cookies","Arrowroot",36,2.1800000000000002]
[null,"2020-02-03","East","Boston","Cookies","Chocolate Chip",31,1.8699999999999999]
[null,"2020-02-06","East","Boston","Crackers","Whole Wheat",28,3.4899999999999998]
[null,"2020-02-09","West","Los Angeles","Bars","Carrot",44,1.7699999999999998]
[null,"2020-02-12","East","New York","Bars","Carrot",23,1.77]
[null,"2020-02-15","East","New York","Snacks","Potato Chips",27,1.35]
[null,"2020-02-18","East","Boston","Cookies","Arrowroot",43,2.1799999999999997]
[null,"2020-02-21","East","Boston","Cookies","Oatmeal Raisin",123,2.84]
[null,"2020-02-24","West","Los Angeles","Bars","Bran",42,1.87]
[null,"2020-02-27","West","Los Angeles","Cookies","Oatmeal Raisin",33,2.84]
[null,"2020-03-02","East","New York","Cookies","Chocolate Chip",85,1.8699999999999999]
[null,"2020-03-05","West","San Diego","Cookies","Oatmeal Raisin",30,2.8400000000000003]
[null,"2020-03-08","East","Boston","Bars","Carrot",61,1.77]
[null,"2020-03-11","East","Boston","Crackers","Whole Wheat",40,3.4899999999999998]
[null,"2020-03-14","West","Los Angeles","Cookies","Chocolate Chip",86,1.8699999999999999]
[null,"2020-03-17","East","New York","Bars","Carrot",38,1.7700000000000002]
[null,"2020-03-20","East","New York","Snacks","Potato Chips",68,1.68]
[null,"2020-03-23","West","San Diego","Cookies","Chocolate Chip",39,1.87]
[null,"2020-03-26","East","Boston","Bars","Bran",103,1.87]
[null,"2020-03-29","East","Boston","Cookies","Oatmeal Raisin",193,2.84]
[null,"2020-04-01","West","Los Angeles","Bars","Carrot",58,1.77]
[null,"2020-04-04","West","Los Angeles","Snacks","Potato Chips",68,1.68]
[null,"2020-04-07","East","New York","Bars","Carrot",91,1.77]
[null,"2020-04-10","East","New York","Crackers","Whole Wheat",23,3.4899999999999998]
[null,"2020-04-13","West","San Diego","Snacks","Potato Chips",28,1.68]
[null,"2020-04-16","East","Boston","Bars","Carrot",48,1.7699999999999998]
[null,"2020-04-19","East","Boston","Snacks","Potato Chips",134,1.68]
[null,"2020-04-22","West","Los Angeles","Bars","Carrot",20,1.77]
[null,"2020-04-25","East","New York","Bars","Carrot",53,1.77]
[null,"2020-04-28","East","New York","Snacks","Potato Chips",64,1.68]
[null,"2020-05-01","West","San Diego","Cookies","Chocolate Chip",63,1.87]
[null,"2020-05-04","East","Boston","Bars","Bran",105,1.8699999999999999]
[null,"2020-05-07","East","Boston","Cookies","Oatmeal Raisin",138,2.8400000000000003]
[null,"2020-05-10","West","Los Angeles","Bars","Carrot",25,1.77]
[null,"2020-05-13","West","Los Angeles","Crackers","Whole Wheat",21,3.49]
[null,"2020-05-16","East","New York","Bars","Carrot",61,1.77]
[null,"2020-05-19","East","New York","Snacks","Potato Chips",49,1.68]
[null,"2020-05-22","West","San Diego","Cookies","Chocolate Chip",55,1.8699999999999999]
[null,"2020-05-25","East","Boston","Cookies","Arrowroot",27,2.1800000000000002]
[null,"2020-05-28","East","Boston","Bars","Carrot",58,1.77]
[null,"2020-05-31","East","Boston","Crackers","Whole Wheat",33,3.49]
[null,"2020-06-03","West","Los Angeles","Cookies","Oatmeal Raisin",288,2.84]
[null,"2020-06-06","East","New York","Cookies","Chocolate Chip",76,1.87]
[null,"2020-06-09","West","San Diego","Bars","Carrot",42,1.77]
[null,"2020-06-12","West","San Diego","Crackers","Whole Wheat",20,3.4899999999999998]
[null,"2020-06-15","East","Boston","Bars","Carrot",75,1.77]
[null,"2020-06-18","East","Boston","Crackers","Whole Wheat",38,3.49]
[null,"2020-06-21","West","Los Angeles","Bars","Carrot",306,1.77]
[null,"2020-06-24","West","Los Angeles","Snacks","Potato Chips",28,1.68]
[null,"2020-06-27","East","New York","Bars","Bran",110,1.8699999999999999]
[null,"2020-06-30","East","New York","Cookies","Oatmeal Raisin",51,2.84]
[null,"2020-07-03","West","San Diego","Bars","Carrot",52,1.77]
[null,"2020-07-06","West","San Diego","Crackers","Whole Wheat",28,3.4899999999999998]
[null,"2020-07-09","East","Boston","Bars","Carrot",136,1.77]
[null,"2020-07-12","East","Boston","Crackers","Whole Wheat",42,3.49]
[null,"2020-07-15","West","Los Angeles","Cookies","Chocolate Chip",75,1.87]
[null,"2020-07-18","East","New York","Bars","Bran",72,1.8699999999999999]
[null,"2020-07-21","East","New York","Cookies","Oatmeal Raisin",56,2.84]
[null,"2020-07-24","West","San Diego","Bars","Bran",51,1.87]
[null,"2020-07-27","West","San Diego","Snacks","Potato Chips",31,1.68]
[null,"2020-07-30","East","Boston","Bars","Bran",56,1.8699999999999999]
[null,"2020-08-02","East","Boston","Cookies","Oatmeal Raisin",137,2.84]
[null,"2020-08-05","West","Los Angeles","Cookies","Chocolate Chip",107,1.87]
[null,"2020-08-08","East","New York","Bars","Carrot",24,1.7699999999999998]
[null,"2020-08-11","East","New York","Crackers","Whole Wheat",30,3.49]
[null,"2020-08-14","West","San Diego","Cookies","Chocolate Chip",70,1.87]
[null,"2020-08-17","East","Boston","Cookies","Arrowroot",31,2.1800000000000002]
[null,"2020-08-20","East","Boston","Bars","Carrot",109,1.77]
[null,"2020-08-23","East","Boston","Crackers","Whole Wheat",21,3.49]
[null,"2020-08-26","West","Los Angeles","Cookies","Chocolate Chip",80,1.8699999999999999]
[null,"2020-08-29","East","New York","Bars","Bran",75,1.87]
[null,"2020-09-01","East","New York","Cookies","Oatmeal Raisin",74,2.84]
[null,"2020-09-04","West","San Diego","Bars","Carrot",45,1.77]
[null,"2020-09-07","East","Boston","Cookies","Arrowroot",28,2.1800000000000002]
[null,"2020-09-10","East","Boston","Bars","Carrot",143,1.77]
[null,"2020-09-13","East","Boston","Snacks","Pretzels",27,3.15]
[null,"2020-09-16","West","Los Angeles","Bars","Carrot",133,1.77]
[null,"2020-09-19","East","New York","Cookies","Arrowroot",110,2.1800000000000002]
[null,"2020-09-22","East","New York","Cookies","Chocolate Chip",65,1.8699999999999999]
[null,"2020-09-25","West","San Diego","Bars","Bran",33,1.87]
[null,"2020-09-28","East","Boston","Cookies","Arrowroot",81,2.1800000000000002]
[null,"2020-10-01","East","Boston","Bars","Carrot",77,1.7699999999999998]
[null,"2020-10-04","East","Boston","Crackers","Whole Wheat",38,3.49]
[null,"2020-10-07","West","Los Angeles","Bars","Carrot",40,1.77]
[null,"2020-10-10","West","Los Angeles","Snacks","Potato Chips",114,1.6800000000000002]
[null,"2020-10-13","East","New York","Cookies","Arrowroot",224,2.1800000000000002]
[null,"2020-10-16","East","New York","Bars","Carrot",141,1.77]
[null,"2020-10-19","East","New York","Crackers","Whole Wheat",32,3.49]
[null,"2020-10-22","West","San Diego","Bars","Carrot",20,1.77]
[null,"2020-10-25","East","Boston","Cookies","Arrowroot",40,2.1800000000000002]
[null,"2020-10-28","East","Boston","Cookies","Chocolate Chip",49,1.8699999999999999]
[null,"2020-10-31","East","Boston","Crackers","Whole Wheat",46,3.4899999999999998]
[null,"2020-11-03","West","Los Angeles","Bars","Carrot",39,1.77]
[null,"2020-11-06","West","Los Angeles","Snacks","Potato Chips",62,1.68]
[null,"2020-11-09","East","New York","Bars","Carrot",90,1.77]
[null,"2020-11-12","West","San Diego","Cookies","Arrowroot",103,2.1799999999999997]
[null,"2020-11-15","West","San Diego","Cookies","Oatmeal Raisin",32,2.84]
[null,"2020-11-18","East","Boston","Bars","Bran",66,1.87]
[null,"2020-11-21","East","Boston","Cookies","Oatmeal Raisin",97,2.8400000000000003]
[null,"2020-11-24","West","Los Angeles","Bars","Carrot",30,1.77]
[null,"2020-11-27","West","Los Angeles","Snacks","Potato Chips",29,1.68]
[null,"2020-11-30","East","New York","Bars","Carrot",92,1.77]
[null,"2020-12-03","West","San Diego","Cookies","Arrowroot",139,2.1799999999999997]
[null,"2020-12-06","West","San Diego","Cookies","Oatmeal Raisin",29,2.84]
[null,"2020-12-09","East","Boston","Bars","Banana",30,2.27]
[null,"2020-12-12","East","Boston","Cookies","Chocolate Chip",36,1.8699999999999999]
[null,"2020-12-15","East","Boston","Crackers","Whole Wheat",41,3.49]
[null,"2020-12-18","West","Los Angeles","Bars","Carrot",44,1.7699999999999998]
[null,"2020-12-21","West","Los Angeles","Snacks","Potato Chips",29,1.68]
[null,"2020-12-24","East","New York","Cookies","Arrowroot",237,2.1799999999999997]
[null,"2020-12-27","East","New York","Cookies","Chocolate Chip",65,1.8699999999999999]
[null,"2020-12-30","West","San Diego","Cookies","Arrowroot",83,2.1800000000000002]
[null,"2021-01-02","East","Boston","Cookies","Arrowroot",32,2.1800000000000002]
[null,"2021-01-05","East","Boston","Bars","Carrot",63,1.77]
[null,"2021-01-08","East","Boston","Snacks","Pretzels",29,3.15]
[null,"2021-01-11","West","Los Angeles","Bars","Bran",77,1.87]
[null,"2021-01-14","West","Los Angeles","Cookies","Oatmeal Raisin",80,2.84]
[null,"2021-01-17","East","New York","Bars","Carrot",102,1.77]
[null,"2021-01-20","East","New York","Crackers","Whole Wheat",31,3.4899999999999998]
[null,"2021-01-23","West","San Diego","Bars","Carrot",56,1.77]
[null,"2021-01-26","East","Boston","Cookies","Arrowroot",52,2.1800000000000002]
[null,"2021-01-29","East","Boston","Bars","Carrot",51,1.77]
[null,"2021-02-01","East","Boston","Snacks","Potato Chips",24,1.68]
[null,"2021-02-04","West","Los Angeles","Cookies","Arrowroot",58,2.1800000000000002]
[null,"2021-02-07","West","Los Angeles","Cookies","Chocolate Chip",34,1.8699999999999999]
[null,"2021-02-10","East","New York","Bars","Carrot",34,1.77]
[null,"2021-02-13","East","New York","Snacks","Potato Chips",21,1.6800000000000002]
[null,"2021-02-16","West","San Diego","Cookies","Oatmeal Raisin",29,2.84]
[null,"2021-02-19","East","Boston","Bars","Carrot",68,1.77]
[null,"2021-02-22","East","Boston","Snacks","Pretzels",31,3.1500000000000004]
[null,"2021-02-25","West","Los Angeles","Cookies","Arrowroot",30,2.1800000000000002]
[null,"2021-02-28","West","Los Angeles","Cookies","Chocolate Chip",232,1.8699999999999999]
[null,"2021-03-02","East","New York","Bars","Bran",68,1.8699999999999999]
[null,"2021-03-05","East","New York","Cookies","Oatmeal Raisin",97,2.8400000000000003]
[null,"2021-03-08","West","San Diego","Bars","Bran",86,1.8699999999999999]
[null,"2021-03-11","West","San Diego","Snacks","Potato Chips",41,1.68]
[null,"2021-03-14","East","Boston","Bars","Carrot",93,1.7700000000000002]
[null,"2021-03-17","East","Boston","Snacks","Potato Chips",47,1.68]
[null,"2021-03-20","West","Los Angeles","Bars","Carrot",103,1.77]
[null,"2021-03-23","West","Los Angeles","Snacks","Potato Chips",33,1.68]
[null,"2021-03-26","East","New York","Bars","Bran",57,1.87]
[null,"2021-03-29","East","New York","Cookies","Oatmeal Raisin",65,2.84]
[null,"2021-04-01","West","San Diego","Bars","Carrot",118,1.77]
[null,"2021-04-04","East","Boston","Cookies","Arrowroot",36,2.1800000000000002]
[null,"2021-04-07","East","Boston","Cookies","Oatmeal Raisin",123,2.84]
[null,"2021-04-10","West","Los Angeles","Bars","Carrot",90,1.77]
[null,"2021-04-13","West","Los Angeles","Crackers","Whole Wheat",21,3.49]
[null,"2021-04-16","East","New York","Bars","Carrot",48,1.7699999999999998]
[null,"2021-04-19","East","New York","Snacks","Potato Chips",24,1.68]
[null,"2021-04-22","West","San Diego","Cookies","Chocolate Chip",67,1.87]
[null,"2021-04-25","East","Boston","Bars","Bran",27,1.87]
[null,"2021-04-28","East","Boston","Cookies","Oatmeal Raisin",129,2.8400000000000003]
[null,"2021-05-01","West","Los Angeles","Cookies","Arrowroot",77,2.1800000000000002]
[null,"2021-05-04","West","Los Angeles","Cookies","Chocolate Chip",58,1.8699999999999999]
[null,"2021-05-07","East","New York","Bars","Bran",47,1.87]
[null,"2021-05-10","East","New York","Cookies","Oatmeal Raisin",33,2.84]
[null,"2021-05-13","West","San Diego","Cookies","Chocolate Chip",82,1.87]
[null,"2021-05-16","East","Boston","Bars","Carrot",58,1.77]
[null,"2021-05-19","East","Boston","Snacks","Pretzels",30,3.15]
[null,"2021-05-22","West","Los Angeles","Cookies","Chocolate Chip",43,1.8699999999999999]
[null,"2021-05-25","East","New York","Bars","Carrot",84,1.77]
[null,"2021-05-28","West","San Diego","Cookies","Arrowroot",36,2.1800000000000002]
[null,"2021-05-31","West","San Diego","Cookies","Oatmeal Raisin",44,2.84]
[null,"2021-06-03","East","Boston","Bars","Bran",27,1.87]
[null,"2021-06-06","East","Boston","Cookies","Oatmeal Raisin",120,2.8400000000000003]
[null,"2021-06-09","East","Boston","Crackers","Whole Wheat",26,3.4899999999999998]
[null,"2021-06-12","West","Los Angeles","Bars","Carrot",73,1.77]
[null,"2021-06-15","East","New York","Bars","Bran",38,1.87]
[null,"2021-06-18","East","New York","Cookies","Oatmeal Raisin",40,2.84]
[null,"2021-06-21","West","San Diego","Bars","Carrot",41,1.7699999999999998]
[null,"2021-06-24","East","Boston","Bars","Banana",27,2.27]
[null,"2021-06-27","East","Boston","Cookies","Chocolate Chip",38,1.87]
[null,"2021-06-30","East","Boston","Crackers","Whole Wheat",34,3.4899999999999998]
[null,"2021-07-03","West","Los Angeles","Bars","Bran",65,1.8699999999999999]
[null,"2021-07-06","West","Los Angeles","Cookies","Oatmeal Raisin",60,2.8400000000000003]
[null,"2021-07-09","East","New York","Cookies","Arrowroot",37,2.1799999999999997]
[null,"2021-07-12","East","New York","Cookies","Chocolate Chip",40,1.8699999999999999]
[null,"2021-07-15","West","San Diego","Bars","Bran",26,1.8699999999999999]
[null,"2021-07-18","East","Boston","Bars","Banana",22,2.27]
[null,"2021-07-21","East","Boston","Cookies","Chocolate Chip",32,1.87]
[null,"2021-07-24","East","Boston","Crackers","Whole Wheat",23,3.4899999999999998]
[null,"2021-07-27","West","Los Angeles","Cookies","Arrowroot",20,2.1800000000000002]
[null,"2021-07-30","West","Los Angeles","Cookies","Chocolate Chip",64,1.87]
[null,"2021-08-02","East","New York","Bars","Carrot",71,1.77]
[null,"2021-08-05","West","San Diego","Cookies","Arrowroot",90,2.1799999999999997]
[null,"2021-08-08","West","San Diego","Cookies","Oatmeal Raisin",38,2.84]
[null,"2021-08-11","East","Boston","Bars","Carrot",55,1.7699999999999998]
[null,"2021-08-14","East","Boston","Snacks","Pretzels",22,3.15]
[null,"2021-08-17","West","Los Angeles","Bars","Carrot",34,1.77]
[null,"2021-08-20","East","New York","Bars","Bran",39,1.87]
[null,"2021-08-23","East","New York","Cookies","Oatmeal Raisin",41,2.84]
[null,"2021-08-26","West","San Diego","Bars","Carrot",41,1.7699999999999998]
[null,"2021-08-29","East","Boston","Cookies","Arrowroot",136,2.1800000000000002]
[null,"2021-09-01","East","Boston","Bars","Carrot",25,1.77]
[null,"2021-09-04","East","Boston","Snacks","Pretzels",26,3.1500000000000004]
[null,"2021-09-07","West","Los Angeles","Bars","Bran",50,1.87]
[null,"2021-09-10","West","Los Angeles","Cookies","Oatmeal Raisin",79,2.8400000000000003]
[null,"2021-09-13","East","New York","Bars","Carrot",30,1.77]
[null,"2021-09-16","East","New York","Snacks","Potato Chips",20,1.6800000000000002]
[null,"2021-09-19","West","San Diego","Bars","Carrot",49,1.77]
[null,"2021-09-22","East","Boston","Cookies","Arrowroot",40,2.1800000000000002]
[null,"2021-09-25","East","Boston","Bars","Carrot",31,1.77]
[null,"2021-09-28","East","Boston","Snacks","Pretzels",21,3.1500000000000004]
[null,"2021-10-01","West","Los Angeles","Bars","Bran",43,1.8699999999999999]
[null,"2021-10-04","West","Los Angeles","Cookies","Oatmeal Raisin",47,2.84]
[null,"2021-10-07","East","New York","Cookies","Arrowroot",175,2.1800000000000002]
[null,"2021-10-10","East","New York","Cookies","Chocolate Chip",23,1.8699999999999999]
[null,"2021-10-13","West","San Diego","Bars","Carrot",40,1.77]
[null,"2021-10-16","East","Boston","Cookies","Arrowroot",87,2.1800000000000002]
[null,"2021-10-19","East","Boston","Bars","Carrot",43,1.77]
[null,"2021-10-22","East","Boston","Crackers","Whole Wheat",30,3.49]
[null,"2021-10-25","West","Los Angeles","Bars","Carrot",35,1.77]
[null,"2021-10-28","East","New York","Bars","Bran",57,1.87]
[null,"2021-10-31","East","New York","Snacks","Potato Chips",25,1.68]
[null,"2021-11-03","West","San Diego","Cookies","Chocolate Chip",24,1.87]
[null,"2021-11-06","East","Boston","Bars","Bran",83,1.87]
[null,"2021-11-09","East","Boston","Cookies","Oatmeal Raisin",124,2.8400000000000003]
[null,"2021-11-12","West","Los Angeles","Bars","Carrot",137,1.77]
[null,"2021-11-15","East","New York","Cookies","Arrowroot",146,2.1799999999999997]
[null,"2021-11-18","East","New York","Cookies","Chocolate Chip",34,1.8699999999999999]
[null,"2021-11-21","West","San Diego","Bars","Carrot",20,1.77]
[null,"2021-11-24","East","Boston","Cookies","Arrowroot",139,2.1799999999999997]
[null,"2021-11-27","East","Boston","Cookies","Chocolate Chip",211,1.8699999999999999]
[null,"2021-11-30","East","Boston","Crackers","Whole Wheat",20,3.4899999999999998]
[null,"2021-12-03","West","Los Angeles","Bars","Bran",42,1.87]
[null,"2021-12-06","West","Los Angeles","Cookies","Oatmeal Raisin",100,2.84]
[null,"2021-12-09","East","New York","Bars","Carrot",38,1.7700000000000002]
[null,"2021-12-12","East","New York","Crackers","Whole Wheat",25,3.49]
[null,"2021-12-15","West","San Diego","Cookies","Chocolate Chip",96,1.87]
[null,"2021-12-18","East","Boston","Cookies","Arrowroot",34,2.1800000000000002]
[null,"2021-12-21","East","Boston","Cookies","Chocolate Chip",245,1.8699999999999999]
[null,"2021-12-24","East","Boston","Crackers","Whole Wheat",30,3.49]
[null,"2021-12-27","West","Los Angeles","Bars","Bran",30,1.87]
[null,"2021-12-30","West","Los Angeles","Cookies","Oatmeal Raisin",44,2.84]