Intern:Quality flags

For a list of Quality flags used in PANGAEA, see Quality flag.

Below detection limit (BDL)
A: Values for BDL are defined for parameters:
 * Replace BDL in data column with

B: Values for BDL are not defined for parameters:
 * * Replace BDL in data column with

Problem: is automatically formatted and decimal places of column format are added. The format can vary in dataset, e.g.,  ,  , ...

Solution: This can be set using formatting. Example: If you want to have at least 2 decimal places but maximum 5 you can put the format  in 4D. All numbers ending with 0 are then without the 0 (e.g. 0.4560 would be 0.456).

If you put  then all 0s at the end are omitted and the numbers in that column have maximum 3 digits.”

Be careful, because all last “0” will disappear!

See: