LineSec.xls
 

Description:

"LINESEC" - SECTION PROPERTY CALCULATION FOR SECTIONS DEFINED BY LINES

Program Description:
"LINESEC" is a spreadsheet program written in MS-Excel for the purpose of calculating the section properties of any section comprising lines.

Program Assumptions and Limitations:
1.  This program will calculate the centroid location, total cross-sectional area, moments of inertia, and radii of gyration for the centroidal axes and the principal axes if applicable.  The value of the rotation angle between the centroidal and principal axes is also calculated.
2.  Units are any consistent set of units the user desires.

Calculation Procedure:
1.  Use 'TabCalc' worksheet to define section. First define points in the xy co-ordinate system (up to 25 points - only update cells with yellow background). Define line thickness and start point and end point of lines (up to 25 lines possible using cells with green background).
2.  Your section will be drawn at the top of 'SecCalc' worksheet. You will need to adjust the aspect ratio of the chart (height to width ratio) so that the x scale equals the y scale other wise your section will appear to be skew. You may also adjust the line thickness scale factor for clarity.
3. If your section is not symmetric you will also be able to view the principal axis of the section.
4. In the section headed 'Stress Evaluation' you can apply loads to the section and calculate the stress at any location.
5. A chart is used to show stress at corner locations of each line.

Application:
1. The workbook is useful for assessment of sections made from fabricated plates.
2. The workbook is also useful for the assessment of weld lines.

Calculation Reference
Beam calculation
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Structural analysis
| 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:

31 May 2011

Submitted By:

JohnDoyle

File Date:

31 May 2011

File Version:

1.1

File Size:

326.50 Kb

File Type:

xls

XLC:

This download requires the XLC Add-in for Excel to be installed.

Downloads:

140

Rating:

Total Votes:1

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=472">ExcelCalcs.com calculation LineSec.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=472">ExcelCalcs.com</a> website.<br /></span><iframe id="ExcelCalcsSample472" name="ExcelCalcsSample472" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=472" align="top" scrolling="auto" height="650" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>

Like This?:

View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.

Need Help?:

Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Comments  

 

#1 AFingle 2009-04-01 07:30

Fantastic - minimal input required (start and end points only) its very fast. Well done.

 

Refresh comments list
RSS feed for comments to this post

Please sign in or register to add a comment.

JComments