LeMandria's PT Spreadsheets & KleineBiere's OPSCalculator - Page 2

<Pion> · 03-26-2020, 01:34 PM

Quote:

Originally Posted by <Pion>

Anyone have a link to the formulas used to calculate the stat line like is done in the OPS Calculator?

Found it!

Jeff1787 · 03-26-2020, 01:38 PM

Quote:

Originally Posted by <Pion>

Found it!

Where??

<Pion> · 03-26-2020, 01:46 PM

Working on translating the formulas...

<Pion> · 03-26-2020, 08:04 PM

Ab - 550
1b - if(con>50,1.089*(con*2-100)/2+146,11.08*(con/5)+35)
2b - 0.95*((gap*2 - 125)/25*7+34.5)
3b - 0.05*((gap*2 - 125)/25*7+34.5)
hr - if(hr>51,(hr*2-125)/25*8.5+24.5,2*hr*0.15818182)
bb - if(eye>50, ((eye)-1)*2-50,eye)
hb - 1
pa - ab+bb+hb

RoteLaterne · 03-27-2020, 01:17 AM

Is the spreadsheet protected with pw?

Unable to add lines.

Jeff1787 · 03-27-2020, 10:16 AM

Quote:

Originally Posted by <Pion>

Ab - 550
1b - if(con>50,1.089*(con*2-100)/2+146,11.08*(con/5)+35)
2b - 0.95*((gap*2 - 125)/25*7+34.5)
3b - 0.05*((gap*2 - 125)/25*7+34.5)
hr - if(hr>51,(hr*2-125)/25*8.5+24.5,2*hr*0.15818182)
bb - if(eye>50, ((eye)-1)*2-50,eye)
hb - 1
pa - ab+bb+hb

To get to the OPS, don't you just double each category (Contact, Gap, etc) minus one.

<Pion> · 03-27-2020, 10:52 AM

OPS = (H+BB+HBP)/AB + (H+2B+3B*2+HR*3)/AB

OPS is OBP plus SLG

<Pion> · 03-27-2020, 10:58 AM

Quote:

Originally Posted by RoteLaterne

Is the spreadsheet protected with pw?

Unable to add lines.

Yes it is

Jeff1787 · 03-27-2020, 11:34 AM

Quote:

Originally Posted by <Pion>

OPS = (H+BB+HBP)/AB + (H+2B+3B*2+HR*3)/AB

OPS is OBP plus SLG

I was referring to the OPS calculator by KleineBiere in an above post. It seems that when entering the numbers (Contact, Gap etc) in the calculator, each number is doubled and then minus one?

<Pion> · 03-27-2020, 12:24 PM

Quote:

Originally Posted by Jeff1787

I was referring to the OPS calculator by KleineBiere in an above post. It seems that when entering the numbers (Contact, Gap etc) in the calculator, each number is doubled and then minus one?

The numbers that are stored internally versus what we see is as you say, doubled then minus one.

StatMan22 · 03-27-2020, 12:42 PM

Potentially unpopular opinion, but y'all shouldn't just be handing out these resources and formulas. People can compile/calculate it themselves if they want to, lazy bums!

Orion · 03-27-2020, 01:38 PM

Thanks for enforcing other people's morality. Any other commandments for us?

smales72 · 03-27-2020, 02:07 PM

Statman is the reply not to make as a first post.

macacks · 03-27-2020, 06:04 PM

I started a new thread about this but figured I would put it here.

Has anybody figured out a simple way to get a complete list of your players and rating. I know you can ‘write to disk’ for you active and reserve roster but that limits you to your 200 cards.

Thx

<Pion> · 03-27-2020, 06:45 PM

Would be nice if there was a simple way to get everyone. I took the long way around it and did an organized activate/deactivate of every player until every single one was active for a file creation.

macacks · 03-27-2020, 07:37 PM

Quote:

Originally Posted by <Pion>

Would be nice if there was a simple way to get everyone. I took the long way around it and did an organized activate/deactivate of every player until every single one was active for a file creation.

Yes. that works until you open a bunch of packs and then decide if you do it all again or manually enter the new cars...lol

One select all radio button would improve things dramatically and one filter by CARD or Rating would make this very doable...

<Pion> · 03-27-2020, 07:47 PM

Quote:

Originally Posted by macacks

Yes. that works until you open a bunch of packs and then decide if you do it all again or manually enter the new cars...lol

One select all radio button would improve things dramatically and one filter by CARD or Rating would make this very doable...

When I open packs, I clear out my reserve list so that all the players opened go to the reserve list. As long as you don't open too many and fill up the reserve list, its fine.

RoteLaterne · 03-28-2020, 01:57 AM

Quote:

Originally Posted by KleineBiere

visible ratings*2-1

The "K" rating does not have any impact on OPS.
Try to change it - OPS stays put.

Hm, can this be correct?
Maybe so, bc it does not matter if it is a flyout, groundout or strikeout.

Can some stat pro confirm?

Charlatan · 03-28-2020, 06:01 AM

Quote:

Originally Posted by RoteLaterne

The "K" rating does not have any impact on OPS.
Try to change it - OPS stays put.

Hm, can this be correct?
Maybe so, bc it does not matter if it is a flyout, groundout or strikeout.

Can some stat pro confirm?

OPS stands for Online Base Percentage (OBP) plus Slugging (SLG). OBP is how often the player gets on base, and slugging let you know the player's batting productivity. In other words, it's how much he gets on base plus the power in his hits.

If you think about it, the type of out he makes is not a factor in this calculation (since it never shows either calculation - OBP is only about outcomes that result in the batter getting on base). Groundout, strikeout, pop fly - doesn't matter, he got out.

So you're correct - a player's OBP is not affected by his strikeout rate.

03-27-2020, 12:42 PM	#31
StatMan22 Minors (Single A) Join Date: Sep 2014 Location: Glen Ellyn, IL Posts: 77	Potentially unpopular opinion, but y'all shouldn't just be handing out these resources and formulas. People can compile/calculate it themselves if they want to, lazy bums! __________________

03-27-2020, 01:38 PM	#32
Orion Major Leagues Join Date: Dec 2019 Posts: 300	Thanks for enforcing other people's morality. Any other commandments for us? __________________

03-27-2020, 06:04 PM	#34
macacks Minors (Triple A) Join Date: Aug 2019 Location: Canada Posts: 285	I started a new thread about this but figured I would put it here. Has anybody figured out a simple way to get a complete list of your players and rating. I know you can ‘write to disk’ for you active and reserve roster but that limits you to your 200 cards. Thx __________________

03-26-2020, 01:46 PM	#23
<Pion> All Star Starter Join Date: Mar 2006 Posts: 1,428	Working on translating the formulas...

03-26-2020, 08:04 PM	#24
<Pion> All Star Starter Join Date: Mar 2006 Posts: 1,428	Ab - 550 1b - if(con>50,1.089(con2-100)/2+146,11.08(con/5)+35) 2b - 0.95((gap2 - 125)/257+34.5) 3b - 0.05((gap2 - 125)/257+34.5) hr - if(hr>51,(hr2-125)/258.5+24.5,2hr0.15818182) bb - if(eye>50, ((eye)-1)2-50,eye) hb - 1 pa - ab+bb+hb

03-27-2020, 01:17 AM	#25
RoteLaterne Major Leagues Join Date: Jun 2009 Location: Germany Posts: 387	Is the spreadsheet protected with pw? Unable to add lines.

03-27-2020, 10:52 AM	#27
<Pion> All Star Starter Join Date: Mar 2006 Posts: 1,428	OPS = (H+BB+HBP)/AB + (H+2B+3B2+HR3)/AB OPS is OBP plus SLG

03-27-2020, 02:07 PM	#33
smales72 Minors (Double A) Join Date: Mar 2020 Posts: 105	Statman is the reply not to make as a first post.

03-27-2020, 06:45 PM	#35
<Pion> All Star Starter Join Date: Mar 2006 Posts: 1,428	Would be nice if there was a simple way to get everyone. I took the long way around it and did an organized activate/deactivate of every player until every single one was active for a file creation.