Energy saving registration form

Energy saving registration formIt refers to analyzing and evaluating whether the energy utilization of investment projects is scientific and reasonable in accordance with energy conservation regulations and standards, and preparing energy conservation assessment documents or filling out energy conservation registration forms. The free download of the energy-saving registration form is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more information about the free download of the energy-saving registration form, please pay attention to Huajun Software Park.

Introduction to energy saving registration form ​​​Energy saving registration formContent list:​​​
​ ​ ①According to the project energy use plan, summarize the production process, power, construction, water supply and drainage, heating, ventilation and air conditioning, lighting, control, electrical and other aspects.
②Analyze the feasibility and rationality of energy-saving technical measures.

General tips for energy saving registration forms

​1: How to sum text
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
​​ Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
              Press the key combination to complete.
​ ​ 2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
​ ​ Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
​ ​ 3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
​​Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)

Recommended by the editor of Huajun Software Park