MOVLOADS.xls
 

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.
CAUTION: When the sum of all of the wheel spacings > L1, then user must input all other possible groupings of wheel loads/spacings <= L1 to assure that the maximum moment has been determined.  The only exception to this is the case for all equal wheel loads with all equal wheel spacings.  
The Left Span (L1) must always be >= the Right Span (L2).  
5.   To determine the value of the maximum reaction at the center support of 2 adjacent simple spans, the group of wheels is positioned with the right most wheel load situated directly over the center support.  Then the  group is moved to the right, one wheel position at a time, until the left most wheel load, P1, is positioned directly over the center support.  In moving the group of wheel loads one wheel position at a time from left to right, any wheels at either end that would drop off of the span(s) are done so.
6.   The calculated value for the maximum deflection is determined from dividing the beam into fifty (50) equal segments with fifty-one (51) points, and including all of the point load locations as well.  (Note: the actual point of maximum deflection is where the slope = 0.)  
7.   The user is given the ability to input two (2) specific locations from the left end of the beam to calculate the shear, moment, slope, and deflection.
8.  This program contains “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc.  (Note:  presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell.  Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box".)

Calculation Reference
AISC- American Society For Civil Engineers
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:

10 Feb 2009

Submitted By:

ATomanovich

File Date:

10 Feb 2009

File Author:

Alex Tomanovich

File Version:

1.1

File Size:

392.00 Kb

File Type:

xls

Downloads:

441

Rating:

Total Votes:8

Like this?:

More submitted by this user.

HTML Link:

Copy code below to your web page to create link to this page:

<a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=292">ExcelCalcs.com calculation MOVLOADS.xls</a>

HTML Window:

Copy code below to your web page to create a dynamic window to this download:

<span style="font-size: 8pt">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=292">ExcelCalcs.com</a> website.<br /></span><iframe id="ExcelCalcsSample292" name="ExcelCalcsSample292" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=292" align="top" scrolling="auto" height="650" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>

Comments  

 

#1 MSH 2008-09-09 16:24

After I used, benefited, and enjoyed your spreadsheets, finally I found the time to say,

 

Refresh comments list
RSS feed for comments to this post

Please sign in or register to add a comment.

JComments