I <3 Spreadsheets (Daily COVID-19 data update CXXV)

If you haven’t seen it already, check out the awesome news result from the Sloan Digital Sky Survey that I was fortunate to be a part of. I’ll tell you more about it in a future post. But for now, COVID-19.

Graphs day 125, pandemic day 132, day 202 since the first cases were diagnosed.

Total cases of COVID-19 diagnosed worldwide: 14,507,132

Total deaths: 606,167

I’m working on a new spreadsheet that will allow me to compare any counties states in the U.S. with any regions in the world – not just countries, but also regions within countries. I’m particularly interested in looking at how current COVID-19 hotspots like Florida compare to past hotspots like Lombardy, Italy and Hubei, China (the province where Wuhan is located).

Here’s the formula that I wrote in one cell of the spreadsheet:

=IF(IFERROR(XMATCH(INDIRECT(CONCAT("'",$B$1,"'!$",$E$1,"$",$A11)),'Areas of interest'!$A$1:$A$99999),-1 <> -1, IF(INDIRECT(CONCAT("'",$B$1,"'!$",$E$2,"$",$A11))="US",INDIRECT(CONCAT("'",$B$1,"'!$",$E$3,"$",$A11)),INDIRECT(CONCAT("'",$B$1,"'!$",$E$1,"$",$A11))),IF(INDIRECT(CONCAT("'",$B$1,"'!$",$E$2,"$",$A11))="US",INDIRECT(CONCAT("'",$B$1,"'!$",$E$1,"$",$A11)),INDIRECT(CONCAT("'",$B$1,"'!$",$E$2,"$",$A11))))

Did I mention that I like spreadsheets?

Here is the update for cases in Florida, compared to the usual comparison countries.

History of the COVID-19 pandemic in various countries, and also Florida
(click for a larger version)

Cases have decreased in Florida the last two days. Hopefully that’s the beginning of a longer trend. We’ll find out as we go.

Update tomorrow, and every day until the pandemic ends or I do.

Leave a Reply