Help w/Creating Stats Cheat Sheet

[jparker2112]

can we get this stickied? the more we learn about new and/or older micro-stats the more it will enhance the game!

[ALB123]

I haven't declared this finished, but when I do, I would gladly post the Excel file so you could configure things more to your liking. My goal wasn't to put every possible statistic into the cheat sheet. In fact, I will probably slim this current cheat down a bit when I'm done with the initial cheat sheet.

It all fits on a single sheet in landscape mode. I may change this too so that hitting stats will be on one side of a page and pitching will be on the other. That way you could trim off the excess and have a much smaller sheet. If anyone has any comments about the values I've used thus far, please let me know and I'll fix it. Oh, I also need to put the stats in a good viewing order so the eye doesn't have to go up and down the list looking for things.

[AJFO]

Originally Posted by ALB123

I haven't declared this finished, but when I do, I would gladly post the Excel file so you could configure things more to your liking. My goal wasn't to put every possible statistic into the cheat sheet. In fact, I will probably slim this current cheat down a bit when I'm done with the initial cheat sheet.

It all fits on a single sheet in landscape mode. I may change this too so that hitting stats will be on one side of a page and pitching will be on the other. That way you could trim off the excess and have a much smaller sheet. If anyone has any comments about the values I've used thus far, please let me know and I'll fix it. Oh, I also need to put the stats in a good viewing order so the eye doesn't have to go up and down the list looking for things.

To be honest, I think it looks beautiful as is. Much, much, much appreciated. This will be an immense help to anyone inclined to actually measure up a player's stats rather than just look at their ratings.

[jimmysthebestcop]

I would make 1 small suggestion. Row colors need alternating shades. Much easier to follow that way

[ALB123]

Originally Posted by jimmysthebestcop

I would make 1 small suggestion. Row colors need alternating shades. Much easier to follow that way

Thanks for the suggestion. I'm having a bit of difficulty understanding what you mean by "row colors need alternating shades". Right now each column is colored, so you'd always know that any number in the red column is "Awesome!" and everything colored blue means "Terrible!"...So if you could make my tiny brain understand, I'd love to try it out.

[jimmysthebestcop]

Originally Posted by ALB123

Thanks for the suggestion. I'm having a bit of difficulty understanding what you mean by "row colors need alternating shades". Right now each column is colored, so you'd always know that any number in the red column is "Awesome!" and everything colored blue means "Terrible!"...So if you could make my tiny brain understand, I'd love to try it out.

Usually when looking at huge spreadsheets rows would alternate in the color shade. So for say your red column it would alternate between red and a shade of red every other row. In your case you would have to assign color to each cell since your columns are color coordinated as well.

Here is an example of shading its row based so you would need to do it for every cell, kind of a pain but it will improve readability.

Either way fabulous job!!!!!

edit
maybe its not a good idea since you are column based. but generally it helps to distinguish which line a person is looking at. but with each column a color it might look messy. not sure. i would need to view examples of both.

[ALB123]

Originally Posted by jimmysthebestcop

Usually when looking at huge spreadsheets rows would alternate in the color shade. So for say your red column it would alternate between red and a shade of red every other row. In your case you would have to assign color to each cell since your columns are color coordinated as well.

Here is an example of shading its row based so you would need to do it for every cell, kind of a pain but it will improve readability.

Either way fabulous job!!!!!

edit
maybe its not a good idea since you are column based. but generally it helps to distinguish which line a person is looking at. but with each column a color it might look messy. not sure. i would need to view examples of both.

Ahhhh...Yes... I can't believe I was unable to comprehend your first explanation. That's definitely a cool way to do it too. I have no problem with maybe having two or three different presentations of the data. I just added this to my to-do list. Your example looks so professional. I like it.

[jimmysthebestcop]

I am super professional. I googled excel rows lol

[CBeisbol]

Originally Posted by ALB123

I haven't declared this finished, but when I do, I would gladly post the Excel file so you could configure things more to your liking. My goal wasn't to put every possible statistic into the cheat sheet. In fact, I will probably slim this current cheat down a bit when I'm done with the initial cheat sheet.

This is great!

A couple of things, though

First, remember that what's good or terrible, is highly dependent on the league context.

For example, wOBA.
in 1894 a .379 wOBA would have been league average
in 1875 a .261 wOBA would have been league average

in 2000 a a .341 wOBA would have been league average
in 2010 a .310 wOBA would have been league average

That's why wRC+ is useful. It adjusts for changes in the league, and changes in park, etc.

Second, with WAR. 0.0 WAR isn't average. 2.0 WAR is average. 0 WAR is replacement level.
A team with all 2 WAR players (well, starters) would win about 81 games
A team with all 0 WAR players would win about 48 games.

A better way to look at it would be something like
0-.5 WAR AAAA
.6-1.5 WAR Bench
1.6-2.5 WAR Starter
2.6-4 WAR Good Starter
4-5 WAR All-Star
5-7 WAR Star
7+ WAR MVP Candidate

Keep in mind with WAR, though, that it's dependent on playing time. A player who gets 1 WAR in 100 PA performed a lot differently than a player who got 1 WAR in 700 PA.

This matters for individual players - like a bench player vs a starter, or a reliever vs a starter.

It also matters for leagues. In one of my sims I have a 100 game schedule. One hundred games is a lot less than 162. Players don't play enough in that league to get 7+ WAR (usually). So, the scale has to be adjusted.

Also, I think you have a type in your OBP line

[ALB123]

Originally Posted by CBeisbol

This is great!

A couple of things, though

First, remember that what's good or terrible, is highly dependent on the league context.

For example, wOBA.
in 1894 a .379 wOBA would have been league average
in 1875 a .261 wOBA would have been league average

in 2000 a a .341 wOBA would have been league average
in 2010 a .310 wOBA would have been league average

That's why wRC+ is useful. It adjusts for changes in the league, and changes in park, etc.

Second, with WAR. 0.0 WAR isn't average. 2.0 WAR is average. 0 WAR is replacement level.
A team with all 2 WAR players (well, starters) would win about 81 games
A team with all 0 WAR players would win about 48 games.

A better way to look at it would be something like
0-.5 WAR AAAA
.6-1.5 WAR Bench
1.6-2.5 WAR Starter
2.6-4 WAR Good Starter
4-5 WAR All-Star
5-7 WAR Star
7+ WAR MVP Candidate

Keep in mind with WAR, though, that it's dependent on playing time. A player who gets 1 WAR in 100 PA performed a lot differently than a player who got 1 WAR in 700 PA.

This matters for individual players - like a bench player vs a starter, or a reliever vs a starter.

It also matters for leagues. In one of my sims I have a 100 game schedule. One hundred games is a lot less than 162. Players don't play enough in that league to get 7+ WAR (usually). So, the scale has to be adjusted.

Also, I think you have a type in your OBP line

Thanks for the feedback. When I first started this, I had a feeling that what I was producing was for a particular set of circumstances. I didn't quite know what yet, but you've articulated it very well. Obviously, I was only thinking of a 162 game schedule. 90% of my data came from Fangraphs and I mindlessly copied them into the 7 columns for each stat. In fact, I used 7 columns specifically because Fangraphs used 7 columns.

Unfortunately, I am possibly the least skilled Excel user in North America. Otherwise, I may have been able to make something that takes into consideration the points you have laid out, like a 100 game season. I am planning on posting the Excel file soon, so I suppose people can easily modify any of the numbers I have used.

Oh, you were saying that I have a typo in my OBP line? I can't figure out what has been misspelled. Could you point out to me exactly what is incorrect? I would greatly appreciate that.

[Bub13]

Originally Posted by ALB123

Oh, you were saying that I have a typo in my OBP line? I can't figure out what has been misspelled. Could you point out to me exactly what is incorrect? I would greatly appreciate that.

It's the numbers, I believe. They go from .290 to .300 back to .290, going from left to right.

[CBeisbol]

Originally Posted by ALB123

Thanks for the feedback. When I first started this, I had a feeling that what I was producing was for a particular set of circumstances. I didn't quite know what yet, but you've articulated it very well. Obviously, I was only thinking of a 162 game schedule. 90% of my data came from Fangraphs and I mindlessly copied them into the 7 columns for each stat. In fact, I used 7 columns specifically because Fangraphs used 7 columns.

Unfortunately, I am possibly the least skilled Excel user in North America. Otherwise, I may have been able to make something that takes into consideration the points you have laid out, like a 100 game season. I am planning on posting the Excel file soon, so I suppose people can easily modify any of the numbers I have used.

Oh, you were saying that I have a typo in my OBP line? I can't figure out what has been misspelled. Could you point out to me exactly what is incorrect? I would greatly appreciate that.

In your OBP line you have, from left to right: .290, .300, .290, .320
The second .290 should probably be .310 or something

The most important one to change is the WAR. 0 WAR is not average under any circumstance (well, if you had like a 10 game season -maybe).




As for the other stats, if you're playing mostly in the current era, they should be...not too far off.

After you get a feel for them, or before, you can download your stats into excel then you can see what average is for your league. Then using some excel tricks and a little bit of knowledge to can see what's, good, bad, great, terrible, etc

[ALB123]

Originally Posted by Bub13

It's the numbers, I believe. They go from .290 to .300 back to .290, going from left to right.

OMG. Thank you!! I can't tell you how many times I looked that over, staring and staring and I could not find it. LOL

Originally Posted by CBeisbol

In your OBP line you have, from left to right: .290, .300, .290, .320
The second .290 should probably be .310 or something

The most important one to change is the WAR. 0 WAR is not average under any circumstance (well, if you had like a 10 game season -maybe).




As for the other stats, if you're playing mostly in the current era, they should be...not too far off.

After you get a feel for them, or before, you can download your stats into excel then you can see what average is for your league. Then using some excel tricks and a little bit of knowledge to can see what's, good, bad, great, terrible, etc

Thanks, CBeisbol! I'll make the adjustment to WAR as soon as I have a chance. As far as importing data from OOTP and using some Excel tricks. Yeah...I'm not certain that's gonna happen. I am TERRIBLE with Excel. I probably shouldn't even be allowed to use it, I'm that bad. LOL But who knows? Maybe I'll consult the supremely wise Googles! We shall see.

Again... Thanks to you both!!

[ALB123]

I placed the Excel file & a .PNG file in the original 1st post in the EDIT section. I've been busy, unfortunately, so while I will be making changes, I decided to put up v1 as it is.

Enjoy

[jparker2112]

This! Is! Awesome!!!

[ALB123]

I updated the original post with a slightly different colored Cheat Sheet. Minor changes.

[r0nster]

old school stats work for me more than the new school stuff as that is all greek to me. Am glad I do not need the new school stuff. Glad it works for you guys.

[garion333]

Wow, just came across this and it's way better than the one I threw together a few years back. I'd probably remove the BABIP from batting, but otherwise this is about as complete as I've seen. Nice job!

[ALB123]

Originally Posted by garion333

Wow, just came across this and it's way better than the one I threw together a few years back. I'd probably remove the BABIP from batting, but otherwise, this is about as complete as I've seen. Nice job!

Glad you like it.

I don't know if you noticed that I included a link to download the Excel file I created this cheat sheet in. So, feel free to download the file and remove anything you aren't interested in or change the colors or anything you'd like.

[GTAltman]

Clearly, a labor of love!!!
I think maybe for v2 would be the use of Conditional Formatting the columns, so that a player with 7 WAR would be RED and a player with 0 WAR BLUE

This way you can see, simply by colors who is best, better, good, worse and bad.

Either way, fantastic job

Originally Posted by ALB123

Glad you like it.

I don't know if you noticed that I included a link to download the Excel file I created this cheat sheet in. So, feel free to download the file and remove anything you aren't interested in or change the colors or anything you'd like.