Trailer Weight Calculations & Load Estimator Utility
Hi all, I've lurked on here for a while and have just now got around to creating an account.
I tow a number of different trailers regularly and I'm in the process of shopping for a new TT. As a result I've been researching & measuring all the specific manufacture ratings and real word scale weights surrounding my TV in order to help me identify trailer loads I can realistically support without being overloaded. To help in that process I built the following utility and wanted to share it with the rest of the towing community.
Weight Calculation utility:
Input your CAT or other truck scale measurement data and the utility will perform a number of meaningful weight calculations. This information is useful in measuring the "real" weights of your tow vehicle and trailer against the maximum limits of both vehicles. The tool will identify if you are over the manufactured specifications in any area and bring this to your attention.
Load Estimator utility:
Allows you to input information about a given trailer and estimate the amount of load required from the tow vehicle to support the trailer weight. Loads are projected in Tow Rating and Payload figures. Useful for trailer shopping to quickly determine if a prospective trailer fits your tow vehicle capabilities.
The tool is based in Microsoft Excel, but no need for any software on your computer as you can access the utility online via Microsoft Skydrive. You can input your data online and even download a copy for offline use (assuming you have Excel installed locally).
Here are a few screen shots of the utility in action:
Access the Trailer Weight Calculations & Load Estimator Utility here:
https://skydrive.live.com/embed?cid=A7EE35AF86FE78FE&resid=A7EE35AF86FE78FE%21142&authkey=ALI_KLtWUH8AJ1A&em=2&wdAllowInteractivity=False&AllowTyping=True&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True
EDIT: updated to version 4.0 to include corrections from comments originating in this thread.
PS: please contact me with any uncovered bugs or issues.
I tow a number of different trailers regularly and I'm in the process of shopping for a new TT. As a result I've been researching & measuring all the specific manufacture ratings and real word scale weights surrounding my TV in order to help me identify trailer loads I can realistically support without being overloaded. To help in that process I built the following utility and wanted to share it with the rest of the towing community.
Weight Calculation utility:
Input your CAT or other truck scale measurement data and the utility will perform a number of meaningful weight calculations. This information is useful in measuring the "real" weights of your tow vehicle and trailer against the maximum limits of both vehicles. The tool will identify if you are over the manufactured specifications in any area and bring this to your attention.
Load Estimator utility:
Allows you to input information about a given trailer and estimate the amount of load required from the tow vehicle to support the trailer weight. Loads are projected in Tow Rating and Payload figures. Useful for trailer shopping to quickly determine if a prospective trailer fits your tow vehicle capabilities.
The tool is based in Microsoft Excel, but no need for any software on your computer as you can access the utility online via Microsoft Skydrive. You can input your data online and even download a copy for offline use (assuming you have Excel installed locally).
Here are a few screen shots of the utility in action:
Access the Trailer Weight Calculations & Load Estimator Utility here:
https://skydrive.live.com/embed?cid=A7EE35AF86FE78FE&resid=A7EE35AF86FE78FE%21142&authkey=ALI_KLtWUH8AJ1A&em=2&wdAllowInteractivity=False&AllowTyping=True&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True
EDIT: updated to version 4.0 to include corrections from comments originating in this thread.
PS: please contact me with any uncovered bugs or issues.
