I've done the hard work..... - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

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

Moderator: Baseball Moderators

J35J is the man!!!

Postby elltrain22 » Mon Oct 09, 2006 8:09 pm

What a spreadsheet dogg!! Love it!! Thanks so much cuzz!! I owe ya one.
Image
elltrain22
Major League Manager
Major League Manager

User avatar

Posts: 1200
Joined: 21 Apr 2006
Home Cafe: Baseball
Location: 1st place beyatch!!!!

Re: J35J is the man!!!

Postby 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
J35J
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterPick 3 Weekly Winner
Posts: 10467
(Past Year: 421)
Joined: 26 Jan 2004
Home Cafe: Baseball

Postby Morrison8312 » Tue Oct 10, 2006 2:11 am

PM sent! You're the man ;-D
Morrison8312
Major League Manager
Major League Manager

User avatar
Mock(ing) Drafter
Posts: 1132
Joined: 5 Aug 2004
Home Cafe: Baseball
Location: In the Heart of Red Sox Nation

Postby jondunc » Tue Oct 10, 2006 9:07 am

Fantastic spreadsheet! Posters and content like this is what makes this site so great. ;-D
2008: 37th ranked Yahoo PLUS Rotisserie Public team (24 weeks in top 45, 9 weeks as #1)
2006: 18th ranked Yahoo PLUS Rotisserie Public team (17 weeks in top 35)
jondunc
College Coach
College Coach


Posts: 178
Joined: 25 Feb 2004
Home Cafe: Baseball

Postby J35J » Tue Oct 10, 2006 9:13 am

Morrison8312 wrote:PM sent! You're the man ;-D


Email sent.

....and thanks, jondunc!


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


Jason
J35J
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterPick 3 Weekly Winner
Posts: 10467
(Past Year: 421)
Joined: 26 Jan 2004
Home Cafe: Baseball

Postby 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
"I don't buy everything I read,
I havn't even read everything I've bought"

"I find it more comforting to believe that this [life] isn't simply a test."
George_Foreman
General Manager
General Manager

User avatar

Posts: 4351
Joined: 16 Apr 2004
Home Cafe: Baseball
Location: at Morimoto's, eating $50 worth of sushi

Postby 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.
The Loveable Losers
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterWeb Supporter
Posts: 7290
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: Cubs Win!!! Cubs Win!!!

Postby markj11 » Mon Oct 16, 2006 5:05 pm

How come you do not consider W for RP?
Thanks for the spread sheet.
I ain't askin' nobody for nothin, If I can't get it on my own. - Charlie Daniels
markj11
Major League Manager
Major League Manager

User avatar

Posts: 2112
Joined: 3 Apr 2006
Home Cafe: Baseball
Location: Wright here

Postby 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
J35J
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterPick 3 Weekly Winner
Posts: 10467
(Past Year: 421)
Joined: 26 Jan 2004
Home Cafe: Baseball

Postby 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.
The Loveable Losers
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterWeb Supporter
Posts: 7290
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: Cubs Win!!! Cubs Win!!!

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: buiviopaufamp, ensanimal, joiingds and 8 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Thursday, Jul. 31
(All times are EST, weather icons show forecast for game time)

Chi White Sox at Detroit
(1:08 pm)
Colorado at Chi Cubs
(2:20 pm)
St. Louis at San Diego
(3:40 pm)
Philadelphia at Washington
(7:05 pm)
Seattle at Cleveland
(7:05 pm)
LA Angels at Baltimore
(7:05 pm)
Cincinnati at Miami
(7:10 pm)
indoors
Toronto at Houston
(8:10 pm)
Minnesota at Kansas City
(8:10 pm)
Pittsburgh at Arizona
(9:40 pm)
Atlanta at LA Dodgers
(10:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact