Ace,
Thank you for your reply. I think I'll just wait for the new spreadsheet. This is really great, and much appreciated.
I willl definitlely help out if I can, but I am not great with Excel. I would like to give back though, as you have given to me and others. Would it be of assistance for me to attempt a college spreadsheet? If yes, then I will. If more competent people are on it then I'll sit tight for most likely a better product.
I'm sending you an email now.
Thank you for your reply. I think I'll just wait for the new spreadsheet. This is really great, and much appreciated.
I willl definitlely help out if I can, but I am not great with Excel. I would like to give back though, as you have given to me and others. Would it be of assistance for me to attempt a college spreadsheet? If yes, then I will. If more competent people are on it then I'll sit tight for most likely a better product.
I'm sending you an email now.
LeadWeight2020 said:
what i get everyone that want one gets....its not a competent....but....the more we get......pick the one that best....or....... use more than one to balance and check.....or.....have someone take the best of everyone and make one that is the state of the art....so get it a try if you want:toast:
best to you
Cant remeber if im on the list to get this scheme..
But please mail me when ready.
mail is: my nick at my nick dot org
Btw.. Instead of sending out several hundreds emails..
I own a server, so i can put it on that, so everyone can just download from that??
And if its meant to be, that one guy updates it, so rest can download, its no problem doing that every week.. Just say so.. :toast:
But please mail me when ready.
mail is: my nick at my nick dot org
Btw.. Instead of sending out several hundreds emails..
I own a server, so i can put it on that, so everyone can just download from that??
And if its meant to be, that one guy updates it, so rest can download, its no problem doing that every week.. Just say so.. :toast:
I would like to see Preseason Weeks 3&4 added to the NFL spreadsheet due to: 1) revenge factor by previous year's regular season players; 2) first-year head coaches playing rookies and free agents; 3) are the teams playing again in the current season?; 4) long-tenured coaches are known for pre-season playing styles relative to the spread and this can be capitalized on; 5) the spread line range seems to only hover between -1.5 and -2.5 in the first two weeks (soft lines) which indicates a pick-em situation where other factors come into play; and 6) soft lines of last two weeks harden (larger point spread) giving an indication to the first four weeks of the regular season where the data values of 6+ become more interpretable, reliable, and relevant.
Callipsios
RX Junior Student in Ex-Bookie School
:modemman:
Callipsios
RX Junior Student in Ex-Bookie School
:modemman:
Hi Ace,
I've failed. I made a spreadsheet that would probably be ok for NFL, but it's not pretty. The college ss is a no go, and beyond my abilities. (the monstrosity I came up with wouldn't help anyone) At this point I think I'm going to use the new NFL one you've got coming, and do a couple of college conferences on paper.
Just thought I would let you know.
I've failed. I made a spreadsheet that would probably be ok for NFL, but it's not pretty. The college ss is a no go, and beyond my abilities. (the monstrosity I came up with wouldn't help anyone) At this point I think I'm going to use the new NFL one you've got coming, and do a couple of college conferences on paper.
Just thought I would let you know.
Been in touch with the guy that handles the MRNFL program also MRCFB for college. He got interested again so just might happen. Used his stuff last year and through some additional spreadsheets I made up did okay. Any way his stuff is very classy and for like 70 dollars a year for both I can't see anyone doing the work for less. Probably speaking too soon but there is a chance. You can download all the stuff like Tuesday or no later than Wednesday so have quite a bit of time to do your own analysis. I liked it because it has a test page where you can change the formula inputs yourself and it will back calculate all games up to that point and give a win loss record. I used as many as 14 different formulas and tracked the results each week. When one started to go south I developed a new one than used the whole thing in a concensus. Unfortunately I did not track my results in college like I did in the NFL.
ACE-ACE said:YOU DONT DO ANYTHING...A BYE WEEK IS JUST A BYE WEEK....MOST OF THE TIME IT ONLY STOPS 4 TEAMS OF THE 32 TEAMS....SO THOSE 4 TEAM GET NO STATS THAT WEEK...ITS THAT EASY
So, for instance in Week 4, one team has already taken their bye and they are playing against a team that hasn't had a bye. Obviously, the team with more games should (potentially) have more penalties and could have more turnovers simply b/c they've played an extra game. If I am understanding correctly, the calculation of my line does not care about that fact and you compare the year's totals regardless of games played. Is that correct?
Thanks for your help and wisdom.
Trapstar said:So, for instance in Week 4, one team has already taken their bye and they are playing against a team that hasn't had a bye. Obviously, the team with more games should (potentially) have more penalties and could have more turnovers simply b/c they've played an extra game. If I am understanding correctly, the calculation of my line does not care about that fact and you compare the year's totals regardless of games played. Is that correct?
Thanks for your help and wisdom.
THE FORMULA DONT CARE ....BUT THAT WHERE AFTER SEEING THE VALUE OF EACH GAME ...YOU HAVE TO MAKE A FINE TUNE UP TO WEEK 10
ACE-ACE
Drpzne said:
IF YOU DID A TEAM WITH PENALTIES
ONE TEAM 4 WK GOT 400YD VS ONE TEAM THAT GOT 3 WK WITH 400 YD
THAN IT WOULD BE 100 VS 133 = 33 DIV BY 100 = .3 ONLY
IF YOU DID IT WITH EVERY TEAM AND EVERY STAT IT WOULD WORK!!!
BUT
THE FORMULA IS IN A WAY THAT ONE WEEK OFF DOES NOT MAKE A DIFF/ MOST OF THE TIME
I WILL LOOK IN TO THIS FOR THE SPEADSHEET!!
GOOD POINT
ACE-ACE
Hi Ace-Ace
First, I would like to thank you for your system and hard work. I have spent months putting this system into excel, using your formulas. I run into a few obstacles and would like to ask you for some inputs:
1. How far off your line from the real line?
2. For LineOff calculation, if SD Wk1 is +11 and CHI Wk1 is -12.5, for week 2 LineOff calculation SD@CHI -4, would it be SD +23.5/10=+2.35? Or SD +1.5/10=SD +.15?
Just for testing your line.....I have SD -6.04, CIN -2.84, and DET -1.93.
Am I on the right track? Am I missing something? Again, thank you for your system.
lt
when you're done with your system, may I have a copy of it? My email is [.
First, I would like to thank you for your system and hard work. I have spent months putting this system into excel, using your formulas. I run into a few obstacles and would like to ask you for some inputs:
1. How far off your line from the real line?
2. For LineOff calculation, if SD Wk1 is +11 and CHI Wk1 is -12.5, for week 2 LineOff calculation SD@CHI -4, would it be SD +23.5/10=+2.35? Or SD +1.5/10=SD +.15?
Just for testing your line.....I have SD -6.04, CIN -2.84, and DET -1.93.
Am I on the right track? Am I missing something? Again, thank you for your system.
lt
when you're done with your system, may I have a copy of it? My email is [.
Last edited by a moderator:
