best method of inserting Excel Data into a Site Model

[Craig D.S.]

Pasting the data into a text file, and Import Survey File does not seem to import all cell data.

So what are the best ways to import one's Excel spreadsheet data into a Site model

[Jonathan Pickup]

export the text file as a simple text document with the following format:

id Northing Easting Elevation Description

nothing else.

then use the import survey command.

[Craig D.S.]

Thanks for replying Jonathan.

I should have stated that the Excel file has only Z height values, and is not the regular survey data file.

that was why I was having trouble in this case.

I can open the tab delineated text file in AccuTrans 3D, save it as a DXF, import that into VW and build the site model around that data.

There does not seem to be an internal way to only insert Z height values...

[Bryan G.]

with only z values I do not believe you will get anything as there is no x-y value.

[Bryan G.]

I think that will give you various elevations at one point 0,0

[Craig D.S.]

As I'm not very familiar with survey files...How do I insert the extra fields for the" id Northing Easting Elevation Description

"?

is ID from 0 to n-1?

Can Northing and Easting be 0,1,2 etc

And I'm not uure of description

I guess I'd better study up on this.

[Bryan G.]

let me first start by asking do you have a survey file from a surveyor? Or are you generating this from scratch.

[Craig D.S.]

I'm generating this myself, from spot elevations a metre apart, to make a 21x21 or 25x25 grid, which can then be visualized in 3D Surface Charts