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

  it 'cell e4 should equal "Nuclear power"' do
    sheet3.e4.should == "Nuclear power"
  end

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

  it 'cell bs7 should equal "TWh / year"' do
    sheet3.bs7.should == "TWh / year"
  end

  it 'cell e8 should equal "Offshore wind"' do
    sheet3.e8.should == "Offshore wind"
  end

  it 'cell bp8 should equal "Coal oversupply (imports)"' do
    sheet3.bp8.should == "Coal oversupply (imports)"
  end

  it 'cell bt8 should equal -322.6813725850956' do
    sheet3.bt8.should be_within(32.26813725850956).of(-322.6813725850956)
  end

  it 'cell bu8 should equal -135.38600824731412' do
    sheet3.bu8.should be_within(13.538600824731413).of(-135.38600824731412)
  end

  it 'cell bv8 should equal 127.74029406117114' do
    sheet3.bv8.should be_within(12.774029406117116).of(127.74029406117114)
  end

  it 'cell bw8 should equal 182.1154229434806' do
    sheet3.bw8.should be_within(18.21154229434806).of(182.1154229434806)
  end

  it 'cell e9 should equal "Wave and Tidal"' do
    sheet3.e9.should == "Wave and Tidal"
  end

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

  it 'cell bt9 should equal 99.62648876757476' do
    sheet3.bt9.should be_within(9.962648876757477).of(99.62648876757476)
  end

  it 'cell bu9 should equal -335.266168824534' do
    sheet3.bu9.should be_within(33.5266168824534).of(-335.266168824534)
  end

  it 'cell bv9 should equal -479.46110977101455' do
    sheet3.bv9.should be_within(47.946110977101455).of(-479.46110977101455)
  end

  it 'cell bw9 should equal -701.4078244564344' do
    sheet3.bw9.should be_within(70.14078244564344).of(-701.4078244564344)
  end

  it 'cell e10 should equal "Biomass/Coal power"' do
    sheet3.e10.should == "Biomass/Coal power"
  end

  it 'cell bp10 should equal "Gas oversupply (imports)"' do
    sheet3.bp10.should == "Gas oversupply (imports)"
  end

  it 'cell bt10 should equal -133.59090031729465' do
    sheet3.bt10.should be_within(13.359090031729465).of(-133.59090031729465)
  end

  it 'cell bu10 should equal -742.3781928670971' do
    sheet3.bu10.should be_within(74.23781928670972).of(-742.3781928670971)
  end

  it 'cell bv10 should equal -1167.957717246065' do
    sheet3.bv10.should be_within(116.7957717246065).of(-1167.957717246065)
  end

  it 'cell bw10 should equal -1667.090671438097' do
    sheet3.bw10.should be_within(166.7090671438097).of(-1667.090671438097)
  end

  it 'cell e11 should equal "Distributed solar PV"' do
    sheet3.e11.should == "Distributed solar PV"
  end

  it 'cell bp11 should equal "Biomass oversupply (imports)"' do
    sheet3.bp11.should == "Biomass oversupply (imports)"
  end

  it 'cell bt11 should equal -4.00072' do
    sheet3.bt11.should be_within(0.40007200000000004).of(-4.00072)
  end

  it 'cell bu11 should equal -2.7912' do
    sheet3.bu11.should be_within(0.27912).of(-2.7912)
  end

  it 'cell bv11 should equal -1.8608' do
    sheet3.bv11.should be_within(0.18608000000000002).of(-1.8608)
  end

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

  it 'cell e12 should equal "Electricity imports / exports"' do
    sheet3.e12.should == "Electricity imports / exports"
  end

  it 'cell bp12 should equal "Electricity oversupply (imports)"' do
    sheet3.bp12.should == "Electricity oversupply (imports)"
  end

  it 'cell bt12 should equal -5.21452425' do
    sheet3.bt12.should be_within(0.521452425).of(-5.21452425)
  end

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

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

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

  it 'cell e13 should equal "Onshore wind"' do
    sheet3.e13.should == "Onshore wind"
  end

  it 'cell e14 should equal "Geothermal"' do
    sheet3.e14.should == "Geothermal"
  end

  it 'cell e15 should equal "Hydroelectric"' do
    sheet3.e15.should == "Hydroelectric"
  end

  it 'cell e16 should equal "Micro wind"' do
    sheet3.e16.should == "Micro wind"
  end

  it 'cell e17 should equal "Biomass to fuel conversion"' do
    sheet3.e17.should == "Biomass to fuel conversion"
  end

  it 'cell bs17 should equal "TWh / year"' do
    sheet3.bs17.should == "TWh / year"
  end

  it 'cell e18 should equal "Agriculture and land use"' do
    sheet3.e18.should == "Agriculture and land use"
  end

  it 'cell bt19 should equal 983.3246092790712' do
    sheet3.bt19.should be_within(98.33246092790712).of(983.3246092790712)
  end

  it 'cell bu19 should equal 1177.360541712306' do
    sheet3.bu19.should be_within(117.7360541712306).of(1177.360541712306)
  end

  it 'cell bv19 should equal 1464.240224020463' do
    sheet3.bv19.should be_within(146.42402240204632).of(1464.240224020463)
  end

  it 'cell bw19 should equal 1814.5418124379926' do
    sheet3.bw19.should be_within(181.45418124379927).of(1814.5418124379926)
  end

  it 'cell bt20 should equal 0.022377129707350875' do
    sheet3.bt20.should be_within(0.0022377129707350876).of(0.022377129707350875)
  end

  it 'cell bu20 should equal 0.03714420734517083' do
    sheet3.bu20.should be_within(0.003714420734517083).of(0.03714420734517083)
  end

  it 'cell bv20 should equal 0.039181692579646675' do
    sheet3.bv20.should be_within(0.003918169257964668).of(0.039181692579646675)
  end

  it 'cell bw20 should equal 0.036384013029576515' do
    sheet3.bw20.should be_within(0.0036384013029576515).of(0.036384013029576515)
  end

  it 'cell e21 should equal "Waste arising"' do
    sheet3.e21.should == "Waste arising"
  end

  it 'cell bt21 should equal 0.32998035828256206' do
    sheet3.bt21.should be_within(0.03299803582825621).of(0.32998035828256206)
  end

  it 'cell bu21 should equal 0.3335837379106431' do
    sheet3.bu21.should be_within(0.033358373791064315).of(0.3335837379106431)
  end

  it 'cell bv21 should equal 0.3033166821638857' do
    sheet3.bv21.should be_within(0.03033166821638857).of(0.3033166821638857)
  end

  it 'cell bw21 should equal 0.2870579648588717' do
    sheet3.bw21.should be_within(0.02870579648588717).of(0.2870579648588717)
  end

  it 'cell e22 should equal "Marine algae"' do
    sheet3.e22.should == "Marine algae"
  end

  it 'cell bt22 should equal 0.07958954661332825' do
    sheet3.bt22.should be_within(0.007958954661332824).of(0.07958954661332825)
  end

  it 'cell bu22 should equal 0.07813578849449382' do
    sheet3.bu22.should be_within(0.007813578849449382).of(0.07813578849449382)
  end

  it 'cell bv22 should equal 0.07398120462781536' do
    sheet3.bv22.should be_within(0.007398120462781536).of(0.07398120462781536)
  end

  it 'cell bw22 should equal 0.07769418888230843' do
    sheet3.bw22.should be_within(0.007769418888230843).of(0.07769418888230843)
  end

  it 'cell e23 should equal "Bioenergy imports"' do
    sheet3.e23.should == "Bioenergy imports"
  end

  it 'cell bt23 should equal 0.15259759848678905' do
    sheet3.bt23.should be_within(0.015259759848678906).of(0.15259759848678905)
  end

  it 'cell bu23 should equal 0.1313338490542644' do
    sheet3.bu23.should be_within(0.01313338490542644).of(0.1313338490542644)
  end

  it 'cell bv23 should equal 0.10862623698314357' do
    sheet3.bv23.should be_within(0.010862623698314358).of(0.10862623698314357)
  end

  it 'cell bw23 should equal 0.0938750109209599' do
    sheet3.bw23.should be_within(0.00938750109209599).of(0.0938750109209599)
  end

  it 'cell bt24 should equal 0.3505704365604274' do
    sheet3.bt24.should be_within(0.035057043656042744).of(0.3505704365604274)
  end

  it 'cell bu24 should equal 0.4044770936286342' do
    sheet3.bu24.should be_within(0.040447709362863425).of(0.4044770936286342)
  end

  it 'cell bv24 should equal 0.4808500434879673' do
    sheet3.bv24.should be_within(0.04808500434879673).of(0.4808500434879673)
  end

  it 'cell bw24 should equal 0.5220737641758892' do
    sheet3.bw24.should be_within(0.05220737641758893).of(0.5220737641758892)
  end

  it 'cell e25 should equal "Domestic passenger transport"' do
    sheet3.e25.should == "Domestic passenger transport"
  end

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

  it 'cell bu25 should equal 0.004826934631779122' do
    sheet3.bu25.should be_within(0.0004826934631779122).of(0.004826934631779122)
  end

  it 'cell bv25 should equal 0.0037539694816342375' do
    sheet3.bv25.should be_within(0.00037539694816342376).of(0.0037539694816342375)
  end

  it 'cell bw25 should equal 0.002842840992031493' do
    sheet3.bw25.should be_within(0.0002842840992031493).of(0.002842840992031493)
  end

  it 'cell bt27 should equal 880.7550961239336' do
    sheet3.bt27.should be_within(88.07550961239338).of(880.7550961239336)
  end

  it 'cell bu27 should equal 865.1677194219126' do
    sheet3.bu27.should be_within(86.51677194219127).of(865.1677194219126)
  end

  it 'cell bv27 should equal 816.6942193549536' do
    sheet3.bv27.should be_within(81.66942193549536).of(816.6942193549536)
  end

  it 'cell bw27 should equal 841.7779403654838' do
    sheet3.bw27.should be_within(84.17779403654839).of(841.7779403654838)
  end

  it 'cell e28 should equal "International aviation"' do
    sheet3.e28.should == "International aviation"
  end

  it 'cell bt28 should equal 0.0013252097289687256' do
    sheet3.bt28.should be_within(0.00013252097289687256).of(0.0013252097289687256)
  end

  it 'cell bu28 should equal 0.0023507535870021666' do
    sheet3.bu28.should be_within(0.00023507535870021667).of(0.0023507535870021666)
  end

  it 'cell bv28 should equal 0.005075602447344801' do
    sheet3.bv28.should be_within(0.0005075602447344802).of(0.005075602447344801)
  end

  it 'cell bw28 should equal 0.00920058081662453' do
    sheet3.bw28.should be_within(0.000920058081662453).of(0.00920058081662453)
  end

  it 'cell e29 should equal "Domestic freight"' do
    sheet3.e29.should == "Domestic freight"
  end

  it 'cell bt29 should equal 0.8039420364324144' do
    sheet3.bt29.should be_within(0.08039420364324144).of(0.8039420364324144)
  end

  it 'cell bu29 should equal 0.8247692172687324' do
    sheet3.bu29.should be_within(0.08247692172687325).of(0.8247692172687324)
  end

  it 'cell bv29 should equal 0.824672499849984' do
    sheet3.bv29.should be_within(0.08246724998499841).of(0.824672499849984)
  end

  it 'cell bw29 should equal 0.8336396890656754' do
    sheet3.bw29.should be_within(0.08336396890656755).of(0.8336396890656754)
  end

  it 'cell e30 should equal "International shipping (maritime bunkers)"' do
    sheet3.e30.should == "International shipping (maritime bunkers)"
  end

  it 'cell bt30 should equal 0.09267392858506686' do
    sheet3.bt30.should be_within(0.009267392858506687).of(0.09267392858506686)
  end

  it 'cell bu30 should equal 0.0972196321718507' do
    sheet3.bu30.should be_within(0.00972196321718507).of(0.0972196321718507)
  end

  it 'cell bv30 should equal 0.10593896311159946' do
    sheet3.bv30.should be_within(0.010593896311159947).of(0.10593896311159946)
  end

  it 'cell bw30 should equal 0.11007471547492079' do
    sheet3.bw30.should be_within(0.011007471547492079).of(0.11007471547492079)
  end

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

  it 'cell bt31 should equal 0.06388459787495036' do
    sheet3.bt31.should be_within(0.006388459787495037).of(0.06388459787495036)
  end

  it 'cell bu31 should equal 0.05559839700123165' do
    sheet3.bu31.should be_within(0.005559839700123165).of(0.05559839700123165)
  end

  it 'cell bv31 should equal 0.05464597357792133' do
    sheet3.bv31.should be_within(0.0054645973577921335).of(0.05464597357792133)
  end

  it 'cell bw31 should equal 0.04877158043417317' do
    sheet3.bw31.should be_within(0.004877158043417318).of(0.04877158043417317)
  end

  it 'cell be32 should equal "Hydrocarbon fuel power generation"' do
    sheet3.be32.should == "Hydrocarbon fuel power generation"
  end

  it 'cell bi32 should equal 196.8319572405069' do
    sheet3.bi32.should be_within(19.68319572405069).of(196.8319572405069)
  end

  it 'cell bj32 should equal 180.19868739760832' do
    sheet3.bj32.should be_within(18.019868739760835).of(180.19868739760832)
  end

  it 'cell bk32 should equal 0.2347909399313342' do
    sheet3.bk32.should be_within(0.023479093993133422).of(0.2347909399313342)
  end

  it 'cell be33 should equal "Bioenergy"' do
    sheet3.be33.should == "Bioenergy"
  end

  it 'cell bi33 should equal -9.295304656359205' do
    sheet3.bi33.should be_within(0.9295304656359206).of(-9.295304656359205)
  end

  it 'cell bj33 should equal -31.848018230568222' do
    sheet3.bj33.should be_within(3.1848018230568225).of(-31.848018230568222)
  end

  it 'cell bk33 should equal -0.04149656272915019' do
    sheet3.bk33.should be_within(0.004149656272915019).of(-0.04149656272915019)
  end

  it 'cell bt33 should equal 489.16767952103856' do
    sheet3.bt33.should be_within(48.91676795210386).of(489.16767952103856)
  end

  it 'cell bu33 should equal 360.50948091227883' do
    sheet3.bu33.should be_within(36.05094809122789).of(360.50948091227883)
  end

  it 'cell bv33 should equal 117.56086729355422' do
    sheet3.bv33.should be_within(11.756086729355424).of(117.56086729355422)
  end

  it 'cell bw33 should equal 98.0486014689702' do
    sheet3.bw33.should be_within(9.80486014689702).of(98.0486014689702)
  end

  it 'cell be34 should equal "Geosequestration"' do
    sheet3.be34.should == "Geosequestration"
  end

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

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

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

  it 'cell bt34 should equal 0.03288633826130892' do
    sheet3.bt34.should be_within(0.003288633826130892).of(0.03288633826130892)
  end

  it 'cell bu34 should equal 0.09310163111090683' do
    sheet3.bu34.should be_within(0.009310163111090683).of(0.09310163111090683)
  end

  it 'cell bv34 should equal 0.37099498349440624' do
    sheet3.bv34.should be_within(0.037099498349440624).of(0.37099498349440624)
  end

  it 'cell bw34 should equal 0.5882342873171872' do
    sheet3.bw34.should be_within(0.058823428731718724).of(0.5882342873171872)
  end

  it 'cell be35 should equal "Agriculture and waste"' do
    sheet3.be35.should == "Agriculture and waste"
  end

  it 'cell bi35 should equal 65.90661263983685' do
    sheet3.bi35.should be_within(6.5906612639836855).of(65.90661263983685)
  end

  it 'cell bj35 should equal 77.80525941161521' do
    sheet3.bj35.should be_within(7.780525941161521).of(77.80525941161521)
  end

  it 'cell bk35 should equal 0.10137682051227241' do
    sheet3.bk35.should be_within(0.010137682051227241).of(0.10137682051227241)
  end

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

  it 'cell bu35 should equal 0.057411804947887723' do
    sheet3.bu35.should be_within(0.005741180494788773).of(0.057411804947887723)
  end

  it 'cell bv35 should equal 0.16856591632371767' do
    sheet3.bv35.should be_within(0.016856591632371767).of(0.16856591632371767)
  end

  it 'cell bw35 should equal 0.18998486180239088' do
    sheet3.bw35.should be_within(0.01899848618023909).of(0.18998486180239088)
  end

  it 'cell e36 should equal "Distributed solar thermal"' do
    sheet3.e36.should == "Distributed solar thermal"
  end

  it 'cell be36 should equal "Heating"' do
    sheet3.be36.should == "Heating"
  end

  it 'cell bi36 should equal 84.42746088138698' do
    sheet3.bi36.should be_within(8.442746088138698).of(84.42746088138698)
  end

  it 'cell bj36 should equal 123.69172054356795' do
    sheet3.bj36.should be_within(12.369172054356795).of(123.69172054356795)
  end

  it 'cell bk36 should equal 0.1611648550139977' do
    sheet3.bk36.should be_within(0.01611648550139977).of(0.1611648550139977)
  end

  it 'cell bt36 should equal 0.8575348775012931' do
    sheet3.bt36.should be_within(0.08575348775012931).of(0.8575348775012931)
  end

  it 'cell bu36 should equal 0.7595946528425213' do
    sheet3.bu36.should be_within(0.07595946528425213).of(0.7595946528425213)
  end

  it 'cell bv36 should equal 0.2818580771206746' do
    sheet3.bv36.should be_within(0.028185807712067464).of(0.2818580771206746)
  end

  it 'cell bw36 should equal 0.144835518174058' do
    sheet3.bw36.should be_within(0.0144835518174058).of(0.144835518174058)
  end

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

  it 'cell be37 should equal "Lighting and appliances"' do
    sheet3.be37.should == "Lighting and appliances"
  end

  it 'cell bi37 should equal 3.141184245661737' do
    sheet3.bi37.should be_within(0.3141184245661737).of(3.141184245661737)
  end

  it 'cell bj37 should equal 3.157195944639504' do
    sheet3.bj37.should be_within(0.3157195944639504).of(3.157195944639504)
  end

  it 'cell bk37 should equal 0.004113687031213883' do
    sheet3.bk37.should be_within(0.00041136870312138827).of(0.004113687031213883)
  end

  it 'cell bt37 should equal 0.11152263608971193' do
    sheet3.bt37.should be_within(0.011152263608971194).of(0.11152263608971193)
  end

  it 'cell bu37 should equal 0.15593572805481856' do
    sheet3.bu37.should be_within(0.015593572805481857).of(0.15593572805481856)
  end

  it 'cell bv37 should equal 0.4918814679798358' do
    sheet3.bv37.should be_within(0.049188146797983584).of(0.4918814679798358)
  end

  it 'cell bw37 should equal 0.631614004538287' do
    sheet3.bw37.should be_within(0.0631614004538287).of(0.631614004538287)
  end

  it 'cell be38 should equal "Industry"' do
    sheet3.be38.should == "Industry"
  end

  it 'cell bi38 should equal 93.41484291354766' do
    sheet3.bi38.should be_within(9.341484291354766).of(93.41484291354766)
  end

  it 'cell bj38 should equal 96.97223490460509' do
    sheet3.bj38.should be_within(9.697223490460509).of(96.97223490460509)
  end

  it 'cell bk38 should equal 0.12635054399844955' do
    sheet3.bk38.should be_within(0.012635054399844955).of(0.12635054399844955)
  end

  it 'cell bt38 should equal 0.02914502245162009' do
    sheet3.bt38.should be_within(0.0029145022451620094).of(0.02914502245162009)
  end

  it 'cell bu38 should equal 0.02454145533879225' do
    sheet3.bu38.should be_within(0.002454145533879225).of(0.02454145533879225)
  end

  it 'cell bv38 should equal 0.04988584168666442' do
    sheet3.bv38.should be_within(0.004988584168666443).of(0.04988584168666442)
  end

  it 'cell bw38 should equal 0.023977456004692945' do
    sheet3.bw38.should be_within(0.0023977456004692947).of(0.023977456004692945)
  end

  it 'cell e40 should equal "Industrial processes"' do
    sheet3.e40.should == "Industrial processes"
  end

  it 'cell be41 should equal "Transport"' do
    sheet3.be41.should == "Transport"
  end

  it 'cell bi41 should equal 180.42433410736052' do
    sheet3.bi41.should be_within(18.042433410736052).of(180.42433410736052)
  end

  it 'cell bj41 should equal 178.80972372942105' do
    sheet3.bj41.should be_within(17.880972372942107).of(178.80972372942105)
  end

  it 'cell bk41 should equal 0.23298118154799713' do
    sheet3.bk41.should be_within(0.023298118154799714).of(0.23298118154799713)
  end

  it 'cell be42 should equal "Fossil fuel production"' do
    sheet3.be42.should == "Fossil fuel production"
  end

  it 'cell bi42 should equal 34.39920743834843' do
    sheet3.bi42.should be_within(3.439920743834843).of(34.39920743834843)
  end

  it 'cell bj42 should equal 15.743695593306029' do
    sheet3.bj42.should be_within(1.574369559330603).of(15.743695593306029)
  end

  it 'cell bk42 should equal 0.020513340800251516' do
    sheet3.bk42.should be_within(0.0020513340800251516).of(0.020513340800251516)
  end

  it 'cell e43 should equal "Commercial heating and cooling"' do
    sheet3.e43.should == "Commercial heating and cooling"
  end

  it 'cell be43 should equal "Transfers"' do
    sheet3.be43.should == "Transfers"
  end

  it 'cell bi43 should equal 4.370651364088464' do
    sheet3.bi43.should be_within(0.4370651364088464).of(4.370651364088464)
  end

  it 'cell bj43 should equal 7.949665972647326' do
    sheet3.bj43.should be_within(0.7949665972647326).of(7.949665972647326)
  end

  it 'cell bk43 should equal 0.010358064050375447' do
    sheet3.bk43.should be_within(0.0010358064050375447).of(0.010358064050375447)
  end

  it 'cell bi44 should equal 653.6209461743783' do
    sheet3.bi44.should be_within(65.36209461743783).of(653.6209461743783)
  end

  it 'cell bj44 should equal 652.4801652668424' do
    sheet3.bj44.should be_within(65.24801652668424).of(652.4801652668424)
  end

  it 'cell bk44 should equal 0.8501528701567419' do
    sheet3.bk44.should be_within(0.08501528701567419).of(0.8501528701567419)
  end

  it 'cell bi45 should equal 0.9649678101046406' do
    sheet3.bi45.should be_within(0.09649678101046406).of(0.9649678101046406)
  end

  it 'cell bo45 should equal "Balancing capacity used"' do
    sheet3.bo45.should == "Balancing capacity used"
  end

  it 'cell bt45 should equal 0.5014941120016841' do
    sheet3.bt45.should be_within(0.050149411200168414).of(0.5014941120016841)
  end

  it 'cell bu45 should equal 0.7804153196065096' do
    sheet3.bu45.should be_within(0.07804153196065096).of(0.7804153196065096)
  end

  it 'cell bv45 should equal 0.8393615363934331' do
    sheet3.bv45.should be_within(0.08393615363934331).of(0.8393615363934331)
  end

  it 'cell bw45 should equal 0.48155131502028103' do
    sheet3.bw45.should be_within(0.0481551315020281).of(0.48155131502028103)
  end

  it 'cell bo46 should equal "Standby capacity required"' do
    sheet3.bo46.should == "Standby capacity required"
  end

  it 'cell br46 should equal "GWcapacity"' do
    sheet3.br46.should == "GWcapacity"
  end

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

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

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

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

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

  it 'cell bo47 should equal "Probable annual emissions"' do
    sheet3.bo47.should == "Probable annual emissions"
  end

  it 'cell br47 should equal "MtCO2e"' do
    sheet3.br47.should == "MtCO2e"
  end

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

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

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

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

  it 'cell e50 should equal "Geosequestration"' do
    sheet3.e50.should == "Geosequestration"
  end

  it 'cell e51 should equal "Storage, demand shifting, backup"' do
    sheet3.e51.should == "Storage, demand shifting, backup"
  end

end