Duramax Diesels Forum Truck of the Week
  #1  
Old 04-04-2017, 05:35 PM
2004LB7's Avatar
2004LB7 2004LB7 is offline
Hotrodder
 
Join Date: Dec 2010
Location: Norcal
Posts: 689

Default Trailer Weight Distribution Calculator

I made a "visual" weight distribution calculator in excel.

it doesn't take into account the difference in the trailers own weight throughout the trailer so if anyone has base line percentages that will increase its accuracy.

I made it more for a camping trailer for loading up or building the inside and wanting to see how placing different items such as the shower, toilet, beds, cabinets, etc affected the tongue weight based on where i would place them. but it should work for any trailer really.

Now, it is only set up right now for a 27 foot trailer but i will likely make it scalable for any length trailer with some more formulas in the future.

so, before you yell at me and tell me it is not accurate, I already know that. it was more for rough calculations and a visual aid to seeing how the weight distributed across the trailer changed the load on the tongue and tires

make sure to remove the ".doc" from the end of the file name to make it an excel ".xls" file

Play around with it and let me know what you think
Attached Files
File Type: doc Trailer Weight Distribution Calculator.xls.doc (35.0 KB, 22 views)
__________________
2008 Chevrolet 3500HD DRW LTZ
285/75/17 Nitto Dura Grapplers, 4.56 gears, Front and rear ARB lockers, Efi Live tuning by me, Raptor 160 LP, Cognito 4-6 NTB Lift, 4" Exhaust, Built Trans by Mike L.
Reply With Quote
  #2  
Old 04-05-2017, 10:36 AM
2004LB7's Avatar
2004LB7 2004LB7 is offline
Hotrodder
 
Join Date: Dec 2010
Location: Norcal
Posts: 689

Default

Version 2 with auto adjusting for trailers beds up to 50 feet and dovetail up to 10 feet.

thanks Jason
Attached Files
File Type: doc Trailer Weight Distribution Calculator V2.xls.doc (66.5 KB, 4 views)
__________________
2008 Chevrolet 3500HD DRW LTZ
285/75/17 Nitto Dura Grapplers, 4.56 gears, Front and rear ARB lockers, Efi Live tuning by me, Raptor 160 LP, Cognito 4-6 NTB Lift, 4" Exhaust, Built Trans by Mike L.

Last edited by 2004LB7; 04-05-2017 at 03:10 PM.
Reply With Quote
  #3  
Old 04-10-2017, 11:30 AM
2004LB7's Avatar
2004LB7 2004LB7 is offline
Hotrodder
 
Join Date: Dec 2010
Location: Norcal
Posts: 689

Default

some small tweaks to the formulas so it doesn't calculate weights that didn't get removed if the trailer was shortened. make it less error prone
Attached Files
File Type: doc Trailer Weight Distribution Calculator V2.xls.doc (73.5 KB, 10 views)
__________________
2008 Chevrolet 3500HD DRW LTZ
285/75/17 Nitto Dura Grapplers, 4.56 gears, Front and rear ARB lockers, Efi Live tuning by me, Raptor 160 LP, Cognito 4-6 NTB Lift, 4" Exhaust, Built Trans by Mike L.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 06:23 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
vB.Sponsors