I have a table that contains tank data...(increment factors)
gauge - contains floating point data in 0.01 feet - primary key
multiplier - contains floating point data in volume per gauge
index - contains floating point data in volume at gauge
gauge - there is no gauge for every 0.01 feet...it is a reference point as follows:
gauge = 0.0 = no multiplier = 44.1345 index volume
gauge = 0.08 = 8.9035 = 115.7775
what this means is that from 0.0 to 0.8 you multiply 8.9035 times the number of gauge values then add it to the 0.0 index volume (44.1345 in this case) to get the actual volume at any of the intermediate gauges...