Smart Elsewhere #1 – Do You Know Where Your Players Bat in the Lineup?

Welcome to the maiden post in the “Smart Elsewhere” series.  In post number one, ESPN’s Tristan H. Cockcroft discusses the “Fantasy value of lineup positions” (follow Tristan on Twitter).  This is an incredibly insightful article about the benefit of loading your team with players that bat in the top four spots of the batting order.

It includes great statistics about the additional plate appearances players higher in the batting order receive, the great production drop off (in runs and RBI) that occurs the further down the line up a player bats, the effect of playing for a good offensive team, and how to think about the value of players who changed teams or positions in the lineup from last year.

Do you know where your players bat in the lineup?


Introducing “Smart Elsewhere”

The best thing you can do to become a smarter fantasy baseball player is pretty straightforward.  You need to read.  Read a lot.  Read articles from a lot of different sources.  And luckily, there are a lot of great writers and analysts out there.

I am going to begin a recurring series of posts, entitled Smart Elsewhere, in which I link to smart fantasy baseball articles written by others.  They may be current articles.  Or they may be old but still helpful at making you a better fantasy baseball player.

If you come across an article you think others can benefit from, mention it to @smartfantasybb on Twitter.  And if you’re not already, make sure to follow Smart Fantasy Baseball on Twitter by clicking on the button below.

Thanks for the follow and be smart.

The SFBB Twitter Lists

Where were you the night of April 27th, 2012?

I won’t soon forget getting off the couch that night, letting my dog out, and checking Twitter while I waited for her to come back inside.  News had hit Twitter that Mike Trout was being called up (you may remember that Bryce Harper was called up just hours before Trout).

I quickly went to all my league sites and picked up Trout and Harper in any leagues in which they were still available.

The point of this story is that Twitter helped me win two of my leagues in 2012.  It’s a great tool for alerting you to important fantasy events (injuries, call ups, closer changes) and aggregating fantasy news and articles from around the web.

The web is full of A TON of great and free fantasy baseball content and Twitter is an invaluable tool for helping you locate that information.

Getting Started

If you need a primer on Twitter, Brien Bonneville over at thefakebaseball.com has a great introduction and some tips for new users.  As a technology lover, I especially like the suggestion to download and use a Twitter dashboard like TweetDeck.  Twitter’s interface is a little clunky.  Using a dashboard allows you to more efficiently access different features in Twitter, arrange and follow multiple streams, and access multiple Twitter accounts at once.

Who To Follow

For the last couple years, David Gonos has put out his list of 99 Fantasy Baseball Twitter Accounts You Should Follow.  There are probably thousands of fantasy baseball Twitter accounts out there and Gonos has done a great job of isolating some of the best.  You’ll see names like Matthew Berry, Jason Collette, Mike Gianella, Tristan Cockroft, and Ron Shandler on his top 99.

SFBB Tip – Twitter Lists

In my opinion, one of the most underutilized features on Twitter is “Lists”.  A Twitter “List” allows you to group and organize Twitter users.  You can subscribe to lists created by other Twitter users and others can subscribe to your own lists.  When you then visit a list, the Tweets from everyone in the list are displayed.

Subscribing to a list is different than following someone.  This is nice because you can easily segregate people you follow for personal reasons from others by using lists.  For example, if you subscribe to one of the lists below, you won’t have MLB injury news cluttering up your Twitter stream.  When you’re ready to do some fantasy baseball reading, you can then view the appropriate list.

Instead of you having to seek out fantasy baseball experts to follow, I’ve created created several Smart Fantasy Baseball Twitter lists you can follow.  You can see all the SFBB lists here, or visit the individual lists with the links below:

How To Subscribe To a List

  1. After clicking on one of the links above, locate and click on the “Subscribe” button in the top left corner of the page.
    TwitterList1
  2. Keep in mind that lists you have subscribed to do not hit your Twitter feed.  To view the contents of a list, after logging into Twitter, click on the “View my profile page” link.
    TwitterList062913
  3. Then click on the “Lists>” link, in the top left corner, to see all lists you are subscribed to.
    TwitterList3
  4. On the ensuing page you will see all of your lists.  The title of each list will be displayed along with who created it.
    TwitterList4
  5. Once you click to view a list, all the Tweets from members added to the list will appear in a feed for you to read.
    TwitterList5
  6. If you do make the jump to using a Twitter Dashboard, like Tweetdeck, you can add followed lists to the Dashboard and have them easily available (and avoid having to jump through these hoops above).
    TwitterList6

Who’s Missing?

Who are your favorite Twitter follows?  Is there anyone missing from the lists that you think should be added?  I don’t intend for the lists to be all encompassing, and I put a preference on quality over quantity.  There are also some fantasy baseball experts that don’t tweet much about fantasy baseball, so I excluded them (Gonos’ list of 99 had some that I left off my lists for that reason).

Stay Smart.  And thanks for reading.

Create Your Own Fantasy Baseball Rankings: Part 6 – Accounting for Replacement Level and Position Scarcity

Welcome to the sixth and final part of the “Create Your Own Fantasy Baseball Rankings” series.  If you missed an earlier part, you can find it here.  You can start at the beginning of the series or if you want to start here at Part 6, you can download the Excel file created during part 5 here.

Please note that this six part series has been adapted into a 10 part book that also shows you how to convert standings gain points into dollar values and how to calculate in-draft inflation.
A few notes about the series:

  • It was originally written before the 2013 MLB season.  The screenshots and player references you see might refer to things from that time frame, but the same approach will work today.
  • If you register as SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book
  • Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used
  • Some of the formulas used in the series do not work in Excel for Mac computers.  I apologize for this.  I don’t understand why Excel isn’t built to operate the same on that platform.

In this sixth part of the series we will discuss the concept of replacement level players and calculating for position scarcity.

Replacement Level Players

Mike Trout is projected for 114 R, 26 HR, and 83 RBI.  Those numbers are gaudy.  But should he get “credit” for all those statistics if I can go out the day after the draft and pickup a player on the free agent list that is projected for 50 R, 15 HR, and 55 RBI?

This is the concept of replacement level.  If player X is projected for 26 HR and there are several free agents that will hit 15 HR, the true value of player X is in his 11 additional HR (26 – 15).

So when calculating a player’s SGP, you should not perform the calculation on the “gross” or total number of HRs.  Rather, you should calculate SGP with the amount of HR over a replacement level player (a free agent).

Determining Replacement Level

Assuming a 12-team league with 14 hitters (two C, 1B, 2B, SS, MI, 3B, CI, five OF, DH), 168 offensive players will be drafted (you can add more to adjust for bench players).  So the 169th player is “replacement level”, right?

Arguably this is true.  But let’s fine tune this a little more.  In a 12-team league where each team must start two catchers, the 25th best catcher is the “replacement level catcher”.

If the league request one 2B, one SS, and one Middle Infielder, then 36 combined 2B and SS will be drafted.  We can assume this will be comprised of 18 2B and 18 SS, and the 19th best of each position will be the “replacement level”.

Likewise, you might expect 18 1B, 18 3B, and 60 OFs to be drafted.  But given that these positions typically produce better offensive statistics than 2B and SS, 1B and OF tend to be slotted into the UTIL/DH spots.  This can push the 1B up to 24 selected players and the OF up to 66 selected players (with the 25th 1B being “replacement level” and the 67th OF being “replacement level”.  

Let’s look at some projected statistics for Jason Heyward and Robinson Cano (please note the tables below don’t foot due to rounding) :

Category Heyward Cano
R SGP 3.82 3.58
HR SGP 2.60 2.40
RBI SGP 3.62 3.98
SB SGP 1.38 0.32
AVG SGP 0.12 0.96
TTL SGP 11.54 11.25

On the surface, the two are near equals, with Heyward holding a slight overall edge in SGP.  But let’s now compare each to a replacement level player at their position.  In my rankings spreadsheet, the 61st ranked OF is Ryan Ludwick.

Category Heyward Ludwick Heyward over Ludwick
R SGP 3.82 2.32  1.50
HR SGP 2.60 1.92  0.68
RBI SGP 3.62 2.72  0.90
SB SGP 1.38 0.11  1.27
AVG SGP 0.12 -0.14  0.26
TTL SGP 11.54 6.93  4.61

In my rankings spreadsheet, the 19th best 2B is Gordon Beckham.

Category Cano Beckham Cano over Beckham
R SGP 3.58 2.20  1.38
HR SGP 2.40 1.25  1.15
RBI SGP 3.98 2.07  1.91
SB SGP 0.32 0.53  -0.21
AVG SGP 0.96 -0.35  1.31
TTL SGP 11.25 5.67  5.54

So despite a higher gross SGP (11.54 vs. 11.25), Heyward comes out as less valuable when we adjust for replacement level players.  In fact, Cano moves to nearly one whole SGP of an advantage over Heyward (5.54 vs. 4.61). Continue reading “Create Your Own Fantasy Baseball Rankings: Part 6 – Accounting for Replacement Level and Position Scarcity”

Create Your Own Fantasy Baseball Rankings: Part 5 – Understanding Standings Gain Points

Welcome to the fifth part of the “Create Your Own Fantasy Baseball Rankings” series.  If you missed an earlier part, you can find it here.  You can start at the beginning of the series or if you want to start here at Part 5, you can download the Excel file created during part 4 here.

Please note that this six part series has been adapted into a 10 part book that also shows you how to convert standings gain points into dollar values and how to calculate in-draft inflation.

A few notes about the series:

  • It was originally written before the 2013 MLB season.  The screenshots and player references you see might refer to things from that time frame, but the same approach will work today.
  • If you register as SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book
  • Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used
  • Some of the formulas used in the series do not work in Excel for Mac computers.  I apologize for this.  I don’t understand why Excel isn’t built to operate the same on that platform.

In this fifth part of the series we will discuss the concept of Standings Gain Points (SGP), a method of evaluating and ranking players.  At the end of this part, we’ll actually have some primitive rankings in place.  But we have quite a few concepts to go over before we  jump into Excel.

THE DIFFICULTY IN RANKING PLAYERS

Which player is worth more and should be ranked higher?

  • Player A – .280, 65R, 30HR, 95RBI, 0SB
  • Player B – .265, 100R, 10HR, 55RBI, 40SB

Or how about this?

  • Player A – .280, 65R, 30HR, 95RBI, 0SB
  • Player C – 5W, 40SV, 75SO, 2.50ERA, 1.10 WHIP

How do you rank different types of players (speed/average vs. power/RBI)?  Or even worse, how do you evaluate the worth of a hitter against the worth of a pitcher?  Enter the concept of Standings Gain Points.

STANDINGS GAIN POINTS – MY INTERPRETATION

The end goal of rotisserie fantasy baseball is to accumulate the most points in the standings.  The Standings Gain Points approach to valuing players is to convert a player’s statistics into the number of rotisserie points those statistics are worth.  

Let’s use some example statistics from a real 12-team 5×5 rotisserie league to illustrate:

POS HR RBI W ERA
1 291 1,054 108 3.359
2 287 1,027 107 3.365
3 281 1,017 93 3.477
4 274 1,003 92 3.678
5 272 998 88 3.815
6 267 973 88 3.857
7 263 968 84 3.946
8 261 965 82 4.096
9 244 945 82 4.097
10 239 921 81 4.177
11 234 920 81 4.284
12 191 792 78 4.361

Continue reading “Create Your Own Fantasy Baseball Rankings: Part 5 – Understanding Standings Gain Points”

Create Your Own Fantasy Baseball Rankings: Part 4 – Pitcher Rankings

Welcome to the fourth part of the “Create Your Own Fantasy Baseball Rankings” series.  If you missed an earlier part, you can find it here.  You can start at almost any part of the series, but it’s not recommended you start with Part 4 unless you are very familiar with the Excel functions listed below.  Part 4 is essentially reperforming step 3(which focused on hitters) for pitchers.  This post assumes you are familiar with the Excel functions and formulas used in Part 3.

Please note that this six part series has been adapted into a 10 part book that also shows you how to convert standings gain points into dollar values and how to calculate in-draft inflation.

A few notes about the series:

  • It was originally written before the 2013 MLB season.  The screenshots and player references you see might refer to things from that time frame, but the same approach will work today.
  • If you register as SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book
  • Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used
  • Some of the formulas used in the series do not work in Excel for Mac computers.  I apologize for this.  I don’t understand why Excel isn’t built to operate the same on that platform.

In this fourth part of the series we will use Excel formulas and functions to start pulling pitcher information (name, position, team) and projection information in order to eventually calculate our own rankings.

EXCEL FUNCTIONS AND FORMULAS IN THIS POST

Below are the Excel functions and formulas used in this post.  If you would like more background on them, please refer to Part 3 or ask questions in the comments area below.

  • VLOOKUP
  • TABLES and NAMED RANGES
  • COLUMN

STEP-BY-STEP INSTRUCTIONS

  1. Staying consistent with the hitting projections, I’m going to use the free Steamer projections from Fangraphs.
  2. To make the pitching projections easier to work with, convert the “Steamer Pitchers” tab to a “table” in Excel.  To do this, click anywhere within the data on the “Steamer Pitchers” worksheet.  Then locate the “Home” tab in the Excel menu system (“the ribbon”).  Click once on the “Format as Table” drop down, and then select your desired color scheme.Part 3-2You will then be prompted to verify the range of cells in the table and that your table has a header row (e.g. Name, W, L, ERA, etc.).  Check “My table has headers”.  Click OK.Part 3-3
  3. Because we’ll later be these pitcher projections into other worksheets, it will help us greatly if the fangraphs player ID is the first column of the table (you can use the VLOOKUP formula if the player ID is in the first column, otherwise you’re stuck using more difficult and/or multiple formulas).  Right-click on the top of the fangraphs player ID column (should be column X in the Steamer Pitchers projections).Cut_Pitcher_IDsPart 3-4.1Now right-click on the top of the player name column (column header “A”) and select “Insert Cut Cells”.  When you’re done, you should have the “playerid” column first and “Name” second.Part 4-1 Continue reading “Create Your Own Fantasy Baseball Rankings: Part 4 – Pitcher Rankings”

Create Your Own Fantasy Baseball Rankings: Part 3 – VLOOKUP, Excel Tables, Named Ranges

Welcome to the third part of the “Create Your Own Fantasy Baseball Rankings” series.  If you missed an earlier part, you can find it here.  You can start at the beginning of the series or if you want to start here at Part 3, you can download the Excel file created during part 2 here.

Please note that this six part series has been adapted into a 10 part book that also shows you how to convert standings gain points into dollar values and how to calculate in-draft inflation.

A few notes about the series:

  • It was originally written before the 2013 MLB season.  The screenshots and player references you see might refer to things from that time frame, but the same approach will work today.
  • If you register as SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book
  • Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used
  • Some of the formulas used in the series do not work in Excel for Mac computers.  I apologize for this.  I don’t understand why Excel isn’t built to operate the same on that platform.

In this third part of the series we will use Excel formulas and functions to start pulling player information (name, position, team) and projection information in order to eventually calculate our own rankings.  Strap in…  This is a long one.

Excel Functions and Formulas In This Post

Below are the Excel functions and formulas used in this part of the series.  If you’re already familiar with what these are, you can skip ahead. Continue reading “Create Your Own Fantasy Baseball Rankings: Part 3 – VLOOKUP, Excel Tables, Named Ranges”

Create Your Own Fantasy Baseball Rankings: Part 2 – Understanding Player IDs

Welcome to the second part of the “Create Your Own Fantasy Baseball Rankings” series.  If you missed Part 1, you can find it here.  You can start at the beginning or if you want to start here at Part 2, you can download the Excel file created during part 1 here.

A few notes about the series:

  • It was originally written before the 2013 MLB season.  The screenshots and player references you see might refer to things from that time frame, but the same approach will work today.
  • If you register as SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book
  • Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used
  • Some of the formulas used in the series do not work in Excel for Mac computers.  I apologize for this.  I don’t understand why Excel isn’t built to operate the same on that platform.

In this second part of the series we discuss what player IDs are so we can later use them to pull information within Excel.  You might have noticed the projection data downloaded from fangraphs in part 1 did not contain the player’s team or position.  But the downloads did contain each player’s fangraphs ID.

UNDERSTANDING PLAYER IDs

Are you familiar with Chris Young, the long-time Arizona Diamondback outfielder with a career batting average of about .240?  Are you familiar with Chris Young, the oft-injured extremely tall pitcher with a career ERA of 3.79?

Even if you’re not familiar with them, know that there are two baseball players of recent note named Chris Young.  Look at this chart:

Source .240 Hitting ID Tall Injured ID
Name Chris B. Young Chris R. Young
Baseball Reference youngch04 youngch03
Fangraphs 3882 3196
MLB 455759 432934
CBS 4898811 517762

Just like you have a unique Social Security Number or Employee ID associated with your name, baseball players have been given unique IDs from different organizations/websites.  These IDs give us a way to differentiate Chris B. Young from Chris R. Young.  The problem is that there is not an agreed upon ID for each player.  Each website or fantasy service uses their own ID.

We need a tool to translate the different player IDs from the various baseball services.  That’s where the Smart Fantasy Baseball Player ID Map comes in. Continue reading “Create Your Own Fantasy Baseball Rankings: Part 2 – Understanding Player IDs”

Create Your Own Fantasy Baseball Rankings: Part 1 – Download Free Projection Data

Welcome to the first part in a series of posts in which I’ll go through the process I use to create my own fantasy baseball rankings.  I’ll provide a link to download the rankings project (in Excel 2010 format) at each part of the series.  Please ask questions in the comments below so others can benefit from your questions.

A few notes about the series:

  • It was originally written before the 2013 MLB season.  The screenshots and player references you see might refer to things from that time frame, but the same approach will work today.
  • If you register as an SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book
  • Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used
  • Some of the formulas used in the series do not work in Excel for Mac computers.  I apologize for this.  I don’t understand why Excel isn’t built to operate the same on that platform.

In this first part of the series we’ll set up a new Excel file, download projection data, and do some basic formatting to make the file presentable.

Step-by-Step Instructions

  1. To start, create and save a new Excel file for this project.
    Rankings Part 1-1
  2. You could always pay for rankings or projections.  But this is a “DIY” project with the goal being to build your own rankings and not spend money in the process.  Fangraphs offers a “Projections” section that includes a number of free projection systems for download.  Choose your favorite projection system and use the link to “Export Data”.Fangraphs-RoS-Export
  3. The data downloads in CSV (comma separated value) format.  Locate the downloaded CSV file and open it.  It should open in Microsoft Excel.  Once the file opens, right-click on the tab and select the option to “Move or Copy…”
    Rankings Part 1-3When prompted, choose your Rankings Excel file (saved in step 1 above) from the drop down menu.  Then hit “OK”.
    Rankings Part 1-4
  4. Any sheet downloaded from Fangraphs has the tab name “FanGraphs Leaderboard”.  Right click on the spreadsheet to give it a more meaningful name (like Zips Hitters). Continue reading “Create Your Own Fantasy Baseball Rankings: Part 1 – Download Free Projection Data”

Downloadable Tool – Calculate What It Takes To Win Your League

I’ve developed a much more refined tool to help calculate the number of rotisserie points it will take to win your league, as well as the statistics necessary in each category to achieve a certain place.

You can download the file here:  What It Takes To Win Calculator.xlsx

You must have Microsoft Excel 2007 or greater to use the calculator.  To use the calculator:

  1. After downloading the file, fill out the information requested on the “Answer These Questions First” tab (genius naming convention, I know).
    Answer These Questions First
  2. The questions can be answered using the drop down menus provided.
    Drop Down Menus
  3. Then proceed to complete all of the yellow hitter and pitcher stat tabs.
    Complete Hitter and Pitcher Tabs
  4. Follow the bold red instructions on each tab.  Also be on the look out for warnings for areas saying “DO NOT ENTER DATA BELOW”.  These are just warnings to ensure formulas work correctly and to prevent you from entering unnecessary data.
  5. Follow Instructions on Each TabAfter you’ve completed all the data entry into the yellow tabs, return to the “Results” tab to see the stats necessary to win your league.
    Results Tab
  6. The end result should be printer friendly, if you’d like to print it out for future reference.  Click on the image below for a larger view of the finished results.
    Printer Friendly Results

Features

The tool can accommodate the following:

  • Up to 15 teams
  • Up to 10 years of historical standings and statistics data
  • Up to 6×6 rotisserie categories (6 hitting, 6 pitching)
  • Hitting categories of BA, R, HR, RBI, SB, OBP, H, BB
  • Pitching categories of W, K, SV, ERA, WHIP, QS

Suggestions or Ideas for Improvement?

Please shoot me a comment and let me know what you think.  Let me know if you’d like to see any additional features or categories added.

As always, make smart choices.