Navigation:  Performing calculations >

Importing call volumes

Print this Topic Previous pageReturn to chapter overviewNext page

Rather than manually entering call volumes, you can import them from other sources.  This is achieved using the Windows clipboard (copy and paste) facility.  Call volumes can be imported from text files or Excel workbooks.

 

Importing from an Excel worksheet

 

For data to be imported from an Excel worksheet, the call volumes must be entered in separate cells.  The cells must be adjacent, but can be orientated either vertically or horizontally.  In other words, the data cells can either occupy one row (and work from left to right) or occupy one column (and work from top to bottom).

 

In Excel, copy the cells to the Windows clipboard by selecting the cells (not the entire row or column) and choosing Edit | Copy from Excel's main menu.  Then, switch to Ansapoint and click on the time interval in the Daily Calls Table where the importing should start.  Select Days | Paste Calls Data from the main menu.  After the importing has been completed, an errors will be displayed in a message box.  Errors will occur if the data does not contain numbers or there are too many entries for the current day.

 

Importing from a text file

 

For data to be imported from a text file, the call volumes must be entered on separate lines, each line ending with a carriage return and with no other data on each line.  Alternatively, the volumes may be entered on one single line, which each entry separated by a tab character.

 

In a text editor, copy the call volume text to the Windows clipboard by selecting the text and choosing Edit | Copy from text editor's main menu.  Then, switch to Ansapoint and click on the time interval in the Daily Calls Table where the importing should start.  Select Days | Paste Calls Data from the main menu.  After the importing has been completed, an errors will be displayed in a message box.  Errors will occur if the data does not contain numbers or there are too many entries for the current day.

 

See also

 

Preparing the project

Manually entering call volumes

The results