Speedometer Calibration Spreadsheet - Ford Powerstroke Diesel Forum
Powerstroke.org is the premier Diesel Truck Forum on the internet. Registered Users do not see the above ads.
Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-15-2009, 09:05 PM
Transmission or Injectors
 

Join Date: Jan 2008
Location: Saskatoon, SK
Posts: 738
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: 1 reviews
Speedometer Calibration Spreadsheet

After reading the post

1994 speedo calibration

and similar ones, I wanted to make a spreadsheet to do all the math for me.

Hope it helps anyone who wants to change their calibration number
Attached Files
File Type: xls Speedometer Calculations.xls (37.0 KB, 252 views)
Reply With Quote Quick reply to this message
Sponsored Links
Advertisement
 
  #2  
Old 09-16-2009, 06:04 PM
Compression Ignition Addict
 

Join Date: Jan 2009
Location: San Ramon Ca.
Posts: 369
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: 0 reviews
I thank your sir! That will make things allot easier for many people.
Reply With Quote Quick reply to this message
  #3  
Old 09-17-2009, 09:20 AM
Compression Ignition Addict
 

Join Date: Apr 2008
Location: Wellington Nevada
Posts: 8,534
Thanks: 1
Thanked 27 Times in 27 Posts
Feedback Score: 5 reviews
thanks!!! great idea.
Reply With Quote Quick reply to this message
  #4  
Old 10-17-2009, 03:31 PM
Powerstroke.org Rookie
 

Join Date: Oct 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: 0 reviews
With all due respect for all the folks here I would like to add my experience.

I have 1994, F150, 300 Six, 5 speed stick, 2 wheel drive.

None of the information in these posts would apply to my truck. I ran the numbers and also looked at the spreadsheet listed. Going by the numbers here I came up with 1089 calibration number. That gave me 70 MPH at an indicated 64.5 on the speedometer - way wrong. I kind of figured it was not calculated right when I saw that the number was nearly off the chart with 28" tall tires.

I found the correct information here: (Reseting Recalibrating your PSOM for the Correct Speed)

As you will see it has completely different numbers from what is presented here and works correctly on my truck.

Hope this helps.

Paul

Last edited by Wisner955; 10-17-2009 at 05:37 PM.
Reply With Quote Quick reply to this message
  #5  
Old 10-17-2009, 05:15 PM
Transmission or Injectors
 

Join Date: Jan 2008
Location: Saskatoon, SK
Posts: 738
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: 1 reviews
You are correct, the numbers will be different.

When I made the spreadsheet, I used the calculation listed in the other post. I had no idea if it was correct or not, I just used that formula to derive the spreadsheet.

Having said that, the calculations also are based on the larger 3/4 ton rear end, which has a larger differential, therefore more teeth on the tone ring. The calculations will be different to compensate for the number of pulses that the PSOM has to calculate to determine a complete revolution. That is why the numbers will be off compared to a F-150 and a Bronco.
Reply With Quote Quick reply to this message
  #6  
Old 10-17-2009, 05:22 PM
Interior Guru
 

Join Date: Nov 2007
Location: Blairsville, PA
Posts: 14,022
Thanks: 4
Thanked 7 Times in 7 Posts
Feedback Score: 3 reviews
So uh, where is this Module that needs replaced? After changing the speedo 6 times it needs replaced...
Reply With Quote Quick reply to this message
  #7  
Old 10-17-2009, 05:25 PM
Transmission or Injectors
 

Join Date: Jan 2008
Location: Saskatoon, SK
Posts: 738
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: 1 reviews
The PSOM module is the speedometer itself. If you are patient, you can just change the speedo from the instrument cluster, but it is easier to just swap out the whole instrument cluster
Reply With Quote Quick reply to this message
  #8  
Old 10-17-2009, 05:31 PM
Interior Guru
 

Join Date: Nov 2007
Location: Blairsville, PA
Posts: 14,022
Thanks: 4
Thanked 7 Times in 7 Posts
Feedback Score: 3 reviews
Oh, Ive done that before, but I didnt think you could change the mileage back to correct then?



Is there a way to change the mileage displayed? Or can the dealership do that? Ive got another speedometer here just in case.
Reply With Quote Quick reply to this message
  #9  
Old 10-17-2009, 05:36 PM
Powerstroke.org Rookie
 

Join Date: Oct 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Feedback Score: 0 reviews
Iwillson,

Thank you for the reply. Good to know someone else is reading these things.

I understand that you used someones "formula" and created a spreadsheet. My beef is with the original formula and numbers - I've tried to run them every which way I can think of and see no explanation for "20186" and the ".6666" or "66.66". I'd like to have Woody 1 walk me through the basis of 20186 and .6666.

Speedometers are the same for the trucks and it can only be 1) Revs/mile (tire size), 2) Number of tone ring teeth (108 or 120), and 3) the constant (8000 or ?).

I just don't want folks later on to get frustrated and waste time like I did using those "numbers"

Best Regards,
Paul
Reply With Quote Quick reply to this message
  #10  
Old 10-17-2009, 05:57 PM
Interior Guru
 

Join Date: Nov 2007
Location: Blairsville, PA
Posts: 14,022
Thanks: 4
Thanked 7 Times in 7 Posts
Feedback Score: 3 reviews
Here is some more information for you guys

7.5" Axles have 108 teeth on the ring
8.8" Axles have 120 teeth
10.25" Axles have 120 teeth
10.50" Axles have 120 teeth
11" Axles have 120 teeth

I also found this...

TOD = Tire Outside Diameter

If TOD is greater than 25.2", use Formula Revs/miles = 1528 - (28xTOD) to calculate SAE average revs/mile

If TOD is less than 25.2", revs/mile = 10,850/TOD.
Reply With Quote Quick reply to this message
Sponsored Links
Advertisement
 
Reply

Quick Reply
Message:
Options

Register Now

In order to be able to post messages on the Ford Powerstroke Diesel Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:

Log-in

Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.



Thread Tools
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -8. The time now is 11:16 AM.


Powered by vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.6.1
Garage Plus, Vendor Tools vBulletin Plugins by Drive Thru Online, Inc.

vB.Sponsors