176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel VBA script to distribute tasks to workers.
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Sep 28, 2010
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Sep 27, 2010
  • 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

An Excel VBA script is needed to distribute multiple "tasks" among different "workers". One Excel sheet will contain a list of "workers", another sheet will contain a list of "tasks". When the VBA script runs, it will distribute all the tasks to the workers based on the rules described later below.

The workers will have the following fields:
Name - This is the name of the worker. (string)
Active - If this column is checked, they will participate in the task distribution. (yes/no)
Current Tasks - This is a numeric value of the number of tasks they currently own. (numeric value)
Skill Level - This is a numeric value indicating the worker's skill level. (numeric value)
Attribute XXX - This represents a skill attribute. If checked, it indicates the worker has that particular skill. (yes/no)

The tasks will have the following fields:
Name - This is the name of the task. (string)
Assignee - This is whom the task is assigned. The VBA script should populate this field!! (string)
...

Sign in or Register to see more

Desired Skills
VBA
Job ID: 21361058
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Japan  |  
An Electrical Engineer and worked 5 years in engineering fields. Worked 10 years in IT Automation and Controls System that involved System...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 21374044  |  Submitted: Sep 28, 2010 18:15 ET 
Proposal SEALED

 Latvia  |  
I specialize in developing customized solutions based on Microsoft Word, Access and Excel. My aim is to provide high-quality and cost-effective...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 21373174  |  Submitted: Sep 28, 2010 16:45 ET 
Proposal SEALED

 United States  |  
Excel Specialist provides solutions for small business designed to fit your budget. My designs save clients time-money and provide fast reporting...
1
  |  
 5.0   |  $299 Earnings   |  1 Jobs
Bid ID: 21371738  |  Submitted: Sep 28, 2010 14:55 ET 
Proposal SEALED

Xion Services      
One or more team members at  are verified.  Learn More
 Chile  |  
We are a Software development and consulting company that offers professional services to a global market, sourcing profesionals from Latin...
4
  |  
 5.0   |  $3,285 Earnings   |  1 Jobs
Bid ID: 21371708  |  Submitted: Sep 28, 2010 14:53 ET 
Proposal SEALED

 United States  |  
I'm a software engineer with over 11 years of experience in IT. - Have a expert level knowledge in Oracle Pl/SQL, Reports, Forms development,...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 21371419  |  Submitted: Sep 28, 2010 14:34 ET 
Proposal SEALED

 China  |  
Winner
I am a freelancer from China. I have been working in software development for 8 years and gained considerable experience and various skills. I...
1
  |  
 0.0   |  Private   |  2 Jobs
Bid ID: 21369116  |  Submitted: Sep 28, 2010 11:29 ET 
Delivery
Within 1 day
$77.00

 United States  |  
Multi-tier application design and development; Client/Server application design and development; Application architecture design and development;...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 21368383  |  Submitted: Sep 28, 2010 10:28 ET 
Proposal SEALED

 India  |  
Successfully finished over 400 Microsoft Access Database projects and 50+ .net projects. DotNetNuke, DNN 5, DNN7, Microsoft Access 2003 ,...
2
  |  
 0.0   |  Private   |  1 Jobs
Bid ID: 21365484  |  Submitted: Sep 28, 2010 06:07 ET 
Proposal SEALED

 United Kingdom  |  
I am a hard core "techie", looking to fill the gaps which other providers leave because the project is too complicated or the technology is not...
11
  |  
 0.0   |  $96,844 Earnings   |  3 Jobs
Bid ID: 21364502  |  Submitted: Sep 28, 2010 04:25 ET 
Proposal SEALED

 Romania  |  
I'm a professional full-time programmer, with 15 years corporate experience and a strong professional background maintained by a significant...
9
  |  
 5.0   |  Private   |  32 Jobs   |  3 verified credential(s)
Bid ID: 21362020  |  Submitted: Sep 28, 2010 00:38 ET 
Proposal SEALED

 China  |  
I wiil be best elancer...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 21361250  |  Submitted: Sep 27, 2010 22:57 ET 
Proposal SEALED
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 »