WSPR Spot Report Analysis Spreadsheet with Charts

This Excel (2000 or later) spreadsheet has added the following to GM4ISM's WSPR data download sheet: Statistical analysis of frequency, SNR and Power dBm of downloaded WSPR spot reports; Charts of frequency and SNR of spot reports vs. Date/Time UTC; and Charts of frequency and SNR of spot reports vs. hour of the day (UTC)

To use the spreadsheet, Instructions :- Fill in blue cells and click the cogs (click away from the blue cells first). The macro will download and chart up to 2500 of the most recent spots that match your criteria directly from the online database.
Select the second worksheet "Data" to view the Statistical Analysis Data for the downloaded spot reports.
The following four worksheets chart: Frequency vs. Date/Time, Frequency vs. Hour, SNR vs. Date/Time, and SNR vs. Hour.
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 reports are only as accurate as the reporting receiver and may also be affected by aircraft scatter Doppler shift.

The spreadsheet uses Microsoft Visual Basic macros and will not work under Google Docs or OpenOffice.