Excel Application/Interview Tracker

[ryanbldr]

First post!!!

BUT ...

I've had way too much free time on my hands waiting for secondaries to come out and I thought I would share this spreadsheet I compiled over the past week. Feel free to personalize anything on the spreadsheet, and goodluck to everyone with the application process!

---

Members don't see this ad.

 

[OREdwardsJR]

Nice, saved. Thanks.

 

[Praefectus]

This is a solid chart. You should post it on Google docs so that you can crowdsource it with other SDN applicants.

 

[ryanbldr]

This is a solid chart. You should post it on Google docs so that you can crowdsource it with other SDN applicants.

Crowdsourced Earliest Interview Notification:

https://docs.google.com/spreadsheet/ccc?key=0Aj19XIl2kCWcdGpBOWE1Nkk2aGdfc2ZsWE0xdnE4aWc

Good call man!

 

[MedPR]

Cool, thanks!

 

[grouchasaurous]

You are a god. this is amazing. updating with my own schools now.

First post!!!

BUT ...

I've had way too much free time on my hands waiting for secondaries to come out and I thought I would share this spreadsheet I compiled over the past week. Feel free to personalize anything on the spreadsheet, and goodluck to everyone with the application process!

 

[aspiringdoc09]

Awesome. Thanks a lot.

 

[Jaqen Hghar]

There are also a few variations of this spreadsheet in the linked thread below for anybody interested.

http://forums.studentdoctor.net/showthread.php?t=214713

 

[syoung]

Thanks! What's the earliest SDN interview notification for? Does it mean on which day on SDN that someone received an interview for that school? Do we mine the data on SDN and fill it in for 2012's cycle then?

 

[Tots]

There are also a few variations of this spreadsheet in the linked thread below for anybody interested.

http://forums.studentdoctor.net/showthread.php?t=214713

An updated version of mine is attached. It is a little different when compared to the OP's though, so to each their own. The way mine works is you input the date in the appropriate columns and then the "Results" column will automatically update. Example: When you put an interview date then it will say "Interview Pending" until after the date when it should change to "Interview Completed." You can see an example of all this in the example tab. I tried to make this basically MDapps in an excel form where you can input dates of every step. Also you can now add secondary fees at the end and it will only be added to the total once "Secondary Submitted" has a date inputted in case you want to keep track of fees you have not paid yet. Also you can use the interview tab to break down interview costs and assuming you put the right number in the box it should match up with the main tab and add to the total cost column. I still don't have sorting added because it is eh on the version of excel I am using and I don't like it.

 

[ryanbldr]

Thanks! What's the earliest SDN interview notification for? Does it mean on which day on SDN that someone received an interview for that school? Do we mine the data on SDN and fill it in for 2012's cycle then?

Exactly! I looked up that information so I could prioritize my secondary writing based on the speed schools review applications. I also wanted to have a general idea about when I should be expected an response so that I can be on top of reaching out to non-responsive schools (I've heard this happens ... 🙁). My hope is that people update the Google Doc with the information they find from last year's threads to make the process easier for everyone, and update this year's column as the process goes along.

However, people keep deleting information from the Google Doc so please compile list w/ schools quoting previous users

 

[DAPI]

An updated version of mine is attached. It is a little different when compared to the OP's though, so to each their own. The way mine works is you input the date in the appropriate columns and then the "Results" column will automatically update. Example: When you put an interview date then it will say "Interview Pending" until after the date when it should change to "Interview Completed." You can see an example of all this in the example tab. I tried to make this basically MDapps in an excel form where you can input dates of every step. Also you can now add secondary fees at the end and it will only be added to the total once "Secondary Submitted" has a date inputted in case you want to keep track of fees you have not paid yet. Also you can use the interview tab to break down interview costs and assuming you put the right number in the box it should match up with the main tab and add to the total cost column. I still don't have sorting added because it is eh on the version of excel I am using and I don't like it.

I really like this one, but 75 school spots?? I hope no one needs that many