Spreadsheet: 35347d1232970327-disabling-auto-calculate-for-others-working-sample
Sheet: Breakdown

 |  |  |  |  |  |  | Instructions: Scroll across the page to the right to view the data in graphical form
1
GRADE | Actual Numbers |  |  |  |  |  |  |  |  |  | Percentage Breakdown of Box Marked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Numbers - Including TP |  |  |  |  |  |  |  |  |  | Actual Numbers - NOT Including TP
 | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 |  | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR - career break/special leave without pay |  | Total Employees | Total Box-Marked | Total Updated | Percentage |  |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay
EA | 6 | 8 | 8 | 5 | 3 | 0 | 1 | 0 | 1 |  | 0.2 | 0.2666666666666667 | 0.2666666666666667 | 0.1666666666666667 | 0.1 |  | 0 | 0.03125 | 0 | 0.03125 |  | 32 | 30 | 32 | 1 |  |  | 6 | 8 | 8 | 5 | 3 | 0 | 1 | 0 | 1 |  | 8 | 10 | 8 | 5 | 4 | 0 | 1 | 0 | 1
EO | 1 | 4 | 2 | 2 | 1 | 0 | 0 | 0 | 0 |  | 0.1 | 0.4 | 0.2 | 0.2 | 0.1 |  | 0 | 0 | 0 | 0 |  | 10 | 10 | 10 | 1 |  |  | 1 | 4 | 2 | 2 | 1 | 0 | 0 | 0 | 0 |  | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0
HEO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HEOD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SEO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
G7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
G6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CSA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 7 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 0.175 | 0.3 | 0.25 | 0.175 | 0.1 |  | 0 | 0.02380952380952381 | 0 | 0.02380952380952381 |  | 42 | 40 | 42 | 1 |  |  | 7 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1
SITE | Actual Numbers |  |  |  |  |  |  |  |  |  | Percentage Breakdown of Box Marked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Numbers - Including TP |  |  |  |  |  |  |  |  |  | Actual Numbers - NOT Including TP
 | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 |  | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR - career break/special leave without pay |  | Total Employees | Total Box-Marked | Total Updated | Percentage |  |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay
Darlington | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 |  | 0.6 | 0 | 0 | 0.4 | 0 |  | 0 | 0 | 0 | 0.1666666666666667 |  | 6 | 5 | 6 | 1 |  |  | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 |  | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1
London | 3 | 1 | 3 | 2 | 1 | 0 | 0 | 0 | 0 |  | 0.3 | 0.1 | 0.3 | 0.2 | 0.1 |  | 0 | 0 | 0 | 0 |  | 10 | 10 | 10 | 1 |  |  | 3 | 1 | 3 | 2 | 1 | 0 | 0 | 0 | 0 |  | 3 | 1 | 3 | 2 | 1 | 0 | 0 | 0 | 0
Runcorn | 1 | 4 | 2 | 1 | 3 | 0 | 1 | 0 | 0 |  | 0.09090909090909091 | 0.3636363636363636 | 0.1818181818181818 | 0.09090909090909091 | 0.2727272727272727 |  | 0 | 0.08333333333333333 | 0 | 0 |  | 12 | 11 | 12 | 1 |  |  | 1 | 4 | 2 | 1 | 3 | 0 | 1 | 0 | 0 |  | 1 | 4 | 2 | 1 | 3 | 0 | 1 | 0 | 0
Sheffield | 1 | 7 | 5 | 2 | 0 | 0 | 0 | 0 | 0 |  | 0.06666666666666667 | 0.4666666666666667 | 0.3333333333333333 | 0.1333333333333333 | 0 |  | 0 | 0 | 0 | 0 |  | 15 | 15 | 15 | 1 |  |  | 1 | 7 | 5 | 2 | 0 | 0 | 0 | 0 | 0 |  | 1 | 7 | 5 | 2 | 0 | 0 | 0 | 0 | 0
Off Site | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 0.2162162162162162 | 0.3243243243243243 | 0.2702702702702703 | 0.1891891891891892 | 0.1081081081081081 |  | 0 | 0.02325581395348837 | 0 | 0.02325581395348837 |  | 43 | 37 | 43 | 1 |  |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1
GENDER | Actual Numbers |  |  |  |  |  |  |  |  |  | Percentage Breakdown of Box Marked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Numbers |  |  |  |  |  |  |  |  |  | Actual Numbers
 | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 |  | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR - career break/special leave without pay |  | Total Employees | Total Box-Marked | Total Updated | Percentage |  |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay
Male | 5 | 5 | 7 | 3 | 3 | 0 | 1 | 0 | 0 |  | 0.2173913043478261 | 0.2173913043478261 | 0.3043478260869565 | 0.1304347826086956 | 0.1304347826086956 |  | 0 | 0.04166666666666666 | 0 | 0 |  | 24 | 23 | 24 | 1 |  |  | 5 | 5 | 7 | 3 | 3 | 0 | 1 | 0 | 0 |  | 5 | 5 | 7 | 3 | 3 | 0 | 1 | 0 | 0
Female | 3 | 7 | 3 | 4 | 1 | 0 | 0 | 0 | 1 |  | 0.1666666666666667 | 0.3888888888888889 | 0.1666666666666667 | 0.2222222222222222 | 0.05555555555555555 |  | 0 | 0 | 0 | 0.05263157894736842 |  | 19 | 18 | 19 | 1 |  |  | 3 | 7 | 3 | 4 | 1 | 0 | 0 | 0 | 1 |  | 3 | 7 | 3 | 4 | 1 | 0 | 0 | 0 | 1
TOTAL | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 0.2162162162162162 | 0.3243243243243243 | 0.2702702702702703 | 0.1891891891891892 | 0.1081081081081081 |  | 0 | 0.02325581395348837 | 0 | 0.02325581395348837 |  | 43 | 37 | 43 | 1 |  |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1
ETHNICITY | Actual Numbers |  |  |  |  |  |  |  |  |  | Percentage Breakdown of Box Marked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Numbers |  |  |  |  |  |  |  |  |  | Actual Numbers
 | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 |  | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR - career break/special leave without pay |  | Total Employees | Total Box-Marked | Total Updated | Percentage |  |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay
BME | 2 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 |  | 0.4 | 0 | 0.4 | 0.2 | 0 |  | 0 | 0 | 0 | 0 |  | 5 | 5 | 5 | 1 |  |  | 2 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 |  | 2 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0
White | 6 | 11 | 8 | 5 | 3 | 0 | 0 | 0 | 1 |  | 0.1818181818181818 | 0.3333333333333333 | 0.2424242424242424 | 0.1515151515151515 | 0.09090909090909091 |  | 0 | 0 | 0 | 0.02941176470588235 |  | 34 | 33 | 34 | 1 |  |  | 6 | 11 | 8 | 5 | 3 | 0 | 0 | 0 | 1 |  | 6 | 11 | 8 | 5 | 3 | 0 | 0 | 0 | 1
Not Known | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | #N/A |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Prefer Not To Say | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 |  | 0 | 0.3333333333333333 | 0 | 0.3333333333333333 | 0.3333333333333333 |  | 0 | 0.25 | 0 | 0 |  | 4 | 3 | 4 | 1 |  |  | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 |  | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0
TOTAL | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 0.2162162162162162 | 0.3243243243243243 | 0.2702702702702703 | 0.1891891891891892 | 0.1081081081081081 |  | 0 | 0.02325581395348837 | 0 | 0.02325581395348837 |  | 43 | 37 | 43 | 1 |  |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1
DISABILITY | Actual Numbers |  |  |  |  |  |  |  |  |  | Percentage Breakdown of Box Marked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Numbers |  |  |  |  |  |  |  |  |  | Actual Numbers
 | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 |  | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR - career break/special leave without pay |  | Total Employees | Total Box-Marked | Total Updated | Percentage |  |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay
Yes | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0.2 | 0.2 | 0.6 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 5 | 5 | 5 | 1 |  |  | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0
No | 7 | 10 | 7 | 6 | 3 | 0 | 1 | 0 | 1 |  | 0.2121212121212121 | 0.303030303030303 | 0.2121212121212121 | 0.1818181818181818 | 0.09090909090909091 |  | 0 | 0.02857142857142857 | 0 | 0.02857142857142857 |  | 35 | 33 | 35 | 1 |  |  | 7 | 10 | 7 | 6 | 3 | 0 | 1 | 0 | 1 |  | 7 | 10 | 7 | 6 | 3 | 0 | 1 | 0 | 1
Not Known | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | #N/A |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Prefer Not To Say | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 |  | 0 | 0.3333333333333333 | 0 | 0.3333333333333333 | 0.3333333333333333 |  | 0 | 0 | 0 | 0 |  | 3 | 3 | 3 | 1 |  |  | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 |  | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0
TOTAL | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 0.2162162162162162 | 0.3243243243243243 | 0.2702702702702703 | 0.1891891891891892 | 0.1081081081081081 |  | 0 | 0.02325581395348837 | 0 | 0.02325581395348837 |  | 43 | 37 | 43 | 1 |  |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1
WORK PATTERN | Actual Numbers |  |  |  |  |  |  |  |  |  | Percentage Breakdown of Box Marked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Numbers |  |  |  |  |  |  |  |  |  | Actual Numbers
 | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 |  | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR - career break/special leave without pay |  | Total Employees | Total Box-Marked | Total Updated | Percentage |  |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay
Part-time | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 1 |  | 0.1666666666666667 | 0.3333333333333333 | 0.3333333333333333 | 0.1666666666666667 | 0 |  | 0 | 0 | 0 | 0.1428571428571428 |  | 7 | 6 | 7 | 1 |  |  | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 1 |  | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 1
Full-time | 7 | 10 | 8 | 6 | 4 | 0 | 1 | 0 | 0 |  | 0.2 | 0.2857142857142857 | 0.2285714285714286 | 0.1714285714285714 | 0.1142857142857143 |  | 0 | 0.02777777777777778 | 0 | 0 |  | 36 | 35 | 36 | 1 |  |  | 7 | 10 | 8 | 6 | 4 | 0 | 1 | 0 | 0 |  | 7 | 10 | 8 | 6 | 4 | 0 | 1 | 0 | 0
TOTAL | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 0.2162162162162162 | 0.3243243243243243 | 0.2702702702702703 | 0.1891891891891892 | 0.1081081081081081 |  | 0 | 0.02325581395348837 | 0 | 0.02325581395348837 |  | 43 | 37 | 43 | 1 |  |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1
AGE GROUPS | Actual Numbers |  |  |  |  |  |  |  |  |  | Percentage Breakdown of Box Marked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Numbers |  |  |  |  |  |  |  |  |  | Actual Numbers
 | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 |  | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR - career break/special leave without pay |  | Total Employees | Total Box-Marked | Total Updated | Percentage |  |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay |  | Cat 1 | Cat 2+ | Cat 2 | Cat 3 | Cat 4 | NR-insufficient time in grade/post | NR-long term sick absence | NR-maternity/parental/adoption/disability leave | NR-career break/special leave without pay
Under 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | #N/A |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 to 29 | 2 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 0 |  | 0.3333333333333333 | 0.1666666666666667 | 0 | 0.3333333333333333 | 0.1666666666666667 |  | 0 | 0 | 0 | 0 |  | 6 | 6 | 6 | 1 |  |  | 2 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 0 |  | 2 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 0
30 to 39 | 4 | 9 | 7 | 4 | 2 | 0 | 1 | 0 | 0 |  | 0.1538461538461539 | 0.3461538461538461 | 0.2692307692307692 | 0.1538461538461539 | 0.07692307692307693 |  | 0 | 0.03703703703703703 | 0 | 0 |  | 27 | 26 | 27 | 1 |  |  | 4 | 9 | 7 | 4 | 2 | 0 | 1 | 0 | 0 |  | 4 | 9 | 7 | 4 | 2 | 0 | 1 | 0 | 0
40 to 49 | 2 | 2 | 3 | 1 | 1 | 0 | 0 | 0 | 1 |  | 0.2222222222222222 | 0.2222222222222222 | 0.3333333333333333 | 0.1111111111111111 | 0.1111111111111111 |  | 0 | 0 | 0 | 0.1 |  | 10 | 9 | 10 | 1 |  |  | 2 | 2 | 3 | 1 | 1 | 0 | 0 | 0 | 1 |  | 2 | 2 | 3 | 1 | 1 | 0 | 0 | 0 | 1
50 to 59 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | #N/A |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
60 and over | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | #N/A |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 0.2162162162162162 | 0.3243243243243243 | 0.2702702702702703 | 0.1891891891891892 | 0.1081081081081081 |  | 0 | 0.02325581395348837 | 0 | 0.02325581395348837 |  | 43 | 37 | 43 | 1 |  |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1 |  | 8 | 12 | 10 | 7 | 4 | 0 | 1 | 0 | 1
put this in your thisworkbook module  Private Sub Workbook_Open() On Error Resume Next Application.CommandBars("Edit").Controls("&copy").Enabled = False Application.CommandBars("cell").Controls("&copy").Enabled = False Application.OnKey "^c", "disablec" End Sub   Sub disablec() MsgBox "Copy command disabled" End Sub   Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error Resume Next Application.CommandBars("Edit").Controls("&copy").Enabled = True Application.CommandBars("cell").Controls("&copy").Enabled = True Application.OnKey "^c", "" End Sub   'then put this in a module  Sub disablec() MsgBox "Copy command disabled" End Sub