Building Energy Management Systems and Baseline #4

Building energy management system using the data analysis features of Excel
After having production data and consumption of energy in your hand, then you must activate the feature "data analysis" on your Excel software.

Click data analysis then this menu will show up

Select Regression, then this menu will show up

If we want to create a baseline consumption of gas and evaluate the performance of reheating furnace of the consumption of natural gas, then input Y range in from this data

Input X range from X1 to X4. Click OK. It will appear in the new results sheet as follows:

Read Next :

BASELINE EVALUATION AND ANALYSIS
Read Previous :
How to develop baseline