Plan Data

A new plan displays the long term forecast data when creating the plan.

  • the long-term forecast data for a single WEM Skill

  • Click the WEM Skill icon  and select a WEM Skill from the drop-down list to display plan data for an individual WEM Skill in the plan.

When creating a plan, you select the Scheduling Units for the plan. You can see and change the staffing parameters at the Scheduling Unit level. The Scheduling Unit to WEM Skill staffing distribution updates the WEM Skills associated with the Scheduling Units.

If you add new hire classes to the plan, the plan also accounts for the time new agents need to become fully productive.

Plan Page Item

Description

Refer To

Scheduling Unit Distribution Add or change the staffing distribution percent for each Scheduling Unit to WEM Skill association in the plan. Add or Change Scheduling Unit to WEM Skill Staffing Distribution

Options (Icon of three vertical black dots)

Export the plan as CSV file, export the plan as an Excel file, import plan data from an Excel file, change plan WEM Skill settings, change plan settings, manage new hire learning curves and classes.

Exporting Plan Data as CSV

Exporting and Importing Plan Data in Excel

Plan WEM Skill Settings

Plan Settings

New Hire Training Class

Save As

Save the plan as a new plan.

Saving a Plan as a New Plan

Save

Save updates to the plan.

Edit Plan Data

WEM Skill

Scheduling Unit

The entity for which you are viewing plan data.

WEM Skill or Scheduling Unit View

Chart (Icon of gray bar chart in a square frame, Icon of gray bar chart with the number 2 in its upper right corner, Icon of gray bar chart with the number 4 in its upper right corner)

Chart the plan data.

Chart Plan Data

Plan data

Plan parameters in a day, week, or month interval.

Plan Spreadsheet Rows and Columns

New Hire Training Class

New Hire Learning Curve Parameters

When you add new hire classes to a plan, the plan calculates how much the new hires contribute in each week of their training. New hire classes contribute to every WEM Skill in the plan. They change these values:

  • Projected Service Level (%), Projected ASA, and Projected Occupancy (%) use AHT (Forecast) and FTE Actual Total, so they reflect agents who are still ramping up.

  • AHT (Forecast) is calculated from AHT (Productive) and AHT (New Hire). FTE Base and FTE Required use it.

  • FTE Required +/- uses FTE Actual Total to show overstaffing and understaffing.

  • FTE Actual Cost uses FTE Total. New hire cost starts on the class start date.

The plan calculates AHT (New Hire), AHT (Forecast), FTE Actual New Hire, FTE Actual Total, FTE New Hire, and FTE Total. You cannot edit these values in the plan. To change them, edit the learning curve or class.

New Hire Learning Curves

New hire learning curves let you plan for the time new agents need to become fully productive. A learning curve describes how new hires perform in each week of their training. You add new hire classes to the Scheduling Units in the plan, and the plan uses them to calculate staffing, handle time, and cost for every WEM Skill in the plan.

You do not need new permissions. With modify permission for the Enhanced Strategic Planner application and the plan entity, you can add, edit, delete, apply, and export learning curves and classes. With view only permission, you can see them but not change them.

How New Hire Learning Curves Work

A learning curve covers a training period of up to 26 weeks, including classroom training and nesting. For each week, you set:

  • AHT: the average handle time, in seconds, that new hires take per volume.

  • % Productive: the percentage of FTE hours that new hires spend handling interactions.

  • Working days: the days new hires handle interactions.

A class is a group of new hires who start on the same date in the same Scheduling Unit. Each class uses one learning curve. A learning curve can have multiple classes.

Productive time is a percentage of the plan FTE hours, even if the training schedule is shorter. It does not reduce the handle time. For example, a class of 20 new hires at 10% productive time in a 40-hour FTE week adds 2 FTE of interaction handling that week. When the class ends, its new hires count as fully productive agents in FTE Actual.

New hire classes affect the plan in these ways:

  • Every class contributes to every WEM Skill in the plan. The plan splits each Scheduling Unit's new hire values across its WEM Skills using the Scheduling Unit to WEM Skill distribution.

  • AHT (Forecast) is calculated from the handle time of productive agents and new hires. When there is no new hire data, it equals AHT (Productive). The plan uses AHT (Forecast) for FTE Base, FTE Required, and the projected service level, ASA, and occupancy.

  • FTE Actual Total is FTE Actual plus the productive share of new hires. The plan uses it for FTE Required +/- and the projections.

  • FTE Total includes every agent, including new hires still in training. The plan uses it for FTE Actual Cost, which starts on the class start date.

Note: If a plan used a new hire training period before, the plan converts it to a learning curve the first time you open the plan.

Add a Learning Curve

To add a learning curve:

  1. On the plan details page, click Options Image of the Options icon, and select New Hire Training Class.

    This option is not available while the plan has unapplied changes.

  2. Click Add Learning Curve.

  3. Enter the Name.

    All WEM Skills in the plan are selected for the learning curve. You cannot clear them.

  4. Enter Class training weeks (enter a whole number from 0 to 26) and click Update Weeks. The default is 4.

  5. For each training week, enter:

    • AHT (seconds): 0.00 to 99999.99, or blank.

    • % Productive: 0.00 to 100.00, or blank.

    % Productive is the percentage of the configured FTE hours spent processing contacts.

    You can enter 0% for weeks spent entirely in training.

  6. Select the Working Days on which new hires process contacts. To use the same days for every week, click Apply to All Weeks.

  7. Click Save.

    The learning curve appears on the New Hire Training Class page. Create the required classes, apply the changes, and save the plan.

Add a New Hire Class

To add a new hire class:

  1. On the New Hire Training Class page, on the learning curve row, click Add Class.

  2. In the Add New Hire Classes window, select one or more Scheduling Units.

  3. In FTE Count, enter the number of new hires.

    Valid values are 0 to 99999.99.

  4. Select a Starting Date or Ending Date.

    The plan calculates the other date using the learning curve’s training weeks.

    • The class must start and end within the plan date range.

    • The starting date must use the plan’s start day of week.

    • Partial training weeks cannot be selected.

    • For a zero-week learning curve, the starting and ending dates are the same.

  5. Click Save.

    The class appears under its learning curve.

  6. Click Apply.

    This applies the learning curves and classes to the plan and recalculates the affected values.

  7. Click Return to Plan.

  8. Click Save or Save As.

    Saving a learning curve or class does not recalculate the plan. Click Apply to recalculate the plan with all your changes. Apply runs in the background and shows its progress.

    Note: Apply does not save the plan. After you apply, click Return to Plan and click Save or Save As. If you close the plan without saving, your applied changes are lost.

    • To undo changes you have not applied, click Discard Changes. The page returns to the last applied values.

    • If you leave the page before you click Apply, a message warns you, and the unapplied changes are discarded.

    • To return to the plan, click Return to Plan

Edit a Learning Curve or Class

To edit a learning curve:

  1. Click the learning curve name.

  2. Change the required weekly AHT, productive percentage, or working days.

  3. Click Save.

  4. Click Apply, then Return to Plan.

  5. Click Save or Save As on the plan page.

    You cannot change the training duration while the learning curve has associated classes. To use a different duration, create another learning curve. If the curve has no classes, its duration can be changed. Changes to an existing curve affect its associated classes when applied.

To edit a class:

  1. Click the class name.

  2. Change FTE Count, Starting Date, or Ending Date.

  3. The Scheduling Unit is read-only.

  4. Click Save.

  5. Click Apply, then Return to Plan.

  6. Click Save or Save As on the plan page.

Delete or Discard New Hire Changes

To delete a class, click its delete icon and confirm. To delete a learning curve, click the learning curve name, click Delete, and confirm. Deleting a learning curve also deletes its associated classes. Review the confirmation before continuing. After deleting, click Apply, return to the plan, and save the plan to retain the changes.

To undo changes made since the last Apply, click Discard Changes. This does not undo changes already applied. To discard applied but unsaved changes, close the plan without saving and reopen it.

Chart New Hire Data

To chart new hire data:

  1. Open the plan, click Scheduling Unit, and select one or more Scheduling Units.

  2. Click the icon for the number of charts you want to see.

  3. Click Show parameters, and select FTE Actual and FTE Actual New Hire.

    The chart shows productive and new hire FTE for each week.

    You cannot drag new hire values in a chart, because the plan calculates them. In the WEM Skill view, you can drag AHT (Productive).

Export New Hire Class Data

On the New Hire Training Class page, select the required Scheduling Units and click Export as CSV. Export as CSV is not available when the plan has no classes.

Exporting Plan Data as CSV

Click Options Icon of three vertical black dots and select Export as CSV to export the plan data you are viewing to a CSV file. The exported data is based on the WEM Skill or Scheduling Unit drop-down selection:

  • one or more Scheduling Units

  • a single WEM Skill

  • All WEM Skills

Click Options Icon of three vertical black dots and select Export Every WEM Skill to export the plan data for each WEM Skill in the plan to a CSV file.

When the WEM Skill distribution calculation method is Use WEM Skill FTE required and there are unapplied changes in the WEM Skill or All WEM Skills plan details page, the export options are not available. When there are unapplied changes in the Scheduling Unit plan details page, the Export Every WEM Skill option is not available.

The new hire training period does not appear in the exported file.

Exporting and Importing Plan Data in Excel

You can export plan data to an Excel workbook to review the data, share it, or change editable parameter values outside Enhanced Strategic Planner. You can then import the updated workbook into the plan without generating another long-term forecast.

The export uses the current WEM Skill or Scheduling Unit selection and date interval. Values in blue text are calculated. If you change a calculated value in Excel, the plan ignores the change when you import the file. The file retains formatting that helps identify the plan values:

  • White background - Editable cell

  • Gray background - Read-only cell

  • Blue text - Calculated value

  • Orange text - Capped value

  • Red text - Negative value

  • Diagonal gray lines - Closed day

  • Italic text - Partial interval

You can import an updated Excel to change editable plan values in bulk. Enhanced Strategic Planner validates the file before applying the values to the grid. Imported values then use the same validation and calculation processes as values entered directly in the plan.

You can export and import plan data only on the WEM Skill and Scheduling Unit pages. You must have modify permission for the plan to import plan data. With view-only permission, you can export plan data, but Import from XLSX is not available.

To export plan data to an Excel file:

  1. Open a plan from the Manage Plans page.

  2. Click WEM Skill or Scheduling Unit and select the WEM Skill, All WEM Skills, or the Scheduling Units you want to export.

  3. Change to the date interval you want to export (month, week, or day).

    The file uses the interval displayed in the plan. You must import the file in the same interval.

  4. If there are unapplied changes on the page, click Apply.

    Export as XLSX is not available while the Scheduling Unit page has unapplied changes. It is also not available on the WEM Skill page when the WEM Skill distribution calculation method is Use WEM Skill FTE required and there are unapplied changes.

  5. Click OptionsImage of Options icon and select Exportas XLSX.

    The Excel file downloads to your computer. The file name identifies the plan, WEM Skill or Scheduling Unit view, entity selection, and interval. The Plan Data worksheet includes:

    • plan name

    • exported by username

    • export date and time

    • date interval

    • view type

    • plan column headings and data

    Edit the plan data in Excel

    You can change editable input values in the exported file. For example, you can adjust forecast contacts received, productive AHT, mean concurrency, service level objectives, or shrinkage where those parameters are editable in the selected view and interval. The same parameter restrictions and valid-value rules apply as when editing the plan directly.

    • Change only cells with white background.

    • Do not change the first row. The import uses it to check the interval and view.

    • Do not add, delete, or move rows or columns. The file must have the same number of rows and columns as the plan page.

    • Keep the data on the first worksheet. The import reads only the first worksheet.

    • Changes to calculated, capped, read-only, locked, or closed-day cells do not override those values in the plan.

    • To clear a value, change it on the plan page instead. The import skips blank cells, so a blank cell does not clear a value.

    • You can rename the file. Save it as an Excel workbook (.xlsx).

To import plan data from Excel:

  1. Open the plan you exported the data from.

  2. Click WEM Skill or Scheduling Unit and select the same WEM Skill, All WEM Skills, or Scheduling Units used when exporting the file.

  3. Change to the same date interval used for the export.

  4. If there are unapplied changes on the page, click Apply. Correct any invalid values in the current grid.

    Import from XLSX is not available while the page has unapplied changes or invalid values.

  5. Click OptionsImage of Options icon and select Import from XLSX.

  6. Select the Excel file and click Open.

    The plan checks the file before it changes any values. If the file type, interval, view, or number of rows and columns does not match, the plan does not import the file.

  7. Review the imported values in the plan.

    Only editable cells are updated. Changes to calculated or read-only cells are ignored, and dependent values are recalculated through the normal plan calculation process.

  8. Correct any highlighted invalid values. Click an invalid cell and review its error information. Enter a valid value for the parameter.

    Until you fix every invalid value, you cannot apply or save the plan.

  9. To undo the import instead, click Reset to last valid plan.

  10. Click Apply.

  11. To save your changes to the plan, click Save or Save As.

    The import does not save the plan. If you close the plan without saving, the imported values are lost.

    After you import the file, the plan recalculates the values that depend on the values you changed. You can keep editing the plan as usual, including copying and pasting and dragging chart points.

    Note: Import the workbook into the same plan, WEM Skill or Scheduling Unit selection, and date interval used for the export. The workbook must have the same number of rows and columns as the current grid.

    For example, a workbook exported in the week interval cannot be imported while the plan displays the month interval.

Saving a Plan as a New Plan

You must have modify permission to a plan to save it as a new plan.

To save a plan as a new plan:

  1. Click Save As on the plan page.

  2. In the Save As window, enter the unique Plan Name.

    This field allows limited special characters (-, (, ), <, >, #, :, ;, blank). The first and last character cannot be a special character.

  3. Click Save.

    This saves the plan settings and plan data. The plan data includes All WEM Skills, WEM Skill, Scheduling Unit, and Scheduling Unit to WEM Skill distribution data.

    Large plans that take a while to save appear in gray text at the top of the Manage Plans page with PENDING in the Modified Date field. For these plans, refresh the Manage Plans page until the plan is no longer pending.

    If the Modified Date of the plan is FAILED, the plan could not be saved. If saving the plan continues to fail, contact your system administrator.

  4. Click on the new plan to open it.

WEM Skill or Scheduling Unit View

The WEM Skill view is the default view when opening a plan.

To view or edit plan data for a single WEM Skill or all WEM Skills in the plan, click WEM Skill. The drop-down list contains:

  • All WEM Skills

    See plan data totals for all WEM Skills in the plan. This option does not appear for a single WEM Skill plans. This is the default selection.

    The WEM Skills are in ascending order.

To view or edit plan data for one or more Scheduling Units in the plan, click Scheduling Unit. The drop-down list contains the plan Scheduling Units.. The Scheduling Units are in ascending order. The default selection is the first Scheduling Unit in the list. Your Scheduling Unit selections for up to the last 10 plans you open will be your new defaults, until you change them or clear your browser's cache.

Plan Spreadsheet Rows and Columns

In the plan spreadsheet:

  • Rows with a gray background are read-only.

  • A value in black text is a user-entered value. A value in blue text is a calculated value.

  • When you hover over a parameter name or column header (other than the date header), a tooltip displays the full name.

  • If the plan forecast was an imported forecast, the dates missing from the forecast appear with blank data.

In the Scheduling Unit view:

  • Plan rollup group heading, under the grid column headers, displays the total of these FTE staffing parameters for all Scheduling Units in the plan:

    • FTE Required

    • FTE Actual Total

    • FTE Required +/-

    • Attrition (%)

    • Attrition (absolute)

    • FTE New Hire

    • FTE Total

  • Under the plan rollup is the data for the selected Scheduling Units. You can collapse or expand this data. If a plan used a new hire training period before, the plan converts it to a learning curve the first time you open the plan.

For details on editing the parameters you can change, see Edit Plan Data.