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.
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
Thanks to Tony's modification I have modified macro to work on selected (by checkboxes) coordinates directions.
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?
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