Ortho Match 2015 Spreadsheet

Link to old thread: Click Here

Hey all, match day is tomorrow! Congrats to everyone that matched.

As seen last year, there was a spreadsheet made by orthostudent1 that listed all of the places students matched at. As many of you know, the Urology Match spreadsheet (just google it) is probably one of the biggest and best resources available to students participating in urology since it contains a lot of equations and of the like in a presentable manner. I wanted to mimic that and bring that type of information to the ortho medical student community. We all know that numbers aren't everything, but having this type of information available is invaluable. It's success can only be obtained if we get enough 4th years that matched to fill it out.

What I did was look up the instutitions participating in ERAS (155 programs) and looked up the associated slot number on orthogate via the review section. It may have been inefficient to find the # of slots, but I couldn't find another source that listed all the slots each program took. There were a couple programs I had trouble with, National capitol consortium and NSLIJHS/Hofstra North Shore. If anyone knows the slot #'s for those programs, let me know.

Just like the urology spreadsheet, I made a summary page (just tweaking the appropriate equations to make it applicable to the list I made) that will display various stats that students put into the main spreadsheet.

In putting your information, do not put your scores along side your name, just put them in a random row in the spreadsheet to preserve anonymity.

If I placed the incorrect amount of spots for a given program that you matched to, please reply to this thread! A few of the equations rely on the number of rows in the spreadsheet, so if anyone adds a row to the spreadsheet, it may break a few things T_T

The summary page will not work unless numbers and Y/N's are placed.

Enjoy guys, I really hope this helps a lot of people out (I sure as hell know it's extremely helpful for me on my end). If you have any suggestions, please let me know!

docs.google.com/spreadsheets/d/1_Rk7nMP7...hyU/edit?usp=sharing

Thanks for putting this together, no doubt its a great resource for those applying to ortho in the future.

I will say that I noticed many of the slot numbers are off for programs. Rather than list them here and edit them all, its probably better for people to just edit the number of slots as they enter their name tomorrow.

Do you know where I can get those slot numbers by chance? A few of the equations, the ones that have y/n, rely on me putting in the accurate amount of rows (right now its from row 4 to row 666). Anything more could throw off the numbers unless I change the 666 number to a higher value

EDIT: Nvm. I just changed the 666 to an arbitrary 900 to take into account people adding more slots. That'll at least be a temp solution

EDIT 2: If any have you have the accurate number of slots for whatever institution you matched in, please post!

Carolinas Medical Center had 5 spots per year, not three.

This is truly a great resource. However, I'd like to make a suggestion for a slight tweak to the format. This data is for the most part compiled by the NRMP, with the exception that it also shows some Step score outliers, # publications and number of places applied to (all the other points correlate.. ie the higher your step score, the more interviews offered).

The data in this sheet can be significantly enhanced to allow future applicants to make better decisions on how to apply. The big debate I've seen over the past few years is how many programs to target in order to get a sufficient number of interviews (and ultimately match). The "average" applicant that's trying to maximize his/her chances is applying to 80+ programs with still very little success in obtaining more than 10 interviews. That's great news for the AAMC that's pocketing $2000 per applicant, and although in the long run doesn't mean much, it's a burden to the ones that are living off loans and having to support their families through this costly process.

I am proposing that the right-sided information be linked to the specific program as opposed to a random order. That allows the "average" applicants to see which programs are only considering individuals with 270+ step scores only or the research-heavy candidates. I understand it comes at a slight cost of losing anonymity, but I highly doubt that many really care about names of individuals that matched (apart from your buddies or people you met along the way). The ability to analyze program specifics can be incredibly useful and will allow applicants to make more informed decisions about where to apply, which saves them money and the stress of applying to a bunch of programs with very little response. I know this will help many people in the long run as the field has become painfully competitive and something has to change about the way we approach this process.

Hey ak2788,

What you're asking for is best attained by replying on the "Residency Review" thread that gets posted every year. I think people do value their privacy because who wants their co-residents to know they have the lowest Step 1 score, fewest number of interviews, matched 8th on their ROL while everyone else ranked the program 1st, etc. Once you attach the right sided information to programs, it becomes really easy to figure out whose data is whose and that's not a slight cost.

I encourage people to fill out the "Residency Review Thread 2014-2015," as the previous years' responses have been pretty informative. This spreadsheet is great for getting a head start on meeting future co-residents, but otherwise it seems as if it is attempting to replicate "Charting Outcomes of the Match" on a much smaller scale.