incrementing and checking till getting value less than specified.

trustmeasfrnd

New Member
Joined
Oct 19, 2008
Messages
32
hi,
i am new to VBA.
how increment using VBA can be done to find minimum requirement for Length(L) and width(B) of foundation so that Modified bearing pressure(PMOD) is less than allowable bearing pressure(ABP). Attached sample calculation for visualisation and better understanding.
Regards,
Abhi


Book1
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1Grade of concrete=35N/mm2
2Grade of steel=415N/mm2
3Density of concrete (RCC)=25kN/m2
4Clear cover to main reinforcement=50mm
5PCC thickness & projection=75mm
6Increment in foundation size=0.1m
7
8Net SBC of Soil as per geotechnical reportSBC=90kN/m2
9Soil Density=13.8kN/m2
10Depth of foundation below ground level (FGL)=3.4m
11Gross SBC of soil for all conditions except wind/seismic=136.92kN/m2
12Gross SBC of soil for wind/seismic=159.42kN/m2
13
14
15
1646.92
17CALCULATION NOTE OF FOUNDATION FOR BEARING PRESSURE CHECK
18
19Load CaseLaod DataTotalPressure CalculationABPUnfactoredNetsumValues are From Teng
20NodeP kNMx kN-mMz kN-mFdn. SizeAxial Loadey/Bex/LKPMOD. K P/(B.L)pmax.Pressure kN/m2Pressure kN/m212345678910
211107201.452.77-7.65Fdn. Size388.5060.0040.0111.08116.97136.92116.97 0.0150.0000.0500.0000.0501.0001.3001.0661.3001.6001.3211.084
22108179.962.704.54L=1.80367.0160.0040.0071.06108.26159.42108.26 0.0110.0000.0500.0000.0501.0001.3001.0411.3001.6001.3221.062
23109222.942.83-19.85B=2.00409.9960.0030.0271.17133.52159.42133.5286.600.0300.0000.0500.0000.0501.0001.3001.1611.3001.6001.3211.172
24110176.943.470.80D=0.45363.9960.0050.0011.04104.95159.42104.95 0.0060.0000.0500.0000.0501.0001.3001.0071.3001.6001.3291.038
25111202.423.75-8.30d=0.45389.4760.0050.0121.10118.56159.42118.56 0.0170.0000.0500.0000.0501.0001.3001.0711.3001.6001.3291.096
26112200.481.78-7.00Col. Size387.5360.0020.0101.07115.38159.42115.38 0.0120.0000.0500.0000.0501.0001.3001.0601.3001.6001.3141.072
271070.000.000.00l= 0.35187.0560.0000.0001.0051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
281080.000.000.00b=0.35187.0560.0000.0001.0051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
291090.000.000.00Wt. of Conc.187.0560.0000.0001.0051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
301100.000.000.0040.5187.0560.0000.0001.0051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
311110.000.000.00Wt. of Soil187.0560.0000.0001.0051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
321120.000.000.00146.556187.0560.0000.0001.0051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
331130.000.000.00187.0560.0000.0001.0051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
342107207.110.033.58Fdn. Size394.1660.0000.0051.030112.83136.92112.83 0.0050.0000.0500.0000.0501.0001.3001.0301.3001.6001.3001.030
35108224.970.9817.31L=1.80412.0260.0010.0231.144130.93159.42130.93 0.0250.0000.0500.0000.0501.0001.3001.1401.3001.6001.3071.144
36109189.25-0.91-10.15B=2.00376.3060.0010.0151.095114.48159.42114.48 0.0160.0000.0500.0000.0501.0001.3001.0901.3001.6001.3071.095
37110229.213.1114.75D=0.45416.2660.0040.0201.133131.05159.42131.05 0.0230.0000.0500.0000.0501.0001.3001.1181.3001.6001.3221.133
38111206.84-23.632.78d=0.45393.8960.0300.0041.297141.95159.42141.95 0.0340.0000.0500.0000.0501.0001.3001.0241.3001.6001.4801.297
39112207.3823.694.38Col. Size394.4360.0300.0061.303142.78159.42142.7895.860.0360.0000.0500.0000.0501.0001.3001.0371.3001.6001.4801.303
401070.000.000.00l= 0.35187.0560.0000.0001.00051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
411080.000.000.00b=0.35187.0560.0000.0001.00051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
421090.000.000.00Wt. of Conc.187.0560.0000.0001.00051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
431100.000.000.0040.5187.0560.0000.0001.00051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
441110.000.000.00Wt. of Soil187.0560.0000.0001.00051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
451120.000.000.00146.556187.0560.0000.0001.00051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
461130.000.000.00187.0560.0000.0001.00051.96159.4251.96 0.0000.0000.0500.0000.0501.0001.3001.0001.3001.6001.3001.000
Sheet1
Cell Formulas
RangeFormula
I11=I8+I9*I10
I12=I8*1.25+I10*I9
I21=ABS(E21/G21/$F$22)
I22=ABS(E22/G22/$F$22)
I23=ABS(E23/G23/$F$22)
I24=ABS(E24/G24/$F$22)
I25=ABS(E25/G25/$F$22)
I26=ABS(E26/G26/$F$22)
I27=ABS(E27/G27/$F$22)
I28=ABS(E28/G28/$F$22)
I29=ABS(E29/G29/$F$22)
I30=ABS(E30/G30/$F$22)
I31=ABS(E31/G31/$F$22)
I32=ABS(E32/G32/$F$22)
I33=ABS(E33/G33/$F$22)
I34=ABS(E34/G34/$F$35)
I35=ABS(E35/G35/$F$35)
I36=ABS(E36/G36/$F$35)
I37=ABS(E37/G37/$F$35)
I38=ABS(E38/G38/$F$35)
I39=ABS(E39/G39/$F$35)
I40=ABS(E40/G40/$F$35)
I41=ABS(E41/G41/$F$35)
I42=ABS(E42/G42/$F$35)
I43=ABS(E43/G43/$F$35)
I44=ABS(E44/G44/$F$35)
I45=ABS(E45/G45/$F$35)
I46=ABS(E46/G46/$F$35)
G21=C21+$F$30+$F$32
G22=C22+$F$30+$F$32
G23=C23+$F$30+$F$32
G24=C24+$F$30+$F$32
G25=C25+$F$30+$F$32
G26=C26+$F$30+$F$32
G27=C27+$F$30+$F$32
G28=C28+$F$30+$F$32
G29=C29+$F$30+$F$32
G30=C30+$F$30+$F$32
G31=C31+$F$30+$F$32
G32=C32+$F$30+$F$32
G33=C33+$F$30+$F$32
G34=C34+$F$43+$F$45
G35=C35+$F$43+$F$45
G36=C36+$F$43+$F$45
G37=C37+$F$43+$F$45
G38=C38+$F$43+$F$45
G39=C39+$F$43+$F$45
G40=C40+$F$43+$F$45
G41=C41+$F$43+$F$45
G42=C42+$F$43+$F$45
G43=C43+$F$43+$F$45
G44=C44+$F$43+$F$45
G45=C45+$F$43+$F$45
G46=C46+$F$43+$F$45
H21=ABS(D21/G21/$F$23)
H22=ABS(D22/G22/$F$23)
H23=ABS(D23/G23/$F$23)
H24=ABS(D24/G24/$F$23)
H25=ABS(D25/G25/$F$23)
H26=ABS(D26/G26/$F$23)
H27=ABS(D27/G27/$F$23)
H28=ABS(D28/G28/$F$23)
H29=ABS(D29/G29/$F$23)
H30=ABS(D30/G30/$F$23)
H31=ABS(D31/G31/$F$23)
H32=ABS(D32/G32/$F$23)
H33=ABS(D33/G33/$F$23)
H34=ABS(D34/G34/$F$36)
H35=ABS(D35/G35/$F$36)
H36=ABS(D36/G36/$F$36)
H37=ABS(D37/G37/$F$36)
H38=ABS(D38/G38/$F$36)
H39=ABS(D39/G39/$F$36)
H40=ABS(D40/G40/$F$36)
H41=ABS(D41/G41/$F$36)
H42=ABS(D42/G42/$F$36)
H43=ABS(D43/G43/$F$36)
H44=ABS(D44/G44/$F$36)
H45=ABS(D45/G45/$F$36)
H46=ABS(D46/G46/$F$36)
J21=Z21
J22=Z22
J23=Z23
J24=Z24
J25=Z25
J26=Z26
J27=Z27
J28=Z28
J29=Z29
J30=Z30
J31=Z31
J32=Z32
J33=Z33
J34=Z34
J35=Z35
J36=Z36
J37=Z37
J38=Z38
J39=Z39
J40=Z40
J41=Z41
J42=Z42
J43=Z43
J44=Z44
J45=Z45
J46=Z46
K21=J21*G21/($F$22*$F$23)
K22=J22*G22/($F$22*$F$23)
K23=J23*G23/($F$22*$F$23)
K24=J24*G24/($F$22*$F$23)
K25=J25*G25/($F$22*$F$23)
K26=J26*G26/($F$22*$F$23)
K27=J27*G27/($F$22*$F$23)
K28=J28*G28/($F$22*$F$23)
K29=J29*G29/($F$22*$F$23)
K30=J30*G30/($F$22*$F$23)
K31=J31*G31/($F$22*$F$23)
K32=J32*G32/($F$22*$F$23)
K33=J33*G33/($F$22*$F$23)
K34=J34*G34/($F$35*$F$36)
K35=J35*G35/($F$35*$F$36)
K36=J36*G36/($F$35*$F$36)
K37=J37*G37/($F$35*$F$36)
K38=J38*G38/($F$35*$F$36)
K39=J39*G39/($F$35*$F$36)
K40=J40*G40/($F$35*$F$36)
K41=J41*G41/($F$35*$F$36)
K42=J42*G42/($F$35*$F$36)
K43=J43*G43/($F$35*$F$36)
K44=J44*G44/($F$35*$F$36)
K45=J45*G45/($F$35*$F$36)
K46=J46*G46/($F$35*$F$36)
L21=I11
L22=$I$12
L23=$I$12
L24=$I$12
L25=$I$12
L26=$I$12
L27=$I$12
L28=$I$12
L29=$I$12
L30=$I$12
L31=$I$12
L32=$I$12
L33=$I$12
L34=I11
L35=$I$12
L36=$I$12
L37=$I$12
L38=$I$12
L39=$I$12
L40=$I$12
L41=$I$12
L42=$I$12
L43=$I$12
L44=$I$12
L45=$I$12
L46=$I$12
M21=K21
M22=K22
M23=K23
M24=K24
M25=K25
M26=K26
M27=K27
M28=K28
M29=K29
M30=K30
M31=K31
M32=K32
M33=K33
M34=K34
M35=K35
M36=K36
M37=K37
M38=K38
M39=K39
M40=K40
M41=K41
M42=K42
M43=K43
M44=K44
M45=K45
M46=K46
N21=IF(M21=MAX($M$21:$M$33),(M21-$K$16),"")
N22=IF(M22=MAX($M$21:$M$33),(M22-$K$16),"")
N23=IF(M23=MAX($M$21:$M$33),(M23-$K$16),"")
N24=IF(M24=MAX($M$21:$M$33),(M24-$K$16),"")
N25=IF(M25=MAX($M$21:$M$33),(M25-$K$16),"")
N26=IF(M26=MAX($M$21:$M$33),(M26-$K$16),"")
N27=IF(M27=MAX($M$21:$M$33),(M27-$K$16),"")
N28=IF(M28=MAX($M$21:$M$33),(M28-$K$16),"")
N29=IF(M29=MAX($M$21:$M$33),(M29-$K$16),"")
N30=IF(M30=MAX($M$21:$M$33),(M30-$K$16),"")
N31=IF(M31=MAX($M$21:$M$33),(M31-$K$16),"")
N32=IF(M32=MAX($M$21:$M$33),(M32-$K$16),"")
N33=IF(M33=MAX($M$21:$M$33),(M33-$K$28),"")
N34=IF(M34=MAX($M$34:$M$46),(M34-$K$16),"")
N35=IF(M35=MAX($M$34:$M$46),(M35-$K$16),"")
N36=IF(M36=MAX($M$34:$M$46),(M36-$K$16),"")
N37=IF(M37=MAX($M$34:$M$46),(M37-$K$16),"")
N38=IF(M38=MAX($M$34:$M$46),(M38-$K$16),"")
N39=IF(M39=MAX($M$34:$M$46),(M39-$K$16),"")
N40=IF(M40=MAX($M$34:$M$46),(M40-$K$16),"")
N41=IF(M41=MAX($M$34:$M$46),(M41-$K$16),"")
N42=IF(M42=MAX($M$34:$M$46),(M42-$K$16),"")
N43=IF(M43=MAX($M$34:$M$46),(M43-$K$16),"")
N44=IF(M44=MAX($M$34:$M$46),(M44-$K$16),"")
N45=IF(M45=MAX($M$34:$M$46),(M45-$K$16),"")
N46=IF(M46=MAX($M$34:$M$46),(M46-$K$16),"")
O21=H21+I21
O22=H22+I22
O23=H23+I23
O24=H24+I24
O25=H25+I25
O26=H26+I26
O27=H27+I27
O28=H28+I28
O29=H29+I29
O30=H30+I30
O31=H31+I31
O32=H32+I32
O33=H33+I33
O34=H34+I34
O35=H35+I35
O36=H36+I36
O37=H37+I37
O38=H38+I38
O39=H39+I39
O40=H40+I40
O41=H41+I41
O42=H42+I42
O43=H43+I43
O44=H44+I44
O45=H45+I45
O46=H46+I46
P21=INDEX(TENG!$B$4:$O$4,1,MATCH(I21,TENG!$A$6:$A$19,1))
P22=INDEX(TENG!$B$4:$O$4,1,MATCH(I22,TENG!$A$6:$A$19,1))
P23=INDEX(TENG!$B$4:$O$4,1,MATCH(I23,TENG!$A$6:$A$19,1))
P24=INDEX(TENG!$B$4:$O$4,1,MATCH(I24,TENG!$A$6:$A$19,1))
P25=INDEX(TENG!$B$4:$O$4,1,MATCH(I25,TENG!$A$6:$A$19,1))
P26=INDEX(TENG!$B$4:$O$4,1,MATCH(I26,TENG!$A$6:$A$19,1))
P27=INDEX(TENG!$B$4:$O$4,1,MATCH(I27,TENG!$A$6:$A$19,1))
P28=INDEX(TENG!$B$4:$O$4,1,MATCH(I28,TENG!$A$6:$A$19,1))
P29=INDEX(TENG!$B$4:$O$4,1,MATCH(I29,TENG!$A$6:$A$19,1))
P30=INDEX(TENG!$B$4:$O$4,1,MATCH(I30,TENG!$A$6:$A$19,1))
P31=INDEX(TENG!$B$4:$O$4,1,MATCH(I31,TENG!$A$6:$A$19,1))
P32=INDEX(TENG!$B$4:$O$4,1,MATCH(I32,TENG!$A$6:$A$19,1))
P33=INDEX(TENG!$B$4:$O$4,1,MATCH(I33,TENG!$A$6:$A$19,1))
P34=INDEX(TENG!$B$4:$O$4,1,MATCH(I34,TENG!$A$6:$A$19,1))
P35=INDEX(TENG!$B$4:$O$4,1,MATCH(I35,TENG!$A$6:$A$19,1))
P36=INDEX(TENG!$B$4:$O$4,1,MATCH(I36,TENG!$A$6:$A$19,1))
P37=INDEX(TENG!$B$4:$O$4,1,MATCH(I37,TENG!$A$6:$A$19,1))
P38=INDEX(TENG!$B$4:$O$4,1,MATCH(I38,TENG!$A$6:$A$19,1))
P39=INDEX(TENG!$B$4:$O$4,1,MATCH(I39,TENG!$A$6:$A$19,1))
P40=INDEX(TENG!$B$4:$O$4,1,MATCH(I40,TENG!$A$6:$A$19,1))
P41=INDEX(TENG!$B$4:$O$4,1,MATCH(I41,TENG!$A$6:$A$19,1))
P42=INDEX(TENG!$B$4:$O$4,1,MATCH(I42,TENG!$A$6:$A$19,1))
P43=INDEX(TENG!$B$4:$O$4,1,MATCH(I43,TENG!$A$6:$A$19,1))
P44=INDEX(TENG!$B$4:$O$4,1,MATCH(I44,TENG!$A$6:$A$19,1))
P45=INDEX(TENG!$B$4:$O$4,1,MATCH(I45,TENG!$A$6:$A$19,1))
P46=INDEX(TENG!$B$4:$O$4,1,MATCH(I46,TENG!$A$6:$A$19,1))
Q21=INDEX(TENG!$B$4:$O$4,1,MATCH(I21,TENG!$A$6:$A$19,1)+1)
Q22=INDEX(TENG!$B$4:$O$4,1,MATCH(I22,TENG!$A$6:$A$19,1)+1)
Q23=INDEX(TENG!$B$4:$O$4,1,MATCH(I23,TENG!$A$6:$A$19,1)+1)
Q24=INDEX(TENG!$B$4:$O$4,1,MATCH(I24,TENG!$A$6:$A$19,1)+1)
Q25=INDEX(TENG!$B$4:$O$4,1,MATCH(I25,TENG!$A$6:$A$19,1)+1)
Q26=INDEX(TENG!$B$4:$O$4,1,MATCH(I26,TENG!$A$6:$A$19,1)+1)
Q27=INDEX(TENG!$B$4:$O$4,1,MATCH(I27,TENG!$A$6:$A$19,1)+1)
Q28=INDEX(TENG!$B$4:$O$4,1,MATCH(I28,TENG!$A$6:$A$19,1)+1)
Q29=INDEX(TENG!$B$4:$O$4,1,MATCH(I29,TENG!$A$6:$A$19,1)+1)
Q30=INDEX(TENG!$B$4:$O$4,1,MATCH(I30,TENG!$A$6:$A$19,1)+1)
Q31=INDEX(TENG!$B$4:$O$4,1,MATCH(I31,TENG!$A$6:$A$19,1)+1)
Q32=INDEX(TENG!$B$4:$O$4,1,MATCH(I32,TENG!$A$6:$A$19,1)+1)
Q33=INDEX(TENG!$B$4:$O$4,1,MATCH(I33,TENG!$A$6:$A$19,1)+1)
Q34=INDEX(TENG!$B$4:$O$4,1,MATCH(I34,TENG!$A$6:$A$19,1)+1)
Q35=INDEX(TENG!$B$4:$O$4,1,MATCH(I35,TENG!$A$6:$A$19,1)+1)
Q36=INDEX(TENG!$B$4:$O$4,1,MATCH(I36,TENG!$A$6:$A$19,1)+1)
Q37=INDEX(TENG!$B$4:$O$4,1,MATCH(I37,TENG!$A$6:$A$19,1)+1)
Q38=INDEX(TENG!$B$4:$O$4,1,MATCH(I38,TENG!$A$6:$A$19,1)+1)
Q39=INDEX(TENG!$B$4:$O$4,1,MATCH(I39,TENG!$A$6:$A$19,1)+1)
Q40=INDEX(TENG!$B$4:$O$4,1,MATCH(I40,TENG!$A$6:$A$19,1)+1)
Q41=INDEX(TENG!$B$4:$O$4,1,MATCH(I41,TENG!$A$6:$A$19,1)+1)
Q42=INDEX(TENG!$B$4:$O$4,1,MATCH(I42,TENG!$A$6:$A$19,1)+1)
Q43=INDEX(TENG!$B$4:$O$4,1,MATCH(I43,TENG!$A$6:$A$19,1)+1)
Q44=INDEX(TENG!$B$4:$O$4,1,MATCH(I44,TENG!$A$6:$A$19,1)+1)
Q45=INDEX(TENG!$B$4:$O$4,1,MATCH(I45,TENG!$A$6:$A$19,1)+1)
Q46=INDEX(TENG!$B$4:$O$4,1,MATCH(I46,TENG!$A$6:$A$19,1)+1)
R21=INDEX(TENG!$A$6:$A$19,MATCH(H21,TENG!$B$4:$O$4,1),1)
R22=INDEX(TENG!$A$6:$A$19,MATCH(H22,TENG!$B$4:$O$4,1),1)
R23=INDEX(TENG!$A$6:$A$19,MATCH(H23,TENG!$B$4:$O$4,1),1)
R24=INDEX(TENG!$A$6:$A$19,MATCH(H24,TENG!$B$4:$O$4,1),1)
R25=INDEX(TENG!$A$6:$A$19,MATCH(H25,TENG!$B$4:$O$4,1),1)
R26=INDEX(TENG!$A$6:$A$19,MATCH(H26,TENG!$B$4:$O$4,1),1)
R27=INDEX(TENG!$A$6:$A$19,MATCH(H27,TENG!$B$4:$O$4,1),1)
R28=INDEX(TENG!$A$6:$A$19,MATCH(H28,TENG!$B$4:$O$4,1),1)
R29=INDEX(TENG!$A$6:$A$19,MATCH(H29,TENG!$B$4:$O$4,1),1)
R30=INDEX(TENG!$A$6:$A$19,MATCH(H30,TENG!$B$4:$O$4,1),1)
R31=INDEX(TENG!$A$6:$A$19,MATCH(H31,TENG!$B$4:$O$4,1),1)
R32=INDEX(TENG!$A$6:$A$19,MATCH(H32,TENG!$B$4:$O$4,1),1)
R33=INDEX(TENG!$A$6:$A$19,MATCH(H33,TENG!$B$4:$O$4,1),1)
R34=INDEX(TENG!$A$6:$A$19,MATCH(H34,TENG!$B$4:$O$4,1),1)
R35=INDEX(TENG!$A$6:$A$19,MATCH(H35,TENG!$B$4:$O$4,1),1)
R36=INDEX(TENG!$A$6:$A$19,MATCH(H36,TENG!$B$4:$O$4,1),1)
R37=INDEX(TENG!$A$6:$A$19,MATCH(H37,TENG!$B$4:$O$4,1),1)
R38=INDEX(TENG!$A$6:$A$19,MATCH(H38,TENG!$B$4:$O$4,1),1)
R39=INDEX(TENG!$A$6:$A$19,MATCH(H39,TENG!$B$4:$O$4,1),1)
R40=INDEX(TENG!$A$6:$A$19,MATCH(H40,TENG!$B$4:$O$4,1),1)
R41=INDEX(TENG!$A$6:$A$19,MATCH(H41,TENG!$B$4:$O$4,1),1)
R42=INDEX(TENG!$A$6:$A$19,MATCH(H42,TENG!$B$4:$O$4,1),1)
R43=INDEX(TENG!$A$6:$A$19,MATCH(H43,TENG!$B$4:$O$4,1),1)
R44=INDEX(TENG!$A$6:$A$19,MATCH(H44,TENG!$B$4:$O$4,1),1)
R45=INDEX(TENG!$A$6:$A$19,MATCH(H45,TENG!$B$4:$O$4,1),1)
R46=INDEX(TENG!$A$6:$A$19,MATCH(H46,TENG!$B$4:$O$4,1),1)
S21=INDEX(TENG!$A$6:$A$19,MATCH(H21,TENG!$B$4:$O$4,1)+1,1)
S22=INDEX(TENG!$A$6:$A$19,MATCH(H22,TENG!$B$4:$O$4,1)+1,1)
S23=INDEX(TENG!$A$6:$A$19,MATCH(H23,TENG!$B$4:$O$4,1)+1,1)
S24=INDEX(TENG!$A$6:$A$19,MATCH(H24,TENG!$B$4:$O$4,1)+1,1)
S25=INDEX(TENG!$A$6:$A$19,MATCH(H25,TENG!$B$4:$O$4,1)+1,1)
S26=INDEX(TENG!$A$6:$A$19,MATCH(H26,TENG!$B$4:$O$4,1)+1,1)
S27=INDEX(TENG!$A$6:$A$19,MATCH(H27,TENG!$B$4:$O$4,1)+1,1)
S28=INDEX(TENG!$A$6:$A$19,MATCH(H28,TENG!$B$4:$O$4,1)+1,1)
S29=INDEX(TENG!$A$6:$A$19,MATCH(H29,TENG!$B$4:$O$4,1)+1,1)
S30=INDEX(TENG!$A$6:$A$19,MATCH(H30,TENG!$B$4:$O$4,1)+1,1)
S31=INDEX(TENG!$A$6:$A$19,MATCH(H31,TENG!$B$4:$O$4,1)+1,1)
S32=INDEX(TENG!$A$6:$A$19,MATCH(H32,TENG!$B$4:$O$4,1)+1,1)
S33=INDEX(TENG!$A$6:$A$19,MATCH(H33,TENG!$B$4:$O$4,1)+1,1)
S34=INDEX(TENG!$A$6:$A$19,MATCH(H34,TENG!$B$4:$O$4,1)+1,1)
S35=INDEX(TENG!$A$6:$A$19,MATCH(H35,TENG!$B$4:$O$4,1)+1,1)
S36=INDEX(TENG!$A$6:$A$19,MATCH(H36,TENG!$B$4:$O$4,1)+1,1)
S37=INDEX(TENG!$A$6:$A$19,MATCH(H37,TENG!$B$4:$O$4,1)+1,1)
S38=INDEX(TENG!$A$6:$A$19,MATCH(H38,TENG!$B$4:$O$4,1)+1,1)
S39=INDEX(TENG!$A$6:$A$19,MATCH(H39,TENG!$B$4:$O$4,1)+1,1)
S40=INDEX(TENG!$A$6:$A$19,MATCH(H40,TENG!$B$4:$O$4,1)+1,1)
S41=INDEX(TENG!$A$6:$A$19,MATCH(H41,TENG!$B$4:$O$4,1)+1,1)
S42=INDEX(TENG!$A$6:$A$19,MATCH(H42,TENG!$B$4:$O$4,1)+1,1)
S43=INDEX(TENG!$A$6:$A$19,MATCH(H43,TENG!$B$4:$O$4,1)+1,1)
S44=INDEX(TENG!$A$6:$A$19,MATCH(H44,TENG!$B$4:$O$4,1)+1,1)
S45=INDEX(TENG!$A$6:$A$19,MATCH(H45,TENG!$B$4:$O$4,1)+1,1)
S46=INDEX(TENG!$A$6:$A$19,MATCH(H46,TENG!$B$4:$O$4,1)+1,1)
T21=INDEX(TENG!$B$6:$O$19,MATCH(H21,TENG!$B$4:$O$4,1),MATCH(I21,TENG!$A$6:$A$19,1))
T22=INDEX(TENG!$B$6:$O$19,MATCH(H22,TENG!$B$4:$O$4,1),MATCH(I22,TENG!$A$6:$A$19,1))
T23=INDEX(TENG!$B$6:$O$19,MATCH(H23,TENG!$B$4:$O$4,1),MATCH(I23,TENG!$A$6:$A$19,1))
T24=INDEX(TENG!$B$6:$O$19,MATCH(H24,TENG!$B$4:$O$4,1),MATCH(I24,TENG!$A$6:$A$19,1))
T25=INDEX(TENG!$B$6:$O$19,MATCH(H25,TENG!$B$4:$O$4,1),MATCH(I25,TENG!$A$6:$A$19,1))
T26=INDEX(TENG!$B$6:$O$19,MATCH(H26,TENG!$B$4:$O$4,1),MATCH(I26,TENG!$A$6:$A$19,1))
T27=INDEX(TENG!$B$6:$O$19,MATCH(H27,TENG!$B$4:$O$4,1),MATCH(I27,TENG!$A$6:$A$19,1))
T28=INDEX(TENG!$B$6:$O$19,MATCH(H28,TENG!$B$4:$O$4,1),MATCH(I28,TENG!$A$6:$A$19,1))
T29=INDEX(TENG!$B$6:$O$19,MATCH(H29,TENG!$B$4:$O$4,1),MATCH(I29,TENG!$A$6:$A$19,1))
T30=INDEX(TENG!$B$6:$O$19,MATCH(H30,TENG!$B$4:$O$4,1),MATCH(I30,TENG!$A$6:$A$19,1))
T31=INDEX(TENG!$B$6:$O$19,MATCH(H31,TENG!$B$4:$O$4,1),MATCH(I31,TENG!$A$6:$A$19,1))
T32=INDEX(TENG!$B$6:$O$19,MATCH(H32,TENG!$B$4:$O$4,1),MATCH(I32,TENG!$A$6:$A$19,1))
T33=INDEX(TENG!$B$6:$O$19,MATCH(H33,TENG!$B$4:$O$4,1),MATCH(I33,TENG!$A$6:$A$19,1))
T34=INDEX(TENG!$B$6:$O$19,MATCH(H34,TENG!$B$4:$O$4,1),MATCH(I34,TENG!$A$6:$A$19,1))
T35=INDEX(TENG!$B$6:$O$19,MATCH(H35,TENG!$B$4:$O$4,1),MATCH(I35,TENG!$A$6:$A$19,1))
T36=INDEX(TENG!$B$6:$O$19,MATCH(H36,TENG!$B$4:$O$4,1),MATCH(I36,TENG!$A$6:$A$19,1))
T37=INDEX(TENG!$B$6:$O$19,MATCH(H37,TENG!$B$4:$O$4,1),MATCH(I37,TENG!$A$6:$A$19,1))
T38=INDEX(TENG!$B$6:$O$19,MATCH(H38,TENG!$B$4:$O$4,1),MATCH(I38,TENG!$A$6:$A$19,1))
T39=INDEX(TENG!$B$6:$O$19,MATCH(H39,TENG!$B$4:$O$4,1),MATCH(I39,TENG!$A$6:$A$19,1))
T40=INDEX(TENG!$B$6:$O$19,MATCH(H40,TENG!$B$4:$O$4,1),MATCH(I40,TENG!$A$6:$A$19,1))
T41=INDEX(TENG!$B$6:$O$19,MATCH(H41,TENG!$B$4:$O$4,1),MATCH(I41,TENG!$A$6:$A$19,1))
T42=INDEX(TENG!$B$6:$O$19,MATCH(H42,TENG!$B$4:$O$4,1),MATCH(I42,TENG!$A$6:$A$19,1))
T43=INDEX(TENG!$B$6:$O$19,MATCH(H43,TENG!$B$4:$O$4,1),MATCH(I43,TENG!$A$6:$A$19,1))
T44=INDEX(TENG!$B$6:$O$19,MATCH(H44,TENG!$B$4:$O$4,1),MATCH(I44,TENG!$A$6:$A$19,1))
T45=INDEX(TENG!$B$6:$O$19,MATCH(H45,TENG!$B$4:$O$4,1),MATCH(I45,TENG!$A$6:$A$19,1))
T46=INDEX(TENG!$B$6:$O$19,MATCH(H46,TENG!$B$4:$O$4,1),MATCH(I46,TENG!$A$6:$A$19,1))
U21=INDEX(TENG!$B$6:$O$19,MATCH(H21,TENG!$B$4:$O$4,1),MATCH(I21,TENG!$A$6:$A$19,1)+1)
U22=INDEX(TENG!$B$6:$O$19,MATCH(H22,TENG!$B$4:$O$4,1),MATCH(I22,TENG!$A$6:$A$19,1)+1)
U23=INDEX(TENG!$B$6:$O$19,MATCH(H23,TENG!$B$4:$O$4,1),MATCH(I23,TENG!$A$6:$A$19,1)+1)
U24=INDEX(TENG!$B$6:$O$19,MATCH(H24,TENG!$B$4:$O$4,1),MATCH(I24,TENG!$A$6:$A$19,1)+1)
U25=INDEX(TENG!$B$6:$O$19,MATCH(H25,TENG!$B$4:$O$4,1),MATCH(I25,TENG!$A$6:$A$19,1)+1)
U26=INDEX(TENG!$B$6:$O$19,MATCH(H26,TENG!$B$4:$O$4,1),MATCH(I26,TENG!$A$6:$A$19,1)+1)
U27=INDEX(TENG!$B$6:$O$19,MATCH(H27,TENG!$B$4:$O$4,1),MATCH(I27,TENG!$A$6:$A$19,1)+1)
U28=INDEX(TENG!$B$6:$O$19,MATCH(H28,TENG!$B$4:$O$4,1),MATCH(I28,TENG!$A$6:$A$19,1)+1)
U29=INDEX(TENG!$B$6:$O$19,MATCH(H29,TENG!$B$4:$O$4,1),MATCH(I29,TENG!$A$6:$A$19,1)+1)
U30=INDEX(TENG!$B$6:$O$19,MATCH(H30,TENG!$B$4:$O$4,1),MATCH(I30,TENG!$A$6:$A$19,1)+1)
U31=INDEX(TENG!$B$6:$O$19,MATCH(H31,TENG!$B$4:$O$4,1),MATCH(I31,TENG!$A$6:$A$19,1)+1)
U32=INDEX(TENG!$B$6:$O$19,MATCH(H32,TENG!$B$4:$O$4,1),MATCH(I32,TENG!$A$6:$A$19,1)+1)
U33=INDEX(TENG!$B$6:$O$19,MATCH(H33,TENG!$B$4:$O$4,1),MATCH(I33,TENG!$A$6:$A$19,1)+1)
U34=INDEX(TENG!$B$6:$O$19,MATCH(H34,TENG!$B$4:$O$4,1),MATCH(I34,TENG!$A$6:$A$19,1)+1)
U35=INDEX(TENG!$B$6:$O$19,MATCH(H35,TENG!$B$4:$O$4,1),MATCH(I35,TENG!$A$6:$A$19,1)+1)
U36=INDEX(TENG!$B$6:$O$19,MATCH(H36,TENG!$B$4:$O$4,1),MATCH(I36,TENG!$A$6:$A$19,1)+1)
U37=INDEX(TENG!$B$6:$O$19,MATCH(H37,TENG!$B$4:$O$4,1),MATCH(I37,TENG!$A$6:$A$19,1)+1)
U38=INDEX(TENG!$B$6:$O$19,MATCH(H38,TENG!$B$4:$O$4,1),MATCH(I38,TENG!$A$6:$A$19,1)+1)
U39=INDEX(TENG!$B$6:$O$19,MATCH(H39,TENG!$B$4:$O$4,1),MATCH(I39,TENG!$A$6:$A$19,1)+1)
U40=INDEX(TENG!$B$6:$O$19,MATCH(H40,TENG!$B$4:$O$4,1),MATCH(I40,TENG!$A$6:$A$19,1)+1)
U41=INDEX(TENG!$B$6:$O$19,MATCH(H41,TENG!$B$4:$O$4,1),MATCH(I41,TENG!$A$6:$A$19,1)+1)
U42=INDEX(TENG!$B$6:$O$19,MATCH(H42,TENG!$B$4:$O$4,1),MATCH(I42,TENG!$A$6:$A$19,1)+1)
U43=INDEX(TENG!$B$6:$O$19,MATCH(H43,TENG!$B$4:$O$4,1),MATCH(I43,TENG!$A$6:$A$19,1)+1)
U44=INDEX(TENG!$B$6:$O$19,MATCH(H44,TENG!$B$4:$O$4,1),MATCH(I44,TENG!$A$6:$A$19,1)+1)
U45=INDEX(TENG!$B$6:$O$19,MATCH(H45,TENG!$B$4:$O$4,1),MATCH(I45,TENG!$A$6:$A$19,1)+1)
U46=INDEX(TENG!$B$6:$O$19,MATCH(H46,TENG!$B$4:$O$4,1),MATCH(I46,TENG!$A$6:$A$19,1)+1)
V21=(U21-T21)/(Q21-P21)*(I21-P21)+T21
V22=(U22-T22)/(Q22-P22)*(I22-P22)+T22
V23=(U23-T23)/(Q23-P23)*(I23-P23)+T23
V24=(U24-T24)/(Q24-P24)*(I24-P24)+T24
V25=(U25-T25)/(Q25-P25)*(I25-P25)+T25
V26=(U26-T26)/(Q26-P26)*(I26-P26)+T26
V27=(U27-T27)/(Q27-P27)*(I27-P27)+T27
V28=(U28-T28)/(Q28-P28)*(I28-P28)+T28
V29=(U29-T29)/(Q29-P29)*(I29-P29)+T29
V30=(U30-T30)/(Q30-P30)*(I30-P30)+T30
V31=(U31-T31)/(Q31-P31)*(I31-P31)+T31
V32=(U32-T32)/(Q32-P32)*(I32-P32)+T32
V33=(U33-T33)/(Q33-P33)*(I33-P33)+T33
V34=(U34-T34)/(Q34-P34)*(I34-P34)+T34
V35=(U35-T35)/(Q35-P35)*(I35-P35)+T35
V36=(U36-T36)/(Q36-P36)*(I36-P36)+T36
V37=(U37-T37)/(Q37-P37)*(I37-P37)+T37
V38=(U38-T38)/(Q38-P38)*(I38-P38)+T38
V39=(U39-T39)/(Q39-P39)*(I39-P39)+T39
V40=(U40-T40)/(Q40-P40)*(I40-P40)+T40
V41=(U41-T41)/(Q41-P41)*(I41-P41)+T41
V42=(U42-T42)/(Q42-P42)*(I42-P42)+T42
V43=(U43-T43)/(Q43-P43)*(I43-P43)+T43
V44=(U44-T44)/(Q44-P44)*(I44-P44)+T44
V45=(U45-T45)/(Q45-P45)*(I45-P45)+T45
V46=(U46-T46)/(Q46-P46)*(I46-P46)+T46
W21=INDEX(TENG!$B$6:$O$19,MATCH(H21,TENG!$B$4:$O$4,1)+1,MATCH(I21,TENG!$A$6:$A$19,1))
W22=INDEX(TENG!$B$6:$O$19,MATCH(H22,TENG!$B$4:$O$4,1)+1,MATCH(I22,TENG!$A$6:$A$19,1))
W23=INDEX(TENG!$B$6:$O$19,MATCH(H23,TENG!$B$4:$O$4,1)+1,MATCH(I23,TENG!$A$6:$A$19,1))
W24=INDEX(TENG!$B$6:$O$19,MATCH(H24,TENG!$B$4:$O$4,1)+1,MATCH(I24,TENG!$A$6:$A$19,1))
W25=INDEX(TENG!$B$6:$O$19,MATCH(H25,TENG!$B$4:$O$4,1)+1,MATCH(I25,TENG!$A$6:$A$19,1))
W26=INDEX(TENG!$B$6:$O$19,MATCH(H26,TENG!$B$4:$O$4,1)+1,MATCH(I26,TENG!$A$6:$A$19,1))
W27=INDEX(TENG!$B$6:$O$19,MATCH(H27,TENG!$B$4:$O$4,1)+1,MATCH(I27,TENG!$A$6:$A$19,1))
W28=INDEX(TENG!$B$6:$O$19,MATCH(H28,TENG!$B$4:$O$4,1)+1,MATCH(I28,TENG!$A$6:$A$19,1))
W29=INDEX(TENG!$B$6:$O$19,MATCH(H29,TENG!$B$4:$O$4,1)+1,MATCH(I29,TENG!$A$6:$A$19,1))
W30=INDEX(TENG!$B$6:$O$19,MATCH(H30,TENG!$B$4:$O$4,1)+1,MATCH(I30,TENG!$A$6:$A$19,1))
W31=INDEX(TENG!$B$6:$O$19,MATCH(H31,TENG!$B$4:$O$4,1)+1,MATCH(I31,TENG!$A$6:$A$19,1))
W32=INDEX(TENG!$B$6:$O$19,MATCH(H32,TENG!$B$4:$O$4,1)+1,MATCH(I32,TENG!$A$6:$A$19,1))
W33=INDEX(TENG!$B$6:$O$19,MATCH(H33,TENG!$B$4:$O$4,1)+1,MATCH(I33,TENG!$A$6:$A$19,1))
W34=INDEX(TENG!$B$6:$O$19,MATCH(H34,TENG!$B$4:$O$4,1)+1,MATCH(I34,TENG!$A$6:$A$19,1))
W35=INDEX(TENG!$B$6:$O$19,MATCH(H35,TENG!$B$4:$O$4,1)+1,MATCH(I35,TENG!$A$6:$A$19,1))
W36=INDEX(TENG!$B$6:$O$19,MATCH(H36,TENG!$B$4:$O$4,1)+1,MATCH(I36,TENG!$A$6:$A$19,1))
W37=INDEX(TENG!$B$6:$O$19,MATCH(H37,TENG!$B$4:$O$4,1)+1,MATCH(I37,TENG!$A$6:$A$19,1))
W38=INDEX(TENG!$B$6:$O$19,MATCH(H38,TENG!$B$4:$O$4,1)+1,MATCH(I38,TENG!$A$6:$A$19,1))
W39=INDEX(TENG!$B$6:$O$19,MATCH(H39,TENG!$B$4:$O$4,1)+1,MATCH(I39,TENG!$A$6:$A$19,1))
W40=INDEX(TENG!$B$6:$O$19,MATCH(H40,TENG!$B$4:$O$4,1)+1,MATCH(I40,TENG!$A$6:$A$19,1))
W41=INDEX(TENG!$B$6:$O$19,MATCH(H41,TENG!$B$4:$O$4,1)+1,MATCH(I41,TENG!$A$6:$A$19,1))
W42=INDEX(TENG!$B$6:$O$19,MATCH(H42,TENG!$B$4:$O$4,1)+1,MATCH(I42,TENG!$A$6:$A$19,1))
W43=INDEX(TENG!$B$6:$O$19,MATCH(H43,TENG!$B$4:$O$4,1)+1,MATCH(I43,TENG!$A$6:$A$19,1))
W44=INDEX(TENG!$B$6:$O$19,MATCH(H44,TENG!$B$4:$O$4,1)+1,MATCH(I44,TENG!$A$6:$A$19,1))
W45=INDEX(TENG!$B$6:$O$19,MATCH(H45,TENG!$B$4:$O$4,1)+1,MATCH(I45,TENG!$A$6:$A$19,1))
W46=INDEX(TENG!$B$6:$O$19,MATCH(H46,TENG!$B$4:$O$4,1)+1,MATCH(I46,TENG!$A$6:$A$19,1))
X21=INDEX(TENG!$B$6:$O$19,MATCH(H21,TENG!$B$4:$O$4,1)+1,MATCH(I21,TENG!$A$6:$A$19,1)+1)
X22=INDEX(TENG!$B$6:$O$19,MATCH(H22,TENG!$B$4:$O$4,1)+1,MATCH(I22,TENG!$A$6:$A$19,1)+1)
X23=INDEX(TENG!$B$6:$O$19,MATCH(H23,TENG!$B$4:$O$4,1)+1,MATCH(I23,TENG!$A$6:$A$19,1)+1)
X24=INDEX(TENG!$B$6:$O$19,MATCH(H24,TENG!$B$4:$O$4,1)+1,MATCH(I24,TENG!$A$6:$A$19,1)+1)
X25=INDEX(TENG!$B$6:$O$19,MATCH(H25,TENG!$B$4:$O$4,1)+1,MATCH(I25,TENG!$A$6:$A$19,1)+1)
X26=INDEX(TENG!$B$6:$O$19,MATCH(H26,TENG!$B$4:$O$4,1)+1,MATCH(I26,TENG!$A$6:$A$19,1)+1)
X27=INDEX(TENG!$B$6:$O$19,MATCH(H27,TENG!$B$4:$O$4,1)+1,MATCH(I27,TENG!$A$6:$A$19,1)+1)
X28=INDEX(TENG!$B$6:$O$19,MATCH(H28,TENG!$B$4:$O$4,1)+1,MATCH(I28,TENG!$A$6:$A$19,1)+1)
X29=INDEX(TENG!$B$6:$O$19,MATCH(H29,TENG!$B$4:$O$4,1)+1,MATCH(I29,TENG!$A$6:$A$19,1)+1)
X30=INDEX(TENG!$B$6:$O$19,MATCH(H30,TENG!$B$4:$O$4,1)+1,MATCH(I30,TENG!$A$6:$A$19,1)+1)
X31=INDEX(TENG!$B$6:$O$19,MATCH(H31,TENG!$B$4:$O$4,1)+1,MATCH(I31,TENG!$A$6:$A$19,1)+1)
X32=INDEX(TENG!$B$6:$O$19,MATCH(H32,TENG!$B$4:$O$4,1)+1,MATCH(I32,TENG!$A$6:$A$19,1)+1)
X33=INDEX(TENG!$B$6:$O$19,MATCH(H33,TENG!$B$4:$O$4,1)+1,MATCH(I33,TENG!$A$6:$A$19,1)+1)
X34=INDEX(TENG!$B$6:$O$19,MATCH(H34,TENG!$B$4:$O$4,1)+1,MATCH(I34,TENG!$A$6:$A$19,1)+1)
X35=INDEX(TENG!$B$6:$O$19,MATCH(H35,TENG!$B$4:$O$4,1)+1,MATCH(I35,TENG!$A$6:$A$19,1)+1)
X36=INDEX(TENG!$B$6:$O$19,MATCH(H36,TENG!$B$4:$O$4,1)+1,MATCH(I36,TENG!$A$6:$A$19,1)+1)
X37=INDEX(TENG!$B$6:$O$19,MATCH(H37,TENG!$B$4:$O$4,1)+1,MATCH(I37,TENG!$A$6:$A$19,1)+1)
X38=INDEX(TENG!$B$6:$O$19,MATCH(H38,TENG!$B$4:$O$4,1)+1,MATCH(I38,TENG!$A$6:$A$19,1)+1)
X39=INDEX(TENG!$B$6:$O$19,MATCH(H39,TENG!$B$4:$O$4,1)+1,MATCH(I39,TENG!$A$6:$A$19,1)+1)
X40=INDEX(TENG!$B$6:$O$19,MATCH(H40,TENG!$B$4:$O$4,1)+1,MATCH(I40,TENG!$A$6:$A$19,1)+1)
X41=INDEX(TENG!$B$6:$O$19,MATCH(H41,TENG!$B$4:$O$4,1)+1,MATCH(I41,TENG!$A$6:$A$19,1)+1)
X42=INDEX(TENG!$B$6:$O$19,MATCH(H42,TENG!$B$4:$O$4,1)+1,MATCH(I42,TENG!$A$6:$A$19,1)+1)
X43=INDEX(TENG!$B$6:$O$19,MATCH(H43,TENG!$B$4:$O$4,1)+1,MATCH(I43,TENG!$A$6:$A$19,1)+1)
X44=INDEX(TENG!$B$6:$O$19,MATCH(H44,TENG!$B$4:$O$4,1)+1,MATCH(I44,TENG!$A$6:$A$19,1)+1)
X45=INDEX(TENG!$B$6:$O$19,MATCH(H45,TENG!$B$4:$O$4,1)+1,MATCH(I45,TENG!$A$6:$A$19,1)+1)
X46=INDEX(TENG!$B$6:$O$19,MATCH(H46,TENG!$B$4:$O$4,1)+1,MATCH(I46,TENG!$A$6:$A$19,1)+1)
Y21=(W21-X21)/(P21-Q21)*(H21-P21)+W21
Y22=(W22-X22)/(P22-Q22)*(H22-P22)+W22
Y23=(W23-X23)/(P23-Q23)*(H23-P23)+W23
Y24=(W24-X24)/(P24-Q24)*(H24-P24)+W24
Y25=(W25-X25)/(P25-Q25)*(H25-P25)+W25
Y26=(W26-X26)/(P26-Q26)*(H26-P26)+W26
Y27=(W27-X27)/(P27-Q27)*(H27-P27)+W27
Y28=(W28-X28)/(P28-Q28)*(H28-P28)+W28
Y29=(W29-X29)/(P29-Q29)*(H29-P29)+W29
Y30=(W30-X30)/(P30-Q30)*(H30-P30)+W30
Y31=(W31-X31)/(P31-Q31)*(H31-P31)+W31
Y32=(W32-X32)/(P32-Q32)*(H32-P32)+W32
Y33=(W33-X33)/(P33-Q33)*(H33-P33)+W33
Y34=(W34-X34)/(P34-Q34)*(H34-P34)+W34
Y35=(W35-X35)/(P35-Q35)*(H35-P35)+W35
Y36=(W36-X36)/(P36-Q36)*(H36-P36)+W36
Y37=(W37-X37)/(P37-Q37)*(H37-P37)+W37
Y38=(W38-X38)/(P38-Q38)*(H38-P38)+W38
Y39=(W39-X39)/(P39-Q39)*(H39-P39)+W39
Y40=(W40-X40)/(P40-Q40)*(H40-P40)+W40
Y41=(W41-X41)/(P41-Q41)*(H41-P41)+W41
Y42=(W42-X42)/(P42-Q42)*(H42-P42)+W42
Y43=(W43-X43)/(P43-Q43)*(H43-P43)+W43
Y44=(W44-X44)/(P44-Q44)*(H44-P44)+W44
Y45=(W45-X45)/(P45-Q45)*(H45-P45)+W45
Y46=(W46-X46)/(P46-Q46)*(H46-P46)+W46
Z21=(V21-Y21)/(R21-S21)*(H21-R21)+V21
Z22=(V22-Y22)/(R22-S22)*(H22-R22)+V22
Z23=(V23-Y23)/(R23-S23)*(H23-R23)+V23
Z24=(V24-Y24)/(R24-S24)*(H24-R24)+V24
Z25=(V25-Y25)/(R25-S25)*(H25-R25)+V25
Z26=(V26-Y26)/(R26-S26)*(H26-R26)+V26
Z27=(V27-Y27)/(R27-S27)*(H27-R27)+V27
Z28=(V28-Y28)/(R28-S28)*(H28-R28)+V28
Z29=(V29-Y29)/(R29-S29)*(H29-R29)+V29
Z30=(V30-Y30)/(R30-S30)*(H30-R30)+V30
Z31=(V31-Y31)/(R31-S31)*(H31-R31)+V31
Z32=(V32-Y32)/(R32-S32)*(H32-R32)+V32
Z33=(V33-Y33)/(R33-S33)*(H33-R33)+V33
Z34=(V34-Y34)/(R34-S34)*(H34-R34)+V34
Z35=(V35-Y35)/(R35-S35)*(H35-R35)+V35
Z36=(V36-Y36)/(R36-S36)*(H36-R36)+V36
Z37=(V37-Y37)/(R37-S37)*(H37-R37)+V37
Z38=(V38-Y38)/(R38-S38)*(H38-R38)+V38
Z39=(V39-Y39)/(R39-S39)*(H39-R39)+V39
Z40=(V40-Y40)/(R40-S40)*(H40-R40)+V40
Z41=(V41-Y41)/(R41-S41)*(H41-R41)+V41
Z42=(V42-Y42)/(R42-S42)*(H42-R42)+V42
Z43=(V43-Y43)/(R43-S43)*(H43-R43)+V43
Z44=(V44-Y44)/(R44-S44)*(H44-R44)+V44
Z45=(V45-Y45)/(R45-S45)*(H45-R45)+V45
Z46=(V46-Y46)/(R46-S46)*(H46-R46)+V46
F30=((F22*F23)*F25+((F22*F23+F27*F28)*0.5*(F24-F25)))*25
F32=F22*F23*($I$10-F25)*$I$9
F43=((F35*F36)*F38+((F35*F36+F40*F41)*0.5*(F37-F38)))*25
F45=F35*F36*($I$10-F38)*$I$9
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,215,006
Messages
6,122,666
Members
449,091
Latest member
peppernaut

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top