Thanks to all who responded to my questions about HFTA issues...both the actual
terrain readouts from K6TU and and also the resulting graphs produced by N6BV's
program.
The results produced from my personally taking elevations from Google Earth
seemed to be somewhat better than the originals, since the non-existing hills
that were taller than the tower location were gone. Not a huge difference, but
enough to make me happy about the new QTH
It never ceases to amaze me how much good info can be obtained from this
reflector. Thanks again! I just received my license from Belize . Now the
wait to get into the closed country to start building a house and a station.
K4XS/KH7XS/V31XX
-----Original Message-----
From: towertalk-request@contesting.com
To: towertalk@contesting.com
Sent: Sun, Oct 4, 2020 4:00 pm
Subject: TowerTalk Digest, Vol 214, Issue 3
Send TowerTalk mailing list submissions to
towertalk@contesting.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.contesting.com/mailman/listinfo/towertalk
or, via email, send a message with subject or body 'help' to
towertalk-request@contesting.com
You can reach the person managing the list at
towertalk-owner@contesting.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of TowerTalk digest..."
Today's Topics:
1. Working with HFTASweep data (Randy Farmer)
2. Re: Working with HFTASweep data (David Gilbert)
3. Re: Working with HFTASweep data (Randy Farmer)
4. Re: Working with HFTASweep data (Dan Maguire)
5. Re: Working with HFTASweep data (Randy Farmer)
6. Re: Working with HFTASweep data (Randy Farmer)
----------------------------------------------------------------------
Message: 1
Date: Sat, 3 Oct 2020 12:28:17 -0400
From: Randy Farmer <w8fn@windstream.net>
To: towertalk <towertalk@contesting.com>
Subject: [TowerTalk] Working with HFTASweep data
Message-ID: <c345f2e7-9088-2689-639a-3ae441472ec1@windstream.net>
Content-Type: text/plain; charset=utf-8; format=flowed
I'm trying to find a way to import the *.13 gain data produced by
HFTASweep into Excel so I can display it as a polar plot for various
elevation angle cuts. I'm definitely no Excel guru, and haven't yet
figured out how to transform the tabular text from the *.13 file into a
usable form for import. Once I can get into cells, I can certainly get
it plotted. I'm sure someone has done this before. Any help would be
appreciated.
73...
Randy, W8FN
------------------------------
Message: 2
Date: Sat, 3 Oct 2020 11:55:24 -0700
From: David Gilbert <ab7echo@gmail.com>
To: towertalk@contesting.com
Subject: Re: [TowerTalk] Working with HFTASweep data
Message-ID: <62761360-0ded-c52b-3704-7af723a68728@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Hi, Randy.
If I understand your question correctly, you should be able to highlight
the text data, copy, it, and then paste it into Excel with the "text"
option selected.
If that doesn't work for you, send me the text data and I'll play with
it until I get it into Excel, and then I'll send the Excel file back to you.
73,
Dave?? AB7E
On 10/3/2020 9:28 AM, Randy Farmer wrote:
> I'm trying to find a way to import the *.13 gain data produced by
> HFTASweep into Excel so I can display it as a polar plot for various
> elevation angle cuts. I'm definitely no Excel guru, and haven't yet
> figured out how to transform the tabular text from the *.13 file into
> a usable form for import. Once I can get into cells, I can certainly
> get it plotted. I'm sure someone has done this before. Any help would
> be appreciated.
>
> 73...
> Randy, W8FN
> _______________________________________________
>
>
>
> _______________________________________________
> TowerTalk mailing list
> TowerTalk@contesting.com
> http://lists.contesting.com/mailman/listinfo/towertalk
------------------------------
Message: 3
Date: Sat, 3 Oct 2020 17:53:31 -0400
From: Randy Farmer <w8fn@windstream.net>
To: towertalk@contesting.com
Subject: Re: [TowerTalk] Working with HFTASweep data
Message-ID: <05336dd5-4c0a-7957-9e5c-a255e935efd8@windstream.net>
Content-Type: text/plain; charset=utf-8; format=flowed
Thanks to those who replied on and off list. It's just a "simple" matter
of importing the *.13 text data (which turns out to be organized in
fixed width fields) into Excel using the Data Import function. Then
there's a whole lot of reformatting to get the tabular formats put into
useful form. Since I'm not an Excel macro guy, that means doing some
simple copy and paste with formulas, followed by a WHOLE lot of manual
deletion of redundant rows of text. I'm making progress.
73...
Randy, W8FN
------------------------------
Message: 4
Date: Sat, 3 Oct 2020 14:59:28 -0700
From: Dan Maguire <danac6la@gmail.com>
To: towertalk <towertalk@contesting.com>
Subject: Re: [TowerTalk] Working with HFTASweep data
Message-ID:
<CAOnXRMvOyC-155xHW6cr5K2ZVU7G3JYO1nFsTHU8Cna6jPUUXQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Randy Farmer wrote:
>>> I'm trying to find a way to import the *.13 gain data produced by HFTASweep
>>> into Excel so I can display it as a polar plot for various elevation angle
>>> cuts.
As an alternative to DIY Excel plotting, and if you are willing to
download and install the ITS HF Propagation package (
http://greg-hand.com/hfwin32.html ), that package has a utility
program called HFANT that can display azimuth and elevation patterns
from *.13 files. Example screen grabs:
https://i.imgur.com/4PLvdmn.png
https://i.imgur.com/Tucgcnm.png
Dan, AC6LA
------------------------------
Message: 5
Date: Sun, 4 Oct 2020 10:42:35 -0400
From: Randy Farmer <w8fn@windstream.net>
To: towertalk@contesting.com
Subject: Re: [TowerTalk] Working with HFTASweep data
Message-ID: <905c7e87-3be2-f665-6207-9b1d58f6e16b@windstream.net>
Content-Type: text/plain; charset=utf-8; format=flowed
Thanks for the tip, Dan. Unfortunately, I can't get the HFANT utility to
accept the data from the HFTASweep files. I get either complaints about
improper antenna name format or invalid character in field. I've done
considerable fooling around with the data files and can't figure out
what the problem is. I can copy the new data and paste it over the data
in one of the sample files and it gives me an error, but doesn't
directly say where it is. I haven't taken the time to check all 32,760
entries in the data file to see what (possibly non-printing) character
is causing the upset. It sure would be nice if I could find a spec for
the exact data table format, but no luck there looking through the
documentation. Guess I'm stuck with Excel.
73...
Randy, W8FN
On 10/3/2020 5:59 PM, Dan Maguire wrote:
> Randy Farmer wrote:
>>>> I'm trying to find a way to import the *.13 gain data produced by
>>>> HFTASweep into Excel so I can display it as a polar plot for various
>>>> elevation angle cuts.
> As an alternative to DIY Excel plotting, and if you are willing to
> download and install the ITS HF Propagation package (
> http://greg-hand.com/hfwin32.html ), that package has a utility
> program called HFANT that can display azimuth and elevation patterns
> from *.13 files. Example screen grabs:
>
> https://i.imgur.com/4PLvdmn.png
>
> https://i.imgur.com/Tucgcnm.png
>
> Dan, AC6LA
------------------------------
Message: 6
Date: Sun, 4 Oct 2020 11:30:47 -0400
From: Randy Farmer <w8fn@windstream.net>
To: towertalk@contesting.com
Subject: Re: [TowerTalk] Working with HFTASweep data
Message-ID: <5364f0bd-d26e-47dd-9bd0-ccc993fd1362@windstream.net>
Content-Type: text/plain; charset=utf-8; format=flowed
I re-ran the sweeps again and this time the new data files work fine
with HFANT. Gawd, I love computers!
73...
Randy, W8FN
On 10/4/2020 10:42 AM, Randy Farmer wrote:
> Thanks for the tip, Dan. Unfortunately, I can't get the HFANT utility
> to accept the data from the HFTASweep files. I get either complaints
> about improper antenna name format or invalid character in field. I've
> done considerable fooling around with the data files and can't figure
> out what the problem is. I can copy the new data and paste it over the
> data in one of the sample files and it gives me an error, but doesn't
> directly say where it is. I haven't taken the time to check all 32,760
> entries in the data file to see what (possibly non-printing) character
> is causing the upset. It sure would be nice if I could find a spec for
> the exact data table format, but no luck there looking through the
> documentation. Guess I'm stuck with Excel.
>
> 73...
> Randy, W8FN
------------------------------
Subject: Digest Footer
_______________________________________________
TowerTalk mailing list
TowerTalk@contesting.com
http://lists.contesting.com/mailman/listinfo/towertalk
------------------------------
End of TowerTalk Digest, Vol 214, Issue 3
*****************************************
_______________________________________________
_______________________________________________
TowerTalk mailing list
TowerTalk@contesting.com
http://lists.contesting.com/mailman/listinfo/towertalk
|
