Find Jobs
Hire Freelancers

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

£10-15 GBP / hour

已完成
已发布超过 5 年前

£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.
项目 ID: 18206343

关于此项目

13提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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天之内
4.8 (52条评论)
5.6
5.6
13威客以平均价£28 GBP/小时来参与此工作竞价
用户头像
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天之内
4.9 (288条评论)
7.7
7.7
用户头像
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天之内
4.9 (66条评论)
7.4
7.4
用户头像
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天之内
4.9 (70条评论)
6.8
6.8
用户头像
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天之内
5.0 (27条评论)
6.5
6.5
用户头像
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天之内
4.8 (97条评论)
6.9
6.9
用户头像
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天之内
5.0 (211条评论)
6.8
6.8
用户头像
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天之内
4.8 (37条评论)
5.8
5.8
用户头像
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天之内
4.7 (28条评论)
5.1
5.1
用户头像
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天之内
5.0 (18条评论)
4.0
4.0
用户头像
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天之内
5.0 (3条评论)
1.1
1.1

关于客户

UNITED KINGDOM的国旗
Poole, United Kingdom
0.0
0
付款方式已验证
会员自11月 6, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。