I had fun putting the spreadsheet together, but I need some more eyes and brains to critique the spreadsheet so I can make improvements and find errors I made so I can correct them.
I admire people that do their homework prior to purchase. However, this is a little overkill and I am not sure it is not overly complex as it reflects the tow vehicles rear suspension. For example, a one ton truck needs no weight distribution, only sway and maybe not even that. It has more than enough capacity to handle the tongue weight for any TT. Your vehicle probably needs some weight distribution. Several years go in the
Airstream magazine there was an excellent article on how to determine the spring bar tension needed based not only on tongue weight of the trailer but also the stoutness of the tow vehicle. It was a far simpler analysis than your spreadsheet. Basically the loaded for camping trailer was weighed, the tongue weight determined (hopefully around 12-13 percent) and then determination was made based on tow vehicle stoutness. The more stout the tow vehicle the less spring bar tension needed. But, good that you were doing your due diligence on this.
I am confident most dealers that set up WD hitches never even begin to think about a spread sheet like you did. So, good job for thinking through it all. The conclusion I came to from your analysis was not so much how to load the trailer as it relates to weight around the axle placements (moment arm stuff), but much more that you could use
more tow vehicle to handle the storage areas in the TT filled with stuff; and folks and supplies in the tow vehicle and not overload the suspension and axle. You are tackling this from the position of distributing the TT load to work with the tow vehicle, I would tackle it from the need to get more truck for this trailer. Two separate conclusions from your analysis.
