Ολοκληρωμένο

Create an Excel worksheet with formulas to calculate commission and sales

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]

Ικανότητες: Excel, Excel Macros

Περισσότερα: tiered commission calculator excel, how to calculate commission using excel, excel formula for tiered rates, excel commission tracker, sales incentive calculation excel format, build a formula to add the commissions amount (e5) to the commissions amount times the rate (f5*e5), how to calculate sales commission formula, build a formula to add the commissions amount to the commissions amount times the rate, calculate projected sales formula excel, calculate projected sales excel, excel condition calculate commission, excel calculate projected sales, create stand alone application excel worksheet, formula calculate projected sales excel, create excel custom worksheet, create excel formulas payroll time lunch time, sales tracking excel worksheet, excel worksheet tracking sales activities, create pdf worksheet macro excel 2010, excel worksheet calculate comp time

Σχετικά με τον Εργοδότη:
( 28 αξιολογήσεις ) Temple city, United States

Ταυτότητα Εργασίας: #17704475

Ανατέθηκε στον:

Capitan0Trueno

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 Περισσότερα

$50 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0

19 freelancers κάνουν προσφορές κατά μέσο όρο $85 για αυτή τη δουλειά

Webxpert4u

Hello, I am ready to write code in excel with formulas to calculate commission and sales. Watching video....Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net fo Περισσότερα

$155 USD σε 1 μέρα
(174 Αξιολογήσεις)
7.4
prameswara

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 σε 3 μέρες
(306 Αξιολογήσεις)
6.9
Mfaisalshahzad00

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% satis Περισσότερα

$150 USD σε 3 μέρες
(18 Αξιολογήσεις)
3.9
Diliphero

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 backg Περισσότερα

$200 USD σε 7 μέρες
(11 Αξιολογήσεις)
3.9
haleem0786

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please review my profile and inbox [login to view URL]

$150 USD σε 3 μέρες
(14 Αξιολογήσεις)
3.6
SousaTranslation

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 sheet Περισσότερα

$66 USD σε 2 μέρες
(13 Αξιολογήσεις)
3.7
$30 USD σε 3 μέρες
(5 Αξιολογήσεις)
3.2
salimmurshed1111

expert in google sheet and excel, can make any type of calculator for you

$40 USD σε 2 μέρες
(2 Αξιολογήσεις)
1.7
joshual21

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 p Περισσότερα

$55 USD σε 1 μέρα
(1 Κριτική)
1.2
AymunSaif

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 σε 1 μέρα
(3 Αξιολογήσεις)
1.3
abugosia

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 thes Περισσότερα

$222 USD σε 8 μέρες
(0 Αξιολογήσεις)
0.0
haiderf83

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 σε 5 μέρες
(0 Αξιολογήσεις)
0.0
$30 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
Justivan53

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 Regard Περισσότερα

$45 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
UrosKrstich

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 Περισσότερα

$100 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
$45 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
ryanparrinello

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 o Περισσότερα

$83 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
miketan08

let me do it i am excel expert let me know time and yiur budget please

$30 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0