Kapalı

Excel Spreadsheet build - Simple Partner Commission Calcuation -- 2

We need an excel spreadsheet that calculates the potential commission on projects. It needs to have drop down selections, easy to use, visually appealing and have a macro to print into pdf for the final calculation.

It also needs to capture the customer name, opportunity name/ID and salesperson.

We have partnered with a telco that offers commissions based on engagements.

There are 3 tiers to partnership, an upfront payment if it's a renewal or new business and different pay percentages based on those tiers of partnership.

The other variable is the contract length (5 options)

There are variables in the % of what product is being proposed as part of a solution (there are 12 product categories).

The other function this calculator needs to provide is a breakdown of payments over the term as there is a combination of once off upfront, and monthly recurring. This needs to be calculated over the term with a visual representation on a graph that can also be a macro to click the button and print to PDF in landscape for this item.

One of the pages needs to be easily modified (if the partner was to change the % paid on a product as an example) or SPIFF - there needs to be a field available for manual entry. The data for the 'backend' of the spreadsheet needs to be easily accessible, readable, but have the ability to lock down and hide with password for this page only.

Beceriler: Visual Basic, Veri İşleme, Veri Girişi, Excel, Excel VBA

Daha fazlasını gör: formula to calculate commission rate in excel, commission sheet template, tiered commission excel template, how to calculate sales commission formula, how to calculate commission in excel using vlookup, formula to calculate commission in excel 2010, sales commission tracker template for excel, sliding scale commission excel template, can build front end excel spreadsheet, draw commission excel spreadsheet, excel spreadsheet commission report, simple math calculations calculator excel spreadsheet, build widget excel spreadsheet, simple excel spreadsheet, simple time management excel spreadsheet, simple warehouse excel spreadsheet, build excel spreadsheet, simple excel spreadsheet margin calculator, simple data collection excel spreadsheet, simple quotation excel spreadsheet

İşveren Hakkında:
( 2 değerlendirme ) Beeliar, Australia

Proje NO: #27566207

Bu iş için 56 freelancer ortalamada $39 teklif veriyor

schoudhary1553

Hi, Greetings! ✅checked your project details: Excel Spreadsheet build - Simple Partner Commission Calcuation ✅Completed Time: In project deadline We have worked on 650 + Projects. I have 6 + years of the experien Daha Fazla

$100 USD in 3 gün içinde
(421 Değerlendirme)
8.2
(291 Değerlendirme)
7.7
(294 Değerlendirme)
7.2
(64 Değerlendirme)
6.3
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.

$50 USD in 3 gün içinde
(101 Değerlendirme)
6.2
(110 Değerlendirme)
5.9
daniyal3214

I can perfectly develop such a dynamic and analytical Excel spreadsheet. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (inclu Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(88 Değerlendirme)
5.9
(32 Değerlendirme)
5.3
nelumindralal

Hello, I went thru the description and this can be started by NOW Send me all the details then i will start it I look forward to haring from you Thanks Regards Thushara

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(34 Değerlendirme)
4.9
paulodayto08

Hi, Good Day! I can help you building Automated tool using excel and vba macro. Most of client need an excel tool that has userforms to make more user friendly and organize. I can help you build that tool. Please messa Daha Fazla

$30 USD in 2 gün içinde
(53 Değerlendirme)
4.9
merinsinha

Will do now. Hi i am an certified excel vba Expert. For Professional works -Hire me. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can p Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(47 Değerlendirme)
4.4
(16 Değerlendirme)
4.5
maguirrer

Hello, I can help you to create the file to get the commission, please send me a message with more details and if it's possible with a file attached as an example, so I can check it and will start working on it inmedia Daha Fazla

$38 USD in 2 gün içinde
(38 Değerlendirme)
4.3
ShakeelASESE

Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial models, Excel Flow Chart, Excel C Daha Fazla

$20 USD in 2 gün içinde
(3 Değerlendirme)
4.3
Monirulop

Dear Client, Speed & Professionalism are my skills. I saw your description & i'm pretty sure that i can pull of it. I am ready to start now within 10% discount. Let's discuss in chat. Best Regards Monirul

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)
3.5
Mohilm007

--------I CAN START RIGHT AWAY 100% ACCURACY-------------------------------- Hello, I have read your project details . I can Automated Data Analysis via Excel spreadsheet by maintaining 100% accuracy of your data abs Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
3.4
RiWong88

Dear Sir, I am an experienced senior audit accountant that dabbled in data analyst for years during my career. I am fast and precise with my work with a great knowledge with Microsoft Excel. I will complete all tasks g Daha Fazla

$35 USD in 3 gün içinde
(2 Değerlendirme)
2.4
sdmidhath

Hi, I can help you build visually appealing dashboard. As I gone through your description I understood that you are looking for some dynamic calculation based on certain criteria and a ability to print (PDF format). I Daha Fazla

$50 USD in 3 gün içinde
(2 Değerlendirme)
1.6
prateeksood99

Greetings, I have read your project description. I have team of members experts in such [login to view URL] me message to share details.I am waiting for your response. Regards Prateek

$50 USD in 2 gün içinde
(2 Değerlendirme)
1.6
ekirafallorina

Hi there, Greetings! I’ve gone through your requirement. I am very much interested to work with you on this project.

$35 USD in 7 gün içinde
(2 Değerlendirme)
1.4