Giantsfan14's Projections and Rankings (updated 2/10)

[GiantsFan14]

Looks like you put a lot of work into this, but more importantly, a lot of good work. I'll have a look at it when I get home, seems like it'll be pretty useful.

And for players that don't have 3 full seasons, you could use MLEs although you will probably only have basic stats and not batted ball data for minor leaguers. To account for incline and decline in numbers depending on age, you could incorporate an aging curve, but that's a lot of work as each stat kinda has its own curve. Overall it looks really good.

I did look at MLEs a bit to project the younger players. I also toyed around with aging curves, but I couldn't figure out exactly how I wanted to do it and it seemed like it would take a lot more time than it would have been worth. I might try some more work on that next year though.

[Curtis Pride]

wow, sounds like a ton of work. Tried to get on, but my company's access to Google docs is spotty.

I know Tom Tango has a projections competition every year to see who comes closest. I believe they accept projections from regular schmoes too.

[bigh0rt]

Whenever I start to think I know a lot / put a lot of time into fantasy baseball, I read something like this and it's a great reality check.

Nice work

GF is a smart dude, just don't ask him for suggestions on your choice of cinema

[MashinSpuds]

Thanks Giantsfan, some of the rankings are interesting to see and are useful for comparisons. Given some of the projections, it makes me want to go out and pick up a few guys to take a chance on. Depending on who is a believer, Zimmerman as the 11th ranked third baseman might cause a stir.

[GiantsFan14]

Thanks Giantsfan, some of the rankings are interesting to see and are useful for comparisons. Given some of the projections, it makes me want to go out and pick up a few guys to take a chance on. Depending on who is a believer, Zimmerman as the 11th ranked third baseman might cause a stir.

My Zimmerman projection is definitely on the conservative side and mainly due to injury concerns limiting the number of plate appearances I projected. If he stays healthy he'd easily outproduce my numbers.

I updated the spreadsheet as the list version which allows easy sorting of the projections or rankings, just click on the column header to sort by that category.

[Mookie4ever]

looks excellent
Looking forward to the pitching projections

[lastingsgriller]

pretty fantastic, GF.. didn't know you had it in ya

[ML610]

Hey -

Can you clarify where to tweak the fb%, hr/f etc. if we want to adjust those numbers?

I tried clicking into the outputs (such as hr's), and the cells that seem to feed into it don't appear correct, and are the same for each player. For example, Y67,68 and 70 are used for shortstops to feed into the HR output. It doesn't look correct, but I'm not familiar with the offset function, so I may be misinterpreting the formula you've used.

Thanks,

[GiantsFan14]

Hey -

Can you clarify where to tweak the fb%, hr/f etc. if we want to adjust those numbers?

I tried clicking into the outputs (such as hr's), and the cells that seem to feed into it don't appear correct, and are the same for each player. For example, Y67,68 and 70 are used for shortstops to feed into the HR output. It doesn't look correct, but I'm not familiar with the offset function, so I may be misinterpreting the formula you've used.

Thanks,

the offset function was so i could do a fill of the projection cells, it starts with the first cell, in this case Y67, 68, 70 and then goes down 6 cells for each new player in my projection. it basically let me fill 1 space at a time in my projections will filling 6 spaces at a time with the fb%, hr/fb, etc. hopefully that makes sense.

[ML610]

Gotcha...so if i wanted to tweak fb%, hr/fb%, bb%, or k%, it should be done from the players weighted average column (y).

Thanks again. Good job on this.