# coding: utf-8
require_relative '../spreadsheet'
# III.b
describe 'Sheet24' do
  def sheet24; $spreadsheet ||= Spreadsheet.new; $spreadsheet.sheet24; end

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

  it 'cell f20 should equal 1.293' do
    sheet24.f20.should be_within(0.1293).of(1.293)
  end

  it 'cell g20 should equal 1.6' do
    sheet24.g20.should be_within(0.16000000000000003).of(1.6)
  end

  it 'cell h20 should equal 1.7' do
    sheet24.h20.should be_within(0.17).of(1.7)
  end

  it 'cell i20 should equal 1.8' do
    sheet24.i20.should be_within(0.18000000000000002).of(1.8)
  end

  it 'cell j20 should equal 1.85' do
    sheet24.j20.should be_within(0.18500000000000003).of(1.85)
  end

  it 'cell k20 should equal 1.9' do
    sheet24.k20.should be_within(0.19).of(1.9)
  end

  it 'cell l20 should equal 1.95' do
    sheet24.l20.should be_within(0.195).of(1.95)
  end

  it 'cell m20 should equal 2.0' do
    sheet24.m20.should be_within(0.2).of(2.0)
  end

  it 'cell n20 should equal 2.05' do
    sheet24.n20.should be_within(0.205).of(2.05)
  end

  it 'cell o20 should equal 2.1' do
    sheet24.o20.should be_within(0.21000000000000002).of(2.1)
  end

  it 'cell f73 should equal 1.293' do
    sheet24.f73.should be_within(0.1293).of(1.293)
  end

  it 'cell g73 should equal 1.6' do
    sheet24.g73.should be_within(0.16000000000000003).of(1.6)
  end

  it 'cell h73 should equal 1.7' do
    sheet24.h73.should be_within(0.17).of(1.7)
  end

  it 'cell i73 should equal 1.8' do
    sheet24.i73.should be_within(0.18000000000000002).of(1.8)
  end

  it 'cell j73 should equal 1.85' do
    sheet24.j73.should be_within(0.18500000000000003).of(1.85)
  end

  it 'cell k73 should equal 1.9' do
    sheet24.k73.should be_within(0.19).of(1.9)
  end

  it 'cell l73 should equal 1.95' do
    sheet24.l73.should be_within(0.195).of(1.95)
  end

  it 'cell m73 should equal 2.0' do
    sheet24.m73.should be_within(0.2).of(2.0)
  end

  it 'cell n73 should equal 2.05' do
    sheet24.n73.should be_within(0.205).of(2.05)
  end

  it 'cell o73 should equal 2.1' do
    sheet24.o73.should be_within(0.21000000000000002).of(2.1)
  end

  it 'cell f81 should equal 1.293' do
    sheet24.f81.should be_within(0.1293).of(1.293)
  end

  it 'cell g81 should equal 1.6' do
    sheet24.g81.should be_within(0.16000000000000003).of(1.6)
  end

  it 'cell h81 should equal 1.7' do
    sheet24.h81.should be_within(0.17).of(1.7)
  end

  it 'cell i81 should equal 1.8' do
    sheet24.i81.should be_within(0.18000000000000002).of(1.8)
  end

  it 'cell j81 should equal 1.85' do
    sheet24.j81.should be_within(0.18500000000000003).of(1.85)
  end

  it 'cell k81 should equal 1.9' do
    sheet24.k81.should be_within(0.19).of(1.9)
  end

  it 'cell l81 should equal 1.95' do
    sheet24.l81.should be_within(0.195).of(1.95)
  end

  it 'cell m81 should equal 2.0' do
    sheet24.m81.should be_within(0.2).of(2.0)
  end

  it 'cell n81 should equal 2.05' do
    sheet24.n81.should be_within(0.205).of(2.05)
  end

  it 'cell o81 should equal 2.1' do
    sheet24.o81.should be_within(0.21000000000000002).of(2.1)
  end

  it 'cell f83 should equal 0.46935899999999997' do
    sheet24.f83.should be_within(0.0469359).of(0.46935899999999997)
  end

  it 'cell g83 should equal 0.6080000000000001' do
    sheet24.g83.should be_within(0.060800000000000014).of(0.6080000000000001)
  end

  it 'cell h83 should equal 0.646' do
    sheet24.h83.should be_within(0.0646).of(0.646)
  end

  it 'cell i83 should equal 0.684' do
    sheet24.i83.should be_within(0.0684).of(0.684)
  end

  it 'cell j83 should equal 0.7030000000000001' do
    sheet24.j83.should be_within(0.07030000000000002).of(0.7030000000000001)
  end

  it 'cell k83 should equal 0.722' do
    sheet24.k83.should be_within(0.0722).of(0.722)
  end

  it 'cell l83 should equal 0.741' do
    sheet24.l83.should be_within(0.0741).of(0.741)
  end

  it 'cell m83 should equal 0.76' do
    sheet24.m83.should be_within(0.07600000000000001).of(0.76)
  end

  it 'cell n83 should equal 0.7789999999999999' do
    sheet24.n83.should be_within(0.0779).of(0.7789999999999999)
  end

  it 'cell o83 should equal 0.798' do
    sheet24.o83.should be_within(0.07980000000000001).of(0.798)
  end

  it 'cell f85 should equal 4.114400994' do
    sheet24.f85.should be_within(0.41144009940000004).of(4.114400994)
  end

  it 'cell g85 should equal 5.329728000000001' do
    sheet24.g85.should be_within(0.5329728000000001).of(5.329728000000001)
  end

  it 'cell h85 should equal 5.662836' do
    sheet24.h85.should be_within(0.5662836000000001).of(5.662836)
  end

  it 'cell i85 should equal 5.995944000000001' do
    sheet24.i85.should be_within(0.5995944000000001).of(5.995944000000001)
  end

  it 'cell j85 should equal 6.162498000000001' do
    sheet24.j85.should be_within(0.6162498000000002).of(6.162498000000001)
  end

  it 'cell k85 should equal 6.329052' do
    sheet24.k85.should be_within(0.6329052000000001).of(6.329052)
  end

  it 'cell l85 should equal 6.4956059999999995' do
    sheet24.l85.should be_within(0.6495606).of(6.4956059999999995)
  end

  it 'cell m85 should equal 6.66216' do
    sheet24.m85.should be_within(0.666216).of(6.66216)
  end

  it 'cell n85 should equal 6.828714' do
    sheet24.n85.should be_within(0.6828714).of(6.828714)
  end

  it 'cell o85 should equal 6.995268000000001' do
    sheet24.o85.should be_within(0.6995268000000001).of(6.995268000000001)
  end

  it 'cell f88 should equal 12.929999999999998' do
    sheet24.f88.should be_within(1.293).of(12.929999999999998)
  end

  it 'cell g88 should equal 16.0' do
    sheet24.g88.should be_within(1.6).of(16.0)
  end

  it 'cell h88 should equal 17.0' do
    sheet24.h88.should be_within(1.7000000000000002).of(17.0)
  end

  it 'cell i88 should equal 18.0' do
    sheet24.i88.should be_within(1.8).of(18.0)
  end

  it 'cell j88 should equal 18.5' do
    sheet24.j88.should be_within(1.85).of(18.5)
  end

  it 'cell k88 should equal 18.999999999999996' do
    sheet24.k88.should be_within(1.8999999999999997).of(18.999999999999996)
  end

  it 'cell l88 should equal 19.5' do
    sheet24.l88.should be_within(1.9500000000000002).of(19.5)
  end

  it 'cell m88 should equal 20.0' do
    sheet24.m88.should be_within(2.0).of(20.0)
  end

  it 'cell n88 should equal 20.499999999999996' do
    sheet24.n88.should be_within(2.05).of(20.499999999999996)
  end

  it 'cell o88 should equal 21.0' do
    sheet24.o88.should be_within(2.1).of(21.0)
  end

  it 'cell f89 should equal 42.31636363636362' do
    sheet24.f89.should be_within(4.231636363636362).of(42.31636363636362)
  end

  it 'cell g89 should equal 52.36363636363635' do
    sheet24.g89.should be_within(5.236363636363635).of(52.36363636363635)
  end

  it 'cell h89 should equal 55.63636363636362' do
    sheet24.h89.should be_within(5.563636363636363).of(55.63636363636362)
  end

  it 'cell i89 should equal 58.90909090909089' do
    sheet24.i89.should be_within(5.89090909090909).of(58.90909090909089)
  end

  it 'cell j89 should equal 60.54545454545453' do
    sheet24.j89.should be_within(6.054545454545454).of(60.54545454545453)
  end

  it 'cell k89 should equal 62.18181818181816' do
    sheet24.k89.should be_within(6.218181818181816).of(62.18181818181816)
  end

  it 'cell l89 should equal 63.8181818181818' do
    sheet24.l89.should be_within(6.38181818181818).of(63.8181818181818)
  end

  it 'cell m89 should equal 65.45454545454544' do
    sheet24.m89.should be_within(6.545454545454544).of(65.45454545454544)
  end

  it 'cell n89 should equal 67.09090909090907' do
    sheet24.n89.should be_within(6.709090909090907).of(67.09090909090907)
  end

  it 'cell o89 should equal 68.7272727272727' do
    sheet24.o89.should be_within(6.872727272727271).of(68.7272727272727)
  end

  it 'cell f90 should equal 2327.3999999999996' do
    sheet24.f90.should be_within(232.73999999999998).of(2327.3999999999996)
  end

  it 'cell g90 should equal 2879.9999999999995' do
    sheet24.g90.should be_within(287.99999999999994).of(2879.9999999999995)
  end

  it 'cell h90 should equal 3059.9999999999995' do
    sheet24.h90.should be_within(305.99999999999994).of(3059.9999999999995)
  end

  it 'cell i90 should equal 3239.9999999999995' do
    sheet24.i90.should be_within(324.0).of(3239.9999999999995)
  end

  it 'cell j90 should equal 3329.9999999999995' do
    sheet24.j90.should be_within(333.0).of(3329.9999999999995)
  end

  it 'cell k90 should equal 3419.999999999999' do
    sheet24.k90.should be_within(341.99999999999994).of(3419.999999999999)
  end

  it 'cell l90 should equal 3509.999999999999' do
    sheet24.l90.should be_within(350.99999999999994).of(3509.999999999999)
  end

  it 'cell m90 should equal 3599.999999999999' do
    sheet24.m90.should be_within(359.99999999999994).of(3599.999999999999)
  end

  it 'cell n90 should equal 3689.999999999999' do
    sheet24.n90.should be_within(368.99999999999994).of(3689.999999999999)
  end

  it 'cell o90 should equal 3779.9999999999995' do
    sheet24.o90.should be_within(378.0).of(3779.9999999999995)
  end

  it 'cell f110 should equal 4.114400994' do
    sheet24.f110.should be_within(0.41144009940000004).of(4.114400994)
  end

  it 'cell g110 should equal 5.329728000000001' do
    sheet24.g110.should be_within(0.5329728000000001).of(5.329728000000001)
  end

  it 'cell h110 should equal 5.662836' do
    sheet24.h110.should be_within(0.5662836000000001).of(5.662836)
  end

  it 'cell i110 should equal 5.995944000000001' do
    sheet24.i110.should be_within(0.5995944000000001).of(5.995944000000001)
  end

  it 'cell j110 should equal 6.162498000000001' do
    sheet24.j110.should be_within(0.6162498000000002).of(6.162498000000001)
  end

  it 'cell k110 should equal 6.329052' do
    sheet24.k110.should be_within(0.6329052000000001).of(6.329052)
  end

  it 'cell l110 should equal 6.4956059999999995' do
    sheet24.l110.should be_within(0.6495606).of(6.4956059999999995)
  end

  it 'cell m110 should equal 6.66216' do
    sheet24.m110.should be_within(0.666216).of(6.66216)
  end

  it 'cell n110 should equal 6.828714' do
    sheet24.n110.should be_within(0.6828714).of(6.828714)
  end

  it 'cell o110 should equal 6.995268000000001' do
    sheet24.o110.should be_within(0.6995268000000001).of(6.995268000000001)
  end

  it 'cell f111 should equal -4.114400994' do
    sheet24.f111.should be_within(0.41144009940000004).of(-4.114400994)
  end

  it 'cell g111 should equal -5.329728000000001' do
    sheet24.g111.should be_within(0.5329728000000001).of(-5.329728000000001)
  end

  it 'cell h111 should equal -5.662836' do
    sheet24.h111.should be_within(0.5662836000000001).of(-5.662836)
  end

  it 'cell i111 should equal -5.995944000000001' do
    sheet24.i111.should be_within(0.5995944000000001).of(-5.995944000000001)
  end

  it 'cell j111 should equal -6.162498000000001' do
    sheet24.j111.should be_within(0.6162498000000002).of(-6.162498000000001)
  end

  it 'cell k111 should equal -6.329052' do
    sheet24.k111.should be_within(0.6329052000000001).of(-6.329052)
  end

  it 'cell l111 should equal -6.4956059999999995' do
    sheet24.l111.should be_within(0.6495606).of(-6.4956059999999995)
  end

  it 'cell m111 should equal -6.66216' do
    sheet24.m111.should be_within(0.666216).of(-6.66216)
  end

  it 'cell n111 should equal -6.828714' do
    sheet24.n111.should be_within(0.6828714).of(-6.828714)
  end

  it 'cell o111 should equal -6.995268000000001' do
    sheet24.o111.should be_within(0.6995268000000001).of(-6.995268000000001)
  end

  it 'cell f120 should equal 12.929999999999998' do
    sheet24.f120.should be_within(1.293).of(12.929999999999998)
  end

  it 'cell g120 should equal 16.0' do
    sheet24.g120.should be_within(1.6).of(16.0)
  end

  it 'cell h120 should equal 17.0' do
    sheet24.h120.should be_within(1.7000000000000002).of(17.0)
  end

  it 'cell i120 should equal 18.0' do
    sheet24.i120.should be_within(1.8).of(18.0)
  end

  it 'cell j120 should equal 18.5' do
    sheet24.j120.should be_within(1.85).of(18.5)
  end

  it 'cell k120 should equal 18.999999999999996' do
    sheet24.k120.should be_within(1.8999999999999997).of(18.999999999999996)
  end

  it 'cell l120 should equal 19.5' do
    sheet24.l120.should be_within(1.9500000000000002).of(19.5)
  end

  it 'cell m120 should equal 20.0' do
    sheet24.m120.should be_within(2.0).of(20.0)
  end

  it 'cell n120 should equal 20.499999999999996' do
    sheet24.n120.should be_within(2.05).of(20.499999999999996)
  end

  it 'cell o120 should equal 21.0' do
    sheet24.o120.should be_within(2.1).of(21.0)
  end

  it 'cell f121 should equal 42.31636363636362' do
    sheet24.f121.should be_within(4.231636363636362).of(42.31636363636362)
  end

  it 'cell g121 should equal 52.36363636363635' do
    sheet24.g121.should be_within(5.236363636363635).of(52.36363636363635)
  end

  it 'cell h121 should equal 55.63636363636362' do
    sheet24.h121.should be_within(5.563636363636363).of(55.63636363636362)
  end

  it 'cell i121 should equal 58.90909090909089' do
    sheet24.i121.should be_within(5.89090909090909).of(58.90909090909089)
  end

  it 'cell j121 should equal 60.54545454545453' do
    sheet24.j121.should be_within(6.054545454545454).of(60.54545454545453)
  end

  it 'cell k121 should equal 62.18181818181816' do
    sheet24.k121.should be_within(6.218181818181816).of(62.18181818181816)
  end

  it 'cell l121 should equal 63.8181818181818' do
    sheet24.l121.should be_within(6.38181818181818).of(63.8181818181818)
  end

  it 'cell m121 should equal 65.45454545454544' do
    sheet24.m121.should be_within(6.545454545454544).of(65.45454545454544)
  end

  it 'cell n121 should equal 67.09090909090907' do
    sheet24.n121.should be_within(6.709090909090907).of(67.09090909090907)
  end

  it 'cell o121 should equal 68.7272727272727' do
    sheet24.o121.should be_within(6.872727272727271).of(68.7272727272727)
  end

  it 'cell f122 should equal 2327.3999999999996' do
    sheet24.f122.should be_within(232.73999999999998).of(2327.3999999999996)
  end

  it 'cell g122 should equal 2879.9999999999995' do
    sheet24.g122.should be_within(287.99999999999994).of(2879.9999999999995)
  end

  it 'cell h122 should equal 3059.9999999999995' do
    sheet24.h122.should be_within(305.99999999999994).of(3059.9999999999995)
  end

  it 'cell i122 should equal 3239.9999999999995' do
    sheet24.i122.should be_within(324.0).of(3239.9999999999995)
  end

  it 'cell j122 should equal 3329.9999999999995' do
    sheet24.j122.should be_within(333.0).of(3329.9999999999995)
  end

  it 'cell k122 should equal 3419.999999999999' do
    sheet24.k122.should be_within(341.99999999999994).of(3419.999999999999)
  end

  it 'cell l122 should equal 3509.999999999999' do
    sheet24.l122.should be_within(350.99999999999994).of(3509.999999999999)
  end

  it 'cell m122 should equal 3599.999999999999' do
    sheet24.m122.should be_within(359.99999999999994).of(3599.999999999999)
  end

  it 'cell n122 should equal 3689.999999999999' do
    sheet24.n122.should be_within(368.99999999999994).of(3689.999999999999)
  end

  it 'cell o122 should equal 3779.9999999999995' do
    sheet24.o122.should be_within(378.0).of(3779.9999999999995)
  end

end