Find Jobs
Hire Freelancers

Create an Excel worksheet with formulas to calculate commission and sales

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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]
Project ID: 17704475

About the project

19 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
19 freelancers are bidding on average $85 USD for this job
User Avatar
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 in 3 days
4.9 (306 reviews)
6.9
6.9
User Avatar
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 in 3 days
5.0 (18 reviews)
3.9
3.9
User Avatar
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 in 7 days
5.0 (11 reviews)
3.9
3.9
User Avatar
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 in 2 days
5.0 (13 reviews)
3.7
3.7
User Avatar
expert in google sheet and excel, can make any type of calculator for you
$40 USD in 2 days
5.0 (2 reviews)
1.7
1.7
User Avatar
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 in 1 day
5.0 (3 reviews)
1.3
1.3
User Avatar
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 in 1 day
5.0 (1 review)
1.2
1.2
User Avatar
let me do it i am excel expert let me know time and yiur budget please
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Temple city, United States
5.0
28
Payment method verified
Member since May 20, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.