# coding: utf-8
require_relative '../spreadsheet'
# VI.c
describe 'Sheet34' do
  def sheet34; $spreadsheet ||= Spreadsheet.new; $spreadsheet.sheet34; end

  it 'cell e7 should equal 2.0' do
    sheet34.e7.should be_within(0.2).of(2.0)
  end

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

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

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

  it 'cell i19 should equal 1.0' do
    sheet34.i19.should be_within(0.1).of(1.0)
  end

  it 'cell j19 should equal 5.0' do
    sheet34.j19.should be_within(0.5).of(5.0)
  end

  it 'cell k19 should equal 10.0' do
    sheet34.k19.should be_within(1.0).of(10.0)
  end

  it 'cell l19 should equal 25.0' do
    sheet34.l19.should be_within(2.5).of(25.0)
  end

  it 'cell m19 should equal 100.0' do
    sheet34.m19.should be_within(10.0).of(100.0)
  end

  it 'cell n19 should equal 250.0' do
    sheet34.n19.should be_within(25.0).of(250.0)
  end

  it 'cell o19 should equal 562.545' do
    sheet34.o19.should be_within(56.2545).of(562.545)
  end

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

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

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

  it 'cell i54 should equal 1.0' do
    sheet34.i54.should be_within(0.1).of(1.0)
  end

  it 'cell j54 should equal 5.0' do
    sheet34.j54.should be_within(0.5).of(5.0)
  end

  it 'cell k54 should equal 10.0' do
    sheet34.k54.should be_within(1.0).of(10.0)
  end

  it 'cell l54 should equal 25.0' do
    sheet34.l54.should be_within(2.5).of(25.0)
  end

  it 'cell m54 should equal 100.0' do
    sheet34.m54.should be_within(10.0).of(100.0)
  end

  it 'cell n54 should equal 250.0' do
    sheet34.n54.should be_within(25.0).of(250.0)
  end

  it 'cell o54 should equal 562.545' do
    sheet34.o54.should be_within(56.2545).of(562.545)
  end

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

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

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

  it 'cell i57 should equal 0.0058333333333333345' do
    sheet34.i57.should be_within(0.0005833333333333335).of(0.0058333333333333345)
  end

  it 'cell j57 should equal 0.038888888888888896' do
    sheet34.j57.should be_within(0.0038888888888888896).of(0.038888888888888896)
  end

  it 'cell k57 should equal 0.07777777777777779' do
    sheet34.k57.should be_within(0.007777777777777779).of(0.07777777777777779)
  end

  it 'cell l57 should equal 0.19444444444444448' do
    sheet34.l57.should be_within(0.019444444444444448).of(0.19444444444444448)
  end

  it 'cell m57 should equal 0.7777777777777779' do
    sheet34.m57.should be_within(0.07777777777777779).of(0.7777777777777779)
  end

  it 'cell n57 should equal 1.9444444444444446' do
    sheet34.n57.should be_within(0.19444444444444448).of(1.9444444444444446)
  end

  it 'cell o57 should equal 4.37535' do
    sheet34.o57.should be_within(0.437535).of(4.37535)
  end

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

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

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

  it 'cell i70 should equal 0.0058333333333333345' do
    sheet34.i70.should be_within(0.0005833333333333335).of(0.0058333333333333345)
  end

  it 'cell j70 should equal 0.038888888888888896' do
    sheet34.j70.should be_within(0.0038888888888888896).of(0.038888888888888896)
  end

  it 'cell k70 should equal 0.07777777777777779' do
    sheet34.k70.should be_within(0.007777777777777779).of(0.07777777777777779)
  end

  it 'cell l70 should equal 0.19444444444444448' do
    sheet34.l70.should be_within(0.019444444444444448).of(0.19444444444444448)
  end

  it 'cell m70 should equal 0.7777777777777779' do
    sheet34.m70.should be_within(0.07777777777777779).of(0.7777777777777779)
  end

  it 'cell n70 should equal 1.9444444444444446' do
    sheet34.n70.should be_within(0.19444444444444448).of(1.9444444444444446)
  end

  it 'cell o70 should equal 4.37535' do
    sheet34.o70.should be_within(0.437535).of(4.37535)
  end

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

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

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

  it 'cell i71 should equal -0.0058333333333333345' do
    sheet34.i71.should be_within(0.0005833333333333335).of(-0.0058333333333333345)
  end

  it 'cell j71 should equal -0.038888888888888896' do
    sheet34.j71.should be_within(0.0038888888888888896).of(-0.038888888888888896)
  end

  it 'cell k71 should equal -0.07777777777777779' do
    sheet34.k71.should be_within(0.007777777777777779).of(-0.07777777777777779)
  end

  it 'cell l71 should equal -0.19444444444444448' do
    sheet34.l71.should be_within(0.019444444444444448).of(-0.19444444444444448)
  end

  it 'cell m71 should equal -0.7777777777777779' do
    sheet34.m71.should be_within(0.07777777777777779).of(-0.7777777777777779)
  end

  it 'cell n71 should equal -1.9444444444444446' do
    sheet34.n71.should be_within(0.19444444444444448).of(-1.9444444444444446)
  end

  it 'cell o71 should equal -4.37535' do
    sheet34.o71.should be_within(0.437535).of(-4.37535)
  end

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

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

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

  it 'cell i80 should equal 1.0' do
    sheet34.i80.should be_within(0.1).of(1.0)
  end

  it 'cell j80 should equal 5.0' do
    sheet34.j80.should be_within(0.5).of(5.0)
  end

  it 'cell k80 should equal 10.0' do
    sheet34.k80.should be_within(1.0).of(10.0)
  end

  it 'cell l80 should equal 25.0' do
    sheet34.l80.should be_within(2.5).of(25.0)
  end

  it 'cell m80 should equal 100.0' do
    sheet34.m80.should be_within(10.0).of(100.0)
  end

  it 'cell n80 should equal 250.0' do
    sheet34.n80.should be_within(25.0).of(250.0)
  end

  it 'cell o80 should equal 562.545' do
    sheet34.o80.should be_within(56.2545).of(562.545)
  end

end