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)
DomainKey-Status: bad (test mode)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=btinternet.com;
  h=Received:X-YMail-OSG:Message-ID:From:To:Subject:Date:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Priority:X-MSMail-Priority:X-Mailer:X-MimeOLE;
  b=u7rwopg84vVOeTeZ2IazV5gXxaXWJ9vQ1v1eekAn0VGocOCOSctwHMDzWcN2oomDp8OsPfG2jZpUOi0XAsleGCquI9jMlQjuVAITpK4pTHrfUjpmVt/RipIT1Ok3B9s22p7m2ODCLyRCuv1DyScCnubIK+dPPmXC0duAk0PPt2I=  ;
Message-ID: <000701c7718b$a31f9fa0$0300a8c0@lark>
From: "Alan Melia" <alan.melia@btinternet.com>
To: <rsgb_lf_group@blacksheep.org>
Date: Wed, 28 Mar 2007 23:50:47 +0100
MIME-Version: 1.0
DomainKey-Status: good (testing) 
Subject: LF: Warning re ERP spreadsheet
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Sender: owner-rsgb_lf_group@blacksheep.org
Precedence: bulk
Reply-To: rsgb_lf_group@blacksheep.org
Status: O

Hi all the Excel spreadsheet for calculating ERP for use at 500kHz (and any
other frequency) is fine if used with the values given. Some wished to
modify the sheet for very short top-loads compared with my 20m minimum. This
can be done but it seems you run into granularity of the lookup table which
will always give the lower value for form-factor if the top to height ratio
is not exactly on a cell value. This means the sheet underestimates the Rrad
slightly for some ratios on very short top loads. Once the top-length is
equal to the height the error is very small. I will rework the sheet
eventually to cover this problem by fitting an equation to the lookup table.
( N.B. this table was intended for use on Battleships !!)
The lastest version ( ERP1.xls) dated 10/3/07 should be correct. I note
though that the table gives a 0.639 form factor for an unloaded vertical
when I thought this should be 0.5. I will need to check this out further. It
came to light as Finbar is experimenting on short verticals with very small
top-hats. We hope to write up his findings in due course.
His present beacon is on a top-inductively loaded 7m vertical with short
capacity wires!! This is an aerial that most should be able to fit into even
a small garden. The trick will be whether we can make it efficient with such
a small top capacity.

Cheers de Alan G3NYK