# coding: utf-8 require_relative '../spreadsheet' # III.a.2 describe 'Sheet23' do def sheet23; $spreadsheet ||= Spreadsheet.new; $spreadsheet.sheet23; end it 'cell e7 should equal 2.0' do sheet23.e7.should be_within(0.2).of(2.0) end it 'cell f19 should equal 0.316666666666667' do sheet23.f19.should be_within(0.0316666666666667).of(0.316666666666667) end it 'cell g19 should equal 1.168' do sheet23.g19.should be_within(0.1168).of(1.168) end it 'cell h19 should equal 1.76' do sheet23.h19.should be_within(0.17600000000000002).of(1.76) end it 'cell i19 should equal 3.0' do sheet23.i19.should be_within(0.30000000000000004).of(3.0) end it 'cell j19 should equal 3.0' do sheet23.j19.should be_within(0.30000000000000004).of(3.0) end it 'cell k19 should equal 3.0' do sheet23.k19.should be_within(0.30000000000000004).of(3.0) end it 'cell l19 should equal 3.0' do sheet23.l19.should be_within(0.30000000000000004).of(3.0) end it 'cell m19 should equal 3.0' do sheet23.m19.should be_within(0.30000000000000004).of(3.0) end it 'cell n19 should equal 3.0' do sheet23.n19.should be_within(0.30000000000000004).of(3.0) end it 'cell f28 should equal 0.0' do sheet23.f28.should be_within(1.0e-08).of(0.0) end it 'cell g28 should equal 0.0' do sheet23.g28.should be_within(1.0e-08).of(0.0) end it 'cell h28 should equal 0.0' do sheet23.h28.should be_within(1.0e-08).of(0.0) end it 'cell i28 should equal -0.03' do sheet23.i28.should be_within(0.003).of(-0.03) end it 'cell j28 should equal -0.23876000000000022' do sheet23.j28.should be_within(0.023876000000000022).of(-0.23876000000000022) end it 'cell k28 should equal -1.168' do sheet23.k28.should be_within(0.1168).of(-1.168) end it 'cell l28 should equal -1.76' do sheet23.l28.should be_within(0.17600000000000002).of(-1.76) end it 'cell m28 should equal -3.0' do sheet23.m28.should be_within(0.30000000000000004).of(-3.0) end it 'cell n28 should equal -3.0' do sheet23.n28.should be_within(0.30000000000000004).of(-3.0) end it 'cell g89 should equal 1.343800000000001' do sheet23.g89.should be_within(0.1343800000000001).of(1.343800000000001) end it 'cell h89 should equal 7.183800000000001' do sheet23.h89.should be_within(0.7183800000000001).of(7.183800000000001) end it 'cell i89 should equal 15.983800000000002' do sheet23.i89.should be_within(1.5983800000000004).of(15.983800000000002) end it 'cell j89 should equal 30.833800000000004' do sheet23.j89.should be_within(3.0833800000000005).of(30.833800000000004) end it 'cell k89 should equal 44.64' do sheet23.k89.should be_within(4.464).of(44.64) end it 'cell l89 should equal 53.8' do sheet23.l89.should be_within(5.38).of(53.8) end it 'cell m89 should equal 60.0' do sheet23.m89.should be_within(6.0).of(60.0) end it 'cell n89 should equal 60.0' do sheet23.n89.should be_within(6.0).of(60.0) end it 'cell o89 should equal 60.0' do sheet23.o89.should be_within(6.0).of(60.0) end it 'cell g97 should equal 1.343800000000001' do sheet23.g97.should be_within(0.1343800000000001).of(1.343800000000001) end it 'cell h97 should equal 7.183800000000001' do sheet23.h97.should be_within(0.7183800000000001).of(7.183800000000001) end it 'cell i97 should equal 15.983800000000002' do sheet23.i97.should be_within(1.5983800000000004).of(15.983800000000002) end it 'cell j97 should equal 30.833800000000004' do sheet23.j97.should be_within(3.0833800000000005).of(30.833800000000004) end it 'cell k97 should equal 44.64' do sheet23.k97.should be_within(4.464).of(44.64) end it 'cell l97 should equal 53.8' do sheet23.l97.should be_within(5.38).of(53.8) end it 'cell m97 should equal 60.0' do sheet23.m97.should be_within(6.0).of(60.0) end it 'cell n97 should equal 60.0' do sheet23.n97.should be_within(6.0).of(60.0) end it 'cell o97 should equal 60.0' do sheet23.o97.should be_within(6.0).of(60.0) end it 'cell g99 should equal 0.4703300000000003' do sheet23.g99.should be_within(0.04703300000000003).of(0.4703300000000003) end it 'cell h99 should equal 2.51433' do sheet23.h99.should be_within(0.251433).of(2.51433) end it 'cell i99 should equal 5.9140060000000005' do sheet23.i99.should be_within(0.5914006).of(5.9140060000000005) end it 'cell j99 should equal 12.333520000000002' do sheet23.j99.should be_within(1.2333520000000002).of(12.333520000000002) end it 'cell k99 should equal 19.1952' do sheet23.k99.should be_within(1.9195200000000001).of(19.1952) end it 'cell l99 should equal 24.21' do sheet23.l99.should be_within(2.4210000000000003).of(24.21) end it 'cell m99 should equal 27.0' do sheet23.m99.should be_within(2.7).of(27.0) end it 'cell n99 should equal 27.0' do sheet23.n99.should be_within(2.7).of(27.0) end it 'cell o99 should equal 27.0' do sheet23.o99.should be_within(2.7).of(27.0) end it 'cell g100 should equal 4.122912780000003' do sheet23.g100.should be_within(0.4122912780000003).of(4.122912780000003) end it 'cell h100 should equal 22.040616780000004' do sheet23.h100.should be_within(2.2040616780000004).of(22.040616780000004) end it 'cell i100 should equal 51.84217659600001' do sheet23.i100.should be_within(5.184217659600002).of(51.84217659600001) end it 'cell j100 should equal 108.11563632000002' do sheet23.j100.should be_within(10.811563632000002).of(108.11563632000002) end it 'cell k100 should equal 168.26512319999998' do sheet23.k100.should be_within(16.82651232).of(168.26512319999998) end it 'cell l100 should equal 212.22486' do sheet23.l100.should be_within(21.222486000000004).of(212.22486) end it 'cell m100 should equal 236.682' do sheet23.m100.should be_within(23.6682).of(236.682) end it 'cell n100 should equal 236.682' do sheet23.n100.should be_within(23.6682).of(236.682) end it 'cell o100 should equal 236.682' do sheet23.o100.should be_within(23.6682).of(236.682) end it 'cell g103 should equal 231.68965517241398' do sheet23.g103.should be_within(23.1689655172414).of(231.68965517241398) end it 'cell h103 should equal 1238.5862068965519' do sheet23.h103.should be_within(123.8586206896552).of(1238.5862068965519) end it 'cell i103 should equal 2755.827586206897' do sheet23.i103.should be_within(275.58275862068973).of(2755.827586206897) end it 'cell j103 should equal 5316.172413793104' do sheet23.j103.should be_within(531.6172413793105).of(5316.172413793104) end it 'cell k103 should equal 7696.551724137932' do sheet23.k103.should be_within(769.6551724137933).of(7696.551724137932) end it 'cell l103 should equal 9275.862068965518' do sheet23.l103.should be_within(927.5862068965519).of(9275.862068965518) end it 'cell m103 should equal 10344.827586206897' do sheet23.m103.should be_within(1034.4827586206898).of(10344.827586206897) end it 'cell n103 should equal 10344.827586206897' do sheet23.n103.should be_within(1034.4827586206898).of(10344.827586206897) end it 'cell o103 should equal 10344.827586206897' do sheet23.o103.should be_within(1034.4827586206898).of(10344.827586206897) end it 'cell g105 should equal 188.1320000000001' do sheet23.g105.should be_within(18.81320000000001).of(188.1320000000001) end it 'cell h105 should equal 1005.732' do sheet23.h105.should be_within(100.5732).of(1005.732) end it 'cell i105 should equal 2365.6023999999998' do sheet23.i105.should be_within(236.56024).of(2365.6023999999998) end it 'cell j105 should equal 4933.408' do sheet23.j105.should be_within(493.34080000000006).of(4933.408) end it 'cell k105 should equal 7678.079999999997' do sheet23.k105.should be_within(767.8079999999998).of(7678.079999999997) end it 'cell l105 should equal 9683.999999999998' do sheet23.l105.should be_within(968.3999999999999).of(9683.999999999998) end it 'cell m105 should equal 10799.999999999998' do sheet23.m105.should be_within(1079.9999999999998).of(10799.999999999998) end it 'cell n105 should equal 10799.999999999998' do sheet23.n105.should be_within(1079.9999999999998).of(10799.999999999998) end it 'cell o105 should equal 10799.999999999998' do sheet23.o105.should be_within(1079.9999999999998).of(10799.999999999998) end it 'cell g124 should equal 4.122912780000003' do sheet23.g124.should be_within(0.4122912780000003).of(4.122912780000003) end it 'cell h124 should equal 22.040616780000004' do sheet23.h124.should be_within(2.2040616780000004).of(22.040616780000004) end it 'cell i124 should equal 51.84217659600001' do sheet23.i124.should be_within(5.184217659600002).of(51.84217659600001) end it 'cell j124 should equal 108.11563632000002' do sheet23.j124.should be_within(10.811563632000002).of(108.11563632000002) end it 'cell k124 should equal 168.26512319999998' do sheet23.k124.should be_within(16.82651232).of(168.26512319999998) end it 'cell l124 should equal 212.22486' do sheet23.l124.should be_within(21.222486000000004).of(212.22486) end it 'cell m124 should equal 236.682' do sheet23.m124.should be_within(23.6682).of(236.682) end it 'cell n124 should equal 236.682' do sheet23.n124.should be_within(23.6682).of(236.682) end it 'cell o124 should equal 236.682' do sheet23.o124.should be_within(23.6682).of(236.682) end it 'cell g125 should equal -4.122912780000003' do sheet23.g125.should be_within(0.4122912780000003).of(-4.122912780000003) end it 'cell h125 should equal -22.040616780000004' do sheet23.h125.should be_within(2.2040616780000004).of(-22.040616780000004) end it 'cell i125 should equal -51.84217659600001' do sheet23.i125.should be_within(5.184217659600002).of(-51.84217659600001) end it 'cell j125 should equal -108.11563632000002' do sheet23.j125.should be_within(10.811563632000002).of(-108.11563632000002) end it 'cell k125 should equal -168.26512319999998' do sheet23.k125.should be_within(16.82651232).of(-168.26512319999998) end it 'cell l125 should equal -212.22486' do sheet23.l125.should be_within(21.222486000000004).of(-212.22486) end it 'cell m125 should equal -236.682' do sheet23.m125.should be_within(23.6682).of(-236.682) end it 'cell n125 should equal -236.682' do sheet23.n125.should be_within(23.6682).of(-236.682) end it 'cell o125 should equal -236.682' do sheet23.o125.should be_within(23.6682).of(-236.682) end it 'cell g134 should equal 188.1320000000001' do sheet23.g134.should be_within(18.81320000000001).of(188.1320000000001) end it 'cell h134 should equal 1005.732' do sheet23.h134.should be_within(100.5732).of(1005.732) end it 'cell i134 should equal 2365.6023999999998' do sheet23.i134.should be_within(236.56024).of(2365.6023999999998) end it 'cell j134 should equal 4933.408' do sheet23.j134.should be_within(493.34080000000006).of(4933.408) end it 'cell k134 should equal 7678.079999999997' do sheet23.k134.should be_within(767.8079999999998).of(7678.079999999997) end it 'cell l134 should equal 9683.999999999998' do sheet23.l134.should be_within(968.3999999999999).of(9683.999999999998) end it 'cell m134 should equal 10799.999999999998' do sheet23.m134.should be_within(1079.9999999999998).of(10799.999999999998) end it 'cell n134 should equal 10799.999999999998' do sheet23.n134.should be_within(1079.9999999999998).of(10799.999999999998) end it 'cell o134 should equal 10799.999999999998' do sheet23.o134.should be_within(1079.9999999999998).of(10799.999999999998) end it 'cell g135 should equal 1.343800000000001' do sheet23.g135.should be_within(0.1343800000000001).of(1.343800000000001) end it 'cell h135 should equal 7.183800000000001' do sheet23.h135.should be_within(0.7183800000000001).of(7.183800000000001) end it 'cell i135 should equal 15.983800000000002' do sheet23.i135.should be_within(1.5983800000000004).of(15.983800000000002) end it 'cell j135 should equal 30.833800000000004' do sheet23.j135.should be_within(3.0833800000000005).of(30.833800000000004) end it 'cell k135 should equal 44.64' do sheet23.k135.should be_within(4.464).of(44.64) end it 'cell l135 should equal 53.8' do sheet23.l135.should be_within(5.38).of(53.8) end it 'cell m135 should equal 60.0' do sheet23.m135.should be_within(6.0).of(60.0) end it 'cell n135 should equal 60.0' do sheet23.n135.should be_within(6.0).of(60.0) end it 'cell o135 should equal 60.0' do sheet23.o135.should be_within(6.0).of(60.0) end it 'cell g136 should equal 231.68965517241398' do sheet23.g136.should be_within(23.1689655172414).of(231.68965517241398) end it 'cell h136 should equal 1238.5862068965519' do sheet23.h136.should be_within(123.8586206896552).of(1238.5862068965519) end it 'cell i136 should equal 2755.827586206897' do sheet23.i136.should be_within(275.58275862068973).of(2755.827586206897) end it 'cell j136 should equal 5316.172413793104' do sheet23.j136.should be_within(531.6172413793105).of(5316.172413793104) end it 'cell k136 should equal 7696.551724137932' do sheet23.k136.should be_within(769.6551724137933).of(7696.551724137932) end it 'cell l136 should equal 9275.862068965518' do sheet23.l136.should be_within(927.5862068965519).of(9275.862068965518) end it 'cell m136 should equal 10344.827586206897' do sheet23.m136.should be_within(1034.4827586206898).of(10344.827586206897) end it 'cell n136 should equal 10344.827586206897' do sheet23.n136.should be_within(1034.4827586206898).of(10344.827586206897) end it 'cell o136 should equal 10344.827586206897' do sheet23.o136.should be_within(1034.4827586206898).of(10344.827586206897) end end