Advanced Conversions
Use this spreadsheet to create advanced conversions between commodities and units.
Setup spreadsheets save time and let you create multiple items at once.
- The menu displays spreadsheets matching your permissions.
- Always download a new spreadsheet before you begin adding data because the spreadsheet is populated with information from your database.
- To avoid errors when creating different objects refer to the required upload order.
- To save time when creating many objects, select from the drop-down menu and then copy and paste the value into the other rows.
Format rules
- Enter all information as text or dates.
- You can add sheets to the notebook, UtilityManagement only processes the sheet named DataEntry.
- Do not rename, remove, 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. |