Fuel Consumed Columns Summary/Statistics

Hello GT,
Any news?

Hello mars, thank you for answering.
I'll try to describe better my ideas.

Problem:
The consumed volume by FLS it's different when consider by Engine Hours, Trips and Summary reports. The value that our clients uses are provided by the summary report only, but it doesn't have many metrics as the others.

The value:
As shown in the first screenshots, there is a significant difference happening when you use the values of consumed during the engine hours or trips to summary, probably caused by the imprecision of the FLSs during the vehicle with engine off. The right value theoretically to use was the difference of the inicial and final value of the fuel level + the fueled volume, so it would be possible to have the right average from the fleet. This value already exists and it's on the summary report, but as I said before, the report doesn't provide the metrics of consumed volume with/without movement neither engine hours with/without movement, so that will be possible to calculate the average wiht/without movement.

It's possible to use the engine hours/trips, but the difference of the real total consumed volume will reach many times around 10%.

Idea:
Adding the fields of consumed volume with/without movement and engine hours with/without movement (for whole period) in the summary report.

Users:
They will be able to calculate the average of the vehicle with/without movement for the whole period.

-

About Statistcs, the problem is basically the same, the averages aren't based in the calculation from the whole period. Our priority is the columns in the summary report.

Hello mars,

Yes, that's right, because in summary we can run the report with group of vehicles and can manipulate some collumns in the calculator, but let me try to explain it again in a different way why we need these columns in summary:
We used to monitor fuel in Omnicomm platform, the platform from the trackers and sensors we use. This system can only calculate fuel consumption like the summary report:

Fuel Consumed = Fuel Fueled - Fuel Theft +  (difference between the inicial and final volume)

The way that trips and engine hours calculate the fuel consumed is different and are the only reports that contain columns with engine with/without movement and fuel consumed with/without movement. Without these columns in the report summary we can't calculate some averages like average with movement (km/l and l/h) and average without movement (l/h).
in the screenshot and excel file I'm sending, you can notice the difference of fuel consumed and averages between both platforms: the values we believe that must be used are the ones that is coming from the Omnicomm, because it consider the total volume of the fuel filled in the vehicles and the difference is slightly high.

Hi Fernando Brochetto,

After another round of explanation here is a brief summary:

1) the data on consumed fuel in the summary table and statistics are correct for you, but using the summary table is a priority as a) it has the calculator to calculate the averages you need and b) it can be applied to a group of units.

2) I will note down your idea on adding columns Consumed by FLS in motion/Consumed by FLS without motion and Engine hours (In movement)/Engine hours (Idling). Basically, these are two additional columns in the table with numerous of other columns. And here is the thing: we are adding the columns that will only make it 'heavier' to work with reports for an absolute majority of users, but may be useful for 1 or 2. With this said, we want to be more careful with adding something that will be not utilized actively.

3) you still can use the Statistic table for the necessary operation: although with the limited functionality (only for 1 unit and all the mathematical operations will need to be performed in the exported file), it has all the values you look for.

Hello mars,
I found another case where I need to have the values of fuel spent without movement, please look the screenshot.
Today we started installing FLSs in Concrete Boom Pumps. These trucks have two engines and two fuel tanks (it's like two vehicles in one). The problem is that from CAN bus we can only get the engine parameter from the tank of the principal engine, the engine from boom pumps we are not having parameters.
The only place this fuel spent appears is in statistics table: fuel consumed without motion or the total value in summary report.
Another thing is that the only place this fuel appears separated is in the reports by units: by groups appears only the total volume of the fuel.
Is there any way of making appear the values from both fuel sensors in reports by group?

hi, Fernando. Fernando Brochetto

this request is noted down, but it is not approved for development so far.