Author Topic: Looking for Prize list programs (Read 1025 times)

Aloarjr810 · « **on:** October 02, 2006, 02:01:52 AM »

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

shelley · « **Reply #1 on:** October 05, 2006, 10:15:24 PM »

I have a spreadsheet that I used to create my prize fund payouts for my men's league this year. I do something like a reciprocal-distance weighting, normalize it, then use those fractions to generate the dollar figures. I round down to the nearest $10, and add those dregs to the rolloff payout. I include high individual and team game and series awards. The weight function is tweakable to give more to the higher teams or to balance the payout from top to bottom.

It'd be easy enough to add more teams, new awards which are taken out before the prize fund is divvied up, as well as tweak the roll-off base prize. It's an OpenOffice.org spreadsheet, I don't know if you can work with it or not, but I'll send it to you if you want it.

SH

shelley · « **Reply #2 on:** October 05, 2006, 10:19:06 PM »

Afterthought:

I could write a program that does exactly that. The only reason I used a spreadsheet was because it was easier to experiment with different weight functions and I could plot them easily in a chart. If I have some time tomorrow afternoon, which I should, I'll try to throw something together.

SH

Aloarjr810 · « **Reply #3 on:** October 05, 2006, 10:43:02 PM »

quote:
Afterthought:

I could write a program that does exactly that. The only reason I used a spreadsheet was because it was easier to experiment with different weight functions and I could plot them easily in a chart. If I have some time tomorrow afternoon, which I should, I'll try to throw something together.

SH

Thanks for the reply. I sent you my email address. Ill give them a try.

shelley · « **Reply #4 on:** October 16, 2006, 10:46:00 AM »

I have put together a short program that I believe does most of what was asked. It's not very glamourous or extraordinarily flexible, but does everything that the spreadsheet does plus a little. Number of teams is more easily changed, as is the list of special awards (high team game, individual average,...).

It's in C++ and the only compilers I have are for Linux and MacOS X. If someone out there has a copy of Visual C++ for Windows and would like to compile it for me, I'd be most appreciative. Otherwise I'd be happy to send the source code or Mac/Linux versions to whoever wants it.

It will also do HTML output for the prize distribution, though it's not very fancy.

SH

Edited on 10/16/2006 10:39 AM

Aloarjr810 · « **Reply #5 on:** October 17, 2006, 01:19:02 PM »

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/23/2006 10:30 PM

Author Topic: Looking for Prize list programs (Read 1025 times)

Aloarjr810

Looking for Prize list programs

shelley

Re: Looking for Prize list programs

shelley

Re: Looking for Prize list programs

Aloarjr810

Re: Looking for Prize list programs

shelley

Re: Looking for Prize list programs

Aloarjr810

Re: Looking for Prize list programs