CivilEA.com
  • Subscribe !
  • Register
  • Login
  • Home
  • Members
  • Help
  • Search
Civil Engineering Association Civil Engineering Resource Civil Engineering Documents Engineering Spreadsheet Import beam design stresses from Staad to Excel

Import beam design stresses from Staad to Excel
 blackjack

Not-Activated

Philippine
User ID: 6184
Joined: Sep 2009
Posts: 14
Threads: 10
Likes: 239 in 16 posts
Given Likes: 322
Points:1,374 EP
#1
02-14-2010, 05:47 PM (This post was last modified: 12-15-2010, 08:26 PM by usman.)
BEAM DESIGN FORCES FROM STAAD TO EXCEL

[Image: 05719225379231227830.jpg]

[Image: info.png]
Import Beam Design Forces from STAAD to Excel using Macro code. Can be used for any type of beam member. Useful to those who would like to check the software's result using their own spreadsheet. Any suggestions on improving the embedded macro shall be appreciated.

Cheers!

[Image: 85083330429139606261.jpg]

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



[-] The following 22 users Like blackjack's post:22 users Like blackjack's post
  • sasan51, Dell_Brett, kowheng, ASEC, engr1900, vvvv, Albert, wa_sin_29, chenamoy, rendel_©, hsccindia, robertsas, deanz_75, HellboyRBJ, abhijit, adshrt, knrsa, Clouseau, kkgcivil, bigone, ambrish, er.shyams
 kusumoaji

Not-Activated

White-private
User ID: 16175
Joined: Mar 2010
Posts: 4
Threads: 2
Likes: 1 in 1 posts
Given Likes: 1
Points:340 EP
#2
03-14-2010, 01:14 PM
on what version of staad it can be used?
i have tried but excel shows nothing

thanks



[-] The following 1 user Likes kusumoaji's post:1 user Likes kusumoaji's post
  • bigone
 rohailiyaz

Not-Activated

Pakistan
User ID: 925
Joined: Mar 2009
Posts: 276
Threads: 146
Likes: 1,152 in 117 posts
Given Likes: 733
Points:14,294 EP
#3
03-14-2010, 04:20 PM
well it works on 05.15 and 06.23
i have tried on both it workks. may be ur missing sumthng



[-] The following 2 users Like rohailiyaz's post:2 users Like rohailiyaz's post
  • blackjack, bigone
 blackjack

Not-Activated

Philippine
User ID: 6184
Joined: Sep 2009
Posts: 14
Threads: 10
Likes: 239 in 16 posts
Given Likes: 322
Points:1,374 EP
#4
03-19-2010, 09:48 AM
it is important to note also that you need to run the staad analysis first before you can import the design forces, otherwise it will not work.



[-] The following 2 users Like blackjack's post:2 users Like blackjack's post
  • hsccindia, bigone
 usman

Professional Member

Protectors
United Nations
User ID: 59
Joined: Dec 2008
Posts: 717
Threads: 138
Likes: 6,571 in 671 posts
Given Likes: 4974
Points:35,696 EP
#5
12-16-2010, 11:29 PM
Direct Mirror

.xls   BEAM_DESIGN FORCES_from STAAD.xls (Size: 367 KB / Downloads: 296)
stone age was not finished due to lack of stones. . . . . .tEChNOlOGY Changed



[-] The following 13 users Like usman's post:13 users Like usman's post
  • Dell_Brett, lednar_ved, dinu69in, kowheng, adshrt, Clouseau, er.shyams, malc, ISTRAKTURA, bigone, duazo2009, cace-01, spat
 abhijit

Not-Activated

India
User ID: 6443
Joined: Sep 2009
Posts: 13
Threads: 2
Likes: 88 in 11 posts
Given Likes: 47
Points:770 EP
#6
08-20-2012, 09:42 AM
Import beam design stresses from Staad to Excel

Size: 0.4 MB
[Image: screen.png]
[Image: 25306948875211978050.jpg]


[Image: info.png]

Completely reworked Excell to import Staad - forces , stresses & utility factor.
It has options
1) Import by Group definitions or by Beam numbers
2) Load case selector

* Only problem with Utility Factor is to get U.F. for perticular load case , you have to give " LOAD LIST " command
by default it will give maximum utility factor

* VB code is open & can be modified.
* Tested on Staad 2005 output


[Image: tips.png]
Private Note:
***************************************
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
***************************************



[align=left][Image: download.png]
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
***************************************


[Image: crack.png]
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
***************************************


[Image: password.png]
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
***************************************

This post has been made by CivilEA Post-Generator ver 2.1.6



[-] The following 7 users Like abhijit's post:7 users Like abhijit's post
  • malc, ISTRAKTURA, Dell_Brett, titko, monter, bigone, we_mbm
 ripach

Semi Senior Member

Registered
Spain
User ID: 5230
Joined: Aug 2009
Posts: 56
Threads: 14
Likes: 259 in 49 posts
Given Likes: 78
Points:2,388 EP
#7
06-22-2017, 04:07 PM
Links dead. Please, re-upload it.



[-] The following 2 users Like ripach's post:2 users Like ripach's post
  • hatkam, caifan
 structural

Not-Activated

Singapore
User ID: 7169
Joined: Sep 2009
Posts: 16
Threads: 2
Likes: 28 in 9 posts
Given Likes: 45
Points:580 EP
#8
06-01-2020, 06:08 AM
Links are not working. Request to please re-upload.



[-] The following 1 user Likes structural's post:1 user Likes structural's post
  • mgdario
 kowheng

Software

Retired Moderator
Thailand
User ID: 2141
Joined: Jun 2009
Posts: 2,909
Threads: 59
Likes: 33,527 in 2,936 posts
Given Likes: 17217
Points:158,166 EP
#9
06-02-2020, 04:55 AM
Link on usman post is still valid.
Please don't request for re-uploading again.



[-] The following 4 users Like kowheng's post:4 users Like kowheng's post
  • structural, Dell_Brett, oanm2000, mohamz
 chukwuma

Not-Activated

Nigeria
User ID: 54070
Joined: Nov 2012
Posts: 32
Threads: 6
Likes: 37 in 20 posts
Given Likes: 34
Points:1,278 EP
#10
06-29-2020, 11:10 AM
Please re-upload the link on Post #6 (abhijit). I want beam stresses with utilization ratio. Thanks




  •
« Next Oldest | Next Newest »

Users browsing this thread: 2 Guest(s)
Pages (2): 1 2 Next »



Possibly Related Threads…
Thread Author Replies Views Last Post
  load on beam in excel camto2 0 4,020 03-27-2018, 04:11 PM
Last Post: camto2
  Importing Staad Support Reactions using OpenSTAAD to Excel blackjack 2 11,458 06-24-2017, 05:04 PM
Last Post: ripach
  Excel for Reduced Beam Section Design RyanRS 0 7,759 08-30-2013, 01:38 PM
Last Post: RyanRS
  Excel macro to import CSI section catalog pro LiviuM 4 10,318 07-06-2012, 05:44 AM
Last Post: andersen3
  Steel Beam Design - Beam Selection Tables usman 0 4,864 12-02-2010, 12:42 AM
Last Post: usman

  • View a Printable Version
  • Subscribe to this thread

Designed by CivilEA - Powered by MyBB

Linear Mode
Threaded Mode