Project Comparisons Report
      Back to home
      1. Success Hub
      2. Join Benchmarking
      3. Project Comparisons Report

      Creating a Project Comparisons Report

      Learn how to quickly utilize historical cost data to create a project comparison report

      Leveraging historical cost data from past projects is a challenge that most companies in the industry face because their information is often siloed or stored in different locations and formats (estimating platforms, spreadsheets, PDF reports, etc.). When all of your projects are entered into Join, the cost data is stored in a central location and is easily leveraged using the project comparisons report. The project comparisons report can be used to quickly create a new Milestone estimate or budget by averaging the $/UNIT costs of past projects and can be organized by any categorization.

      Included in Join Benchmarking

       

      Creating a Project Comparisons Report

      From the Benchmarking Page

      To create a Project Comparisons Report from the Benchmarking page, follow these steps:

      1. Navigate to the Benchmarking page
      2. Click the Explore subtab
      3. Sort and filter the list of projects and click the Add to compare check box next to all projects you want to add to the report
      4. Click the Create a comparison report button in the bottom right corner

      From the Reports Tab in a Project

      To create a project comparisons report within a project, follow these steps:

      1. While in a project, click on the Reports tab and expand the Built-in Reports section
      2. Click the Start Report button to the far right of the Project Comparisons section
      3. Sort and filter the list of projects and select the check boxes for all projects you want to add to the report
      4. Click the Create report button to create the report with the selected projects

      Display Settings

      The display settings are used to change how the cost data is displayed. In the Display Settings section, click on the drop-down list to select how direct costs and markups will be displayed in the report. This functions similarly to the display cost settings for a project in Join.

      Metrics

      In the Metrics section click the Settings button to select the Units of Measure to be used as the unit price ($/UNIT) for cost calculations and comparisons. You can select from any of the built-in Units of Measure or custom ones you've created for your projects. To change the Unit of Measure used in the calculations click the Pin button when hovering next to a Unit of Measure.

      Escalation

      The Escalation section can be used to adjust historical costs based on location and time. Escalation rates can be entered manually or automatically applied using Gordian's RSMeans Construction Cost Indexes. The Escalating Historical Costs article provides a detailed breakdown of how to correctly apply escalation factors to your data.

      Costs

      Selecting a Categorization

      Break down the costs of each project by a specific categorization. You can either select the categorization for each project using the drop-down menu in the column of each project or by clicking the Edit button in the Costs section and then selecting the categorization for each project in the menu that opens.

      Creating a Comparison Average

      After the projects have been added to a project comparisons report, a new average column can be added to help build a conceptual estimate for your project by following these steps:

      1. Click the Start a comparison average button in the top left of the report
      2. Rename the column based on your project or Milestone (optional)
      3. Upload an image and choose a color for the column by clicking the Options button in the top right corner of the column and selecting Customize
      4. Enter a quantity for the selected Units of Measure for the project and the total costs will be calculated based on the average $/UNIT of the comparable projects

      Tip: You can manually override the average $/UNIT or average Total for each row by clicking into the cell and editing the cost value. Cells that have been overridden will be indicated with a green dot. Clicking the green dot will allow you to reset the value back to the average or add a note explaining why it was changed.

      Saving a Report

      The project comparisons report can be saved and accessed at any time from the Reports page using the following steps:

      1. Click the Report button in the upper right-hand corner of the report
      2. Select Save as...
      3. Enter a report name (required) and a description (optional)
      4. Click the Save button

      Tip: If you make changes to a saved report, you will also have the option to select Save or Save a copy... during step #2.

      Sharing a Saved Report

      Once you’ve saved a Report, you can choose to share it with others from your company who also have access to Benchmarking. All shared users will have full edit access to the shared report.

      Share From the Benchmarking Reports Page

      To share a report from the Benchmarking Reports page, follow these steps:

      1. Navigate to Benchmarking > Reports
      2. Click the options  button to the right of the saved report
      3. Select Share report
      4. Click the check box next to each teammate you want to share the report with
      5. Click the Share button in the bottom right

      Share From the Project Comparison Report

      To share a report while editing a Project Comparison Report, follow these steps:

      1. Open a saved Project Comparison Report
      2. Click the Share button at the top of the report
      3. Click the check box next to each teammate you want to share the report with
      4. Click the Share button at the bottom right.

      Tip: You can remove a teammate from a saved report by following the same steps above and unchecking the box next to their name.

      How do I get access to Project Comparisons?

      If your company doesn’t have access to the Project Comparisons report then please reach out to your account manager or send an email to support@join.build. If your company has access but you don’t see it, then reach out to your company administrator and ask them to change your company role to Manager or above.