Linking Point elevation to Excel

[Anonymous]

Can I somehow link my point elevations to an Excel Spreadsheet? I have fives
monitoring wells and once a month I recieve data. I input the five vaules
into excel and get elevation averages. Then I go into my drawing and change
the point elevation for each of the five wells, (from my spreadsheet
information) then rebuild the surface and contours. So my question is how
could I get the new cells from Excel to automatically transfer the well
elevation to my drawing point elevation? Asking too much?

[Anonymous]

Hi,

It's certainly possible, but it requires some custom programming.

You would be strongly advised to do the coding in AutoCAD to run the Excel
from AutoCAD rather than running AutoCAD from Excel.

If you only do this once a month for only 5 values, you may find the capital
cost of the custom programming will never be recovered.
--

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

"Robert" wrote in message
news:5540447@discussion.autodesk.com...
Can I somehow link my point elevations to an Excel Spreadsheet? I have fives
monitoring wells and once a month I recieve data. I input the five vaules
into excel and get elevation averages. Then I go into my drawing and change
the point elevation for each of the five wells, (from my spreadsheet
information) then rebuild the surface and contours. So my question is how
could I get the new cells from Excel to automatically transfer the well
elevation to my drawing point elevation? Asking too much?

[Anonymous]

Just a thought, and it's an ugly one.

You can make a profile from a text file. Find the format in help. Output
from Excel to that format, then use that profile to drive a corridor with
just those PIs and no real sections (a marked point only corridor, one of
Dana's faves.) Set the sampling interval really high, so that is just hits
the PIs, and build from the feature line basically. Just a thought. Then you
just have to export a new txt file every month and hit update. Probably not
much less work than the manual update to be honest.

--
James Wedding, P.E.
Engineered Efficiency, Inc.
Civil 3D 2007
XP Tablet, SP2, 2GHz, 2G
www.eng-eff.com
www.civil3d.com

[Anonymous]

I know it's not the answer you're looking for, but.

Why not insert them as points?
1) Have a point group defined as your monitoring wells (Defined by raw
description)
2) Use points to define the surface using the point group
3) delete old monitoring well points
4) import new monitoring well points with updated elevation
5) rebuild surface

after the initial setup, you'd just have to do steps 3 4 and 5

Basically, I'd have 2 excel sheets. One is your master that you spoke of.
The second is a *.csv file with P,N, E, Automatic Elevation from Master,
Description. The *.csv is what I would then import to the drawing.

--
----
Sorry, nothing snappy here to say.
"Robert" wrote in message
news:5540447@discussion.autodesk.com...
Can I somehow link my point elevations to an Excel Spreadsheet? I have fives
monitoring wells and once a month I recieve data. I input the five vaules
into excel and get elevation averages. Then I go into my drawing and change
the point elevation for each of the five wells, (from my spreadsheet
information) then rebuild the surface and contours. So my question is how
could I get the new cells from Excel to automatically transfer the well
elevation to my drawing point elevation? Asking too much?