Great works fine thanks :-)

Regards
Ben


--- In exceldyno@yahoogroups.com, "Wes" <bajawes@...> wrote:
>
> Hi Ben,
>
> Yes, you've found a problem. It is calculating the rpm in gear
wrong
> for mph. I don't have many mph users so no-ones really noticed
> before.
>
> I'll fix it and post up a new version of the spreadsheet soon.
>
> If you want to fix it yourself, do the following;
> * Select columns R and U, right click and select unhide.
> * Change cell T33 from =IF($J$23="kph",J33,J33/mtokm)
> to =IF($J$23="kph",J33,J33*mtokm)
> * Select columns S and T, right click and select hide
>
> There you go, all fixed and ready to calculate in mph.
>
> Cheers,
> Wes
>
> --- In exceldyno@yahoogroups.com, "Ben Spray" <ben@> wrote:
> >
> > Hi All
> >
> > Just found this spreadsheet this week. really is great...
> > Im using it to try to work out a gearbox / reduction (transfer)
> ratio
> > on my land rover expedition truck which has been converted to a
> diesel
> > engine.
> >
> > One thing which Ive noticed may just be something Im doing but
the
> bit
> > on the input sheet that works out the RPM ina certain gear at a
> certain
> > speed seems to work fine in KPH but not in MPH? trying to find a
> good
> > ratio to cruise at 2500rpm in top gear (can see it on the gearing
> graph
> > anyway but would be good to figure out what Im doing on the input
> page)
> >
> > Cheers
> > Ben
> >
>