Version 1
Fixed Normalization for Cumulative Duration
Fixed Triathalon Normalization format
Version 1.1
Totals for Normalized scored messed up when sorted
Improved Normalizing Algorithm to get rid of extra tables
Highlight Typing areas
Add Sort capability to menu for manual flight order/groups
Some cosmetic changes like fonts
Normalization function bug fixed
Version 1.2
Added Distance and Speed Tasks
Fixed Number format for cum dur target time to show zeros.
Version 1.3
Changed Frequency conflict resolution to do a better job
Combined flight group allocation macros for easier maintenance
small menu changes
Version 2.0
Major Upgrade to Excel 97
Major change to allow up to 10 user defined classes
Changed flight group allocations to be more intelligent
Automatically uppercase class abbreviations
Version 2.1
Added error checking to seconds and landing points
Changed fromat for minutes fields to have time colons
Fixed a bunch of sheets where the input area highlighting was incorrect
Changed all input fields to BOLD 12pt to make them easier to read outdoors
Versions 2.2, 2.3
Forgot to record what I changed - a few formula errors I think…
Version 2.4
Removed Menu from menubar at close..
Allowed for Withdrawal during a contest to not affect flight groups
Version 2.5
Changed Normalized scores to display 2 decimal places
Changed some layouts to print better
2.6
Changed to add open winch menu item
Tweaked flight group allocation algorithm
Added sorting function to tools menu
2.7
Changed normalization to allow an option for including landing scores or not in normalization
2.8
Added a HL task scoring template
2.9
Fixed Normalizing templates to show an ORDER error instead of #REF if no flight group is assigned
2.1
Added menu item for printing flight groups
2.11
Fixed problem with withdraw in byclass fg assignments
2.12
Added Hand Launch Tasks to menus and created scroing matrixes
2.13
Fixed HL to have at least 10 rounds of a single max time
Fixed the total sorting to avoid class normalization truncation
Fixed various formulas that got deleted accidentally
2.14
Added F3J type Flight Matrixes
2.15
Added Flight group allocation by high scores for total and round scores
2.16
Added calculation of flying and retrieving assignments for each flight group
2.17
Changed Speed to be F3B speed - since no-one flys T8 Speed.
Fixed a display problem in Distance Normalized
2.18
Updated Data Validation to handle Ham Bands - Channels 00-09 and the 53 mhz Freqs
2.19
Changed Round to int to try to be backward compatible with xls97
2.2
Fixed a sorting problem on the Totals sheet
2.21
Changed FG Assignment to randomize the winch assignments
Changed fly/fetch order print to size automatically and select the area
2.22
Fixed a problem with Class names in the totals sheet
Fixed a problem with flyer row 12 not being set in the totals
2.23
Fixed Totals Sort Problem
2.24
Fixed problem with more than 3 classes in totals
2.25
Re-did macro names - 'case excel messed the references up
2.26
Added ranking by contest and by class to the totals sheet
2.27
Fixed problem with ranking by contest
Added display of "-" to landing scores to differentiate between unentered scores and zero.
2.28
Added the ability to have a list of flyers with their class and frequencies that can accessed from the Name pulldown
Protected fields on "Contest Data" that should not be changed
2.29
Added immediate printout to Fly/Fetch - Totals - and added print round capability
2.30
Made the PrintTotals function also print out the round sheet - for score verification
2.31
Updated the code that removes the toolbar to only remove it when the last instance of an AMA Worksheet is closed.
2.32
Updated to allow for up to 18 rounds in a single contest
Update to allow for throw-aways for every 6 rounds
2.33
Update to allow recording a team for F3J scoring
2.34
Update to allow import of an external flight group matrix
2.35
Update to add Safety penalties that are recorded in the round they occur, but are added to the total at the end of the contest.
2.36
Update error messages to not show on unused entries
Fix reference for F3J style
2.37
Added AMA number to Contest Data sheet and use it to look up names and frequencies from the STDNames page
2.38
Fixed a bunch of references that broke when I added the stuff for 2.37…
2.39
Made winch assignments a truly random process
Printed an ® next to fetchers that are assigned randomly when there are not enough fetchers for the flyers in the group
2.40
Fixed the algorithm for setting rank by contest in the totals sheet
2.41
Fixed bug in Seeded MoM by Totals
2.42
Fixed similar bug in Seeded MoM by Prev Round
2.43
Fixed Problem with sorting on Totals page
2.44
Fix a problem with the fix in 2.43 …