re: Daily COVID Updated as of 11/2/20 8:00 PM

Thanks, Matt!

1) Google sheets have a conditional formating option for showing a color scale based on the range of numbers. Since this color scale is based on a state's numbers, what looks bright red for Alaska might be only 20 cases while for NY bright red might represent 1900 cases. The way to address this would be in your 3rd bullet point, normalize it by population.

2) There is actually a date header row; however, to format the sheet to look like this you have to narrow down each column which causes the headers to disappear because the column width is so narrow. In the displayed graphic everything starts on March 15th.

You can see this full graphic in my US tracker, it's the very last tab in the workbook. This one is static as it's just a mock-up for me to use to work out the issues. I won't be updating it in this tracker as it's a manual build process and takes about 30 minutes to do this one tab. Once I get a script-driven tracker implemented, I will be able to write the code to generate this automatically. I was thinking I would offer this view for 1) New Cases 2) Deaths 3) Total Tests for both the raw numbers and the normalized numbers.

I was also thinking it would be interesting to show this plot for each state where the 1st row would show the number of new cases and the 2nd row would show deaths. That would allow you to see the relationship between new cases and deaths...or it might be a lot of effort and be worthless.