绘制任意跨连续梁上任一截面处的弯矩剪力变形影响线.xlsVIP

Solver Input AnalysisOption ChartMenuRange D_IL DiagramLink EI getLine L LineArea LoadSpan LoadX M_IL m10x10 Moment Msimple Msup Nsections Nspans OptionButton15_Click OptionButton16_Click p1x10 Pier_or_Span .00 .00 1.00 Reactions SectionSpan SectionX Shear V_IL X X_Global_Big XGLOBAL XLoc1 Span No. Span Length: Stiffness EI Stiffness Matrix [d] Point load in span Distance from the beginning of span: Load Vector [Dp] [Dp] -X(L-X)/(6LEI): Section in span Mp M = Vp V = Span X-Local X-Global Bending Moment Shear Force INFLUENCE LINES IN CONTINUOUS BEAMS Moment Shear RESULTS Defined Ranges deltaP =OFFSET(p1x10,0,0,1,Nspans-1) DiagramLink =Input!$I$13 EI =Input!$G$5:$P$5 InfluenceLine L =Input!$G$4:$P$4 LoadSpan =Solver!$E$17 LoadX =Solver!$E$18 M_IL =OFFSET(X_Global,,3) m10x10 =Solver!$B$6:$J$14 matrix =OFFSET(m10x10,0,0,Nspans-1,Nspans-1) =Solver!$B$30 Nsections =Input!$D$5 Nspans =Input!$D$4 p1x10 =Solver!$B$21:$J$21 SectionSpan =Solver!$E$24 SectionX =Solver!$E$25 =Solver!$B$35 V_IL =OFFSET(X_Global,,4) X X_Global =OFFSET(X_Global_Big,,,COUNT(X_Global_Big)) X_Global_Big =Input!$A$18:$A$848 XGLOBAL =Input!$A$18:$A$61 XLoc1 =Input!$C$17 Number of Spans ( =10 ): No. of Sections in Span (=30): Maximum Value: Minimum Value: Positive Area: Negative Area: Total Area: Simple span moments in statically determined structure Msup =Solver!$B$22:$J$22 Moment in simple beam under Point load: Msimple= Msimple =Solver!$H$18 Deflections D_IL =OFFSET(X_Global,,5) =CHOOSE(DiagramLink,M_IL,V_IL,D_IL) Piers Analysis Option R = Msup/Li-1 Msup/Li Piers Reaction Msup/L Reaction in statically determined structure Reaction Total Reactions 1.00 1.00 2.00 3.00 1.00 2.00 1.00 1.00 3.00 4.00 1.00 .00 .00 5.00 2.00 .02 6.00 3.00 .00 .00 8.33E-03 7.00 8.00 9.00 10.00 11.00 4.00 40.00 .00 1.00 .00 2.00 .00 .00 .00 2.00 .00 .00 .00 2.00 .00 .00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 .00