How to work out price per mile - SaabCentral Forums
*
Home Saab Pictures Saab Classifieds Saab Dealer Listings Saab Forum Saab Forum


Go Back   SaabCentral Forums > Saab Cafe > The Lounge

The Lounge For general discussions

SaabCentral.com is the premier Saab Forum on the internet. Registered Users do not see the above ads.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th March 2007
mjl mjl is offline
Active Member
 
Join Date: Jan 2004                                                
Location: Tring - Hertfordshire
My Saabs: 1999 95 Estate SE
Posts: 31
Lightbulb How to work out price per mile

Hi all you Excel types out there - little challenge for you.

I want to work out the price of a road trip in petrol, and have been struggerling to work out the required Excel formula. Any ideas anyone?

As my 9-5 show the mpg the first stage is to convert Litres to MPG and then allocate the price of each Ltr - then there must be a way of entering the distance covered and hopefully this'll give me the cost of petrol for the trip.

If someone could provide the formula or and explination of the maths it'll be good. So if anyone wants the challenge...please let me know

Or more simply can I set my display to read litres...

thanks in advance

Martin
Reply With Quote Quick reply to this message
Sponsored Links
Advertisement
 
  #2  
Old 14th March 2007
SMHarman SMHarman is offline
Saab Lunatic
 
Join Date: Jan 2006                                                
Location: Hoboken NJ
My Saabs: '03 9-3SS Vector
Posts: 2,883
Default

Quote:
Originally Posted by mjl
Or more simply can I set my display to read litres...
Yes you press two of the buttons on the SID controls at the same time. Should tell you which two in the handbook then you get to choose metric 1 or 2, Imperial and US. Metric 1 and 2 do litres.
Reply With Quote Quick reply to this message
  #3  
Old 14th March 2007
omegajb's Avatar
omegajb omegajb is offline
Saab Crazy
 
Join Date: Jul 2004                                                
Location: Washington DC
My Saabs: 2004 9-3 Arc
Posts: 601
Default

Microsoft Mappoint can do this as well. You tell it where you are going and the cost of fuel and it will calculate the totals for you.
Reply With Quote Quick reply to this message
  #4  
Old 15th March 2007
unkleG'sif's Avatar
unkleG'sif unkleG'sif is offline
Saab Lunatic
 
Join Date: Sep 2004                                                
Location: Liverpool, UK
My Saabs: 1993 T16 (xLPT) - 1994 RUBY!!!
Posts: 3,470
Default

if you know what you are getting in MPG, just divide it by 4.54 to get Miles Per Litre..... there are 4.54 litres to a Gallon..... easy peasy lemon squeezy

G
__________________
"we can allow satellites, planets, suns, universe, nay whole systems of universe[s,] to be governed by laws, but the smallest insect, we wish to be created at once by special act" - Charles Darwin


http://www.nicecupofteaandasitdown.com/

http://www.saabcentral.com/phpgallery/Gs-little-Saab
Reply With Quote Quick reply to this message
  #5  
Old 15th March 2007
cdaly's Avatar
cdaly cdaly is offline
Moderator
 
Join Date: Dec 2003                                                
Location: Dublin, Ireland
My Saabs: '92 900LPT, '90 900i vert
Posts: 4,637
Default

MPG / 4.54 = MPL (miles per litre)
MPL * distance = litres
litres * price per litre = "oh ****, I'm sorry I asked!..."
Reply With Quote Quick reply to this message
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now

In order to be able to post messages on the SaabCentral Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
If you do not want to register, fill this field only and the name will be used as user name for your post.
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:

Log-in

Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.



Thread Tools
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:10 PM.



Powered by vBulletin® Copyright ©2000 - 2014, vBulletin Solutions, Inc.

top of page | sitemap | email us



copyright © 2003 - 2011 saabcentral.com, All rights reserved http://www.whiter.co.uk - valid xhtml - valid css
SaabCentral is an independently run website and is not affiliated in any way to Saab Automobile AB.


Garage Plus vBulletin Plugins by Drive Thru Online, Inc.