A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
1 | 2023 - 2024 Emergency Medicine Applicant Spreadsheet | |||||||||
2 | ||||||||||
3 | ||||||||||
4 | ||||||||||
5 | ||||||||||
6 | 09/02/2024: The spreadsheet for the 2024 - 2025 application cycle can be found here: 2024-2025 EM Match Spreadsheet This spreadsheet will be locked for future editing. If you want to edit any information or add what # you matched at on your ROL, leave a comment or email a moderator. 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: Ellen (ellen.c.knox@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 | ~ -561 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/vSkKDyRn If you haven't used Discord in the past, it's a great way to chat and it was very helpful to many during last year's application cycle. This server has been in use for at least two application cycles, so you will connect with last years applicants (current PGY-1s and -2s) 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/Cons | Program Details | Virtual Open Houses | Post-Rotation | Archive/Past Sheets: | |||||
28 | 3. Make and compare your rank order lists (ROL) | 2017-2018 | 2021-2022 | |||||||
29 | CHAT and [try to] destress! | 2018-2019 | 2022-2023 | |||||||
30 | Navigation | 2019-2020 | ||||||||
31 | Chat | Applicant Data | Rank Order List | X vs. Y | 2020-2021 | |||||
32 | Pros/Cons | Program Details | Post-Interview Communications | Post-Rotato Impressions | Popularity Chart | |||||
33 | Shame/Fame | 10 IV & Under Club | Open House/Events List | Abbreviation Cheat Sheet | Frequency Charts | |||||
34 | IV Format + Offers | IV Wave Watcher | IV Tough Questions | Signals | ||||||
35 | Dropped IVs | Rejections/WL | Resident Q&A | Combo Program Mastersheet | ||||||
36 | SUGGESTIONS FOR SPREADSHEET IMPROVEMENT | Moderator Bar | ||||||||
37 | Date | Suggestion | Comments | Status | Mod Notes | |||||
38 | 9/15/2023 | Sheet created | 11 27 0127 | |||||||
39 | 2/6/2023 | Suggestion for next year: Maybe fix "conferences" to split between conferences (ACEP, ACOEP) and didactics? | done 9/15 -EK | created a second column, renamed, and split information that was there | ||||||
40 | 7/16/2023 | Can we add a "Pass" option for Step 1 on the data? | < this, add in a Fail->Pass also | Plz do the same for COMLEX Level 1 *** | done 9/15 w/remake -EK | Added Fail, Pass, and Fail -> Pass as options in data validation. Updated range for data validation opens on Applicant Data. | ||||
41 | 8/15/2023 | Can we add a tab for preinterview/application events? | Can we add a tab for events that can be updated/editable as they pop up? | done 9/15 -EK | Added Pre-IV Virtual House List sheets | |||||
42 | 9/19/2023 | cleaned up formulas for IV tracker, rejections/waitlist, combo programs, & ROL, added signal tracker | ||||||||
43 | 9/19/2023 | To do: fix data tables & frequency charts, check for new programs | done 10/9 -EK | |||||||
44 | 9/27/2023 | Can we create a spreadsheet with the interview dates available at each program? | Does "Days Offered Interviews MTuWThF" on the IV Format + Offers sheet not work for this? | |||||||
45 | 10/4/2023 | Did not add: Pennsylvania Pottstown Tower Health Program 1104100001 Not Participating | Added: Texas Galveston University of Texas Medical Branch Hospitals Program 1104800003 Participating Texas Edinburg Doctors Hospital at Renaissance, Ltd. Program 1104800002 Participating New York Bethpage Good Samaritan University Hospital Program New Program! 1103500005 Participating Iowa Des Moines Central Iowa Health System (Iowa Methodist/Iowa Lutheran) Program 1101800001 Participating California Thousand Oaks HCA Healthcare/Los Robles Regional Medical Center Program New Program! 1100500002 Participating Arizona Chandler Dignity Health East Valley Program 1100300002 Participating" | |||||||
46 | 10/4/2023 | Removed: ProMedica Monroe | ||||||||
47 | Can we add some kind of analysis of 3 vs 4 year programs? Like maybe signal distribution broken down by 3 vs 4? Just curious! | I checked this out and the results weren't very exciting - signals between 3- and 4-year programs were split almost exactly according to their proportions. https://docs.google.com/spreadsheets/d/1VRhEjyNQcspLlmTuRKTdHgT7r_0uaUf9-gC8hl0s6Ww/edit#gid=1244197766&range=A327 | ||||||||
48 | 10/16/2023 | can Sigma Xi be added to "honors societies" under "applicant data"? | it looks like a small org, only a few chapters in the US. Am I wrong? | |||||||
49 | 10/18/2023 | Can you add jefferson health new jersey to program details tab | New Jersey RowanSOM/Jefferson Health/Virtua Our Lady of Lourdes Hospital Program is already on there | |||||||
50 | 11/9/2023 | Can you add a "family friendly" column? | What information are you looking for specifically? Whether current residents have kids, parental leave practices, anything else? | Yes, thank you! | Added 11/20 | |||||
51 | 11/9/2023 | Where did the "post-interview impressions" page go? | Post-IV Impressions Column | I think this should be made seperately from communications | ^x2 | |||||
52 | 11/26/2023 | the discord link does not work :( | ||||||||
53 | 12/5/2023 | I think the post-interview impressions should be its own page and should be separate from post-interview communications. | ||||||||
54 | 1/2/2024 | Can we get row 5 (state, program, etc.) in Program Details locked at the top so it can be seen when scrolling down to look at programs? | Otherwise you have to keep scrolling up and down to remember what each column is titled | |||||||
55 | Spectrum Health/Michigan State University Program changed to Corewell Health – Grand Rapids/Michigan State University Program | Beaumont Health (Farmington Hills) Program changed to Corewell Health East Beaumont (Farmington Hills) Program | Beaumont Health (Royal Oak) Program changed to Corewell Health East Beaumont (Royal Oak) Program | Spectrum Health Lakeland Program changed to Corewell Health Lakeland Program | Beaumont Health (Trenton and Dearborn) Program changed to Corewell Health East Beaumont (Trenton and Dearborn) Program | |||||
56 | ||||||||||
57 | ||||||||||
58 | ||||||||||
59 | ||||||||||
60 | ||||||||||
61 | ||||||||||
62 | ||||||||||
63 | ||||||||||
64 | ||||||||||
65 | ||||||||||
66 | ||||||||||
67 | ||||||||||
68 | ||||||||||
69 | ||||||||||
70 | ||||||||||
71 | ||||||||||
72 | ||||||||||
73 |