Analysis

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

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.