Per Michael's request:
For each parameter:
- If there is not a value for a parameter for a row:
- determine the count of missing datapoints between the last recorded measurement and the next available measurement, $MISSING_COUNT
- pseudocode: ABS($LAST_VALUE - $NEXT_VALUE) / $MISSING_COUNT = $INCREMENT
- Starting with the first missing datapoint value, add $INCREMENT
- With each next missing datapoint, add $INCREMENT + $VALUE_OF_LAST_INCREMENT
- Add a code designator of "E" or something that shows we estimated.
- Create a record of the formula we used to create that value, and we'll need to figure out where to store it. Possibly in the project's app.config.
We'll do this individually for each parameter (each column).