Fantasy Baseball Cafe Forums

by **elltrain22** » Mon Oct 09, 2006 8:09 pm

What a spreadsheet dogg!! Love it!! Thanks so much cuzz!! I owe ya one.

by **J35J** » Mon Oct 09, 2006 9:13 pm

elltrain22 wrote:What a spreadsheet dogg!! Love it!! Thanks so much cuzz!! I owe ya one.

No problem, dogg??!! ;-)

Jason

by **Morrison8312** » Tue Oct 10, 2006 2:11 am

PM sent! You're the man ;-D

by **jondunc** » Tue Oct 10, 2006 9:07 am

Fantastic spreadsheet! Posters and content like this is what makes this site so great. ;-D

by **J35J** » Tue Oct 10, 2006 9:13 am

Morrison8312 wrote:PM sent! You're the man

Email sent.

....and thanks, jondunc!

Hope everyone else I sent it to can find it a little useful for next year.

Jason

by **George_Foreman** » Tue Oct 10, 2006 12:04 pm

RugbyD wrote:
J35J wrote:Rugby, WOW........the only thing I can think of to say in response is that you are trying to hard!! Its really quite a simple process and its only there to "PRE RANK" players. I use it to just get guys in a quick order, though a pretty good order, then I will go in and tweak things as necessary. If you try to rank your players purely based on a formula, well, good luck.

IMO, I think your trying to have your formula do too much, but thats just me. Nice work though!

Jason

not really that much extra effort. if you look through the many other threads discussing ranking systems, it is par for the course that ratio-based stats have to be weighted to achieve their true meaning.

I like using standard deviation from the mean. :-D

by **The Loveable Losers** » Tue Oct 10, 2006 1:31 pm

If you get a chance, PM me the spreadsheet as well.

I've been toying with rankings for awhile now but I've yet to find one that I really like. I've never been happy with the ways I've found to handle scarcity in the counting statistics and ratio categories as well. I'd go into more detail on my experience with this but I think I'll wait to look at your formulas first and then make my commentary.

by **markj11** » Mon Oct 16, 2006 5:05 pm

How come you do not consider W for RP?
Thanks for the spread sheet.

by **J35J** » Mon Oct 16, 2006 5:52 pm

markj11 wrote:How come you do not consider W for RP?
Thanks for the spread sheet.

I did in my last years spreadsheet but figured that was probably the biggest crap shoot to try to predict so I figured I would move guys up or down manually if a player normally gets alot of wins or if they normally don't. By all means add that into the formula if you want but I figured I would go without this year.

Jason

by **The Loveable Losers** » Mon Oct 16, 2006 6:05 pm

J35J wrote:
markj11 wrote:How come you do not consider W for RP?
Thanks for the spread sheet.

I did in my last years spreadsheet but figured that was probably the biggest crap shoot to try to predict so I figured I would move guys up or down manually if a player normally gets alot of wins or if they normally don't. By all means add that into the formula if you want but I figured I would go without this year.

Jason

Here's my article on projecting wins. The methodology used in there is by no means professional but I gave it as thorough a handling as my non-professional stats background (read: I don't have the first clue how to do a regression analysis) allowed. It seems fairly accurate over a large data set (say all of the closers in a given season) but there's such a chance for wild fluctuations in the small data sets of closers that it can seem that there's no rhyme or reason. Wins do seem to follow predictable patterns when you look at closers as a group though...it's just that an individual closer may or may not end up anywhere near his projected wins.

Fantasy Baseball Cafe Forums

I've done the hard work.....

J35J is the man!!!

Re: J35J is the man!!!

Who is online