Robash Posted August 5, 2007 Share Posted August 5, 2007 thanks , awesome job as always...and no issues so far with Office 07, not sure if there even would be though Quote Link to comment Share on other sites More sharing options...
JoJoTheWebToedBoy Posted August 5, 2007 Share Posted August 5, 2007 It's like Christmas in Aug...... Excellent Job, thanks Quote Link to comment Share on other sites More sharing options...
J.J. Posted August 6, 2007 Share Posted August 6, 2007 Thanks a bunch Rhino Quote Link to comment Share on other sites More sharing options...
rhino Posted August 6, 2007 Author Share Posted August 6, 2007 Rhino, you are the man!!! These instructions worked for me too. Thanks again. Glad to hear it! You can thank "ts" for these instructions, I believe. He found them a couple years ago. How he every came across this "recipe", I'll never figure it out. Â Well, I figured out my deal with Excel. It just took a little visit to the update office website and now everything works great. Rhino, I really appreciate this. Glad to hear it! Yes! Quote Link to comment Share on other sites More sharing options...
BetterOff Posted August 6, 2007 Share Posted August 6, 2007 Rhino  Do you still have the spreadsheet for WDIS? I am a huge fan of the draft spreadsheet and wanted all the cool tools. Quote Link to comment Share on other sites More sharing options...
sunysteelfly76 Posted August 6, 2007 Share Posted August 6, 2007 Â As always. Quote Link to comment Share on other sites More sharing options...
Pope Flick Posted August 6, 2007 Share Posted August 6, 2007 Just so the newbies understand: some people, with the breadth of their knowledge make this THE place to be through the year with their multiple posts. Â Rhino does it once a year, every year, in this single post. Quote Link to comment Share on other sites More sharing options...
rhino Posted August 6, 2007 Author Share Posted August 6, 2007 Rhino Do you still have the spreadsheet for WDIS? I am a huge fan of the draft spreadsheet and wanted all the cool tools. I'll get that up and started when the season gets closer. I'm working on keeping the Wtd Avg Draft sp-sheet updated for now. Quote Link to comment Share on other sites More sharing options...
mbarton11 Posted August 8, 2007 Share Posted August 8, 2007 can someone email me a version of this spreadsheat, i can not get it open, email it in works if you could. thanks mbarton11@yahoo.com Quote Link to comment Share on other sites More sharing options...
keggerz Posted August 8, 2007 Share Posted August 8, 2007 does it include IDPs Quote Link to comment Share on other sites More sharing options...
Turf Smurf Posted August 11, 2007 Share Posted August 11, 2007 Just back from a long vacation. Man, you rock. Thought it needed another bump for the new folks. Quote Link to comment Share on other sites More sharing options...
spot7 Posted August 11, 2007 Share Posted August 11, 2007 Thanks again Rhino I look forward to it every year. Quote Link to comment Share on other sites More sharing options...
mrmookie123 Posted August 11, 2007 Share Posted August 11, 2007 Rhino, Excellent Information. Thanks.. Quote Link to comment Share on other sites More sharing options...
canman1104 Posted August 11, 2007 Share Posted August 11, 2007 Everyone has already said it but thanks AWESOME work.. Quote Link to comment Share on other sites More sharing options...
LosGatosEnFuegos Posted August 11, 2007 Share Posted August 11, 2007 Hey Rhino, thanks a ton! This thing is simplifying...err, complicating my draft ten-fold. But in a good way. Â One problem though, the update player list buttons don't work for me. Is this a problem that occurred when I opened it (I'm using a mac w/office 2004 BTW) or is the script incorrect. When I press it, it makes every player the first player alphabetically. So if I update RBs, everyone becomes Joseph Addai...They should all be so lucky. Sadly I never learned Basic, so when I looked at the scripts I just got confused. Quote Link to comment Share on other sites More sharing options...
rhino Posted August 12, 2007 Author Share Posted August 12, 2007 Hey Rhino, thanks a ton! This thing is simplifying...err, complicating my draft ten-fold. But in a good way. Â One problem though, the update player list buttons don't work for me. Is this a problem that occurred when I opened it (I'm using a mac w/office 2004 BTW) or is the script incorrect. When I press it, it makes every player the first player alphabetically. So if I update RBs, everyone becomes Joseph Addai...They should all be so lucky. Sadly I never learned Basic, so when I looked at the scripts I just got confused. Â ALWAYS, after hitting the <Update Player List> button on any Rank tab, one must hit the <F9> (re-calculate button) to have the formulas update the names on the Rank tab. Â So, when doing this operation on a Rank tab, follow this order: Â a. <Update Player List> ("copies" all names from the Position tab) b. <F9> (recalculates so that the actual names are listed, just not "Addai, Joseph" on the RB Rank tab (for example)) c. <Fantasy Points> (resort the Rank tab based on projected fantasy points) d. <F9> again, to get the Rank II tab updated with the new sort order from step "c". Â Done. Â (I know thisi is a pain in the butt, but if one has "Automatic Calculation" turned off, then this is needed.) Quote Link to comment Share on other sites More sharing options...
rhino Posted August 12, 2007 Author Share Posted August 12, 2007 does it include IDPs Sorry. Quote Link to comment Share on other sites More sharing options...
rhino Posted August 12, 2007 Author Share Posted August 12, 2007 can someone email me a version of this spreadsheat, i can not get it open, email it in works if you could. thanks mbarton11@yahoo.com You'll need Excel. I know not if this works in Works. If it did, I don't think you'll like the final result, as I'm sure Works leaves A LOT out that I'm using in Excel. Just my .02. Quote Link to comment Share on other sites More sharing options...
Pitbull739 Posted August 12, 2007 Share Posted August 12, 2007 Spectacular again, Mr. Rhino. Cheers! Quote Link to comment Share on other sites More sharing options...
LosGatosEnFuegos Posted August 12, 2007 Share Posted August 12, 2007 ALWAYS, after hitting the <Update Player List> button on any Rank tab, one must hit the <F9> (re-calculate button) to have the formulas update the names on the Rank tab. So, when doing this operation on a Rank tab, follow this order:  a. <Update Player List> ("copies" all names from the Position tab) b. <F9> (recalculates so that the actual names are listed, just not "Addai, Joseph" on the RB Rank tab (for example)) c. <Fantasy Points> (resort the Rank tab based on projected fantasy points) d. <F9> again, to get the Rank II tab updated with the new sort order from step "c".  Done.  (I know thisi is a pain in the butt, but if one has "Automatic Calculation" turned off, then this is needed.)  Quote Link to comment Share on other sites More sharing options...
Grits and Shins Posted August 12, 2007 Share Posted August 12, 2007 Its a piece of crap ... really. Quote Link to comment Share on other sites More sharing options...
ts Posted August 12, 2007 Share Posted August 12, 2007 Glad to hear it! You can thank "ts" for these instructions, I believe. He found them a couple years ago. How he every came across this "recipe", I'll never figure it out. Â Â My life is nothing but a series of "workarounds" to challenges presented by every day events. Quote Link to comment Share on other sites More sharing options...
rhino Posted August 12, 2007 Author Share Posted August 12, 2007 Its a piece of crap ... really. For him who has the eyes to see, let him see. (Then there's the Cowboys fan.) Quote Link to comment Share on other sites More sharing options...
Matrix Posted August 16, 2007 Share Posted August 16, 2007 Rhino...thanks again for all of your hard work on this. Every year you offer us humble Huddlers the very best information there is. Thanks! 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.