Table 3 Imputation results are reported for each BA including the mean percentage error and MAPE.

From: Developing reliable hourly electricity demand data through screening and imputation

BA

Median dem. (MW)

Imputed hours

Mean pct. error (%)

MAPE (%)

Forecast MAPEF (%)

Short

Long

Inclusive

PJM

88,679

102

0.179

1.42

1.98

1.91

3.59

MISO

72,912

25

0.237

1.08

1.77

1.34

2.72

ERCO

38,965

240

0.586

3.77

5.32

5.22

2.53

SWPP

28,546

1,307

−0.071

1.61

2.37

2.34

3.02

SOCO

25,407

1,855

−0.039

1.79

2.38

2.36

3.88

CISO

25,154

349

−0.033

1.66

3.05

2.74

3.04

NYIS

17,812

28

−0.295

0.88

2.33

2.13

3.49

TVA

17,173

752

−0.022

1.51

2.40

2.36

2.15

FPL

13,905

177

0.246

1.61

2.51

2.18

5.29

ISNE

13,754

66

−0.106

1.33

2.65

1.49

2.76

DUK

11,365

240

0.226

2.15

2.62

2.59

2.78

CPLE

6,585

229

0.154

1.96

3.03

2.88

3.81

BPAT

6,203

54

0.232

1.15

2.24

1.86

2.00

FPC

5,722

212

0.019

1.17

2.20

1.93

20.85†

PACE

5,382

3,604

0.033

2.36

3.57

3.39

4.81

PSCO

4,905

526

0.093

1.53

3.58

3.49

3.59

LGEE

3,939

101

0.156

2.04

2.89

2.78

5.44

NEVP

3,829

890

0.129

2.45

2.99

2.86

3.51

PSEI

3,367

242

0.754

2.53

3.54

3.47

49.97†

AZPS

3,181

152

0.103

1.94

3.28

3.07

3.81

LDWP

3,126

585

0.423

2.37

4.60

4.45

5.06

SRP

2,998

3,358

0.009

1.96

2.87

2.79

5.15

WACM

2,883

909

−0.062

1.56

4.98

4.36

4.05

SC

2,666

3,357

−0.383

2.73

3.49

3.47

4.03

SCEG

2,621

26

0.001

2.06

2.33

2.30

2.96

PGE

2,349

786

0.739

1.67

3.25

3.21

2.22

TEC

2,333

27

0.547

1.14

2.59

2.37

4.57

PACW

2,298

4,039

0.402

3.23

4.33

4.25

6.34

AECI

2,240

13

0.548

2.82

3.21

2.86

5.11

FMPP

1,969

671

0.162

1.60

1.87

1.84

5.17

BANC

1,889

1,478

−0.070

2.15

3.81

3.78

3.13

IPCO

1,826

258

0.045

2.47

5.36

4.01

5.74

PNM

1,545

53

0.239

1.12

2.81

2.08

2.93

TEPC

1,532

3,838

1.727

4.82

9.32

9.25

13.97†

JEA

1,420

241

0.912

2.05

4.32

3.95

6.46

AVA

1,351

445

0.247

2.79

3.52

3.38

9.24†

NWMT

1,301

152

0.110

1.34

3.12

2.61

3.58

SCL

1,103

198

0.317

1.58

3.19

2.75

2.15

WALC

1,020

663

0.615

4.52

7.09

6.36

20.13

EPE

886

98

0.062

1.61

2.99

1.72

3.50

GCPD

568

171

0.220

0.88

3.96

1.34

2.56

CPLW

557

237

0.165

2.11

4.56

3.78

3.77

TPWR

541

305

0.148

1.39

2.25

2.05

2.86

AEC

478

304

0.285

2.51

4.75

4.46

93.73†

IID

351

742

4.033

7.80

11.27

10.88

11.03

TAL

301

46

0.121

1.73

“—”

1.73

4.32

TIDC

282

386

−0.035

1.64

3.44

2.88

2.82

GVL

217

3,308

0.144

2.48

3.66

3.60

8.58†

CHPD

198

205

1.142

3.13

12.67

6.96

123.41

DOPD

172

1,658

0.036

1.94

5.06

3.63

9.15

WAUW

90

4,778

0.664

4.51

7.99

7.58

6.49

SPA

70

293

1.017

8.12

9.14

8.33

11.72†

HST

62

1,665

0.798

2.47

5.29

4.34

7.44

NSB

45

3,587

−0.069

3.50

5.44

4.97

8.80

  1. For comparison, the MAPE of the forecast values versus the actual values is also included. The MAPE values are categorized into three columns: short gaps of 1 or 2 hours, long 3+ hour gaps, and all gaps inclusive. The BAs are ordered by their median demand. The total number of ‘missing’ and screened hours for each BA is denoted in the ‘Imputed Hours’ column. There are no long gaps for the TAL BA as noted by the “—”.
  2. †BAs where forecast and reported demand values are expected to disagree based on EIA guidance.
Back to article page