Spreadsheet: 101062d1299225281-multiple-data-tables-link-and-calculate-onto-target-tables-test2-excel-forum-reply
Sheet: Sheet2

Annual Energy Tracking
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Report Period |  |  | November |  |  | 2010
 | 2005 Baseline Annual Energy Usage, MMBTU |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015 Target Annual Energy Usage, MMBTU
 |  |  |  |  | History |  |  |  |  |  |  |  |  |  |  |  |  |  | Usage
 |  |  |  |  | Annual Elec, kWh |  | Annual Gas, CCF |  | Annual MMBTU |  |  |  |  |  |  |  | This month's Elec, kWh |  | This Month's Gas, CCF |  | This Month'sTotal MMBTU
 | Reference: |  | 2005 Baseline |  |  |  |  |  |  |  |  |  | Reference: |  | 2005 Baseline
 | Reference: |  | 2015 Goal |  |  |  |  |  |  |  |  |  | Reference: |  | 2015 Goal
 |  |  |  | Usage |  |  |  |  |  |  |  |  |  |  |  | Usage
 |  | vs 2015 Goal Variance |  |  |  |  |  |  |  |  |  |  |  | vs 2015 Goal Var, +/-%
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly MMBTU
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 2015 Goal | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  | YTD Cumulative Tracking, MMBTU |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  | [NAME], kWh |  | Cumulative Gas, CCF |  | Cumulative MMBTU |  |  |  |  |  |  | July
 | Reference: |  | 2005 Baseline |  |  |  |  |  |  |  |  |  |  |  |  | August
 | Reference: |  | 2015 Goal |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  | Cum |  |  |  |  |  |  |  |  |  |  |  | October
 |  | vs 2015 Goal Variance |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dummy data linked to respective cells in given timeframe for testing purposes only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | need to match cell C22 to cells [NAME]:AA17, and take the column for the matching cell to be the column for the vlookup.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | want to sum(cell NN##:cell MM##)
 |  | 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 |  |  |  |  |  |  |  |  | 1 | January |  |  |  |  |  |  |  |  |  | January |  | 2491.933113000001 | 2708.47426 | 2708.47426 | 2708.47426 | 2708.47426 | 2708.47426 | 2708.47426
 | February |  |  |  |  |  |  |  |  | 2 | February |  |  |  |  |  |  |  |  |  | February |  | 2236.057176 | 2066.800924000001 | 2066.800924000001 | 2066.800924000001 | 2066.800924000001 | 2066.800924000001 | 2066.800924000001
 | March |  |  |  |  |  |  |  |  | 3 | March |  |  |  |  |  |  |  |  |  | March |  | 1297.906623 | 1311.523328 | 1311.523328 | 1311.523328 | 1311.523328 | 1311.523328 | 1311.523328
 | April |  |  |  |  |  |  |  |  | 4 | April |  |  |  |  |  |  |  |  |  | April |  | 1255.412512223126 | 825.678268 | 825.678268 | 825.678268 | 825.678268 | 825.678268 | 825.678268
 | May |  |  |  |  |  |  |  |  | 5 | May |  |  |  |  |  |  |  |  |  | May |  | 775.174971 | 890.0004039999999 | 890.0004039999999 | 890.0004039999999 | 890.0004039999999 | 890.0004039999999 | 890.0004039999999
 | June |  |  |  |  |  |  |  |  | 6 | June |  |  |  |  |  |  |  |  |  | June |  | 672.3141929999999 | 866.62608 | 866.62608 | 866.62608 | 866.62608 | 866.62608 | 866.62608
 | July |  |  |  |  |  |  |  |  | 7 | July |  |  |  |  |  |  |  |  |  | July |  | 737.087097 | 867.616652 | 867.616652 | 867.616652 | 866.62608 | 866.62608 | 866.62608
 | August |  |  |  |  |  |  |  |  | 8 | August |  |  |  |  |  |  |  |  |  | August |  | 706.649706 | 904.0568040000002 | 904.0568040000002 | 904.0568040000002 | 904.0568040000002 | 904.0568040000002 | 904.0568040000002
 | September |  |  |  |  |  |  |  |  | 9 | September |  |  |  |  |  |  |  |  |  | September |  | 639.5243967125848 | 1051.19138 | 1051.19138 | 1051.19138 | 1051.19138 | 1051.19138 | 1051.19138
 | October |  |  |  |  |  |  |  |  | 10 | October |  |  |  |  |  |  |  |  |  | October |  | 1011.656217 | 1259.72896 | 1259.72896 | 1259.72896 | 1259.72896 | 1259.72896 | 1259.72896
 | November |  |  |  |  |  |  |  |  | 11 | November |  |  |  |  |  |  |  |  |  | November |  | 2321.253584802063 | 2510.473008 | 2510.473008 | 2510.473008 | 2510.473008 | 2510.473008 | 2510.473008
 | December |  |  |  |  |  |  |  |  | 12 | December |  |  |  |  |  |  |  |  |  | December |  | 2391.585624 | 2559.441343999999 | 2559.441343999999 | 2559.441343999999 | 2559.441343999999 | 2559.441343999999 | 2559.441343999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17821.611412 | 17821.611412 | 17821.611412 | 17820.62084 | 17820.62084 | 17820.62084
 | Approx MMBTUelec versus MMBTUgas = |  |  |  |  | 1 : 1.3 | in other words, approx 30% more energy used as gas vs elec
 |  |  | % MMBTU elec
 |  |  | % MMBTU gas
 | 2015 GOAL |  | IF CELL Q1=MONTHX, SUM [NAME] THRU MONTHX