FY 2016 |
Counts the number of cells in Column B of the Data Entry sheet that contain information and subtracts Carry-Ins (Column D)
Veterans Referred from VR&E |
Counts the number of cells in Column E of the Data Entry sheet that contains a "Y"
Carried In From Previous FY |
Counts the number of cells in Column K of the Data Entry Sheet minus D on the Report Data Sheet
Referred Veterans Provided Employment Services |
Calculates the number of days from the date in Column H to the date in Column K of the Data Entry sheet for those rows that have an "E" entered in Column I divided by the number of records with an "E" in Column I on the Data Entry sheet.
Avg # of Days from Referral to Employment Svc Provided |
Counts the number of cells in Column B on the Data Entry sheet that contain information and the number of cells in Column E that do not contain a "Y" and where Column K does not contain a date
Referred Veterans Not Provided Service |
Counts the number of cells in Column I of the Data Entry sheet that contain an "L"
Referred Veterans for Initial LMI |
Author:
Counts the number of cells in Column M of the Data Entry sheet that contain a "Y"
Employment Considered Suitable |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "D"
Closed "D" Financial Disincentives |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "E"
Closed "E" Entered Unsuitable Employment |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "F"
Closed "F" Family Resp. |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "L"
Closed "L" Provided Initial LMI |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "M"
Closed "M" Medical Reasons |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "N"
Closed "N" Not Satisfied with Services |
Counts the number of cells in Column S of the Data Entry sheet that contain the codes 1-6
Closed "O" Other |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "R"
Closed "R" Rehab. |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "S"
Closed "S" School / Continuing Education |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "T"
Closed "T" Moved Out of State |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "U"
Closed "U" Unable to Locate or Unresp. Veteran |
Counts the number of cells in Column S of the Data Entry sheet that contain the code "X"
Closed "X" Unwilling / Unable to Relocate for Employment |
Counts the number of cells in Column I of the Data Entry sheet that contain an "E" and a date in Column K and does not contain a closure reason in Column S
Veterans Provided Svc & Available for Work |
Averages the hourly wage amounts entered in Column Q of the Data Entry Sheet
and have a "Y" in Column M
divided by the number of "Y" in Column M.
Average Entry Wage for Those Considered Rehab. |
For those Veterans that have a code "E" in Column G
Avg # of Days from Referral for Empl. Services to Empl. |
The sum of all "R" codes in Column S divided by the sum of all "R","E", and "N" codes in Column S.
JWG Rehab. Rate |