|
To download the files, which
are stored in the .zip format, right click over the link and then choose "Save
Target As...", which will enable you to choose where the file will be stored on
your PC. You can then un-zip the file and load it into Excel.
Contact Tony -
 if there are any queries, or if you have a particular interest in
scoring these types of event.
|
|
F3KScore
.XLS
Will handle up to 20 rounds
plus a fly-off, if needed. In use from 2004. Updated Aug 2009, with the new
task designations, now only scores the 8 official tasks.
Last updated Oct
2009.
Contact
F3KScoreCards.xls
Prints score cards for F3K tasks, four to an A4 sheet.
Will also "mail merge" competitors names if needed. In use from 2004. Last
updated Aug 2009 with the new task designations.
TasksF3K-Lotsofinfo.xls
Provides lots of information about the F3K Tasks. In use
from 2004.
FAI F3K Rules
2009
This is a .pdf file containing just F3K (9 pages),
instead of the 43 pages for all the F3 classes. |
eScoring.XLS
Converted from F3KScore.xls to suit the
eSoaring 200W/Kg class
that uses height limiters. In use from 2008, last updated May 2009.
200W-Scoring.XLS
Converted from eScoring.XLS to suit the different overfly rules. - 2
points taken off for every second overflown.
May 2009. |
|
F6DScore.XLS
The variation on
F3K designed to suit the World Air Games. In use from 2008.
F6D
Score Cards.xls
Score cards for above. In use from
2008. |
|
XLSCORE.xls
For BARCS Open and
100S (will handle F3J but poor at re-flies.) Includes facility for 2 or 3 man
teams. In use from 1997, last update 2005. Used at the 1st F3J World
Championship; held in the UK in 1998.
NAM-LAB.xls
Used with
XLSCORE.xls to produce slot picking lists and time recording sheets as well as
the transmitter labels that were popular when transmitters were impounded
between rounds. In use from 1997.
VICTOR-LUDORUM.xls
At
BARCS Radioglide the pilot with the best 3 results wins the trophy. This
workbook does the calculation. In use from 1997.
|
BARCSPostal.xls
Used to
record scores for the BARCS postal "best 10 from 20" flights
competition. |
|
Leagues.xls
Used to combine
events flown during the year into the League Totals and then find the best 4
results. In use since 2004. |
|
F3KDurationChallenge.zip
2009 - An informal competition that has been held for several years.
F3K pilots register their longest flight, so far, for the year. The winner
is the one who has held the longest flight position for the greatest number of
days.
The Excel workbook keeps track of the days and makes it easy to check
who is in the lead.
This keeps pilots busy in the early months of the year
as the times are slowly pushed up, then someone puts in a really long flight
and everyone else looses interest.
|
|
The Matrix
Easily producing a good
matrix for a soaring competition, ensuring everyone flys against everyone else
the same number of times, continues to be a problem.
Back in pre 35Mhz days
when we just had 6 frequencies it was done from pre-prepared tables. These
tables continued to be developed as more frequencies became available and it
was Alan Moore from Norfolk who produced the comprehensive set of tables
available here. - MOOREMAT.xls
The best computer
generated matrix maker I have come across is the one I used at the F3J World
Championships in 1998. It comes from the German set of Scoring files DAVE-F3J.
I preferred my own Excel workbooks for the scoring but was impressed with
STARTORD.EXE, which I have continued to use ever since. It is a touch arcane to
use but gives good results, especially with big contests. I have
produced STARTORD.XLS which takes the initial matrix data and converts it to a form that I
use in my scoring workbooks.
It turns out that
producing an Excel matrix checker is a lot easier than producing a matrix maker
itself and there is MatrixCheck.xls
available.
I would be pleased to hear
from anyone with an interest in matrix makers, particularly if they use
Excel.
Tony Beckett
|
