Discussion in 'Pre-Medical - MD' started by Depakote, May 10, 2008.

1. ### Depakote Pediatric Anesthesiologist Rocket Scientist PhysicianModerator EmeritusLifetime DonorClassifieds Approved

Joined:
Nov 2, 2004
Messages:
20,812
99
Status:
Attending Physician
Last year I made a spreadsheet that helped me organize my thoughts when I was deciding between some schools.

I've adapted it to help those of you that might still be deciding which offers to decline and those of you that might be getting off of waitlists in the coming weeks.

Here is how you use the sheet and interpret the results:

First. Take the criteria and put them in the order most important to you. Add any that you need.

Then give the schools subjective grades. If one school did particularly well in that area, give the school positive number, if the school did particularly poorly give it a negative number. For me, the rankings are a bit relative in that I had been to both schools prior to filling out the form, and if both were exactly tied, I gave both 0's. However, if both did well in an area, I would give both positive numbers, b/c a good performance in one area could outweigh a poor performance in another (e.x. all had good medical mission opportunities but School A got a better score, b/c I liked their's better and that point for Schools B and C could counteract something that I didn't like another area). The color coding was an after thought to make everything a little easier to understand.

Once you have the values totaled, use the sum function to total your raw score.

Now the spreadsheet should automatically calculate an adjusted score in the adjusted columns. This score is weighted by the value of the importance of each criteria (so curriculum is more important than gym and gets more weight in the adjusted score). The adjusted score will then be the one you want to look at if you are using this spreadsheet.

The multiplication factor is not entirely arbitrary, but it's not totally scientific.

the formula is y=1/(.25x)

This gives you a decreasing multiplier that looks something like this:

I played with the values and this seemed to give a good decreasing scale across ~20 criteria. It gives good strong points to the most important criteria by heavilly weighting them and then levels off at the later criteria.

If you're making major changes, you'll want to check to be sure that you haven't thrown off any of the calculations. If you don't have any experience with Excel, you might want to get some help with this.

Anyway, a lot of this was just gut reaction when assessing certain aspects of the schools. Go with what you think works... let me know if you have specific questions. Good luck.

Disclaimer: This is just a tool to help you make decisions. I pretty much found that the spreasheet just confirmed what I was thinking all along. If you disagree with what the spreadsheet says or wishing the results came out different, that's probably you making your decision right there.

Here is the spreadsheet and an example spreadsheet on how you might apply it:

#### Attached Files:

• ###### medical school comparison spreadsheets.zip
File size:
9.8 KB
Views:
1,493
Xzu, amerepedestrian and Sunbodi like this.

3. ### Depakote Pediatric Anesthesiologist Rocket Scientist PhysicianModerator EmeritusLifetime DonorClassifieds Approved

Joined:
Nov 2, 2004
Messages:
20,812
99
Status:
Attending Physician
I'll give this a bump

4. ### zpiff Spaceman

Joined:
Dec 6, 2007
Messages:
451
0
Status:
Medical Student
Thanks! I was trying to make something to this effect last night so I'll definitely take a look at this!

5. ### Depakote Pediatric Anesthesiologist Rocket Scientist PhysicianModerator EmeritusLifetime DonorClassifieds Approved

Joined:
Nov 2, 2004
Messages:
20,812
99
Status:
Attending Physician
going ahead and sticking this lest it get buried in X v. Y threads.

feel free to ignore if you don't find it useful.

Joined:
Nov 4, 2007
Messages:
409
0
Status:
Pre-Medical

7. ### Doc Henry blowin' in the wind

Joined:
Feb 4, 2007
Messages:
933
3
Status:
Pre-Medical
This looks like a good tool. I couldn't help myself from guessing about A, B, C and I had A=DMU B=AZCOM?? C=PCOM/CCOM. On the charts page I found out I was pretty much right about DMU and CCOM because it went from saying "A and C" to the real names. No such luck on B though, still just said B. In any event, thanks for the useful tool! I can only hope I'll br lucky enough to use it next year

8. ### Depakote Pediatric Anesthesiologist Rocket Scientist PhysicianModerator EmeritusLifetime DonorClassifieds Approved

Joined:
Nov 2, 2004
Messages:
20,812
99
Status:
Attending Physician
Ah, thought I had taken all the original school info out, guess I missed some.

Anyway, since you saw I'll go ahead and say that School B was KCUMB.

9. ### Depakote Pediatric Anesthesiologist Rocket Scientist PhysicianModerator EmeritusLifetime DonorClassifieds Approved

Joined:
Nov 2, 2004
Messages:
20,812
99
Status:
Attending Physician
I've revised and streamlined the spreadsheet.

If you used the other-one, there really isn't a functional difference. This one just has it all in one place.

File size:
106.5 KB
Views:
421
10. ### lucybug

Joined:
Jun 7, 2007
Messages:
46
0
Status:
Pre-Medical
This is great! I am glad to see others love excel just as much as I do.

11. ### Depakote Pediatric Anesthesiologist Rocket Scientist PhysicianModerator EmeritusLifetime DonorClassifieds Approved

Joined:
Nov 2, 2004
Messages:
20,812
99
Status:
Attending Physician
unstuck.

feel free to bump as needed.

12. ### Depakote Pediatric Anesthesiologist Rocket Scientist PhysicianModerator EmeritusLifetime DonorClassifieds Approved

Joined:
Nov 2, 2004
Messages:
20,812
99
Status:
Attending Physician

Joined:
Apr 6, 2006
Messages:
5,276
10
Status:
Resident [Any Field]
That is so classic! I just sat here for five minutes watching that over and over again!

14. ### paradocs we are In love with you

Joined:
Apr 2, 2007
Messages:
4,737
0
Status:
Medical Student
How fitting for the 2-7AM crew thread.

15. ### pianola MS2

Joined:
May 23, 2008
Messages:
6,072
14
Status:
Medical Student
WOW...yeah, that's all I have to say.

17. ### ButImLETired Prodigal member Moderator Emeritus

Joined:
May 27, 2008
Messages:
3,281
72
Status:
Resident [Any Field]
Bumping since it's already come up...

18. ### amerepedestrian ACCEPTED (DO), WAITLISTED (MD)

Joined:
Sep 21, 2017
Messages:
228
199
Status:
Pre-Medical
Using this and finding very helpful 9 years later. This should be a bulletin post!

Sunbodi likes this.
19. ### Lawper In 3D Rocket ScientistGold Donor

Joined:
Jun 17, 2014
Messages:
11,693
26,602
I actually recommend everyone to use @voteknope spreadsheet

The thread is found in Essential SDN Wisdom sticky.

20. ### amerepedestrian ACCEPTED (DO), WAITLISTED (MD)

Joined:
Sep 21, 2017
Messages:
228
199
Status:
Pre-Medical
Hmm...What makes you prefer that one to the one in this thread? I prefer the color-coding aspect of this one, but I guess the weighting system is more arbitrary/possibly not as useful.

Joined:
Jun 17, 2014
Messages:
11,693