Percentages in Inspections

Percentages in Inspections

As you complete inspections in CleanTelligent, you will notice that there are scores given per service, per area, per inspection, and per location or group of locations over a period of time. You will also see that some of your inspections have a percentage of the services scored are deficient or non-deficient. We will discuss in this article what all this means and how CleanTelligent calculates these percentages.

Scores Per Service

In an inspection, each service provided by the Job Template will have a set of scores that can be applied. These are the buttons seen below taken from the mobile app.



When you select one of these scores and save, the corresponding percentage is associated with that service. The score percent is based on the Custom Rating Template being used in your Job Template

For a refresher on the Custom Rating Template, see Custom Rating Templates



As you can see from the image above, a rating of 1 has a score of 100% and a rating of 5 has a score of 0% but there are other scores in between. Also note that ratings 3 through 5 are all marked as deficient, we'll come back to that later.

Based on this rating template, if we were to chose a rating of 3 we would be scoring the service at 75% and marking it as deficient at the same time.

Average Scores

CleanTelligent will provide average scores within each inspection per area, for the entire inspection, and for groupings of inspections based on a date range and selection of locations through reports and dashboards. This section explains how those averages are calculated. There will be a little math in this section so strap on your thinking caps and get ready. We'll explain it all as best we can and try not to loose you.

"If you have a set of numbers, the average is found by adding all numbers in the set and dividing their sum by the total number of numbers added in the set."

In CleanTelligent, if all of your service scores are weighted the same then the calculation is this simple. Add up all the scores and then divide by the number of scores in the data set. If you are looking at just a single inspection that means all the services scored in that inspection. If you are looking at several inspections that means all the services scored in all the inspections combined.
Sometimes people add up the average scores from each inspection and divide by the number of inspections and think that should be the average score across those multiple inspections but this is not the case. That is what is called Averaging Averages. While sometimes the math coincidentally works out, that is a rare thing. Most of the time things will get messy and you will have the wrong score. What CleanTelligent does by looking at each score individually across multiple inspections avoids averaging the averages. Here is a great article by Indiana University that illustrates this concept and why we calculate things the way we do. http://www.incontext.indiana.edu/2013/mar-apr/article3.asp

Weighted Scores

While we recommend not weighting your services differently from the rest, CleanTelligent does give you the option to do just that in the Job Template. This makes scoring and averaging the scores a little bit more complicated. Here is the math behind weighted scores and calculating the average. 
Remember, if all of your scores are weighted the same then the weight of all scores is a 1 so we can still use the simple average formula
What CleanTelligent does is this. We take all the individual scores, multiply each score by their weight, add them together, and divide by the sum of your scored services weights. In our calculations we have the following variables:
  1. Little s = the score given to each service
  2. Little w = the weight of each service scored
  3. Big S = the weighted score of each service = s * w
  4. Big T = the sum of all S
  5. Big W = the sum of all w
Using these variables we have the following equation to calculate the average score of a set of scores.
Average Score = T / W

Example:
Given the following table of data, we get an average score of 77.5%. We've added another column to show which of these scores are deficient and which are not.

s = the score given to each service
w = the weight of each service
S = s * w
Deficient?
95%
1
95%
No
95%
1
95%
No
95%
2
190%
No
100%
1
100%
No
100%
1
100%
No
100%
1
100%
No
100%
1
100%
No
100%
1
100%
No
50%
1
50%
Yes
0%
2
0%
Yes

W = 12
T = 930%


930% / 12 = 77.5%


Percent Deficient vs Non Deficient

When you look at your dashboards, reports, or email notifications you may see the average score as described above as well as the percent of deficient vs non-deficient scores. These values may match up if you only deal with 100% and 0% scores where all services are weighted the same, but likely you will come across different percentages.



Using the same dataset from the table above in the Weighted Scores section, we can calculate the percent of deficient scores by adding up how many are deficient and dividing that number by the total number of scores. Likewise, we find the percent of non-deficient scores by adding the number of non-deficient scores and dividing by the total number of scores. When calculating these percentages we don't take weights into account.

s = the score given to each service
w = the weight of each service
S = s * w
Deficient?
95%
1
95%
No
95%
1
95%
No
95%
2
190%
No
100%
1
100%
No
100%
1
100%
No
100%
1
100%
No
100%
1
100%
No
100%
1
100%
No
50%
1
50%
Yes
0%
2
0%
Yes

W = 12
T = 930%


Given the table above, we have 10 services that are scored, 8 of which are non-deficient and 2 of which are deficient.
Non-Deficient = 8/10 = 80%
Deficient = 2/10 = 20%

    • Related Articles

    • Completing Inspection Deficiencies in Work Orders

      If you have work orders being generated from your inspections, any deficiencies found will show up as items to be completed for that work order. (To learn how to set that up, check out SP Info Overview) You can find these deficiencies on the mobile ...

    • Inspection Template Types

      What Are Inspection Template Types? A basic inspection will only require one type of template assigned to the service location, the Job Template. This assigns the services to be scored during an inspection. (see Create a Job Template) But the ...

    • Completing Saved Inspections on the Mobile App

      What is a Saved Inspection? A Saved Inspection is any inspection you performed on your mobile device that was not fully uploaded to CleanTelligent servers. It could be that you didn't have an internet connection when you completed the inspection. It ...

    • Average Inspection Scores Report

      Transcript: This video is to show how to run the Average Inspection Scores report. Start by clicking on the Reports tab. The Average Inspection Scores report is located in the first section. There are two output types, PDF Report and MS Excel. Choose ...

    • FAQ: Inspection Users

      Q: How do I perform an inspection on the app? A: Follow the instructions in our guide Perform a Mobile Inspection Q: How do I perform an inspection on the website? A: Follow the instructions in our guide Perform a Web Inspection Q: What reports can I ...