Sports Reference Blog

SPREADSHEET: Record with leads of X going into inning N grouped by decade

Posted by sean on April 19, 2013

Clicking the link below will download a csv (actually tab-delimited) file (suitable for Excel) that contains decade-by-decade records for teams when they enter an inning with a lead of 1 to 6+ runs (about 400 lines).

http://tmp.bbref.com/record-with-leads-of-x.csv

Feel free to use it however you wish, but a cite and a link to Baseball-Reference are always appreciated. RetroSheet data was used in the preparation of this doc.

For example, here are the team W-L% holding a lead of one run going into the 9th.

1940s	9	1	623	0.8604
1950s	9	1	2324	0.8515
1960s	9	1	3470	0.8559
1970s	9	1	4254	0.8618
1980s	9	1	4169	0.8638
1990s	9	1	4306	0.8511
2000s	9	1	4574	0.8566
2010s	9	1	1535	0.8612

Related posts:

  1. Play Index Inning Scoring & Lead Change Tool
  2. PI Inning Summary

This entry was posted on Friday, April 19th, 2013 at 9:27 am and is filed under Announcement, Baseball-Reference.com. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

5 Responses to “SPREADSHEET: Record with leads of X going into inning N grouped by decade”

  1. Cliff Otto Says: April 19th, 2013 at 10:06 am

    Opening the file directly with Excel did not work as the tabs were lost. I had to open it with a text editor and paste it as text into Excel to get the columns to separate...just in case anyone else tries.

  2. Ryan Says: April 19th, 2013 at 10:45 am

    Cliff,

    It does work, upon opening the excel doc you need to select the Data tab, click "Text to Cloumns", select the Delimited button, hit next and select Comma (leaving tab selected), finally click finish and you will be good to go.

  3. TapDancingTeddy Says: April 19th, 2013 at 1:33 pm

    For Excel 2007 It works fine if you import the data by going to the "Data" tab in Excel and selecting "From Text" in the "Get External Data" box. That starts up the "Import Wizard" that allows you to configure the columns and delimiters for the file you are importing.

    If I remember correctly older Excel versions had an "Import" function on the file menu itself. Maybe Microsoft thought that was too easy.

  4. Chuck Hildebrandt Says: April 19th, 2013 at 2:20 pm

    So a sample size of at least 600 seems enough to stabilize the winning percentage of a one-run lead going into the ninth to within a range of 85.1% and 86.4% across eight separate decades.

  5. Cliff Otto Says: April 20th, 2013 at 9:54 am

    Okay, Ryan, I didn't try that because I just saw one solid word that didn't look like there was any delimiters and I expected Excel to automatically recognize the tabs. Thanks.