Consumption km/L field, I need a formula like this.
The odometer will have several columns, that is, to record the data in and out of the factory. There will be a total of 6 refills.
Each day is filled about 3-5 times, but the calculations are calculated across columns.
e.g. ( odometer 1 - odometer 5 ) / liter of that column
Are you recording all refills in one row or across multiple rows?
YES
For example, In odometer, day 1 minus day 2 equals the running distance field of line 2.
Next line, subtract date 2, date 3 to get the runnin value of line 3.
And do you have one item you are tracking odo for? Or multiple?
i am just trying to wrap my head around exactly what part you are having trouble with.
if you had to do this in excel/sheets, would you be able to do this?
In odometer = keys
Runing Distance = Calculate
will be divided into 3 columns
1. Date
2.In odometer
3.Runing Distance
the key is
1) 1/5/22 In odometer = 11245 Runing Distance =
2) 2/5/22 In odometer = 11546 Runing distance = 301
3) 3/5/22 In odometer = 12546 Runing distance = 1000
4) 4/5/22 In odometer = 12364 Runing Distance = 182
(Running Distance is to subtract In odometer yesterday and In odometer today and keep deleting this way)
User | Count |
---|---|
41 | |
30 | |
29 | |
16 | |
14 |