Please reply to this topic to comment on or discuss Repository item:
ASCE702W.xls

Alex Tomanovich asked me to update this file to version 1.7

One of the guys pointed out a typo error to me in the "ASCE702W.xls"
spreadsheet workbook. In the "MWFRS (Any Ht.)" worksheet at the bottom of the 4th page at Note #3, it should read "PLx, PLy = Leeward face pressure.....". It was inadvertently shown as "PLx, PLy = Windward face pressure.....". The diagrams shown above the notes would have clarified this. This has now been corrected.

I also corrected a couple of page breaks that were not coming out in the correct positions. I usually place a border around each of the pages of a particular worksheet, so it is easy to adjust the page breaks to line up with these borders if necessary, in the event that they are not coming out right with your particular printer/driver.

Alex Tomanovich, P.E.
Senior Structural Engineer

In the "MWFRS (Low-Rise)" worksheet of the "ASCE702W.xls" workbook it was discovered that for in Figure 6-10 for roof angles greater than 45 degrees the program was defaulting to the wind external pressure coefficient values for 90 degrees for zones 2, 3 and 2A, 3A. The code permits interpolation between any of the ranges of roof angles in that table, and the program was interpolating for all the others ranges of values of roof angles. For some reason, I failed to do it for those specific 4 zones.

Typically in industrial work we don't encounter such steep roof angles.
However, one of the guys who was doing some work outside of the industrial market sector brought this to my attention. In a sense the program wasn't really wrong, but merely overly conservative by not making use of permitted interpolation.

This has now been corrected.

I have started on a workbook for wind loading analysis per the ASCE 7-05 Code. I hope to have it completed in the near future.

I think this is an excellent worksheet. I've tried to do this in the past, but your result is a much better presentation than mine. Kudos!!

However, I think I've found an error in the stacks & tanks page. It seems from posts below that its appropriate to post it here. So here goes:

on the stacks and tanks tab, in cel B98 and the accompanying C98, there is a misplaced ) that results in an incorrect value for flexible structure gust factor.
the formula in B98 matches the description in C98.

as is, cell C98 shows
'= 0.925*(1+1.7*Iz(bar)*(gq^2*Q^2+gr^2*R^2))^(1/2)/(1+1.7*gv*Iz(bar)) , Eq. 6-8

with my proposed correction, cell C98 would read
'= 0.925*(1+1.7*Iz(bar)*(gq^2*Q^2+gr^2*R^2)^(1/2))/(1+1.7*gv*Iz(bar)) , Eq. 6-8


the red parenthesis is the one I've corrected


Check Eq. 6-8 in the code and note what is under the radical, I think my correction makes the formula right. Cell B98 formula needs to be corrected to match.


I don't know if this error also occurs on other pages.


Still, an excellent worksheet.


regards,


chichuck

chichuck:

You are correct in the formula as you have shown it in your post. However, the ONLY error that I see in version 1.8 of that worksheet which is currently on the calculation repository is in the formula that is displayed in the comment box. The actual calculation formula as well as the text displayed version of the formula look to be correct to me (just as you have shown it).

I have been working on a workbook for wind analysis per the ASCE 7-05 Code and I already picked up the error in the comment box. I will issue version 1.9 to this workbook soon, about the same time that I issue the new "ASCE705W.xls" workbook.

Alex

Alex,

I see. The version I have is version 1.4. I missed the fact that this is an outdated version.

regards,

chichuck.