Spreadsheet: 751524d1634154641-is-there-a-better-way-than-indirect-test-vehicle-and-equipment-maintenance-log
Sheet: 83

Vehicle [NAME] |  |  |  | Total Repair Cost: |  |  | Back to Master List
 | Vehicle ID Number: |  |  | Purchased: | 2018-08-16 00:00:00
 | Year: | 2018 |  | Sold:
 | Make: | Ram
 | Model: | 1500 (Sean)
 | Engine: | Gas |  | Current Mileage/Hours: |  |  | ◄ DO NOT EDIT Current Mileage on this sheet, only on the Master List
 | Serial #: |  |  | Next Service Due: |  |  | ◄ CHANGE to next Service Due
 | License Plate: |  |  | Last Oil Change: |  |  | ◄ DO NOT EDIT
Date of Service | Mileage at Service | Work Performed and Service Schedule | Performed By | Cost | Notes
2018-08-16 00:00:00 | 20 | Purchased from OCJ Dodge
2018-12-21 00:00:00 | 7597 | Engine oil, filter & lube, washer fluid
2019-02-20 00:00:00 | 11124 | [NAME] |  |  |  |  | ◄ Tip: Enter a new line within a cell by typing Alt+Enter
2019-06-11 00:00:00 | 19188 | Engine oil, filter & lube, washer fluid
2019-07-03 00:00:00 | 21278 | Recall Occupant Restraint Module Recall Tailgage Actuator 27 point inspection
2020-03-19 00:00:00 | 37789 | Replace headlight bulb
2020-05-20 00:00:00 | 40364 | (4) New Tires |  |  |  |  | ◄ Tip: Itemize costs by entering work and/or parts on separate lines
2020-07-29 00:00:00 | 44208 | Engine oil, filter & lube, washer fluid, tire ballanced & rotated
2021-01-04 00:00:00 | 53220 | Engine oil, filter & lube |  |  |  |  | ◄ Clear the example by selecting cells and pressing Delete
2021-10-04 00:00:00 | 69887 | [NAME]
 |  |  |  |  |  |  | ◄ Tip: Enter a new line within a cell by typing Alt+Enter
 |  |  |  |  |  |  | ◄ Tip: Itemize costs by entering work and/or parts on separate lines
 |  |  |  |  |  |  | ◄ [NAME] new rows above this last row
 | 5000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 10000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 15000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 15000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 20000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 25000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 30000 | Change automatic transmission/[NAME] |  |  | Every 30,000 Miles
 | 30000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 30000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 35000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 40000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 45000 | Change Engine Coolant |  |  | Change every 45,000 Miles or every 3 Years
 | 45000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 45000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 50000 | Change front/rear axle gear oil |  |  | Every 50,000 Miles
 | 50000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 55000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 55000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 60000 | Change automatic transmission/[NAME] |  |  | Every 30,000 Miles
 | 60000 | Change transfer case fluid |  |  | Every 60,0000 Miles
 | 60000 | Change spark plugs |  |  | Every 60,0000 Miles
 | 60000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 65000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 70000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 70000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 75000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 80000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 85000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 85000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 90000 | Change automatic transmission/[NAME] |  |  | Every 30,000 Miles
 | 90000 | Change Engine Coolant |  |  | Change every 45,000 Miles or every 3 Years
 | 90000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 95000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 100000 | Change front/rear axle gear oil |  |  | Every 50,000 Miles
 | 100000 | • Change oil and oil fiiter • Replace air filteras required • Inspect and lubricate U-joints • Inspect brake system • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 105000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 105000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 110000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 115000 | • Change oil and oil fiiter • Replace air filteras required • Inspect and lubricate U-joints • Inspect brake system • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 120000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 120000 | Change automatic transmission/[NAME] |  |  | Every 30,000 Miles
 | 120000 | Change transfer case fluid |  |  | Every 60,000 Miles
 | 120000 | Change spark plugs |  |  | Every 60,000 Miles
 | 120000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 125000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 130000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 130000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 135000 | Change Engine Coolant |  |  | Change every 45,000 Miles or every 3 Years
 | 135000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 140000 | • Change oil and oil fiiter • Replace air filteras required • Inspect and lubricate U-joints • Inspect brake system • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | or every 6 Months or 200 Hours of engine operation
 | 145000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 145000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 150000 | Change automatic transmission/[NAME] |  |  | Every 30,000 Miles
 | 150000 | Change front/rear axle gear oil |  |  | Every 50,000 Miles
 | 150000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 155000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 160000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 160000 | • Change oil and oil fiiter • Replace air filteras required • Inspect and lubricate U-joints • Inspect brake system • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 165000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 170000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 175000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 175000 | • Change oil and oil fiiter • Replace air filteras required • Inspect and lubricate U-joints • Inspect brake system • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 180000 | Change automatic transmission/[NAME] |  |  | Every 30,000 Miles
 | 180000 | Change Engine Coolant |  |  | Change every 45,000 Miles or every 3 Years
 | 180000 | Change transfer case fluid |  |  | Every 60,000 Miles
 | 180000 | Change spark plugs |  |  | Every 60,000 Miles
 | 180000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 185000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 190000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 190000 | • Change oil and oil fiiter • Replace air filteras required • Inspect and lubricate U-joints • Inspect brake system • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 195000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 200000 | Change front/rear axle gear oil |  |  | Every 50,000 Miles
 | 200000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 205000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 205000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 210000 | Change automatic transmission/[NAME] |  |  | Every 30,000 Miles
 | 210000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 215000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 220000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 220000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 225000 | Change Engine Coolant |  |  | Change every 45,000 Miles or every 3 Years
 | 225000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 230000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 235000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 235000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 240000 | Change automatic transmission/[NAME] |  |  | Every 60,000 Miles
 | 240000 | Change transfer case fluid |  |  | Every 60,000 Miles
 | 240000 | Change spark plugs |  |  | Every 60,000 Miles
 | 240000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 245000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours
 | 250000 | Change front/rear axle gear oil |  |  | Every 50,000 Miles
 | 250000 | Replace fuel filter |  |  | Every 15,000 Miles
 | 250000 | • Change oil and oil fiiter • Replace air filter as required [NAME] all fluids [NAME] • Rotate Tires & Inspect • Lubricate zerk fittings |  |  | Every 5000 Miles, 6 Months or 200 Hours