EcoModder.com

EcoModder.com (https://ecomodder.com/forum/)
-   Off-Topic Tech (https://ecomodder.com/forum/off-topic-tech.html)
-   -   Calculation help (https://ecomodder.com/forum/showthread.php/calculation-help-16614.html)

Creeper 03-26-2011 11:33 PM

Calculation help
 
Ok I've been wroking on a fuel economy work book for cars made ranging from 1990 (cars sold in North America) too 2010 I'm going to wait till 2012 to update for 2011. I have the vehicles years, make, modle, engine displacement (not done cyclenders but its not that hard to figure out), Transmission, Drive train FF, RWD, AWD or 4WD, and combination of the trans with drive train. What type of fuel Reg Premium or Diesel, and yes Hybrid is listed in the makes. I also put in the the vehicles fuel tank size both the listed tank size and an inclreas of 10% I know that certain cars can take more or less but all of my friends (was not about to ask 16,000 vehicle owners how much gas can you really put into your tank. I then listed the price of gas Reg Prem and Diesel both the lowest price in the city and the highest for all 3 types then multiplied it by the tank size to determin the cost of gas and its a bit disturbing on some of the cost. I am in Canada so all my calcs are set in L/100km for both city and hyway found some really good cars to but now I want to add 1 more calc to my tables lol I go out to make a simple excel doc and wind up with a huge book.

I digress, what I am looking at is how to get the cost per km driven. I was thinking of dividing the cost of the tank by the amoutn ok km that the car can go on both the hywy and City would this be correct? I know from testing the math on the rated economy and my current vehicle but this will hopefully be the last calc then I can be done till next year or I find some more info lol.

meelis11 03-27-2011 09:48 AM

You dont need tank size to calculate Price per Km

You need two things:
fuel economy L/100km (Eco100km)
fuel price per liter (PriceL)

Price per kilometer (PriceKm) = Eco100km * PriceL / 100

Example:
Eco100km = 7.5
PriceL = 1.2 EUR
PriceKm = 7.5 * 1.2 / 100 = 0.09EUR
So it is 9 eurocents per Km

Creeper 03-27-2011 11:14 AM

Ok that part I get I'll try and adapt it as I want to show how much it cost each car to travel on full tank so if the car travels 500km it would cost .01 per km for that car.

Creeper 03-28-2011 08:16 PM

Thanks none the less.


All times are GMT -4. The time now is 03:05 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.5.2
All content copyright EcoModder.com