To use the spreadsheet, Instructions :- Fill in blue cells and click the cogs (click away from the blue cells first). The macro will retrieve and chart up to 2500 of the most recent spots that match your criteria directly from the http://www.wsprnet.org/olddb online database.
Select the second worksheet "Data" to view the Statistical analysis of frequency, SNR, drift, Power dBm, distance (km) and azimuth of online WSPR spot reports.
The following ten worksheets chart: frequency, SNR, Drift, Distance and Azimuth of spot reports vs. Absolute Date/Time UTC and vs. Hour of Day (UTC) composite over observed range.
The Date/Time charts show all spots reports in chronologic order.
The hourly charts show a composite of all spot reports from 0000-2359 each day (UTC) to visualize cyclic daily trends.
SNR reports may vary with changes in local noise level at the receiving station and variation in antenna gain and bearing at either station.
Frequency and drift reports are only as accurate as the reporting receiver and may also be affected by propagation Doppler shift.
The spreadsheet uses Microsoft Visual Basic macros and will not work under Google Docs or OpenOffice.
The HamCalc macros by Bo Hansen OZ2M are used to calculate distance and azimuth.