A step-by-step guide on how to build a Fantasy Baseball Spreadsheet. Learn how to import stats automatically every day. You will have batter's stats based on the pitcher they are facing, pitcher's strikeout percentage, projected runs, and more! You will learn how to color code stats to easily see great plays. There is also a lineups page where you can easily compare lineups for the day! The Fantasy Basketball course was taken by hundreds of students, in 48 different countries. Daily Fantasy Baseball brings a millions stats to look at. This spreadsheet will immediately speed up your research. Save time and take your Fantasy game to a professional level with this easy to follow guide!
How to start your Google Spreadsheet. Then exporting the players for the day from DraftKings.
What you came here for! This is the equation needed to import stats automatically for you every single day!
Get every Starting Pitcher for the day automatically imported into your spreadsheet.
Using player I.D. numbers is much more accurate than using a player's name. It can be Jon one place and Jonathan another.
This will get you the day's schedule and the Vegas Projected Runs for each team.
Each batter's wOBA vs left or right handed pitchers, depending on who they are facing that day. wOBA is a great stat to use for Fantasy Baseball. FanGraphs has a great explanation of it in the attached link.
The ISO for each batter vs left or right handed pitchers, depending on who they are facing that day. ISO is a great stat to measure power and extra base hits (UPSIDE). FanGraphs has a detailed explanation in the attached link.
The projected runs for each batter's team.
Get today's Starting Pitchers to the SP page.
Each Starting Pitcher's team and player I.D.
Automatically get the throwing hand for each starting pitcher and the projected runs.
Another great stat for pitchers. Strikeouts per 9 innings pitched.
Bringing it all together to make dominant lineups! Just copy and paste the lineups page from FantasyBlueprint.com and you will easily be able to compare different lineups during your research.
After your Blueprint is complete, we make a copy of it to start from every day. Saving a ton of time!
All the work is done! This is how you will start your spreadsheet every day. It sets up in just a couple of minutes, allowing you more time building the perfect lineup!
I've been playing Fantasy sports for 15 years. MLB is my absolute favorite and I count down the days to Spring Training. I've played Fantasy Baseball, Football, Basketball, Hockey, Golf, and Bass Fishing (really). I'm a Certified Google Educator and have been using Google Sheets for years. I will help you build an amazing fantasy spreadsheet!