The ability to exclude rows for all selected historical estimates, allowing users to quickly eliminate items or groups in the estimate that are not applicable to the current project. With Version 1.6, CostX® Benchmark users can simply click on a row to exclude it from the calculations and associated reports, or click on an excluded row again to reinstate it.
In the above example, the red highlighted section shows that Demolition has been excluded, and all values are displayed with a strikethrough to indicate they will not be included in the totals.
Parent group rows are also highlighted, making it easy to identify which groups contain excluded child rows even when groups are collapsed. If all child rows are excluded the parent group row displays in red, but if only some child rows are excluded and some are not, then the group row is shown in pink.
The option to exclude individual cells from benchmark calculations, ensuring that abnormal items for particular projects or cells with zero values do not impact the calculation of averages.
As with excluding rows, the chosen cell will be highlighted in red and the value displayed with a strikethrough.
Once a cell is clicked it becomes excluded, and the benchmark cost is instantly recalculated without that cell’s value contributing to the average. If the cell in question also contains child cells, these will be excluded as well.
A new Aged Care template for use when creating a Functional Analysis. Aged Care is a rapidly-growing sector in many countries worldwide so, in addition to the twenty-five pre-existing purpose-built templates for analysing different project types, CostX Benchmark 1.6 incorporates a further Aged Care functional template.
To select the Aged Care template, simply navigate to the Key Project Information section and choose Aged Care from the Template Type drop-down list.
The ability to visualise Functional Benchmarks in Chart format, with a variety of display options available according to user preference. Benchmark users can configure their outputs in several ways, with columns, grouping and included values able to be altered as shown below.
Complex charts can even be filtered to show or hide chosen subsets. In the example below, the bar demonstrating Common Area/Tenant has been removed after clicking on the correspondent legend entry.
Users can also change the value of the y-axis as required, pan a chart horizontally or vertically to alter the graphical output, or magnify certain areas for greater clarity. Completed charts can be downloaded as an image for use in client presentations or for easy future reference.
Bulk import of client lists in CSV format is now supported, allowing users to input client data much more quickly than was previously possible.
Bulk lists can be imported seamlessly through CSV format, with information able to be previewed for accuracy before the upload is completed. Users can upload new data in this format, or else overwrite older data after viewing and comparing existing and current client data side-by-side, as shown below.
Values for List Type Attributes can now be bulk imported in CSV format, supporting the efficient input of large value lists. This feature helps users get their initial configuration setup done very quickly, with configuration information even able to be migrated from other systems using the import.
Existing values can also be updated by way of bulk import, with users only needing to add a separate column to their CSV spreadsheet that identifies values that already appear in the CostX® Benchmark database. It is possible to insert new values and update existing values within a single CSV import.
Users can check a preview of all attribute values to confirm accuracy before completing the import, as demonstrated below.
Added ability to make multiple selections when conducting an Advanced Search within an Estimates list. Users are now able to apply multiple Category A and Category B selections to Advanced Search parameters, allowing users to more effectively filter results based on a chosen range of attributes. As an example, users can now filter for estimates from the categories School, College and University in a single search, rather than separately as before.
Project Volume within Power BI
Index Factors within Tableau.