Hi all
I'm trying to make a scheduling calendar for my general contractor business, but I think I've been thinking about it too hard. I am incredibly confused.
I have a handful of projects going simultaneously, and I have a handful of subcontractors working for me on these projects. They can't work on more than one project at a time. I am trying to schedule them without any overlap, but I can't figure it out.
I have five subcontractors: HVAC, plumbing, electric, drywall, and roofing. They can all work on the same project simultaneously, no problem. But any one subcontractor can't work on more than one project per day, and they always finish one project before moving to another. So I need to be able to enter a start date, an end date, which project it is, which subcontractor it is, and then have Excel tell me if I have any of the subcontractors in more than one place on any given day so I can adjust accordingly. I'll then use this info to manually fill in the calendars around the office.
Thank you, and I hope this makes sense. It's been a long day.
Bookmarks