PWS_Attachment_13-YCP-Assessment_Overall_Health_Calculator_V5.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- YCP INSPECTION Services ONLY
- Solicitation number
- W9133L-17-R-0030
- Issued by
-
Department of the Army National Guard
About this file
PWS Attachment #13
View the file
Other files
Show all 47
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Overall Health Calculator
FOR GOVERNMENT USE ONLY
Instructions: Fill in the green shaded boxes by inputing the Program Code,Visit Date, and scores (including two decimal places) for all compliance and individual performance metrics.
| Program Code |
| Visit Date |
| Assign based on score ranges | Compute decile for pointer placement | Lower bounds of each range | ||||||
| Score | Rating | ExSum (out of 10) | Outstanding | Excellent | Satisfactory | Marginal | Unsatisfactory | |
| OE Compliance | 100.00 | Outstanding | 10 | 95 | 90 | 85 | 80 | 0 |
| RM Compliance | 100.00 | Outstanding | 10 | 95 | 90 | 85 | 80 | 0 |
| Graduation Target | 101.00 | Outstanding | 10 | 98 | 95 | 93 | 90 | 0 | 15 |
| Month 6 Placement | 57.00 | Satisfactory | 0 | 85 | 71 | 57 | 43 | 0 | |
| Month 12 Placement | 73.00 | Excellent | 0 | 86 | 73 | 59 | 46 | 0 | |
| Month 6 Contact | 53.00 | Marginal | 0 | 95 | 81 | 67 | 53 | 0 | |
| Month 12 Contact | 66.00 | Satisfactory | 0 | 94 | 80 | 66 | 52 | 0 | |
| OE Performance (sum standard scores) | 162.25 | Satisfactory | 5 | 188 | 171 | 155 | 139 | 0 |
| Cost per Cadet | 102.90 | Satisfactory | 7 | 102 | 102.7 | 103.3 | 104 | inf | 7 |
| Budget Execution | 100.00 | Outstanding | 10 | 99 | 98.3 | 97.7 | 97 | 0 | |
| Financial Performance (sum standard scores) | 197.18 | Outstanding | 1 | 197 | 196 | 195 | 193 | 0 |
| Overall Health (sum component scores) | 559.43 | Excellent | 4 | 575 | 547 | 520 | 492 |
| Notes: There is no rounding for ratings. Performance scores are sum of each Performance metric. Dollar cost per Cadet floored at 100% and converted to ascending measure for Financial Performance total score; Graduation Target is capped at 100% for OE Performance total score. Overall health score is the sum of the four component scores. |
Overall Health Outbrief Slide Assessment Results
| Overall Health Score: | 559.43 | This sheet provides the information in the format needed for the Outbrief slides. Copy the required cells from this page. Highlight those cells in PowerPoint and paste. |
| Overall Health Rating: | EXCELLENT |
| Component | Rating |
| Operational Compliance | Outstanding |
| Resource Management Compliance | Outstanding |
| Operational Performance | Satisfactory |
| Financial Performance | Outstanding |
File details come from the government source that posted it. Updated .