Ranking excel problem

jerfep · Feb 21, 2011

I need to rank these colleges by how important they are but my problem is these categories from the data like comparing the expenditure per student to academic reputations is really hard to make an equation ranking of especially if I am going to rank these colleges based from all the the following categories:

1. [FONT=&quot]Acade-mic Rep. (this is based from a survey so under the data it is already rank which # 1 and etc. but not in order)
2. [/FONT][FONT=&quot]Students from top 10% (students who had been in top 10% of their high school class) [/FONT]
[FONT=&quot]3. SAT/ACT 25th-75th Percentile [/FONT]
4. [FONT=&quot]Accept. Rate [/FONT]
5. [FONT=&quot]Yield (the percentage of students who got admitted and actually decided to attend that school)[/FONT]
6. [FONT=&quot]Expenditure per Student[/FONT]
7.[FONT=&quot] Student/Faculty Ratio
[/FONT]8.[FONT=&quot]Classes of 50+ (percent of courses in which there are 50 or more students)[/FONT]
9.[FONT=&quot]Alumni Giving Rate (percent of alumni students who donate to the college)[/FONT]
10.[FONT=&quot]Freshman Retention Rate (meaning freshmen who made it to sophomore year)[/FONT]
11.[FONT=&quot]1995 Grad. Rate[/FONT]
12.[FONT=&quot]Predicted Grad Rate[/FONT]

I am new in excel so making a rank function based on these categories is hard.

 <table class="MsoNormalTable" style="width: 382px; margin-left: 4.65pt; border-collapse: collapse; height: 745px;" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 51.75pt;"> <td style="width: 64.55pt; padding: 0in 5.4pt; height: 51.75pt;" width="86" nowrap="nowrap">

INSTITUTIONS

</td> <td style="width: 42pt; border: 1pt solid black; padding: 0in 5.4pt; height: 51.75pt;" width="56">

[FONT=&quot]Acade-mic Rep. [/FONT]

</td> <td style="width: 45.2pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="60">

[FONT=&quot]Students from top 10% [/FONT]

</td> <td style="width: 47.2pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="63">

[FONT=&quot]SAT/ACT 25th-75th Percentile [/FONT]

</td> <td style="width: 42.7pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="57">

[FONT=&quot]Accept. Rate [/FONT]

</td> <td style="width: 38.2pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="51">

[FONT=&quot]Yield[/FONT]

</td> <td style="width: 54.9pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="73">

[FONT=&quot]Expenditure per Student[/FONT]

</td> <td style="width: 71pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="95">

[FONT=&quot]Student/Faculty Ratio [/FONT]

</td> <td style="width: 43.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="58">

[FONT=&quot]Classes of 50+[/FONT]

</td> <td style="width: 41.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="55">

[FONT=&quot]Alumni Giving Rate [/FONT]

</td> <td style="width: 47.4pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="63">

[FONT=&quot]Freshman Retention Rate [/FONT]

</td> <td style="width: 39.35pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="52">

[FONT=&quot]1995 Grad. Rate[/FONT]

</td> <td style="width: 46.3pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0in 5.4pt; height: 51.75pt;" width="62">

[FONT=&quot]Predicted Grad Rate [/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border: 1pt solid black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Benedict Arnold U. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]30[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]82[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1230 - 1410[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]39[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]49[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$15,874 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]13/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]13[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]50[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]97[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]94[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]81[/FONT]

</td> </tr> <tr style="height: 39pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 39pt;" width="86">

[FONT=&quot]Cal Ripken Tech [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="56">

[FONT=&quot]18[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="60">

[FONT=&quot]85[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]1260 - 1530[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="57">

[FONT=&quot]26[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="51">

[FONT=&quot]38[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="73">

[FONT=&quot]$25,878 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="95">

[FONT=&quot] 8/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="58">

[FONT=&quot]9[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="55">

[FONT=&quot]43[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]95[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="52">

[FONT=&quot]89[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="62">

[FONT=&quot]92[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Diplomas-R-US [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]1[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]92[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1340 - 1550[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]14[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]60[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$32,417 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot] 8/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]13[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]62[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]97[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]95[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]93[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Duchess [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]7[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]81[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1250 - 1440[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]34[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]45[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$22,285 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]13/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]11[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]20[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]95[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]89[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]87[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Emory Board U. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]11[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]83[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1270 - 1440[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]33[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]48[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$32,022 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot] 6/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]16[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]38[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]95[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]87[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]87[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Fly-by-Night U. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]11[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]87[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1290 - 1470[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]29[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]40[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$31,652 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]14/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]7[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]41[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]96[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]95[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]90[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Hall Institute [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]3[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]92[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1370 - 1560[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]12[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]75[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$42,902 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot] 12/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]21[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]48[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]96[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]97[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]97[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Karweit Kollege [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]3[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]87[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1330 - 1530[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]19[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]55[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$36,643 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]13/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]14[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]31[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]97[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]93[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]97[/FONT]

</td> </tr> <tr style="height: 39pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 39pt;" width="86">

[FONT=&quot]Koresh Divinity School [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="56">

[FONT=&quot]7[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="60">

[FONT=&quot]97[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]1400 -1580[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="57">

[FONT=&quot]27[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="51">

[FONT=&quot]43[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="73">

[FONT=&quot]$73,967 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="95">

[FONT=&quot] 6/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="58">

[FONT=&quot]5[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="55">

[FONT=&quot]36[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]94[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="52">

[FONT=&quot]85[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="62">

[FONT=&quot]99[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Londontown U. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]7[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]76[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1280 - 1460[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]43[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]26[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$61,704 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]14/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]11[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]37[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]94[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]87[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]88[/FONT]

</td> </tr> <tr style="height: 39pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 39pt;" width="86">

[FONT=&quot]Mr. Roger's University [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="56">

[FONT=&quot]11[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="60">

[FONT=&quot]81[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]1260 - 1440[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="57">

[FONT=&quot]40[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="51">

[FONT=&quot]38[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="73">

[FONT=&quot]$29,760 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="95">

[FONT=&quot] 12/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="58">

[FONT=&quot]10[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="55">

[FONT=&quot]23[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]96[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="52">

[FONT=&quot]90[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="62">

[FONT=&quot]82[/FONT]

</td> </tr> <tr style="height: 39pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 39pt;" width="86">

[FONT=&quot]North-Northwestern U. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="56">

[FONT=&quot]24[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="60">

[FONT=&quot]67[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]1180 - 1380[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="57">

[FONT=&quot]56[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="51">

[FONT=&quot]23[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="73">

[FONT=&quot]$54,020 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="95">

[FONT=&quot] 10/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="58">

[FONT=&quot]7[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="55">

[FONT=&quot]94[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]94[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="52">

[FONT=&quot]85[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="62">

[FONT=&quot]81[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Offshore U. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]11[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]88[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1330 - 1520[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]23[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]46[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$31,491 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot] 10/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]13[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]42[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]97[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]94[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]90[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Pilaf U. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]30[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]81[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1230 - 1390[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]51[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]26[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$30,163 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]14/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]7[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]91[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]91[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]90[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]82[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Smartmouth [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]24[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]64[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1220 - 1370[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]58[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]30[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$25,490 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]13/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]5[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]91[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]91[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]83[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]77[/FONT]

</td> </tr> <tr style="height: 39pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 39pt;" width="86">

[FONT=&quot]Virginia Macho Inst. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="56">

[FONT=&quot]3[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="60">

[FONT=&quot]95[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]1350 - 1550[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="57">

[FONT=&quot]20[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="51">

[FONT=&quot]54[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="73">

[FONT=&quot]$45,507 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="95">

[FONT=&quot] 9/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="58">

[FONT=&quot]9[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="55">

[FONT=&quot]45[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="63">

[FONT=&quot]98[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="52">

[FONT=&quot]95[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 39pt;" width="62">

[FONT=&quot]94[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Votre Dame [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]11[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]84[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1341 - 1438[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]24[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]43[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$32,738 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]18/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]9[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]27[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]95[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]88[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]86[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Wawa Institute [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]3[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]74[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1270 - 1470[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]71[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]31[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$40,686 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot] 7/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]5[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]47[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]91[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]86[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]89[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Whattsamatta U. [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]1[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]97[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1380 - 1540[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]27[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]53[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$37,376 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot] 10/1[/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]12[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]42[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]97[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]89[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]95[/FONT]

</td> </tr> <tr style="height: 26.25pt;"> <td style="width: 64.55pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0in 5.4pt; height: 26.25pt;" width="86">

[FONT=&quot]Zanvyl Hopkins [/FONT]

</td> <td style="width: 42pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="56">

[FONT=&quot]11[/FONT]

</td> <td style="width: 45.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="60">

[FONT=&quot]86[/FONT]

</td> <td style="width: 47.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]1290 - 1470[/FONT]

</td> <td style="width: 42.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="57">

[FONT=&quot]21[/FONT]

</td> <td style="width: 38.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="51">

[FONT=&quot]48[/FONT]

</td> <td style="width: 54.9pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="73">

[FONT=&quot]$23,889 [/FONT]

</td> <td style="width: 71pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="95">

[FONT=&quot]13/1 [/FONT]

</td> <td style="width: 43.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="58">

[FONT=&quot]13[/FONT]

</td> <td style="width: 41.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="55">

[FONT=&quot]39[/FONT]

</td> <td style="width: 47.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="63">

[FONT=&quot]96[/FONT]

</td> <td style="width: 39.35pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="52">

[FONT=&quot]93[/FONT]

</td> <td style="width: 46.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0in 5.4pt; height: 26.25pt;" width="62">

[FONT=&quot]87[/FONT]

</td> </tr> </tbody></table>

Ruddles · Feb 21, 2011

You could do this:-

Rank each college in each category so you get twelve additional columns (N-Y).
Create an 'average ranking' column (col Z) which contains the average of the twelve individual ranking columns (N-Y).
Finally rank column Z.

You'll need to flatten the SATs score into an average so that RANK can treat it as a numeric value (=(RIGHT(D2,4)+LEFT(D2,4))/2) - same goes for the student/faculty ratio (=VALUE(LEFT(H2,FIND(":",H2)-1))). Do that in a separate 'helper' column and perform the RANK on the 'helper' column.

When you write the RANK formulae, take care to rank each column correctly: for example student/faculty ratio would be 'lowest is best' whereas freshman retention rate is 'highest is best'.

Once you get it working, you might decide that some categories deserve a higher weighting than others - for example you might consider that the student/faculty ratio is twice as important than the predicted graduation rate - so you could apply a weighting or multiplier to each one to give them more or less prominence.

jerfep · Feb 21, 2011

(=VALUE(LEFT(H2,FIND(":",H2)-1))) is supposed give numbers right? but when plug it in it did not work so I cant rank it yet but this ":" quote is that what I need to work on

Ruddles · Feb 21, 2011

Code:

[B]=[COLOR=blue]VALUE(LEFT(H2,[COLOR=red]FIND(":",H2)[/COLOR]-1))[/COLOR][/B]

The bit in red finds the position of the colon, so if the cells holds 50:1 it will return 3. The LEFT returns the leftmost 2 characters (because you subtract 1), so you get 50. VALUE turns it from a string into a number.

That's assuming the student/faculty ratio is in column H.

Ranking excel problem

jerfep

New Member

Excel Facts

Ruddles

Well-known Member

jerfep

New Member

Ruddles

Well-known Member

Similar threads

Forum statistics

Share this page

Ranking excel problem

jerfep

New Member

Excel Facts

Ruddles

Well-known Member

jerfep

New Member

Ruddles

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock