176985602337900

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.

Description
Date

Job awarded.

Dec 6, 2012
Close

Job Description

  |  Change History >>

Updated

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

    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
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India
- Freelance, part-time work from home. - Previously worked in the Information Technology industry for 8 years. - Have worked extensively on MS...
1
  |  
 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...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35785514  |  Submitted: Dec 5, 2012 16:35 ET 
Proposal SEALED

 India  |  
BAANS Consulting Services has 18 years of IT industry exp with USA, UK, AUS clients. We are LARGEST PROVIDER of offshore custom development...
7
  |  
 4.7   |  Private   |  57 Jobs
Bid ID: 35737686  |  Submitted: Dec 4, 2012 08:26 ET 
Proposal SEALED

 United States  |  
1
  |  
 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. Work both in core and framework
8
  |  
 4.7   |  Private   |  89 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...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35705514  |  Submitted: Dec 3, 2012 09:43 ET 
Proposal SEALED

Rajasekar M.      
Rajasekar M.'s identity has been verified.  Learn More
 India  |  
Winner
I have 9 years experience in VB.net,VBA,VSTO,WPF.I am providing solutions for Microsoft Excel,Word ,PowerPoint ,Access ,Outlook ,Google API...
5
  |  
 3.7   |  Private   |  39 Jobs
Bid ID: 35705420  |  Submitted: Dec 3, 2012 09:40 ET 
Delivery
Within 3 days
$471.23
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »