Estimated Offense Worksheet
Feb 3, 2020 4:46:09 GMT -8
Rangers GM (Victor), Cubs GM (Beau), and 3 more like this
Post by Rockies GM (Dan) on Feb 3, 2020 4:46:09 GMT -8
In the process of tweaking the program, I came up with a system to (hopefully) better accumulate preseason projections into usable stats. I came up with historical correlations which attempt to take positions and multi-position players into account.
This will require an overhaul of my program eventually, so for now, I've put everything into an Excel worksheet in order to test it out.
Ever want to know how a free agent should theoretically affect your teams/stats? See how you'll stack up in comparison to the rest of the league?
If you want to know that second one, you're out of luck - not sharing my simulation algorithm.
BUT, if you want to know the answer to the first question, here's a worksheet. A few notes
1) It's still affected by projections. The formulas each have at least a .91 R-squared with end-of-season total stats vs. counted stats, but those may differ vastly from early projections. This is not intended to be 100% accurate at the end of the season. That's impossible to know.
2) If you are lacking significant at-bats at a certain position, the worksheet may project that group for more at-bats than they actually are projected for. (In my own calculations, there's only one team I've noticed in this position)
HOW TO USE
- Fill in the data from projections (Steamer, ZIPS, Depth Charts, etc.)
- If a player on Fantrax has multi positions, place them in each position they're eligible for, as well as the gray multi-position area.
- Don't touch the bottom
The very bottom line of the sheet is your forecast for the year.
Offense Worksheet.xlsx (15.54 KB)
This will require an overhaul of my program eventually, so for now, I've put everything into an Excel worksheet in order to test it out.
Ever want to know how a free agent should theoretically affect your teams/stats? See how you'll stack up in comparison to the rest of the league?
If you want to know that second one, you're out of luck - not sharing my simulation algorithm.
BUT, if you want to know the answer to the first question, here's a worksheet. A few notes
1) It's still affected by projections. The formulas each have at least a .91 R-squared with end-of-season total stats vs. counted stats, but those may differ vastly from early projections. This is not intended to be 100% accurate at the end of the season. That's impossible to know.
2) If you are lacking significant at-bats at a certain position, the worksheet may project that group for more at-bats than they actually are projected for. (In my own calculations, there's only one team I've noticed in this position)
HOW TO USE
- Fill in the data from projections (Steamer, ZIPS, Depth Charts, etc.)
- If a player on Fantrax has multi positions, place them in each position they're eligible for, as well as the gray multi-position area.
- Don't touch the bottom
The very bottom line of the sheet is your forecast for the year.
Offense Worksheet.xlsx (15.54 KB)
