×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

space gass and excel

space gass and excel

space gass and excel

(OP)
Hey guys,

I am totally new to space gass. I am just curious to know if there is a way to record a macro in the spacegass similar to microsoft office apps.

I need some intial help to write a code to perform an action in Space Gass using the macro?

Any idea??

Thanks in advance

RE: space gass and excel

Shei7141,
most people would use the import function to import information from excel to Spacegass mostly as txt files. haven't heard of many people programming in spacegass other than the developers. Probably best to call the support they are helpful.   

http://www.nceng.com.au/
"A safe structure will be the one whose weakest link is never overloaded by the greatest force to which the structure is subjected" Petroski 1992

RE: space gass and excel

(OP)
thanks buddy,
really appreciate your response.

I am trying to perform a specific action in  a SG. it normally takes me around 20 minutes to do so. All I am trying to do is automate that action by the use of a macro.

Would you have the tech support team contact info by any chance??

once again thanks

RE: space gass and excel

the Australian contact is Contact: Mr. Peter Schulze
Phone: (61) 3 5222 6757, but you should check with your local supplier.  

http://www.nceng.com.au/
"A safe structure will be the one whose weakest link is never overloaded by the greatest force to which the structure is subjected" Petroski 1992

RE: space gass and excel

What action are you trying to automate?

RE: space gass and excel

(OP)
First of all thanks RowingEngineer

Actually, I am trying to extract the filtered intermediate shear and moment results for every single structural element in a text format. Also want to save each result in a separate txt file.

Right now, I have to go to file, print result and have to apply the filter each member individually and then print the intermediate shear and moment results in the text file.

I am trying to automate this entire action.

Any help will be much  

RE: space gass and excel

shei7141,

It is possible (and not that hard) to control Space Gass with a text file - but in this case I don't think it is necessary.

I would use the Export to MS-Excel command in Space Gass and use a macro in excel to print out the results the way you want.

Do this by running your analysis then:

File > Export > to MS-Excel - Select "Include Results"

Have a look through the excel file, all the information you need will be there. It's then a matter of either recording or writing a macro in excel that saves the data into a text file.

If you have trouble with not getting the intermediate results try subdividing your members. I think this will produce forces at nodes.

Alternatively, you could print a report text file with everything in it (no filter applied) import the text file into Excel and extract the results in the format you're after.

Let me know how you go,

RE: space gass and excel

(OP)
Thanks Buddy,

I tried the excel outputs already, but it does nt provide the intermidiate results. It produces the default output format. I also tried the sub-dividing method previously but didn't workout for me.

I also tried to reduce a text output file without applying the filter but it crashed and gave me some insufficent memory related error. This is one of the reason, I ended up reducing the results by applying filter. But depending on the size of the model, I most of the time has to repeat the same procedure to arounf 50 times (cos of the various scenarios and the structural members).

I somehow want to automated that iterative procedure in SpaceGass and control it from excel.

Any suggestions will be much appreciated.


Kind Regards,
S

RE: space gass and excel

you can control spacegass from excel, take a look in the help menu for controlling spacegass with macros.

here is an old script I used when I was using space gass about 3 years ago.

Space gass script

#import a text file
Menu 01 15 C:\spacegass\text\textin.txt

# perform a non linear anaylsis
Menu 04 02

# export a txt file
Menu 01 22 c:\spacegassdata\text\textout.text

# exist space gass
Menu 01 34

  

http://www.nceng.com.au/
"A safe structure will be the one whose weakest link is never overloaded by the greatest force to which the structure is subjected" Petroski 1992

RE: space gass and excel

(OP)
dude you;re a genius.........

Thanks a million......

just one last thing could you briefly explain this menu numbering convention?

what does these number stand for and I'll take it from thr then...

once again, thanks a millliioooonnnnnn

RE: space gass and excel

I don't know, this is a macro I started and never finished, probably got it from the help file to start with and never finished.  

http://www.nceng.com.au/
"A safe structure will be the one whose weakest link is never overloaded by the greatest force to which the structure is subjected" Petroski 1992

RE: space gass and excel

shei7141,

The first number indicates which Menu you select as you go across the Menu Bar. i.e. 01 = File, 02 = Structure, 03 = Loads etc...

The second number indicates the selection in that menu. i.e. 01 05 = Menu, Save As.


Note that some menus have extensions, such as the File menu has an extension for Import and Export. The numbers continue along these for example...

# Import an excel file (Textin.txt)
MENU 01 25 C:\Temp\Import.xls

# Export the results to MS-Excel file
MENU 01 34 C:\Temp\SpaceGassout.xls

  

RE: space gass and excel

(OP)
thank you thank you thank you.............................

I love you all :)

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources