"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"
