Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Section properties excel spreadsheet 4
- Thread starter DJWNZ101
- Start date
-
2
- #2
I may be biased, but I think the spreadsheet at:
is pretty good.
Please let me know if you have any questions or suggestions for improvement.
Doug Jenkins
Interactive Design Services
is pretty good.
Please let me know if you have any questions or suggestions for improvement.
Doug Jenkins
Interactive Design Services
MiketheEngineer
Structural
I wrote my own - took like three minutes??
- Thread starter
- #4
Thanks, trying it right now. It is possible to combine basic shapes to create some more complex sections? I am working with repairs to aircraft fuselage stringers, so my starting point is a top hat section with flanged edges, to which I am attaching c-section extrusions either side, then maybe a L-extrusion in the corners etc etc. Get the idea? All of the sections I am creating can be broken down into rectangle.
For complex shapes you have to define the shape with coordinates (on the Coords sheet) at the moment. I'm thinking about adding routines to allow simple shapes to be combined, but other things have priority at the moment. It's open source, so maybe MiketheEngineer might like to spend a couple of minutes doing it for us. 
Doug Jenkins
Interactive Design Services
Doug Jenkins
Interactive Design Services
msquared48
Structural
HP used to have one in their Structural X package for the 41C and CX.
Mike McCann
MMC Engineering
Mike McCann
MMC Engineering
MiketheEngineer
Structural
IDS -
I was thinking more on the lines of I-beams 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!!
I was thinking more on the lines of I-beams 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!!
Mike - it's not really the cost, I just enjoy doing these things myself. I think I'll have a go at adding the feature to combine shapes to my spreadsheet when I have some spare time. Not a 3 minute job, but not a huge amount of work either.
Doug Jenkins
Interactive Design Services
Doug Jenkins
Interactive Design Services
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
I'll give it some thought. If anyone has any comments on how this is handled in different software, I'd be interested.
Doug Jenkins
Interactive Design Services
Doug Jenkins
Interactive Design Services
johnbridge231
Civil/Environmental
Such calculations may be very complex for application in excel. The sectional properties of polygonal sections can be calculated using the Green's theorem. You may try using another program or use a more advanced programming environment for such tasks, for example C# etc.
Regards.
Analysis and Design of arbitrary cross sections
Reinforcement design to all major codes
Moment Curvature analysis
Regards.
Analysis and Design of arbitrary cross sections
Reinforcement design to all major codes
Moment Curvature analysis
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
-
1
- #16
electricpete
Electrical
The question was answered admirably by IDS. I've had his spreadsheet stored in a handy location for the last 4 years and consulted it often.
It includes both look-up to get the equations for typical shapes (see DefShapes tab) as well as ability to analyse non-typical user-defined shapes.
=====================================
(2B)+(2B)' ?
It includes both look-up to get the equations for typical shapes (see DefShapes tab) as well as ability to analyse non-typical user-defined shapes.
=====================================
(2B)+(2B)' ?
Thanks Pete. I think I might make an update my next project, with:
[ul]
[li]Function to combine shapes into a compound shape[/li]
[li]Provision for input of modular ratios[/li]
[li]Allow shapes within another shape to be specified as either additive or displacing[/li]
[li]Plotting function for compound shapes[/li]
[li]Not sure about torsion constants. Quite difficult to do properly I think[/li]
[/ul]
Doug Jenkins
Interactive Design Services
[ul]
[li]Function to combine shapes into a compound shape[/li]
[li]Provision for input of modular ratios[/li]
[li]Allow shapes within another shape to be specified as either additive or displacing[/li]
[li]Plotting function for compound shapes[/li]
[li]Not sure about torsion constants. Quite difficult to do properly I think[/li]
[/ul]
Doug Jenkins
Interactive Design Services
jimstructures
Structural
In the AISC Steel Tools site under Alex Tomanovich's excellent list of spreadsheets is SECTPROP.xlsx which is similar to his useful app for the HP48G and HP50G.
His HP48G app does section properties of known shapes or outlines of described shapes.
Jim H
His HP48G app does section properties of known shapes or outlines of described shapes.
Jim H
- Status