UBC SEISMIC CALCULATIONS EXCEL SHEET
Current time: 04-26-2018, 12:56 AM
Users browsing this thread: 1 Guest(s)
Author: RANA WASEEM
Last Post: RANA WASEEM
Replies 4
Views 6989

UBC SEISMIC CALCULATIONS EXCEL SHEET
#1
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]
WS
[-] The following 23 users say Thank You to RANA WASEEM for this post:
  • cve_jule, kowheng, Sumatra, dizz, hazus, we_mbm, jcoronellr, shaqee, hmwere, cordoba123, DamaD, rendel_©, Ronald005, ranger, deadlord, eshetu, oanm2000, paladin, Dell_Brett, HerrMeier, vir_lao, Akachan, bigone
Reply
#2
guyz...i made some new changes and now version 2 is available here...

2007 format
***************************************
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
***************************************
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
***************************************
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
***************************************

WS
Reply
#3
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...
WS
[-] The following 5 users say Thank You to RANA WASEEM for this post:
  • BennyK, Dell_Brett, oanm2000, hmwere, TAFATNEB
Reply
#4
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
WS
[-] The following 3 users say Thank You to RANA WASEEM for this post:
  • oanm2000, hmwere, Arigato
Reply
#5
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
***************************************

WS
[-] The following 15 users say Thank You to RANA WASEEM for this post:
  • viet2010, hima, malc, Dell_Brett, karthikeyans3d, cace-01, hatkam, TAFATNEB, gundis, hignacio43, jaks, kkding, tqthanh, ranger, ronnie_150
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
Analysis:Egyptian Code ECP201-2008 Earthquake Lateral Forces Excel sheet bigone 1 3,076 11-15-2014, 11:18 AM
Last Post: bigone
ACI 350.3-06 Appendix B Seismic Loads for Liquid-Containing Rectangular RC Tank Excel bigone 3 6,975 11-09-2014, 01:48 PM
Last Post: bigone
ACI_Check of Max. Crack width for M & N for both Rec. & T sections_ DAR excel sheet bigone 0 4,160 09-09-2013, 09:14 AM
Last Post: bigone
AISC360-05 LRFD Shear bolted connection check Excel Sheet bigone 0 3,274 07-14-2012, 03:51 AM
Last Post: bigone
Analysis:ASEC7-05 / IBC2006 Earthquake Lateral Forces Excel sheet bigone 1 3,038 06-30-2012, 03:47 PM
Last Post: bigone



Users browsing this thread: 1 Guest(s)