Go Back   iRV2 Forums > TRAVEL TRAILER, 5th WHEEL & TRUCK CAMPER FORUMS > Trailer Towing and Tow Vehicles Discussion
Join iRV2 Today

Mission Statement: Supporting thoughtful exchange of knowledge, values and experience among RV enthusiasts.
  This discussion is proudly sponsored by:
Please support our sponsors and let them know you heard about their products on iRV2
Thread Tools Search this Thread Display Modes
Old 05-30-2014, 06:51 PM   #1
Junior Member
Join Date: Mar 2014
Posts: 1
Weight Distribution Spreadsheet Calculator

After going through two undersized weight distribution hitches, I developed a spreadsheet to calculate what size I actually needed. I also used the spreadsheet to help me load my travel trailer (TT) and tow vehicle (TV).

If any of you understand how to use spreadsheets, you can modify my spreadsheet to match you TT and TV combination.

You can find my latest spreadsheet revision at the following URL:

My spreadsheet to approximate what size of weight distribution hitch I needed for my travel trailer and suburban | Thoughts by DCG

Have Fun Camping,
David Geminden

davidgeminde is offline   Reply With Quote
Join the #1 RV Forum Today - It's Totally Free!

iRV2.com RV Community - Are you about to start a new improvement on your RV or need some help with some maintenance? Do you need advice on what products to buy? Or maybe you can give others some advice? No matter where you fit in you'll find that iRV2 is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with other RV owners, see fewer ads, upload photographs, create an RV blog, send private messages and so much, much more!

Old 05-31-2014, 08:37 AM   #2
Moderator Emeritus
SmokeyWren's Avatar

Join Date: Jun 2011
Location: Midland County, Texas
Posts: 2,756
Much too complicated for my lazy brain to critique. But the proof in the pudding is tongue weight shown by a tongue weight scale. Does the tongue weight scale confirm the accuracy of your spreadsheet results?

If you don't have a tongue weight scale, you can get wet and loaded tongue weight with two passes over the CAT scale. The first pass with the trailer tied on, but without the spring bars. The second pass without the trailer. Add the front and rear axle weights, and the difference with and without the trailer is tongue weight.

You also need the CAT scale report in the middle of a towing trip after you fill up the SUV with fuel and after all passengers return from the loo. The CAT scale report will give you front, rear and trailer axle weights, as well as gross weight of the rig. (Not tongue weight or trailer GVW).

You need two trips across the CAT scale to determine the percentages of tongue weight that is distributed to the three different axles - one with the spring bars not attached, and the other with the spring bars tightened to where you think they are properly adjusted.


My wet and loaded tongue weight was 570 pounds per my tongue weight scale.

Without the spring bars:
Steer axle =3040
drive axle = 3880
trailer axles = 3480
gross = 10,400

With spring bars tightened:
steer axle = 3280 = 240 pounds increase = 42% of tongue weight
drive axle = 3520 = 360 pounds decrease = 210 pounds remaining on the rear axle = 27% of tongue weight
trailer axles = 3620 = 140 pounds increase = 25% of tongue weight
gross = 10420 (20# scale error)

Conclusion: Hitch needs more adjustment to distribute less weight to the front axle and leave it on the rear axle. Goal is 25/50/25% and we now have 42/27/25. So try reducing the tightness of the spring bars by one length, then change the angle of the ball mount to the shank by a few degrees. Then weigh the rig again with the spring bars tightened, and check weight distribution again .
Grumpy ole man with over 50 years towing experience. Now my heaviest trailer is a 7,000-pound enclosed cargo trailer, RV is a 5,600 pound Skyline Nomad Joey 196S, and my tow vehicle is a 2012 F-150 EcoBoost SuperCrew.
SmokeyWren is online now   Reply With Quote


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not 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 Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Weight Distribution Distributing Trailer Hitch Opinion's palehorse89 Toads and Motorhome Related Towing 17 08-24-2015 01:53 PM
Weight distribution afrohman Class A Motorhome Discussions 3 05-11-2014 07:03 AM
Tongue Weight Question scfella Trailer Towing and Tow Vehicles Discussion 5 04-25-2014 09:37 PM
Load distribution balancing to achieve tongue weight kenn_chan Travel Trailer Discussion 17 01-20-2014 07:30 AM
Weight distribution WE RV 2 Travel Trailer Discussion 3 01-12-2014 05:56 PM

» Virginia Campgrounds

Reviews provided by

Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -6. The time now is 08:33 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.