Section properties excel spreadsheet
Section properties excel spreadsheet
(OP)
Can anyone recommend a good quality, free, section properties calculation tool available in excel?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you an
Engineering professional? Join EngTips Forums!
*EngTips's functionality depends on members receiving email. By joining you are opting in to receive email. Posting Guidelines 

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love EngTips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Section properties excel spreadsheet
http://newtonexcelbach.wordpress.com/2008/03/25/se...
is pretty good.
Please let me know if you have any questions or suggestions for improvement.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
RE: Section properties excel spreadsheet
RE: Section properties excel spreadsheet
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
Dik
RE: Section properties excel spreadsheet
Mike McCann
MMC Engineering
http://mmcengineering.tripod.com
RE: Section properties excel spreadsheet
I was thinking more on the lines of Ibeams and hollow sections.. What your are talking about is bit more complex.. Archon at $40.00 has a rather decent program for doing these things.... Not easy BUT cheap!! www.archoneng.com.
RE: Section properties excel spreadsheet
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
RE: Section properties excel spreadsheet
Not sure how I'd handle that automatically. Wouldn't it be better to leave it to the user to adjust the shapes according to their own requirements?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
RE: Section properties excel spreadsheet
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
Regards.
Analysis and Design of arbitrary cross sections
Reinforcement design to all major codes
Moment Curvature analysis
http://www.engissol.com/crosssectionanalysisdes...
RE: Section properties excel spreadsheet
Not really, this is well within the capabilities availbale within Excel. The only difficulty was applying a correct algorithm, but having thought about it that's not too difficult either. The only remaining problem is finding some spare time to actually do it.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
RE: Section properties excel spreadsheet
Dik
RE: Section properties excel spreadsheet
It includes both lookup to get the equations for typical shapes (see DefShapes tab) as well as ability to analyse nontypical userdefined shapes.
=====================================
(2B)+(2B)' ?
RE: Section properties excel spreadsheet
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
His HP48G app does section properties of known shapes or outlines of described shapes.
Jim H
RE: Section properties excel spreadsheet
http://newtonexcelbach.wordpress.com/2013/04/12/se...
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
there's a thought (for a friday afternoon) ... if time dilates, you'd think slower ... wouldn't you ? you're aging slower, an experienced second is 1 minute to someone outside the rocket ship ... so i got to ... if you're aging slower, your metabolism is slower, you eat, breathe (or poop) slower, you'd think and work slower (you'd accomplish 1 second's work in 1 experienced second).
Quando Omni Flunkus Moritati
RE: Section properties excel spreadsheet
Every once in a blue moon, I have a 'hollow' shape where the hole and the section do not have the same center of mass. It would be cool if AutoCAD could perform the parallel axis calculations. I am sure somebody who knows LISP has already created the routine...
RE: Section properties excel spreadsheet
 Define the exterior shape with a pline, working clockwise.
 Extend the pline to any point on the interior void.
 Define the void shape, working anticlockwise.
 Extend the pline back to the starting point on the outer shape.
As long as the two lines connecting the inner and outer shapes are exactly coincident, and the shapes are defined in opposite directions, the result should give the correct section properties.
Probably a good idea to check the results with a spreadsheet though :)
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
=====================================
(2B)+(2B)' ?
RE: Section properties excel spreadsheet
Makes it obvious why you should go around the void in the opposite direction to the outer shape.
I meant to add that the same method works with any computation based on coordinates, either CAD or spreadsheet based.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Section properties excel spreadsheet
Acad can also find properties of complicated shapes. To remove a hole: region both shapes, them pick modify, solid editing, subtract.
I will hatch the new region to verify I have created the correct cross section.