Website Questions & Input Suggestions and inquiries about GreenHybrid are welcome here.

Quick Math Help

  #1  
Old 08-07-2005, 10:42 PM
Site Founder
Thread Starter
Join Date: Dec 2003
Posts: 4,623
Default Quick Math Help

For the mileage database, a small display bug was pointed out. To rectify it, I need to calculate the MPG for the tanks that are logged. It's late and my brain is fried. Can anyone else figure out the equation?

Known: Lifetime MPG, Lifetime Miles, Starting MPG, Starting Miles, Tank Miles
Need: Tank MPG

This may be really easy, but at 1:45 after all I've been doing on this thing... can't think! Thanks.
 
  #2  
Old 08-07-2005, 11:06 PM
Join Date: Dec 2004
Location: Leominster, MA
Posts: 2,161
Default Re: Quick Math Help

can it be done? how can you ever know tank mpg without knowing tank gallons

You can maybe take a guess at it and assume all tanks had equal gallons. But this tank could be the exception to the rule.

I think you need tank gallons to do this equasion.
 
  #3  
Old 08-07-2005, 11:15 PM
Site Founder
Thread Starter
Join Date: Dec 2003
Posts: 4,623
Default Re: Quick Math Help

Haha. I think not! I'll figure it out tomorrow when I get some more sleep Trust me, it's possible.

BTW how do you think I calculate lifetime mileage when I never know how many gallons anyone ever uses?
 
  #4  
Old 08-08-2005, 01:40 PM
Conservative Republican
Join Date: Apr 2005
Location: near Fredericksburg, Virginia
Posts: 180
Default Re: Quick Math Help

Jason,

If I could to real math.... Never mind. Math was not my subject. I have not had a math class since 10th grade geometry in 1975. I never had Algebra II, or Trig, or Calc, but...

I think what you are talking about can be figured by taking miles for a given tank, divided by total miles, to get a percentage that tank represents of the total miles. Multiply that number by the mpg for that tank, and you get X. Do the equation again for another tank and you get X1, and again for another tank and you get X2, and again for another tank and you get X3.... Add X, X1, X2, X3, etc together, and you get an mpg for the total number of miles entered.

Am I making any sense? It frightens me to think I might be. Don't ask me how I came up with this. I don't know.

Bob

Originally Posted by Jason
For the mileage database, a small display bug was pointed out. To rectify it, I need to calculate the MPG for the tanks that are logged. It's late and my brain is fried. Can anyone else figure out the equation?

Known: Lifetime MPG, Lifetime Miles, Starting MPG, Starting Miles, Tank Miles
Need: Tank MPG

This may be really easy, but at 1:45 after all I've been doing on this thing... can't think! Thanks.
 

Last edited by rjbarlow; 08-08-2005 at 01:46 PM.
  #5  
Old 08-08-2005, 01:45 PM
Conservative Republican
Join Date: Apr 2005
Location: near Fredericksburg, Virginia
Posts: 180
Default Re: Quick Math Help

Jason,

Isn't this the same formula you use to figure out cumulative mpg for each member? All you need to do for me is use the formula you use now to calculate mpg, but subtract the "at start" numbers from your formula.

Does this make sense?

Bob
 
  #6  
Old 08-08-2005, 01:45 PM
Site Founder
Thread Starter
Join Date: Dec 2003
Posts: 4,623
Default Re: Quick Math Help

Hmm. That requires a loop... a bit code intensive. I'm telling you... there IS a better way! I'll figure it out soon.
 
  #7  
Old 08-08-2005, 01:47 PM
Site Founder
Thread Starter
Join Date: Dec 2003
Posts: 4,623
Default Re: Quick Math Help

If any of you know PHP, maybe this could help. It's the code to calculate lifetime MPG.

Code:
$carQUERY=mysql_query("SELECT tanks, mi_start, mpg_start FROM cars WHERE cid=$cid");
$car=mysql_fetch_array($carQUERY);

// Grab tanks data
$tanks=0;
$tankQUERY=mysql_query("SELECT mi, mpg FROM tanks WHERE cid=$cid AND deleted=0");
while($tank=mysql_fetch_array($tankQUERY)) {
	$tanks_bit=$tanks_bit + ($tank['mi']/$tank['mpg']);
	$mi_tanks=$mi_tanks + $tank['mi'];
	$tanks++;
}

// Define car data
$mi=$car['mi_start']+$mi_tanks;
if($car['mpg_start']>0) {
	$mpg=$mi / ($tanks_bit + ($car['mi_start']/$car['mpg_start']));
} elseif ($mi_tanks>0) {
	$mpg=$mi_tanks / $tanks_bit;
} else {
	$mpg=0;
}
 
  #8  
Old 08-08-2005, 01:49 PM
Conservative Republican
Join Date: Apr 2005
Location: near Fredericksburg, Virginia
Posts: 180
Default Re: Quick Math Help

Well, I don't know anything about computer programming either. You are on your own!
 
  #9  
Old 08-08-2005, 01:54 PM
Conservative Republican
Join Date: Apr 2005
Location: near Fredericksburg, Virginia
Posts: 180
Talking Re: Quick Math Help

Jason,

Now I am really treading into the unknown, I know NOTHING about computer language or programming. But what if in the third line of the partial quote below you changed ">0" to "=0" as the formula just to calculate the progress since adding tanks? Isn't that the code entry that tells the calculator that the mpg start may be something above 0, as in 23,151 miles in my case?

Bob

Originally Posted by Jason
If any of you know PHP, maybe this could help. It's the code to calculate lifetime MPG.

[// Define car data
$mi=$car['mi_start']+$mi_tanks;
if($car['mpg_start']>0) {
$mpg=$mi / ($tanks_bit + ($car['mi_start']/$car['mpg_start']));
} elseif ($mi_tanks>0) {
$mpg=$mi_tanks / $tanks_bit;
} else {
$mpg=0;
}[/code]
 
Related Topics
Thread
Topic Starter
Forum
Replies
Last Post
txav8r
GM Hybrid Trucks, Cadillac Escalade Hybrid, Chevrolet Tahoe Hybrid & GMC Yukon Hybrid
1
11-30-2009 01:08 PM
ManyMPG
Honda Insight
0
06-16-2006 10:29 AM
lkewin
Journalism & The Media
7
10-20-2005 12:33 AM
Jason
Fuel Economy & Emissions
23
05-09-2005 06:07 PM


Thread Tools
Search this Thread
Quick Reply: Quick Math Help


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

© 2019 MH Sub I, LLC dba Internet Brands

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.