Forum-Gallery-Shop-Sponsors

« Advertise on Freel2.com

Home > Maintenance & Modifications > Servicing Spreadsheet
Post Reply  Down to end
Page 1 of 1
Print this entire topic · 
Dean1234



Member Since: 18 Jan 2022
Location: Northamptonshire
Posts: 219

United Kingdom 2010 Freelander 2 TD4_e XS Manual Biscay Blue
Servicing Spreadsheet

A little bit of back story before I get to the point so please bear with me. Smile

Between my better half (Alana) and myself, we filmed a video called "What To Service, When And What To Be Prepared For When Owning A Land Rover Freelander 2" a couple of months ago and put it onto YouTube. Ever since filming that video, something has been bugging me. In a lot of reviews and posts on this forum, I see a lot of "the big 10 year service" or "has it had the big 10 year service?" or just something referencing a 10 year service interval. Hopefully I'm not going to ruffle any feathers when I say this next part but I don't think there is any such thing as a 10 year service when it comes to Freelander 2's.

In the video we made, the only thing that I quoted as being 10 years was the timing belt for pre-facelifted Freelander 2's. But even then, I'd say it's best to follow the practice of the post-facelifted cars and do that every 7 years.

So getting to my point in hand. I feel like everything serviceable should have it's own date and not be put into a box of "every 10 years" just because it's easier to remember. Plus even if things could last 10 years or more, isn't it just better practice to maintain our cars before things have gone past their best?

So I've created a super basic spreadsheet that hopefully I can get help from you very knowledgeable people on this forum. My plan is that people will be able to download a template, add in their own information in the top section and the bottom section will automatically fill itself in on when the item will need servicing next.

The other thing that I'd like the spreadsheet to do but not sure if it's possible and that is to automatically list the next series of jobs for the next 365 days and/or jobs within the next 10,000 miles and put them into chronological order at the bottom of the sheet. So the sheet fetches today's date, the cars mileage from the top of the sheet and looks for anything within 365 days of it and copies and pastes it into its own section which I've labelled "Jobs coming up in the next 365 days or 10,000 miles.

I'm also going to add a section of important notes at the bottom of the sheet such as "buy a purflux fuel filter" and other associated important notes.

At the moment the service intervals are listed as the following using a formula of =(cell number from the top row+xxxx days) or =(cell number from the top row+xxxxx) for the mileage row:

Haldex: 2 years. I've not come across a mileage for this
Rear Diff: 5 years or 60,000 miles
Gearbox Oil: 5 years or 60,000 miles
PTU Oil: 5 years or 50,000 miles
Power Steering Fluid: 5 years or 60,000 miles
Timing Belt Kit: 7 years or 100,000 miles
Coolant Change: 5 years. No mileage?
Aux Belt Kit: 7 years or 100,000 miles
Oil And Filter: 1 year or 6,000 miles
Air And Cabin Filter: 1 year.
Fuel Filter: 2 years. No mileage?
Brake Fluid: 3 years. No mileage?
Brake Lines: 6 years. No mileage?
Air Con Service: 2 years.

Obviously these can all be changed to the users preference if they so wish. I made this in OpenOffice Calc and then uploaded and tweaked it in Google Sheets.
If anyone can make it better then be my guest. Having never used Google Sheets before, I think it's public and editable by anyone. Obviously if you want to use it as is then go to File > Download or otherwise everyone will see what you've entered. Very Happy

https://docs.google.com/spreadsheets/d/1Ca...sp=sharing https://www.youtube.com/@scottandalana4x4

Post #444050 14th Aug 2024 11:47 am
View user's profile Send private message View poster's gallery Reply with quote
IanMetro



Member Since: 11 Sep 2017
Location: Somerset BS21
Posts: 3133

United Kingdom 2014 Freelander 2 SD4 Metropolis LE Auto Fuji White

On the Official LR FL2 Servicing Schedule the 10 year service includes transmission/gearbox fluid changes.

This is the extra expense.

Official Maintenance Check List ----
https://www.freel2.com/gallery/albums/user...0Miles.pdf

(I have just had mine done as I run it with Main Dealer Servicing and Full Extended Warranty)

Over the years I have had 3 unscheduled garage visits, including a recent Rear Diff change all under warranty with free breakdown and hire car. FL2 XS SD4 Auto 2010 2012-2017 (21k - 91k miles) (MY2011)
FL2 Metropolis SD4 Auto 2014 2017- (16k - 77k+ miles) (MY2015)
Metro in its 11th Year of (Extended) LR Warranty / Full LR Service History
(Expensive, but Trouble/Worry free - hopefully?)

Post #444052 14th Aug 2024 12:57 pm
View user's profile Send private message View poster's gallery Reply with quote
Dean1234



Member Since: 18 Jan 2022
Location: Northamptonshire
Posts: 219

United Kingdom 2010 Freelander 2 TD4_e XS Manual Biscay Blue

Everyone has their own ideas as to when best to service their own Freelander 2. But the general consensus I get from both this forum and from fellow Freelander 2 owners over on YouTube is that Land Rovers official service sheet has things set waaaay too far apart. Hence why I'm trying to put together some kind a spreadsheet for those people like me who do get confused by all the different items to service on the car and what realistic service intervals should be for each item. Smile https://www.youtube.com/@scottandalana4x4

Post #444053 14th Aug 2024 1:06 pm
View user's profile Send private message View poster's gallery Reply with quote
Nodge68



Member Since: 15 Jul 2020
Location: Newquay
Posts: 2082

United Kingdom 2009 Freelander 2 TD4 SE Manual Rimini Red

You can't over service a vehicle, especially where fluids are concerned. So it's best to do them at ½ to ⅓ the time/distance that LR suggested. Hyundai Ioniq 5 Ultimate. The family car.
2009 Rimini Red SE TD4. Gone.
2006 Tonga Green i6 HSE. Gone.
Audi A5 convertible, my daily driver.
1972 Hillman Avenger GT, the project.

Post #444063 14th Aug 2024 9:24 pm
View user's profile Send private message View poster's gallery Reply with quote
Grue



Member Since: 29 Apr 2018
Location: New Zealand
Posts: 366

New Zealand 2007 Freelander 2 TD4 SE Auto Sumatra Black

I've added mine to SHEET 2 in case you want to pinch anything from there. I enter my current milage at the top and it highlights anything outstanding. Some of my servicing schedules are by the book, some are my own preference.

I'll have a think about a Vlookup table for upcoming jobs... I'll see what i can come up with

EDIT... ah ha, didn't take my formulas over in the cut and paste.... I'll have a tinker today
EDIT2... formulas should work now.

Post #444064 14th Aug 2024 10:03 pm
View user's profile Send private message View poster's gallery Reply with quote
jenks1950



Member Since: 20 Apr 2013
Location: Stevenage
Posts: 258

England 2013 Freelander 2 SD4 XS Auto Santorini Black

A Few Observations
The thing about servicing is that it is something required throughout the life of a vehicle, but by and large the benefit goes to the later owners. Probably after 80 -100k miles

I bought my Freely as a "nearly new" and have now owned it for 11 years and 160k miles. Apart from the regular items (oil/filter/fuel filter) I have maintained a schedule at roughly 65% of that recommended by Land Rover and added in a couple of the notorious "sealed for life" items. There are a couple of items I have "stretched" a bit.. Brake fluid change and Air con service, but they have still been done!! I have been strongly influenced by the knowledge and opinions from this forum.

Apart from a starter motor issue, servicing and consumables are the only expense I have had during my ownership.

I would just add that generally garages will not suggest or offer many standard service items unless specifically requested or there are strong signs that attention is needed

Post #444069 15th Aug 2024 9:03 am
View user's profile Send private message View poster's gallery Reply with quote
Dean1234



Member Since: 18 Jan 2022
Location: Northamptonshire
Posts: 219

United Kingdom 2010 Freelander 2 TD4_e XS Manual Biscay Blue

Thanks a lot Grue for giving me a massive boost with this! Thumbs Up

For everyone:

Can you have a look through page 1 labelled "2006 - 2010 TD4 Freelander 2 Miles" and check for the following:

1. Service intervals are at reasonable amounts for each item.
2. Part numbers are correct.
3. The information is correct.

Remember to scroll to the right to see additional information on the sheet. Smile I just spent about the last 4 or so hours on it but have run out of time for today.

https://docs.google.com/spreadsheets/d/1Ca...sp=sharing

For Grue or anyone else good on spreadsheets:

On page 2 labeled "2007 - 2010 TD4 Freelander 2 KM". I'm trying to make a copy of the miles version, but making KM's the preference for anyone that doesn't work in miles. Due to tiredness and staring at this spreadsheet for too long, I think I've messed up the next due part so if that can be looked at that would be great. Smile

Also, I've got no idea on how to make the "DUE" column work when it's operating in KM's. But I don't know if that's linked to me messing up the next due column which is causing the Due column not to work.

https://docs.google.com/spreadsheets/d/1Ca...sp=sharing

If anyone wants to see an example of how the sheet looks with proper data in, scroll across to ScottAlanaCar page on the spreadsheet. https://www.youtube.com/@scottandalana4x4

Post #444084 15th Aug 2024 4:58 pm
View user's profile Send private message View poster's gallery Reply with quote
Freddie17



Member Since: 01 Aug 2024
Location: Kent
Posts: 13

United Kingdom 2009 Freelander 2 TD4 SE Manual Rimini Red

Hi Scott

I like the idea of the spreadsheet - I might borrow your template !
I like to make a record of everything I do myself on my F1, and use a template showing the usual stuff - miles, date, parts used, work done, etc. But I’ve not actually come up with something I can read off at a glance and easily see what is due.

Nice one!

(Also watch your you-tube channel - good info 👍)

Post #444088 15th Aug 2024 7:55 pm
View user's profile Send private message View poster's gallery Reply with quote
Grue



Member Since: 29 Apr 2018
Location: New Zealand
Posts: 366

New Zealand 2007 Freelander 2 TD4 SE Auto Sumatra Black

Had a bit of a tinker but it's already looking pretty good! Nice work getting so much stuff in there for the different models etc

Post #444093 15th Aug 2024 9:26 pm
View user's profile Send private message View poster's gallery Reply with quote
Dean1234



Member Since: 18 Jan 2022
Location: Northamptonshire
Posts: 219

United Kingdom 2010 Freelander 2 TD4_e XS Manual Biscay Blue

Freddie17 wrote:
Hi Scott

I like the idea of the spreadsheet - I might borrow your template !
I like to make a record of everything I do myself on my F1, and use a template showing the usual stuff - miles, date, parts used, work done, etc. But I’ve not actually come up with something I can read off at a glance and easily see what is due.

Nice one!

(Also watch your you-tube channel - good info 👍)


You're welcome Freddie Thumbs Up . Most of the credit goes to Grue on this one. Very Happy

Right, today's tinkerings. I think I'm finished for now. If anyone spots any errors, things that can be improved or just anything that can be added, post it up in this section. I'm going to make a clean fresh thread eventually to put all this in. But until it's been "beta tested", I want to be sure it's actually any use to anyone.

2006 - 2010 TD4 Freelander 2 Template:
Miles:https://docs.google.com/spreadsheets/d/1ae...sp=sharing
KM: https://docs.google.com/spreadsheets/d/10t...sp=sharing

2011 - 2015 SD4 Freelander 2 Template:
Miles: https://docs.google.com/spreadsheets/d/1cl...sp=sharing
KM: https://docs.google.com/spreadsheets/d/16_...sp=sharing

2011> eD4 Freelander 2 Template:
Miles: https://docs.google.com/spreadsheets/d/1av...sp=sharing
KM: https://docs.google.com/spreadsheets/d/1ou...sp=sharing

2006 - 2015 3.2L i6 Freelander 2 Template:
Miles: https://docs.google.com/spreadsheets/d/1us...sp=sharing
KM: https://docs.google.com/spreadsheets/d/1aE...sp=sharing

The eD4 templates and i6 templates are the main ones that could contain the most error's as finding out information about these cars is super tough! Thanks once again to Grue for the help along with this. Smile

If anyone wants to see an example, here is our one all filled out:
https://docs.google.com/spreadsheets/d/1MU...sp=sharing

The master template is here:
https://docs.google.com/spreadsheets/d/1Ca...sp=sharing https://www.youtube.com/@scottandalana4x4

Post #444110 16th Aug 2024 2:33 pm
View user's profile Send private message View poster's gallery Post Reply
Post Reply  Back to top
Page 1 of 1
All times are GMT

Jump to  
Previous Topic | Next Topic >
Posting Rules
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Site Copyright © 2006-2024 Futuranet Ltd & Martin Lewis
Freel2.com RSS Feed - All Forums


Switch to Mobile site