European Energy Management Specialist Training for SMEs

MODULE-4
Excel tool and samples
1
Context
2
1. ENMs Program
3
Standarts
Energy
Performance
and
Measurements
1. ENMs Program
4
 
Energy consumption
must first be measurable
and recorded.
 
E
nergy consumption
must first be measurable
and recorded.
Energy consumption is
related to performance
for processes and is
analyzed based on
efficiency.
 
Measuring energy
consumption for each
source is the first step in
process analysis and
evaluation of energy
efficiency performance.
 
Measuring, analyzing or
monitoring energy in
businesses should serve a
purpose. In this context,
the assessment defines
the effectiveness of
energy management.
 
ENMS
 
Program
 
1. ENMS
5
1. ENMs Program
6
2. 
EnMs P
r
ocedures
7
 
Preparation  and Commitment
Task
8
Preparation  and Commitment
Task
What is required?
 
1. ENMS
9
10
 
Preparation  and Commitment
 
Task
 
Frequency of the task
11
 
Preparation  and Commitment
 
Task
 
Relevant documentation
12
 
Preparation  and Commitment
 
Task
 
Communication
13
 
Planning
14
 
Operating
 
Promote energy
awareness
 
Implement
training
 
Internal
Communication
 
External
Communication
 
Document
Control
 
Operational
Control
s
 
Energy Efficient
Design
 
Procurement
s
Operational 
Control
s
Procurement
s
Critical Operating Parameters
Description.
 
Tasks
15
 
Checking
 
Excel Tool
16
 
1. ENMS
17
 
Example of Roles and Resposibilities
18
 
 Example of Scope
19
 
Boundaries;  
physical or site limits and/or organisational limits as defined by the organisation
 
 Example of Boundaries
20
Boundaries;  
physical or site limits and/or organisational limits as defined by the organisation
 
 Example of SEUs
21
 
 Example of SEUs
22
 
Operational Control
23
 
Operational Control
24
 
Opportunities List
25
 
4. Quiz
26
 
Which of the variable does not contribute to energy consumption?
 
a)
Production
 
b) Hours
 
 
c) Climate
 
d) none of the above
Y
N
Y
N
Y
N
Y
N
 
4. Quiz
27
 
What do you mean by “toe”
 
a)
Total oil equivalent
 
b) Tons of effluent
 
 
c) 
Tons of oil equivalent
 
d) none of the above
Y
N
Y
N
Y
N
Y
N
 
4. Quiz
28
 
Which of the variable does not contribute to energy consumption?
 
a)
Production
 
b) Hours
 
 
c) Climate
 
d) none of the above
Y
N
Y
N
Y
N
Y
N
 
4. Quiz
29
 
Which are the two important attributes for Electrical Efficiency of  AC Induction motors
 
a)
Voltage and Current
 
b) Hertz and THD
 
 
c) Efficiency and Resistance
 
d) Efficiency and Power Factor
Y
N
Y
N
Y
N
Y
N
 
4. Quiz
30
 
The characteristic of a positive displacement compressor for a given speed is
 
a)
Temperature remains constant
 
b) 
Flow output remains constant
 
 
c) Pressure remains constant
 
d) Compression ratio remains constant
Y
N
Y
N
Y
N
Y
N
 
4. Quiz
31
 
Which of  the following is used to represent energy balance of a system?
 
a)
Sankey Diagram
 
b) Flow Chart
 
 
c) Single line Diagram
 
d) Block Diagram
Y
N
Y
N
Y
N
Y
N
Congragulation
…………………….
……………………….
…………………………
………………………….
32
Slide Note

This section contains the Excel tool and sample studies related to it. In this context, the basic application structure of the management system will be implemented through this developed excel tool. For this reason, as an important stage of the training, Excel tool will be applied page by page. Please press the Start button.

Embed
Share

Explore Module 4 of the E-Learning program focusing on Excel tools, ISO standards, energy consumption analysis, and interdisciplinary energy management. Dive into EnMs procedures, energy performance measurement, and the development of energy policies for effective energy management within organizations.

  • Energy Management
  • SMEs
  • Training
  • ISO Standards
  • Excel Tools

Uploaded on Apr 05, 2024 | 7 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

E N D

Presentation Transcript


  1. E-Learning Home MODULE-4 Excel tool and samples Start European Energy Management Specialist for SMEs TREY research 1

  2. Module -4 E-Learning Home Context ENMs Program EnMs Procedures Excel tool Excel applications Quiz European Energy Management Specialist for SMEs TREY research 2

  3. 1. ENMs Program Module -4 E-Learning Home ISO 14044 specifies requirements and provides guidelines for life cycle assessment (LCA) including: definition of the goal and scope ISO 9001 is defined as the international standard that specifies requirements for a quality management system of the LCA EN16001 Energy Management Standard Looks at the implementation and development of Energy Management Systems within an organisation. Energy Performance and Measurements Standarts ISO14001 is the international standard that specifies requirements for an effective environmental management system (EMS) European Energy Management Specialist for SMEs TREY research 3

  4. 1. ENMs Program Module -4 E-Learning Home Energy consumption must first be measurable and recorded. Energy consumption is related to performance for processes and is analyzed based on Measuring energy consumption for each source is the first step in process analysis and evaluation of energy efficiency performance. Measuring, analyzing or monitoring energy in businesses should serve a purpose. In this context, the assessment defines the effectiveness of energy management. Energy consumption must first be measurable and recorded. Process analysis efficiency. Monitoring ENMS Energy consumptions Evaluation and revision Program European Energy Management Specialist for SMEs TREY research 4

  5. 1. ENMS Module 4 E-Learning Home The need to develop interdisciplinary energy managers is a priority Yes No European Energy Management Specialist for SMEs TREY research 5

  6. Module -4 E-Learning Home 1. ENMs Program European Energy Management Specialist for SMEs TREY research 6

  7. 2. EnMsProcedures Module -4 E-Learning Home Preparation and Commitment Participate in management review Task Define scope and boundaries of the EnMS Review/Appro ve the energy policy Manage roles and responsibilitie s Consider energy performance in long term planning Develop the energy policy Set objectives and targets European Energy Management Specialist for SMEs TREY research 7

  8. Module -4 E-Learning Home Preparation and Commitment What is required? Task "Scope: what energy sources and uses are included. Define scope and boundaries of the EnMS Boundaries: what parts of the organisationare included" Ensure that relevant personnel understand their roles, responsibility and authority and are resourced and supported in their roles in the EnMSimplementation Develop and periodically review the energy policy document Manage roles and responsibilities Develop the energy policy Review and approve the policy document Review/Approve the energy policy Participate in management review Attend the management review meeting Ensure that energy performance is con- sidered in long term and strategic planning Consider energy performance in long term planning Based on available opportunities but aligned with relevant commitments Set objectives and targets European Energy Management Specialist for SMEs TREY research 8

  9. 1. ENMS Module -4 E-Learning Home Developing behavior culture is the primary target of the EnMs program Yes No European Energy Management Specialist for SMEs TREY research 9

  10. Preparation and Commitment Module -4 E-Learning Home Task Frequency of the task Review annually Define scope and boundaries of the EnMS Continuously Manage roles and responsibilities Review annually prior to management review Annually Develop the energy policy Review/Approve the energy policy Participate in management review Annually As required Consider energy performance in long term planning Annually Set objectives and targets European Energy Management Specialist for SMEs TREY research 10

  11. Preparation and Commitment Module -4 E-Learning Home Task Relevant documentation Define scope and boundaries of the EnMS Scope worksheet Manage roles and responsibilities Management approved document Develop the energy policy Policy worksheet Review/Approve the energy policy Participate in management review Energy Policy Presentation and minutes Consider energy performance in long term planning Energy Strategy Set objectives and targets European Energy Management Specialist for SMEs TREY research 11

  12. Preparation and Commitment Module -4 E-Learning Home Task Communication Energy Team Define scope and boundaries of the EnMS All affected staff and contractors Manage roles and responsibilities As appropriate Develop the energy policy All staff and contractors Review/Approve the energy policy Participate in management review Energy Team and top management team Energy Team, project management team Consider energy performance in long term planning Top mangement and energy team Set objectives and targets European Energy Management Specialist for SMEs TREY research 12

  13. Planning Module -4 E-Learning Home Relevant documentation Task What is required? Frequency of the task Communication Identify and document all legal and other requirements applicable to the organisation's use of energy Legal and other requirements Quarterly Legal worksheet Energy Team Complete the energy review steps (ER1 to ER8) Complete all the steps in the energy review process Annually ER worksheets Energy Team European Energy Management Specialist for SMEs TREY research 13

  14. Operating Module -4 E-Learning Home Tasks Procurements Operational Controls Energy Efficient Design Document Control Internal Communication External Communication Promote energy awareness Implement training Operational Controls Procurements Operation of SEUs Maintenance of SEUs Energy Equipment Critical Operating Parameters Description. European Energy Management Specialist for SMEs TREY research 14

  15. Checking Module -4 E-Learning Home Relevant documentation Task What is required? Frequency of the task Communication Monitor and take action related to energy bills, EnPIs and other energy metrics Schedule and organise internal audits of the EnMS Bills, EnPIs, EnPI worksheet, etc. Monitor energy metrics Continuously Internal audit work- sheet, records and corrective actions Internal Audits Quarterly As appropriate Ensure that all action and training plan items are progressing according to plan Action plan progress, ER8 Opportunities List worksheet Review action plan progress Monthly As appropriate Review maintenance and operational records and operating parameters Operation and mainteinance records Operation and main- tenance staff Monitor operational control Continuously Manage corrective and preventive actions related to the EnMS. These include deviations from plans, EnPIs and 2ND or 3rd party audit findings, etc. Non-conformity worksheet Manage non-conformities Continuously As appropriate European Energy Management Specialist for SMEs TREY research 15

  16. Excel Tool Module -4 E-Learning Home UNIDO EnMS Tools.xls Self-assessment ER6 Maintenance Criteria Roles and Resp. (Key Concept #1) ER6 Critical Op Param Scope ER7 Technical Audits Policy ER8 Opportunities List (KC #4) ER1 Data Training ER2 Trends Documents ER3 SEU List (KC # 2) Op Cont (KC #5) ER3 SEU - Motors Procurement ER3 SEU - Heat Users Design ER3 SEU - Lighting Non-conformities ER4 Drivers Legal Internal Audits ER5 EnPIs (KC # 3) ER5 Measurement Plan European Energy Management Specialist for SMEs TREY research 16

  17. 1. ENMS Module -4 E-Learning Home Maintenance of SEUs is the criteria evaluated for process Procurement processes. Yes No European Energy Management Specialist for SMEs TREY research 17

  18. Example of Roles and Resposibilities Module -4 E-Learning Home European Energy Management Specialist for SMEs TREY research 18

  19. Example of Scope Module -4 E-Learning Home Boundaries; physical or site limits and/or organisational limits as defined by the organisation European Energy Management Specialist for SMEs TREY research 19

  20. Example of Boundaries Module -4 E-Learning Home Boundaries; physical or site limits and/or organisational limits as defined by the organisation European Energy Management Specialist for SMEs TREY research 20

  21. Example of SEUs Module -4 E-Learning Home European Energy Management Specialist for SMEs TREY research 21

  22. Example of SEUs Module -4 E-Learning Home European Energy Management Specialist for SMEs TREY research 22

  23. Operational Control Module -4 E-Learning Home European Energy Management Specialist for SMEs TREY research 23

  24. Operational Control Module -4 E-Learning Home European Energy Management Specialist for SMEs TREY research 24

  25. Opportunities List Module -4 E-Learning Home SO 50001 : It requires the organisation to consider energy performance improvement opportunities and operational control in the design of facilities, equipment, systems and processes that can have a significant impact on its energy performance European Energy Management Specialist for SMEs TREY research 25

  26. Module -4 E-Learning Home 4. Quiz Which of the variable does not contribute to energy consumption? a) Production Y N b) Hours Y N c) Climate Y N d) none of the above Y N European Energy Management Specialist for SMEs TREY research 26

  27. Module -4 E-Learning Home 4. Quiz What do you mean by toe Y N a) Total oil equivalent b) Tons of effluent Y N c) Tons of oil equivalent Y N d) none of the above Y N European Energy Management Specialist for SMEs TREY research 27

  28. Module -4 E-Learning Home 4. Quiz Which of the variable does not contribute to energy consumption? a) Production Y N b) Hours Y N c) Climate Y N d) none of the above Y N European Energy Management Specialist for SMEs TREY research 28

  29. Module -4 E-Learning Home 4. Quiz Which are the two important attributes for Electrical Efficiency of AC Induction motors a) Voltage and Current Y N b) Hertz and THD Y N c) Efficiency and Resistance Y N d) Efficiency and Power Factor Y N European Energy Management Specialist for SMEs TREY research 29

  30. Module -4 E-Learning Home 4. Quiz The characteristic of a positive displacement compressor for a given speed is a) Temperature remains constant Y N b) Flow output remains constant Y N c) Pressure remains constant Y N d) Compression ratio remains constant Y N European Energy Management Specialist for SMEs TREY research 30

  31. Module -4 E-Learning Home 4. Quiz Which of the following is used to represent energy balance of a system? a) Sankey Diagram Y N b) Flow Chart Y N c) Single line Diagram Y N d) Block Diagram Y N European Energy Management Specialist for SMEs TREY research 31

  32. Home E-Learning Modules Congragulation . . . European Energy Management Specialist for SMEs TREY research 32

More Related Content

giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#