rhino Posted August 16, 2005 Share Posted August 16, 2005 Here's the link to download the spreadsheet. Here's the link to find out what the above link is all about. This update includes some projection updates, and some changes in the conditional formatting on the One Pager tabs. Tip for the week: Once you have updated the spreadsheet with your scoring, weights, own projections, sorts, etc, and you're ready for your draft... feel free to delete the One Pager and Draft tab that doesn't apply to your league (TE-reqd vs non-TE-reqd). Do a "Save As..."; Exit; and try to reopen it. I do not have any problems with this, and it reduces the overall size of your spreadsheet. ENJOY Quote Link to comment Share on other sites More sharing options...
seminoles Posted August 16, 2005 Share Posted August 16, 2005 TY VERY MUCH! Quote Link to comment Share on other sites More sharing options...
seminoles Posted August 16, 2005 Share Posted August 16, 2005 one question. how is LT's average pick 2.23? Quote Link to comment Share on other sites More sharing options...
Gunther Posted August 16, 2005 Share Posted August 16, 2005 Awesome, thanks rhino! Quote Link to comment Share on other sites More sharing options...
Piles Posted August 16, 2005 Share Posted August 16, 2005 Thanks Rhino Quote Link to comment Share on other sites More sharing options...
rajncajn Posted August 16, 2005 Share Posted August 16, 2005 (edited) This deserves a dancing banana! Edited August 16, 2005 by rajncajn Quote Link to comment Share on other sites More sharing options...
nogohawk Posted August 16, 2005 Share Posted August 16, 2005 Thanks for the update rhino! Quote Link to comment Share on other sites More sharing options...
TitansFan Posted August 16, 2005 Share Posted August 16, 2005 This deserves a dancing banana! 930282[/snapback] I second that. Quote Link to comment Share on other sites More sharing options...
rhino Posted August 17, 2005 Author Share Posted August 17, 2005 one question. how is LT's average pick 2.23? 930161[/snapback] Interesting. I'll have to take a look at that, to determine if it's the spreadsheet formulas messing that up, or if its's the input from MFL. Good catch. Quote Link to comment Share on other sites More sharing options...
seminoles Posted August 17, 2005 Share Posted August 17, 2005 Interesting. I'll have to take a look at that, to determine if it's the spreadsheet formulas messing that up, or if its's the input from MFL. Good catch. 931728[/snapback] oh my bad. i was looking at the wrong part. i think. the white area for average pick is 2.23. the yellow area is 1.02. what is the difference between them Quote Link to comment Share on other sites More sharing options...
DexterDew Posted August 17, 2005 Share Posted August 17, 2005 Great Job on the update! I have started to customize for my draft and am very grateful that others in my league don't know about this spread sheet or the Huddle. PM Sent Thanks again! Quote Link to comment Share on other sites More sharing options...
T_bone65 Posted August 17, 2005 Share Posted August 17, 2005 Awesome as always Rhino Quote Link to comment Share on other sites More sharing options...
Grits and Shins Posted August 17, 2005 Share Posted August 17, 2005 A nit ... but when you are tracking a draft it highlights the corresponding row on the one pager for a player selected. The color used can not be overriden (easily). However, you only highlight part of the row which means, the anal guy that I am, I have to highlight the rest of the row. Not that big of a deal but bothersome, especially since I have to select the color you used from the menu drop down instead off off the tool bar. Quote Link to comment Share on other sites More sharing options...
UNVMe Posted August 18, 2005 Share Posted August 18, 2005 bump for great effort... will come in very handy... now if can just tweak this for distance scoring method -UNVMe Quote Link to comment Share on other sites More sharing options...
rhino Posted August 19, 2005 Author Share Posted August 19, 2005 bump for great effort... will come in very handy... now if can just tweak this for distance scoring method -UNVMe 935799[/snapback] There's a column in the "RANK" tabs to adjust the scoring, as you see fit. It handles these extra scoring issues (like distance, bonuses for 300 yds passing, etc), that are not really projected a great deal, but used in your league. Quote Link to comment Share on other sites More sharing options...
rhino Posted August 19, 2005 Author Share Posted August 19, 2005 A nit ... but when you are tracking a draft it highlights the corresponding row on the one pager for a player selected. The color used can not be overriden (easily). However, you only highlight part of the row which means, the anal guy that I am, I have to highlight the rest of the row. Not that big of a deal but bothersome, especially since I have to select the color you used from the menu drop down instead off off the tool bar. 932937[/snapback] Grits, this is a good point, and it wasn't recently changed. The "highlight" does NOT go all the way across the player's row. This is BECAUSE there is other conditional formatting involved on that ONE PAGER tab, which hides the "-1%", "98" and "99" values. I have not had time to see if these 2 different conditional formatting rules can coexist. Also, I haven't found a way to "customize" the highlight easily, unless going thru conditional formatting. If you find an easy way, feel free to let me know. To find the color I used, click on a cell, on the ONE PAGER tab, a cell containing a name, go to "Format > Conditional formmating...". Hope this helps. Quote Link to comment Share on other sites More sharing options...
REZ Posted August 19, 2005 Share Posted August 19, 2005 Bumping back to the top in case somebody missed this awesome tool Quote Link to comment Share on other sites More sharing options...
Grogansghost Posted August 19, 2005 Share Posted August 19, 2005 (edited) Thanks Rhino, this tool is awesome. Its powers border on witchcraft for a spreadsheet novice such as myself. Edited August 19, 2005 by Grogansghost Quote Link to comment Share on other sites More sharing options...
borge007 Posted August 19, 2005 Share Posted August 19, 2005 Thanks Rhino-Great job and excellent,usable information. 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.