Civil Engineering Association

Full Version: UBC SEISMIC CALCULATIONS EXCEL SHEET
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Here is my new sheet for seismic base shear and drift calculations. It is integrated with Visual Basic.
Please enable macro when asked after opening this sheet.

Sheet name is CB (coolest bliss) Seis Ver 1.0 dedicated to CIVILEA...
Its freeware and you can distribute without my permissions. This is for educational purposes only and not for commercial and I am not responsible for any reactions due to its use. If you like my contribution press THANKS.

1) This sheet is not protected for users of CIVILEA so that they can learn the formulas used and also VB coding. but take care not to delete the formula cells.
2) Put your values in white cells
3) This sheet has a button for printing front page summary and then building data on A4. so no need to adjust anything if you want to print on A4.
4) This sheet support both units SI and IMPERIAL. just click on the relevant units buttons before starting your work.
5) Calculations are based on UBC-97 code.
6) You have to put the delta s (Design Seismic Forces Displacement) values to complete drift calculations.

if you find any error or suggestions please do not hesitate to contact me.

here is a snap shot of a simple 5 storey building print our report which can be generated by this sheet...

[Image: 62154803059289533570.jpg]
[Image: 98183283463647443707.jpg]
guyz...i made some new changes and now version 2 is available here...

2007 format
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

A STEP BY STEP EXAMPLE USING THIS SHEET AND ETABS
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

EXE PROGRAM VER 3.0
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************
Dear BENNYK,
Why you need version 1...Use the latest version...I made some improvments like giving an option to change the values of time period etc apart from calculated ones...thats the difference b.w old and new version....
secondly, when you integrate visual basic or programming with excel sheets, you can do whatever a standard exe file can do but within excel environment...i mean yes you can design a virus in structural excel sheet also...:-)...thats y it always gives warning to use macros at your own risk...but believe me my sheets do not contain virus...if you note...my excel sheets are not protected...because
1) Users can have insight look how to perform programming for structural purposes.
2) Users can see inside to make sure...that there is not virus....:-)

Regarding confusions about version 1 and version 2....i will edit my previous post and i will delete all old links..because i know the old links are not working...to encourage users to download the latest files...
Dear members, once again..sorry for too much editing...but i have updated new links for Version 3.0
a) Excel 2007 Sheet
b) Installation exe file...

New version has following two updates:-
1-)Base shear calculation according to EQ-30-7 is included...
2-)In exe program UBC tables are attached for help...

Enjoy...
Note: Program name CB Seis has been changed to WS Seis
here is new linl:-



***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************