I was asked on Wednesday to compose 1 of 3 prize lists for a 22-team mixed league.  I thought it would be a cinch since I had this site bookmarked here at work.

http://home.earthlink.net/~litefrozen/index.htm

And there is an awesome prizelist calculator in there to be sure.  However, there are 20-team and 24-team tabs.

Any ideas how I could tweak them to get a 22-team format?  It's probably easier than I'm making it out to be, but I just can't see it.

Any help would be greatly appreciated guys.  Thanks and have a great day.
--------------------
If I ever saw an amputee being hanged, I''d just yell out letters.  --DM

Edited on 9/11/2009 7:16 AM

I updated the sheet for 22 teams and updated my site, be sure to double check the figures the first time you try it. Just to make sure its running ok.

http://home.earthlink.net/~litefrozen/downloads/prizelist_calculator_2.1.zip

Shelly you helped with a formula(suggesting using the POWER function).
also others like promptjack and those in the openoffice spreadsheet(calc) forums helped too.


--------------------
Aloarjr810
----------
Click For My Grip


Edited on 9/12/2009 2:15 PM