Customer Comment from BHP

Sandra Ainsworth, Environmental Engineer , Pinto Valley Op'ns, BHP Copper Inc.

"Stuart, THANK-YOU so much. This calculation made my life so much easier.

We have 50 or so ponds on site that we have to measure capacity remaining to ensure that we have sufficient volume available in the event of a 100 year event. (We had a 100 year event in February and were on the brink of a catastrophe). This is required by a consent decree issued by the US EPA.

We take staff readings once a month and enter them into the database. I created translation grids for each pond which turns the staff reading into a pond volume. Then for each pond I have to calculate the volume remaining and then compare that to the BMP level (the volume we are required to have available). Instead of creating constants and calculations for each pond, I created a compliance grid with the maximum volume for each pond and the BMP level for each pond. This way, I only had to create two calculations instead of 50. I ran the script you sent today and it worked perfectly.

The whole point of the story is that I could use a table similar to a compliance grid for many purposes.

Thanks,  Sandra"

Quick links: