
	Already a member? Login here. If not, Register Today! \| Help

Newest | Active | Popular | RVing FAQ

Forum Rules | Forum Posting Help and Support | Contact

Open Roads Forum > Truck Campers

This Topic Is Closed | Print Topic | Post New Topic |

Sponsored By:

kohldad

Goose Creek, SC

Senior Member

Joined: 07/20/2004

View Profile

Good Sam RV Club Member

Offline

Posted: 03/19/10 03:47pm

Link | Print | Notify Moderator

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

2015 Ram 3500 4x4 Crew Cab SRW 6.4 Hemi LB 3.73 (12.4 hand calc avg mpg after 92,000 miles with camper)
2004 Lance 815 (prev: 2004 FW 35'; 1994 TT 30'; Tents)

pcryer

Texas

Full Member

Joined: 05/16/2006

View Profile

Good Sam RV Club Member

Offline

Posted: 03/19/10 10:49pm

Link | Print | Notify Moderator

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
2006 Coachmen Freelander 2600 (Class C)
2013 19' Xcursion Pontoon w/Yamaha 70 4-stroke

Blueboat

Arizona, Mesa

Senior Member

Joined: 07/22/2008

View Profile

Posted: 03/20/10 12:07am

Link | Print | Notify Moderator

Very cool, wish I could do stuff like that.

Mike

2009 Dodge Cummins 3500 LB 4X4 SRW
2010 811 Arctic Fox.

~DJ~

Boise, Idaho

Senior Member

Joined: 05/10/2005

View Profile

Good Sam RV Club Member

Posted: 03/20/10 03:59am

Link | Print | Notify Moderator

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!! [emoticon]

'17 Class C 22' Conquest on Ford E 450 with V 10. 4000 Onan, Quad 6 volt AGMs, 515 watts solar.
'12 Northstar Liberty on a '16 Super Duty 6.2. Twin 6 volt AGMs with 300 watts solar.

kohldad

Goose Creek, SC

Senior Member

Joined: 07/20/2004

View Profile

Good Sam RV Club Member

Offline

Posted: 03/20/10 07:45am

Link | Print | Notify Moderator

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

Posted: 03/20/10 08:01am

Link | Print | Notify Moderator

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

Posted: 03/20/10 08:51am

Link | Print | Notify Moderator

Brad, can you put a copy in TCU?

drhutch

Centennial, CO

Senior Member

Joined: 04/19/2005

View Profile

Offline

Posted: 03/20/10 09:27am

Link | Print | Notify Moderator

Is somebody sitting inside with too much time on their hands waiting for the weather to warm so they can go camping?? [emoticon]

Looks good, I will have to play with that a bit.
Hutch

2016 Chevy 3500 CC Dually Dmax/Allison / Lance 980 11'3" camper / 30' Rockwood 5er
16' Sylvan fishing boat / 25' Sea OX Walk around big water fishing boat
NRA Life Member
US Army RVN 68-70
The summer of 69 was NOT the best years of my life.
RVing since 1976

kohldad

Goose Creek, SC

Senior Member

Joined: 07/20/2004

View Profile

Good Sam RV Club Member

Offline

Posted: 03/22/10 06:47am

Link | Print | Notify Moderator

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?