Aaron F. Snyder
Utility Business Solutions
March 13, 2002
© ABB Inc. - USETI
All Rights Reserved
10/3/2015
Insert image
here
Insert image
here
An Economic Analysis
Development
Framework for
Distributed Resources
Insert image
here
Presentation Outline
Introduction

Software Framework

Application

Conclusions
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 2 -

Introduction

Problem Statement


© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 3 -

Is DR an attractive financial alternative to my current grid
connection?
Traditional Analysis Tools Lack Solution Capability at
High Level

Too much data required for technical calculation

No limited data set common in packages to perform financial
calculation

Package focused on single DR solution or solution approach
Can COTS solution run on my computer platform?
Presentation Outline
Introduction

Software Framework

Application

Conclusions
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 4 -

Software Framework

Standard Office Application (Excel) leads to Ease-of-Use

Development Language (VBA) leads to stand-alone
migration path

Flexibility in time-series data manipulation (15-min to 1 year)

Cookie-cutter solution for other time-series intervals
User interface based on commonly accepted graphic
components (push-buttons, dialog boxes, check boxes,
etc.)

Ease of deployment across business network
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 5 -

Software Framework
S ta rt
In p u t S c re e n

Dual-Path Data Approach

E x is tin g S e rvic e
L o a d P ro file
E x is tin g S e rvic e
N o L o a d P ro file
D G D a ta
L o a d P ro file
D G D a ta
N o L o a d P ro file
Load Profile
V irtu a l U tility
F in a n c e
S o lu tio n s


No Load Profile
R a te U p d a te
W iz a rd
S ta rt
Data Sets
O u tp u t S c re e n
D a ta S h e e ts
R e p o rts
D ie s e l G e n e ra to r
F u e l C e ll
G ra p h s
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 6 -
M ic ro T u rb in e

Existing Service

Dist. Res.
E X IT
In p u t S c re e n
E x is tin g S e rvic e
L o a d P ro file
E x is tin g S e rvic e
N o L o a d P ro file
D G D a ta
L o a d P ro file
D G D a ta
N o L o a d P ro file
V irtu a l U tility
In p u t S c re e n
Software Framework
S ta rt
In p u t S c re e n

Common Data Path

E x is tin g S e rvic e
L o a d P ro file
E x is tin g S e rvic e
L o a d P ro file
E x is tin g S e rvic e
N o L o a d P ro file
D G D a ta
L o a d P ro file
D G D a ta
N o L o a d P ro file
Virtual Utility
E x is tin g S e rvic e
N o L o a d P ro file
V irtu a l U tility
F in a n c e
S o lu tio n s


Finance Solutions
R a te U p d a te
W iz a rd
D G D a ta
L o a d P ro file
Output Screen
D a ta S h e e ts
O u tp u t S c re e n
D G D a ta
N o L o a d P ro file
R e p o rts
D ie s e l G e n e ra to r
F u e l C e ll
G ra p h s
M ic ro T u rb in e
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 7 -


Solution with Existing Service

Solution with Dist. Res.
Rate Update Wizard

Rate-Tier Input

Average Rate Input
R a te U p d a te
W iz a rd
E X IT
V irtu a l U tility
F in a n c e
S o lu tio n s
O u tp u t S c re e n
E x is tin g S e rvic e
L o a d P ro file
E x is tin g S e rvic e
N o L o a d P ro file
D G D a ta
L o a d P ro file
D G D a ta
N o L o a d P ro file
Software Framework
S ta rt

In p u t S c re e n
Detailed Reports

Summary Report of Key
Financial Factors
E x is tin g S e rvic e
L o a d P ro file
E x is tin g S e rvic e
N o L o a d P ro file
D G D a ta
L o a d P ro file
D G D a ta
N o L o a d P ro file
V irtu a l U tility
V irtu a l U tility
F in a n c e
S o lu tio n s
R a te U p d a te
W iz a rd


D a ta S h e e ts
R e p o rts
D ie s e l G e n e ra to r
F u e l C e ll
G ra p h s
F in a n c e
S o lu tio n s
M ic ro T u rb in e
E X IT
Detailed Graphs



Detailed Financials by Time
Period
O u tp u t S c re e n
Electrical Energy
Heat Energy
R a te U p d a te
W iz a rd
O u tp u t S c re e n
Database Provisions

DR Rate Sheets

Common Data Structure
D a ta S h e e ts
R e p o rts
D ie s e l G e n e ra to r
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 8 -
F u e l C e ll
G ra p h s
M ic ro T u rb in e
E X IT
Presentation Outline
Introduction

Software Framework

Application

Conclusions
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 9 -

Application

Key parameters

1900kW Load

1700kW Utility Connection

© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 10 -

23kW CHP DR
Yearly Load Profile Available
(15-minute intervals)

Cost

Energy
D R In fo rm a tio n
L o a d (D e m a n d ) to tu rn D R O n
(p e a k s h a vin g )
R a te to tu rn D R O n (p e a k
s h a vin g )
E xp e c te d N um b e r o f Y e a rs o f
R e tu rn o f In ve s tm e n t
D R F ix e d C o s ts (lu m p s u m )
D R In itial C o st (P ric e +
S h ip p in g + Ins ta llatio n )
F u e l S to ra g e C o st
L a n d F e e C o st
M e te rin g C o s t
O th e r F ixe d C o s ts
D R F ix e d C re d its
T a x C re d it p e r ye a r
P o w e r Q u a lity C re d its (p e r
kW h )
E n viro n m e nta l C re d its
D R O p e ra tio n al / An n u a l
C o s ts
D R S ize
D R F u e l P ric e
O p e ra tin g & M a in te n a n c e
C o s ts
D R P o w e r F a c to r at R a te d
Load
H e a t R a te
kW
1700
$ /kW h
0 .0 6 5
ye a rs
20
$
1 8 0 ,0 0 0 .0 0
$
$
$
$
1 0 ,0 0 0 .0 0
1 ,5 0 0 .0 0
5 0 0 .0 0
1 ,0 0 0 .0 0
$ /ye a r
$ /kW h
1 ,5 0 0 .0 0
0 .0 0 5
$ /kW h
0 .0 0 5
kW
$ /kW h
$ /ye a r
230
0 .0 1 5
5 ,0 0 0 .0 0
"-1 " to "1 "
B tu /kW h
0
10000
Application
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 11 -
Load
L o a d F a c to r
M o n th ly C h a rg e
M o n th ly D e m a n d C h a rg e
M o n th ly C u rta ilm e n t C re d its
M o n th ly C u rta ilm e n t
P e n a lties
R e a c tive P o w e r P e n a ltie s
R e a c tive P o w e r C re d its
P o w e r F a c to r S e t-P o int
(P e n a lty/C re d it)
kW
from "0" to "1"
$ /m o n th
$ /m o n th
$ /m o n th
$ /m o n th
$ /kV A R
$ /kV A R
"-1 " to "1 "
V U C o s ts
V U A cc e ss F e e
V U A p p lic atio n s P ack a g e s
V U H a rd w a re (s e rve rs ,
c om m u nic atio n s )
V U o th e r c os ts
B e n e fits :
N u m b e r of o uta g e s p e r ye a r
C o s t of o uta g e
E n e rg y A va ila b le fo r T ra d in g
p e r m o n th
E xp e c te d S e llin g P ric e
1900
1
8 0 ,0 0 0 .0 0
5 ,0 0 0 .0 0
2 ,0 0 0 .0 0
2 ,5 0 0 .0 0
0 .0 1 5
0 .0 1 5
0 .8 5
$
$
$
1 ,5 0 0 .0 0
8 ,0 0 0 .0 0
2 0 ,0 0 0 .0 0
$
5 ,0 0 0 .0 0
o u ta g e /ye a r
$ /o u ta g e
kW h
$ /kW h
4
2 5 ,0 0 0 .0 0
2 1 ,6 0 0
0 .0 5
Application
T o ta l C os t o f V U
In itia l C o st of D R
D o w n p a ym e n t
Loan
In te re st (p e r ye a r)
N o . o f ye a rs
D is c o u nt/In flatio n R a te
kW h L im it
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 12 -
250
300
400
550
650
$
$
$
$
%
ye a r
%
3 4 ,5 0 0 .0 0
1 9 3 ,0 0 0 .0 0
2 5 ,0 0 0 .0 0
2 0 2 ,5 0 0 .0 0
7 .0 0
20
2 .0 0
O n -P e a k C o s t
($ /kW h )
0 .0 8
0 .0 7
0 .0 6
0 .0 5
0 .0 4
O ff-P e a k C o s t
($ /kW h )
0 .0 7 5
0 .0 6 5
0 .0 5 5
0 .0 4 5
0 .0 3 5
Application
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 13 -
W ith o u t V irtu a l U tility
T o ta l us e
A ve ra g e u s e
T o ta l c os t
A ve ra g e c o st
W ith V irtu al U tility
T o ta l us e
A ve ra g e u s e
T o ta l c os t
A ve ra g e c o st
S a v in g s
T o ta l us e
A ve ra g e u s e
T o ta l c os t
A ve ra g e c o st
A n n u a l E le c tric ity B ill
A n n u a l S a v in g s o n
E le c tricity B ill
kW h /ye a r
kW h /p e rio d
$ /ye a r
$ /p e rio d
2 2 ,6 6 5 ,0 6 0
6 4 6 .8 3
$ 7 1 4 ,7 8 9 .3 1
$ 2 0 .4 0
kW h /ye a r
kW h /p e rio d
$ /ye a r
$ /p e rio d
1 0 ,6 1 7 ,4 7 6 .0 0
3 0 3 .0 1
$ 5 7 0 ,3 3 5 .5 6
$ 1 6 .2 8
kW h /ye a r
kW h /p e rio d
$ /ye a r
$ /p e rio d
U tility o n ly
U tility a n d D R
1 2 ,0 4 7 ,5 8 4 .0 0
3 4 3 .8 2
$ 1 4 4 ,4 5 3 .7 5
$ 4 .1 2
$ 1 ,7 4 0 ,7 8 9 .3 1
$ 6 4 3 ,7 2 3 .4 8
$ 1 ,0 9 7 ,0 6 5 .8 3
Application
Av e ra g e 1 5 /3 0 /6 0 -m in L o a d P ro file
(w ith o u t V U )
6 0 0 .0 0 0 0
L o a d (k W h )
5 0 0 .0 0 0 0
4 0 0 .0 0 0 0
3 0 0 .0 0 0 0
2 0 0 .0 0 0 0
1 0 0 .0 0 0 0
2 3 :0 0
2 1 :1 5
1 9 :3 0
1 7 :4 5
1 6 :0 0
1 4 :1 5
1 2 :3 0
1 0 :4 5
9 :0 0
7 :1 5
5 :3 0
3 :4 5
2 :0 0
0 :1 5
-
T im e (H o u rs :M in u te s )
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 14 -
F ig ure 1 : 15 -M in u te L o a d P rofile w itho u t V U /D R
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 15 -
Application
Presentation Outline
Introduction

Software Framework

Application

Conclusions
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 16 -

Conclusions

Development Achievements

Minimal data set for each type of distributed resource required

Visual Basic for Applications code allows for future portability to
complied stand-alone application

Intuitive user interface requires minimal training

Solution details minimal yet optimal

Software architecture allows for scalable solution
Financial Analysis Tool Complimentary to Technical
Analysis Tool

Solution Deployable on Common Computing Platform
with Minimal Hardware Requirements
© ABB Inc. - USETI
All Rights Reserved
10/3/2015 - 17 -

Descargar

UBS Template (reduced)