Jayco RV Owners Forum
 


Reply
 
Thread Tools Display Modes
 
Old 04-18-2014, 01:25 PM   #1
Senior Member
 
Join Date: Aug 2011
Location: Missouri City, The Republic of Texas
Posts: 3,007
5th Wheel weight analysis

I've been busy (having fun). I'm uploading a ZIP file that contains 2 Microsoft Excel spreadsheets for your amusement. This sheet asks you to input the weights from your TV and FW load stickers and your CAT scale results. The analysis will tell you how you are loaded and whether you are in or out of weight limits.
There are 4 sections that expect you to enter data and they all have a bright green border:
1) the title - whatever makes you happy
2) the sticker weights
3) the CAT scale weights
4) the pin weight range (as a percentage)
The Analysis section will calculate some weights and show how much under or over weight you are. The "J" column will have a Green/Red indicator to indicate Under/Over weight.

Feel free to download and use/abuse as you feel.

Disclaimer: I've done what I can to insure the results are accurate but there's no guarantee. Let me know if I've made some mistakes!

Note: I've built a version using Excel 2013 and it works on the 2010 version and is the *.xlsx file. If you are using an older version of Excel you will want to use the *.xls file.

FW weight analysis.zip
__________________

__________________
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 04-19-2014, 08:24 AM   #2
Senior Member
 
Join Date: May 2013
Posts: 355
Very cool. Thanks for sharing!
__________________

__________________
2014 Ram 3500 SRW CTD
gtsum2 is online now   Reply With Quote
Old 04-19-2014, 11:43 AM   #3
Senior Member
 
Join Date: Aug 2011
Location: Missouri City, The Republic of Texas
Posts: 3,007
Hope it's of some use
__________________
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
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 01:04 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.