Cheatsheet Compiler
Introduction
This section of the help guide describes what each tab in the Compiler is for.
Cheatsheet Compiler
Update
The Update tab allows you to perform 2 different functions. The first is to update
projections from FF Today.com. Make sure you are connected to the Internet and click the
Update Projections button. This will take a minute or two to finish. The Compiler will
inform you of the update status as it works.
The second function allows you to copy saved league profiles from an older version
of the Compiler to your current version. Make sure the old Compiler filename is correctly
stated in the yellow box, use the drop-down to identify the old Compiler file as a 2005 or
a 2006 file, and click Copy League Profiles. All league settings and scoring should copy
from the old file to your current file.
Setup
The Setup tab is used to enter all league and other variables specific to the user,
except for scoring, that the Compiler uses to create the cheatsheets. Cells that
the user can change the values for are highlighted in yellow. The setup tab also includes
the action buttons for the user to click to perform different functions. Most notably,
the Compile Cheatsheets button should be pressed each time the user changes any
input variables, scoring, player projections, etc. in the Compiler, to ensure these
changes are reflected in the Compiler created cheatsheets.
Scoring
The Scoring tab is where to enter scoring options for the league. Cells that
the user can change the values for are highlighted in yellow. Scoring is
sorted by position, QB, RB, WR, TE, K, Team Defense (DEF), DL, LB and DB. Most of
the main scoring categories are entered as X FF points per Y units of the statistic.
For example, 6 FF points per 1 rushing TD (RuTD) or 1 FF point per 20 passing yards (PaYd).
The distance ranges shown for TDs and FGs cannot be changed. If your league scores
extra points or bonuses for long TDs and FGs, then you can enter the scoring one of
two ways. You can set the standard scoring option for TDs/FGs at the base (minimum) scoring
amount for the stat, and the distance scoring tables just to record the extra points or
bonuses. Or you can set the standard scoring to 0 (nil) and the use the
distance scoring tables to score the whole amount (base + distance bonus). Do not
use both the standard scoring at the base amount and distance scoring tables for the
whole amount, or scoring for TDs/FGs will be overstated.
Here is an example
The points and yards against
ranges for Team Defense scoring can be changed, but for the best results make sure
the ranges start at 0 for the low range in the first row and increase in
consecutive order, with no gaps between the ranges, as shown in this example:
Cheatsheets
The Cheatsheets tab is the main output tab from the Compiler. It includes 3
different cheatsheets, one for offense by position, one for defensive players (IDP) by
position, if your league uses IDP, and an overall ranking cheatsheet. Scroll to the right and left to
view each of them as they are side-by-side on the tab. The print settings are
such that they should print on 2 or 3 pages.
The cheatsheets are designed to show the top 60 QB, 100 RB, 100 WR, 38 TE, 32 K,
32 DEF, 80 DL, 80 LB, 80 DB. The overall list will show enough players to fill all
team rosters in your league based on the settings on the setup tab, to a maximum of
240 players.
One option for this tab is you can
highlight selected positions on the overall ranking cheatsheet. Select the position
using the drop-down box for each of the three colors at the top of the cheatsheet where
it says Highlight these positions.
ADP
ADP stands for Average Draft Position. This tab includes data to represent when,
on average, players are being drafted in common fantasy scoring and lineup formats
for 10, 12 and 14 team leagues. This data feeds into the offense cheatsheet to give an
idea whether you can wait longer before drafting certain players because they typically
are not drafted until the round and pick indicated by the ADP.
Depth and IDP Depth
The Depth and IDP Depth tabs are additional informational cheatsheets showing
the current fantasy value depth chart by team for all offensive and defensive
positions. There is some
judgement involved in assessing the depth chart rank for some teams/players,
particularly where there are ongoing position battles. This data is based on the
depth charts available at FF Today, found
here.
QB, RB, WR, TE, K, DEF, DL, LB, DB
The QB tab, and the remaining position tabs, are all designed the same way. They
include all the data about the players that is used by the Compiler to calculate
projected fantasy points and create the cheatsheet rankings. The sections, moving right
to left on the tab are:
·Name, team, bye week, depth chart ranking, height, weight, age, experience,
link to FF Today player page
·Non-default % key, key being used, allocation % by projection/stat section*
·Calculated fantasy points by projection/stat section*
·Calculated player projections based on the projections, stats and allocation key
·FF Today (or Site A) player projections
·TD distance ability rating, if applicable (QB, RB, WR and TE only)*
·Player statistics for the final 8 games of 2005
·Player stats for 2005
·Player stats for 2004
·Player stats for 2003
·Site B player projections (section to input another set of projections)
·Site C player projections (section to input another set of projections)
* Note by default the Compiler hides some of these columns to give a cleaner
look to the tabs. You can quickly open up these sections by clicking the "+" (plus)
sign above the headings. Alternatively, you can re-hide the columns by clicking the
"-" (minus) sign.
TD Distance
The TD Distance tab is mainly historical data used to create different TD distance
ability ratings to apply to each player for those who want to adjust players better or
worse than average at scoring long TDs. This is for the purpose of helping score leagues
that give bonuses for long TDs. The sections are divided by position and type of TD, and
only players are shown who had a noteworthy number of TD scored of that type from 2001 to
2005 seasons. There are also 5 generic categories (Great, Good, Average, Below Average and
Poor). The % used in each distance range for these categories can be changed, noting if
you do change them they should add to 100%. These are highlighted in yellow.
Questions?
Check out the Compiler
Message Board or send
an email to Mike MacGregor and he will respond ASAP.
|
