Direct Cost Schedule – Grid Columns

Each window within Expert Estimation has its own unique workspace layout. The following displays a list of all the available columns that information can be entered within the Direct Cost Schedule window.

NAME

DESCRIPTION

Line #

The main identifier for an item that is automatically numbered and cannot be modified directly.

Information ()

The Information column displays specific information about a Schedule Item.

This is done in the form of icons.

You can hover your mouse over any of the icons within the Information column and a tooltip will appear providing you with a description of the icon displayed.

A list of all the icons that are displayed in the Information column can be seen appended to the end of this article.

Item #

A reference number that can be used to quickly identify the item.

This could be supplied by the client to match internal records.

Description

This column allows you to provide a detailed explanation of the item to be completed.

Formula

The Formula column allows you to perform calculations to produce a quantity for a single item or sum the value of multiple items.

Using the shortcut key Ctrl + Space within this field, will provide you with a list of available formula that can be applied to the item.

Provisional Sum

This column allows you to enter a value against an item that will be represented in the overall project total, without requiring a build up of costs through resource usage.

These Provisional Sum items will be displayed on your client submission reports.

Quantity

Represents the number of units of an item that will be required to complete a schedule item.

Quantities can be calculated using mathematical formula entered in the Formula column. In this scenario, an icon will appear next to the value displayed, representing that the quantity has been calculated.

Using a formula to calculate the quantity, will make the Quantity field read-only.

Estimated Quantity

This column allows you to enter a different quantity that you can base a cost estimate off other than the quantity specified by the client.

Genesis edition only.

Unit

The Unit column is used to define a unit of measure that the Schedule Item is measured in.

The unit of measure can be anything considered necessary for measuring the Item, such as days, cubic metres or hours.

Resource Name

Allows you to specify the name of a resource to be applied directly to the Schedule Item.

This would be most commonly used when a schedule item does not require a build up using a Cost Estimate.

Matrix Item

Specifies the name of the Matrix Item applied to the Schedule Item.

When using a Matrix Item you are prevented from applying a resource to the Schedule Item.

A Schedule Item can still contain a Cost Estimate, however, the value of the item is obtained exclusively from the Matrix Item’s value.

Genesis edition only.

Estimated Rate

The Estimated Rate column shows the per unit rate of the Schedule Item.

This is calculated by dividing the Estimated Total by the Quantity of the Cost Schedule item.

Estimated Total

The Estimated Total represents the entire Cost Total of a Schedule Item.

This can be calculated by using a Cost Estimate, a resource applied to the Schedule Item, or both.

Alternatively the value can be built up exclusively from a Matrix Item assigned to the Schedule Item.

Note: This scenario is only available in Genesis Edition.

Excluded

This column identifies whether or not a schedule item has been excluded from project calculations and ultimately, from the project altogether.

Hidden

This column identifies whether or not a schedule item has been set to a hidden status.

Hidden Items are treated similarly to that of Overhead Cost Schedule items in that they contribute to the project but the item itself will be hidden from the client’s submission document.

Genesis and Express editions only.

Item Type

The Item Type column allows you to set how a Schedule Item contributes to the project.

If the Schedule Item has a quantity, then the item can have its Item Type set to either Contributing or Rate Only.

Item State

The Item State column identifies the current status of a Cost Schedule item.

These states can only be applied to Schedule items that have an Item Type of either Contributing or Rate Only.

Duration

The Duration column allows you to define a length of time that the item will take to complete.

The value entered within the Duration column will become the value of the automatic define #DUR, used within the Schedule Item’s Cost Estimate.

This column is typically used when the Cost Estimate of the Schedule Item is using a Time based Estimating mode.

Genesis edition only.

Duration Type

The Duration Type column allows you to define the period length that the Duration represents.

This can be Hour, Day, Week, Fortnight, Month, Quarter, Half Years or Years.

Genesis edition only.

Resource Type Rate

These are a series of columns, one for each resource type (Labour, Material, Plant, Subcontractor and Other) that display the cost per unit for their respective resource type.

Genesis and Express editions only.

Resource Type Total

These are a series of columns, one for each resource type (Labour, Material, Plant, Subcontractor and Other) that display the total cost for their respective resource type.

This value is based on the total resource usage value for an individual Resource Type defined by the item either through a Cost Estimate build up, resource applied directly to the item or Matrix Item.

Genesis and Express editions only.

Parent Line

If a Cost Schedule item has been indented below another Cost Schedule item, the Parent Line column will show the line number of its immediate parent Cost Schedule item.

Page Breaks

The Page Breaks column allows you to define locations in the Direct Cost Schedule to insert page breaks to be displayed in reports.

The reports where these Page Breaks will appear include:

Page Breaks will appear before the Direct Cost Schedule items they are allocated to.

Note: This property can be applied to all Direct Cost Schedule item types.

Anticipated Rate

The Anticipated Rate column is used to enter a user defined preliminary rate for the schedule item. The item needs to have a quantity in order to enter an anticipated rate.

Alternatively this value can also be calculated by dividing the Anticipated Total by the Quantity.

Anticipated Total

The Anticipated Total column is used to enter a user defined preliminary total for the schedule item. The item needs to have a quantity in order to enter an anticipated total.

Alternatively this value can also be calculated by multiplying the Anticipated Rate by the Quantity.

Resource Description

The Resource Description column displays the description of the resource that is assigned to the direct cost schedule item.

If no resource is assigned, then the column will be blank.

Resource Unit

The Resource Unit column displays the unit of the resource that is assigned to the direct cost schedule item.

If no resource is assigned, then the column will be blank.

Resource Type

The Resource Type column displays the resource type of the resource that is assigned to the direct cost schedule item.

If no resource is assigned, then the column will be blank.

Note: Additional User Defined Columns can be added from the Project Properties - Schedules window.

INFORMATION COLUMN ICONS

Depending on the status of an item, the Information column will display an icon to visually reflect information about the item.

ICON

DESCRIPTION

If a lock is displayed you cannot modify the Schedule Item due to it being edited by either yourself in another window or another concurrent user.

If a full green circle is displayed, this indicates the Schedule Item is a Contributing Item.

When a half green circle is displayed, this is an indication that the Schedule Item is Rate Only Item.

If a full yellow circle is shown, this indicates the Schedule Item is set to Hidden.

If a workman is displayed, this is an indication that the Schedule item is apart of a Subcontractor Comparison.

When a sigma symbol is displayed, this is an indication that the Schedule Item is using a summation formula.

When a notepad and pen is shown, this indicates that the Schedule Item contains a note or reference.

When a money bag icon is shown, this indicates that the Schedule Item has a Provisional Sum applied to it.

CHECK OUT THIS TIPS AND TRICKS VIDEO