Analysis

Overview

The whole project depends on correct time allocation, so you have to follow these rules:

• add revisions to the rest of the tasks carefully ( search for "more()" in the python file )
• the sprint effort must depend on the resources (developers and QA-s availability) for this sprint
• use the exported files from sophie2-wbs.py for information

Task requirements

• The time allocation should be done according to the whole time for the project and should not exceed it.
• Every task should be divided in three phases (base version, intermediate version, final version).
• Every phase of a task should be divided by parts called revisions.
• The sum of the time of all revisions of a task should be equal to the time allocated for the whole task itself.
• The sum of the time of all tasks should be equal to the time allocated for the whole project.
• Every base version of a task should begin in the time interval assigned for the beginning of a task(RED zone - see resources.ods for details).
• Every intermediate version of a task should begin in the time interval assigned for it (YELLOW zone - see resources.ods for details).
• Every final version of a task should begin in the interval assigned for it (GREEN zone - zone - see resources.ods for details).

Task result

• an understandable schedule in an appropriate form, so that it is easily maintainable (a table for example).

Implementation idea

• create a Open Office Spreadsheet for easy manipulation.

How to demo

• open the resources.ods table and browse through the sheets.
• see the time allocated for every revision (the middle of the table).
• see the overall time allocated for every task (the most right-hand column).
• see the zones (RED, YELLOW, GREEN) in the top-most row to see the beginning, intermediate and finel phase of a task.
• see zeros bellow the top-most column - they represent that a milestone's time is divided among tasks and that neither more nor less time is assigned for the milestone.

Design

The goal is to synchronize the effort allocations in sophie2-wbs.py to the resources.ods.

• Create new sheets
  • Platform
  • Core
  • Base
  • Main
  • Extra
  • SCS
  • S2S
  • Supporting
  • End_Prod
• For each sheet do the following
  • First row should be the same as in alloc sheet
  • Second row should be the same as the corresponding row in alloc sheet (ex. for Platform sheet row 2 should be copied row 3 from alloc sheet)
  • Third row - cells c3..p3 should contain "=X2-SUM(X4:X24)

When this table is ready, each task can be imported in this table. In row 3 can be seen easily how much days are remaining for this milestone for this group of tasks. Use the Output sheet to move the desired rows to the others.

Implementing

• resulted in a table called resources.ods in the old repository.