Armchair QB

I am not a huge SD fan...but I like to pull for Phillip Rivers since I graduated from NC State. So I typically pull for them. But this game had much more importance since I have LT....and the guy I am playing against this week has Cutler. So I get to watch LT get me a whopping 4 points...and Cutler rang up 40+ points. Cutler should have lost 2 points for the fumble!! Instead, he got 6 points for the TD...and another 2 ponts for teh conversion. So instead of going into tomorrow nights game down 20 points....I am now down 30 points. I have TO...so I still may not have caught him....but I highly doubt TO will get me 30 points. So that whole fiasco really screwed my chances to go 2-0.

Hey Mike..thanks for the response.. I went to the TE tab and looked at each column under his name. It looks like each column is OK...and it shows his projected 2004 point total to be 98.5 points. I am not an expert with spreadsheets, but it seems like the point value for Gates is not being pulled from the proper location when the cheatsheets compile. There is no value being shown at the position rankings, and the overall rankings show the #VALUE error and have him listed at the fist slot. Wait a minute...I think I figured out the problem.... I fixed it...somehow the equation had gotten erased from the position by position rankings. I copied the equation from the line above and it fixed the problem. Thanks again and keep up the good work.

No one else having this problem?

When I compile my overall rankings with Cheatsheet 2.0, Antonio Gates (TE from SD) is listed as the #1 overall player. But there are no point values listed next to his name. The cell says #VALUE. I have not made any changes or added any additional stats to the Compiler. What do I need to do to correct this issue. Everything else appears to be correct. But I have not yet tried to run the Draft Buddy.

I guess this question has stumped everyone? It seems like a straightforward question...can the master Cheat Sheet show more TE's or not. Since there has been no response, I guess I will assume that it cant.

I have a question regarding the number of players shown on the Master Cheatsheet that shows all positions. The master list only includes the top 28-TEs's. In the past, this has not been a problem. However, my league has gained alot of popularity with my fellow workers and neighbors. We might end up with 20 teams in this years league, which is more than I really want. I typically give a copy of the generated Master Cheatsheet to all of the teams in the league to use as a checklist, and to help them draft (most are not football junkies). Since we draft 2 TE's per team, 28 will not be enough. Is there anyway to expand the list to show more TE's? If not, I can create a separate spreadsheet using the info generated within the separate position tabs.

Did I stump everyone??? Is my league the only one out here that has this type of flex player that can be either a WR or RB? Anyone out there?

I just purchased and downloaded the Cheatsheet Compiler and Draft Buddy. I already see a possible problem. In my league, each team has the following roster... 2-QBs, 3-RB's, 3-WR's, 2-TE's, 2-K's, 2-DEF, and 1-WR/RB (can be either) Each week the starting lineup is.... 1-QB, 2-RB, 2-WR, 1-TE, 1-K, 1-DEF, & 1 additional WR or RB. The Cheetsheet Compiler & Draft Buddy roster options do not allow for the additional WR/RB position. Since I have no way of knowing which one each team will choose, I see this being a problem with the projections. I also see this not allowing me to have the proper categories and drop down menus when trying to use the Draft Buddy. Am I missing something, or am I just out of luck.

I would love to get a copy of that spreadsheet as well. If it is not too much trouble...could you please email it to me at mtolbert@newbanks.com