Make it easier to copy data from the database for analysis

2 posts / 0 new
Last post
vk2tpm
vk2tpm's picture
Offline
Last seen: 2 weeks 1 day ago
Joined: 2008/10/20 - 03:49
Make it easier to copy data from the database for analysis

An obvious use of the magnificent WSPR spot data set is to figure out the best time for a voice contact between two locations. To do this I capture spots over a period of time and plot S/N against time of day and the best times are revealed.

As there's currently no download data option, I display the data and then copy and paste from the web page to a spreadsheet.

The data display html makes it a little difficult to do this cleanly. Each field is surrounded by nbsp characters which upsets my spreadsheet. Also the + before positive S/N db confuses it.

Is there any chance of removing these or providing a "clean feed"?

My other wishes are to be able to get a report between two grid locations (both ways) and the ability to use wild cards of some sort.

Thanks for a great dataset, service and software.

Peter, VK2TPM.