- Thread starter
- #1
cjedmonton
Well-known member
Quite awhile ago, I was fooling around with Microsoft Excel, and wound up devising a unique fantasy baseball game. Basically, I formed a database of the top 5 career strikeout leaders and top hit leaders at each position for each of the 30 major league clubs. I also went on to include the all-time winningest managers, top single season attendence per game ballparks, and the all-time winning percentage for each club as well.
After the database was formed, a simple formula would generate a new and completely random fantasy team at the push of a button (F9). For those statheads out there, the number of unique teams works out to...wait for it...573,956,280,000,000,000,000,000! How? 15 Categories with 30 possible outcomes each, plus 1 category with 40 possible outcomes.
Ultimately, this gave me an idea to have a tournament where 3 teams would go head to head to head for each round until a winner is crowned (4 rounds in total).
To play this game, we'll need 30 folks to sign up. The remaining 6 slots will be reserved for the "house" (aka: Me).
Here's a sample of 3 teams that could face off in a round:
BASIC SCORING:
1. Each line/position on a team competes directly with the same line/position on the opposing teams
2. The raw totals are compared. The highest total earns 5 points, the 2nd highest total earns 3 points, and the 3rd highest total earns 1 point. If there is a tie, then the same number of points will be awarded to both/all teams. Example: a 2 way tie for first would each earn 5 points, while the remaining team would earn 3 points.
3. Repeat for all 16 lines and add up the total for your team
4. Refer to the bonus table for additional points, if applicable
5. Any "combos" refer to 2 or more entries from the same franchise
6. Add any bonus points to the basic points earned
7. The highest overall total from that group advances to the next round
The winner of this tournament will win the entire 192 set of Goodwin Gypsy Queen minis I had offered before in the HOF prediction contest (no winners).
Simply copy/paste the signup list in your reply.
This could be a lot of fun, folks! More details to follow tomorrow (including an overview of the tournament bracket).
Don't hesitate to ask any questions! Thanks.
Chris
After the database was formed, a simple formula would generate a new and completely random fantasy team at the push of a button (F9). For those statheads out there, the number of unique teams works out to...wait for it...573,956,280,000,000,000,000,000! How? 15 Categories with 30 possible outcomes each, plus 1 category with 40 possible outcomes.
Ultimately, this gave me an idea to have a tournament where 3 teams would go head to head to head for each round until a winner is crowned (4 rounds in total).
To play this game, we'll need 30 folks to sign up. The remaining 6 slots will be reserved for the "house" (aka: Me).
Here's a sample of 3 teams that could face off in a round:
BASIC SCORING:
1. Each line/position on a team competes directly with the same line/position on the opposing teams
2. The raw totals are compared. The highest total earns 5 points, the 2nd highest total earns 3 points, and the 3rd highest total earns 1 point. If there is a tie, then the same number of points will be awarded to both/all teams. Example: a 2 way tie for first would each earn 5 points, while the remaining team would earn 3 points.
3. Repeat for all 16 lines and add up the total for your team
4. Refer to the bonus table for additional points, if applicable
5. Any "combos" refer to 2 or more entries from the same franchise
6. Add any bonus points to the basic points earned
7. The highest overall total from that group advances to the next round
The winner of this tournament will win the entire 192 set of Goodwin Gypsy Queen minis I had offered before in the HOF prediction contest (no winners).
Simply copy/paste the signup list in your reply.
This could be a lot of fun, folks! More details to follow tomorrow (including an overview of the tournament bracket).
Don't hesitate to ask any questions! Thanks.
Chris