| Power Pros Forum https://www.mlbppworld.com/ |
|
| 2018 Roster Update FORMULAS https://www.mlbppworld.com/viewtopic.php?f=11&t=10750 |
Page 2 of 2 |
| Author: | AgentP [ Tue Oct 24, 2017 10:53 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
PEDs wrote: Gonna start updating the formulas on the spreadsheet I made a while back. (https://docs.google.com/spreadsheets/d/ ... sp=sharing) whoa this is really cool!! could be super helpful if we were able to use this sort of a system instead of calculating each player's stuff by hand 
|
|
| Author: | PEDs [ Sat Oct 28, 2017 10:11 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
AgentP wrote: PEDs wrote: Gonna start updating the formulas on the spreadsheet I made a while back. (https://docs.google.com/spreadsheets/d/ ... sp=sharing) whoa this is really cool!! could be super helpful if we were able to use this sort of a system instead of calculating each player's stuff by hand Yeah. Im glad i put this together last year cause it saves a lot of time between going back and forth between a bunch of tabs to get the data. Also it helps having a place to keep the ratings if you want to work on updating when you are away from your wii/ps2. So I have currently updated all the formulas for the ratings and limited abilities that ive put in so far. My one issue is fielding for catchers. Since we dont have an actually made out formula for that I wont be able to put it in the spreadsheet. |
|
| Author: | AgentP [ Sun Oct 29, 2017 12:29 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
UPDATE 5: Formulas for Good Pickoff and VS Lefty 1/5, 2/4 have been updated. |
|
| Author: | robhallett [ Tue Oct 31, 2017 9:50 am ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
Check this out http://www.retrosheet.org/Research/Rosc ... System.pdf This is what I use for catchers as it rates them in categories that decide a good catcher, calling a game, passed balls, errors, throwing out runners etc. I've got a spreadsheet with the formulas pre filled and all it needs is the data put in. On another note the speed calculation which would be a good tool. Are we using any ranges for max/min run speed for each position? As most of the faster players seem to be CF, SS and 2B. |
|
| Author: | Kungfupandacam [ Tue Oct 31, 2017 4:12 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
i haven't done anything with max/min, but I would love to see your spreadsheet and/or your formulas |
|
| Author: | Kungfupandacam [ Wed Nov 01, 2017 5:56 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
So I found a new rating that works for arm str so it's (Assists-(5*Throwing Errors))/(IP) You can do it by who's highest gets 15 ARM STR. Works pretty well as it shows a lot with accuracy and how many throws they get. |
|
| Author: | ZeroGibson13 [ Wed Nov 01, 2017 6:01 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
I don't think that really relates to arm strength tho. That would be more along the lines of Throwing 4/2 id say |
|
| Author: | Kungfupandacam [ Wed Nov 01, 2017 6:02 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
yeah I will probably redo the ARM STR when Fans Scouting comes out, but it does say how well they throw. And accurately too. |
|
| Author: | robhallett [ Thu Jan 18, 2018 7:54 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
Another thing if it’s not known already, baseball savant has heat maps for batters when finding hot spots/ cold spots etc. Then just look at the avgs heat map |
|
| Author: | willthethrill [ Fri Aug 09, 2019 9:34 pm ] |
| Post subject: | Re: 2018 Roster Update FORMULAS |
This might be a dumb question, but how do I retain the working formulas after downloading a Google Spreadsheet and reading it in OpenOffice? I know it's something simple involving commas or spaces. |
|
| Page 2 of 2 | All times are UTC - 5 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|