+ Reply to Thread
Results 1 to 1 of 1

balancing workload

  1. #1
    Registered User
    Join Date
    05-26-2014
    Posts
    5

    Post balancing workload

    Hello,
    I'm busy with a project for school and I want to balance workload using excel en VBA.
    I have times for how long it takes to assemble something and a maximum available time.
    Now I want to divide it over workers using VBA.
    I thought that a good way was, to select the maximum of the times, set it in a the row of the specific worker, then take the second largest time check of the sum of the two times is less than the maximum available time.(if not check the third largest ect.) and continue until the worker is full (can't do the smallest task anymore).
    Then continue with the next worker for the remaining task until all the task have been divided.
    (In this way the last worker will has the most spare time to do other things)

    thanks in anticipation !!

    Ps: sorry for my English
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Selective Load Balancing Macro
    By Dissonant in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-12-2013, 11:43 PM
  2. Producing balancing entries
    By The Phil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2013, 11:50 AM
  3. Balancing
    By reficuul in forum Excel General
    Replies: 8
    Last Post: 05-01-2010, 03:24 AM
  4. Balancing Operations
    By EH003268 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-04-2007, 02:13 AM
  5. balancing check register
    By Faye in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2006, 01:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1