rhino Posted August 12, 2011 Share Posted August 12, 2011 All, The first release of the "Wtd Avg Projections Spreadsheet" is out. LINK 1. As in years past, there is a TE-REQD version, and a NO-TE-REQD version. Select the appropriate directory at the link, based on your league. 2. As in years past, there are 2 excel saved-versions of each spreadsheet. One is saved in the 1997-2003 version, and the other is saved in 2010 version of Excel. Unlike past years, this version was created in Excel 2010 and then a "Save As" was performed to get the 1997-2003 version. Unlike past years, there is no Excel 5.0 or Excel 95 version. I had a hard time getting Excel 2010 to save it in that version and maintain the minimum set of functionality to make it worth your while. 3. Please give thanks / props / slaps on the back / slaps upside the head to ts, who is responsible for making this year's spreadsheet possible. I am swamped with other duties / responsibilities / career / hobby / picking my nose, that this spreadsheet has now become an afterthought. ts volunteered to transition this spreadsheet ownership from me to him so that it may continue to live. We are currently in that transition period, where we're both working on different pieces. But, ts has done the majority of the work this year. 4. As in years past, there is no IDP functionality. Sorry. 5. For those who have used this in the past, get after it. For those who have no idea what this is, get after it. Just download it. Put your league's scoring rules in the "Scoring" tab, hit <F9> to recalculate the projected fantasy points for each player, and look at the results on the Rank tabs. Feel free to "weight" the different websites (fftoday, kffl, etc) as you see fit on the POS tabs (QB, RB, WR, etc), hit <F9> to recalculate, and see the results on the Rank tabs. There is a resulting 1-Page cheatsheet, which is sorted in the same manner as your Rank tabs. And there is a Draft tab, in which you can keep track of your draft, team-by-team. When a player is entered on the Draft tab, that player is automatically highlighted on the 1-Page cheatsheet (and Depth Chart) tab, to mark that player "off your list". 6. There are other tips-n-tricks. I'll let ts fill in the many holes I left here. I'll try to chime in the best I can when time allows. Thanks ts! Quote Link to comment Share on other sites More sharing options...
buddahj Posted August 12, 2011 Share Posted August 12, 2011 Hell Ya!!! Thanks again!!! Quote Link to comment Share on other sites More sharing options...
Thunder Chicken Posted August 12, 2011 Share Posted August 12, 2011 Thanks a bunch! Can't wait to dig into it. Thanks again for your time. Quote Link to comment Share on other sites More sharing options...
Grits and Shins Posted August 12, 2011 Share Posted August 12, 2011 Quote Link to comment Share on other sites More sharing options...
kcmast Posted August 12, 2011 Share Posted August 12, 2011 Rhino, you're the best! Thank you! Quote Link to comment Share on other sites More sharing options...
bostonsoxandy Posted August 12, 2011 Share Posted August 12, 2011 (edited) Sick!!!! Thanks rhino, great work! EDIT: One quick question: Do you release updated versions of this awsum excel in the future? Cuz that would be xtra-awsum. Edited August 12, 2011 by bostonsoxandy Quote Link to comment Share on other sites More sharing options...
Square Posted August 12, 2011 Share Posted August 12, 2011 Wow. Wasn't expecting it this year. Thanks to ts for helping and Rhino for being teh original awesomeness. Quote Link to comment Share on other sites More sharing options...
BRUISER Posted August 12, 2011 Share Posted August 12, 2011 very nice. thanks again. Quote Link to comment Share on other sites More sharing options...
Brent Posted August 12, 2011 Share Posted August 12, 2011 nice work, DMD needs to add you to the payroll.... Quote Link to comment Share on other sites More sharing options...
ajh2 Posted August 12, 2011 Share Posted August 12, 2011 ts and rhino... Thank you very much. I am partaking of your Excel-lent work. Quote Link to comment Share on other sites More sharing options...
steveo Posted August 12, 2011 Share Posted August 12, 2011 Wow - thanks! I sure wasn't expecting this! As always, we appreciate your time and dedication to this spreadsheet. Quote Link to comment Share on other sites More sharing options...
Hat Trick Posted August 12, 2011 Share Posted August 12, 2011 Quote Link to comment Share on other sites More sharing options...
ts Posted August 12, 2011 Share Posted August 12, 2011 (edited) Just a few extra notes & comments, since rhino covered the basics: - as a reminder, you must have macros enabled in Excel, or the formulas will not work properly. - the actual data was last updated on 8/7/11, so any NFL roster moves announced after that date will not be reflected in the file; users can update their own copy as needed. - due to the short time frame this year, less unit testing than usual has been done; however, no glaring problems are expected, but there are no guarantees either ... see the link below to a thread from last season, which includes some tips/tricks and answers to a couple of FAQs. - it is possible, but unlikely, that there will be additional updates this season. If there is one, we do not have a set schedule for any update in mind, it will occur as time permits - but again, an update is unlikely. - some of the data included from various sites is now a couple of weeks old; users may want to consider 'weighting' the more recent projections more heavily. - users should review the Release Notes tab, which includes a summary of which data elements were updated when, as well as some additional general comments on this year's file. Link to last season's release announcement: http://forums.thehuddle.com/index.php?show...;hl=spreadsheet Edited August 12, 2011 by ts Quote Link to comment Share on other sites More sharing options...
rajncajn Posted August 12, 2011 Share Posted August 12, 2011 Wow. Wasn't expecting it this year. Thanks to ts for helping and Rhino for being teh original awesomeness. +1 Awesome stuff as usual rhino and thanks to ts as well. Quote Link to comment Share on other sites More sharing options...
nogohawk Posted August 12, 2011 Share Posted August 12, 2011 Awesome as always ... thanks again rhino & ts! Quote Link to comment Share on other sites More sharing options...
Chief Dick Posted August 12, 2011 Share Posted August 12, 2011 (edited) Thanks rhino and ts! Really, really appreciated. Edited August 12, 2011 by Chief Dick Quote Link to comment Share on other sites More sharing options...
GMac Posted August 12, 2011 Share Posted August 12, 2011 Quite possibly the greatest thing ever. If it was updated on or close to August 25, It would be officially the greatest thing ever. (FF draft is on the 26th, ) Thanks a lot to whoever put the time and effort into this. Quote Link to comment Share on other sites More sharing options...
rhino Posted August 12, 2011 Author Share Posted August 12, 2011 Thanks for the kind words all. I'm confident that update(s) is planned. When and how often will be the result of other priorities. Quote Link to comment Share on other sites More sharing options...
NAUgrad Posted August 12, 2011 Share Posted August 12, 2011 Holly crap this is awesome! Quote Link to comment Share on other sites More sharing options...
tazinib1 Posted August 12, 2011 Share Posted August 12, 2011 Quote Link to comment Share on other sites More sharing options...
Lost Posted August 13, 2011 Share Posted August 13, 2011 (edited) You da man TS! Thanks for picking up the slack man! Didn't know if you would make it this year. Edited August 13, 2011 by Lost Quote Link to comment Share on other sites More sharing options...
Inhiding Posted August 13, 2011 Share Posted August 13, 2011 On the draft tab, does it update automatically or do you need to keep pressing F9 for it to update? and should the player be removed from the drop down menu or will they stay there. i am checking out this nice sheet and those are two of the questions i have. Thanks in advance and thanks to Rhino and TS! Quote Link to comment Share on other sites More sharing options...
ts Posted August 13, 2011 Share Posted August 13, 2011 On the draft tab, does it update automatically or do you need to keep pressing F9 for it to update? and should the player be removed from the drop down menu or will they stay there. i am checking out this nice sheet and those are two of the questions i have. Thanks in advance and thanks to Rhino and TS! Always use F9 to recalculate any time you make any change in data, including adding a 'selected' player on the draft tab - the player will be highlited in yellow on the One Pager tab as a result. The Draft tab player dropdown is always pre-populated from the player list on the matching Position tab, so the full player list will always be presented in the Draft tab dropdown. Quote Link to comment Share on other sites More sharing options...
loaf Posted August 13, 2011 Share Posted August 13, 2011 Thanks guys! Quote Link to comment Share on other sites More sharing options...
The Holy Roller Posted August 13, 2011 Share Posted August 13, 2011 Holly crap this is awesome! We prefer the Holy version. But, yeah, this is awesome! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.