I'm glad I can make a contribution.
T. William (Bill) Allen, S.E.
ALLEN DESIGNS
Consulting Structural Engineers
> -----Original Message-----
> From: Doug Mayer [mailto:doug.mayer@taylorteter.com]
> Sent: Friday, December 07, 2007 9:34 AM
> To: seaint@seaint.org
> Subject: RE: Great ASCE7 spreadsheet / ComboBoxes
>
> 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@cox.net]
> Sent: Friday, December 07, 2007 7:50 AM
> To: seaint@seaint.org
> 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
> Laminated
> (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
> things).
>
> 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.
> ALLEN DESIGNS
> Consulting Structural Engineers
>
> Visit our new website at www.taylorteter.com
>
> ******* ****** ******* ******** ******* ******* ******* ***
> * Read list FAQ at: http://www.seaint.org/list_FAQ.asp
> *
> * This email was sent to you via Structural Engineers
> * Association of Southern California (SEAOSC) server. To
> * subscribe (no fee) or UnSubscribe, please go to:
> *
> *
http://www.seaint.org/sealist1.asp
> *
> * Questions to seaint-ad@seaint.org. 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: http://www.seaint.org
> ******* ****** ****** ****** ******* ****** ****** ********
******* ****** ******* ******** ******* ******* ******* ***
* Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*
* This email was sent to you via Structural Engineers
* Association of Southern California (SEAOSC) server. To
* subscribe (no fee) or UnSubscribe, please go to:
*
*
http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad@seaint.org. 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: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ********