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.