US +1 617 5008224
EU +44 113 8152220
Toll Free: Skype
Forum or Email
 Tweet

Our Feeds

### Who's Online

We have 62 guests and 39 members online

206638

### Our Services

ï»¿

Enter Amount:

Home

ExcelCalcs
ASCE705S.xls (1 viewing) (1) Guest
This area of the Forum is reserved for notes about the Version history of items in the repository. A link to the related repository item is always included at the top of each thread.
 Favoured: 107 Page: << Start < Prev 1 2 Next > End >>
TOPIC: ASCE705S.xls
#2485
(User)
Frog Prince (Platinum Boarder)
Posts: 147

 Update to version 1.5 2 Years, 1 Month ago Karma: 50 For some people, there has been some confusion in the "Snow Load" worksheet, distinguishing between the use of the maximum drift height, "hd(max)" and the design drift height, "hd". I have added a variable named "hd(max)" to distinguish between "hd(max)" and "hd" for determining the proper usage of each one in eventually calculating the drift width, "w" and the weight of the drift at the high end, "pd". Below is the logic that I have used for the revised worksheet from the second paragraph of ASCE 7-05 Section 7.7.1. I don't know about the rest of you, but to me that paragraph typifies some of the confusing and convoluted verbiage that is often found in building codes. hd(max) = maximum of (hdL or hdw) If hd(max) <= hc then w = 4*hd(max) and hd = hd(max) (where hc = clear height) If hd(max) > hc then w = 4*hd(max)^2/hc and hd = hc The current version is now 1.5.

Logged

The administrator has disabled public write access.
#2756
(User)
Frog Prince (Platinum Boarder)
Posts: 147

 Update to v1.6 1 Year, 2 Months ago Karma: 50 It was brought to my attention in the "ASCE705S.xls" workbook in the "Snow Load" worksheet that was a wrong cell reference pertaining to the calculation for the snow drift sketch off to the right of the main calculation page. Here the user could input a distance from the end where the drift is a maximum value, and determine what the value of the drift is at that distance away. The calculation in Cell AC41 was using the actual calculated drift length, "w", when it should have been using the "w(use)" value of the drift, which is the minimum of either "w" or "w(max)". The error would show up only when the value of "w(use)" was controlled by the value of "w(max)". I have made the appropriate cell reference correction, and the version of this workbook is now 1.6.

Logged

The administrator has disabled public write access.
#2814
(User)
Frog Prince (Platinum Boarder)
Posts: 147

 ASCE705S.xls update to 1.7 1 Year ago Karma: 50 It was brought to my attention in the "ASCE705S.xls" spreadsheet workbook, for the rather rare case when the actual length of lower roof is less than the calculated snow drift length, the spreadsheet was reducing the magnitude of the snow drift to a value of zero at the edge of the roof. This was incorrect. Per ASCE 7-05 Section 7.7.1, when length of lower roof is less than calculated length of snow drift, the snow drift shall be truncated at the far edge of roof, and not reduced to zero there. Thus, for this special case I had to create another result, in the form of the weight of the snow drift at the low end (minimum value). Please note that for this rather rare case, the illustration shown at the bottom of the calculation sheet will not actually depict the snow drift value at the low end (edge of building) correctly. Sorry, there's really not an easy nor convenient way to address that particular case, and to me it's not worth the effort trying to address it. The user will just have to be aware of it. This workbook is now version 1.7.

Logged

The administrator has disabled public write access.
 Page: << Start < Prev 1 2 Next > End >>

# Training Courses For London Underground

"Thanks again for your excellent course this past week." "Thank you for the course last week, found it very interesting both from the perspective of a quick refresh, but also on how we can optimise the work we do." "Thanks for a very interesting and usef...

I am pleased to report that XLC Ribbon works with the 32bit and 64 bit versions of Excel 2013 obtained using the free Office 365 Home Premium Preview. Excel 2013 looks a little flat and dull compared to previous versions but I think this is the influence of the new Windows 8 'metro' look and f...

# Introducing XLC the Ribbon Version

New!XLC Ribbon    For the first time XLC works with both 32 bit and 64 bit versions of Excel with an enhanced Office Ribbon display. It is a much simpler installation process than the previous Toolbar versions so you can be up and running in no time at all. ...

# ExcelCalcs Bites the Bullet!

Hitachi have recently been awarded the largest ever UK rolling stock order and they’ll be bringing their Shinkansen bullet train technology to Europe. In August ExcelCalcs braved the stifling Japanese heat to deliver their ‘Fatigue of Welded Structures’ course to Hitachi b...

# Engineer's Excel!

Our XLC software is a mathematical add-in for Excel. Generating equations direct from cell formulas it is an essential verification tool for engineers. Furthermore the ExcelCalcs community is the world’s most active producer of Excel solutions to engineering problems. The table below shows w...

# ExcelCalcs Lego-Like Way to Engineering

Like a child selecting parts to construct a Lego model engineers bring together blocks of science to create new designs. These building blocks could be a load calculation, a beam calculation, a weld calculation, a fatigue calculation or any other calculation from a myriad of engineering topics. As...

# iPhone, Android and Mobile Device Access

The site is optimised for browsing on mobile devices like the iPhone or Android phones. To create a web app icon browse to http://www.excelcalcs.com/navigate/ and ‘Add to Home Screen’. You will find an icon much like an app icon on your home screen which will bring you straight back...

# ExcelCalcs Trailblazers

I have been chasing up feedback from new users signing up to XLC Pro accounts in the last month. I am delighted with their positive feedback. “I started using XLC but I am now insisting that my whole team use the add-in .“ “It is a great tool for validation and pres...

# Increasing Engineering Confidence

Engineering training - “I run a team of engineers and whilst there are plenty of soft options for training expounding the latest management techniques there is precious little to develop the engineering skills of my team”. This is a familiar story we hear from clients of our trai...