Jayco RV Owners Forum
 


Reply
 
Thread Tools Display Modes
 
Old 06-16-2015, 02:50 PM   #1
Senior Member
 
Join Date: Aug 2011
Location: Missouri City, The Republic of Texas
Posts: 3,010
Post My Weight Analysis Spreadsheets

I've created a couple of weight analysis spreadsheets. One for a 5th and another for a Bumper-pull. Guess I've got too much time on my hands.
Click image for larger version

Name:	5th weight.png
Views:	107
Size:	106.0 KB
ID:	18713

Click image for larger version

Name:	TT weight.png
Views:	113
Size:	122.1 KB
ID:	18714
__________________

__________________
Cheers,
T_

2013 F-350 CC SB 2WD 6.7PS
2013 Eagle Premier 351 RLTS
-SOLD- 2012 X23B
-SOLD- 2003 Ford Expedition 5.4, Bilstein shocks
RedHorse1 is offline   Reply With Quote
Old 06-16-2015, 02:54 PM   #2
Senior Member
 
Filthy-Beast's Avatar
 
Join Date: May 2015
Location: Chicago
Posts: 269
Nice and clean looking, I also track max tongue weight of my hitch receiver, not that I'll ever be close.
__________________

__________________
2015 Jay Flight 31 RLDS
2015 F250, Reese straightline
Ham Lic: W4TFB
Filthy-Beast is offline   Reply With Quote
Old 06-16-2015, 03:08 PM   #3
Senior Member
 
Join Date: Oct 2014
Location: St. Clairsville
Posts: 227
It is interesting to me that we worry so much about this nowadays. Not necessarily in a bad way, just interesting. Remember back when we just hooked up and drove? And if you had a dually you could tow anything. This topic has gotten very complicated. Nice clean looking spreadsheets!
djtho1 is offline   Reply With Quote
Old 06-16-2015, 03:41 PM   #4
Senior Member
 
Join Date: Aug 2011
Location: Missouri City, The Republic of Texas
Posts: 3,010
Thanks! I did my first one for the X23B and was surprised how close on the rear axle I was. Basically I just started throwing numbers on the sheet and doing a few calcs. When we upgraded to the 5th I made the 2nd sheet and kept tinkering with it until I liked the look. Just recently I overhauled the first sheet and made it look like the newer one.
__________________
Cheers,
T_

2013 F-350 CC SB 2WD 6.7PS
2013 Eagle Premier 351 RLTS
-SOLD- 2012 X23B
-SOLD- 2003 Ford Expedition 5.4, Bilstein shocks
RedHorse1 is offline   Reply With Quote
Old 06-17-2015, 08:11 AM   #5
Senior Member
 
Join Date: Feb 2014
Location: Owensboro, KY
Posts: 239
Looks great red horse1. I've though about doing this myself...but not enough spare time! Can you post in a downloadable format?
__________________
2015 Jayco 27DSRL (Sold and shopping for new 5er)
2016 Little Guy CIRRUS 800 Truck Camper
2015 GMC SLT 3500 Duramax Crew Cab, SRW
KYCAMPER is offline   Reply With Quote
Old 06-17-2015, 10:10 AM   #6
Member
 
SBL9A's Avatar
 
Join Date: Aug 2014
Location: Indiana
Posts: 30
Looks nicer than mine. Are you going to share them? Thanks.
__________________
SBL9A

"Its easier to ask forgivness than permission"
SBL9A is offline   Reply With Quote
Old 06-17-2015, 11:01 AM   #7
Senior Member
 
Join Date: Aug 2011
Location: Missouri City, The Republic of Texas
Posts: 3,010
Quote:
Originally Posted by SBL9A View Post
Looks nicer than mine. Are you going to share them? Thanks.
I'm happy to share.
I can't post an Excel Spreadsheet so I've posting it as a ZIP file. There are 2 versions included, an ".XLS" and ".XLSX". The XLS should work with older versions of Excel and the XLSX with the newer versions. The boxes with "GREEN" fill (Column "I") are my attempt to show Over/Under weights (RED being over weight). Some of the Conditional Formatting may be lost in the XLS version but that's just window dressing.
Each spreadsheet has 2 tabs, one for a 5th and one for a bumper-pull.
The cells I intend to be changed have a "RED" outline and currently contain the numbers from our HTT (now gone) and 5th.
I have hidden column "M" just to make it a little more tidy.

Feel free to make any changes you like (including the title).

Please note that though I believe my calculations are correct I do not guarantee them to be error free. If you find errors please let me know so I can update the sheets.

SBL, I would be interested to hear if our calculations give different results.

Weight Analysis-v3.0.zip

If you have trouble with the ZIP file send me a PM with a return e-mail and I'll send an unzipped copy directly to you.

__________________
Cheers,
T_

2013 F-350 CC SB 2WD 6.7PS
2013 Eagle Premier 351 RLTS
-SOLD- 2012 X23B
-SOLD- 2003 Ford Expedition 5.4, Bilstein shocks
RedHorse1 is offline   Reply With Quote
Old 06-17-2015, 07:06 PM   #8
Senior Member
 
Nighthawk 96's Avatar
 
Join Date: Apr 2011
Location: Columbia SC
Posts: 571
Thanks for these, will check them (trailer one) against another set that I have and get back to you later.
__________________
2012 Toyota Tundra 5.7 Litre DoubleCab
6 speed, 4.30 Limited Slip, Tow Package
2013 Jayco White Hawk 27DSRL
2010 Jayco JayFlight 26BH sold
Yamaha EF2000is Generators (2)
1996 Honda CB750 Nighthawk
Nighthawk 96 is offline   Reply With Quote
Old 06-18-2015, 06:25 AM   #9
Member
 
SBL9A's Avatar
 
Join Date: Aug 2014
Location: Indiana
Posts: 30
Redhorse,

Your sheet is more detailed but shows the same numbers for tongue weight. I'm about 100lbs light. I'm going to transfer some weight forward for the next trip. Thanks again.
__________________
SBL9A

"Its easier to ask forgivness than permission"
SBL9A is offline   Reply With Quote
Old 06-20-2015, 06:14 PM   #10
Senior Member
 
Nighthawk 96's Avatar
 
Join Date: Apr 2011
Location: Columbia SC
Posts: 571
Trailer sheet looks real good to me. Easy to use, better laid out my current sheet.
Thanks for posting.
__________________

__________________
2012 Toyota Tundra 5.7 Litre DoubleCab
6 speed, 4.30 Limited Slip, Tow Package
2013 Jayco White Hawk 27DSRL
2010 Jayco JayFlight 26BH sold
Yamaha EF2000is Generators (2)
1996 Honda CB750 Nighthawk
Nighthawk 96 is offline   Reply With Quote
Reply

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


» Virginia State Campgrounds

Reviews provided by

Powered by vBadvanced CMPS v3.2.3

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


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2002-2016 Social Knowledge, LLC All Rights Reserved.