Archive for spreadsheet

Raise your hand if any of these statements are true.

1. You have a hard time remembering all the players on your various fantasy teams.
2. You remember the players, but you have a hard time remembering exactly which team the players are on.
3. You get alerts that one of your players is out of the lineup and you need a quick way to find all the teams that player is on to swap him out.
4. You have more than four fantasy teams (… but maybe not this many).
5. You like to look at more than the base stats provided to you about each player on your league hosting site (R, HR, RBI, W, and SV are nice but you want K%, OPS, FIP, etc.)
6. You would like an easier way to research your own players on various sites like Fangraphs, Brooks Baseball, and Baseball Savant (the official MLB version!).

I have a poor understanding of the “fantasy baseball demographics” of our readership, but hopefully the majority of Fangraphs readers can relate to at least one of the issues above. Many believe that duct tape fixes all problems. I believe they’re wrong and that spreadsheets are the superior panacea.

I’ve been working on a prototype spreadsheet that will help keep track of all the players on your fantasy teams, provide easy access to all of your league sites, free agent listings, and standings pages, help you easily determine what teams a specific player is on, and will also let you easily research players on Fangraphs, see pitch velocities and usage mixes at Brooks Baseball, and see exit velocity data at Baseball Savant. Read the rest of this entry »

A couple weeks back I wrote my first Excel-focused piece here at Rotographs. I was testing the water to see how it would go over and the results were pretty unanimous… More Excel please!

So I’m back today with a very practical tip to help you during the draft or while you’re conducting player research. In the instructions that follow I will show you how to add clickable player page hyperlinks to your draft spreadsheet.

Running out of time on the draft clock? Want to look up Dexter Fowler’s walk rate? Or Chris Davis‘ home run per fly ball rate for 2015? You’ll quickly be able to get to any player’s Fangraphs profile page after adding this to your spreadsheet.

Read the rest of this entry »

I’m going to try something a bit different here.

Instead of analysis, let’s try an instructional piece about how to add a feature to your draft prep spreadsheet. In the instructions that follow, I’ll show you how to make a cheat sheet based on auction values. When you’re done, you’ll have something like this…

Read the rest of this entry »