Page 1 of 6 123 ... LastLast
Results 1 to 10 of 59
  1. #1
    AGS World Heavyweight Champion
    superman7515's Avatar
    Join Date
    Nov 2009
    Location
    Parts Unknown
    Posts
    9,518

    New & Improved! Good Wins/Bad Losses Spreadsheet

    After shutting it down for the last 48+ hours and in consultation with some of the most mediocre minds AGS has to offer (just kidding, sincere thanks to everyone I contacted and who got back with me) a revamped and improved (at least in my mind) spreadsheet has been completed to assist in our poll making ventures. Using multiple sources, several polls, a couple of shots of vodka, and a high tech simulation engine...



    ... every team in the FCS was ranked.

    The top 1/3 are counted as Good Wins.
    The middle 1/3 doesn't count for or against anyone.
    The bottom 1/3 counts as a bad loss.
    Any FBS team that is not ranked higher than the last team in the top 1/3 does not count as a Good Win (ex. there are 120 teams in the FCS, if the FBS team ranks lower than #40, it isn't a Good Win).

    https://docs.google.com/spreadsheet/...Hc&usp=sharing

    Also, you'll notice there are now additional tabs at the bottom. If you click on the Good Win tab, you will see every team that counts as a Good Win (in alphabetical order, not by order of ranking, NDSU came out on top getting every possible #1) and the five teams that are just outside the top 1/3. The same goes with the Bad Loss tab, which will show you the bottom 1/3 in alphabetical order and the five teams in the most danger of dropping into the bottom 1/3. Finally, the Non-Counter FBS tab shows all of the FBS teams that do not count as a Good Win (see the above explanation) so that when you look at How They Fared sheet, you'll know that not all FBS wins are created equal.
    University of Delaware: Cop Free Since 1743
    Brock Free Since 10-16
    Lunch by invitation only

  2. #2
    FCS Champion
    rokamortis's Avatar
    Join Date
    Aug 2004
    Location
    Not Conway, SC
    Posts
    3,565

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    That is damn impressive.

    I liked it before but love it now.

    I think someone jokingly suggested that we should send both of your compiled documents the voters of other polls .... but seriously, that should happen.

    One suggestion, can you add in a key to what the background colors stand for in the first column?
    Last edited by rokamortis; October 16th, 2013 at 12:02 AM.

  3. #3
    AGS FCS Champion Twentysix's Avatar
    Join Date
    Sep 2008
    Location
    San Diego, California
    Posts
    10,778

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    You should email this to the voting SID's. lol.
    North Dakota State University Football
    National Champions: 1965 '68 '69 '83 '85 '86 '88 '90 2011 '12 '13 '14 '15 '17
    MVFC champions: 2011 '12 '13 '14 '15 '16 '17

  4. #4
    AGS World Heavyweight Champion
    superman7515's Avatar
    Join Date
    Nov 2009
    Location
    Parts Unknown
    Posts
    9,518

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    Quote Originally Posted by rokamortis View Post
    One suggestion, can you add in a key to what the background colors stand for in the first column?
    And done. It's to the right of the spreadsheet, just after the FBS section, so you'll have to scroll over a bit if you don't have it opened full screen.
    Last edited by superman7515; October 16th, 2013 at 07:43 AM.
    University of Delaware: Cop Free Since 1743
    Brock Free Since 10-16
    Lunch by invitation only

  5. #5
    AGS FCS Champion
    ElCid's Avatar
    Join Date
    Jul 2012
    Location
    Brevard, NC
    Posts
    9,338

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    Crap, I can't get to it at work. Have to wait until lunch. The suspense is killing me.

  6. #6
    AGS FCS Expert Houndawg's Avatar
    Join Date
    Oct 2007
    Location
    Egypt
    Posts
    5,598

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    SEMO beats Murray State, a good win for SEMO but not a bad loss for Murray?
    Subvert the dominant paradigm

  7. #7
    AGS World Heavyweight Champion
    superman7515's Avatar
    Join Date
    Nov 2009
    Location
    Parts Unknown
    Posts
    9,518

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    Quote Originally Posted by Houndawg View Post
    SEMO beats Murray State, a good win for SEMO but not a bad loss for Murray?
    No. As I explained, the bottom 1/3 of teams are a Bad Loss. SEMO is not ranked in the bottom 1/3. Not every Good Win has a Bad Loss attached. Extreme example, no one would claim that Northern Iowa's loss to North Dakota State is a Bad Loss. And vice-versa, not every Bad Loss has a Good Win attached. If Savannah State beats Florida A&M, that's a Bad Loss for Florida A&M, but FAMU isn't rated high enough to be a Good Win for Savannah State.
    University of Delaware: Cop Free Since 1743
    Brock Free Since 10-16
    Lunch by invitation only

  8. #8
    First Class FCS Ruler WH49er's Avatar
    Join Date
    Sep 2011
    Location
    Lake Norman
    Posts
    528

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    Can't really agree with what you put up for Charlotte but good job on all the hard work.

  9. #9
    AGS FCS Champion
    IBleedYellow's Avatar
    Join Date
    Jun 2008
    Location
    Fargo, ND
    Posts
    6,473

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    Crazy how many teams can't get to 7 wins already.

    2011, '12, '13, '14 '15 '17 & '18 National Champions



  10. #10
    AGS World Heavyweight Champion
    superman7515's Avatar
    Join Date
    Nov 2009
    Location
    Parts Unknown
    Posts
    9,518

    Re: New & Improved! Good Wins/Bad Losses Spreadsheet

    Quote Originally Posted by WH49er View Post
    Can't really agree with what you put up for Charlotte but good job on all the hard work.
    The only thing on Charlotte is that their 23 point loss to D2 UNC Pembroke was a bad loss. Not sure how many would disagree with that, but I feel the majority would agree with that assessment. Well, the only other thing is that they have a red background because they can't reach 7 D1 wins, but that's not subjective.
    University of Delaware: Cop Free Since 1743
    Brock Free Since 10-16
    Lunch by invitation only

Similar Threads

  1. Replies: 0
    Last Post: October 5th, 2013, 01:50 AM
  2. Replies: 0
    Last Post: October 4th, 2013, 05:00 PM
  3. Good Wins/Bad Losses - The Newest Poll Tool from Superman!
    By superman7515 in forum FCS Discussion
    Replies: 21
    Last Post: September 9th, 2013, 11:12 AM
  4. 7 DI wins & 4 losses
    By URMite in forum FCS Discussion
    Replies: 8
    Last Post: November 11th, 2007, 08:54 PM
  5. Pick your wins and losses
    By OL FU in forum FCS Discussion
    Replies: 145
    Last Post: October 15th, 2007, 01:19 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •