The Experience NCAA '12 Almanac

Discussion in 'The Experience' started by Nautica, Jul 18, 2011.

  1. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    [​IMG]


     
  2. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
  3. fuzzyl0gic

    fuzzyl0gic No new friends

    Joined:
    Apr 14, 2010
    Messages:
    8,935
    Nautica would you guys mind if I used this lay-out for record keeping in Orange Crush? It's a really nice set-up. Sorry if this post clutters up things, feel free to delete it if need be. :cool:
     
  4. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    Your free to use it if you would like to
     
  5. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    Only 4 team's pages are update date. About half haven't even been touched.
     
  6. dakota7

    dakota7 Former Blue Chip Recruit

    Joined:
    Sep 23, 2009
    Messages:
    12,443
    How do I edit it?
     
  7. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    PMed it to you so it's not public here.
     
  8. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    I've updated the almanac to show our teams' prestige changes. Here's a summary.

    Unchanged:
    Arizona (3*)
    Michigan (5*)
    I was shocked to see that Michigan managed to hold on to their 5* rating. They actually finished as the 23rd ranked team which was very surprising to me.

    Gained1*:
    ASU (4*)
    Arkansas (5*)
    MSU (5*)
    Ole Miss (4*)
    USC-jr(5*)
    Stanford (5*)
    No big surprises here as all of these teams had solid years.

    Lost 1*:
    Georgia (4*)
    Northwestern (2*)
    Washington (2*)
    Wisconsin (4*)
    Georgia and Wisconsin are going in the wrong direction, but this isn't a surprise after this season. 'Sconsin got screwed by EA in the Rose Bowl, but they got stroked by EA in the CCG so they probably finished right where they were supposed to. As if things weren't bad enough for Washington and Northwestern, they're getting even tougher as a lowly 2*. They need to regain that star immediately next year. I was really surprised to see them drop to a 2* as you have to do a lot to lose that 3rd star (finish outside of the top 75). I can see a 3-9 Washington team being out of the top 75, but I'm really, really surprised that a 6-7(4-4) Northwestern team lost their 3rd star. An 8-5 Michigan team finishes in the top 25 and keeps their 5th star while a 6-7 Northwestern team can't finish in the top 75 and loses their 3rd star.
    Wow!

    JCspartan2 Big Suge Knight dakota7 GoGators edge7771 texacotea blLL flo Nautica Randiesel75 MaslerBoros16 UofCWildcat
     
  9. blLL flo

    blLL flo BTFU!

    Joined:
    Aug 13, 2009
    Messages:
    2,655
    Ya we didn't have a good season by any means, but a vacation and some sim losses hurt us.

    I couldn't play Nautica, texacotea, or edge and I lost all 3 of those games. Not saying I would have beat Nautica, but I was close with SC and beating up on Ole Miss before having to take the sim and the loss. Then I win my bowl game, but have to settle for another sim because EA sucks and I'm handed another loss.

    Should have been more like 8-5 this season, maybe 9-4, and if I could have played all my user games, possibly 10-3.

    Anyways, I was just downgrading myself for all you guys who said Wow, Georgia is a 5*! Lol
     
  10. UofCWildcat

    UofCWildcat Bear Down!

    Joined:
    Mar 13, 2011
    Messages:
    8,580
    God... I think if i would of won my bowl i could of jumped a prestige. O well
     
  11. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    I've created a new page in the almanac for 2012. I've updated the prestiges and added the top 25. I'm at work so I don't have access to the All Americans, so could someone add that?
     
  12. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    I've updated the Almanac for 2012.
     
  13. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    jello man you rock!
     
  14. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    Arizona State's team page has been updated for 2012. The other 11 teams still need to be updated.
     
  15. dakota7

    dakota7 Former Blue Chip Recruit

    Joined:
    Sep 23, 2009
    Messages:
    12,443
    Did you type out your entire roster? I have to be honest, I don't have time for that.
     
  16. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    Go to Dynasty Wire.
    Download your roster.
    Sort the columns in the .csv file it creates by position and then OVR (I have a custom sort that I use in a lot of spreadsheets that sorts by QB -> HB -> FB -> etc). Once you have the custom sort, it'll always be in excel for you to use at a later time.
    Copy/paste from the .csv file into the google spreadsheet.
    It should take 2 minutes, tops.

    [​IMG]
     
  17. dakota7

    dakota7 Former Blue Chip Recruit

    Joined:
    Sep 23, 2009
    Messages:
    12,443
    jello1717

    2 minutes for a guy who uses spreadsheets.........which I don't. I will give it a shot, thanks.
     
  18. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    Just in case you guys don't know much about excel:

    [​IMG]

    Go to Data and then Sort
    Select sort by Position or you can do it by column (C in this case) if you prefer.
    Sort on Values
    Order select Custom List
    If you don't have a list set up, click on NEW LIST
    Then fill out the order you want to sort to use. See the column List entries in the lower right window for my custom position sorting list.
    If you've already set up this list, just click on your custom list (mine's highlighted in blue above).
    After you're sorting the positions, in this example we want to then sort by OVR.
    Click Add Level in the middle window above.
    Select the new Sort by as Overall (or choose the column if you prefer)
    Order is Highest to Lowest

    That's all there is to sorting.
     
  19. UofCWildcat

    UofCWildcat Bear Down!

    Joined:
    Mar 13, 2011
    Messages:
    8,580
    jello1717 how do i paste this sucker into the google spreadsheet? I've been trying for twenty mins but i can't figure it out at all. I've copied it from the Excel file on my computer and now can't paste into the Google Doc.
     
  20. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    CTRL/v should do it.
     
  21. UofCWildcat

    UofCWildcat Bear Down!

    Joined:
    Mar 13, 2011
    Messages:
    8,580
    Yeah thats not work =/
     
  22. UofCWildcat

    UofCWildcat Bear Down!

    Joined:
    Mar 13, 2011
    Messages:
    8,580
    Nevermind. It wasn't working for twenty minutes but now it works all of a sudden. Thanks
     
  23. dakota7

    dakota7 Former Blue Chip Recruit

    Joined:
    Sep 23, 2009
    Messages:
    12,443
    Haha........I played with it, I got something there but it ain't pretty.
     
  24. jello1717

    jello1717 "Those who stay will be champions." -- Bo

    Joined:
    Jun 21, 2009
    Messages:
    13,617
    I've updated the Almanac. I've added a 2013 tab and included our teams' prestige changes.
    jello1717 , Nautica , and edge7771 gained a star for the 2nd season in a row.
    UofCWildcat , blLL flo , GoGators , Randiesel75 , and dakota7 gained a star for the first time
    JCspartan2 , MaslerBoros16 both stayed put
    Big Suge Knight was the only one to lose a star.
    I'm not sure what Darkwing 's prestige was, but he's @ :4stars: now.

    I also added all award winners to both the 2012 and 2011 tabs. (well not all, as avid doesn't have an entry for the new awards, the Nagurski, and the other one).
     
    • Like Like x 3
  25. GoGators

    GoGators GT: KSherm

    Joined:
    May 19, 2009
    Messages:
    7,893
    Thanks for doing this stuff bud.
     

Share This Page