20040220Robinette Exhibits.pdf

Brad M. Purdy
Attorney at Law
Bar No. 3472
2019 N. 17th St.
Boise, ID 83702
[phone]
FAX: [phone]
bmpurdy~hotmail. com
Attorney for Petitioner
Community Action Partnership
Association of Idaho and
American Association of
Retired Personsco
:\ECEIVED
;LED
20011 FEE 20 Pt, 3: 29
. .
' 'c'
J fiLl T!E~/ COr,:fiSSJON
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION OF
IDAHO POWER COMPANY FOR AUTHORITY)
TO INCREASE ITS INTERIM AND BASE
RATES AND CHARGES FOR ELECTRIC SERVlCE
CASE NO.IPC-03-
COMMUNITY ACTION PARTNERSHIP ASSOCIATION OF IDAHO
DIRECT TESTIMONY OF KEN ROBINETTE
EXIBIT #806
Idaho Power LIW A Statistics
April 1 , 1989 to December 31 , 1994
PA
G
E
ID
A
H
O

P
O
W
E
R

E
N
E
R
G
Y

M
A
N
A
G
E
M
E
N
T

D
E
P
A
R
T
M
E
N
T
lO
W

I
N
C
O
M
E

W
E
A
T
H
E
R
I
Z
A
T
I
O
N

P
R
O
G
R
A
M
EN
E
R
G
Y

S
A
V
I
N
G
S

R
E
P
O
R
T
FO
R

T
H
E

P
E
R
I
O
D

S
T
A
R
T
I
N
G

0
4
/
0
1
/
8
9

A
N
D

E
N
D
I
N
G

1
2
/
3
1
/
9
4
DA
T
E

O
F

R
E
P
O
R
T
:
0
1
/
0
4
/
9
5
AV
E
R
A
G
E
TO
T
A
L
IP
e
O
TO
T

A
l
NU
M
B

E
R
TO
T
A
L
AV
E
R
A
G
E
IP
C
O
AV
E
R
A
G
E
CO
S
T
CO
S
T
KW
H
KW
H
TO
T
A
L
CO
S
T
IP
C
O
CO
S
T
KW
H
PE
R
PE
R
SA
V
I
N
G
S
AG
E
N
C
Y
JO
B
S
SA
V
E
D
CO
S
T
PE
R

J
O
B
CO
S
T
PE
R

J
O
B
SA
V
E
D
KW
H
KW
H
PE
R

S
O
F
T
WE
S
T
E
R
N

I
D

c
a
.
u
J
N
I
T
Y

A
C
T
I
O
N

A
G
E
N
C
Y
10
-
8
0
0
20
3
99
8
,
79
4
.
28
2
,
81
5
:
2
2
39
3
.
16
8
,
96
1
.
83
2
.
92
0
.
02

CO
f
o
U
J
H
I
T
Y

A
C
T
I
O
N

AG
E
N
C
Y
,

I
N
C
5-
8

e
e
27
,
00
8
.
11

,
74
8
.
1
,
95
8
.

1
1
24
0
.
04
0
.
50
1
.
2J
~
MA
L
H
E
U
t

C
O
U
N
C
I
L

O
N

A
G
I
N
G
23
-
8
0
0
23
9
,
81
8
.
12
9
,
15
8
.
1
.
50
1

.
76
.
57
6
.
89
0
.
43

I

2
,
78
8
.
32
~
El
-
A
D
A

c
a
.
t
.
I

AC
T
I
O
N

A
G
E
N
C
Y
30
-
8
0
0
34
9
26
8
,
05
5
.
41
0
,
53
7
.
1
,

1
7
6
.
21
6
,
48
1
.
-
6
~
0
.

2
9
63
3
.
ID
A
H
O

M
I
G
R
A
N
T

C
O
U
N
C
I
L
31
-
8
0
0
14
7
43
4
,
32
1
.
16
2
,
12
0
1
,

1
0
2
.
93
,
56
3
.
63
6
.
95
4
.
CA
N
Y
O
N

C
T
Y

O
R
G
A
N
I
Z
A
T
I
O
N

O
N

A
G
I
N
G
31
-
8
0
1
28
0
89
3
.
46
8
.
41
7
,
25
4
.
49
0
.
19
9
,
14
0
.
71
1

.
90
5
.
22

SO
U
T
H

C
E
N
T
R
A
L

C
t
M
C

A
C
T
I
O
N

A
G
E
N
C
Y
50
-
8
0
9
56
4
26
4
,
84
7
.
74
7
,
91
2
.
32
6
.
50
0
,
04
9
.
88
6
.
01
5
.
SO
U
T
H

E
A
S
T

1
0

Ca
.
t
.
f

A
C
T
I
O
N

AG
E
N
C
Y
70
-
8
0
9
23
6
18
8
,
45
4
.
80
2
,
21
0
.
39
9
18
5
,
68
2
.
78
6
.
03
5
.
80
(
!
)
TO
T
A
L
18
7
1
51
4
,
75
8
.
96
3
,
75
6
.
58
4
.
44
6
,
69
7
.
77
3
.
01
6
.
..
.
.
~
t
D
L
If
'

ro
n
\
NO
T
E
:

A
L
L

F
I
G
U
R
E
S

I
N
C
L
U
D
E

R
E
P
A
I
R
S

A
N
D

T
H
E

I
P
e
O

A
D
M
I
N
I
S
T
R
A
T
I
V
E

F
E
E
Brad M. Purdy
Attorney at Law
Bar No- 3472
2019 N. 17th St.
Boise, ID 83702
[phone]
FAX: [phone]
bmpurdy~hotmail. com
Attorney for Petitioner
Community Action Partnership
Association ofIdaho and
American Association of
Retired Persons.
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION OF
IDAHO POWER COMPANY FOR AUTHORITY)
TO INCREASE ITS INTERIM AND BASE
RATES AND CHARGES FOR ELECTRIC SERVlCE
CASE NO.IPC-03-
COMMUNITY ACTION PARTNERSHIP ASSOCIATION OF IDAHO
DIRECT TESTIMONY OF KEN ROBINETTE
EXIBIT #807
Meetings to Discuss Contract Design and Changes with
Idaho Power and Community Action Agencies
;-. . :0 i
IDAHO
POWER
COMPANY
t~ers
In El1e
~~~
serVat.i CO.- . O
WITH
IDAHO
WEATHERIZATION
PROGRAMS
10/08/98
IDAHO POWER
Low Income Weatherization
Assistance Program
IDAHO POWER KUDOS
GREAT PARTNERSHIP WITH IDAHO POWER COMPANY
Would not have been able to perform many of the services
low-income families.
HAVE ALLOWED AGENCIES/ORGANIZATIONS TO UP-
GRADE FACILITIES TO ACHIEVE HIGHER ENERGY
EFFI CIEN CY
TEAMED UP ON DOE NON-ELIGIBLE HOMES
V. Jackson
B. Climer
G. Pullman
WHEN A EN CIES HA VE. NEED ED AD VI CE ON
ELECTRICAL HOMES/ISSUES THE LOCAL
REPRESENT A TIVES ARE AL WAYS THERE TO OFFER
PROFESSIONAL ADVICE
THANK YOU!
. ,
IDAHO POWER
Low Income Weatherization
Assistance Program
BARRIERS
WHY AGENCIES ARE NOT SPENDING
ALLOCA TIONS
CONTRACTS RECEIVED PRIOR TO CONTRACT DATE
Agencies not turning in work until IP contracts are received.
SMALL HOMES NOT BEING TURNED IN
MOST ELECTRICALL YHEA TED HOMES (Better housing
stock-FMHA , mobile homes-aluminum wiring)
50/50 IS ONLY WHEN THE FOLLOWING ITEMS ARE NOT
INCLUDED:1. Water Pipes2. Furnace Repair3. Health & Safety
EA-3 NOT CAPTURING ACTUAL LABOR COST - ONLY
ESTIMA TED
OFFSETTING AVERAGE DOEIIP COST PER UNIT
AGENCIES DOWNSIZING TO REDUCE SUPPORT COSTS IN
ORDER TO MEET STATE CONTRACTUAL REQUIREMENTS
IDAHO POWER
Low Income Weatherization
Assistance Program
SUPPLEMENTAL MEASURES
PROCESS WAS SLOW IN RECEIVING
A UTH 0 RIZA TI ON
. . .
MANY TINIE S WE MAKE
SUPPLENIENT AL MEASURE REQUESTS DUE TO
ENIERGENCY SITUATIONS
FURNACE REPLACEMENTS, MODIFICATIONS OR
REP AIRS
WINDOWS/STORMS AND DOORS WHEN SIR'S ARE NOT
AT 1 OR GREATER BUT NEEDS TO BE REPLACED (WE
HA VE TO CHARGE TO HEAL TH & SAFETY)
jtWfO~POWERENERGY SERVICES DEPARTMENT
LOW INCOME WEATHERIZATION PROGRAM
PAYMENT REQUEST - ADDITIONAL QUALIFYING MEASURES
(Please complete with estimated costs and submit to
IPCo Energy Services, P.O. Box 70, Boise, 10 83707)
ate
less Ity
ustomer
less Ity
0 OWN RENTING
REASON FOR SUPPLEMENT MEASURE (Explain)
::)aves t:nergy
Safety Hazard
(;ode VIolation
ESTIMATED COSTS
QUALIFYING MEASURES (Describe)LABOR MATERIAL TOTAL
Electric water heater repair or replacement
Electrical service upgrade
Mobile home skirting
Lighting
Window (Jalousie , Broken Glass , etc.
Electrical wiring
Other
TOTAL ESTIMATED COSTS
------------------------------------------------------- I d ah 0 P owe r Use 0 n Iy
-------------------------------------------------
I:o lma d (.;re-approved D
I U
Actual Costs:
Labor
Material
Cost Cost
Center Element Type Activity
505 5360 ILIW050
APPROVALS
EmplO)"" No SigT8I1n:
Total
ESD 183 (2195)
IDAHO POWER
Low Income Weatherization
Assistance Program
ADMINISTRATIVE EXPENSES
CURRENT ADMINISTRATIVE CHARGE OF $75.00 HAS
BEEN IN PLACE SINCE 1989
AGENCIES CURRENT ADMINISTRATIVE EXPENDITURES
EXCEED THE IDAHO POWER $75.00 ADMINISTRATIVE
AMOUNT
AGENCIES PRESENT AVERAGE ADMINISTRATIVE
EXPENDITURES ARE $146.00 EACH
WOULD LIKE TO RECOMMEND SETTING
ADMINISTRATIVE ALLOWANCE AT $150.00 PER HOIvlE
IDAHO POWER
Low Income Weatherization
Assistance Program
OTHER
ADDITIONAL ELIGIBLE DWELLINGS
Idaho Power Contract Pg 2 Section 2
IDAHO POWER REFERRALS
TRAININ G
IDAHO POWER AUDIT ON NON LOW -INCOME HOMES
OTHER
UCT-Ll ~~ TliU lL:~~ I'M ~""VM .l1l11Vlt r~A avo llUO/JJ~JJJ r. l
IDAHO LOW-INCOME WEATHERIZATION
Future of Idaho s Low-Income Citizens
Idaho Power Company
October 21, 1999
Agenda
Introductions
The Weatherization need in Idaho Power Service Territory
Cunent Program Design
How docs it work
What measures are covered
Baniers to ful1y addressing the need
Program changes that will improve program effectiveness
STATE OF IDAHO
Low-Income Weatherization Program
December 1998 through March 1999 Heating Season (LIHEAP bill
assistance)
Eligible Idaho Households
Total Idaho Power Households
Total Eligible Idaho Recipients
Total Elderly /Handicapped/Child 0-
21,230
990
53,884
16,982
33%
31.
Homes weatherized with Idaho power LIW AP Jan 98-Nov 98
Homes comp1eted state wide 272
This in comparison to eligible households for 98/99
Households still eligible to receive Idaho Power LIW AP 96%
Average cost from three agencies (EI-Ada, ceo A, SeCM)
Note: these Agencies receive major portion of Idaho Power LIWAP
Apri198-March 99 (Department of Energy Contract Period)Total homes completed 687 (without Id Power LIW AP)Total cost $1,044,722.
A vcrage home cost $ 1,521.
Idaho Power Homes complete 245
Total Idaho Power cost invested S 137,249.
Average Idaho Power cost $ 560.
Total homcs completed with DOElId Power LIW APTotal homes completed 687
Idaho power homes completed 36%
Total DOElIdaho Power Cost
Total home cost
Average home cost
$1.181 971.00
$ 1 720.
(Based on 245 Domes)
Total DOE average cost $1 521.00 x 245 homes = $372,645.
Total Idaho PowerLIWAP average cost $560.00 x 245 homes= $137,249.
Combined DOE cost + Idaho Power LlWAP cost-- $509,894.
DOE Percent 73%
Idaho Power Percent 27%
V\d ':'1 JJ IllU 1.(.' JO fm .:II", I",VJlWJ.. l1.vllVU "\ uv,i I.UU 1.J")oJ.J.J.J
CURRENT PROGRAM DESIGN
Idaho Power Pays 50% of Eligible Weatherization Measures
determined by DOE regulations and the State of idaho Energy
Audit
An measures must have a savings to investment ratio (SIR) of
1 or greater
Eligibility is based on 133% OMB Guidelines
Certain measures are eligible under Supplementa1 Programs
i.e. - water heater replacement, electrical upgrades
U\,I Ll-jj IhU lL:jl ~M :, \., \.,VMtIi. AI,! i VJ.1 .l'i\A !tv.LUtJl jjjJ)J r.
B arri ers
In reality current Program Design does not calculate 50/50 split for
expenditures.
Only the measure receiving (SIR's) Energy Saving savings are considered.
Health and Safety Issues are left to be covered by Department of Energy.
Program Changes Towards Effectiveness
Al1ow true 50% split on total cost of home.
Perhaps gear program simi1ar to Bonneville Power Administration (BP A)
Low-Income Weatherization Program.
nclude Health and Safety measures.
Include electric fumace repair and/or replacement.
Electronic Claim Filing (eliminate hand copying)
208-377-0859 TO: 1208~339355 I
,::
PAGE: 03
! ::.i
, i:i~
I ~~
I I!II 1\;;
. I:
; ,
~n PiptrGrey
Communi
I:Relatioll$ LeaderIdabo Power. Box 70irBoise, ID 83707" ' II [phone]
i :::
,,' .
Ii:
lIT
!~ '
!II "
iili '::i:
Annmick tf~nry and Kevin Vigl;~rs
Fl-Ada.lnc,
7nl F.44"'51 h.i~, 10 83114 i:
;'
I II':: I
' '
RF.: '2000 EL-ADA LlWA Con~rad
F.ncl is the 2000 LC)w-~com ~eatheriza'ion Assjsl~nce Pr?gram contract flom Idaho Power, Because POPulationshift.'i in Idaho Power s TernloTY *u may fln~ it change In the disbursement of the funds: !' Ii I ;
, i f.r:mof~he ntracti~fo ;~I~ndarye~beginningJa.nuary I and ending December 2000.
; ~ '" ,
' ,'s ~ cl~f1I'ge In th~ a?'lo
~ "
t o,fthe fu~lDg for ~on-~rofit Progr~m Funds. Each ag~cy may apply fi money to be
;, ~d ,",am this fund which: WI I !be awardC;CS at the dIscretion of lPeo:
: . ,. '
:: , ~ ~ed clis~olner count.. in .' ~'r service ~tory to determine your spebiftC allocation of moneys along ~i'hc os~erali()~ of the percent population:below poverty based on the 1990 Census
~:.
ntiact changes include:
~! .. Remo~a"()fthe require !ent that Eliiible Dwellings, Additional Eligibl~ Dwellings, and Eligible B~ildings be~: primarily heated b~ elec~iEity. '
II' . rro~ram' Funds !;hall n9t exceed ~n. average c~st Iimitation of 75% support labor/ ~verhead and not SS than 25%
, malenal Investment aver~ge per Eligible Dwelling Installed by the agency,
l~cIusion of allowable "Hear~and Safely Measures
" :
The SIR (saving:! to investmeRI ratio) is changed to 1,1 or greater,
A~ju5tments which li$ted the vpallowBble$ of installing plastic window coverings and repair or replacell1e~l of fossil fuelh~ating have been eliminated.
j , ; .
II!i,
!'
We w,:lcome suggestions you may\ljave em how to improve and bring more value _to the customers we all serv :. Please contact, me, Ol'd;Miir;e Ybarguen, Dan Olms~~d or Layn~ 000$01'1 or the s~ff listed below 'fyou have:~y suggestions. I' Ii , i
' ;;
lastly II aPt sendi~g 10 you two si ,ed copies 4Cthe abQve contract Would you pleiI$CI sign ~?th, keep one fo ~our OWl) filesd re 'mithe other to Sharon C ' , along wi~ the rll!quired Certificate of I..sarance as dCKribcd in ,"tio,.(e) oftbis' I
, , ", '
;~1 . I !i '1:
jti~~~ ~~,t1.l ~O ': IL
. ,
I ' I" I'
i'I
; It;...QI cL.
, ~-~
titI:. ,i' Ii, Susan f,iper Grey i ,
Comm
rnity Rtilati
pns Leader, Cor
~i.rate He~uarters OnWi?: Pat Sullivan! ca~~n Moran :Namp~ Jim JauregUI ,I r ! I Boise:: t ,?ruce Clevelan laJce W~n. RuslY Kirtley, Arden D~vis i :
twin E\.lJs: Jim Mason, Bob ~ubel, Mlke:Pohanka
,.,
. ocateUo: " ~iarsha loS$e i~nn Stokes,: Gary Moldenhauer, MBIk Lupo I, 'Vi ' i ' I :I I
" ,
" I " i; i 'ii
\1 !
' :;!,:: , ,
!: f
(I 1I I
,..~ .
! Ii
d=R
IDACORP Company
"'"O_~t(Q)r'lf JAN 05 2001
o. BOX 70 '
BOISE, IDAHO 83707
Jon Roholt
Delivery Services Leader
Idaho Power, Box 70, Boise,lD 83707
[phone]
1/3/01
Ken Robinette
South Central Community Action Agency
726 Shoshone St.
Twin Falls, ill 83303-0531
RE: 2001 SCCAA LIW A Contract
Enclosed is the 2001 Low-Income Weatherization Assistance Program contract from Idaho Power.
The term of the contract is for the calendar year beginning January I st and ending December 15th, 200 I.
There is a change in the amount of the funding for Non-Profit Program Funds. Each agency may apply for money to be
used from this fund which will be awarded at the discretion of IPCo.It is on a first come first served basis. The amount
for 2001 is $15,000 and all 5 Idaho Agencies may apply.
This year, we used only residential customer counts in your service tenitory to determine your specific allocation of
moneys along with consideration of the percent of population below poverty based in the 1990 Census.
Again, this year, the SIR (savings to investment ratio) is changed to 1.1 or greater.
Adjustments which listed the unallowables of installing plastic window coverings and repair or replacement of fossil fuel
heating have been eliminated.
We welcome suggestions you may have on how to improve and bring more value to the customers we all serve. Please
contact
myself, Sharon Carter or Pat Sullivan or the staff listed below if you have any suggestions.
Lastly, I am sending to you two signed copies of the above contract. Would you please sign both
, keep one for your own files
and return the other to Sharon Carter (Idaho Power, PO Box 70, Boise, Idaho 83707) along with the required Certificate of
Insurance as described in section 9 (e) of this document.
:::-----
Sincerely,~D)~
JonD. Roholt
Delivery Services Leader
COC: Jim JaureguiBoise: Blake Watson, Bruce Cleveland, Arden Davis
Twin Falls: Jim Mason, Mike Pohanka
Pocatello: Marsha Losser, Mark Lupo
Regional Managers: Denny Trumble, Keith Kolar, Kevin Whittier, Perry VanPatten
Corporate: Jerry Nielson and Jim BaggsLegal: Larry Ripley and Ric Gale
nA
R

2

3

20
0
1
20
0
1
Ll
W
A

D
o
l
l
a
r
s
EL
-
A
D
A
,

E
l
m
o
r
e

&

A
d
a
Co
u
n
t
i
e
s
,
CC
O
A
-
C
a
n
y
o
n

C
o
u
n
t
y

o
n
Ag
i
n
g
SC
C
A
A
-
So
u
t
h
C
e
n
t
r
a
l
Co
m
m
u
n
i
t
y

A
c
t
i
o
n

A
g
e
n
SE
I
C
A
-
S
o
u
t
h

E
a
s
t
e
r
n

I
d
a
h
o
Co
m
m
u
n
i
t
y

A
c
t
i
o
n
,
EI
S
S
A
-
Ea
s
t
e
m

I
d
a
h
o

S
p
e
c
i
a
l
Se
l
V
i
c
e
s

A
g
e
n
c
y
Id
a
h
o

A
g
e
n
c
i
e
s

A
l
l
o
c
a
t
i
o
n
Su
b
t
o
t
a
l
:
Id
a
h
o

N
o
n

P
r
o
f
i
t

P
o
o
l
el
i
g
ib
l
e

f
o
r

n
o
n
-
pr
o
f
i
t

p
o
o
l
el
i
g
i
b
l
e

f
o
r

n
o
n
-
pr
o
f
i
t

p
o
o
l
12
8
3
0
7
17
.
1
5
%
82
8
7
0
16
.
33
%
55
2
1
8
14
.
1
0
%
40
2
2
2
14
.
1
6
%
38
0
0
15
.
68
%
31
0
4
1
7
el
i
g
i
b
l
e

f
o
r

n
o
n
-
pr
o
f
i
t

p
o
o
l
el
i
g
i
b
l
e

f
o
r

n
o
n
-
pr
o
f
i
t

p
o
o
l
el
i
g
i
b
l
e

f
o
r

n
o
n
-
pr
o
f
i
t

p
o
o
l
15
.
00
0
1
$1
5
,
00
0
To
t
a
l

I
d
a
h
o

F
u
n
d
s
$,
2
1
2
,
5
3
4
1
$3
1
2
53
4
Ma
l
h
e
u
r

C
o
u
n
c
i
l

o
n

A
g
i
n
g
$2
3
,
09
1
""
:
'
G
"
""
"
,
.
.t,
.
~,

,'~
'
,
=
"
"
:
"
,
T
=
'
J
'
4
'
;
f'8
'
!
T
.
e
;
o
:
:
"
,
.
!
Or
e
g
o
n

T
o
t
a
l

F
u
n
d
s
$2
3
,
09
1
1

n
o
t

e
l
i
g
i
b
l
e

f
o
r

n
o
n
-
pr
o
f
i
t

p
o
o
l
ID

&

O
R

T
O
T
A
L

P
R
O
G
R
A
M
FU
N
D
S
$2
3
5
,
62
5
$3
3
5
62
5
Al
l
o
c
a
t
i
o
n

A
s
s
u
m
p
t
i
o
n
s
:
1:

U
s
e
d

R
e
s
i
d
e
n
t
i
a
l

C
u
s
t
o
m
e
r

C
o
u
n
t

o
n
l
y
32
1
2
7
3
2.

B
a
c
k
e
d

o
u
t

O
r
e
g
o
n

C
u
s
t
o
m
e
r
s
:

(
V
a
l
e
,

O
n
t
a
r
i
o
,
an
d

N
y
s
s
a
,

1
0
,
85
6
)
Cu
s
t
o
m
e
r

U
s
e
d

1
0

b
a
s
e

F
P
L

o
n
.
10
8
5
6
31
0
4
1
7
3.

B
a
c
k
e
d

o
u
t

O
r
e
g
o
n

d
o
l
l
a
r
s
:

2
3
,
09
1

a
n
d

1
5
,
00
0
no
n

p
r
o
f
i
t

p
o
o
l

m
o
n
e
y
4.

W
e
a
t
h
e
r
i
z
a
t
i
o
n

d
o
n
e

p
e
r

r
e
s
i
d
e
n
c
e

p
e
r

m
e
t
e
r
.
...
.
20
0
1

l
I
W
A

B
u
d
g
e
l

r
e
v
i
s
e
d
2
Re
v
i
s
e
d
:

3
/
2
2
/
0
1
(C (Q) (Pf 'JAN 05 2001
IDAHO POWER COMPANY
O. BOX 70
BOISE, IDAHO B3707
Jon Roholt
Delivery Services Leader
Idaho Power, Box 70, Boise, ID 83707
[phone]
IDACORP Company
1/3/01
Ken Robinette
South Central Community Action Agency
726 Shoshone St. .
Twin Falls, ill 83303-0531
RE: 2001 SCCAA LIW A Contract
Enclosed is the 2001 Low-Income Weatherization Assistance Program contract from Idaho Power.
The term of the contract is for the calendar year beginning January 1 st and ending December 15th, 2001.
There is a change in the amount of the funding for Non-Profit Program Funds, Each agency may apply for money to be
used from this fund which will be awarded at the discretion of IPCo, It is on a first come first served basis. The amount
for 2001 is $15 000 and all 5 Idaho Agencies may apply,
This year, we used only residential customer counts in your service territory to determine your specific allocation of
moneys along with consideration of the percent of population below poverty based in the 1990 Census,
Again, this year, the SIR (savings to investment ratio) is changed to 1.1 or greater.
Adjustments which listed the unallowables of installing plastic window coverings and repair or replacement of fossil fuel
heating have been eliminated,
We welcome suggestions you may have on how to improve and bring more value to the customers we all serve, Please contact
myself, Sharon Carter or Pat Sullivan or the staff listed below if you have any suggestions,
Lastly, I am sending to you two signed copies of the above contract. Would you please sign both, keep one for your own files
and return the other to Sharon Carter (Idaho Power, PO Box 70, Boise, Idaho 83707) along with the required Certificate o
Insurance as described in section 9 (e) of this document.
...- :::.--- -
Sincerely,~DJ~
Jon,D. Roholt
Delivery Services Leader
COC: Jim JaureguiBoise: Blake Watson, Bruce Cleveland, Arden Davis
Twin Falls: Jim Mason, Mike Pohanka
Pocatello: Marsha Losser, Mark Lupo
Regional Managers: Denny Trumble, Keith Kolar, Kevin Whittier, Peny VanPatten
Corporate: Jeny Nielson and Jim BaggsLegal: Larry Ripley and Ric Gale
Brad M. Purdy
Attorney at Law
Bar No. 3472
2019N, 17th St.
Boise, ID 83702
[phone]
FAX: [phone]
bmpurdy~hotmail. com
Attorney for Petitioner
Community Action Partnership
Association ofldaho and
American Association of
Retired Persons..
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION OF
IDAHO POWER COMPANY FOR AUTHORITY)
TO INCREASE ITS INTERIM AND BASE
RATES AND CHARGES FOR ELECTRIC SERVlCE
CASE NO.IPC-03-
COMMUNITY ACTION PARTNERSHIP ASSOCIATION OF IDAHO
DIRECT TESTIMONY OF KEN ROBINETTE
EXIBIT #808
EA-4 Energy Audit
Approved by u.s. Department of Energy
Utilized by Community Action Agencies
EA4 - Computerized Energy Audit Data Entry
Data entry of all turquoise colored cells should be done first. Turquoise colored cells denote the minimum data
entry that is required to successfully calculate most items on the sheet. If the turquoise cells are entered first, then as
Invest, CFM/50, Material, Area, Exist U and Prop U are entered from left to right, calculated values will appear (SIR
Savings BTU, etc,), If the turquoise cells are not entered first, then the error indicator "#DIV/O" will appear in those
cells where calcula~on is occurring where a division by 0 (zero) is included in the formula,
Heading Information
Date - enter the data entry date of the audit (01/01/2001)
Last Name - enter the Client's last name (Doe)
Agency - entry should already be displaying your Agency s name (CAP)
County - enter the County in which the Client resides (Idaho)
Prefix - enter the Prefix, if you Agency uses one (A)
Job# - enter the Job# (1111) note: do not enter alpha characters use PrefIX for alpha characters
Utility Participation - enter the Utility's name if there is Utility Participation (IP, BPA, etc,
Auditor - enter the Auditor s initials (JD)
Inspector - enter the Inspector s initials (RJ)
Dwelling Type - enter the type of Dwelling according to the following:
note: will display as 1/1/01
1 = Mobile Home
2 = Single Family
3 = Multi-Family three or less
4 = Multi-Family four or more
Additional Notes: Heading data entries must be consistent for proper reporting of completions, i,e, County,
Utility Participation, Auditor and Inspector are fields that are added to existing data and therefore should be consistent
as agreed upon between the State and the Agencies.
Windows Section
All window areas and U-values must be entered whether or not corrective measures are to be taken,
1, Ifwindows are not to be treated, areas may be combined if U-values are the same,
2, If U-values are not the same, each window area must be entered separately, showing the different values,
3, Ifwindows are to be treated, areas may be combined if the existing and proposed U-values are the same,
Investment -leave blank or enter 1 , or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
CFM/50 or Condition - enter a 1 to increase savings due to reduction in AC/Hr (1)
Material- enter the dollar amount of the individual line s material investment (121.43)
Labor - labor values will automatically calculate in the gray colored cells for windows installed by Agency
crews and you enter actual contractor labor costs (235,65) within the white colored cells for windows
installed using a contractor
Area - enter the total square footage of the individual line s window(s) (18)
Exist U - enter the appropriate U value from the Windows U Value chart(s) provided by the State (1,13)
Prop U - enter the appropriate U value from the Windows U Value chart(s) provided by the State (.31)
Additional Notes: Indiv~duallines are supplied for the entry of Replacement and Stonn windows because the
labor factors for each are different, enter the individual or grouping oflike U valued windows on the appropriate line,
After entry of Exist and Prop U values (if all turquoise colored cells have been data entered properly), then S-
Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should display properly. If you do not see these
numbers being generated, check data entry in the turquoise colored cells and in all cell entries for the individual item
row,
Doors Section
All door areas and U-values must be entered whether or not corrective measures are to be taken.
1, If doors are not to be treated, areas may be combined if U-values are the same,
2. If U-values are not the same, each door area must be entered separately, showing the different values,
3, If doors are to be treated, areas may be combined if the existing and proposed U-values are the same,
Investment - leave blank or enter 1, 2, 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
CFM/50 or Condition - enter a 1 to increase savings due to reduction in AClHr (1)
Material ~ enter the dollar amount of the individual line s material investment (142.43)
Labor - labor values will automatically calculate in the gray colored cells for doors installed by Agency
crews and you enter actual contractor labor costs (227.65) within the white colored cells for doors
installed using a contractor
Area - enter the total square footage of the individual line s doors(s) (18)
Exist U - enter the appropriate U value from the Doors U Value chart( s) provided by the State (1.13)
Prop U - enter the appropriate U value from the Doors U Value chart(s) provided by the State (,06)
Additional Notes: After entry of Exist and Prop U values (if all turquoise colored cells have been data entered
properly), then S-, Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should display properly, If you
do not see these numbers being generated, check data entry in the turquoise colored cells and in all cell entries for the
individual item s row,
Walls Section
All exterior wall areas, less window and door areas, must be entered whether or not corrective measures are to be taken,
Walls separating the conditioned space from an enclosed but unconditioned porch or attached garage are considered
buffered" walls,
1. If walls are not to be treated, areas may be combined if U-values are the same.
2, If U-values are not the same, each wall area must be entered separately, showing the different values,
3, Ifwalls are to be treated, areas may be combined if the existing and proposed U-values are the same.
Investment -leave blank or enter 1 , 2, 3 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
CFM/50 or Condition - enter a 1 to indicate that the wall is a "buffered" wall (1), leave blank: if the wall is
not buffered, see above for defInition of buffered wall
Material- enter the dollar amount of the individual line s material investment (2121.34)
Labor - labor values will automatically calculate in the gray colored cells for walls insulated by Agency
crews and you enter actual contractor labor costs (315,55) within the white colored cells for walls
insulated using a contractor
Area - enter the total square footage of the individual line s walles) (18)
Exist U - enter the appropriate U value from the Walls U Value chart(s) provided by the State (2,81)
Prop U - enter the appropriate U value from the Walls U Value chart(s) provided by the State (,029)
Additional Notes: After entry of Exist and Prop U values (if all turquoise colored cells have been data entered
properly), then S-, Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should display properly, If you
do not see these numbers being generated, check data entry in the turquoise colored cells and in all cell entries for the
individual item s row,
Ceilings Section
All attic areas must be entered whether or not corrective measures are to be taken,
1. If ceilings are not to be treated, areas may be combined if U-values are the same,
2. If U-values are not the same, each ceiling area must be entered separately, showing the different values,
3, If ceilings are to be treated, areas may be combined if the existing and proposed U-values are the same.
Investment - leave blank or enter 1 , 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
' '
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
Materia1- enter the dollar amount of the individual line s material investment (146,63)
Labor - labor values will automatically calculate in the gray colored cells for ceilings insulated by Agency
crews and you enter actual contractor labor costs (248,05) within the white colored cells for ceilings
insulated using a contractor
Area - enter the total square footage of the individual line s ceiling(s) (18)
Exist U - enter the appropriate U value from the Ceiling U Value chart(s) provided by the State (,292)
Prop U - enter the appropriate U value from the Ceiling U Value chart(s) provided by the State (,023)
Additional Notes: After entry of Exist and Prop U values (if all turquoise colored cells have been data entered
properly), then S-, Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should display properly. If youdo not see these numbers being generated, check data entry in the turquoise colored cells and in all cell entries for the
individual item s row,
Vents Section
All existing ventilation is to be reported whether or not corrective measures are to be taken.
1. Enter a (1) into the "Condition" colunm when: Ifhigh/low vents are present; it is possible to install high/low
venting; if there is a ceiling vapor barrier, This will reduce the required net free venting from "1/150" to "1/300"
2, The total square feet of existing net free attic ventilation must be entered,
3, Additional square feet of net free ventilation installed must also be entered.
Investment - leave blank or enter 1, 2, 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
CFM/50 or Condition - enter a 1 to indicate existing venting condition, see 1. above (1)
Material- enter the dollar amount of the individual line s material investment (72.10)
Labor - labor values will automatically calculate in the gray colored cells for venting installed by Agency
crews and you enter actual contractor labor costs (115.16) within the white colored cells for venting
installed using a contractor
Exist - enter the existing square footage of net free ventilation (1.75)
Prop - will display the proposed square footage of net free ventilation that need to be installed
Installed - enter the total square footage of net free ventilation installed
Additional Notes: After entry of all ceiling area(s) and if Condition is Ion either venting line
, "
Add" (net free
ventilation area) will be calculated (if all turquoise colored cells have been data entered properly), Then, if "Installed"(net free ventilation area) is entered, labor costs, Exist BTU and Prop BTU should display properly, If you do not seethese numbers being generated, check data entry in the turquoise colored cells and in all cell entries for the individual
item s row,
Floors Section
All floor areas must be entered whether or not corrective measures are to be taken, A buffering factor of ,5 is
automatically included to the heat loss formulas:
1. Enter a (1) into the "Condition" column on a tight line(s), if the foundation wall is a solid continuous barrier
between the crawl space and the elements. This will reduce the buffer factor to a .4.
2, Enter a (1) into the "Condition" column on an open line(s), if the crawl space is open to the elements. This
will reduce the buffer factor to ,
3, When floor area represents slab on grade or conditioned basement, F-values are to be entered and area is to
be expressed in lineal feet, not square footage,
Investment - leave blank or enter 1, 2, 3 , 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q 138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
CFM/50 or Condition - enter a 1 on the appropriate row to indicate whether floor is "open" or "tight"
see 1, and 2. above and enter only on the appropriate row to express existing conditions
Material- enter the dollar amount of the individual line s material investment (216.38)
Labor - labor values will automatically calculate in the gray colored cells for floors insulated by Agency
crews and you enter actual contractor labor costs (312,22) within the white colored cells for floors
insulated using a contractor
Area - enter the total square footage of the individual line s floor(s) (18) or
enter the linear footage for expression of an F value
Exist U - enter the appropriate U value from the Floors U Value chart(s) provided by the State (,238) or
enter the appropriate F value from the Values for Below Grade Walls chart supplied by the State
84) or enter the appropriate F value from the Concrete Slab Floor on Grade (,81)
Prop U - enter the appropriate U value from the Floors U Value chart(s) provided by the State (,031) or
enter the appropriate F value from the Values for Below Grade Walls chart supplied by the State
61) or enter the appropriate F value from the Concrete Slab Floor on Grade (.55)
Additional Notes: After entry of Exist and Prop U values (ifall turquoise colored cells have been data entered
properly), then S-, Savings BTU, Total BTIJ Savings %, Exist BTU and Prop BTIJ should display properly, If you
do not see these numbers being generated, check data entry in the turquoise colored cells and in all cell entries for the
individual item s row,
Infiltration Section
CFM/50 flow rate infonnation, Exist and Prop must be entered from blower door readings,
1. "CFM/50" is derIDed as the cubic feet per minute flow rate at a house pressure of 50 pascals.
2, The "natural" flow rate (AC/hr and cubic feet per minute per person fonnulas) takes into consideration
both wind and stack effects,
3, Site Exp, should be entered as follows:
1.5 for a house exposed to the elements, no building or trees close by (very exposed)
1 for a house in nonnal conditions, some trees or buildings close by (average exposure)
5 for a house that is shielded by buildings or trees, close by on at least three sides (minimal exposure)
4, Stories should be entered simply as the number of stories of the house (1) (1.5) (2) and so on
Investment -leave blank or enter 1 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
Material- enter the dollar amount of the individual line s material investment (47.36)
Labor - labor values will automatically calculate in the gray colored cells for infiltration measures installed
by Agency crews and you enter actual contractor labor costs (102,63) within the white colored cells
for infiltration measures installed using a contractor
CFM50 Exist - enter the appropriate blower door reading (2850)
CFM50 Prop - enter the appropriate blower door reading (1500)
Site Exp. - enter the appropriate site exposure rating, see 3. above (., 1, 1.5)
Stories - enter the appropriate number of stories, see 4. above (1 1.5
Additional Notes: After entry of Exist CFM/50 readings, minimum, maximum and cautionary CFM/50
readings will be generated and after site exposure and stories are entered (if all turquoise colored cells have been data
entered properly), then S-, Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should display properly,
If you do not see these numbers being generated, check data entry in the turquoise colored cells and in all cell entries for
the individual item s row,
Ducts Section
Existing ducts should be entered in lineal feet whether or not corrective measures are to be applied.
1. Duct systems are automatically considered un-insulated and located in an unconditioned space(s).
2. Ducts should be entered on the appropriate line, denoting whether they are supply or return,
1. Enter (1) into the "Insulated" column for ducting that is insulated (supply, re1:m"I! or in conditioned
space(s) as appropriate),
3, Enter the lineal feet only when ducting is/are not insulated and cannot be insulated.
Investment -leave blank or enter 1 , 2, 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
CFM/50 or Condition - enter a 1 on the appropriate row to indicate whether ducts are insulated
Material- enter the dollar amount of the individual line s material investment (86,13)
Labor - labor values will automatically calculate in the gray colored cells for ducts insulated by Agency
crews and you enter actual contractor labor costs (122.75) within the white colored cells for ducts
insulated using a contractor
Area - enter the total lineal feet of the appropriate duct as denoted on the rows (48)
Additional Notes: After entry oflinear feet of ducts (if all turquoise colored cells have been data entered
properly), then S-, Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should display properly, If youdo not see these numbers being generated, check data entry in the turquoise colored cells and in all cell entries for the
individual item s row,
Health & Safety Section
This section is for reporting health and safety information not covered elsewhere,
1. Where an area, already insulated, requires further venting and/or moisture control measures (exhaust fan
ground cover, etc,
2. Minor structural repairs required to protect weatherization materials,
3, Minor electrical repairs: fuse/circuit breaker replacement; repair connections, etc.
4. Minor plumbing repairs (replace/repair leaking pipe, elbow, union, etc,) to protect weatherization materials,
Investment - leave blank or enter 1, 2, 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (I138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
Material- enter the dollar amount of the individual line s material investment (36,14)
Labor - labor values wili automaticaliy calculate in the gray colored cells for Health and Safety work
completed by Agency crews and you enter actual contractor labor costs (75,00) within the white
colored cells for Health and Safety work completed using a contractor
Area - If applicable, enter the total square footage of the individual line (40)
Exist U - If applicable, enter the appropriate U value from the Windows, Doors, Walls, Ceilings, or Floors
U Value chart(s) provided by the State (,238
, ,
042, 1.13, etc.) although no values are needed to
represent "repairs , as deemed by DOE, within the Health and Safety Section and expenditures
expressed here are not subject to S-R requirements and no S-R is calculated
Prop U - If applicable, enter the appropriate U value from the Windows, Doors, Walls, Ceilings, or Floors
U Value chart(s) provided by the State (.238
, .
042, 1.13, etc.) although no values are needed to
represent "repairs , as defined by DOE, within the Health and Safety Section and expenditures
expressed here are not subject to S-R requirements and no S-R is calculated
Additional Notes: After entry of Area, Exist and Prop U values (if all turquoise colored cells have been data
entered properly), then Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should display properly, if
applicable. If you do not see these numbers being generated, check data entry in the turquoise colored cells and in all
cell entries for the individual item s row, If an improvement in U value resulted from the repairs done then the Savings
BTU etc, will calculate,
Other Investment Section
This section is for reporting other investment information not covered elsewhere,
1, Where investment in the home is from other sources than the State W AP funding.
i.!_Jf~iil~1il.A
Investment - 4 or 5 according to the following:
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
Material- enter the dollar amount of the individual line s material investment (291.36)
Labor - labor values will automatically calculate in the gray colored cells for Other Investment work
completed by Agency crews and you enter actual contractor labor costs (62,50) within the white
colored cells for Other Investment work completed using a contractor
Area - If applicable, enter the total square footage of the individual line (40)
Exist U - If applicable, enter the appropriate U value from the Windows, Doors, Walls, Ceilings, or Floors
U Value chart(s) provided by the State (.238 042 1.13 , etc,) although no values are needed to
represent expenditures in this section where non W AP funds are represented and are not subject to
R requirements and no S-R is calculated
Prop U - Ifapplicable, enter the appropriate U value from the Windows, Doors, Walls, Ceilings, or Floors
U Value chart(s) provided by the State (.238 042 1.13, etc.) although no values are needed to
represent expenditures in this section where non W AP funds are represented and are not subject to
R requirements and no S-R is ca1cuiated
Additional Notes: After entry of Area, Exist and Prop U values (if all turquoise colored cells have been data
entered properly), then Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should display properly, if
applicable. If you do not see these numbers being generated, check data entry in the turquoise colored cells and in all
cell entries for the individual item s row. If an improvement in U value resulted from the Other Investment work done
then the Savings BTU etc, will calculate.
Water Heater Section
1. Water heaters are automatically considered electric and located in an 1ll1conditioned area,
Fuel Price - enter the water heater s fuel source cost, electric or gas 1ll1der the appropriate heading Elect or
Gas (,071, 1.02)
Investment - leave blank or enter 1 , 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment AmO1ll1t" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amO1ll1t entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amO1ll1t entered into "Partial Investment AmO1ll1t" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amO1ll1t entered as a partial payment
CFM/50 or Condition - enter a 1 in the "Condition" column on the row identified as "insulated" to indicate
an existing, insulated water heater and/or enter a 1 on the row identified as "gas" to indicate an
existing gas water heater and/or enter a 1 on the row identified as "repair" to indicate repair
expenditures for the water heater (Future, " or enter a 1 on the row identified as "replace" to indicate
replacement expenditures for a new water heater)
Material- enter the dollar amount of the individual line s material investment (14,38)
Labor - labor values will automatically calculate in the gray colored cells for water heater work completed by
Agency crews and you enter actual contractor labor costs (52.50) within the white colored cells for
water heater work completed using a contractor
Diameter - enter the diameter of the water heater in inches (15)
Height - enter the height of the water heater in inches (50)
Exist Temp - enter the water heater s existing temperature setting (145)
Prop Temp - enter the water heater s proposed temperature setting (120)
Number in home -=- enter the number of people in the home (6)
Exist KWHNr - (future", enter existing KWHNr figure that is produced by running DOE's water heater
replacement program, actual program is currently due for release sometime in 2003) (2185)
Prop KWYNr - (future ." enter proposed KWHlYr figure that is produced by running DOE's water heater
replacement program, actual program is currently due for release sometime in 2003) (1550)
R - (future", enter S-R that is produced by rmming DOE's water heater replacement program, actual
program is currently due forrelease sometime in 2003) (1.01)
Additional Notes: After entry of fuel source, diameter, height, temperature, number in home, material and
labor costs if applicable (if all turquoise colored cells have been data entered properly), Savings BTU, Total BTU
Savings %, Exist BTU and Prop BTU should display properly. If you do not see these numbers being generated, check
data entry in the turquoise colored cells and in all cell entries for the individual item s row, The number in home is used
not only for calculating water usage and its related energy savings but also for calculating target, minimum and
cautionary cfm/50 flow rates as established by ASHRAE for the Infiltration and CFM/50 Sections,
Pipes Section
The lineal feet of existing water pipe should be entered whether or not corrective action is to be taken,
1, Water pipes are automatically considered un-insulated and located in an unconditioned space.
Investment -leave blank or enter 1 , 2, 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
CFM/50 or Condition - enter a 1 on the appropriate row to indicate whether pipes represented are
insulated" or in a "conditioned" space
Material- enter the dollar amount of the individual line s material investment (21.43)
Labor - labor values will automatically calculate in the gray colored cells for pipes insulated by Agency
crews and you enter actual contractor labor costs (45.00) within the white colored cells for pipes
insulated using a contractor
Area - enter the total lineal feet of the pipes as denoted on the appropriate row (65)
Additional Notes: After entry oflineal feet of pipes (if all turquoise colored cells have been data entered
properly), then S-, Savings BTIJ, Total BTIJ Savings %, Exist BTIJ and Prop BTUshould display properly, If youdo not see these numbers being generated, check data entry in the turquoise colored cells and in all cell entries for the
individual item s row,
Refrigerator Replacement Section
Data entry (Exist KWH/Hr, Prop KWH/Hr and S-R) for use in this section is produced from an Access 2000 program
developed by DOE that uses tables of manufacturer and model numbers from refrigerators to evaluate existing and
proposed KWHlYr (Energy Star ratings), taking into account the expected lifetime and appropriate discount factors in
the calculation of a S-R, The program (Replace Refrig-Access 2000,mdb) must be run in Access 2000 or later, the
program is free for downloading at:
http://www,waptac-pic,orgibaseload/analvsis,htm and procedures at
http://www,waptac-pic.org/BaseLoad,htm along with supporting documentation at
http://www,waptac-pic,orgfbaseload/files/Toolkit07,PDF and
http://www,waptac-pic.org/baseload/files/FrigreplaceWX,pdf as well as other refrigerator energy use data at
http://www, waptac-pic,org/baseload/refrigdata.htm
~i'lllj~i!~!
Investment - leave blank or enter l , 2, 3 , 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private lOO% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (I13 8) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs fua..,
the amount entered as a partial payment
Material- enter the dollar amount of the replacement refrigerator s material investment (420.00)
Labor - enter actual Agency or contractor labor costs within the white colored cells for the refrigerator
replacement (135,00)
Exist KWY /Y r - enter the KWHlHr figure that is produced by running Replace Refrig-Access 2000,mdb as
developed by D&R International, Ltd" for DOE to establish an existing KWH/Yr (2250)
Prop KWY /Y r - enter the KWHlHr figure that is produced by running Replace Refrig-Access 2000,mdb as
developed by D&R International, Ltd" for DOE to establish a proposed KWH/Yr (1250)
R - enter the S-R figure that is produced by running Replace Refrig-Access 2000,mdb as
developed by D&R International, Ltd., for DOE to establish an existing KWH/Yr (1.36)
Additional Notes: After entry of Exist and Prop KWH/Yr as well as S-R (if all turquoise colored cells have
been data entered properly), then Savings BTU, Total BTU Savmgs%, Exist BTU and Prop BTU should display
properly, If you do not see these numbers being generated, check data entry in the turquoise colored cells and in all cell
entries for the individual item s row.
Furnace Section
Existing and proposed seasonal efficiencies
, "
Seas Efr' must be entered whether or not corrective action is to be taken,
even if a furnace replacement is proposed.
1, If no measures are performed, enter the same figure for both existing and proposed seasonal efficiency.
2, If "tune-up" or "modify" measures are performed and results in improved efficiency, enter the fmal proposed
seasonal efficiency after work is completed and the unit's seasonal efficiency is documented with a field test,
3, Ifrepairs are being represented, enter the same existing and proposed seasonal efficiency on either the
tune-up or modify line
~ 1 I ~
~ ~ ~ ~
j 1
Investment -leave blank or enter 1 , 2, 3 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to bit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to bit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
Material- enter the dollar amount of the individual line s material investment (157.43)
Labor - enter actual Agency or contractor labor costs within the wbite colored cells for furnace work
completed on the unit (175,00)
Exist Seas Eff - enter the appropriate seasonal efficiency value from the Heating Systems Seasonal
Efficiencies Value chart(s) provided by the State (,10)
Prop Seas Eff - enter the appropriate seasonal efficiency value from the Heating Systems Seasonal
Efficiencies Value chart(s) provided by the State (2,00)
Additional Notes: Enter data on the appropriate line for "tune-up
, "
modify" or "repair" as applicable but only
on one row, After entry of Exist Seas Effand Prop Seas Eff (if all turquoise colored cells have been data entered
properly), then S-R (except on repair row), Savings BTU, Total BTU Savings %, Exist BTU and Prop BTU should
display properly, If you do not see these numbers being generated, check data entry in the turquoise colored cells and in
all cell entries for the individual item s row,
Site Infonnation, CFM/50, Furnace Replacement and Job Totals Section
Volume - enter the home s volume in cubic feet (3733)
Elev - enter the appropriate elevation in feet from the Station/HDD/Elevation/Design Temperature chart(s)
provided by the State or specific elevation sites may be provided by the agency, (2480)
HDD - enter the appropriate heating degree days from the StationIHDD/Elevation/Design Temperature,
chart(s) provided by the State (2480)
Des Temp - enter the appropriate design temperature from the StationIHDD/Elevation/Design Temperature
chart(s) provided by the State (2480)
Fuel Price - enter only the client's primary fuel source s price under the appropriate "Elect"
, "
Gas
, "
Wood"
Oil"
, "
Coal" or "Propane" label (price to be agreed upon between the State and Agency or as provided
by a vendor receipt/documentation received from the client) (.065, 1.02, 95., 1.85, 110,, 1.95)
Audit Investment - leave blank or enter 1 , 2, 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
BTU input of Open Combustion Appliance - enter the BTU input of any open combustion appliance
located in the conditioned space of the home as identified on the appliance s label, serial plate or other
such manufacturer/model information directly related to the unit (15000)
Replacement - enter a 1 if the client's primary furnace is being replaced
Health & Safety - enter a 1 if the furnace replacement is Health and Safety related
Investment - leave blank or enter 1 , 2, 3, 4 or 5 according to the following:
blank = Agency 100% of cost
1 = Utility 100% of cost
2 = Utility 50% of cost
3 = Utility provides the amount entered into "Partial Investment Amount" (Q138) under
Utility Investment section, this allows you to hit an exact total dollar
investment amount for Utility, only one "3" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
4 = Private 100% of cost
5 = Private provides the amount entered into "Partial Investment Amount" (1138) under
Private Investment section, this allows you to hit an exact total dollar
investment amount for Private, only one "5" should appear on any job
and should only be applied to a line item that is larger in total material and labor costs than
the amount entered as a partial payment
Seasonal Eff - enter the appropriate seasonal efficiency value for the replacement furnace from the Heating
Systems Seasonal Efficiencies Value chart(s) provided by the State (2,00)
Material Cost - enter the material dollar amount of the furnace replacement (425.00)
Labor Cost - enter the labor dollar amount of the furnace replacement (550,00)
Fuel Price - enter the price of the replacement furnace s fuel source besides the appropriate fuel source label
Elect"
, "
Gas
, "
Wood"
, "
Oil"
, "
Coal" or "Propane" label (price to be agreed upon between the State
and Agency or as provided by a vendor receipt/documentation received from the client) (,065, 1,95,, 1.85, 110,, 1.95)
Actual Hrs - enter the total "production" hours for Agency crew(s) needed to complete all work on the
home, as derIDed by the State (32)
Contract Labor - enter the total of all contractor labor costs expressed in EA4 (283,00)
Client Income - enter the Client's annual income as documented on the W AP application (12400)
Total Floor Area - enter the total square footage area represented in EA4 (539)
Actual Energy Use Exist - enter annual energy used by client's primary heating source as
estimated/directed by the State or documented by actual Utility billing information if available (2035)
Additional Notes: After entry of all data (if all turquoise colored cells have been data entered properly), then
Estimates ofTotalBTUSavings, CFM per Person Exist and Prop, CFM/50 Target/Minimum/Cautionary, Total Job
R and other totaling in this section should display properly, If you do not see these numbers being generated, checkdata entry in the turquoise colored cells and in all cell entries within this section,
Private and Utility Section
Partial Investment Amount (under Private Investment) - enter the amount of money desired to be
allocated to private investment as identified with a 5 in the "Investment" colunm ofEA4, Only one 5 may appear on an
entire Job to calculate total investments correctly and should only be applied to a line item that is larger in total material
and labor costs than the amount entered as a partial payment, Use this cell to round up to an exact Private Investment
Total as calculated and displayed in the "Total" row in the lower section under "Private Investment"
Partial Investment Amount (under Utility Investment) - enter the amount of money desired to be
allocated to utility investment as identified with a 3 in the "Investment" colunm ofEA4. Only one 3 may appear on an
entire Job to calculate total investments correctly and should only be applied to a line item that is larger in total material
and labor costs than the amount entered as a partial payment. Use this cell to round up to an exact Utility Investment
Total as calculated and displayed in the "Total" row in the lower section under "Utility Investment"
How to Create the CSV File from the XLS File
You can produce the csv file needed nom EA4 for WITS, quite simply in spite of Microsoft's confusing and
threatening interface, Once you have completed an audit on EA4 and saved the file, all the data that makes up the csv
file should be displayed on the sheet labeled "EA4-CSV"
1, Select the EA4-CSV tab to go to that sheet, click File, Save As
2, Activate the drop down list box aligned with "Save as type:" (by clicking the down pointing triangle)3. Scroll down to "CSV (Comma delimited)(*csv) and click it. Note: If you have previously saved the
EA4 file as say 4265,x1s, then the name for the csv file will automatically be supplied and the csv
file s name will be shown as 4265,csv,
4. Navigate (browse) to where you want to store the csv file and then click Save.
5, You will then receive a warning of sorts about
, "
". selected file type does not support workbooks
that contain multiple sheets, .., ", ignore the warning and click OK
6, You ll then be told that
, "
", 4265,csv may contain features that are not compatible with CSV
(Comma delimited), Do you want to keep the workbook in this format? .. ., be brave, ignore the warning
and click Yes
7, Exit Excel but upon exiting, DO NOT SAVE the file again!!! Click "" when asked
, "
Do you want
to save the changes you made to 4265,csv!" and you will fmally exit Excel.
Microsoft really designed a confusing interface for the saving of data into a comma delimited file format but if
done successfully, you should now have both a 4265,xls and 4265.csv file, Process both files as you do now.
Common Data Entry Errors Discovered During Beta Testing of EA4
#NAME!"
, "
#DIV/O!" and "#V ALDE!" error indicators happen when data entry errors have occurred. If yousee the error indicator #NAME!, check your data entry for double periods, like an electricity rate of ,65 or ..065.
#NAME! indicates that Excel thinks that you are trying to give it a cell name (HDD) to go to instead of a legal cell
reference (AI) and #Value! usually means that there is an alpha character in a numeric field, or even a blank space
" "
an entry,
As mentioned earlier, a #DIV/O! error indicator is saying that somewhere in the cell's or cells' fonnula, a
division is occurring using a 0 (zero). This will most likely happen if you don t enter all the data in the turquoise colored
cells before you enter Material, Area, Exist U and Prop U or you have inadvertently entered a 0 as data entry,
Remember that the format of some of the cells is a fIXed number of decimal places so if data entry error occurs, sayentering .065 as ,00065, you may only see the value 0 in the cell.
Another time that you will see #DIV/O! is if you delete the material money or area from a line that still has Exist
and Prop U values entered, EA4 was developed for data entry to occur as follows, all turquoise colored cells and then
data on the individual measure rows (lines) nom left to right. If you follow this pattern, then you will have immediate
display of all the relevant calculations, If you complete an individual line s input and the calculated values don t showup immediately, that is an indicator that data entry is not correct on the line just entered,
When completing many EA4s together, it would probably be safest to open a new audit file nom the original
EA4,xls file for each job that you are entering. You can indeed delete all the data entry done by selecting the cells and
hitting the delete or backspace keys. However, if you accidentally leave anything, even a blank space
" "
in a cell nomthe previous job, you will not be able to visibly see the data entry error causing the error indicator but EA4 will display
the #V ALDE! error indicator in numerous places. This error is especially hard to track down because it usually is not
being caused by anything that you can visually see on the screen.
KENT (M 4k.t
Kearns ENTerprises