Home › Forums › General Forum › Creating a Dashboard

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • July 28, 2025 at 11:22 am #6736
    Honor Gifford
    Participant

    Hi everyone,

    I hope you are having a good summer.

    We want to track various items by creating a dashboard, including research projects, Step 3 scores, OITE scores, and more. I’m happy to create a spreadsheet but was wondering if anyone already had and would be willing to share what they have. Mostly to see what things we may not have thought about tracking that we should and isn’t tracked somewhere else.

    If you have such a spreadsheet, will you please post it here, or email it to me at honor@jhmi.edu?

    Thank you!

    Honor Gifford (new/old last name :))

    July 28, 2025 at 11:25 am #6737
    Chanelle Arsenault
    Participant

    If you could also send me a copy, that would be great!

    chanelle_arsenault@med.unc.edu

    Thank you,

    Chanelle

    July 28, 2025 at 1:30 pm #6740
    Mara Sweet
    Participant

    I combined a few of my trackers into this one excel. I usually have my OITE separate from ABOS (once they graduate, I move them from OITE to ABOS!). The resident personnel tabs I keep in an excel all their own and have it password protected since it has their SSN’s (I move all their personal info over to my alumni excel once they graduate, except for the SSN’s which I delete!). We’re trying to figure out a better way to track our research, right now I only track it if they get it accepted for podium/poster through my financial budget tracker.

    Attachments:
    You must be logged in to view attached files.
    July 29, 2025 at 7:25 am #6743
    Missy Durante
    Participant

    You have created some great spreadsheets.  Can you do an excel training session 🙂

    Do you happen to have one for tracking time off?  If so, would you be willing to share.

    Thank you!

    July 29, 2025 at 9:55 am #6744
    Honor Gifford
    Participant

    To the administrator from Vanderbilt,

    Thank you for sharing your template! I love it. I have a lot of things in that spreadsheet but spread out over numerous sheets.

     

    Missy,

    I love excel!! I’d be happy to give a training session.

    My chiefs manage vacations and created the spreadsheet I have attached to track vacations. I hope this helps.

     

    Honor

    Attachments:
    You must be logged in to view attached files.
    July 29, 2025 at 10:36 am #6746
    Mara Sweet
    Participant

    You’re welcome! I also have my trackers spread all over the place. I’ve considered putting them all in one folder, but I’m used to having them all over! I’ve also attached my absence tracker. We do absences via Qgenda now that we have it for our call schedule, so I use this less than I used to. I use my ABOS tracker a little more for the absence tracker part of things now, but sometimes it is good to see it all in one place!

    Attachments:
    You must be logged in to view attached files.
    July 29, 2025 at 11:13 am #6748
    Jennafer Hoyland
    Keymaster

    Not sure if this is what you are looking for but we use this for our semi-annual evaluations to track everything for the residents. We use it in smart sheets but I exported it to excel to share easier.

    Jennafer Hoyland

    Attachments:
    You must be logged in to view attached files.
    July 31, 2025 at 9:06 am #6754
    Missy Durante
    Participant

    Thank you!!!

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.