涵洞八字墙计算公式

涵洞八字墙计算公式

帽缘缘石砼=(Q6+R6+涵长计算!E6+0.1)*0.2*0.35*2

隔水墙=(Y6*TAN(RADIANS(K6))+Y6*TAN(RADIANS(ABS(L6)))+涵长计算!E6+0.4)*F6*0.4*2

洞身铺砌=涵长计算!Y6*涵长计算!E6*J6

洞口铺砌=(Y6*TAN(RADIANS(K6))+2*涵长计算!E6/COS(RADIANS(涵长计算!C6))+Y6*TAN(RADIANS(ABS(L6))))*Y6*J6

V =Z6+AA6

V基= =(D6*(Q6+U6+W6)*(N6-M6)*G6+D6/(2*O6)*(N6^2-M6^2)*G6)*2+(D6*(R6+V6+X6)*(N6-M6)*G6+D6/(2*P6)*(N6^2-M6^2)*G6)*2

V身= =(1/2*Q6*D6*(N6^2-M6^2)+D6/(6*O6)*(N6^3-M6^3))*2+(1/2*R6*D6*(N6^2-M6^2)+D6/(6*P6)*(N6^3-M6^3))*2

G= =D6*(N6-M6)

e2正翼墙= =I6/COS((A TAN(TAN(RADIANS(K6))-1/(D6*O6))))

e2反翼墙= =IF(L6<0,I6/COS((A TAN(TAN(RADIANS(ABS(L6)))+1/(D6*P6)))),I6/COS((ATAN(TAN(RADIANS(ABS(L6)))-1/(D6*P6)))))

e1正翼墙= =I6/COS(RADIANS(K6))

e1反翼墙= =I6/COS(RADIANS(L6))

c1正= =Q6+N6/O6

c1反= =R6+N6/P6

c正= =H6/(COS(RADIANS(K6)))

c反= =H6/(COS(RADIANS(L6)))

n0正= =(E6+SIN(RADIANS(K6))/D6)*COS(RADIANS(K6))

n0反= =IF(L6<0,(E6-SIN(RADIANS(ABS(L6)))/D6)*COS(RADIANS(L6)),(E6+SIN(RADIANS(ABS(L6)))/D6)*COS(RADIANS(L6)))

H= =涵长计算!F6+涵长计算!G6+F6-G6

h= =F6-G6+0.2

β1= =IF(C6<10,30,IF(C6>=30,55,35))

β2 =IF(C6<10,30,IF(C6>=30,-20,0))

涵长计算

净跨径L0= =IF(D6<3,D6-0.4,D6-0.6)

路肩标高左侧=

=IF(N6=0,K6+(B6-S6*TAN(RADIANS(C6))-J6)*L6-P6*(S6-R6/2),K6+(B6-S6*TAN(RADIANS(C6))-J6)*L6+(M6-ABS(B6-S6*TAN(RADIANS(C6))-J6))^2/(2*N6))-P6*(S6-R6/2)

路肩标高右侧=

=IF(N6=0,K6+(B6+T6*TAN(RADIANS(C6))-J6)*L6-Q6*(T6-R6/2),K6+(B6+T6*TAN(RADIANS(C6))-J6)*L6+(M6-ABS(B6+T6*TAN(RADIANS(C6))-J6))^2/(2*N6))-Q6*(T6-R6/

2)

涵长L左=(S6+O6*(U6-H6-F6-G6))/(COS(RADIANS(C6))+O6*I6) 涵长L右=(T6+O6*(V6-H6-F6-G6))/(COS(RADIANS(C6))-O6*I6) 涵长L全长=W6+X6