space gass and excel 1

[shei7141]

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

 

[rowingengineer]

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

 

[shei7141]

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

 

[rowingengineer]

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

 

[asixth]

What action are you trying to automate?

 

[shei7141]

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

 

[SydStructEng]

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,

 

[shei7141]

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

 

[rowingengineer]

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

 

[shei7141]

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

 

[rowingengineer]

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

 

[SydStructEng]

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

 

[shei7141]

thank you thank you thank you.............................

I love you all