运用Excel回归分析功能实现GB/T13234-2018《用能单位节能量计算方法》中的归一化操作

Using Excel Regression Analysis Function to Realize GBT13234-2018 Energy Saving Quantity Calculation Method of Energy Consuming Unit As Normalization Operation

GB/T13234-2018《用能单位节能量计算方法》作为节能量审核工作的权威依据,由国家市场监督管理总局、中国国家标准化管理委员会发布,于2019年4月1日正式实施。与前一版GB/T13234-2009《企业节能量计算方法》相比,它最重要的更新是提出了“归一化”的概念,提倡用建立回归分析模型的方法对能耗进行校准和修正。重点解读GB/T13234-2018《用能单位节能量计算方法》中“归一化”的相关内容,并示范运用Excel回归分析功能实现“归一化”操作的具体步骤。

GBT13234-2018 Energy Saving Quantity Calculation Method of Energy Consuming Unit is authority basis of energy conservation quantity examining and verifying work,which was issued by National Market Supervision Administration and National Standardization Administration Committee on 1st,April 2019.Compared to former edition,it puts forward normalization operation idea as crucial innovation,which suggests that building up regression analysis model method to calibrate and modify energy consumption.Reviewing GBT13234-2018 Energy Saving Quantity Calculation Method of Energy Consuming Unit and normalization operation relative contents,the author demonstrates details steps to use Excel regression analysis function to realize normalization operation.