ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Please download this spreadsheet to your own computer or Google Drive - you may not edit the original
2
3
Enter Information in Shaded Cells Only
4
5
Tow Vehicle (TV)Trailer
6
7
TV Curb WeightUVWDry TW %#DIV/0!
8
TV GVWR (Gross Vehicle Weight Rating)CCCGVWR TW
9
TV GCVWR (Gross Combine Vehicle Weight Rating)GVWR (CCC + UVW) 0 12% 0 *
10
TV PayloadDry Hitch Weight (TW)17% 0 **
11
TV Towing (pulling) Capacity
12
PassengersWeight
13
Estimated TV Vehicle Payload Including Hitch WeightDriver
14
Passengers (Pulls from I12:14) 0 Passenger(s)
15
TV Cargo (Pulls from I18:25) 0 Furry Companion(s)
16
Trailer Cargo (Pulls from I29:36 or I7); Lessor of I29:36 or I7 0 0
17
Hitch Weight (enter either cell L8 or L9); see* or ** to decide; Generally, Avg L8 & L9
18
Total TV Payload 0 TV CargoWeight
19
Hitch Weight Itself
20
Available TV Capacities once TV is Hitched to Trailer% availableWood
21
Available TV Payload#DIV/0!Supplies
22
Available TV GVWR (Gross Vehicle Weight Rating)#DIV/0!Bike(s)
23
Available GCVWR (Gross Combine Vehicle Weight Rating)#DIV/0!Kayak
24
Available TV Towing Capacity#DIV/0!Generator
25
Tools
26
GAWR Curb WeightAvailable Axle Capacityit adds up quickly
27
Front Axle 0 0 0
28
Rear Axle 0 0
29
 0 Trailer CargoWeight
30
Gold - spending money
31
* 12% Loaded Trailer Tongue Weight is the minimum TW a high profile trailer should have to track well. Under 12% is typically considered unloaded and an unloaded Tongue is the main cause of sway.Clothes & Per. Items
32
Bike(s)
33
Furniture
34
* 17% Loaded Trailer Tongue Weight would occurr with propane, two lead acid house batteries on tongue, holding tanks full as well as loaded and heavy items in the front storage areas.Dishware
35
Tools
36
Hoses/Cords
37
Disclaimer: It is your responsibility to check all formulas, numbers and data for accurate information.
Camp Supplies
38
Check all load capacities, including your tires. 0
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
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