## 05 March 2014

### WSPR: Antenna and Propagation Considerations 5

Part 5: WSPR: Antenna and Propagation Analyses

Today we will have a look at some details of the WSPRnet reports. I will not use the whole data set. As explained before I sort the big spreadsheet after certain criteria and copy / paste the relevant data sets into a new sheet. I know this could be done in a more simple way, but I prefer to see the whole picture on a sheet.

## 04 March 2014

### WSPR: First Spreadsheet Results 4

Part 4: WSPR: Antenna and Propagation Analyses

So we got everything settled and we  can look at the numbers and figure out what they will tell us about our system. But first, as an appetizer, let's look at the actual map produced by the WSPRnet site.

Doesn't that look beautiful? These are my reports on 30m in the last 12 hours. And I have used only 100 mW.
And the longest way my signals traveled last  night was to Steven K9AN in Illinois some  7250 km away. (Just 725.000 km per watt.) But let's turn to the facts gathered in my spreadsheet.

## 02 March 2014

Part 2: WSPR: Preparing Data for Spreadsheets

(Just as a reminder: I am using Gnumeric as spreadsheet)

It is still winter although we have no snow at the moment. So it is better to stay at home and fulfill the plea of a fellow ham to explain the calculation of the Maidenhead

 Sommer im Herzen © Joachim Lehrer 2014
First of all remember, that the saga of the world being round is totally wrong. The world is flat and square.

### WSPR: Preparing Data for Spreadsheets 2

Part 2: WSPR: Antenna and Propagation Analyses

If you know how to do it, it's most of the time trivial to do it. But if you don't know how ... it could be, that you get lost. I have been asked to explain more clearly what I have described in my last post. So here it is and if you know how to work with spreadsheets, you are allowed to skip this post.

(Just as a reminder: I am using Gnumeric as spreadsheet)
This is the data set which we want to import.
We open a new sheet in the software, select all the data from the browser, copy and past it into the spreadsheet. The software was able to identify 12 different values and distributed them into 12 columns.

Column Date and Time
In the first column we find the string ' 2014-02-27 19:32 A string is a just a sequence of characters. Although you see numbers, they are not numbers in the eye of the computer. You have to transform them.

1. Open a new column on the right side of the field and type =left(A1;11) This will copy the first 11 characters of the cell A1 into cell B1
and it will look like that: ' 2014-02-27.It is still a string. Now let us change the string into a number.
2. Open a new column on the right side of the field and type =value(B1).You've got it. In cell C1 you have a real date which could be used for further computation.
3. Open a new column on the right side of the field and type =right(A1;6)
This will copy the last 6 characters of the cell A1 into cell D1
and it will look like that: ' 19:32.
It is still a string. Now let us change the string into a number.
4. Open a new column on the right side of the field and type =value(D1).You've got it. In cell E1 you have a real time which could be used for further computation.
Column Call

It is boring. Nothing to do. It is a string with my call sign and it will stay that way.

Column Frequency
Just remember, software is not intelligent or it is just as intelligent as his programmer (Please reconsider my intelligence when looking at the last lines ;-))
Gnumeric could not decide what it was and choose the easiest solution. It must be a string: ' 10.140187.
Do you remember? You can not calculate with characters. You have to transform them.

1. Open a new column on the right side of the field and type =value(G1). Thats all folks. You've got the real frequency as number.
Column Power
I already explained it. The spreadsheet took the number 0.100 and thought, that I would be an American programmer writing a period to distinguish number 1000.
1. Open a new column on the right side of the field and type =M1/1000.

The spreadsheet will look like this:

Now you have all number in the correct format and you better clean up the mess. But beware. You can not just delete the columns like column A. You would loose all your data and it is safer to keep your original data.
So just open a second sheet and copy the relevant columns. Another trick: Select copy only the value from the menu.
We are done (for the moment)

and we can proceed to more interesting features.

Stay Tuned!

## 01 March 2014

### WSPR: Antenna and Propagation Analyses 1

What do you do, when you are a beacon on Wspr? You transmit your signal and wait until you get an report from that great Wsprnet.org site. Then you filter the reports and I get my signal reports with 200 mW on 30m.

 DL1SDZ 12 hours 30m with 200 mW Ultimate 3 Power
That's nice to look at and you can impress your fellow hams. But somehow it was not satisfying, at last not for me.

## 25 February 2014

### QRPp and Power Measurements

It was cold and dark - And so I was operating the Ultimate3 in WSPR mode. All was guessing and hoping, that everything was right. At these low levels of power I could only measure the output with my scope. My other gear didn't work with power levels > 500 mW. (Also my trusted Elecraft T1 Auto-tuner didn't come alive and I had to pre-tune it with another rig and switch antennas in the hope that the expected 50 Ohm were still there.

But things have changed - somehow. I was looking for a power meter or an swr meter, which was able to measure power down to 1 mW or less and I found a solution. In an article written by   Loftur E. Jonasson:  Power and SWR Meter with dual bargraphs and sticky bar, using 2x AD8307 described the necessary circuit and even posted the software. But - it was no kit. The schematics for the PCB board are also published - well done - still I was no happy camper - no way to produce this piece of measurement device.

So I looked an asked and complained and asked and finally I was confronted with a solution which was ready made and calibrated. A good friend of mine had some time ago constructed the gear I was looking for.

## 16 February 2014

### Power Whispering and Propagation

Normally, I am a shy guy who doesn't boost about my roaming around. But sometimes someone shows you that things which you are doing are more interesting than it seems to be at the first glance.  An so it was today: Bert (PA1B) wrote me, that he made a new analysis and if I was interested, I could post it on my blog. So here it is:

 With permission of Bert (PA1B)
So what's so interesting in these figures?