Definitions and Calculations
Explanation of column names and formulas
| MP | Modified Positions | |
| AP | Authorized Positions | |
| E | Enrollments | |
| V | Variance | MP-E or AP-E |
| # Counties | Number of counties with positions | # Counties where grantee or type of grantee (state/national/state+national) has MP or AP |
| # Under | Number of counties with under-enrollment | # counties where grantee or type of grantee (state/national/state+national) has - V |
| % Under | Percentage of positions with under-enrollment | # Un-E / # counties where grantee or type of grantee (state/national/state+national) has MP or AP |
| Avrg.% Und. E | Average percentage of under-enrollment | SUM of V where grantee or type of grantee (state/national/state+national) has - V / SUM of MP or AP where grantee or type of grantee (state/national/state+national) has - V |
| # Over | Number of counties with over-enrollment | # counties where grantee or type of grantee (state/national/state+national) has + V |
| % Over | Percentage of positions with over-enrollment | # counties where grantee or type of grantee (state/national/state+national) has + V / # counties where grantee or type of grantee (state/national/state+national) has MP or AP |
| Avrg.% Over E | Average percentage of over-enrollment | SUM of V where grantee or type of grantee (state/national/state+national) has + V / SUM of MP or AP where grantee or type of grantee (state/national/state+national)) has + V |
| #Over Under | Number of counties with under- or over-enrollment | # counties where grantee or type of grantee (state/national/state+national) has either + V OR - V |
| %Over or Under | Percentage of counties with under- or over-enrollment | # of counties grantee or type of grantee (state/national/state+national) with either +V or –V / # counties where grantee or type of grantee (state/national/state+national) has MP or AP |
| Total V/AP | Total variance as percent of modified or authorized positions | The percentage of total variance (absolutely value of all under- or over-enrollment in counties or states served without regard to directionality) in relation to MP or AP. Calculated as the absolute value of the SUM of variance where grantee (state/national/state+national) has negative variance + absolute value of the SUM of variance where (grantee (state/national/state+national) has positive variance) divided by the SUM of all MP or AP in the relevant grantee or grantee type (state/national/state+national) [NOTE: denominator is ALL MP or AP, not MP or AP where there is positive or negative V] |
Spark lines legend