Author Topic: TABLE EDIT POLYLINE  (Read 15868 times)

vagk_18

  • Jr. Member
  • **
  • Posts: 33
TABLE EDIT POLYLINE
« 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.

Lars

  • Administrator
  • Hero Member
  • *****
  • Posts: 664
Re: TABLE EDIT POLYLINE
« Reply #1 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
« Last Edit: January 29, 2015, 08:21:25 PM by Lars »

vagk_18

  • Jr. Member
  • **
  • Posts: 33
Re: TABLE EDIT POLYLINE
« Reply #2 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.

Lars

  • Administrator
  • Hero Member
  • *****
  • Posts: 664
Re: TABLE EDIT POLYLINE
« Reply #3 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