ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2019-2020 Emergency Medicine Applicant Spreadsheet@@
2
3
4
5
6
7
8
Welcome! This spreadsheet is the continuation of a long-time tradition and has been adapted and modified from previous years for our current cycle. The intent is to provide a central location for applicants to research information about residency programs, view stats of other applicants and where they are applying, share information about travel, interviews, hotels, and general advice. This spreadsheet should not be an official guide for you to select a residency. Users self-report information and therefore you must take everything you read on here as opinion and with a grain of salt. I encourage ALL applicants to participate. Though you will see a skew towards high-stat applicants being the majority, it helps immensely to see applicants with all different types of scores/backgrounds/experiences.RULES: There are no rules. We are all adults so please respect one another, act profesionally and report accurate information. If you try and deface or delete the spreadsheet we can easily just restore it from an earlier version so please don't waste anyone's time. COMMENTS THAT ARE RACIST, ATTACKING SOMEONE'S RELIGION OR SEXUALITY WILL NOT BE TOLERATED.Tips:
9
10
Any form with a purple box/white lines indicates there is a google form associated with that spreadsheet. When you fill out the associated google form by clicking on the bright green link at the top of the spreadsheet, the information will automatically populate onto the spreadsheet after the form is submitted.Please don't list your username as "anonymous" if you want your interview invites tally to populate correctly
11
12
You can protect the any cells that you free text into by doing the following: Select the cell(s) -> Click "Data" up top -> Protected sheets & ranges -> click "Add a sheet or range" -> No description needed, should autopopulate the cell you're working with -> Set permissions -> Restrict who can edit to "you and owner" -> Done (if anyone deletes your stuff and locks it, email me and I can fix it)
13
14
15
16
17
18
Please contact me for any issues or questions:
19
emergencymedicinespreadsheet@gmail.com
20
emergencymedicinespreadsheet@gmail.com
21
22
23
SuggestionResponse
24
25
Just a thought for the benefits tab...a lot of this info doesn't actually come out until after matching/ during orientation... maybe keep it open into June and encourage people to come back and fill in what they know now? My program was shady about these initially but now we have details and I'm happy to fill in shifts, meal benefits, parking, swag, etcg
26
for next year can we add a place for extraneous info for programs? like where to live, random things you might need to pack, etcwait until next year to make the suggestion; go study for your shelf and get off the spreadsheet<-jesus calm down gunner < things to pack? are we fucking going on a camping trip?
yes we are+1>I love fucking camping trips
27
Can we extend the Popularity rank columns to 10 or so?no, defeats the point of checking popularity, which would really be ranks 1-3
Can we add a DNR column?
28
Text wrap all the columns/rows in ROL tab. Doesn't transfer well from google forms.
29
Popularity tab needs CA St. Joe's Stockton
No1 wants to go there dude who cares
30
STEPHANOP where did you match!
She matched at Baystate!
31
32
33
Can new name and shames be placed on top?
34
Can you add the Vegas programs to the ROL questionnaire? done
35
Can the ROL tab be wrapped so we can actually read the latest entries?
done
36
Name and shame time?in progress
37
Can we expand the column BH on the Rank Order List page? The amount of text in some of those boxes make everything stretched and hard to readdone
38
Can we unlock post-iv tab??? <+1
39
can we sticky Reddit.com/r/ by
40
41
Can you create a google form for post-iv comm so people are posting their comms?done
42
can the program benefits tab be restored??
Restored, thanks for catching that it was deleted
43
Can you bring back the Jan/Feb dates looks like it got deleted. Deleted again. Thank you! >>Donewowwwim going to restore and lock it for a while
44
Ranks 1/2/3 tab got locked but is missing the university of alabama row again. I don't want whatever pissed off resident or faculty member to successfully delete that conversation
Restored
45
In the ROL, can we make the columns a bit wider so that the rows fit on the screen better? Some people get really wordy and it has problems all fittingDone
46
Done- G range and onward is now open
47
Can "CAN RESIDENTS PLEASE FILL THE GAPS IN PROGRAM BENEFITS? cme money, 401k match?, SAEM/ACEP included PGY1/3?, whether you pay for insurance (vs free)?, etc" and "Heads up: Post-IV Communications is frozen till column K. Make sure you fill out accurate information after column K :)" be sticked to top to chat?Done
48
can 123 tab be restored? and maybe can the tabs be locked so they dont keep being deleted. under 10 is gone again too...Done
49
Can the pros/cons for university of alabama be restored and added as a protected range so they can't continue to be repeatedly deleted?no, someone keeps deleting University of Alabama - Birmingham due to overwhelmingly negative comments >>>>
That's the one, thanks >
is this southern alabama?
ok let me fix it<<I think I restored the one you're talking about, let me know if that's the right oneNo prob
50
there is no option for PA - WellSpan York Hospital on ROL tab (program has been around for 30 years....)Added
51
can someone fix the post IV communciation tab? things are deleted and cells are shifted
fixed and locked now
52
Some weird cell/row shifting happened in the Post IV communication tab at like 3am, might need to revert backsee above
53
will you put abrazo and health quest as options in the ROL
Done < no its not <<they are at the bottom of the list< thanks!
54
The ROL tab still doesn’t seem to be working? People are commenting that they have filled out the form but it is still not populating?fixed and working, please note that there are two pages on the form, so you have to click next, fill out whatever fields you want, then click submit. There has been on response recorded and it is on the spreadsheet.
55
Post-IV Communication tab is garbage compared to last year. Can we just create one that lists programs similar to last year.sure
56
Can we unlock edit for IV offers again? Wanted to update there instead of main chat when i got off waitlist/new interv offers
the boxes under the yellow header are open for edits
Link to 2017-2018 spreadsheet:
2017-2018
57
Can we create a benefits tab for all the programs? Moonlighting, salary, conferences, paid international electives, food, parking, paid vs deducted insurance?Great idea, I’ll start working on it
Link to 2018-2019 spreadsheet:
2018-2019
58
Can the width of the columns in the X vs T tab be widened? Specifically for the feedback #4, #5, #6 etc. They are very short so they become very difficult to read as they take up lots of linesdone
59
Can we formalize the post IV communication like the 2018/2019 sheet? Also, promote it if programs reached out to applicants already?Done
60
61
Can we add a column to the far left in the chat to indicate the date a comment was left (saw this when an FM friend of mine was going through their google doc) Seems to help keep organized how old certain comments are and allows us to refer back to them by date if we are waiting on repliesDone
62
Could we make a tab for programs that are continuing to interview into January?
Looks like someone took care of this
63
is it time to open up the ROL tab??Hey OP, could we lock the ROL tab and have ppl submit thru google form so it can't be altered. thx!TY! you're the bestit's open :)
64
Can we fix the post-IV tab/restore it to what it was before? some columns were deleted and things shifted up. Some are trying to fix manually but not sure if everything is still aligneddone
65
Can we get a key for the interview offers tab? I may just be dumb but I don’t understand it/ it’s been dead since October I don't know what you mean by key? Feel free to email me to discuss it more, there have been new interview invites posted since october
66
can someone put BIDMC on the Praise+NAME&SHAME tab?
done
67
Is it possible to put up a list of mental health resources and/or reddit places that have mental health resources? Seems to be an uptick in people "joking" about SI/depression on this spreadsheet and if they're serious they should have a place to goyes, would you be willing to e-mail me a list and I can post that to the main page
68
Can we fix how the text keeps clipping the bottom of the cell on the chat? Seems like a default almost
I try and fix this on a daily basis, but since the chat is open to edits anyone can mess with it unfortunately
69
More X vs Y rows pleasedone
70
Add a column in IV dropped for date the candidate dropped and when the interview was for? Kind of confusing right now as people are listing either the date they dropped it or the interview date as the sameDone
71
Can the rejections, dropped, and waitlist pages be changed back to chronological?! its in alphabetical order but It's most useful to know when rejections happen in real-time.Done
72
On IV offers tab can the colum with the programs name be frozen - hard to scroll horizontally and see which program I’m looking at Done
73
Can’t add rows in the X vs Y spreadsheet
Added more
74
The Metro Health University of Michigan link is the one that is for Metro Health in Cleveland. Here's the right link: https://metrohealth.net/wp-content/uploads/2018/09/Emergency-Medicine-Residency-Program-Online-Updated.pdfFixed, thank you!
75
Any way you can make the chart a little more tight on “IV offers page” that is at the bottom? Seeing the graph as a whole is difficult because the columns are so wide
76
"Dropped" tab deleted again. Please restore!
Restored
77
What happened to the IV swap tab??Restored
78
The "interviews dropped" tab has been deleted :'(Restored
79
Can we make the interview invite tab editable again?
It is, just not the boxes towards the left
80
First column for comments in X vs Y (after OP comment) was deleted somehow. Restore possible?
i can't restore this without reverting back to two days ago which deletes chat and interview invites since then; actually hang on i may have a fix. FIXED
81
Either blind, or can't find link to IV impression form. Would like both fixed if possible
sorry not sure how it disappeared- should be fixed now!
82
In IV Offers is there any reason to keep the unified releases split from the rest of the dates? Just makes it harder to read at this point.For future classes to reference
83
University of Central Florida (Orlando) is 15-17 shifts. Please updateDone
84
ty for restoring the chat!np :)
85
looks like someone went through and deleted a lot off of IV offers tab
I don't see any major variations in the total numbers over the past few days, have also been locking cells to protect from this but can only do so much, I wish people would stop doing that
86
Can you widen the cells in IV impresions page (specifically the pros and cons), thanks!Done
87
I mis-entered my SVI score. I forget the exact number but it was DEFINITELY higher than 13, lol. Could someone delete it so my app info is marginally less of the train wreck that it is? Thanks. -AspiringERMDyes i'll delete it, if you want it updated fell free to email me at the address listed
88
Can we add a tab for interviews dropped?
DoneThank you <3 NP
89
At the risk of negative comments, can we please add Summa in Akron?
90
Can we add Nazareth Hospital Program in Philadelphia?
Have an interview here so interested in experiences!
Added! < thank you!!
91
Why is the hotels page view only tried to make yale have discount but it wouldn’t let meSorry about that, it's open now<<TY!
92
Can someone make a Google Form for the "#II you have" sheet? Not sure why this sheet even exists though since "Applicant Information" has the identical information already...The forms take a while to make so I didn't want to recreate one for an area where we already have that info (minus unified day specifics)
93
can we add a tab for which schools are waitlisting people? so that we know if there's a waitlist we're not even on yet ;) <<+1Done
94
Hey admin :) thanks for doing this. For the "IV Offers" tab, could there be a column specifically for Unified Release date? Thank you!No prob! Done.
95
Can you add Swedish Covenant Hospital - Illinois?2ndedAdded!
96
on the applicant info tab, for # of interviews, would it be possible to add column that says which programs those interviews are at? << EMRAT provides this functionalityI'll look into it but honestly not sure how to write the coding for this, as an alternative, you can use ctrl/command F on the IV offers page to search the applicant's name
Did you list managing "EM Applicant Spreadsheet" on ERAS?
It seems like a ton of work
lol! been asked this a few times, no, just a labor of love/personal interest
97
Couch surfing page?Added a discussion page
You've been doing an amazing job and we appreciate you!! -W
wow thank you!
98
Interview date swap page? Is this even possible? Or does waitlist preclude us doing thisAdded a discussion page
99
On IV offers page there are 2 university of Michigan’s... rows 88 and 111fixed, Thanks!
100
^^same with U Chicago, Einstein/Montefiore, Hofstra (listed as Zucker SOM and Hofstra Northwell)Fixed, see Zucker SOM question in row 54