Advanced Conversions
Use this spreadsheet to create advanced conversions between commodities and units.
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. |