kohldad
Goose Creek, SC
Senior Member
Joined: 07/20/2004
View Profile
 Offline
|
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.
Basic sheet is locked at Version 3: weight-v3.xls
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
Photo Albums (TN Whirlwind pics uploaded 8/18/10)
My Weight Calculator Spreadsheet
2004.5 Ram 3500 4x4 Quad-Cab SRW CTD 6-spd
2004 Lance 815 (an upgrade from my prev 2005 35' fiver  )
DW, 2 DDs, 1 DE (neigh), 2 DFs (meow)
|
pcryer
Texas
Full Member
Joined: 05/16/2006
View Profile
Offline
|
I like this and you obviously put a lot of work into it. Looking forward to measuring the truck and playing with this spreadsheet.
Thanks!
2006 Ford F250 Super Duty, Ext. Cab, Diesel, 2WD, shortbed
Air Bags, Stock 17" E Rated Tires
2003 Lance 815 Ext. Cab with a/c
2002 22' Bennington Triple Toon w/Mercury 150 2-stroke
|
Blueboat
Arizona, Mesa
Full Member
Joined: 07/22/2008
View Profile
|
Very cool, wish I could do stuff like that.
Mike
2009 Dodge Cummins 3500 LB 4X4 SRW
2010 811 Arctic Fox on order.
|
~DJ~
Boise, Idaho
Senior Member
Joined: 05/10/2005
View Profile
Good Sam RV Club Member
|
That is really something!!! A case of beer overloads my new pop up/grocery getter so I have to settle for Jack!!!
It sure looks like fun to play around with though!! 
2010 F150 Super Cab XLT 5.4 4X4 Short Box
2010 18' Springdale Rugged Terrain
1988 Nortstar 8' pop up TC
Honda 2000
26th Marines RVN 69-70 Semper Fi
M-14 was the only Woodstock I saw in 1969.
|
kohldad
Goose Creek, SC
Senior Member
Joined: 07/20/2004
View Profile
Offline
|
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".
|
|
|
Wasatch Lance
Park City, Utah
Senior Member
Joined: 02/11/2005
View Profile
Offline
|
Great Job!
That should be a very handy tool.
Thank you for taking the time to create it and share it on the forum!
2002 F-350 CC 4X4 PSD, Stage II Injectors, Garrett BB Turbo, AFE Air Cleaner, Chip, 4" Exhaust, Gauges, Extra Leaf Springs, Air Lift Bags, Hellwig Sway Bars, Rancho RS9000XL shocks, American Racing Wheels, Toyo M/T Tires (4,300 lb rating),
2003 Lance 1121
|
~DJ~
Boise, Idaho
Senior Member
Joined: 05/10/2005
View Profile
Good Sam RV Club Member
|
Brad, can you put a copy in TCU?
|
drhutch
Centennial, CO
Full Member
Joined: 04/19/2005
View Profile
Offline
|
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
2003 Chevy 3500 EC Dually Dmax/Allison / Lance 980 11'3" camper
|
kohldad
Goose Creek, SC
Senior Member
Joined: 07/20/2004
View Profile
Offline
|
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.
Any other features wanted?
|
silversand
Montreal
Senior Member
Joined: 09/12/2004
View Profile
|
Beautiful! Nice and generic; useful for everyone.
Additionally, thanks for using the ROUND function
Cheers,
Silver-
Silver
2004 Chevy Silverado 2500HD 4x4 6.0L Ext/LB Tow Package 4L80E Michelin AT2s| Outfitter Caribou
|
|
|
