AutoCAD Land Desktop (Read Only)
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Comparing Elevations in a Spreadsheet

9 REPLIES 9
Reply
Message 1 of 10
ginopalomo
341 Views, 9 Replies

Comparing Elevations in a Spreadsheet

I have two sets of points that fall in a 25' grid. The first set has elevations established conventionally. The second set has elevations established by another high-tech method. It is easy to compare their elevations visually in the drawing, since their positional horizontal accuracy is less than 5 hundreds of a foot.

Now I'm being ask to select these points and create a Comma Delimited File (CSV) in Excel to create a spreadsheet to show their differences. Point numbers are not consecutive on these two sets. How can I do that easily? Is there any way to perform this task? We have thousands of points and doing this manually would take forever. Is there a special function I need to know about?
9 REPLIES 9
Message 2 of 10
Anonymous
in reply to: ginopalomo

If the existing elevations and the second set of elevations are in separate
layers then I can do what you want.
Send me the file.

wrote in message news:5666075@discussion.autodesk.com...
I have two sets of points that fall in a 25' grid. The first set has
elevations established conventionally. The second set has elevations
established by another high-tech method. It is easy to compare their
elevations visually in the drawing, since their positional horizontal
accuracy is less than 5 hundreds of a foot.

Now I'm being ask to select these points and create a Comma Delimited File
(CSV) in Excel to create a spreadsheet to show their differences. Point
numbers are not consecutive on these two sets. How can I do that easily? Is
there any way to perform this task? We have thousands of points and doing
this manually would take forever. Is there a special function I need to know
about?
Message 3 of 10
Anonymous
in reply to: ginopalomo

You can also sort the data by columns in Excel.

--
John Mayo
Project Engineer
Conklin Associates
Ramsey, NJ

Civil 3D 2008, LDT 2008, Raster Design 2008
P-IV at 3.5 GHz
2 GB Ram
Nvidea Quadro FX w/ 128 MB Ram
"Ran" wrote in message
news:5666079@discussion.autodesk.com...
If the existing elevations and the second set of elevations are in separate
layers then I can do what you want.
Send me the file.

wrote in message news:5666075@discussion.autodesk.com...
I have two sets of points that fall in a 25' grid. The first set has
elevations established conventionally. The second set has elevations
established by another high-tech method. It is easy to compare their
elevations visually in the drawing, since their positional horizontal
accuracy is less than 5 hundreds of a foot.

Now I'm being ask to select these points and create a Comma Delimited File
(CSV) in Excel to create a spreadsheet to show their differences. Point
numbers are not consecutive on these two sets. How can I do that easily? Is
there any way to perform this task? We have thousands of points and doing
this manually would take forever. Is there a special function I need to know
about?
Message 4 of 10
Anonymous
in reply to: ginopalomo

You can also create two surfaces and a stratum from each data set. Then,
from the grading pull down you can UPDATE points by selection and have new
points added to your grid that get the difference from the surface. All
inside LDT

--
Joe

Joseph D. Bouza, P.E.
Civil 3D 2006
LDT 2006
Win XP pro
v 2002, sp 2
hp workstation xw4100
*****************************************************************************************
In memory of the King of Work-arounds
"The only Constant is Change".

"The only thing worse than training your staff, and having them leave is -
not training your staff, and having them stay." 😮
A reminder taken from Graphics Solution Providers' Calendar page
*****************************************************************************************
"John Mayo" wrote in message
news:5666107@discussion.autodesk.com...
You can also sort the data by columns in Excel.

--
John Mayo
Project Engineer
Conklin Associates
Ramsey, NJ

Civil 3D 2008, LDT 2008, Raster Design 2008
P-IV at 3.5 GHz
2 GB Ram
Nvidea Quadro FX w/ 128 MB Ram
"Ran" wrote in message
news:5666079@discussion.autodesk.com...
If the existing elevations and the second set of elevations are in separate
layers then I can do what you want.
Send me the file.

wrote in message news:5666075@discussion.autodesk.com...
I have two sets of points that fall in a 25' grid. The first set has
elevations established conventionally. The second set has elevations
established by another high-tech method. It is easy to compare their
elevations visually in the drawing, since their positional horizontal
accuracy is less than 5 hundreds of a foot.

Now I'm being ask to select these points and create a Comma Delimited File
(CSV) in Excel to create a spreadsheet to show their differences. Point
numbers are not consecutive on these two sets. How can I do that easily? Is
there any way to perform this task? We have thousands of points and doing
this manually would take forever. Is there a special function I need to know
about?
Message 5 of 10
ginopalomo
in reply to: ginopalomo

Ran,

Thank you for offering help me with this. Here's the file, the points ARE in two different layers. In the meantime I need to investigate how to work with surfaces and "stratums" as someone else mentioned below.
Message 6 of 10
ginopalomo
in reply to: ginopalomo

Joe,

I'm using Land Desktop 2007, but I'm not sure what do you mean by the stratum. I have created surfaces before, so I'll play around with this for now.
Message 7 of 10
Anonymous
in reply to: ginopalomo

When you use Terrain Models for Earth work calculatuion you have to create
strata: a sandwhich created by two surfaces. The grading pull down ( Civil
companion) allows you to update/ create point ( on a grid or else where in
the design ) - you can use the option "difference between two surface" to
create a 3rd set of data points. Then you would have grid01 , grid 02 &
grid01-grid02.

--
Joe

Joseph D. Bouza, P.E.
Civil 3D 2006
LDT 2006
Win XP pro
v 2002, sp 2
hp workstation xw4100
*****************************************************************************************
In memory of the King of Work-arounds
"The only Constant is Change".

"The only thing worse than training your staff, and having them leave is -
not training your staff, and having them stay." 😮
A reminder taken from Graphics Solution Providers' Calendar page
*****************************************************************************************
wrote in message news:5666569@discussion.autodesk.com...
Joe,

I'm using Land Desktop 2007, but I'm not sure what do you mean by the
stratum. I have created surfaces before, so I'll play around with this for
now.
Message 8 of 10
Anonymous
in reply to: ginopalomo

Hi,

There are lots of ways of doing it.

If you wish to stay in a spreadsheet do this:

Isolate one of the layers containing Points
Make a Point Group of the points on that layer
Repeat for the other layer

Export each to the point groups to CSV files containing Point number,
easting, northing and elevation
Insert each file into separate worksheets in Excel
Sort each worksheet by Northing, then Easting
Copy the A,B,C and D columns from one worksheet to columns H,I,J and K in
the other worksheet
In column E create a difference value between the Eastings in columns B and
I
In column F create a difference value between the Eastings in columns C and
J

Use an If value in the formula so that the value only displays if the
difference exceeds 0.1 or some other sutiable value
Check the results to see if all the differences are OK - such that all point
rows contain matching points
If not move the data till you are satisified you have matching locations

Create the elevation difference in column G between columns D and K

However, Joe's advice to use the LDT tools and create a differential
surface is a far far better solution.

Not only does it entail less work and not require Excel, but you can plot
contours of the surface on different layers to get different colours for cut
and fill, and plot the zero contour to get the boundary of cut and fill etc.


--

Laurie Comerford
CADApps
www.cadapps.com.au
www.civil3Dtools.com


wrote in message news:5666075@discussion.autodesk.com...
I have two sets of points that fall in a 25' grid. The first set has
elevations established conventionally. The second set has elevations
established by another high-tech method. It is easy to compare their
elevations visually in the drawing, since their positional horizontal
accuracy is less than 5 hundreds of a foot.

Now I'm being ask to select these points and create a Comma Delimited File
(CSV) in Excel to create a spreadsheet to show their differences. Point
numbers are not consecutive on these two sets. How can I do that easily? Is
there any way to perform this task? We have thousands of points and doing
this manually would take forever. Is there a special function I need to know
about?
Message 9 of 10
Anonymous
in reply to: ginopalomo

Write me directly to navaran@zahav.net.il
wrote in message news:5666566@discussion.autodesk.com...
Ran,

Thank you for offering help me with this. Here's the file, the points ARE in
two different layers. In the meantime I need to investigate how to work with
surfaces and "stratums" as someone else mentioned below.
Message 10 of 10
Anonymous
in reply to: ginopalomo

Attached xls file

wrote in message news:5666566@discussion.autodesk.com...
Ran,

Thank you for offering help me with this. Here's the file, the points ARE in
two different layers. In the meantime I need to investigate how to work with
surfaces and "stratums" as someone else mentioned below.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report