rhino

Wtd Avg 2006 Projection Spreadsheet -- Released!

Recommended Posts

Rhino - every year this simple post out-contributes what 99.5% of the readers do each YEAR here.

 

Thanks, as always.

Share this post


Link to post
Share on other sites

WOW! Well done! Another fine spreadsheet...how many years is this now...and when are you going to start asking for a kick-back? You totally deserve it....even for love of the game...

 

:D

Share this post


Link to post
Share on other sites

Fantastic job!!

 

I noticed on the one pager that the WR's avg pick column is missing and there is no 2nd page?

 

 

 

You're right. :D The "WR's Avg Pick" column is not included in the "Print Area" for the "One Pager" tabs. I'll get that fixed for the next release.

 

Tip of the Day

Feel free to "hide" columns on the "One Pager" tab before printing. The current One Pager with all the columns printed causes eyestrain and requires a very fine highlighter for the draft. Do not recommend that. So, hide the columns that you won't be using during the draft (Exp?, Age?), then print.

Share this post


Link to post
Share on other sites

Great work, once again. Thanks for your efforts.

 

As with last year, mine opens with a slight tweak to the expected procedure. I have Windows XP Pro running Office 2000 Premium. I downloaded the 97 version from the site and it opens if I actually open Excel by itself (through the start menu) and the goto File -> Open and find the .xls spreadsheet. It fails if I merely double click the spreadsheet icon in windows explorer. Thought it might help someone out there.

 

 

Thanks for the reminder Gonkis. Very much appreciated.

Share this post


Link to post
Share on other sites

Great work again rhino.

 

One note, on the 2002 version the depth chart does not appear to be updated. Arrington, J.J. is the #1 RB for Arizona, Vanderjagt is #PK for Indy.

 

I see that you discovered why this is. Thanks for the heads up, nonetheless.

 

The next release will have the huddle's version of the depth charts included.

 

Feel free to point out any other omissions, suggestions, etc.

Edited by rhino

Share this post


Link to post
Share on other sites

Great job as usual Rhino.

 

The only issue I have using the 2002 version is after changing for my leagues scoring, I cannot get the WR/TE one pager to order properly. It does not sort in decending order like it should. I'm going to download again and try it on my work machine.

 

Bummer! Can you tell me what your scoring is, and I'll see if I can re-create the problem here. Sorry for the issue.

Share this post


Link to post
Share on other sites

Tremendous work. Excellent!!

 

I sent DMD a PM a while back to inquire about doing some different work on consistency rankings. Your sheet seems like it would be a perfect venue for this as well.

 

Counting 100 yd efforts and games with a TD is a good measure of consistency. I have been looking at players points per week scored and been calculating a std dev for them based on last season, or in some cases the last couple of seasons.

 

What this tells me is that when I am looking to draft someone because they might have so many yards or so many TDs, do they score close to the same number of points every week or are they high some weeks and low others.

 

It changes the measuring stick from 'how many 100 yard games might I see from this guy' to 'will this guy get me 11ish points every week, or will it be 18 this week and 4 next week'.

 

I like this idea. But, I don't know if I can get it in this year. I'll see what I can do.

Share this post


Link to post
Share on other sites

Made the changes to the scoring and I'm getting Value for my projected points. using decimals in the scoring system. what am I doing wrong besidestryingtooperateacomputer.

 

Ok figured that out now how do I get the players to re rank themselves after all new values have been entered.

 

I apologize it wasn't straightforward. But, I'm glad you're up and running now.

Share this post


Link to post
Share on other sites

Thanks for the kind words all. Glad it's working for ya'.

Share this post


Link to post
Share on other sites

Thank you rhino. This is always a nice little Christmas-in-summer toy to tinker with! :D

Share this post


Link to post
Share on other sites

Great work as always Rhino!!!

 

Thanks for sharing!

Share this post


Link to post
Share on other sites

Thank You Rhino!

 

Your hard work putting this together is appreciated!

 

If someone has already mentioned it, I apologize for the repeat but have you ever thought of adding auction values to the sheet?

 

 

Thanks Again!

 

Busby

Share this post


Link to post
Share on other sites

Nice, Thanks Rhino!

 

1st time using it.....in the one pager it just lists the top players (ie, Manning, Johnson, Smith) with #NAME? in all the rest of the cells. Is this correct?

 

Also in the draft page I entered in Larry Johnson and it didn't add in in his info....what did I do wrong?

 

Also my interpretation is that it gives us rankings based on other numbers and our scoring system, correct?

 

Is there a way to see who your next logical pick should be? Sorry for all the (stupid) questions, I'm not really that excel savy.

 

Again thanks for all your hard work, this is cool!!!!

 

Sorry if some of these questions were answered already.

Edited by nhoops

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.