I'm having a bit of a slack day and was pondering the repair / maintenance topic again so I decided to map out what the DB might look like for comments (and maybe a tiny bit of encouragement to have it done).





Vehicle Information Master (combine with Mileage DB master?)

• Vehicle Type<
• Starting Mileage<
• Extended Warranty Coverage (Y/N)<
• Price Paid for Extended Warranty<

Service Record Table

• Current Mileage<
• Type of Service (see service category listing)<
• Covered under Factory Warranty (Y/N)<
• Covered under Extended Warranty (Y/N)<
• Cost of Service<
• Approx. value of service if received under Extended Warranty<
• Comment / Description<

Service Category Table



Maintenance

• Oil Filter Reg
• Oil Filter Syn
• Brakes
• Transmission / Transaxle Fluid / Service
• Coolant / Rad Flush
• Belts
• Tires (worn or failed only)

Repair

• Hybrid Specific (Battery, Electric Motor, CPU, generator, CVT)
• Engine / Transmission component
• Body Electrical (lights, dash, power assessories, audio, etc.)
• Body (latches, doors, panels, trim, squeeks, rattles, rust, etc.)
• Breakdown Costs (towing, rentals, hotels, etc.)

Accident Repair

• Glass Replacement
• Bodywork

Basic Queries / Reports by Vehicle Type

• Total Maintenance Costs per 1000 mi<
• Individual subcategory Maintenance Costs per 1000 mi<
• Total Repair Costs per 1000 mi<
• Individual subcategory Repair Costs per 1000mi<
• Top 5 Count of Repair Types<
• Top 5 Count of Factory Warranty Covered Repairs<
• Top 5 Count of Extended Warranty Covered Services.<
• Percentage of Vehicles with Extended Warranty Coverage<
• Average price paid for Extended Warranty<
• Average total value of services received from Extended Warranty Coverage<

So... Ready next week?

Two climate control systems, one inside and the other at the tailpipe.

2007 Camry Hybrid (in service June 2006)
FE: 6.77L/100km (34.8 mpg) over 37750km (23450mi)
75% city - Ave trip 20 min - 2 Winters