The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Forum Username


Search the Elsmar Cove
Custom Search
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links





Donate and $ Contributor Forum Access

Click the graphic above.
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook
IRCA - International Register of Certified Auditors
SAE - Society of Automotive Engineers
Quality Digest Portal
IEST - Institute of Environmental Sciences and Technology
ASQ - American Society for Quality

Related Topic Tags
employee performance and reviews, key performance indicators (kpi), kpi data, microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
  #1  
Old 11th April 2007, 07:08 PM
goallout - 2009 goallout - 2009 is offline
E-Mails Invalid or Rejected by Recipient System

 
Registration Date: Aug 2006
Location: China
 
Posts: 33
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 0
Karma: 10
goallout - 2009 has less than 100 Karma points so far.
Thank You! Staff KPI (Key Performance Indicator) .xls Excel format

I am tasked to come out a KPI format to measure my staffs performance in monthly basis.
Anyone has any example in excel format to share.

Sponsored Links
  #2  
Old 16th April 2007, 09:08 AM
CarolX's Avatar
CarolX CarolX is offline
Super Moderator

 
Registration Date: Jun 2000
Location: North of Chicago,Illinois, USA
Age: 54
 
Posts: 2,171
Thanks Given to Others: 471
Thanked 390 Times in 279 Posts
Karma Power: 285
Karma: 5210
CarolX is appreciated, and has over 1700 Karma points.
CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.CarolX is appreciated, and has over 1700 Karma points.
Re: Looking for Staff KPI (Key Performance Indicator) .xls Excel format

No response yet - can anyone help?

__________________

CarolX

Theater is life, film is art, and television is furniture.
Sponsored Links

  #3  
Old 16th April 2007, 10:15 AM
SteelMaiden's Avatar
SteelMaiden SteelMaiden is offline
Super Moderator

 
Registration Date: Jan 2001
Location: NC, USA
 
Posts: 4,192
Thanks Given to Others: 575
Thanked 1,387 Times in 847 Posts
Karma Power: 496
Karma: 11454
SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.
SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.
Re: Looking for Staff KPI (Key Performance Indicator) .xls Excel format

First, why are you measuring your STAFF's performance, shouldn't you measure the process? What are you asking for?
If you want all the "XYZ Clerks" to process 100 pieces of "Paper123" each day you can track by listing each clerk down column 1, then the days of the month across row one. If Sally processes 100 on the first, 99 on the 2nd, 98 on the 3rd, you just fill in the numbers. But, somehow, I find that this sounds a little simplistic and micromanagerial, can it possibly be what you are asking?

__________________

"It's fun to have fun, but you have to know how", Dr. Seuss
Man may have invented fire, it took a woman to learn how to play with it.
  #4  
Old 16th April 2007, 10:37 AM
Ajit Basrur's Avatar
Ajit Basrur Ajit Basrur is offline
Forum Administrator

 
Registration Date: Dec 2005
Location: Massachusetts, USA
Age: 50
 
Posts: 5,671
Thanks Given to Others: 1,745
Thanked 2,661 Times in 1,671 Posts
Karma Power: 400
Karma: 16136
Ajit Basrur is appreciated, and has over 1700 Karma points.
Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.
Re: Looking for Staff KPI (Key Performance Indicator) .xls Excel format

Quote:
In Reply to Parent Post by goallout View Post

I am tasked to come out a KPI format to measure my staffs performance in monthly basis.
Anyone has any example in excel format to share.
Can you be more specific what you are expecting by STAFF performance ?

__________________

You canít use up creativity. The more you use, the more you have Ė Maya Angelou
  #5  
Old 16th April 2007, 10:45 AM
Benjamin28 Benjamin28 is offline
Inactive Registered Visitor

 
Registration Date: Dec 2006
Location: CT
 
Posts: 379
Thanks Given to Others: 89
Thanked 161 Times in 109 Posts
Karma Power: 69
Karma: 982
Benjamin28 is appreciated, and has over 900 Karma points.Benjamin28 is appreciated, and has over 900 Karma points.Benjamin28 is appreciated, and has over 900 Karma points.Benjamin28 is appreciated, and has over 900 Karma points.Benjamin28 is appreciated, and has over 900 Karma points.Benjamin28 is appreciated, and has over 900 Karma points.Benjamin28 is appreciated, and has over 900 Karma points.Benjamin28 is appreciated, and has over 900 Karma points.
Re: Looking for Staff KPI (Key Performance Indicator) .xls Excel format

I'm assuming you're just looking for an example of the format of such a sheet as KPI is absolutely unique to your organization/goals. One such example is attached

As you can see the first page is simply a definition of what indicators are being reviewed followed by supporting data, graphical or otherwise. You can set up a sheet any way you like though, it's your KPI and it should be set up in a fashion that makes sense to you. As for what to measure, as stated, it depends on your organization and goals, but you must ensure that whatever you select IS measurable in one way or another. Just try to select meaningful items, and if you're going to review anything related to volume (e.g. Bob produces 100 parts per shift) try to also include a review of quality output (e.g. Bob also produces 10% non-conforming parts per shift).



Oh, another thing, quite often weighted values are used to better identify what's most/more important.
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls Key Performance Indicators List.xls (2.77 MB, 1387 views)
Thank You to Benjamin28 for your informative Post and/or Attachment!
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
KPI (Key Performance Indicators) vs. Objectives Thelearner ISO 9000, ISO 9001, and ISO 9004 - Questions and Discussions 58 13th June 2011 04:14 AM
Key Performance Indicators (KPI) in IT Environment keres Quality Tools, Improvement and Analysis 10 30th December 2010 11:52 AM
Can a KPI (Key Process Indicator) be created against Nonconformances? munkee Nonconformance and Corrective Action 8 13th December 2010 12:23 PM
KPI (Key Process Indicator) - Cost of Non Quality alekra Benchmarking - Sharing Data 8 9th November 2009 01:47 AM
Key Performance Index (KPI) in a restaurant! vasilist Statistical Analysis Tools, Techniques and SPC 13 1st May 2006 01:15 PM



The time now is 11:51 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272