Excluding from Total in Cubit Estimating

Follow

Available in Cubit Estimating 9.1+

 

Exclude from Total is a feature that can be used in the Estimate sheet, Rate sheet, or Calculation sheet that enables you to exclude one or more selected Trade or Heading or Item from the Job Total.

Note: Any items marked as "Exclude from Total" will be displayed in Italics.

Exclude from the Total column

Use the column chooser to add the Exclude from total column to the Estimate, Rate, and/or Calculation sheet. This column can be checked to exclude the selected row(s) from its parent's total.

figure_1.PNG
Fig 1. Exclude single line

Exclude from the Total result type

In the Estimate sheet, there is a new Exclude from total result type. When a row's result type is set to Exclude from total it will be excluded from its parent's total.

If the "Exclude from Total" column is shown, any rows with the result type set to Exclude from total will be shown with the column check and it will not be possible to uncheck it.

figure_2.PNG
Fig 2. Exclude Result Type

Items and Headings marked with 'exclude from total' will not be exported to Microsoft Excel and not be included in Grouped Views, BoQ, or Bartender jobs.

A new Report Parameter has been added for default Cubit Estimating reports excluding these items from the report.

0 out of 0 found this helpful

Comments

4 comments
  • Theo, is this function in a new version? I'm using 9.0.3.0 and appears not in the column selections? Regards Grant

    0
    Comment actions Permalink
  • This feature is available in Cubit version 9.1, please monitor our website for a release date.

    0
    Comment actions Permalink
  • Hi Theo,
    When you exclude a line from the total, does it also exclude the quantity? For example, if you were to switch over to the Grouped Views tab, would the quantities also reflect the exclusion?

    0
    Comment actions Permalink
  • Hello Carlo,

    Exclude from total will remove the entire lines data (example Quantity, Rate, Total etc) from both the Estimate view and the Grouped view tabs.

    0
    Comment actions Permalink

Please sign in to leave a comment.