[antdroid]

Quote: Originally Posted by Anarchy666

ok then 30 and 31 (no change) 29 & 28 (+1) 27 & 26 (+2) 25 & 24 (+3) 23 & 22 (+4) 21 & 20 (+5) 19 & 18 (+6) 17 & 16 (+7) 15 & 14 (+8) 13 & 12 (+9) 11 & 10 (+10) 9 & 8 (+11) 7 & 6 (+12) 5 & 4 (+13) 3 & 2 (+14) 1 & 0 (+15) basically my modding suggestion compacts the possible number of PPOE ratings from 32 down to 17, and the minimum rating would be 15 (which sits in the Average range, but hopefully there won't be any players that progress too slowly and the rate players progress by generally should be a bit higher). i really wish team info was amongst the info in the player db, as you could then give players on smaller colleges a bigger ratings boost, as those are the teams that really need it, usually unable to recruit effectively to fill holes in rosters and slow-progressing guys recruited from a season or two before having to step up when the seniors leave the only other ways of filtering it are by OVR rating (under 93) and Year (Freshmen and Sophs).

the team info is embedded in the player id number.

for example Air Force is 70 to 139

you can use this function to find team ID
=ROUNDDOWN(**PLAYER ID COLUMN**/70,0)

=vlookup()

Team Name Team ID Roster Numbers
Air Force 1 70
Akron 2 140
Alabama 3 210
Arizona 4 280
Arizona State 5 350
Arkansas 6 420
Arkansas State 7 490
Army 8 560
Auburn 9 630
Ball State 10 700
Baylor 11 770
Boise State 12 840
Boston College 13 910
Bowling Green 14 980
Buffalo 15 1050
BYU 16 1120
Cal 17 1190
UCF 18 1260
Central Michigan 19 1330
Cincinnati 20 1400
Clemson 21 1470
Colorado 22 1540
Colorado State 23 1610
Duke 24 1680
ECU 25 1750
Eastern Michigan 26 1820
Florida 27 1890
Florida State 28 1960
Fresno State 29 2030
Georgia 30 2100
Georgia Tech 31 2170
Hawaii 32 2240
Houston 33 2310
Idaho 34 2380
Illinois 35 2450
Indiana 36 2520
Iowa 37 2590
Iowa State 38 2660
Kansas 39 2730
Kansas State 40 2800
Kent State 41 2870
Kentucky 42 2940
Louisiana Tech 43 3010
Louisville 44 3080
LSU 45 3150
Marshall 46 3220
Maryland 47 3290
Memphis 48 3360
Miami 49 3430
Miami University 50 3500
Michigan 51 3570
Michigan State 52 3640
Mid Tenn State 53 3710
Minnesota 54 3780
Mississippi State 55 3850
Missouri 56 3920
Navy 57 3990
Nebraska 58 4060
Nevada 59 4130
New Mexico 60 4200
New Mexico State 61 4270
North Carolina 62 4340
NC State 63 4410
North Texas 64 4480
UL Monroe 65 4550
Northern Illinois 66 4620
Northwestern 67 4690
Notre Dame 68 4760
Ohio 69 4830
Ohio State 70 4900
Oklahoma 71 4970
Oklahoma State 72 5040
Ole Miss 73 5110
Oregon 74 5180
Oregon State 75 5250
Penn State 76 5320
Pittsburgh 77 5390
Purdue 78 5460
Rice 79 5530
Rutgers 80 5600
San Diego State 81 5670
San Jose State 82 5740
SMU 83 5810
South Carolina 84 5880
Southern Miss 85 5950
UL Lafayette 86 6020
Stanford 87 6090
Syracuse 88 6160
TCU 89 6230
Temple 90 6300
Tennessee 91 6370
Texas 92 6440
Texas A&M 93 6510
Texas Tech 94 6580
Toledo 95 6650
Tulane 96 6720
Tulsa 97 6790
UAB 98 6860
UCLA 99 6930
Connecticut 100 7000
UNLV 101 7070
USC 102 7140
Utah 103 7210
Utah State 104 7280
UTEP 105 7350
Vanderbilt 106 7420
Virginia 107 7490
Virginia Tech 108 7560
Wake Forest 109 7630
Washington 110 7700
Washington State 111 7770
West Virginia 112 7840
Western Michigan 113 7910
Wisconsin 114 7980
Wyoming 115 8050
Alabama A&M 116 8120
Alabama State 117 8190
Alcorn State 118 8260
Ark - Pine Bluff 119 8330
Bethune-Cookman 120 8400
Brown 121 8470
Columbia 122 8540
Cornell 123 8610
Dartmouth 124 8680
Delaware State 125 8750
Florida A&M 126 8820
Grambling State 127 8890
Hampton 128 8960
Harvard 129 9030
Howard 130 9100
Jackson State 131 9170
Miss Valley State 132 9240
Morgan State 133 9310
Norfolk State 134 9380
NC A&T State 135 9450
Penn 136 9520
Prairie View A&M 137 9590
Princeton 138 9660
S Carolina State 139 9730
Southern 140 9800
Texas Southern 141 9870
Yale 142 9940
Troy 143 10010
USF 144 10080
Delaware 145 10150
Western Kentucky 211 14770
Florida Atlantic 229 16030
FIU 230 16100