Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Spreadsheet Refinement | VB and Advanced Excel Formulas
Sign in to Add to Watch List

IT & Programming > Software Application

View Change History

The client has made the following changes to the job.


Job awarded.

Dec 6, 2012

Job Description

  |  Change History >>


  • Posted: Mon, Dec 03, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have an existing excel spreadsheet that simulates commission splits for salespeople (agent) to a company. The system is based on a graduated split called 'tiers'. The higher the gross sales earnings a salesperson makes, the more they keep. At the end of the year, depending on their earnings and the tier level achieved, they would then drop one tier level to start the following year. All their earning for the next year up to this lower tier level would be at that established percentage level.

Currently I can:

a. Add salesperson
b. Change the tier (amounts) of the sales thresholds for the various levels
c. Adding, removing or editing complete tier structures for other sales teams
d. Setting the tier level in which a salesperson begins
c. The ability to track Company Income, and Salesperson Income by Year, Quarter, etc. and show graphically.
d. The tier system is set up to define a decreasing split to the Company as the agent performs, on the anniversary of the agent coming to the ...

Sign in or Register to see more

Desired Skills
Microsoft Visual Studio
Job ID: 35701532
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

- Freelance, part-time work from home. - Previously worked in the Information Technology industry for 8 years. - Have worked extensively on MS...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35799046  |  Submitted: Dec 6, 2012 04:20 ET 
Proposal SEALED

 Puerto Rico  |  
Specialized on complex VBA applications. Very good listener. Tthe focus is on you. Honest about what is possible and usually can do better than...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35785514  |  Submitted: Dec 5, 2012 16:35 ET 
Proposal SEALED

 India  |  
Team of 25 developers.skills on Web/Mobile(PHP,MS.Net), DB(SQL,MYSQL),Zoho,Tableau,Tibco,Excel/Access VBA.Traveled&Worked w/USA,UK,AUS,Saudi Arabia...
 4.5   |  Private   |  34 Jobs
Bid ID: 35737686  |  Submitted: Dec 4, 2012 08:26 ET 
Proposal SEALED

 United States  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35718688  |  Submitted: Dec 3, 2012 17:45 ET 
Proposal SEALED

 Pakistan  |  
Experienced PHP, ASP.Net developer, expertise both in desktop and web application. Expert in database driven application with excellent user...
 4.9   |  Private   |  37 Jobs   |  1 verified credential(s)
Bid ID: 35714029  |  Submitted: Dec 3, 2012 14:18 ET 
Proposal SEALED

Issam B.      
Issam B.'s identity has been verified.  Learn More
 Tunisia  |  
I m specialised in two fields : - Gathering, structuring and formatting data - Assisting student in their assignments and Master/Thesis...
 0.0   |  Private   |  0 Jobs
Bid ID: 35705514  |  Submitted: Dec 3, 2012 09:43 ET 
Proposal SEALED

One or more team members at  are verified.  Learn More
 India  |  
.Net and VBA expert with 15 years of experience on MS Office development(Excel,Powerpoint,Outlook,Visio) and CAD software customization(Proe...
 5.0   |  Private   |  3 Jobs
Bid ID: 35705420  |  Submitted: Dec 3, 2012 09:40 ET 
Within 3 days
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »