Power Pros Forum

A community-run forum for Power Pros
It is currently Thu Mar 28, 2024 7:27 pm

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 25 posts ]  Go to page Previous  1, 2
Author Message
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Tue Oct 24, 2017 10:53 pm 
Power Pro Legend
Power Pro Legend
User avatar

Joined: Mon Aug 01, 2011 8:29 pm
Posts: 11487
Location: Skaia
Favorite Team: Rangers
Console '07: Nintendo Wii
Console '08: Nintendo Wii
Favorite Japanese title: (PS3) Jikkyou Powerful Pro Yakyuu 2012
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 that log's dead too- i mean on hiatus (yes that one too) (seriously all of them now lol)

NAPOLI FOR MVP

"All people are good for something. The important thing is finding what." - Tom

post count doesn't matter

BrewersFuzz wrote:
PEDs wrote:
i think we banned him cause he was an idiot
glad i never got banned for that


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Sat Oct 28, 2017 10:11 pm 
AAA Starter
AAA Starter
User avatar

Joined: Sun Apr 19, 2015 9:57 am
Posts: 60
Location: NY
Favorite Team: Astros
Console '07: Nintendo Wii
Console '08: Nintendo Wii
Favorite Japanese title: (Vita) Jikkyou Powerful Pro Yakyuu 2012
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.

_________________
jag123jg wrote:
I'll help, and partially cover for AOW:

Horns, that rapid drum tapping thing, my n-word, n-word, drugs, weed, guns, money, bitches, pussy, pussy ass bitches, bitch ass n-word, shawty, saying the same thing over and over to fill up space, simple sentences that have no context, saying the same thing over and over to fill up space, blat blat, pussy shit, porsche


jag123jg wrote:
Are you guys actually *(censored)* stupid? Learn to wait for a 3-5 game sample size and then read stats before making players, dumbasses


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Sun Oct 29, 2017 12:29 pm 
Power Pro Legend
Power Pro Legend
User avatar

Joined: Mon Aug 01, 2011 8:29 pm
Posts: 11487
Location: Skaia
Favorite Team: Rangers
Console '07: Nintendo Wii
Console '08: Nintendo Wii
Favorite Japanese title: (PS3) Jikkyou Powerful Pro Yakyuu 2012
UPDATE 5: Formulas for Good Pickoff and VS Lefty 1/5, 2/4 have been updated.

_________________
yeah that log's dead too- i mean on hiatus (yes that one too) (seriously all of them now lol)

NAPOLI FOR MVP

"All people are good for something. The important thing is finding what." - Tom

post count doesn't matter

BrewersFuzz wrote:
PEDs wrote:
i think we banned him cause he was an idiot
glad i never got banned for that


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Tue Oct 31, 2017 9:50 am 
All-Star
All-Star
User avatar

Joined: Mon Jan 05, 2009 7:21 pm
Posts: 1223
Location: Australia
Favorite Team: Orioles
Console '07: Sony PS2
Console '08: Sony PS2
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.


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Tue Oct 31, 2017 4:12 pm 
Power Pro Legend
Power Pro Legend
User avatar

Joined: Fri Aug 07, 2015 7:15 pm
Posts: 2367
Location: 南ジャージー
Favorite Team: Angels
Console '07: Nintendo Wii
Console '08: Nintendo Wii
Favorite Japanese title: (Wii) Jikkyou Powerful Major League 2009
i haven't done anything with max/min, but I would love to see your spreadsheet and/or your formulas

_________________
Dynasties That Never Were
Dynasties That Never Were MLBPP Stats
2011 San Francisco Giants Log
Cleveland Browns : The Race For Last Place
2018 MLBPP Update


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Wed Nov 01, 2017 5:56 pm 
Power Pro Legend
Power Pro Legend
User avatar

Joined: Fri Aug 07, 2015 7:15 pm
Posts: 2367
Location: 南ジャージー
Favorite Team: Angels
Console '07: Nintendo Wii
Console '08: Nintendo Wii
Favorite Japanese title: (Wii) Jikkyou Powerful Major League 2009
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.

_________________
Dynasties That Never Were
Dynasties That Never Were MLBPP Stats
2011 San Francisco Giants Log
Cleveland Browns : The Race For Last Place
2018 MLBPP Update


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Wed Nov 01, 2017 6:01 pm 
Wiki Contributor
Wiki Contributor
User avatar

Joined: Tue Jun 05, 2012 4:34 pm
Posts: 8771
Location: On the bump
Favorite Team: Athletics
Console '07: Wii and PS2
Console '08: Wii and PS2
Favorite Japanese title: (PS3) Jikkyou Powerful Pro Yakyuu 2012
I don't think that really relates to arm strength tho. That would be more along the lines of Throwing 4/2 id say

_________________
Fantasty

~~~~~~~~~~~~~~~~~~~~~

2017 and 2018 MLBPPW Fantasy Football League Champion


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Wed Nov 01, 2017 6:02 pm 
Power Pro Legend
Power Pro Legend
User avatar

Joined: Fri Aug 07, 2015 7:15 pm
Posts: 2367
Location: 南ジャージー
Favorite Team: Angels
Console '07: Nintendo Wii
Console '08: Nintendo Wii
Favorite Japanese title: (Wii) Jikkyou Powerful Major League 2009
yeah I will probably redo the ARM STR when Fans Scouting comes out, but it does say how well they throw.
And accurately too.

_________________
Dynasties That Never Were
Dynasties That Never Were MLBPP Stats
2011 San Francisco Giants Log
Cleveland Browns : The Race For Last Place
2018 MLBPP Update


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Thu Jan 18, 2018 7:54 pm 
All-Star
All-Star
User avatar

Joined: Mon Jan 05, 2009 7:21 pm
Posts: 1223
Location: Australia
Favorite Team: Orioles
Console '07: Sony PS2
Console '08: Sony PS2
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


Top
 Profile  
 
 Post subject: Re: 2018 Roster Update FORMULAS
PostPosted: Fri Aug 09, 2019 9:34 pm 
Rookie
Rookie
User avatar

Joined: Mon Mar 20, 2017 4:05 am
Posts: 24
Favorite Team: Giants
Console '07: Nintendo Wii
Console '08: Sony PS2
Favorite Japanese title: Don't Own
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 25 posts ]  Go to page Previous  1, 2

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 37 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group