WBSTasksTask LeadStartEnd [631357]

[Project Name]
Project Lead:Today's Date:5/14/2017(Sun)(vertical red line)[42]Start Date:1/3/2017(Tue)First Day of Week (Sun=1):2##########################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################
WBSTasksTask LeadStartEnd
Duration (Days)
% Complete
Working Days
Days Complete
Days Remaining
02 – Jan – 17
09 – Jan – 17
16 – Jan – 17
23 – Jan – 17
30 – Jan – 17
06 – Feb – 17
13 – Feb – 17
20 – Feb – 17
27 – Feb – 17
06 – Mar – 17
13 – Mar – 17
20 – Mar – 17
27 – Mar – 17
03 – Apr – 17
10 – Apr – 17
17 – Apr – 17
24 – Apr – 17
01 – May – 17
08 – May – 17
15 – May – 17
22 – May – 17
29 – May – 17
05 – Jun – 17
12 – Jun – 17
19 – Jun – 17
26 – Jun – 17
03 – Jul – 17
10 – Jul – 17
17 – Jul – 17
24 – Jul – 17
31 – Jul – 17
07 – Aug – 17
14 – Aug – 17
21 – Aug – 17
1 John1/03/173/04/176085%44519
1.1 1/03/171/18/1715100%12150
1.2 1/18/172/02/171595%121411.3 2/02/172/17/171595%121411.4 2/17/173/04/171550%11782 3/04/178/01/1715023%107341162.1 3/04/173/19/171550%10782.2 3/19/176/17/179030%6527632.3 6/17/127/17/12300%220302.4 7/17/178/01/17150%120153 8/01/178/16/17150%120153.1 8/01/178/16/17150%12015Depozit IT SRL
Victor Mihai Deacoescu
Analiza sistemului existent
Analiza ecoomica a firmei
Analiza procedurilor si a documentelorAnaliza fluxului de documenteAnaliza sistemului informatic existentProiectarea sistemului informaticProiectarea bazei de dateProiectarea aplicatiei informaticeTestarea aplicatiei informaticeImplementarea aplicatiei informaticeExploatarea sistemului informaticExploatarea sistemului informatic
HELP
– Modify the GREEN cells and the WBS, Tasks, and Task Lead columns. The rest of the columns are formulas.- The number of weeks shown in the gantt chart is limited by the maximum number of columns available.- The Start Date that you choose determines the first week in the gantt chart, starting on a Monday.- Change the first day of the week via cell K8- Use the slider to adjust the range of dates shown in the gantt chart.- Only 34 weeks can be shown/printed at one time, because each week uses up 7 columns.
Q: How do I make Task 2 start the day after the end of Task 1?Use the following formula for the start date of Task 2:=EndDate+1where EndDate is the reference to the cell containing the end date of task 1
Q: How do I add/insert tasks and subtasks ?Copy the entire ROW (or a group of rows) for the type of task(s) you want to add and then right-click on the row where you want to insert the new tasks, then select Insert Copied Cells.Important Note: When inserting a new subtask after the last subtask or before the first subtask, you will need to update the formulas for calculating the Level 1 %Complete and Duration (see below) to include the new subtask, because the ranges won't automatically expand to include the additional row.
Q: How do I calculate the %Complete for a Level 1 task based upon the %Complete of all of the associated subtasks?Example: If Task 1 is on row 11 and the subtasks are on rows 12-15, use the following formula:=SUMPRODUCT(F12:F15;G12:G15)/SUM(F12:F15)
Q: How do I calculate the Duration for a Level 1 task based upon the largest end date of a sub task?Example: If the Level 1 task is on row 11 and the sub tasks are on rows 12-15, use the following formula=MAX(E12:E15)-D11
Q: How can I include holidays in the calculation of the Working Days?You can add a list of holidays to exclude in the NETWORKDAYS function. See the help on that function.
Q: How do I change the print settings?Select the entire range of cells that you want to print and then define a Print Range in the Format menu. Then go to Format > Page and select the Sheet tab. Adjust the Scaling mode as desired.