2009 CFB POW Week #2

[BoiseBrian]

thursday GT
friday Toledo
saturday Utah
Air Force
OK State
TCU
UCLA

 

[bluelabga]

Pops,

Refer to thread #28 - I didn't see where you made the changes to that column - just reminding you in case you may have forgotten.

 

[pops69]

Pops,

Refer to thread #28 - I didn't see where you made the changes to that column - just reminding you in case you may have forgotten.

col W is fixed in the spreadsheet i uploaded earlier and the pivot tables reflect those changes. eg. oreg was a VMP. SM (are simple majority where it's less than 2-1 pow, and MP are majority picks where over 2-1 ration the H and V are for home and visitor

 

[CTP]

I think the wrong formula is in V. Believe it should be this one.

IF(Q2+R2=0,"",IF(S2>2,"HMP",IF(AND(Q2+R2>3,S2>0,S2<=2),"HSM",IF(T2>2,"VMP",IF(AND(Q2+R2>3,T2>0,T2<=2),"VSM",IF(Q2*100/(Q2+R2)=50,"NMP"))))))

Oregon still ended as a VSP and should be a VMP

 

[pops69]

I think the wrong formula is in V. Believe it should be this one.

IF(Q2+R2=0,"",IF(S2>2,"HMP",IF(AND(Q2+R2>3,S2>0,S2<=2),"HSM",IF(T2>2,"VMP",IF(AND(Q2+R2>3,T2>0,T2<=2),"VSM",IF(Q2*100/(Q2+R2)=50,"NMP"))))))

Oregon still ended as a VSP and should be a VMP

yep that fixed it. a vmp now

tks #1

 

[pops69]

sm lose way more the mp

data from the pivot tables below

post em if you got em

<table style="border-collapse: collapse; width: 320pt;" border="0" cellpadding="0" cellspacing="0" width="426"><col style="width: 138pt;" width="184"> <col style="width: 103pt;" width="137"> <col style="width: 18pt;" width="24"> <col style="width: 61pt;" width="81"> <tbody><tr style="height: 15pt;" height="20"> <td style="background: rgb(219, 229, 241) none repeat scroll 0%; height: 15pt; width: 138pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20" width="184">Week #</td> <td class="xl78" style="background: rgb(219, 229, 241) none repeat scroll 0%; width: 103pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="137">1</td> <td class="xl78" style="width: 18pt;" width="24">
</td> <td class="xl78" style="width: 61pt;" width="81">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="background: rgb(219, 229, 241) none repeat scroll 0%; height: 15pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">Day</td> <td class="xl78" style="background: rgb(219, 229, 241) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">(All)</td> <td class="xl78">
</td> <td class="xl78">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="background: rgb(219, 229, 241) none repeat scroll 0%; height: 15pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">Home</td> <td class="xl78" style="background: rgb(219, 229, 241) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">(All)</td> <td class="xl78">
</td> <td class="xl78">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="background: rgb(219, 229, 241) none repeat scroll 0%; height: 15pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">Away</td> <td class="xl78" style="background: rgb(219, 229, 241) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">(All)</td> <td class="xl78">
</td> <td class="xl78">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0%; height: 15pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">Site Location</td> <td class="xl78" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">(All)</td> <td class="xl78">
</td> <td class="xl78">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td class="xl78">
</td> <td class="xl78">
</td> <td class="xl78">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="background: rgb(219, 229, 241) none repeat scroll 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">Count of Won/Loss Vs Close</td> <td class="xl78" style="background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Column Labels</td> <td class="xl78" style="background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> <td class="xl78" style="background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">Row Labels</td> <td class="xl78" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">W</td> <td class="xl78" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">L</td> <td class="xl78" style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); border-width: medium medium 0.5pt; background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Grand Total</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl78" style="height: 15pt;" height="20">HMP</td> <td class="xl78">6</td> <td class="xl78">6</td> <td class="xl78">12</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl78" style="height: 15pt;" height="20">HSM</td> <td class="xl78">1</td> <td class="xl78">4</td> <td class="xl78">5</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl78" style="height: 15pt;" height="20">NMP</td> <td class="xl78">3</td> <td class="xl78">2</td> <td class="xl78">5</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl78" style="height: 15pt;" height="20">VMP</td> <td class="xl78">5</td> <td class="xl78">6</td> <td class="xl78">11</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl78" style="height: 15pt;" height="20">VSM</td> <td class="xl78">2</td> <td class="xl78">4</td> <td class="xl78">6</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl79" style="border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; border-width: 0.5pt medium medium; background: rgb(219, 229, 241) none repeat scroll 0%; height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" height="20">Grand Total</td> <td class="xl78" style="border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; border-width: 0.5pt medium medium; background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">17</td> <td class="xl78" style="border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; border-width: 0.5pt medium medium; background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">22</td> <td class="xl78" style="border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; border-width: 0.5pt medium medium; background: rgb(219, 229, 241) none repeat scroll 0%; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">39</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>

 

[bluelabga]

Pops - are you going to make the changes to the spreadsheet or do I. I just pulled it back up and nothing had changed.

 

[oilbarrel]

pops take a look at the mlb thread when you get a chance

 

[fballplaya]

All Saturday plays...

Iowa St
Utep
USC
So. Miss
Georgia

 

[bucknuts]

Iowa
Notre Dame
Navy
Air Force
Ohio State
Oregon
Western Michigan

 

[jesse1111]

G Tech

Tennessee
Navy
Notre Dame
Air Force
Kansas

 

[pops69]

Iowa
Notre Dame
Navy
Air Force
Ohio State
Oregon
Western Michigan

only 5 pow, and you can have 1 for the thru fri game. if no thur or fri it still only 5. let me know which to delete

tks

 

[Romanowski]

clemson

toledo

Iowa

penn st

wash st

 

[nosepicker]

Mid Tenn St
Ohio
Tulane
UTEP
Clemson
Ohio St
UL Laf
New Mex

 

[JARBrigger]

Week 2

Th - G. Tech
Fr -
Sa - Iowa St.
Sa - Stanford
Sa - Texas Tech
Sa - Notre Dame
Sa - North Carolina

Lock it in!

 

[I'mBombed]

Thurs- GA tech
Fri- Toledo
Sat- Stanford, North Texas, Washington, Texas Tech, Georgia

 

[pops69]

Mid Tenn St
Ohio
Tulane
UTEP
Clemson
Ohio St
UL Laf
New Mex

5 sat games period. you can also have 1 on thu and 1 for friday. if you dont like any of the games on the weekdays. you still only get 5 pow for sat

let me know thanks

 

[pops69]

that's it for me today, but sure would love to see that i have a bunch of work to do in the morning

post em if you go em

nite and glta

 

[jwheels]

thurs. - clemson

 

[EatTheChalk]

Toledo (+)
Tulane (+)
Michigan (+)
Virginia (+)
Tennessee

-ETC