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
#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
#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
#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
#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
#5
12-16-2010, 11:29 PM
Direct Mirror

.xls   BEAM_DESIGN FORCES_from STAAD.xls (Size: 367 KB / Downloads: 297)
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
#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
#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
#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
#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
#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: 1 Guest(s)
Pages (2): 1 2 Next »



Possibly Related Threads…
Thread Author Replies Views Last Post
  load on beam in excel camto2 0 4,787 03-27-2018, 04:11 PM
Last Post: camto2
  Importing Staad Support Reactions using OpenSTAAD to Excel blackjack 2 12,334 06-24-2017, 05:04 PM
Last Post: ripach
  Excel for Reduced Beam Section Design RyanRS 0 8,504 08-30-2013, 01:38 PM
Last Post: RyanRS
  Excel macro to import CSI section catalog pro LiviuM 4 11,432 07-06-2012, 05:44 AM
Last Post: andersen3
  Steel Beam Design - Beam Selection Tables usman 0 5,464 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