Post by Andy Barnes on Aug 2, 2012 18:35:24 GMT -5
Gentlemen and not so gentle men, I would like to introduce you all to WAIVR.
WAIVR is a project that Brad Z and I worked extensively on over the last month or so. It stands for Weighted Average and Individual Value Rating. This will be the official tool used to calculate arbitration raises every off season. The following is a primer on how it works, so study up, because it will be released within the next few days.
Step 1
It is linked directly to the master list on the DLF spreadsheet, so it only includes players that are getting paid in our league universe.
Step 2
It sorts these players by position, so players may be listed in more than one location. It uses ESPN eligibility requirements to apply the positions. So this is not for the 2012 in season positions, but those that the player will qualify for in 2013.
Step 3
It uploads stats from multiple sources and populates the fields for each respective player, with their current 2012 stats.
Step 4
I reversed engineered the ESPN Player Rater to find the formulas and weights that they use. I applied those to the stats that are applied in step 3. This allows us to rate each player based on the average of DLF players at their respective positions, rather than rating them against the average of all players at all positions like ESPN does.
Step 5
Players that have become arbitration eligible during this season will have their names highlighted in Yellow[/color]. They will only be highlighted at the position at which they qualify at for arbitration.
Step 6
After the regular season concludes, the 15 minute macro that Brad created will be ran, and these fields will be populated with up to date and accurate stats.
Step 7
Once the stats are populate, the sheets will be sorted from highest to lowest in the WAIVR column. If a highlighted arbitration eligible player is within the specified range for his position, he will be awarded the appropriate arbitration raise.
Extras[/i]
You will also notice on the sheets that Salary is also documented, so you can sort the sheets based on all kinds of information, like how many HR per $1 your player has provided. Also, there is a league baseline average tab, that lists what the average DLF player is being paid at each position, and what his baseline stats are for 2012.
I hope you all enjoy this addition to the league, because it has taken a lot of work. Speaking of that, I would like to personally thank Brad Z for his hard work as the programmer for this.
All comments, questions, concerns, babbling, whatever are welcome and Brad and I will do our best to explain it into the greatest amount of detail that is required.
We will share the most up to date WAIVR report as soon as we can fill the stats in and tweak the formatting to make it nice and pretty for everyone.
Enjoy
WAIVR is a project that Brad Z and I worked extensively on over the last month or so. It stands for Weighted Average and Individual Value Rating. This will be the official tool used to calculate arbitration raises every off season. The following is a primer on how it works, so study up, because it will be released within the next few days.
Step 1
It is linked directly to the master list on the DLF spreadsheet, so it only includes players that are getting paid in our league universe.
Step 2
It sorts these players by position, so players may be listed in more than one location. It uses ESPN eligibility requirements to apply the positions. So this is not for the 2012 in season positions, but those that the player will qualify for in 2013.
Step 3
It uploads stats from multiple sources and populates the fields for each respective player, with their current 2012 stats.
Step 4
I reversed engineered the ESPN Player Rater to find the formulas and weights that they use. I applied those to the stats that are applied in step 3. This allows us to rate each player based on the average of DLF players at their respective positions, rather than rating them against the average of all players at all positions like ESPN does.
Step 5
Players that have become arbitration eligible during this season will have their names highlighted in Yellow[/color]. They will only be highlighted at the position at which they qualify at for arbitration.
Step 6
After the regular season concludes, the 15 minute macro that Brad created will be ran, and these fields will be populated with up to date and accurate stats.
Step 7
Once the stats are populate, the sheets will be sorted from highest to lowest in the WAIVR column. If a highlighted arbitration eligible player is within the specified range for his position, he will be awarded the appropriate arbitration raise.
Extras[/i]
You will also notice on the sheets that Salary is also documented, so you can sort the sheets based on all kinds of information, like how many HR per $1 your player has provided. Also, there is a league baseline average tab, that lists what the average DLF player is being paid at each position, and what his baseline stats are for 2012.
I hope you all enjoy this addition to the league, because it has taken a lot of work. Speaking of that, I would like to personally thank Brad Z for his hard work as the programmer for this.
All comments, questions, concerns, babbling, whatever are welcome and Brad and I will do our best to explain it into the greatest amount of detail that is required.
We will share the most up to date WAIVR report as soon as we can fill the stats in and tweak the formatting to make it nice and pretty for everyone.
Enjoy
