PDA

View Full Version : Solidice's NCAA Football 12 Team Info Spreadsheet



Solidice
06-29-2011, 03:42 PM
similar to the one I did for NCAA 11, I've copied it over and started updating it to NCAA 12. A lot of the things are still based on NCAA 11, and some even based on NCAA 10(like the "main" rival thing). I'll start really updating it once I get the game of course or when more info comes out, but for now I figure I would go ahead and post the link for the spreadsheet so people can see it.

Here is the link
https://spreadsheets.google.com/spreadsheet/ccc?key=0Ariz5WETeaOwdEVubHkwNFBCMDktdlkwQW1NLTVnW lE&hl=en_US&authkey=CLqZ_vYK

currently it includes all 120 FBS teams and:
Preseason rank for year 1 of dynasty(1-120)
School Prestige
their numerical ratings that you see when you start a dynasty
Conference they start in
Offensive Play Style
No-huddle setting*
Defense
Head Coach
Offensive Coordinator
Defensive Coordinator
Real life Pass %
City, State
Stadium + Capacity
Primary Rival*
Additional Rivals
Mascots
Pride Stickers
Impact Players
Recruiting Pitch Ranks
Pipeline States

The 2nd sheet at the bottom list in text what each team has for uniform options.

Items with * in the list above are not currently updated to NCAA 12 info.
I entered the HC, OC, and DC info about a month ago, so let me know if something recently has changed in those areas.

baseballplyrmvp
06-29-2011, 08:46 PM
hawaii's o coordinator is nick rolovich, not ron lee. and our d-coordinator is dave aranda, not cal lee. otherwise :up:

morsdraconis
06-30-2011, 12:01 AM
WVU - Holgorsen is the Head Coach and OC. Not sure how the game is gonna handle that though... Maybe make the RB coach the OC (Robert Gillespie (http://www.msnsportsnet.com/staffDirectory.cfm?func=view&staffID=2250)) instead of having Holgorsen still be the OC and Stewart the HC.

jaymo76
06-30-2011, 12:25 AM
Thanks for all your hard work.

BigDmo
06-30-2011, 04:02 AM
Thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you

coogrfan
06-30-2011, 09:44 AM
Thanks for all your hard work.

Ditto.

Fyi --UH defense s/b a 3 - 4

AustinWolv
06-30-2011, 10:35 AM
Thanks for including real life pass % in there, as that is an excellent resource to have compiled in one easy-to-see format.

morsdraconis
06-30-2011, 11:04 AM
Thanks for including real life pass % in there, as that is an excellent resource to have compiled in one easy-to-see format.

+1

Absolutely. I totally missed that the first time I looked at it as I immediately went over to the HC/OC/DC section to check on those being correct.

Solidice
06-30-2011, 01:21 PM
Thanks for including real life pass % in there, as that is an excellent resource to have compiled in one easy-to-see format.

if anyone has seen a source for the 2010 season stats with the Pass %, let me know. It would save me some time.

AustinWolv
06-30-2011, 01:34 PM
Sorry, all I've seen so far is from the NCAA site:
http://web1.ncaa.org/mfb/2010/Internet/trend/FBS_trend_team_off_1.pdf

illwill10
06-30-2011, 01:40 PM
ONe way(LONG) is to add Total Rush Attempts and Pass Atempts=Total Attempts, Then Pass Attempts/Total Attempts=%. It will take a long time if you cant find a certain source
Hawaii passes 76.7% and Nevada passes 44%

Cody
06-30-2011, 02:10 PM
Thanks a ton Solidice.

morsdraconis
06-30-2011, 03:01 PM
Give me a few hours, and I'll have all that stuff from the post that Austin made into a nice table for you to take and use as a reference point for the run/pass %.

Solidice
06-30-2011, 03:07 PM
Give me a few hours, and I'll have all that stuff from the post that Austin made into a nice table for you to take and use as a reference point for the run/pass %.

That'll be a huge help. I'm currently going through NCAA 12 TB and updating the uniform choices.

morsdraconis
06-30-2011, 03:37 PM
Teams | Rush Atts | Pass Atts | Total | Run % | Pass %
Air Force | 748 | 168 | 916 | 81.7% | 18.3%
Akron | 393 | 349 | 742 | 53.0% | 47.0%
Alabama | 467 | 362 | 829 | 56.3% | 43.7%
Arizona | 435 | 524 | 959 | 45.4% | 54.6%
Arizona St. | 413 | 464 | 877 | 47.1% | 52.9%
Arkansas | 421 | 465 | 886 | 47.5% | 52.5%
Arkansas St. | 420 | 436 | 856 | 49.1% | 50.9%
Army | 728 | 138 | 866 | 84.1% | 15.9%
Auburn | 652 | 296 | 948 | 68.8% | 31.2%
Ball St. | 445 | 309 | 754 | 59.0% | 41.0%
Baylor | 468 | 471 | 939 | 49.8% | 50.2%
Boise St. | 486 | 424 | 910 | 53.4% | 46.6%
Boston College | 464 | 351 | 815 | 56.9% | 43.1%
Bowling Green | 361 | 459 | 820 | 53.0% | 56.0%
Buffalo | 440 | 410 | 850 | 51.8% | 48.2%
BYU | 518 | 428 | 946 | 54.8% | 45.2%
California | 428 | 332 | 760 | 56.3% | 43.7%
Central Mich. | 383 | 477 | 860 | 44.5% | 55.5%
Cincinnati | 402 | 435 | 837 | 48.0% | 52.0%
Clemson | 457 | 409 | 866 | 52.8% | 47.2%
Colorado | 450 | 397 | 847 | 53.1% | 46.9%
Colorado St. | 392 | 393 | 785 | 49.9% | 50.1%
Connecticut | 501 | 357 | 858 | 58.4% | 41.6%
Duke | 383 | 489 | 872 | 43.9% | 56.1%
East Carolina | 358 | 632 | 990 | 36.2% | 63.8%
Eastern Mich. | 511 | 282 | 793 | 64.4% | 35.6%
FIU | 522 | 384 | 906 | 57.6% | 42.4%
Fla. Atlantic | 399 | 342 | 741 | 53.8% | 46.2%
Florida | 504 | 381 | 885 | 56.9% | 43.1%
Florida St. | 500 | 397 | 897 | 55.7% | 44.3%
Fresno St. | 494 | 364 | 858 | 57.6% | 42.4%
Georgia | 455 | 359 | 814 | 55.9% | 44.1%
Georgia Tech | 753 | 168 | 921 | 81.8% | 18.2%
Hawaii | 308 | 618 | 926 | 33.3% | 66.7%
Houston | 410 | 484 | 894 | 45.9% | 54.1%
Idaho | 373 | 549 | 922 | 40.5% | 59.5%
Illinois | 619 | 284 | 903 | 68.5% | 31.5%
Indiana | 348 | 513 | 861 | 40.4% | 59.6%
Iowa | 449 | 357 | 806 | 55.7% | 44.3%
Iowa St. | 455 | 373 | 828 | 55.0% | 45.0%
Kansas | 470 | 353 | 823 | 57.1% | 42.9%
Kansas St. | 554 | 293 | 847 | 65.4% | 34.6%
Kent St. | 383 | 390 | 773 | 49.5% | 50.5%
Kentucky | 452 | 458 | 910 | 49.7% | 50.3%
La.- Lafayette | 414 | 436 | 850 | 48.7% | 51.3%
La.- Monroe | 473 | 401 | 874 | 54.1% | 45.9%
Louisiana Tech | 465 | 425 | 890 | 52.2% | 47.8%
Louisville | 472 | 363 | 835 | 56.5% | 43.5%
LSU | 538 | 301 | 839 | 64.1% | 35.9%
Marshall | 345 | 421 | 766 | 45.0% | 55.0%
Maryland | 433 | 389 | 822 | 52.7% | 47.3%
Memphis | 383 | 335 | 718 | 53.3% | 46.7%
Miami (FL) | 494 | 443 | 937 | 52.7% | 47.3%
Miami (OH) | 438 | 503 | 941 | 46.5% | 53.5%
Michigan | 556 | 385 | 941 | 59.1% | 40.9%
Michigan St. | 444 | 373 | 817 | 54.3% | 45.7%
Middle Tenn. | 525 | 384 | 909 | 57.8% | 42.2%
Minnesota | 447 | 378 | 825 | 54.2% | 45.8%
Mississippi | 496 | 330 | 826 | 60.0% | 40.0%
Mississippi St. | 619 | 288 | 907 | 68.2% | 31.8%
Missouri | 439 | 490 | 929 | 47.3% | 52.7%
Navy | 692 | 157 | 849 | 81.5% | 18.5%
Nebraska | 634 | 282 | 916 | 69.2% | 30.8%
Nevada | 669 | 375 | 1044 | 64.1% | 35.9%
New Mexico | 440 | 365 | 805 | 54.7% | 45.3%
New Mexico St. | 449 | 376 | 825 | 54.4% | 45.6%
North Carolina | 440 | 425 | 865 | 50.9% | 49.1%
North Carolina St. | 461 | 545 | 1006 | 45.8% | 54.2%
North Texas | 489 | 316 | 805 | 60.7% | 39.3%
Northern Ill. | 581 | 329 | 910 | 63.8% | 36.2%
Northwestern | 557 | 385 | 942 | 59.1% | 40.9%
Notre Dame | 414 | 481 | 895 | 46.3% | 53.7%
Ohio | 496 | 272 | 768 | 64.6% | 35.4%
Ohio St. | 547 | 349 | 896 | 61.0% | 39.0%
Oklahoma | 578 | 633 | 1211 | 47.7% | 52.3%
Oklahoma St. | 450 | 532 | 982 | 45.8% | 54.2%
Oregon | 629 | 395 | 1024 | 61.4% | 38.6%
Oregon St. | 384 | 375 | 759 | 50.6% | 49.4%
Penn St. | 448 | 425 | 873 | 51.3% | 48.7%
Pittsburgh | 470 | 360 | 830 | 56.6% | 43.4%
Purdue | 442 | 354 | 796 | 55.5% | 44.5%
Rice | 494 | 360 | 854 | 57.8% | 42.2%
Rutgers | 445 | 324 | 769 | 57.9% | 42.1%
San Diego St. | 439 | 426 | 865 | 50.8% | 49.2%
San Jose St. | 352 | 436 | 788 | 44.7% | 55.3%
SMU | 404 | 516 | 920 | 43.9% | 56.1%
South Carolina | 522 | 389 | 911 | 57.3% | 42.7%
South Fla. | 487 | 323 | 810 | 60.1% | 39.9%
Southern Cal. | 477 | 453 | 930 | 51.3% | 48.7%
Southern Miss. | 559 | 471 | 1030 | 54.3% | 45.7%
Stanford | 535 | 379 | 914 | 58.5% | 41.5%
Syracuse | 448 | 364 | 812 | 55.2% | 44.8%
TCU | 600 | 331 | 931 | 64.4% | 35.6%
Temple | 430 | 297 | 727 | 59.1% | 40.9%
Tennessee | 408 | 419 | 827 | 49.3% | 50.7%
Texas | 433 | 445 | 878 | 49.3% | 50.7%
Texas A&M | 519 | 515 | 1034 | 50.2% | 49.8%
Texas Tech | 437 | 617 | 1054 | 41.5% | 58.5%
Toledo | 495 | 365 | 860 | 57.6% | 42.4%
Troy | 469 | 528 | 997 | 47.0% | 53.0%
Tulane | 434 | 465 | 899 | 48.3% | 51.7%
Tulsa | 537 | 469 | 1006 | 53.4% | 46.6%
UAB | 417 | 465 | 882 | 47.3% | 52.7%
UCF | 602 | 296 | 898 | 67.0% | 33.0%
UCLA | 484 | 318 | 802 | 60.3% | 39.7%
UNLV | 453 | 352 | 805 | 56.3% | 43.7%
Utah | 428 | 398 | 826 | 51.8% | 48.2%
Utah St. | 528 | 324 | 852 | 62.0% | 38.0%
UTEP | 412 | 432 | 844 | 48.8% | 51.2%
Vanderbilt | 421 | 360 | 781 | 53.9% | 46.1%
Virginia | 419 | 443 | 862 | 48.6% | 51.4%
Virginia Tech | 570 | 343 | 913 | 62.4% | 37.6%
Wake Forest | 460 | 302 | 762 | 60.4% | 39.6%
Washington | 481 | 376 | 857 | 56.1% | 43.9%
Washington St. | 417 | 384 | 801 | 52.1% | 47.9%
West Virginia | 526 | 382 | 908 | 57.9% | 42.1%
Western Ky. | 500 | 295 | 795 | 62.9% | 37.1%
Western Mich. | 385 | 475 | 860 | 44.8% | 55.2%
Wisconsin | 584 | 276 | 860 | 67.9% | 32.1%
Wyoming | 402 | 289 | 691 | 58.2% | 41.8%

morsdraconis
06-30-2011, 03:37 PM
Hope that helps.

:up:

AustinWolv
06-30-2011, 03:47 PM
Hey mors, nice job running the numbers.

Solidice, one thing that perhaps fans of various teams can help with: Teams that changed coaches since those stats above are based on the 2010 teams of course.

For example, Michigan obviously changed coaching staff, so I would recommend putting in SDSU's pass % in the sheet instead of the 2010 numbers, which were noticeably biased to run %.
Another example might be Texas that hired the Boise St. OC, so maybe tweak them a touch closer to the BSU 2010 numbers instead.

Just a thought.

Solidice
06-30-2011, 05:45 PM
finished updating uniform options, added Baylor's Mascot(Bruiser), added Akron's new stadium and updated all of the stadium capacities that EA listed.

for now, I just enter the pass % as what they were as a team last season. I'll go back through and try change it based on coach changes.

Treadstone6700
06-30-2011, 11:57 PM
Amazing. Thanks Solidice!

CLW
07-02-2011, 07:50 AM
This bad boy needs to get the STICKY. :nod:


EDIT: for whatever it is worth :Duke: has switched to a 4-2-5 this year IRL. Whether that is in the game or not I have no clue.

souljahbill
07-02-2011, 10:36 AM
EDIT: for whatever it is worth :Duke: has switched to a 4-2-5 this year IRL. Whether that is in the game or not I have no clue.So did Southern Miss




Sent from my iPhone using Tapatalk

ThatSnickelfritz
07-05-2011, 12:24 AM
Don't know if the speadsheet is based on the game or real life but, ECU is running the 3-4 this year instead of the 4-3.

souljahbill
07-05-2011, 07:16 AM
Don't know if the speadsheet is based on the game or real life but, ECU is running the 3-4 this year instead of the 4-3.

The game. The purpose of the spreadsheet is to give information that may be vital for selecting teams in the game.


Sent from my iPhone using Tapatalk

Cipher 8
07-05-2011, 09:09 AM
First I want to say A BIG THANK YOU to Solidice for doing this, not only this year but last year's I never did get around to posting much but I'll tell you right now I used your Team Info spreadsheet and gschwendt's NCAA Football 11 Playbook Spreadsheet (http://www.thegamingtailgate.com/forums/showthread.php?473-NCAA-Football-11-Playbook-Spreadsheet&) a lot when trying to pick a team. I go into great detail and analysis and put a lot of thought into it more then most do, or at least I'de like to think I do. Anyways I wanted to ask if you plan on including team's rivals in this year's Team Info Spreadsheet? I hope so but if not I can understand. I just ask because that's a big factor I usually decide on when it comes to picking teams.

My procress of picking a team:
1. Schools Recruiting Stats
2. Location (Weather - I like snow games)
3. Uniform Options
4. School's Rivals (The more the merrier and the longer running more storied rivalries are better, love getting them trophies and playing games with more meaning behind them.)
5. Mascot or School Name

Solidice
07-05-2011, 09:58 AM
Don't know if the speadsheet is based on the game or real life but, ECU is running the 3-4 this year instead of the 4-3.

most of the stuff is based on the game, with exception to the coaches names(which the game doesn't come with), and the real life pass %(so people can alter the run/pass ratio in the coaching screen for all the teams).

me9rob
07-05-2011, 04:48 PM
Wasn't sure how accurate you were trying to be with the spreadsheet, but for Southern California, Ed Orgeron is listed as the Defensive Coordinator in real life.

Sweet spreadsheet btw

Dr Death
07-05-2011, 04:56 PM
I just want to know how :Air_Force: can only pass 18% of the time. The name is A-I-R F-O-R-C-E... they should be throwing the ball all over the place... alright... back to your regularly scheduled program.

Solidice
07-05-2011, 05:20 PM
Wasn't sure how accurate you were trying to be with the spreadsheet, but for Southern California, Ed Orgeron is listed as the Defensive Coordinator in real life.

Sweet spreadsheet btw

I filled in the coaches names over a month ago, and I'm not sure how old the source I used was. It had most, if not all of the 2011 head coach changes correct though.

SmoothPancakes
07-05-2011, 07:09 PM
I just want to know how :Air_Force: can only pass 18% of the time. The name is A-I-R F-O-R-C-E... they should be throwing the ball all over the place... alright... back to your regularly scheduled program.

Because they are a run and option oriented offense, just like Army, Navy, and Georgia Tech. The service academies tend to stick to option and running offenses due to their major limitations when it comes to football players, specifically the weight limits they have to deal with for their offensive lines. The option offense is best suited for the limitations they are forced to deal with, as opposed to a normal passing offense.

morsdraconis
07-05-2011, 07:11 PM
Because they are a run and option oriented offense, just like Army, Navy, and Georgia Tech. The service academies tend to stick to option and running offenses due to their major limitations when it comes to football players, specifically the weight limits they have to deal with for their offensive lines. The option offense is best suited for the limitations they are forced to deal with, as opposed to a normal passing offense.

I think he was being facetious. ;)

SmoothPancakes
07-05-2011, 07:13 PM
I think he was being facetious. ;)

:D A little hard to tell sometimes online I'm afraid. :blush:

Dr Death
07-06-2011, 03:06 PM
Hey Solidice... you might want to make Dan Morrison the OC for :SMU: as he is listed as Assistant Head Coach/Offense on the :SMU: website. That would eliminate June Jones being in there twice, even though JJ is the OC.

Solidice
07-06-2011, 03:56 PM
Hey Solidice... you might want to make Dan Morrison the OC for :SMU: as he is listed as Assistant Head Coach/Offense on the :SMU: website. That would eliminate June Jones being in there twice, even though JJ is the OC.

updated that.

anyone know who the OC at Nevada is? or DC for San Diego State?

also, if anyone know who to put in for OC/DC for the other teams that the HC is both(GT for example), let me know

prime9
07-06-2011, 04:04 PM
Why are some team's overalls not on the spreadsheet?

gschwendt
07-06-2011, 04:06 PM
I'd put Grant Heard as Arkansas State's OC... Freeze will call all the plays but Heard has been Freeze's OC before.

Solidice
07-06-2011, 04:09 PM
Why are some team's overalls not on the spreadsheet?

because I don't know them. I don't have the game yet. the ones that are there are ones I got from pictures and videos.

prime9
07-06-2011, 04:12 PM
because I don't know them. I don't have the game yet. the ones that are there are ones I got from pictures and videos.

That's what I figured, but I was just making sure. The spreadsheet is amazing though, great job.

OptionMasta
07-07-2011, 02:21 PM
You did a nice job on the spreadsheet. What I will mention, though, is that if this isn't based entirely off of the game Pitt will be running an "Aggressive" No Huddle, spread offense this year and either a 3-4 or 3-3-5 stack defense (probably the later). In the spreadsheet you have Todd Graham listed as the coach but the offense is Pro Style and defense is 4-3 which is incorrect.

If this is based on the game I will be even more pissed at EA than usual this year and I apologize for the correction.

Solidice
07-07-2011, 03:53 PM
You did a nice job on the spreadsheet. What I will mention, though, is that if this isn't based entirely off of the game Pitt will be running an "Aggressive" No Huddle, spread offense this year and either a 3-4 or 3-3-5 stack defense (probably the later). In the spreadsheet you have Todd Graham listed as the coach but the offense is Pro Style and defense is 4-3 which is incorrect.

If this is based on the game I will be even more pissed at EA than usual this year and I apologize for the correction.
since I don't have the game yet, Offensive Style and default defensive playbook, as well as a few others are still based on NCAA 11. I have them marked in the first post on which is still based on NCAA 11.

OptionMasta
07-07-2011, 07:34 PM
My apologies. I must have misread the first post. I thought you were saying that everything was based on the game besides coaches, coordinators, and real life pass/run percentages. Good work!

OMRebel
07-08-2011, 01:36 AM
I'm pretty sure Ole Miss is a 3 star prestige. It had us as a 2 star in the dynasty video, but the rest have us at 3 stars.

Cipher 8
07-08-2011, 08:29 AM
I'm pretty sure Ole Miss is a 3 star prestige. It had us as a 2 star in the dynasty video, but the rest have us at 3 stars.

According to this (http://traditionsportsonline.com/ncaa-12-team-ratings-revealed) they are... I was surprised to see that UCLA is only a :2star:

BearDownUofA
07-10-2011, 12:53 AM
Arizona's offensive coordinator is Seth Littrell, not Robert Anae.

Cipher 8
07-10-2011, 05:11 PM
Are you going to be listing all the schools Recruiting Topic Ratings (Academic Prestige, Athletic Facilities, Television Exposure, etc) and their starting out Pipeline States?

I don't have much experience with spreadsheets or Google docs but the last couple of years I have used graph paper with pencils and a highlighters to do it. I ask because I like to compare between the schools and rather than just their OVR rating and prestige stars I look into their recruiting stuff. If you don't want to do it could I maybe add it to your spreadsheet or have you send me a copy so I don't have to start from scratch with all the info you already have listed, I'de have to figure out how it works but like I said I'm not familiar with the computer programs really but I am willing to take the time to do this if you aren't. Maybe I could just compile the info in a openoffice spreadsheet and then email you the document and you could add it to your spreadsheet? Or would i have to actually add it over the internet on googledocs? I'm just suggesting you add these two features to your spreadsheet but if you don't want to I'm willing to help do it.

Solidice
07-10-2011, 05:54 PM
Are you going to be listing all the schools Recruiting Topic Ratings (Academic Prestige, Athletic Facilities, Television Exposure, etc) and their starting out Pipeline States?

I don't have much experience with spreadsheets or Google docs but the last couple of years I have used graph paper with pencils and a highlighters to do it. I ask because I like to compare between the schools and rather than just their OVR rating and prestige stars I look into their recruiting stuff. If you don't want to do it could I maybe add it to your spreadsheet or have you send me a copy so I don't have to start from scratch with all the info you already have listed, I'de have to figure out how it works but like I said I'm not familiar with the computer programs really but I am willing to take the time to do this if you aren't. Maybe I could just compile the info in a openoffice spreadsheet and then email you the document and you could add it to your spreadsheet? Or would i have to actually add it over the internet on googledocs? I'm just suggesting you add these two features to your spreadsheet but if you don't want to I'm willing to help do it.

I'll update the recruiting ranks once I get the game. I might add in the pipeline states at the same time as updating the recruiting ranks..

OptionMasta
07-10-2011, 07:21 PM
Adding the recruiting information and pipeline states is a great idea.

Cipher 8
07-10-2011, 10:12 PM
I'll update the recruiting ranks once I get the game. I might add in the pipeline states at the same time as updating the recruiting ranks..

Okay otherwise if you need some help i can download it to open office I think, i know I did that with one other googledoc spreadsheet. I'm willing to help.

Also I don't know how you plan on doing the Pipeline states but there's two ideas I have.

Option A: Just have it list Pipeline all in one column. Example:

School|Pipeline States
LSU|LA, FL, TX, GA
UCLA|CA, AZ, HI


Or if you have the time and want to put in the effort...

Option B: Have it where there is a column for each state alphabetically (http://www.ilru.org/html/publications/directory/state_list.html) and then a check mark or dot when a school has a pipeline in that state. Example:

|||||||Pipeline States|||||
School|Alabama|Alaska|Arizona|Arkansas|California| Colorado|Connecticut|Delaware|District of Columbia|Florida|Georgia|Hawaii
LSU||||||||||*|*
UCLA|||*||*|||||||*

This way you can click on the column and sort through by certain states and see what schools have for example Texas as a pipeline state starting out. Rather then having to scroll through each school and see what states they have.

Just giving ya suggestions... ;)

and before I go I'de suggest to also list the schools recruiting topics in order as they appear when looking at a recruit in game. For example:

||||||Recruiting Topics||||||
School|Academics|Lifestyle| Coach Experience| Coach Prestige| Conference| Championship Contender| Athletic Facilities| Fan Base| Pro Potential| Stability| Tradition| Television Exposure
LSU|B|A+|A|A|A+|A+|A+|A+|A+|A|A+|A
UCLA|A+|A+|A|A|B+|C+|A+|B+|B+|B|B+|B *Based off last year's game.

JeffHCross
07-10-2011, 10:26 PM
and before I go I'de suggest to also list the schools recruiting topics in order as they appear when looking at a recruit in game. For example: I'm fairly certain that also matched the My Schools screen, just for ease of entering.

Cipher 8
07-10-2011, 10:29 PM
Yeah i just checked the spreadsheet as i hadn't looked at it in awhile and it looks like he's already got the school recruiting ratings already in there, my bad. But yeah Pipeline States (Option B) after that would be a nice addition.

Solidice
07-11-2011, 11:05 AM
I originally planned to do it like option A, but I could do it like option B. I had the recruiting ranks on there for NCAA 11, I just need to update the grades to NCAA 12

if you have a google account, I could add you to the list of people who can edit the spreadsheet on the site itself, if you wanted to help.

Solidice
07-11-2011, 04:42 PM
Thanks to gschwendt's playbook spreadsheet, I was able to update all the team's offensive play styles to NCAA 12.

Cipher 8
07-11-2011, 06:46 PM
I originally planned to do it like option A, but I could do it like option B. I had the recruiting ranks on there for NCAA 11, I just need to update the grades to NCAA 12

if you have a google account, I could add you to the list of people who can edit the spreadsheet on the site itself, if you wanted to help.

Well Option A is fine just saying Option B would allow users to search by state which schools has a pipeline there. I don't actually have a google account believe it or not but I'm sure I could make one. We'll see how it looks whichever way you decide to do it and if I get ambitious I'll contact you to help.

Solidice
07-11-2011, 07:03 PM
Well Option A is fine just saying Option B would allow users to search by state which schools has a pipeline there. I don't actually have a google account believe it or not but I'm sure I could make one. We'll see how it looks whichever way you decide to do it and if I get ambitious I'll contact you to help.

to save space so you don't have to scroll forever, I'll probably do option A on the main sheet, then later make a new page/sheet within the spreadsheet that will have the Option B look.

Solidice
07-12-2011, 09:44 AM
updated the team's default roster ratings and started on the impact players(got to Central Michigan). going to get a game or 2 in before inputting more.

Ndrake
07-12-2011, 11:19 AM
Could someone with the game post Nebraska's rivals, since they will have to change from the Big 12 teams to Big Ten teams.

Solidice
07-12-2011, 06:26 PM
updated impact players and rivals.

added rivals from NCAA 11:
Boise State-TCU
Colorado-Utah
Georgia Tech-Virginia Tech
Iowa-Nebraska

rivals removed from NCAA 11:
Colorado-Kansas State
Kansas State-Nebraska
Middle Tennessee State-North Texas
New Mexico-Utah

Solidice
07-12-2011, 06:54 PM
The 'Coach Loyalty' recruiting pitch for all the school will show up as a "C" on the spreadsheet. I entered the dynasty with contracts off so I can control 12 teams at a time and then just keep making new ones/deleting old ones without leaving dynasty mode. but since you can't use existing coaches once inside dynasty, I guess they will all be a C and it would take a very long time to keep going in and out of dynasty mode using existing coach one at a time.


although the coach prestige seems to the existing coach, so maybe it's supposed to be a C at the start?

mpk0303
07-12-2011, 06:55 PM
Hey any updates on how to get Roster names for PS3 yet?

Paakaa10
07-12-2011, 06:57 PM
Hey any updates on how to get Roster names for PS3 yet?

http://www.thegamingtailgate.com/forums/showthread.php?2644-BigWY-s-Named-Rosters-(PS3)

Solidice
07-13-2011, 12:01 PM
updated the recruiting pitches and pipeline states on the main sheet.

Solidice
07-14-2011, 07:10 PM
Updated the pride stickers

teams I saw with them, I think I got them all.

Arkansas - sledgehammer
Arkansas State - "I Will"
BYU - Cougar
Clemson - Paw Print
Florida State - Tomahawk
Fresno State - Bone
Georgia - Bone
Kentucky - Wildcat Paw
Louisiana Lafayette - Cajun Pepper
Louisiana Monroe- Maroon Star
Middle Tennessee State-Pegasus logo
Northwestern University - White Wildcat
Ohio State - Buckeye Leaf
SMU - Skull and Crossbones
Stanford - Axe Blade
Temple - Diamond
Toledo- Yellow Rocket and White Rocket
Vanderbilt - Ship Anchor


It seem Michigan State lost theirs?

Solidice
07-14-2011, 07:45 PM
Updated the default defensive playbook for each team. Is there any place in the game to see whether or not they are a no-huddle team?

ThatSnickelfritz
07-16-2011, 06:22 PM
Woah woah woah...in Edit Coaches you can edit the Pipeline states? That's pretty cool. Seems extremely subjective and alot of work though.

Solidice
07-16-2011, 07:47 PM
Woah woah woah...in Edit Coaches you can edit the Pipeline states? That's pretty cool. Seems extremely subjective and alot of work though.

the pipeline states are determine by the team's roster and where their players are from. you can't set them by editing the coaches.

roccogator
07-26-2011, 03:15 PM
Updated the pride stickers

teams I saw with them, I think I got them all.

Arkansas - sledgehammer
Arkansas State - "I Will"
BYU - Cougar
Clemson - Paw Print
Florida State - Tomahawk
Fresno State - Bone
Georgia - Bone
Kentucky - Wildcat Paw
Louisiana Lafayette - Cajun Pepper
Louisiana Monroe- Maroon Star
Middle Tennessee State-Pegasus logo
Northwestern University - White Wildcat
Ohio State - Buckeye Leaf
SMU - Skull and Crossbones
Stanford - Axe Blade
Temple - Diamond
Toledo- Yellow Rocket and White Rocket
Vanderbilt - Ship Anchor


It seem Michigan State lost theirs?

Did USF lose their pride stickers? I know the game used to only show them on the gold helmets, but now it defaults to the white one.

Solidice
07-26-2011, 05:29 PM
they do have them, I just somehow left them off that list, but in the sheet I do have them as having them.

Quo
08-05-2011, 12:35 PM
Very nice spreadsheet, Solidice. Just wanted to say thanks... that's a lot of work.

prime9
08-09-2011, 02:28 PM
Can anyone else not get the sortable things to work?

Solidice
08-10-2011, 09:50 PM
Can anyone else not get the sortable things to work?

you have to go to View > List, then you'll be able to sort it.

prime9
08-13-2011, 02:31 PM
you have to go to View > List, then you'll be able to sort it.

I do that and they don't work.

roccogator
08-22-2011, 12:32 PM
Hey Solidice, it does appear that USF does not have pride stickers any more. Played two seasons and no stickers on either helmet.