05-21-2010, 12:24 PM
|
#1
|
|
Member
|
|
Join Date: May 2010
Location: Portland, Or
Age: 43
Posts: 773
|
|
Member
Join Date: May 2010
Location: Portland, Or
Age: 43
Posts: 773
|
Creating A Maitenance Spreadsheet
I want to create a maintenance spreadsheet in excel, so I can start keeping track of all of the maintenance I have done, and when the next interval will be due. I have had my 4runner for a few weeks now, with 98k mi on it, and have no maintenance records on it, so I will be starting from scratch.
Can anyone point me in the direction of some good resources for what maintenance needs to be done, and at what interval. I can share the spreadsheet with everyone once it is done!
|
|
Reply With Quote
|
05-21-2010, 12:36 PM
|
#2
|
|
Member
|
|
Join Date: Nov 2009
Location: Denver, CO
Posts: 151
Real Name: Kyle
|
|
Member
Join Date: Nov 2009
Location: Denver, CO
Posts: 151
Real Name: Kyle
|
I use the Toyota Owners Website
Its great for keeping track of the work you've done. Create an account, it's free. Doesn't matter if you service your vehicle at a dealer or not. You can manually add your records and if you decide to have your 4R serviced at the dealer, your profile automatically be updated, I think.
EDIT: On that same website, you will find all of the recommended services and suggested intervals for maintaining your 4R. Go here for FSM.
__________________
98 4Runner / 5 spd / 3.4L
98 Civic HX / 5 spd / 1.6L
Last edited by denverunner; 05-21-2010 at 12:39 PM.
|
|
Reply With Quote
|
05-21-2010, 12:57 PM
|
#3
|
|
Elite Member
|
|
Join Date: Nov 2006
Location: Pocono Mountains
Posts: 7,498
|
|
Elite Member
Join Date: Nov 2006
Location: Pocono Mountains
Posts: 7,498
|
I just have a 4 column spreadsheet going back to '99. Date/Miles/Work/Receipt. The last is a one bit Y/N field to show whether a receipt is in the folder. I don't keep fluid and filter receipts once I am out of warranty; I have a stock of both and it would be meaningless. Plus things like MAF cleanings and brake bleedings don't generate receipts.
I don't track to intervals for groups of items because I don't do everything at once. After 10 years, gear oil and coolant may both be at 30K intervals, but those are now 10k apart for one reason or another. So I just look at the record and figure out what needs to be done next and I do it when I can. Oil and tire rotation I pay close attention to. The rest is plus or minus 5K so I can do it in nice weather. I make a list in the Spring and try to finish it by Fall.
__________________
'99 4Runner SR5 5spd 3.4L V6 4WD(U.S), original '99 Talls in front, OME 906s in back, Hella fogs, Trekmaster shocks in front, Billy in back, no running boards, FIAMM horns, Alpine sound, Michelin LTX M/S2's, owned since new.
'97 HiLux SW4 5spd 4WD(Japan model bought in Brazil assembled in Argentina, very close to a 3.0 4Runner/Surf)
'71 FordWillys Jeep CJ5 (with straight six Ford Maverick 3.0 liter engine--lives in the mountains north of Sao Paulo Brazil)
My Backyard Frame Swap
|
|
Reply With Quote
|
05-21-2010, 01:24 PM
|
#4
|
|
Elite Member
|
|
Join Date: Dec 2009
Location: California
Posts: 5,470
|
|
Elite Member
Join Date: Dec 2009
Location: California
Posts: 5,470
|
I seperated my work log into 3 sections:
1) Stuff that I did/stuff I need to do according to mileage (in order of soonest to perform).
2) Stuff I have done because it broke/wore out (A-Z).
3) Little stuff to do whenever I get a chance (like replacing my door light triggers).
__________________
2021 Tacoma 4x4 TRD Off Road Double Cab Short Bed (my DD)
2017 4Runner 4x4 Limited (the wife’s)
|
|
Reply With Quote
|
05-21-2010, 03:02 PM
|
#5
|
|
Member
|
|
Join Date: Mar 2010
Location: Statesboro, Ga
Posts: 219
|
|
Member
Join Date: Mar 2010
Location: Statesboro, Ga
Posts: 219
|
I am in the same boat, just got mine with 96k on it and not sure of some of the maintenence. The oil and plugs are fine, however I am replacing the differential fluids and transfer case asap. I also plan to change the transmission fluid when able along with a MAF cleaning, I here that can make a big difference. I figure anything that is reasonable to do I want to go ahead and do it.
Maxil
__________________
98' SR5 4x4
Yaesu FT-8900 with Larsen NMO 150 Antenna
K&N Cold air intake
Koyo Radiator with B&M 70264 for towing
Amsoil fluid everywhere, except Radiator
|
|
Reply With Quote
|
05-21-2010, 04:48 PM
|
#6
|
|
Elite Member
|
|
Join Date: Nov 2006
Location: Pocono Mountains
Posts: 7,498
|
|
Elite Member
Join Date: Nov 2006
Location: Pocono Mountains
Posts: 7,498
|
Quote:
Originally Posted by brian2sun
I seperated my work log into 3 sections:
1) Stuff that I did/stuff I need to do according to mileage (in order of soonest to perform).
2) Stuff I have done because it broke/wore out (A-Z).
3) Little stuff to do whenever I get a chance (like replacing my door light triggers).
|
I tried that split between 1 & 2 on previous cars but I gave up. When something breaks, I end up doing as much needed maintenance as I can in the vicinity. Frozen e-brake bellcrank leads to clean, lube and adjust rear brakes (yikes, they need it and drum is off), flush brake fluid (oo--it was icky) and rotate tires (well, two are off). I applaud your intent but I am too disorganized to do it that way.
__________________
'99 4Runner SR5 5spd 3.4L V6 4WD(U.S), original '99 Talls in front, OME 906s in back, Hella fogs, Trekmaster shocks in front, Billy in back, no running boards, FIAMM horns, Alpine sound, Michelin LTX M/S2's, owned since new.
'97 HiLux SW4 5spd 4WD(Japan model bought in Brazil assembled in Argentina, very close to a 3.0 4Runner/Surf)
'71 FordWillys Jeep CJ5 (with straight six Ford Maverick 3.0 liter engine--lives in the mountains north of Sao Paulo Brazil)
My Backyard Frame Swap
|
|
Reply With Quote
|
05-21-2010, 06:40 PM
|
#7
|
|
Elite Member
|
|
Join Date: Dec 2009
Location: California
Posts: 5,470
|
|
Elite Member
Join Date: Dec 2009
Location: California
Posts: 5,470
|
Quote:
Originally Posted by TheDurk
I tried that split between 1 & 2 on previous cars but I gave up. When something breaks, I end up doing as much needed maintenance as I can in the vicinity. Frozen e-brake bellcrank leads to clean, lube and adjust rear brakes (yikes, they need it and drum is off), flush brake fluid (oo--it was icky) and rotate tires (well, two are off). I applaud your intent but I am too disorganized to do it that way.
|
I try to keep it organized, but it doesn't always work out like that. I will also usually try to take care of everything in an area even if it's not necessarily time to do each item yet - I think that is wise and probably saves a lot of effort in the long run.
I'll also adjust some of the mileage intervals so I can bang out several items in one shot. Like if I'm due to change my oil at 180K, rotate my tires at 182K and grease my driveline at 179K, I'll just do all 3 at 181K or something. I just make sure that nothing is going too far past the recommended interval.
__________________
2021 Tacoma 4x4 TRD Off Road Double Cab Short Bed (my DD)
2017 4Runner 4x4 Limited (the wife’s)
|
|
Reply With Quote
|
05-22-2010, 09:02 AM
|
#8
|
|
Registered User
|
|
Join Date: Mar 2008
Location: Dirty Jersey
Posts: 1,600
|
|
Registered User
Join Date: Mar 2008
Location: Dirty Jersey
Posts: 1,600
|
If you have office '07 then try this. I use it for my fiancee's car and my runner. There are a lot of templates on the Microsoft Office site so I would suggest you search there before creating your own. I like the fact that you can have different worksheets for each vehicle in Excel, otherwise I would just create a table in Word.
|
|
Reply With Quote
|
05-22-2010, 09:15 PM
|
#9
|
|
Member
|
|
Join Date: Jan 2010
Posts: 367
|
|
Member
Join Date: Jan 2010
Posts: 367
|
__________________
2001 M. Silver 4WD SR5 5VZ Love Machine
3rd Gen FAQ Here
|
|
Reply With Quote
|
05-22-2010, 10:25 PM
|
#10
|
|
Senior Member
|
|
Join Date: Dec 2008
Location: OREGON
Posts: 2,067
|
|
Senior Member
Join Date: Dec 2008
Location: OREGON
Posts: 2,067
|
at 100k id start thinking about the timing belt and water pump sure you could let it go a little longer but not too long
__________________
98 4runner sr5 3.4L 5spd 4x4 e-locker sold 10/2/11
07 tundra 5.7L 4x4 limited dc was my moms r.i.p 3/19/11
Oregon Toyota Owners Club
|
|
Reply With Quote
|
05-23-2010, 02:15 AM
|
#11
|
|
Member
|
|
Join Date: Jan 2010
Posts: 367
|
|
Member
Join Date: Jan 2010
Posts: 367
|
clean the MAF
water pump
timing belt
thermostat
pcv valve
lube chassis
retorque driveshaft bolts
air filter
drive belts
spark plugs (every 30,000)
diff fluids changed
trans flush or fluid change (auto - manual)
ps fluid flush
fuel filter
steering rack bushings
check your brakes for wear
__________________
2001 M. Silver 4WD SR5 5VZ Love Machine
3rd Gen FAQ Here
Last edited by notrayray; 05-23-2010 at 02:20 AM.
|
|
Reply With Quote
|
05-23-2010, 01:33 PM
|
#12
|
Member
|
|
Join Date: Apr 2010
Location: Houston, TX
Posts: 328
|
|
Member
Join Date: Apr 2010
Location: Houston, TX
Posts: 328
|
Quote:
Originally Posted by notrayray
retorque driveshaft bolts
|
Whats the correct torque?
|
|
Reply With Quote
|
05-23-2010, 10:24 PM
|
#13
|
|
Member
|
|
Join Date: Jan 2010
Posts: 367
|
|
Member
Join Date: Jan 2010
Posts: 367
|
__________________
2001 M. Silver 4WD SR5 5VZ Love Machine
3rd Gen FAQ Here
|
|
Reply With Quote
|
05-23-2010, 11:36 PM
|
#14
|
|
Member
|
|
Join Date: Mar 2008
Location: Pennsylvania
Age: 45
Posts: 678
|
|
Member
Join Date: Mar 2008
Location: Pennsylvania
Age: 45
Posts: 678
|
Look, I believe in preventative maintenance as well but seriously......spreadsheets????
__________________
98 4Runner Limited,265/75/16 Hankook Dynapros, KMC XD Black Hoss Wheels, Hella 500, Tokico, PP 1" Springs, Optima Red 34R, K&N, JL, Kenwood
|
|
Reply With Quote
|
03-17-2020, 09:03 PM
|
#15
|
Junior Member
|
|
Join Date: Mar 2020
Location: ALABAMA
Posts: 4
|
|
Junior Member
Join Date: Mar 2020
Location: ALABAMA
Posts: 4
|
lifetime powertrain warranty...they give it for free because only 1 in 1000 will follow thru , keep the vehicle forever, and do and document the required maintenance..."I AM THAT ONE " !
|
|
Reply With Quote
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|