CSS Button No Image Css3Menu.com

Baseball Prospectus home
Click here to log in Click here for forgotten password Click here to subscribe
Strength of Schedule Report
<< Previous Article
Premium Article Prospects Will Break Y... (02/12)
<< Previous Column
Feature Focus: Sortabl... (08/28)
Next Column >>
Feature Focus: Visual ... (07/25)
Next Article >>
Fantasy Article Tale of the Tape: Evan... (02/13)

February 13, 2014

Feature Focus

PECOTA Weighted Means Spreadsheet

by Colin Wyers

Note: this piece was originally published on July 11, 2013.

Welcome back to another installment of Feature Focus! I’m your host, Richard Kiley. (We spared no expense.) This week, I want to talk to you about the PECOTA Weighted Means Spreadsheet.

To download the PECOTA Weighted Means spreadsheet, simply go to the Fantasy dropdown on the navbar at the top of any BP page:

If you’re a BP subscriber (you are a subscriber, aren’t you?) that link will download an Excel spreadsheet. The most common way to open those is with Microsoft Excel. If you don’t have Excel, however, there are several alternatives:

  • You can download the free Excel Viewer for Windows.
  • Users of Mac OS X v10.7 (Lion) and newer can use Preview, which comes preinstalled
  • You can download one of several free Excel-compatible spreadsheet programs, like Gnumeric, LibreOffice, and OpenOffice
  • You can import the spreadsheet into Google Docs or Office Web Apps and view it in your web browser.

The first sheet is an informational page, containing the latest date updated, the copyright notice, information about the playing time forecasts and a link to the PECOTA glossary. For players who are in the depth charts (that is, expected to play in MLB), we use their Depth Charts forecast from the moment the spreadsheet was published; all other players have automated playing time forecasts based on their past playing time, both major and minor league. This means that summing values out of the PECOTA spreadsheet will vastly outstrip the amount of playing time we actually expect in MLB for the season; if you want team totals, you need to use only the values for players who are in the depth charts (which will have a “T” in the DC_FL column in their respective sheet).

The next sheet contains hitter forecasts. Several columns are links; you can click on a player’s BPID to view his player card, his team to view the team’s Depth Chart page, or his MLBCODE to visit the player’s page at MLB.com. The spreadsheet also displays a player’s official stats, and several rate stats computed from those. Please bear in mind that the rate stats are rounded separately from the counting stats, so a player’s hit totals may not reconcile exactly with his listed batting average, for instance. We also show the key value stats we use for hitters at BP—True Average, Baserunning Runs, FRAA, VORP and WARP. Then come the PECOTA diagnostics, based on the percentiles.

Much like the hitters sheet, the pitchers sheet contains hyperlinks for player cards and the team’s Depth Chart page. We have a variety of official (and essentially official, like Quality Start) stats, along with our value stats and PECOTA diagnostics. If you're wondering about projections of rest-of-season performance, you can find those on the player cards.

That’s all for this week. Have requests for additional PECOTA spreadsheet features? Or have a feature at BP you’d like to see highlighted? Leave a comment below.

Colin Wyers is an author of Baseball Prospectus. 
Click here to see Colin's other articles. You can contact Colin by clicking here

Related Content:  PECOTA,  Projections,  Feature Focus

26 comments have been left for this article.

<< Previous Article
Premium Article Prospects Will Break Y... (02/12)
<< Previous Column
Feature Focus: Sortabl... (08/28)
Next Column >>
Feature Focus: Visual ... (07/25)
Next Article >>
Fantasy Article Tale of the Tape: Evan... (02/13)

BP South Side
BP Wrigleyville
BP En Espanol: Los lanzadores calificados pa...
What You Need to Know: Judge Rules Against T...
Short Relief: Home Runs and Runs Home
Premium Article Baseball Therapy: Confessions of a Fake Mana...
Flu-Like Symptoms: The Vanishing ERA Qualifi...

Premium Article Transaction Analysis: Phillies Sign Burnett,...
Premium Article Skewed Left: Fun with 2014 PECOTA Comparable...
Premium Article Rumor Roundup: Catching Up with Catcher News
The BP Wayback Machine: Derek Jeter's Career...
Fantasy Article Get to Know: Third Base Prospects
Fantasy Article Tale of the Tape: Evan Longoria vs. David Wr...

2014-02-13 - Feature Focus: PECOTA Weighted Means Spreads...
2013-11-01 - Manufactured Runs: Moments of Transition, Mo...
2013-10-02 - Premium Article Playoff Prospectus: NL Wild Card Game Recap:...
2013-09-19 - Reworking WARP: The Importance of a Living R...

2014-08-14 - Feature Focus: Prospect Tracker
2014-07-31 - Feature Focus: Pitch f/x Matchup Tool
2014-07-25 - Feature Focus: Visual Depth Charts
2014-02-13 - Feature Focus: PECOTA Weighted Means Spreads...
2013-08-28 - Feature Focus: Sortable Statistics (Introduc...
2013-07-30 - Feature Focus: Team Audit
2013-07-26 - Feature Focus: Depth Charts