Format of the Import File

The file from which you import data needs to have its values separated by commas. The file extension can be either .csv or .txt.

The file must conform to the format:

Work queue name, M-D-YYYY, Volume, AHT

For example:

BillingQueue, 1-2-2018, 521, 242

The date format MM/DD/YYYY is also supported for the import format.

Two examples are shown below, one for a single work queue, the second for multiple work queues.

Single Work Queue

q1,09-02-2017,30000,180

q1,10-02-2017,40000,180

q1,11-02-2017,30000,180

q1,12-02-2017,40000,180

q1,01-03-2018,30000,180

q1,02-03-2018,40000,180

q1,03-03-2018,30000,180

Multiple Work Queues

q1,09-02-2017,30000,180

q1,10-02-2017,40000,180

q1,11-02-2017,30000,180

q1,12-02-2017,40000,180

q1,01-03-2018,30000,180

q1,02-03-2018,40000,180

q1,03-03-2018,30000,180

q2,03-02-2018,3000,170

q2,04-02-2018,4000,170

q2,05-02-2018,3000,170

q2,06-02-2018,4000,170

q2,07-03-2018,3000,170

q2,08-03-2018,4000,170

q2,09-03-2018,3000,170

Intra-week distribution information

For intra-week distribution information, you define dates that are single days and not months.

For example:

q1,09-01-2017,30000,180

q1,09-08-2017,15000,90

q1,10-02-2017,40000,180

q1,11-02-2017,30000,180

q1,12-02-2017,40000,180

q1,01-03-2018,30000,180

q1,02-03-2018,40000,180

Strategic Planner averages the volumes for each day. All Sundays in the week are averaged, then all Mondays, and so on. AHT is calculated as a weighted average of the volume.