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
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
Cell Formulas | ||
---|---|---|
Range | Formula | |
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 |