Trainguy,
You may be relieved to know that I am the one and only genuine (perhaps even dinkum) Austim.
I have happily embraced computer technology as it has been developed, and encouraged others to do so, but to use it intelligently and for appropriate purposes. No, my slide rule slides no longer, but my pocket (programmable) electronic calculator still works full time. [Perhaps you were never required to prepare alternative bridge girder designs for tender within an unreasonably brief tender period, before in-flight movies had been invented ?]
My previous lengthy post was directly aimed at Vintage70's initial question - "Is there a way to calculate S1 & S2 & I ?". Rightly or wrongly, I concluded that Vintage70 had either forgotten how to do it, or had never been taught the basic principles. That would not be a good start for setting up a spreadsheet.
1. Re my hand calcs for section properties:
I still stand by my view that rushing to a computer to do the calculation needed by vintage70 is the wrong way to go. In fact, for any beam calculation that I might do, the three properties sought by Vintage70 would only be part of the problem. What about Iyy, J, W (required to determine lateral/torsional buckling properties), and the plastic moduli about each principal axis? ACAD does not appear to offer any help with J and W or the plastic moduli, so I would have to pull out the pencil and paper anyway. And in one quick exercise I have my submission documentation finished.
I have never been one to avoid a challenge, but I cannot (quite) match your nominated 3 minutes. (But have you actually timed yourself)?
Under 'exam conditions' (starting with blank sheet of paper, section table booklet closed and calculator switched on), my best time so far for calculating the elastic moduli to the top and bottom of an Ibeam-plus-angles section is 4min, 34.9 seconds (including time to start and stop the digital stop watch on my laptop). Allowing for improved neatness of presentation for serious work, say about 5 minutes.
But that has already got me further than ACAD can do, since I have written down the two section moduli, which you cannot read from ACAD, and I have got a calculation sheet (including a sketch of the section) to incorporate into my record file.
I never use ACAD for drawing (only for reading drawings that others send to me), so any attempt of mine to confirm your 3 minutes estimate would be pointless. But I seriously question whether you could, within your suggested 3 minutes, find and load the relevant drawing, find a suitable cross-section, verify that it has been drawn accurately, select it, convert it to a region, find its CG, move it so that the relocated CG is at (0,0), record the CG location and M of I, and then calculate and record the two section moduli that Vintage70 wanted.
At the very best, the ACAD process will derive four elastic properties of the gross cross-section (A,ybar,Ix,Iy). Within current Australian practice, that is really not much use as a general procedure, and could mislead inexperienced engineers into some dangerous design decisions, particularly if they were to use it for large plate girders.
The Australian steel design code abandoned ASD methods for all structural work 12 years ago. As a result, the elastic moduli on their own are virtually useless to us. To determine the bending capacity of a section, we have to be able to calculate the plastic modulus and take account of possible reductions in effective section due to the slenderness ratios of the various plate elements involved in the section. Then, of course to calculate the bending capacity of a beam, we have to allow for possible lateral/torsional buckling, which requires us to know the two torsional parameters J and W.
[The best that I can get from ACAD is an upper bound to the design values for A, Ixx, Iyy, which can be reduced significantly by plate slenderness effects.]
Essentially, these factors force us to use standard sections for which all tabulated properties are available, or alternatively to know what we are doing, and calculate for ourselves the design properties for all special sections. In much of my own work (heavily loaded plate girders etc) the latter option is unavoidable.
2. re my non-linear suggestion (which was not entirely tongue-in-cheek. Some day I will try it for myself).
Again, current Australian practice comes into the picture. Since 1990, our LFRD design code has specified quite clearly that if we only use first-order (linear) analyses, then we have to multiply all of our output moments by moment amplification factors which vary according to the critical axial buckling load applied axial load in each member.
Alternatively we may use the output from a non-linear analysis without further modification. (Provided that we keep above a buckling factor of 5, the non-linearity does not have to include the effect of axial load on the member stiffness). The 2nd-order alternative is much 'neater' and simpler in practice. It rarely adds much to the analysis time, and avoids a very messy process once we have our analytical results. So, whenever I can, I adopt 'non-linear' as a standard process.