I need to drop the elevations in an ascii point file by a certain distance.
My software has decided it does not want to do this today and of course I need it out of here today.
email is current in profile.
Thanks in advance.
What software are you running? If it's Carlson, I may be able to figure it out.
When you say by a certain distance, do you mean like a radial area around one point and only clip those points?
Paste the ASC data into excel. Do text to columns by delimiter and choose comma. Then in a blank column put the equation in = Elevation cell + or - The datum shift. Then drag that down to cover all the rows. Select the new elevation column and copy and paste VALUES into the old elevation column. They should now be correct and you can delete the column with the math in it. Save this as a CSV comma delimited file. Then you can change the extension back to txt or asc or whatever you want.
Wow! That seems a lot more complicated when written out like that. In my head it was pretty quick and easy, but I guess it's a lot of little steps.
Already done ?. Just like you said.
Thanks,
Scott Hurtt has helped me out of my jam.
What a place this is.
Thanks again
Randy
Modest Excel Skills
It doesn't take a big investment in time or money to acquire some modest excel skills. Very handy thing for a surveyor to have in the tool box. Head on down to your local Office Depot and drop $20 for the Learn-to Excel CD and spend an evening. You won't be sorry. If that is too much for you there are plenty of free youtubes.
Even if you don't have Office, a nearly identical program, Open Office's Calc (also Libre Office's Calc), is available for free.
FREE! Free Survey Software and FREE training! No strings! No 30 day demo! No upgrade to the PRO version! No salesman will call. FREE!! If you will take it.
> Paste the ASC data into excel. Do text to columns by delimiter and choose comma....
I'd edit commas into the PNEZD list, if necessary, using search and replace in Notepad. Then save that notepad file as a .csv. Then double click on that file name to open in Excel.
>... Then in a blank column put the equation in = Elevat......ion column.
I would make use of a second worksheet. Copy the contents of the first row of columns, by formula, to the same columns of worksheet 2. For the elevation column of worksheet 2 edit the formula to add/subtract the elevation offset to the elevation column of worksheet 2. Then copy the formulas for all columns down the stack as far as you need to. With worksheet 2 open, saveas a .csv file. You will get a comma delimited file of the amended values.
Personally, I'd also save a copy of the multi worksheet spreadsheet as a .xls file for future reuse and backup.
for future reference
POINTS
POINT UTILITIES
ELEVATION FOR POINTS
you are looking for the DIFFERENTIAL option.
Modest Excel Skills
:good: :good: :good:
I use Excel all the time, very useful program.
It is great for manipulating point lists, moving columns, booting, etc.
