All data is imported automatically. The spreadsheets update themselves everytime you open them. I think I would go nuts trying manually update these things every week.
Jackal - I'm fairly literate with Excel spreadsheets and trying to come up with my own passed on this very great system in this thread, but totally clueless on how to incorporate the automic update feature. Any chance you can share some knowledge on that, including where you get the updates from? If this is too much to ask, just say the word and I understand. Thanks to you, Samy and the Ace for everything!
Jackal - I'm fairly literate with Excel spreadsheets and trying to come up with my own passed on this very great system in this thread, but totally clueless on how to incorporate the automic update feature. Any chance you can share some knowledge on that, including where you get the updates from? If this is too much to ask, just say the word and I understand. Thanks to you, Samy and the Ace for everything!
this is from Jackal...gets the data from sports.com and statfox.com
"to update the spreadsheet automatically everytime you open the sheet go to (you have to do this for each tab that imports data):
Data > Import External Data > Data Range Properties
Then check the box that says 'Refresh data on file open'"
READING YOUR E-MAIL TODAY...would like to know what the avg yards for D-line vs the reg one of 325?...I send you a e-mail also
if you are asking what the defensive average would be, it would be the same as the offense. i think that is what your asking. just trying to help
Defense is 325.931677
offense is also 325.931677.
They are exactly the same and always will be.
example...
If Bills gain 319 and give up 334 to miami, then miami gained 334 and gave up 319 to the bills. The offense yards averaged is (319 the bills gained+334 the fins gained)/2. The Defensive yards averaged is (334 the bills allowed + 319 the fins allowed)/2.
They are exactly the same.
Here are the plays with +17 or more:
Over/Under with value of ONLY +20 or more: YTD 11-3
Over/Under with value of +17 to +19.99: YTD 6-3
<TABLE style="WIDTH: 577pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=770 border=0 x:str=""><COLGROUP><COL style="WIDTH: 61pt" width=82><COL style="WIDTH: 106pt" width=141><COL style="WIDTH: 18pt" width=24><COL style="WIDTH: 122pt" width=163><COL style="WIDTH: 60pt" width=80><COL style="WIDTH: 27pt" width=36><COL style="WIDTH: 83pt" width=111><COL style="WIDTH: 53pt" width=71><COL style="WIDTH: 47pt" width=62><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="WIDTH: 61pt; HEIGHT: 12.75pt" width=82 height=17>Time</TD><TD class=xl23 style="BORDER-LEFT: medium none; WIDTH: 106pt" width=141>Game Information</TD><TD class=xl23 style="BORDER-LEFT: medium none; WIDTH: 18pt" width=24 x:str="">
</TD><TD class=xl23 style="BORDER-LEFT: medium none; WIDTH: 122pt" width=163 x:str="">
</TD><TD class=xl23 style="BORDER-LEFT: medium none; WIDTH: 60pt" width=80>StatFox Line</TD><TD class=xl23 style="BORDER-LEFT: medium none; WIDTH: 27pt" width=36 x:str="">
</TD><TD class=xl25 style="BORDER-LEFT: medium none; WIDTH: 83pt" width=111>Predicted Score</TD><TD class=xl25 style="BORDER-LEFT: medium none; WIDTH: 53pt" width=71>O/U Value</TD><TD class=xl26 style="BORDER-LEFT: medium none; WIDTH: 47pt" width=62>O/U Play</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-TOP: medium none; HEIGHT: 12.75pt" align=right height=17 x:num="0.625">3:00:00 PM</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(149) WASHINGTON</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">AT</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(150) WASHINGTON ST</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">7</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">48.5</TD><TD class=xl24 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="17.178777777777796">17.18</TD><TD class=xl24 style="BACKGROUND: lime 0% 50%; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" align=right x:num="31.321222222222204">31.32</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">UNDER</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-TOP: medium none; HEIGHT: 12.75pt" align=right height=17 x:num="0.83333333333333337">8:00:00 PM</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(153) TEXAS TECH</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">AT</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(154) OKLAHOMA</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">-7</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">75</TD><TD class=xl24 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="99.338777777777793">99.34</TD><TD class=xl24 style="BACKGROUND: lime 0% 50%; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" align=right x:num="24.338777777777793">24.34</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">OVER</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-TOP: medium none; HEIGHT: 12.75pt" align=right height=17 x:num="0.83333333333333337">8:00:00 PM</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(181) UNLV</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">AT</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(182) SAN DIEGO ST</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">11.5</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">58.5</TD><TD class=xl24 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="36.112111111111147">36.11</TD><TD class=xl24 style="BACKGROUND: lime 0% 50%; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" align=right x:num="22.387888888888853">22.39</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">UNDER</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-TOP: medium none; HEIGHT: 12.75pt" align=right height=17 x:num="0.64583333333333337">3:30:00 PM</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(189) LA MONROE</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">AT</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(190) FLA INTERNATIONAL</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">-6.5</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">53</TD><TD class=xl24 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="32.525444444444467">32.53</TD><TD class=xl24 style="BACKGROUND: lime 0% 50%; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" align=right x:num="20.474555555555533">20.47</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">UNDER</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-TOP: medium none; HEIGHT: 12.75pt" align=right height=17 x:num="0.96180555555555547">11:05:00 PM</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(185) IDAHO</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">AT</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(186) HAWAII</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">-23.5</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">58.5</TD><TD class=xl24 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="40.272111111111123">40.27</TD><TD class=xl24 style="BACKGROUND: yellow 0% 50%; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" align=right x:num="18.227888888888877">18.23</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">UNDER</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-TOP: medium none; HEIGHT: 12.75pt" align=right height=17 x:num="0.66666666666666663">4:00:00 PM</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(165) BOISE ST</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">AT</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">(166) NEVADA</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">6</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="">61</TD><TD class=xl24 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right x:num="80.458777777777811">80.46</TD><TD class=xl24 style="BACKGROUND: yellow 0% 50%; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial" align=right x:num="19.458777777777811">19.46</TD><TD class=xl23 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">OVER</TD></TR></TBODY></TABLE>
10-0 Huskies at the half. These teams are terrible! hno: Anyone else watching this god awful game? :drink:
edit: HAHA announcer just said "I don't care which one, just somebody please get in the endzone"