Progress Planned and Achieved by Code

Mike,

There are two ways to get to the answer which i think you are looking for:

The first is to summarise each group of items so you have a builders elements summary, an electrical elements summary and a plumbing elements summary. The summary bar will have its own 'rolled-up' planned and actual percent complete shown in the spreadsheet however this may distort the natrual order of your programme. So it may be better to create a hammock for each group of tasks at the top of the programme, again a builders elements hammock, an electrical elements hammock and a plumbing elements hammock and then add the respective activities to the correct hammocks and as with the summary tasks this will also give you a 'rolled-up' planned and actual percent complete for each hammock.

Both the hammocks and the summary tasks will provide a visual representation of the progress if you are using a 'jagged' progress period line, however if you didn't want to show the additional bars the hammocks would be easier to hide than the summary bars as the hammocks don't contain any infomation as such, they only reflect the infomation which is contained elsewhere. Hope this helps!

Rob H.