D1-AX1 Title. The unit names entered in the Resource Summary worksheet are auto-populated. Workgroup Type D3-AX19 The formula in each cell computes the FTEs needed for each workgroup type by referencing the respective Needed by Workgroup Type” cell location in the “Hours worksheet and dividing it by the hours Hours Needed caseworkers have available for casework, dependent on the hours caseworkers are to work each week as reported in the Resource Summary worksheet. Total Unit Count D20-AX20 Sum of the FTEs needed for each unit. Calculated Workgroup Time The analytic tool contains the times needed to complete required and other tasks and formulas which sum the total time needed to complete all the tasks for each workgroup type. The gold highlighted cells may be changed as policies or practice standards change, amending the time it takes to complete a task, adding new tasks and their respective times, or deleting a task that is no longer completed for all workgroups of a given workgroup type (i.e., required tasks). Once a gold cell has been altered, the salmon colored cells will readjust the sums accordingly, including those in the Hours Needed worksheet. The following details the contents of the worksheet. Column Cell Location Content Required Tasks A1 Title. Definition A2-A13 List of required tasks. Tasks A14 Title. Time Standard A15 Title. Intake Screening B1 Title.
Workgroup Type Total Unit Count D1-AX1 D3-AX19 D20-AX20 Title. The unit names entered in the Resource Summary worksheet are auto-populated. The formula in each cell computes the FTEs needed for each workgroup type by referencing the respective “Hours Needed by Workgroup Type” cell location in the Hours Needed worksheet and dividing it by the hours caseworkers have available for casework, dependent on the hours caseworkers are to work each week as reported in the Resource Summary worksheet. Sum of the FTEs needed for each unit. Calculated Workgroup Time The analytic tool contains the times needed to complete required and other tasks and formulas which sum the total time needed to complete all the tasks for each workgroup type. The gold highlighted cells may be changed as policies or practice standards change, amending the time it takes to complete a task, adding new tasks and their respective times, or deleting a task that is no longer completed for all workgroups of a given workgroup type (i.e., required tasks). Once a gold cell has been altered, the salmon colored cells will readjust the sums accordingly, including those in the Hours Needed worksheet. The following details the contents of the worksheet. Column Cell Location Content Required Tasks Definition Tasks Time Standard A1 A2-A13 A14 A15 Title. List of required tasks. Title. Title. Intake Screening B1 Title.
OKAPSWorkloadStudyFINALMinusForms.docx