Need a book? Engineering books recommendations...
Re: Great ASCE7 spreadsheet[Subject Prev][Subject Next][Thread Prev][Thread Next]
- To: Glen Pappas <gpappas(--nospam--at)lanl.gov>
- Subject: Re: Great ASCE7 spreadsheet
- From: Mark Johnson <markajohn(--nospam--at)yahoo.com>
- Date: Tue, 4 Dec 2007 07:38:46 -0800 (PST)
- Cc: seaint(--nospam--at)seaint.org
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.
From: Glen Pappas <gpappas(--nospam--at)lanl.gov>
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.
Date: Mon, 13 Feb 2006 08:05:26 -0800
From: "Yo Ratanapeanchai" <ratany(--nospam--at)co.clark.nv.us>
Subject: Re: IBC 2003 Spreadsheet
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.
>>> "Glen Pappas" <gpappas(--nospam--at)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.
>>Date: Tue, 07 Feb 2006 14:09:55 -0800
>>From: "Yo Ratanapeanchai" <ratany(--nospam--at)co.clark.nv.us>
>>Subject: Re: IBC 2003 Spreadsheet
>>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.
>> >>> "Glen Pappas" <gpappas(--nospam--at)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?
Glen Pappas, Ph.D., PE, SECB, BSCP
Los Alamos National Laboratory
Technical Staff Member
- RE: Great ASCE7 spreadsheet
- From: Conrad Harrison
- RE: Great ASCE7 spreadsheet
- Prev by Subject: RE: Great ASCE7 spreadsheet
- Next by Subject: RE: Great ASCE7 spreadsheet
- Previous by thread: RE: Great ASCE7 spreadsheet
- Next by thread: RE: Great ASCE7 spreadsheet