I was wondering the same thing.
T. William (Bill) Allen, S.E.
Consulting Structural Engineers
V (949) 248-8588 •
-----Original Message-----
From: Conrad Harrison [mailto:sch.tectonic@bigpond.com]
Sent: Tuesday, December 04, 2007 6:55 PM
To: seaint@seaint.org
Subject: RE: Great ASCE7 spreadsheet
Curious as to why people use the combobox from the control toolbox, rather than use the simpler data validation list.
<snip>
Regards
Conrad Harrison
B.Tech (mfg & mech), MIIE, gradTIEAust
mailto:sch.tectonic@bigpond.com
Adelaide
South Australia
From: Mark Johnson [mailto:markajohn@yahoo.com]
Sent: Wednesday, 5 December 2007 02:09
To: Glen Pappas
Cc: seaint@seaint.org
Subject: Re: Great ASCE7 spreadsheet
Glen and List,
Thanks for your permission to forward this to the SEAINT List. It should be helpful for anyone who wants to use this tool. I had exactly the same difficulty with the combo boxes as you did when I copied the spread sheets. I'm still hoping someone will crack it for us.
Mark Johnson
----- Original Message ----
From: Glen Pappas <gpappas@lanl.gov>
To: markajohn@yahoo.com
Sent: Tuesday, December 4, 2007 7:04:07 AM
Subject: RE: Great ASCE7 spreadsheet
Hello, Mark. I saw your e-m & it rang a bell, so I did some digging & found e-m below.
Although we're obviously not talking about the exact same software (i.e., for one thing, what you're looking at is IBC '06, whereas I was looking at '03) hopefully the e-m will be of some use to you anyway?
Feel free to share w/rest of SEAINT List.
Glen
Date: Mon, 13 Feb 2006 08:05:26 -0800
From: "Yo Ratanapeanchai" <ratany@co.clark.nv.us>
To: gpappas@lanl.gov
Subject: Re: IBC 2003 Spreadsheet
Hi Glen:
I am must be drank when I wrote this Snow Load spreadsheet. I was using ASCE7-1998 edition instead of 2002 edition. The Equation 7-3 in 1998, the value of beta base on L and W dimension and completely difference from 2002 edition. However the L,Lr,S sheet is not a password protected, so you can unprotect and modify to correct vision of the code. I will revise the spreadsheet as soon as possible. thanks for catching an error.
Yo
>>> "Glen Pappas" <gpappas@lanl.gov> 2/10/06 1:35:21 PM >>>
Yo, I've learned that creating Combo Box isn't trivial! I've put that on
hold for a while, & tried using your spreadsheet as is.
On the L, Lr, S sheet, why doesn't the value of beta change as the ground
snow load (pg) changes? You correctly indicate that beta is determined
based on Eq. 7-3, but regardless of the the value of pg that I specify,
beta remains 0.89. Beta should be 0.89 only for pg = 24.4 psf.
Thanks,
Glen
>>Date: Tue, 07 Feb 2006 14:09:55 -0800
>>From: "Yo Ratanapeanchai" <ratany@co.clark.nv.us>
>>To: gpappas@lanl.gov
>>Subject: Re: IBC 2003 Spreadsheet
>>Glen
>>The only thing that copy and paste command will not copy is the drop down
>>menu (Combo box from Control tool box). But you can create the Combo Box
>>after you copy the rest of spreadsheet. The password only protects the
>>user from modifying the original spreadsheet. If you know how the Combo
>>box works then it should be very easy to modify the rest. I'd rather
>>not discuss how Excel works. Thanks.
>>
>>Yo Ratanapeanchai
>>
>> >>> "Glen Pappas" <gpappas@lanl.gov> 2/7/06 12:25 PM >>>
>>Hello, Yo. You've done a great job getting the IBC into a spreadsheet!
>>
>>I'm having trouble trying to copy your sheet so that I can change some
>>values (e.g., the "0.00256" value for qz). I believe I followed the
>>instructions in your Read Me file but, when I pasted, I lost the pull-down
>>menus & the values you have in blue. I had macros enabled w/your sheet
>>before I copied.
>>
>>Could the problem be that the macros are password-protected? If so, can
>>you send them to me so that I can insert them in the appropriate places in
>>my copy of your spreadsheet?
>>
>>Thanks,
>>Glen
Glen Pappas, Ph.D., PE, SECB, BSCP
Los Alamos National Laboratory
ES-DE
Technical Staff Member
Phone: 505-665-1221
Fax: 505-665-4728
MS M791
TA-00-0786
gpappas@lanl.gov