Quote:
Originally Posted by zuley
I would love to see someone create a template of sorts and list it with a sticky that we could print off and use as required. The template would show fill in the blank formulas for calculating capacities along with all terminology and an explanation of each.
Is there any interest in this and is there anyone willing to take on this task?
|
Send me a Private Message on the board, I'm happy to share the spreadsheet I've built. If you are comfortable with spreadsheets and adjusting the math in the cells as you add more data, you might find it helpful.
I have an initial row with weights of the TV, wife and I, full tank of fuel, toolbox etc as we normally travel. Subsequent rows have been added each time I get weights of the TV and trailer. Steer axle, drive axle and trailer weights can be added and a number of additional cells automatically calculate to show various percentages of the GAWR / GVWRs of TV and trailer, along with calculated pin weights, pin weight % of trailer weight, % of max tire and axle weights, on and on. Conditional formatting will show some cells in green where I'm good and in red if you go over the GAWR/GVWR.
When I insert a new row for the latest weight, it takes a bit of work to redirect some of the cells and calculations. Someone who is more an EXCEL wizard than me, might be able to re-program a few of the cells to make it a bit more user friendly.
PM me and I'm happy to forward it on!