5900-268 Performance Path Calculator

Energy Star Program in the Residential Sector (Renewal)

Copy of 5900_268_MFHR Performance Path Calculator_V1.2.xls

Energy Star Program in the Residential Sector: Private Sector

OMB: 2060-0586

⚠️ Notice: This form may be outdated. More recent filings and information on OMB 2060-0586 can be found here:

2024-01-30 - Extension without change of a currently approved collection

Document [xlsx]

Download: xlsx | pdf

Overview

Introduction
Basic Info
Reporting Summary
SIR by Measure
Windows eQUEST
Water Savings
DHW Demand
Appliances
Lighting Schedule
In-Unit Lighting
Interior Lighting
Exterior Lighting
Infiltration&Ventilation
EIR for PTAC and PTHP
Results from eQUEST
Simulation Summary

Sheet 1: Introduction

Performance Path Calculator		OMB Control No. 2060-0586
Version 1.2 Summary of Changes: Reporting Summary: Minor updates. LEED-H MR Form: Removed. Water Savings Worksheet: updated calculation for number of occupants, which will increase the demand and savings from low-flow fixtures. In-Unit Lighting Worksheet: updated to allow users to assume a greater square footage illuminated by hard-wired fixtures. Interior Lighting Worksheet: updated to allow Prescriptive Path users to compare to 90.1-2010 and to calculate 80% ENERGY STAR fixtures. EIR for PTAC and PTHP: Updated calculations. Version 1.1 Summary of Changes: Basic Info Worksheet: square footage calculation was corrected and lighting was converted to W/sf. Reporting Summary: Window to Floor Area ratio replaced with Window to Wall Area ratio. Comment added that appears only if common area lighting exceed prerequisite (20% over ASHRAE). Add % savings by end-use that contributes to total % savings. LEED-H MR Form: Corrected calculations. DHW Demand: Calculations added for storage water heaters; comment added that GPM flowrates entered must be the GPM rated at 80 psi. Interior Lighting Worksheet: column added to sum square footage when using multipliers and note provided to caution users to only insert rows at the end of tables. Column for "24/7?" expanded to document "sensors". Food prep and family dining areas removed from ASHRAE space type drop-down. If these areas exist in common spaces, use "Multipurpose". Drop-down added to indicate Space-by-Space or Building Area method. Infiltration/Ventilation Worksheet: Range hood included as an option in the drop-down menu for Exhaust Fan type; Rooftop expanded to include "other". EIR for PTAC and PTHP: PTHP section expanded to include heating COP/EIR. Version 1.2

The following worksheets detail the information regarding the recommended scope of work and document the achievement of the 15% Performance Target. Some cells are protected to prevent accidental over-writing of formulas.

Note that throughout these worksheets, common information from cells are linked and should automatically update. Only cells shaded in blue need to be entered manually. Entering values into white or orange cells will override pre-determined formulas.

Basic Info
	In blue cells only, enter the basic information about the building (number of units, square footage of the apartments and commercial spaces, type of garage (if applicable) and indicate the level of space conditioning in each zone). All other square footages will auto-fill after completion of the Interior Lighting worksheet.

Reporting Summary
	In blue cells only, enter general information about the project, the model and specifics about the ASHRAE compliant components of the Baseline Building and the energy efficient components in the Proposed Design.

SIR by Measure
	Although not required by the EPA to earn the ENERGY STAR, if incremental costs are entered, this worksheet can be used to determine the cost effectiveness for each recommended measure and for the project as a whole.

Windows eQUEST
	For eQUEST users only, this calculates the Shading Coefficient for entry into eQUEST and modifies the NFRC U-factor to exclude the air-film.

Water Savings
	By entering data in blue cells only, this worksheet will calculate the water savings in gallons based on the proposed flow rates entered. This information does not affect the Performance Rating but can be used when calculating SIR to justify measures that reduce consumption of water.

DHW Demand
	Enter in occupancy usage characteristic (low/medium/high) and information about the appliances that consume water in the building. You must enter data in the Basic Info and Water Savings tab, prior to this tab.

Appliances
	Enter data in blue cells. Values are calculated in W/SF or kWh/yr for entry into software.

Lighting Schedule
	Developed for eQUEST users, but can be used with other software to translate total operating hours/day into an hourly schedule that meets the requirements from the Simulation Guidelines.

In-Unit Lighting
	Enter details and counts of installed lighting fixtures in apartments only. Square footage not illuminated by these fixtures will have a default lighting power density of 1.1 W/Sf assigned to both baseline and proposed. Installed fixtures in rooms where supplemental light will be provided by the occupant or through switched outlets, shall not be modeled as providing illumination for the entire room. Overall lighting power density is calculated on this worksheet for input into software.

Interior Lighting
	Using floor plans, a lighting schedule, and lighting cut sheets, fill in the details of this worksheet. This will sum the square footages by ASHRAE space type for reporting purposes on the Basic Info tab, and calculate the lighting power density to be modeled per room. It also provides the maximum wattage allowed by ASHRAE 90.1 for that room, which can be more useful to the design team than the lighting power density. To help project compliance with program Prerequisites, zones are highlighted in red that exceed ASHRAE LPD’s by more than 20%, which reduce the energy savings of the building, as well as zones that have insufficient illumination.

Exterior Lighting
	Enter details in blue cells only on exterior areas to be illuminated. The total wattage will be provided for input into the simulation software.

Infiltration&Ventilation
	Although developed initially for eQUEST users, the approach can be used for other simulation software if needed. The approach allows for infiltration and exhaust in apartments to be combined in the worksheet and a combined value to be entered into the software.

EIR for PTAC or PTHP
	Although developed initially for eQUEST users, the approach can be used for other simulation software if the energy efficiency of these systems are entered in terms of EIR, rather than EER.

Results from eQUEST
	For eQUEST users only, this worksheet is based upon the Parms.csv file that is generated upon simulation of your building. If those results are pasted into this worksheet, according to the directions, the performance rating will automatically calculate in the Simulation Summary worksheet.

Simulation Summary
	This worksheet requires you to enter the fuel prices in order to calculate the overall energy cost savings, which are required to demonstrate achievement of the Performance Target. This tab links to the Results eQUEST tab and is based on natural gas or electric heat. To use oil, modifications to this tab would be needed.

EPA Form 5900-268
The government estimates the average time needed to fill out this form is up to 1 hour and welcomes suggestions for reducing this effort.
Send comments (referencing OMB Control Number) to the Director, Collection Strategies Division, U.S. EPA (2822T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460.

Sheet 2: Basic Info

	Instructions:
1	First fill in the Interior Lighting tab (this information will populate the square footages for this table)
2	Only fill in cells highlighted with this color.
	Basic Project Information

	Number of Units (per building)
	Studio
	1 - Bedroom
	2 - Bedroom
	3 - Bedroom
	4 - Bedroom

	Building Areas (per building)
	Building Area	Total Square Ft	Conditioned?	Lighting (W/sf)
	Apartment			#DIV/0!
	Storage, active	0		#DIV/0!
	Storage, inactive	0		#DIV/0!
	Lobby	0		#DIV/0!
	Corridor/Transition	0		#DIV/0!
	Stairs - Active	0		#DIV/0!
	Restroom	0		#DIV/0!
	Office	0		#DIV/0!
	Conference/meeting/multipurpose	0		#DIV/0!
	Electrical/Mechanical	0		#DIV/0!
	Workshop	0		#DIV/0!
	Parking garage	0	Unconditioned	#DIV/0!
	Nonresidential Spaces (ie. commercial)
		0

	Type of Garage

Sheet 3: Reporting Summary

ENERGY STAR Multifamily High Rise
Reporting Summary, Version 1.2

Table 1. General Project Information

Current Project Status:

Builder / Developer:

Estimated Construction Completion Date (mo/yr):

Name of contact:

Project Name:

Phone:

Project Address:

E-mail:

Project City, State, Zip:

Table 2. Modeling Information

Modeler:

Simulation Program & Version #:

Company:

Baseline:

Phone:

Weather File Location (City, ST):

E-mail:

Climate Zone:

Table 3. Building Information

# of stories

Total bldg ft2:

Space heating fuel:

Residential

DHW fuel:

Common space

Heating system:

Commercial

Cooling system:

Other

Ventilation system:

Conditioned ft2:

DHW System:

Heated & cooled

Heated-only

Cooled-only

Apartment type

Studio

1-BR

2-BR

3-BR

4-BR

Total

# of apartments

Average ft2

#DIV/0!

Table 4. ENERGY STAR Portfolio Manager Input

Gross Floor Area

Notes

Number of bedrooms

Number of Floors

Number of in-apartment laundry hookups

Number of common area laundry hookups

Number of dishwashers

% gross floor area that is heated

#DIV/0!

% gross floor area that is cooled

#DIV/0!

Table 5. Comparison of Inputs

Model Input Parameter

Example Unit

Baseline Design
(provide description and specification)

Proposed Final Design
(provide description and specification)

Building envelope

Ext. wall construction (above grade)

U-factor or R

Ext. wall construction (below grade)

C-factor or R

Floor construction

U-factor or R

Slab-on-grade construction (unheated)

F-factor

Slab-on-grade construction (embedded heat)

F-factor

Slab-below grade construction

C-factor

Roof construction

U-factor or R

Window/wall area ratio

Window type and U-factor

U-factor

Window SHGC

SHGC

Shading devices

Doors

U-factor

Lighting & appliances

In-unit lighting power density

W/ft2

1.1

W/SF

#DIV/0!

W/SF

Corridor lighting power density

W/ft2

0.5 W/SF

#DIV/0!

W/SF

Other interior lighting

W/ft2

#DIV/0!

W/SF, per ASHRAE 90.1, Table 9.6.1

#DIV/0!

W/SF

#DIV/0!

Exterior lighting

Lighting controls

Refrigerator

ENERGY STAR?

Dishwasher

ENERGY STAR?

Clothes Washer

ENERGY STAR?

HVAC System

Primary HVAC system type

Apartment Ventilation System

Corridor Outdoor Air Supply

CFM/ft2

Primary System Heating efficiency

AFUE / HSPF

Primary System Cooling efficiency

SEER / EER

Fan supply power

Domestic Hot Water System

Equipment efficiency

EF, %Et

Kitchen Faucets

GPM

2.5 @ 80 psi

0.00

Lavatory Faucets

GPM

2.5 @ 80 psi

0.00

Showerheads

GPM

2.5 @ 80psi

0.00

Solar DHW system

% of load

Renewable Electric Generation System

Type of system

Rated capacity

Other

Table 6. Comparison of Estimated Consumption

End Use

Units

Baseline
Annual Consumption

Proposed Design
Annual Consumption

% Savings
by end-use

% Savings
toward Target

Electric loads

Ventilation fans

kWh

#DIV/0!

Space heating

kWh

#DIV/0!

Space cooling

kWh

#DIV/0!

Domestic hot water

kWh

#DIV/0!

Interior lighting

kWh

#DIV/0!

Exterior lighting

kWh

#DIV/0!

Appliances

kWh

#DIV/0!

Pumps and Aux

kWh

#DIV/0!

Other exterior

kWh

#DIV/0!

Plug loads

kWh

#DIV/0!

Gas loads

Space heating

MMbtu

#DIV/0!

Domestic hot water

MMbtu

#DIV/0!

Appliances

MMbtu

#DIV/0!

Other

MMbtu

#DIV/0!

Fuel oil loads

Space heating

MMbtu

#DIV/0!

Domestic hot water

MMbtu

#DIV/0!

Other

MMbtu

#DIV/0!

Totals

Electric loads

kWh

#DIV/0!

Gas loads

MMbtu

#DIV/0!

Oil loads

MMbtu

#DIV/0!

Table 7. Fuel Cost

Electricity

$/kWh

Natural Gas

0.00

$/Therm

Fuel Oil

0.00

$/Gallon

Table 8. Performance Rating Calculation

Baseline

Proposed

BTU Savings, %

$ Savings, %

Fossil Fuel, Btu

Electricity, Btu

Cost, $

Fossil Fuel, Btu

Electricity, Btu

Cost, $

Annual Heating

#DIV/0!

Annual Cooling

#DIV/0!

Annual Lighting

#DIV/0!

Annual Hot Water

#DIV/0!

Annual Appliance

#DIV/0!

Annual Other

#DIV/0!

Total without Renewable

#DIV/0!

#DIV/0!

Annual Renewable

Total with Renewable

#DIV/0!

#DIV/0!

Table 9. Energy Usage per Square Foot of Conditioned Area

Baseline

Proposed

Btu/SqFt

Annual Heating

Annual Cooling

Annual Lighting

Annual Hot Water

Annual Appliance

Annual Other

Total without Renewable

Sheet 4: SIR by Measure

	Instructions:
1	Enter each measure and the corresponding baseline and proposed costs.
2	Use the SAME order as the parametric runs copied in the Results from eQuest worksheet.

	Discount Rate:	3.0%

Energy Reduction Measures and Incremental Hard Costs
		Baseline Components		Proposed Components					Incremental Metrics				Lifecycle Savings	Weighted Lifetime
	Parametric Run	Description	Baseline Cost	Description	Proposed Cost	Lifetime	Energy Savings		Costs	Cost Savings	Payback	S.I.R.
						years	MMBtu	kWh		$	years
1	0						0	0	$0	$0	0.0	0.0	$0	$0
2	0						0	0	$0	$0	0.0	0.0	$0	$0
3	0						0	0	$0	$0	0.0	0.0	$0	$0
4	0						0	0	$0	$0	0.0	0.0	$0	$0
5	0						0	0	$0	$0	0.0	0.0	$0	$0
6	0						0	0	$0	$0	0.0	0.0	$0	$0
7	0						0	0	$0	$0	0.0	0.0	$0	$0
8	0						0	0	$0	$0	0.0	0.0	$0	$0
9	0						0	0	$0	$0	0.0	0.0	$0	$0
10	0						0	0	$0	$0	0.0	0.0	$0	$0
11	0						0	0	$0	$0	0.0	0.0	$0	$0
12	0						0	0	$0	$0	0.0	0.0	$0	$0
13	0						0	0	$0	$0	0.0	0.0	$0	$0
14	0						0	0	$0	$0	0.0	0.0	$0	$0
15	0						0	0	$0	$0	0.0	0.0	$0	$0
16	0						0	0	$0	$0	0.0	0.0	$0	$0
17	0						0	0	$0	$0	0.0	0.0	$0	$0
18	0						0	0	$0	$0	0.0	0.0	$0	$0
19	0						0	0	$0	$0	0.0	0.0	$0	$0
20	0						0	0	$0	$0	0.0	0.0	$0	$0
21	0						0	0	$0	$0	0.0	0.0	$0	$0

							0	0		$0			$0	#DIV/0!
									$0		#DIV/0!	#DIV/0!	$0

Sheet 5: Windows eQUEST

	Instructions:
1	Using ASHRAE 90.1-2007 Table 5.5 (copied below), enter values for your Climate Zone and framing in the Baseline column.
2	Baseline fenestration is based on construction. Wood-frame buildings use nonmetal framing; all others use applicable metal framing.
3	Enter actual NFRC values in the Proposed column.
4	Use calculated values as inputs into eQUEST Glass Type Properties - Basic Specifications screen.

	Climate Zone
	Construction Type

	ASHRAE 90.1-2007	Residential		Nonresidential
		Baseline	Proposed	Baseline	Proposed
	NFRC SHGC
	NFRC U-value

	eQUEST SC	0.000	0.000	0.000	0.000
	eQUEST U-value	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!


	Residential	Climate Zone 1		Climate Zone 2		Climate Zone 3		Climate Zone 4		Climate Zone 5		Climate Zone 6		Climate Zone 7		Climate Zone 8
		U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC
	Nonmetal Framing (all)	1.20	0.25	0.75	0.25	0.65	0.25	0.40	0.40	0.35	0.40	0.35	0.40	0.35	NR	0.35	NR
	Metal Framing (storefront)	1.20	0.25	0.70	0.25	0.60	0.25	0.50	0.40	0.45	0.40	0.45	0.40	0.40	NR	0.40	NR
	Metal Framing (entrance door)	1.20	0.25	1.10	0.25	0.90	0.25	0.85	0.40	0.80	0.40	0.80	0.40	0.80	NR	0.80	NR
	Metal Framing (all other)	1.20	0.25	0.75	0.25	0.65	0.25	0.55	0.40	0.55	0.40	0.55	0.40	0.45	NR	0.45	NR


	Nonresidential	Climate Zone 1		Climate Zone 2		Climate Zone 3		Climate Zone 4		Climate Zone 5		Climate Zone 6		Climate Zone 7		Climate Zone 8
		U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC	U-value	SHGC
	Nonmetal Framing (all)	1.20	0.25	0.75	0.25	0.65	0.25	0.40	0.40	0.35	0.40	0.35	0.40	0.35	0.45	0.35	0.45
	Metal Framing (storefront)	1.20	0.25	0.70	0.25	0.60	0.25	0.50	0.40	0.45	0.40	0.45	0.40	0.40	0.45	0.40	0.45
	Metal Framing (entrance door)	1.20	0.25	1.10	0.25	0.90	0.25	0.85	0.40	0.80	0.40	0.80	0.40	0.80	0.45	0.80	0.45
	Metal Framing (all other)	1.20	0.25	0.75	0.25	0.65	0.25	0.55	0.40	0.55	0.40	0.55	0.40	0.45	0.45	0.45	0.45

Sheet 6: Water Savings

	Instructions:
1	First, fill in Basic Info tab.
2	In the "Baseline Fixture" table, enter an estimated number of uses/day for urinals in the appropriate space. Enter "0" if there are no urinals in building.
3	The baseline usage values will generate automatically.
4	In the "Proposed Fixture" table, enter the flow rate for each proposed fixture type.
5	When on-site collected graywater or rainwater is used for sewage conveyance, the total estimated annual graywater quantity may be subtracted from the total annual design case water usage. Estimated graywater quantity may not be greater than the total usage of fixtures that utilize it. For example, if graywater will be used only in flush toilets, the estimated graywater quantity cannot be greater than the total annual water used by the toilets. Estimate graywater usage for each fixture type and enter the value in the appropriate cell.
6	The remaining values will generate automatically. Water usage savings and cost savings may be reported as indicated in the Water Savings section of the Simulation Guidelines.
	Average Price per Gallon of Water
	No. of Occupants	0
	Dishwasher Savings (Gal/yr)	0
	Clothes Washers Savings (Gal/yr)	0

	Baseline Fixture		Baseline Flow Rates (GPF/GPM)	Baseline Usage (Gallons/year)
	Toilets	<Enter "0" below if no urinals>	1.6	0
	Urinals		1.0	0
	Showerheads		2.5	0
	Bathroom Faucets		2.5	0
	Kitchen Faucets		2.5	0
	Total			0

	Proposed Fixture	Proposed Fixture Flow Rate (GPM/GPF)	Graywater Usage (Gallons/year)	Proposed Usage (Gallons/year)
	Toilets			0
	Urinals			0
	Showerheads (@80 psi)			0
	Bathroom Faucets (@80 psi)			0
	Kitchen Faucets (@80 psi)			0
	Total			0

	Savings by Fixture Type	Water Usage Savings (Gallons/year)	Cost Savings ($/year)
	Toilets	0	$0.00
	Urinals	0	$0.00
	Showerheads	0	$0.00
	Bathroom Faucets	0	$0.00
	Kitchen Faucets	0	$0.00
	Total	0	$0.00

Sheet 7: DHW Demand

	Instructions:
1	First fill in the Basic Info and Water Savings tabs.
2	Fill in cells highlighted with this color.				Occupancy		Low/medium/high usage (see Simulation Guidelines, 3.9.2)
3	Data to be entered into software.					44	gallons per person per day

		Proposed	Baseline		Kitchen Faucet	0.0	GPM
	Avg Faucet gpm (@ 80 psi)	#DIV/0!	2.5		Bath Faucet	0.0	GPM
	Showerhead gpm (@ 80 psi)	0.0	2.5		Baseline DW	0	GAL/YR PER APT =		0	gallons/day-apt (1 dishwasher)
	Total Gal/day (occupant only)	#DIV/0!	0		Proposed DW	1290	GAL/YR PER APT =		4	gallons/day-apt (1 dishwasher)
	Total Gal/day (w/both DW & CW)	#DIV/0!	-		Baseline CW	-	hot water gallons/yr =			-	Total hot water gallons/day (all clothes washers)
	GPM w/DOE APT DHW schedule	#DIV/0!	-		Proposed CW	-	hot water gallons/yr =			-	Total hot water gallons/day (all clothes washers)


	Schedule	DOE APT DHW	Proposed	Baseline			Do apartments have dishwashers? (Y/N)
	0.05	0	#DIV/0!	-			Are they Energy Star rated? (Y/N/NA)
	0.05	1	#DIV/0!	-		0	# of bedrooms
	0.05	2	#DIV/0!	-		0	# of apartments
	0.05	3	#DIV/0!	-			# kitchen faucets				# kitchens
	0.05	4	#DIV/0!	-			# lav faucets				# lavatories (that require exhaust)
	0.05	5	#DIV/0!	-
	0.3	6	#DIV/0!	-			# of dishwashers
	0.5	7	#DIV/0!	-			# of clothes washers
	0.4	8	#DIV/0!	-			Are they Energy Star rated? (Y/N/NA)
	0.3	9	#DIV/0!	-
	0.3	10	#DIV/0!	-			washer and dryer
	0.35	11	#DIV/0!	-
	0.4	12	#DIV/0!	-			Central DHW
	0.35	13	#DIV/0!	-			DHW Storage Volume (gallons)				1.25	radius
	0.35	14	#DIV/0!	-		0.0	DHW Storage Volume (cubic feet)				0.0	height
	0.3	15	#DIV/0!	-		12.5	R-value
	0.3	16	#DIV/0!	-		9.8	Surface Area			% EFF	HIR/EIR
	0.5	17	#DIV/0!	-		0.8	UA for eQuest				#DIV/0!
	0.5	18	#DIV/0!	-
	0.4	19	#DIV/0!	-			In-Unit Water Heater
	0.35	20	#DIV/0!	-			Volume	Fuel	EF	HIR/EIR
	0.45	21	#DIV/0!	-		Baseline				#VALUE!
	0.3	22	#DIV/0!	-		Proposed	0	0		#DIV/0!
	0.05	23	#DIV/0!	-
	6.7		#DIV/0!	-

Sheet 8: Appliances

	Instructions:
1	First, fill out Basic Info and DHW Demand tabs.
2	Fill in cells highlighted with this color.
3	Data to be entered in eQUEST as Equipment or Internal Energy Sources.

		Proposed	Baseline	Equipment # (optional)	Sensible	Latent	Schedule
	Refrigerator, kWh/yr-unit	423	529		Heat Ratio	Heat Ratio
	Refrigerator, kWh/yr-blg	0	0
	Refrigerator, W/SqFt	#DIV/0!	#DIV/0!	Apt Equipment [#]	1.0	0.0	T24 DAY EQP WD			1 Stove
	Electric Stove, kWh/yr-unit	0	0						Stove Type	0.0	Therms
	Electric Stove, kWh/yr-blg	0	0
	Stove, W/SqFt	#DIV/0!	#DIV/0!	Apt Equipment [#]	0.0	0.0	T24 DAY EQP WD
	Dishwasher, kWh/yr-unit	0	0					0	# of dishwashers
	Dishwasher, kWh/yr-bldg	0	0
	Dishwasher, W/SqFt	#DIV/0!	#DIV/0!	Apt Equipment [#]	0.60	0.15	T24 DAY EQP WD
	In-Unit Clothes Washer, kWh/yr	0	0
	In-Unit Clothes Washer, kWh/yr-bldg	0	0					1	F-factor
	In-Unit Washer, W/SqFt	#DIV/0!	#DIV/0!	Apt Equipment [#]	0.8	0.0	T24 DAY EQP WD	0	# of washers
	In-Unit Dryer, kWh/yr-bldg	#DIV/0!	#DIV/0!						# of dryers	1 Dryer
	In-Unit Dryer, W/SqFt	#DIV/0!	#DIV/0!	Apt Equipment [#]	0.15	0.05	T24 DAY EQP WD		DRYER	0.0	Therms
	Common Washer, kWh/yr-machine	0	0					#DIV/0!	Average # bedrooms in living units
	Common Washer, kWh/yr-bldg	0	0						sum of area of all common laundry rooms
	Common Washer, W/SqFt	#DIV/0!	#DIV/0!	NA	NA	NA	T24 EQP WD
	Common Dryer, kWh/yr-bldg	#DIV/0!	#DIV/0!
	Common Dryer, W/SqFt	#DIV/0!	#DIV/0!	NA	0.15	0.05	T24 EQP WD
	In-Unit Dryer, BTU/h (PER dryer)	-	-	NA	NA	NA	T24 DAY EQP WD
	In-unit, misc. kWh/yr-SqFt (SG 2-11)	1.05	1.05
	In-unit misc W/SqFt	0.50	0.50	Apt Equipment 1	0.9	0.1	T24 DAY EQP WD	Number of Stories:	0
	Corridor, restrooms & Stairs W/SqFt	0.2	0.2	Corr & Stairs Equipment 1	1.0	0.0	T24 EQP WD	Area of Elevator:
	Elevator W/SqFt	#DIV/0!	#VALUE!	Elevator Equipment 1	0.1	0.0	T24 EQP WD	Elevator Type:
	Office W/SqFt	1.5	1.5	Office Equipment 1	1.0	0.0	T24 EQP WD	SG, Section 3.11	Baseline kWh/yr for elevator
	Other Public and Common Area W/SqFt	0.5	0.5	Common Area Equipment 1					Proposed kWh/yr (same as Baseline if not requesting performance credit)
	Hour	Common area plug load schedule, SG 2.11 (Same as T24 EQP WD)	Apartment Plug load schedule (Same as T24 DAY EQP WD)
	1	0.1	0.05
	2	0.1	0.05
	3	0.1	0.05
	4	0.1	0.05
	5	0.1	0.05
	6	0.3	0.05
	7	0.45	0.05
	8	0.45	0.05
	9	0.45	0.5
	10	0.45	0.5
	11	0.3	0.5
	12	0.3	0.5
	13	0.3	0.3
	14	0.3	0.5
	15	0.3	0.5
	16	0.3	0.5
	17	0.3	0.5
	18	0.3	0.5
	19	0.6	0.35
	20	0.8	0.05
	21	0.9	0.05
	22	0.8	0.05
	23	0.6	0.05
	24	0.3	0.05
	Total	9	5.8

Sheet 9: Lighting Schedule

	Instructions:
1	Use this worksheet to generate schedules for lighting inputs.
2	Enter hours/day in the cell highlighted in this color to generate a 24 hour schedule in column F.
3	Do not edit cells highlighted in this color.
4	Do not edit cells highlighted in this color. These calculated values are for editing or creating schedules.
5	Elevator lighting should only be assigned to ONE elevator zone.
6	In eQUEST, exit Signs can be added as Lighting #2 (kW) in the appropriate zones.
7	Credit for occupancy sensors can be applied to corridors and stairs by reducing proposed W/SF by 25% and 35% respectively.

	Daily operating hours	hr/day
	Apartments and Balconies	2.34
	Garage, Corridors, Lobbies & Stairs	24
	Exterior Lighting	12
	Non Apartment, Non 24 hour

		APT LTG WD	Adjusted Fraction	Adjusted Fraction
	Hr	Fraction	Apartments	Non Apartment, Non 24 hour
	1	0.05	0.015	0.000
	2	0.05	0.015	0.000
	3	0.05	0.015	0.000
	4	0.05	0.015	0.000
	5	0.05	0.015	0.000
	6	0.05	0.015	0.000
	7	0.25	0.077	0.000
	8	0.45	0.139	0.000
	9	0.45	0.139	0.000
	10	0.35	0.108	0.000
	11	0.35	0.108	0.000
	12	0.35	0.108	0.000
	13	0.25	0.077	0.000
	14	0.25	0.077	0.000
	15	0.25	0.077	0.000
	16	0.25	0.077	0.000
	17	0.25	0.077	0.000
	18	0.35	0.108	0.000
	19	0.7	0.217	0.000
	20	0.7	0.217	0.000
	21	0.7	0.217	0.000
	22	0.7	0.217	0.000
	23	0.6	0.186	0.000
	24	0.05	0.015	0.000
	Total	7.55	2.34	0
	Apartment Adjustment	0.309933774834437
	Non Apartment, Non 24 hour	0

Sheet 10: In-Unit Lighting

	Instructions:
1	Include all in-unit hard-wired lighting in this table. Rated wattage must include ballast (follow 90.1 User's manual or Appendix B of Performance Path).
2	Per ASHRAE 9.1.4, screw-based fixtures must be entered using the maximum rated wattage of the fixture, even if a screw-based CFL or LED is installed. As this requirement is waived for this program, screw-base fixtures may be entered using the installed lamp and ballast wattage or the maximum rated wattage of the fixture.
3	Only the rooms for which there are specified hard-wired lighting fixtures should be entered in this table. Therefore, the total square feet that you list in this table might be smaller than the total square feet of the Apartments. If there are multiple fixtures per room, distribute area accordingly.
4	Likewise, for some rooms, the areas for which lighting is specified may be LESS than the total area of the room. If the specified fixtures are intended to light only a portion of the room, enter the square feet of the lighted area only, per your own estimation, but not to exceed 3 square feet per Watt. (Ex. A 13 Watt wall sconce in a bedroom can light at most 39 square feet and should not be modeled as lighting the entire space.)
5	Cells highlighted in red indicate spaces where estimated lumen output of fixture does not provide minimum illumination (16 lumens/SqFt) per IESNA.
6	Enter data in the cells highlighted in this color.
7	Do not edit cells highlighted in this color.
8	Do not edit cells highlighted in this color. These calculated values are to be entered into software as W/SF for Apartment zones.

	*In-Unit Lighting Table*
	Room Name	Room Area, SqFt	Quantity	Fixture Code	Fixture Wattage	Lumens per Fixture	Number of such rooms in the building	Total Area, SqFt	Total Installed Wattage, W	Illumination (footcandles or lumens/SqFt)
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0
					0	0		0.0	0.0	0.0

	Summary
	Total in-unit area with specified lighting, SqFt				0.0
	Total specified lighting, W				0.0
	Specified lighting power density, W/SqFt				NA
	Proposed lighting power density, W/SqFt				#DIV/0!
	Baseline lighting power density, W/SqFt				1.10

Sheet 11: Interior Lighting

Instructions:

Fixture Code

Fixture Type

Use maximum rated wattage for the fixture if following ASHRAE explicitly. EPA allows wattage to be calculated using wattage of installed lamps and ballast, regardless of maximum rated wattage of the fixture. Watts/Fixture

Follow Appendix B of Prerequisites Lumens/fixture

Manufacturer/Model

General Location

ENERGY STAR? (Y/N)

24/7?

Quantity

1. Fill in cells highlighted with this color, including the Watts/fixture and Lumens/fixture in Column J&K.

MUST BE ALPHABETICAL

#DIV/0!

2. When available, provide manufacturer, model, whether ENERGY STAR qualified and indicate 24 hour operation.

#DIV/0!

3. List NON-APARTMENT rooms in the building that have specified lighting by FLOOR. For typical floors, indicate the floor multiplier in Column H.

#DIV/0!

4. List square footages for all NON-APARTMENT spaces in Column B (do not assign square footages to rows for Exit Signs or Exterior Lights).

#DIV/0!

5. Indicate how many fixtures of each type are in each room in Column E.

#DIV/0!

6. Use drop down menu to indicate the ASHRAE space type for calculating proposed LPD's.

#DIV/0!

7. Rooms with more than one fixture type should be entered using multiple rows (Ex. exit signs); square footage should be distributed between entries.

#DIV/0!

8. If you need more rows for your building, add them at the bottom by copying rows above (or filling down).

#DIV/0!

9. When finished, be sure to delete any "#N/A" from blank rows.

#DIV/0!

10.Red cells indicate ZONES where proposed lighting exceed ASHRAE LPD by more than 20%.

#DIV/0!

11.ZONES can exceed LPDs by more than 20%, but the TOTAL proposed wattage cannot exceed the TOTAL wattage in the baseline by more than 20%.

#DIV/0!

Select calculation method:

Space-By-Space (90.1-2007)

#DIV/0!

Fixture Count

TOTAL

ENERGY STAR

> 80%?

#DIV/0!

Apartment

#DIV/0!

Common Space

#DIV/0!

Exterior

#DIV/0!

If you need more rows, insert below this row >>

#DIV/0!

Square Footage

Room Name

ASHRAE Space Type

Installed quantity

Fixture Code (A,B,C etc)

Fixture Installed Wattage

Floor Multiplier

Total Installed Wattage

PROPOSED W/SF

BASELINE W/SF

BASELINE WATTS

CALCULATED FOOTCANDLES

IESNA FOOTCANDLES

Total Square Footage

Footcandle Warning

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

Sheet 12: Exterior Lighting

	Instructions:
1	Enter data in the cells highlighted with this color.
2	Use values from the cells highlighted in this color in the energy simulations.
3	In eQUEST, exterior lighting should be entered in the "Utility & Economics" section, under Electric Meter as a Direct Exterior Load, with Ambient Lighting enduse and a 12 hr/day schedule.
4	For proposed design simulation, enter exterior lighting specified on drawings.
5	Apartment balcony lighting should be treated as façade lighting, and modeled using the 2.34 hr/day schedule for in-unit lighting.
	Exterior Lighting Allowances (Per Table 9.4.5 of ASHRAE 90.1-2007)

	*Area Type*	*Lighting Power Density*	Area	Baseline Lighting Allowance	Proposed Lighting Allowance	Proposed Fixture Description
	*Area Type*	*W/SqFt*	SqFt	W	W
	Uncovered parking lots and drives	0.15		0
	Walkways 10ft wide or greater	0.20		0
	Exterior stairways	1.00		0
	Canopies and overhangs	1.25		0
	Building Facades (1)	0.20		0			If Proposed façade lighting exceeds Baseline allowance, model proposed as designed.
							If Proposed façade lighting is less than Baseline allowance, model baseline the same as proposed.
	*Area Type*	*Lighting Power Density,*	Linear feet	Baseline Lighting Allowance	Proposed Lighting Allowance	Proposed Fixture Description
		*W/linear foot*	Ft	W	W
	Walkways less than 10 ft wide	1.00		0
	Main building entrance (2)	30.00		0
	Other exterior doors (2)	20.00		0
	Building Facades (3)	5.00		0

	*Total Exterior Building Allowance to be entered in Energy Models (4)*
		Baseline	Proposed
	Tradable	0	0	Watts
	Non-Tradable	0	0	Watts
		0	0	Watts
	*Notes:*
	(1) Enter area of all illuminated walls or surfaces in the Area column
	(2) Enter total linear foot of door width for main entrance doors
	(3) Enter total linear foot of all illuminated wall or surface length
	(4) Total values include additional 5% allowance per Section 9.4.5

Sheet 13: Infiltration&Ventilation

Instructions:

In the simulation software, rather than model Outside Air and Exhaust for Apartments separately, you may combine and model as "Infiltration".

You may model Exhaust for refuse rooms and laundry rooms as equivalent "Infiltration" as well.

Fill in cells highlighted with this color.

Data to be entered into simulation software.

Corridor Supply Air can be modeled as Outside Air in software.

Supply Ventilation for Apartments should be mechanical supply or trickle vents, but not corridor make-up air.

ACH or CFM/SF can be used for data entry.

In eQUEST, electricity for exhaust fans should be modeled as Direct-Interior or Exterior Loads in Electric Meter, with Ventilation Fans enduse.

Red cells will indicate when continuous baseline ventilation is not properly modeled.

Baseline

Proposed

Baseline

Proposed

Baseline

Proposed

Baseline

Proposed

Space Type

Apartments

Refuse Room

Laundry Room

Total Area For Space Type, SqFt

Ceiling Height, Ft

Total Volume For Space Type, CuFt

For exhaust fans with different runtimes, use formulas in row 61 and 64 to determine equivalent continuous flow rates. Exhaust Ventilation, CFM (Design/tested flows at grilles)

This applies to central exhaust systems only. Ventilation Duct Leakage (Baseline add 10 CFM/floor per shaft)

For exhaust fans with different runtimes, use formulas in row 61 and 64 to determine equivalent continuous flow rates and enter 24 hours here. If not otherwise known, intermittent fans should be modeled using a 2 hour/day runtime. For intermittent fans that are also used to provide whole-house ventilation, increase the runtime accordingly. Exhaust Runtime, hr/day

Assumed Infiltration Rate, ACH

0.1

Equivalent Continuous Exhaust, ACH

#DIV/0!

Supply Ventilation, CFM

Supply Runtime, hr/day

Equivalent Continuous Supply, ACH

#DIV/0!

Minimum Outdoor Air Requirements, ACH

0.35

Average Combined Hourly Infiltration/Ventilation Rate, ACH

#DIV/0!

Average Combined Hourly Infiltration/Ventilation Rate, CFM/SF

#DIV/0!

This assumes that all fans within the space are the same. To calculate the power consumption of different fans within the same space, you would need to modify the exhaust in row 16 to represent the CFM from one fan and record the power consumption. Repeat this step for the number of unique fans that you have. Exhaust Fan Type

CFM/W

#N/A

Pfan (Watts)

#N/A

#DIV/0!

#N/A

#DIV/0!

#N/A

#DIV/0!

Do not Enter data

Pfan (Watts)

BHP

Do not Enter data

Motor Efficiency

Do not Enter data

Pfan (Watts)

Local Exhaust (62.2-2007):

Kitchen

Bathroom

CFM is the maximum allowed in the baseline if both fans run continuously or both fans run intermittently.

MAXIMUM CONTINUOUS LOCAL BASELINE EXHAUST:

MAXIMUM INTERMITTENT LOCAL BASELINE EXHAUST:

150

Kitchen

Bathroom

CFM is the minimum allowed in the baseline if both fans run continuously or both fans run intermittently.

MINIMUM CONTINUOUS LOCAL BASELINE EXHAUST:

MINIMUM INTERMITTENT LOCAL BASELINE EXHAUST:

100

BASELINE LOCAL EXHAUST VENTILATION:

You may choose to exceed the maximum CFM allowed in the baseline, however, your model must be penalized for the extra volume of ventilated air. PROPOSED LOCAL EXHAUST VENTILATION:

INTERMITTENT OR CONTINUOUS?:

Insufficient Ventilation

Kitchen volume shall be determined by drawing the smallest possible rectangle on the floor plan that encompasses all cabinets, pantries, islands, and peninsulas and multiplying by the average ceiling height for this area. Cabinet volume shall be included in the kitchen volume calculation. Kitchen Area:

Kitchen Ceiling height:

Continuous CFM equivalent to 5ACH (62.2-2007):

Whole Unit Ventilation Rate (62.2-2007):

Studios

1BR

2BR

3BR

4BR

Average Area (SqFt):

This is the CONTINUOUS rate needed to meet ASHRAE 62.2-2007. This can also be met using a timer and a larger sized fan. Ex. 20 CFM continuous is equivalent to an 80 CFM fan that operates 15 minutes each hour. Minimum CFM required:

<< These values are updated once you have entered your average area.

Exceeding whole-house ventilation rates by more than 50% is permitted only if using continuously running local exhaust fans to meet whole-house ventilation. Maximum CFM allowed in Baseline:

<< These values are determined once you have entered your proposed CFM.

If this is met using a timer approach, enter the equivalent continuous rate. Ex. An 80 CFM fan that operates 15 minutes each hour should be entered as 20 CFM. You may choose to exceed the maximum CFM allowed in the baseline, however, your model must be penalized for the extra volume of ventilated air unless the additional CFM was needed to meet continuous local exhaust. Proposed CFM:

Insufficient Ventilation

CFM

minutes/hour

hours/day

Convert Intermittent Ventilation to equivalent Continuous:

CFM is the equivalent continuous ventilation rate.

Quantity of Fans

CFM

minutes/hour

hours/day

Combine Different Ventilation to equivalent Continuous:

CFM is the equivalent continuous ventilation rate for all fans combined.

Sheet 14: EIR for PTAC and PTHP

	Instructions:
1	For gas heated buildings using System 1 - PTAC, use the top chart to calculate cooling-EIR
2	For electric heated buildings using System 2 - PTHP, use the bottom chart to calculate cooling-EIR
3	Baseline PTAC fan energy should be simulated as 0.3 W/CFM
4	Fill in cells highlighted with this color.
5	Data to be entered in simulation software.
		Baseline Design		Proposed Design
		Common Space Systems	Apartment Systems	Apartment Systems	Common Space System1	Common Space System2	Common Space System3	Common Space System4	Common Space System5	Common Space System6
	System Type	PTAC	PTAC
	EER	11.009	11.009
	Net Cooling Capacity, Btu/Hr
	Fan BHP	NA	NA
	Fan Motor Efficiency	NA	NA
	CFM	NA	NA
	Fan kW/CFM	0.0003	0.0003	-	-	-	-	-	-	-
	EIR or 1/COP	0.258	0.258	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!


		Baseline Design		Proposed Design
		Common Space Systems	Apartment Systems	Apartment Systems	Common Space System1	Common Space System2	Common Space System3	Common Space System4	Common Space System5	Common Space System6
	System Type	PTHP	PTHP
	Cooling EER	10.809	10.809
	Net Cooling Capacity, Btu/Hr
	Fan BHP	NA	NA
	Fan Motor Efficiency	NA	NA
	CFM	NA	NA
	Fan kW/CFM	0.0003	0.0003	-	-	-	-	-	-	-
	EIR or 1/COP (COOLING)	0.263	0.263	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
	Net Heating Capacity, Btu/Hr
	COP (HEATING)	3.018	3.018
	EIR or 1/COP (HEATING)	0.331	0.331	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!

Sheet 15: Results from eQUEST

Instructions:

Open Parms.csv file that corresponds to baseline and proposed eQUEST models.

Copy runs corresponding to four orientation exposures from baseline Parms.csv to row 13-16 below. If not rotated, copy into row 13 only.

Copy run that corresponds to proposed design from proposed Parms.csv to row 19 below

These values will used to calculate the performance rating in the Simulation Summary worksheet

If building uses more than one fossil fuel or uses oil instead of gas for heating, adjustments are needed.

Annual Lighting

Annual Appliance

Annual Heating

Annual Cooling

Annual Other

Annual Appliance

Annual Heating

Annual Hot Water

Annual Other

Annual Lighting

Annual Appliance

Annual Heating

Annual Cooling

Annual Other

Annual Appliance

Annual Heating

Annual Hot Water

Annual Other

Step1:

Baseline Design (copy runs corresponding to four exposures from <project name>-Parms.csv to row 13-16 below)

Electric Usage:

Fuel Usage:

Source Energy:

TDV Energy:

Annual Utility Costs:

SS-D

PS-E

BEPS

TDV1

ES-E

Peak Cooling

Ambient

Task

Misc

Space

Heat

Pumps

Ventilation

Refrig

Heat Pump

Domestic

Exterior

Ambient

Task

Misc

Space

Heat

Pumps

Ventilation

Refrig

Heat Pump

Domestic

Exterior

Bldg

Total

Electric

Run

Internal

Case

Short

Carry

Incremental

Coil Load

Lights

Equip

Heating

Cooling

Reject

& Aux

Fans

Display

Supplement

Hot Water

Usage

Total

Lights

Equip

Heating

Cooling

Reject

& Aux

Fans

Display

Supplement

Hot Water

Usage

Total

Energy

EUI

Energy

EUI

Electric

Fuel

kWh

Type

Loads

Name

Fwd

First Cost ($)

Annual Maint. ($)

Date & Time of Run

File Name

Case Description

kBtu

kWh

Therms

MBtu

kBtu/sf/yr

TDV-MBtu

TDV-kBtu/sf/yr

Average of 4 exposures (needed in Simulation Summary)

#DIV/0!

Step2:

Proposed Design (copy run that corresponds to proposed design from <project name>-Parms.csv to row 19 below)

Step3:

Energy Savings By Measure (copy runs that correspond to EACH parametric run from <project name>-Parms.csv to rows below). These are used to calculate savings in SIR by Measure worksheet

Peak Cooling

Ambient

Task

Misc

Space

Heat

Pumps

Ventilation

Refrig

Heat Pump

Domestic

Exterior

Ambient

Task

Misc

Space

Heat

Pumps

Ventilation

Refrig

Heat Pump

Domestic

Exterior

Bldg

Total

Electric

Run

Internal

Case

Short

Carry

Incremental

Coil Load

Lights

Equip

Heating

Cooling

Reject

& Aux

Fans

Display

Supplement

Hot Water

Usage

Total

Lights

Equip

Heating

Cooling

Reject

& Aux

Fans

Display

Supplement

Hot Water

Usage

Total

Energy

EUI

Energy

EUI

Electric

Fuel

kWh

Type

Loads

Name

Fwd

First Cost ($)

Annual Maint. ($)

Date & Time of Run

File Name

Case Description

kBtu

kWh

Therms

MBtu

kBtu/sf/yr

TDV-MBtu

TDV-kBtu/sf/yr

(these rows can be manually entered for calculations done outside of eQuest such as Solar Hot Water, Solar PV, etc)

Sheet 16: Simulation Summary

	Instructions:
1	First fill in the Basic Info worksheet and copy results into Result Summary eQUEST worksheet.
2	Fill in cells highlighted with this color.
3	If oil is used rather than natural gas, modifications to table are needed.
4	Baseline and Proposed design fuel usage is copied from the corresponding rows in Result Summary eQUEST worksheet.
5	Performance rating is shown in Red Font
6	Energy cost savings associated with on-site power generation, including cogeneration, photovoltaics, and wind turbines, may not be used to meet the Performance Target of 15%, but can be listed in Row 31.
	Building Area Summary (conditioned spaces only)
	Space Type	Area, SqFt	Notes
	Residential	0	Include total floor area of all residential units in building
	Common Area	0	Include combined floor area of residential-associated spaces (corridors, recreation areas, lobbies, etc.)
	Commercial Area	0	Include combined floor area of nonresidential spaces (commerical, office, retail, food sales, etc.)
	Garage	0	Include floor area of enclosed/underground garages
	Total Conditioned	0

	Fuel Cost
	Electricity		$/kWh
	Natural Gas		$/Therm
	Fuel Oil		$/Gallon

	Performance Rating Calculation
		Baseline			Proposed			Site BTU Savings, %	$ Savings, %
		Fossil Fuel, Btu	Electricity, Btu	Cost, $	Fossil Fuel, Btu	Electricity, Btu	Cost, $	Site BTU Savings, %	$ Savings, %
	Annual Heating	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Cooling	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Lighting	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Hot Water	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Appliance	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Other	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Total without Renewable	#DIV/0!	#DIV/0!	#DIV/0!	-	-	$0.00	#DIV/0!	#DIV/0!
	Annual Renewable	0	0	$0.00		On-site electricity generation should be added as a negative value.	$0.00	0.00%	0.00%
	Total with Renewable	#DIV/0!	#DIV/0!	#DIV/0!	-	-	$0.00	#DIV/0!	#DIV/0!

							#DIV/0!	average monthly gas costs per apartment
							#DIV/0!	average monthly electricity costs per apartment

	Utility Bill Comparison
		Baseline			Proposed			Site BTU Savings, %	$ Savings, %
		Fossil Fuel, therms	Electricity, kWh	Cost, $	Fossil Fuel, therms	Electricity, kWh	Cost, $	Site BTU Savings, %	$ Savings, %
	Annual Heating	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Cooling	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Lighting	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Hot Water	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Appliance	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Annual Other	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!
	Total with Renewable	#DIV/0!	#DIV/0!	#DIV/0!	0	0	$0.00	#DIV/0!	#DIV/0!


	Energy Usage per Square Foot of Conditioned Area

		Baseline	Proposed
		Btu/SqFt	Btu/SqFt
	Annual Heating	0	0
	Annual Cooling	0	0
	Annual Lighting	0	0
	Annual Hot Water	0	0
	Annual Appliance	0	0
	Annual Other	0	0
	Total without Renewable	0	0

File Type	application/vnd.ms-excel
Author	Rasmussen, Anne
Last Modified By	Purdy, Mark
File Modified	2019-05-29
File Created	2007-11-19