Find Jobs
Hire Freelancers

Establish formula to calculate the email complaint response time and the resolution time based on the defined working hours

$10-30 USD

Terminado
Publicado hace 4 meses

$10-30 USD

Pagado a la entrega
I am seeking an Excel expert who can assist in creating a formula for the following tasks: 1) Calculate email response time and resolution time, taking into account the specified working hours: - Monday to Friday (8 am - 8 pm) - Saturday (8 am - 4 pm) - Non-working days will be excluded (Sunday and Public Holidays - based on a list of Public Holidays which will be provided). 2) Based on the calculations in item 1, determine the Performance % against the Service Level Agreement (SLA) for: - Response Time: Within 1 working day - Resolution Time: Within 10 working days Sample data will be provided later.
ID del proyecto: 37673125

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 4 meses

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
ADVANCE EXCEL , more 7 years experience Sir, am an EXCEL Formula with advanced skills. About me I am a CERTIFIED Excel VBA Programming , CERTIFIED Business Analytics and Professional Certificate in Excel Accountant i have a MASTER of BUSINESS ADMINISRATION Watch videos of previous jobs (automatic EXCEL _VBA) in MY YOUTUBE CHANNEL ([login to view URL])
$25 USD en 1 día
5,0 (17 comentarios)
4,4
4,4
18 freelancers están ofertando un promedio de $21 USD por este trabajo
Avatar del usuario
As an Excel expert with a substantial 7-year experience, I strongly believe that I am precisely the freelancer you need for your project. I have a deep understanding of advanced formulas, VBA and macros, which are exceptionally valuable in processing complex data like the one in question. Moreover, I have substantial experience creating dynamic dashboards that cater to data analysis such as your request to calculate email response and resolution times. To properly enforce working hours and consider non-working days with a tangible sample of public holidays – my knowledge on macros and VBA will address this neatly. I can assure you of an optimized formula built just the way you want it. Professionally, I've had an extensive experience using Excel for dynamic data analysis, substantial calculations - all backed up with my PowerBI and Tableau expertise. All these experiences combined explicitly put me in the favourited position for executing your task efficaciously. By clicking on the "Hire Me" blue button and granting me this opportunity, you'll be making an informed choice for a diligent, skilled pair of hands. Let's make this project a success!
$25 USD en 1 día
5,0 (41 comentarios)
5,6
5,6
Avatar del usuario
As an Electrical Engineer, I have been extensively using Excel for a wide array of tasks and data manipulations - from analyzing electrical signals to creating financial models and forecasting. I'm certain these skills can be perfectly employed to establish the required formulas for your project. Having worked in the realm of data processing within intricate time constraints, I'm no stranger to devising robust calculations, especially given specific parameters as in your project description. My experience with Signal Processing in MATLAB and Python goes hand in hand with handling and manipulating datasets. Additionally, my proficiency in Machine Learning algorithms raises my capabilities beyond just calculation. I can implement sophisticated methods to improve efficiency and accuracy of your formulas – ensuring compliance with your Service Level Agreement (SLA). My broad skillset extends beyond Excel expertise allowing me to leverage other software like Matlab or Python if your project requires more advanced analysis, such as prediction modeling or statistical analysis. This also allows me to consider a range of future applications for this project, offering creative solutions that take into account potential future SLAs you may have. In a nutshell, I feel confident that my comprehensive skillset and experience as an Electrical Engineer and Data Scientist will be suited perfectly to create the precise formulas needed for your task
$20 USD en 7 días
5,0 (13 comentarios)
4,3
4,3
Avatar del usuario
Hello There, I can do this fast. This a piece of cake to me. Lets chat to discuss deadline You can visit my Profile https://www.freelancer.com/u/ExpertSoul
$30 USD en 1 día
5,0 (6 comentarios)
4,0
4,0
Avatar del usuario
Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev
$20 USD en 7 días
5,0 (6 comentarios)
3,7
3,7
Avatar del usuario
Hi As Excel Expert I can assure you I will perform this task with honesty and accuracy. This is simple task which needs few minutes . Text me and we can discuss it
$15 USD en 2 días
5,0 (10 comentarios)
3,6
3,6
Avatar del usuario
I have prepared many calculators purely in Ms Excel and my experience of working in Excel is more than 8 years. With the help of further understanding I am sure that i will be able to create the formula as desired.
$20 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can assure you your work in a very short span of time yet very to the point work. I have a good amount of experience in writing excel and you wont regret associating your business with me. I promise to deliver the best only. Thank you.
$20 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i am best excel works i am best excel works i am best excel works i am best excel works i am best excel works
$20 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello Thanks for sharing your project requirements with us. I'm interested in your work and will gladly help you. I possess diverse skills in Microsoft Excel, enabling me to handle complex data tasks efficiently. As an Excel expert, I have extensive knowledge of the software's advanced features and functionalities. Below are some of my skills; • Data Entry • Data Cleaning • Linear Programming/Optimization • Sensitivity Analysis • Data Analysis • VBA/Macros • Excel Functions and Formulas; Sum if, LOOKUP, VLOOKUP, index, match, etc. • Conditional Formatting • Data Entry and Cleaning • Pivot Tables, Charts, and Graphs • Google Spreadsheets • Break-even analysis • File Conversion; pdf, CSV, etc., to Excel In addition to my technical skills, I possess strong analytical thinking and problem-solving capabilities. I can leverage my Excel expertise to develop innovative solutions, optimize processes, and drive decision-making. My well-rounded skill set and passion for data analysis make me a valuable asset in any project. I'm ready and willing to start working on your project. Thank you!
$30 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello sir/mam I am Pavan Kumar I required your all requirement I am fully expert in data entry, excel,VBA, typing other more than two year experience I can replace your with another picture and that will Look 100% real I will give work best on your time and budget Until you get fully Satisfied with work I am new freelancer but not for this job Trust me Sir/mam just give me one chance to show my talent Thanks waiting for response…
$10 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Experienced Virtual Relationship Manager with 3 years in Excel and a background in customer support. Proficient in email communication, I assure accurate and timely completion of tasks. Ready to leverage my skills to deliver the best results for your project. Let's collaborate for success.
$16 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello! Sir i am a data entry operator in excel, ms word, ms office. And i am a typing expert. I am able for do your work.
$15 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Offering efficient and accurate data entry services to streamline your project. As a dedicated freelancer, I ensure meticulous data handling, timely delivery, and a commitment to quality results.
$17 USD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de MALAYSIA
Kuala Lumpur, Malaysia
0,0
0
Forma de pago verificada
Miembro desde ene 20, 2024

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.