Journey with Confidence RV GPS App RV Trip Planner RV LIFE Campground Reviews RV Maintenance Take a Speed Test Free 7 Day Trial ×


Reply
 
Thread Tools Display Modes
Old 03-24-2014, 07:54 PM   #1
Junior Member
 
Join Date: Aug 2013
Posts: 17
Smile My spreadsheet for WD hitch for my travel trailer and TV

After reading the "Sticky" thread in the "Towing" forum on the Open Road Forums and some communications with Ron Gratz, I worked up a spreadsheet using "LibreOffice Calc" in the free Libreoffice Suite that I used to approximate what size weight distribution (WD) hitch I needed. I had Libreoffice save it as a MS xls spreadsheet file. The link to the spreadsheet is at the end of this post.


My spreadsheet is an obvious overkill, because most manufactures of WD hitches only use the travel trailer (TT) tongue weight, the hitch weight, the load weight behind the rear axle of the towing vehicle (TV) and the total loaded weight of the trailer to determine the size of WD for their customers.


I had fun putting the spreadsheet together, but I need some more eyes and brains to critique the spreadsheet so I can make improvements and find errors I made so I can correct them.


http://thoughtsbydcg.files.wordpress...ght-calc71.xls


David Geminden
davidgeminden is offline   Reply With Quote
Old 03-27-2014, 04:40 PM   #2
Junior Member
 
Join Date: Aug 2013
Posts: 17
I revised the spreadsheet -- Version b

Hi RVers,

I revised the spread sheet to version b. The link is below:

http://thoughtsbydcg.files.wordpress...ght-calc7b.xls

The new version has added calculations for TV total weight with WD hitch activated, TV rear axle weight with active WD hitch, TV front axle weight with WD hitch active and total TV weight. It also has front, read TV axle weights and total TV weight when disconnected from the trailer and WD hitch not on the back of my 1500 suburban.

David Geminden
__________________
Rockwood 2109s by Forest River -- 21' 6"
2005 1500 Z71 Suburban 5.3L 4.10 ratio
400 watts of PV solar panels
Two 6v 216 Amp-Hour Batteries
davidgeminden is offline   Reply With Quote
Old 03-29-2014, 02:29 PM   #3
Junior Member
 
Join Date: Jul 2013
Posts: 15
Looks great! I will try inputting some of my specs!
PhotoDj is offline   Reply With Quote
Old 04-02-2014, 12:57 PM   #4
Junior Member
 
Join Date: Aug 2013
Posts: 17
Hi All,

I found some more errors and corrected them, and I also made some modifications. Below is a link to revision d.

http://thoughtsbydcg.files.wordpress...ght-calc7d.xls
__________________
Rockwood 2109s by Forest River -- 21' 6"
2005 1500 Z71 Suburban 5.3L 4.10 ratio
400 watts of PV solar panels
Two 6v 216 Amp-Hour Batteries
davidgeminden is offline   Reply With Quote
Old 04-02-2014, 06:21 PM   #5
H2oski
 
Join Date: Dec 2008
Location: Hartford, AL
Posts: 639
Quote:
Originally Posted by davidgeminden View Post
Hi All,
I love it when people understand arm and moment

I have a weight and balance program on excel., PM me and I'll send it to to you and you can look at and use any of it you like if it will help.

Delete if you don't like it.
__________________
Wife
2007 Chevy 2500 HD 6.6
2012 Sabre 31RETS
(LA) Lower Alabama
h20ski is offline   Reply With Quote
Old 04-02-2014, 07:48 PM   #6
chicagoslick
 
chicagoslick's Avatar
 
Join Date: Dec 2013
Location: Indianapolis Area
Posts: 198
Impressive...
__________________

Gary, Tonia, Baile, Summer and Otis our Boston T.
Flagstaff 27RLWS Emerald Pkg
2015 Ford F150 King Ranch FX4 Max Tow 3.5EB, 3.55
Equalizer 4 WDH, 1,200 / 12,000Lbs
chicagoslick is offline   Reply With Quote
Old 04-03-2014, 12:40 AM   #7
Junior Member
 
Join Date: Aug 2013
Posts: 17
Hi All,

Again, I found some more errors and corrected them, and I also made some modifications. Below is a link to revision e.

http://thoughtsbydcg.files.wordpress...ght-calc7e.xls
__________________
Rockwood 2109s by Forest River -- 21' 6"
2005 1500 Z71 Suburban 5.3L 4.10 ratio
400 watts of PV solar panels
Two 6v 216 Amp-Hour Batteries
davidgeminden is offline   Reply With Quote
Old 04-06-2014, 03:03 PM   #8
Junior Member
 
Join Date: Aug 2013
Posts: 17
Hi Everyone,


I have posted my "My Travel Trailer Weight Distribution Hitch Calculator" on several different RV & Travel Trailer forums. Therefore, in order to not have to post an update on all those forums each time I update my spreadsheet calculator, I am posting the url for my website where I have posted all my updated versions.


If you are interested in obtaining my latest version of the spreadsheet, please go to the following link:


My spreadsheet to approximate what size of weight distribution hitch I needed for my travel trailer and suburban | Thoughts by DCG
__________________
Rockwood 2109s by Forest River -- 21' 6"
2005 1500 Z71 Suburban 5.3L 4.10 ratio
400 watts of PV solar panels
Two 6v 216 Amp-Hour Batteries
davidgeminden is offline   Reply With Quote
Reply

Tags
hitch, trailer, travel, travel trailer

Thread Tools
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


» Featured Campgrounds

Reviews provided by

Disclaimer:

This website is not affiliated with or endorsed by Forest River, Inc. or any of its affiliates. This is an independent, unofficial site.



All times are GMT -5. The time now is 02:53 AM.