Stage storage volumes are a common request from clients and engineers. Rather than using Civil 3D’s stage storage function we use a more dynamic and accurate technique here that is easily replicable and verifiable. Like anything, the more you do it the quicker it becomes and the less you’ll need to revisit this post!
Step 1 – Basin surface
Starting with the basin surface you want to query, in this case a mine pit shell, find a contour near where it looks like water would spill out over if filled to the brim. ‘ID’ this contour with OSNAPs to get an approximate Z value for the next step.
Step 2 – Level surface
Draw a rectangular polyline around the basin surface, then in Properties assign this Z value. Create a new surface named “Level” or similar and edit the Surface Style to display Triangles and/or Border only. Add this polyline as Contour to the surface.
Step 3 – Volume surface
Now we are going to generate a polyline that represents the intersection of the Pit shell surface and Level surface. The command ‘CreateSurfaceComposite‘ will do this. Select ‘Level’ as the top surface and ‘Pit shell’ as the bottom surface. This will create a Volume surface. Edit the Surface style so only the major contour is on and the interval is set to a large number such as 25000. Hit OK and then make sure it is set to Rebuild Automatically.
Step 4 – Extracting the boundary
What you are looking for now is that this boundary line is unbroken, but only just. You are trying to get the maximum level just before water starts spilling out, so keep raising or lowering the Level surface until the volume surface boundary line is unbroken. Then extract this line and apply it as a boundary to the Level surface.
Step 5 – Insert Elevations table
Now we can get into using Civil 3D smarts for our stage storage. From the Annotate tab > Add Tables > Add surface legend table button select the volume surface from step 3. We want an Elevations table, select Dynamic, then click somewhere convenient to insert the table. This should produce an empty table with a few headings. Now we will populate it.
Step 6 – Create Elevations Data
In the Volume surface properties select the Analysis tab > Elevations for analysis type. Select ‘Range interval with datum’ and then enter the resolution you want the stage storage to be calculated at. Civil 3D 2018 is limited the 200 rows so I typically enter somewhere between 1-5m.
Step 7 – Create Volume data
Once you hit OK the table from step 5 will populate. Now we need to get the right information in this table for exporting into a spreadsheet. Edit the table style and make sure there is an Elevation and Volume column. You can also add an Area column if required. Use the + and x buttons found on the right-hand side to add and delete columns. Give each column a title and double-click on the column value box to bring up the contents editor. In Properties drop-down select the data field you’re after then hit the right arrow to add it.
Step 8 – Export CSV table
Now your table has all the relevant info we need, explode it twice to get it down to the entity level. Here we need to use an external lisp routine called COT.lsp (click to download). Type Appload then locate this file. At the command line enter COT to run it. Draw a box around the exploded table to create an AutoCAD table, then right click on it, select Export and saved it as a CSV file.
Step 9 – Organising Excel data
Open Excel and drag in this CSV file. In the top elevation cell type in the RL of the Level surface from step 4. Make sure there is a volume next to it and not a zero. Below that elevation cell, type in the next lower elevation at the correct increment, i.e. 440m top then 338m below that, and double click in that cell’s bottom right corner to populate all cells down automatically.
Step 10 – Complete stage storage
Here I like to flip the data so that the cumulative volume increases as you go down the page. Select all cells and in the Data tab > Sort from smallest to largest. To finish the Stage Storage calculation you need to create a new column to the right of the volume column for Cumulative volume. Referring to the image below, in cell C5 type ‘=B5’ then in the cell C6 type ‘=C5+B6’ and double click in that cell’s bottom right corner to populate all cells down automatically. Double check that the final cumulative volume matches the volume Civil 3D calculated in the Volume surface properties from step 3.
That’s it! 10 steps that amount to half an hours’ work or less. Typically the client or engineer will not require a graph but if they do Excel makes it simple with Insert > Charts.