Enhanced Supported Employment 90 Day Calculator Instructions
TheESEMP 90 Day Calculator Excel Spreadsheet was created to help DDSOs and Agencies track the amount of time available for participants in Enhanced Supported Employment contract(s) to gain competitive employment in compliance with the 90 day rule. For the 90 day rule, the first day of employment is considered to be the first day the person reports to work and receives paid compensation for the performance of his/her job duties ( i.e., on the payroll as a paid employee).
Indicate Agency Name, Agency Contact and DDSO(s) thatissued the contract in the first three rows.
Enter the name of each participant in column A.
Column B will automatically calculate the amount of time left for a participant to gain employment before they must be removed from the pilot.
Select “yes” from the drop down menu in column C if a 90 day extension has been approved by the DDSO.
Enter the numerical date the participant’s Enhanced Supported Employment service is initiated as follows: Column G= Month. Column H = Day. Column I = Year. This date should match the service enrollment date entered in TABS.
When a participant becomes employed, enter the Date Employment Began in columns V-X using the same format described above. The Date Employment Began is the first day the person reports to work and receives paid compensation for the performance of his/her job duties ( i.e., on the payroll as a paid employee).The 90 Day Calculator will count the day PRIOR to the Date Employment Began as a day against the 90 Day limit, but the Date Employment Began will not count against the 90 Day limit.
If a participant becomes unemployed, enter the Date Employment Ended in columns AA-AC using the same format described above. The Date Employment Ended is the day after the last day of the person’s paid employment.Columns to the right can be used to track up to 22 additional changes in employment status. The 90 Day Calculator will count the day AFTER Date Employment Ended as a day against the 90 Day limit, but the Date Employment Ended will not count against the 90 Day limit.
Disenrollment from Enhanced Supported Employment will “stop the clock” and reenrollment will start it again. Enter the numerical Date of Disenrollment and Reenrollment in columns L-S using the format described above. A disenrolled individual’s name will be highlighted in purple. If additional disenrollment dates are required for an individual, enter disenrollment & reenrollment dates as periods of employment begin and end. It would help to shade these dates or insert a comment to indicate these are not actual periods of employment.
Important: If there is a Date Employment Began, the Disenrollment Dates must occur on or after last Date Employment Ended or the input will not be accepted. Even if a person continues to be employed when disenrolled, a Date Employment Ended must be entered. If reenrolled, a new Date Employment Began can then be entered.
For questions regarding this spreadsheet contact TheCenter for Employment Excellence at (518) 473-1190 or .