Any Excel, Baseball System Guys in Here?

[Boxslayer]

I've been working on a baseball system the past few days. I'm pretty sure how I will structure it. I want everything calculated with formulas, I want to use VLookups, I am also looking into using the webupdate feature, so that everytime a stat is updated onlineat ESPN for example, it updates that stat in my Excel sheet. Basically, I want everything automated to the point where I do basic minimal work.

Basically, I was looking to see if anyone has ever set one up before - sophisticated or basic. How long it took them, if they want to share any advice or tips. Maybe if they have a copy they wouldnt mind sharing on here so I can download it and take a look at how it was laid out.

Any help would be appreciated....

 

[honkee]

im working something now, im winning at about 55%, as long as im over 50% im good..

This is a long tedious process but once the spreadsheet is rolling its pie after that, i should have my system perfected by june

 

[CalvinTy]

Bumping for you. I myself finally toyed around with Vlookups this month when I was creating a file for the "Boys of Summer" contest.

I took some time reading online about Vlookups, creating & using naming ranges, and Pivottables. As usual, the time spent was mostly not on the actual structure of the spreadsheet but the formatting and double-checking I didn't make errors anywhere.

I can send that file to you (just reach me via email on my profile); about the webupdate feature, it fascinates me as I didn't think of that as a potential method to upload scores and/or stats without my feeding it manually.

At least in my file, after I simply tell my spreadsheet the final results of the games, all I had to do was to select which poster (in the contest) then select which team the poster chose as one of his picks, then the rest is populated by the Vlookup function. I used some IF functions to help me interpret whether a pick was a winner & a loser & the exact result of that pick.

Though, my formatting of the file leaves much to be desired since I have to do some exact steps every contest day to make the file continue to work correctly.

Just let me know if you e-mailed me or not (I check that email only a couple times A WEEK).

Cheers,

* CalvinTy

 

[Boxslayer]

Calvin, and honkee...that's good stuff there.

I'm definitely not interested in a system if I have to update a bunch of stuff. And I want the "system" to just basically take all of the things that I incorporate into my handicapping, and just do it for me, and spit out a Power Ranking for each team, updated daily automatically, and then I can determine value daily based on overall play, recent play, pitching, situational (L/R)

I'll have a power ranking for every team and how they fare vs. lefties and righties, and every pitcher and how they fare vs. lefties and righties.

Basically, I use the following things in my capping:

1. Overall standings (Is the team winning or losing)
2. Recent Play (Last 10, Last 7 days averages, etc)
3. Stats (Overall .BA, SLG%, etc)
4. Specific/Situational Stats (L/R)
5. Starting Pitcher, and his stats, and situational stuff
6. Bullpen

All of that can be updated automatically with Web Queries.

When you go to Excel, I open a new worksheet, I go to "Data>Import Data>New Web Query"

Navigate to ESPN in the web browser that pops up in excel.

And click in which table/chart you wish to import. ESPN for example can import the standings table, or go to stats, overallMLB stats, and then how teams do vs. lefties, righties, last 7 days, etc.

All of that goes in a worksheet called "web queries" for me. I have it set to updated those stats every 60 mins automatically and go grab the latest updates from espn. Then I reference those stats with formulas on a page called "caluclations"

Then I throw in some weighted formulas for how seriously I want to take each stat out of 100, and I have it spit out a final power ranking next to the team name on a different page.

As ESPN updates their site daily, my power rankings get updated daily.

The tedious part will be with 30 MLB teams, each team has 5 starting pitchers, and making a table and reference 150 pitchers and writing formulas for a power ranking for each pitcher (updated daily).

Thats basically what I am trying to do.

I will definitely e-mail to see how you use some of these functions, and once I get my system somewhat sophisticated and working, I wont mind sharing back.

Thanks.

 

[Gonzo]

Box, you may want to check with fhmesq44 and SSI. I know these guys do a lot of system plays. They may use excel to help generate their picks - I'm not sure. Also, I know Ace Ace had a spreadsheet put together but I'm sure it wasn't him that did it. However he could certainly point you to the guy that created it...Hope this helps. I check out a lot of your plays and I am interested to see what you come up with regarding your system spreadsheet...

 

[Boxslayer]

I need any help I can get right now. I had Tampa Bay and Baltimore yesterday and both blew 3 run leads late. Yay.

 

[BillsBets]

Box,

I am average with Excel but wouldnt mind assisting you to compile a spreadsheet. Let me know if your interested ill be on msn billy_the_kid4@hotmail.com

 

[fhmesq44]

Box,

I am more than happy to help you out, however, importing data from the internet into excel is beyond my capabilities. I do play systems and use a lot of excel in researching and determining the systems. However, I have always just cut and pasted the data from (usually) covers and then used formulas in excel to get me the information I want.

My baseball spreadsheets are set up like this:

<table x:str="" style="border-collapse: collapse; width: 729pt;" border="0" cellpadding="0" cellspacing="0" width="969"><col style="width: 37pt;" width="49"> <col style="width: 25pt;" width="33"> <col style="width: 66pt;" width="88"> <col style="width: 39pt;" width="52"> <col style="width: 66pt;" width="88"> <col style="width: 42pt;" width="56"> <col style="width: 26pt;" width="34"> <col style="width: 27pt;" width="36"> <col style="width: 25pt;" width="33"> <col style="width: 25pt;" width="33"> <col style="width: 11pt;" width="15"> <col style="width: 18pt;" width="24"> <col style="width: 18pt;" width="24"> <col style="width: 11pt;" width="14"> <col style="width: 14pt;" width="19"> <col style="width: 18pt;" width="24"> <col style="width: 14pt;" width="19"> <col style="width: 19pt;" width="25"> <col style="width: 18pt;" width="24"> <col style="width: 11pt;" width="15"> <col style="width: 32pt;" width="43"> <col style="width: 30pt;" width="40"> <col style="width: 11pt;" width="14"> <col style="width: 47pt;" width="63"> <col style="width: 35pt;" width="46"> <col style="width: 44pt;" width="58"> <tbody><tr style="height: 31.5pt;" height="42"> <td class="xl28" style="height: 31.5pt; width: 37pt;" height="42" width="49">Date</td> <td class="xl26" style="width: 25pt;" width="33">A/H</td> <td class="xl48" style="width: 66pt;" width="88">Team</td> <td class="xl48" style="width: 39pt;" width="52">Runs Scored</td> <td class="xl26" style="width: 66pt;" width="88">Opp</td> <td class="xl26" style="width: 42pt;" width="56">Runs Against</td> <td class="xl31" style="width: 26pt;" width="34">Line</td> <td class="xl27" style="width: 27pt;" width="36">O/U</td> <td class="xl31" style="width: 25pt;" width="33">O Line</td> <td class="xl27" style="width: 25pt;" width="33">U Line</td> <td class="xl34" style="width: 11pt;" width="15"> </td> <td class="xl30" style="width: 18pt;" width="24">HF</td> <td class="xl31" style="width: 18pt;" width="24">RD</td> <td class="xl34" style="width: 11pt;" width="14"> </td> <td class="xl40" style="width: 14pt;" width="19">L</td> <td class="xl40" style="width: 18pt;" width="24">HF</td> <td class="xl36" style="width: 14pt;" width="19">W</td> <td class="xl36" style="width: 19pt;" width="25">HD</td> <td class="xl36" style="width: 18pt;" width="24">RD</td> <td class="xl34" style="width: 11pt;" width="15"> </td> <td class="xl27" style="width: 32pt;" width="43">Lose by 5</td> <td class="xl38" style="width: 30pt;" width="40">Win by 5</td> <td class="xl34" style="width: 11pt;" width="14"> </td> <td class="xl36" style="width: 47pt;" width="63">8 or less OOU 4 game</td> <td class="xl44" style="width: 35pt;" width="46">9 UUO 4/5 game</td> <td class="xl30" style="width: 44pt;" width="58">9.5 OOU 5 game</td> </tr> <tr style="height: 10.5pt;" height="14"> <td class="xl43" style="height: 10.5pt; width: 37pt;" x:num="39173" height="14" width="49">1-Apr</td> <td class="xl42">A</td> <td class="xl47">NY Mets</td> <td class="xl33" x:num="">6</td> <td class="xl24">St. Louis</td> <td class="xl46" style="width: 42pt;" x:num="" width="56">1</td> <td class="xl49" style="width: 26pt;" x:num="" width="34">127</td> <td class="xl24" x:num="" align="right">8</td> <td class="xl47" x:num="" align="right">-105</td> <td class="xl24" x:num="" align="right">-115</td> <td class="xl35"> </td> <td class="xl29" x:str="" x:fmla="=IF(AND($B2="H",$G2<-129,$F2>$D2),"L",IF(AND($B2="h",$G2<-129,$F2<$D2),"W",IF(AND($B2="h",$G2<-129,$D2=$F2),"x","")))"> </td> <td class="xl32" x:fmla="=IF(AND($B2="a",$G2>109,$F2>$D2),"L",IF(AND($B2="a",$G2>109,$F2<$D2),"W",IF(AND($B2="a",$G2>109,$D2=$F2),"x","")))">W</td> <td class="xl35"> </td> <td class="xl41" x:str="" x:fmla="=IF(F2>D2,"L","")"> </td> <td class="xl41" x:str="" x:fmla="=IF(AND($B2="H",$G2<-109,$F2>$D2),"L",IF(AND($B2="h",$G2<-109,$F2<$D2),"W",IF(AND($B2="h",$G2<-109,$D2=$F2),"x","")))"> </td> <td class="xl37" x:fmla="=IF(F2<D2,"W","")">W</td> <td class="xl37" x:str="" x:fmla="=IF(AND($B2="H",$G2>99,$F2>$D2),"L",IF(AND($B2="h",$G2>99,$F2<$D2),"W",IF(AND($B2="h",$G2>99,$D2=$F2),"x","")))"> </td> <td class="xl37" x:fmla="=IF(AND($B2="a",$G2>99,$F2>$D2),"L",IF(AND($B2="a",$G2>99,$F2<$D2),"W",IF(AND($B2="a",$G2>99,$D2=$F2),"x","")))">W</td> <td class="xl35"> </td> <td class="xl25" x:str="" x:fmla="=IF(($F2-$D2>4.9),"x","")">
</td> <td class="xl39" x:fmla="=IF(($D2-$F2>4.9),"x","")">x</td> <td class="xl35"> </td> <td class="xl37" x:fmla="=IF(AND($H2<8.1,$F2+$D2<$H2,(OR($D2>0,$F2>0))),"U",IF(AND($H2<8.1,$F2+$D2>$H2),"O",IF(AND($H2<8.1,$H2>0.1,$F2+$D2=$H2),"P",IF(AND($H2<8.1,$H2>0.1,$D2=$F2),"x",""))))">U</td> <td class="xl45" x:str="" x:fmla="=IF(AND($H2=9,$F2+$D2<$H2,(OR($D2>0,$F2>0))),"U",IF(AND($H2=9,$F2+$D2>$H2),"O",IF(AND($H2=9,$H2>0.1,$F2+$D2=$H2),"P",IF(AND($H2=9,$H2>0.1,$D2=$F2),"x",""))))"> </td> <td class="xl29" x:str="" x:fmla="=IF(AND($H2=9.5,$F2+$D2<$H2,(OR($D2>0,$F2>0))),"U",IF(AND($H2=9.5,$F2+$D2>$H2),"O",IF(AND($H2=9.5,$H2>0.1,$F2+$D2=$H2),"P",IF(AND($H2=9.5,$H2>0.1,$D2=$F2),"x",""))))"> </td> </tr> </tbody></table>
I have to input the scores and lines and then everything after the U Line column is formulas and spits out my plays for the day. I could be handy for formulas, but I am worthless for importing.

 

[fhmesq44]

Here is an example of one of the formulas (the one in the 8 or less column)

=IF(AND($H3<8.1,$F3+$D3<$H3,(OR($D3>0,$F3>0))),"U",IF(AND($H3<8.1,$F3+$D3>$H3),"O",IF(AND($H3<8.1,$H3>0.1,$F3+$D3=$H3),"P",IF(AND($H3<8.1,$H3>0.1,$D3=$F3),"x",""))))

 

[Boxslayer]

I feel like I may be putting something extremely sophisticated together. This certainly isnt some overnight project.

I will probably end up having anywhere from 7-10 worksheets with an extreme amount of data, one page that caluclates it all, and one page that is user friendly to look at it with power rankings generated from the other pages, updated automatically daily.

I want every team to have an overall power ranking, overall vs. lefty pitchers, and overall vs. righty pitchers. Those will be the 3 main power rankings. Then I want every pitcher to have an overall power ranking, power ranking vs. predominanly lefty hitters, and righty so each pitcher has 3 main power rankings.

I will start off by using multiple stats to come up with an "overall" pitcher ranking, such as W/L, ERA and WHIP averaged out into a ranking. Same vs. lefties. Same vs. righties. And a recent performance power ranking. I will start by weighing each one 25% of the pitchers total power ranking. Then do the same vs. lefties and righty hitters.

Then all of that the same for each team. Stats will be W/L, BA, OBP, and SLG overall, vs. lefties and righties. Then recent performance. Etc and weigh each one an equal amount.

Then start tweaking which ones I feel should be weighted a little more heavily.

Let me setup some of the basics so you guys can see what I am talking about here, and I will drop you guys an email with the spreadsheet I come up with.

Everything will be automatic. EVERYTHING updated daily using web queries, which honestly arent that difficult - and should automatically identify value.

Then a bettor would look at the potential value plays and if he agreed with his capping (umpires, weather, and trends), or the "human edge" then it would become a play.

 

[fhmesq44]

I don't think coming up with formulas would be that difficult.

 

[Boxslayer]

I don't think coming up with formulas would be that difficult.

No it wont be. It's just gonna be so many things tied together, a lot of work will be double checking the loose ends.

 

[BillsBets]

Box,

I would be willing to help input all the info from espn if you wanted. Let me know

 

[Boxslayer]

Box,

I would be willing to help input all the info from espn if you wanted. Let me know

Bills, it's gonna be done with web query. There will be no input. When ESPN is updated, my spreadsheet and rankings will automatically update.

 

[BillsBets]

ya i mean I can setup the fields for you just tell me what you want

 

[Boxslayer]

ya i mean I can setup the fields for you just tell me what you want

You may be able to help with formulas, but the web query is literally 2 clicks of the mouse. You just navigate to the website and click on which info you want on the little excel tab and thats it, it imports it all.

I want to setup a basic template first so everyone can see how I lay out out as an example and then it will be easier for anyone to add.

I'll keep you posted.

 

[BillsBets]

Ya please do I am really interested in learning more about capping and I think this is a great opportunity for me to improve

thanks

 

[NickFantana]

Box.
You should stop by pops thread and see if any of them can help you. That guy knows excel like nobody else and he is all about automation. I'm definitely interested in the idea of a daily updating power rankings for each team. Any way I can help, let me know, but I think you stand your best chance running this by pops and his crew. Otherwise, let me know if I can help out. By the way, I've been following all season long and I like your capping technique and your opinion on plays, always respect it.

 

[Boxslayer]

I've "finished" the hitting/overall/last 7 days section.

The power rankings take into account win %, runs scored, overall (BA, OBP, SLG), last 7 days (BA, OBP, SLG).

For vs. lefty/vs. righty....it is based on the averaged difference between (BA, OBP, SLG) vs. lefties compared to normal average and (BA, OBP, SLG) vs. righties compared to normal average.

So it factors who the best overall team is based on overall performance, who the best team is the past 7 days, and who the best team is vs. each situation (L/R).

I havent even gotten to pitchers yet. Right now I have it, you plug in L or R into a column and it will autmatically calculate that teams power ranking vs. a lefty or righty. So, I want to get it to the point where you type in the pitchers last name, and L or R, and it will look all of that up, and factor that into the ranking so you can use it on a daily basis and all you would have to input is who is pitching and if he is a lefty or righty.

I also want to eventually turn the power rankings into a formula that will give me a line and as ACE ACE says "line off".

Here are how the power rankings came out vs. RHP:

<TABLE style="WIDTH: 148pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=197 border=0 x:str><COLGROUP><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width=92><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 79pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=105 height=17 x:num="74.5625">74.56</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 69pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=92>Cleveland</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>63.00</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Boston</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="61.708333333333336">61.71</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">NY Mets</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="61.083333333333336">61.08</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Detroit</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="60.020833333333336">60.02</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">NY Yankees</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="57.666666666666664">57.67</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Chicago Cubs</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="57.625">57.63</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">LA Angels</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="56.166666666666664">56.17</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Atlanta</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="55.416666666666664">55.42</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Oakland</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="54.875">54.88</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Chicago Sox</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="54.270833333333336">54.27</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Minnesota</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="54.083333333333336">54.08</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Philadelphia</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>53.75</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Tampa Bay</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="52.541666666666664">52.54</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">St. Louis</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="52.104166666666664">52.10</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Texas</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="51.458333333333336">51.46</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">LA Dodgers</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="50.875">50.88</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Arizona</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="50.604166666666664">50.60</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">San Diego</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="50.541666666666664">50.54</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Florida</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="49.5625">49.56</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Kansas City</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="49.375">49.38</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Seattle</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="49.333333333333336">49.33</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Toronto</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="49.3125">49.31</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Milwaukee</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="45.833333333333336">45.83</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Pittsburgh</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="43.395833333333336">43.40</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Cincinnati</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="42.395833333333336">42.40</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">San Francisco</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="40.604166666666664">40.60</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Baltimore</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="40.145833333333336">40.15</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Colorado</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="38.895833333333336">38.90</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Houston</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="28.291666666666668">28.29</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Washington</TD></TR></TBODY></TABLE>

vs. LHP:

<TABLE style="WIDTH: 148pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=197 border=0 x:str><COLGROUP><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width=92><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 79pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=105 height=17 x:num="76.541666666666671">76.54</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 69pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=92>NY Mets</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="72.166666666666671">72.17</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Boston</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="68.5625">68.56</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Cleveland</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="67.416666666666671">67.42</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Detroit</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="65.833333333333329">65.83</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Toronto</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="61.916666666666664">61.92</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Oakland</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="61.4375">61.44</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">San Diego</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="60.770833333333336">60.77</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Texas</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="60.125">60.13</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">LA Angels</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>59.25</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Tampa Bay</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="58.833333333333336">58.83</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Atlanta</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="57.375">57.38</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Seattle</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="57.041666666666664">57.04</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Florida</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="55.625">55.63</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">LA Dodgers</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="55.1875">55.19</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">NY Yankees</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="52.5625">52.56</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Houston</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>51.00</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Chicago Cubs</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="49.479166666666664">49.48</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Milwaukee</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>49.00</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Pittsburgh</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>48.25</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Philadelphia</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="47.895833333333336">47.90</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Kansas City</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="47.708333333333336">47.71</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Chicago Sox</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="47.708333333333336">47.71</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">St. Louis</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="47.208333333333336">47.21</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Arizona</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="44.104166666666664">44.10</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Minnesota</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="43.104166666666664">43.10</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Baltimore</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="42.395833333333336">42.40</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Cincinnati</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="41.229166666666664">41.23</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">San Francisco</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="34.3125">34.31</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Colorado</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num="32.625">32.63</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Washington</TD></TR></TBODY></TABLE>

 

[Boxslayer]

Here is the excel sheet so far which should grab the latest stats from espn.com, and spit them into the tables when you open it automatically, and that will update the rankings in real time.

This is a serious work in progress. I am aware some weighted averages may be off. I am starting with the baseline first.