The Bill Viewer page lists the bills that have been calculated in Energy Analysis. The information from these bills is used for graphing kW, kWh, etc. for a monthly comparison of up to two years of data.
1. Click on the View button of a recent bill. This will be the last month displayed for the 12 month graph.
1. Click on the Bill Determinants button
· The Print button will print the bill that is displayed.
· The Back button will return you to the previous screen.
2. Select the determinants that you wish to compare
· The following lists many of the determinants that are available for graphing for electric rates. Determinants will vary by rate. The name of the determinant (such as Total On Peak KWH), the unit (such as kW, kWh, etc.), and the value of that determinant are listed.
o Cust Max Demand, Adj CM Demand or Adj Max Demand refer to the Customer Maximum Demand
o OnPeakDemand, Billing Demand or Adj Max OP Demand refer to the on peak demand that has been adjusted for power factor.
o TotalEnergy refers to the sum of the on peak and the off peak kWhs.
o Total Off Peak KWH
o Total On Peak KWH
o Power Factor
o Reg Bill Total is the dollar amount of the pro forma bill calculated on a monthly basis. This does not include taxes, additional meter charges etc. This is NOT the amount of your actual bill.
o Curtailment Credit is the estimated credit for being on a curtailable rate. This is NOT the amount on your bill.
3. For each determinant that you have checked, select a different color by clicking on the arrow and selecting a color.
4. Click the Graph button.
5. A line graph of the selected determinants is displayed. The data will go display for 12 months, going backwards from the month that you selected on the Bill Viewer screen.
6. To change the time period on the graph, use the arrows as follows:
· << Back one year
· < Back one month
· > Forward one month
· >> Forward one year
· Or, use the drop down arrows to select a different month and/or year
· When you change the time period, click the Refresh button to update the data.
7. Graphs may be displayed as a Line or a Bar graph.
· When you change the graph type, click the Refresh button to update the data.
· Select the Download button for an Excel spreadsheet of the numbers used to create the graph.
8. The following is an example of the graph data downloaded to an Excel spreadsheet.
9. To view two years of data, select Frozen and Clone for the determinant(s) that you wish to graph.
10. Select the time period that you wish to compare. For example, go back one year. Do this by changing the year from 2008 to 2007 or using the << Button.
· Select the Refresh button to refresh the data.
· The following is an example of a comparison showing data starting Dec 2008 (black and red lines, frozen data) to data starting December 2007 (yellow and green line, time period that you selected).
TIP: A flat line at the bottom of the graph indicates that no data points are available for the graph.
11. Use the Download button to obtain an Excel spreadsheet with data for both years.
· The black arrows point to the columns with the frozen data for Jan 2008 through Dec 2008. Note the “(F)” in the column description. You may wish to add a column with the dates for the “frozen” data to make the data easier to understand.
· The Bill Month description is for the data that was not frozen.