1. #1
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Ask my CFB database!

    I've got a pretty good CFB db, and in an effort to help out - I'm new here - I thought I'd offer my services this weekend. Ask me a question and I'll run your query thru my db and post the results.
    Last edited by shari91; 09-30-11 at 11:13 AM. Reason: soliciting points

  2. #2
    cant call it
    BAMA UP!!!
    cant call it's Avatar Become A Pro!
    Join Date: 08-29-10
    Posts: 8,817
    Betpoints: 455

    How many people will jordan jefferson kick this weekend?

  3. #3
    PAULYPOKER
    I slipped Tricky Dick a hit of LSD!
    PAULYPOKER's Avatar Become A Pro!
    Join Date: 12-06-08
    Posts: 36,585

    What your DB say for the Bama/Gator game..................

  4. #4
    BernardMadoff
    Sam Hurd +3000
    BernardMadoff's Avatar Become A Pro!
    Join Date: 12-12-09
    Posts: 6,679
    Betpoints: 280

    LoL.

  5. #5
    Demonata
    Demonata's Avatar SBR PRO
    Join Date: 07-12-11
    Posts: 25,800
    Betpoints: 5421

    What's it say for tonights byu utah state game?

  6. #6
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Actually, instead of providing recommendations I'm making my db available for any questions you might have. About a team maybe, or a specific coach, or a general situation you've always been interested in but didn't have the resources on your own to check out.

  7. #7
    scarface0800
    Update your status
    scarface0800's Avatar Become A Pro!
    Join Date: 01-19-10
    Posts: 920
    Betpoints: 2862

    give us the winner for tonights game

  8. #8
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    I have a db, not a crystal ball.

  9. #9
    Demonata
    Demonata's Avatar SBR PRO
    Join Date: 07-12-11
    Posts: 25,800
    Betpoints: 5421

    Well can you tell who has the better chance to win tonight?

  10. #10
    cant call it
    BAMA UP!!!
    cant call it's Avatar Become A Pro!
    Join Date: 08-29-10
    Posts: 8,817
    Betpoints: 455

    What is BYU's offensive coordinator's record versus teams west of the mississippi river?

  11. #11
    PAULYPOKER
    I slipped Tricky Dick a hit of LSD!
    PAULYPOKER's Avatar Become A Pro!
    Join Date: 12-06-08
    Posts: 36,585


  12. #12
    Demonata
    Demonata's Avatar SBR PRO
    Join Date: 07-12-11
    Posts: 25,800
    Betpoints: 5421

    Will J J diluigi get over 43 rushing yards today?

  13. #13
    Boscoe
    Boscoe's Avatar Become A Pro!
    Join Date: 02-08-10
    Posts: 2,811
    Betpoints: 494

    percentage of road dogs that cover when spread is 10?

  14. #14
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by Boscoe View Post
    percentage of road dogs that cover when spread is 10?
    Exactly 10 or 10 or more?

  15. #15
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by TheEditor View Post
    I've got a pretty good CFB db, and in an effort to help out - I'm new here - I thought I'd offer my services this weekend. Ask me a question and I'll run your query thru my db and post the results.
    How far back do you go? I go back to 1985 but I usually only use data since 1998 (first year of overtime).

  16. #16
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by Demonata View Post
    Will J J diluigi get over 43 rushing yards today?
    Yes.

  17. #17
    House
    House's Avatar Become A Pro!
    Join Date: 09-04-11
    Posts: 7,019
    Betpoints: 5492

    Will I get a bike for Christmas? I hope its yes......

  18. #18
    Boscoe
    Boscoe's Avatar Become A Pro!
    Join Date: 02-08-10
    Posts: 2,811
    Betpoints: 494

    Quote Originally Posted by LT Profits View Post
    Exactly 10 or 10 or more?
    how about both?

  19. #19
    Demonata
    Demonata's Avatar SBR PRO
    Join Date: 07-12-11
    Posts: 25,800
    Betpoints: 5421

    Quote Originally Posted by LT Profits View Post
    Yes.
    You sure man... He really has not run well. What makes you think he will?

  20. #20
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by Boscoe View Post
    how about both?
    Nothing there.

    Road Dogs since 1998 (pushes omitted)

    10+: 1548-1525, 50.4%
    10: 65-67, 49.2%

  21. #21
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by Demonata View Post
    You sure man... He really has not run well. What makes you think he will?
    My projections say 59 yards, Not good, but more than 43.

  22. #22
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    My data starts in 1990. I'm running a complete rebuild right now and am out of commission for probably about another hour.

    I can run queries on coordinators, but not with a phrase like "west of the Mississippi". Though it wouldn't be that hard. Food for thought.

  23. #23
    cant call it
    BAMA UP!!!
    cant call it's Avatar Become A Pro!
    Join Date: 08-29-10
    Posts: 8,817
    Betpoints: 455

    What is the average shoe size from jersey #s 20-76 on utah states roster?

  24. #24
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by cant call it View Post
    What is the average shoe size from jersey #s 20-76 on utah states roster?
    My projections say 10.5

  25. #25
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by TheEditor View Post
    My data starts in 1990. I'm running a complete rebuild right now and am out of commission for probably about another hour.

    I can run queries on coordinators, but not with a phrase like "west of the Mississippi". Though it wouldn't be that hard. Food for thought.
    1990 is good, but you might be better served by shrinking it to 1998 if it makes things go any faster. I rarely look back before then.

  26. #26
    BillyGoat
    BillyGoat's Avatar Become A Pro!
    Join Date: 10-29-10
    Posts: 223
    Betpoints: 1093

    What is the record of an in conference game dogs with a line of +10 or greater.

  27. #27
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by BillyGoat View Post
    What is the record of an in conference game dogs with a line of +10 or greater.
    Believe it or not:

    1281-1281, 50.0%

  28. #28
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Queries themselves are near instantaneous. Its the rebuilding of the db that takes time. I have roughly 400 fields I can query for each game. Rebuilding the current season takes a couple of minutes. Rebuilding from 1990 on takes a bit of time. Normally I don't do that but once or twice during the summer. But I found a cobweb that needs clearing.

  29. #29
    BernardMadoff
    Sam Hurd +3000
    BernardMadoff's Avatar Become A Pro!
    Join Date: 12-12-09
    Posts: 6,679
    Betpoints: 280

    Quote Originally Posted by TheEditor View Post
    Queries themselves are near instantaneous. Its the rebuilding of the db that takes time. I have roughly 400 fields I can query for each game. Rebuilding the current season takes a couple of minutes. Rebuilding from 1990 on takes a bit of time. Normally I don't do that but once or twice during the summer. But I found a cobweb that needs clearing.
    Put the term Motivation in your database. You cant account for motivation, not to mention turnovers. In other words, databases dont work. See the Pitt game last night, surely your database would have probably had USF winning perhaps and if it didnt, surely it didnt have Pitt winning by more than 20 and the games it did have Pitt winning by more than 20 was probably less than 5% of all possible choices. If youre just trying to hit say over 50%, sure you may come up with something that hits that and better, hope it works out for you and others.

  30. #30
    DangerousOne
    DangerousOne's Avatar Become A Pro!
    Join Date: 10-30-08
    Posts: 249
    Betpoints: 42

    We've finally got a good source for data and we're asking sh*t like what's Penn St.'s record when Jopa craps himself (I believe 1-0). How bout this Editor... Many good cappers leaning heavier towards overs the last couple of years on the theory that as college offenses have opened up books are slow in raising totals... is this true? Can you berakdown yearly over the last say 5 years the % of overs that hit? Thx in advance.

  31. #31
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by DangerousOne View Post
    We've finally got a good source for data and we're asking sh*t like what's Penn St.'s record when Jopa craps himself (I believe 1-0). How bout this Editor... Many good cappers leaning heavier towards overs the last couple of years on the theory that as college offenses have opened up books are slow in raising totals... is this true? Can you berakdown yearly over the last say 5 years the % of overs that hit? Thx in advance.
    Not really. Since 2005, Over is 1989-2080, 48.9%

  32. #32
    DangerousOne
    DangerousOne's Avatar Become A Pro!
    Join Date: 10-30-08
    Posts: 249
    Betpoints: 42

    If you break it down year by year is it trending up or are we pretty much flat over that period? Thanks for the info LT.

  33. #33
    G's pks
    Update your status
    G's pks's Avatar Become A Pro!
    Join Date: 01-01-09
    Posts: 22,251

    Last edited by shari91; Today at 11:13 AM. Reason: soliciting points





  34. #34
    louis.ana
    louis.ana's Avatar Become A Pro!
    Join Date: 02-08-09
    Posts: 359
    Betpoints: 446

    I always wondered about this trend..

    Can you tell me how many times (win rate) an underdog covered when a top 25 team plays a non-top 25 team, for the last year, 2 years, whatever. I always feel the lines for top 25 teams are inflated, had no way to prove it.

    Can anybody look this up?

  35. #35
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by dangerousone View Post
    if you break it down year by year is it trending up or are we pretty much flat over that period? Thanks for the info lt.
    2005: 198-194, 51.0%
    2006: 332-373, 47.1%
    2007: 340-362, 48.4%
    2008: 352-354, 49.9%
    2009: 337-366, 47.9%
    2010: 344-349, 49.6%
    2011: 87-86, 50.3%

123 Last
Top