Updating previous posts about recorded mileage I’m getting in the Scout, I did some beginner math in Excel and then had to call in my sister, the logistics expert, to help me with a formula. The speedometer is original to the truck and to 28″ tires, which means a 4″ lift and 32″ tires throw off the odometer by a factor of 1.13 (88 miles indicated to 100 true). I figured out the calculation in Excel to take the base mileage number from 2014 and increase it exponentially to match that ratio, but I couldn’t find a way to modify that calculation to change the reference by one in each successive row. Renie unlocked the Excel formula which then made it easy to duplicate just by pulling the control corner down vs. copy/pasting the formula and updating the numbers by hand. Which sucked.
So there it is. The odometer says 48552, but the actual miles are 50342, or at least, starting from 2014. All of this work is purely academic; I have no idea when the lift was installed or what the true mileage on the engine is—I doubt this odometer was original to the drivetrain, being that it’s installed in a body tub from 1975—but these engines were made to last 300,000 miles in constant use by dump trucks and schoolbuses. This engine is running like a Swiss watch, so I’ll just keep the oil clean and make sure the important maintenance is covered.