CLK55 AMG, CLK63 AMG (W208, W209) 2000 - 2010 (Two Generations)

Oil Loss Analysis Excel Spreadsheet Tool

Thread Tools
 
Search this Thread
 
Rate Thread
 
Old Sep 17, 2018 | 09:50 PM
  #1  
LITAMG's Avatar
Thread Starter
Newbie
 
Joined: Jul 2018
Posts: 13
Likes: 0
From: St. Louis, MO
05 CLK55 AMG
Lightbulb Oil Loss Analysis Excel Spreadsheet Tool

Hey guys so a while back I had a bad rear main seal leak and I wanted to keep track of it so I created this Oil Loss Analysis Excel Spreadsheet Tool. I use Google Drive and access the spreadsheet on my phone and update it every time I get ready to leave the garage in the morning.
It took me a while to create this and I hope it helps someone who wants to see exactly what is happening with their oil. The more data you have, the more idea you have of what is wrong.
Feel free to download the file from the following google drive link. I have made a blank version that anyone can fill out and use as their own.

https://docs.google.com/spreadsheets...it?usp=sharing



When using the Spreadsheet, leave the Zeros at the top(Row 3) alone and enter in Mileage, Oil Level, Oil Check Message, and Cost Per Liter to start recording data. Feel free to change the dates to the date that you enter in the data for each row.
Check the Example worksheet if you want to see an example of how it everything works for reference. When you enter data in, it will auto-populate the calculated columns and the graph.

Remember you will have slight variations in oil level depending on the temperature of your oil/engine. So to keep things consistent I prefer to check when the engine is cold and has sat overnight in my garage.

To check your oil using the instrument cluster follow these steps. (This won't work on all cars but should work on most (Works on my CLK55 and my C55))
  1. Make sure your car is on level ground and has sat for at least 10 minutes.
  2. Hop in the car and insert the key.
  3. Turn it one click to ACC
  4. Make sure the mileage is displayed and if it's not, scroll through the pages until you bring it up.
  5. Then quickly press the trip reset button three times. This will open a hidden diagnostic screen that shows the voltage of your battery.
  6. Then turn the key to the on position but do not crank the engine over. This enables the sensors of the car and allows the oil to be measured and displayed.
  7. Use the up and down arrows to scroll through the various pages such as voltage, VIN, and the engine type, model, as well as Dyno mode and oil level.
I hope this helps and that you guys find it useful! Let me know what you think!
Reply
Old Sep 18, 2018 | 10:41 AM
  #2  
PJmak's Avatar
MBWorld Fanatic!
15 Year Member
Liked
Loved
Community Favorite
 
Joined: Sep 2007
Posts: 4,566
Likes: 421
05 c55 silver, 98 Imperial Red C43
So you lost three qts of oil in less than a month?

How bad was your rear main seal?


Btw the graph is very helpful, thanks for taking the time to create it.
Reply
Old Sep 18, 2018 | 11:52 AM
  #3  
LITAMG's Avatar
Thread Starter
Newbie
 
Joined: Jul 2018
Posts: 13
Likes: 0
From: St. Louis, MO
05 CLK55 AMG
Yeah I was losing quite a bit but now it looks like my valve guide seals are leaking and making my engine eat oil. That oil refill as of Sept 8th was after i got the rear main seal fixed. Unfortunately its still losing oil and there's no significant leaks from what I can tell. We just replaced the valve covers gasket and resealed the breather chambers but they seem to be seeping a bit of oil as its a little moist around part of the seals. The oil dipstick tube seal seems to be leaking a tad but i cant pinpoint if its that seal or not.
Reply
Old Sep 18, 2018 | 04:02 PM
  #4  
PJmak's Avatar
MBWorld Fanatic!
15 Year Member
Liked
Loved
Community Favorite
 
Joined: Sep 2007
Posts: 4,566
Likes: 421
05 c55 silver, 98 Imperial Red C43
Since you have experience with oil leaks, I have one that I cant identify. I thought it was a rear main seal so I had that done but the leak is still there.

It looks like a oil pan leak but my friend who is a mechanic told me its not. He said its coming from the upper\side end of the motor somewhere.

Here is a pic from below the car. I did an oil change recently. The oil leak wasn't there for a week or so after the oil change but then it came back.

2005 c55
If you look at this pic and to the right of the screw that has oil on it, you can see that area of the transmission is oily




Reply
Old Sep 18, 2018 | 07:05 PM
  #5  
LITAMG's Avatar
Thread Starter
Newbie
 
Joined: Jul 2018
Posts: 13
Likes: 0
From: St. Louis, MO
05 CLK55 AMG
Have you checked to see if its an upper oil pan gasket leak? It could also be a valve cover seal leak that's dripping down your engine and to the back of the block.

The upper oil pan and lower oil pan look like this if you need to see how it looks so you know where to look!


Reply

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 


You have already rated this thread Rating: Thread Rating: 0 votes,  average.


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

story-0
New Electric Mercedes-AMG GT 4-Door Coupe Unveiled: 10 Things You Need to Know

Slideshow: Mercedes-AMG's new electric GT 4-Door Coupe trades combustion for software, synthetic noise, and more than 1,100 horsepower.

By Verdad Gallardo | 2026-05-20 20:08:15


VIEW MORE
story-1
6 Mercedes Models That Did NOT Age Well (But Are Somehow Still Cool)

Slideshow: Not every Mercedes design becomes timeless, some feel stuck in the era they came from.

By Verdad Gallardo | 2026-05-12 18:09:07


VIEW MORE
story-2
Manual Mercedes? 6 Times Sindelfingen Let Drivers Have All The Fun

Slideshow: Yes, Mercedes built manual cars, and some of them are far more interesting than you'd expect.

By Verdad Gallardo | 2026-05-02 12:36:58


VIEW MORE
story-3
Mercedes SLR McLaren 722 S Is Extremely Rare Example Modified by McLaren

Slideshow: A one-of-one U.S.-spec Mercedes-Benz SLR McLaren Roadster became even rarer after a factory-backed transformation at McLaren's headquarters.

By Verdad Gallardo | 2026-04-29 11:19:28


VIEW MORE
story-4
8 Classic Boxy Mercedes Designs That Have Aged Like Fine Wine

Slideshow: Before curves took over, Mercedes mastered the art of the straight line, and some of those shapes still look right today.

By Verdad Gallardo | 2026-04-25 12:05:49


VIEW MORE
story-5
Flawlessly Restored Mercedes 190E Evo II Heads to Auction

Slideshow: The 190E Evolution II shows how a homologation necessity became a six-figure collector icon.

By Verdad Gallardo | 2026-04-22 17:53:47


VIEW MORE
story-6
Electric Mercedes C-Class Unveiled: 11 Things You Need to Know

Slideshow: Mercedes is turning one of its core nameplates electric, and the details show just how serious this shift is.

By Verdad Gallardo | 2026-04-21 13:58:06


VIEW MORE
story-7
Mercedes EQS Gets A Major Update: Everything You Need to Know

Slideshow: Faster charging, longer range, and a controversial steer-by-wire system define the latest evolution of Mercedes-Benz EQS.

By Verdad Gallardo | 2026-04-15 10:35:34


VIEW MORE
story-8
5 Underrated Mercedes-Benz Models That Don't Get the Love They Deserve

Slideshow: These overlooked Mercedes-Benz models never got the spotlight, but they quietly delivered more than most remember.

By Verdad Gallardo | 2026-04-13 19:35:45


VIEW MORE
story-9
Mercedes 300D Has Pushed Well Past 1 Million Miles and It Ain't Stopping

Slideshow: A well-used 1991 Mercedes-Benz 300D with more than one million miles is now looking for a new owner, and it still appears ready for more.

By Verdad Gallardo | 2026-04-10 10:05:15


VIEW MORE