With this sheet of our Dashboard project we are able to monitor activities in progress and assigned to various members of the development group.
The information to be inserted are arranged in columns, some other input and calculated with the formulas of the spreadsheet. Let's see the details
- title - this column contains the name of the person in charge of
- start - insert here the date of commencement of
- end - is a calculated column and is the end date of activity, calculated by adding the date start working days of the column effort and days of delay of the column delay.
- description - contains a brief description of the activity.
- extends - is the estimated date of the end of the activity, without taking into account any delay.
- effort - is the number of working days estimated to complete the task.
- delay - is the deviation from the initial estimate dell'effort the actual duration. As an offset, can be a positive or negative number.
- ellapsed - is the number of calendar days that elapse from the beginning of its end.
- the data presented here are used directly as input for the gant homepage displayed in the dashboard page Timeline . The field title, start, end and description have these names, even if not immediately apparent, because the graphics components that draw the gant they post on the presence of columns designated as such.
- to insert a new row or a new activity to be traced, you should copy an existing line.
- milestones are activities without the column end.
- milestone today aims to identify at a glance which activities are yet to begin and what could already be over.
- ordering activities than the start date, for example when you insert new tasks or when you want to update the position of the milestone today, simply sort the column B of the spreadsheet.
- attribute the delay to be updated daily, based on estimates of changes or delays actually measured.
This classification of assets no longer running it is very important to maintain statistics on the project, for example, to measure the speed of development or the accuracy of estimates made.
experience, this is the daily work sheet during the coordination of a development project.