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. |
Resource Description |
The Resource Description column displays the description of the resource that is assigned to the overhead 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 overhead 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 overhead 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 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. |