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), analyze the data, and build 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 in particular the 'Last Modified' and 'Name',
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.
         
      3. You can use Excel tools to look at the chart data in more detail, e.g. some of the following, possibly in combination:
         1. the Zoom feature under the View tab 
         2. re-formating the x-axis and y-axis limits to restrict the viewing area 
            
         3. Using Log10 y scales