Results 1 to 2 of 2

Thread: Batting Streaks and Seasonal Highs

  1. #1
    Join Date
    Aug 2004
    Location
    FL
    Posts
    52,890

    Batting Streaks and Seasonal Highs

    I'm going to put this here, because ultimately, it is a feature request that I was able to accomplish using google sheets.

    Batting Streaks - number of games in a row that a player records > 0 of a stat
    Seasonal Highs - the most of a stat that a player gets in a season.

    https://docs.google.com/spreadsheets...it?usp=sharing

    How to use it
    You need a google account. Click the link above, go to File -> Make a Copy, name it whatever you'd like.

    In the BatStat sheet, put the teamid in B1 and the season/year in B2, then wait a bit. The BatStat sheet is the juice of the document.

    The Columns
    A through R will be the Batting Stats page.
    S through W is important, but mostly housekeeping. Getting the playerid is essential to allowing the Batting Log sheets (B1-B20) to populate.
    X through AI is the streaks information. If a player has zeroes in these fields, it is likely the player card hasn't populated yet, some patience may be required
    AK through end is the seasonal high information. For all of a player's games in the game log, the highest value for each category is displayed.

    B1-B20 Sheets
    These are the player card Batting Logs for the first 20 players on the Batting Stats page.

    Limitations
    I'm only doing this for the first 20 players on a team.
    I'm only doing this for one team and one season at a time. If you want to expand your copy, feel free, but i have had issues with google sheets and csfbl performance when asking for too much at a time.

    If you make any improvements or just want to share something that you think would improve this, please share!

    Enjoy!

  2. #2

    Re: Batting Streaks and Seasonal Highs

    Nice!


    Sent from my iPad using CSFBL
    Overall World Series Record 26-19

    Georgia Peaches (Diamond Legends, 81-current) 87, 90, 91, 93, 97,2009,10,11
    Royston Tigers (Big League 85-current) 85, 88, 89, 91, 92, 97, 02, 04, 05, 06 ,07,08,09,10,11,12
    Cobbs Scoundrels (CBF 2115-2127, 2129-current) 28, 29
    Tuktoyaktuk Wolverines (TCL, 2122-current) 2128
    Cobbs Black Sox (Dirty Dozens, 2118-current)
    Cobbs Black Sox (E P86-2013) 86, 91, 92, 04, 06, 08
    Cobbs Deadball Brawlers (MLB Blitz, 81-1998) 93
    Cobbs Terrible Beauties (Cooperstown Prospects, 2002-2016) 02, 03, 04, 05, 06, 07, 08
    Cobbs Deadball Brawlers (Blue Chip Baseball, 2003-2013) 08, 09
    Cobbs Daffiness Boys (Dodgers Baseball, 1956-65) 61, 62
    Cobbs Leatherstockings (GOAT 3, 2006-2011)
    Augusta Tigers (LEG, 2056-2067)

Tags for this Thread

Bookmarks

Posting Permissions

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