Page 1 of 2 12 LastLast
Results 1 to 20 of 35

Thread: Solidice's NCAA Football 11 Team Info Spreadsheet

  • Share
    • Facebook
  • Thread Tools
  • Display
  1. #1
    Varsity Solidice's Avatar
    Join Date
    May 2010
    Location
    Texas
    Posts
    601

    NCAA Football 11 Team Info Spreadsheet

    I original created this back in early June(during E3 week) and have been adding to it here and there once more info released. As of right now, the spread sheet has each team's:

    Main Sheet:
    pre-season rank from dynasty mode
    prestige
    numerical rating *default roster based on E3 copy*
    their conference
    Offensive Style
    whether or not if they run no-huddle *if blank, means they don't run it as an 'offense'*
    defensive playbook *still WIP*
    their current head coach *for those that like to rename the coaches in dynasty mode, if its still available*
    their real life pass % *based on 2009 stats*
    city, state of the university
    stadium name/capacity *based on what was listed on teambuilder*
    Rivals *the primary rival column is mostly for TB users, now updated to NCAA 11
    Mascot *if it's in the game*
    Pride Stickers *if they have them, this is currently based on NCAA 10
    Impact Players *only numbers
    Recruiting pitch ranks

    Uniform Sheet:
    list all the teams helmet/jersey/pants option that are available in NCAA 11 *only in Text format*

    Playbook Sheet:
    playbook sheet just has a link to another spreadsheet. PB sheet made by gschwendt *huge thanks to him for this

    you can access the spread sheet here:
    https://spreadsheets.google.com/ccc?...mzW9FFYg#gid=0

    if there is anything else that I can add that would be helpful/useful for this spreadsheet, feel free to make a suggestion.

    currently future additions planned:


    **you can get a sortable page for the sheet by click on view>list view at the top of the sheet. it even allow you to filter some things(like only show Big XII teams, only Air Raid teams, etc)
    Last edited by Solidice; 07-17-2010 at 07:49 PM.

  2. #2
    Thanks for this. Is there a site that lists the run/pass ratios for each school or did you calculate that yourself?

  3. #3
    Varsity Solidice's Avatar
    Join Date
    May 2010
    Location
    Texas
    Posts
    601
    Quote Originally Posted by AMagicianNamedGOB View Post
    Thanks for this. Is there a site that lists the run/pass ratios for each school or did you calculate that yourself?
    someone at OS(coachchris) provided the info, I just used the pass % for my sheet. he had the number of runs, passes, sacks, etc.. that was used in the 2009 season. I guess he got the info from ESPN, or another site that listed stats for college football.

    obviously, the teams that got new coaches may be a little off if they are changing offensive styles form 2009 to 2010.

  4. #4
    Freshman Boucher's Avatar
    Join Date
    Jul 2010
    Location
    Toronto
    Posts
    181
    I was gunna say you should add pride stickers but you already did!! Helluva Job!

  5. #5
    Varsity ebin's Avatar
    Join Date
    May 2010
    Location
    Eugene
    Posts
    243
    Thanks for adding the primary rival information; this is really useful!

  6. #6
    Resident Lawyer of TGT CLW's Avatar
    Join Date
    Jun 2010
    Location
    Oklahoma City
    Posts
    12,499
    Nice work!

  7. #7
    Varsity Solidice's Avatar
    Join Date
    May 2010
    Location
    Texas
    Posts
    601

    Solidice's NCAA Football 11 Team Info Spreadsheet


  8. #8
    Freshman Jcoop9's Avatar
    Join Date
    Jun 2010
    Location
    Chi town
    Posts
    26
    Appreciate the info sheet....good job man

  9. #9
    Varsity Solidice's Avatar
    Join Date
    May 2010
    Location
    Texas
    Posts
    601
    updated defensive playbooks, pride stickers, impact players(numbers only for now), and rivals.

    from what I can tell, the 'new' rivalries in NCAA 11 are:
    Florida-Alabama
    Alabama-Ole Miss
    Arizona-New Mexico
    Boston College-Syracuse
    Boston College-Virginia Tech
    BYU-TCU
    Duke-Maryland
    Duke-NC State
    ECU-UCF
    Florida Atlantic-Troy
    Fresno State-Louisiana Tech
    Georgia Tech-Virginia Tech
    Maryland-Navy
    Maryland-NC State
    Navy-Notre Dame
    Navy-Rutgers
    Navy-SMU
    NC State-Wake Forest
    New Mexico-Utah
    North Texas-SMU
    Notre Dame-Pittsburgh
    Oregon State-Washington
    Oregon State-Washington State
    Pittsburgh-Syracuse
    San Diego State-San Jose State
    San Jose State-Stanford

    rivalries removed: (based on what I have written/typed down for NCAA 10)
    Alabama-Mississippi State

  10. #10
    Varsity Cipher 8's Avatar
    Join Date
    Jul 2010
    Location
    WI/MN border
    Posts
    412
    Last year and in 09' I liked to run Maryland's playbook but they changed all the teams playbooks up in 11' and took a lot of my favorite plays out of it. So now I'm looking for a playbook with most of those plays since Maryland's has stripped of all my fav. plays.

    Does anyone know of a playbook with these plays in it?

    Maybe you've seen one or a couple of them when playing with or against a certain team perhaps?

    The play I loved the most was Ace -Ace Slot - Z Spot.

  11. #11
    Hall of Fame SmoothPancakes's Avatar
    Join Date
    Jun 2010
    Location
    Ohio
    Posts
    16,450
    Quote Originally Posted by Solidice View Post
    updated defensive playbooks, pride stickers, impact players(numbers only for now), and rivals.

    from what I can tell, the 'new' rivalries in NCAA 11 are:
    Maryland-Navy
    Navy-Notre Dame
    Navy-Rutgers
    Navy-SMU
    Sweet! They've now got all 6 of Navy's rivalries recognized! This is going to make my Navy dynasty so much better when it actually recognizes it as a rivalry game in the dynasty.

  12. #12
    Varsity Solidice's Avatar
    Join Date
    May 2010
    Location
    Texas
    Posts
    601
    yeah, I was surprise at how many were added. I think they only added 1 or 2 from '09 to 10 if I remember correctly.

    but Navy and SMU are really rivals? that one had me thinking. I didn't realized that.

  13. #13
    Hall of Fame SmoothPancakes's Avatar
    Join Date
    Jun 2010
    Location
    Ohio
    Posts
    16,450
    Yeah, it was literally started last season between Navy and SMU.

    The Gansz Trophy was created in 2009 through a collaboration between the athletic departments of The United States Naval Academy and Southern Methodist University. The trophy is named for Frank Gansz who played linebacker at the Naval Academy from 1957 through 1959. Gansz later served on the coaching staffs at numerous colleges, including all three service academies and Southern Methodist, as well as several professional teams.
    And if this rivalry becomes anything like the game that started it off last year (a 38-35 OT thriller victory for Navy), I am going to be very much looking forward to the Navy-SMU game every year.

  14. #14
    Varsity Cipher 8's Avatar
    Join Date
    Jul 2010
    Location
    WI/MN border
    Posts
    412
    Well I used the playbook/formation spread sheet to find all the teams that have the Weak I: Twin TE formation and those were Miami, Wisconsin, Minnesota, and Kansas. None of those teams had the HB Dive w/ the FB in motion, the PA TE Under w/ FB in motion, nor the Rollout Strong. They all had the HB Power O w/ FB in motion however but there are tons of Power O's in the game. So I think those three plays are gone which sucks because they worked well of each other and were great for short yardage situations. I haven't seen them in any other formations so if you do let me know. I'm moving on to the other plays now...

    I'm going to look over the other plays, diff. formations, but there's literally 20+ teams with those formations so anybody else's help would be awesome. Just if you see any of those plays let me know.

  15. #15
    Varsity ebin's Avatar
    Join Date
    May 2010
    Location
    Eugene
    Posts
    243
    Quote Originally Posted by Solidice View Post
    updated defensive playbooks, pride stickers, impact players(numbers only for now), and rivals.e
    Thank you, kind sir!

  16. #16
    Freshman Roy38's Avatar
    Join Date
    Jul 2010
    Location
    Enid, Oklahoma
    Posts
    175
    Solidice, is your project finished or still a WIP?

  17. #17
    Varsity Solidice's Avatar
    Join Date
    May 2010
    Location
    Texas
    Posts
    601
    Quote Originally Posted by Roy38 View Post
    Solidice, is your project finished or still a WIP?
    it'll probably always be WIP as long as there is stuff to add.

    I've started to add each team's starting rank in each of the recruiting pitches. it'll probably be a while before I get all that done though.

    if there is anything else that can be added, I'll try to get it done.

  18. #18
    Freshman Boucher's Avatar
    Join Date
    Jul 2010
    Location
    Toronto
    Posts
    181
    Soo SMU has pride stickers IRL but i dont think they have them in NCAA 11... Disappointing

  19. #19
    Varsity Solidice's Avatar
    Join Date
    May 2010
    Location
    Texas
    Posts
    601
    Quote Originally Posted by Boucher View Post
    Soo SMU has pride stickers IRL but i dont think they have them in NCAA 11... Disappointing
    apparently. they also have Bowling Green with pride sticker even though I don't think they still wear them. and they took out ECU, Kentucky, and Purdue when I think they all still wear them and they were in NCAA 10(not 100% sure that they still wear them in real life)

  20. #20
    Freshman Boucher's Avatar
    Join Date
    Jul 2010
    Location
    Toronto
    Posts
    181
    Reason why they would take them out?

Bookmarks

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
  •