I thought I would make it available for people to try and also because I am looking for any feedback or alternative formulas etc.
I am especially interested in any suggestions for formulas for Arm Strength and Accuracy, as I have been unable to think of any, based on the current set of stats that I use.
The calculator is worked by simply selecting the player from the drop down menu on the HOME tab.
If you want to see the formulas I have used, they are listed on the Calcs tab and down the right hand side, I have also listed alternative formulas that could be used instead.
As I am a total newbie to roster making, I can't promise it will be 100% accurate but it has been completed to the best of my abilities.
03/11/12 --- v3 fixes an error with the pitcher k/9 rating ---
05/11/12 --- changed drag bunt formula - doesn't affect rating, just inputs "-" when appropriate ---
17/11/12 --- v4 This fixes the 2012 Tampa Bay Rays pitcher stats with RISP omission ---
17/11/12 --- pitcher H/9 and HR/9 formula changes ---
23/11/12 --- v5 new fielding ability formula and changes to H/9 AND HR/9 ---
02/12/12 --- Have updated the file to include missing players and all players now have detailed personal information ---
21/02/13 --- New version of calculator that is compatible with older versions of Word and Open Office now available ---
03/03/13 --- Bahnzo's formulas added and a formula fix ---
06/03/13 --- v6 new formulas for Base Running Ability and Aggressiveness, Discipline, Bunting and modifications to Catcher Blocking and Reaction ---
17/03/13 --- "user input" tab added ---
06/08/13 --- New version of the calculator available for download but unfortunately, due to its size (14mb) I am unable to upload it.
30/08/13 --- Comapatabilty version for use with older versions of Excel and Open Office now available ---
03/09/13 --- create a year calculator available for download ---
08/10/13 --- Updated to include all the 2013 regular season stats, bios etc. ---
For those with Excel 2010 and later
======================
Calculator:
http://www.jamesagrant.webspace.virg...ator_2013.xlsx
Create a year calculator:
http://www.jamesagrant.webspace.virg...stom_year.xlsx
For those with OpenOffice or older versions of Excel etc
===================================
Calculator:
http://www.jamesagrant.webspace.virg...atability.xlsx
Create a year calculator:
http://www.jamesagrant.webspace.virg...atability.xlsx
The calculator is designed for use with Excel 2010 and later, so there may be some anomalies with the "compatability version" due to trying to work out averages for example, when there are errors etc.
Comment