Find Jobs
Hire Freelancers

Create an Excel worksheet with formulas to calculate commission and sales

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
The project here is to SET UP FORMULAS in an Excel worksheet to calculate commission Total and Sales Total. The data structure is fixed but the volume changes every time. The formulas must be able to calculate the cumulative commissions and sales for each individual that appears under Staff Name. Rules for each type of staff are different so the formulas must be configured separately. A youtube video has been included to explain the goals and examples, which have been also included in the attached Excel file as well as some sample data. If macros must be enabled to achieve the goals, please communicate to me AHEAD OF TIME! Project winner is welcome to format the non-data area to make the presentation better! [login to view URL]
ID del proyecto: 17704475

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 6 años

¿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
Aeronautical engineer and MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
$50 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
19 freelancers están ofertando un promedio de $85 USD por este trabajo
Avatar del usuario
Hello Sir i already see your explanation on youtube and i can do build your calculator like u need Sir please give me this job and im able to start working today Thank You Sincerely Galih AP
$100 USD en 3 días
4,9 (306 comentarios)
6,9
6,9
Avatar del usuario
Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. I am regularly doing following kind of tasks: The project here is to SET UP FORMULAS in an Excel worksheet to calculate commission Total and Sales Total. Thanks.
$150 USD en 3 días
5,0 (18 comentarios)
3,9
3,9
Avatar del usuario
Greetings, I am professionally qualified Business & Financial Consultant from Sri Lanka with a degree in Management & Finance. I am very proficient in VBA, Macros and Excel dashboards. My business and financial background is also a perfect fit for your work. Please come to chat to discuss further. I have the experience in supporting many businesses in supporting many activities with o% errors. I can do this work satisfying your business requirements. Look forward to discussing with you of the opportunity further. Kind regards, Dilip.
$200 USD en 7 días
5,0 (11 comentarios)
3,9
3,9
Avatar del usuario
Hello I am an Excel expert with a lot of experience creating spreadsheet for advanced calculations through formulas. I have created spreadsheets for both companies and private use, mainly real estate and payment sheets, which were similar to what you want created, and so far all of my customers have been very satisfied. Depending on all the features I will add and from what I've seen in the YouTube video it might take me two days but it will probably take me a lot less than the day. If you are interested or want to discuss anything else related to the project or my qualifications message me.
$66 USD en 2 días
5,0 (13 comentarios)
3,7
3,7
Avatar del usuario
expert in google sheet and excel, can make any type of calculator for you
$40 USD en 2 días
5,0 (2 comentarios)
1,7
1,7
Avatar del usuario
Hi concerned I can develop your excel sheet as I have relevant experience and can get the work done quickly. All payments will be when you will satisfy from my work. Hope to hear from you. Thanks!
$41 USD en 1 día
5,0 (3 comentarios)
1,3
1,3
Avatar del usuario
Hello, I am confident that I can assist with your requirements. I am a professional business consultant looking to expand my client base through Freelancer.com. I have a vast level of experience over 20 years as a professional. I am a diligent worker and I never miss a deadline. You will find me easy to communicate with, and I value my ability to provide an efficient and accurate service for my clients. Regarding this task in particular, I have been specialising in complex Excel projects throughout my career, and I am sure I can assist with the creation of your worksheet formulas to calculate commission and sales. I am available for a discussion anytime, and I look forward to hearing from you in due course. Kind Regards, Josh Luttrell
$55 USD en 1 día
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
let me do it i am excel expert let me know time and yiur budget please
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I'm Abu Gosia. I'm interesting your project very well. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
$222 USD en 8 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hello. i am Farhan Haidar i do this work . sir you can trust on me and give me this project i have complete this project in 4 days so you share the detail i also do this project mvdl e-commerce pvt ltd in delhi
$31 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi One way is to use macro for the project, this solution would be faster and more stable. Although it can be solve with formulas too. Also if you choose macro the Staff columns can be also flexible. Best Regards Ivan
$45 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
This is an easy task. To properly build a template I'd need the following information: 1) Would you prefer Macro with VBA or just formulas? (First option is more recommendable for larger quantities) 2) Would you like to have a control over default options? (I.e. for template to be user-friendly so that you can change the individual commission or add new employees on your own) 3) Would you like extra safety features on template? (i.e. to have a warning sign when illegal entry is made or when something is out of right place. This might prolong time needed for making the template)
$100 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, Thank you for the opportunity to bid this job. I will require more information on what you require out of this spreadsheet, but as for my background - I currently work as a Plant Manager and have designed all of the inventory management, process flow, and calculation databases for my current employer via Excel. If given this opportunity and necessary information about your job, I will return an exception workbook for your use.
$83 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Temple city, United States
5,0
28
Forma de pago verificada
Miembro desde may 20, 2009

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.