Contributor
Posts: 14
Registered: ‎07-20-2007
Message 1 of 10 (124 Views)

# Comparing Elevations in a Spreadsheet

124 Views, 9 Replies
07-23-2007 05:55 AM
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?
*Ran
Message 2 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-23-2007 06:04 AM 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
*John Mayo
Message 3 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-23-2007 06:32 AM 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
*Joe Bouza
Message 4 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-23-2007 08:07 AM 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." :-o
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
Contributor
Posts: 14
Registered: ‎07-20-2007
Message 5 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-23-2007 11:08 AM 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.
Contributor
Posts: 14
Registered: ‎07-20-2007
Message 6 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-23-2007 11:11 AM 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.
*Joe Bouza
Message 7 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-23-2007 02:46 PM 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." :-o
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.
*Laurie Comerford
Message 8 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-24-2007 03:45 AM 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
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
*Ran
Message 9 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-24-2007 07:41 AM 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.
*Ran
Message 10 of 10 (124 Views)

# Re: Comparing Elevations in a Spreadsheet

07-25-2007 05:10 AM 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.

### You are not logged in.

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.