Archived TCBL Player Stats & Adjusted Stats

Discussion in 'The Sandlot - The Show '15 OL' started by HAL9100, Apr 14, 2012.

  1. HAL9100

    HAL9100 TSO's Resident Antagonist

    Joined:
    Jul 15, 2011
    Messages:
    3,259
    Featured Threads:
    1
    Last edited: Apr 14, 2012
    • Like Like x 3
  2. HAL9100

    HAL9100 TSO's Resident Antagonist

    Joined:
    Jul 15, 2011
    Messages:
    3,259
    Featured Threads:
    1
    There are 2 purposes to this thread. The first is that allows us to view player's stats outside of the online league. The second is that the spreadsheets calculate where the player's stats would be on a 162 game schedule. So we can compare them to the past and present. Spreadsheets for pitching stats are on the way.

    In order to add a player's stats, there's just a few steps.

    1. Click on the link to open the spreadsheet for your league and then select the sheet for your team's stats. Make sure you are not in the sheet for the adjusted stats.

    2. The stats for Plate Appearances(PA), Batting Average(BA), On Base Percentage(OBP), Slugging Percentage(SLG), and On Base Percentage Plus Slugging Percentage(OPS) are automatically created based on the other stats you enter, so don't enter anything into those cells. When adding players, just click on them, click on the little blue square, and then drag down for how many cells you want to copy the formula into as seen here:

    1.png

    2.png

    3. Add the player's stats for all other categories.

    4. Go over to your team's adjusted stats sheet. Don't type into any cell here. Like above, just highlight everything from Player over to IBB and drag down for how many players you are adding like this:

    3.png

    And that's it.
     
    Last edited: Apr 14, 2012
  3. HAL9100

    HAL9100 TSO's Resident Antagonist

    Joined:
    Jul 15, 2011
    Messages:
    3,259
    Featured Threads:
    1
    I've updated the 1st post with the pitching stats. The steps are practically identical to updating the the hitting stats.

    1. ERA, WHIP, H/9, HR/9, BB/9, SO/9, and SO/BB are all generated based off of the stats you enter so treat them like you do PA, BA, OBP, SLG, and OPS in the hitting stats.

    2. For Innings Pitched, often times you'll see the stats represented as 7.1 or 7.2 innings, etc. You need to switch the .1 or .2 into .33 or .67 for innings pitched since were converting 1/3 and 2/3. So, 7.2 would be entered as 7.67. And in later appearances, don't add the decimal points. If it adds up to 17 1/3 innings, put 17.33. Hopefully that makes sense.

    3. Like the adjusted hitting stats, select everything from player to SO/BB and drag it down in the pitchers adjusted stats.
     

Share This Page