I'm looking for a bowling program that generates a prize list.
I had 2 that some guys had made, that I had learned about here.
I cant find one now and the other don't work (its called "prizelist")
And now I cant find where I got them from.
Both let you put in number of teams, prize fund amount and how to weight
the list(you know more for the top teams less for lower or other way around)
Does anyone know of any programs
---------------------------------------
this was a idea of some requirements for a prog. or S.Sheet . I know theres more options that could be done this was just a starting point.
---------------------------------------
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).
----------------------------
Ill add this on here in case somebody doesnt read all the thread
Well heres the spreadsheet I have been working on. its only for a 32 team league at the moment. I'll be adding more league sizes as it goes along.
Just click the link here to get it and try it out. Its a 16k zip file, excel spreadsheet.
Click here.
prizelist_calculator_v1.6
This is a spreadsheet for making a bowling league prize list.
Team payouts are based on position (1st place, 2nd place etc..).
With payouts for individual mens and womens awards and Team awards.
Edited on 10/5/2006 6:40 PM
Edited on 10/18/2006 12:51 PM
Edited on 10/23/2006 10:29 PM