MOVLOADS.xls

Rating:
15

Description


"MOVLOADS" is a spreadsheet program written in MS-Excel for the purpose of analysis of simple-span members subjected to from one (1) up to eight (8) moving wheel loads with up to seven (7) wheel spacings.  Specifically, the maximum moment and location from the left end of the member and wheel postioning, the maximum end shears, the maximum deflection, and the maximum center support reaction for two (2) adjacent simple-span members are calculated.
This program is a workbook consisting of two (2) worksheets, described as follows:
Worksheet Name
Doc
Moving Loads
Program Assumptions and Limitations:
1.   The following references were used in the development of this program (see below):
     a. "Modern Formulas for Statics and Dynamics, A Stress-and-Strain Approach" by Walter D. Pilkey and Pin Yu Chang, McGraw-Hill Book Company (1978), pages 11 to 21.
     b. AISC 9th Edition Allowable Stress (ASD) Manual (1989), pages 2-298 and 2-310.
2.   This program uses the three (3) following assumptions as a basis for analysis:
     a.  Beams must be of constant cross section (E and I are constant for entire span length).
     b.  Deflections must not significantly alter the geometry of the problem.
     c.  Stress must remain within the "elastic" region.
3.   To determine the value of the maximum moment and location from the left end of the left span for either only one (1) or two (2) wheel loads, those values are calculated directly by formulas.
4.   To determine the value of the maximum moment and location from the left end of the left span for three (3) up to eight (8) wheel loads, the group of wheel loads is positioned with wheel load P1 situated directly over the left support.  Then the group is moved to the right in 1/200*span increments, and the left and right reactions as well as the moments under each of the wheel loads are calculated.  In moving the group of wheel loads incrementally from left to right, any wheels that would drop off of the span are done so.  Then this entire procedure is mirrored for the opposite direction, from right to left.

Calculation Preview

Submitted On:
26 Nov 2019
File Size:
455.00 Kb
Downloads:
662
File Version:
1.3
File Author:
Alex Tomanovich
Rating:
15

 
This download is for Registered Users Only.
Perhaps you need to login or register.
Comments: 4
ATomanovich 7 months ago
In my MOVLOADS.xls spreadsheet, for the case of 2 equal moving loads with the spacing being 0.586*L, there are 2 possible positions for the pair of wheels to produce the maximum moment. Depending of the results of the MATCH and VLOOKUP commands that were utilized, sometimes the first position is found and other times the second position is found. The spreadsheet was not always correctly matching the “x” distance from the left end with the appropriate wheel load, either P1 or P2. This has now been corrected for the special case of 2 moving loads, whether the 2 loads are equal or unequal, and the current version is 1.3.
ATomanovich 5 years ago
Dear Sir,
Please include negative bending moment values for two trucks of same configuration but with variable headway distance between them.
Thank you
ATomanovich 7 years ago
While recently using the "MOVELOADS.xls" spreadsheet workbook for moving loads analysis, I inadvertently discovered that the program does not work properly for wheels loads that are input with negative ( < 0 ) values.
Thus, I added the user input data validation to restrict the input values of the wheel loads to values greater than 0.
This workbook is now version 1.2.
ATomanovich 11 years ago
I re-formatted the appearance of the "MOVLOADS.xls" workbook calculation worksheet to make it easier to visually distinguish which wheel spacings correspond to what wheel loads. In doing this, I oriented the page to landscape mode instead of portrait mode.
I also added some input data validation to restrict the input value of the Right Span (L2) to always be <= the Left Span (L1). This because the maximum moment, shear, and deflection calculations are only performed for the Left Span (L1). The only purpose of the Right Span (L2) is for determining the maximum column reaction at the center support between the two (2) simple span beams.
Finally, I added a "CAUTION" message off of the calculation page to the right and a pop up message on the calculation page to alert the user that when the sum of the wheel spacings >= the Left Span (L1), then user must input all other possible groupings of wheel loads/spacings that will fit on the Left Span (L1) to assure that the maximum moment has been determined. The only exception is the case for all equal wheel loads with all equal wheel spacings.