Discussion Groups

Robot Structural Analysis

Reply
Valued Mentor
tony.ridley
Posts: 652
Registered: ‎09-07-2011

Re: Panel contour points modification

04-13-2012 08:11 AM in reply to: sergey.churilov

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

 

 

Please use plain text.
Valued Contributor
sergey.churilov
Posts: 59
Registered: ‎04-12-2012

Re: Panel contour points modification

04-13-2012 09:11 AM in reply to: tony.ridley

Hahaha :smileyhappy:

 

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.

Please use plain text.
Valued Mentor
tony.ridley
Posts: 652
Registered: ‎09-07-2011

Re: Panel contour points modification

04-14-2012 07:25 AM in reply to: sergey.churilov

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

 

Please use plain text.
Valued Contributor
sergey.churilov
Posts: 59
Registered: ‎04-12-2012

Re: Panel contour points modification

04-14-2012 11:44 PM in reply to: tony.ridley

Thank you Tony for the file.

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

Please use plain text.
Valued Mentor
tony.ridley
Posts: 652
Registered: ‎09-07-2011

Re: Panel contour points modification

04-16-2012 01:20 AM in reply to: sergey.churilov
Please use plain text.
Product Support
Rafal.Gaweda
Posts: 4,978
Registered: ‎04-26-2010

Re: Panel contour points modification

04-17-2012 06:08 AM in reply to: tony.ridley

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



Rafal Gaweda
Please use plain text.
Valued Contributor
sergey.churilov
Posts: 59
Registered: ‎04-12-2012

Re: Panel contour points modification

04-17-2012 06:12 AM in reply to: Rafal.Gaweda

Thnaks Rafal.

You are doing great job.

Please use plain text.
Valued Mentor
t.sautier
Posts: 353
Registered: ‎12-14-2012

Re: Panel contour points modification

03-20-2013 01:59 AM in reply to: tony.ridley

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

 

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 4,978
Registered: ‎04-26-2010

Re: Panel contour points modification

03-20-2013 07:10 AM in reply to: t.sautier

Attached macro will work notonly with English robot interface.



Rafal Gaweda
Please use plain text.
Valued Mentor
t.sautier
Posts: 353
Registered: ‎12-14-2012

Re: Panel contour points modification

03-20-2013 07:51 AM in reply to: Rafal.Gaweda

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.

 

Please use plain text.