Hello everyone,
I'd like to use excel for solving this complex scheduling problem that I'm running into and I'm hoping that there's a superstar here who can help out.
The solution is very valuable for me and I'm willing to pay very well for it, so if you're keen to take this up please do get in touch.
Do you think this is something that's do-able in excel?
I believe most project management tools don't have task schedulers that can handle so many conditions. If that information is wrong, I'd also appreciate any other tool that can handle this problem.
Thanks in advance! and greatly appreciate your time!
Mukund
I'd like to use excel for solving this complex scheduling problem that I'm running into and I'm hoping that there's a superstar here who can help out.
The solution is very valuable for me and I'm willing to pay very well for it, so if you're keen to take this up please do get in touch.
I've attached an excel called task_simulation_01_02.xlsx file that contains more information about the problem
Context
I have 2 data tables
Context
I have 2 data tables
- Table 1 Contains resources (manpower) with
- Their Efficiencies
- Their Capabilites to do a particular task
- Their Availabilities (Start Dates & End Dates)
- Their Leaves
- Table 2 Contains Tasks with
- Dependencies
- Type of resource needed for the task (same as resource Capability)
- Effort for that task
- Task Status
- Table 1 Contains resources (manpower) with
and 1 result Table (with Yellow headers)
Problem
Get the shortest overall duration to complete all the tasks, keeping in mind
Problem
Get the shortest overall duration to complete all the tasks, keeping in mind
- Task Dependencies
- Resource Availability
- Resource Efficiency
- Match Resource and Task capabilities
- Filter out the tasks that are already done
Present this information on a per task basis in the 3rd table with the Yellow headers
Do you think this is something that's do-able in excel?
I believe most project management tools don't have task schedulers that can handle so many conditions. If that information is wrong, I'd also appreciate any other tool that can handle this problem.
Thanks in advance! and greatly appreciate your time!
Mukund