Monthly meter budget worksheet

The monthly meter budget worksheet lets you update use, average unit cost, heating degree days, and cooling degree days by meter and month to adjust your budget as needed.  Only white columns should be updated, columns shaded gray should not be changed or updated.

If you need to make adjustments to floor area download the Monthly building budget worksheet.

After you've entered your updates, upload the worksheet into UtilityManagement to track your progress throughout the year with charts and reports

Worksheet columns

• Columns are grouped to let you easily show and hide the details of each section. When you hide all the details it's easy to see your overall budget without scrolling.
• Expand each section to see the previous use and cost and what the new use and costs are after you enter your changes.

Worksheet rows

• Rows are grouped at two levels, once by the meters for the building, and second by the months for each meter. 
• The topmost row in black, shows totals from all the buildings included in the spreadsheet.
• You can expand each building to see the attached meters. And expand each meter to see the details for each month.

Edit your budget

Enter the percent of change for each area. You can expand each group to see the impact of your changes.

• Use*
• Average unit cost*
• Heating Degree Day Changes
• Cooling Degree Day Changes

*Optionally, you can enter a value instead of a percent for New Monthly Use and New Average Unit Cost. 

Budget versions

You can create different versions for your budget to try out different scenarios, but only one version can be active at a time.

1. Copy the budget version to create a new one.
2. Download the worksheet and enter your changes.
3. Upload the worksheet to the corresponding version.
4. Update the active version as needed before running a report.
   
   

Meters with a charge but no use

There may be situations where a meter may have bills that include a cost but are not used in one or more months. This may occur for many reasons, including emergency service meters, off-season months, etc., when the meter did not observe any energy usage.

However, the energy provider may have fixed costs associated with the service that are charged monthly. In these cases, Utility Management does not calculate a unit cost. For budgeting purposes, the charges for the month are moved to the Other fixed costs/adjustments column.

While you adjust your budget, if this month is expected to have energy usage in the future, consider updating the New Monthly Use and the New Average Unit Cost columns for those months. Depending on your total cost, you may have to delete the Other fixed costs/adjustments column for this month to avoid double counting.

You may also want to review the bill to see if the charge should have been an account-level charge. Account-level charges are not included when creating your budget.

Upload your budget

Use the Excel icon picker to upload your updated budget file. The file version you upload must match the version you select in the application.

How to handle errors