2009 CFB POW Week #4

[Bulldawg23]

OK, forgive my thickness. I cannot figure out what tables 4, 5, 6, and 7 are on the pivot page(from left to right). 7 looks like line movement OL vs CL, but if that's what it is then we've only had 16 games with no line movement at all?

Thanks again.

 

[pops69]

OK, forgive my thickness. I cannot figure out what tables 4, 5, 6, and 7 are on the pivot page(from left to right). 7 looks like line movement OL vs CL, but if that's what it is then we've only had 16 games with no line movement at all?

Thanks again.

the key to understand what each pivot table is very simple. just click anywhere inside of the pivot table.. this will bring up a pivot table field list with 4 boxes.

top left - the filter report (this is the variables that i want to change. eg week to week #2 vs all etc

top right & bottom right - are just the results i want to see in the top right. eg won lost push or over under etc. the bottom right is the same item as the top right but just the sum of the results

botton left - row lables. what is it that i want to measure. normally only one item, but sometimes i do a combination of things that i want to look at

from that pivot table report, you can just drag or drop any col that are in the 2009 results and OL tab, plus they are all shown in the pivot table field list with check boxes as to what has already be selected

all that #4 is the number of people on each team (pow) right now there's way to many numbers. when i have situations like that i'll create buckets and lump the data like i do in my MLB spreadsheets to help find patterns easier. 4 thru 6 will need to have data buckets as just way too many specific numbers to mean anything. it's just like whip numbers in mlb i could have 10,000 item numbers, so i've set specific numbers into range buckets to lump results to help find patterns easier. remember the detail of any number in any of the pivot tables is just double click away

use the 1st pivot table as an example. just double clike on the VSM 15 (row 13 col B) and it will bring up everyone of those games and all the detail for them into another tab in the spreadsheet

keep em coming

 

[SpreadDestroyerr]

Play of the week

S. Car

 

[pops69]

guys i know your all fucking the dog in the promise land, but please read those notices (and pay attention to them b4 the OL come out) many show key player (esp qb injury situations etc) and it will effect the way the numbers open and or move. dont get caught hold the bag

 

[pops69]

S. Car

just like the guy that was all over florida last week regardless of the number

your down for it

gl

 

[SpreadDestroyerr]

just like the guy that was all over florida last week regardless of the number

your down for it

gl

Love the spot they are in here pops, along with Ole Miss being one of the most overrated teams in the history of CFB to boot. GL!!

 

[pops69]

Love the spot they are in here pops, along with Ole Miss being one of the most overrated teams in the history of CFB to boot. GL!!

that's a long time. i think a couple of those took the tail pipe this past weekend. still think is always good to look at the numbers b4 you make up your mind. but that's only me, i always wait until right b4 the window closes unless it's a position type

 

[pops69]

i'll go above and beyond the COD and stick for a couple more hrs to try and get everyone the complete schedule with all the OL. if nothing by than. it's la la time

 

[pops69]

week #4 POW spreadsheets below, includes all schedules and OL

have fun and enjoy the rest of the nfl promise land

nite and glta

 

[Coldweather]

Thank again for all your hard work. But for my ego, I will do much more gooder as in goodlyest next week. Take it to the football bank. For Real!

:toast:

 

[jesse1111]

Thanks. Didn't know if you checked week 3 again or not.
Where did you relocate to ? You were in Vegas correct?

 

[pops69]

Thank again for all your hard work. But for my ego, I will do much more gooder as in goodlyest next week. Take it to the football bank. For Real!

:toast:

if anyone can repeat this year, you have the best shot. i know how much time i spend working on data and analysis, so you must be swamped with all the detailed analysis you do on all the sports you bet

gl

 

[pops69]

Thanks. Didn't know if you checked week 3 again or not.
Where did you relocate to ? You were in Vegas correct?

yes, but no one tells me what i can say and do so no longer part of uss. enough said about the sub as i dont want to get pissed again

 

[pops69]

wow, you guys are burning up the pow thread. i better order a new puter to handle the workload

post em if you got em

 

[pops69]

this is not a complete list but i sure miss these guys not posting. they were way more valuable that most, sure hope they are alive and well

jpatterson91
x-caliber
soonersfan88
fballplaya
bolty
its not me its u
silver7
mccabe
nad-man
jbrag10
sparticus
danjarus
dirtmule
jblonghorn
jimmyjet
leatherballs
yimes
lil kiper


we need you man, and all love u as well

 

[pops69]

NFL Data base (no macro or 2nd half trigger points) still work in progress for all pivot tables and additional calc for public vs LM. all actual data is there

enjoy

 

[pops69]

soon we will have a correlation on the % vs LM. things like 95% on miss but line moving the other way

leave no stone unturned so seek and you will find the truth

 

[UnderDawg]

Thursday Mississippi
Friday Mizz
Saturday Penn St.,Louisville,UNC,Stanford and Cincy (again)

Not waisting any time here

 

[pops69]

Thursday Mississippi
Friday Mizz
Saturday Penn St.,Louisville,UNC,Stanford and Cincy (again)

Not waisting any time here

that's the way i like it

fire away guys, light day so let's get it on

post em if you got em

 

[Pancho-3]

NFL Data base (no macro

Pops - Are the macros for Rotation, Stats and Scores top secret,
or would you consider Posting.

Thanks for what you do, in educating the newbies.