Lukket

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.

Evner: Visual Basic, Databehandling, Dataindførsel, Excel, Excel VBA

Se mere: 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

Om arbejdsgiveren:
( 2 bedømmelser ) Beeliar, Australia

Projekt ID: #27566207

56 freelancere byder i gennemsnit $39 på dette job

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 Flere

$100 USD in 3 dage
(421 bedømmelser)
8.2
(291 bedømmelser)
7.7
(294 bedømmelser)
7.2
(64 bedømmelser)
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 dage
(101 bedømmelser)
6.2
(110 bedømmelser)
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 Flere

$35 USD på 1 dag
(88 bedømmelser)
5.9
(32 bedømmelser)
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

$100 USD på 1 dag
(34 bedømmelser)
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 Flere

$30 USD in 2 dage
(53 bedømmelser)
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 Flere

$30 USD på 1 dag
(47 bedømmelser)
4.4
(16 bedømmelser)
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 Flere

$38 USD in 2 dage
(38 bedømmelser)
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 Flere

$20 USD in 2 dage
(3 bedømmelser)
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

$30 USD på 1 dag
(12 bedømmelser)
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 Flere

$35 USD på 1 dag
(5 bedømmelser)
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 Flere

$35 USD in 3 dage
(2 bedømmelser)
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 Flere

$50 USD in 3 dage
(2 bedømmelser)
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 dage
(2 bedømmelser)
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 dage
(2 bedømmelser)
1.4