Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Great ASCE7 spreadsheet / ComboBoxes

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Very nice Bill.  Thanks for sharing that as I had not yet seen a good
example of the "Indirect" function.  I will definitely be using that
from now on.

Doug Mayer, SE
Structural Engineer

-----Original Message-----
From: Bill Allen [mailto:t.w.allen(--nospam--at)] 
Sent: Friday, December 07, 2007 7:50 AM
To: seaint(--nospam--at)
Subject: RE: Great ASCE7 spreadsheet / ComboBoxes

Thanks for the info, Conrad.

My best example of using the indirect function is in selecting the type
of wood beam I want to design. This example is much better than apples
and trees that Microsoft uses. I often design wood beams of different
properties; sawn beams, Glu-Lam beams (GLB) and Parallel Strand
(PSL) beams.

I first set up a validation list to select the type of beam (Sawn, GLB
or PSL). Whichever I choose, the options for the different sizes change
based on my selection. In other words, if I want to design a sawn beam,
I have a list consisting of 2x4, 4x8 or 6x12. If I want to design a GLB,
my list consists of 3-1/8"x12", 5-1/8"x18" or 6-3/4"x24". If I want to
design a PSL beam, my list would change to 3-1/2"x11-1/4", 5-1/2"x14" or
7"x20". From there, you could have simple lookup commands to fetch
section properties such as the beam width and beam depth (among other

This procedure (at least the way I do it) requires named ranges. To
assist in the visualization, I've included a sample. Note: there are no
VBA scripts in this example so don't worry about a virus.

Have fun!

T. William (Bill) Allen, S.E.
Consulting Structural Engineers

Visit our new website at

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at:
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*   Questions to seaint-ad(--nospam--at) Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: 
******* ****** ****** ****** ******* ****** ****** ********