Performance Tracking

obirobkenobi

New Member
Joined
Nov 22, 2016
Messages
1
I want to track performance of my service techs.
I want to measure them monthly by service request turnover and average age of service requests.
Turnover is how many new requests were generated during the month and how many were closed. Target is 100%
Average age of service requests is how many days it takes to close a request. Target is 7 days.
Average age is the priority, so I'd like to weigh that metric at 75% vs. 25% for the # of requests.
I want to refer to the result as the Performance Factor.
I'd like to group the results in a graduating scale, e.g. 0-3 = 100%, 3-6 = 90%, and so on.
I'd like to have a table the corresponds to the results that you can reference based on the result.
I would appreciate any ideas on this project.
Thanks in advance.
Rob
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,216,471
Messages
6,130,823
Members
449,595
Latest member
jhester2010

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top