Ratings book and Download???

I was looking at the current ratings disk to see how some of my keeper league players will perform. Posey has 100.7 TB's vs. LHP. I have the ratings disks back to 2006 so I went back to see if anyone else had broken the century mark. Nope. Not even close. The best card ever vs. LHP is coming soon.

Here are the best vs. L and R in the past.

2006
vs. L - Alex Escobar - 79.6 (inj 6)
vs. R - Pujols - 75.4

2007
vs. L - Chipper - 73.8
vs. R - Ar. Ramirez - 84.8

2008
vs. L - Pujols -79.3
vs. R - Pujols - 63.9

2009
vs. L - J. Upton - 84.8
vs. R - Howard - 71.4

2010
vs. L - V. Martinez - 91.8
vs. R - Hamilton - 80.5

2011
vs. L - Craig - 80.3 - (inj. 5)
vs. R - Ike Davis - 71.6 (inj. 5)

"For instance I will set the On Base count column to chge to red font for everyone over a 35 on base count, makes it reall easy to find viable leadoff hitters"


For us chiropractors that have no idea of what the hell we're doing in Excel...

How do you do this?



And FTR, I love the download, but the ratings book makes GREAT bathroom reading material.

Vis,

I'll see if I can step you through it.

First select the column you want to highlight, I used OBP in my example before, so I'll do that here. Obviously you have to do it twice, once for each side, but there is a short cut to doing the second side.

Anyway, we'll do OB vs RHP, so select that colum by the letter at the top of the column, I believe it's column P.

Next, depending on what version of EXCEL you are running ( and I hope you are runnning office 2007 as that's what I'm running) on the home tab there is a menu on the top of the spread sheet for conditional formating, click it. It brings up a drop down, click New Rule on the drop down.

On the next menu click under Select a rule type click the second line that reads:

Format Only Cells that contain

Now in the lower menu that reads Edit the Rule Description go to the second box, click the drop down arrow and select

Greater than or equal to:

Now click on the empty box and choose your value, we'll say 35.

Now click the format button, this calls up the Font format menu and allows you to change the font type, size, color, bold, underline, etc, basically anything you can do to the font. I usually selct Bold and change the color to red. Once you've made your changes Click okay on the bottom of the font editting box, which brings you back to the rule edit box.

Click ok on the bottom of that box and your rule will now go into effect.

Please note, Text is valued greated than numbers for some weird reson, so the title of the column will change to. Once you've done it for the RH side you can easily copy and paste it to the LH side without setting up the whole thing step by step.

To copy from the RH side to the left or vice-versa, first select the colum with the rule you want to copy, then RIGHT click with your mouse and select COPY from the menu. Now select the column you want to copy the rule to then RIGHT click on that column. Select Paste SPECIAL and when the menu comes up, select Formats and then hit OK and you will paste the conditional formatting from one column to another.

If you screw it up you can hit the undo button and take things back to where you made the mistake.

You can do this for as many columns, rows, or even individual cells you want and can change the values. For pitchers you'd likely want less than or equal too.

Hope this helps.

"For instance I will set the On Base count column to chge to red font for everyone over a 35 on base count, makes it reall easy to find viable leadoff hitters"


For us chiropractors that have no idea of what the hell we're doing in Excel...

How do you do this?



And FTR, I love the download, but the ratings book makes GREAT bathroom reading material.

Vis,


I often use fill option on the spreadsheet and use a color coding system
top 24 Ob green next 24 lt green etc
players with a lot of green are worth green
I'll see if I can step you through it.

First select the colum you want to highlight, I use OBP so I'll do that. Obviously you have to do it twice, once for each side.

Anyway, we'll do OB vs RHP, so select that colum by the letter at the top of the column, I believe it's column P.

Next, depending on what version of EXCEL you are running ( and I hope you are runnning office 2007) on the home tab there is a menu on the top of the sprwead sheet for conditional formating, click it. It brings up a drop down, click New Rule on the drop down.

Next, On the next menu click under Select a rule type click the second line that reads:

Format Only Cells that contain

Now in the lower menu that reads Edit the Rule Description go to the second box, click the drop down arrow and select Great than or equal to:

Now click on the empty box and choose your value, we'll say 35.

Now click the format button, this calls up the Font format menu and allows you to change the font type, size, color, bold, underline, etc, basically anything you can do to the font. I usually selct Bold and change the color to red. Once you've made your changes Click okay on the bottom of the font editting box, which brings you back to the rule edit box.
Click ok on the bottom of that bo and your rule will now go into effect.

Please note, Text is valued greated than numbers for some weird reson, so the title of the column will change to. Once you've done it for the RH side you can easily copy and paste it to the LH side without setting up the whole thing step by step.

To copy from the RH side to the left, first select the colum with the rule you want to copy, then RIGHT click with your mouse and select COPY from the menu. Now select the column you want to copy the rule to then RIGHT click on that column. Select Paste SPECIAL and when the menu comes up, select Formats and then hit OK and you will paste the conditional formattin from one column to another.

If you screw it up you can hit the undo button and take things back to where you made the mistake.

Hope this helps.

"For instance I will set the On Base count column to chge to red font for everyone over a 35 on base count, makes it reall easy to find viable leadoff hitters"


For us chiropractors that have no idea of what the hell we're doing in Excel...

How do you do this?



And FTR, I love the download, but the ratings book makes GREAT bathroom reading material.

Vis,




First select the colum you want to highlight, I use OBP so I'll do that. Obviously you have to do it twice, once for each side.

Anyway, we'll do OB vs RHP, so select that colum by the letter at the top of the column, I believe it's column P.

Next, depending on what version of EXCEL you are running ( and I hope you are runnning office 2007) on the home tab there is a menu on the top of the sprwead sheet for conditional formating, click it. It brings up a drop down, click New Rule on the drop down.

Next, On the next menu click under Select a rule type click the second line that reads:

Format Only Cells that contain

Now in the lower menu that reads Edit the Rule Description go to the second box, click the drop down arrow and select Great than or equal to:

Now click on the empty box and choose your value, we'll say 35.

Now click the format button, this calls up the Font format menu and allows you to change the font type, size, color, bold, underline, etc, basically anything you can do to the font. I usually selct Bold and change the color to red. Once you've made your changes Click okay on the bottom of the font editting box, which brings you back to the rule edit box.
Click ok on the bottom of that bo and your rule will now go into effect.

Please note, Text is valued greated than numbers for some weird reson, so the title of the column will change to. Once you've done it for the RH side you can easily copy and paste it to the LH side without setting up the whole thing step by step.

To copy from the RH side to the left, first select the colum with the rule you want to copy, then RIGHT click with your mouse and select COPY from the menu. Now select the column you want to copy the rule to then RIGHT click on that column. Select Paste SPECIAL and when the menu comes up, select Formats and then hit OK and you will paste the conditional formattin from one column to another.

If you screw it up you can hit the undo button and take things back to where you made the mistake.

Hope this helps.

This is what GORM was trying to say, but he put it in the quote


Vis,


I often use fill option on the spreadsheet and use a color coding system
top 24 Ob green next 24 lt green etc
players with a lot of green are worth green

which can also be done by conditional formating, you can chnage text color, cell fill color just about anything to make the infoamtion you want to highlight stand out.

When someone gets their ratings book will they please tell us what injury number Giancarlo Stanton and David Ortiz are.

My guess is a 4 for Ortiz and a 3 for Stanton. But I'm hoping for less than that.

When someone gets their ratings book will they please tell us what injury number Giancarlo Stanton and David Ortiz are.

My guess is a 4 for Ortiz and a 3 for Stanton. But I'm hoping for less than that.

Be glad to.

Hasn't come in the mail yet.

Anyone get there's yet???

When someone gets their ratings book will they please tell us what injury number Giancarlo Stanton and David Ortiz are.

My guess is a 4 for Ortiz and a 3 for Stanton. But I'm hoping for less than that.

Be glad to.

Hasn't come in the mail yet.

Anyone get there's yet???

Appreciate it. I sent for one too. But not yet.

When someone gets their ratings book will they please tell us what injury number Giancarlo Stanton and David Ortiz are.

My guess is a 4 for Ortiz and a 3 for Stanton. But I'm hoping for less than that.

Book came today:

Injury ratings and what they mean:

6 = injured on a roll of 7
5 = injured on a roll of 6 or 8
4 = 5 or 9
3 = 4 or 10
2 = 3 or 11 ( almost all catchers have this roll)
1 = 2 or 12 ( almost all regular players have this roll)
0 = No injury roll

Ortiz is a 4
Stanton is a 3


There is only 1 zero in the whole set, Adam Jones

When someone gets their ratings book will they please tell us what injury number Giancarlo Stanton and David Ortiz are.

My guess is a 4 for Ortiz and a 3 for Stanton. But I'm hoping for less than that.

Book came today:

Injury ratings and what they mean:

6 = injured on a roll of 7
5 = injured on a roll of 6 or 8
4 = 5 or 9
3 = 4 or 10
2 = 3 or 11 ( almost all catchers have this roll)
1 = 2 or 12 ( almost all regular players have this roll)
0 = No injury roll

Ortiz is a 4
Stanton is a 3

There is only 1 zero in the whole set, Adam Jones

That hurts. Thanks Niners. And good luck withy your football team...assuming you're a San Francisco fan.

I have Napoli in a keeper league and he's missed 35 of my first 85 games. He's a "3" injury. Nine HRs in 50 games and my ballpark is Rangers stadium. http://onlinegames.strat-o-matic.com/team/815217

I hope Stanton has a luckier fate as a 3 for the next SOM season.

Fred,

No problem, and yeah, you could say I'm a fan . I'm as nervous as a longtailed cat in a room full of rocking chairs about the game tomorrow.

BTW, Napoli, in that keepr is a 4 FWIW.