Discuss (0)

Print

RSS

Products » Call Center Calculator » Here

Importing Excel data in L3C

Lokad Call Center Calculator (L3C) can import inbound call logs and staff level logs from a regular Excel spreadsheet (Excel 97-2003, 2007 or above). In order to do that, the data in the spreadsheet must follow a specific layout. This guide explains how to organize data in the Excel spreadsheet for a later import in L3C.

Download: SampleHotlineData.xls
(illustrative spreadsheet)

Logs sheet

Your Excel workbook must contain a sheet named Logs. This sheet would contain both inbound call logs and staff level logs. In this Logs sheet, 4 columns are expected:

• QueueName: The name of queue associated to the record.
• CallTime: The time of the record (date-time is expected).
• CallCount: The number of incoming calls (number is expected).
• AgentCount: The number of agents (number is expected).
  

The three first columns are required, otherwise L3C won't be able to forecast the future inbound activity. Yet, AgentCounts are supported for convenience. If the historical staff level data is not available, then you can put zeroes in the AgentCount column. It won't negatively impact your forecasts.

It must be noted that you don't need to perform any particular data preparation for those records. In particular,

• records can be missing (will be replaced by zeroes).
• records do not need to match specific time constraints (no need to equi-space the records).
  

Once you have setup your logs, you can save your Excel file.

Getting the data into L3C

Open L3C, click on File » New. Define your report settings. Choose Excel as data adapter type. Browse and select the Excel file that you have just prepared. Finish the wizard, and click on Refresh.