CadTools and xTurn (Vehicle Turning Software) Forum

CadTools General Category => CadTools General => Topic started by: vagk_18 on January 27, 2015, 10:43:00 AM

Title: TABLE EDIT POLYLINE
Post by: vagk_18 on January 27, 2015, 10:43:00 AM

Hi Lars,
I wanted to ask you if it's possible to change something in the table edit table.
Is it possible to make a new column for the elevation difference to seperate the elevation from the elevation diference.
Furthermore I 'd like to ask from you to provide a saving to excel format if possible as you made for the csv format.
Thank you in advance.

Title: Re: TABLE EDIT POLYLINE
Post by: Lars on January 29, 2015, 02:23:15 PM

Hi

What you are asking for is already there.
Easiest way to get values to excel is to click in upper left corner in the grid (#) to select entire grid. Then Right-klick with the mouse and select Copy.

Paste it into Excel!

If you want so save to CSV look into the Menu "File, Save to CSV"

/Lars

Title: Re: TABLE EDIT POLYLINE
Post by: vagk_18 on January 30, 2015, 02:00:39 PM

Thank you for the tip. It is very helpfull.
My problem remains as I must separate the elevations from the elevation differences.
If you can separate them to appear in different columns I 'd find it very helpfull (only if it 's something easy for you).
Thank you anyway.

Title: Re: TABLE EDIT POLYLINE
Post by: Lars on January 31, 2015, 09:17:44 AM

Hi!

I'm sorry but I will not change CadTools according to your request. It would not benefit the user interface.
As an alternative you can set up some formulas in Excel and calculate length and slope. Use "Export polyline coordinates to Excel" (Lines).
If you copy only X,Y Z columns from that workbook to the one with your formulas you will get what you want. Save your Workbook for future use

The formula for length is: Sqr(((EndX-StartX)^2) +((EndY-StartY)^2)) or (((EndX-StartX)^2) +((EndY-StartY)^2))^0,5
And for slope in percent you use: (EndZ-StartZ)/Length*100

/Lars