NCAA Formcharts Now Posted

[gh]

On front page, compiled by Jack Pfeifer.... this is updated since the one that's in the July issue. Looks like a great team battle between Arizona State and LSU.

Teams
1 Arizona State 48
2 LSU 47
3 South Carolina 39
4 USC 37
5 Texas A&M 36
6 Michigan 29
7 Texas 26
8 Georgia 23
9 Nebraska 22
Auburn 22
11 UCLA 21
Oregon 21
Arkansas 21
14 Texas Tech 20
Stanford 20

[gh]

And now the men's by John Auka.... team battle still looks like a Florida State runaway.

[26mi235]

I now have my own form chart and here is the scoring; the second number is the rank from John Auka:

1 1 FloridaSt 61.0
2 2 LSU 44.8
3 5 Oregon 37.5
4 3 USC 36.5
5 4 Auburn 32.0
6 6 UCLA 30.3
7 7 Louisville 27.5
8 =9 Florida 26.0
9 Tennessee 23.8
9 8 Wisconsin 23.8
11 =9 Arizona 23.5
12 ArizonaSt 23.0
13 =9 NorthCarolina 22.5
13 Texas 22.5
15 Baylor 19.0
15 Stanford 19.0
17 BYU 18.8
18 TexasA&M 15.0
19 Mississippi 14.3
19 TexasTech 14.3

[dl]

Interesting to see that Kerron Stewart is only running the 200 (and 4x1) this year.

[richxx87]

On the women's form chart there seems to be a mistake or two on the 4x400, perhaps just a typo.

On the w4x400 it says USC will get 6th. The USC 4x4 is fully 2 seconds behind conference rival UCLA for instance, and currently ranked 24th on the NCAA list. ... So what have they done in the past two weeks that makes them the 6th best? Surely that must be a typo. Also, how does Miami's 3:32 team not make the top 10, someone injured?

Lastly, Rhonda Watkins is entered in both the Long Jump and High Jump (underestimate her at your peril).

[richxx87]

Also...
Israel has been cleared to compete (by the NCAA) and with a pb of 208-9, should be in the top 5.

[jazzcyclist]

Interesting to see that Kerron Stewart is only running the 200 (and 4x1) this year.

This along with some other surprises was already mentioned on the "Regionals Declarations" thread:

http://mb.trackandfieldnews.com/discuss ... hp?t=25473

[AS]

As someone with less than perfect recall on which college is in a particular region, is there any chance you could add the region to the form guide (so we can see where to look for their performance over the weekend)?

[gh]

sorry, no chance

[tandfman]

As someone with less than perfect recall on which college is in a particular region, is there any chance you could add the region to the form guide (so we can see where to look for their performance over the weekend)?

You could always refer to the results of last year's Regionals to figure that out. I don't think any school has switched regions this year.

[26mi235]

As someone with less than perfect recall on which college is in a particular region, is there any chance you could add the region to the form guide (so we can see where to look for their performance over the weekend)?

There is a relatively quick way to do this in a spreadsheet, except I need to find one more command; I will edit this when I have more time. This will only get you schools that have entrants, but that is probably all that matters. You could duplicate this for men and women, but you probably do not need to, thus it only needs to be done 3 times.

gh, would you mind if I pasted the results into a thread?

1 copy the entire regional data into Excel.

2 with the data all in a block, use AltDE, then select Fixed Width, then Next (screen)

3 in the window, put lines just before the school name and after the school name and before the time (the times for the 5000 take more room than for the 100m, so leave room to the left)

4 get rid of the columns that do not have the school name (not necessary but usseful)

5 Sort the column with names alphabetically, delete rows that have things like 'heat ... or top 3, which will come from the rows that had all the explanation of heats etc. then sort again. This gives you a list of all the schools with entrants, the problem is that schools show up (Florida St 25 times for the mens East).

6 Block the data, the do Data, select PivotTable and click through the first several questions (default yes is the simplest).

7 When you have the Pivot table shell it will have a section on the right side of screen called PivotTable Field List; drag the listed item (e.g., Albany) to the left portion labeled Drop Row Fields here. This will give a list of unique schools, you can copy this row elsewhere (I am pasting it here). There are 93 schools with 491 entries (omits the relays). Be aware that sometimes schools are listed by more than one name (Florida State and Florida St)

Mens East Schools

Albany
American
App. State
Army
Bethune-Cookman
Binghamton
Boston College
Boston Univ.
Brown
Bucknell
Buffalo
Campbell
Charleston Sthrn
Charlotte
Clemson
Coastal Carolina
Colgate
Columbia
Connecticut
Coppin St.
Cornell
Dartmouth
Davidson
Duke
Duquesne
E. Carolina
FDU
FL Intn'l
Florida
Florida St.
Fordham
Gardner-Webb
George Mason
Georgetown
Georgia
Georgia St.
Georgia Tech
Hampton
High Point
Holy Cross
Howard
Iona
La Salle
Lafayette
Lehigh
Liberty
Maine
Manhattan
Maryland
Maryland-ES
Miami
Monmouth
Morgan St.
Mt. St. Mary's
Navy
NC A&T
NC State
New Hampshire
Norfolk St.
North Carolina
Northeastern
Penn St.
Pennsylvania
Pittsburgh
Princeton
Providence
Radford
Rhode Island
Rider
Robert Morris
Rutgers
S. Carolina
S. Florida
Sacred Heart
SC State
School
Seton Hall
St. Francis-NY
St. Francis-PA
St. Joseph's
Stony Brook
Syracuse
UMBC
UNC-Wilmington
VA Tech
VCU
Villanova
Virginia
W. Carolina
Wake Forest
William & Mary
Winthrop
Yale


gh, would you mind if I pasted the results into a thread?

[richxx87]

okay then, that's pretty helpful.

But what about the typo that has USC women getting 6th in the 4x4? I would be seriously interested to find out what's going on. Did Alyson Felix (who attends USC as a student only) decide to run the 4x4 and bring along Sanya Richards (I think she still technically has some eligibility left) to run the anchor for the Trojan gals?

[26mi235]

okay then, that's pretty helpful.

But what about the typo that has USC women getting 6th in the 4x4? I would be seriously interested to find out what's going on. Did Alyson Felix (who attends USC as a student only) decide to run the 4x4 and bring along Sanya Richards (I think she still technically has some eligibility left) to run the anchor for the Trojan gals?

With those two added to the team, the move would not be to fourth.

This event is one that can be estimated without the team running all of the members. Suppose that a team had a 400m runner that had an open 400 in 52 but who had not run with the rest of the team up until regionals (or after even). Say she replaces a runner who has hit 58. Now it might be pretty easy to expect a 6 second improvement and to forecast placement based on that information.

[Bruce Kritzler]

One guideline that helps coordinate teams with regions is that all the teams (I think) in a state compete in the same region. So it's divided along state lines.
Exception may be UTEP and TX Tech in midwest?

[gh]

One guideline that helps coordinate teams with regions is that all the teams (I think) in a state compete in the same region. So it's divided along state lines.
Exception may be UTEP and TX Tech in midwest?

Yes, is currently broken along state lines, which means that Conferences sometimes get split up.

The UTEP/TT exception is part of the proposed new setup (which I posted yesterday somewhere here on the board) which would shunt schools westward from the three eastern-most Regions.