Quick Math Help
Thread Starter
|
Site Founder
Joined: Dec 2003
Posts: 4,623
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.
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.
Joined: Dec 2004
Posts: 2,161
From: Leominster, MA
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.
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.
Thread Starter
|
Site Founder
Joined: Dec 2003
Posts: 4,623
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?
Trust me, it's possible.BTW how do you think I calculate lifetime mileage when I never know how many gallons anyone ever uses?
Conservative Republican
Joined: Apr 2005
Posts: 180
From: near Fredericksburg, Virginia
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
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.
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; Aug 8, 2005 at 01:46 PM.
Conservative Republican
Joined: Apr 2005
Posts: 180
From: near Fredericksburg, Virginia
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
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
Thread Starter
|
Site Founder
Joined: Dec 2003
Posts: 4,623
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;
}
You are on your own!
Conservative Republican
Joined: Apr 2005
Posts: 180
From: near Fredericksburg, Virginia
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
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]
[// 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]
Thread
Topic Starter
Forum
Replies
Last Post
txav8r
GM Hybrid Trucks, Cadillac Escalade Hybrid, Chevrolet Tahoe Hybrid & GMC Yukon Hybrid
1
Nov 30, 2009 01:08 PM
lkewin
Journalism & The Media
7
Oct 20, 2005 12:33 AM
