Efficient way to organize interview invites by date?

[studentdoc911]

I'm getting owned here organizing TY+Rads interviews in a nice neat format. I accidentally scheduled an interview today on a date that I had another interview, and had to call back and apologize.
Anyone have an suggestions/examples/pics on how to do it efficiently in excel/word/google docs?

---

Members don't see this ad.

 

[username456789]

Honestly I found that entering an interview date/location into my iphone's calendar worked just fine. Then whenever I got an email with an interview invitation, I would just quickly check my phone to see if I had an opening.

 

[TeaKae]

Laugh at me if you want, but I printed out blank calendars for my interview months, and write in all my interviews as they come, and color code them according to specialty (TY, IM, and PMR). Haven't double-booked by accident but I agree, trying to schedule all of this is tough...and that's without having booked many flights or hotels yet

 

[Carlin]

Honestly I found that entering an interview date/location into my iphone's calendar worked just fine. Then whenever I got an email with an interview invitation, I would just quickly check my phone to see if I had an opening.

This is exactly what I'm doing and it's working out just fine!

 

[DrBowtie]

Laugh at me if you want, but I printed out blank calendars for my interview months, and write in all my interviews as they come, and color code them according to specialty (TY, IM, and PMR). Haven't double-booked by accident but I agree, trying to schedule all of this is tough...and that's without having booked many flights or hotels yet

I used a combo of that and google calendar.

You need to make sure to block out appropriate travel time as well.

Safely navigated 30 total interviews without a travel blunder.

 

[gasblaster]

Laugh at me if you want, but I printed out blank calendars for my interview months, and write in all my interviews as they come, and color code them according to specialty (TY, IM, and PMR). Haven't double-booked by accident but I agree, trying to schedule all of this is tough...and that's without having booked many flights or hotels yet

It's especially easy to have something printed out vs on the phone because when you make those phone calls back to PC to schedule a date, you have your calender in front of you instead of trying to talk and look on the calender on your phone at the same time.

I would later then input it into whatever google, iphone, apple calendar you have after.

 

[deleted103644]

I'm getting owned here organizing TY+Rads interviews in a nice neat format. I accidentally scheduled an interview today on a date that I had another interview, and had to call back and apologize.
Anyone have an suggestions/examples/pics on how to do it efficiently in excel/word/google docs?

I used Google Spreadsheets and a few formulas.

Set up a grid of every program I applied to, category, interview status, and interview date (if offered).

I then had automatically generated lists of interviews by interview date, color coded by category (using conditional colors, FILTER, SORT functions).

Once I had all the programs added, wasn't hard to update the spreadsheet from my smartphone.

 

[QuacksterVu]

I used Google Spreadsheets and a few formulas.

Set up a grid of every program I applied to, category, interview status, and interview date (if offered).

I then had automatically generated lists of interviews by interview date, color coded by category (using conditional colors, FILTER, SORT functions).

Once I had all the programs added, wasn't hard to update the spreadsheet from my smartphone.

^This, although I didn't do the conditional colors and I just used Excel since I have my laptop everywhere with me.

 

[deleted103644]

^This, although I didn't do the conditional colors and I just used Excel since I have my laptop everywhere with me.

Google spreadsheets is actually better than Excel at this point unless you use Macros (even then really).

I scheduled a few in the middle of other interviews, so laptop could not be handy.