+ Reply to Thread
Results 1 to 1 of 1

Distributing work across the calendar days based on effort taken per task

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    1

    Distributing work across the calendar days based on effort taken per task

    Hello all,

    This is my first post on the forum so please excuse me if i'm not clear enough.

    I'm trying to schedule activity in the team across the calendar days in the month. Each task that has to go in the calendar has a different volume but the approximate time taken to perform a particular task is known. There is also a particular time by which a certain task has to be completed. Considering all the above parameters, will it be possible to create a schedule which will equally distribute the task between the days?

    I have attached the excel with the input data and how i would like the output to look like. I'm currently using Office 365.

    Thanks everyone in advance!
    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. [SOLVED] How do I display work days only in a calendar format
    By john dalton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2014, 10:47 AM
  2. Replies: 2
    Last Post: 07-31-2013, 02:00 PM
  3. Code to work out working days a task took
    By ianma in forum Excel General
    Replies: 1
    Last Post: 10-21-2009, 10:44 AM
  4. Figuring out Availability based upon work/task schedule
    By B. Baumgartner in forum Excel General
    Replies: 0
    Last Post: 05-03-2007, 10:58 AM
  5. [SOLVED] Distributing Estimated Hours over calendar working days.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2006, 12:15 AM

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