Spread Results - Grid Columns
Genesis edition only.
Each window within Expert Estimation has its own unique workspace layout. The following is a list of the available columns that information can be analysed within the Spread Results window.
Note: Spread Results window is read only and no data can be edited.
NAME |
DESCRIPTION |
---|---|
Line # |
The main identifier for a Direct Cost Schedule Item that is automatically numbered and cannot be modified. |
Item # |
A reference number that can be used to quickly identify the item, this can be supplied by the client to match internal records. |
Description |
Provides a detailed explanation of what the Direct Cost Schedule item is representing in the project. |
Formula |
The Formula column displays the formula applied to a Direct Cost Schedule item. |
Quantity |
The Quantity column displays the number of units required to complete the Direct Cost Schedule item. |
Unit |
The Unit column represents the Unit of measure for the Direct Cost Schedule item. |
Estimated Rate |
The Estimated Rate column shows the per unit rate of the Direct Cost 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 cost total of the Direct Cost Schedule item. This is calculated by using a Cost Estimate, a resource applied to the Schedule Item, or both. Alternatively, when using Genesis edition, the value can be built exclusively from a Matrix Item assigned to the Direct Cost Schedule item. |
Resource Type Total |
Provides a per Base Resource Type estimated total of the item. |
Hidden Item Spread |
The Hidden Item Spread displays the total amount of Hidden Direct Cost Schedule Items spread across each available item. Genesis and Express editions only. |
Overhead Spread |
The Overhead Spread displays the total amount of Overhead costs spread across each available item. |
Risk and Opportunities Spread |
The Risk and Opportunities Spread displays the total amount of Risk and Opportunities value spread across each available item. Genesis and Express editions only. |
Preadjustments Spread |
The Preadjustments Spread displays the total amount of Pre-margin adjustment value spread across each available item. Genesis and Express editions only. |
Margin Spread |
The Margin Spread displays the total amount of Margin value spread across each available item. |
Postadjustments Spread |
The Postadjustments Spread displays the total amount of Post-margin adjustment value spread across each available item. Genesis and Express editions only. |
Sell Rate |
The unit rate that the client will be charged for the item. This is calculated by dividing the Sell Total by the Item’s Quantity. This Rate is then rounded in accordance to the Sell Rate rounding rules set within the Spreading section of the Project Properties window. |
Sell Rate including Tax |
The unit rate that the client will be charged for the item including a Tax. This is calculated by applying the Tax percentage to the Sell Rate of the Item. |
Sell Total |
The total amount that the client will be charged for the item. This is calculated by multiplying the Sell Rate by the Quantity of the item. If the item is rate only the Sell Total column will be blank. |
Sell Total including Tax |
The total amount that the client will be charged for the item including a Tax. This is calculated by multiplying the Sell Total by the Tax percentage. |
Tax Amount |
The Tax Amount displays the total value of tax that has been applied to the item. A sales tax as well as the percentage it represents, can be set from the Tax Information section of the Project Properties. |
Effective Markup |
The percentage that the item has been marked up by. This is the percentage difference between the Estimated Total and the Sell Total. |
Resource Type Hidden Spread |
Provides a per Base Resource Type total of the Hidden Direct Cost Schedule Item value spread onto the item. Genesis and Express editions only. |
Resource Type Overhead Spread |
Provides a per Base Resource Type total of the Overhead Cost Schedule Item value spread onto the item. Genesis and Express editions only. |
Resource Type Risk and Opportunities Spread |
Provides a per Base Resource Type total of the Risk and Opportunities value spread onto the item. Genesis and Express editions only. |
Resource Type Preadjustments Spread |
Provides a per Base Resource Type total of the Pre-margin adjustment value spread onto the item. Genesis and Express editions only. |
Resource Type Margin Spread |
Provides a per Base Resource Type total of the Margin value spread onto the item. Genesis and Express editions only. |
Resource Type Postadjustments Spread |
Provides a per Base Resource Type total of the Post-margin adjustment value spread onto the item. Genesis and Express editions only. |
Resource Type Sell Total |
Provides a per Base Resource Type sell total of the item. |