Multi-Site Predictions

After the creation of the Alternate Site Prediction capability, someone thought it might be nice to see LOTS of predictions for many different locations. The idea is to assist in planning the pre-positioning of Tracking & Recovery team members. So, ...

Above is a screen shot of this capability. The flight is out of Pueblo CSU. In the example above, the output has been sorted to show the stations in increasing range from each station to the setting distance of the balloon. You can sort on the either distance from the rise to the station, the closest approach or the set to the station as well as by station name. All sorts are ascending only. I could make it toggle, but for this particular application, I'm not sure it's worth the time writing the code. Let me know if you need that. I'd be happy to add it if there was that need.


Menu Options

[File/Select]

Using the File menu you can [File/Select] and choose an input file. This filename is "sticky". That is, it is saved to the wbaltrak.ini file and will be used each time the Multi-Predict screen is opened. Naturally, if you change it, the new filename will replace the old on in the INI file. (see notes below about file format)

There used to be a "Run" menu item. I dumped it. Now, whenever the program has a database file to work from, it automatically generates the prediction.

[File/Export/Prediction Spreadsheet]

Using the File menu you can [File/Export/Prediction Spreadsheet]. This selection will export the same data you see in the form above with no additional data. It will contain a header line indicating what each column contains. Most if not all spreadsheet programs should be able to read this file as it is a plain Ascii delimited file. The default file extension is CSV and that will alert Excel to simply load it as a spread sheet and not ask you  how you want the data interpreted.

    Here is an example file: multisite.csv

[File/Export/Prediction Text File]

Using the File menu you can [File/Export/Prediction Text File] to generate a plain text file with formatting. This file runs around 150 characters wide so you'll need to set your printers to landscape and reduce the font size if you actually want this on paper. But, at a font size of 8 using Courier New, it does fit.

Here is an example file: multisite.txt

[File/Export/Full Database Spreadsheet]

Using the File menu you can [File/Export/Full Database Spreadsheet] export the full database with all those fields shown below in the database editor and file format sections. This is similar to the Prediction Spreadsheet export above.

Here is an example file: multisite_full.csv

You'll note that even I don't have any data for these extra site description fields. I'm hoping the EOSS Tracking and Recovery team will be supplying me with that data over the coming years.

[File/Export/Street Atlas Map File]

Using the File menu you can [File/Export/Street Atlas Map File] export a file that will map out the current predicted track of the balloon, and all stations that will see the balloon rise above their locations' horizon. When you select this option this dialog box appears.

Any changes you make to this dialog will be saved in the wbaltrak.ini file and will become the defaults for future SA exports. These settings are independent of the SA Export routines available for the predictions only. So, you need not be concerned that you will generate confusing maps with these two Street Atlas settings dialogs.

Click the Export button and a map file is written out the the folder you specified on the setup screen for ASCII and Mapping Exports. Or, you can always change that location in the export file dialog box. Load that file into Street Atlas and here's what it looks like.

 

The above map was made with the database set to sort on the "Set" field. So, each bearing and range relates to that position. Since this map is so crowded, below is a close-up of the flight path with only a couple of stations included.

The Red Triangles are a few of the stations for which predictions were made. For each station the azimuth and range to the balloon is given after the station's name. The figures used depend on the way the prediction file was sorted. If you select to sort by the Rise, then that information will be given for each station. Select the closest approach sort option and that data will be placed on the map. Select the Set for the sort field as was the case above, and the map has notations for each station for the azimuth and range from that station to the location where the balloon disappeared below their local horizon.

Here is an example text export file for Street Atlas: multisiteSA.txt

Here is a Street Atlas 9 data file with the data used to make the above maps: multisite.sa9

[File/Preferences]

Under preferences you can select to calculate for either the Closest Approach or Maximum Elevation for sites in the database. This preference setting works with both the Alternate Site Prediction and the Multi-Site prediction, so changing it on one, changes it for the other as well. You can also set whether or not to display the lat/long/altitude of the station. Foregoing this information makes the display a little more user friendly. Be aware, when you  export the data to a text file, the printout is identical to what you see on the screen. So, this compact form will not export the lat/long/alt of the stations to the report file.


No lat/long/alt for stations

You can still check the lat/long/altitude by hovering your mouse over one of the station names. My screen capture tool won't capture tooltips but, ... take my word for it.

[Sort/Location Name]

The program sorts the results alphabetically by station name. A definite oversite in the previous version. I find myself looking for information about a particular station much more often than the data set as a whole. Sorting on the other keys is useful in certain applications but mostly, I find people are asking me for details about a particular station, not the closest, furthest, station with the highest maximum elevation. So ... better late than never.

[Sort/Rise Distance]

The program sorts the results by the distance from where the balloon rises over the horizon of the station being predicted for.

The next Item will either be sort for closest distance or maximum elevation. The selection is based on what settings are entered in the program preferences.

[Sort/Closest Distance]

The program sorts the results by the distance from where the balloon comes closest to the station being predicted for.

[Sort/Maximum Elevation]

The program sorts the results by the maximum elevation in relation to the station being predicted for.

[Sort/Set Distance]

The program sorts the results by the distance from where the balloon descends below the horizon of the station being predicted for.

A shortcut to sorting, just click on the title of the frames that contain each body of information (Rise, Closest Approach, Set) and the data will be sorted by range for that field.

The last sorting method used prior to closing this screen will be saved as the new default sort and used in subsequent multi site predictions.

[Edit Database]

Click [Edit Database] and the currently displayed database will be loaded into an editor. If the database is not a true multi-site database (20 fields) then the program will offer you two choices. Create a new file in true database format and you'll be prompted for a file name, or continue on and view the database with it temporarily corrected to a full 20 fields. However, if you try to save the changes you've made, assuming you make any, the program will insist you then enter a new file name for that database. This is probably the fastest way to convert any of your location INI files. Just load them into the editor, and when prompted, give that file a new name. I just stuck with the same original filename but let the program replace the file extension ".INI" with the default database extension ".OSD".

You can change any field on this screen, but for it to take effect you need to click the save button. Whatever changes you make on this screen are only made to the database in memory.

You can delete sites, add sites but all actions are in memory only.

When you exit this form by any method other than the Cancel Button you will be prompted to save the file. Cancel will let you abandon all changes an return to the Multi-Site Prediction form.

If you do make changes, additions or deletions, they will immediately be reflected in the Multi-Site Prediction form.


At the bottom of the Multi-Site Prediction screen is a status bar. The name of the current database file is in the lower left. To its right a "reminder" if you are using a file other than a true multi-site 20 field database. If you have a true database loaded, then it will tell you that ("Good DB File"). On the lower right, the sort method and the number of reporting stations is given.


The program is actually looking for a full database as described below, however, if the first four fields pass this check and there are no other fields, the program will create a temporary file adding commas to allow it to be properly imported.

This "calculator" will read in any Balloon Track Location file, with the exception of the VOR file. So, Launchsites.ini, landingsites.ini, Gridsites.ini will load and the station information in those files and can be used to generate this report. They are also excellent templates for creating a new file from scratch.

Database File Format

This file must be ASCII delimited by commas and strings should be surrounded by quotes (NO COMMAS in the quoted strings) and the file should have no header information and contain these fields:

The minimum acceptable input format is:

  • The name of the site as a string

  • The latitude of the as a decimal number (south is negative)

  • The Longitude of the site as a decimal number (west is negative)

  • The Altitude of the site as a decimal number. But you can enter a whole integer for the altitude without a decimal point. It just can't be a string value in the data base surrounded by quotation marks.

However the program will accept these fields in this order:

  • The name of the site as a string

  • The latitude of the as a decimal number (south is negative)

  • The Longitude of the site as a decimal number (west is negative)

  • The Altitude of the site as a decimal number. But you can enter a whole integer for the altitude without a decimal point. It just can't be a string value in the data base surrounded by quotation marks.

  • Street as a string

  • County as a string

  • State as a string

  • 8 horizon elevations (N, NE, E, SE, S, SW, W, NW) as integers 0 thru 90 degrees

  • RDF Quality (Integer 1 to 5)

  • Road Quality (Integer 1 to 5)

  • Parking Quality (Integer 1 to 5)

  • One Sentence Note as a string

  • A credit to the individual who surveyed the site as a string

The full database of fields won't be used with the possible exception of the horizon picture within Balloon Track. They are there for use in generating reports with Excel about the general quality and location of each observing site. Since there aren't too many, I thought it would be simple enough to just carry them into the program so that the data associated with each station would be easier to link. Otherwise it would have been necessary to generate a relational database to restore the linked data and generate reports.

If you aren't interested in all this extra data, just stick with the 4 value database files shown as the minimum required.


This new capability may or may not be of interest to others. But, our tracking team is always looking for a better way to get ready before the flight and this was their request.