Corona Virus Spreadsheet – Requires Excel 365

22 Apr

Corona worldwide and country spreadsheet

The workbook automatically downloads current data from the European Centre for Disease Prevention and Control and presents

  • Rolling, last-10-day case totals worldwide (the Worldwide totals sheet)
  • Rolling, last-10-day totals by continent (the By continent sheet)
  • Last-10-day data by country with accompanying sparklines (Last 10 days by country)
  • A fourth sheet that enables the user to enter any country name in an auto-complete text box in the sheet’s upper left corner and any two dates, to produce case data for the country across that span (Selected time span and country).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: