Hello all.
I was able to find a gantt chart template to help me do some scheduling work. I attached a photo so you can get a visual of what I am trying to accomplish. Unfortunately I can't attach what I am working due to confidentiality issues.
So I have my worksheet setup for a week. Sunday-Saturday. I show hours like in the photo below but it extends past 24 obviously as I am scheduling for 7 days. What I am trying to accomplish is get more than one start/stop for each activity. We have more than 40 activities/tasks so I could do something like "running1" and in the next row "running2". Unfortunately if I was to do that I would have hundreds of rows because each activity is done multiple times in a day/week.
As of now my only solution I attempted was to add in a bunch more columns to show like | plan start 1| plan duration 1 | actual start 1 | actual duration 1 | plan start 2 | plan duration 2 | actual start 2 | actual duration 2 | and so on to around 20+. I was then able to get the conditional to allow multiple runs on each activity throughout the week. The problem is now I have a TON of extra columns to the left and can't even see my schedule.
Does anyone have any suggestions of an easier way to go about this? Worst case I could possibly send the file to someone but I would remove all the activities to show examples.
Thanks all!
Bookmarks