CSS Button No Image Css3Menu.com

Baseball Prospectus home
  
  
Click here to log in Click here for forgotten password Click here to subscribe

<< 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

24 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)

RECENTLY AT BASEBALL PROSPECTUS
Premium Article Pitching Backward: The Guy Who Makes Scherze...
Fantasy Article Fantasy Team Preview: Los Angeles Angels of ...
Premium Article Rumor Roundup: Upton and Ubaldo in One Ugly ...
Premium Article Pebble Hunting: Hank Aaron's Hypothetical Fo...
Premium Article Raising Aces: Free Agent Pitchers: The Top T...
Premium Article Moonshot: A New View of Plate Discipline, Pa...
Premium Article 2015 Prospects: Cincinnati Reds Top 10 Prosp...

MORE FROM FEBRUARY 13, 2014
Point/Counterpoint
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...

MORE BY COLIN WYERS
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...
More...

MORE FEATURE FOCUS
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
More...

INCOMING ARTICLE LINKS
2014-02-04 - Baseball Prospectus News: Reintroducing PECO...