Concluído

Excel Spreadsheet build - Simple Partner Commission Calcuation

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.

Habilidades: Excel, Processamento de Dados, Visual Basic, Processamento de dados, Arquitetura de software

Veja mais: build simple web page header, can build front end excel spreadsheet, convert web page excel spreadsheet, sales commission calculator excel template, vlookup commission excel, tiered commission excel template, draw commission spreadsheet, google sheets commission template, commission spreadsheet template excel, employee commission template, sliding scale commission excel template, draw commission excel spreadsheet, post excel spreadsheet web page, excel spreadsheet commission report, convert excel spreadsheet work web page, build simple page portfolio, much cost someone build simple page website, pasting web page excel spreadsheet, export excel spreadsheet web page, macro copy currently open html page excel spreadsheet

Acerca do Empregador:
( 2 comentários ) Beeliar, Australia

ID do Projeto: #27476232

Concedido a:

sevillajk01

hello! I can help you with your excel commission calculation project. You can be assured of a high quality and accurate output. I hope you will consider me, thanks!

$50 USD em 7 dias
(38 Comentários)
4.9

10 freelancers are bidding on average $26 for this job

mohamedBJ

Hi I am an expert in excel and can start right away. Hope you will consider my application. Looking forward to working with you.

$30 USD em 1 dia
(8 Comentários)
4.6
ware910

Hi sir I am excel and VBA expert Talking about my background I have more than 3 years of experience developing business intelligence for companies

$30 USD in 2 dias
(10 Comentários)
3.6
anowarbss

Hi, There I can complete your excel sheet only few hours kindly drop me a message so that we can discuss more Thanks Anowar

$15 USD em 1 dia
(17 Comentários)
2.9
professional800

Greetings I have experience of more than two decades as Manager Accounts in Listed Companies. I have experience of VBA and Advance Excel. I can start your project now. Thanks

$28 USD em 1 dia
(5 Comentários)
2.8
govindpatra

Respected Sir,/Ma'am; hope you are also doing well. I have some great exposures in Excel, also I'm a CPA & CMA, so I can handle this project perfectly. please text me to discuss more. Please check-out one of my relate Mais

$30 USD in 2 dias
(6 Comentários)
2.9
sumbegr

Hi There, I read your job description and understand all the requirements. I am a qualified process specialist with more than 10+ years of experience and Job success rate in Digital and Social media marketing. I am a Mais

$20 USD in 7 dias
(0 Comentários)
0.0
Bainet

Hello I'm Binet and am from Kenya, I have 3 years experience in data entry, PDF, MS Excell, MS Word and more. I have read and understood your project description and I will be so glad to work with you on your project Mais

$25 USD in 7 dias
(1 Comentário)
0.0
Debabratachell

Dear Sir, SIR MY NAME IS DEBRATA CHELL. I AM A CIVIL ENGINEER. I HAVE 3 YEAR EXPERIENCE IN THIS TYPE OF PROJECT. SIR THIS IS MY FIRST PROJECT. PLEASE GIVE ME ONE OPPORTUNITY TO START MY FREELANCING CAREER. PLEASE GIVE Mais

$10 USD in 7 dias
(0 Comentários)
0.0
mb652219

I am interested this work please share your project I am professional data entry operator give me a chance I impress for you by my service

$20 USD in 7 dias
(0 Comentários)
0.0