Transcript The Industrial Facilities Quick PEP Test Excel File Michael MacDonald

The Industrial Facilities
Quick PEP Test Excel File
Michael MacDonald
Background and How to Use
June 2008
Intent
 Scorecard in
Quick PEP
 Industrial
Facilities
 Quick-cut
analysis of rough
range of possible
savings from
buildings
measures
Quick PEP Step 8
Step 8 — Energy Savings Opportunities
2
Download the Excel file:
http://eber.ed.ornl.gov/indtest/
3
Excel file simulates Quick PEP
 Users of Quick PEP will handle data at
different steps, e.g., energy use input
 Score Cards are at Step 8 of Quick PEP
 Calculations in Quick PEP will be invisible
to users, but the Excel file is meant to
allow testers to see what is happening
4
Opening sheet of Excel file
Facilities Score Card test tool, ver 1.0b
This Score Card is being developed for implementation in Quick PEP, Step 8
For info on Quick PEP, go to the Best Practices website, Software Tools, first item
ver test-1.0b
4/29/2008
This test tool is intended to add capabilities for a rough, quick assessment of energy used by
buildings at a plant, and gives a quick assessment of energy measures that can be considered for
further investigation.
Go to the "How-To" Sheet (next sheet) to read directions on how
to use this test Score Card
5
Second sheet is How-to
Quick PEP
Step 8 - Energy Savings Opportunities
Facilities Energy Score Card test version 1.0b
How to Use this test tool
STEP
0 Go to the RESULTS sheet, Part 3, to see the example savings estimates
A
Go to next sheet, PctFac, Part 1:
1. Enter industry fraction(s) in column G,use "Other" if needed
The total in cell G33 should equal 100%
2. If cell D16 is zero, then the value in cell D15 will be used in D19
3. If cell D16 is NOT zero, then the value in cell D16 will be used in D19
4. Only change values in G7:G31 or D16; do not change any other cells
6
Step 0: Go to the RESULTS sheet, Part
3, to see the example savings estimates
Quick PEP
Part 3
RESULTS
Facilities Energy Score Card test version 1.0b
REVIEW these as necessary on other sheets
>> DO NOT CHANGE THESE VALUES HERE <<
Estimated Percent of TOTAL Plant Energy that might be saved
SAVINGS ESTIMATES
= A/100 x C x D
Electricity
Fuel/Steam
percent
Facilities Energy System
Envelopes
0.15%
0.50%
Lighting
2.84%
0.00%
Space Conditioning
1.11%
2.60%
Ventilation
0.00%
0.00%
Miscellaneous (incl hot water)
0.00%
0.42%
TOTAL
4.1%
3.5%
Quick PEP users will enter total electricity use and fuel/steam use prior to using a Score Card
Thus, this test Score Card can only show percentages of the total energy to be entered
7
Quick PEP
Part 3
RESULTS
Facilities Energy Score Card test version 1.0b
REVIEW these as necessary on other sheets
>> DO NOT CHANGE THESE VALUES HERE <<
NAME of sheet to review --->
PctFac
PERCENT of total plant site energy that is for facilties:
28.00%
NAME of sheet to review --->
Scorecard
end-use
A
B
Facilities Energy System
Scorecard
Score out of
100
End-Use Breakout of
Facilities Energy
Electricity
Envelopes
Lighting
Space Conditioning
Ventilation
Miscellaneous (incl hot water)
TOTAL
Fuel/Steam
D
C
Maximum Pct Facilities
Energy that can be saved
Electricity
Fuel/Steam
35
5%
17%
2%
5%
56
30%
0%
18%
0%
26
30%
70%
15%
35%
0
20%
10%
6%
3%
50
15%
3%
0%
3%
100%
100%
41%
46%
Estimated Percent of TOTAL Plant Energy that might be saved
SAVINGS ESTIMATES
= A/100 x C x D
Electricity
Fuel/Steam
percent
Facilities Energy System
Envelopes
0.15%
0.50%
Lighting
2.84%
0.00%
Space Conditioning
1.11%
2.60%
Ventilation
0.00%
0.00%
Miscellaneous (incl hot water)
0.00%
0.42%
TOTAL
4.1%
3.5%
Quick PEP users will enter total electricity use and fuel/steam use prior to using a Score Card
Thus, this test Score Card can only show percentages of the total energy to be entered
8
Step A: Go to
next sheet, PctFac, Part 1
Quick PEP
Part 1
Percent Facilities Energy --------------->>>>
Facilities Energy Score Card test version 1.0b
Facilities energy is only a fraction of total energy use
at industrial sites, sometimes small and sometimes large.
The defaults shown at the right are what Quick PEP assumes
for specific industries, but you can set the actual percent here:
#2
CHANGE the percent, item 'b' below if needed
Setting the percent of energy used by facilities
If you set a percent other than zero in 'b' it will be used instead:
a. Current default percent =
10.10%
b. Percent to use instead =
28.00%
The percent value here will be used [do not change this ]
c. Percent that will be used =
28.00%
#1
\/
SELECT
Industry
Fractions
0
0
0
0
0
0
0
0.3
0
0
0.7
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Default Quick PEP Industry Facilities Energy
Industry
% of total that is facilities energy
Ag, Forestry, Fishing
16%
Chemical
8%
Aluminum / Alumina
3%
Cement
0%
Computers, Elec, Appl
40%
EAF Steel
8%
Fab Metal Prod
19%
Food, Bev, tobacco
15%
Foundries
15%
Furniture and related
16%
Glass and glass products
8%
Heavy machinery
35%
Integrated Steel
7%
Mining (except oil and gas)
0%
Non-metallic mineral products
16%
Oil and Gas extraction
16%
Petroleum and Gas products
16%
Petroleum Refining
8%
Plastic and Rubber products
16%
Primary Metals
16%
Printing, Pub, allied
16%
Textiles, Apparel, Leather Goods
22%
Transportation equipment
29%
Wood products, Pulp, Paper
7%
Other
16%
100.00% Industry fractions should add to 100%.
9
Energy Percents
 Excel file simulates
calculations using
percentages
 Percents cascade
from total plant to end
uses to ECM savings
 Electric is separate
from fuel/steam
 Simplified single
percent of total plant
energy that is
facilities-related
 End-use breakout
percents for electric
and fuel/steam
 Technical savings
percents by end-use
for electric and
fuel/steam
10
How-to Steps B-E
B
Go to the sheet after that, end-use, Part 2:
1. You may not need to change anything on this sheet
2. If you need to change some values, change in the columns specified
The sums in row 20 should not be changed
The sums shown in row 20 should equal 100%
3. Only change values in B15:E19; do not change any other cells
C
Go to the sheet after that, RESULTS, Part 3:
1. Make sure cell D7 is the same as cell D19 in Sheet "PctFac"
2. Make sure the values in rows 12-16 match the data in rows 15-19 in Sheet end-use
"end-use" columns B and C should match "RESULTS" columns C and D
"end-use" columns F and G should match "RESULTS" columns E and F
3. Do not change any cells on this sheet
D
Go to the "Scorecard" sheet, Part 4,
Fill out or change the scorecard values according to your assessment of the plant or building
The assessment must cover the facilities included in the total energy data entered in Quick PEP
Do not change any TOTALS on this sheet; only enter responses in column D
E
Return to the RESULTS sheet, Part 3, to see the savings estimates
11
Step B: Go to the sheet after that, enduse, Part 2: can modify yellow cells
Percent of Facility energy
Facility End-Use
Envelopes
Lighting
Space Conditioning
Ventilation
Miscellaneous
SUM
Max percent savings
considered achievable
Max percent Result for
Facilities Energy
Column 'B'
Column 'C'
Column 'D'
Column 'E'
Column 'F'
Column 'G'
Electricity
(%)
Fuel/Steam
(%)
Electricity
(%)
Fuel/Steam
(%)
Electricity
(%)
Fuel/Steam
(%)
5%
30%
30%
20%
15%
100%
17%
0%
70%
10%
3%
100%
30%
60%
50%
30%
0%
30%
0%
50%
30%
100%
2%
18%
15%
6%
0%
41%
5%
0%
35%
3%
3%
46%
The sum of columns B and C should be 100%
12
Columns B and C, Part 2
 Columns B and C
are simpler to
understand
 These percents are
the estimated
facility energy
breakouts for
electric and fuel/
steam
Percent of Facility energy
Facility End-Use
Envelopes
Lighting
Space Conditioning
Ventilation
Miscellaneous
SUM
Column 'B'
Column 'C'
Electricity
(%)
Fuel/Steam
(%)
5%
30%
30%
20%
15%
100%
17%
0%
70%
10%
3%
100%
 The total = 100%
13
Columns D and E, Part 2
 Columns D and E need explanation
 These percentages are the
“technical maximum” potential
savings for the particular end uses
 E.g., when the envelope needs a lot
of work, and the best possible set of
envelope measures is installed, 30%
of envelope-related electrical and
steam might be saved
 In the final Score Card, we need to
think about how users might be able
to change these directly
Max percent savings
considered achievable
Column 'D'
Column 'E'
Electricity
(%)
Fuel/Steam
(%)
30%
60%
50%
30%
0%
30%
0%
50%
30%
100%
Facility End-Use
Envelopes
Lighting
Space Conditioning
Ventilation
Miscellaneous
14
Desired Feedback 1
 User suggestions are welcomed regarding
appropriate end-use breakout data
 Regional values might be appropriate if you
can provide - estimate – develop
 Suggestions on how to handle user
specification of facilities energy is also
welcomed (go to the Quick PEP web app, start
a dummy case, and go to Step 7)
 Suggested values or methods on handling
maximum possible savings by end use are
also welcomed
15
Launch Quick PEP with dummy
case
 Go to website (see p 2
of this presentation)
 Select Launch Quick
PEP
 Pass Step 1 by
entering (dummy)
Case Name and
picking any industry
besides “Other”
 Click the Next button
16
Select Step 7 at the top for facility
 Step 7 provides default
percent “process”
breakouts
 One “process” is Facility
Energy Use
 Users can enter the
appropriate values for
facilities energy percents
here
 One page for electricity
and one for fuel /steam
17
Back to the EXCEL file: Scorecard
Questions, Part 4
Quick PEP
 Once all the
Scorecard Questions
“percents” are
acceptable, the
Facilities Energy Score Card test version 1.0b
Scorecard
YES = '1' for this sheet
questions are
enter percents as percents, not fractions
answered (6th sheet
in file)
Part 4
 Questions are
asked for envelopes
/ infiltration, lighting
/ daylighting, space
conditioning,
ventilation, and
misc hot water
18
Two sheets past Scorecard is
Score Info, with more info about
questions
 Envelope / infiltration questions are E1 – E6
 Similarly, lighting / daylighting, L1 – L6
 L2 and L4 should not add up to more than
25% together
 Space conditioning is HC1 – HC6
 Ventilation is V1 – V6
19
Score info indicates maximum
scores for each question, total 100
20
Building Envelopes / Infiltration
Building Envelopes / Infiltration
All the responses below apply only to
buildings or facilities that are heated and/or
cooled.
E1
E2
E3
E4
Enter percent of total building wall and
roof/attic areas of all heated and/or cooled
buildings that could have insulation (or
additional insulation) added?
Could large unsealed openings or broken
windows in walls or roofs be sealed or
repaired?
Could other major air leakage paths in a
significant fraction of buildings or facilities
be sealed?
Could large expanses of glass that are not
needed be insulated?
required
response
YOUR
Response
YOUR
SCORE
MAX
SCORE
50
25
50
yes/no
0
20
yes/no
0
10
10
10
percent
yes/no
1
E5
Could large loading dock building sections
that do not have air sealing to limit air
infiltration have air sealing installed?
yes/no
0
5
E6
In buildings with air conditioning, could
large window or glazing sections that allow
excessive solar heat to enter be covered or
insulated?
yes/no
0
5
TOTAL
35.00
21
Lighting / Daylighting
Lighting / Daylighting
All the responses below apply mainly to
buildings or facilities that are significantly lit
by electric lighting.
L1
L2
L3
L4
If a large amount of daylight is presently
provided in most spaces, could electric
lighting be dimmed in response if not
already?
What percent of total floor area is lit by older
fluorescent (T12) or incandescent lighting
that could be retrofit to T8?
What percent of total floor area has lighting
left on all the time or most of the time when
little or no activity is occurring? Or lights
cannot be turned off due to lack of
switching?
What percent of indoor lighting could be
reduced by removing lamps? Or what
percent could have task lighting installed and
overhead lights be kept off?
required
response
YOUR
Response
YOUR
SCORE
MAX
SCORE
The responses for L2 and L4 are mutually exclusive
and should not exceed 100. So choose either one or
the other, or split the percents.
yes/no
0
15
percent
75
18.75
25
percent
75
37.5
50
percent
0
25
L5
Could use of outdoor lighting be reduced?
And could outdoor lighting be switched to
fluorescent with motion sensor control?
yes/no
0
10
L6
Can high-bay lighting be switched to
fluorescent with motion sensor control or can
fixtures be lowered and wattage reduced?
yes/no
0
10
TOTAL
56.25
22
Space Conditioning
Space Conditioning
required
response
YOUR
Response
YOUR
SCORE
MAX
SCORE
percent
70
14
20
percent
25
7.48502994
30
All the responses below apply mainly to buildings
or facilities that are significantly heated and/or
cooled, and do not include mopajor ventilation
systems or envelope effects (handled under other
categories).
HC1
HC2
Enter percent of total building floor areas of
all heated and/or cooled buildings that do not
reduce space conditioning during periods of
low occupancy or non-work hours now, but
could do so?
Enter percent of total building floor areas of
all heated and/or cooled buildings that heat
and cool air supply at the same time
(simulataneous heating and cooling fighting
each other), that could have this energywasting situation corrected?
HC3
If boilers or boiler heat supply could be shut
off to building systems during mild and hot
weather -- OR if process heat recovery could
supply some space heating, and this is not
currently done, could either shutoff orheat
recovery be implemented?
yes/no
0
15
HC4
If too much air is supplied for heating and
cooling, could this flow be reduced?
yes/no
0
15
HC5
If there are significant building areas that are
heated and/or cooled that do not need to be
conditioned, could space conditioning be
turned off or disconnected in these areas?
yes/no
0
15
HC6
If excess heating or cooling is provided for
any reason, could the excess be reduced?
yes/no
5
5
1
TOTAL
26.49
23
Ventilation
Ventilation
required
response
YOUR
Response
YOUR
SCORE
MAX
SCORE
yes/no
0
20
yes/no
0
40
yes/no
0
20
yes/no
0
10
yes/no
0
10
All the responses below apply to ventilation
provided by building space conditioning, makeup
air, aor exhaust systems.
V1
V2
V3
V4
V5
If makeup air or exhaust systems are
operating at a static pressure higher than
needed to provide required functionality,
could static pressure be reduced?
If makeup air or exhaust systems are
operating at flow rates higher than needed to
provide required functionality, could flow
rates be reduced?
If excessive outdoor air for ventilation, based
on CO2 readings, is provided for human
occupancy in non-process areas (see chart for
CO2 readings), could the excess outdoor air
be reduced?
If air over 150 F is exhausted to atmosphere
with no heat recovery, could heat be
recovered for useful purposes?
Could enthalpy wheels, heat pipes, or other
devices be used to recover total enthalpy in
exhaust air flows?
TOTAL
0.00
24
CO2 parameters indicating effective
ventilation provided for reference
25
Miscellaneous hot water
Miscellaneous hot water
W1
Can process heat recovery be used to heat
domestic hot water? Enter the percent of
domestic hot water that could be heated.
required
response
percent
YOUR
Response
YOUR
SCORE
MAX
SCORE
50
50
100
TOTAL
50.00
26
After Scorecard Questions,
RESULTS
 Scorecard questions will be blank for
users initially, and the values shown here
are just so testers see that numbers are
generated
 But you must change inappropriate
answers to zero or blank
 RESULTS sheet, Part 3, should not be
modified in any way
27
Quick PEP
Part 3
RESULTS
Facilities Energy Score Card test version 1.0b
REVIEW these as necessary on other sheets
>> DO NOT CHANGE THESE VALUES HERE <<
NAME of sheet to review --->
PctFac
PERCENT of total plant site energy that is for facilties:
28.00%
NAME of sheet to review --->
Scorecard
end-use
A
B
Facilities Energy System
Scorecard
Score out of
100
End-Use Breakout of
Facilities Energy
Electricity
Envelopes
Lighting
Space Conditioning
Ventilation
Miscellaneous (incl hot water)
TOTAL
Fuel/Steam
D
C
Maximum Pct Facilities
Energy that can be saved
Electricity
Fuel/Steam
35
5%
17%
2%
5%
56
30%
0%
18%
0%
26
30%
70%
15%
35%
0
20%
10%
6%
3%
50
15%
3%
0%
3%
100%
100%
41%
46%
Estimated Percent of TOTAL Plant Energy that might be saved
SAVINGS ESTIMATES
= A/100 x C x D
Electricity
Fuel/Steam
percent
Facilities Energy System
Envelopes
0.15%
0.50%
Lighting
2.84%
0.00%
Space Conditioning
1.11%
2.60%
Ventilation
0.00%
0.00%
Miscellaneous (incl hot water)
0.00%
0.42%
TOTAL
4.1%
3.5%
Total plant energy
that might be saved
through facilities
energy measures
Quick PEP users will enter total electricity use and fuel/steam use prior to using a Score Card
Thus, this test Score Card can only show percentages of the total energy to be entered
28
Desired Feedback 2
 Suggestions for simplifying or modifying the
Scorecard questions
 Suggestions for enhancements to Scorecard
approach
 Ideas about how users might be instructed
on use of the Scorecard or what examples
might be useful
 Additions to system questions, but
remember we need to keep it simple
29
Contact Information
 Rolf Butters, DOE ITP
 202-586-0984
 [email protected]
 Mike MacDonald, ORNL
 865-574-5187
 [email protected]
30