ID | Name | Description | Duration | Quantity | Precedents | Productivity | Output | Resource1 | FixedCost | Unitcost |
Unique Identifier of the Activity - should consist of only alphabets and numbers. Should not contain special characters | Name of the activity that will be displayed in the output | Description (ignored) | Maximum Time Of Activity. 0 indicates no constraint on time. | Amount of Work to be carried out | Identifiers of predecessor activities separated by coma. Leave empty if there are no precedence relationsips for this activity | Amount of Work that can be done Per Unit Quantity of Resource | Entities produced by the activity | Unique Identifier of the Resource needed for the activity | Fixed component of the cost of the activity (One time cost at the start of the activity) | Cost per unit time of execution of the activity |
A1 | Site Preparation | All prelim works | 0 | 102.3 | 50 | worker | 0 | 100 | ||
A2 | Excavation | Excavate soil to 1.2 m depth | 0 | 1.2 | A1 | 0.6 | earthwork | JCB | 5000 | 100 |
In the above table, the first row is the header and should be exactly the same in your data file.
The second row is provided for describing the fields. It should NOT be in your data file.
The third and fourth rows are examples for illustration. Use your own data for all the rows starting from 2.
The last three columns should be repeated for each resource, if any activity requires more than one resource.
Some activities can have multiple columns for resources, while others may not have any columns for resources at all.