Aluminum Member Design
Aluminum Member Design
(OP)
Has anyone else, at one time or another, pulled their hair out trying to develop spreadsheet-based design of aluminum members? The elements of welded aluminum members are the worst! Any good ideas out there? Currently, I am working around a multi-workbook set-up where you progress from general input workbook through material prop file, flexural, etc. All the workbooks are linked together, but I find the relative links to be a pain in the arse. I constantly am having to re-connect links that I thought were supposed to be relative. Maybe there is an excel setting that I am missing for forcing relative links to remain as such?
-Mac






RE: Aluminum Member Design
Nearly all men can stand adversity, but if you want to test a man's character, give him power. Abraham Lincoln
RE: Aluminum Member Design
Excel spreadsheets can get VERY large before they bog down modern computers, as long as you're using simple value calls and not a ton of macros.
RE: Aluminum Member Design
jgKRI - Well, my experience has been the opposite even with simple cell formulas. Maybe that is just my nice new 6 core 16 gig dell... :/ The other thing is that it makes it super hard to work on when I can't have more than 1 worksheet on another monitor.
Frankly, I am mostly just venting about comprehensive aluminum design not being readily part of structural design packages.
-Mac
RE: Aluminum Member Design
RE: Aluminum Member Design
RE: Aluminum Member Design
appot - I will give that a try. Thanks.
-Mac
RE: Aluminum Member Design
RE: Aluminum Member Design
-Mac
RE: Aluminum Member Design
RE: Aluminum Member Design
I like to debate structural engineering theory -- a lot. If I challenge you on something, know that I'm doing so because I respect your opinion enough to either change it or adopt it.
RE: Aluminum Member Design
Celt, you can design for reduced properties by splitting the member near the weld locations and using a different material property. Not necessarily that streamlined but it's how RISA recommends you do it.
RE: Aluminum Member Design
simple enough solution. we've done that method before tricky part is always remembering to override the unbraced length of the main member chunk assuming you split it at any meaningful distance away from the supports.
RE: Aluminum Member Design
Luckily I don't do much aluminum design so I don't have any complaints. Just occasional small component on larger projects.
RE: Aluminum Member Design
I have tried to put together a proper spreadsheet on previous jobs but the situation becomes so specific that I can't reuse it.
RE: Aluminum Member Design
Celt83 - I would imagine that it only allows applying weld-affected properties to the entire section in that subdivided member. The ideal software would account for per element weld-affected area and use the weighted calculations to determine the average cross sectional properties. I doubt RISA can do that (yet). Josh Plummer to the rescue! That said, I guess you could deal with those local element problems on a case by case basis if you really need to squeeze out all the capacity you can get. The other thing I realized is that for exposed, uncoated aluminum lower stress alloys and tempers tend to be used because of better finishing properties. It is a pain in the arse when you have 3 ksi allowable to work with! And of course, the manufacturer's drafter/designer already take a stab at the proportioning of members/thicknesses, etc. so their quoted prices revolve around that - they get really cranky when we want to upgrade wall thicknesses and such. Plus, they hate fasteners! Weld, weld, weld. My oh my...
The overarching issue for me is that our firm is always trying to get into specialized areas to corner the local market. Our true specialty is concrete parking garage design and repair, aside from typical large building design. The ambitions have resulted in looking to specialize in delegated aluminum railing, canopies, etc. I was tasked with becoming the specialist in Aluminum design and to develop a spreadsheet-based program to automate the process. As I started learning about Aluminum design, I quickly realized that this venture was a mistake without investing in tested and maintained software. Of course that isn't going to happen, but the specialty goal is still is being pushed forward because the fabricator has gotten buddy-buddy with our president (of course with promises galore). Imagine this - the first project I had lost money. Who would have thought, while trying to develop a generalized program, meet the deadline, and manage all my other projects. I know you all are familiar with this pain - it is the inevitable struggle.
-Mac