The newest addin from Autodesk Labs - Project Octopus that allows designers and engineers using Autodesk Robot Structural Analysis to seamlessly access data and results with Microsoft Office Excel. To know more about it please use this link.
For the first look this is the Excel_Formulas.xlsm from the 2014 SDK.
Do you find the posts helpful? "LIKE" these posts!
Have your question been answered successfully? Click 'ACCEPT SOLUTION' button.
Roman Zhelezniak
Robot Evangelist & Passionate Civil Structural Engineer
Solved! Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
Hello,
It would be great if Excel could read bar data like this: " 4to94By30", like Robot can, when we use the bar selection, for example.
Regards,
Hugo
Well,
you can write a VBA routine that create a selection group in excel starting from the Robot selection string. Use the Visual Basic text function or the excel text function.
Greetings
Hello,
Well but i also would like to know if Project Octopus can read that kind of data.
Regards,
Hugo
I think not, because i think Project Octopus can only read the first number of a specific cell in Excel.
Can you confirm if i am right?
Thanks,
Hugo
Sorry but i cant accept your offer, since im Portuguese i surely can suggest you a bottle of good Portuguese wine from the Douro Valley !
Hugo
ah yes true 🙂
your code is nicer then mine. Mine has more than 6 lines 😞
oh and Australian wine is best in the world no? Well, we think it is.............
Hello,
Is it possible to select only one type of bar through octopus? for example: If i want to extract only the bars that have RC Columns defined as their section type.
I would appreciate some help 🙂
I browsed Autodesk Labs/downloads and download Project octopus.exe .
It requires visual studio 2012 updates , is there a method to download only these files without installing visual studio 2012 ?
Hi,
I tried to insert Plastic modulus values (Zy)of section and it seems it is not working properly, it gives small value which is not corresponding to the correct value of the sections.
This is an example to what I mean:
=RSA_SECTION_DATA("ZY","HSSQ 4x4x0.1875")
Please fix.
@StefanoPasquini6790 wrote:Well,
you can write a VBA routine that create a selection group in excel starting from the Robot selection string. Use the Visual Basic text function or the excel text function.
Greetings
I've just started using Octopus. I am not familier with VB. Can someone explain this to me more accurate, maybe with some examples?
I want to extract global extremes (Fx, Fy, Fz) in every pinned support for load combination 50to350. Every little help is very appreciated!
Thanks in advance!
Thanks, that is helping, but I want to extract these values for more than one node at a time. Now I manually have to do this for every node and manually copy/paste cells?
Or is it something I'm missing?
So maybe this:
http://forums.autodesk.com/t5/robot-structural-analysis/local-reactions-api/td-p/3791474/page/2
or check this thread:
http://forums.autodesk.com/t5/robot-structural-analysis/useful-addins-for-robot-api/td-p/3899448
Hi,
I had only ten minutes but I hope that you can develop this spreadsheet by your own.
In this spreadsheet you have to chose the Robot number, the start combination number and the end combination number and the macro define a link with robot for you needed reactions. To use only this you can set one sheet for each node that you have to investivate. Once created you linked file, when you run calculation and modify the data you have only to press F9 in excel spreadsheet to update all the values, so you create the linked file only one time.
Sorry for my basic programming but I can't make it better in few minutes.
Cheers
Can't find what you're looking for? Ask the community or share your knowledge.