Home

Calculating MPG including Partial Fill-ups

%3CLINGO-SUB%20id%3D%22lingo-sub-1054378%22%20slang%3D%22en-US%22%3ECalculating%20MPG%20including%20Partial%20Fill-ups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054378%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20way%20to%20calculate%20MPG%20even%20when%20there%20are%20not%20total%20fill-ups.%26nbsp%3B%20Example%3A%20Gas%20prices%20are%20lower%20in%20the%20next%20state%20so%2C%20I%20only%20purchase%20%2425%20of%20fuel%20to%20get%20me%20to%20the%20cheaper%20fuel.%26nbsp%3B%20When%20I%20get%20to%20the%20next%20location%20and%20fill-up%20I%20do%20not%20want%20to%20rely%20on%20memory%20or%20get%20out%20of%20the%20practice%20of%20entering%20every%20purchase.%26nbsp%3B%20So%2C%20can%20Excel%20calculate%20this%20easily%20with%20a%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20spreadsheet%20I%20added%20a%20box%20which%20I%20can%20check%20if%20it%20is%20a%20partial%20fill-up.%26nbsp%3B%20Does%20anyone%20know%20how%20or%20have%20suggestions%20or%20know%20how%20to%20accomplish%20my%20need%20in%20Excel.%26nbsp%3B%20Thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1054378%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054761%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20MPG%20including%20Partial%20Fill-ups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481247%22%20target%3D%22_blank%22%3E%40Hobo_the_Wonder_Dog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20radical%20suggestion%2C%20since%20you%20don't%20want%20to%20rely%20on%20memory%3A%20%3CSTRONG%3Epaper%20and%20pencil.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20little%20notebook%20with%20you%20in%20your%20car%20and%20%3CEM%3Ewrite%20down%20the%20amount%20of%20gas%20purchased%20%3CU%3E%3CSTRONG%3Eeach%20time%3C%2FSTRONG%3E%3C%2FU%3E%2C%20not%20just%20when%20it's%20%22partial.%22%20%3CSTRONG%3EBECAUSE%3C%2FSTRONG%3E%20%3CU%3Eit%20is%20in%20fact%20a%20partial%20fill-up%20every%20time%3C%2FU%3E%2C%3C%2FEM%3E%20even%20though%20it%20may%20be%20quite%20low.%20Assuming%20you%20want%20to%20be%20anywhere%20near%20accurate%20with%20your%20MPG%20calculations%2C%20you%20need%20not%20only%20to%20have%20the%20miles%20driven%20be%20accurate%20but%20also%20the%20gallons%20of%20gas.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055077%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20MPG%20including%20Partial%20Fill-ups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055077%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481247%22%20target%3D%22_blank%22%3E%40Hobo_the_Wonder_Dog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20your%20spreadsheet%20you'd%20need%20a%20column%20with%20last%20Odometer%20reading%20to%20get%20your%20miles%20then%20another%20column%20with%20gallons%20of%20fuel%20and%20even%20a%203rd%20with%20%24%20spent%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20attached%20an%20example%20of%20the%20type%20of%20thing%20you'd%20need%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055668%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20MPG%20including%20Partial%20Fill-ups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481247%22%20target%3D%22_blank%22%3E%40Hobo_the_Wonder_Dog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20additional%20thought%3A%20Do%20you%20have%20a%20mobile%20device%20(hard%20to%20imagine%20anyone%20who%20doesn't%20these%20days)%3F%20Especially%20if%20you%20have%20an%20iPad%20or%20equivalent%2C%20it's%20quite%20easy%20to%20have%20your%20Excel%20software%20on%20that%20device%2C%20so%20you%20can%20do%20data%20entry%20on%20a%20real-time%20basis%20and%20need%20neither%20memory%20nor%20paper%20and%20pencil%20records.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1056890%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20MPG%20including%20Partial%20Fill-ups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1056890%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481247%22%20target%3D%22_blank%22%3E%40Hobo_the_Wonder_Dog%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3Bmakes%20an%20interesting%20point%2C%26nbsp%3B%20sometimes%20we%20get%20too%20caught%20up%20in%20Excel%20so%20maybe%20an%20App%20like%20MPG%20Calc%20Free%20or%20Gas%20Manager%20can%20do%20what%20you%20want%20much%20better%20more%20easily.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1057760%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20MPG%20including%20Partial%20Fill-ups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1057760%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481247%22%20target%3D%22_blank%22%3E%40Hobo_the_Wonder_Dog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EActually%2C%20Hobo%2C%20with%20your%20mobile%20device--most%20likely%20either%20an%20iOS%20or%20an%20Android%20system--you%20have%20immediate%20access%20to%20Numbers*%20or%20Google%20Sheets*%2C%20either%20one%20of%20which%20(though%20neither%20is%20up%20to%20all%20of%20Excel's%20capabilities)%20is%20fully%20capable%20of%20tracking%20and%20calculating%20MPG.%20You%20can%20have%20all%20the%20satisfaction%20of%20creating%20your%20own%20app.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20little%20spreadsheet%20in%20Numbers%2C%20for%20example%2C%20that%20I%20can%20use%20to%20keep%20score%20in%20Scrabble%20(so%20I%20don't%20need%20to%20use%20outmoded%20technology%20like%20paper%20and%20pencil).....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*I%20trust%20it's%20not%20a%20violation%20of%20microsoft's%20techcommunity%20rules%20to%20utter%20the%20names%20of%20these%20competitors.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Hobo_the_Wonder_Dog
Occasional Visitor

I need a way to calculate MPG even when there are not total fill-ups.  Example: Gas prices are lower in the next state so, I only purchase $25 of fuel to get me to the cheaper fuel.  When I get to the next location and fill-up I do not want to rely on memory or get out of the practice of entering every purchase.  So, can Excel calculate this easily with a formula?

 

In my spreadsheet I added a box which I can check if it is a partial fill-up.  Does anyone know how or have suggestions or know how to accomplish my need in Excel.  Thank you for your help!

5 Replies

@Hobo_the_Wonder_Dog 

 

Here's a radical suggestion, since you don't want to rely on memory: paper and pencil.

 

Have a little notebook with you in your car and write down the amount of gas purchased each time, not just when it's "partial." BECAUSE it is in fact a partial fill-up every time, even though it may be quite low. Assuming you want to be anywhere near accurate with your MPG calculations, you need not only to have the miles driven be accurate but also the gallons of gas.

Hi @Hobo_the_Wonder_Dog 

 

In your spreadsheet you'd need a column with last Odometer reading to get your miles then another column with gallons of fuel and even a 3rd with $ spent

 

I've attached an example of the type of thing you'd need

 

@Hobo_the_Wonder_Dog 

 

An additional thought: Do you have a mobile device (hard to imagine anyone who doesn't these days)? Especially if you have an iPad or equivalent, it's quite easy to have your Excel software on that device, so you can do data entry on a real-time basis and need neither memory nor paper and pencil records.

@Hobo_the_Wonder_Dog ,

@mathetes makes an interesting point,  sometimes we get too caught up in Excel so maybe an App like MPG Calc Free or Gas Manager can do what you want much better more easily.

 

 

 

 

@Hobo_the_Wonder_Dog 

 

Actually, Hobo, with your mobile device--most likely either an iOS or an Android system--you have immediate access to Numbers* or Google Sheets*, either one of which (though neither is up to all of Excel's capabilities) is fully capable of tracking and calculating MPG. You can have all the satisfaction of creating your own app.

 

I have a little spreadsheet in Numbers, for example, that I can use to keep score in Scrabble (so I don't need to use outmoded technology like paper and pencil).....

 

*I trust it's not a violation of microsoft's techcommunity rules to utter the names of these competitors.

Related Conversations
TextJoin Partial Matches?
meklund in Excel on
6 Replies