5.75 in Drop, 2 washers, bracket 1 hole up
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
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!
2
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:
3
https://campaddict.com/weight-distribution-hitch/
4
Note 1:
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)
5
User entries are outlined and colored in a light, bright blue
Required entries have an * before the description
6
Note 2:
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'.
7
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
8
Note 3:
Some cells will change color to indicate specification compliance:
<90% of spec90-99% of spec
>=100% of spec
9
10
Figuring out tongue weight and how well your weight distribution hitch is distributing weight
11
You will need to take three weights:
12
Take these weights with your trailer loaded as you normally use it (water, food, personal items, propane, etc).
13
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)
14
1. Weight of trailer axle(s) and tow vehicle axles with weight distribution hooked up
15
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.
16
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.
17
You will be entering weights into the cells that are boxed in. Bolded figures are calculated for you by the spreadsheet.
18
19
DateConfiguration (w/ passengers & cargo)Grand Cherokee Front Axle (Max 3200)Grand Cherokee Rear Axle
(Max 3700)
Grand Cherokee Total (GVWR 6800)Bambi Trailer Axle (Max 3500)Tongue Weight
(Max 720)
Bambi Trailer Total (Max 3500)Grand Cherokee GCWR (Max 10300)
20
9/20/2019
WDH hooked up
316031406,30032209,520
21
9/20/2019WDH unhooked262039406,56029405803,5209,500
22
9/20/2019TV only290030805,980
23
98.75%84.86%92.65%92.00%92.43%
(This and next two rows showed computed percentages of measured values / spec values)
24
81.88%106.49%96.47%84.00%80.56%100.57%92.23%
25
90.63%83.24%87.94%
26
27
Tow Vehicle (TV) Ratings
28
Year:2014Manufacturer:JeepModel:
Grand Cherokee
29
* TV Max Towing:7,200lbs
30
* TV Max Tongue:720lbs
31
CCC: Max Pass & Cargo:
1,525
lbs (computed)
(computed: GVWR - TV Curb Weight)
32
* GVWR: Gross Vehicle Weight Rating:
6,800lbs
(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)
33
* GCWR: Gross Combined Weight Rating:
10,300lbs
(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)
34
* FGAWR (Front Axle Rating):
3,200lbs
35
* RGAWR (Rear Axle Rating):
3,700lbs
36
TV Curb Weight:5,275lbs
(Unloaded TV weight, usually as declared by manufacturer in sales literature)
37
38
Trailer Ratings
39
Year:2016Manufacturer:AirstreamModel:Bambi
40
GVWR: Gross Vehicle Weight Rating
3,500
lbs (computed)
* Trailer GVWR Manufacturer Spec:
3500lbs
C40: May be limited by sum of trailer/TV max tongue and trailer GAWR
41
* GAWR (Axle Rating)3,500lbs
42
Max tongue (computed):
720
lbs (computed)
Trailer Manufacturer Tongue Weight Spec:
0lbs
C42: Value will be minimum of TV and Trailer (if known) max tongue weights
43
Dry Weight:2,960lbs
(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.)
44
CCC (Cargo Carrying Capacity):
540
lbs (computed)
(computed: GVWR - Dry Weight)
45
46
47
10,300GCWR
48
10,300GCWR
49
3,540Trailer Weighthooked up
50
3,520Trailer Weightunhooked
51
3,800Trailer weight
unhooked tongue weight + hooked up trailer axle weight
52
9,520Total TV + Trailerhooked up
53
9,500Total TV + Trailerunhooked
54
580Tongue Weightunhooked
55
320Tongue Weighthooked up
56
16.48Tongue Weight%unhooked
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...