Archive of SportingNews.com's old SOM Baseball forum

This is probably only going to matter to the spreadsheet geeks...

First, you determine hits. Then you determine slugging pct without triples (assuming every non-double or non-homer is a single). Next you subtract actual slugging from your derived slugging pct. Keeping in mind that you already assume one base gained, you take the slugging pct difference, multiply it by AB and divide it by 2. Simple.

Already Defined
AB
2B
HR
AVG
SLG

Determine Hits: H = AVG*AB
Determine SLG w/o Triples: SLG1 = ((H-2B-HR)+2B*2+HR*4)/AB
SLG difference (This isolates the SLG for triples only): SLG2 = SLG - SLG1
Determine Triples (t -- again, assuming one base has already been gained): 2t/AB = SLG2 or t = (SLG2*AB)/2

Now, a real world example
Joe Evans
AB: 596
2B: 20
HR: 0
AVG: .243
SLG: .388

(Round to the nearest whole number)

Hits: .243*596 = 145
SLG w/o Triples: ((145-20-0)+20*2+0*4)/596 = .277
SLG Difference: .388 - .277 = .111
Triples: (.111*596)/2 = 33

I'm sorry if I'm a little obtuse, but isn't it just easier to click on the player's name, pull up his card, and see how many triples he got?

Maybe I'm missing something here -- after all, if I were good with numbers, I would have become an accountant or an engineer. I wasn't, so I went to law school. (I was always very good with BS). :lol:

Very true. However, I wanted to keep a spreadsheet of all the players I've had. I copied the 'Your Team' roster and pasted into a spreadsheet. The roster, however, does not contain triples. It's a lot less time consuming to do this formula than to copy each player individually.

:shock: And I'm still using parchment and a quill pen!!!! I am DEFINITELY technologically challenged....