Made my own ratings calculator

[Scott]

Re: Made my own ratings calculator

Scott & Crew,

Sorry to do this to you, but I added Jeezy's Pitch ratings, came up with my own control rating for the generic type of pitch, did fielding stats, and pitcher batting. I put it all in the spreadsheet. It took forever to calculate, so I put all the teams in, and made a ratings sheet with no formulas for anybody that wants to run with it. Ask questions if needed.

Is there anyway I can get this but with the forumulas? That way I can input minor league players...

[spboden]

Re: Made my own ratings calculator

scott i am assuming the new patch issue will not effect what you are doing? it sounds like it is caused from schedule and franchise already in place, but some thought maybe something with the rosters.....your thoughts or input.....thanks again.

[Scott]

scott i am assuming the new patch issue will not effect what you are doing? it sounds like it is caused from schedule and franchise already in place, but some thought maybe something with the rosters.....your thoughts or input.....thanks again.

Correct. Doesn't effect it at all.


Sent from my iPhone using Tapatalk

[Matz21Moabit]

Re: Made my own ratings calculator

best calculator out there imho !!! thanks !!! do working on a pitcher calculator ?

[DeathMetal]

Re: Made my own ratings calculator

Are you talking about mine? Heh it's hard to tell, this thread has been hijacked so badly . No I'm not working on a pitcher calculator. I don't have any plans to either, sorry.

[Matz21Moabit]

Re: Made my own ratings calculator

yeah, i´m talking about yours ! great work !!! to bad that there isn´t a good pitching calculator out there

[King Simba]

Re: Made my own ratings calculator

What are the formulas exactly? Can you post them please kind sir.

[DeathMetal]

Re: Made my own ratings calculator

Sure, I'll paste the excel formulas I used.

Contact:
=IF(B42=0,0,IF(OR(B44<0.25,B43<100),SUM(B44*900)/4,IF(B44<0.32,SUM(B44*1000)/4,SUM(B44*1100)/4)))

Cell B42 is hits.
Cell B43 is at bats.
Cell B44 is average.

I basically used three different numbers in the formula based on the players stats.

If average is less than .250 or if at bats are less than 100 I used SUM(B44*900)/4

If average is less than .320 (but over .250) I used SUM(B44*1000)/4

If average is equal to or over .320 I used SUM(B44*1100)/4

Power:
=IF(B53=0,0,(IF(B54<100,90-B55,IF(B55<=15,110-B55,IF(B55<=25,100-B55,90-B55)))))

Cell B53 is home runs
Cell B54 is at bats
Cell B55 is AB/HR

If at bats less than 100 I used 90-B55

If AB/HR less than or equal to 15 I used 110-B55

If AB/HR less than or equal to 25 100-B55

So for AB/HR of 25 or greater it's 90-B55

Vision:
=IF(B66=0,0,(42-B67)/0.355)

Cell B65 is Strikeouts
Cell B66 is at bats
Cell B67 is =(B65/B66) * 100

The first part is just for error checking, if no at bats return a zero. The actual formula is (42-B67)/0.355.

Discipline:
=IF(B73=0,0,100+((17-B74)/-0.213))

Cell B72 is walks
Cell B73 is at bats
Cell B74 is =(B72/B73) * 100

The formula is 100+((17-B74)/-0.213)

Durability:
=(B78/162)*100

Cell B78 is games played.

This is just (games played / 162) * 100

Clutch:
=IF(C36=0,0,IF(OR(B37<0.25,B36<100),SUM(B37*900)/4,IF(B37<0.32,SUM(B37*1000)/4,SUM(B37*1100)/4)))

Cell B36 is at bats with RISP
Cell C36 is hits with RISP
Cell B37 is average with RISP

This is basically the same as the contact formula.
If average with RISP is less than .250 or if at bats with RISP are less than 100 I used SUM(B44*900)/4

If average with RISP is less than .320 (but over .250) I used SUM(B44*1000)/4

If average with RISP is equal to or over .320 I used SUM(B44*1100)/4