Ah Peter, you are trapped in the cache !! I didnt think of that. Get the
Programs page up again from the net and then press the REFRESH button at the
top, if you get the updated page you will see the second link to ERP2.xls as
well. You are being served the old page you downloaded last night from your
PCs cache, "Temporary Internet Files" this speeds access and flipping
backwards and forwards without having to download the old page again, but it
can catch you out...always press Refresh if in any doubt.

Cheers de Alan G3NYK

----- Original Message -----
From: <[email protected]>
To: <[email protected]>
Sent: 30 April 2007 14:45
Subject: Re: LF: Re: Re: 500 ERP calculation Spreadsheet


>
>
> 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,
> [email protected] 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: <[email protected]>
> To:  <[email protected]>
> 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
> >
>
>
>
>
>
>
>
>
>