#1
|
|||
|
|||
How to calculate fuel consumption within financial spreadsheet
I keep a spreadsheet of expenditure on a monthly basis and have various categories of spending which I summarise for each month.
One category is Diesel fuel, but in order to get the most accurate figure for fuel consumption, I record the mileage each time I fully fill the fuel tank as Category 'dfull', with the actual volume of fuel purchased in an adjacent column. As I don't always fill the tank fully, I keep a note of the amount of fuel subsequently purchased simply as category 'd', recording the volume purchased as above. It's easy to automatically calculate fuel usage within a single month, provided I use another 'dfull' within that month, but often there may be a much longer interval between fills. So is there a simple way to selct the previous incident of 'dfull' and calculate how much fuel has been used, including that in the current 'dfull', in order to determine a true fuel consumption figure, knowing the total mileage covered between true fills? A sample illustrative spreadsheet is attached, which hopefully shows my dilemma. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to know expired qty based on my consumption data | Imran Laldin | Excel | 1 | 05-02-2019 05:05 AM |
Graph average monthly consumption | TimTDP | Excel | 1 | 12-03-2017 09:17 AM |
calculate spreadsheet data | ewso | Excel Programming | 3 | 07-30-2017 07:25 AM |
Financial Data Organization | captain_hawkeye | Excel | 1 | 06-14-2010 04:09 AM |
Formatting financial ratios | jtrobinson | Word | 0 | 01-19-2010 06:46 AM |