I have a spreadsheet that could be easily modified for this work. It already does speed in gears based on tire sizes, and has a calculation for wheel rpm's per mile.
One other factor to consider is the actual rolling radius of the tire, not just the stated radius (actually diameter, i.e., 31-10.50-15), as the actual may be quite different than the stated. You will also get differences from expansion of the effective rolling radius with speed from centrifugal effects on the tire tread, but they shouldn't exceed the unladen (tire inflated and suspended out of contact with terra firma) radius of the tire, unless you have a serious tire belt problem - an incipient blowout from carcass failure.
-------------------- Not responsible for advice not taken...
This site and all original materials contained herein are Copyright 1999 - 2013 by OutdoorWire, Inc. -- All Rights Reserved.
You may link freely to this site, but no further use is allowed without the express written permission of the owner of this material.
All corporate trademarks are the property of their respective owners.
This publication and OutdoorWire, Inc. assume no liability for your use of the material contained within this site.
OutdoorWire, 4x4Wire, SUVWire, JeepWire, MUIRNet-News, and 4x4Voice are all trademarks and publications of OutdoorWire, Inc.