Fun Excel File of the Day - Shortstops, Just For You!

Discuss the Brewster Baseball Association here!
User avatar
RonCo
GB: JL Frontier Division Director
Posts: 22111
Joined: Sat Nov 14, 2015 10:48 pm
Has thanked: 2435 times
Been thanked: 3963 times

Fun Excel File of the Day - Shortstops, Just For You!

Post by RonCo » Thu May 15, 2025 3:06 pm

I've effectively "wasted" my morning making a new report built off game log data. In this case, it's a table of shortstops across the whole of the BBA, and their BIP and Out conversions by Zone.

I'm posting the whole thing here so you too can waste big parts of the day trying to decide if your shortstops were really any good or not.

Lucky you!

Bottom line, the file has every player who played even an inning at shortstop, and lists first by each SS zone, GB in Zone, GB Converted into outs, and then a simple % conversion. I considered taking out the "56" zones (between 3B and SS) simply because they are clouded by the performance of the 3B, but I've left them in there for now simply because you might be able to think of a way to use it. [LEARNING OF THE WEEK: the 3B is the fielder of record on 60-70% of GB in those zones, especially shallow and mid...which makes sense to me].

Anyway, I've had fun staring at it. Maybe you will, too.
Attachments
Shortstop_Defense.csv
(17.77 KiB) Downloaded 15 times
GM: Bikini Krill
Nothing Matters But the Pacific Pennant
Roster

User avatar
cheekimonk
BBA GM
Posts: 5956
Joined: Sat Oct 23, 2010 6:46 pm
Location: Birmingham, AL
Has thanked: 297 times
Been thanked: 275 times
Contact:

Re: Fun Excel File of the Day - Shortstops, Just For You!

Post by cheekimonk » Sun May 18, 2025 11:35 pm

It's always seemed intuitive to me that the more range your shortstop has (i.e., the better he is defensively), the less your 3B needs to have (i.e., defensive requirement for 3B can dip)
Ben Teague GM Boise Spuds
2964-3356, .469 PCT (39 seasons)
10 Postseason Appearances, 1 Championship, 3 GM of the Year
Caleca Award: 2059

Former BBA GM: Many (Brewster Memorial Champion: 1997-Hackensack Bulls)

Boise Home Page (roster, prospects, etc.)

User avatar
CTBrewCrew
GB: FL Heartland Division Director
Posts: 6350
Joined: Wed Sep 04, 2019 11:20 am
Location: Milford, CT
Has thanked: 993 times
Been thanked: 1633 times

Re: Fun Excel File of the Day - Shortstops, Just For You!

Post by CTBrewCrew » Tue May 20, 2025 8:49 pm

Cool - thanks ill see how i can visualize it. Always fun to play with something new.
Image

Post Reply Previous topicNext topic

Return to “League Chatter”

Who is online

Users browsing this forum: No registered users and 5 guests