Reply
 
Thread Tools Search this Thread Display Modes
 
Old 05-05-2016, 06:30 PM   #1
2 Rivet Member
 
clamb's Avatar
 
2002 25' Classic
Portland , Oregon
Join Date: Jul 2012
Posts: 79
Images: 15
Looking for a few to try out a WDH spreadsheet

Hi all,
Some of you are familiar with my spreadsheet project which I introduced in another thread.... http://www.airforums.com/forums/f464...nt-149347.html

Another member, dznf0g, has been working with me to develop this, and he has expanded it to include calculations for a Hensley hitch. My own version is intended for a simple WDH, typically with coupling at the ball and 2 spring bars.

My reason for doing this is that, being a good distance from the nearest scale (which is not CAT), I would like to have a good estimation of my axle weights and eliminate the need to go to the scale.

In my preliminary work with this, I am getting good results that are within 100 lbs on each axle, and I feel the main reason I am not getting closer results is because I am not using a certified CAT scale.

This spreadsheet can be used to arrive at the force being applied by your bars.

So, I am looking for someone who has accurate axle and tongue scale weights, both empty and loaded, or can get them easily, and who might also be fluent in Excel spreadsheets.

You will need to take accurate measurements and weights of payload items and locations. A degree from the Columbia School of Weights and Measures is desirable!

Please let me know if you would like to try it out. I want to limit this to maybe 5 so I don't get overloaded, and we'll go from there.

Please no responses telling me it is useless- I've already gotten those!
__________________

__________________
clamb is offline   Reply With Quote
Old 05-06-2016, 07:51 AM   #2
Rivet Master
 
dznf0g's Avatar

 
2007 30' Classic
Oswego , Illinois
Join Date: Jul 2010
Posts: 9,401
Images: 5
Quote:
Originally Posted by ROBERT CROSS View Post
Another member went that route awhile back..../Users/brkcro/Library/Containers/com.apple.mail/Data/Library/Mail Downloads/E6F1CEE0-A1F2-41B3-A4D0-A5325B67F94A/Towing weight calculator.xls
Link doesn't work. I'd like to see it, can you double check?
__________________

__________________
-Rich-

"If the women don't find you handsome, they should at least find you handy." - Red Green
dznf0g is offline   Reply With Quote
Old 05-06-2016, 08:25 AM   #3
CLOUDSPLITTER "Tahawas"
 
ROBERT CROSS's Avatar

 
2003 25' Classic
Zanadude Nebula , WNY
Join Date: Jun 2007
Posts: 11,153
Images: 1
Try this....it went to my downloads and I could open it there....way beyond me, I would prefer a ruler ..sorry



Bob
Attached Files
File Type: xls Towing weight calculator.xls (31.0 KB, 135 views)
__________________
PFC.....

“After all these years the reason I continue to love Thanksgiving.....I still sit at the kids table.”
RLC

Sandra wanted to go to Cleveland on vacation,
but I’m the Husband, so we went to Cleveland.
RLC
ROBERT CROSS is offline   Reply With Quote
Old 05-06-2016, 09:18 AM   #4
2 Rivet Member
 
clamb's Avatar
 
2002 25' Classic
Portland , Oregon
Join Date: Jul 2012
Posts: 79
Images: 15
Bob, thanks and I did try it out. That sheet is fine for weighing a fully loaded rig and comparing to weight ratings, but mine (and Rich's) is used to predict those weights before leaving home. It uses distances such as TV wheelbase, RA to ball, ball to TT axle, and entry of payload items such as 45 lbs of food in fridge at 138 inches from ball. The payload locations are all measured once, and weights are edited when the rig is loaded.
__________________
clamb is offline   Reply With Quote
Old 05-06-2016, 09:51 AM   #5
Rivet Master
 
A W Warn's Avatar
 
2000 25' Safari
1999 34' Excella
Davidson County, NC , Highlands County, FL
Join Date: Aug 2006
Posts: 2,568
Quote:
Originally Posted by ROBERT CROSS View Post
Try this....it went to my downloads and I could open it there....way beyond me, I would prefer a ruler ..sorry

Bob
Glad to see someone is remembering my spread sheet.
I dropped that subject when there seemed to be no interest.
__________________
A W Warn is offline   Reply With Quote
Old 05-06-2016, 09:57 AM   #6
Rivet Master
 
dznf0g's Avatar

 
2007 30' Classic
Oswego , Illinois
Join Date: Jul 2010
Posts: 9,401
Images: 5
I cross checked it with clambs sheet and some of the calculations agree either exactly or very close. I do question the TW as it relates to PPP hitching and some apparent assumptions made by the author. I'll have to study it some more.

As Clamb says, the sheet he is working on allows for those of us (particularly) who have drastically differing loads on different trips to predict load scenarios pretty accurately. For example, In addition to my usual loads, I only sometimes take along: Generators, portable solar, SIB inflatable boat, 10 hp outboard, boat gear, tank for gennie and boat, 125cc scooter....among other things...and in differing combinations, depending on trip.

The temptation is to throw everything in the bed or back seat area. While developing the sheet, it was quite an eye-opener as to where things need to be and how they affect various loads in varying combinations, including varying the black, gray, and fresh loads...predicting a regular amount of travel days.
__________________
-Rich-

"If the women don't find you handsome, they should at least find you handy." - Red Green
dznf0g is offline   Reply With Quote
Old 05-06-2016, 10:01 AM   #7
Rivet Master
 
A W Warn's Avatar
 
2000 25' Safari
1999 34' Excella
Davidson County, NC , Highlands County, FL
Join Date: Aug 2006
Posts: 2,568
Quote:
Originally Posted by clamb View Post
....snip....

So, I am looking for someone who has accurate axle and tongue scale weights, both empty and loaded, or can get them easily, and who might also be fluent in Excel spreadsheets.

You will need to take accurate measurements and weights of payload items and locations. A degree from the Columbia School of Weights and Measures is desirable!

Please let me know if you would like to try it out. I want to limit this to maybe 5 so I don't get overloaded, and we'll go from there.

Please no responses telling me it is useless- I've already gotten those!
I'll be happy to try!
I'm fairly proficient in Excel (but a little rusty after 6 years of retirement), but no degree from CSWM
I have Cat scale results for my vehicles. I do not have individual axle weights for the trailer.

ps: I'm going on a short trip next week so I could stop by the scales and weigh again if needed.
__________________
A W Warn is offline   Reply With Quote
Old 05-06-2016, 10:11 AM   #8
Rivet Master
 
dznf0g's Avatar

 
2007 30' Classic
Oswego , Illinois
Join Date: Jul 2010
Posts: 9,401
Images: 5
Quote:
Originally Posted by A W Warn View Post
I'll be happy to try!
I'm fairly proficient in Excel (but a little rusty after 6 years of retirement), but no degree from CSWM
I have Cat scale results for my vehicles. I do not have individual axle weights for the trailer.
Yeah, we haven't delved into individual wheel or axle weights of tandems. If I had access to some individual scales, I'd be willing to add that, but there's a whole 'nuther level of complexity to the calculations.
__________________
-Rich-

"If the women don't find you handsome, they should at least find you handy." - Red Green
dznf0g is offline   Reply With Quote
Old 05-06-2016, 10:12 AM   #9
2 Rivet Member
 
clamb's Avatar
 
2002 25' Classic
Portland , Oregon
Join Date: Jul 2012
Posts: 79
Images: 15
I'm going to go ahead and post the spreadsheet here- anyone is welcome to try it out. Any weights and measures shown are my own- any yellow colored cell can be edited. Note that this is pretty much unloaded- just me, the propane tanks and 50 lbs in the truck bed are listed as cargo.

The idea is to weigh everything as close to empty as possible first. OR weigh with anything that would always be present and not enter that as cargo.

THEN, as you load the TV and trailer, record the weights and measurements and weigh again and compare results. Scale accuracy is critical!

Moderator Note - V4 spreadsheet removed - please see new spreadsheet at post #48
__________________
clamb is offline   Reply With Quote
Old 05-06-2016, 10:24 AM   #10
2 Rivet Member
 
clamb's Avatar
 
2002 25' Classic
Portland , Oregon
Join Date: Jul 2012
Posts: 79
Images: 15
For starters, if you just want to play around with it, try using it as is and add payload here and there and see what changes.
__________________
clamb is offline   Reply With Quote
Old 05-06-2016, 11:23 AM   #11
CLOUDSPLITTER "Tahawas"
 
ROBERT CROSS's Avatar

 
2003 25' Classic
Zanadude Nebula , WNY
Join Date: Jun 2007
Posts: 11,153
Images: 1
Thumbs up

Hey...that's great guys, glad to see the interest.
Hope 'ya get a workable sheet.
Don't let the poo-poo's discourage the operation, who knows maybe even my thick noggin will understand, my problem is figuring out what to forget to make room for what I need to remember.......


Bob
__________________
PFC.....

“After all these years the reason I continue to love Thanksgiving.....I still sit at the kids table.”
RLC

Sandra wanted to go to Cleveland on vacation,
but I’m the Husband, so we went to Cleveland.
RLC
ROBERT CROSS is offline   Reply With Quote
Old 05-06-2016, 04:02 PM   #12
Rivet Master
 
A W Warn's Avatar
 
2000 25' Safari
1999 34' Excella
Davidson County, NC , Highlands County, FL
Join Date: Aug 2006
Posts: 2,568
I've taken a few minutes to look over the spreadsheet, cell formulas, etc...
My first questions: How do you arrive at the number for "location" on the first two sheets? Is it a measurement from some point (in inches)?

Once I get the answer, I think I can fairly quickly fill in the blanks. I have already weighed and made a list of most of the cargo item that are inside both my tow vehicle and trailer. My wife even tells people I weighed her and added her to the list. (and that's true )
__________________
A W Warn is offline   Reply With Quote
Old 05-06-2016, 04:40 PM   #13
Rivet Master
 
dznf0g's Avatar

 
2007 30' Classic
Oswego , Illinois
Join Date: Jul 2010
Posts: 9,401
Images: 5
On the truck sheet 0" is at the front hub and numbers increase working backward on your particular TV.

On the trailer sheet the ball coupler is 0" and the numbers increase as you move rearward on your particular trailer.

These numbers are CRITICAL for accuracy. Eyeballing it don't work, as rounding errors, one on top of another multiply quickly.

I used a line drawing of my AS frame which I got from AS a couple years ago; and line drawings for my truck from the upfitter manual online. That was after using a tape and eyeballs. I was off by .5" here and there and it made a significant difference in the end.
__________________
-Rich-

"If the women don't find you handsome, they should at least find you handy." - Red Green
dznf0g is offline   Reply With Quote
Old 05-06-2016, 05:55 PM   #14
Rivet Master
 
A W Warn's Avatar
 
2000 25' Safari
1999 34' Excella
Davidson County, NC , Highlands County, FL
Join Date: Aug 2006
Posts: 2,568
I'm withdrawing my offer to participate. For me, that is too much measuring to get exact weight placement of every item added to the vehicles so that the results will be accurate. I'm not willing to take the time to do it.
I live 10-15 minutes from a CatScale, so actual weighing will be my method.


ps:
I now understand what you were speaking of, in other threads and posts, about the difficulty of placing COG of items in vehicles in a linear dimension.
For example: the driver's center of gravity would be difficult to accurately place at a specific "Location" dimension from the spindle center line. The bulk of that person's weight would be on the seat, but a large portion (legs and arms) would be forward of the body, moving the COG forward of the body. It would be impossible to place accurately and would vary with any seat adjustment and driver movement. In the case of two or three people in front, it's more complex and more variable.
__________________

__________________
A W Warn is offline   Reply With Quote
Reply


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
Rental Inquiry - Try Out Airstream asugerma Our Community 12 04-13-2016 11:08 PM
Vintage Trailer Prices Spreadsheet kmel Trailer Values 0 02-26-2016 04:21 PM
Phoenix, AZ - Looking for reputable business to purchase and install WDH AZBG Hitches, Couplers & Balls 12 07-28-2015 10:50 AM
2015 Spreadsheet Model/Length/Price Tomy Trailer Values 14 01-04-2015 07:51 PM
Try this out - oven cleaner vs clearcoat! jpeters Cleaning, Stripping & Polishing 4 01-11-2007 12:22 PM


Virginia Campgrounds

Reviews provided by




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -6. The time now is 01:28 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

Airstream is a registered trademark of Airstream Inc. All rights reserved. Airstream trademark used under license to Social Knowledge LLC.