Announcement

Collapse
No announcement yet.

In-Season Spreadsheet

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • In-Season Spreadsheet

    Sorry if this is the wrong place to post this. I'm looking for a spreadsheet that someone posted in an article awhile ago. This spreadsheet helped you keep track of your league's current stats and projections and I'm having a very difficult time finding it.

    Might I suggest a place to put all "downloads" like this?
    13-Team, Mixed, Salary Capped ($15,500 on SLU) 5x5 Roto League
    AVG, SB, HR, R, RBI / QS, ERA, WHIP, SV, K
    15 Starters: C, 1B, 2B, 3B, SS, 3xOF, UT, 3xSP, 2xRP, P, 11xBench (max 4 pitchers), 2xDL

    SLU
    C: Lucroy $940
    1B: LaRoche $1040
    2B: Gordon $1070
    3B: Prado $980
    SS: Lowrie $860
    OF: Bruce $1040
    OF: CarGo $1260
    OF: Soler $720
    UT: Ortiz $1180
    SP: Paxton $650
    SP: Sale $1200
    SP: Shields $1110
    RP: Papelbon $1180
    RP: Reed $1140
    P: Colon $890

    RESERVE:
    1B: Carter $870
    2B: Travis $400
    3B: Lamb $480
    3B: Rendon $1200
    SS: Aybar $990
    OF: Jennings $960
    OF: Souza $400
    C: Jaso $620
    OF: Span $1050
    P: Quintana $850
    P: Hammel $780
    P: McCarthy $720
    P: Ottavino $630

  • #2
    Sorry, I don't know the piece you're referring to. If someone else does I'll be happy to dig up a link to it.

    Comment


    • #3
      I'll try to describe it. There are several tabs. A "Projected Standings" tab that has "Projected Final Standings - Ordered", "Projected Final Standings - Raw", "Current Standings - Ordered", etc. A "Rosters" tab where you input every team's roster, projected playing time, position. Then you have your projections tabs. There's also a "Formula Primer" tab that explains all of the EXCEL functions that are used in the spreadsheet. IE: it explains what "OFFEST" is used for or "RANK", or "COUNTIF", etc.

      I can email you the one I dowloaded last year if you'd like (I need the original one because I screwed mine all up).
      13-Team, Mixed, Salary Capped ($15,500 on SLU) 5x5 Roto League
      AVG, SB, HR, R, RBI / QS, ERA, WHIP, SV, K
      15 Starters: C, 1B, 2B, 3B, SS, 3xOF, UT, 3xSP, 2xRP, P, 11xBench (max 4 pitchers), 2xDL

      SLU
      C: Lucroy $940
      1B: LaRoche $1040
      2B: Gordon $1070
      3B: Prado $980
      SS: Lowrie $860
      OF: Bruce $1040
      OF: CarGo $1260
      OF: Soler $720
      UT: Ortiz $1180
      SP: Paxton $650
      SP: Sale $1200
      SP: Shields $1110
      RP: Papelbon $1180
      RP: Reed $1140
      P: Colon $890

      RESERVE:
      1B: Carter $870
      2B: Travis $400
      3B: Lamb $480
      3B: Rendon $1200
      SS: Aybar $990
      OF: Jennings $960
      OF: Souza $400
      C: Jaso $620
      OF: Span $1050
      P: Quintana $850
      P: Hammel $780
      P: McCarthy $720
      P: Ottavino $630

      Comment


      • #4
        Yeah, definitely email me an older version if you have one. rmurph3@comcast.net

        Honestly, based on what you describe, I'm wondering if you got it from a different site. This isn't jogging any memories for me. Maybe I just need some coffee, though. Send it over and I'll take a look.

        Comment


        • #5
          Ha! Yeah, I definitely got it from here. I don't subscribe to any other sites.
          13-Team, Mixed, Salary Capped ($15,500 on SLU) 5x5 Roto League
          AVG, SB, HR, R, RBI / QS, ERA, WHIP, SV, K
          15 Starters: C, 1B, 2B, 3B, SS, 3xOF, UT, 3xSP, 2xRP, P, 11xBench (max 4 pitchers), 2xDL

          SLU
          C: Lucroy $940
          1B: LaRoche $1040
          2B: Gordon $1070
          3B: Prado $980
          SS: Lowrie $860
          OF: Bruce $1040
          OF: CarGo $1260
          OF: Soler $720
          UT: Ortiz $1180
          SP: Paxton $650
          SP: Sale $1200
          SP: Shields $1110
          RP: Papelbon $1180
          RP: Reed $1140
          P: Colon $890

          RESERVE:
          1B: Carter $870
          2B: Travis $400
          3B: Lamb $480
          3B: Rendon $1200
          SS: Aybar $990
          OF: Jennings $960
          OF: Souza $400
          C: Jaso $620
          OF: Span $1050
          P: Quintana $850
          P: Hammel $780
          P: McCarthy $720
          P: Ottavino $630

          Comment


          • #6
            You ever find this spreadsheet?

            Comment

            Working...
            X