I need a professional Dashboard Tab creating on an Excel forecasting spreadsheet whereby up to 7 dates can be selected on the dashboard in order to display an average number of calls taken per interval over 24 hours (Intervals). An Erlang Calculator is in place to calculate number of agents required on the "Expected Service Level" tab but I need a shrinkage option to be added to the calculation on the dashboard so we can adjust as necessary. I would like the "Expected Service Level" tab to be the basis of the dashboard but for it to look more professional and clean. I need a light purple/lilac and white colour scheme on the dashboard.
The purpose of the dashboard is to be able to select all Mondays in a month, or all thursdays, or a Monday, Tuesday, Wednesday etc (basically any combination of up to 7 days) which will then average the amount of calls per interval over the selected days, whether 1 day is selected or 7. Off the back of these average numbers in the intervals, I need the Erlang calculator to calculate the projected number of agents needed based on that data.
The Erlang Calculator options must be present so we can adjust our service levels and Average Handling times etc to manipulate the data to make it accurate.
The Excel file will represent 1 month's data, available on "Sheet1" so needs to also be easy to drag and drop data into Sheet1 when creating future months going forward.
13 фрилансеров(-а) в среднем готовы выполнить эту работу за £28/час
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.