• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Task Scheduling with Excel

D

Dagon

New Member
Hi all! This is my first post. First, I want to say thank you for all the great articles and assistance on here.

I am currently working on a project where I need to use Excel to schedule tasks. for source data, I have two tables and want to produce my results in a 3rd.

Table 1 - StaffSchedule
  • Date = date
  • Staff1 = units or hours per day
  • Staff2 = units or hours per day
  • Staff3 = units or hours per day
  • Staff4 = units or hours per day
  • Staff5 = units or hours per day
  • Staff6 = units or hours per day
  • Total Work per day = total units or hours per day
Table 2 - AvailableWork
  • WorkStatus = Complete or Uncompleted
  • Task = Task name
  • Task Duration = units of work or hours needed to complete task
  • CumulativeDuration = Remaining work if task if not complete
Table 3 - WorkSchedule (ResultsTable)
  • Date = Calculated date based on Workstatus (complete or not complete), current date, and available resources for that day
  • Task = Calculated date based on Workstatus (complete or not complete), current date, and available resources for that day
  • Staff = Calculated date based on Workstatus (complete or not complete), current date, and available resources for that day
I've looked through several of the posts and articles on scheduling, but most seem a little different than what I am trying to do here. Any help you can provide would be much appreciated!

I have uploaded a sample of the data.
 

Attachments

Hi, Dagon!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, have you searched this site for similar problems?

f you haven't performed yet the search herein, try going to the topmost right zone of this page (Search...), type the keywords used in the title when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.

Regards!
 
Yes I have searched for similar problems. I've broken the problem into two parts.

Part 1: determine the day of the task can be performed based on the MaxWorkPerDay.
Part 2: determine the staff to perform the task based on the Staff schedule

The following post on Production Scheduling is similar to part 1 of the problem I am trying to solve. However, they have a fixed MaxWorkPerDay where mine varies based on the day.
http://chandoo.org/wp/2012/10/11/formula-forensics-no-031/
 
I finished the spreadsheet today! It is not pretty and I am sure there are more elegant ways to do the calculations. But, it is probably the most complicated spreadsheet I have done so far. Please feel free to take a look and let me know how I did.

Regards!
 

Attachments

You must log in or register to reply here.
Back
Top