131

**Where should I go next fall? / Re: So F***ing confused! HELP!**

« **on:**March 04, 2005, 08:49:47 PM »

I used a table similar to this to pick which schools I originally applied to. If you know how to use excel, then this might help you quantify your feelings about the schools and their programs.

You should be able cut and paste this into excel. Replace the total (85) with this formula

=B3*$B$2+C3*$C$2+D3*$D$2+E3*$E$2

Then drag the formula straight down to the other totals.

Then change the values for each school and each criterion to match how you feel about the school. So if the location for Hastings is about 3 times better than Kent, change the Hastings number to a 3.

Finally, play with the multiplier. If Ranking is twice as important as Location, then make sure the multiplier is twice the location multiplier.

The general idea is that the best school for you will have the highest number. This is something to play with over a few days. It will eventually help you sort out what are the most important criterion to you and how you really feel about each school.

Of course, if you don't know excel, then it might just drive you crazy!

Ranking | Location | Debt | Curriculum | Total | |

Multiplier | 5 | 8 | 2 | 4 | |

American | 3 | 5 | 1 | 7 | 85 |

Brooklyn | 3 | 5 | 1 | 6 | 81 |

Hastings | 10 | 8 | 1 | 5 | 136 |

IU-B | 5 | 2 | 1 | 4 | 59 |

Kent | 3 | 1 | 3 | 3 | 41 |

Santa Clara | 3 | 10 | 1 | 2 | 105 |

Wisconsin Madison | 10 | 0 | 1 | 1 | 56 |

You should be able cut and paste this into excel. Replace the total (85) with this formula

=B3*$B$2+C3*$C$2+D3*$D$2+E3*$E$2

Then drag the formula straight down to the other totals.

Then change the values for each school and each criterion to match how you feel about the school. So if the location for Hastings is about 3 times better than Kent, change the Hastings number to a 3.

Finally, play with the multiplier. If Ranking is twice as important as Location, then make sure the multiplier is twice the location multiplier.

The general idea is that the best school for you will have the highest number. This is something to play with over a few days. It will eventually help you sort out what are the most important criterion to you and how you really feel about each school.

Of course, if you don't know excel, then it might just drive you crazy!