BIG thanks to Jim who took the original version of this spreadsheet and made it MUCH more useful by doing stuff way above our skill level. Thanks Jim!
This spreadsheet is derived from the Weight Distribution Hitch page of Camp Addict, where you can find pictures and a video showing how to properly position your rig on a scale:
Verify all data has been entered correctly in the vehicle section (showing the tow vehicle's max GAWR front and rear, tongue, GVWR, GCVWR, etc. as well as trailer GAWR and GVWR)
User entries are outlined and colored in a light, bright blue
Required entries have an * before the description
Each axle will need to be weighed individually. You will weigh the trailer axle(s) on one 'pad' of the commercial scale, the rear axle of the tow vehicle on another 'pad', and the front axle on a third 'pad'.
You will then enter the 3 different axle weights into the appropriate spot in the spreedsheet (heavy outlined boxes) to let it do it's calculations
Some cells will change color to indicate specification compliance:
|<90% of spec||90-99% of spec|
>=100% of spec
Figuring out tongue weight and how well your weight distribution hitch is distributing weight
You will need to take three weights:
Take these weights with your trailer loaded as you normally use it (water, food, personal items, propane, etc).
Take these weights with your tow vehicle loaded as you normally have it when towing, INCLUDING the number of people usually in while towing (driver and any passengers)
1. Weight of trailer axle(s) and tow vehicle axles with weight distribution hooked up
2. Without moving your trailer off the scale, simply detach the weight distribution spring arms (or weight distribution mechanism) so that no weight is being distributed and take the weight of the trailer axle(s) and tow vehicle axles.
3. Move trailer and tow vehicle off the scale and detach trailer. Weigh the tow vehicle by itself, making sure you are getting separate weights of the front and rear axles.
You will be entering weights into the cells that are boxed in. Bolded figures are calculated for you by the spreadsheet.
|Date||Configuration (w/ passengers & cargo)||Grand Cherokee Front Axle (Max 3200)||Grand Cherokee Rear Axle |
|Grand Cherokee Total (GVWR 6800)||Bambi Trailer Axle (Max 3500)||Tongue Weight |
|Bambi Trailer Total (Max 3500)||Grand Cherokee GCWR (Max 10300)|
WDH hooked up
(This and next two rows showed computed percentages of measured values / spec values)
Tow Vehicle (TV) Ratings
|* TV Max Towing:||7,200||lbs|
|* TV Max Tongue:||720||lbs|
CCC: Max Pass & Cargo:
(computed: GVWR - TV Curb Weight)
* GVWR: Gross Vehicle Weight Rating:
(This is the maximum weight that the can be supported by the TV's axles, frame, brakes, etc., etc. Includes cargo and occupants, as well as the tongue weight of the trailer that is distributed to the TV's front and rear axles)
* GCWR: Gross Combined Weight Rating:
(This is the maximum allowable weight of the loaded TV as well as the weight of the attached trailer, so the combined weight of the two)
* FGAWR (Front Axle Rating):
* RGAWR (Rear Axle Rating):
|TV Curb Weight:||5,275||lbs|
(Unloaded TV weight, usually as declared by manufacturer in sales literature)
GVWR: Gross Vehicle Weight Rating
* Trailer GVWR Manufacturer Spec:
C40: May be limited by sum of trailer/TV max tongue and trailer GAWR
|* GAWR (Axle Rating)||3,500||lbs|
Max tongue (computed):
Trailer Manufacturer Tongue Weight Spec:
C42: Value will be minimum of TV and Trailer (if known) max tongue weights
(Weight before you add any cargo or fill the fresh water tanks - number is usually found on placard on/near door or on side of trailer.)
CCC (Cargo Carrying Capacity):
(computed: GVWR - Dry Weight)