20170815IPC to Tamarack Request 2 Attachment 1 (Plot HH hist vs EIA).xls

IceYearSettles
EIA
AecoBasis
AecoMatch
HenryHub
HenryHubMatch
IFforGDD
IFforGDDRockies
IFforGDDSumas
MalinBasis
MalinMatch
NGIforGDDMalin
RockiesBasis
RockiesMatch
SampleDate
SumasBasis
SumasMatch
Grand Total
Year of setttle
Data
Average of 2008
Average of 2009
Average of 2010
Average of 2011
Average of 2012
Average of 2013
Average of 2014
Average of 2015
Average of 2016
Average of 2017
Average of 2018
Average of 2019
Average of 2020
Average of 2021
Average of 2022
Average of 2023
Average of 2024
Average of 2025
Average of 2026
Average of 2027
Average of 2028
Actual HH
year
2010 EIA Forecast ……..……………..…….Nominal $
2011 EIA Forecast ……..……………..…….Nominal $
2012 EIA Forecast (2013 IRP)…………...Nominal $
2013 EIA Forecast………………...………...Nominal $
2014 EIA Forecast (2015 IRP) …………..Nominal $
2008 (2006 dollars)
EIA data
2009 (2007 dollars)
2010 (2008 dollars)
2008 EIA Forecast
2009 EIA Forecast
2010 EIA Forecast
2011 EIA Forecast
2012 EIA Forecast (2013 IRP)
2013 EIA Forecast
2014 EIA Forecast (2015 IRP)
2015 IRP presentation
2015 (2013 dollars)
2015 EIA Forecast
2016 (2014 dollars)
ICE 2008
ICE 2009
ICE 2010
ICE 2011
ICE 2012
ICE 2013
ICE 2014
ICE 2015
ICE 2016
2016 EIA Forecast
2016 Low (2014 dollars)
2016 EIA Low Case (2017 IRP)
2008.00
$7.96
$9.83
$9.83
$9.61
$9.47
$9.42
$9.47
$9.58
$9.72
$8.57
$8.75
$8.93
2009.00
$5.78
$7.09
$7.47
$7.61
$7.73
$7.86
$7.99
$8.14
$8.30
$8.45
$8.69
$8.69
2010.00
$5.23
$5.93
$6.23
$6.44
$6.66
$6.89
$7.12
$7.35
$7.59
$7.80
$0.00
$0.00
$0.00
2011.00
$4.50
$5.08
$5.43
$5.73
$6.01
$6.28
$6.55
$6.81
$7.06
$6.60
$7.74
$8.02
2012.00
$3.50
$4.08
$4.37
$4.57
$4.78
$5.01
$5.26
$5.53
$5.81
$6.25
$6.59
$6.93
$7.20
$7.13
2013.00
$4.10
$4.36
$4.49
$4.62
$4.79
$5.02
$5.29
$5.59
$5.89
$6.21
$6.54
$6.86
$6.97
2014.00
$4.38
$4.28
$4.39
$4.53
$4.66
$4.81
$4.96
$5.10
$5.23
$5.32
$5.42
$5.36
2015.00
$3.02
$3.37
$3.54
$3.63
$3.74
$3.86
$4.01
$4.16
$4.30
$4.45
$4.61
$4.75
2016.00
$2.33
$3.14
$3.28
$3.16
$3.19
$3.30
$3.43
$3.58
$3.73
$3.90
$4.08
$4.25
$4.43
39479.00
39814.00
40179.00
40544.00
40909.00
41275.00
41640.00
42005.00
42370.00
42736.00
43101.00
43466.00
43831.00
44197.00
44562.00
44927.00
45292.00
45658.00
46023.00
46388.00
46753.00
3596.23
177.07
93.69
63.75
49.43
40.40
35.33
30.96
27.46
26.18
26.40
26.73
29.37
37.84
43.62
44.10
44.68
45.32
58.45
96.88
182.86
$9.04
$3.99
$4.39
$4.04
$2.79
$3.65
$4.43
$2.67
$2.46
2008.00
2009.00
2010.00
2011.00
2012.00
2013.00
2014.00
2015.00
2016.00
2017.00
2018.00
2019.00
2020.00
2021.00
2022.00
2023.00
2024.00
2025.00
2026.00
2027.00
2028.00
$7.96
$9.83
$9.83
$9.61
$9.47
$9.42
$9.47
$9.58
$9.72
$8.57
$8.75
$8.93
$5.78
$7.09
$7.47
$7.61
$7.73
$7.86
$7.99
$8.14
$8.30
$8.45
$8.69
$8.69
$5.23
$5.93
$6.23
$6.44
$6.66
$6.89
$7.12
$7.35
$7.59
$7.80
$4.50
$5.08
$5.43
$5.73
$6.01
$6.28
$6.55
$6.81
$7.06
$7.25
$7.74
$8.02
$3.50
$4.08
$4.37
$4.57
$4.78
$5.01
$5.26
$5.53
$5.81
$6.25
$6.59
$6.93
$7.20
$7.13
$4.10
$4.36
$4.49
$4.62
$4.79
$5.02
$5.29
$5.59
$5.89
$6.21
$6.54
$6.86
$6.97
$4.38
$4.28
$4.39
$4.53
$4.66
$4.81
$4.96
$5.10
$5.23
$5.32
$5.42
$5.36
$3.02
$3.37
$3.54
$3.63
$3.74
$3.86
$4.01
$4.16
$4.30
$4.45
$4.61
$4.75
$2.33
$3.14
$3.28
$3.16
$3.19
$3.30
$3.43
$3.58
$3.73
$3.90
$4.08
$4.25
$4.43
$9.04
$3.99
$4.39
$4.04
$2.79
$3.65
$4.43
$2.67
$2.46
2008.00
2009.00
2010.00
2011.00
2012.00
2013.00
2014.00
2015.00
2016.00
2017.00
2018.00
2019.00
2020.00
2021.00
2022.00
2023.00
2024.00
2025.00
2026.00
2027.00
2028.00
0.01
$0.02
$7.45
1.00
2006.00
$7.68
$7.32
$7.07
$6.96
$6.83
$6.74
$6.70
$6.75
$6.94
$7.13
$7.34
$7.32
$7.26
$7.54
$7.82
$8.16
$8.47
$8.82
$9.02
$9.51
$6.82
$7.01
$7.06
$7.33
$7.49
$7.73
$7.99
$8.30
$8.68
$9.13
$9.57
$9.60
$9.49
$9.72
$10.00
$10.61
$11.14
$11.67
$12.21
$12.67
$4.64
$5.93
$6.53
$6.60
$6.67
$6.99
$7.23
$7.38
$7.57
$7.80
$8.11
$8.41
$8.84
$9.06
$9.20
$9.49
$9.91
$10.31
$10.88
$11.48
$12.15
$12.94
$13.40
$13.74
$14.40
$4.79
$4.89
$5.09
$5.27
$5.41
$5.58
$5.77
$6.10
$6.45
$6.76
$7.12
$7.53
$7.90
$8.21
$8.56
$8.82
$9.04
$9.28
$9.59
$9.96
$10.34
$10.76
$4.24
$4.41
$4.62
$4.67
$4.79
$4.93
$5.16
$5.39
$5.77
$6.22
$6.58
$6.88
$7.23
$7.56
$7.93
$8.22
$8.57
$8.95
$9.35
$9.81
$10.19
$10.94
$3.36
$3.28
$3.32
$3.86
$4.06
$4.42
$4.59
$4.77
$5.00
$5.35
$5.68
$5.93
$6.14
$6.44
$6.65
$6.94
$7.18
$7.45
$7.78
$8.06
$8.41
$8.96
$3.86
$3.93
$4.41
$4.76
$5.27
$5.19
$4.96
$5.37
$5.64
$5.90
$6.20
$6.45
$6.72
$7.00
$7.26
$7.63
$8.12
$8.47
$8.91
$9.41
$9.83
$4.09
$4.61
$5.07
$5.54
$5.79
$5.97
$6.25
$6.48
$6.72
$7.09
$7.21
$7.34
$3.21
$3.83
$4.34
$4.90
$4.89
$5.03
$5.59
$6.00
$6.27
$6.22
$6.31
$6.50
$2.68
$3.20
$3.17
$3.18
$3.14
$3.15
$3.32
$3.50
$3.71
$3.90
$4.06
$4.31
$7.23
$7.35
$6.90
$6.56
$6.37
$6.16
$5.99
$5.87
$5.82
$5.89
$5.97
$6.05
$5.95
$5.82
$5.95
$6.08
$6.25
$6.39
$6.56
$6.61
$6.86
$7.06
$7.22
$9.03
$6.54
$6.66
$6.62
$6.75
$6.76
$6.82
$6.90
$7.02
$7.18
$7.38
$7.56
$7.43
$7.22
$7.29
$7.40
$7.77
$8.08
$8.38
$8.67
$8.92
$9.09
$9.25
$8.86
$3.49
$4.50
$5.68
$6.17
$6.13
$6.09
$6.27
$6.38
$6.38
$6.43
$6.51
$6.64
$6.74
$6.93
$6.96
$6.91
$6.99
$7.15
$7.29
$7.53
$7.77
$8.05
$8.39
$8.50
$8.53
$8.75
$8.88
$4.09
$4.61
$5.07
$5.54
$5.79
$5.97
$6.25
$6.48
$6.72
$7.09
$7.21
$7.34
$3.21
$3.83
$4.34
$4.90
$4.89
$5.03
$5.59
$6.00
$6.27
$6.22
$6.31
$6.50
$2.42
$2.82
$2.74
$2.69
$2.61
$2.56
$2.64
$2.73
$2.83
$2.92
$2.97
$3.09
$3.16
$3.19
$3.19
$3.17
$3.10
$3.00
$2.81
$2.63
ICE 2009
2009 EIA Forecast
ICE 2010
2010 EIA Forecast
ICE 2011
2011 EIA Forecast
ICE 2012
2012 EIA Forecast (2013 IRP)
ICE 2013
2013 EIA Forecast
ICE 2014
2014 EIA Forecast (2015 IRP)
ICE 2015
2015 EIA Forecast
ICE 2016
2016 EIA Forecast
2016 EIA Low Case (2017 IRP)
Actual HH
Year
$/mmBTU
IPC:
Lline 635 sup_ogc 2008.xls
2013.00
$6.60
$4.79
$4.24
$3.36
2014.00
$6.67
$4.89
$4.41
$3.28
$3.86
2015.00
$6.99
$5.09
$4.62
$3.32
$3.93
2016.00
$7.23
$5.27
$4.67
$3.86
$4.41
2017.00
$7.38
$5.41
$4.79
$4.06
$4.76
2018.00
$7.57
$5.58
$4.93
$4.42
$5.27
2019.00
$7.80
$5.77
$5.16
$4.59
$5.19
2020.00
$8.11
$6.10
$5.39
$4.77
$4.96
2021.00
$8.41
$6.45
$5.77
$5.00
$5.37
2022.00
$8.84
$6.76
$6.22
$5.35
$5.64
2023.00
$9.06
$7.12
$6.58
$5.68
$5.90
2024.00
$9.20
$7.53
$6.88
$5.93
$6.20
2025.00
$9.49
$7.90
$7.23
$6.14
$6.45
2026.00
$9.91
$8.21
$7.56
$6.44
$6.72
2027.00
$10.31
$8.56
$7.93
$6.65
$7.00
2028.00
$10.88
$8.82
$8.22
$6.94
$7.26
2029.00
$11.48
$9.04
$8.57
$7.18
$7.63
2030.00
$12.15
$9.28
$8.95
$7.45
$8.12
2031.00
$12.94
$9.59
$9.35
$7.78
$8.47
2032.00
$13.40
$9.96
$9.81
$8.06
$8.91
2033.00
$13.74
$10.34
$10.19
$8.41
$9.41
2034.00
$14.40
$10.76
$10.94
$8.96
$9.83