Monthly Project Scheduler

[Bumblebee00]

Hi all,

I need some help with a monthly project scheduler my boss has asked me to create. Basically it shows all of our current jobs for the month, the employees and equipment allocated to each job and the start and end dates for each job. I need help with the formatting to highlight when employee's and/or equipment are allocated to more than one job on the same date(s).

Please help!
Thanks in advance.

 

[Dendro]

could you give an example of how your file would look like?

 

[Bumblebee00]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Job #
[/TD]
[TD]Client
[/TD]
[TD]Field Supervisor
[/TD]
[TD]Equipment
[/TD]
[TD]Employees
[/TD]
[TD]Start
[/TD]
[TD]End
[/TD]
[TD]Days
[/TD]
[TD]Complete
[/TD]
[/TR]
[TR]
[TD]99
[/TD]
[TD]C. Yasoon
[/TD]
[TD]Scott
[/TD]
[TD]DD005
[/TD]
[TD]Lee
[/TD]
[TD]16/2
[/TD]
[TD]17/2
[/TD]
[TD]2
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EX001
[/TD]
[TD]Tom
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]PS004
[/TD]
[TD]Mark
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]91
[/TD]
[TD]Theresa Green
[/TD]
[TD]Scott
[/TD]
[TD]DD009
[/TD]
[TD]Tom
[/TD]
[TD]13/2
[/TD]
[TD]20/2
[/TD]
[TD]7
[/TD]
[TD]50%
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TR008
[/TD]
[TD]John
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EX006
[/TD]
[TD]Mark
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]PS004
[/TD]
[TD]Jim
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

This is what is looks like. I want to highlight any employees and/or equipment that is scheduled for a job on the same dates. This will enable project managers to see at a glance what resources and people are allocated to which jobs and on which dates, so they know who is available and who isn't.
I hope that makes sense.

 

[Dendro]

So the output has to be a calendar which holds all employees/equipment who are assigned and who are not?
If so research 'Gantt chart', you have free applications that do this for you with great ease or you can find an excel template which you just have to adapt to your whishes.

 

[Bumblebee00]

Yes that's basically it.
Thank you. I will research the Gantt Chart as you suggest.