Advanced Conversions

What it's for

Use the Advanced Conversions spreadsheet to:

  • Create conversions between commodities and units
  • Convert
    • From one unit to another within the same commodity.
    • From one commodity/unit category to another.
    • View all system commodities and the multiplier that is used to convert the commodity.

Limitations

  • ❌You cannot create conversions for the Temperature unit category.

Spreadsheet details

  • Each column header includes help text in the row just below.
  • Required fields are clearly marked.
  • Format matters: make sure each row is complete and follows the expected format.

What happens on upload

  • Only rows without errors are processed
  • If there are issues:
    • You'll get an error file with messages for each row.
    • Cells with problems will be highlighted in red.

Setup Spreadsheets Overview

Setup spreadsheets help you save time by creating multiple items at once.

  • The menu shows only spreadsheets you have permission to use.
  • Always download a new spreadsheet before adding data—it’s populated with information from your database.
  • Follow the required upload order when creating related objects to avoid errors.
  • To save time, select a value from the drop-down and copy it into other rows as needed.

Formatting Rules

  • Enter all information as text or dates.
  • Only the sheet named DataEntry is processed—you can add other sheets, but they are ignored.
  • Do not rename, delete, or rearrange columns.

Spreadsheet columns

Column Rules
Error

Read-only field
Conversion key Read-only field
Commodity name (From) Select a commodity from the list that you want to create a new conversion for.
Unit category (From) Select the new unit category
Unit (From) Select the unit of measure.
Commodity name (To) Select the commodity you want to convert to
Unit category (To) Select the unit category you want to use for this conversion
Unit (To) Select the unit for the conversion
Multiplier Enter the multiplier to convert the unit of your commodity to another unit. For example, 1 KWh of electricity x 0.003421  = 1 MMBtu
Effective date An optional field. Enter the effective date for this conversion.
Delete Select delete from the menu to delete the conversion or a version.