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
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
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