# coding: utf-8
require 'rubyfromexcel'

class Spreadsheet
  include RubyFromExcel::ExcelFunctions

  def initialize
    @worksheet_names = {"2007"=>"sheet55", "2007 (Actual, frozen)"=>"sheet53", "2007 (Consistent)"=>"sheet54", "2010"=>"sheet56", "2015"=>"sheet57", "2020"=>"sheet58", "2025"=>"sheet59", "2030"=>"sheet60", "2035"=>"sheet61", "2040"=>"sheet62", "2045"=>"sheet63", "2050"=>"sheet64", "All vectors"=>"sheet8", "CHANGELOG"=>"sheet6", "Combustion Emissions Factors"=>"sheet12", "Constants"=>"sheet11", "Contents"=>"sheet1", "Control"=>"sheet3", "Conversions"=>"sheet9", "DECC Energy Cons. (1.14)"=>"sheet73", "DECC Energy Cons. (4.1)"=>"sheet74", "DUKES 09 (1.2)"=>"sheet65", "DUKES 09 (1.9)"=>"sheet66", "DUKES 09 (2.5)"=>"sheet67", "DUKES 09 (5.1)"=>"sheet68", "DUKES 09 (5.6)"=>"sheet69", "DUKES 09 (7.2)"=>"sheet70", "DUKES 09 (7.4)"=>"sheet71", "DUKES 09 (A.1)"=>"sheet72", "Global assumptions"=>"sheet10", "Glossary"=>"sheet4", "I.a"=>"sheet17", "I.b"=>"sheet18", "II.a"=>"sheet19", "III.a.1"=>"sheet20", "III.a.2"=>"sheet21", "III.b"=>"sheet23", "III.c"=>"sheet22", "III.d"=>"sheet24", "IV.a"=>"sheet25", "IV.b"=>"sheet26", "IV.c"=>"sheet27", "IX.a"=>"sheet38", "IX.c"=>"sheet39", "Instructions"=>"sheet2", "Intermediate output"=>"sheet7", "Preferences"=>"sheet5", "V.a"=>"sheet28", "V.b"=>"sheet29", "VI.a"=>"sheet30", "VI.b"=>"sheet31", "VI.c"=>"sheet32", "VII.a"=>"sheet33", "VII.b"=>"sheet34", "VII.c"=>"sheet35", "VII.c (1 day)"=>"sheet36", "VIII.a"=>"sheet37", "X.a"=>"sheet40", "X.b"=>"sheet41", "XI.a"=>"sheet42", "XII.a"=>"sheet43", "XII.b"=>"sheet44", "XII.c"=>"sheet45", "XII.e"=>"sheet46", "XIII.a"=>"sheet47", "XIV.a"=>"sheet48", "XV.a"=>"sheet49", "XV.b"=>"sheet50", "XVI.a"=>"sheet51", "XVII.a"=>"sheet52", "{Emissions}"=>"sheet16", "{Energy vectors}"=>"sheet15", "{Modules}"=>"sheet14", "{Workstreams}"=>"sheet13"}
    @workbook_tables = {"all.vectors.and.emissions"=>'Table.new(sheet8,"All.Vectors.And.Emissions","B4:P241",["Module", "Module name", "Vector", "Vector name", "Combined", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "bioexports"=>'Table.new(sheet28,"BioExports","B183:O186",["Vector", "Exports of biomass (supply - available)", "Note", "Units", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "changelog"=>'Table.new(sheet6,"Changelog","B2:E34",["Version", "Release date", "Responsible", "Changes since last version"],)', "ef"=>'Table.new(sheet12,"EF","B4:G50",["Vector", "Description", "CO2", "CH4", "N2O", "Comments"],)', "ghg"=>'Table.new(sheet16,"GHG","B20:D24",["GHG_code", "GHG_description", "Comment"],)', "global.assumptions"=>'Table.new(sheet10,"Global.Assumptions","B4:E14",["Year", "Population", "Households", "GDP (2005 £m)"],)', "i.a.emissions"=>'Table.new(sheet17,"I.a.Emissions","C197:O201",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "i.a.info"=>'Table.new(sheet17,"I.a.Info","C209:O211",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "i.a.inputs"=>'Table.new(sheet17,"I.a.Inputs","C14:O16",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "i.a.outputs"=>'Table.new(sheet17,"I.a.Outputs","C183:O190",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "i.b.emissions"=>'Table.new(sheet18,"I.b.Emissions","C207:O212",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "i.b.info"=>'Table.new(sheet18,"I.b.Info","C219:O221",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "i.b.inputs"=>'Table.new(sheet18,"I.b.Inputs","C15:O17",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "i.b.outputs"=>'Table.new(sheet18,"I.b.Outputs","C194:O200",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ii.a.info"=>'Table.new(sheet19,"II.a.info","C127:O129",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "ii.a.inputs"=>'Table.new(sheet19,"II.a.Inputs","C14:O16",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "ii.a.outputs"=>'Table.new(sheet19,"II.a.Outputs","C114:O120",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ii.b.info"=>'Table.new(sheet44,"II.b.info","C206:O209",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iii.a.1.info"=>'Table.new(sheet20,"III.a.1.info","C97:O100",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iii.a.1.outputs"=>'Table.new(sheet20,"III.a.1.Outputs","C87:O90",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iii.a.2.info"=>'Table.new(sheet21,"III.a.2.info","C101:O104",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iii.a.2.outputs"=>'Table.new(sheet21,"III.a.2.Outputs","C91:O94",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iii.b.info"=>'Table.new(sheet23,"III.b.info","C86:O89",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iii.b.outputs"=>'Table.new(sheet23,"III.b.Outputs","C76:O79",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iii.c.outputs"=>'Table.new(sheet22,"III.c.Outputs","C140:O144",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iii.c.tidalrange.info"=>'Table.new(sheet22,"III.c.TidalRange.info","C189:O192",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iii.c.tidalrange.outputs"=>'Table.new(sheet22,"III.c.TidalRange.Outputs","C164:O168",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iii.c.tidalstream.info"=>'Table.new(sheet22,"III.c.TidalStream.info","C182:O185",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iii.c.tidalstream.outputs"=>'Table.new(sheet22,"III.c.TidalStream.Outputs","C156:O160",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iii.c.wave.info"=>'Table.new(sheet22,"III.c.Wave.info","C175:O178",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iii.c.wave.outputs"=>'Table.new(sheet22,"III.c.Wave.Outputs","C148:O152",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iii.d.info"=>'Table.new(sheet24,"III.d.info","C73:O75",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iii.d.outputs"=>'Table.new(sheet24,"III.d.Outputs","C63:O66",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ipcc"=>'Table.new(sheet16,"IPCC","B4:D15",["Sector_code", "Sector_description", "Comment"],)', "iv.a.info"=>'Table.new(sheet25,"IV.a.info","C80:O82",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iv.a.outputs"=>'Table.new(sheet25,"IV.a.Outputs","C70:O73",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iv.b.info"=>'Table.new(sheet26,"IV.b.info","C75:O77",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iv.b.outputs"=>'Table.new(sheet26,"IV.b.Outputs","C63:O68",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "iv.c.info"=>'Table.new(sheet27,"IV.c.info","C80:O83",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "iv.c.outputs"=>'Table.new(sheet27,"IV.c.Outputs","C70:O73",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.a.chp.emissions"=>'Table.new(sheet38,"IX.a.CHP.Emissions","C714:O718",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.a.chp.outputs"=>'Table.new(sheet38,"IX.a.CHP.Outputs","C671:O682",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.a.emissions"=>'Table.new(sheet38,"IX.a.Emissions","C723:O727",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.a.info"=>'Table.new(sheet38,"IX.a.info","C735:O736",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "ix.a.nochp.emissions"=>'Table.new(sheet38,"IX.a.NoCHP.Emissions","C705:O709",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.a.nochp.outputs"=>'Table.new(sheet38,"IX.a.NoCHP.Outputs","C656:O666",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.a.outputs"=>'Table.new(sheet38,"IX.a.Outputs","C687:O697",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.c.chp.emissions"=>'Table.new(sheet39,"IX.c.CHP.Emissions","C415:O419",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.c.chp.outputs"=>'Table.new(sheet39,"IX.c.CHP.Outputs","C376:O386",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.c.emissions"=>'Table.new(sheet39,"IX.c.Emissions","C424:O428",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.c.info"=>'Table.new(sheet39,"IX.c.info","C436:O437",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "ix.c.nochp.emissions"=>'Table.new(sheet39,"IX.c.NoCHP.Emissions","C406:O410",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.c.nochp.outputs"=>'Table.new(sheet39,"IX.c.NoCHP.Outputs","C362:O371",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "ix.c.outputs"=>'Table.new(sheet39,"IX.c.Outputs","C390:O399",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "modules"=>'Table.new(sheet14,"Modules","B4:F50",["Code", "Module", "WS Code", "Workstream", "Comments"],)', "unused.xiii.a.outputs"=>'Table.new(sheet47,"UNUSED.XIII.a.Outputs","C43:O48",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "v.a.emissions"=>'Table.new(sheet28,"V.a.Emissions","C214:O216",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "v.a.info"=>'Table.new(sheet28,"V.a.info","C224:O226",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "v.a.inputs"=>'Table.new(sheet28,"V.a.Inputs","C14:O19",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "v.a.inputs2"=>'Table.new(sheet28,"V.a.Inputs2","C23:O26",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "v.a.outputs"=>'Table.new(sheet28,"V.a.Outputs","C197:O207",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "v.b.emissions"=>'Table.new(sheet29,"V.b.Emissions","C83:O85",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "v.b.info"=>'Table.new(sheet29,"V.b.info","C92:O94",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "v.b.inputs"=>'Table.new(sheet29,"V.b.Inputs","C14:O17",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "v.b.outputs"=>'Table.new(sheet29,"V.b.Outputs","C71:O76",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vectors"=>'Table.new(sheet15,"Vectors","B4:F60",["Category", "Subcategory", "Code", "Description", "Comment"],)', "vi.a.biocrop.info"=>'Table.new(sheet30,"VI.a.Biocrop.info","C422:O423",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "vi.a.emissions"=>'Table.new(sheet30,"VI.a.Emissions","C408:O415",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vi.a.forestry.info"=>'Table.new(sheet30,"VI.a.Forestry.info","C427:O428",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "vi.a.outputs"=>'Table.new(sheet30,"VI.a.Outputs","C389:O401",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vi.b.emissions"=>'Table.new(sheet31,"VI.b.Emissions","C279:O283",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vi.b.info"=>'Table.new(sheet31,"VI.b.info","C290:O292",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "vi.b.outputs"=>'Table.new(sheet31,"VI.b.Outputs","C266:O272",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vi.c.info"=>'Table.new(sheet32,"VI.c.info","C65:O67",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "vi.c.outputs"=>'Table.new(sheet32,"VI.c.Outputs","C55:O58",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vii.a.info"=>'Table.new(sheet33,"VII.a.info","C68:O70",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "vii.a.outputs"=>'Table.new(sheet33,"VII.a.Outputs","C58:O61",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vii.b.info"=>'Table.new(sheet34,"VII.b.info","C47:O49",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "vii.b.inputs"=>'Table.new(sheet34,"VII.b.Inputs","C8:O9",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "vii.b.outputs"=>'Table.new(sheet34,"VII.b.Outputs","C36:O40",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vii.c.emissions"=>'Table.new(sheet35,"VII.c.Emissions","C444:O448",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vii.c.emissions75"=>'Table.new(sheet36,"VII.c.Emissions75","C443:O447",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "vii.c.info"=>'Table.new(sheet35,"VII.c.Info","C431:O436",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "vii.c.info83"=>'Table.new(sheet36,"VII.c.Info83","C430:O435",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "viii.a.emissions"=>'Table.new(sheet37,"VIII.a.Emissions","C73:O77",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "viii.a.info"=>'Table.new(sheet37,"VIII.a.info","C84:O87",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "viii.a.inputs"=>'Table.new(sheet37,"VIII.a.Inputs","C8:O9",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "viii.a.outputs"=>'Table.new(sheet37,"VIII.a.Outputs","C61:O66",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "workstreams"=>'Table.new(sheet13,"Workstreams","B4:C21",["Code", "Workstream"],)', "x.a.emissions"=>'Table.new(sheet40,"X.a.Emissions","C109:O113",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "x.a.info"=>'Table.new(sheet40,"X.a.info","C121:O123",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "x.a.outputs"=>'Table.new(sheet40,"X.a.Outputs","C98:O102",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "x.b.emissions"=>'Table.new(sheet41,"X.b.Emissions","C100:O104",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "x.b.info"=>'Table.new(sheet41,"X.b.info","C112:O114",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "x.b.outputs"=>'Table.new(sheet41,"X.b.Outputs","C89:O93",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xi.a.emissions"=>'Table.new(sheet42,"XI.a.Emissions","C225:O234",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xi.a.info"=>'Table.new(sheet42,"XI.a.info","C242:O244",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xi.a.outputs"=>'Table.new(sheet42,"XI.a.Outputs","C211:O218",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.a.aviation.emissions"=>'Table.new(sheet43,"XII.a.Aviation.Emissions","C395:O399",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.a.aviation.outputs"=>'Table.new(sheet43,"XII.a.Aviation.Outputs","C359:O364",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.a.emissions"=>'Table.new(sheet43,"XII.a.Emissions","C371:O375",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.a.info"=>'Table.new(sheet43,"XII.a.info","C406:O408",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xii.a.outputs"=>'Table.new(sheet43,"XII.a.Outputs","C330:O337",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.a.rail.emissions"=>'Table.new(sheet43,"XII.a.Rail.Emissions","C387:O391",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.a.rail.outputs"=>'Table.new(sheet43,"XII.a.Rail.Outputs","C350:O355",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.a.road.emissions"=>'Table.new(sheet43,"XII.a.road.Emissions","C379:O383",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.a.road.outputs"=>'Table.new(sheet43,"XII.a.Road.Outputs","C341:O346",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.b.emissions"=>'Table.new(sheet44,"XII.b.Emissions","C170:O174",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.b.nationalnavigation.emissions"=>'Table.new(sheet44,"XII.b.NationalNavigation.Emissions","C194:O198",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.b.nationalnavigation.outputs"=>'Table.new(sheet44,"XII.b.nationalnavigation.Outputs","C159:O162",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.b.outputs"=>'Table.new(sheet44,"XII.b.Outputs","C133:O139",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.b.rail.emissions"=>'Table.new(sheet44,"XII.b.Rail.Emissions","C186:O190",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.b.rail.outputs"=>'Table.new(sheet44,"XII.b.Rail.Outputs","C151:O155",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.b.road.emissions"=>'Table.new(sheet44,"XII.b.Road.Emissions","C178:O182",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.b.road.outputs"=>'Table.new(sheet44,"XII.b.road.Outputs","C143:O147",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.c.emissions"=>'Table.new(sheet45,"XII.c.Emissions","C70:O74",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.c.info"=>'Table.new(sheet45,"XII.c.info","C82:O84",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xii.c.outputs"=>'Table.new(sheet45,"XII.c.Outputs","C60:O63",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.e.emissions"=>'Table.new(sheet46,"XII.e.Emissions","C69:O73",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xii.e.info"=>'Table.new(sheet46,"XII.e.info","C81:O83",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xii.e.outputs"=>'Table.new(sheet46,"XII.e.Outputs","C59:O62",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xiii.a.info"=>'Table.new(sheet47,"XIII.a.info","C55:O58",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xiv.a.emissions"=>'Table.new(sheet48,"XIV.a.Emissions","C80:O82",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xiv.a.info"=>'Table.new(sheet48,"XIV.a.info","C90:O92",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xiv.a.outputs"=>'Table.new(sheet48,"XIV.a.Outputs","C70:O73",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xv.a.emissions"=>'Table.new(sheet49,"XV.a.Emissions","C115:O119",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xv.a.info"=>'Table.new(sheet49,"XV.a.info","C127:O130",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xv.a.inputs"=>'Table.new(sheet49,"XV.a.Inputs","C8:O9",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xv.a.outputs"=>'Table.new(sheet49,"XV.a.Outputs","C100:O108",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xv.b.emissions"=>'Table.new(sheet50,"XV.b.Emissions","C91:O97",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xv.b.info"=>'Table.new(sheet50,"XV.b.info","C105:O107",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xv.b.outputs"=>'Table.new(sheet50,"XV.b.Outputs","C73:O84",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xvi.a.emissions"=>'Table.new(sheet51,"XVI.a.Emissions","C72:O74",["GHG", "IPCC Sector", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xvi.a.info"=>'Table.new(sheet51,"XVI.a.info","C82:O84",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xvi.a.inputs"=>'Table.new(sheet51,"XVI.a.Inputs","C8:O11",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xvi.a.outputs"=>'Table.new(sheet51,"XVI.a.Outputs","C57:O65",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)', "xvii.a.info"=>'Table.new(sheet52,"XVII.a.info","C48:O50",["Vector", "Information type", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xvii.a.inputs"=>'Table.new(sheet52,"XVII.a.Inputs","C8:O9",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],)', "xvii.a.outputs"=>'Table.new(sheet52,"XVII.a.Outputs","C37:O41",["Vector", "Name", "Notes", "2007", "2010", "2015", "2020", "2025", "2030", "2035", "2040", "2045", "2050"],1)'}
  end

  def balancing_boostable_capacity_ccs; sheet18.a('f172','o172'); end
  def balancing_boostable_capacity_coal_bio; sheet17.a('f174','o174'); end
  def constants_density_diesel; sheet11.c34; end
  def constants_density_motor_spirit; sheet11.c33; end
  def constants_gcv_atf; sheet11.c16; end
  def constants_gcv_coal; sheet11.c6; end
  def constants_gcv_coke; sheet11.c7; end
  def constants_gcv_coke_breeze; sheet11.c8; end
  def constants_gcv_crude_oil; sheet11.c12; end
  def constants_gcv_diesel; sheet11.c15; end
  def constants_gcv_landfill_gas; sheet11.c23; end
  def constants_gcv_motor_spirit; sheet11.c14; end
  def constants_gcv_natural_gas_produced; sheet11.c19; end
  def constants_gcv_petroleum_products; sheet11.c13; end
  def conversion_to_annual_energy; sheet9.e55; end
  def conversion_to_average_power; sheet9.e54; end
  def conversion_to_energy_per_second; sheet9.e56; end
  def conversions_area_m2; sheet9.a('e44','e49'); end
  def conversions_area_units; sheet9.a('b44','b49'); end
  def conversions_energy_joules; sheet9.a('e5','e20'); end
  def conversions_energy_units; sheet9.a('b5','b20'); end
  def conversions_power_units; sheet9.a('b26','b31'); end
  def conversions_power_watts; sheet9.a('e26','e31'); end
  def ef_blast_furnace_gas_co2; sheet11.f9; end
  def ef_diesel_ch4; sheet11.g7; end
  def ef_diesel_co2; sheet11.f7; end
  def ef_diesel_n2o; sheet11.h7; end
  def ef_industrial_coal_ch4; sheet11.g6; end
  def ef_industrial_coal_co2; sheet11.f6; end
  def ef_industrial_coal_n2o; sheet11.h6; end
  def ef_natural_gas_ch4; sheet11.g8; end
  def ef_natural_gas_co2; sheet11.f8; end
  def ef_natural_gas_n2o; sheet11.h8; end
  def global_ukincident_solar_energy; sheet10.i5; end
  def global_ukincident_solar_energy_south_facing; sheet10.i6; end
  def gwp_ch4; sheet11.k7; end
  def gwp_n2o; sheet11.k8; end
  def i_a_scenario; sheet3.z10; end
  def i_b_1_scenario; sheet3.z6; end
  def i_b_2_scenario; sheet3.z7; end
  def i_b_scenario; sheet3.z6; end
  def ii_a_scenario; sheet3.z4; end
  def iii_a_1_scenario; sheet3.z13; end
  def iii_a_2_scenario; sheet3.z8; end
  def iii_a_scenario; sheet3.z13; end
  def iii_b_scenario; sheet3.z15; end
  def iii_c_scenario; sheet3.z9; end
  def iii_d_scenario; sheet3.z14; end
  def iv_a_scenario; sheet3.z11; end
  def iv_b_scenario; sheet3.z36; end
  def iv_c_scenario; sheet3.z16; end
  def ix_a_scenario_electrification; sheet3.z34; end
  def ix_a_scenario_fuel; sheet3.z35; end
  def ix_a_scenario_insulation; sheet3.z33; end
  def ix_a_scenario_service_demand; sheet3.z32; end
  def ix_c_scenario_demand; sheet3.z44; end
  def ix_c_scenario_electrification; sheet3.z45; end
  def ix_c_scenario_fuel; sheet3.z46; end
  def preferences_area_units; sheet5.c7; end
  def preferences_energy_units; sheet5.c3; end
  def preferences_power_units; sheet5.c5; end
  def preferences_unit_energy; sheet5.f3; end
  def preferences_unit_power; sheet5.f5; end
  def unit_acre; sheet9.f46; end
  def unit_btu; sheet9.f18; end
  def unit_calorie; sheet9.f19; end
  def unit_day; sheet9.f37; end
  def unit_gj; sheet9.f7; end
  def unit_gw; sheet9.f26; end
  def unit_gwh; sheet9.f13; end
  def unit_gwyear; sheet9.f20; end
  def unit_ha; sheet9.f44; end
  def unit_hour; sheet9.f38; end
  def unit_j; sheet9.f8; end
  def unit_km2; sheet9.f47; end
  def unit_ktoe; sheet9.f15; end
  def unit_k_w; sheet9.f28; end
  def unit_k_wh; sheet9.f10; end
  def unit_k_wh_p_d; sheet9.f11; end
  def unit_m2; sheet9.f48; end
  def unit_mcm_d; sheet9.f30; end
  def unit_mha; sheet9.f45; end
  def unit_minute; sheet9.f39; end
  def unit_mj; sheet9.f9; end
  def unit_mtoe; sheet9.f16; end
  def unit_mtoe_y; sheet9.f31; end
  def unit_mw; sheet9.f27; end
  def unit_pj; sheet9.f5; end
  def unit_therm; sheet9.f17; end
  def unit_tj; sheet9.f6; end
  def unit_toe; sheet9.f14; end
  def unit_twh; sheet9.f12; end
  def unit_w; sheet9.f29; end
  def unit_wales; sheet9.f49; end
  def unit_year; sheet9.f36; end
  def v_a_scenario; sheet3.z17; end
  def v_b_scenario; sheet3.z23; end
  def vi_a_2_scenario; sheet3.z20; end
  def vi_a_scenario; sheet3.z19; end
  def vi_b_scenario; sheet3.z21; end
  def vi_c_scenario; sheet3.z22; end
  def vii_a_scenario; sheet3.z12; end
  def vii_c_scenario; sheet3.z51; end
  def x_a_scenario_demand; sheet3.z38; end
  def x_a_scenario_technology; sheet3.z39; end
  def x_b_scenario_demand; sheet3.z48; end
  def x_b_scenario_technology; sheet3.z49; end
  def xi_a_scenario_efficiency; sheet3.z42; end
  def xi_a_scenario_output; sheet3.z41; end
  def xii_a_scenario_demand; sheet3.z26; end
  def xii_a_scenario_technology; sheet3.z27; end
  def xii_b_scenario; sheet3.z29; end
  def xii_c_scenario; sheet3.z28; end
  def xii_e_scenario; sheet3.z30; end
  def xiv_a_scenario; sheet3.z50; end
end

Dir[File.join(File.dirname(__FILE__),"sheets/","sheet*.rb")].each {|f| Spreadsheet.autoload(File.basename(f,".rb").capitalize,f)}