# coding: utf-8
require_relative '../spreadsheet'
# Control
describe 'Sheet5' do
  def sheet5; $spreadsheet ||= Spreadsheet.new; $spreadsheet.sheet5; end

  it 'cell e5 should equal "Nuclear power"' do
    sheet5.e5.should == "Nuclear power"
  end

  it 'cell e6 should equal "Carbon Capture Storage (CCS)"' do
    sheet5.e6.should == "Carbon Capture Storage (CCS)"
  end

  it 'cell bv8 should equal "Interconnector capacity"' do
    sheet5.bv8.should == "Interconnector capacity"
  end

  it 'cell ca8 should equal 2.5' do
    sheet5.ca8.should be_within(0.25).of(2.5)
  end

  it 'cell cb8 should equal 6.0' do
    sheet5.cb8.should be_within(0.6000000000000001).of(6.0)
  end

  it 'cell cc8 should equal 10.0' do
    sheet5.cc8.should be_within(1.0).of(10.0)
  end

  it 'cell cd8 should equal 10.0' do
    sheet5.cd8.should be_within(1.0).of(10.0)
  end

  it 'cell e9 should equal "Offshore wind"' do
    sheet5.e9.should == "Offshore wind"
  end

  it 'cell bv9 should equal "Standby capacity required"' do
    sheet5.bv9.should == "Standby capacity required"
  end

  it 'cell by9 should equal "GWcapacity"' do
    sheet5.by9.should == "GWcapacity"
  end

  it 'cell ca9 should equal 0.0' do
    sheet5.ca9.should be_within(1.0e-08).of(0.0)
  end

  it 'cell cb9 should equal 0.2677288659808359' do
    sheet5.cb9.should be_within(0.026772886598083592).of(0.2677288659808359)
  end

  it 'cell cc9 should equal 20.693382832338038' do
    sheet5.cc9.should be_within(2.069338283233804).of(20.693382832338038)
  end

  it 'cell cd9 should equal 34.761081811442104' do
    sheet5.cd9.should be_within(3.4761081811442107).of(34.761081811442104)
  end

  it 'cell e10 should equal "Onshore wind"' do
    sheet5.e10.should == "Onshore wind"
  end

  it 'cell bv10 should equal "Probable annual emissions"' do
    sheet5.bv10.should == "Probable annual emissions"
  end

  it 'cell by10 should equal "MtCO2e"' do
    sheet5.by10.should == "MtCO2e"
  end

  it 'cell ca10 should equal 0.0' do
    sheet5.ca10.should be_within(1.0e-08).of(0.0)
  end

  it 'cell cb10 should equal 0.014840118539961152' do
    sheet5.cb10.should be_within(0.0014840118539961153).of(0.014840118539961152)
  end

  it 'cell cc10 should equal 1.1470270607528565' do
    sheet5.cc10.should be_within(0.11470270607528565).of(1.1470270607528565)
  end

  it 'cell cd10 should equal 1.9267947547202986' do
    sheet5.cd10.should be_within(0.19267947547202988).of(1.9267947547202986)
  end

  it 'cell e11 should equal "Tidal and Wave"' do
    sheet5.e11.should == "Tidal and Wave"
  end

  it 'cell e12 should equal "Biomass/Coal power stations"' do
    sheet5.e12.should == "Biomass/Coal power stations"
  end

  it 'cell e13 should equal "Solar PV"' do
    sheet5.e13.should == "Solar PV"
  end

  it 'cell e14 should equal "Solar thermal"' do
    sheet5.e14.should == "Solar thermal"
  end

  it 'cell e15 should equal "Geothermal electricity"' do
    sheet5.e15.should == "Geothermal electricity"
  end

  it 'cell e16 should equal "Hydroelectric power stations"' do
    sheet5.e16.should == "Hydroelectric power stations"
  end

  it 'cell e17 should equal "Small-scale wind"' do
    sheet5.e17.should == "Small-scale wind"
  end

  it 'cell e18 should equal "Electricity imports"' do
    sheet5.e18.should == "Electricity imports"
  end

  it 'cell e19 should equal "Agriculture and land use"' do
    sheet5.e19.should == "Agriculture and land use"
  end

  it 'cell bz19 should equal "TWh / year"' do
    sheet5.bz19.should == "TWh / year"
  end

  it 'cell bw20 should equal "Coal oversupply (imports)"' do
    sheet5.bw20.should == "Coal oversupply (imports)"
  end

  it 'cell ca20 should equal -329.05563918270377' do
    sheet5.ca20.should be_within(32.90556391827038).of(-329.05563918270377)
  end

  it 'cell cb20 should equal -75.33233276970904' do
    sheet5.cb20.should be_within(7.533233276970904).of(-75.33233276970904)
  end

  it 'cell cc20 should equal 107.26999404459559' do
    sheet5.cc20.should be_within(10.72699940445956).of(107.26999404459559)
  end

  it 'cell cd20 should equal -11.605761552073517' do
    sheet5.cd20.should be_within(1.1605761552073517).of(-11.605761552073517)
  end

  it 'cell bw21 should equal "Oil and petroleum products oversupply (imports)"' do
    sheet5.bw21.should == "Oil and petroleum products oversupply (imports)"
  end

  it 'cell ca21 should equal 86.78455797358367' do
    sheet5.ca21.should be_within(8.678455797358367).of(86.78455797358367)
  end

  it 'cell cb21 should equal -313.09395809458334' do
    sheet5.cb21.should be_within(31.309395809458337).of(-313.09395809458334)
  end

  it 'cell cc21 should equal -346.7112541447758' do
    sheet5.cc21.should be_within(34.67112541447758).of(-346.7112541447758)
  end

  it 'cell cd21 should equal -504.28688593352877' do
    sheet5.cd21.should be_within(50.42868859335288).of(-504.28688593352877)
  end

  it 'cell e22 should equal "Volume of Waste & Recycling"' do
    sheet5.e22.should == "Volume of Waste & Recycling"
  end

  it 'cell bw22 should equal "Gas oversupply (imports)"' do
    sheet5.bw22.should == "Gas oversupply (imports)"
  end

  it 'cell ca22 should equal -149.76767097151924' do
    sheet5.ca22.should be_within(14.976767097151924).of(-149.76767097151924)
  end

  it 'cell cb22 should equal -473.31187743652674' do
    sheet5.cb22.should be_within(47.33118774365268).of(-473.31187743652674)
  end

  it 'cell cc22 should equal -361.9416976362309' do
    sheet5.cc22.should be_within(36.194169763623094).of(-361.9416976362309)
  end

  it 'cell cd22 should equal -41.09404704388524' do
    sheet5.cd22.should be_within(4.109404704388524).of(-41.09404704388524)
  end

  it 'cell e23 should equal "Marine algae"' do
    sheet5.e23.should == "Marine algae"
  end

  it 'cell bw23 should equal "Biomass oversupply (imports)"' do
    sheet5.bw23.should == "Biomass oversupply (imports)"
  end

  it 'cell ca23 should equal -4.00072' do
    sheet5.ca23.should be_within(0.40007200000000004).of(-4.00072)
  end

  it 'cell cb23 should equal -23.95399069767442' do
    sheet5.cb23.should be_within(2.3953990697674423).of(-23.95399069767442)
  end

  it 'cell cc23 should equal -39.302660465116276' do
    sheet5.cc23.should be_within(3.930266046511628).of(-39.302660465116276)
  end

  it 'cell cd23 should equal -70.0' do
    sheet5.cd23.should be_within(7.0).of(-70.0)
  end

  it 'cell e24 should equal "Types of fuel from Biomass"' do
    sheet5.e24.should == "Types of fuel from Biomass"
  end

  it 'cell bw24 should equal "Electricity oversupply (imports)"' do
    sheet5.bw24.should == "Electricity oversupply (imports)"
  end

  it 'cell ca24 should equal -5.684341886080802e-14' do
    sheet5.ca24.should be_within(1.0e-08).of(-5.684341886080802e-14)
  end

  it 'cell cb24 should equal -5.684341886080802e-14' do
    sheet5.cb24.should be_within(1.0e-08).of(-5.684341886080802e-14)
  end

  it 'cell cc24 should equal 0.0' do
    sheet5.cc24.should be_within(1.0e-08).of(0.0)
  end

  it 'cell cd24 should equal 103.25093663250482' do
    sheet5.cd24.should be_within(10.325093663250483).of(103.25093663250482)
  end

  it 'cell e25 should equal "Bioenergy imports"' do
    sheet5.e25.should == "Bioenergy imports"
  end

  it 'cell e27 should equal "Domestic passenger transport"' do
    sheet5.e27.should == "Domestic passenger transport"
  end

  it 'cell bz28 should equal "TWh / year"' do
    sheet5.bz28.should == "TWh / year"
  end

  it 'cell e30 should equal "Domestic freight"' do
    sheet5.e30.should == "Domestic freight"
  end

  it 'cell ca30 should equal 989.1712766501873' do
    sheet5.ca30.should be_within(98.91712766501874).of(989.1712766501873)
  end

  it 'cell cb30 should equal 911.6496784660293' do
    sheet5.cb30.should be_within(91.16496784660293).of(911.6496784660293)
  end

  it 'cell cc30 should equal 659.131539316433' do
    sheet5.cc30.should be_within(65.9131539316433).of(659.131539316433)
  end

  it 'cell cd30 should equal 203.06559504889498' do
    sheet5.cd30.should be_within(20.3065595048895).of(203.06559504889498)
  end

  it 'cell e31 should equal "International aviation"' do
    sheet5.e31.should == "International aviation"
  end

  it 'cell ca31 should equal 0.02224486582423221' do
    sheet5.ca31.should be_within(0.002224486582423221).of(0.02224486582423221)
  end

  it 'cell cb31 should equal 0.07127231319939303' do
    sheet5.cb31.should be_within(0.007127231319939304).of(0.07127231319939303)
  end

  it 'cell cc31 should equal 0.11308668146134376' do
    sheet5.cc31.should be_within(0.011308668146134376).of(0.11308668146134376)
  end

  it 'cell cd31 should equal 0.39959597376402045' do
    sheet5.cd31.should be_within(0.03995959737640205).of(0.39959597376402045)
  end

  it 'cell e32 should equal "International shipping"' do
    sheet5.e32.should == "International shipping"
  end

  it 'cell ca32 should equal 0.32802995248386824' do
    sheet5.ca32.should be_within(0.032802995248386826).of(0.32802995248386824)
  end

  it 'cell cb32 should equal 0.318952492516671' do
    sheet5.cb32.should be_within(0.031895249251667104).of(0.318952492516671)
  end

  it 'cell cc32 should equal 0.29528498273868087' do
    sheet5.cc32.should be_within(0.029528498273868088).of(0.29528498273868087)
  end

  it 'cell cd32 should equal 0.0018256467692384557' do
    sheet5.cd32.should be_within(0.00018256467692384559).of(0.0018256467692384557)
  end

  it 'cell e33 should equal "Domestic space heating and hot water"' do
    sheet5.e33.should == "Domestic space heating and hot water"
  end

  it 'cell bk33 should equal "Hydrocarbon fuel power generation"' do
    sheet5.bk33.should == "Hydrocarbon fuel power generation"
  end

  it 'cell bo33 should equal 200.1293411589495' do
    sheet5.bo33.should be_within(20.01293411589495).of(200.1293411589495)
  end

  it 'cell bp33 should equal 16.688490998952744' do
    sheet5.bp33.should be_within(1.6688490998952745).of(16.688490998952744)
  end

  it 'cell bq33 should equal 0.021538695768502956' do
    sheet5.bq33.should be_within(0.0021538695768502955).of(0.021538695768502956)
  end

  it 'cell ca33 should equal 0.07911911887624118' do
    sheet5.ca33.should be_within(0.007911911887624119).of(0.07911911887624118)
  end

  it 'cell cb33 should equal 0.07404473144868146' do
    sheet5.cb33.should be_within(0.007404473144868146).of(0.07404473144868146)
  end

  it 'cell cc33 should equal 0.07333954367278696' do
    sheet5.cc33.should be_within(0.007333954367278696).of(0.07333954367278696)
  end

  it 'cell cd33 should equal 0.0006343433044882847' do
    sheet5.cd33.should be_within(6.343433044882847e-05).of(0.0006343433044882847)
  end

  it 'cell bk34 should equal "Bioenergy"' do
    sheet5.bk34.should == "Bioenergy"
  end

  it 'cell bo34 should equal -9.546024100803647' do
    sheet5.bo34.should be_within(0.9546024100803647).of(-9.546024100803647)
  end

  it 'cell bp34 should equal -120.94874750502247' do
    sheet5.bp34.should be_within(12.094874750502248).of(-120.94874750502247)
  end

  it 'cell bq34 should equal -0.15610028949026228' do
    sheet5.bq34.should be_within(0.015610028949026229).of(-0.15610028949026228)
  end

  it 'cell ca34 should equal 0.15169564407197347' do
    sheet5.ca34.should be_within(0.015169564407197349).of(0.15169564407197347)
  end

  it 'cell cb34 should equal 0.13802475159955507' do
    sheet5.cb34.should be_within(0.013802475159955509).of(0.13802475159955507)
  end

  it 'cell cc34 should equal 0.1700449218209926' do
    sheet5.cc34.should be_within(0.01700449218209926).of(0.1700449218209926)
  end

  it 'cell cd34 should equal 0.1951964468220445' do
    sheet5.cd34.should be_within(0.019519644682204452).of(0.1951964468220445)
  end

  it 'cell bk35 should equal "Geosequestration"' do
    sheet5.bk35.should == "Geosequestration"
  end

  it 'cell bo35 should equal 0.0' do
    sheet5.bo35.should be_within(1.0e-08).of(0.0)
  end

  it 'cell bp35 should equal 0.0' do
    sheet5.bp35.should be_within(1.0e-08).of(0.0)
  end

  it 'cell bq35 should equal 0.0' do
    sheet5.bq35.should be_within(1.0e-08).of(0.0)
  end

  it 'cell ca35 should equal 0.3544090019616174' do
    sheet5.ca35.should be_within(0.035440900196161744).of(0.3544090019616174)
  end

  it 'cell cb35 should equal 0.4087945018474925' do
    sheet5.cb35.should be_within(0.040879450184749255).of(0.4087945018474925)
  end

  it 'cell cc35 should equal 0.3491410930627102' do
    sheet5.cc35.should be_within(0.03491410930627102).of(0.3491410930627102)
  end

  it 'cell cd35 should equal 0.0' do
    sheet5.cd35.should be_within(1.0e-08).of(0.0)
  end

  it 'cell bk36 should equal "Agriculture and waste"' do
    sheet5.bk36.should == "Agriculture and waste"
  end

  it 'cell bo36 should equal 65.90661263983685' do
    sheet5.bo36.should be_within(6.5906612639836855).of(65.90661263983685)
  end

  it 'cell bp36 should equal 42.670605810430715' do
    sheet5.bp36.should be_within(4.267060581043071).of(42.670605810430715)
  end

  it 'cell bq36 should equal 0.05507203718216681' do
    sheet5.bq36.should be_within(0.005507203718216681).of(0.05507203718216681)
  end

  it 'cell ca36 should equal 0.0' do
    sheet5.ca36.should be_within(1.0e-08).of(0.0)
  end

  it 'cell cb36 should equal 0.006233800666110939' do
    sheet5.cb36.should be_within(0.000623380066611094).of(0.006233800666110939)
  end

  it 'cell cc36 should equal 0.06022950697085157' do
    sheet5.cc36.should be_within(0.006022950697085157).of(0.06022950697085157)
  end

  it 'cell cd36 should equal 0.747988561246979' do
    sheet5.cd36.should be_within(0.0747988561246979).of(0.747988561246979)
  end

  it 'cell bk37 should equal "Heating"' do
    sheet5.bk37.should == "Heating"
  end

  it 'cell bo37 should equal 84.42746088138698' do
    sheet5.bo37.should be_within(8.442746088138698).of(84.42746088138698)
  end

  it 'cell bp37 should equal 0.09229764491462902' do
    sheet5.bp37.should be_within(0.009229764491462903).of(0.09229764491462902)
  end

  it 'cell bq37 should equal 0.00011912226780062139' do
    sheet5.bq37.should be_within(1.191222678006214e-05).of(0.00011912226780062139)
  end

  it 'cell e38 should equal "Domestic lighting, appliances, and cooking"' do
    sheet5.e38.should == "Domestic lighting, appliances, and cooking"
  end

  it 'cell bk38 should equal "Lighting and appliances"' do
    sheet5.bk38.should == "Lighting and appliances"
  end

  it 'cell bo38 should equal 3.141184245661737' do
    sheet5.bo38.should be_within(0.3141184245661737).of(3.141184245661737)
  end

  it 'cell bp38 should equal 0.0' do
    sheet5.bp38.should be_within(1.0e-08).of(0.0)
  end

  it 'cell bq38 should equal 0.0' do
    sheet5.bq38.should be_within(1.0e-08).of(0.0)
  end

  it 'cell ca38 should equal 893.2928046957027' do
    sheet5.ca38.should be_within(89.32928046957028).of(893.2928046957027)
  end

  it 'cell cb38 should equal 825.6067296884866' do
    sheet5.cb38.should be_within(82.56067296884866).of(825.6067296884866)
  end

  it 'cell cc38 should equal 666.164733428575' do
    sheet5.cc38.should be_within(66.6164733428575).of(666.164733428575)
  end

  it 'cell cd38 should equal 647.586750616167' do
    sheet5.cd38.should be_within(64.7586750616167).of(647.586750616167)
  end

  it 'cell bk39 should equal "Industry"' do
    sheet5.bk39.should == "Industry"
  end

  it 'cell bo39 should equal 93.41484291354766' do
    sheet5.bo39.should be_within(9.341484291354766).of(93.41484291354766)
  end

  it 'cell bp39 should equal 52.116904730965224' do
    sheet5.bp39.should be_within(5.211690473096523).of(52.116904730965224)
  end

  it 'cell bq39 should equal 0.06726373016390486' do
    sheet5.bq39.should be_within(0.006726373016390486).of(0.06726373016390486)
  end

  it 'cell ca39 should equal 0.0009660471857197657' do
    sheet5.ca39.should be_within(9.660471857197658e-05).of(0.0009660471857197657)
  end

  it 'cell cb39 should equal 0.012989019027497654' do
    sheet5.cb39.should be_within(0.0012989019027497654).of(0.012989019027497654)
  end

  it 'cell cc39 should equal 0.028542338282817943' do
    sheet5.cc39.should be_within(0.0028542338282817946).of(0.028542338282817943)
  end

  it 'cell cd39 should equal 0.05496793231938379' do
    sheet5.cd39.should be_within(0.005496793231938379).of(0.05496793231938379)
  end

  it 'cell ca40 should equal 0.8066937854641579' do
    sheet5.ca40.should be_within(0.0806693785464158).of(0.8066937854641579)
  end

  it 'cell cb40 should equal 0.8260426123430087' do
    sheet5.cb40.should be_within(0.08260426123430087).of(0.8260426123430087)
  end

  it 'cell cc40 should equal 0.7953842090486902' do
    sheet5.cc40.should be_within(0.07953842090486903).of(0.7953842090486902)
  end

  it 'cell cd40 should equal 0.8074294438796155' do
    sheet5.cd40.should be_within(0.08074294438796155).of(0.8074294438796155)
  end

  it 'cell e41 should equal "Industrial processes"' do
    sheet5.e41.should == "Industrial processes"
  end

  it 'cell bk41 should equal "Transport"' do
    sheet5.bk41.should == "Transport"
  end

  it 'cell bo41 should equal 183.61905836674865' do
    sheet5.bo41.should be_within(18.361905836674865).of(183.61905836674865)
  end

  it 'cell bp41 should equal 133.23482195276705' do
    sheet5.bp41.should be_within(13.323482195276705).of(133.23482195276705)
  end

  it 'cell bq41 should equal 0.17195708683255972' do
    sheet5.bq41.should be_within(0.017195708683255973).of(0.17195708683255972)
  end

  it 'cell ca41 should equal 0.09137321430337475' do
    sheet5.ca41.should be_within(0.009137321430337476).of(0.09137321430337475)
  end

  it 'cell cb41 should equal 0.09417937153259387' do
    sheet5.cb41.should be_within(0.009417937153259387).of(0.09417937153259387)
  end

  it 'cell cc41 should equal 0.11790689476672107' do
    sheet5.cc41.should be_within(0.011790689476672108).of(0.11790689476672107)
  end

  it 'cell cd41 should equal 0.12423974417978967' do
    sheet5.cd41.should be_within(0.012423974417978968).of(0.12423974417978967)
  end

  it 'cell bk42 should equal "Fossil fuel production"' do
    sheet5.bk42.should == "Fossil fuel production"
  end

  it 'cell bo42 should equal 34.39920743834843' do
    sheet5.bo42.should be_within(3.439920743834843).of(34.39920743834843)
  end

  it 'cell bp42 should equal 13.911074045661776' do
    sheet5.bp42.should be_within(1.3911074045661778).of(13.911074045661776)
  end

  it 'cell bq42 should equal 0.017954073361182214' do
    sheet5.bq42.should be_within(0.0017954073361182215).of(0.017954073361182214)
  end

  it 'cell ca42 should equal 0.06298795293818339' do
    sheet5.ca42.should be_within(0.00629879529381834).of(0.06298795293818339)
  end

  it 'cell cb42 should equal 0.05769933375732998' do
    sheet5.cb42.should be_within(0.005769933375732998).of(0.05769933375732998)
  end

  it 'cell cc42 should equal 0.06612018819075834' do
    sheet5.cc42.should be_within(0.006612018819075834).of(0.06612018819075834)
  end

  it 'cell cd42 should equal 0.06271049802359432' do
    sheet5.cd42.should be_within(0.006271049802359433).of(0.06271049802359432)
  end

  it 'cell bk43 should equal "Transfers"' do
    sheet5.bk43.should == "Transfers"
  end

  it 'cell bo43 should equal 4.370651364088464' do
    sheet5.bo43.should be_within(0.4370651364088464).of(4.370651364088464)
  end

  it 'cell bp43 should equal 0.5509656293136967' do
    sheet5.bp43.should be_within(0.05509656293136968).of(0.5509656293136967)
  end

  it 'cell bq43 should equal 0.0007110937153894972' do
    sheet5.bq43.should be_within(7.110937153894973e-05).of(0.0007110937153894972)
  end

  it 'cell e44 should equal "Commercial heating and cooling"' do
    sheet5.e44.should == "Commercial heating and cooling"
  end

  it 'cell bo44 should equal 659.8623349077645' do
    sheet5.bo44.should be_within(65.98623349077646).of(659.8623349077645)
  end

  it 'cell bp44 should equal 138.31641330798337' do
    sheet5.bp44.should be_within(13.831641330798337).of(138.31641330798337)
  end

  it 'cell bq44 should equal 0.17851554980124437' do
    sheet5.bq44.should be_within(0.01785155498012444).of(0.17851554980124437)
  end

  it 'cell ca44 should equal 496.28220167438485' do
    sheet5.ca44.should be_within(49.628220167438485).of(496.28220167438485)
  end

  it 'cell cb44 should equal 353.76972207519685' do
    sheet5.cb44.should be_within(35.376972207519685).of(353.76972207519685)
  end

  it 'cell cc44 should equal 197.17405988023407' do
    sheet5.cc44.should be_within(19.71740598802341).of(197.17405988023407)
  end

  it 'cell cd44 should equal 447.47958585440966' do
    sheet5.cd44.should be_within(44.74795858544097).of(447.47958585440966)
  end

  it 'cell bo45 should equal 0.9741822320923665' do
    sheet5.bo45.should be_within(0.09741822320923665).of(0.9741822320923665)
  end

  it 'cell ca45 should equal 0.033905978732375996' do
    sheet5.ca45.should be_within(0.0033905978732376).of(0.033905978732375996)
  end

  it 'cell cb45 should equal 0.27855953013130164' do
    sheet5.cb45.should be_within(0.027855953013130166).of(0.27855953013130164)
  end

  it 'cell cc45 should equal 0.9443674830192103' do
    sheet5.cc45.should be_within(0.09443674830192103).of(0.9443674830192103)
  end

  it 'cell cd45 should equal 0.7046616861676455' do
    sheet5.cd45.should be_within(0.07046616861676455).of(0.7046616861676455)
  end

  it 'cell ca46 should equal 0.0' do
    sheet5.ca46.should be_within(1.0e-08).of(0.0)
  end

  it 'cell cb46 should equal 0.058505572151820756' do
    sheet5.cb46.should be_within(0.005850557215182076).of(0.058505572151820756)
  end

  it 'cell cc46 should equal 0.5507566838369091' do
    sheet5.cc46.should be_within(0.055075668383690914).of(0.5507566838369091)
  end

  it 'cell cd46 should equal 0.8941642651090271' do
    sheet5.cd46.should be_within(0.08941642651090272).of(0.8941642651090271)
  end

  it 'cell ca47 should equal 0.8595772059722248' do
    sheet5.ca47.should be_within(0.08595772059722248).of(0.8595772059722248)
  end

  it 'cell cb47 should equal 0.774065887814426' do
    sheet5.cb47.should be_within(0.0774065887814426).of(0.774065887814426)
  end

  it 'cell cc47 should equal 0.16805192336216487' do
    sheet5.cc47.should be_within(0.01680519233621649).of(0.16805192336216487)
  end

  it 'cell cd47 should equal 0.0' do
    sheet5.cd47.should be_within(1.0e-08).of(0.0)
  end

  it 'cell e48 should equal "Commercial lighting, appliances, and catering"' do
    sheet5.e48.should == "Commercial lighting, appliances, and catering"
  end

  it 'cell ca48 should equal 0.10992388791300337' do
    sheet5.ca48.should be_within(0.010992388791300337).of(0.10992388791300337)
  end

  it 'cell cb48 should equal 0.14182425786155722' do
    sheet5.cb48.should be_within(0.014182425786155722).of(0.14182425786155722)
  end

  it 'cell cc48 should equal 0.2490529772262767' do
    sheet5.cc48.should be_within(0.024905297722627673).of(0.2490529772262767)
  end

  it 'cell cd48 should equal 0.10381258493994135' do
    sheet5.cd48.should be_within(0.010381258493994135).of(0.10381258493994135)
  end

  it 'cell ca49 should equal 0.028727209950603034' do
    sheet5.ca49.should be_within(0.0028727209950603037).of(0.028727209950603034)
  end

  it 'cell cb49 should equal 0.02306797165654345' do
    sheet5.cb49.should be_within(0.002306797165654345).of(0.02306797165654345)
  end

  it 'cell cc49 should equal 0.027687241142682412' do
    sheet5.cc49.should be_within(0.0027687241142682413).of(0.027687241142682412)
  end

  it 'cell cd49 should equal 0.0' do
    sheet5.cd49.should be_within(1.0e-08).of(0.0)
  end

  it 'cell e52 should equal "Geosequestration"' do
    sheet5.e52.should == "Geosequestration"
  end

  it 'cell e53 should equal "Storage, demand shifting, interconnection"' do
    sheet5.e53.should == "Storage, demand shifting, interconnection"
  end

end