Forum Discussion
I need help finishing my spreadsheet.
I could fuel up as many times as 7 in a week. Each fuel has 3 elements Truck, reefer, and def. Truck and Reefer cost the same. Def is cheaper. Each time I fuel there is varying amounts and varying costs. I need an easy way to enter each fuel stop ticket and then get an average fuel cost. I need the 3 together to come out as my total fuel cost.
Then I would like the weekly to be able to be seen in a monthly, and ultimately the monthly to be seen in an annual spreadsheet.
Is it possible for someone to do this for e or point me in the direction where i can get it finished?
Thanks!
Hi Eric,
First you shall organize your source data as connected to dates. Other words have tables against dates for your mileage, fuel purchases, earnings, etc. Ideally for each day when you drive (for mileage) or transaction happens, but that could be summary for few days.
After that most universal solution is to build the data model using Power Query/Power View adding the measures you need and summarise them by Pivot Tables for weekly/monthly/annual periods.
Alternatively you may build your summary by formulas separately for weeks, months and years. In the attached file Sheet2 few formulas for weekly stats, the rest is similar.
