{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Score","Initial-Instructions","P(1)","P(2)","P(3)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":"Score","index":0,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Problem","Description","Possible Points","Earned Points","Note"]
[null,"1)","Did you drag Phone field to Rows area?",{"$f":"100/ROWS(D3:D43)","v":2.4390243902439024},{"$f":"D3","v":2.4390243902439024}]
[null,null,"Did you drag Phone field to Values area for Count calculation?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you drag Phone field to Values area for % Count calculation?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you create Informative Report Column Header Names, like Phones Purchased, Count, % Count?",2.4390243902439024,2.4390243902439024]
[null,"2)","Download File Part:",2.4390243902439024,2.4390243902439024]
[null,null,"Did you go to this web site: https://data-seattlecitygis.opendata.arcgis.com/datasets/SeattleCityGIS::sdot-trees/explore?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you NOT download it to the default location on your computer?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you use the Save As dialog box to save the csv file to your Busn 218 folder?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you change the csv file name to \"YourNameSeattleTrees.csv\"? If your name is Ty Cox, your file name must be: \"TyCoxSeattleTrees.csv\". If you do not rename this file, your test score will be zero.",2.4390243902439024,2.4390243902439024]
[null,null,"Power Query Part:",2.4390243902439024,2.4390243902439024]
[null,null,"Did you import your csv file into the Power Query Editor?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you create a new column for Year?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you create a new column for Time?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you select the four columns: \"Date\", \"Fremont Bridge Sidewalks, south of N 34th St\", \"Year\", \"Time\", and remove the other columns?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you filter the \"Year\" column to include only 2023 records?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you load the 8,760 records to the Excel Worksheet?",2.4390243902439024,2.4390243902439024]
[null,null,"PivotTable Part:",2.4390243902439024,2.4390243902439024]
[null,null,"Did you create a PivotTable with Time in the Row?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you use the \"Fremont Bridge Sidewalks, south of N 34th St\" column to calculate average number of riders per hour?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you have informative column hedaers in PivotTable?",2.4390243902439024,2.4390243902439024]
[null,null,"Chart Visualization Part:",2.4390243902439024,2.4390243902439024]
[null,null,"Did you use a Line Chart?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you have Time in horizontal axis?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you show the average in the vertical axis?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you have an informative chart title?",2.4390243902439024,2.4390243902439024]
[null,null,"Other 1",2.4390243902439024,2.4390243902439024]
[null,null,"Other 2",2.4390243902439024,2.4390243902439024]
[null,"3)","Create new Product column in table with formula like: =XLOOKUP([@ProductID],dProduct[ProductID],dProduct[Price])*[@Units]",2.4390243902439024,2.4390243902439024]
[null,null,"Create new Region column in table with formula like: =XLOOKUP([@SalesRepID],dSalesRep[SalesRepID],dSalesRep[Region])",2.4390243902439024,2.4390243902439024]
[null,null,"Create new Sales column in table with formula like: =XLOOKUP([@ProductID],dProduct[ProductID],dProduct[Price])*[@Units]",2.4390243902439024,2.4390243902439024]
[null,null,"Did you drag Region field to Rows area?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you drag Product field to Rows area?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you drag Sales field to Values area for Sum calculation?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you create Informative Report Column Header Names, like \"Region\" and \"Product\" and \"Sales($)\"?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you use a Column Chart?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you have Region and Product in horizontal axis?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you show the sum of sales in the vertical axis?",2.4390243902439024,2.4390243902439024]
[null,null,"Did you have an informative chart title?",2.4390243902439024,2.4390243902439024]
[null,null,"Other 1",2.4390243902439024,2.4390243902439024]
[null,null,"Other 2",2.4390243902439024,2.4390243902439024]
[null,null,"Did you have your name in the test file?",2.4390243902439024,2.4390243902439024]
[null,null,"Total Possible Points",{"$f":"SUM(D3:D43)","v":99.999999999999957}]
[null,null,"Is Test Submitted Past due date-time?","No",{"$f":"IF(D45=\"Yes\",-0.25*SUM(E3:E43),\"\")","v":""},{"$f":"IF(D45=\"Yes\",\"Deduction for late test\",\"\")","v":""}]
[null,null,null,"Your Earned Test Score:",{"$f":"SUM(E3:E45)","v":99.999999999999957}]
[]
[]
[null,"Be sure to scroll up to see whole score sheet.",null,null,null,"fall 2022"]

{"sheet":"Initial-Instructions","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["* This test covers everything in class up to minute marks 00:00 to 01:28:37 in MECS video #4"]
[null,"Test Instructions:"]
["1)","You must rename each test file so that the file name contains your name."]
[null,"For example, if your name is “Sioux Noline” and the test file has the name “Busn218Fall2022Test06.xlsm\","]
[null,"you MUST rename the file to become: “SiouxNoline Busn218Fall2022Test06.xlsm”."]
[null,"Tests that do not follow this naming rule are scored as zero."]
["2)","The Excel test file MUST use the file extension \".xlsm\". Tests that do not follow this rule are scored as zero."]
["3)","This test has five problems on the worksheets with the names \"P(1)\", \"P(2)\", \"P(3)\", \"P(4)\" and \"P(5)\". You will also have to use other files for these problems."]
["4)","Late tests without a documentable emergency are assessed as a 25% deduction."]
[null,"You can hand in tests late if a documentable emergency occurs, like documented deaths or medical emergencies."]
[5,"The test scores earned will count toward your grade for the class."]
[]
["If you have questions you can contact Michael Girvin: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[null,null,null,null,null,"Fall, 2022 File"]

{"sheet":"P(1)","index":2,"n_rows":396,"n_cols":10,"rows_kept":396,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data: You are given survey data from customers preferences on cola drinks."]
[null,"Goal: ","Summarize survey results to show count and % count, similar to Example #4 in MECS video #4 at the 15:58 minute mark. Link to right =>",null,null,null,null,"MECS04",null," https://www.youtube.com/watch?v=TjSnQ4VDHTE&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=8&t=958s"]
[null,null,"Data = about 390 rows = "]
[null,"Create the Report on this Worksheet."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[null,null,"Survey Results",null,"Survey Results","Count","% Count"]
[null,null,"Coca Cola",null,"Coca Cola",143,0.3704663212435233]
[null,null,"Coke",null,"Coke",103,0.26683937823834197]
[null,null,"Shasta Cola",null,"Pepsi",72,0.18652849740932642]
[null,null,"Coca Cola",null,"RC Cola",42,0.10880829015544041]
[null,null,"Coca Cola",null,"Shasta Cola",26,6.7357512953367879E-2]
[null,null,"Coke",null,"Grand Total",386,1]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Shasta Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"RC Cola"]
[null,null,"Shasta Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Shasta Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Shasta Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"RC Cola"]
[null,null,"Shasta Cola"]
[null,null,"RC Cola"]
[null,null,"RC Cola"]
[null,null,"Pepsi"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Shasta Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"RC Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Shasta Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Shasta Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"RC Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Shasta Cola"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Shasta Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"RC Cola"]
[null,null,"Shasta Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"RC Cola"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Shasta Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"RC Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Shasta Cola"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Shasta Cola"]
[null,null,"Coke"]
[null,null,"Pepsi"]
[null,null,"Shasta Cola"]
[null,null,"RC Cola"]
[null,null,"Pepsi"]
[null,null,"Pepsi"]
[null,null,"RC Cola"]
[null,null,"Shasta Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coke"]
[null,null,"Coca Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"RC Cola"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]
[null,null,"RC Cola"]
[null,null,"Shasta Cola"]
[null,null,"Pepsi"]
[null,null,"Coca Cola"]
[null,null,"Coca Cola"]
[null,null,"Coke"]

{"sheet":"P(2)","index":3,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Back Story:"]
[null,"Your boss works in the transportation department for the City of Seattle and wants to know how many bicyclists use the Seattle's Fremont Bridge per hour for the year 2023. "]
[null,"Since the year 2013, the Fremont Bridge has tracked the number of bikes per hour on the Fremont Bridge and made the data available online."]
["1)","Goal: Download Fremont Bridge data in a csv file and then import, clean, transform and load the data as a Table to this Excel Worksheet, then create a PivotTable and Chart."]
["2)","Go to this web site: ",null,"https://data.seattle.gov/Transportation/Fremont-Bridge-Bicycle-Counter/65db-xm6k/about_data"]
["3)","In the upper right corner, click the Export button. Then click the CSV Download button. Change the file name to \"YourNameFremontBridgeBikeData.csv\"."]
[null,"1) DO NOT download it to the default location on your computer."]
[null,"2) Using the Save As dialog box save the csv file to your Busn 218 folder."]
[null,"3) If your name is Ty Cox, change the file name to: \"TyCoxFremontBridgeBikeData.csv\". If you do not rename this file, your test score will be zero."]
["4) Using Power Query to import, clean, transform and load the data to the worksheet, follow these steps:"]
[null,"1) Import your csv file into the Power Query Editor"]
[null,"2) In the Power Query Editor, to create a new column for year: select the Date column, Click the Add Column tab in the Power Query Ribbon,"]
[null,"in the From Date & Time group, click the Date dropdown arrow and then click Year."]
[null,"3) In the Power Query Editor, to create a new column for time: select the Date column, Click the Add Column tab in the Power Query Ribbon,"]
[null,"in the From Date & Time group, click the Time dropdown arrow and then click Time Only."]
[null,"4) Select the four columns: \"Date\", \"Fremont Bridge Sidewalks, south of N 34th St\", \"Year\", \"Time\", and remove the other columns."]
[null,"5) Filter the \"Year\" column to include only 2023 records."]
[null,"6) Load the 8,760 records to the Excel Worksheet below."]
["MECS video #4 at the 20:25 minute mark shows how to import a csv file and then clean and transform the data before loading to Worksheet.  Link to right =>",null,null,null,null,null,null,null,"MECS04"]
["5) After loading the query to the worksheet, add Time Number Formatting to the Time column so that a time like 8:00:00 AM is shown as 8 AM."]
["Hint: Use Ctrl + 1 to open the Format Cells dialog box, in the Number tab, click Custom, then in the Type text box type the time code: h AM/PM"]
["6) Using the column \"Fremont Bridge Sidewalks, south of N 34th St\" as the number of bike riders per hour, "]
["create a PivotTable that calculates the average number of bike riders per hour as shown to the right =>"]
["7) Create a line chart visualization that shows the average number of riders per hour, as shown to right =>"]
["Do not ask for help with test or work with others on test."]
["It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]

{"sheet":"P(3)","index":4,"n_rows":877,"n_cols":17,"rows_kept":877,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal: To the right of the below tables, create the PivotTable report and Chart visual that shows product sales by state. Picture is shown to the right =>"]
[null,"Create PivotTable reports on this Worksheet."]
[null,"Name the report column header for Units \"Total Units\"."]
[null,"Hint: You will have to do some data modeling by using worksheet formulas to create three new columns in the fSales table, Product, Region, and Sales."]
[null,"Data = about 858 rows = "]
[null,"From business sales data"]
["MECS video #4 at the MECS 01:17:51 minute mark shows how to using XLOOKUP to do Data Modeling.  Link to right =>",null,null,null,null,null,null,null,null,"MECS04",null,null,null,null,null,null,"https://www.youtube.com/watch?v=TjSnQ4VDHTE&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=8&t=4671s"]
["Hint: When creating the column for sales you will have to lookup the product price and then multiply it by units, something like this: =XLOOKUP([@ProductID],dProduct[ProductID],dProduct[Price])*[@Units]"]
["Do not copy and paste work previously done."]
["Do not ask for help with test or work with others on test."]
["It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[]
[]
[]
[null,"fSales","Fact Table",null,null,null,null,null,null,"dProduct","Lookup or Dimension Table"]
[]
[null,"Date","ProductID","SalesRepID","Units",null,null,null,null,"ProductID","Product","Supplier","Cost","Price"]
[null,"2022-08-22",2,4,144,null,null,null,null,1,"Quad","Gel Booms",23.75,43.95]
[null,"2023-05-03",4,4,6,null,null,null,null,2,"Carlota","Gel Booms",13.52,29.95]
[null,"2023-11-08",1,2,73,null,null,null,null,3,"Aspen","Colorado Booms",12.48,25.95]
[null,"2021-11-29",2,4,95,null,null,null,null,4,"Yanaki","Colorado Booms",11.67,23.95]
[null,"2021-08-27",2,2,5]
[null,"2022-12-01",2,2,4,null,null,null,null,"dSalesRep","Lookup or Dimension Table"]
[null,"2022-08-16",2,1,91]
[null,"2023-08-23",2,4,1,null,null,null,null,"SalesRepID","SalesRep","Region"]
[null,"2022-01-06",1,2,187,null,null,null,null,1,"Sioux","CA"]
[null,"2023-06-06",2,2,81,null,null,null,null,2,"Chantel","CA"]
[null,"2021-03-19",2,4,80,null,null,null,null,3,"Gigi","WA"]
[null,"2023-02-13",3,2,125,null,null,null,null,4,"Mo","WA"]
[null,"2021-11-11",4,2,3]
[null,"2021-12-06",2,1,57]
[null,"2021-10-14",1,2,1]
[null,"2022-11-21",2,4,4]
[null,"2022-04-12",2,3,2]
[null,"2022-01-27",2,2,238]
[null,"2021-08-20",3,3,102]
[null,"2023-11-03",2,2,242]
[null,"2021-12-24",2,4,150]
[null,"2023-11-23",1,2,6]
[null,"2022-05-26",1,4,78]
[null,"2021-11-18",2,4,75]
[null,"2022-06-07",1,1,6]
[null,"2023-09-07",2,4,2]
[null,"2023-02-01",2,4,71]
[null,"2021-05-10",2,1,251]
[null,"2021-04-12",2,4,88]
[null,"2022-11-22",2,2,6]
[null,"2022-11-06",2,4,230]
[null,"2021-12-29",4,4,185]
[null,"2022-12-31",2,4,75]
[null,"2023-12-15",2,4,3]
[null,"2021-06-17",2,4,209]
[null,"2022-08-24",4,4,4]
[null,"2022-08-26",4,1,280]
[null,"2021-08-19",4,2,52]
[null,"2021-08-18",4,3,101]
[null,"2021-10-08",4,4,89]
[null,"2023-12-11",2,1,1]
[null,"2023-04-13",2,4,4]
[null,"2023-11-10",2,4,6]
[null,"2023-07-08",2,2,159]
[null,"2021-12-05",3,3,6]
[null,"2021-12-20",1,2,3]
[null,"2022-05-08",3,1,1]
[null,"2021-11-01",3,4,6]
[null,"2021-12-13",1,2,14]
[null,"2021-08-07",2,3,71]
[null,"2023-12-17",3,2,101]
[null,"2022-06-10",2,2,27]
[null,"2021-07-20",2,2,1]
[null,"2021-09-04",2,2,36]
[null,"2023-11-23",2,4,31]
[null,"2023-01-26",2,1,196]
[null,"2022-11-18",2,1,6]
[null,"2023-12-13",2,3,110]
[null,"2022-12-08",1,1,26]
[null,"2021-12-03",2,4,80]
[null,"2023-10-09",2,2,70]
[null,"2023-09-23",2,4,28]
[null,"2023-12-19",2,2,80]
[null,"2023-06-26",1,4,6]
[null,"2023-10-25",3,4,201]
[null,"2021-09-06",2,2,77]
[null,"2023-10-24",4,2,62]
[null,"2023-10-29",2,2,103]
[null,"2023-11-08",2,1,6]
[null,"2022-12-19",2,2,237]
[null,"2021-10-07",3,3,90]
[null,"2021-08-23",3,2,2]
[null,"2023-12-17",4,4,6]
[null,"2022-12-27",4,2,61]
[null,"2023-07-02",4,4,74]
[null,"2021-09-07",1,4,116]
[null,"2021-12-18",4,3,1]
[null,"2023-09-05",2,4,119]
[null,"2021-11-21",2,2,279]
[null,"2021-11-30",2,4,1]
[null,"2023-09-21",2,4,242]
[null,"2022-01-03",3,1,3]
[null,"2022-07-29",1,4,3]
[null,"2021-11-21",2,1,5]
[null,"2022-12-24",1,2,3]
[null,"2023-10-30",3,2,54]
[null,"2022-09-02",2,4,5]
[null,"2022-07-08",2,4,4]
[null,"2023-05-17",2,4,75]
[null,"2022-12-02",1,2,134]
[null,"2023-08-06",2,2,78]
[null,"2022-03-16",2,4,1]
[null,"2022-04-25",4,2,146]
[null,"2023-01-25",2,2,3]
[null,"2021-10-25",2,4,69]
[null,"2023-10-22",1,2,4]
[null,"2021-10-18",2,4,72]
[null,"2022-05-06",2,2,6]
[null,"2023-12-27",2,2,4]
[null,"2022-02-03",2,4,64]
[null,"2023-06-19",2,4,101]
[null,"2022-03-22",2,3,1]
[null,"2022-10-19",2,4,78]
[null,"2021-05-24",2,4,1]
[null,"2022-05-12",2,4,6]
[null,"2022-12-23",2,2,101]
[null,"2023-01-18",4,2,101]
[null,"2021-12-01",4,4,6]
[null,"2022-05-24",2,2,6]
[null,"2021-02-04",2,2,1]
[null,"2023-08-13",2,2,284]
[null,"2023-09-05",2,4,6]
[null,"2022-11-27",2,4,4]
[null,"2022-11-13",2,2,176]
[null,"2023-11-17",4,2,84]
[null,"2022-04-02",1,4,103]
[null,"2022-09-07",1,2,247]
[null,"2021-06-15",2,2,76]
[null,"2023-07-24",4,4,131]
[null,"2022-03-25",2,4,118]
[null,"2021-08-14",2,1,4]
[null,"2021-12-14",2,4,69]
[null,"2021-12-21",4,4,5]
[null,"2022-12-09",2,4,247]
[null,"2021-12-10",2,2,71]
[null,"2021-11-19",2,1,96]
[null,"2021-07-08",4,4,76]
[null,"2022-09-25",4,4,81]
[null,"2022-10-09",2,2,106]
[null,"2022-12-04",3,3,246]
[null,"2021-11-22",2,2,138]
[null,"2021-11-26",3,2,106]
[null,"2021-12-19",2,4,97]
[null,"2023-11-08",3,4,210]
[null,"2022-09-05",3,4,101]
[null,"2021-08-14",1,4,70]
[null,"2023-02-20",4,2,264]
[null,"2023-11-26",2,3,107]
[null,"2022-07-12",3,4,71]
[null,"2023-10-21",2,2,275]
[null,"2023-10-26",1,4,83]
[null,"2022-11-07",2,1,63]
[null,"2021-10-19",1,2,3]
[null,"2021-08-03",4,4,93]
[null,"2023-12-15",2,4,289]
[null,"2022-10-14",1,4,4]
[null,"2023-10-28",2,2,78]
[null,"2022-12-15",4,4,155]
[null,"2022-12-09",2,4,247]
[null,"2023-11-27",2,4,89]
[null,"2021-12-13",2,4,88]
[null,"2022-08-05",3,4,69]
[null,"2022-12-13",4,2,230]
[null,"2023-12-10",4,2,3]
[null,"2022-12-29",1,4,4]
[null,"2021-07-24",2,4,4]
[null,"2023-12-04",2,2,283]
[null,"2022-09-30",2,4,3]
[null,"2021-07-05",2,4,91]
[null,"2022-02-25",2,2,190]
[null,"2022-07-09",1,2,101]
[null,"2022-09-04",4,2,74]
[null,"2021-11-18",2,4,84]
[null,"2022-11-19",2,2,5]
[null,"2021-12-04",2,4,3]
[null,"2021-11-06",2,2,176]
[null,"2023-10-04",2,2,71]
[null,"2021-06-06",2,2,2]
[null,"2023-06-15",1,1,4]
[null,"2023-11-08",2,1,89]
[null,"2023-02-25",3,3,150]
[null,"2021-11-26",3,2,2]
[null,"2022-11-15",1,2,277]
[null,"2023-12-10",2,4,194]
[null,"2022-03-10",2,2,112]
[null,"2021-11-15",2,4,223]
[null,"2022-05-16",4,3,28]
[null,"2021-11-27",2,4,89]
[null,"2023-11-28",2,1,95]
[null,"2023-12-30",2,2,141]
[null,"2023-11-22",2,4,73]
[null,"2022-11-11",2,4,5]
[null,"2021-11-27",1,2,83]
[null,"2023-08-08",2,4,223]
[null,"2021-10-27",2,4,87]
[null,"2022-03-11",2,1,4]
[null,"2023-12-22",2,4,286]
[null,"2021-09-10",1,2,86]
[null,"2021-11-12",2,4,6]
[null,"2021-07-15",2,2,5]
[null,"2021-06-11",2,4,92]
[null,"2023-04-09",2,2,4]
[null,"2023-11-24",2,2,6]
[null,"2022-05-28",3,4,4]
[null,"2023-04-01",1,1,185]
[null,"2022-06-03",3,1,61]
[null,"2022-12-26",3,2,98]
[null,"2022-11-25",2,2,56]
[null,"2021-01-29",1,4,108]
[null,"2022-10-07",1,1,6]
[null,"2022-12-12",2,2,5]
[null,"2022-12-29",2,1,148]
[null,"2021-11-03",2,2,251]
[null,"2022-11-28",2,2,82]
[null,"2022-06-22",2,4,100]
[null,"2021-11-28",2,2,244]
[null,"2022-11-16",2,4,3]
[null,"2022-06-14",2,4,1]
[null,"2021-08-18",2,4,2]
[null,"2022-11-29",3,4,209]
[null,"2021-12-16",2,2,100]
[null,"2023-09-30",2,3,2]
[null,"2023-10-13",1,1,83]
[null,"2023-04-30",2,2,210]
[null,"2023-05-08",2,2,5]
[null,"2023-07-19",3,3,91]
[null,"2022-03-04",3,4,2]
[null,"2023-05-25",2,2,56]
[null,"2022-08-01",2,2,4]
[null,"2022-04-05",2,2,2]
[null,"2021-04-28",3,2,18]
[null,"2023-09-30",2,4,266]
[null,"2021-12-01",2,4,78]
[null,"2022-11-10",2,2,100]
[null,"2022-12-19",3,2,2]
[null,"2023-12-14",1,2,101]
[null,"2023-09-23",2,4,115]
[null,"2023-09-12",4,2,292]
[null,"2021-09-28",4,2,31]
[null,"2022-02-16",2,3,73]
[null,"2021-12-24",3,4,1]
[null,"2023-12-14",2,2,89]
[null,"2022-03-30",2,2,209]
[null,"2021-03-22",2,2,90]
[null,"2023-11-06",2,2,75]
[null,"2022-11-14",2,4,2]
[null,"2021-12-10",1,2,200]
[null,"2023-08-08",4,4,18]
[null,"2023-04-20",2,3,63]
[null,"2023-11-14",4,1,6]
[null,"2023-02-14",3,2,89]
[null,"2023-10-20",2,2,280]
[null,"2022-08-25",2,2,264]
[null,"2021-10-02",2,4,4]
[null,"2022-05-30",2,2,3]
[null,"2022-07-12",2,4,4]
[null,"2021-09-04",2,2,1]
[null,"2023-05-11",1,4,1]
[null,"2022-11-23",1,4,5]
[null,"2022-07-06",3,4,224]
[null,"2022-06-17",2,2,5]
[null,"2022-05-15",3,3,4]
[null,"2022-04-13",3,4,4]
[null,"2022-09-06",2,2,168]
[null,"2022-11-21",2,4,64]
[null,"2021-11-13",2,2,3]
[null,"2021-12-08",3,3,79]
[null,"2022-07-16",2,2,4]
[null,"2023-12-23",4,3,147]
[null,"2023-11-10",2,3,107]
[null,"2021-07-12",1,3,99]
[null,"2021-10-13",1,2,3]
[null,"2023-05-25",2,2,109]
[null,"2022-05-21",1,2,97]
[null,"2022-09-23",2,4,100]
[null,"2022-11-10",2,2,2]
[null,"2022-11-18",2,2,6]
[null,"2022-06-02",2,2,61]
[null,"2022-10-20",3,2,104]
[null,"2023-12-13",2,2,280]
[null,"2023-11-25",3,2,48]
[null,"2023-08-15",1,2,6]
[null,"2021-06-21",2,2,3]
[null,"2023-12-12",1,4,94]
[null,"2022-11-15",2,1,1]
[null,"2023-07-25",3,2,144]
[null,"2023-12-10",2,1,3]
[null,"2023-11-18",2,4,183]
[null,"2021-12-12",4,2,6]
[null,"2022-11-28",4,1,5]
[null,"2023-05-16",2,1,3]
[null,"2022-11-23",1,1,58]
[null,"2022-12-07",1,4,97]
[null,"2022-12-23",2,2,105]
[null,"2023-12-06",3,4,5]
[null,"2021-09-10",2,4,57]
[null,"2023-11-11",1,2,120]
[null,"2021-11-01",2,1,5]
[null,"2023-12-09",2,2,3]
[null,"2022-06-17",1,4,107]
[null,"2023-04-16",2,2,1]
[null,"2023-10-11",2,4,106]
[null,"2021-10-02",2,4,1]
[null,"2022-06-02",2,2,263]
[null,"2023-07-28",2,2,4]
[null,"2021-11-17",2,2,82]
[null,"2022-12-20",2,3,3]
[null,"2021-12-12",2,2,127]
[null,"2022-11-13",4,3,46]
[null,"2022-11-05",2,3,105]
[null,"2021-05-11",1,2,8]
[null,"2021-12-12",1,4,168]
[null,"2021-11-12",2,2,3]
[null,"2023-08-14",2,2,92]
[null,"2023-05-06",4,4,4]
[null,"2021-12-14",2,2,90]
[null,"2022-05-03",2,4,233]
[null,"2022-06-01",2,4,253]
[null,"2021-10-21",2,3,101]
[null,"2023-12-22",2,2,247]
[null,"2023-11-17",2,3,75]
[null,"2022-04-18",2,4,111]
[null,"2021-08-31",3,4,93]
[null,"2021-07-03",2,2,3]
[null,"2023-10-26",2,4,137]
[null,"2021-05-11",1,2,3]
[null,"2023-08-25",3,2,3]
[null,"2022-11-11",1,2,280]
[null,"2021-11-02",2,3,70]
[null,"2022-06-24",2,4,64]
[null,"2022-12-03",2,2,3]
[null,"2023-12-02",2,2,74]
[null,"2021-07-24",2,3,5]
[null,"2023-03-30",2,2,45]
[null,"2021-04-13",1,2,39]
[null,"2022-11-03",2,2,1]
[null,"2023-12-12",2,2,291]
[null,"2021-04-08",2,4,5]
[null,"2023-07-03",2,2,5]
[null,"2023-12-03",3,4,234]
[null,"2022-08-06",4,4,88]
[null,"2021-07-31",2,3,215]
[null,"2022-02-19",3,3,74]
[null,"2023-07-16",2,3,115]
[null,"2023-12-14",2,4,93]
[null,"2022-09-24",2,1,153]
[null,"2021-12-15",2,4,95]
[null,"2021-12-16",3,2,101]
[null,"2022-12-16",2,3,114]
[null,"2021-12-28",4,4,40]
[null,"2022-12-31",3,4,2]
[null,"2023-12-01",2,4,83]
[null,"2023-11-13",2,3,183]
[null,"2022-12-28",2,4,4]
[null,"2022-07-13",4,4,24]
[null,"2022-01-27",2,4,4]
[null,"2023-10-05",2,4,3]
[null,"2023-12-24",3,4,1]
[null,"2021-11-29",2,2,60]
[null,"2023-11-21",4,4,1]
[null,"2023-05-28",1,2,123]
[null,"2023-11-24",2,4,1]
[null,"2023-04-26",3,3,114]
[null,"2023-01-14",3,2,107]
[null,"2021-11-20",4,2,192]
[null,"2021-12-27",4,4,105]
[null,"2023-12-23",2,2,122]
[null,"2022-11-18",2,4,2]
[null,"2021-08-06",2,4,94]
[null,"2022-11-27",4,3,6]
[null,"2023-11-10",2,2,83]
[null,"2022-12-30",2,4,6]
[null,"2021-07-10",2,1,78]
[null,"2021-06-11",2,4,91]
[null,"2023-09-16",2,4,4]
[null,"2022-12-07",2,2,25]
[null,"2023-10-31",3,2,74]
[null,"2022-05-13",4,4,258]
[null,"2022-11-02",4,4,5]
[null,"2023-07-20",2,2,114]
[null,"2022-12-13",2,4,8]
[null,"2021-04-12",2,4,70]
[null,"2023-10-22",2,2,15]
[null,"2021-11-29",2,3,39]
[null,"2022-11-13",4,2,2]
[null,"2021-08-06",2,3,2]
[null,"2021-03-17",3,1,119]
[null,"2022-05-01",2,4,53]
[null,"2022-11-04",2,4,4]
[null,"2022-12-18",2,2,4]
[null,"2023-10-13",2,2,77]
[null,"2022-02-21",2,4,163]
[null,"2022-12-20",3,1,81]
[null,"2023-04-23",2,4,186]
[null,"2022-07-18",2,4,1]
[null,"2021-06-06",3,4,3]
[null,"2021-12-23",2,4,100]
[null,"2022-06-18",1,1,62]
[null,"2021-12-04",2,2,61]
[null,"2022-11-21",4,2,106]
[null,"2023-04-22",4,2,282]
[null,"2021-04-05",2,2,189]
[null,"2021-10-16",2,2,288]
[null,"2021-07-18",2,4,66]
[null,"2021-12-14",1,4,8]
[null,"2023-08-04",2,4,97]
[null,"2023-06-17",4,4,1]
[null,"2022-11-03",4,2,127]
[null,"2022-11-07",3,2,252]
[null,"2023-12-28",2,4,87]
[null,"2022-11-09",3,4,1]
[null,"2022-09-03",2,2,3]
[null,"2023-11-13",1,2,81]
[null,"2023-09-12",2,2,93]
[null,"2022-11-30",4,4,225]
[null,"2022-07-06",1,2,58]
[null,"2021-10-11",2,1,50]
[null,"2023-11-12",2,2,126]
[null,"2023-08-10",2,3,1]
[null,"2022-05-02",3,1,2]
[null,"2022-12-19",2,4,1]
[null,"2023-04-30",2,4,174]
[null,"2021-04-07",2,3,90]
[null,"2023-09-03",2,4,5]
[null,"2022-08-31",2,3,6]
[null,"2022-11-13",2,2,2]
[null,"2022-11-30",2,4,105]
[null,"2022-12-04",2,2,88]
[null,"2021-12-21",4,4,93]
[null,"2022-07-11",3,2,5]
[null,"2021-07-27",1,3,1]
[null,"2023-11-17",4,1,94]
[null,"2022-12-22",4,4,2]
[null,"2022-11-13",4,1,65]
[null,"2022-09-05",2,2,192]
[null,"2022-03-26",1,4,1]
[null,"2022-12-26",2,4,68]
[null,"2022-06-22",2,4,69]
[null,"2023-02-15",2,4,96]
[null,"2022-05-02",3,4,105]
[null,"2023-09-15",4,4,79]
[null,"2021-11-13",2,4,140]
[null,"2023-08-22",3,2,212]
[null,"2023-11-20",2,3,68]
[null,"2023-11-14",4,2,32]
[null,"2021-09-01",2,1,49]
[null,"2023-12-31",2,4,109]
[null,"2023-04-13",2,2,174]
[null,"2023-09-29",2,1,251]
[null,"2021-12-29",1,4,6]
[null,"2022-04-07",2,3,69]
[null,"2021-11-25",2,2,66]
[null,"2022-05-22",2,2,216]
[null,"2021-12-19",3,4,162]
[null,"2022-11-13",4,1,73]
[null,"2022-11-17",2,1,90]
[null,"2021-05-20",4,1,245]
[null,"2022-06-03",2,2,6]
[null,"2022-11-04",2,4,94]
[null,"2023-08-18",4,4,5]
[null,"2023-03-10",2,4,105]
[null,"2023-11-06",2,3,91]
[null,"2022-12-07",2,2,51]
[null,"2021-12-02",2,2,4]
[null,"2023-08-23",2,4,160]
[null,"2023-01-21",2,2,291]
[null,"2023-02-16",4,2,68]
[null,"2021-12-31",1,2,4]
[null,"2021-11-24",3,2,292]
[null,"2023-11-27",1,4,115]
[null,"2022-12-11",3,1,82]
[null,"2023-10-06",2,4,84]
[null,"2023-09-01",2,4,5]
[null,"2021-12-14",4,2,99]
[null,"2023-10-06",1,2,209]
[null,"2023-09-05",2,4,51]
[null,"2021-09-04",2,2,203]
[null,"2021-12-09",1,4,69]
[null,"2021-10-26",2,2,2]
[null,"2021-11-14",2,2,6]
[null,"2021-10-10",3,4,5]
[null,"2021-07-27",1,3,17]
[null,"2022-08-30",2,2,102]
[null,"2023-12-05",2,2,5]
[null,"2022-06-10",2,2,1]
[null,"2023-12-25",1,2,56]
[null,"2021-10-07",2,4,86]
[null,"2021-07-20",2,4,110]
[null,"2022-11-06",1,2,6]
[null,"2023-05-02",2,4,128]
[null,"2021-12-22",2,4,124]
[null,"2021-11-25",2,2,100]
[null,"2021-04-06",1,2,5]
[null,"2022-11-08",2,4,97]
[null,"2022-08-30",3,2,65]
[null,"2022-05-31",2,4,293]
[null,"2023-04-17",2,4,105]
[null,"2023-10-04",2,4,57]
[null,"2021-10-22",2,2,2]
[null,"2023-08-04",2,2,82]
[null,"2021-05-12",2,4,5]
[null,"2021-09-03",3,2,58]
[null,"2021-05-05",3,2,4]
[null,"2022-06-20",3,4,12]
[null,"2023-12-20",3,4,107]
[null,"2021-08-17",2,2,84]
[null,"2022-04-06",2,2,49]
[null,"2022-08-28",2,2,3]
[null,"2021-12-24",2,4,284]
[null,"2022-12-31",2,4,5]
[null,"2022-08-29",2,4,4]
[null,"2022-12-29",2,4,4]
[null,"2023-11-21",4,4,93]
[null,"2021-12-20",2,2,82]
[null,"2022-12-16",1,2,4]
[null,"2021-03-30",3,4,130]
[null,"2023-04-20",1,3,4]
[null,"2022-12-26",4,2,91]
[null,"2021-12-26",4,4,98]
[null,"2023-03-01",2,4,242]
[null,"2022-12-05",2,4,169]
[null,"2021-08-26",3,2,5]
[null,"2021-05-27",2,2,77]
[null,"2021-12-22",4,2,279]
[null,"2021-10-09",2,2,5]
[null,"2022-01-11",2,4,113]
[null,"2023-12-30",3,4,94]
[null,"2021-12-27",1,4,6]
[null,"2023-10-19",2,2,109]
[null,"2022-11-05",1,2,1]
[null,"2021-01-17",2,2,200]
[null,"2023-12-13",3,4,2]
[null,"2023-03-09",1,2,69]
[null,"2022-12-02",3,2,198]
[null,"2021-04-22",2,4,6]
[null,"2023-07-23",2,4,27]
[null,"2023-11-09",1,4,286]
[null,"2022-12-31",4,4,4]
[null,"2022-05-31",2,4,44]
[null,"2022-11-24",1,2,4]
[null,"2023-02-11",3,4,225]
[null,"2022-01-16",2,4,231]
[null,"2022-06-07",3,4,249]
[null,"2021-01-31",4,4,63]
[null,"2023-11-03",1,2,74]
[null,"2023-02-20",2,2,158]
[null,"2021-11-28",3,4,4]
[null,"2021-04-30",2,2,3]
[null,"2023-04-29",4,4,73]
[null,"2021-12-31",2,1,5]
[null,"2023-11-04",2,4,141]
[null,"2023-11-10",4,3,134]
[null,"2021-11-29",1,1,74]
[null,"2023-12-17",3,4,47]
[null,"2022-12-06",2,2,161]
[null,"2021-04-16",3,4,1]
[null,"2022-06-07",2,4,4]
[null,"2021-12-06",2,4,71]
[null,"2021-11-10",1,2,3]
[null,"2023-12-19",2,4,5]
[null,"2022-11-18",2,1,82]
[null,"2023-11-21",2,2,6]
[null,"2023-07-24",2,4,3]
[null,"2022-12-26",1,2,21]
[null,"2021-10-07",2,4,90]
[null,"2021-08-06",2,2,93]
[null,"2023-07-27",2,4,2]
[null,"2021-04-15",2,2,286]
[null,"2022-10-21",2,2,6]
[null,"2023-10-21",2,4,11]
[null,"2021-12-30",2,4,252]
[null,"2022-12-21",1,2,63]
[null,"2021-06-22",2,2,90]
[null,"2023-09-15",4,2,43]
[null,"2023-11-28",2,2,59]
[null,"2022-07-26",2,2,274]
[null,"2022-12-19",4,2,57]
[null,"2022-11-11",2,1,3]
[null,"2021-11-15",4,2,6]
[null,"2022-12-23",2,2,2]
[null,"2023-12-22",4,4,37]
[null,"2023-10-22",2,4,248]
[null,"2023-11-02",2,1,116]
[null,"2022-07-01",2,4,66]
[null,"2023-04-08",4,3,5]
[null,"2022-07-30",2,4,126]
[null,"2022-10-01",2,4,121]
[null,"2023-11-11",2,4,126]
[null,"2021-12-30",2,2,4]
[null,"2021-09-27",3,4,2]
[null,"2023-11-14",1,3,185]
[null,"2023-04-04",2,2,6]
[null,"2021-10-22",3,4,159]
[null,"2021-11-09",3,4,1]
[null,"2022-10-02",2,2,4]
[null,"2021-08-11",2,2,82]
[null,"2021-07-18",3,2,11]
[null,"2021-12-20",2,3,65]
[null,"2021-10-18",2,2,3]
[null,"2021-12-31",1,3,69]
[null,"2022-09-01",2,1,3]
[null,"2022-12-22",1,2,72]
[null,"2022-05-30",3,2,64]
[null,"2023-07-01",4,4,80]
[null,"2022-12-31",3,2,2]
[null,"2022-08-06",2,2,176]
[null,"2023-05-10",4,3,110]
[null,"2022-07-31",4,4,1]
[null,"2023-10-31",2,4,69]
[null,"2022-11-25",2,4,5]
[null,"2021-07-15",2,1,1]
[null,"2023-07-21",2,2,107]
[null,"2022-11-29",2,4,285]
[null,"2021-11-19",1,4,3]
[null,"2023-09-24",2,2,131]
[null,"2023-07-07",2,2,88]
[null,"2024-10-04",2,2,5]
[null,"2024-04-19",2,2,200]
[null,"2024-11-10",2,4,242]
[null,"2024-12-12",2,4,83]
[null,"2024-12-22",2,2,50]
[null,"2024-09-29",4,2,89]
[null,"2024-10-14",2,4,183]
[null,"2024-10-30",2,4,102]
[null,"2024-11-28",2,2,86]
[null,"2024-05-31",1,2,142]
[null,"2024-06-15",3,2,205]
[null,"2024-08-13",2,2,5]
[null,"2024-03-16",3,2,3]
[null,"2024-06-16",4,1,131]
[null,"2024-08-23",3,3,132]
[null,"2024-11-19",1,4,80]
[null,"2024-09-27",4,4,4]
[null,"2024-07-14",2,4,176]
[null,"2024-11-14",2,2,5]
[null,"2024-11-08",2,2,56]
[null,"2024-08-27",1,4,2]
[null,"2024-10-12",2,4,78]
[null,"2024-09-02",2,2,63]
[null,"2024-11-12",2,2,188]
[null,"2024-06-18",4,2,85]
[null,"2024-09-07",2,4,139]
[null,"2024-10-08",2,2,175]
[null,"2024-10-28",1,2,3]
[null,"2024-05-24",2,4,64]
[null,"2024-11-14",2,2,95]
[null,"2024-08-27",3,4,85]
[null,"2024-04-28",2,2,89]
[null,"2024-12-26",3,4,3]
[null,"2024-12-19",2,4,287]
[null,"2024-10-06",3,4,1]
[null,"2024-07-15",1,2,171]
[null,"2024-10-19",2,4,29]
[null,"2024-08-02",4,2,142]
[null,"2024-05-24",2,4,4]
[null,"2024-10-20",2,1,66]
[null,"2024-06-14",2,2,4]
[null,"2024-07-20",2,2,3]
[null,"2024-11-22",1,3,88]
[null,"2024-11-02",3,1,2]
[null,"2024-09-05",4,2,69]
[null,"2024-12-31",2,2,97]
[null,"2024-02-10",2,4,4]
[null,"2024-11-06",2,4,76]
[null,"2024-10-26",2,4,75]
[null,"2024-02-19",2,2,145]
[null,"2024-08-12",2,2,81]
[null,"2024-04-15",3,4,2]
[null,"2024-12-03",1,4,81]
[null,"2024-07-22",2,4,92]
[null,"2024-08-22",2,2,93]
[null,"2024-06-29",2,1,51]
[null,"2024-11-22",2,4,102]
[null,"2024-10-17",2,4,62]
[null,"2024-12-19",1,2,173]
[null,"2024-02-07",2,2,118]
[null,"2024-12-01",2,4,52]
[null,"2024-07-21",2,3,63]
[null,"2024-08-29",2,4,86]
[null,"2024-06-13",4,4,282]
[null,"2024-10-25",3,4,24]
[null,"2024-06-16",2,4,88]
[null,"2024-11-19",3,2,259]
[null,"2024-11-19",2,4,98]
[null,"2024-11-12",2,4,4]
[null,"2024-11-19",2,4,65]
[null,"2024-11-01",2,3,238]
[null,"2024-07-23",1,1,1]
[null,"2024-07-07",2,2,116]
[null,"2024-11-10",2,1,176]
[null,"2024-06-23",2,4,98]
[null,"2024-12-09",2,4,6]
[null,"2024-08-15",1,4,64]
[null,"2024-10-13",2,2,119]
[null,"2024-12-24",1,2,262]
[null,"2024-12-25",2,1,4]
[null,"2024-12-31",2,1,1]
[null,"2024-09-26",2,2,96]
[null,"2024-12-13",3,2,4]
[null,"2024-10-27",2,2,116]
[null,"2024-09-16",3,4,91]
[null,"2024-09-18",1,2,107]
[null,"2024-11-02",2,4,101]
[null,"2024-11-29",2,1,61]
[null,"2024-01-11",2,4,77]
[null,"2024-04-07",4,4,265]
[null,"2024-04-19",1,4,4]
[null,"2024-10-19",3,2,3]
[null,"2024-12-18",2,2,92]
[null,"2024-10-03",3,4,103]
[null,"2024-12-29",3,2,94]
[null,"2024-04-16",2,2,177]
[null,"2024-05-13",2,2,58]
[null,"2024-09-27",2,4,80]
[null,"2024-11-21",2,2,80]
[null,"2024-01-08",2,2,269]
[null,"2024-10-10",2,3,37]
[null,"2024-12-28",2,4,36]
[null,"2024-04-21",4,2,4]
[null,"2024-11-28",2,2,94]
[null,"2024-12-24",1,4,4]
[null,"2024-12-25",3,2,64]
[null,"2024-08-16",2,1,2]
[null,"2024-05-12",4,4,80]
[null,"2024-04-19",2,1,155]
[null,"2024-05-24",2,4,64]
[null,"2024-04-29",2,4,86]
[null,"2024-09-02",2,2,49]
[null,"2024-12-28",2,4,153]
[null,"2024-11-22",2,1,110]
[null,"2024-11-13",3,2,291]
[null,"2024-11-16",2,4,131]
[null,"2024-12-04",2,4,87]
[null,"2024-11-04",3,4,112]
[null,"2024-10-24",1,2,83]
[null,"2024-10-17",2,2,4]
[null,"2024-12-12",3,2,102]
[null,"2024-10-30",2,4,6]
[null,"2024-07-29",2,4,92]
[null,"2024-05-22",2,4,121]
[null,"2024-09-01",2,2,122]
[null,"2024-03-28",2,2,80]
[null,"2024-08-08",3,3,97]
[null,"2024-11-11",2,1,91]
[null,"2024-06-15",2,2,2]
[null,"2024-10-19",3,2,1]
[null,"2024-11-15",2,4,68]
[null,"2024-12-06",4,2,1]
[null,"2024-11-14",3,4,6]
[null,"2024-09-29",4,2,56]
[null,"2024-08-28",2,4,149]
[null,"2024-04-17",2,1,3]
[null,"2024-10-01",2,4,3]
[null,"2024-10-31",1,4,1]
[null,"2024-10-29",3,2,94]
[null,"2024-01-16",2,2,247]
[null,"2024-06-08",2,2,73]
[null,"2024-12-23",3,2,40]
[null,"2024-12-30",2,4,111]
[null,"2024-05-24",2,2,162]
[null,"2024-12-28",2,1,78]
[null,"2024-07-25",3,4,83]
[null,"2024-07-22",3,4,5]
[null,"2024-11-20",2,4,84]
[null,"2024-06-13",3,3,267]
[null,"2024-10-06",2,2,61]
[null,"2024-04-23",3,2,3]
[null,"2024-11-06",2,4,4]
[null,"2024-07-11",2,4,113]
[null,"2024-07-20",2,1,83]
[null,"2024-10-20",3,2,23]
[null,"2024-04-05",1,4,300]
[null,"2024-09-18",2,2,4]
[null,"2024-11-18",2,2,2]
[null,"2024-10-19",1,1,5]
[null,"2024-02-08",1,2,6]
[null,"2024-03-02",2,2,94]
[null,"2024-12-09",2,4,1]
[null,"2024-12-31",2,4,74]
[null,"2024-10-22",2,4,23]
[null,"2024-09-05",2,4,4]
[null,"2024-12-25",2,2,111]
[null,"2024-08-09",3,1,93]
[null,"2024-10-27",2,2,135]
[null,"2024-11-30",2,2,74]
[null,"2024-09-26",2,4,1]
[null,"2024-11-07",2,2,3]
[null,"2024-02-26",3,4,6]
[null,"2024-10-09",1,1,105]
[null,"2024-12-29",2,2,2]
[null,"2024-08-04",2,4,3]
[null,"2024-07-05",3,2,259]
[null,"2024-10-09",2,2,4]
[null,"2024-12-15",2,2,58]
[null,"2024-11-20",2,2,3]
[null,"2024-12-18",1,2,1]
[null,"2024-06-30",2,2,4]
[null,"2024-07-12",2,2,88]
[null,"2024-04-20",2,2,160]
[null,"2024-06-02",1,2,2]
[null,"2024-12-01",2,2,6]
[null,"2024-11-29",1,2,83]
[null,"2024-11-14",2,2,62]
[null,"2024-12-14",2,2,4]
[null,"2024-11-30",2,4,190]
[null,"2024-12-16",1,3,87]
[null,"2024-04-30",2,4,2]
[null,"2024-11-07",3,2,107]
[null,"2024-11-14",4,4,199]
[null,"2024-04-21",2,2,5]
[null,"2024-12-01",3,4,89]
[null,"2024-10-28",2,2,86]
[null,"2024-09-28",2,4,42]
[null,"2024-12-27",2,2,59]
[null,"2024-12-04",2,2,168]
[null,"2024-10-14",2,2,252]
[null,"2024-08-07",1,2,3]
[null,"2024-09-08",3,2,58]
[null,"2024-12-26",2,4,26]
[null,"2024-12-26",2,4,2]
[null,"2024-02-14",2,4,5]
[null,"2024-09-01",3,4,6]
[null,"2024-07-21",2,2,72]
[null,"2024-06-20",4,4,116]
[null,"2024-08-15",2,2,30]
[null,"2024-03-02",3,1,107]
[null,"2024-11-17",2,4,252]
[null,"2024-10-08",3,4,3]
[null,"2024-10-30",1,4,4]
[null,"2024-01-19",2,4,63]
[null,"2024-09-19",2,2,4]
[null,"2024-12-02",2,4,5]
[null,"2024-12-09",4,2,1]
[null,"2024-11-16",2,2,62]
[null,"2024-11-24",2,4,163]
[null,"2024-12-04",2,3,85]
[null,"2024-09-13",2,4,2]
[null,"2024-02-18",4,2,294]
[null,"2024-07-19",2,2,246]
[null,"2024-03-14",3,2,1]
[null,"2024-08-06",4,2,97]
[null,"2024-11-18",2,2,6]
[null,"2024-04-17",2,4,5]
[null,"2024-11-13",4,2,291]
[null,"2024-05-26",2,3,161]
[null,"2024-06-15",4,2,70]
[null,"2024-12-22",2,2,4]
[null,"2024-04-04",2,4,2]
[null,"2024-11-15",2,2,26]
[null,"2024-07-04",1,2,102]
[null,"2024-11-25",2,4,94]
[null,"2024-06-28",4,2,263]
[null,"2024-09-17",4,1,72]
[null,"2024-12-14",1,2,6]
[null,"2024-12-22",2,4,4]
[null,"2024-11-03",1,4,4]
[null,"2024-05-26",1,4,64]
[null,"2024-11-25",2,2,4]
[null,"2024-10-27",2,4,1]
[null,"2024-10-11",1,4,6]
[null,"2024-05-03",2,1,122]
[null,"2024-06-16",4,3,63]
[null,"2024-05-02",3,4,146]
[null,"2024-06-01",2,4,92]
[null,"2024-10-14",4,4,3]
[null,"2024-11-14",1,4,71]
[null,"2024-01-18",4,2,221]
[null,"2024-07-07",1,3,151]