Home Menu

Site Navigation


User Tag List

Reply
 
Thread Tools Rate Thread Display Modes
Old 05-21-2010, 12:24 PM #1
Whiplash Willy's Avatar
Whiplash Willy Whiplash Willy is offline
Member
 
Join Date: May 2010
Location: Portland, Or
Age: 43
Posts: 773
Whiplash Willy is on a distinguished road
Whiplash Willy Whiplash Willy is offline
Member
Whiplash Willy's Avatar
 
Join Date: May 2010
Location: Portland, Or
Age: 43
Posts: 773
Whiplash Willy is on a distinguished road
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!
Whiplash Willy is offline   Reply With QuoteReply With Quote
Old 05-21-2010, 12:36 PM #2
denverunner's Avatar
denverunner denverunner is offline
Member
 
Join Date: Nov 2009
Location: Denver, CO
Posts: 151
Real Name: Kyle
denverunner is on a distinguished road
denverunner denverunner is offline
Member
denverunner's Avatar
 
Join Date: Nov 2009
Location: Denver, CO
Posts: 151
Real Name: Kyle
denverunner is on a distinguished road
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.
denverunner is offline   Reply With QuoteReply With Quote
Old 05-21-2010, 12:57 PM #3
TheDurk's Avatar
TheDurk TheDurk is offline
Elite Member
 
Join Date: Nov 2006
Location: Pocono Mountains
Posts: 7,498
TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light
TheDurk TheDurk is offline
Elite Member
TheDurk's Avatar
 
Join Date: Nov 2006
Location: Pocono Mountains
Posts: 7,498
TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light
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
TheDurk is offline   Reply With QuoteReply With Quote
Old 05-21-2010, 01:24 PM #4
brian2sun's Avatar
brian2sun brian2sun is offline
Elite Member
 
Join Date: Dec 2009
Location: California
Posts: 5,470
brian2sun has a spectacular aura about brian2sun has a spectacular aura about
brian2sun brian2sun is offline
Elite Member
brian2sun's Avatar
 
Join Date: Dec 2009
Location: California
Posts: 5,470
brian2sun has a spectacular aura about brian2sun has a spectacular aura about
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).
__________________
1997 4Runner 4x4 SR5 - Geared, Locked & Armored
**CLICK FOR '97 BUILD THREAD**
2021 Tacoma 4x4 TRD Off Road Double Cab Short Bed (my DD)
2017 4Runner 4x4 Limited (the wife’s)
brian2sun is offline   Reply With QuoteReply With Quote
Old 05-21-2010, 03:02 PM #5
Maxil's Avatar
Maxil Maxil is offline
Member
 
Join Date: Mar 2010
Location: Statesboro, Ga
Posts: 219
Maxil is on a distinguished road
Maxil Maxil is offline
Member
Maxil's Avatar
 
Join Date: Mar 2010
Location: Statesboro, Ga
Posts: 219
Maxil is on a distinguished road
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
Maxil is offline   Reply With QuoteReply With Quote
Old 05-21-2010, 04:48 PM #6
TheDurk's Avatar
TheDurk TheDurk is offline
Elite Member
 
Join Date: Nov 2006
Location: Pocono Mountains
Posts: 7,498
TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light
TheDurk TheDurk is offline
Elite Member
TheDurk's Avatar
 
Join Date: Nov 2006
Location: Pocono Mountains
Posts: 7,498
TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light TheDurk is a glorious beacon of light
Quote:
Originally Posted by brian2sun View Post
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
TheDurk is offline   Reply With QuoteReply With Quote
Old 05-21-2010, 06:40 PM #7
brian2sun's Avatar
brian2sun brian2sun is offline
Elite Member
 
Join Date: Dec 2009
Location: California
Posts: 5,470
brian2sun has a spectacular aura about brian2sun has a spectacular aura about
brian2sun brian2sun is offline
Elite Member
brian2sun's Avatar
 
Join Date: Dec 2009
Location: California
Posts: 5,470
brian2sun has a spectacular aura about brian2sun has a spectacular aura about
Quote:
Originally Posted by TheDurk View Post
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.
__________________
1997 4Runner 4x4 SR5 - Geared, Locked & Armored
**CLICK FOR '97 BUILD THREAD**
2021 Tacoma 4x4 TRD Off Road Double Cab Short Bed (my DD)
2017 4Runner 4x4 Limited (the wife’s)
brian2sun is offline   Reply With QuoteReply With Quote
Old 05-22-2010, 09:02 AM #8
004Gunner's Avatar
004Gunner 004Gunner is offline
Registered User
 
Join Date: Mar 2008
Location: Dirty Jersey
Posts: 1,600
004Gunner is on a distinguished road
004Gunner 004Gunner is offline
Registered User
004Gunner's Avatar
 
Join Date: Mar 2008
Location: Dirty Jersey
Posts: 1,600
004Gunner is on a distinguished road
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.
004Gunner is offline   Reply With QuoteReply With Quote
Old 05-22-2010, 09:15 PM #9
notrayray's Avatar
notrayray notrayray is offline
Member
 
Join Date: Jan 2010
Posts: 367
notrayray is on a distinguished road
notrayray notrayray is offline
Member
notrayray's Avatar
 
Join Date: Jan 2010
Posts: 367
notrayray is on a distinguished road
I use this....
MyCar-Monitor - Free software downloads and software reviews - CNET Download.com
__________________
2001 M. Silver 4WD SR5 5VZ Love Machine

3rd Gen FAQ Here
notrayray is offline   Reply With QuoteReply With Quote
Old 05-22-2010, 10:25 PM #10
Elton H's Avatar
Elton H Elton H is offline
Senior Member
 
Join Date: Dec 2008
Location: OREGON
Posts: 2,067
Elton H is on a distinguished road
Elton H Elton H is offline
Senior Member
Elton H's Avatar
 
Join Date: Dec 2008
Location: OREGON
Posts: 2,067
Elton H is on a distinguished road
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
Elton H is offline   Reply With QuoteReply With Quote
Old 05-23-2010, 02:15 AM #11
notrayray's Avatar
notrayray notrayray is offline
Member
 
Join Date: Jan 2010
Posts: 367
notrayray is on a distinguished road
notrayray notrayray is offline
Member
notrayray's Avatar
 
Join Date: Jan 2010
Posts: 367
notrayray is on a distinguished road
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.
notrayray is offline   Reply With QuoteReply With Quote
Old 05-23-2010, 01:33 PM #12
bigtimeweb bigtimeweb is offline
Member
 
Join Date: Apr 2010
Location: Houston, TX
Posts: 328
bigtimeweb is on a distinguished road
bigtimeweb bigtimeweb is offline
Member
 
Join Date: Apr 2010
Location: Houston, TX
Posts: 328
bigtimeweb is on a distinguished road
Quote:
Originally Posted by notrayray View Post
retorque driveshaft bolts
Whats the correct torque?
bigtimeweb is offline   Reply With QuoteReply With Quote
Old 05-23-2010, 10:24 PM #13
notrayray's Avatar
notrayray notrayray is offline
Member
 
Join Date: Jan 2010
Posts: 367
notrayray is on a distinguished road
notrayray notrayray is offline
Member
notrayray's Avatar
 
Join Date: Jan 2010
Posts: 367
notrayray is on a distinguished road
Quote:
Originally Posted by bigtimeweb View Post
Whats the correct torque?
1996 to 2002 Toyota 4Runner OEM Repair and Wiring Manuals

http://www.ncttora.com/fsm/1996/SIL/.../pr/torspe.pdf

54 ft/lb's
__________________
2001 M. Silver 4WD SR5 5VZ Love Machine

3rd Gen FAQ Here
notrayray is offline   Reply With QuoteReply With Quote
Old 05-23-2010, 11:36 PM #14
bgmac's Avatar
bgmac bgmac is offline
Member
 
Join Date: Mar 2008
Location: Pennsylvania
Age: 45
Posts: 678
bgmac is on a distinguished road
bgmac bgmac is offline
Member
bgmac's Avatar
 
Join Date: Mar 2008
Location: Pennsylvania
Age: 45
Posts: 678
bgmac is on a distinguished road
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
bgmac is offline   Reply With QuoteReply With Quote
Old 03-17-2020, 09:03 PM #15
Meherg Meherg is offline
Junior Member
 
Join Date: Mar 2020
Location: ALABAMA
Posts: 4
Meherg is on a distinguished road
Meherg Meherg is offline
Junior Member
 
Join Date: Mar 2020
Location: ALABAMA
Posts: 4
Meherg is on a distinguished road
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 " !
Meherg is offline   Reply With QuoteReply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

Powered by vBadvanced CMPS v3.2.2

All times are GMT -4. The time now is 02:32 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
***This site is an unofficial Toyota site, and is not officially endorsed, supported, authorized by or affiliated with Toyota. All company, product, or service names references in this web site are used for identification purposes only and may be trademarks of their respective owners. The Toyota name, marks, designs and logos, as well as Toyota model names, are registered trademarks of Toyota Motor Corporation***Ad Management plugin by RedTyger
 
Copyright © 2020