Spreadsheet: 101585d1299685695-dynamic-charting-test2-excel-forum-reply-2-
Sheet: Sheet2

Annual Energy Tracking
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Report Period |  |  | August |  | 2012
 | 2005 Baseline Annual Energy Usage, MMBTU |  |  |  |  |  |  |  |  |  |  | 2015 Target Annual Energy Usage, MMBTU
 |  |  |  |  | Month's Usage |  |  |  |  |  |  |  |  |  |  |  | YTD Cumulative, MMBTU
 |  |  |  |  | This Month's Elec, kWh |  | This Month's Gas, CCF |  | Month'sTotal MMBTU |  |  |  |  |  |  |  | [NAME], kWh |  | Cumulative Gas, CCF |  | Cumulative MMBTU
Reference: |  |  | 2005 Baseline |  |  |  |  |  |  |  |  | Reference: |  |  | 2005 Baseline
Reference: |  |  | 2015 Goal |  |  |  |  |  |  |  |  | Reference: |  |  | 2015 Goal
Reference: |  |  |  | Usage |  |  |  |  |  |  |  | Reference: |  |  |  | Cum
This Year |  |  |  | Usage |  |  |  |  |  |  |  | This Year |  |  |  | Cum
 |  | vs 2015 Goal Var, +/-% |  |  |  |  |  |  |  |  |  |  |  | vs 2015 Goal Variance
 |  |  |  |  | Annual Usage - History
 |  |  |  |  | Annual Elec, kWh |  | Annual Gas, CCF |  | Annual MMBTU
 | Reference: |  | 2005 Baseline
 | Reference: |  | 2015 Goal
 | Reference: |  |  | Usage
 |  | vs 2015 Goal Variance
 |  | Monthly Electricity, kWh |  |  |  |  |  |  |  |  |  | Monthly Gas, CCF |  |  |  |  |  |  |  |  |  | Monthly Combined Energy Electricity + Gas, MMBTU
 | Month |  | 2005 Baseline | 2015 Goal | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 |  | Month |  | 2005 Baseline | 2015 Goal | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 |  | Month |  | 2005 Baseline | 2015 Goal | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
 | January |  |  |  |  |  |  |  |  |  |  | January |  |  |  |  |  |  |  |  |  |  | January |  |  | 2491.933113000001 | 2708.47426 | 2708.47426 | 2708.47426 | 2708.47426 | 2708.47426 | 2708.47426
 | February |  |  |  |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  |  |  |  | February |  |  | 2236.057176 | 2066.800924000001 | 2066.800924000001 | 2066.800924000001 | 2066.800924000001 | 2066.800924000001 | 2066.800924000001
 | March |  |  |  |  |  |  |  |  |  |  | March |  |  |  |  |  |  |  |  |  |  | March |  |  | 1297.906623 | 1311.523328 | 1311.523328 | 1311.523328 | 1311.523328 | 1311.523328 | 1311.523328
 | April |  |  |  |  |  |  |  |  |  |  | April |  |  |  |  |  |  |  |  |  |  | April |  |  | 1255.412512223126 | 825.678268 | 825.678268 | 825.678268 | 825.678268 | 825.678268 | 825.678268
 | May |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  |  |  |  | May |  |  | 775.174971 | 890.0004039999999 | 890.0004039999999 | 890.0004039999999 | 890.0004039999999 | 890.0004039999999 | 890.0004039999999
 | June |  |  |  |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  |  |  |  | June |  |  | 672.3141929999999 | 866.62608 | 866.62608 | 866.62608 | 867 | 866.62608 | 866.62608
 | July |  |  |  |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  |  |  |  | July |  |  | 737.087097 | 867.616652 | 867.616652 | 867.616652 | 866.62608 | 866.62608 | 866.62608
 | August |  |  |  |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  |  |  |  | August |  |  | 706.649706 | 904.0568040000002 | 904.0568040000002 | 904.0568040000002 | 904.0568040000002 | 904.0568040000002 | 904.0568040000002
 | September |  |  |  |  |  |  |  |  |  |  | September |  |  |  |  |  |  |  |  |  |  | September |  |  | 639.5243967125848 | 1051.19138 | 1051.19138 | 1051.19138 | 1051.19138 | 1051.19138 | 1051.19138
 | October |  |  |  |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  |  |  |  | October |  |  | 1011.656217 | 1259.72896 | 1259.72896 | 1259.72896 | 1259.72896 | 1259.72896 | 1259.72896
 | November |  |  |  |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  |  |  |  | November |  |  | 2321.253584802063 | 2510.473008 | 2510.473008 | 2510.473008 | 2510.473008 | 2510.473008 | 2510.473008
 | December |  |  |  |  |  |  |  |  |  |  | December |  |  |  |  |  |  |  |  |  |  | December |  |  | 2391.585624 | 2559.441343999999 | 2559.441343999999 | 2559.441343999999 | 2559.441343999999 | 2559.441343999999 | 2559.441343999999
 |  |  |  |  |  | 556 | 0.435
 | Approx MMBTUelec versus MMBTUgas = |  |  |  |  | 1 : 1.3 | in other words, approx 30% more energy used as gas vs elec
 |  |  | % MMBTU elec
 |  |  | % MMBTU gas
 |  |  |  |  |  |  |  |  |  | 2013
 | 2015 GOAL
 |  |  | =SUM(INDIRECT("$C$27:"&"$C$32")) | =sum(c27:c32)