F3K Scoring Spreadsheet

markStockton · Jul 04, 2007, 04:44 AM

Hi All

I've written a spreadsheet that can be used to score F3K events. The spreadsheet caters for up to 25 competitors that are split into upto 3 slots per round. It is fairly trivial to extend the sheet to cater for more competitors as well as more slots.

It should be noted that this is very much a beta (test) version and I'm sure there are still bugs and mistakes. If you find any please let me know and I'll correct them. The spreadsheet was created using OpenOffice.org 2.2, however it should work well on MS Office as well.

OpenOffice.org 2.X
MS Office

To use the spreadsheet's, one would need to do the following:

- Capture Pilot Names on the "Pilots" worksheet.
- Capture all scores for the various tasks in seconds.
- Use the "Results" worksheet to sort the final result.

I will endevour to keep the latest versions available for download on South African F3K Blog

Richard S · Jul 04, 2007, 08:22 AM

Hi Mark,

We have a very similar thing here in the UK, including automatic matrixing, printing of scorecards etc etc

You might want to get hold of a copy to see if you can swap idea's.

The best contact is to PM "Tony" on the www.flyquiet.co.uk forum. Tony has put a huge amount of effort into creating it over the years ,and is one of the most helpful guys you'll find.

Richard

IBWALT · Jul 04, 2007, 08:51 AM

We have one that we use here in Houston that was written by Oleg and modified by one of our club members. It will handle 40 pilots in four flight groups. Automatically alphabetize the pilot list, assign pilots to random flight groups for all rounds and check for frequency conflicts. Right now it will handle 16 rounds of regular flying plus a three round fly off and then sort the final scores from highest to lowest. It even washed my car one time and I think that it makes drunk chicks think I'm good looking.

Time is kept in seconds and each round is normalized. It is Excel based and requires Excel 2003 or later to run.

If you would like a copy for your club F3K contests just pm me.

TonyB · Jul 09, 2007, 04:07 AM

At the comp last Saturday I heard from Richard about this thread.
Thanks Mark, I have downloaded your file and had a look.

My approach is to use Excel macros to pull in the tasks when needed and to get results into the final totals.

In the UK we have got used to seeing printed results at the end of each round; the Excel macros make this easy. Also producing running totals when you want as well as drop one or drop two scores. It will also print a flying order sheet.

Of course the disadvantage of using Visual Basic for Applications is that you have to be running Excel. No possibility of a conversion to Open Office as in Marks formula based version.

I also have an Excel score card printing file. All the F3K tasks are included and can be chosen individually. We print four to an A4 piece of thin coloured card. This A6 size clips neatly to our stop watch set. The cards have a reminder of the task being flown printed on them.

Interested to read that in Houston you use “random flight groups”. In the UK we have tried to have an “accurate” matrix where, within the constraints of shared frequencies, each pilot flies against all others an equal number of times. To do this we use <Startord.exe> from Germany. I have used this since 1998 and believe it does a good job. However it is a little tricky to use and I would be pleased to hear from others how they deal with matrix producing. I have been told that there is a branch of mathematics called “network flow optimisation” which deals with “matrix making” but I have no knowledge of this.

Should anyone have a matrix maker I have an Excel version of a matrix checker. Much easier to produce something that checks the matrix than it is to make the matrix maker in the first place….

If you wish to have a copy of my scoring workbook let me know at tony@barcs.clara.net. If anybody is curious about the F3K Score Cards file I have put a zipped version on the board.

Tony

IBWALT · Jul 09, 2007, 09:02 AM

Quote:

Originally Posted by TonyB

Interested to read that in Houston you use “random flight groups”.
Tony

Tony, the flight groups are random in the sense that the spreadsheet generates them. However, if you want to make sure that certain individuals fly against each other or you have a special reason to make sure that there are special parings. Then all you need to do is press the resort button for the round or rounds in question until you get the pairings that you desire.

Walt

Richard S · Jul 09, 2007, 10:29 AM

Hi Walt,

It is not just individual pairings that matter, obviously you want the top pilots flying against each other an equal number of times.

However you also need the "novice" pilots to fly against the top pilots equally, otherwise you could end up with a novice pilot beating an experience pilot.... all because the novice has not had to fly in as many challenging rounds. (in the uk there are no separate classes for "novice", "sportsman" and "advanced")

There have been one or two occations in the UK competitions where it has been possible to plot peoples placings in a series of competitions, directly to where there have been difficulties with the matrixing. Luckily using the tools that Tony has produced, this kind of error can be reduced making for a fair competition.

With Tony's scoring application it actually displays a view of the matrix validity, allowing you to make manual changes to the calculated matrix and viewing how this effects the number of times people meet each other in a slot... it is virtually impossible to get a valid matrix showing up by using either random or manual methods.

IBWALT · Jul 09, 2007, 11:09 AM

Richard, I see your point or points and I can remember being at contests when I looked at the other competitors and said what am I doing in this round.

But like you said in the States we have three different classes of flyers and they compete with other flyers in their class on the score sheet at least. While flying in the same rounds as pilots from the other two classes. At the end of the contest you can compare your score against the better flyers and see how you did in comparison to them. Because you flew in the same rounds as them and your score was normalized right along with theirs. This gives you a overall understanding of how well you did and you can tell if it is time for you to move up in class or think about selling your HLG and buying a slope ship.

The big difference and what levels the playing field is the different classes of flyers and the random nature of the sort prevents any competitor from getting beat up by or beating up on the same persons all of the time. Also the beauty of this program is that if you see after the sorting is done that a couple of the "Big Boys" are not flying against each other you only need to re-sort a round or two to solve the problem.

Now whether random is really random or not is another question. Seems every time I go to Vegas (Las Vegas) I end up on the short end of the random stick.

Jul 04, 2007, 04:44 AM	#1
markStockton F3J, F3K and F5J eXtreme Join Date: Apr 2005 Location: Johannesburg, South Africa Posts: 276	F3K Scoring Spreadsheet Hi All I've written a spreadsheet that can be used to score F3K events. The spreadsheet caters for up to 25 competitors that are split into upto 3 slots per round. It is fairly trivial to extend the sheet to cater for more competitors as well as more slots. It should be noted that this is very much a beta (test) version and I'm sure there are still bugs and mistakes. If you find any please let me know and I'll correct them. The spreadsheet was created using OpenOffice.org 2.2, however it should work well on MS Office as well. OpenOffice.org 2.X MS Office To use the spreadsheet's, one would need to do the following: - Capture Pilot Names on the "Pilots" worksheet. - Capture all scores for the various tasks in seconds. - Use the "Results" worksheet to sort the final result. I will endevour to keep the latest versions available for download on South African F3K Blog

Jul 09, 2007, 04:07 AM	#4
TonyB Registered User Join Date: Oct 2003 Location: Rutland, UK Posts: 7	At the comp last Saturday I heard from Richard about this thread. Thanks Mark, I have downloaded your file and had a look. My approach is to use Excel macros to pull in the tasks when needed and to get results into the final totals. In the UK we have got used to seeing printed results at the end of each round; the Excel macros make this easy. Also producing running totals when you want as well as drop one or drop two scores. It will also print a flying order sheet. Of course the disadvantage of using Visual Basic for Applications is that you have to be running Excel. No possibility of a conversion to Open Office as in Marks formula based version. I also have an Excel score card printing file. All the F3K tasks are included and can be chosen individually. We print four to an A4 piece of thin coloured card. This A6 size clips neatly to our stop watch set. The cards have a reminder of the task being flown printed on them. Interested to read that in Houston you use “random flight groups”. In the UK we have tried to have an “accurate” matrix where, within the constraints of shared frequencies, each pilot flies against all others an equal number of times. To do this we use <Startord.exe> from Germany. I have used this since 1998 and believe it does a good job. However it is a little tricky to use and I would be pleased to hear from others how they deal with matrix producing. I have been told that there is a branch of mathematics called “network flow optimisation” which deals with “matrix making” but I have no knowledge of this. Should anyone have a matrix maker I have an Excel version of a matrix checker. Much easier to produce something that checks the matrix than it is to make the matrix maker in the first place…. If you wish to have a copy of my scoring workbook let me know at tony@barcs.clara.net. If anybody is curious about the F3K Score Cards file I have put a zipped version on the board. Tony Attached Files F3K Score Cards.zip (47.4 KB, 91 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
scoring spreadsheet	tony estep	RCSE	0	Jun 12, 2006 11:11 AM
TD Scoring spreadsheet	Hostage-46	Sailplane Talk	6	May 19, 2005 10:42 AM

Jul 04, 2007, 08:22 AM	#2
Richard S Registered User Join Date: Oct 2005 Location: Milton Keynes, UK Posts: 840	Hi Mark, We have a very similar thing here in the UK, including automatic matrixing, printing of scorecards etc etc You might want to get hold of a copy to see if you can swap idea's. The best contact is to PM "Tony" on the www.flyquiet.co.uk forum. Tony has put a huge amount of effort into creating it over the years ,and is one of the most helpful guys you'll find. Richard

Jul 04, 2007, 08:51 AM	#3
IBWALT W0X0F Join Date: Nov 2005 Location: Kingwood, TX Posts: 794	We have one that we use here in Houston that was written by Oleg and modified by one of our club members. It will handle 40 pilots in four flight groups. Automatically alphabetize the pilot list, assign pilots to random flight groups for all rounds and check for frequency conflicts. Right now it will handle 16 rounds of regular flying plus a three round fly off and then sort the final scores from highest to lowest. It even washed my car one time and I think that it makes drunk chicks think I'm good looking. Time is kept in seconds and each round is normalized. It is Excel based and requires Excel 2003 or later to run. If you would like a copy for your club F3K contests just pm me.

Jul 09, 2007, 10:29 AM	#6
Richard S Registered User Join Date: Oct 2005 Location: Milton Keynes, UK Posts: 840	Hi Walt, It is not just individual pairings that matter, obviously you want the top pilots flying against each other an equal number of times. However you also need the "novice" pilots to fly against the top pilots equally, otherwise you could end up with a novice pilot beating an experience pilot.... all because the novice has not had to fly in as many challenging rounds. (in the uk there are no separate classes for "novice", "sportsman" and "advanced") There have been one or two occations in the UK competitions where it has been possible to plot peoples placings in a series of competitions, directly to where there have been difficulties with the matrixing. Luckily using the tools that Tony has produced, this kind of error can be reduced making for a fair competition. With Tony's scoring application it actually displays a view of the matrix validity, allowing you to make manual changes to the calculated matrix and viewing how this effects the number of times people meet each other in a slot... it is virtually impossible to get a valid matrix showing up by using either random or manual methods.

Jul 09, 2007, 11:09 AM	#7
IBWALT W0X0F Join Date: Nov 2005 Location: Kingwood, TX Posts: 794	Richard, I see your point or points and I can remember being at contests when I looked at the other competitors and said what am I doing in this round. But like you said in the States we have three different classes of flyers and they compete with other flyers in their class on the score sheet at least. While flying in the same rounds as pilots from the other two classes. At the end of the contest you can compare your score against the better flyers and see how you did in comparison to them. Because you flew in the same rounds as them and your score was normalized right along with theirs. This gives you a overall understanding of how well you did and you can tell if it is time for you to move up in class or think about selling your HLG and buying a slope ship. The big difference and what levels the playing field is the different classes of flyers and the random nature of the sort prevents any competitor from getting beat up by or beating up on the same persons all of the time. Also the beauty of this program is that if you see after the sorting is done that a couple of the "Big Boys" are not flying against each other you only need to re-sort a round or two to solve the problem. Now whether random is really random or not is another question. Seems every time I go to Vegas (Las Vegas) I end up on the short end of the random stick.