Show us your application excel spreadsheet of doom

[centrigeugle]

I'm sure everybody has an excel spreadsheet with various infoz for their application process.

Knowing SDN, many of us probably waste a significant amount of time playing around with them for absolutely no reason. Me, I just sit and stare at it sometimes.

So anyways, SHOW US YOUR EXCEL SPREADSHEET! Be sure to edit out anything important! Here's mine, for funsies. Don't laugh because I'm an idiot/lazy about state abbreviations.

I showed you mine. So you show me yours!

---

Members don't see this ad.

 

[hiyaman]

Wow you are very organized, I just organized things in my gmail account with various folders.

 

[EBTrailRunner]

Great spreadsheet. Mine's identical except no column for LizzyM score or state and it's listed by completion date.

 

[blizzah]

I keep all the info I have in my mdapps, email or brain. Maybe I should have made a sexy excel

 

[DrMcHindi]

Very similar to mine except I created a scoring system using 5 parameters to rank the order in which I completed secondaries. Obnoxiously pre-med, I know.

 

[Slowpoke]

Here is half of mine! Not shown are school websites with passwords and school rejections (grayed out).

 

[intj]

My spreadsheat has the following columns:
1) Name of school
2) Date secondary received
3) Date secondary submitted
4) Date complete
5) Date interview invite
6) Date interview attended
7) Date of decision (green background box if acceptance, red box if rejection, yellow if waitlist)
8) Username and password for account


Boxes that are not applicable yet are left blank.

 

[CodeBlu]

Holy neuroticism...

I thought I was bad for having Gmail folders... wow.

 

[Slowpoke]

Holy neuroticism...

I thought I was bad for having Gmail folders... wow.

you jelly of ze pretty colors?

 

[autotroph]

My spreadsheat has the following columns:
1) Name of school
2) Date secondary received
3) Date secondary submitted
4) Date complete
5) Date interview invite
6) Date interview attended
7) Date of decision (green background box if acceptance, red box if rejection, yellow if waitlist)
8) Username and password for account


Boxes that are not applicable yet are left blank.

Exactly how mine is set up. I have a box at the top for "running odds" based on us news acceptance numbers. I use total applications until I get an invite and then it's updated to interview numbers. I take into account IS vs OOS. I also have a box for odds solely at the schools I have interviews at.

I also have columns for expenditures: secondary fee, travel, lodging, food and anything else that comes up like postage a couple times.

 

[intj]

I also have columns for expenditures: secondary fee, travel, lodging, food and anything else that comes up like postage a couple times.

Forgot to mention I also keep track of expenditures!
Keeping track of odds is a pretty good idea...

 

[kexy]

Hahaha I am glad I'm not alone.

Pink= top choice. Blue highlight=already interviewed there. When I get rejected somewhere, I just delete it from the list instead of writing rejected in the outcome column. And my super reach schools aren't on the list because looking at them and knowing I'm already silently rejected makes me sad. Hahah.

 

[Gnomes]

I have one too. It has a ranking algorithm based on the US News rank and scores in six other categories including aspects of the program and the location and environment of the school. It's ordered by the score of the school normalized against the top-ranked school. (So, before Stanford rejected me, the schools were ranked in centiStanfords, and now they're ranked in centiHarvards. Not that I expect(ed) to be accepted by either!) And yes, it has pretty colors based on the numbers.

 

[intj]

This post is the epitome of quintessential SDN neuroticism and obssession/compulsion 😀

 

[centrigeugle]

I have one too. It has a ranking algorithm based on the US News rank and scores in six other categories including aspects of the program and the location and environment of the school. It's ordered by the score of the school normalized against the top-ranked school. (So, before Stanford rejected me, the schools were ranked in centiStanfords, and now they're ranked in centiHarvards. Not that I expect(ed) to be accepted by either!) And yes, it has pretty colors based on the numbers.

pics or stfu

 

[NickNaylor]

You guys have way too much free time.

 

[intj]

I have one too. It has a ranking algorithm based on the US News rank and scores in six other categories including aspects of the program and the location and environment of the school. It's ordered by the score of the school normalized against the top-ranked school. (So, before Stanford rejected me, the schools were ranked in centiStanfords, and now they're ranked in centiHarvards. Not that I expect(ed) to be accepted by either!) And yes, it has pretty colors based on the numbers.

 

[mauberley]

You guys have way too much free time.

I made one for my app cycle that's not unlike the others that have been posted here. Given that a good amount of my job revolved around using spreadsheets to track project status, it was only natural.

Everyone else on this thread has no excuse. 😉

 

[karmayogi]

ha i love this. it almost made me feel like i should spruce up my color-less spreadsheet!

 

[centrigeugle]

Seems like everybody is applying to a LOT of schools this year.

Or maybe it's just that the people with awesome spreadsheets happen to apply broadly...

 

[CodeBlu]

you jelly of ze pretty colors?

Obvs

 

[OldMan707]

Wow!! I'm so impressed with you guys! I have a bunch of sticky notes haha, very low tech.

 

[liveoak]

nice spreadsheet, dork. 😀

 

[ilubse7en]

Wow!! I'm so impressed with you guys! I have a bunch of sticky notes haha, very low tech.

same here, bunch of sticky notes and gmail folders
its amazing how much time people put in

 

[intj]

same here, bunch of sticky notes and gmail folders
its amazing how much time people put in

Making a spreadsheet really doesn't take much time. It takes me a second to update it whenever I get something new, and helps with organization, especially when schools are on different schedules. As for the interview:admit ratio and application:interview ratio, that's something I'd probably look up anyway, spreadsheet or no spreadsheet, and once I save it in the spreadsheet, it won't get lost 😎

 

[member88]

I made a simple spreadsheet in june and update it periodically. Took me 10-15 minutes to make aesthetically pleasing, 15-20 seconds to update it each time. It works for me.

I don't feel this was a neurotic move, nor do I think I have way too much time on my hands.

 

[sector9]

I showed you mine. So you show me yours!

 

[Knocked Up]

I showed you mine. So you show me yours!

This sounds dirty. Sure you got the right forum?

 

[autotroph]

Making a spreadsheet really doesn't take much time. It takes me a second to update it whenever I get something new, and helps with organization, especially when schools are on different schedules. As for the interview:admit ratio and application:interview ratio, that's something I'd probably look up anyway, spreadsheet or no spreadsheet, and once I save it in the spreadsheet, it won't get lost 😎

I must add that I'm also INTJ 😛

Reorganized my list in chronological order of completion.

I also have another spreadsheet that I used to rank every school using us news research rankings, clinical rankings and student/resident ratings for both too. The next sheet was that ranking plugged into an algorithm with other variables based on my personal preferences. >_<

 

[ManBroDude]

I have a google docs spreadsheet, so I can stare at this spreadsheet anywhere. The top is my TOC, the below the red line is a sample tab from RVU with to-do lists, essay prompts, dates, and logins all organized into specific places. I have a tab for each school. Green = done, red = not done. LizzyM scores are way outdated for DO schools, so I didn't bother.

 

[mauberley]

same here, bunch of sticky notes and gmail folders
its amazing how much time people put in

People who think this takes any amount of time aren't skilled in Excel-fu. 😉

 

[ManBroDude]

People who think this takes any amount of time aren't skilled in Excel-fu. 😉

Statistics and Ecology changed me.

 

[wololololololo]

These spreadsheets are pretty crazy. I just bookmarked all of my status pages on Chrome...

 

[haloschief]

Here is mine. I have another word doc that goes with this that includes my questions to secondaries + my answers. I found this less time consuming than trying to organize with gmail labels/folders.