Tweet
Program for making a Prize list
I'm looking for a program or spreadsheet that will generate a league prize list.
I found 2 along time ago. I cant find one of them now and the other doesnt want to work right anymore (its called prizelist).
You could put in the prize fund amount+number of teams+number of players and it would make a prize list.
im trying to make a spreadsheet and these are some ideas for what I think it or a program should do. (I know there might be other options, but this is based on how our league runs.
What a prize list generating program or spreadsheet should do-
From the user inputted variables of-
1- Total amount of money in the prize fund.
2- Number of teams.
3- Number of players per team.
4- Name of the league.
5- Distribution (weighting) of the team position awards. Optional
It would make a prize list that could be saved and printed or exported or copied to be saved and printed. That showed-
A- The name of the league, number of teams and the amount of money in the prize fund.
B- Team Position Awards-
1- Amount of Each team position from 1st place to last and showing the per player share.
C- Individual Team Awards-(These can be user inputted.)
1- Team High Series Scratch showing per player share. Paying up to 3 places.
2- Team High Series Handicap showing per player share. Paying up to 3 places.
3- Team High Game Scratch showing per player share. Paying up to 3 places.
4- Team High Game Handicap showing per player share. Paying up to 3 places.
D- Individual Awards Men-(These can be user inputted.)
1- Men's High Series Scratch. Paying up to 3 places.
2- Men's High Series Handicap. Paying up to 3 places.
3- Men's High Game Scratch. Paying up to 3 places.
4- Men's High Game Handicap. Paying up to 3 places.
5- Men's High Average.
6- Men's Most Improved Average.
E- Individual Awards Women-(These can be user inputted.)
1- Women's High Series Scratch. Paying up to 3 places.
2- Women's High Series Handicap. Paying up to 3 places.
3- Women's High Game Scratch. Paying up to 3 places.
4- Women's High Game Handicap. Paying up to 3 places.
5- Women's High Average.
6- Women's Most Improved Average.
F- At least 2 user defined optional awards.
G- Totals for-
1- Team Position Awards.
2- Individual Team Awards.
3- Individual Awards Men.
4- Individual Awards Women.
5- Optional Awards
6- Grand Total of all awards.
The amount of money available for the Team position awards. Would be figured from the total amount of money in the prize fund minus(-) the total of all individual team, mens, womens and optional awards.
The per player share would be figured from the team prize divided(÷) by the number of team members.
The Distribution (weighting) would be a way of adjusting the prize list. So that you could have more money going to the top teams or the lower teams getting more or have the list be alot flatter.
The prize list should fit on one sheet of letter size paper (8.5x11).
I found 2 along time ago. I cant find one of them now and the other doesnt want to work right anymore (its called prizelist).
You could put in the prize fund amount+number of teams+number of players and it would make a prize list.
im trying to make a spreadsheet and these are some ideas for what I think it or a program should do. (I know there might be other options, but this is based on how our league runs.
What a prize list generating program or spreadsheet should do-
From the user inputted variables of-
1- Total amount of money in the prize fund.
2- Number of teams.
3- Number of players per team.
4- Name of the league.
5- Distribution (weighting) of the team position awards. Optional
It would make a prize list that could be saved and printed or exported or copied to be saved and printed. That showed-
A- The name of the league, number of teams and the amount of money in the prize fund.
B- Team Position Awards-
1- Amount of Each team position from 1st place to last and showing the per player share.
C- Individual Team Awards-(These can be user inputted.)
1- Team High Series Scratch showing per player share. Paying up to 3 places.
2- Team High Series Handicap showing per player share. Paying up to 3 places.
3- Team High Game Scratch showing per player share. Paying up to 3 places.
4- Team High Game Handicap showing per player share. Paying up to 3 places.
D- Individual Awards Men-(These can be user inputted.)
1- Men's High Series Scratch. Paying up to 3 places.
2- Men's High Series Handicap. Paying up to 3 places.
3- Men's High Game Scratch. Paying up to 3 places.
4- Men's High Game Handicap. Paying up to 3 places.
5- Men's High Average.
6- Men's Most Improved Average.
E- Individual Awards Women-(These can be user inputted.)
1- Women's High Series Scratch. Paying up to 3 places.
2- Women's High Series Handicap. Paying up to 3 places.
3- Women's High Game Scratch. Paying up to 3 places.
4- Women's High Game Handicap. Paying up to 3 places.
5- Women's High Average.
6- Women's Most Improved Average.
F- At least 2 user defined optional awards.
G- Totals for-
1- Team Position Awards.
2- Individual Team Awards.
3- Individual Awards Men.
4- Individual Awards Women.
5- Optional Awards
6- Grand Total of all awards.
The amount of money available for the Team position awards. Would be figured from the total amount of money in the prize fund minus(-) the total of all individual team, mens, womens and optional awards.
The per player share would be figured from the team prize divided(÷) by the number of team members.
The Distribution (weighting) would be a way of adjusting the prize list. So that you could have more money going to the top teams or the lower teams getting more or have the list be alot flatter.
The prize list should fit on one sheet of letter size paper (8.5x11).