HOME  |  ARTICLESBAND CONDITIONS  |  EQUIPMENT  |  LINK  | MAIL   |  OPERATIONAL  |  PROJECTS  |  REPAIRS & MODS
      HOME  > OPERATIONAL >REFERENCES >
WSPRnet CHARTING OVERVIEW
Step by step guide for exporting WSPRnet data to Microsoft Excel for charting.
Graphing history of WSPR pings from the WSPRnet database. Below are three effective techniques for exporting WSPRnet data to Microsoft Excel for charting, sorting and or archiving WSPR data.

 

1 My original method of coping and pasting to a text editor and then opening the the text file with Microsoft Excel import Wizard. WSPR CHARTS V1
2 A more direct method of coping the data and using Microsoft Excel / Past Special to complete the import. Note: Preferred method. WSPR CHARTS V2
3 Direct Web data import from Microsoft Excel. Very useful method. Including the ability to save the query so that the entire process can be saved as *.igy file WSPR CHARTS V3

 

Example of WSPR data has been graphed using Microsoft Excel to compare two antennas. Horizontal axis = UTC Time, Vertical axis = dB below the noise floor. 

 

TOP OF PAGE

Page last revised 31 August 2017  
 

ACTIVITIES | ARTICLES | EQUIPMENT | HOMELINK | MAIL | PROJECTS

Web design by Peter Miles

All content may be used for unlimited distribution with credits.

This site has been designed to cater for 800 x 600 resolution.
Site is best viewed with Internet Explorer 5.5 or Netscape 6 or higher.