Darren Guess
New Member
- Joined
- Dec 7, 2011
- Messages
- 28
Good Afternoon All
I currently have a Gantt chart within an excel report that I have managed to get working based upon my limited knowledge and searching threads on this forum. Although it works ok there are elements that I would like to work a little better. The layout of the gantt data is displayed below where:</SPAN>
1) Any row with a purple task in column B has the start and end dates in columns C & E fed from another sheet within the excel. The entire row is locked for editing by any user other than myself, as these are used for performance measurement.
2) All other rows (with a yellow task in column B) have the start and end dates entered by a defined team for each report, where additional rows can be added by copying the last row (38) and inserting where required (As these already have the formulas in the respective cells).
3) The chart is then displayed on a seperate tab where there are currently 4 data series used for the chart. The 'Start Date' (column C) data series is filled with no colour, so that the Gantt appears floating from it's respective start date. Days Completed (column F) displays in green as the chart is advanced along. Days left to complete (column G) displays in blue and finally Additional Days (Column H) displays in red.
If we take row 8 below as an example to explain the formulas these are as follows:
D8 (Duration Days) =E8-C8.
F8 (Days Completed) =IF(J8>=I8,I8,J8).
G8 (Days Left to Complete) =IF(I8-F8<0,0,I8-F8).
I8 (Total Days to Complete) = E8-C8.
J8 (Non-Negativity) =IF($C$43>=C8,$C$43-C8,0) where C43 is a date fed in from another sheet.
Excel 2007
<COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]Note: When using the Gantt Chart Input Data, only cells & dates that are coloured in green require filling out. All other dates will be calculated automatically
Please note that the task description cells highlighted in Purple should not be renamed[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #ffff99, align: center"]Check Duration[/TD]
[TD="bgcolor: #ffffff, align: center"]63[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #ffff99"]Task[/TD]
[TD="bgcolor: #ffff99, align: center"]Start Date[/TD]
[TD="bgcolor: #ffff99, align: center"]Duration (days)[/TD]
[TD="bgcolor: #ffff99, align: center"]End Date[/TD]
[TD="bgcolor: #ffff99, align: center"]Days Completed[/TD]
[TD="bgcolor: #ffff99, align: center"]Days left to complete[/TD]
[TD="bgcolor: #ffff99, align: center"]Additional Days[/TD]
[TD="bgcolor: #ffff99, align: center"]Total days to complete[/TD]
[TD="bgcolor: #ffff99, align: center"]Non-negativity[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #cc99ff"]Pre Dock [/TD]
[TD="align: center"]01/08/12[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]02/08/12[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]9[/TD]
[TD="bgcolor: #ffff99"]Functions[/TD]
[TD="bgcolor: #ccffcc, align: center"]01/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ccffcc, align: center"]04/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]10[/TD]
[TD="bgcolor: #ffff99"]Thrust Reverser Functions[/TD]
[TD="bgcolor: #ccffcc, align: center"]01/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ccffcc, align: center"]04/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]11[/TD]
[TD="bgcolor: #ffff99"]FR 80 Doubler corrosion investigation[/TD]
[TD="bgcolor: #ccffcc, align: center"]01/08/12 12:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ccffcc, align: center"]03/08/12 13:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]12[/TD]
[TD="bgcolor: #ffff99"]FR 80 Data sent to AIB [/TD]
[TD="bgcolor: #ccffcc, align: center"]03/08/12 13:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ccffcc, align: center"]03/08/12 15:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]47[/TD]
[TD="align: center"]13[/TD]
[TD="bgcolor: #ffff99"]Awaiting AIB FR 80 Response[/TD]
[TD="bgcolor: #ccffcc, align: center"]03/08/12 15:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ccffcc, align: center"]06/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]47[/TD]
[TD="align: center"]14[/TD]
[TD="bgcolor: #ffff99"]FR 80 & FR 58 Stress jacking[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 07:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 19:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="align: center"]15[/TD]
[TD="bgcolor: #ffff99"]FR 80 Repair assessment[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 13:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ccffcc, align: center"]11/08/12 19:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]41[/TD]
[TD="align: center"]16[/TD]
[TD="bgcolor: #cc99ff"]Open Up [/TD]
[TD="align: center"]01/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]8[/TD]
[TD="align: center"]09/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]8[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]8[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]17[/TD]
[TD="bgcolor: #cc99ff"]Base Insp [/TD]
[TD="align: center"]02/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]12[/TD]
[TD="align: center"]13/08/12 13:00[/TD]
[TD="bgcolor: #ffffff, align: center"]12[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]12[/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="align: center"]18[/TD]
[TD="bgcolor: #cc99ff"]Supplemental Insp [/TD]
[TD="align: center"]02/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]24[/TD]
[TD="align: center"]25/08/12 19:00[/TD]
[TD="bgcolor: #ffffff, align: center"]24[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]24[/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="align: center"]19[/TD]
[TD="bgcolor: #ffff99"]ETIC Review[/TD]
[TD="bgcolor: #ccffcc, align: center"]26/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]27/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]25[/TD]
[TD="align: center"]20[/TD]
[TD="bgcolor: #ffff99"]Ageing A/C Review[/TD]
[TD="bgcolor: #ccffcc, align: center"]02/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]15[/TD]
[TD="bgcolor: #ccffcc, align: center"]17/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]15[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]15[/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="align: center"]21[/TD]
[TD="bgcolor: #ffff99"]NDT Programme[/TD]
[TD="bgcolor: #ccffcc, align: center"]07/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="bgcolor: #ccffcc, align: center"]25/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="bgcolor: #ffffff, align: center"]44[/TD]
[TD="align: center"]22[/TD]
[TD="bgcolor: #ffff99"]Routine Maintenance[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="bgcolor: #ccffcc, align: center"]20/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="align: center"]23[/TD]
[TD="bgcolor: #ffff99"]Defect Rectifications[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="bgcolor: #ccffcc, align: center"]27/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="bgcolor: #ffffff, align: center"]7[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="align: center"]24[/TD]
[TD="bgcolor: #cc99ff"]Close up [/TD]
[TD="align: center"]01/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]26[/TD]
[TD="align: center"]27/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]19[/TD]
[TD="bgcolor: #ffffff, align: center"]7[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]26[/TD]
[TD="bgcolor: #ffffff, align: center"]19[/TD]
[TD="align: center"]25[/TD]
[TD="bgcolor: #cc99ff"]Power on [/TD]
[TD="align: center"]03/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]04/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]17[/TD]
[TD="align: center"]26[/TD]
[TD="bgcolor: #ffff99"]FR47 AIB Response[/TD]
[TD="bgcolor: #ccffcc, align: center"]15/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]16/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]5[/TD]
[TD="align: center"]27[/TD]
[TD="bgcolor: #ffff99"]FR47 Repair Action ?[/TD]
[TD="bgcolor: #ccffcc, align: center"]15/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]7[/TD]
[TD="bgcolor: #ccffcc, align: center"]22/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]5[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]7[/TD]
[TD="bgcolor: #ffffff, align: center"]5[/TD]
[TD="align: center"]28[/TD]
[TD="bgcolor: #ffff99"]Frame 48+51 installation[/TD]
[TD="bgcolor: #ccffcc, align: center"]19/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ccffcc, align: center"]22/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]29[/TD]
[TD="bgcolor: #cc99ff"]Post Maintenance Functions [/TD]
[TD="align: center"]11/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]9[/TD]
[TD="bgcolor: #ffffff, align: center"]9[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="bgcolor: #ffffff, align: center"]9[/TD]
[TD="align: center"]30[/TD]
[TD="bgcolor: #cc99ff"]Post Dock [/TD]
[TD="align: center"]28/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]31[/TD]
[TD="bgcolor: #ffff99"]Engine Runs[/TD]
[TD="bgcolor: #ccffcc, align: center"]28/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]32[/TD]
[TD="bgcolor: #ffff99"]Defuel and Sump[/TD]
[TD="bgcolor: #ccffcc, align: center"]28/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]33[/TD]
[TD="bgcolor: #ffff99"]Weigh+Check Completion[/TD]
[TD="bgcolor: #ccffcc, align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]30/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]34[/TD]
[TD="bgcolor: #cc99ff"]Test Flight Programme [/TD]
[TD="align: center"]30/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="align: center"]03/10/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]35[/TD]
[TD="bgcolor: #cc99ff"]ETIC (Delivery)[/TD]
[TD="align: center"]02/10/12[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]03/10/12[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]36[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]37[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]38[/TD]
[TD="bgcolor: #ffff99"]Description[/TD]
[TD="bgcolor: #ccffcc, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ccffcc, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]41172[/TD]
[TD="align: center"]39[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: center"]40[/TD]
[TD="bgcolor: #ffffff, align: center"]To add lines, copy the above row, insert at the point you want it and manually set the highlighted dates.
If you subsequently wish to add an additional line copy the above row once again and insert it at the point you want it, manually setting the highlighted dates.[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]41[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
</TBODY>
At present everything works ok and is fairly robust, but the one thing I would like to be able to do is to change the way column H (Additional Days) works. At the moment this is a simple data series on the chart, whereby if a user enters a number the series length is displayed in red. Every day the milestone is missed the user must remember to increase the value by 1 to advance the series on one more day. What I would like to do is to change the logic of this column, so that a user can enter the revised target date for that milestone. I cannot work out what formula would be required so that if the original End Date in column E is surpassed and a date is entered in column H the gantt will still advance as it does presently with a master date reference. I would like the extra days in the revised date series to display in say orange (to show how much we are potentially going to miss a target by), until the date has passed, when it would then turn red (to show how many days we actually missed the target).
I am hoping I have explained what I am looking to achieve well enough, as I have tried to insert the chart also for reference, without success. If someone can guide me how to do this I will post this up also.
Many Thanks in advance
Darren
I currently have a Gantt chart within an excel report that I have managed to get working based upon my limited knowledge and searching threads on this forum. Although it works ok there are elements that I would like to work a little better. The layout of the gantt data is displayed below where:</SPAN>
1) Any row with a purple task in column B has the start and end dates in columns C & E fed from another sheet within the excel. The entire row is locked for editing by any user other than myself, as these are used for performance measurement.
2) All other rows (with a yellow task in column B) have the start and end dates entered by a defined team for each report, where additional rows can be added by copying the last row (38) and inserting where required (As these already have the formulas in the respective cells).
3) The chart is then displayed on a seperate tab where there are currently 4 data series used for the chart. The 'Start Date' (column C) data series is filled with no colour, so that the Gantt appears floating from it's respective start date. Days Completed (column F) displays in green as the chart is advanced along. Days left to complete (column G) displays in blue and finally Additional Days (Column H) displays in red.
If we take row 8 below as an example to explain the formulas these are as follows:
D8 (Duration Days) =E8-C8.
F8 (Days Completed) =IF(J8>=I8,I8,J8).
G8 (Days Left to Complete) =IF(I8-F8<0,0,I8-F8).
I8 (Total Days to Complete) = E8-C8.
J8 (Non-Negativity) =IF($C$43>=C8,$C$43-C8,0) where C43 is a date fed in from another sheet.
Excel 2007
| B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|
<COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]Note: When using the Gantt Chart Input Data, only cells & dates that are coloured in green require filling out. All other dates will be calculated automatically
Please note that the task description cells highlighted in Purple should not be renamed[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #ffff99, align: center"]Check Duration[/TD]
[TD="bgcolor: #ffffff, align: center"]63[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #ffff99"]Task[/TD]
[TD="bgcolor: #ffff99, align: center"]Start Date[/TD]
[TD="bgcolor: #ffff99, align: center"]Duration (days)[/TD]
[TD="bgcolor: #ffff99, align: center"]End Date[/TD]
[TD="bgcolor: #ffff99, align: center"]Days Completed[/TD]
[TD="bgcolor: #ffff99, align: center"]Days left to complete[/TD]
[TD="bgcolor: #ffff99, align: center"]Additional Days[/TD]
[TD="bgcolor: #ffff99, align: center"]Total days to complete[/TD]
[TD="bgcolor: #ffff99, align: center"]Non-negativity[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #cc99ff"]Pre Dock [/TD]
[TD="align: center"]01/08/12[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]02/08/12[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]9[/TD]
[TD="bgcolor: #ffff99"]Functions[/TD]
[TD="bgcolor: #ccffcc, align: center"]01/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ccffcc, align: center"]04/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]10[/TD]
[TD="bgcolor: #ffff99"]Thrust Reverser Functions[/TD]
[TD="bgcolor: #ccffcc, align: center"]01/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ccffcc, align: center"]04/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]11[/TD]
[TD="bgcolor: #ffff99"]FR 80 Doubler corrosion investigation[/TD]
[TD="bgcolor: #ccffcc, align: center"]01/08/12 12:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ccffcc, align: center"]03/08/12 13:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]12[/TD]
[TD="bgcolor: #ffff99"]FR 80 Data sent to AIB [/TD]
[TD="bgcolor: #ccffcc, align: center"]03/08/12 13:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ccffcc, align: center"]03/08/12 15:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]47[/TD]
[TD="align: center"]13[/TD]
[TD="bgcolor: #ffff99"]Awaiting AIB FR 80 Response[/TD]
[TD="bgcolor: #ccffcc, align: center"]03/08/12 15:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ccffcc, align: center"]06/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]47[/TD]
[TD="align: center"]14[/TD]
[TD="bgcolor: #ffff99"]FR 80 & FR 58 Stress jacking[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 07:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 19:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="align: center"]15[/TD]
[TD="bgcolor: #ffff99"]FR 80 Repair assessment[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 13:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ccffcc, align: center"]11/08/12 19:00[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"]41[/TD]
[TD="align: center"]16[/TD]
[TD="bgcolor: #cc99ff"]Open Up [/TD]
[TD="align: center"]01/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]8[/TD]
[TD="align: center"]09/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]8[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]8[/TD]
[TD="bgcolor: #ffffff, align: center"]50[/TD]
[TD="align: center"]17[/TD]
[TD="bgcolor: #cc99ff"]Base Insp [/TD]
[TD="align: center"]02/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]12[/TD]
[TD="align: center"]13/08/12 13:00[/TD]
[TD="bgcolor: #ffffff, align: center"]12[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]12[/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="align: center"]18[/TD]
[TD="bgcolor: #cc99ff"]Supplemental Insp [/TD]
[TD="align: center"]02/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]24[/TD]
[TD="align: center"]25/08/12 19:00[/TD]
[TD="bgcolor: #ffffff, align: center"]24[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]24[/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="align: center"]19[/TD]
[TD="bgcolor: #ffff99"]ETIC Review[/TD]
[TD="bgcolor: #ccffcc, align: center"]26/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]27/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]25[/TD]
[TD="align: center"]20[/TD]
[TD="bgcolor: #ffff99"]Ageing A/C Review[/TD]
[TD="bgcolor: #ccffcc, align: center"]02/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]15[/TD]
[TD="bgcolor: #ccffcc, align: center"]17/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]15[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]15[/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="align: center"]21[/TD]
[TD="bgcolor: #ffff99"]NDT Programme[/TD]
[TD="bgcolor: #ccffcc, align: center"]07/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="bgcolor: #ccffcc, align: center"]25/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="bgcolor: #ffffff, align: center"]44[/TD]
[TD="align: center"]22[/TD]
[TD="bgcolor: #ffff99"]Routine Maintenance[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="bgcolor: #ccffcc, align: center"]20/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="align: center"]23[/TD]
[TD="bgcolor: #ffff99"]Defect Rectifications[/TD]
[TD="bgcolor: #ccffcc, align: center"]09/08/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="bgcolor: #ccffcc, align: center"]27/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="bgcolor: #ffffff, align: center"]7[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]49[/TD]
[TD="bgcolor: #ffffff, align: center"]42[/TD]
[TD="align: center"]24[/TD]
[TD="bgcolor: #cc99ff"]Close up [/TD]
[TD="align: center"]01/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]26[/TD]
[TD="align: center"]27/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]19[/TD]
[TD="bgcolor: #ffffff, align: center"]7[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]26[/TD]
[TD="bgcolor: #ffffff, align: center"]19[/TD]
[TD="align: center"]25[/TD]
[TD="bgcolor: #cc99ff"]Power on [/TD]
[TD="align: center"]03/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]04/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]17[/TD]
[TD="align: center"]26[/TD]
[TD="bgcolor: #ffff99"]FR47 AIB Response[/TD]
[TD="bgcolor: #ccffcc, align: center"]15/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]16/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]5[/TD]
[TD="align: center"]27[/TD]
[TD="bgcolor: #ffff99"]FR47 Repair Action ?[/TD]
[TD="bgcolor: #ccffcc, align: center"]15/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]7[/TD]
[TD="bgcolor: #ccffcc, align: center"]22/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]5[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]7[/TD]
[TD="bgcolor: #ffffff, align: center"]5[/TD]
[TD="align: center"]28[/TD]
[TD="bgcolor: #ffff99"]Frame 48+51 installation[/TD]
[TD="bgcolor: #ccffcc, align: center"]19/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ccffcc, align: center"]22/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]2[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]29[/TD]
[TD="bgcolor: #cc99ff"]Post Maintenance Functions [/TD]
[TD="align: center"]11/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]9[/TD]
[TD="bgcolor: #ffffff, align: center"]9[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]18[/TD]
[TD="bgcolor: #ffffff, align: center"]9[/TD]
[TD="align: center"]30[/TD]
[TD="bgcolor: #cc99ff"]Post Dock [/TD]
[TD="align: center"]28/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]31[/TD]
[TD="bgcolor: #ffff99"]Engine Runs[/TD]
[TD="bgcolor: #ccffcc, align: center"]28/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]32[/TD]
[TD="bgcolor: #ffff99"]Defuel and Sump[/TD]
[TD="bgcolor: #ccffcc, align: center"]28/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]33[/TD]
[TD="bgcolor: #ffff99"]Weigh+Check Completion[/TD]
[TD="bgcolor: #ccffcc, align: center"]29/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ccffcc, align: center"]30/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]34[/TD]
[TD="bgcolor: #cc99ff"]Test Flight Programme [/TD]
[TD="align: center"]30/09/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="align: center"]03/10/12 00:00[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]3[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]35[/TD]
[TD="bgcolor: #cc99ff"]ETIC (Delivery)[/TD]
[TD="align: center"]02/10/12[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="align: center"]03/10/12[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]1[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="align: center"]36[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]37[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]38[/TD]
[TD="bgcolor: #ffff99"]Description[/TD]
[TD="bgcolor: #ccffcc, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ccffcc, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"]0[/TD]
[TD="bgcolor: #ffffff, align: center"]41172[/TD]
[TD="align: center"]39[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: center"]40[/TD]
[TD="bgcolor: #ffffff, align: center"]To add lines, copy the above row, insert at the point you want it and manually set the highlighted dates.
If you subsequently wish to add an additional line copy the above row once again and insert it at the point you want it, manually setting the highlighted dates.[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="align: center"]41[/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
[TD="bgcolor: #ffffff, align: center"][/TD]
</TBODY>
Gantt Chart Data
At present everything works ok and is fairly robust, but the one thing I would like to be able to do is to change the way column H (Additional Days) works. At the moment this is a simple data series on the chart, whereby if a user enters a number the series length is displayed in red. Every day the milestone is missed the user must remember to increase the value by 1 to advance the series on one more day. What I would like to do is to change the logic of this column, so that a user can enter the revised target date for that milestone. I cannot work out what formula would be required so that if the original End Date in column E is surpassed and a date is entered in column H the gantt will still advance as it does presently with a master date reference. I would like the extra days in the revised date series to display in say orange (to show how much we are potentially going to miss a target by), until the date has passed, when it would then turn red (to show how many days we actually missed the target).
I am hoping I have explained what I am looking to achieve well enough, as I have tried to insert the chart also for reference, without success. If someone can guide me how to do this I will post this up also.
Many Thanks in advance
Darren
