Sports database design

**mathdotcom** · 07-14-12, 11:10 PM

This is like asking, When you drive do you turn left or right?

It fukkin depends what you're trying to do

**357vegas** · 07-14-12, 11:22 PM

Not really but i always see you are a hard ass.

Home pitcher era = 3.49 / Away pitcher era = 6.49 / Home_era_dif +3.00 / Away_era_dif -3.00

If I want to do analysis on the difference between the two teams on any given stat. Wouldn't I want both teams on one record then?

**MonkeyF0cker** · 07-14-12, 11:30 PM

You're on page 3 of "How to Create a Table in a Database for Dummies."

Keep reading.

**357vegas** · 07-14-12, 11:32 PM

Funny guy..... stick to your day job.

**mathdotcom** · 07-14-12, 11:50 PM

Originally posted by 357vegas

Not really but i always see you are a hard ass.

Home pitcher era = 3.49 / Away pitcher era = 6.49 / Home_era_dif +3.00 / Away_era_dif -3.00

If I want to do analysis on the difference between the two teams on any given stat. Wouldn't I want both teams on one record then?

Maybe... it depends what you want to do...

**mathdotcom** · 07-14-12, 11:50 PM

Originally posted by 357vegas

Funny guy..... stick to your day job.

Funny... this is my day job. What's yours ??

**357vegas** · 07-15-12, 12:22 AM

What i want to do is be able to query on anyone of those 4 field from the example above. Unless someone has a better idea. Im all ears.
Any ideas is much much appreciated.

**MonkeyF0cker** · 07-15-12, 12:22 AM

Nobody can tell you how you should design your database without knowing everything that you're attempting to do. And then they might as well just create it for you. So, like I said, keep reading. Otherwise, hire someone.

**MonkeyF0cker** · 07-15-12, 12:26 AM

If your "database" consists of four fields, you probably don't need a database to begin with.

**357vegas** · 07-15-12, 12:28 AM

Such a friendly group. So this is the hang out for programmer who can't handicap.... Amazing. Monkey... you ever ask anyone questions? or were you born a savant.

**357vegas** · 07-15-12, 12:29 AM

My excel worksheet has 168 fields. I just used 4 has an example.

**357vegas** · 07-15-12, 12:31 AM

For every stat field, I want to know the difference between the two teams per my example above.

**MonkeyF0cker** · 07-15-12, 12:48 AM

Originally posted by 357vegas

Such a friendly group. So this is the hang out for programmer who can't handicap.... Amazing. Monkey... you ever ask anyone questions? or were you born a savant.

If I had a question, there are probably only a few people here that could answer it.

**357vegas** · 07-15-12, 12:50 AM

[TABLE="width: 833"]
[TR]
[TD="width: 65, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 78, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl116, width: 321, bgcolor: transparent, colspan: 5"]BASKETBALL WORKSHEET[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]SCORE = [/TD]
[TD="class: xl109, bgcolor: transparent"]80[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl166, bgcolor: transparent, colspan: 3"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]g67[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]SCORE = [/TD]
[TD="class: xl109, bgcolor: transparent"]89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl123, bgcolor: transparent"]MASTER[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]DATE =[/TD]
[TD="class: xl165, bgcolor: transparent, colspan: 2"]2/16/2012[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]2.78[/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl68, bgcolor: transparent"]DATE =[/TD]
[TD="class: xl165, bgcolor: transparent, colspan: 2"]2/16/2012[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]2.78[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl116, bgcolor: transparent"][/TD]
[TD="class: xl102, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl116, bgcolor: transparent"][/TD]
[TD="class: xl102, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl169, bgcolor: transparent, colspan: 2"]BOSTON[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: transparent"]8.0[/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl162, bgcolor: transparent, colspan: 2"]CHICAGO[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: transparent"]-8.0[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl112, bgcolor: transparent"]15[/TD]
[TD="class: xl113, bgcolor: transparent"]13[/TD]
[TD="class: xl82, bgcolor: transparent"]0.54[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"]7.5[/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]24[/TD]
[TD="class: xl113, bgcolor: transparent"]7[/TD]
[TD="class: xl82, bgcolor: transparent"]0.77[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"]-7.5[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]4[/TD]
[TD="class: xl113, bgcolor: transparent"]5[/TD]
[TD="class: xl142, bgcolor: #C4D79B"]0.44[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl112, bgcolor: transparent"]10[/TD]
[TD="class: xl113, bgcolor: transparent"]1[/TD]
[TD="class: xl142, bgcolor: #C4D79B"]0.91[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]2[/TD]
[TD="class: xl113, bgcolor: transparent"]3[/TD]
[TD="class: xl143, bgcolor: #C4D79B"]0.40[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]4[/TD]
[TD="class: xl113, bgcolor: transparent"]1[/TD]
[TD="class: xl143, bgcolor: #C4D79B"]0.80[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl116, bgcolor: transparent, colspan: 3"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl116, bgcolor: transparent, colspan: 3"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl114, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl149, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]29[/TD]
[TD="class: xl113, bgcolor: transparent"]35[/TD]
[TD="class: xl82, bgcolor: transparent"]0.45[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]35[/TD]
[TD="class: xl113, bgcolor: transparent"]29[/TD]
[TD="class: xl82, bgcolor: transparent"]0.55[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]5[/TD]
[TD="class: xl113, bgcolor: transparent"]5[/TD]
[TD="class: xl124, bgcolor: transparent"]0.50[/TD]
[TD="class: xl66, bgcolor: transparent"]=[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]5[/TD]
[TD="class: xl113, bgcolor: transparent"]5[/TD]
[TD="class: xl124, bgcolor: transparent"]0.50[/TD]
[TD="class: xl66, bgcolor: transparent"]=[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]9[/TD]
[TD="class: xl113, bgcolor: transparent"]21[/TD]
[TD="class: xl124, bgcolor: transparent"]0.30[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]21[/TD]
[TD="class: xl113, bgcolor: transparent"]9[/TD]
[TD="class: xl124, bgcolor: transparent"]0.70[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]1[/TD]
[TD="class: xl113, bgcolor: transparent"]3[/TD]
[TD="class: xl74, bgcolor: transparent"]0.25[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl113, bgcolor: transparent"]3[/TD]
[TD="class: xl113, bgcolor: transparent"]1[/TD]
[TD="class: xl74, bgcolor: transparent"]0.75[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]89.69[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl108, bgcolor: transparent"]-8.05[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl108, bgcolor: transparent"]90.55[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"]81.43[/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]97.74[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl108, bgcolor: transparent"]8.05[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl108, bgcolor: transparent"]98.45[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"]96.09[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]ADV[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"]ADV[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]87.45[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl108, bgcolor: transparent"]-1.20[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl108, bgcolor: transparent"]-7.90[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl108, bgcolor: transparent"]-14.65[/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]88.65[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl108, bgcolor: transparent"]1.20[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl108, bgcolor: transparent"]7.90[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl108, bgcolor: transparent"]14.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]LN_ADV[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"]LN_ADV[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]90.20[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl108, bgcolor: transparent"]-7.60[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl125, bgcolor: #C4D79B"]-0.4[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl126, bgcolor: #C4D79B"]-7.15[/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]97.80[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl108, bgcolor: transparent"]7.60[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl125, bgcolor: #C4D79B"]0.4[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl126, bgcolor: #C4D79B"]7.15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]87.10[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl108, bgcolor: transparent"]-0.90[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl164, bgcolor: #C4D79B, colspan: 3"]DECLINING[/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]88.00[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl108, bgcolor: transparent"]0.90[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl164, bgcolor: #C4D79B, colspan: 3"]IMPROVING[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]3.10[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl108, bgcolor: transparent"]-6.70[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]9.80[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl108, bgcolor: transparent"]6.70[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl106, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"]3.10[/TD]
[TD="class: xl74, bgcolor: transparent"]87.45[/TD]
[TD="class: xl80, bgcolor: transparent"]100.52[/TD]
[TD="class: xl93, bgcolor: yellow"]-9.97[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl75, bgcolor: transparent"]-2.47[/TD]
[TD="class: xl66, bgcolor: transparent"]MAYBE[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl74, bgcolor: transparent"]9.80[/TD]
[TD="class: xl74, bgcolor: transparent"]88.65[/TD]
[TD="class: xl80, bgcolor: transparent"]86.91[/TD]
[TD="class: xl93, bgcolor: yellow"]11.54[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl81, bgcolor: transparent"]4.04[/TD]
[TD="class: xl66, bgcolor: transparent"]MAYBE[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl94, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl154, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl154, bgcolor: transparent, colspan: 2"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]02-15-12[/TD]
[TD="class: xl87, bgcolor: transparent"]H[/TD]
[TD="class: xl87, bgcolor: transparent"]L[/TD]
[TD="class: xl78, bgcolor: transparent"]88[/TD]
[TD="class: xl78, bgcolor: transparent"]98[/TD]
[TD="class: xl152, bgcolor: transparent, colspan: 2"]DETROIT[/TD]
[TD="class: xl110, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl84, bgcolor: transparent"]02-14-12[/TD]
[TD="class: xl87, bgcolor: transparent"]H[/TD]
[TD="class: xl87, bgcolor: transparent"]W[/TD]
[TD="class: xl78, bgcolor: transparent"]121[/TD]
[TD="class: xl78, bgcolor: transparent"]115[/TD]
[TD="class: xl152, bgcolor: transparent, colspan: 2"]SACRAMENTO[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]02-12-12[/TD]
[TD="class: xl87, bgcolor: transparent"]H[/TD]
[TD="class: xl87, bgcolor: transparent"]W[/TD]
[TD="class: xl78, bgcolor: transparent"]95[/TD]
[TD="class: xl78, bgcolor: transparent"]91[/TD]
[TD="class: xl152, bgcolor: transparent, colspan: 2"]CHICAGO[/TD]
[TD="class: xl110, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl84, bgcolor: transparent"]02-12-12[/TD]
[TD="class: xl87, bgcolor: transparent"]A[/TD]
[TD="class: xl87, bgcolor: transparent"]L[/TD]
[TD="class: xl78, bgcolor: transparent"]91[/TD]
[TD="class: xl78, bgcolor: transparent"]95[/TD]
[TD="class: xl152, bgcolor: transparent, colspan: 2"]BOSTON[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]02-10-12[/TD]
[TD="class: xl87, bgcolor: transparent"]A[/TD]
[TD="class: xl87, bgcolor: transparent"]L[/TD]
[TD="class: xl78, bgcolor: transparent"]74[/TD]
[TD="class: xl78, bgcolor: transparent"]86[/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 2"]TORONTO[/TD]
[TD="class: xl110, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl84, bgcolor: transparent"]02-10-12[/TD]
[TD="class: xl87, bgcolor: transparent"]A[/TD]
[TD="class: xl87, bgcolor: transparent"]W[/TD]
[TD="class: xl78, bgcolor: transparent"]95[/TD]
[TD="class: xl78, bgcolor: transparent"]64[/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 2"]CHARLOTTE[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: transparent"]257[/TD]
[TD="class: xl78, bgcolor: transparent"]275[/TD]
[TD="class: xl75, bgcolor: transparent"]-18.00[/TD]
[TD="class: xl79, bgcolor: transparent"]-6.00[/TD]
[TD="class: xl111, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: transparent"]307[/TD]
[TD="class: xl78, bgcolor: transparent"]274[/TD]
[TD="class: xl75, bgcolor: transparent"]33.00[/TD]
[TD="class: xl76, bgcolor: transparent"]11.00[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl116, bgcolor: transparent, colspan: 3"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl116, bgcolor: transparent, colspan: 3"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]83.03[/TD]
[TD="class: xl81, bgcolor: transparent"]-2.78[/TD]
[TD="class: xl81, bgcolor: transparent"]80.25[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl82, bgcolor: transparent"]85.39[/TD]
[TD="class: xl81, bgcolor: transparent"]-2.78[/TD]
[TD="class: xl81, bgcolor: transparent"]82.61[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent"]97.74[/TD]
[TD="class: xl81, bgcolor: transparent"]-2.78[/TD]
[TD="class: xl81, bgcolor: transparent"]94.96[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl81, bgcolor: transparent"]89.69[/TD]
[TD="class: xl81, bgcolor: transparent"]2.78[/TD]
[TD="class: xl81, bgcolor: transparent"]92.47[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"]84.31[/TD]
[TD="class: xl74, bgcolor: transparent"]2.78[/TD]
[TD="class: xl81, bgcolor: transparent"]87.09[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl74, bgcolor: transparent"]77.40[/TD]
[TD="class: xl74, bgcolor: transparent"]2.78[/TD]
[TD="class: xl81, bgcolor: transparent"]80.18[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]262.30[/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]87.43[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl108, bgcolor: transparent"]2.35[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]255.26[/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]85.09[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl108, bgcolor: transparent"]-2.35[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl85, bgcolor: transparent"]-6.00[/TD]
[TD="class: xl86, bgcolor: transparent"]87.43[/TD]
[TD="class: xl74, bgcolor: transparent"]100.52[/TD]
[TD="class: xl93, bgcolor: yellow"]-19.09[/TD]
[TD="class: xl66, bgcolor: transparent"]--[/TD]
[TD="class: xl75, bgcolor: transparent"]-11.59[/TD]
[TD="class: xl140, bgcolor: #C4D79B"]DON’T[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl74, bgcolor: transparent"]11.00[/TD]
[TD="class: xl86, bgcolor: transparent"]85.09[/TD]
[TD="class: xl74, bgcolor: transparent"]86.91[/TD]
[TD="class: xl93, bgcolor: yellow"]9.18[/TD]
[TD="class: xl66, bgcolor: transparent"]+[/TD]
[TD="class: xl81, bgcolor: transparent"]1.68[/TD]
[TD="class: xl66, bgcolor: transparent"]MAYBE[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: transparent"]************[/TD]
[TD="class: xl89, bgcolor: transparent"]************[/TD]
[TD="class: xl90, bgcolor: transparent"]************[/TD]
[TD="class: xl89, bgcolor: transparent"]************[/TD]
[TD="class: xl70, bgcolor: transparent"]************[/TD]
[TD="bgcolor: transparent"]************[/TD]
[TD="bgcolor: transparent, colspan: 2"]************[/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl89, bgcolor: transparent"]************[/TD]
[TD="class: xl89, bgcolor: transparent"]************[/TD]
[TD="class: xl89, bgcolor: transparent"]************[/TD]
[TD="class: xl89, bgcolor: transparent"]************[/TD]
[TD="class: xl70, bgcolor: transparent"]************[/TD]
[TD="class: xl89, bgcolor: transparent"]************[/TD]
[TD="class: xl89, bgcolor: transparent"]************[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl161, bgcolor: transparent, colspan: 3"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: transparent"][/TD]
[TD="class: xl161, bgcolor: transparent, colspan: 3"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl154, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl154, bgcolor: transparent, colspan: 2"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]02-10-12[/TD]
[TD="class: xl87, bgcolor: transparent"]A[/TD]
[TD="class: xl87, bgcolor: transparent"]L[/TD]
[TD="class: xl78, bgcolor: transparent"]74[/TD]
[TD="class: xl78, bgcolor: transparent"]86[/TD]
[TD="class: xl152, bgcolor: transparent, colspan: 2"]TORONTO[/TD]
[TD="class: xl110, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl84, bgcolor: transparent"]02-14-12[/TD]
[TD="class: xl87, bgcolor: transparent"]H[/TD]
[TD="class: xl87, bgcolor: transparent"]W[/TD]
[TD="class: xl78, bgcolor: transparent"]121[/TD]
[TD="class: xl78, bgcolor: transparent"]115[/TD]
[TD="class: xl152, bgcolor: transparent, colspan: 2"]SACRAMENTO[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]01-31-12[/TD]
[TD="class: xl87, bgcolor: transparent"]A[/TD]
[TD="class: xl87, bgcolor: transparent"]W[/TD]
[TD="class: xl78, bgcolor: transparent"]93[/TD]
[TD="class: xl78, bgcolor: transparent"]90[/TD]
[TD="class: xl152, bgcolor: transparent, colspan: 2"]CLEVELAND[/TD]
[TD="class: xl110, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]![/TD]
[TD="class: xl84, bgcolor: transparent"]01-27-12[/TD]
[TD="class: xl87, bgcolor: transparent"]H[/TD]
[TD="class: xl87, bgcolor: transparent"]W[/TD]
[TD=

**357vegas** · 07-15-12, 12:54 AM

I believe you. I was just being a smart ass. You have great skills. Im just trying to learn to get ideas on the right way to move forward.

**MonkeyF0cker** · 07-15-12, 01:01 AM

Originally posted by 357vegas

For every stat field, I want to know the difference between the two teams per my example above.

Then, my answer is maybe. It doesn't matter unless efficiency and scaling and much less future work are important to you. And then it's still maybe since I don't know what you plan to do in the future with your data beyond your current project.

Make sense?

**MonkeyF0cker** · 07-15-12, 01:05 AM

The only way to learn is by failing - especially when it comes to programming and databases.

Trial and error is the best teacher.

**357vegas** · 07-15-12, 01:09 AM

Yes it does. That's my whole point. Spend less time with data entry and more time handicapping. Automate as much as possible.

**yak merchant** · 07-15-12, 01:38 AM

The mods/regulars here try to be as unhelpful as humanly possible. While it does "Depend" on quite a few things, and you can build it a 1000 different ways from one big ass table to over normalized where you have tables all over the place. Personally for baseball I don't keep summarized stats (i.e. ERA) and build everything dynamically from the raw data later down the road, but what you are asking for is likely what I do in my football databases. So while I'm not 100% sure what you are doing, in some of my databases I do keep both teams stats on the same record, but you would still have two records. i.e.

Team, Opp, HomeAway, Team ERA, OPP ERA, Advantage

HOU, STL, H, 4.32, 3.52, -0.8

STL, HOU, A, 3.52, 4.32, 0.8

Not applicable for all situations but works in many situations where you want a quick way to query without having to try to figure out the opponent from a separate record.

**Ganchrow** · 07-15-12, 03:15 AM

I think the issue is that without knowing your use cases a thorough response to your post would only bring up more questions than answers. Use cases logically dictate data relationships and accurate and parsimonious modelling of data relationships is really the essence of traditional DB design.

DB design in general is a complex topic and unless you're looking to learn more about about it for professional or academic reasons, my quick and dirty advice would be to proceed in the simplest, most intuitive manner possible. Ostensibly this would probably mean a small number of database tables with a large number of columns and with absolutely no heed whatsoever paid to the evils of data redundancy in any of its incatiomns.

What I've recommended is more or less the opposite of a "normalized" structure, which many consider essential (in one of its several forms) to a well-designed database schema. Although slightly dated in parts of the real world, normalization is a core concept of database design and an essential early research topic for a motivated beginner looking to delve into database theory.

Still, for a non-programmer working alone and for his sole benefit within the GUI confines of MS Access or a high-level mySQL front end, there'd be de minimis benefit to a traditional well-designed, normalized DB over an intuitive structure that flowed naturally from source material (an Excel spreadsheet, say)

**a4u2fear** · 07-15-12, 11:13 AM

As your database grows, remove the formulas that are calculations and replace them with the value calculated as this will slow down your program.

Also, if you're using VBA, when the code is running, turn of screen updating, it will run much faster.

**mathdotcom** · 07-15-12, 01:09 PM

Better advice... stop using Excel immediately

**Ganchrow** · 07-15-12, 11:25 PM

Originally posted by mathdotcom

Better advice... stop using Excel immediately

I think this is an unrealistic option for the vast majority of non-programmers.

**Maverick22** · 07-16-12, 10:06 AM

357vegas, by database do you mean excel? Or do you mean a relational database like mysql, oracle, access, etc?

If you mean a relational database, take notes from ganchrow, and normalize your data. As you learn to do this, your database structure will become more and more apparent. And by normalize data, that means exercises in removing duplications in your data across your tables.

If you are using excel... Well I couldn't help you there.

**Optional** · 07-16-12, 10:22 AM

So nice to see Ganch giving a thoughtful response, in contrast to the assholes that control this place with their trolling these days.

**mathdotcom** · 07-16-12, 11:09 AM

Originally posted by Ganchrow

I think this is an unrealistic option for the vast majority of non-programmers.

I guess, but then again so is winning.

**EXhoosier10** · 07-16-12, 11:48 AM

Originally posted by mathdotcom

Better advice... stop using Excel immediately

Was this in reference to everything, or simply for database creation?

If you meant in general, what is a better way to keep a track of all of my data? Obviously I could instead be using Access and could generate a report any time I want to look at everything, but this tracks by team, bet type, week#, month, day of week, etc. It has a -1 RL calculator and a Scalp calculator. Is this even possible to do in something other than excel?

**mathdotcom** · 07-16-12, 12:39 PM

Of course its possible

**jgilmartin** · 07-16-12, 12:39 PM

I prefer to go the mySQL route for a number of reasons, most notably speed and flexibility. Even a 1.5MB Excel file runs slowly on my computer. If you set up your mySQL database efficiently (or even somewhat non-efficiently - I'm certain my DBs are nowhere near perfectly optimized), queries will run incredibly fast. For an implementation like an automated backtest of a model, I cannot even imagine trying to use Excel; you could easily accomplish this with a programming language and a mySQL database.

I get Ganch's point but I think if most people were really serious about saving time in the long run, they could learn a programming language with minimal effort. I've had no formal coding training and I learned the basics of PHP and SQL in around 2 weeks (although I would do Phython instead of PHP if I had to do it over). Anyone who is willing to look up some tutorials on Google and do a little bit of experimentation can pick this stuff up easily, IMO.

**yak merchant** · 07-16-12, 01:12 PM

Originally posted by EXhoosier10

Was this in reference to everything, or simply for database creation?

If you meant in general, what is a better way to keep a track of all of my data? Obviously I could instead be using Access and could generate a report any time I want to look at everything, but this tracks by team, bet type, week#, month, day of week, etc. It has a -1 RL calculator and a Scalp calculator. Is this even possible to do in something other than excel?

Calculating in Excel is fine. Storing in Excel is bad. If you stored in Database (I personally hate Access) you can "filter" a thousand times easier and build dynamic queries and use Excel to "View" the data and calculate if necessary. For instance in your spreadsheet how fast can you find ROI for American league teams, playing at home against a left hander with a negative Money Line and a positive RL, coming off a loss? You can build that in Excel but you have to go through some serious hoops. In a database you just basically drop in a query with a where clause something like

where league = 'A' and home = 1 and opppitch = 'L' and ML < 0 and RL > 0 and losingstreak > 0

With a properly structured DB, in 5 seconds you could get an answer to a question that I would be scared to know how long it would take you in Excel.

I think Excel is great, you just have to realize when you are guilty of using a hammer to fix everything.

**EXhoosier10** · 07-16-12, 02:06 PM

Sorry to hijack your thread, 357. my take is that if you're trying to backtest anything or query, filter, etc, one line is the best way to go.

My daily spreadsheet is set to run the day's games on 3 different lines (Away, Home, random stats). There's not a chance in hell that I could have ever gone back to test this stuff if I didn't move it all into a single line. However, there's not a chance in hell that I could cap a game as efficiently if all the data was on a single line in 70 cells.

Like everyone has said, depending on what you're using it for, single line or multiple could be better.

Originally posted by yak merchant

Calculating in Excel is fine. Storing in Excel is bad. If you stored in Database (I personally hate Access) you can "filter" a thousand times easier and build dynamic queries and use Excel to "View" the data and calculate if necessary.

That's my understanding as well. I don't do a lot of backtesting on this and simply use it to track bets and calculate as the season goes along. My goal is to eventually get my bets in the same database as my pitching/hitting data for each game, but you're right that a relational db is definitely the way to do that and getting it out of excel to do research after the season is over is the best solution.

**Maverick22** · 07-16-12, 02:08 PM

Originally posted by 357vegas

My excel worksheet has 168 fields. I just used 4 has an example.

Use a "real" database software and QUICK.

**357vegas** · 07-19-12, 10:51 PM

Thanks People

Going to see some programmers tommorrow morning. Time to start building this machine.

Thanks again for all the advise.

**Augustus** · 07-20-12, 03:02 AM

Anyone here knows how to extract the data you want directly from a website and input into your database?