...
- Click on Data to the left, the data for the chart will show up.
- In the data click on a grey 'Value' cell, the row will get a blue background.
- Then on a Mac I tapped the fn-delete key. Fairly frequently nothing happened. I am not sure what the magic is, maybe it's a long delay, I usually tried again on another row. Eventually a row was deleted it seemed to then work for more rows. It may be a good idea to do a Save, in case something breaks. After the save you may have to go thru the same magic again to get started on the deletions.
- As a matter of practice I deleted all rows except the first 3. This is so there is something left to display in the chart.
- I saved this partially emptied data file.
- Next I created the csv Excel file.
- I created a perl script create-covid.pl to read the PingER data for a specified PingER metric (default Inter Packet Delay Variation (ipdv)) measured from SLAC, for each country for the last 120 days (from https://www-iepm.slac.stanford.edu/pinger/prmout/), merge it together with Covid-19 data from Johns Hopkins University (https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv) plus the Country name, TLD, population, continent and region and write it all to a csv file using the Charte.ca format.
- Enter the data into Charte.ca app
- I fed this file to Excel, verified it looked correct, made a copy in Excel
- Went to the Charte.ca Clone, deleted the remaining 3 lines. The data was now empty.data cell
- Clicked on the top left data cell (its background goes blue) and pasted it into the cell, and waited. Eventually (after a minute or two) the new data showed up as well as the motion plot.
...