Spreadsheet: 691594d1597770924-calculating-difference-between-two-columns-of-numerical-data-and-returning-a-third-column-sample-tech-productivity-2019-20
Sheet: Sheet1

Technician Productivity Report
Month in review: | Jul
Technician | Grade | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Tech 1 | ST | 0.99 | 1.320138888888889 | 1.12 |  | 1 | 1.07 | 1.33 | 1.17 | 1.07 | 1.09 | 0.98 | 0.74
Tech 2 | ST | 1.11 | 1.215 | 0.88 |  | 1.11 | 1.09 | 1.31 | 1.09 | 0.95 | 0.99 | 1.02 | 0.88
Tech 3 | MT | 0.86 | 1.302982456140351 | 1.31 |  | 0.98 | 1.09 | 1.1 | 0.98 | 1.3 | 0.99 | 1.02 | 0.65
Tech 4 | ST | 1.07 | 1.172777777777778 | 0.89 |  | 1.06 | 1.06 | 1.07 | 1.08 | 1.17 | 0.95 | 1.02 | 0.65
Tech 5 | ST | 0.85 | 1.247124183006536 | 1.07 |  | 0.94 | 1.09 | 1.15 | 1.07 | 1.05 | 1.05 | 1 | 0.55
Tech 6 | MT | 0.97 | 1.053703703703704 | 1.05 |  |  | 1.05 | 1.09 | 0.99 | 1.09 | 0.95 | 0.94 | 0.66
Tech 7 | MT | 0.84 | 1.056111111111111 | 0.73 |  | 1.11 | 1.06 | 1.04 | 1.04 | 1.12 | 1.07 | 0.83 | 0.59
Tech 8 | MT | 0.7 | 1.094444444444445 | 1.07 |  |  | 1.09 | 1.19 | 0.74 | 1.11 | 0.97 | 0.99 | 0.52
Tech 9 | MT | 0.69 | 1.043859649122807 | 0.94 |  | 1.02 | 1.05 | 1.07 | 1.04 | 1.03 | 0.95 | 0.84 | 0.7
Tech 10 | MT | 0.85 | 0.9833333333333333 | 0.94 |  | 1.19 | 1.08 | 0.95 | 1.01 | 1.01 | 0.97 | 0.95 | 0.4
Tech 11 | MT | 0.78 | 1.058765432098765 | 0.81 |  | 0.95 | 1.06 | 1.06 | 1.17 | 1.04 | 0.95 | 0.98 | 0.43
Tech 12 | MT | 0.69 | 1.174269005847953 | 0.84 |  | 0.97 | 1.23 | 1.33 |  |  | 0.65 | 0.86 | 0.57
Tech 13 | MT | 0.26 | 0.5137254901960784 | 0.74 |  | 1.14 | 1.08 | 1.34 | 1.06 | 0.92 | 1.2 | 0.61 | 1.11
Tech 14 | MT | 0.43 | 1.051234567901235 | 0.65 |  | 1.45 | 0.78 | 1.05 | 1 | 1.07 | 0.97 | 0.99 | 0.43
Tech 15 | DT | 0.79 | 1.069135802469136 | 0.91 |  | 0.88 | 0.86 | 0.95 | 0.86 | 0.92 | 0.88 | 0.61 | 0.49
Tech 16 | MT | 0.82 | 1.047863247863248 | 0.63 |  |  |  | 1.08 | 0.74 | 0.94 | 0.95 | 0.95 | 0.38
Tech 17 | MT | 0.63 | 0.9135802469135802 | 0.82 |  |  |  | 1.05 | 1 | 0.92 | 0.91 | 0.82 | 0.36
Tech 18 | MT | 0.63 | 1.046777777777778 | 0.66 |  | 0.86 | 0.82 | 0.53 | 0.88 | 0.96 | 0.9 | 0.77 | 0.56
Tech 19 | MT | 0.66 | 1.081666666666667 | 0.77 |  |  |  | 1.07 | 0.8 | 0.84 | 0.71 | 0.8 | 0.31
Tech 20 | DT | 0.59 | 0.6876543209876543 | 0.52 |  | 1.2 | 1.3 | 0.94 | 0.77 | 0.71 | 0.65 | 0.55 | 0.51
Tech 21 | MT | 0.44 | 0.8076923076923077 | 0.6 |  | 0.9 | 0.95 |  | 0.87 | 0.72 | 0.81 | 0.95 | 0.41
Tech 22 | MT | 0.65 | 0.975 | 0.66 |  | 0.57 | 0.7 | 0.95 |  |  | 0.65 | 0.8 | 0.35
Tech 23 | ST | 0.3 | 0.3228395061728395 | 0.27 |  | 0.32 | 0.99 | 0.33 |  | 0.94 | 0.95 | 0.98 | 0.2
Grand Totals
Over 95%
Highest Performer in month in review
Lowest [NAME] in month in review
Most improved against previous month
Least improved against previous month
MT
ST
DT
DT TL
DT SUP
MOT
App. 4
App. 3
[NAME]
Croydon
[NAME]
Brooklands
Brentford
[NAME]
Bromley
[NAME]
[NAME]
Waltham Cross
Loughton
Colindale
Watford
[NAME]
Temple Fortune
Chelsea
Service Factory
 |  | Feb | Jan | Dec | Nov | Oct | Sep | Aug | Jul | Jun | May | Apr | Mar
 |  | Mar | Feb | Jan | Dec | Nov | Oct | Sep | Aug | Jul | Jun | May | Apr
 |  | Apr | Mar | Feb | Jan | Dec | Nov | Oct | Sep | Aug | Jul | Jun | May
 |  | May | Apr | Mar | Feb | Jan | Dec | Nov | Oct | Sep | Aug | Jul | Jun
 |  | Jun | May | Apr | Mar | Feb | Jan | Dec | Nov | Oct | Sep | Aug | Jul
 |  | Jul | Jun | May | Apr | Mar | Feb | Jan | Dec | Nov | Oct | Sep | Aug
 |  | Aug | Jul | Jun | May | Apr | Mar | Feb | Jan | Dec | Nov | Oct | Sep
 |  | Sep | Aug | Jul | Jun | May | Apr | Mar | Feb | Jan | Dec | Nov | Oct
 |  | Oct | Sep | Aug | Jul | Jun | May | Apr | Mar | Feb | Jan | Dec | Nov
 |  | Nov | Oct | Sep | Aug | Jul | Jun | May | Apr | Mar | Feb | Jan | Dec
 |  | Dec | Nov | Oct | Sep | Aug | Jul | Jun | May | Apr | Mar | Feb | Jan
 |  | Jan | Dec | Nov | Oct | Sep | Aug | Jul | Jun | May | Apr | Mar | Feb