Find Jobs
Hire Freelancers

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

£10-15 GBP / hour

Tamamlandı
İlan edilme: 5 yıldan fazla önce

£10-15 GBP / hour

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.
Proje No: 18206343

Proje hakkında

13 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 5 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
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 dynamic dashboards and Reports. I have completed many similar projects before, you can check some of my previous works here. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] I am ready to start your project immediately, please send me a message to discuss further. Thanks
£15 GBP 40 gün içinde
4,8 (52 değerlendirme)
5,6
5,6
13 freelancers are bidding on average £28 GBP/ saat for this job
Kullanıcı Avatarı
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 for Call Centre Forecasting - Erlang Calc already included - Need shrinkage option added. I can assure you the quality job. I have good experience in Data Processing, Excel. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
£20 GBP 40 gün içinde
4,9 (288 değerlendirme)
7,7
7,7
Kullanıcı Avatarı
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 successful similar projects of building dashboards. Look forward to hearing from you. Regards, Vlad
£25 GBP 40 gün içinde
4,9 (66 değerlendirme)
7,4
7,4
Kullanıcı Avatarı
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 (user-forms), drop-down boxes, generator reports, and charts. I prepare proposals for investors (including pitch decks, business plans, due diligence, financial modules like feasibility studies, and financial projections with dynamic scenarios). I prepare dynamic & designed reports for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts. With these skills, I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner.
£18 GBP 40 gün içinde
4,9 (70 değerlendirme)
6,8
6,8
Kullanıcı Avatarı
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 Rahila to bid on your project. I believe we can help you with your Finish an Excel Dashboard for Call Centre Forecasting because I do have a team and are mostly my cousins/close friends that is why we have been working as a good team with trust. My business is to make your business effective, profitable & efficient. We are able to have a sound understanding of our Clients’ operations and their corporate goals, and we continually bring knowledge and new ideas to them. I am a pioneer in the outsourcing/call center industry in the Philippines, and as such, have a deep understanding of world-class customer service, prompt delivery of jobs & the importance of client satisfaction of our work. The team is led by me–a forward-thinking, resourceful professional with more than 13 yrs of experience in Sales, Marketing & Customer Service; who understands the power of good relationships with customers/clients, and that this is the foundation of a successful business & attracts repeat sales. We are highly-skilled, well-educated, English-speaking, smart professionals ready to deliver results for you. Been working on different projects since 2014, with most of my clients are from here (you can check the good reviews we garner on my profile). Willing to discuss.
£15 GBP 40 gün içinde
5,0 (27 değerlendirme)
6,5
6,5
Kullanıcı Avatarı
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 agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
£20 GBP 40 gün içinde
4,8 (97 değerlendirme)
6,9
6,9
Kullanıcı Avatarı
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 regards
£15 GBP 40 gün içinde
5,0 (211 değerlendirme)
6,8
6,8
Kullanıcı Avatarı
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 you’re looking for? Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?
£13 GBP 40 gün içinde
4,8 (37 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
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. We can have a call and discuss in detail what is required and how we can address them properly. Please contact
£12 GBP 40 gün içinde
4,7 (28 değerlendirme)
5,1
5,1
Kullanıcı Avatarı
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 40 gün içinde
5,0 (18 değerlendirme)
4,0
4,0
Kullanıcı Avatarı
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 experience in Data Processing, Excel. I would highly pleased if you consider my particulars yours obediently. So I hope your kind response. Regards Saidur Rahman Khan
£10 GBP 40 gün içinde
5,0 (3 değerlendirme)
1,1
1,1

Müşteri hakkında

   UNITED KINGDOM bayrağı
Poole, United Kingdom
0,0
0
Ödeme yöntemi onaylandı
Kas 6, 2018 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.