At the nudge of an fellow TCer, I finally got around to working on and almost completing my weight spreadsheet. The sheet allows you to enter the weight of numerous items along with the dimensions specific to your rig and will calculate the effect on each axle along with the total weight.
This is the first draft and would appreciate comments on features you would like added and if there are any mistakes. The data you see in the sheet is from my rig when towing a jeep.
Enhanced sheet is Version 6: weight-v6-100323.xls
As data is entered into table, the last 6 digits will change which is the date stamp in yymmdd format.
* This post was
last
edited 03/23/10 07:34pm by kohldad *
View edit history
Just finished a 12-day trip gathering photos for next report.Photo Albums
2004.5 Ram 3500 4x4 Quad-Cab SRW CTD 6-spd
2004 Lance 815 (an upgrade from my prev 2005 35' fiver )
DW (homemaker), 1 DD @ Clemson in Civil Eng, 1 DD @ Tech in Acct, 2 DFs (meow)
Made a few improvements to the sheet and updated the link in the top post.
Updates:
1. Cleaned up the drawing and made the letters easier to read.
2. Added an entry for trailer weight so it will give you the GCW.
3. Reoriented the calculations table for easier interpretation.
4. Added an area where camper cargo can be broken down into individual items located throughout the camper.
5. Reverified all calculations and they seem correct (jinxed me).
Still have one more feature I want to add and hope to get to it tonight.
A few quick helpful hints:
1. Press "tab" key to move between fields you can change
2. Only required field is "A".
Is somebody sitting inside with too much time on their hands waiting for the weather to warm so they can go camping??
Looks good, I will have to play with that a bit.
Hutch
Quote: Is somebody sitting inside with too much time on their hands waiting for the weather to warm so they can go camping??
Nope, been camping three times already this year. Just haven't been to anything exciting enough to write a trip report about.
Still working on Ver3. Discovered today that I need to add a "slide" entry in case you want to slide the camper rearward in the bed. Discovered this when thinking about moving my TC rearward 18" and putting the short bed skirts back on.
)
Offline
