The addition of Custom Functional Templates, allowing users to create their own metrics to effectively analyse the function of a wider variety of project types. With Version 1.7, it’s a simple process to create and store functional templates that are directly applicable to each organisation’s unique project analysis requirements.
System Administrators can create Custom Functional Templates by defining the Key Project Information and Functional Details required to be entered for each project, and the metrics derived from them that then appear in the Functional Information Summary. The ability to define the information entered, and the calculations applied to that information, means all manner of project metrics can be included in the Functional Information Summary. This data can be arranged in user-defined groupings to provide a clear insight into the functional costs and design aspects of each project.
What’s more, this customisable, user-defined template is utilised as the basis of Functional Benchmarking between projects, to provide relevant and actionable information for project managers. Notable project metrics can be easily displayed in pie chart format in a Functional Analysis Report by simply dragging and dropping the data selections as shown below.
This new functionality supports enterprises that deal in benchmarking and conceptual estimating for a wide scope of major project functions. Managers now have the option to select one of our 25 in-built System Templates such as Residential or Shopping Centre, or else build a custom template that suits the specific function of the development at hand.
The ability to import code libraries in Excel format to CostX®. Prior to Version 1.7, only CSV format was supported for importing code libraries to CostX® Benchmark. With this release, users will be able to select their preferred Excel file type for a smoother workflow.
Once the user has selected their chosen code library in the File Upload area, a preview of the data to be imported will display as shown below. From here, multi-level code libraries can be expanded or collapsed to verify data before the file is uploaded.
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.