Завершено

Finish an Excel Dashboard for Call Centre Forecasting - Erlang Calc already included - Need shrinkage option added

Hi,

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.

Квалификация: Обработка данных, Excel

Показать больше international standard typing call centre, can find project call centre, free excel dashboard software, free excel dashboard, call centre bid, vici call centre software, call centre animations, process international call centre, commission based call center call centre india philippines, custom excel dashboard developers, call centre quality assurance feedback form copy, capturing individual call centre stats excel, excel template call centre, call centre quality excel, call centre excel sheetstemplates, call centre productivity tracker excel, call centre reports excel, quality monitoring call centre form excel

О работодателе:
( 0 отзыв(-а, -ов) ) Poole, United Kingdom

ID проекта: #18206343

Поручен:

aimefx

Hi, I am expert in Excel, Access VBA, MySQL, Google Sheet and Power BI. I can database and can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time dyna Больше

£15 GBP / час
(52 отзывов(-а))
5.6

13 фрилансеров(-а) в среднем готовы выполнить эту работу за £28/час

Webxpert4u

Hello, I am ready to update Excel Dashboard for Call Center Forecasting by adding shrinkage option. I need to discuss in details before starting. ALSO I prefer to do it by a fixed price instated of hourly. Highly ex Больше

£175 GBP / час
(213 отзывов(-а))
7.8
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Finish an Excel Dashboard for Call Centre Forecasting - Erlang Calc already included - Need shrinkage option added Finish an Excel Dashboard fo Больше

£20 GBP / час
(288 отзывов(-а))
7.7
Vlzinch

Hello, First of all, I need to say that my rate is slightly higher than your estimates, but I deliver quality service really fast. I will create a required professional and clean dashboard. I have had dozens of succ Больше

£25 GBP / час
(66 отзывов(-а))
7.4
dgled

I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's ( Больше

£18 GBP / час
(70 отзывов(-а))
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Больше

£15 GBP / час
(211 отзывов(-а))
6.8
jkaranm

Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Rahi Больше

£15 GBP / час
(27 отзывов(-а))
6.5
zekovicm

Hi there,I am Miljan,excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agr Больше

£20 GBP / час
(97 отзывов(-а))
6.9
SShtv

I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data and co Больше

£15 GBP / час
(65 отзывов(-а))
5.7
dvcontact

Hi, If you are looking for an Expert in Data Processing, Excel to create Excel dashboard that will calculate the average calls per selected interval, I am the most suitable candidate. Why am I so sure I’m the person y Больше

£13 GBP / час
(37 отзывов(-а))
5.8
khurram1984

Hi. We are finance experts since 2009 and have prepared numerous financial models, projections, reports etc. We have advanced level proficiency in excel and will make sure your sheet is automatic as much as possible. Больше

£12 GBP / час
(28 отзывов(-а))
5.1
dalsaniyasonu123

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.

£13 GBP / час
(18 отзывов(-а))
4.0
akmsrkfl

Hello, I am Saidur Rahman Khan. I am very much interested in your project. I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. I have a lot of e Больше

£10 GBP / час
(3 отзывов(-а))
1.1