Announcement

Collapse
No announcement yet.

Refining the NFL Excel Program

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Refining the NFL Excel Program

    I want to refine my Program. I use 17 different statistical categories.

    I do not use Special Team categories. Based on my research, in and of itself it is not a determing factor in teams that win--unlike Total Offensive Yardage which is a HUGE determination in Winning.

    Another huge determining factor is Yards Per Pass Attempt. Bud Goode is a statistical expert and claims this is the number one determining factor.

    Obviously Turnovers play a role, but I believe there are as many by LUCK as by aggressiveness.

    Net Points is a Big Factor.

    Yards Per Rush is not necessarily a big factor, but Yards Rushing Per Game is.

    So I've narrowed it down to either 15 or 17 categories, depending on whether take-a-ways and give-a-ways should each have their own category or if Net Turnovers is sufficient.

    I am inclined to think Net Turnovers is sufficient since a team's Turnover Rank can go from, say, 7th in the league to 19th in the league in one or 2 games. And therefore, with that kind of volatility, perhaps it is better not to TRIPLE that influence by factoring in take-a-ways and give-a-ways along with the NET.

    So here's 15 categories, and I am wondering how much weight to give to each one in fine tuning my Program. I welcome your input, and we'll build a killer program.

    First, here are Four Categories that I am already convinced need to be weighted more than other categories:

    1.) The Win Factor

    The win factor is that something special that teams like the Patriots have. They just win even if the stats say otherwise. This must be weighted for more than other categories.

    2.) Yards Per Pass Attempt

    I have kept an eye on this since I first read some articles by Bud Goode, a professional capper and statistician. He's right. This is a HUGE determining factor.

    3.) Net Points

    This is a no-brainer. Obviously since the final score determines who wins or loses, it should count for more.

    4.) Total Offensive Yardage

    Seems to be more important in "getting to the playoffs". Once there, it seems to be all about defense.


    Now the 2 categories that I do not think needs to be weighted...

    5.) Net Turnovers

    This can swing up and down through out the season based on a teams last 1 or 2 games. It's too volatile to factor in more weight.

    6.) Penalties

    Like turnovers, because the numbers are usually single digits (average penalties less than 8 per team per game), it is too volatile.

    That leaves 9 categories I am unsure of. What do you think? What categories are worthy of more weight?

    7.) Points For (redundant since NET is already weighted?)
    8.) Points Against (ditto)
    9.) Pass Yards (redundant since YPPA is already weighted?)
    10.) Pass Yards Against (my hunch is no extra weight here)
    11.) Rush Yards Per Game (maybe?)
    12.) Rush Yards Against (no)
    13.) Total Yards Against (no)
    14.) Net Yardage (probably)
    15.) Yards Per Pass Attempt Allowed (?)

    Feedback welcome.
    dave

  • #2
    Dave,

    You're in Cabot, Arkansas? That's about 20 minutes from me.

    Comment


    • #3
      Your making it too hard, IMO...I've drilled it done easier...give me a shout.
      FUCK YOU, FUCK ME

      Comment


      • #4
        Vinny,

        This program has really helped me get a much better feel for the teams. It's amazing how I can go to forums and read stuff and think, "No, that's not right" regarding strengths and weaknesses of teams. I just left a forum with a thread on the KC-Miami game that was full of misconceptions. This line is about right. Chiefs opened at -1.5 and action has pushed it about where it needs to be at Mia -2.0.

        Anyway, I've threw out the take-a-ways and give-a-ways and kept only the net turnovers. That left me with 15 categories.

        I've held my ground on emphasizing total yards, net points, net yards, yppa, and the win factor. These categories receive 1.5 in weight, or a 50% increase in weight.

        The rest are the same except penalties and net turnovers, which are 0.5, which is 1/2 the standard weight.

        Thanks for posting.


        BC,

        I went to Auburn (Opelika) Alabama for the Hurricane intending on being there a couple days and going back business as usual for Hurricanes. The rest is history. I did'nt make it back to Biloxi. And after staying about 3 weeks in Tiger Town, we made the move to Austin ARK temporarily, which is about 11 miles from Cabot (as you probably know).

        We now live in Cabot Arkansas and are here for at least one year. After that, we don't know. I like the area and its a little cooler up here, so the posibility exists that we will continue to live here after 1 year.

        Cabot is awesome. Crime is non-existent and the people bring back memories of what it use to be like in Biloxi before the Casino industry took over. Our two kids love it, and the schools are really good.

        Earning the same kind of money that I did in Biloxi will be a real challenge, for now the games are keeping my head above water as we continue to settle in, nipping and tucking our lives.

        Where are U? Jacksonville? North Little Rock?

        dave

        Comment


        • #5
          Dave, I agree 100%...I think I have a simplier version for you...somehow get my email...not sure if it's readily avail? Just think I could save you time...and get same result...???
          FUCK YOU, FUCK ME

          Comment


          • #6
            I'd like to see it. Mine doesn't take much time. Writing the Program last sprind took a while. But now I just punch in the stats at the end of the week.

            Also, I like to not only get a line, but I like the idea of keeping stats on that many categories so that I can glance at team's strengths and weaknesses, how it matches up with their opponent, and how it compares to the NFL Average.

            I like to find a game where the numbers and the techs are on the same side.

            Monday Night is a good example. I think UNDER the Jets-Falcons has the numbers and techs lining up.

            Not sure what procedure is for email addresses, any Moderator can email you my address if/when they read this or have time.

            thanx,
            dtoop
            at hot male :christmas

            Comment


            • #7
              Dave,

              I'm in North Little Rock

              Cabot is growing like mad as we've ran out of room here in NLR. I hear that the schools there are good.

              Comment


              • #8
                Originally posted by dave T
                2.) Yards Per Pass Attempt

                I have kept an eye on this since I first read some articles by Bud Goode, a professional capper and statistician. He's right. This is a HUGE determining factor.
                Dave,

                Can you please send me the articles by Bud Goode to me?

                My analysis and studies have shown that good passing teams in the NFL perform poorly ATS. They however do win more games SU. IMO bettors and fans are influenced by offense and scoring.

                Teams that throw more often, throw for more yardage and more Yards Per Pass Attempt overall are poor ATS investments.

                Using raw passing stats with no other factors:

                Teams that average more Yards Per Pass Attempt than their opponent.
                SU 57.2%
                ATS 48.1%

                Teams that average a 1/2 yard more per pass attempt than their opponent:
                SU 59.8%
                ATS 47.6%

                Teams that average a 1 yard more per pass attempt than their opponent:
                SU 62.7%
                ATS 48.0%

                Teams that average 1.5 yards more per pass attempt than their opponent:
                SU 63.7%
                ATS 47.5%

                We can see the better the passing team the better they do in winning the game. Yet do poorly ATS. The difference between winning SU and covering widens.

                Comment


                • #9
                  What's interesting is the team that passes for more yard per attempt Win 73.7% SU and 68.9% ATS.

                  This analysis proves it's difficult predicting which team will pass more more yards per pass attempt based on previous games.

                  IMO the key is finding teams with good balance with running the ball as well as passing.
                  Last edited by frankb03; 10-21-2005, 12:20 PM.

                  Comment


                  • #10
                    Teams that average more pass attempts per game:

                    SU 48.0%
                    ATS 49.0%


                    The team that attempts more passes in a game their opponent:
                    SU 29.7%
                    ATS 29.8%

                    The last stat is amazing. Teams that must pass the ball do very poorly winning the game and covering. Obviously, they are in the come from behind roll.

                    Comment


                    • #11
                      Originally posted by dave T
                      That leaves 9 categories I am unsure of. What do you think? What categories are worthy of more weight?

                      11.) Rush Yards Per Game (maybe?)
                      IMO rushing the ball is extremely important in winning football games. It controls how the game is being played. Unlike passing team. Teams that rush the ball well in previous game and the current game do very well. However, it doesn't necessarily translate into ATS wins.

                      Teams that average more rushing yards per game than their opponent.

                      SU 56.2%
                      ATS 50.7%


                      Teams that average 25+ more rushing yards per game than their opponent.

                      SU 61.2%
                      ATS 51.9%

                      Teams that average 50+ more rushing yards per game than their opponent.

                      SU 65.4%
                      ATS 52.3%

                      We can see the team wins more games the better they rush the football. Though, they don't cover more.


                      Teams that outrush their opponent in the game
                      SU 72.9%
                      ATS 68.7%

                      The more they outrush their opponent in the game the better they perform SU and ATS

                      Teams that outrush their opponest in the game bt 50 or more yards.

                      SU 82.7%
                      ATS 77.5%

                      What does this all mean? If you are watching a game and your team is running the ball down the throat of the other team. They are more likely to win and cover.

                      Comment


                      • #12
                        Now let's put rushing and passing together.

                        Teams that outrush their opponent in total rushing yards per game and throw for more yards per pass attempt:

                        SU 61.4%
                        ATS 49.0%

                        In this situation the home team won over 70% of the games yet only covered 48.6%

                        This stunned me. Balanced offense wins games. It doesn't win bets.

                        Comment


                        • #13
                          Win Factor

                          Teams with the better win%

                          SU 61.0%
                          ATS 47.4%

                          Teams over .500 with better win% than their opponent

                          SU 62.3%
                          ATS 48.3%

                          Teams with the better win% vs opponent with win% over .500

                          SU 52.0%
                          ATS 48.5%


                          Teams with a win% better than .500 vs teams with a win% below .200

                          SU 68.7%
                          ATS 47.1%


                          Teams with a win% better than .500 vs teams with a win% below .200 week 6 or later.

                          SU 74.9%
                          ATS 40.8%

                          The last stat is staggering. Better teams rise to the surface as far as winning the game. Vegas clearly inflates these teams knowing public prefers favorites and the public doesn't have the balls to play bad football teams.

                          BTW, Texas is in this roll this week.

                          Comment


                          • #14
                            Thank you for all your input. I'm still tweeking it, but not sure the difference will be that significant with minor weights in a handful of categories. A Houston Cover would not surprise me. But like you said, man it's really hard to back them. The disparity between the two is more that of a College game with Houston's injuries and all. I remember last year on Thanksgiving Day when the Colts were off a few HUGE WINS and you just knew they would let down...but they rolled at Detroit.

                            Indy is so good offensively it seems they buck all the trends. When they play a weak team, they just steamroll them.

                            BC,

                            We were fortunate. There are waiting lists for people to get their kids into certain schools. And people are trying to move to Cabot like crazy. But the town is only so big and its full. People are trying to get OUT of Little Rock. Anyway, because we were Hurricane People, we got bumped to the top of the list whatever we needed, including the schools.

                            Btw, my little girl (Alaya, 4) was on the Cover of the Cabot newspaper Wed, Sept 28. My neighbor knocked on my door and brought it to my attention. The local paper was doing a piece on Cabot Kare, and we happened to be there at the time. The photographer apparently snapped a shot of Alaya playing in the toy section and put it on the Front Page.

                            gl,
                            dave

                            ps- Frank, I read this article at Bud Goode's site a few years ago. I just went there and it looks like you have to subscribe now.
                            Last edited by dave T; 10-21-2005, 07:24 PM.

                            Comment

                            Working...
                            X