(u 338 e) · 1 ramp power bi access form & sign‐up instructions 1.5 1 ramp power bi user guide...
TRANSCRIPT
-
(U 338‐E)
Southern California Edison Company’s Risk Assessment and Mitigation Phase
I.18‐11‐006
Workpapers
Rosemead CA
November 15, 2018
-
-
Excel versions of Workpapers are available online 1. Go to www.sce.com/applications 2. Select SCE 2018 RAMP 3. In the new window, select Zipped document
1 of 4
2018 SCE Risk Assessment Mitigation Phase (RAMP)
SCE 2018 RAMP Workpapers
Index of Workpapers CH DOCUMENT NAME PAGE(S)
1 2013 – 2023 Recorded and Forecast Costs for Controls & Mitigations 1.1
1 Risk Register to RAMP Risk Mapping 1.2
1 RAMP Power BI Access Form & Sign‐up Instructions 1.5
1 RAMP Power BI User Guide 1.9
1 EEI Serious Injury Definition 1.41
1 WP Ch. 1 ‐ 2013‐2023 Recorded and Forecast Costs for Controls & Mitigations Excel
1 WP Ch. 1 ‐ Risk Register to RAMP Risk Mapping Excel
2 Risk Model Lessons Learned ‐ Additional Detail 2.1
3 2014 – 2018 CPUC Reported Public Serious Injuries 3.1
3 Safety Culture Transformation Roadmap 3.31
4 Baseline Risk Assessment 4.1
4 Control & Mitigation Risk Reduction Effectiveness 4.5
4 SME Qualifications 4.13
4 WP Ch. 4 ‐ Baseline Risk Assessment Excel
4 WP Ch. 4 ‐ Control Mitigation Risk Reduction Effectiveness Excel
5 Baseline Risk Assessment 5.1
5 Control & Mitigation Risk Reduction Effectiveness 5.3
5 Mitigation Effectiveness Workpaper 5.12
5 WP Ch. 5 ‐ Baseline Risk Assessment Excel
5 WP Ch. 5 ‐ Control & Mitigation Risk Reduction Effectiveness Excel
-
Excel versions of Workpapers are available online 1. Go to www.sce.com/applications 2. Select SCE 2018 RAMP 3. In the new window, select Zipped document
2 of 4
2018 SCE Risk Assessment Mitigation Phase (RAMP)
SCE 2018 RAMP Workpapers
Index of Workpapers CH DOCUMENT NAME PAGE(S)
5 WP Ch. 5 ‐ Mitigation Effectiveness Workpaper Excel
6 Baseline Risk Assessment 6.1
6 Subject Matter Expert Qualifications 6.5
6 Outcome‐Based Risk Reduction Model Overview 6.7
6 WP Ch. 6 ‐ Baseline Risk Assessment Workpaper Excel
7 Baseline Risk Assessment 7.1
7 RAMP Mitigation Reduction Workpaper 7.5
7 Subject Matter Expert Qualifications 7.19
7 Safety Standards, Programs, and Policies 7.20
7 WP Ch. 7 ‐ RAMP Mitigation Reduction Workpaper Excel
7 WP Ch. 7 ‐ Safety Standards Programs and Policies Excel
7 WP Ch.7 ‐ Baseline Risk Assessment Excel
8 Baseline Risk Assessment 8.1
8 Control & Mitigation Risk Reduction Effectiveness 8.4
8 SME Qualifications 8.14
8 WP Ch. 8 ‐ Baseline Risk Excel
8 WP Ch. 8 ‐ RAMP Mitigation Reduction Workpaper ‐ Hydro Asset Safety Excel
9 Baseline Risk Assessment Workpaper 9.1
9 Subject Matter Expert Qualifications 9.4
9 RAMP Mitigation Reduction Workpaper 9.6
-
Excel versions of Workpapers are available online 1. Go to www.sce.com/applications 2. Select SCE 2018 RAMP 3. In the new window, select Zipped document
3 of 4
2018 SCE Risk Assessment Mitigation Phase (RAMP)
SCE 2018 RAMP Workpapers
Index of Workpapers CH DOCUMENT NAME PAGE(S)
9 Control or Mitigation Effectiveness Workpaper 9.21
9 WP Ch. 9 ‐ Baseline Risk Assessment Excel
9 WP Ch. 9 ‐ Control & Mitigation Risk Reduction Effectiveness Excel
10 Baseline Risk Assessment 10.1
10 RAMP Mitigation Reduction 10.9
10 Mitigation Effectiveness Workpaper 10.27
10 Circuit Deployment Prioritization 10.43
10 RAMP to GSRP Comparison Workpaper 10.47
10 Wildfire ‐ Subject Matter Expert Judgment ‐ CMI Consequence 10.52
10 WP Ch. 10 ‐ Baseline Risk Assessment Workpaper Excel
10 WP Ch. 10 ‐ Mitigation Effectiveness Workpaper Excel
10 WP Ch. 10 ‐ RAMP Mitigation Reduction Workpaper Excel
11 Baseline Risk Assessment Workpaper 11.1
11 RAMP Mitigation Reduction Workpaper 11.3
11 Mitigation Effectiveness Workpaper 11.9
11 WP Ch. 11 ‐ Baseline Risk Assessment Workpaper Excel
11 WP Ch. 11 ‐ Mitigation Effectiveness Workpaper Excel
11 WP Ch. 11 ‐ RAMP Mitigation Reduction Workpaper Excel
12 2016 SCE Climate Impact Analysis and Resilience Planning Report 12.1
12 Sample of Rain Events and Storm Declaration 12.33
-
Excel versions of Workpapers are available online 1. Go to www.sce.com/applications 2. Select SCE 2018 RAMP 3. In the new window, select Zipped document
4 of 4
2018 SCE Risk Assessment Mitigation Phase (RAMP)
SCE 2018 RAMP Workpapers
Index of Workpapers CH DOCUMENT NAME PAGE(S)
12 Baseline Risk Assessment Inputs 12.34
12 Heatwave vs. Average Summer Temperatures 12.36
12 RAMP Mitigation Reductions 12.43
12 Number of Weather Stations 12.53
12 Subject Matter Expert Qualifications 12.54
12 WP Ch. 12 – Baseline Risk Assessment Workpaper Excel
12 WP Ch. 12 ‐ D1 – Extreme Rain Events Excel
12 WP Ch. 12 ‐ D2 – Extreme Heat Events Excel
12 WP Ch. 12 ‐ D3 – Extreme Wildfire Events Excel
12 WP Ch. 12 ‐ Heatwave vs. Average Summer Temperatures Workpaper Excel
12 WP Ch. 12 – Number of Weather Stations Excel
12 WP Ch. 12 – RAMP Mitigation Reduction Workpaper Excel
12 WP Ch. 12 – Sample of Rain Events and Storm Declarations Excel
-
(U 338‐E)
Southern California Edison Company’s Risk Assessment and Mitigation Phase
Workpapers
Chapter 1 RAMP Report Overview
-
2018 SCE Risk Assessment Mitigation Phase (RAMP)
Chapter 1 ‐ RAMP Overview
Index of Workpapers
DOCUMENT NAME PAGE(S)
2013 – 2023 Recorded and Forecast Costs for Controls & Mitigations 1.1
Risk Register to RAMP Risk Mapping 1.2
RAMP Power BI Access Form & Sign‐up Instructions 1.5
RAMP Power BI User Guide 1.9
EEI Serious Injury Definition 1.41
WP Ch. 1 ‐ 2013‐2023 Recorded and Forecast Costs for Controls & Mitigations Excel
WP Ch. 1 ‐ Risk Register to RAMP Risk Mapping Excel
Excel versions of Workpapers are available online 1. Go to www.sce.com/applications 2. Select SCE 2018 RAMP 3. In the new window, select Zipped document
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
WP
Ch. 1
- 20
13-2
023
Reco
rded
and
For
ecas
t Cos
ts fo
r Con
trol
s & M
itiga
tions
.xlsx
WP
Ch. 1
- Re
cord
ed a
nd F
orec
ast C
osts
Wor
kpap
er1,
2
$ in
Mill
ions
Capi
tal
O&
MRe
cord
edFo
reca
stRe
cord
edFo
reca
stRA
MP
Chap
ter
Cont
rol/
Miti
gatio
n N
ame
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
Cybe
r Att
ack
C1a
Perim
eter
Def
ense
4.8
12
.2
11.8
5.
7
18.2
13
.4
13.1
13
.6
13.6
13
.6
13.6
-
-
-
-
-
4.
2
4.5
5.
4
6.9
6.
9
7.0
Cy
ber A
ttac
kC2
aIn
terio
r Def
ense
12.0
4.
7
7.4
7.
8
10.1
7.
2
8.3
8.
1
8.1
8.
1
8.1
-
-
-
-
-
2.
9
2.9
3.
5
4.7
4.
9
4.9
Cy
ber A
ttac
kC3
aDa
ta P
rote
ctio
n3.
1
8.2
9.
0
3.7
10
.4
0.5
6.
0
6.1
6.
1
6.1
6.
1
-
-
-
-
-
1.7
1.
7
2.3
3.
6
3.7
3.
7
Cybe
r Att
ack
C4a
SCAD
A Cy
bers
ecur
ity-
-
-
-
10
.6
7.1
2.
4
2.5
2.
6
2.6
2.
6
-
-
-
-
-
2.6
2.
5
2.8
4.
0
4.0
4.
1
Cybe
r Att
ack
C5a
Grid
Mod
erni
zatio
n Cy
bers
ecur
ity-
-
-
2.
9
15.0
24
.7
32.0
36
.0
26.2
20
.6
29.8
-
-
-
-
-
2.
3
4.3
5.
8
7.1
7.
1
7.2
Cy
ber A
ttac
kC0
Com
mon
Cyb
er S
ecur
ity (C
CS)
8.2
9.
8
7.4
0.
8
0.2
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Cy
ber A
ttac
kCM
1IT
NER
C CI
P Co
mpl
ianc
e0.
9
4.9
7.
1
2.6
0.
1
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Cybe
r Att
ack
CYB
O&
M3
Tota
l Cyb
er O
&M
Rec
orde
d-
-
-
-
-
-
-
-
-
-
-
8.
2
11.7
12
.6
13.5
12
.8
-
-
-
-
-
-
Und
ergr
ound
Equ
ipm
ent F
ailu
reCM
1U
nder
grou
nd D
etai
l Ins
pect
ions
(UDI
) and
Und
ergr
ound
Pre
vent
ive
Mai
nten
ance
-
-
-
-
-
-
-
-
-
-
-
55.4
57
.8
40.6
38
.5
36.7
-
-
-
-
-
-
U
nder
grou
nd E
quip
men
t Fai
lure
M1
Cove
r Pre
ssur
e Re
lief a
nd R
estr
aint
(CPR
R) P
rogr
am-
-
-
-
-
-
8.
0
15.0
15
.0
15.0
15
.0
-
-
-
-
-
-
-
-
-
-
-
Und
ergr
ound
Equ
ipm
ent F
ailu
reC1
Cabl
e Re
plac
emen
t Pro
gram
s (W
CR)
121.
0
15
3.0
117.
7
14
3.2
135.
3
11
7.3
103.
7
93
.4
93.4
93
.4
99.7
-
-
-
-
-
-
-
-
-
-
-
U
nder
grou
nd E
quip
men
t Fai
lure
C2Ca
ble
Repl
acem
ent P
rogr
ams (
CIC)
21.3
36
.3
65.7
56
.3
74.4
62
.2
64.6
60
.3
60.3
60
.3
60.3
-
-
-
-
-
-
-
-
-
-
-
U
nder
grou
nd E
quip
men
t Fai
lure
C3U
G O
il Sw
itch
Repl
acem
ent P
rogr
am18
.8
19.6
25
.9
17.6
19
.1
12.8
16
.7
17.4
17
.8
22.0
23
.1
-
-
-
-
-
-
-
-
-
-
-
Empl
oyee
, Con
trac
tor &
Pub
lic S
afet
yCM
1Co
mpl
ianc
e-Ba
sed
Safe
ty S
tand
ards
, Pro
gram
s and
Pro
cedu
res
-
-
-
-
-
-
-
-
-
-
-
8.4
9.
2
8.1
10
.1
11.2
-
-
-
-
-
-
Em
ploy
ee, C
ontr
acto
r & P
ublic
Saf
ety
CM2
Com
plia
nce-
Base
d Te
chni
cal T
rain
ing
-
-
-
-
-
-
-
-
-
-
-
44.4
53
.0
46.7
54
.8
57.5
-
-
-
-
-
-
Em
ploy
ee, C
ontr
acto
r & P
ublic
Saf
ety
C1Sa
fety
Con
trol
s-
-
-
-
-
-
-
-
-
-
-
0.
3
0.3
0.
3
0.2
0.
3
2.3
2.
3
2.3
2.
3
2.3
2.
3
Empl
oyee
, Con
trac
tor &
Pub
lic S
afet
yC2
Cont
ract
or S
afet
y Pr
ogra
m
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0.0
0.
2
0.1
0.
2
0.2
0.
2
0.2
0.
2
Empl
oyee
, Con
trac
tor &
Pub
lic S
afet
yM
1aSa
fety
Cul
ture
Tra
nsfo
rmat
ion
- Cor
e Pr
ogra
m-
-
-
-
-
-
5.
0
4.0
4.
0
-
-
0.5
1.
6
0.9
0.
8
1.4
14
.0
17.7
0.
9
0.3
0.
3
0.3
Em
ploy
ee, C
ontr
acto
r & P
ublic
Saf
ety
M2
Indu
stria
l Erg
onom
ics
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0.0
0.
0
0.0
0.
0
0.0
0.
0
0.0
Em
ploy
ee, C
ontr
acto
r & P
ublic
Saf
ety
M3a
Offi
ce E
rgon
omic
s - C
ore
Prog
ram
0.0
0.
0
0.0
0.
0
0.0
2.
3
2.4
2.
4
2.5
2.
5
2.6
-
-
-
-
0.
0
0.5
0.
5
0.5
0.
5
0.5
0.
5
Clim
ate
Chan
geC1
Emer
genc
y M
anag
emen
t-
-
-
-
-
-
-
-
-
-
-
1.
3
2.2
3.
2
2.8
3.
7
3.2
3.
5
3.5
3.
6
3.7
3.
8
Clim
ate
Chan
geC2
Fire
Man
agem
ent
-
-
-
-
-
-
-
-
-
-
-
0.3
0.
5
0.5
0.
5
0.5
0.
6
0.8
0.
8
0.8
0.
8
0.9
Cl
imat
e Ch
ange
M1
Clim
ate
Adap
tatio
n &
Sev
ere
Wea
ther
Pro
gram
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0.5
0.
5
0.4
0.
4
0.3
0.
4
Clim
ate
Chan
geM
2aSi
tuat
iona
l Aw
aren
ess,
Mon
itorin
g &
Ana
lytic
s (O
ptim
al)
-
-
-
-
-
6.2
12
.0
8.6
0.
0
-
-
-
-
-
-
-
2.2
4.
8
6.1
4.
8
5.0
5.
1
Cont
act w
/ Ene
rgize
d Eq
uipm
ent
C1O
verh
ead
Cond
ucto
r Pro
gram
(OCP
)-
-
60
.7
97.3
13
8.7
138.
8
13
9.0
127.
9
10
2.5
99.5
10
7.5
-
-
-
-
-
-
-
-
-
-
-
Cont
act w
/ Ene
rgize
d Eq
uipm
ent
C1a
OCP
Util
izing
Tar
gete
d Co
vere
d Co
nduc
tor
-
-
-
-
-
-
-
-
11.4
11
.1
11.9
-
-
-
-
-
-
-
-
-
-
-
Co
ntac
t w/ E
nerg
ized
Equi
pmen
tC2
Publ
ic O
utre
ach
-
-
-
-
-
-
-
-
-
-
-
5.5
7.
1
7.7
5.
2
5.1
5.
5
5.5
5.
5
5.5
5.
5
5.5
Co
ntac
t w/ E
nerg
ized
Equi
pmen
tM
4In
frar
ed In
spec
tions
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0.5
0.
5
0.5
0.
5
0.5
0.
5
Cont
act w
/ Ene
rgize
d Eq
uipm
ent
M5
Wild
fire
Cove
red
Cond
ucto
r Pro
gram
-
-
-
-
-
32.1
42
.4
194.
6
23
6.5
296.
1
35
9.1
-
-
-
-
-
-
-
-
-
-
-
Cont
act w
/ Ene
rgize
d Eq
uipm
ent
CM1
Dist
ribut
ion
Dete
riora
ted
Pole
Rem
edia
tion
Prog
ram
and
Pol
e Lo
adin
g Pr
ogra
m (P
LP)
161.
3
20
6.9
456.
0
34
7.3
273.
9
-
-
-
-
-
-
-
-
-
28
.1
30.9
-
-
-
-
-
-
Co
ntac
t w/ E
nerg
ized
Equi
pmen
tCM
2Ve
geta
tion
Man
agem
ent
-
-
-
-
-
-
-
-
-
-
-
30.7
34
.0
41.7
67
.8
84.3
-
-
-
-
-
-
Co
ntac
t w/ E
nerg
ized
Equi
pmen
tCM
3O
verh
ead
Deta
iled
Insp
ectio
n, A
ppar
atus
Insp
ectio
ns, a
nd P
reve
ntat
ive
Mai
nten
ance
-
-
-
-
-
-
-
-
-
-
-
47.0
49
.7
37.1
33
.9
36.0
-
-
-
-
-
-
Co
ntac
t w/ E
nerg
ized
Equi
pmen
tCM
4In
trus
ive
Pole
Insp
ectio
ns a
nd P
ole
Load
ing
Asse
ssm
ents
-
-
-
-
-
-
-
-
-
-
-
9.
5
6.7
6.
5
6.8
6.
0
-
-
-
-
-
-
Hydr
o As
set S
afet
yCM
1Hy
dro
Ope
ratio
ns-
-
-
-
-
-
-
-
-
-
-
1.
4
1.3
1.
4
1.3
1.
2
-
-
-
-
-
-
Hydr
o As
set S
afet
yCM
2Hy
dro
Mai
nten
ance
-
-
-
-
-
-
-
-
-
-
-
1.7
0.
9
0.9
0.
9
1.3
-
-
-
-
-
-
Hy
dro
Asse
t Saf
ety
CM3
Dam
Saf
ety
Prog
ram
-
-
-
-
-
-
-
-
-
-
-
1.4
1.
3
1.4
1.
3
1.2
-
-
-
-
-
-
Hy
dro
Asse
t Saf
ety
CM4
Exte
rnal
Insp
ectio
ns-
-
-
-
-
-
-
-
-
-
-
0.
6
0.6
0.
6
0.6
0.
7
-
-
-
-
-
-
Hydr
o As
set S
afet
yC1
Seism
ic R
etro
fit0.
6
0.2
0.
0
0.1
-
4.
9
0.5
-
-
-
2.
0
-
-
-
-
-
-
-
-
-
-
-
Hydr
o As
set S
afet
yC2
Dam
Sur
face
Pro
tect
ion
0.5
6.
3
4.8
2.
6
5.3
0.
1
-
-
-
-
0.5
-
-
-
-
-
-
-
-
-
-
-
Hy
dro
Asse
t Saf
ety
C3Sp
illw
ay R
emed
iatio
n an
d Im
prov
emen
t1.
1
0.0
-
0.
0
0.3
0.
5
4.0
3.
0
2.5
2.
0
-
-
-
-
-
-
-
-
-
-
-
-
Hydr
o As
set S
afet
yC4
Low
Lev
el O
utle
t Im
prov
emen
ts-
-
0.
1
0.6
-
1.
3
5.6
1.
5
-
-
5.0
-
-
-
-
-
-
-
-
-
-
-
Hy
dro
Asse
t Saf
ety
C5Se
epag
e M
itiga
tion
-
-
-
-
-
-
2.0
2.
0
3.9
2.
6
-
-
-
-
-
-
-
-
-
-
-
-
Hydr
o As
set S
afet
yC6
Inst
rum
enta
tion
/ Com
mun
icat
ion
Enha
ncem
ents
-
-
-
-
0.7
1.
8
1.5
2.
9
0.3
-
-
-
-
-
-
-
-
-
-
-
-
-
Bu
ildin
g Sa
fety
CM1
Fire
Life
Saf
ety
Com
plia
nce
0.6
0.
2
0.2
1.
0
0.6
-
-
-
-
-
-
0.
2
0.2
0.
2
0.1
0.
3
-
-
-
-
-
-
Build
ing
Safe
tyCM
2El
ectr
ical
Com
plia
nce
1.7
0.
6
0.7
3.
0
2.6
-
-
-
-
-
-
0.
1
0.1
0.
1
0.2
0.
2
-
-
-
-
-
-
Build
ing
Safe
tyC1
Seism
ic B
uild
ing
Safe
ty P
rogr
am-
-
-
2.
3
8.9
10
.5
6.6
5.
6
6.5
6.
5
6.5
-
-
-
-
0.
0
0.7
1.
0
1.0
1.
0
1.0
1.
0
Build
ing
Safe
tyC2
Faci
lity
Emer
genc
y M
anag
emen
t Pro
gram
-
-
-
-
-
-
-
-
-
-
-
0.1
0.
2
0.2
0.
1
0.4
0.
1
0.1
0.
1
0.1
0.
1
0.1
Bu
ildin
g Sa
fety
M1
Fire
Life
Saf
ety
Port
folio
Ass
essm
ent
-
-
-
-
-
-
1.0
1.
0
1.0
1.
0
1.0
-
-
-
-
-
-
0.
2
0.2
0.
2
0.2
0.
2
Build
ing
Safe
tyM
2El
ectr
ical
Insp
ectio
ns-
-
-
-
-
-
1.
0
1.0
1.
0
1.0
1.
0
-
-
-
-
-
1.3
1.
6
1.7
1.
6
1.6
1.
7
Phys
ical
Sec
urity
CM1
NER
C CI
P-01
4-
-
13
.4
16.9
26
.9
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Phys
ical
Sec
urity
CM2
NER
C CI
P 00
6-
-
-
-
3.
4
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Phys
ical
Sec
urity
C1b4
Grid
Infr
astr
uctu
re P
rote
ctio
n - E
nhan
ced
5.3
1.
1
3.6
10
.2
11.6
14
.6
19.7
39
.5
31.1
19
.6
20.1
-
-
-
-
-
-
0.
1
0.1
0.
1
0.2
0.
2
Phys
ical
Sec
urity
C24
Prot
ectio
n of
Gen
erat
ion
Capa
bilit
ies
-
-
-
-
-
2.4
3.
3
4.5
4.
5
4.1
3.
8
-
-
-
-
-
-
-
0.1
0.
2
0.2
0.
2
Phys
ical
Sec
urity
C3b
Non
-Ele
ctric
Fac
ilitie
s Bla
nket
/Pro
tect
ion
of M
ajor
Bus
ines
s Fun
ctio
ns -
Enha
nced
1.4
2.
1
8.9
0.
9
10.2
8.
3
11.8
14
.2
13.6
14
.1
12.0
-
-
-
-
-
-
-
0.
2
0.2
0.
3
0.2
Ph
ysic
al S
ecur
ityC4
Asse
t Pro
tect
ion
-
-
-
-
-
-
-
1.9
0.
0
2.0
6.
0
25.7
26
.6
28.9
28
.6
25.7
21
.2
21.2
20
.6
19.8
20
.0
20.3
Ph
ysic
al S
ecur
ityM
1aIn
sider
Thr
eat P
rogr
am E
nhan
cem
ent -
Info
rmat
ion
Anal
ysis
- Bas
e-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0.
1
0.3
0.
3
0.3
0.
2
0.2
Ph
ysic
al S
ecur
ityM
2Sm
art K
ey P
rogr
am P
hase
1 -
List
ed B
R/ C
S Cr
itica
l Site
s-
-
-
-
-
-
1.
2
4.4
3.
4
-
-
-
-
-
-
-
-
-
-
0.1
0.
1
0.1
W
ildfir
eCM
1Ve
geta
tion
Man
agem
ent
-
-
-
-
-
-
-
-
-
-
-
30.7
34
.0
41.7
67
.8
84.3
-
-
-
-
-
-
W
ildfir
eC1
5O
verh
ead
Cond
ucto
r Pro
gram
-
-
60.7
97
.3
138.
7
21
.5
30.9
18
.4
5.1
13
.5
12.9
-
-
-
-
-
-
-
-
-
-
-
W
ildfir
eC2
FR3
Ove
rhea
d Di
strib
utio
n Tr
ansf
orm
ers
-
-
-
-
-
12.5
12
.9
13.3
13
.7
14.1
14
.5
-
-
-
-
-
-
-
-
-
-
-
Wild
fire
M1
Wild
fire
Cove
red
Cond
ucto
r Pro
gram
-
-
-
-
-
32.1
42
.4
194.
6
23
6.5
296.
1
35
9.1
-
-
-
-
-
-
-
-
-
-
-
Wild
fire
M2
Rem
ote-
Cont
rolle
d Au
tom
atic
Rec
lose
rs (R
ARs)
and
Fas
t Cur
ve S
ettin
gs-
-
-
-
-
-
9.
1
19.3
-
-
-
-
-
-
-
-
2.
5
0.3
-
-
-
-
W
ildfir
eM3
Publ
ic S
afet
y Po
wer
Shu
toff
(PSP
S) P
roto
col a
nd S
uppo
rt F
unct
ions
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
4.8
3.
7
3.8
3.
5
2.8
2.
8
Wild
fire
M4
Infr
ared
(IR)
Insp
ectio
n Pr
ogra
m-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0.
5
0.5
0.
5
0.5
0.
5
0.5
W
ildfir
eM
5Ex
pand
ed V
eget
atio
n M
anag
emen
t-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
40
.8
80.7
81
.8
82.8
84
.2
Wild
fire
M7
Enha
nced
Situ
atio
nal A
war
enes
s-
-
-
-
-
9.
7
12.5
8.
5
0.0
-
-
-
-
-
-
-
1.
7
4.5
5.
9
4.6
4.
7
4.8
W
ildfir
eM
8Fu
sing
Miti
gatio
n-
-
-
-
-
11
.9
46.5
10
.0
-
-
-
-
-
-
-
-
-
1.7
21
.7
-
-
-
Wild
fire
M9
Fire
Res
istan
t Pol
es-
-
-
-
-
-
5.
1
23.6
28
.7
36.0
43
.6
-
-
-
-
-
-
-
-
-
-
-
437.
6
717.
5
926.
6
820.
0
863.
6
556.
5
673.
2
958.
9
951.
8
1,06
3.4
1,
227.
4
273.
4
299.
0
281.
4
364.
3
401.
9
76.0
12
8.2
17
7.3
15
9.1
16
0.4
16
2.8
Not
e:[1
] Exp
endi
ture
s rep
rese
nt to
tal c
ompa
ny, u
nadj
uste
d co
sts i
n no
min
al d
olla
rs. I
nclu
des c
osts
reco
rded
in b
alan
cing
/mem
oran
dum
acc
ount
s.[2
] Rec
orde
d co
sts p
rovi
ded
for a
ll co
mpl
ianc
e ac
tiviti
es. F
orec
ast c
osts
are
not
incl
uded
as t
hese
act
iviti
es a
re n
ot m
odel
ed in
this
RAM
P re
port
.[3
] SCE
trac
ks re
cord
ed C
yber
secu
rity
O&
M a
t a p
ortf
olio
leve
l, an
d no
t by
each
cyb
erse
curit
y co
ntro
l. Th
is pr
oxy
cont
rol (
CYB
- O&
M) w
as p
rovi
ded
to sh
ow th
e to
tal O
&M
reco
rded
acr
oss a
ll Cy
bera
ttac
k co
ntro
ls.[4
] SCE
has
hist
oric
ally
trac
ked
cost
s rel
ated
to p
rote
ctin
g el
ectr
ic in
fras
truc
ture
(C1b
) and
gen
erat
ion
capa
bilit
ies (
C2) c
olle
ctiv
ely
in o
ne a
ccou
nt. T
here
fore
, the
reco
rded
cos
ts sh
own
for C
1b in
clud
e an
y re
cord
ed c
osts
app
licab
le to
C2
over
the
2013
-201
7 pe
riod,
and
the
reco
rded
cos
t cel
ls fo
r C2
are
left
bla
nk.
[5] W
ildfir
e: T
he fu
ll re
cord
ed c
osts
of t
he O
CP p
rogr
am a
re sh
own
for C
1, w
hile
the
fore
cast
cos
ts fo
r C1
are
only
app
licab
le to
OCP
scop
e w
ithin
HFR
A.
Cont
rol/
M
itiga
tion
ID
1.1
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
Wor
kpap
er: M
appi
ng o
f Ris
k Re
gist
er to
RAM
P Ri
sks
Chap
ter 1
- RA
MP
Ove
rvie
w
Risk
IDRi
sk N
ame
Risk
Sta
tem
ent
RAM
P Ri
sk C
hapt
er1
Pole
Fai
lure
Ove
rload
ed o
r det
erio
rate
d in
fras
truc
ture
cou
ld le
ad to
pol
e fa
ilure
s, re
sulti
ng in
serio
us in
jurie
s and
/or o
utag
es, w
ildfir
es,
finan
cial
aw
ards
to in
jure
d pa
rtie
s, a
nd n
on-c
ompl
ianc
e co
nseq
uenc
es.
Cont
act w
ith E
nerg
ized
Equi
pmen
t, W
ildfir
e
2W
orke
r/Pu
blic
Saf
ety
- Wor
ker E
rror
W
orke
r err
or, a
nd/o
r pro
cess
failu
res c
ould
exp
ose
publ
ic o
r wor
kers
to p
oten
tial h
azar
ds. T
his c
ould
resu
lt in
serio
us
inju
ry a
nd/o
r fat
aliti
es, f
inan
cial
aw
ards
to in
jure
d pa
rtie
s, n
on-c
ompl
ianc
e co
nseq
uenc
es, a
nd o
utag
es.
Empl
oyee
, Con
trac
tor &
Pub
lic S
afet
y
3W
orke
r/Pu
blic
Saf
ety
- Fle
et A
ccid
ents
SCE
vehi
cle
fleet
acc
iden
t cou
ld e
xpos
e pu
blic
and
/or w
orke
rs to
haz
ards
. Thi
s cou
ld re
sult
in i
njur
y, fi
nanc
ial a
war
ds to
in
jure
d pa
rtie
s, a
nd n
on-c
ompl
ianc
e.
Empl
oyee
, Con
trac
tor &
Pub
lic S
afet
y
5Gr
id/(
SCAD
A)- D
estr
uctio
n of
the
Grid
(C
yber
Att
ack)
Delib
erat
e at
tack
to S
CE in
fras
truc
ture
cou
ld le
ad to
serio
us d
amag
e or
des
truc
tion
to th
e gr
id, r
esul
ting
in th
e lo
ss o
f use
of
the
grid
for a
n ex
tend
ed p
erio
d of
tim
e, a
nd c
atas
trop
hic
outc
omes
at i
ndiv
idua
l and
com
mun
ity le
vels.
Cybe
ratt
ack
7Gr
id/(
SCAD
A) -
Com
prise
of t
he G
rid
(Cyb
er A
ttac
k)De
liber
ate
atta
ck c
ould
lead
to c
ompr
omise
of t
he g
rid, r
esul
ting
in te
mpo
rary
loss
of g
rid c
ontr
ol. T
his c
ould
trig
ger
outa
ges,
incr
ease
d fin
anci
al c
ost,
and
non-
com
plia
nce.
Cybe
ratt
ack
10Pu
blic
Saf
ety
- Cop
per t
heft
At
tem
pted
cop
per t
heft
lead
ing
to h
uman
con
tact
with
ene
rgize
d eq
uipm
ent,
resu
lting
in se
rious
inju
ries/
fata
litie
s.Ph
ysic
al S
ecur
ity13
Wor
ker/
Publ
ic S
afet
y -
Syst
em/E
quip
men
t Fai
lure
Fa
ilure
of s
yste
m/e
quip
men
t exp
oses
wor
kers
or m
embe
rs o
f the
pub
lic to
haz
ards
. Thi
s cou
ld re
sult
in se
rious
inju
ries
and/
or fa
talit
ies,
fina
ncia
l aw
ards
to in
jure
d pa
rtie
s, n
on-c
ompl
ianc
e, a
nd o
utag
es.
Cont
act w
ith E
nerg
ized
Equi
pmen
t, U
nder
grou
nd
Equi
pmen
t Fai
lure
, Wild
fire,
Hyd
ro A
sset
Saf
ety
15Re
liabi
lity
of C
ritic
al IT
Sys
tem
sTh
e in
trod
uctio
n of
a n
ew su
ppor
t mod
el c
ould
exp
ose
the
relia
bilit
y of
crit
ical
IT sy
stem
s, re
sulti
ng in
com
prom
ised
info
rmat
ion
and/
or in
abili
ty to
pro
vide
/obt
ain
info
rmat
ion
criti
cal t
o bu
sines
s fun
ctio
ns su
ch a
s cus
tom
er se
rvic
e, c
rew
sc
hedu
ling,
out
age
man
agem
ent,
etc.
Cybe
ratt
ack
19W
orke
r/Pu
blic
Saf
ety
- Ele
ctric
al
Cont
act
Due
to e
ither
ext
erna
l or i
nter
nal c
ause
s, d
own
wire
s or i
nduc
ed v
olta
ges c
ould
lead
to w
orke
r or p
ublic
con
tact
with
en
ergi
zed
equi
pmen
t, re
sulti
ng in
serio
us in
jurie
s and
/or f
atal
ities
to w
orke
rs a
nd/o
r pub
lic, a
nd o
utag
es.
Cont
act w
ith E
nerg
ized
Equi
pmen
t, Em
ploy
ee,
Cont
ract
or &
Pub
lic S
afet
y23
Wor
kpla
ce V
iole
nce
Disg
runt
led
empl
oyee
(s) w
ho m
ay b
e m
ore
susc
eptib
le to
wor
kpla
ce v
iole
nce
coul
d ha
rm th
emse
lves
or o
ther
s, re
sulti
ng
in se
rious
inju
ries a
nd/o
r fat
aliti
es to
wor
kers
, sev
ere
nega
tive
psyc
holo
gica
l effe
cts o
n w
orke
rs, a
nd la
wsu
its.
Ph
ysic
al S
ecur
ity
24Gr
id/S
CADA
- Po
litic
ally
Mot
ivat
ed
Cybe
r Att
ack
If an
indi
vidu
al o
r gro
up in
itiat
es a
cyb
er-a
ttac
k in
an
effo
rt to
influ
ence
pol
itica
l dec
ision
-mak
ing
or se
nd a
pol
itica
l m
essa
ge, t
he c
ompa
ny is
exp
osed
to h
eigh
tene
d cy
ber r
isk th
at c
an re
sult
in a
ttac
ks to
our
bus
ines
s net
wor
ks a
nd a
ttac
ks
on th
e gr
id, w
hich
lead
to c
onse
quen
ces f
or th
e co
mpa
ny in
all
impa
ct d
imen
sions
.
Cybe
ratt
ack
28Ca
tast
roph
ic E
vent
s - N
atur
al D
isast
ers
- Wild
fires
Abili
ty to
man
age
the
effe
cts o
f wild
fires
will
requ
ire th
at th
e co
mpa
ny e
ffect
ivel
y pr
even
t, pr
otec
t aga
inst
, miti
gate
, re
spon
d, a
nd re
cove
r fro
m w
ildfir
es. I
f not
effe
ctiv
ely
man
aged
, wild
fires
can
resu
lt in
ass
et fa
ilure
, ser
ious
pub
lic a
nd
empl
oyee
safe
ty in
cide
nts,
and
serv
ice
deliv
ery
impa
cts.
Clim
ate
Chan
ge, W
ildfir
e
33Ph
ysic
al S
ecur
ity o
n Cr
itica
l In
fras
truc
ture
Delib
erat
e at
tack
to S
CE c
ritic
al in
fras
truc
ture
cou
ld re
sult
in a
secu
rity
brea
ch a
nd p
oten
tially
lead
to d
amag
e of
eq
uipm
ent (
resu
lting
in to
xic
spill
s), c
asca
ding
out
ages
, sys
tem
failu
res,
and
serio
us in
jurie
s and
/or f
atal
ities
to w
orke
rs,
and
pote
ntia
lly m
embe
rs o
f the
pub
lic.
Phys
ical
Sec
urity
36Cu
stom
er S
ervi
ce S
yste
ms F
ailu
reCr
itica
l agi
ng c
usto
mer
serv
ice
plat
form
and
tech
nolo
gy o
bsol
esce
nce
coul
d re
sult
in c
usto
mer
serv
ice
syst
em fa
ilure
s, a
nd
lead
to d
elay
s and
err
ors i
n ha
ndlin
g ro
utin
e cu
stom
er re
ques
ts, p
robl
ems i
n ou
tage
man
agem
ent,
addi
tiona
l ope
ratio
nal
cost
s, n
on-c
ompl
ianc
e, d
elay
s in
colle
ctin
g re
venu
e, a
nd p
oten
tial i
mpa
ct to
crit
ical
car
e cu
stom
ers.
N/A
- Se
cond
ary
safe
ty im
pact
s
40Pu
blic
Saf
ety
- Str
ay V
olta
geAs
par
t of a
rout
ine
over
head
and
und
ergr
ound
con
stru
ctio
n pr
actic
e, li
nes a
nd e
quip
men
t are
gro
unde
d fo
r pur
pose
s of
stab
iliza
tion
and
prot
ectio
n, w
hich
cre
ates
a c
urre
nt re
turn
pat
h th
roug
h ea
rth.
Mem
bers
of t
he p
ublic
in c
lose
pro
xim
ity
to a
subs
tatio
n m
ay b
ecom
e pa
rt o
f a c
urre
nt re
turn
pat
h w
hen
mak
ing
cont
act w
ith a
subs
tatio
n fe
nce,
mak
ing
cont
act
with
a c
ondu
ctiv
e in
door
wat
er fi
xtur
e or
out
door
con
duct
ive
wat
er p
ipe,
or w
hile
exi
ting
an u
ngro
unde
d sw
imm
ing
pool
su
rrou
nded
by
a co
ncre
te d
eck.
Thi
s can
pot
entia
lly re
sult
in in
jurie
s and
civ
il lit
igat
ion.
N/A
- Di
d no
t mee
t saf
ety
thre
shol
d
45Sm
artC
onne
ct a
nd/o
r Net
com
m
Met
erin
g Sy
stem
Fai
lure
Asse
t, sy
stem
, pro
cess
or w
orke
r fai
lure
, or s
ecur
ity b
reac
h co
uld
caus
e SC
E's A
dvan
ced
Met
erin
g Sy
stem
s to
fail.
The
ou
tcom
es o
f the
se ty
pes o
f fai
lure
s may
impa
ct p
ublic
and
em
ploy
ee sa
fety
, cau
se lo
ss o
r del
ay o
f cor
pora
te re
venu
e, a
nd
trig
ger i
ncre
ased
man
ual w
ork
arou
nds,
loss
of d
ata,
larg
e-sc
ale
outa
ges,
and
cus
tom
er d
issat
isfac
tion.
N/A
- Di
d no
t mee
t saf
ety
thre
shol
d
Desc
riptio
n: F
or th
e sa
ke o
f rel
evan
cy a
nd b
revi
ty, S
CE h
as fi
ltere
d its
risk
regi
ster
to o
nly
disp
lay
thos
e ris
ks th
at a
ctua
lly h
ave
a sa
fety
impa
ct. T
his i
s wha
t is s
how
n in
this
docu
men
t. W
e ha
ve m
appe
d th
ese
risks
to o
ne o
r mor
e RA
MP
Risk
Cha
pter
s, w
here
app
licab
le. R
isk sc
ores
foun
d on
the
"SCE
ERM
Risk
Reg
ister
Det
ail"
tab
wer
e de
velo
ped
usin
g SC
E's p
revi
ous R
isk E
valu
atio
n To
ol (R
ET) a
nd e
valu
atio
n m
etho
dolo
gy to
ass
ess f
requ
ency
, con
sequ
ence
s,
and
risk
"sco
re" o
f eac
h ris
k.
1.2
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
Risk
IDRi
sk N
ame
Risk
Sta
tem
ent
RAM
P Ri
sk C
hapt
er48
Elec
tron
ic D
ata
Brea
ch G
RID
-In
telle
ctua
l Pro
pert
y /C
ompa
ny
Conf
iden
tial
Inte
rnal
or e
xter
nal a
ttac
k co
uld
resu
lt in
the
loss
of,
or u
naut
horiz
ed c
hang
es to
, con
fiden
tial/s
ensit
ive
elec
tron
ic d
ata
supp
ortin
g th
e Gr
id o
r rel
ated
inte
llect
ual p
rope
rty
and
trig
ger l
iabi
lity
asso
ciat
ed w
ith d
ata
expo
sure
and
/or u
naut
horiz
ed
chan
ges t
o Gr
id d
ata.
Cybe
ratt
ack
53Di
strib
utio
n En
ergy
Res
ourc
es (D
ER)
Adva
nces
in c
usto
mer
and
dist
ribut
ed e
nerg
y re
sour
ce te
chno
logi
es w
ill in
crea
se th
e pa
ce o
f ado
ptio
n an
d pe
netr
atio
n of
di
strib
uted
ene
rgy
reso
urce
s on
the
dist
ribut
ion
syst
em, w
hich
may
incr
ease
the
risks
to fu
ture
relia
bilit
y an
d po
wer
qu
ality
.
N/A
- Di
d no
t mee
t saf
ety
thre
shol
d
57Ve
ndor
Per
form
ance
and
M
anag
emen
t - N
on IT
Vend
or/s
uppl
ier p
erfo
rman
ce (l
abor
disp
utes
, raw
mat
eria
l sho
rtag
e, e
tc.)
coul
d le
ad to
disr
upte
d su
pply
cha
in a
nd re
sult
in in
abili
ty to
com
plet
e w
ork
assig
ned
to c
ontr
act c
rew
s, a
nd in
suffi
cien
t mat
eria
l to
supp
ort O
&M
, cap
ital,
stor
m a
nd
emer
genc
y jo
b ac
tiviti
es.
N/A
- Di
d no
t mee
t saf
ety
thre
shol
d
59SO
NGS
- M
anag
e De
com
miss
ioni
ng -
Co-O
wne
rsSO
NGS
Co-
Part
icip
ants
una
nim
ous v
otin
g re
quire
men
t pro
duce
s slo
w d
ecisi
on-m
akin
g or
inab
ility
to re
ach
cons
ensu
s,
prev
entin
g th
e co
mpl
etio
n of
nec
essa
ry w
ork
and/
or d
elay
ing
the
deco
mm
issio
ning
pro
ject
and
cau
sing
budg
et o
verr
uns.
N/A
- Se
e Ap
pend
ix A
(Nuc
lear
Dec
omm
issio
ning
)
61Pu
blic
Saf
ety
- Con
tact
Vol
tage
Und
er a
bnor
mal
ope
ratin
g co
nditi
ons,
a d
iffer
ence
in p
oten
tial (
volta
ge) c
an e
xist
bet
wee
n ea
rth
and
a co
nduc
tive
surf
ace
or b
etw
een
two
cond
uctiv
e su
rfac
es a
s a re
sult
of d
irect
con
tact
with
an
expo
sed
ener
gize
d lin
e co
nduc
tor o
r cab
le, o
r as a
re
sult
of in
duct
ion.
A p
erso
n co
uld
beco
me
part
of a
cur
rent
pat
h w
hile
wal
king
, or w
hile
sim
ulta
neou
sly c
onta
ctin
g ea
rth
and
a co
nduc
tive
surf
ace,
resu
lting
in a
mod
erat
e to
seve
re e
lect
ric sh
ock
and
pote
ntia
l civ
il lit
igat
ion.
N/A
- Di
d no
t mee
t saf
ety
thre
shol
d
63Th
ird P
arty
Com
plia
nce
A sig
nific
ant n
onco
mpl
ianc
e ev
ent o
ccur
s at a
supp
lier.
Thi
s im
pact
s con
tinui
ty o
f sup
ply
and
pres
ents
fina
ncia
l and
re
puta
tiona
l risk
s.Cy
bera
ttac
k, a
nd o
ther
risk
s enc
ompa
ssin
g as
set
failu
re64
Reco
rds a
nd In
form
atio
n M
anag
emen
t Com
plia
nce
Empl
oyee
s not
follo
win
g pr
oces
ses,
or p
roce
sses
not
acc
urat
ely
refle
ctin
g th
e op
erat
ing
need
s, c
ould
lead
to
poor
/inap
prop
riate
reco
rds m
anag
emen
t. Th
is ca
n re
sult
in in
abili
ty to
acc
ess i
nfor
mat
ion,
and
/or i
nabi
lity
to re
spon
d fu
lly, a
ccur
atel
y, a
nd ti
mel
y to
regu
lato
ry in
quiri
es a
nd d
ata
requ
ests
.
Empl
oyee
, Con
trac
tor &
Pub
lic S
afet
y
67Em
ploy
ee M
iscon
duct
Uni
nten
tiona
l or I
nten
tiona
l em
ploy
ee m
iscon
duct
cou
ld re
sult
in v
iola
tion
of E
mpl
oyee
Cod
e of
Con
duct
, pol
icy,
or l
aw
and
caus
e ha
rm to
em
ploy
ees,
cus
tom
ers o
r sha
reho
lder
s.N
/A -
Did
not m
eet s
afet
y th
resh
old
72Pe
rmitt
ing
Perm
its n
ot b
eing
file
d pr
oper
ly (o
r file
d pr
oper
ly b
ut n
ot a
ctua
lly ta
ken
out t
o th
e jo
b sit
e, a
s req
uire
d) le
ads t
o SC
E cr
ews
not h
avin
g th
e re
quire
d pe
rmits
. Th
is re
sults
in o
ur w
orke
rs n
ot fo
llow
ing
the
perm
ittin
g ru
les a
nd re
gula
tions
, whi
ch
carr
y sa
fety
, fin
anci
al a
nd c
ompl
ianc
e im
pact
s for
the
com
pany
.
N/A
- Di
d no
t mee
t saf
ety
thre
shol
d
73Pu
blic
Saf
ety
- Dam
Fai
lure
High
-haz
ard
dam
s bei
ng su
bjec
ted
to m
ajor
nat
ural
haz
ards
or f
ailu
res c
ould
pot
entia
lly c
ause
an
Unc
ontr
olle
d Ra
pid
Rele
ase
of W
ater
(URR
W) l
eadi
ng to
serio
us in
jurie
s and
/or f
atal
ities
, des
truc
tion
of p
rope
rty,
long
-ter
m e
nviro
nmen
tal
dam
age,
com
plia
nce
failu
res,
loss
of o
pera
tion
and
reve
nue,
and
des
truc
tion
of th
e pr
ojec
t.
Hydr
o As
set S
afet
y
75W
orke
r/Pu
blic
Saf
ety
- B B
ank
Tran
sfor
mer
B-ba
nk tr
ansf
orm
er in
serv
ice
failu
re d
ue to
cop
per t
heft
lead
ing
to B
-ban
k tr
ansf
orm
er u
nava
ilabi
lity
and
pote
ntia
lly
resu
lting
in se
rious
inju
ries a
nd/o
r fat
aliti
es.
Phys
ical
Sec
urity
79Re
spon
se a
nd R
ecov
ery
from
M
anm
ade
Disa
ster
sFa
ilure
to im
plem
ent a
n ef
fect
ive
com
pany
-wid
e bu
sines
s res
ilien
cy p
lann
ing
and
emer
genc
y m
anag
emen
t sys
tem
in
resp
ondi
ng to
man
-mad
e di
sast
ers c
ould
resu
lt in
syst
em fa
ilure
; del
ayed
or u
ncoo
rdin
ated
com
pany
resp
onse
and
re
cove
ry e
ffort
s; fa
ilure
to ti
mel
y co
mm
unic
ate
and
coor
dina
te w
ith e
xter
nal a
genc
ies.
Appl
icab
le a
s res
pons
e to
all
nine
risk
cha
pter
s
80Re
spon
se a
nd R
ecov
ery
from
Bus
ines
s Di
srup
tions
Failu
re to
impl
emen
t an
effe
ctiv
e co
mpa
ny-w
ide
busin
ess r
esili
ency
pla
nnin
g an
d em
erge
ncy
man
agem
ent s
yste
m in
pr
epar
atio
n fo
r bus
ines
s disr
uptio
ns c
ould
resu
lt in
del
ayed
or u
ncoo
rdin
ated
com
pany
resp
onse
and
reco
very
effo
rts;
fa
ilure
to ti
mel
y co
mm
unic
ate
and
coor
dina
te w
ith e
xter
nal a
genc
ies;
pub
lic o
r em
ploy
ee in
jurie
s or f
atal
ities
.
Appl
icab
le a
s res
pons
e to
all
nine
risk
cha
pter
s
81Re
spon
se a
nd R
ecov
ery
from
En
viro
nmen
tal I
ssue
sFa
ilure
to im
plem
ent a
n ef
fect
ive
com
pany
-wid
e bu
sines
s res
ilien
cy p
lann
ing
and
emer
genc
y m
anag
emen
t sys
tem
in
prep
arat
ion
for c
limat
e ch
ange
and
/or o
ther
cha
ngin
g en
viro
nmen
tal c
ondi
tions
(e.
g., i
ncre
ased
wild
fire
risk
due
to
drou
ght)
cou
ld re
sult
in p
ublic
or e
mpl
oyee
inju
ries o
r and
/or i
ncre
ased
impa
ct to
SCE
's as
sets
.
Clim
ate
Chan
ge, W
ildfir
e
84El
ectr
ical
Sys
tem
Fai
lure
s -
Sout
hwes
tern
Bla
ckou
tA
com
bina
tion
of a
sset
failu
res,
wor
ker e
rror
, and
/or p
roce
ss fa
ilure
s cou
ld le
ad in
to a
maj
or e
lect
rical
syst
em fa
ilure
re
sulti
ng in
to a
sout
hwes
tern
syst
em b
lack
out w
ith sa
fety
, rel
iabi
lity
and
finan
cial
con
sequ
ence
s.N
/A -
Prim
arily
a d
irect
relia
bilit
y im
pact
, with
a
seco
ndar
y sa
fety
impa
ct
99U
ncer
tain
ties a
nd th
e Po
tent
ial
Mar
gin
of E
rror
in S
yste
m P
lann
ing
or
Engi
neer
ing
Impa
ctin
g Re
liabi
lity
Unc
erta
intie
s in
dem
and
fore
cast
pla
nnin
g as
sum
ptio
ns a
nd in
crea
sing
syst
em c
ompl
exiti
es d
ue to
var
iabl
e cu
stom
er-s
ide
reso
urce
s cou
ld le
ad to
the
actu
al d
eman
d ex
ceed
ing
the
fore
cast
, res
ultin
g in
pot
entia
l circ
uit o
verlo
ads a
nd c
usto
mer
ou
tage
s
N/A
- Se
cond
ary
safe
ty im
pact
s
1.3
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
Risk
IDRi
sk N
ame
Risk
Sta
tem
ent
RAM
P Ri
sk C
hapt
er10
0In
sider
Thr
eat
Acci
dent
al o
r del
iber
ate
actio
ns o
f cur
rent
or f
orm
er e
mpl
oyee
s, c
ontr
acto
rs, o
r bus
ines
s par
tner
s cou
ld e
xpos
e th
e co
mpa
ny to
cyb
er ri
sk s
that
invo
lve
unau
thor
ized
acce
ss to
net
wor
k, sy
stem
, or d
ata.
Th
ese
actio
ns m
ay n
egat
ivel
y af
fect
ed th
e co
nfid
entia
lity,
inte
grity
, or a
vaila
bilit
y of
the
Grid
syst
ems a
nd d
ata,
our
in
form
atio
n or
info
rmat
ion
syst
ems.
Cybe
ratt
ack,
Phy
sical
Sec
urity
101
Exec
utio
n Ri
sk R
elat
ed to
De
com
miss
ioni
ng P
roje
ctDe
com
miss
ioni
ng G
ener
al C
ontr
acto
r fai
ls to
succ
essf
ully
com
plet
e th
e de
com
miss
ioni
ng o
f SO
NGS
per
the
fixed
pric
e co
ntra
ct sp
ecifi
catio
ns, l
eadi
ng to
pot
entia
l pro
ject
del
ays,
incr
ease
d pr
ojec
t cos
ts a
nd sa
fety
impl
icat
ions
for S
CE.
See
gene
rally
App
endi
x A
(Nuc
lear
Dec
omm
issio
ning
)
109
Polic
y Ru
ling
Affe
ctin
g In
crea
sed
Adop
tion
of A
ltern
ativ
e Te
chno
logi
esPo
licy
rulin
g af
fect
ing
inve
stm
ent o
ppor
tuni
ties a
nd su
ppor
ting
adva
nced
tech
nolo
gies
cou
ld le
ad to
SCE
dep
loyi
ng D
ERs
rapi
dly
and
in a
wid
espr
ead
fash
ion.
Sup
port
ing
this
effo
rt w
ithou
t hav
ing
the
appr
opria
te re
sour
ces c
an re
sult
in
pote
ntia
l saf
ety
issue
s, in
crea
sed
finan
cial
cos
t, an
d po
tent
ial o
utag
es.
N/A
- Se
cond
ary
safe
ty im
pact
s
122
Cata
stro
phic
Eve
nts -
Nat
ural
Disa
ster
s - E
arth
quak
esAb
ility
to m
anag
e th
e ef
fect
s of e
arth
quak
es a
nd a
fter
shoc
ks w
ill re
quire
that
SCE
effe
ctiv
ely
prot
ect,
miti
gate
, res
pond
an
d re
cove
r fro
m th
e co
nseq
uenc
es o
f ear
thqu
akes
. If t
he e
ffort
s are
not
effe
ctiv
ely
man
aged
, the
resu
lt ca
n be
ass
et
failu
re, p
ublic
and
em
ploy
ee sa
fety
inci
dent
s, a
nd se
rvic
e de
liver
y im
pact
s.
Build
ing
Safe
ty, H
ydro
Ass
et S
afet
y, (a
lso se
e Ap
pend
ix C
- Se
ismic
Eve
nts)
123
Cata
stro
phic
Eve
nts -
Oth
er N
atur
al
Disa
ster
s - (N
ot re
late
d to
Ear
thqu
akes
or
Wild
fires
)
Abili
ty to
man
age
the
effe
cts o
f nat
ural
disa
ster
s rai
nsto
rms a
nd la
ndsli
des w
ill re
quire
that
SCE
effe
ctiv
ely
prot
ect,
miti
gate
, res
pond
and
reco
ver f
rom
such
nat
ural
disa
ster
s. T
hese
disa
ster
s, if
not
effe
ctiv
ely
man
aged
, can
resu
lt in
ass
et
failu
re, p
ublic
and
em
ploy
ee sa
fety
inci
dent
s, a
nd se
rvic
e de
liver
y im
pact
s.
Clim
ate
Chan
ge
124
Wor
ker/
Publ
ic S
afet
y - P
roce
ss F
ailu
reW
orke
r err
or, a
nd/o
r pro
cess
failu
res c
ould
exp
ose
publ
ic o
r wor
kers
to p
oten
tial h
azar
ds. T
his c
ould
resu
lt in
serio
us
inju
ry a
nd/o
r fat
aliti
es, f
inan
cial
aw
ards
to in
jure
d pa
rtie
s, n
on-c
ompl
ianc
e, o
utag
es, a
nd n
egat
ive
publ
ic re
latio
ns.
Empl
oyee
, Con
trac
tor &
Pub
lic S
afet
y
1.4
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
1
ACCESS TO POWER BI REQUESTING ACCESS By signing or submitting this form, you agree that any information you obtain through this access to Power BI shall only be used in connection with SCE’s Risk Assessment Mitigation Phase (RAMP) or General Rate Case proceedings. If any SCE confidential information is inadvertently disclosed to you as a result of your access to Power BI, you acknowledge that you will treat that information as confidential. To receive access to the Power BI site, you should complete this form and send via email to:
Case Administration Southern California Edison Company [email protected]
After SCE’s acceptance, the User will be notified of activation by email within 2‐3 days.
Access Request for Power BI Case Name: SCE 2018 RAMP
User Name: User Title:
Organization:
Mailing Address:
Email:
Telephone Number:
Party or Governmental Entity Represented by User:
By:
User Signature
Date:
1.5
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
2
INSTRUCTIONS TO ACCESS POWER BI
If you don’t have already Microsoft account, follow the steps below to create one. If you already have a Microsoft account for this email address, you can log‐in as usual.
1. You will receive an invitation to access the
site, with a link to the Report.
2. Click on the link in the email.
3. If you don’t already have a Microsoft
account, a new window will instruct you to create one.
4. Click on “Next”
5. A new window will prompt you to create a
password
6. Create a unique password, using uppercase, lowercase, a symbol, and a number
7. Once a password has been created, a verification email will be sent to your email. 8. Go to the email titled “Verify your email address” to get the Security Code
1.6
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
3
9. Enter your security code in the prompted window
10. Click “Next”
11. Verify that you are a human.
12. Click “Next”
13. Verify your email address, if correct click
on “Looks Good!”
1.7
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
4
14. Review permissions and click on “Accept”
15. Congratulations, you have successfully accessed the site!
1.8
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
Pow
er B
I Roa
dmap
to V
isual
izin
g RA
MP
Dat
a
1.9
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
SCE Inpu
t
Baseline Da
ta•
Expo
sure
•Driver Frequ
ency
•Outcome Prob
ability
•Co
nseq
uence Distrib
ution
Mitigatio
ns Data
•Co
st•
Mitigatio
n Re
duction
Percen
tages
•Mitigatio
n Expo
sure
•Mitigatio
n Po
rtfolios
Inpu
t Data
Mod
el Engine
Mon
te Carlo Sim
ulation
•Ra
ndom
draws from each
bowtie
com
pone
nt•
Iterate 10,00
0 tim
es fo
r each
year
•Perform abo
ve step
s for
Baseline and each m
itigatio
n po
rtfolio
Mod
el Outpu
t
Outpu
t•
Distrib
ution of
conseq
uences by ou
tcom
e in natural units
•Mean and Tail Av
erage
•MAR
S•
Risk Spe
nd Efficien
cy fo
r po
rtfolio
and
mitigatio
ns
90%
Expe
cted
10%
Repo
rting
Power BI
•Clou
d based visualiza
tion
tool
•Re
view
inpu
t and
outpu
t data
Mod
el Architecture Overview
Power BI is u
sed to disp
lay the results of the
RAM
P sim
ulation mod
el in
an intuitive and
easy to
filte
r manne
r.
1.10
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
3
Power BI O
verview
Power BI is a
Microsoft clou
d‐ba
sed bu
siness a
nalytics softw
are that harnesses th
e key
streng
ths o
f Excel (a
nalytical and
cha
rting capa
bilities) and
Pow
erpo
int(presentatio
n capa
bilities).
SCE used
this platform
to tran
sform RAM
P da
ta into easily digestib
le inform
ation.
Key Capabilities
•Clou
d‐based, no special softw
are to install other th
an an internet browser
•Allows u
ser to “slice and dice” the data versus a
static file
•Und
erlying data can
be do
wnloade
d
•The platform
perform
s the
“he
avy liftin
g” in
transforming data into inform
ation
1.11
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
4
Power BI
Repo
rt #
Power BI R
eport N
ame
Summary
Slides
for
Add’lInfo
1Risk Bow
tiePresentsan
interactive bo
wtie
with
baseline and mitigated bo
wtie
data.
8‐9
2Risk
Bowtie
(Hydro)
Same repo
rt as R
eport#
1, sp
ecific to Hydro Asset Safety du
e to th
e nu
mbe
r of significant digits.
8‐9
3Inpu
tDetail
Provides ta
bles
with
ann
ual driv
er, outcome, and
con
sequ
ence data, fo
r baseline and mitigated po
rtfolios.
10‐11
4Mitigatio
n Co
stProvides various
charts sh
owing costs of m
itigatio
ns and
mitigatio
n plans,
by year.
12‐13
5Co
nseq
uences
by Outcomes
Provides chartsd
epictin
g the conseq
uences associated with
each risk
outcom
e, fo
r baseline and mitigated risk levels.
14‐15
6Co
nseq
uences Sum
mary
Provides a su
mmary of each chapter’s baselineand mitigated
conseq
uences, in natural units.
16‐17
7MAR
S by Scenario
Provides
charts disp
laying
mean and tail‐average MAR
S results fo
r baseline
and mitigat ed risk.
18‐19
8MAR
S Stack
Provides
a cross‐risk comparison
of b
aseline and mitigated risk levels on
a
MAR
S basis, w
ith stacked bars to
disp
lay conseq
uence im
pacts.
20‐21
9Po
rtfolio
RSE
Provides a m
apping
of con
trols a
nd m
itigatio
ns to
mitigatio
n plans.
Provides risk re
duction, co
st, and
RSE fo
r each mitigatio
n plan
considered
.22
‐23
10Mitigatio
n RSE
Pro vides risk re
duction,cost, and
RSE fo
r each control and
mitigatio
n on
a
mean and tail‐average basis, as w
ell as the
ir im
pacts to conseq
uences.
24‐25
11Mitigatio
n Co
st Detail
Provides ann
ualcost e
stim
ates over 2
018 –2023
period for e
ach control /
mitigatio
n considered
in th
is RA
MP repo
rt26
‐27
Power BI Rep
orts Overview
Note: These are th
e repo
rts S
CE has includ
ed at the
time of our RAM
P subm
ission. Since Pow
er BI is a
n active
application, th
ese repo
rts m
ay be ad
justed
and
add
ition
al re
ports m
ay be provided
as n
eeded.
1.12
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
5
Descrip
tion:
This is the title page
There are no
buttons or a
ny ty
pe of d
ata interactions here.
1.13
-
Workpaper – Southern California Edison / SCE 2018 RAMP
Chapter 1 – RAMP Report Overview
6
Descrip
tion:
This repo
rt describes th
e 9 risks.
Please ta