Uploaded image for project: 'Great Lakes to Gulf Virtual Observatory'
  1. Great Lakes to Gulf Virtual Observatory
  2. GLGVO-7

USGS script: generate estimated or calculated values

XMLWordPrintableJSON

    • Icon: Task Task
    • Resolution: Done
    • Icon: Normal Normal
    • 0.1
    • None

      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).

              brock Brock Angelo (Inactive)
              brock Brock Angelo (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: