Simple Productivity/Interruption Tracker

Post your working scripts, libraries and tools
User avatar
AlleyArtwork
Posts: 30
Joined: 09 Jun 2015, 21:08

Simple Productivity/Interruption Tracker

13 Sep 2018, 08:30

Hi All,
At work I felt the need to track how often I was being interrupted, and by who.
I started out with an extremely simple Hotkey to launch an inputbox to enter in a user. It would track my login, the user I entered, and time stamp it.

Eventually I wanted to track by which method I was being interrupted (walkups, phone, IM, slack, email, etc.) and also the duration, along with a description.
Then i noticed typos in people i was tracking, so I built in a quick AD lookup to make sure that usernames were consistent when being entered.
Eventually my whole team began to use this, and eventually still, other teams wanted to use it, so I added a way to create and switch between team databases where the information is tracked.

As with all things, i'm sure someone here can look at this and make it even better (especially the GUI which I am sure is laughable), but we've discovered that the data provided by tracking productivity interruptions has helped us identify offenders and schedule process training or other automations to help minimize or eliminate future interruptions from frequent offenders, or help with making cases about project interruptions due to other priorities (say a severity incident, or impromptu emergency from someone you probably shouldn't say no to).

Quick Start Guide:
on first use:
1) click New Database
2) Create a TXT file in a location of your choosing, then select that file
3) you can now save input with the GUI.

Other notes:
- The LogonID field is freeform, so if you wanted to track against something other than people, you may (like a cross-team project name for example)
- The Minutes/duration is also freeform if you want a custom value.
- The "report" opens data in CSV. If you are using excel you can then Pivot table & Graph out any datapoint you would like.
- If you only use this for yourself, you can create a local or home-drive file
- if you want this accessible for a team, you can create a file on a team's network drive
- if you want this available through out an entire department/business, you can create a file on a network share available by all teams

Code: [Select all] [Expand] [Download] GeSHi © Codebox Plus

loop {
MsgBox, Life is like an Infinite Message Box of chocolates.`nThere are %a_index% chocolates in this box.
}
burque505
Posts: 547
Joined: 22 Jan 2017, 19:37

Re: Simple Productivity/Interruption Tracker

14 Sep 2018, 14:25

@AlleyArt, that is very nice.
Regards,
burque505
User avatar
AlleyArtwork
Posts: 30
Joined: 09 Jun 2015, 21:08

Re: Simple Productivity/Interruption Tracker

16 Sep 2018, 16:17

Thanks guys, I hope you enjoy it or find the idea useful or can also put it to use as is.
If you can improve on it, or find a better way to do it please feel free to share.
I learned today, in the Discord chat, that i'm pretty much still quite the noob; and when helping someone, my 50 lines of code and multiple loops to accomplish something, was turned into a much cleaner 30 lines of code. Always learning and being humbled by people better than myself haha.
loop {
MsgBox, Life is like an Infinite Message Box of chocolates.`nThere are %a_index% chocolates in this box.
}

Return to “Scripts and Functions”

Who is online

Users browsing this forum: No registered users and 25 guests