# coding: utf-8
require_relative '../spreadsheet'
# IV.a
describe 'Sheet27' do
  def sheet27; $spreadsheet ||= Spreadsheet.new; $spreadsheet.sheet27; end

  it 'cell e8 should equal 2.0' do
    sheet27.e8.should be_within(0.2).of(2.0)
  end

  it 'cell f20 should equal 0.02' do
    sheet27.f20.should be_within(0.002).of(0.02)
  end

  it 'cell g20 should equal 0.04812208' do
    sheet27.g20.should be_within(0.004812208).of(0.04812208)
  end

  it 'cell h20 should equal 0.207906650909' do
    sheet27.h20.should be_within(0.020790665090900003).of(0.207906650909)
  end

  it 'cell i20 should equal 0.898239965774483' do
    sheet27.i20.should be_within(0.0898239965774483).of(0.898239965774483)
  end

  it 'cell j20 should equal 2.28206289133007' do
    sheet27.j20.should be_within(0.228206289133007).of(2.28206289133007)
  end

  it 'cell k20 should equal 5.79779484148812' do
    sheet27.k20.should be_within(0.579779484148812).of(5.79779484148812)
  end

  it 'cell l20 should equal 10.8246133579908' do
    sheet27.l20.should be_within(1.0824613357990802).of(10.8246133579908)
  end

  it 'cell m20 should equal 20.2097965784382' do
    sheet27.m20.should be_within(2.0209796578438204).of(20.2097965784382)
  end

  it 'cell n20 should equal 37.7321447181613' do
    sheet27.n20.should be_within(3.7732144718161305).of(37.7321447181613)
  end

  it 'cell o20 should equal 70.4467627621362' do
    sheet27.o20.should be_within(7.044676276213621).of(70.4467627621362)
  end

  it 'cell f67 should equal 0.02' do
    sheet27.f67.should be_within(0.002).of(0.02)
  end

  it 'cell g67 should equal 0.04812208' do
    sheet27.g67.should be_within(0.004812208).of(0.04812208)
  end

  it 'cell h67 should equal 0.207906650909' do
    sheet27.h67.should be_within(0.020790665090900003).of(0.207906650909)
  end

  it 'cell i67 should equal 0.898239965774483' do
    sheet27.i67.should be_within(0.0898239965774483).of(0.898239965774483)
  end

  it 'cell j67 should equal 2.28206289133007' do
    sheet27.j67.should be_within(0.228206289133007).of(2.28206289133007)
  end

  it 'cell k67 should equal 5.79779484148812' do
    sheet27.k67.should be_within(0.579779484148812).of(5.79779484148812)
  end

  it 'cell l67 should equal 10.8246133579908' do
    sheet27.l67.should be_within(1.0824613357990802).of(10.8246133579908)
  end

  it 'cell m67 should equal 20.2097965784382' do
    sheet27.m67.should be_within(2.0209796578438204).of(20.2097965784382)
  end

  it 'cell n67 should equal 37.7321447181613' do
    sheet27.n67.should be_within(3.7732144718161305).of(37.7321447181613)
  end

  it 'cell o67 should equal 70.4467627621362' do
    sheet27.o67.should be_within(7.044676276213621).of(70.4467627621362)
  end

  it 'cell f76 should equal 0.02' do
    sheet27.f76.should be_within(0.002).of(0.02)
  end

  it 'cell g76 should equal 0.04812208' do
    sheet27.g76.should be_within(0.004812208).of(0.04812208)
  end

  it 'cell h76 should equal 0.207906650909' do
    sheet27.h76.should be_within(0.020790665090900003).of(0.207906650909)
  end

  it 'cell i76 should equal 0.898239965774483' do
    sheet27.i76.should be_within(0.0898239965774483).of(0.898239965774483)
  end

  it 'cell j76 should equal 2.28206289133007' do
    sheet27.j76.should be_within(0.228206289133007).of(2.28206289133007)
  end

  it 'cell k76 should equal 5.79779484148812' do
    sheet27.k76.should be_within(0.579779484148812).of(5.79779484148812)
  end

  it 'cell l76 should equal 10.8246133579908' do
    sheet27.l76.should be_within(1.0824613357990802).of(10.8246133579908)
  end

  it 'cell m76 should equal 20.2097965784382' do
    sheet27.m76.should be_within(2.0209796578438204).of(20.2097965784382)
  end

  it 'cell n76 should equal 37.7321447181613' do
    sheet27.n76.should be_within(3.7732144718161305).of(37.7321447181613)
  end

  it 'cell o76 should equal 70.4467627621362' do
    sheet27.o76.should be_within(7.044676276213621).of(70.4467627621362)
  end

  it 'cell f78 should equal 0.00194' do
    sheet27.f78.should be_within(0.00019400000000000003).of(0.00194)
  end

  it 'cell g78 should equal 0.00466784176' do
    sheet27.g78.should be_within(0.00046678417600000004).of(0.00466784176)
  end

  it 'cell h78 should equal 0.020166945138173003' do
    sheet27.h78.should be_within(0.0020166945138173).of(0.020166945138173003)
  end

  it 'cell i78 should equal 0.08712927668012485' do
    sheet27.i78.should be_within(0.008712927668012486).of(0.08712927668012485)
  end

  it 'cell j78 should equal 0.2213601004590168' do
    sheet27.j78.should be_within(0.022136010045901683).of(0.2213601004590168)
  end

  it 'cell k78 should equal 0.5623860996243476' do
    sheet27.k78.should be_within(0.056238609962434766).of(0.5623860996243476)
  end

  it 'cell l78 should equal 1.0499874957251076' do
    sheet27.l78.should be_within(0.10499874957251076).of(1.0499874957251076)
  end

  it 'cell m78 should equal 1.9603502681085057' do
    sheet27.m78.should be_within(0.19603502681085058).of(1.9603502681085057)
  end

  it 'cell n78 should equal 3.6600180376616462' do
    sheet27.n78.should be_within(0.36600180376616465).of(3.6600180376616462)
  end

  it 'cell o78 should equal 6.833335987927212' do
    sheet27.o78.should be_within(0.6833335987927213).of(6.833335987927212)
  end

  it 'cell f79 should equal 0.01700604' do
    sheet27.f79.should be_within(0.001700604).of(0.01700604)
  end

  it 'cell g79 should equal 0.04091830086816001' do
    sheet27.g79.should be_within(0.004091830086816001).of(0.04091830086816001)
  end

  it 'cell h79 should equal 0.17678344108122454' do
    sheet27.h79.should be_within(0.017678344108122454).of(0.17678344108122454)
  end

  it 'cell i79 should equal 0.7637752393779744' do
    sheet27.i79.should be_within(0.07637752393779745).of(0.7637752393779744)
  end

  it 'cell j79 should equal 1.9404426406237414' do
    sheet27.j79.should be_within(0.19404426406237416).of(1.9404426406237414)
  end

  it 'cell k79 should equal 4.929876549307031' do
    sheet27.k79.should be_within(0.4929876549307031).of(4.929876549307031)
  end

  it 'cell l79 should equal 9.204190387526294' do
    sheet27.l79.should be_within(0.9204190387526294).of(9.204190387526294)
  end

  it 'cell m79 should equal 17.184430450239162' do
    sheet27.m79.should be_within(1.7184430450239163).of(17.184430450239162)
  end

  it 'cell n79 should equal 32.08371811814199' do
    sheet27.n79.should be_within(3.208371811814199).of(32.08371811814199)
  end

  it 'cell o79 should equal 59.90102327016994' do
    sheet27.o79.should be_within(5.990102327016994).of(59.90102327016994)
  end

  it 'cell f82 should equal 0.0097' do
    sheet27.f82.should be_within(0.00097).of(0.0097)
  end

  it 'cell g82 should equal 0.0233392088' do
    sheet27.g82.should be_within(0.00233392088).of(0.0233392088)
  end

  it 'cell h82 should equal 0.100834725690865' do
    sheet27.h82.should be_within(0.010083472569086501).of(0.100834725690865)
  end

  it 'cell i82 should equal 0.4356463834006242' do
    sheet27.i82.should be_within(0.043564638340062425).of(0.4356463834006242)
  end

  it 'cell j82 should equal 1.106800502295084' do
    sheet27.j82.should be_within(0.1106800502295084).of(1.106800502295084)
  end

  it 'cell k82 should equal 2.811930498121738' do
    sheet27.k82.should be_within(0.2811930498121738).of(2.811930498121738)
  end

  it 'cell l82 should equal 5.2499374786255375' do
    sheet27.l82.should be_within(0.5249937478625538).of(5.2499374786255375)
  end

  it 'cell m82 should equal 9.801751340542527' do
    sheet27.m82.should be_within(0.9801751340542527).of(9.801751340542527)
  end

  it 'cell n82 should equal 18.30009018830823' do
    sheet27.n82.should be_within(1.830009018830823).of(18.30009018830823)
  end

  it 'cell o82 should equal 34.166679939636055' do
    sheet27.o82.should be_within(3.4166679939636055).of(34.166679939636055)
  end

  it 'cell f84 should equal 88181.81818181818' do
    sheet27.f84.should be_within(8818.181818181818).of(88181.81818181818)
  end

  it 'cell g84 should equal 212174.62545454546' do
    sheet27.g84.should be_within(21217.462545454546).of(212174.62545454546)
  end

  it 'cell h84 should equal 916679.3244624091' do
    sheet27.h84.should be_within(91667.93244624091).of(916679.3244624091)
  end

  it 'cell i84 should equal 3960421.667278402' do
    sheet27.i84.should be_within(396042.1667278402).of(3960421.667278402)
  end

  it 'cell j84 should equal 10061822.748137126' do
    sheet27.j84.should be_within(1006182.2748137126).of(10061822.748137126)
  end

  it 'cell k84 should equal 25563004.528379433' do
    sheet27.k84.should be_within(2556300.4528379436).of(25563004.528379433)
  end

  it 'cell l84 should equal 47726704.351141244' do
    sheet27.l84.should be_within(4772670.435114125).of(47726704.351141244)
  end

  it 'cell m84 should equal 89106830.36856842' do
    sheet27.m84.should be_within(8910683.036856843).of(89106830.36856842)
  end

  it 'cell n84 should equal 166364456.25734752' do
    sheet27.n84.should be_within(16636445.625734754).of(166364456.25734752)
  end

  it 'cell o84 should equal 310606181.26941866' do
    sheet27.o84.should be_within(31060618.126941867).of(310606181.26941866)
  end

  it 'cell f112 should equal 0.01700604' do
    sheet27.f112.should be_within(0.001700604).of(0.01700604)
  end

  it 'cell g112 should equal 0.04091830086816001' do
    sheet27.g112.should be_within(0.004091830086816001).of(0.04091830086816001)
  end

  it 'cell h112 should equal 0.17678344108122454' do
    sheet27.h112.should be_within(0.017678344108122454).of(0.17678344108122454)
  end

  it 'cell i112 should equal 0.7637752393779744' do
    sheet27.i112.should be_within(0.07637752393779745).of(0.7637752393779744)
  end

  it 'cell j112 should equal 1.9404426406237414' do
    sheet27.j112.should be_within(0.19404426406237416).of(1.9404426406237414)
  end

  it 'cell k112 should equal 4.929876549307031' do
    sheet27.k112.should be_within(0.4929876549307031).of(4.929876549307031)
  end

  it 'cell l112 should equal 9.204190387526294' do
    sheet27.l112.should be_within(0.9204190387526294).of(9.204190387526294)
  end

  it 'cell m112 should equal 17.184430450239162' do
    sheet27.m112.should be_within(1.7184430450239163).of(17.184430450239162)
  end

  it 'cell n112 should equal 32.08371811814199' do
    sheet27.n112.should be_within(3.208371811814199).of(32.08371811814199)
  end

  it 'cell o112 should equal 59.90102327016994' do
    sheet27.o112.should be_within(5.990102327016994).of(59.90102327016994)
  end

  it 'cell f113 should equal -0.01700604' do
    sheet27.f113.should be_within(0.001700604).of(-0.01700604)
  end

  it 'cell g113 should equal -0.04091830086816001' do
    sheet27.g113.should be_within(0.004091830086816001).of(-0.04091830086816001)
  end

  it 'cell h113 should equal -0.17678344108122454' do
    sheet27.h113.should be_within(0.017678344108122454).of(-0.17678344108122454)
  end

  it 'cell i113 should equal -0.7637752393779744' do
    sheet27.i113.should be_within(0.07637752393779745).of(-0.7637752393779744)
  end

  it 'cell j113 should equal -1.9404426406237414' do
    sheet27.j113.should be_within(0.19404426406237416).of(-1.9404426406237414)
  end

  it 'cell k113 should equal -4.929876549307031' do
    sheet27.k113.should be_within(0.4929876549307031).of(-4.929876549307031)
  end

  it 'cell l113 should equal -9.204190387526294' do
    sheet27.l113.should be_within(0.9204190387526294).of(-9.204190387526294)
  end

  it 'cell m113 should equal -17.184430450239162' do
    sheet27.m113.should be_within(1.7184430450239163).of(-17.184430450239162)
  end

  it 'cell n113 should equal -32.08371811814199' do
    sheet27.n113.should be_within(3.208371811814199).of(-32.08371811814199)
  end

  it 'cell o113 should equal -59.90102327016994' do
    sheet27.o113.should be_within(5.990102327016994).of(-59.90102327016994)
  end

  it 'cell f122 should equal 0.08818181818181817' do
    sheet27.f122.should be_within(0.008818181818181817).of(0.08818181818181817)
  end

  it 'cell g122 should equal 0.21217462545454543' do
    sheet27.g122.should be_within(0.021217462545454546).of(0.21217462545454543)
  end

  it 'cell h122 should equal 0.9166793244624091' do
    sheet27.h122.should be_within(0.09166793244624091).of(0.9166793244624091)
  end

  it 'cell i122 should equal 3.960421667278402' do
    sheet27.i122.should be_within(0.3960421667278402).of(3.960421667278402)
  end

  it 'cell j122 should equal 10.061822748137125' do
    sheet27.j122.should be_within(1.0061822748137126).of(10.061822748137125)
  end

  it 'cell k122 should equal 25.56300452837943' do
    sheet27.k122.should be_within(2.5563004528379434).of(25.56300452837943)
  end

  it 'cell l122 should equal 47.726704351141244' do
    sheet27.l122.should be_within(4.772670435114125).of(47.726704351141244)
  end

  it 'cell m122 should equal 89.10683036856841' do
    sheet27.m122.should be_within(8.910683036856842).of(89.10683036856841)
  end

  it 'cell n122 should equal 166.3644562573475' do
    sheet27.n122.should be_within(16.63644562573475).of(166.3644562573475)
  end

  it 'cell o122 should equal 310.60618126941864' do
    sheet27.o122.should be_within(31.060618126941865).of(310.60618126941864)
  end

  it 'cell f123 should equal 0.02' do
    sheet27.f123.should be_within(0.002).of(0.02)
  end

  it 'cell g123 should equal 0.04812208' do
    sheet27.g123.should be_within(0.004812208).of(0.04812208)
  end

  it 'cell h123 should equal 0.207906650909' do
    sheet27.h123.should be_within(0.020790665090900003).of(0.207906650909)
  end

  it 'cell i123 should equal 0.898239965774483' do
    sheet27.i123.should be_within(0.0898239965774483).of(0.898239965774483)
  end

  it 'cell j123 should equal 2.28206289133007' do
    sheet27.j123.should be_within(0.228206289133007).of(2.28206289133007)
  end

  it 'cell k123 should equal 5.79779484148812' do
    sheet27.k123.should be_within(0.579779484148812).of(5.79779484148812)
  end

  it 'cell l123 should equal 10.8246133579908' do
    sheet27.l123.should be_within(1.0824613357990802).of(10.8246133579908)
  end

  it 'cell m123 should equal 20.2097965784382' do
    sheet27.m123.should be_within(2.0209796578438204).of(20.2097965784382)
  end

  it 'cell n123 should equal 37.7321447181613' do
    sheet27.n123.should be_within(3.7732144718161305).of(37.7321447181613)
  end

  it 'cell o123 should equal 70.4467627621362' do
    sheet27.o123.should be_within(7.044676276213621).of(70.4467627621362)
  end

end