Skip to main content

FORMAT_DGA

FORMAT_DGA

Formula​

=FORMAT_DGA(samplingDate, hydrogen ,methane ,ethane ,ethylene ,acetylene ,carbonMonoxide ,carbonDioxide ,oxygen ,nitrogen)

Description​

This formula is the first formula you should apply to the DGA data. This formula normalises the format of the DGA so the rest of the formulas in xDGA can consume this data.

The formula takes the Sampling Date and each of the gases in the DGA as inputs.

The Sampling Date is expected to be in a date format recognisable by Excel. Each of the gas concentrations is expected to be in ppm or µl/l units.

Output​

The output is a formatted string that is ready to be consumed by the rest of the xDGA formulas.

{
  "samplingDate": "2023-01-31T00:00:00.000Z",
  "hydrogen": {
    "value": 250,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  },
  "methane": {
    "value": 30,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  },
  "ethane": {
    "value": 5,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  },
  "ethylene": {
    "value": 3,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  },
  "acetylene": {
    "value": 2,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  },
  "carbonMonoxide": {
    "value": 100,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  },
  "carbonDioxide": {
    "value": 1000,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  },
  "oxygen": {
    "value": 3000,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  },
  "nitrogen": {
    "value": 12000,
    "unit": { "name": "Parts per Million", "symbol": "PPM", "base": 1, "family": "Concentration" }
  }
}