Return-Path: Received: from rly-ma01.mx.aol.com (rly-ma01.mail.aol.com [172.20.116.44]) by air-ma01.mail.aol.com (v123.3) with ESMTP id MAILINMA013-88c49a57e43aa; Wed, 25 Feb 2009 12:22:23 -0500 Received: from post.thorcom.com (post.thorcom.com [193.82.116.20]) by rly-ma01.mx.aol.com (v123.3) with ESMTP id MAILRELAYINMA016-88c49a57e43aa; Wed, 25 Feb 2009 12:22:13 -0500 Received: from majordom by post.thorcom.com with local (Exim 4.14) id 1LcNSA-0004lj-7y for rs_out_1@blacksheep.org; Wed, 25 Feb 2009 17:21:50 +0000 Received: from [193.82.116.32] (helo=relay1.thorcom.net) by post.thorcom.com with esmtp (Exim 4.14) id 1LcNS9-0004la-NG for rsgb_lf_group@blacksheep.org; Wed, 25 Feb 2009 17:21:49 +0000 Received: from mk-filter-1-a-1.mail.uk.tiscali.com ([212.74.100.52]) by relay1.thorcom.net with esmtp (Exim 4.63) (envelope-from ) id 1LcNS7-0001f1-6M for rsgb_lf_group@blacksheep.org; Wed, 25 Feb 2009 17:21:49 +0000 X-Trace: 156832754/mk-filter-1.mail.uk.tiscali.com/B2C/$b2c-THROTTLED-DYNAMIC/b2c-CUSTOMER-DYNAMIC-IP/88.106.83.13/None/g4wgt@tiscali.co.uk X-SBRS: None X-RemoteIP: 88.106.83.13 X-IP-MAIL-FROM: g4wgt@tiscali.co.uk X-MUA: Microsoft Office Outlook 11Produced By Microsoft MimeOLE V6.00.2900.3350 X-IP-BHB: Once X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AjoNAI8MpUlYalMN/2dsb2JhbACCclEwEYUzAX2DYctYB4QKBg X-IronPort-AV: E=Sophos;i="4.38,266,1233532800"; d="scan'208,217";a="156832754" Received: from 88-106-83-13.dynamic.dsl.as9105.com (HELO asus) ([88.106.83.13]) by smtp.tiscali.co.uk with ESMTP; 25 Feb 2009 17:21:25 +0000 From: "Gary - G4WGT" To: References: <009201c99767$6fb3cd90$6401a8c0@asus> <3C9EC82F90B64DD0ADB0D86BBDAC08C7@p4> Date: Wed, 25 Feb 2009 17:21:25 -0000 Message-ID: <000601c9976d$7cefa780$6401a8c0@asus> MIME-Version: 1.0 X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350 Thread-Index: AcmXazyNee6dlPfRQMCK+5tx89EtggAAaWIg In-Reply-To: <3C9EC82F90B64DD0ADB0D86BBDAC08C7@p4> X-Karma: unknown: X-Spam-Score: 0.0 (/) X-Spam-Report: autolearn=disabled,HTML_MESSAGE=0.001 Subject: LF: RE: Re: 500khz wspr spreadsheet Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C9976D.7CEFA780" X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on post.thorcom.com X-Spam-Level: X-Spam-Status: No, hits=0.2 required=5.0 tests=HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 X-SA-Exim-Scanned: Yes Sender: owner-rsgb_lf_group@blacksheep.org Precedence: bulk Reply-To: rsgb_lf_group@blacksheep.org X-Listname: rsgb_lf_group X-SA-Exim-Rcpt-To: rs_out_1@blacksheep.org X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-AOL-IP: 193.82.116.20 ------=_NextPart_000_0007_01C9976D.7CEFA780 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Mark, Thanks for looking & your reply. I did it manually & as it was my first a bit time consuming, I think the Excel macro will ease the data retrieval part at least, I will give it a try. It makes the levels more interesting in that format. 73 Gary - G4WGT _____ From: owner-rsgb_lf_group@blacksheep.org [mailto:owner-rsgb_lf_group@blacksheep.org] On Behalf Of Mark Sent: 25 February 2009 17:03 To: rsgb_lf_group@blacksheep.org Subject: LF: Re: 500khz wspr spreadsheet Hi Gary, very interesting, especially the correlation of the signal strengths which seems moderately high. for those wishing to do similar processing of WSPR data, I have written an Excel macro that enables you to extract data from the web database very quickly, and also converts the text based time date fields to a usable (ie plottable) format. http://www.dc2light.co.uk/getwspr1.6.xls no warranty offered or implied. it doesn't seem to work under openoffice either.. Hope this is of use ----- Original Message ----- From: Gary - G4WGT To: LF -RSGB LF Group Sent: Wednesday, February 25, 2009 4:38 PM Subject: LF: 500khz wspr spreadsheet Hi LF, I have created a MS Excel spread-sheet for my WSPRing last night. I have uploaded it to my website as it is too large for the LF group forum. On three worksheets there is a graph in marker format, a graph in line format & the data from the five stations who reported to the WSPR Spots page. It is my first attempt at an Excel chart, please let me know what you think. It can be downloaded at :- http://myweb.tiscali.co.uk/wgtaylor/WSPR01.xls 73, Gary - G4WGT - IO83QP. _____ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.237 / Virus Database: 270.11.3/1970 - Release Date: 02/24/09 13:35:00 ------=_NextPart_000_0007_01C9976D.7CEFA780 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Mark,=

&nb= sp;

Thanks for looking & your reply.

&nb= sp;

I did it manually & as it was my first a bit time consuming, I think the Excel ma= cro will ease the data retrieval part at least, I will give it a try.=

&nb= sp;

It makes the levels more interesting in that format.

&nb= sp;

73<= /o:p>

&nb= sp;

Gary = 211; G4WGT

&nb= sp;

From: owner-rsgb_lf_group@blacksheep.org [mailto:owner-rsgb_lf_group@blacksheep.or= g] On Behalf Of Mark
Sent: 25 February 2009 17:03<= br> To: rsgb_lf_group@blacksheep.= org
Subject: LF: Re: 500khz wspr spreadsheet

 

Hi Gary, very interesting, especially the correlati= on of the signal strengths which seems moderately high.

for those wishing to do similar processing of WSPR=20= data, I have written an Excel macro that enables you to extract data from the web database very quickly, and also converts the text based time date fields to=20= a usable (ie plottable) format.

no warranty offered or implied.<= /o:p>

it doesn't seem to work under openoffice either..

Hope this is of use

----- Original Message -----

Fro= m: Gary - G4WGT

Sent: Wedn= esday, February 25, 2009 4:38 PM

Subject: L= F: 500khz wspr spreadsheet

 

Hi LF,=

 =

I have created a MS Excel sprea= d-sheet for my WSPRing last night. I have uploaded it to my website as it is too large f= or the LF group forum. On three worksheets there is a graph in marker format, a graph in line format & the data from the five stations who reported to t= he WSPR Spots page.

 =

It is my first attempt at an Ex= cel chart, please let me know what you think. It can be downloaded at :-

 =

http://myweb.tiscali.co.uk/wgtaylor/WSPR01.xls

 =

73,

 

Gary - G4WGT - IO83QP.=

 


No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.3/1970 - Release Date: 02/24/09 13:35:00

------=_NextPart_000_0007_01C9976D.7CEFA780--