Part 5 - Trailer Balance Spreadsheet
What happened to Parts 1 to 4? They explain the theory behind this spreadsheet and they were moved elsewhere to stop scaring visitors! If you would like to read them, they’re here.
Below you can download an Excel spreadsheet that will calculate the hitch weight of your trailer design, working from data that you provide.
But please note that the spreadsheet cannot estimate the weight of your trailer - you have to do that for yourself! However it will let you work with just actual dimensions and weights expressed as a percentage of the total trailer weight.
The spreadsheet allows the following weights:
- a main body weight;
- a tongue weight;
- an axle weight (ie, wheels, axle, suspension, etc);
- up to three extra weights for galley weights, etc, which can be at any position.
To make it easier to do initial estimating, the spreadsheet uses a 'basic trailer weight' - this is the total of the body, tongue and axle weights (but does not include any of the extra weights). The tongue and axle weights are input as percentages of the basic trailer weight and, if you don't have any better data,
you can use these default values which are already in the spreadsheet:
- tongue weight = 5% of basic trailer weight;
- axle weight = 12% of basic trailer weight.
These percentages are suggestions - satisfy yourself that they are appropriate before you use them.
You can use from zero to three extra weights. In the diagram above, extra weight 1 is representing weight in the galley, extra weight 2 is representing a tongue box and extra weight 3 is not shown - the possibility to use a third extra weight has been included because if it isn't someone is bound to ask for it! For each one, you need the extra weight in pounds and its distance from the rear of the trailer in inches.
The diagram above shows where the measurements are taken from. If you prefer to use metric units (eg, kg and cm or mm), you can use the spreadsheet just as it is, but you may want to alter the number of decimal places in some cells.
Excel trailer balance spreadsheet (in a Zip file)
To make your own version of this spreadsheet in different software, view and save this .pdf file containing formulae for all calculated cells