DPChallenge: A Digital Photography Contest You are not logged in. (log in or register) 
 

DPChallenge Forums >> General Discussion >> Gas Mileage Log - Excel Help!
Pages:  
Showing posts 1 - 13 of 13, (reverse)
AuthorThread
 08/03/2008 02:40:46 PM · #1
I have made a gas mileage log to suit my needs but I'm having a problem with a couple of formulas. I'm using Excel 2000 and you can view the log here. As you can see in some columns there are "0" because nothing has been entered in the referring cells and the same in the columns that is giving me #DIV/0. I know it's an ISERROR issue but cannot figure out what to do. I would like those cells that is giving me the ISERROR messages and "0" to be blank until I enter information in the referring cells.

Can anyone help me with this. I know it's simple but I just can't figure it out.

BTW, what do you think of the gas mileage log?

Thanks in advance,
Scott
 08/03/2008 03:01:45 PM · #2
Try an IF statment

=IF(C8=0,"",D8+E8) example
type =IF( the cell that = 0,"",then the forumla that you want to apply if not 0

"" is equal to blank text
if you have trouble with it PM me the sheet and Ill fix it

Message edited by author 2008-08-03 19:02:56.
 08/03/2008 03:04:11 PM · #3
if the formula is correct, and you want it to be blank rather than '0'...try putting a 'conditional format' in the cells.

Oh I see DarkRider has answered with a different formula
08/03/2008 03:55:20 PM · #4
Thanks for the advice. I will go and try the suggestions.

The reason for me making up this template is because I am having trouble with my gas mileage and it's a pain for the dealer to fix. I have had the 40k tuneup and new tires. After the tuneup my mileage dropped from 17 to 15mpg. They wanted a log of my mileage because their computer is not showing a problem. Now this week I have to ride in town and on the road with the manager the fill back up my tank and he will figure the MPG. I guess they think I have a lead foot. :)
 08/03/2008 05:49:47 PM · #5
Hey Scott, what type of car? I have the same problem on my Acadia. It went from 17mpg to 11mpg in under a year. Dealership just says well the computer doesn't show anything.

Oi!
 08/03/2008 06:06:44 PM · #6
Originally posted by chesire:
Hey Scott, what type of car? I have the same problem on my Acadia. It went from 17mpg to 11mpg in under a year. Dealership just says well the computer doesn't show anything.

Oi!

It's a 2004 Jetta. If the computer does not show a problem then your going to have to have the service department run a fuel consumption test. Even though my car is still under the manufactures warranty this is how the do it, from what I understand.

1. You bring your car in with a full tank of gas and you along with a technician will drive about 35 miles in town; then fill up. He will then record miles driven and divide it by the amount of gallons it took to fill up your car.

2. Then you and the technician will drive about 35 miles on the highway; then fill up. He will do the same as in #1

Now you have your "City MPG" and your "Highway MPG".

3. Then He will add the two together ((City miles + Highway miles) / (City Gallons + Highway Gallons)) = Your Avg. MPG.

NOTE: Don't let him then do a 55/45% split on City and Highway miles respectively. Because both were 35 miles, City and Highway. So it should be 50/50%

4. He then will note your driving style and determine (subjectively) if the car has a problem or your driving style is causing the lower than normal gas mileage. He will also check tires, tire pressure, etc.

5. If your getting less than 90% of the revised estimated gas mileage for the age of your car, there is a problem.

NOTE: Have you had a tune up? Has your oil been changed regularly per manufacture specifications? All of this will be taken in consideration.

Hope this helps.
Scott

Message edited by author 2008-08-03 22:12:07.
 08/03/2008 09:25:31 PM · #7
Adding to darkrider suggestion, if you don't want the zeros to show. Go to the options menu, under the "view" tab, uncheck "zero values".
 08/04/2008 01:05:08 AM · #8
Scott, a couple of people have made suggestions already, here's how I usually do it. Darkrider's suggestion will get rid of the Null (0) values, but this will get rid of the #div/0 and other error messages.

=if(iserror(D8/9),"",(d8/d9))

Hope this helps.
 08/04/2008 01:52:37 AM · #9
Scott to hide zero values
Go to Tools/options/view/untick "zero values" box

To hide your formula error message use conditional formatting as follows
Select the cells that contain the error value.
On the Format menu, click Conditional Formatting.
In the box on the left, click Formula Is.

In the box on the right, type =ISERROR(reference), where reference is a reference to the cell that contains the error value.
Click Format, and then click the Font tab.

Click Format.
In the Color box, select white.
08/04/2008 09:07:04 AM · #10
Lots of different options here for the same result. I learned a trick or two. thx

SDW, Did you get the sheet fixed up?
 08/04/2008 10:46:39 AM · #11
Originally posted by DarkRider:
Lots of different options here for the same result. I learned a trick or two. thx

SDW, Did you get the sheet fixed up?

Yes some of the options worked. I haven't had time to go through all of them but so far all the suggestions have been a big help. Hopefully I will have time today to try them all. And have the log setup.

Thanks everyone for your help. I may need to call on you again, I hope you don't mind.

Thanks,
Scott
 08/05/2008 11:18:03 AM · #12
Thanks everyone for your help. The functions worked great. Here is the updated spreadsheet.

What do you think about it. Do you think it is setup to be a good tool for tracking Cost, MPG, Yearly cost and consumption?

Any input would be great.

Thanks,
Scott
 08/05/2008 01:51:36 PM · #13
Originally posted by SDW:
After the tuneup my mileage dropped from 17 to 15mpg.


And

Originally posted by SDW:
It's a 2004 Jetta. If the computer does not show a problem then your going to have to have the service department run a fuel consumption test. Even though my car is still under the manufactures warranty this is how the do it, from what I understand.

5. If your getting less than 90% of the revised estimated gas mileage for the age of your car, there is a problem.


Scott,

I'm puzzled. I can't find any 2004 Jettas ranked anywhere near the 17 mpg you were originally getting. With the new number the lowest rated Jettas I can find were rated 19/27.

Second, I would not consider 90% of the new revised numbers anywhere near acceptable. I've always gotten close to or beat the older higher numbers without any problem.

A couple of things that could be cutting your gas mileage. First look at the rolling resistance of the tires. It that went up your gas mileage will go down. Second have you switched from straight gas to the new E10 - ethanol. That will also hurt you gas mileage. And lastly was there any difference in the diameter of the tires. New tires are a bit bigger than the old ones due to less tread wear, but that is a small effect. Did you go with larger tires? Without recalibrating the odometer that can make a difference.
Pages:  
Current Server Time: 04/09/2025 05:35:45 PM

Please log in or register to post to the forums.


Home - Challenges - Community - League - Photos - Cameras - Lenses - Learn - Help - Terms of Use - Privacy - Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 04/09/2025 05:35:45 PM EDT.