Reading a value from an existing cell
Do a calculation on it and enter the value in the table..
And so on..
What I'm trying to do is a fuel consumption calculator.
What I do today, every time I fuel the motorcycle, i take a picture with my cell phone of my mileage, and the amount of fuel I fueled and how much it cost.
Then when I get home I put the data into Excel and there it's easy to calculate.
In the first cell I write the date.
The new mileage value minus the previous one, that's the range I've driven.
This is the second cell.
In the third cell I write the value of the second cell (the range I traveled) divided by the amount of fuel, this is the average consumption.
In the fourth cell the quantity in liters, and in the fifth the cost.
What I've been able to do so far (on my first day in the apps)
It's just to write the data to a CSV file and display it.
But I couldn't figure out how I take them and do calculations on them to insert a new value with them.
Any chance of help? Or give me direction?
Maybe I should do it in Google Sheets and not in CSV?
Attached File
Thanks to everyone who can and is willing to help!!
Delek.aia (4.6 KB)