What's new
Fantasy Football - Footballguys Forums

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Team Projections? (1 Viewer)

PR Sparty

Footballguy
I'm trying to make my own "by committee" cheat sheets and I'm looking for offensive and defensive team projections. IE...least amount of points scored, least amount of rush yards, etc.

I'm sure it's somewhere on FBG's but i'm striking out via the search engine.

TIA

 
Hey PR Sparty - Here's the 2010 Projections on the site here. Hope that helps. It's under the Forecast tab. Wait, you're looking for sortable stats, right?

 
Last edited by a moderator:
Hey PR Sparty - Here's the 2010 Projections on the site here. Hope that helps. It's under the Forecast tab. Wait, you're looking for sortable stats, right?
Thanks Jeff. What i'm looking for is something that might rank total offense. Like total projected passing yards, total rushing yards, ect. Mostly NFL rank. Like STL is projected to be the 32 worst passing team, CLE is projected to be the 30th worst rushing team, etc.I suppose I could do this with individual ranks and simple addition, but I assumed something was already put together.

Thanks

 
Hey PR Sparty - Here's the 2010 Projections on the site here. Hope that helps. It's under the Forecast tab. Wait, you're looking for sortable stats, right?
Thanks Jeff. What i'm looking for is something that might rank total offense. Like total projected passing yards, total rushing yards, ect. Mostly NFL rank. Like STL is projected to be the 32 worst passing team, CLE is projected to be the 30th worst rushing team, etc.I suppose I could do this with individual ranks and simple addition, but I assumed something was already put together.

Thanks
If you dump the player projections to Excel it will sum up everything for you easily. Just get the data in there so it has the stats you want with the team in a column of it's own, and a header row on top. Then make a Pivot table (Data -> Pivot Tables and Charts), selecting the entire data area for the data to be used. Drop the Team name into the Row Fields Here area, and the stat you want to see into the Data Items Here area. It will probably default to summing up the stat by team. If not, right click on the stat and choose Field Settings and chose Sum.
 

Users who are viewing this thread

Back
Top