Speedometer Calibration Spreadsheet - Ford Powerstroke Diesel Forum
User Tag List

Reply
 
LinkBack Thread Tools Display Modes
post #1 of 11 Old 09-15-2009, 10:05 PM Thread Starter
Transmission or Injectors
 
lwillson's Avatar
 
Join Date: Jan 2008
Location: Saskatoon, SK
Posts: 741
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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, 292 views)

lwillson is offline  
Sponsored Links
Advertisement
 
post #2 of 11 Old 09-16-2009, 07:04 PM
Compression Ignition Addict
 
pjwoolw's Avatar
 
Join Date: Jan 2009
Location: San Ramon Ca.
Posts: 369
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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.

Pete in San Ramon

2005 F250 6.0 4X4 Lariat CC short bed (stock)

1997 F250 7.3 4X4 XLT Reg. cab (stock)

1986 F250 6.9 4X4 XLT Gone but not forgotten



:
pjwoolw is offline  
post #3 of 11 Old 09-17-2009, 10:20 AM
Compression Ignition Addict
 
Join Date: Apr 2008
Location: Wellington Nevada
Posts: 8,701
Mentioned: 4 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Thanks: 1
Thanked 38 Times in 38 Posts
Feedback Score: 5 reviews
thanks!!! great idea.
CT Performance, Inc. is offline  
post #4 of 11 Old 10-17-2009, 04:31 PM
Powerstroke.org Rookie
 
Join Date: Oct 2009
Posts: 2
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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 06:37 PM.
Wisner955 is offline  
post #5 of 11 Old 10-17-2009, 06:15 PM Thread Starter
Transmission or Injectors
 
lwillson's Avatar
 
Join Date: Jan 2008
Location: Saskatoon, SK
Posts: 741
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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.

lwillson is offline  
post #6 of 11 Old 10-17-2009, 06:22 PM
Interior Guru
 
weareweird69's Avatar
 
Join Date: Nov 2007
Location: Blairsville, PA
Posts: 14,430
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 39 Post(s)
Thanks: 6
Thanked 15 Times in 15 Posts
Feedback Score: 3 reviews
So uh, where is this Module that needs replaced? After changing the speedo 6 times it needs replaced...

-Garrett


Too many projects. Too little time...
weareweird69 is offline  
post #7 of 11 Old 10-17-2009, 06:25 PM Thread Starter
Transmission or Injectors
 
lwillson's Avatar
 
Join Date: Jan 2008
Location: Saskatoon, SK
Posts: 741
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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

lwillson is offline  
post #8 of 11 Old 10-17-2009, 06:31 PM
Interior Guru
 
weareweird69's Avatar
 
Join Date: Nov 2007
Location: Blairsville, PA
Posts: 14,430
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 39 Post(s)
Thanks: 6
Thanked 15 Times in 15 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.

-Garrett


Too many projects. Too little time...
weareweird69 is offline  
post #9 of 11 Old 10-17-2009, 06:36 PM
Powerstroke.org Rookie
 
Join Date: Oct 2009
Posts: 2
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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
Wisner955 is offline  
post #10 of 11 Old 10-17-2009, 06:57 PM
Interior Guru
 
weareweird69's Avatar
 
Join Date: Nov 2007
Location: Blairsville, PA
Posts: 14,430
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 39 Post(s)
Thanks: 6
Thanked 15 Times in 15 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.

-Garrett


Too many projects. Too little time...
weareweird69 is offline  
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:
OR

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
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



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

 
For the best viewing experience please update your browser to Google Chrome