Template For Weekly Schedule That Will Look Like My Example?

Hello All!

I've been scouring the internet for days, searching for a template to use that will produce results like you see in my attached example, without having to manually type the jobs and employees over and over. Making this each week has become quite cumbersome and tedious, especially when a job or customer changes at the last minute, and employees need to be shuffled around to other jobs or placed on a completely new one that wasn't originally scheduled.

But, first, let me give you some backstory. I work for a branch office of a company that services and installs conveyor belts for a major copper-producing company in the Southwestern US. We have nearly 20 employees, and a handful of unique customers, in addition to the main one.

We've been using Excel to produce a weekly schedule that looks like what you see here, but I'm looking for a way to make this more user-friendly, and not so time consuming to maintain. So, I've been on the hunt for an easier solution. I tried making an alternative on my own, but I think maintaining it will be even more time-consuming than just typing the entries in each cell by hand.

The first file, "Sample Weekly Schedule," is what we're currently using (with any identifying information removed), and the second file, "Weekly Schedule - Working Template," was my 'attempt,' unsuccessfully, to create a different version that would be easier to use/maintain, but still give me the same appearance of the first file.

Any help you all could give would be greatly appreciated.

Thanks,

William

I would use a simple tabular format as shown in "Schedule" in the attached which makes it much easier to manipulate and report on, your data/business.

Equally, you can "print" in any required format.

You can reduce typing and potential errors by using data validation lists e.g. List of your customers, list of jobs, list of employees.