Calculate New Data Based on One PCode

You can calculate new data based on other previously selected data and add it to the currently selected Working table by selecting Edit | Calculate | New Data. You are first reminded what data have been previously selected like this:

Note that you can calculate using data from the current browser or from a previously selected browser. Next the following screen appears:

All selected records having the "PCode for Existing Records" that you identify will have the equation that is specified applied to compute new values. These new values will have the PCode and CCode for "New Records" assigned, and the Station ID, Date-time, LEW, and Depth fields will all be taken from the original data. Any valid numerical computation involving the addition, subtraction, multiplication and/or division (using the +, -, *, and / operators) is allowed; the # symbol must be used as a placeholder for the original numeric result.

In the example above, for all records having a PCode of "TEMP", the Result field will be multiplied by 4.567 and added to 0.123. A new record will be added with this new computed result, the PCode will be set to "TEMP", the CCode will be set to "D", and all other fields will assume the corresponding values from the original "DO" record. The original records are not modified.