| A | B | C | D | E | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024 General Surgery Residency Application Spreadsheet | |||||||||
2 | ROL Submit Countdown | DONE | Match Week Countdown | DONE | Match Day Countdown | DONE | ||||
3 | RULES | Useful Links | Prior Year Spreadsheets | |||||||
4 | 1. Don't edit other people's cells. | 2024 Discord | 2022-2023 Sheet | |||||||
5 | 2. Be honest: don't add info that is untrue. If you troll, your comments will be deleted :) | 2024 ERAS Residency Timeline | 2021-2022 Sheet | |||||||
6 | 3. Be kind: this is a stressful process for everyone – let's make it through together! | 2024 NRMP Match Calendar | 2020-2021 Sheet | |||||||
7 | 4. Don't change the order of the sheets for the love of god. Let's keep the clutter to a minimum. | ReviewMyResidency | 2019-2020 Sheet | |||||||
8 | 5. Please don't randomly delete the instructions/headers for sheets. | 2018-2019 Sheet | ||||||||
9 | 6. Don't add or delete any sheets. | |||||||||
10 | ||||||||||
11 | MOD ANNOUNCEMENTS [04/08/2024] | |||||||||
12 | - SHEET WILL BE LOCKED ON 4/10/24 | |||||||||
13 | ||||||||||
14 | ||||||||||
15 | Suggestion/Question | Mod Response | ||||||||
16 | Sorting applicant info has messed up protected ranges (e.g. if row 111 was originally protected by creator but then mod(?) sorts by step 2 and row 111 is now row 99, row 111 is still the protected row) I can probably cook up an apps script that handles this issue in like 1 day, I'm just a medspouse so I have the time lol | That would be much appreciated. - mod < I sent you an email | ||||||||
17 | Malignant page? | done | ||||||||
18 | Can we add a home student/away rotation impressions tab and start collecting? +2 | done | ||||||||
19 | Can we add a "Warning - program change" tab for programs that historically have a "good" reputation but have significantly changed in the past 2-3 years/will have significant changes coming? +1 | done | ||||||||
20 | prelim page? | done | ||||||||
21 | personalized PS page please? | done | ||||||||
22 | 3 vs 4 LoR info at a glance? | Whoops may be a little late for this | ||||||||
23 | interview invite tab? | done | ||||||||
24 | prelim page? | done | ||||||||
25 | program communication page? | done | ||||||||
26 | am I anonymous? | yes you are | ||||||||
27 | trying to edit my applicant info row to reflect interview invites but it's saying that I don't have permission... help | you probably protected the cells and are now accessing the sheet on a different google account | ||||||||
28 | Can we have a supplemental page? | that's what the 2/pre-interview communication page is | ||||||||
29 | Discord invite is invalid? | |||||||||
30 | On the Applicant Info tab, does publications just mean published papers/abstracts or do they include everything like presentations? | just published papers | ||||||||
31 | calander with programs interview dates | added | ||||||||
32 | I had locked a row but now after its been re-sorted the new row is locked and I cant change it. I'm using the same google account. +2 same happened with me | |||||||||
33 | @mod will you please unlock scalpelgirlie so i can edit my applicant info? I'm only using one Google account and the row is now locked after beign resorted | DONE! - @surgmod < I still can't edit my row :/ Can you try again pls? << sorry about that, try it again it should work now | ||||||||
34 | @mod will you please unlock bluefield so i can edit my applicant info? my row is locked after being resorted | Try it now, it should work as long as no one else resorts the page | ||||||||
35 | shouldnt tracking the be on the II by date page rather than the II dropped | done | ||||||||
36 | mod i love u <3 | ♥️ | ||||||||
37 | what happened to former spread sheets | Trolls be trollin'. Will fix it this weekend when I have a bit more time | ||||||||
38 | any chance we can make the average step 2 score lower, just to relieve my anxiety? <<< what was it? | Yeah it's kind of dumb. The true average will be published next year anyways. Removed. | ||||||||
39 | What happened to the 2º/Communications page?? | I'm not mod but I tried to restore it the best way I can < thank u king +1 | ||||||||
40 | Can the secondary/pre-interview page be restored to old format please | |||||||||
41 | Would it be possible to add the geographic signal regions to the programs? | Can you elaborate? | ||||||||
42 | whered the discord link go? | https://discord.gg/fz2KtQwK7j | ||||||||
43 | can we create an interview questions tab like in last year's spreadsheet please? | |||||||||
44 | I have no idea why this keeps happening... someone locked my applicant info row again. @mod can you unlock again pretty please? >> lol yeah someone must have locked mine too because I have tried every email I own and none of them can edit my cells | Unlocked applicant info page completely. May need to go back and refill everything else if troll come through. Mod... Thank you! That is easier to do at least... can you make a copy of the sheet and lock the copy as back up in case that happens? That way we can restore it to at least where it is now | ||||||||
45 | ^^ can we just not lock this page at all because every time someone sorts, it gets wonky +1 | ^^ | ||||||||
46 | ^^ agreed!!!! | ^^ | ||||||||
47 | Mod can we stop the person spamming the pages with the reviewmyresidency website? It's getting annoying and showing up on multiple sheets. | |||||||||
48 | Thank you mod for all the work you do! :) | |||||||||
49 | what happened to the interview dates tab? | Nothing, still there << im talking about the calander sorry shouldve clarified << removed because redundant, see II by Program tab for IV date info << could we add it back? It was much easier for me to see the dates on an actual calendar rather than searching for specific dates when I was trying to schedule an interview without any conflicting times +1 << sorry about that, just restored the most recent version - mod << Thank you so much!! | ||||||||
50 | Discord invite is invalid? +2 | |||||||||
51 | some way to make room to talk about which programs have interview spots still open? +4 | done <- might be better to change the format of the page so that all the programs are listed & people can just fill in whether or not there are empty spots (instead os request based)< the number of spots available will change every day, so better to answer on request | ||||||||
52 | In West Virginia , Marshall has 2 gen surg residency programs. The General Surgery residency (4 categorical) and the Consortium Rural General Surgery (3 categorical)- | done | ||||||||
53 | Can we create a tab for post-II communications bc we're getting into interview season now? pls and thank you! :) | done | ||||||||
54 | can we have an interview questions page? thx mod I hope your socks always slide on just right! | done | ||||||||
55 | Franciscan IL not on II by program list? | done | ||||||||
56 | Can we think about doing an A vs B page soon? I know right now people are still getting invites, but at some point later on there might be some that conflict and peopel can utilize that. Also for when we get closer to rank list! | done | ||||||||
57 | Is it possible to have a Chat[DO] tab? | I believe there is one on the discord channel, thank you! << my bad, looks like there wasn't one before but should be there now | ||||||||
58 | Somebody trashed the II by date tab. A lot of entries have been deleted and they added shit stats like MD 214. This why we cant have nice things. @mod, can you revert it to the previous version? | I did not see many changes comparing it to the previous versions other than 1-2 deleted programs that have been added back up. I'll keep an eye on it though << the programs in column F have been deleted<< missing info should be back now << LOL just copy pasted from the next column. << I'm an idiot haha let me try that again...so it looks like there was no deleted data, just someone added a column | ||||||||
59 | Mod ur the MVP. I hope you have all the interview invites. +2 | |||||||||
60 | On IV impressions, under Connecticut I think Griffin is outdated--can it be updated to include Danbury instead? | done | ||||||||
61 | Hi mod, would it be possible to make a new tab for people to post for next year's applicants whether they got an II at their away program(s)?<OP responding to mod, that makes total sense. Happy to spearhead the effort down the line if you want my help | Can make one after the match since that'll be around VSLO opening time - mod | ||||||||
62 | What happened to the applicant info tab? The page is all messed up | Thanks for the heads up, fixed | ||||||||
63 | ^^ maybe we can include more info too like "did you get an interview?" "did you signal them?" "did they tell you to signal them?" etc.. idk. < I think that's likely up to the applicant to ask during their away, plus the last thing we need is for people to promote misinformation by lying on here tbh (ie, saying the PD said not to signal even though they did and screwing people over idk maybe I'm just a cynic haha)>> fair point. | |||||||||
64 | Wheres the invite by date tab go? | its still there | ||||||||
65 | Can we move the IMG chat to be with General and DO? | |||||||||
66 | Keep messing with the votes in A vs B tab and I'll keep deleting all the numbers. > wtf | |||||||||
67 | New to this spreadsheet, does "II" stand for secondary applications or interview invitations? thanks! | Interview invites | ||||||||
68 | could we fix the rows on the general chat that are frozen when you scroll? | done | ||||||||
69 | On IV impressions, can we differentiate between NYU Manhattan and NYU Brooklyn please? Thanks | done | ||||||||
70 | Thank you for all that you do. On IV impressions, Massachusetts-Maryland-Maine are probably not in alphabetical order - sorry, I have little else to do in my life but look at these sheets! | |||||||||
71 | Can we make a tab for recruitment packages/SWAG, we have a lot of serious tabs... it would be nice to have a fun one < this exists under the post-II communication tab! | |||||||||
72 | People are going through and deleting other's responses. Is there a way we can moderate this? | |||||||||
73 | Can we get the military hospitals on this chart? | If someone can provide me a list of those I can put em on < the military match happened today so there's probably no point adding them now imo < would be good to put them on now in case the folks next year want to use a copy of this spreadsheet for the 2025 match | ||||||||
74 | Can we add the program awards and name and shame tabs? | Coming soon - mod | ||||||||
75 | Can we add a program HQ tab? and people fill in information they got from programs. Like food situation, call schedule etc. OBGYN spreadsheet has something like this and I think it would be useful. +1 < check out the IV impressions tab, there are columns to add that info | |||||||||
76 | Can you guys add Good Samaritan University hospital to all the pages please? Brand new program in NY | done < ty! | ||||||||
77 | Can we have the II by programs section back please? | done, someone's going around hiding some of the sheets < Thank you! | ||||||||
78 | Can we make a tab for general responses we've received from PDs after sending thank you notes? It would be helpful to know if a response saying they want me in their program actually means anything, or if it's a standardized thing they send to everybody. | |||||||||
79 | Thank you, Mod for fixing the spreadsheet! | |||||||||
80 | Could you please fix rejection tab? | What's wrong with it<<<Someone sorted it alphabetically. < fixed<thank you | ||||||||
81 | Could you please fix rejection tab? | |||||||||
82 | hey mod, instructions on the "rank spots" tab are scattered within the list of programs | Thanks! fixed - mod | ||||||||
83 | For Mod: For the Applicant info tab, someone replace the region of 20 applicants with a Nazi troll. I deleted but hoping you could restore the original info | Thanks for letting me know! Fixed - mod | ||||||||
84 | Just as a heads up for any applicants applying to UNC, WakeMed recently posted a listing for an APP Fellowship, paying $79,126.80 for 40 hours a week. https://www.intelycare.com/jobs/45510514-physician-assistant-or-nurse-practitioner-fellow-general-surgery | |||||||||
85 | Can the chat be restored to before the inappropriate comments were made? I deleted the rows to get rid of the comment | Fixed - mod | ||||||||
86 | locking some cells because people delete comments they don't like | See above | ||||||||
87 | somebody is harrassing people in here. look at 1/24 quesiton about Miami jackson, not even related to OP question, please clear out the row | See above | ||||||||
88 | Users locking cells in active use (UCI applicant/resident conversation) to stifle responses from those using it | See above | ||||||||
89 | Can we get a missed connections page? +2 << I'm sure ppl are looking for me < i am << its a week from valentines day do you guys just want me to not have love in my life | DONE - mod | ||||||||
90 | I've gotten a few RTM/Post-II comms, but they were all in response to TY emails or f/u questions I had about the programs. Could we get a designated spot for this or ammend the Post-II Comms sheet to include this stuff? | Just add that next to it | ||||||||
91 | Done - mod | |||||||||
92 | ||||||||||
93 | ||||||||||
94 | ||||||||||
95 | ||||||||||
96 | ||||||||||
97 | ||||||||||
98 | ||||||||||
99 | ||||||||||
100 | ||||||||||