Using Standings Gain Points to Rank and Value Fantasy Baseball Players: A Step-by-Step Guide Using Microsoft Excel

"Using Standings Gain Points to Rank and Value Fantasy Baseball Players" is written by Tanner Bell, author of the SmartFantasyBaseball.com blog.

This instructional guide is written specifically for rotisserie fantasy baseball players looking to create customized player rankings and calculate custom dollar values for their own league.

Whether you play in a 10-team, 12-team, or 15-team league, AL-only, NL-only, or Mixed league, traditional categories or sabermetric categories, this book will teach you the fundamentals necessary to calculate customized rankings and dollar values.

This book includes highly detailed step-by-step instructions with over 200 screenshots outlining exactly how to set up spreadsheets, where to download projections, exact formulas to be used, and links to actual example Excel files to download every step of the way.

The book is written specifically for Microsoft Excel users running Windows (sorry Mac users, because of differences in Excel for Mac, this book does not translate perfectly to your world). You should also be using Excel 2007 or later. You will be better off if you know your way around Excel, but you don't need to be an expert.

The ten step process outlined in the book will help you build a spreadsheet that can be used any season and can easily be updated each year. The specific chapters in the book are:

Part 1 - Download Free Projection Data
Part 2 - Understanding Player IDs
Part 3 - VLOOKUP, Excel Tables, and Named Ranges for Creating Hitter Rankings
Part 4 - Pitcher Rankings
Part 5 - Understanding Standings Gain Points (SGP)
Part 6 - Accounting for Replacement Level and Position Scarcity
Part 7 - Understanding the Hitter/Pitcher Dollar Allocation
Part 8 - Converting SGPs into Hitter Dollar Values
Part 9 - Converting SGPs into Pitcher Dollar Values
Part 10 - Incorporating In-Draft Price Inflation and Keeper League Inflation

Download free fresh books every day!
PDF - for your PC!
EPUB - for your SonyReader, IPHONE, IPAD (also you can download ReaderLibrary and read on your PC: Download )!
MOBI - for your Kindle (also you can download mobireader and read on your PC: Download)!