Page History

...

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 countries/states/counties and the following metrics.

Using the results

1. From your web browser go to https://www-iepm.slac.stanford.edu/pinger/excel.
   1. The filenames provide the metric 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.
      Image Added
   3. Clicking on the 'Chart1' tab at the bottom you will see a chart of the data.
      Image Added
      1. Moving the mouse over a line displays the relevant date and value.
      2. Clicking on a line will identify points on the line.