GANTT Chart help.

willhub · 4 Nov 2009 at 11:46

Hi, for my assignment we have to make some gantt charts, now they're simple enough, well up to a certain degree, and I'm using excel, but the thing is, at the moment I have 3 sepeate gantt charts for the following

Computer parts - installation times, the time scaled on the chart is in minutes, 5,10,15,20 etc...

Another chart for software installation, on the same time scale as the above.

Then one for the computer upgrade on a whole, 4 technicians, each building 1 computer at a time, estimated time of building and installing the software is 1 hour 20mins, so I've had to put this into the chart, assuming that is the time for 1 computer and there are 4 techys then around 20 computers can be built in day. This chart is on the scale of hours.

The problem is, my tutor wants a larger gantt chart on a scale of days, and I'm unsure how I am going to fit this into a larger gantt chart on the scale of days?

Any help would be good, thanks.

willhub · 4 Nov 2009 at 12:05

We don't have MS Project here so I've got no choice but to use excel.

willhub · 4 Nov 2009 at 12:50

Well the duration is 60 days apparently, the tutor won't explain anything else.

I have done 3 charts, they are pretty simple.

What I need to do is get this into one chart, and it's on a daily scale of 60 days, basically the brief says we have 250 computers to upgrade and due to the times it takes to get one computer up and running I estimate 20 computers a day assuming they have 4 techys.

But I really cannot work out how to get this into one gantt chart.

willhub · 4 Nov 2009 at 12:59

I broke the chart down into minutes.

The reason being is we where told to make a gannt chart for the installation of the individual pc parts, now if the tutor thought this was too much detail though I thought hed tell me? I'm just really confused I hate these charts.

The problem is, if I do less detail, I can't think of the point of a gantt chart.

250 pc's
60 days

tasks:
install hardware
install software
user training
testing

Unless the way I should do it, is allow 30 days for PC hardware/software install, 20 for user trianing and 10 for testing, but then all I can see is 3 lines on a chart.

willhub · 4 Nov 2009 at 13:11

We have to fit them all in one go, identifying software was done for us, we need to do audit sheets like but we are not needed to include that, all we need to include is hardware/software installation, training staff and testing, that's about it.