Autodesk Robot Structural Analysis

[#1]

This is the problem with Rafal's spreadsheets.  Every time one comes along, it makes you want more!

[#2]

Hahaha

I tried ROS 7 years ago, but I was not able at that time to do something. Since this lovely sheet, my interest has grown.

Pls, do not forget to upload your updated sheet on Monday.

[#3]

Ok, I've uploaded my spreadsheet hack of Rafals' original one.  

Sorry if my VB coding is a bit schoolboy style.  

It works like this.  You can select to either fix the number of decimal points, or additionally include rounding of the data by inputting into the orange coloured cells.  

If you are happy with the rounding click accept rounding. 

Then click update Robot model

Tony

[#4]

Thank you Tony for the file.

Can you please save the file in Excel 2003 version also?

[#5]

attached

[#6]

Thanks to Tony's modification I have modified macro to work on selected (by checkboxes) coordinates directions.

[#7]

Thnaks Rafal.

You are doing great job.

[#8]

I have found you nice spreasheet to round up panel counter Rafal.

I tried to use it :

importing coordinates -> not a problem

I modify some coordinates and then I try to update -> I get a the attached error.

I assume it is a misuse, can you help?

Thx

[#9]

Attached macro will work notonly with English robot interface.

[#10]

Same macro with the rounddown function.

This avoid the problem for example :

point 1 : X=6.217 -> rounded 6.22

point 2 : X=6.212 -> rounded 6.21    ---> problem

rounddown will make 6.21 in both case.

NOTe : could be roundup .... 

Rafal, I'd like to implement this in the extra addin you given to us (with this .dll ou .exe) could please either modify your addin or give us the code.

I prefer your addin as it works on nodes, panel and bars and not only pannel like in the excel sheet

Thanks again.