Create rate schedules with a spreadsheet

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.

Download the rate setup create spreadsheet

On the Create page, click Setup Spreadsheets.

  1. From the Setup Spreadsheets Log, click Downlaod.
  2. Under Create Spreadsheet, choose Rate Schedules.
  3. Download the spreadsheet.
  4. The name format is yyyymmdd-CREATE_RateSchedules.xlsx.
  5. Add your information and save.
  6. Use Import to upload your spreadsheet.
  7. The Setup Spreadsheets Log reports the results and any errors. You can download the kickout (errors) spreadsheet from the hyperlink, fix any errors, and upload the error sheet.

Permissions

The ability to create objects is determined by user role and any limits placed on the user's topmost place or topmost cost center.

Prerequisites

Before creating a rate schedule the vendor must exist.

Upload order for objects when using spreadsheets

Upload setup spreadsheets in the following order.

For example, if you want to create a meter,  search to find the vendor, rate schedule, and building. If these items already exist, create the account and meter. If not, you need to create the vendor, rate schedule, and building (in that order) and then the account and meter.

  1. Vendors
  2. Rates
  3. Organizations and Buildings
  4. Cost Centers
  5. Accounts and Meters

Create rate schedules spreadsheet details

Column Rules

Vendor Code

Choose the vendor from the drop-down. The vendor must be created before you can create the rate schedule.

Commodity Name

Choose from the drop-down.

Rate Schedule

Enter the name of the rate schedule used by the vendor.

 

Allowed characters for codes

  1. A-Z, no lower case letters
  2. 0-9
  3. &
  4. _
  5. /
  6. -

Example 

example spreadsheet