Fantasy Baseball Strategy
 Adaptive Valuation Spreadsheet Configuration Form

Thank you for your purchase of the Fantasy Baseball Strategy Adaptive Valuation Spreadsheet. Your spreadsheet can be configured to the exact specifications of your league. While it is fully self-configurable, there is a learning curve for most people who are not proficient with Excel. After reading the book, the spreadsheet should make much more sense and you should be better able to create strategic advantages from its capabilities. Some older versions of Excel may have trouble running the Macros that update the league specific settings. For these reasons, we would like to initially configure your spreadsheet to your league. You can make your own adjustments as you become more familiar with the spreadsheet and/or book.

Your Information:

Name     E-mail Address     Phone #

How did you hear about Fantasy Baseball Strategy? Please specify:

How would you like to receive the Excel spreadsheet?    for reference, free Yahoo e-mail accounts are typically 4 MB and Hotmail accounts are 2 MB.

AL only League is  3.15 MB

NL only is 3.88 MB

Both AL and NL is 5.38 MB

Your League Setup:

Does your league pick from NL only teams, AL only teams, or BOTH?

Teams in your league

Budget per team

Players drafted per team

Starting hitters

Starting pitchers (as in non-reserves)

Preferred Beginning Hitter/Pitcher Budget Allocation Ratio

Comments

Historical League Scoring:

The statistical player projections for 2004 are already loaded in the spreadsheet. Most people will not want to change those. For most, after setting up your league in the section above, the player dollar amounts will still be more relevant to your league than nearly any dollar amounts published for generic leagues.

If you want the most accurate dollar values possible, filling out the table below will adjust the projections to your actual league scoring. The Fantasy Baseball Strategy Book will give you a better understanding of the methodology and why this information is important. In short, the range will tell you how many category points a given player is likely to give your team compared to a replacement player. For instance, in a 12-team league, if your team hits five HR more, then it is worth one point in the standings in that category. Barry Bonds is projected to hit 48 HR in 2004 and the average player may hit 22 HR. Bonds is 26 HR better than the average player and would be worth about five points more in the standings in HR than a replacement player would.

To find the range, you simply need to the final standings for your league from last year. Most online administration services have that information still available. Otherwise, you league commissioner should have it. To find the range, subtract the worst team's total in a category from the top team's total.

For example, the top team hit 759 HR and the worst team hit 700 so the range is 59. The default ranges are displayed.

  Default Default Default  
   Category   NL Only AL Only

Both NL&AL

   Your League Range 

HR 87 75 94
BA 0.031 0.0185 0.022
RBI 374 254 218
SB 99 63 75
R 373 206 172
ERA 1.02 0.98 1.14
WHIP 0.198 0.218 0.226
W 26 34 29
SV 70 55 85
SO 319 313 490

For even more accuracy, you may have to do some adding.

LEAGUE HITTING

League AB   Defaults NL, AL, Both (73026 / 71086 / 70022)

League Hits  (19863 / 19230 / 19611)

LEAGUE PITCHING

League IP (16305 / 14780 / 19340)

League Hits + BB (As part of WHIP calculation H+BB/IP)  (22105 / 19933 / 26109)

League ER Allowed  (7570 / 7250 / 8774)

You may choose to skip filling out this historical information until later. You can always do it on your own. After receiving your inputs, you can usually expect to receive a configured spreadsheet via e-mail within 48 hours. We also have a download site if your e-mail box lacks enough storage capacity.