Spreadsheet mania - WEEK 8

Jimboski

Registered User
Forum Member
Dec 15, 2005
4,499
14
0
Florida
EDITING this because the lines were way out of wack . Was going to just delete it, but I'll leave it just to see how it woulda done.:0corn

USE THIS POST FOR :em38:

4th post (down from here) has the corrected lines and corrected plays for Saturday. Note that almost all the plays have changed now that the correct lines are used.


Sorry for the problem; there is an explanation of what happened below also.






Sorry I don't track my record but the ole bankaroo sez that following the "sheet" is working.

Just a little misc. stuff before I list this week's plays:

- added data (from last week's results to my "Calculate the line" project and it is looking EXCELLENT. Lands right on the line in some cases where the line is like + or - 17 and even hits the nail on the head for bigger nos. as well sometimes. I'm putting more weight on this calc. line thingy when I filter the Cruncher's STRONG picks.

- After adding last week's data, I checked out the "formulas" between the newest one and the one we used last week (and also vs. the one we used the week before). I'd really like to see the new one look very close to the older one (based on less data, BUT STILL WORKED quite well). Unfortunately that ain't happening - newest formula is a little too much different than the older ones. The object of this silly project IS to find out which of the MANY factors (stats) are really the most important and which ones are really negligible. More specifically - "exactly" how much weight to put on each factor. So far, the Cruncher keeps changing it's mind a little about the answer to this huge question :shrug:

- I didn't mess around with the sheet (you know, like try to tweak it). But, I AM now able to use TWO formulas (actually - equations) to get my picks now instead of just the latest one. I get it's rating from the
formula that used data from weeks 4,5, and 6 and also get it's rating based on the formula using data from weeks 5,6, and 7. Only the picks that are rated as STRONG PLAYS from BOTH equations get filtered (I wrote how I do that in one of my previous posts) and after passing the filter steps it becomes a play for this week.

Here thems are:

Central Mich. +4: BARELY made the STRONG PLAY rating. I like the fact this team should have no problem putting points on the scoreboard. Hell, they put up more pts. vs. Mich St. than B.G. put up vs. Ball St. BTW, the Falcons get DOWN graded (Statfox ratings) when I do the filtering thingy cause I've seen them play and they ain't poopies.

South Fla +4: NICE play methinks.

So. Carolina -4: Be careful cause this is one them "looks too easy" plays.

Nebraska -4

N. Illinois +4: This one won for me as a bestest bet a couple of weeks ago and I expect the same today. (UT oh... .. :scared believe I wrote that about New Mex. State last week). I never got to actually see them play, but I did go over each of their games pretty close like and the Huskies get UPgraded in my figures. They lost several key players from last yr's. defensive squad but apparently thats not affecting their play this year. Watch for Coffman to pick at least one this Sat.

Rice +10 (git the hook and make it 10 1/2): NO the Cruncher didn't blow a fuse when it picked this college football team wannabe. The first thing I saw when filtering this one was the level of competition they faced vs. who their opponent's faced so far this season. That was enough for me to make them a real play. They did cover vs. Okie State in week 3 BTW. One HUGE problem though is that Fanuzzi (Rice QB) is questionable and Rice relies on the air ball game. Still, they're returning home vs a so/so team and I got a good feeling about this game with 10 1/2 points in my pocket at the get-go.

This one's MY pick:
FIU +10 1/2: Ever hear of em? :142smilie I bet there really are some that haven't. This team has improved to TERRIBLE and that status can handle Ark. State I think ESP. with a 10 1/2 point head start. I've seen them play and believe a LOT of people would know who their QB is if he only had some big team receivers to work with. He is very good. And how bout a player named Jason Frierson - third best (avg.) punt returner IN THE COUNTRY.

Wanna forget the checkmark on yer scorecard and play along?? Playing them all, even for only one stinkin unit, has been working all but one week or.. .. .... .. . just pick a red one, make sure YOU think they gotta shot, and go a little heavier.

G.L.


 
Last edited:

doncartmill

Registered User
Forum Member
Sep 6, 2007
8
0
0
Jim What Happened ????? 1st 5 of 7 are totally whacko : Spreads off by 10-15 points ???
Sorry I don't track my record but the ole bankaroo sez that following the "sheet" is working.

Just a little misc. stuff before I list this week's plays:

- added data (from last week's results to my "Calculate the line" project and it is looking EXCELLENT. Lands right on the line in some cases where the line is like + or - 17 and even hits the nail on the head for bigger nos. as well sometimes. I'm putting more weight on this calc. line thingy when I filter the Cruncher's STRONG picks.

- After adding last week's data, I checked out the "formulas" between the newest one and the one we used last week (and also vs. the one we used the week before). I'd really like to see the new one look very close to the older one (based on less data, BUT STILL WORKED quite well). Unfortunately that ain't happening - newest formula is a little too much different than the older ones. The object of this silly project IS to find out which of the MANY factors (stats) are really the most important and which ones are really negligible. More specifically - "exactly" how much weight to put on each factor. So far, the Cruncher keeps changing it's mind a little about the answer to this huge question :shrug:

- I didn't mess around with the sheet (you know, like try to tweak it). But, I AM now able to use TWO formulas (actually - equations) to get my picks now instead of just the latest one. I get it's rating from the
formula that used data from weeks 4,5, and 6 and also get it's rating based on the formula using data from weeks 5,6, and 7. Only the picks that are rated as STRONG PLAYS from BOTH equations get filtered (I wrote how I do that in one of my previous posts) and after passing the filter steps it becomes a play for this week.

Here thems are:

Central Mich. +4: BARELY made the STRONG PLAY rating. I like the fact this team should have no problem putting points on the scoreboard. Hell, they put up more pts. vs. Mich St. than B.G. put up vs. Ball St. BTW, the Falcons get DOWN graded (Statfox ratings) when I do the filtering thingy cause I've seen them play and they ain't poopies.

South Fla +4: NICE play methinks.

So. Carolina -4: Be careful cause this is one them "looks too easy" plays.

Nebraska -4

N. Illinois +4: This one won for me as a bestest bet a couple of weeks ago and I expect the same today. (UT oh... .. :scared believe I wrote that about New Mex. State last week). I never got to actually see them play, but I did go over each of their games pretty close like and the Huskies get UPgraded in my figures. They lost several key players from last yr's. defensive squad but apparently thats not affecting their play this year. Watch for Coffman to pick at least one this Sat.

Rice +10 (git the hook and make it 10 1/2): NO the Cruncher didn't blow a fuse when it picked this college football team wannabe. The first thing I saw when filtering this one was the level of competition they faced vs. who their opponent's faced so far this season. That was enough for me to make them a real play. They did cover vs. Okie State in week 3 BTW. One HUGE problem though is that Fanuzzi (Rice QB) is questionable and Rice relies on the air ball game. Still, they're returning home vs a so/so team and I got a good feeling about this game with 10 1/2 points in my pocket at the get-go.

This one's MY pick:
FIU +10 1/2: Ever hear of em? :142smilie I bet there really are some that haven't. This team has improved to TERRIBLE and that status can handle Ark. State I think ESP. with a 10 1/2 point head start. I've seen them play and believe a LOT of people would know who their QB is if he only had some big team receivers to work with. He is very good. And how bout a player named Jason Frierson - third best (avg.) punt returner IN THE COUNTRY.

Wanna forget the checkmark on yer scorecard and play along?? Playing them all, even for only one stinkin unit, has been working all but one week or.. .. .... .. . just pick a red one, make sure YOU think they gotta shot, and go a little heavier.

G.L.


 

Jimboski

Registered User
Forum Member
Dec 15, 2005
4,499
14
0
Florida
THANK YOU mucho.

THANK YOU mucho.

I just checked the first game (Cent. Mich) and see the line is REALLY MINUS 9 and NOT +4. Man, talk about shaving points! EGAD :banghead:

You know, I was wondering how could all my games be +/- 4 or 10 when I posted (didn't play anthing for real yet cause I gotta make a few parlays before I do, but gonna put them in tonight). Sure do appreciate your corrections. Man, I sure hope there was at least one MJer right in back of you that would have pointed this out cause I SURE look pretty foolish:eek:

Do you see what time I post these things, that's NOT the beginning of my 20 hr. day - it's the END of my 20 hr. day and I sure was bushed after wrestling with the Cruncher when I tried updating the last sheet to reflect THIS WEEK'S action.

Just to offer YOU an answer - the problem was the way I update from week to week. After making a copy of the prior weeks sheet I run a macro that OVERWRITES last weeks games with this weeks games then I employ the new equations to get the rating. It's ALL automatic. Well .. .. almost. The data and the RATINGS are correct and these plays will prob. remain as STRONG plays. BUT, the part that gives me a rating based on the REAL line and my calculated line is bogus. Why? Cause everything is automatic EXCEPT for the new line for this week's matchup. Sooo.... the dang thang just copied the cell with the line figure from that game that got overwritten (last week) onto THIS WEEKS report. I forgot that I have to MANUALLY enter the lines for this week and then run the report. SHEET!

Thank you mucho, Don. Now I gotta enter all the lines for this dang week and see what happens then I'll repost. Ugh! I just may edit all of what I posted? We'll see what the new results are.
 

Jimboski

Registered User
Forum Member
Dec 15, 2005
4,499
14
0
Florida
CORRECTED plays from Crunchy - Week 8

CORRECTED plays from Crunchy - Week 8

Sheesh, things were so much easier when I used to just figure out MY own picks, postem, playem, and lose my moola. Now, we're all caught up with the electronic gadgets ("necessities") and they can give ya some freakin headache sometimes. Well, I'm hooked on puters but, at least, I ain't a cellphone head.

If ya don't know what I'm referring too with the above . .. . that's a GOOD thing, just know that these are the corrected plays for tomorrow....

Duke -4: it's an iffy play. Got a strong rating from my spreadsheet, but the filtering (stuff I do to further check out the STRONG rated plays) wasn't too positive for this one.

So. Carolina -13 1/2: STILL a play (my orig. post that had the wrong lines also LUVED this one). I'll be buying it down to -13 or maybe even -12 1/2. Best of all - NOW, it doesn't look too easy to be true. :00hour

Miami (Ohio) +11: JUST letting you know that the SS rates this as an ULTRA STRONG play. Yes, I verified that there are no mistakes in the calculations neither. Really hate to disregard such a rating from something that has done very well so far.. but I AM, no play for me especially due to the team they are playing that has been very good to me so far and I believe is much better that the expert's rate.

Idaho +15 1/2: Another one that I'm not that comfortable with considering the fact that a team that should be doing nuthin is doing EVERYTHING. You know, feel like i'm going to the well a little too often. Also, I know virtually nothing about Nevada. BUT, the nos. are strong and YES I'm on them Vandals again.

Rice +10 (+ 1/2): Actually, RIGHT NOW the line IS +10 1/2. Another one that still remains a pick from that thread I posted with the wrong lines. All the comments from that problem thread are valid for this pick.

Washington +10: Yes, its 10 1/2 for me, not gonna keep writing this but - I ALWAYS buy a half when the line is 10 . This team came through for me last week by getting bitten by the snake (BAD, BAD luck) and the miracle finish of that game paid off for me. Maybe they'll come through for me again by holding on this week. No question, I watched every second of last weeks game and they ARE better than their pre-season ratings or even their current "official" rating. Much improved team. Like the fact that the Ducks will be running (and using up the clock) in this game that has a double digit line, giving Wash. the digits. LUV the fact that despite the extra week of rest - TWO key players are likely to sit out this game for the Quackers and one is their QB, Masoli. Also, I think Wash justified that unbelievable win vs. USC in their subsequent games and continue to play very well. I'll be taking the points and pushing the clock for this one.

Fla International +11 : That's the CURRENT line. See comments in the "fiasco" thread. With the corrected line, the SS (Crunchy) rates this play as "Solid", which is short of "Strong". I like it enough to post and play.

I also like N. Tex and Troy to go OVER
(58)
which is the current line. N. Tex could be the problem cause they are most inconsistent. They have an average total yards/game of 405, WOW. Now,if they can only stop turning over the dang ball, more of those yards should turn into points. It does look like Troy will handle their end of the bargain or more than their share. Worth a shot.

That's it, thanks again Donhawkmill and Hawkeye for alerting me to that original thread and letting me know some peoples are actually reading all I wrote, and GL yaw'l.
 

Jimboski

Registered User
Forum Member
Dec 15, 2005
4,499
14
0
Florida
a little late but

a little late but

Looks like about 10 to Posttime..

taking UNDER 40 for the Rutgers/Army game. Both will run, both can defend run OK. Neither is a scoring machine.

GL
 

Jimboski

Registered User
Forum Member
Dec 15, 2005
4,499
14
0
Florida
Adding

Adding

This thread sure turned into a mess appearance wise... .. BUT, it could still become a golden egg. We'll see :0corn

Sorry bout that late post on the Rutgers game. I shoulda known that nobody's gonna run to their Bookie Man and put it in just on account of they just saw me post it. I DID play it AFTER i posted it with still minutes to spare though.

How bout that Cruncher piciking Miami (Ohio). Yeah, only a push.... .. but that still shows that this mechanical method helps finding a play that (maybe) nobody would have thunk of. I sure as hell wouldn't have thought of that one.

OK, I waited to see about the weather for this one and it shows "cloudy" but no rain. So, I'm putting in:

TCU/BYU OVER 51.

G.L.
gotta go see how the Dukies are doin kurby
 
Bet on MyBookie
Top