Excel Gantt chart for monitoring multiple projects.

Description of excel work: Hello everyone.

What I'm after is an excel spreadsheet that gives an overview of various projects in the layout of a Gantt chart. Quite a simple Gantt chart is needed though. I've seen a few on line that have each project split down into multiple goals and time chunks but that's too much info.

Basically we have about 60 projects and we need a way to plan out peoples time lines and what they will be working on. Each project officer has a start and end date and that populates a gantt / bar chart style view. Hopefully it will be a super quick simple little task for someone.

I've included a word document with a mock up of what I need to help clarify anything. If possible I'd need this completed by Friday as i need to present all our projects time lines and plan for the next year.

We only have excel 2007 but ideally needs to work in all iterations as far back as 2003. Please ask any questions, happy to expand if needed.
Extra notes: