Map Metra

Program 6: Resource worksheet

Part 6 of the Program series. Work out construction activity durations from quantities and productivity in the resource worksheet, assign resources, compare resource cost with the estimate, and use RateBuild rates. Everything shown can also be done by asking the Map Metra connector in Claude or ChatGPT.

How to

  1. 1

    The worksheet

    Each activity shows its linked item and quantity, its resource, and three durations: the calculated duration, the existing one, and the final duration that drives the chart. Then come the resource cost, the estimate cost, and the variance between them.

  2. 2

    Linking a quantity

    Activities imported from the WBS arrive with their quantities linked. Where one has none, such as painting, choose Link, and pick the measured quantities from the Bill of Quantities.

  3. 3

    Timed from a RateBuild rate

    Floor tiling is priced in the Estimate with the tiling rate from RateBuild, so it is timed from the tiler's productivity: seventy six point three square metres, at twelve a day, is six point three six days. The labourer and the wet saw work alongside, so they add no time.

  4. 4

    Assigning a resource

    For other activities, assign a resource from the library. Choose a carpenter for the external walls, and choose Assign.

  5. 5

    Applying to the Estimate

    Tick the box in the arrow Est column, to use the resource cost as the line's rate in the Estimate. If the line already has a rate, you are asked first.

  6. 6

    Calculating everything

    Calculate duration from productivity switches the calculated durations on or off together, and Use calc all applies them in one go. Match resources suggests a resource from your library for each activity that has none.