- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Daily COVID Updated as of 11/2/20 8:00 PM
Posted on 5/27/20 at 11:24 am to Chromdome35
Posted on 5/27/20 at 11:24 am to Chromdome35
These are the tabs currently available on the tracker:
US Tab: This shows data for the US. You cannot change anything on this tab.
State Tab: This shows data for the selected state. You can change the State by clicking on cell B1 and selecting a different state via the dropdown. It will take about 30 seconds to update. you can also select the date which will change the starting point for the graphs. 3/15/20 is a good starting date as there isn't much data before that time.
By Capita Tab: This shows a comparison of states by capita for a given day. You can select the date in cell A2 and the data element you want to view in cell B2. After a few seconds, the chart will update.
Heat Map Tab: This allows you to pick a starting date and a data element to view. You can also select a state in cell B6 that you can use to compare to the cells below. The colors are based on the data range for each state. This means that for a given state, whichever days have the highest values will be the most red. The scale is state dependant which means that for Arkansas the highest day might be 100 cases and it will be red while for NY, red might be 2000 cases. It's all relative to each state.
Control Tab: This tab is used by the various formulas to populate the various dropdowns and as a reference for the sheets formulas to refer to.
COVIDData Tab: This tab contains 1 row for each state for each day. The data for the US is here as well with the US appearing as another state in the table. On the control tab, you'll see a data definition of the table on the COVIDData tab. If you want to do your own analysis, you can pull the data out of this tab for your own use.
WoMUSData Tab: This tab uses the google sheets importhtml function to screen scrape the WoM site for the number of new cases and deaths for the day. This data is then displayed on the top row of the tracker so the viewer will have an idea of how today is trending. You can compare these 2 numbers to the Previous day's columns in cells C8 and C11.
US Tab: This shows data for the US. You cannot change anything on this tab.
State Tab: This shows data for the selected state. You can change the State by clicking on cell B1 and selecting a different state via the dropdown. It will take about 30 seconds to update. you can also select the date which will change the starting point for the graphs. 3/15/20 is a good starting date as there isn't much data before that time.
By Capita Tab: This shows a comparison of states by capita for a given day. You can select the date in cell A2 and the data element you want to view in cell B2. After a few seconds, the chart will update.
Heat Map Tab: This allows you to pick a starting date and a data element to view. You can also select a state in cell B6 that you can use to compare to the cells below. The colors are based on the data range for each state. This means that for a given state, whichever days have the highest values will be the most red. The scale is state dependant which means that for Arkansas the highest day might be 100 cases and it will be red while for NY, red might be 2000 cases. It's all relative to each state.
Control Tab: This tab is used by the various formulas to populate the various dropdowns and as a reference for the sheets formulas to refer to.
COVIDData Tab: This tab contains 1 row for each state for each day. The data for the US is here as well with the US appearing as another state in the table. On the control tab, you'll see a data definition of the table on the COVIDData tab. If you want to do your own analysis, you can pull the data out of this tab for your own use.
WoMUSData Tab: This tab uses the google sheets importhtml function to screen scrape the WoM site for the number of new cases and deaths for the day. This data is then displayed on the top row of the tracker so the viewer will have an idea of how today is trending. You can compare these 2 numbers to the Previous day's columns in cells C8 and C11.
This post was edited on 5/27/20 at 4:20 pm
1
Posted on 5/27/20 at 3:28 pm to Chromdome35
I finally got screen scraping to work so I could pull some numbers from the WoM site. I made the header of the tracker look like this
This shows you New Cases and Deaths for the day from WoM along with a comparison to the previous day which shows as Down or UP X from the previous day.
I also added a WoM States reporting so we could see how many states currently have reported numbers on the WoM site. Just because a state has updated, doesn't mean they won't update again during the day. Florida, Georgia and NY all seem to update more than once a day.
The screen scrape runs once an hour on the hour.
This shows you New Cases and Deaths for the day from WoM along with a comparison to the previous day which shows as Down or UP X from the previous day.
I also added a WoM States reporting so we could see how many states currently have reported numbers on the WoM site. Just because a state has updated, doesn't mean they won't update again during the day. Florida, Georgia and NY all seem to update more than once a day.
The screen scrape runs once an hour on the hour.
This post was edited on 5/27/20 at 3:29 pm
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News