Importing Cross Section Data from Excel - CS Software Help
ESurvey Section allows you to import data from 5 different types of excel formats – Layers, Series, Classic, Fixed Distance and Field Book.
1. Click on ‘Template’ button on the toolbar and select each of these options and open the templates.
These are sample data files for various templates
A. Layers: Use this template if the input data is available layer wise.
B. Series: Use this template if the input data is available section wise.
C. Classic: Please note that there are 5 different worksheets in this template and you need to select the template depending on the number of columns of data you have.
D. Fixed Distance: Use this template if the input data is available at standard distance.
E. Field Book: Use this template when you have survey data created from auto level.
2. To understand the column names better, open and see C:\ESurvey\ESurveyCADD\Sample\Series.xls which is a readily available in sample folder.
3. There are 5 columns of data – Layer, Section, Distance, Level and Remark. ESurvey CADD allows importing data up to 20 layers.
Normally ground data are imported in Layer1 and hence you have to specify 1 as layer number. In section column, you have to specify the chainage value. In the Distance column, you have to give the distance from the centre for offsets on left side give distance in negative. In a level column, enter reduced level that is the elevation or z value of the point. You can optionally enter the remark if any. After entering the data you save the file in any location.
4. You can import data available in sample folder that is ‘Series.xls’. Click on 'Excel Import' and select ‘Series.xls’.
5. Once the data is imported, all the cross sections will be created automatically. You can navigate from a cross section to cross section in the preview screen.