Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Lesson Highlights

Name of the lesson

Fuel Data Quality FieldsAnalytics

Purpose of the lesson

This document provides clear explanations and simplifies the underlying logic behind the various results users may encounter when analyzing their fuel data.

...

Table of Contents
stylenone

Operational Fuel Consumption per Hour

Galooli offers its clients three distinct methods for accessing fuel data related to operational consumption (not including fuel drops).

Below, you’ll find an overview of each option, along with recommendations on when to use these fields for optimal analysis.

Galooli Operational Consumption (Direct Reading + Estimations)

Location: Pro Fields - Summary >> Working - Generators >> Generator 1/2 Galooli Operational Consumption [Gallon US/H]

  • This field provides an adjusted assessment of fuel consumption when the detected data appears illogical or inconsistent with the generator’s KVA. This ensures reliable insights even when anomalies are present in the raw sensor data.

  • Calculation details: In case the direct reading of the fuel consumption is invalid (not in a predefined range), the estimation of the consumption is based on:

    • Final and initial fuel levels, considering drops and refuels.

    • Fuel consumption patterns observed in the generator’s operation. The average fuel consumption will be considered if the generator average operating load has not changed significantly (more than 10% change) compared to the previous week.

    • Estimated consumption derived from the generator’s load and KVA rating (load-based consumption)

Operational Consumption according to Fuel Sensor (Direct Reading)

Location: Pro Fields - Summary >> Working - Generators >> Generator 1/2 Fuel Sensor Operational Consumption [Gallon US/H]

  • This field captures a direct reading from the installed fuel sensor on-site, including potential spikes in data.

  • Calculation Details: The fuel level is measured every minute, and at the end of each day, the total fuel consumption in liters is calculated. This total is then divided by the generator's operating hours to determine the daily average fuel consumption rate

Load-Based Consumption (Estimation)

Location: Pro Fields - Summary >> Working - Generators >> Generator 1/2 Load-Based Fuel Consumption [Gallon US/H]

  • This field calculates estimated fuel consumption based on the generator's specific KVA rating and operating load. It provides a baseline for assessing whether the generator's fuel usage is reasonable and contributes to the "Data Quality" scores.

  • Calculation Details:

    • The operating load is calculated by (Avg Load Power / (Generator KVA × 0.8)). In case there is no generator power data available, a default of 60% load is used.

    • The estimation is using a different formula for each KVA, which was developed by operational expertise and manufacturer-provided data.

Fuel Drops

Galooli provides information about number and amount of fuel drops. To enable analysis, the user must configure a "Fuel Drop" event under "Fuel Events." Events

  • Total Number of Fuel Drops [Count]
    Location: Pro - Summary >> Working - Generators >> Generator 1/2 Fuel Drops
    This field displays the total number of fuel drop events detected, helping to track instances of abnormal fuel usage.

  • Total Fuel Drop [Gallon/Liters]
    Location: Pro - Summary >> Working - Generators >> Fuel Drop [Gallon US]
    This field calculates the total volume of fuel lost while the generator was not running. These drops could indicate potential issues, such as fuel theft or leakage, offering a critical tool for operational oversight.

To validate data quality and ensure only valid refueling events are considered, it is advised to use the "Fuel Data Quality - Possible Reasons" field and exclude rows with the following results:

  • "Irrational events count"

  • "Irrational events volume"

Refuels

Galooli provides information about number and amount of refuels. To enable analysis, the user must configure a "Tank Refueled" event under "Fuel Events." Events

  • Number of refuels

...

  • Location: Pro - Summary >> Working - Generators >> Generator 1 Refuel.
    This field summarizes the total number of refuel events detected each day.

  • Total Amount [Gallon or Liters] of fuel refueled -

...

  • LocationPro - Summary >> Working - Generators >> Generator 1 Refuel [Gallon/Liter]
     This fields calculated total volume of fuel refueled within the selected time range.

To validate data quality and ensure only valid refueling events are considered, it is advised to use the "Fuel Data Quality - Possible Reasons" field and exclude rows with the following results:

  • "Irrational events count"

  • "Irrational events volume"

Fuel Data Quality

The Data fields section introduces two types data quality fields, "Data Quality - Possible Reasons" and "Low Fuel Data Quality - Description", which analyze fuel data reliability and offer insights into potential issues.
Each issue is explained with actionable recommendations, such as recalibrating sensors, verifying site configurations, or replacing faulty hardware.

...