Update custom building benchmarks with an spreadsheet

This spreadsheet is a special type of setup spreadsheet that lets you create, update, or delete ALL with one file.

When you download the create spreadsheet all the columns are empty. When you download an update spreadsheet, it is the same format populated with the information from your database.

After the custom benchmarks are created you can use the spreadsheet to manage the values.

Download the update spreadsheet

The drop-down menu lists spreadsheets matching your permissions.

  1. From the Setup Spreadsheets Log, click Download.
  2. Under Update, choose Custom Benchmarks.
  3. Choose the custom building benchmark to modify.
  4. Download the spreadsheet.
  5. Name format is yyyymmdd-UPDATE_PlaceBenchmarks.xlsx.
  6. Edit your information and save.
  7. Use Import to upload your spreadsheet.
  8. The Setup Spreadsheets Log reports the results and any errors. You can download the error (kickout) spreadsheet from the hyperlink, fix any errors, and upload the error sheet.
Available update columns are listed below.
Column Rule
Building Code Choose the building from the drop-down.
Effective Month/Period Enter the period when this value becomes effective.
Effective Year Enter the the year when this value becomes effective.
Benchmark Value Set the value for the custom benchmark.