+- Civil Engineering Association (https://forum.civilea.com)
+-- Forum: Civil Engineering Resource (https://forum.civilea.com/forum-1.html)
+--- Forum: Civil Engineering Documents (https://forum.civilea.com/forum-89.html)
+---- Forum: Engineering Spreadsheet (https://forum.civilea.com/forum-43.html)
+---- Thread: Import beam design stresses from Staad to Excel (/thread-8840.html)
Pages:
1
2
Import beam design stresses from Staad to Excel - blackjack - 02-14-2010
BEAM DESIGN FORCES FROM STAAD TO EXCEL
![[Image: 05719225379231227830.jpg]](https://pic.civilea.com/images/05719225379231227830.jpg)
![[Image: info.png]](http://forum.civilea.com/postgen/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]](https://pic.civilea.com/images/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
***************************************RE: Import beam design stresses from Staad to Excel - kusumoaji - 03-14-2010
on what version of staad it can be used?
i have tried but excel shows nothing
thanks
RE: Import beam design stresses from Staad to Excel - rohailiyaz - 03-14-2010
well it works on 05.15 and 06.23
i have tried on both it workks. may be ur missing sumthng
RE: Import beam design stresses from Staad to Excel - blackjack - 03-19-2010
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.
RE: Import beam design stresses from Staad to Excel - usman - 12-16-2010
Direct Mirror
BEAM_DESIGN FORCES_from STAAD.xls (Size: 367 KB / Downloads: 289)
RE: Import beam design stresses from Staad to Excel - abhijit - 08-20-2012
Import beam design stresses from Staad to Excel
Size: 0.4 MB
![[Image: screen.png]](http://postgen.civilea.com/icon/screen.png){kind=icon}
![[Image: 25306948875211978050.jpg]](https://pic.civilea.com/images/25306948875211978050.jpg)
![[Image: info.png]](http://postgen.civilea.com/icon/info.png){kind=icon}
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]](http://postgen.civilea.com/icon/tips.png){kind=icon}
Private Note:
[align=left]
![[Image: download.png]](http://postgen.civilea.com/icon/download.png){kind=icon}
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]](http://postgen.civilea.com/icon/crack.png){kind=icon}
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]](http://postgen.civilea.com/icon/password.png){kind=icon}
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
***************************************RE: Import beam design stresses from Staad to Excel - ripach - 06-22-2017
Links dead. Please, re-upload it.
RE: Import beam design stresses from Staad to Excel - structural - 06-01-2020
Links are not working. Request to please re-upload.
RE: Import beam design stresses from Staad to Excel - kowheng - 06-02-2020
Link on usman post is still valid.
Please don't request for re-uploading again.
RE: Import beam design stresses from Staad to Excel - chukwuma - 06-29-2020
Please re-upload the link on Post #6 (abhijit). I want beam stresses with utilization ratio. Thanks