Creating APDV Files - Analyte Data Measured at Points

Creating APDV Files - Analyte Data Measured at Points

Begin by selecting the Tools tab, and select Generate APDV File.

Note: this topic builds upon Creating AIDV Files and assumes that you have completed that topic.

Let's browse to the folder shown and select the file Railyard-soil.xlsx

This file has three sheets and for this example, we'll choose the second one. This particular sheet has Z coordinates represented as both true Elevation and Depth below ground surface. Both are commonly used and it is not uncommon to see both in a database as a convenience for people working with the data. Our exporter can use either one and there is no technical advantage of one over the other. However, the data file created will retain the Z coordinate option selected.

Since we used True Elevations for AIDV files, let's work with Depths this time. The correct settings are:

Please note that Top, which is our Ground Surface must be in true elevation since it is the reference surface used to define depths. Depths are always positive numbers with greater depth corresponding to lower elevations.

With all of our settings correct as shown above, all we need to do is click the Generate APDV File button, and let's call the file railyard-tothc.apdv.

In notepad++ our file looks like:

and if we look at this file in Studio with Z-Scale of 5 it is:

© 1994-2017 kulunsoft.com