Turn Off Ads?
Results 1 to 15 of 15

Thread: PROject proJECT 2010 Discussion thread

  1. #1
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    PROject proJECT 2010 Discussion thread

    I thought it might be useful to have a thread for general PROject proJECT discussion. If you have an idea of something you'd like to see in the spreadsheet, let me know here. I'll also use it to talk about what I'm doing in the record keeping and calculations.


  2. Turn Off Ads?
  3. #2
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    One thing that's wonky about Google docs is you can't define your own numbering formats unless you enter it as a formula. This is most noticeable in stats like BA, OBP, SLG and OPS because there is no numbering format with 3 decimal places. I'm able to make it display OK in the top summary section by using the "=TEXT(value, "0.000") function but not when I enter the data from the projections. I mean, I could, but it's a PITA/I'm lazy.

  4. #3
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    OK, here's a question: should we do a projection on Aroldis Chapman?

  5. #4
    Registered User
    Join Date
    Jun 2004
    Location
    West Virginia
    Posts
    38,000

    Re: PROject proJECT 2010 Discussion thread

    Quote Originally Posted by nate View Post
    OK, here's a question: should we do a projection on Aroldis Chapman?
    YES!

  6. #5
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    Quote Originally Posted by OnBaseMachine View Post
    YES!
    Heh, OBM!

    Here's what I'm thinking. We'll do the 25-man then we'll round out the 40-man.

    How's that?

  7. #6
    Registered User
    Join Date
    Jun 2004
    Location
    West Virginia
    Posts
    38,000

    Re: PROject proJECT 2010 Discussion thread

    Sounds good.

  8. #7
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    I wonder if anyone has any suggestions on how I might "marry" projections that consist only of rate stats with those that have counting stats and / or both.

    Also, what about weighting projections based on playing time? Is it a good idea? Aroldis Chapman, for example, has quite a wide range of projections for IP. It would seem odd to give a 1.5 ERA in 19 IP the same weight as a 5.4 ERA in 100 IP.

  9. #8
    Sprinkles are for winners dougdirt's Avatar
    Join Date
    Jan 2006
    Posts
    49,393

    Re: PROject proJECT 2010 Discussion thread

    Quote Originally Posted by nate View Post
    I wonder if anyone has any suggestions on how I might "marry" projections that consist only of rate stats with those that have counting stats and / or both.

    Also, what about weighting projections based on playing time? Is it a good idea? Aroldis Chapman, for example, has quite a wide range of projections for IP. It would seem odd to give a 1.5 ERA in 19 IP the same weight as a 5.4 ERA in 100 IP.
    Figure out the actual earned runs for each projection. Add them all up and then calculate ERA based on that.

  10. #9
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    Quote Originally Posted by dougdirt View Post
    Figure out the actual earned runs for each projection. Add them all up and then calculate ERA based on that.
    Right. I'm thinking of generating all rate stats from counting stats. The problem comes when someone hasn't projected any counting stats or playing time. However, I'm thinking of just doing the best I can to "reverse engineer" their projection using, perhaps, the average of everyone else's playing time projection along with the average of anything else needed to generate the desired stat.

    If that makes sense.

  11. #10
    Member Spring~Fields's Avatar
    Join Date
    Sep 2001
    Posts
    8,630

    Re: PROject proJECT 2010 Discussion thread

    Quote Originally Posted by nate View Post
    I thought it might be useful to have a thread for general PROject proJECT discussion. If you have an idea of something you'd like to see in the spreadsheet, let me know here. I'll also use it to talk about what I'm doing in the record keeping and calculations.
    Yeah,
    yes sir MR. Nate.

    I have a question or suggestion. An ornery one.

    So when are we going to project the Cubs, Cardinals and Brewers to see how all this projecting of the Reds stacks up to the comparison of the competition?

    Before you say it. No, oh no, I am not volunteering to do that.

    I did get as far as looking at some of the OPS and OBP for the Cards and Cubs players, then said forget that, maybe Nate will do it.

    Last edited by Spring~Fields; 01-17-2010 at 07:31 PM.

  12. #11
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    Quote Originally Posted by Spring~Fields View Post
    Yeah,
    yes sir MR. Nate.

    I have a question or suggestion. An ornery one.

    So when are we going to project the Cubs, Cardinals and Brewers to see how all this projecting of the Reds stacks up to the comparison of the competition?

    Before you say it. No, oh no, I am not volunteering to do that.

    I did get as far as looking at some of the OPS and OBP for the Cards and Cubs players, then said forget that, maybe Nate will do it.

    Heh.

    I'm pretty sure I won't get to the Cubs or Cards. But maybe it would be interesting to take a look at their projections from Fangraphs and see what others think their players can do.

  13. #12
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    Let me know if this seems correct. If you go to the hitters page and to Ramon Hernandez' tab, check out (just as an example) the line pahster projected:

    350 PA, .260/.320/.380

    So, it would seem to me that I could derive from that:

    *walk rate (OBP-BA)
    *a fair approximation of AB (PA * Walk Rate)
    *a fair approximation of the number of hits (AB * BA)

    Does that seem correct or is my baseball math off somewhat?

  14. #13
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    It's a shame I don't know this but perhaps some of those more knowledgeable about the minor leaguers can chime in. Are any of these 40-man roster guys worth projecting for the Reds in 2010?

    Logan Ondrusek
    Jordan Smith
    Philippe-Alexandre Valiquette

    Thanks!

  15. #14
    Back from my hiatus Mario-Rijo's Avatar
    Join Date
    Apr 2005
    Location
    Springfield, Ohio
    Posts
    9,070

    Re: PROject proJECT 2010 Discussion thread

    Quote Originally Posted by nate View Post
    It's a shame I don't know this but perhaps some of those more knowledgeable about the minor leaguers can chime in. Are any of these 40-man roster guys worth projecting for the Reds in 2010?

    Logan Ondrusek
    Jordan Smith
    Philippe-Alexandre Valiquette

    Thanks!
    Personally I think Ondrusek has a shot at being in the pen at some point in '10 assuming injuries and/or september call up. I don't believe Valiquette will at all and Smith I'd be on the fence leaning away from him contributing this season.
    "You can't let praise or criticism get to you. It's a weakness to get caught up in either one."

    --Woody Hayes

  16. #15
    High five!
    Join Date
    Sep 2005
    Location
    Irvine, CA
    Posts
    6,976

    Re: PROject proJECT 2010 Discussion thread

    Quote Originally Posted by Mario-Rijo View Post
    Personally I think Ondrusek has a shot at being in the pen at some point in '10 assuming injuries and/or september call up. I don't believe Valiquette will at all and Smith I'd be on the fence leaning away from him contributing this season.
    OK, maybe I'll save these cats for last.


Turn Off Ads?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Board Moderators may, at their discretion and judgment, delete and/or edit any messages that violate any of the following guidelines: 1. Explicit references to alleged illegal or unlawful acts. 2. Graphic sexual descriptions. 3. Racial or ethnic slurs. 4. Use of edgy language (including masked profanity). 5. Direct personal attacks, flames, fights, trolling, baiting, name-calling, general nuisance, excessive player criticism or anything along those lines. 6. Posting spam. 7. Each person may have only one user account. It is fine to be critical here - that's what this board is for. But let's not beat a subject or a player to death, please.

Thank you, and most importantly, enjoy yourselves!


RedsZone.com is a privately owned website and is not affiliated with the Cincinnati Reds or Major League Baseball


Contact us: Boss | Gallen5862 | Plus Plus | Powel Crosley | RedlegJake | The Operator