We have a workshop and each of our technicians have a excel document they open.
On the workbook there are 6 tabs which are for 6 different jobs that they may be asked to do today. An example is, fit number plates or quality check.
They scan our job card at the beginning of their job and at the end of each job.
A typical entry would look like;
Person name, scanned vin, time/date stamped, scanned vin (for finishing job), time stamp, then a date stamp
I have 20 colleagues each using their own workbook, at the moment I am running power query for each of the tabs, or ‘jobs’
From that I can drill in to individual performance which is great.
But as these workbooks are shared and updated at 5 minutes Intervals I’m trying to automate a larger top view automatically. What I need to see is;
Each of the 6 jobs with a current average time per job Live-ish.
underneath each job a breakdown of the colleagues name that is doing that job today or between a set of dates and their average time.
To summarise I want to see if we are running behind on a particular job such as quality control in real time and then be able to see who is doing that task and maybe holding up the average time.
What would be the best way to do this? Could this be a power bi type thing?
On the workbook there are 6 tabs which are for 6 different jobs that they may be asked to do today. An example is, fit number plates or quality check.
They scan our job card at the beginning of their job and at the end of each job.
A typical entry would look like;
Person name, scanned vin, time/date stamped, scanned vin (for finishing job), time stamp, then a date stamp
I have 20 colleagues each using their own workbook, at the moment I am running power query for each of the tabs, or ‘jobs’
From that I can drill in to individual performance which is great.
But as these workbooks are shared and updated at 5 minutes Intervals I’m trying to automate a larger top view automatically. What I need to see is;
Each of the 6 jobs with a current average time per job Live-ish.
underneath each job a breakdown of the colleagues name that is doing that job today or between a set of dates and their average time.
To summarise I want to see if we are running behind on a particular job such as quality control in real time and then be able to see who is doing that task and maybe holding up the average time.
What would be the best way to do this? Could this be a power bi type thing?
