Ok, I've been reading your posts again and looking at the web sites. See if this is close:
Step 1 : you go to the FCC FM-Query Search web site and enter the a radius and the Center Coordinates (NAD 27), then click a button.
Step 2 : you get a page of FM Query Results, do some filtering on the results and end up with a list of Stations.
Step 3 : you click on a call sign and another FM Query Results page appears.
Step 4 : in the FM Query Results from Step 3, clicking on "Calculate HAAT" results in this page. I'm not sure how you get the data saved to a text file. You rename each file to "CallSignHAATData.txt".
So now you have X number of files (20 in your example in Post #39) that look like
Code:
Antenna Height Above Average Terrain Calculations -- Results
Input Data
Latitude 36° 41' 45" North
Longitude 108° 13' 23" West (NAD 27)
These coordinates convert to NAD 83 coordinates of
36° 41' 45.01", North, 108° 13' 25.27" West (NAD 83).
Height of antenna radiation center above mean sea level: 1802 meters AMSL
Number of Evenly Spaced Radials = 360 0° is referenced to True North
Results
Calculated HAAT = 88 meters
Antenna Height Above Average Terrain calculated
using 1 km GLOBE terrain data
Individual "Radial HAAT" Values, in meters
0° 145.2 m 120° 72.0 m 240° 60.6 m
1° 148.0 m 121° 70.2 m 241° 61.5 m
2° 147.5 m 122° 67.8 m 242° 62.4 m
3° 146.2 m 123° 65.1 m 243° 63.5 m
4° 145.3 m 124° 62.7 m 244° 64.9 m
Step 5 : Next convert the 6 column text files to 2 column text files renamed to something like "CallSignHAATDataReady.txt".
The data in the text file looks like
Code:
1 148.0 m
2 147.5 m
3 146.2 m
4 145.3 m
5 143.2 m
6 138.9 m
7 132.5 m
8 127.4 m
9 122.1 m
10 115.9 m
11 111.1 m
12 107.1 m
13 103.4 m
14 99.8 m
15 96.2 m
etc.
Step 6 : Using "FccCurves.mdb", the "CallSignHAATDataReady.txt" files are processed and renamed "CallSignDistance.txt"
The text file data now is
Code:
1 139449
2 139212
3 139081
4 139010
5 138963
6 138844
7 138713
8 138558
9 138391
10 138224
11 138033
In "FccCurves.mdb", you set:
Select Contour Type = F(50,50) service contour option
Select Channel Range = FM radio and TV transmit Channels 2-6
ERP (in kilowatts) = 6
Field strength (in dBu) = 70
HAAT = empty
Q1) Distance is left empty?
Q2) If you had 20 text files, would all 20 files use the same parameters?
Q3) What is the RESULTS control for?
Q4) What does the FIND button do?
Finally, the "CallSignDistance.txt" files are copied into the JaveScript program to create latitude/longitude pairs in a CSV file for plotting.
Am I close??
-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------
I didn't forget. Here is rpeare's dB that should run in your computer.
I used Win XT with Access 2000. It runs in my computer, so it should run on your computer.
The function "PopulateList" is what I modified.
Code:
<snip>
With lstFiles
For Each fsFile In fsFolder.files
sFile = fsFile.Name
sCall = Left(sFile, InStr(sFile, " ") - 1)
sBand = Right(sCall, Len(sCall) - InStr(sCall, "-"))
sCall = Left(sCall, InStr(sCall, "-") - 1)
' .AddItem sCall & ";" & sBand & ";" & sFile
tmp = tmp & sCall & ";" & sBand & ";" & sFile & ";"
' Debug.Print tmp
Next fsFile
.RowSource = tmp
End With
<snip>