X-GM-THRID: 1235102064118401282 X-Gmail-Labels: rsgb lf Delivered-To: daveyxm@gmail.com Received: by 10.35.22.5 with SMTP id z5cs392156pyi; Mon, 30 Apr 2007 06:49:31 -0700 (PDT) Received: by 10.67.71.15 with SMTP id y15mr5417753ugk.1177940970701; Mon, 30 Apr 2007 06:49:30 -0700 (PDT) Return-Path: Received: from post.thorcom.com (post.thorcom.com [193.82.116.20]) by mx.google.com with ESMTP id 27si6848861ugp.2007.04.30.06.49.26; Mon, 30 Apr 2007 06:49:30 -0700 (PDT) Received-SPF: neutral (google.com: 193.82.116.20 is neither permitted nor denied by best guess record for domain of owner-rsgb_lf_group@blacksheep.org) Received: from majordom by post.thorcom.com with local (Exim 4.14) id 1HiWCO-0003mg-2B for rs_out_1@blacksheep.org; Mon, 30 Apr 2007 14:45:52 +0100 Received: from [83.244.159.144] (helo=relay3.thorcom.net) by post.thorcom.com with esmtp (Exim 4.14) id 1HiWCN-0003mX-G1 for rsgb_lf_group@blacksheep.org; Mon, 30 Apr 2007 14:45:51 +0100 Received: from imo-d04.mx.aol.com ([205.188.157.36]) by relay3.thorcom.net with esmtp (Exim 4.63) (envelope-from ) id 1HiWCM-0007vN-79 for rsgb_lf_group@blacksheep.org; Mon, 30 Apr 2007 14:45:51 +0100 Received: from ColePe@aol.com by imo-d04.mx.aol.com (mail_out_v38_r9.2.) id l.bec.de5f029 (41809) for ; Mon, 30 Apr 2007 09:45:35 -0400 (EDT) From: ColePe@aol.com Message-ID: Date: Mon, 30 Apr 2007 09:45:35 EDT To: rsgb_lf_group@blacksheep.org MIME-Version: 1.0 X-Mailer: 9.0 SE for Windows sub 5022 X-Spam-Flag: NO X-Spam-Score: 0.6 (/) X-Spam-Report: autolearn=disabled,HTML_MESSAGE=0.001,NO_REAL_NAME=0.55 Subject: Re: LF: Re: Re: 500 ERP calculation Spreadsheet Content-Type: multipart/alternative; boundary="-----------------------------1177940735" X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on post.thorcom.com X-Spam-Level: X-Spam-Status: No, hits=0.4 required=5.0 tests=CLICK_BELOW, HTML_LINK_CLICK_HERE,HTML_MESSAGE,NO_REAL_NAME 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 Status: O X-Status: X-Keywords: X-UID: 1985 -------------------------------1177940735 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Alan, so what am I doing wrong? The following is all I see at the bottom of the page. Clicking on ERP1.xls opens the March file. I can find no reference to ERP2. When I find this will it give the correct answers for a vertical? Peter. _Click here to download CVconv.zip_ (http://www.alan.melia.btinternet.co.uk/download/CVconv.zip) (abt 85k) 6. Excel spreadsheet that calculates the radiation resistance of a loop and a top-loaded vertical (Marconi) and calculated the aerial current necesary to radiate -10dBw as allowed on the new 500kHz experimental allocation. This spreadsheet uses the procedure that was in the old Loopcalac. However it turns out that the radiation resistance i used for the inverted "L" was incorrect by a factor of 2. The formula I used from the Admiralty handbook 1938 vol 2 turns out to be for a dipole. The radiated power quoted in this sheet is the "total radiated power" which I think would be EIRP. I suggest that this is more practically correct for amateur sized aerials than using the ERP figure which is 2.8dB greater due to the directivity. The top-length figure may need changing for very small aerials, and you will need to unprotect the sheet and juct change to top row cell and the change should rattle through the sheet. I suggest you protect it again to prevent accidental corruption. _Click here to download ERP1.xls_ (http://www.alan.melia.btinternet.co.uk/download/ERP1.xls) In a message dated 30/04/2007 13:11:55 Greenwich Standard Time, alan.melia@btinternet.com writes: Hi Peter both versions I checked this morning are dated 29/04/07 and "corrected for form-factor" Try http://www.btinternet.com/~alan.melia/programs.htm and go to the bottom of the page and click on the appropriate version ERP2 is for short top-loads. There is still a minor problem with this that is the form-factor ratio falls between two of the data points is selects the lower value. I dont think this is really significant, although it will give a slightly different Rrad for very short top loads from other equations or programs. I have kept the file names the same as there are links published to them. Best Wished de Alan G3NYK ----- Original Message ----- From: To: Sent: 30 April 2007 13:11 Subject: Re: LF: Re: Re: 500 ERP calculation Spreadsheet > > > Alan, > > where do I find the new copy of your spreadsheet? All I see on your web > site is the March edition. > > Peter, G3JFS > -------------------------------1177940735 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Alan, so what am I doing wrong? The following is all I see at the bottom=20= of=20 the page.  Clicking on ERP1.xls opens the March file. I can find no=20 reference to ERP2.  When I find this will it give the correct answers f= or a=20 vertical?

Peter.

Cl= ick=20 here to download CVconv.zip (abt 85k)

6. Excel spreadsheet that calculates the radiation resistance of=20= a=20 loop and a top-loaded vertical (Marconi) and calculated the aerial current=20 necesary to radiate -10dBw as allowed on the new 500kHz experimental allocat= ion.=20 This spreadsheet uses the procedure that was in the old Loopcalac. However i= t=20 turns out that the radiation resistance i used for the inverted "L" was=20 incorrect by a factor of 2. The formula I used from the Admiralty handbook 1= 938=20 vol 2 turns out to be for a dipole. The radiated power quoted in this sheet=20= is=20 the "total radiated power" which I think would be EIRP. I suggest that this=20= is=20 more practically correct for amateur sized aerials than using the ERP figure= =20 which is 2.8dB greater due to the directivity. The top-length figure may nee= d=20 changing for very small aerials, and you will need to unprotect the sheet an= d=20 juct change to top row cell and the change should rattle through the sheet.=20= I=20 suggest you protect it again to prevent accidental corruption.

Clic= k here=20 to download ERP1.xls

 

 
In a message dated 30/04/2007 13:11:55 Greenwich Standard Time,=20 alan.melia@btinternet.com writes:
<= FONT=20 style=3D"BACKGROUND-COLOR: transparent" face=3DArial color=3D#000000 size= =3D2>Hi Peter=20 both versions I checked this morning are dated 29/04/07 and
"corrected=20= for=20 form-factor"
Try http://www.btinternet.com/~alan.melia/programs.htm
= and=20 go to the bottom of the page and click on the appropriate version ERP2
= is=20 for short top-loads. There is still a minor problem with this that is=20 the
form-factor ratio falls between two of the data points is selects t= he=20 lower
value. I dont think this is really significant, although it will=20= give=20 a
slightly different Rrad for very short top loads from other equations= =20 or
programs. I have kept the file names the same as there are links=20 published
to them.

Best Wished de Alan G3NYK

----- Origin= al=20 Message -----
From: <ColePe@aol.com>
To:=20 <rsgb_lf_group@blacksheep.org>
Sent: 30 April 2007 13:11
Subje= ct:=20 Re: LF: Re: Re: 500 ERP calculation=20 Spreadsheet


>
>
> Alan,
>
> where do= I=20 find the new copy of your spreadsheet?  All I see on your =20 web
> site is the March edition.
>
> Peter,=20 G3JFS
>
 
-------------------------------1177940735--