online resource request

some stat compilers online let you do certain stat sorting, even without a "column" for it -- say, AB/HR

does anyone know where I can get a list of 2014 (or any) players sorted by PA/2B? I want to know the best doubles-hitters without simply using a "counting" stat that doesn't account for players with fewer games played

some stat compilers online let you do certain stat sorting, even without a "column" for it -- say, AB/HR

does anyone know where I can get a list of 2014 (or any) players sorted by PA/2B? I want to know the best doubles-hitters without simply using a "counting" stat that doesn't account for players with fewer games played

Well if you have the ratings download and are a member of SOMworld.com, ( it's a paid subscription site) they produce an add on for the ratings spreadsheet that gives the doubles and triples counts for both sides of the cards used with a filter on PA's for excel that would get you the info.

Also have you just tried ESPN.com and MLB.com's stats pages? seems you could list highest doubles and then set a threshold by pa's. ESPN's is set up in 25pa increments, you could also do it by position on their site to narrow it down even more.

seems you could list highest doubles and then set a threshold by pa's.

Thanks for responding. That won't help, because it's still just a "counting" stat -- the issue isn't a minimum number of PAs (as in a "rate" stat), but most doubles per PA, which I could then eyeball to exclude obvious low-PA flukes

as for SOM, I want this free! hence online

seems you could list highest doubles and then set a threshold by pa's.

Thanks for responding. That won't help, because it's still just a "counting" stat -- the issue isn't a minimum number of PAs (as in a "rate" stat), but most doubles per PA, which I could then eyeball to exclude obvious low-PA flukes

as for SOM, I want this free! hence online

Do you have the ratings spreadsheet?

Are you just looking for Doubles per At-Bat (not Plate Appearance)? Using Excel with the downloadable SOM player list, I did a quick list of the top 25 or so as follows:

NAME TM AB 2B 2B/AB
Lucroy, Jonathan MIL 585 53 0.0906
Cabrera, Miguel DET 611 52 0.0851
Brantley, Michael CLE 611 45 0.0736
Altuve, Jose HOU 660 47 0.0712
Freeman, Freddie ATL 607 43 0.0708
Gonzalez, Adrian LAD 591 41 0.0694
McCutchen, Andrew PIT 548 38 0.0693
Werth, Jayson WAS 534 37 0.0693
Peralta, Jhonny STL 560 38 0.0679
Puig, Yasiel LAD 558 37 0.0663
Trout, Mike LAA 602 39 0.0648
Holliday, Matt STL 574 37 0.0645
Span, Denard WAS 610 39 0.0639
Rendon, Anthony WAS 613 39 0.0636
Abreu, Jose CHW 556 35 0.0629
Cano, Robinson SEA 595 37 0.0622
Murphy, Daniel NYM 596 37 0.0621
Cabrera, Melky TOR 568 35 0.0616
Utley, Chase PHI 589 36 0.0611
Gordon, Alex KC 563 34 0.0604
Beltre, Adrian TEX 549 33 0.0601
Upton, Justin ATL 566 34 0.0601
Cespedes, Yoenis BOS 600 36 0.0600
Pedroia, Dustin BOS 551 33 0.0599
Zobrist, Ben TB 570 34 0.0596
Gomez, Carlos MIL 574 34 0.0592
Martinez, Victor DET 561 33 0.0588

For Strat purposes, it might be better to simply use the Excel hitters' data and translate each player's stats into what they would be at 600 AB each. On that basis, the top doubles hitters are:
Kouzmanoff, Kevin - 77
Nieuwenhuis, Kirk - 75
Colon, Christian - 67
Blanco, Andres - 64
Goldschmidt, Paul - 58
Susac, Andrew - 55
Lucroy, Jonathan - 54
Soler, Jorge - 54
Clevenger, Steve - 54
Ynoa, Rafael - 54

Thanks for asking the question, by the way. I knew about most of those guys -- drafted Nieuwenhuis, Colon, Blanco, and Ynoa in various "pre-card" draft leagues -- but who on earth is Steve Clevenger?!?

For Strat purposes, it might be better to simply use the Excel hitters' data and translate each player's stats into what they would be at 600 AB each. On that basis, the top doubles hitters are:
Kouzmanoff, Kevin - 77
Nieuwenhuis, Kirk - 75
Colon, Christian - 67
Blanco, Andres - 64
Goldschmidt, Paul - 58
Susac, Andrew - 55
Lucroy, Jonathan - 54
Soler, Jorge - 54
Clevenger, Steve - 54
Ynoa, Rafael - 54

Thanks for asking the question, by the way. I knew about most of those guys -- drafted Nieuwenhuis, Colon, Blanco, and Ynoa in various "pre-card" draft leagues -- but who on earth is Steve Clevenger?!?

You're right - I agree with your list based on 2B/AB - my previous list filtered out certain teams and any player under 600 PA's and it erroneously excluded the guys that you have listed.

Are you just looking for Doubles per At-Bat (not Plate Appearance)? Using Excel with the downloadable SOM player list, I did a quick list of the top 25 or so

I hadn't thought of that! -- I am bad at spreadsheets and I always forget you can get them to do arithmetical operations. Per PA would be better, but per AB is fine -- thank you.

Is that excel data the free version in the player set, or is it from the ratings guide?

Are you just looking for Doubles per At-Bat (not Plate Appearance)? Using Excel with the downloadable SOM player list, I did a quick list of the top 25 or so

I hadn't thought of that! -- I am bad at spreadsheets and I always forget you can get them to do arithmetical operations. Per PA would be better, but per AB is fine -- thank you.

Is that excel data the free version in the player set, or is it from the ratings guide?

That's just from the free download at the SOM site

It doesn't change much, but here is the list by doubles vis à vis PA (AB+BB+HB):

1 Double per # of PAs

Kouzmanoff 8.5
Nieuwenhuis 9.14
Colon 9.6
Blanco 9.8
Ynoa 11.8
Soler 11.88
Susac 11.88
Goldschmidt 12.1
Clevenger 12.13
Lucroy 12.32
Zimmerman 12.42
Petit 12.5
Gimenez 12.8
Cabrera 12.96
Johnson, Reed 13.06
Escobar 13.11
Lind 13.25
Pillar 13.44
Lutz 13.5
Arenado 13.56
Cuddyer 13.6