If the Excel file contains point data (each XY coordinate pair in the data file is an individual point), you can create a post map.
You can use this grid file to create maps. That will create a grid file from your data. In the Grid Data dialog, select the X, Y and Z columns from the data file, and choose any gridding options you want (or accept the defaults).Click Home | Grid Data | Grid Data, select the data file and click Open.If the X, Y and Z coordinates in the grid file are all in meters, then the volume is reported in m 3 (and surface area is X*Y, or m 2).If your data file has XYZ data and you would like to create a contour map or other grid-based map type, follow these steps: Note that the units of the volume are in X*Y*Z. The volume calculations will not include the areas that are blanked. Enter your desired input for the Upper Surface and Lower Surface and click OK. You can calculate between a grid file and a horiztonal surface, or between two grid files. The volume calculations calculate the volume between two surfaces. In the Grid Volume dialog, the grid file will be entered as the Upper Surface.Once the grid is blanked, so that there is only data inside the area you want (you may want to create a contour map first to confirm this): Then click Grid | Blank, select the grid file and click Open.If it is a 1, change it to a 0, save and close the file. Once the BLN file is created, be sure to open the BLN file in the Surfer worksheet and confirm that cell B1 shows a 0 (zero), which tells Surfer to blank outside the polygon in the BLN file.If you need help creating a BLN file, please see the article How can I create a BLN file in Surfer?. Create a BLN file containing the polygon you want to blank outside of.Grid the data over the entire rectangular bounding box.The area outside the desired polygon area can be blanked using a BLN file that describes the boundary of the polygon. Step 1: Blank the Grid File to the Desired Area The blanked areas are not included in the volume calculations and are separated out in the surface area calculations. In Surfer 13 and previous, you will need to blank the grid file outside the polygon defining the area using Grid | Blank, and then use the Grid | Volume command. Save this file if desired by clicking File | Save As in the report window.
Click OK and a Grid Volume Computations report is generated.Toggle Volume Inside, and choose whether to calculate for all polygons on the map layer or just the selected polygon(s).In the Polygon Boundary section, choose a base map containing your polygon from the dropdown list, or click Browse to navigate to and select your vector file.If your z units are not the same as your x and y units, enter the appropriate Z Scale Factor to convert from the z units to the x and y units.Since volume is calculated between two surfaces, in the Lower Surface section, either choose a different map layer or browse to a grid file for the lower surface, or set a constant Z value.In the Upper Surface section, choose a grid-based map from the dropdown list, or click Browse to navigate to and select your grid file.If you need help creating one, please see the article How can I create a BLN file in Surfer?.
Create a vector file containing the polygon.
You can choose to add this to the map as a base layer, if desired.