ABCDEFGHIJ
1
2022 - 2023 Emergency Medicine Applicant SpreadsheetWant to get involved with what will become THE comprehensive anki-based resource for EM? Join the EMpower discord and help us out! We are looking for anyone wanting to help - including moderating, contributing to the deck, or building/supporting the community!
https://discord.gg/WYbWm8k2xV
2
3
4
5
6
09/15/2023: The spreadsheet for the 2023 - 2024 application cycle can be found here: 2023-2024 EM Match Spreadsheet

03/19/2023 @ 1900 EST: Spreadsheet reverted to the morning of 03/17/23 (due to griefing that made it impossible to load the sheet)
- Spreadsheet editing turned off
- If you want to update any rows or add what # you matched at on your ROL, email a mod or leave a comment on the sheet

Congratulations to all our fellow future EM physicians who matched!
7
8
Welcome! This is a central location for current EM residency applicants to find and share information about the current cycle. Remember that all information is self-reported and user-sourced; all users should take all information as opinion and with a grain of salt. All applicants are asked and encouraged to participate regardless of stats.
9
10
11
12
Moderator: Elle (discord)
Admin: /u/Vanc_Zos | emspreadsheet2023@gmail.com
13
14
PLEASE CLOSE THE SHEET WHEN NOT IN USE! New users cannot access when too many people have the sheet open.RULES: Don't be a dick. Moderators will remove inflammatory or abusive content and revoke access to those who post them. Disparaging comments and vandalism of any kind is not tolerated.
15
16
17
DON'T BE A JERK; DON'T EDIT OTHERS' COMMENTS
18
~ -952 Days until Match Day ~
19
If you want to protect your data/comments so they don't get changed:
Enter your data → Right click on cell (or row) → Hover "view more cell actions" →
Click "Protect Range" → Click "Set Permissions" →
Underneath "Restrict who can edit this range," click the dropdown and select "Only you..." → Click "Done"
Please join the discord at https://discord.gg/AfahejM5xP
If you haven't used Discord in the past, it's a great way to chat and it was very helpful during last year's application cycle. We are re-using last year's server so you will connect with last years applicants (current PGY1s) and even some EM faculty!
20
21
22
23
Getting Started:
24
1. Enter your applicant stats (pick a pseudonym or reddit username)
25
* Your pseudonym will be used to anonymously identify and pull data for your ROL
26
2. Contribute information about programs / IVs:
27
Pros/ConsProgram DetailsPost-InterviewPost-RotationArchive/Past Sheets:
28
3. Make and compare your rank order lists (ROL)2017-20182021-2022
29
CHAT and [try to] destress!2018-2019
30
Navigation2019-20202023-2024
31
ChatApplicant DataRank Order ListX vs. Y2020-2021
32
Pros/ConsProgram DetailsPost-IV Impressions/Comms.Post-Rotato ImpressionsPopularity Chart
33
Shame/FamePre-IV Virtual House ListMissed Connections <3Drinking Game
34
IV Format + OffersIV Wave WatcherIV Tough QuestionsIV Swap
35
Dropped IVsRejections/WLResident Q&ACombo Program Mastersheet
36
SignalsGraphs10 IV & Under ClubAbbreviation Cheat Sheet
37
SUGGESTIONS FOR SPREADSHEET IMPROVEMENTModerator Bar
38
DateSuggestionCommentsStatusMod Notes
39
9/6/2022Sheet createdPrelim version done 9/7
40
9/8/2022Sheet releasedPublic as of 09/08/2022
41
9/8/2022Add NYU Long Island to school listAdded 09/08/2022
42
9/8/2022Keep an eye out for UTMB Galveston to be added to ERASWill be watching here: https://services.aamc.org/eras/erasstats/par/display.cfm?NAV_ROW=PAR&SPEC_CD=110UTMB was approvedWaiting for program to be added to ERAS as of 9/9/2Current number of programs included in the spreadsheet: 277
43
9/9/2022Added a column in Program Details for Program LengthAdded 9/9/22May want to add validation data "3 years" & "4 years"/ done -VZ
44
9/12/2022Add "Misc" column to Program details for possible step score cut offs, programs requiring 3 LORs etc... Added to end of program details 9/13/22 -VZ
45
9/15/2022Added Geisinger Health System Wilkes-Barre siteAdded Resident Q&A
46
9/16/2022Consider reversing the time-order of the chat (newer chats at the top) +1Will work on it 9/16
update: no really elegant way to do it without making the chat experience more cumbersome as a whole, just going to leave as is 9/17
im open to doing it manually...looking at prior years, that may have been what they did 9/18 -VZ		We could reverse the order & just leave 10-15 empty lines at the top? Mods can add new lines as needed -EK
47
9/16/2022Can we make it so the Pre-IV Virtual House page gets organized by date/time, so we can have a running chronologic list of what virtual events every program is doing?Will add 9/16
update: added separate submission page + highlighting to show if date is past, today, or future 9/17 -VZ
48
9/18/2022Version history shows that the spreadhseet owner deleted all the chat this morning?See line 36 on this page - the time order of the chat was reversed so that new comments are at the top, blank lines have been inserted to allow new comments. You just need to scroll down a few lines. -EKAdded a note at the top so people don't make false accusations get confused :) -VZ. > got it, thx!
49
9/19/22VZ, the formula in Applicant Data Z5 (% Yield) needs to be applied to the rest of the column (can't access because other have protected their whole row - you should be able to though) -EKDone, also protected that column to preserve formula 9/19 -VZ
50
9/19/2022Add mean/average row to applicant data sheet (for scores, # programs applied) ?Added most common value for scores - because they are ranges, it would be a hassle to get an actual average unless anyone has a formula handy. Working on getting averages for the numerical values, but I would think medians a more helpful average than mean? -EK

update - median is hard, leaving it at average unless someone wants to propose a formula		Added 9/20 most common value for scores and averages for pubs, work experiences, volunteer experiences, programs applied, interviews, rejections, and ranked -EKwill take a look over the weekend - VZ
10/2 added averages

51
9/21/2022A new tab where we can tally number of signals to programs (Anesthesia spreadsheet has this to track popularity of signals to programs)https://docs.google.com/spreadsheets/d/1c8sR-RdVIsjBMjvn0vKhmdeujqi1lBTANCURbnhYdF8/edit?pli=1#gid=1252308983<<< this would be nice to knowAdded Signals 9/23Done -EK
52
9/29/2022"No new interviews today" on wave watcher scrip isn't workingAdded a few other metrics in K1 & K2 but can't get that one -EKI'lllook into this afternoon -VI think I got it, feel free to double check me -EKLooks good, very clever fix -VThx
53
9/29/2022Will work on adding an option for "signaled" under "other info" for interview invites - EKDone -EK
54
9/29/2022Revising cell O8, someone put 11/30 for presumably the date of their interview and not the date of the offer -EK
55
10/4/2022Can we add a tab for 10 & Under IV Club like last year?Def doable but I'm thinking we should wait until after the unified release date to prevent premature panikWill add after 10/19

10/25: Added
56
10/5/2022may need more than 20 columns in interview offers as some are already filling up (one is at 17)True facts -EK
Added 10 more columns, will add more when necessary but feel free to point it out if I don't notice (damn Hopkins, lol)		NTS: Should probably add up to 35-40 spots (McGaw, Hopkins)

Added up to 50 10/19
57
10/17/2022abbreviation cheat sheet -- some do not know terms like OOSsuggestions on other terms?IS, IV, II, Sub-I, eSLOE, oSLOE, SLOE, URM, ROL, LOI, COL, PGY, SOAP, PD, APD, ROL, IMG, USIMG, OP10/25: Will work on this when I have availability, I'll go ahead and make a sheet without protections after all of the other tabs if anyone wants to get started. -EKDone
58
10/18/2022Post IV review page is noting all program locations incorrectlyagain, ugh. will work on it. -- that should do it
59
10/19/2022I think the rejection/waitlist page cell formula is incorrect because when I chose my pseudonym it spit out someone else's statsI am baffled...Vanc, any thoughts? Exhibit a - D72 on Rejections/Waitlist is returning the correct value in E72, but I97 is not returning the correct value in J97. Should be returning the values from row 144 in Applicant Data, but is instead returning the values from row 106. -EKLooking now -VZ
2218 Have the fix, just trying to figure out the best way to apply it to the entire spreadsheet
60
10/19/2022Tried to fix above problem with a named function...but that bricked the sheet so I reverted it. Will look into a better way to do thisThink I have a fix with regex -VZ10/20 2330 EST Did some regex magic, lookup formula should be fixed across all sheets. lmk if its not -VZLooks great!
61
10/31/2022can we widen some of the columns on some of the tabs so when people write a lot that row doesn't take up so much verticle space? it makes it difficult to read/scroll and keep up when there are lots of rows and lots of text, especially on a small screen. some people are making their text smaller to compensate (or merging cells like above) but it's still hard to read sometimes. examples on the ROL and name/shame/fame tabs but it's an issue on multiple tabs. Updated what I could 10/31- EK

TY!! You have truly been awesomeVZ, you may need to do the rest due to protections. Also, someone has protected pros/cons for SUNY Upstate Medical University Program if you can remove that.Removed protections on the pros/cons sheet (since it's supposed to be a collaborative sheet) and widened those columns somewhat. lmk if there's anything else i need to fix 10/31 -VZ
62
10/31/2022What do people think about adding "Trauma split" and/or "Airways" in the program details tab? would be great to get this written down for all programs how/when trauma is split with surgery and how airways are handled. Reposting in the chat and if it gets traction I'll add the columnsDone 11/5 -EK
63
11/1/2022Need more rows on "Dropped IVs"VZ, may need you to fix this. Should just be able to delete the "whole sheet except" protection on Dropped IVs. It says I should be able to edit, but of course glitches out every time I try. -EKI saw this at one point and realized we would need to change it...then I forgot to actually change it. I'll fix it tonight
Should be fixed now 11/1 -VZ
64
11/1/2022Widened some columns on the "Program Details" sheet. Also made the "date last updated" column autoupdate (with a clever solution I found online) -VZ
65
11/2/2022Noticed a DO friendly section under the program details tab. Is it possible to add a similar section about IMG friendliness?Can doDone 11/5 -EK
66
11/10/2022is there anywhere for second look info, who's doing them, etc? Added a column under IV format to include information about second looks.
67
11/15/2022Still can't add more rows on "Dropped IVs"This has been fixed as far as I can tell?
68
11/20/2022I think it would be helpful to have a page or column somewhere to add programs EM program ran website rather than the hospital site. For example, limaemergency.com is for st ritas in ohio but i had no clue until googling myself since my interview is pending. Added
69
1/6/2023Spreadsheet restored to 01/05/2023 after griefing. Existing data protected to prevent repeat griefing. Message a mod for permission to edit old data.
70
1/10/2023Ranks and popularity tab for anonymous rank list reportings? Ty:) Can you detail what you're looking for? You can enter your rank list without including a pseudonym.Last years speadsheet had all of the programs and people could put where they're ranking programs and it would give stats in terms of how many times ranked #1-3 or 5+ etc.
71
2/6/2023Suggestion for next year: Maybe fix "conferences" to split between conferences (ACEP, ACOEP) and didactics?
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100