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]
You're welcome.

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(--nospam--at)taylorteter.com]
> Sent: Friday, December 07, 2007 9:34 AM
> To: seaint(--nospam--at)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(--nospam--at)cox.net]
> Sent: Friday, December 07, 2007 7:50 AM
> To: seaint(--nospam--at)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(--nospam--at)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(--nospam--at)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 
******* ****** ****** ****** ******* ****** ****** ********