Van weight calculator/assessment

oldbloke · Guru

Van weight calculator/assessment

yobarr · Guru

oldbloke wrote:
Sooo, I'm not sure where I got this from but its little xls sheet to work out if your over weight or not.
I just tapped in all of my latest weights and it did confirm that I'm a little over if I fill all my water tanks, gas food clothes etc. (fully loaded) So Il just keep doing what I'm doing and travel with water tanks about 50% full. Ensuring I'm just under my max. And keep working on reducing weight where I can, which I think will be forever.
Just complete pg 1 and the results are on pg 2. Page one also describes how to weigh everything.
Yellow cells are for "ratings". Green "actual" weights.
I just hope this helps someone as it can be a bit of a head spin when you first try to understand all this stuff.
Good luck. U will need it. LOL

Is this the table created by Kevin J? Tonight I am putting a few beers where the flies can't get at them,but tomorrow I will study the formulae etc. Has there been any allowance made for varying TBOs? Enough for now.Cheers

KevinJ · Senior Member

yobarr wrote:
oldbloke wrote:
Sooo, I'm not sure where I got this from but its little xls sheet to work out if your over weight or not.
I just tapped in all of my latest weights and it did confirm that I'm a little over if I fill all my water tanks, gas food clothes etc. (fully loaded) So Il just keep doing what I'm doing and travel with water tanks about 50% full. Ensuring I'm just under my max. And keep working on reducing weight where I can, which I think will be forever.
Just complete pg 1 and the results are on pg 2. Page one also describes how to weigh everything.
Yellow cells are for "ratings". Green "actual" weights.
I just hope this helps someone as it can be a bit of a head spin when you first try to understand all this stuff.
Good luck. U will need it. LOL
Is this the table created by Kevin J? Tonight I am putting a few beers where the flies can't get at them,but tomorrow I will study the formulae etc. Has there been any allowance made for varying TBOs? Enough for now.Cheers

No, the one attached is the one I created. It uses VBA and there is over 800 lines of code, not just X/L formulas as it gives more power and control with Excel. As an aside, if anyone wants to know what they can do with VBA, let me know as I would be more than happy to explain it. You will be surprised how easy it is to grasp.

Ray Saunders · Member

Hi

Just had a look at your spreadsheet re weights etc. I can understand what it is all about.

I will use this when I get my new caravan in March 2022.

Ray

Ricey88 · Newbie

Hi KevinJ

Awesome load calculator, I appreciate the amount of work that you must have put into building it. Is there any chance i could get a copy that i can load my TowTug and Van into. As soon as i change anything in the tow tab the load calculator sheet just shows #Name?

Thanks