Berk21
Jan 26, 2009, 06:11 PM
I have been working on a spread sheet on quality control for telecommunican technicians.
I am stumped on one or two things. I am trying to get a % of failure according to the work that has successfully completed according to what was QC'd and what failed. Is there such a way? Or formula? And would it be fair to evaluate them on such a equation?
Example:
Joe completes 25 jobs successfully. Quality control evaluates 32% of that work. Joe fails 5 of that 32%.. What can I base his failure % on?
I have attached the spread sheet to help in the matter... The column I need help with is P (QC failure % by Tech)
I have a feeling I can't do it based on the information provided.
Thanks in advanced
I am stumped on one or two things. I am trying to get a % of failure according to the work that has successfully completed according to what was QC'd and what failed. Is there such a way? Or formula? And would it be fair to evaluate them on such a equation?
Example:
Joe completes 25 jobs successfully. Quality control evaluates 32% of that work. Joe fails 5 of that 32%.. What can I base his failure % on?
I have attached the spread sheet to help in the matter... The column I need help with is P (QC failure % by Tech)
I have a feeling I can't do it based on the information provided.
Thanks in advanced