Documentation

Over the weekend, I looked at the project spreadsheet we have on Google Documents. This spreadsheet contains the Gantt Chart, which shows an overview of the project and each single task that is related to the project, and the Budget, which just shows the overview of funds planned and used on the entire project.

The Gantt Chart

The Gantt Chart went through several changes which also lead to the entire chart being widened. The row where the tasks were placed had been modified where each week had their days merged, so each week can be clearly defined on the actual chart. The heading was modified and cleaned up. A brief description on how to use the chart was added to the top and one of the tasks was renamed from 'Preparation of Report/Budget' to 'Documentation'. I felt the name change described the task at hand more than the original one.

Overview of the modified Gantt Chart.

The Budget

The budget went through minor changes relating only to the formatting and layout. Mostly changes to the size of the format, and the headings the tables are located under. The expenditure heading was removed entirely since there was already a heading for budget. The sub-heading Salary, was replaced with Work Hours due to it sounding a little better.



Overview of the budget prior to the changes.



With the table containing each of the tasks as well as planned hours, start dates and costs involving workers, has been modified to directly link to the tasks in the Gantt Chart. If tasks are renamed in the Gantt Chart, they will be renamed in the budget. Simplicity. The wage rate was moved to the right of the work hours table, whilst maintaining the link where changing the wage rate changes the costs involved.

Overview of the budget after the changes. Still a work in progress.