Covid-19 - Visualizing the data with Excel

Introduction

Using the perl Excel utility https://metacpan.org/pod/Excel::Writer::XLSX, we created a script (excel-job.pl) to read the Covid-19 data from Johns Hopkins University (JHU) and built a library of Excel spreadsheets and charts at https://www-iepm.slac.stanford.edu/pinger/excel for areas/countries/states/counties (e.g. West Europe, US by state, California by county) and the following metrics against the date.

Using the results

1. From your web browser go to https://www-iepm.slac.stanford.edu/pinger/excel.
   1. The filenames provide the metric, aggregation (daily or cumulative), and area etc.
   2. Using the browser you can sort the files by clicking on the headings,
2. Click on one of the files. 
   1. This will create an Excel workbook for the chosen metric, for the country/state/county (column) for each day (row) the data was gathered.
   2. After opening the workbook the spreadsheet will be displayed.
      
   3. Clicking on the 'Chart1' tab at the bottom you will see a chart of the data.
      
      1. Moving the mouse over a line displays the relevant date and value.
      2. Clicking on a line will identify points on the line.