Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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

...