Overhead Cost Schedule – Grid Columns

Each window within Expert Estimation has its own unique workspace layout. The following displays a list of the available columns available within the Overhead Cost Schedule window.

NAME

DESCRIPTION

Line #

The main identifier for an item that is automatically numbered by the application and cannot be modified.

Information ()

The Information column displays specific information about Schedule Items through the use of icons.

A tooltip will appear providing you with a description of the icon displayed when the mouse cursor hovers over any of the icons within the Information column.

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 keyboard shortcut Ctrl + Space within this field, will provide you with a list of available formula that can be applied to the item.

Quantity

Represents the number of units 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 columns 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 required a build up using a Cost Estimate.

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.

Excluded

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

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 are either Contributing or Rate Only.

Items with quantities can have an item state of Unfinished, Checked or Finished.

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.

This column is typically used when the item’s Cost Estimate 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

Columns representing each resource type, displaying the cost per unit for each base resource type (Labour, Material, Plant, Subcontractor or Other) per item.

Genesis and Express editions only.

Resource Type Total

Columns representing each resource type (Labour, Material, Plant, Subcontractor and Other), displaying 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 Overhead 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 Overhead Cost Schedule items they are allocated to.

Note: This property can be applied to all Overhead 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.

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

INFORMATION COLUMN ICONS

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

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.

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.

CHECK OUT THIS TIPS AND TRICKS VIDEO