I am brand new to caravanning forums and am about to do my lap of the map. I have many done hours of interesting reading over the past few months since I joined the forums but this is my first post about anything at all and I am still learning about this topic in particular.
In order to assist me to ensure that my tow vehicle and caravan stays safe and within all weight limits, I have fallen back on some very rusty and basic spreadsheet skills that I used in my pre-Grey Nomad life, to design a calculator/analyser to do all the brain work and warn me if anything exceeds a limit or specification when I am towing a caravan.
At the risk of venturing where angels fear to tread, I am sharing as an attachment to this post a copy of the spreadsheet that other laymen like me might find useful if they need to check that their tow vehicle and caravan are safe and legal when travelling. However, for it to be of any use, you will need to have access to a device with Microsoft Excel (or compatible) software on it and then just be able to enter a number into a colour coded and labelled box. I have also attached a pdf copy of the calculator with some sample data entries in it in order to deliberately cause a red exceedance message to appear alongside every relevant data box and show the range of information that the model will feedback to a user.
I have not attempted to create a calculator which will estimate tow ball load based on the position of payload in the caravan. Far beyond my competence, so I will leave that to the engineers and I think there is already one mentioned somewhere in one of the countless forums posts I have read. I simply adjust my tow ball load by using a tow ball weight scale and lifting movable payload back and forth in the caravan.
The concept, design and programming of the calculator followed a fair amount of research and a steep learning curve, much of the knowledge being gleaned from the enormous amount of informed, and sometimes it seems not so informed, comment on this and other caravanning forums, e.g. the Grey Nomads. I have password protected the spreadsheet from changes to its design, to hide all formulas and to lock all cells that do not need a number (weight/mass) entered into them. I prefer not to share the password so as to prevent someone fiddling with the programmed, underlying, formulas which will result in spreading inconsistent or even inaccurate models on the subject.
I have taken the liberty (risk?) of including a few notes at the beginning titled Some Towing Terminology in Laymans Terms, but pleeeeease .. is it humanly possible to avoid being overly pedantic on the subject of definitions involving towing weights and masses which has been almost done to death on other posts in this forum? Mans greatest challenge sometimes is to resist the natural temptation to change what are probably someone elses perfectly good words! However, if a learned forum member feels the words used in my calculator are simply wrong or are quite misleading, as opposed to just being different to the way someone else might want to define or explain the meaning, then OK, I do welcome feedback and please comment accordingly. I will take all feedback on board and if necessary put out v2.0 to all.
Ideally, the spreadsheet should be filled in after a weighbridge check but it can be used anytime if you already know or have a fair guesstimateof your actual (i.e. weighed) caravan GTM, weighed ball load and weighed tow vehicle GVM (including full payload for caravan travel). Finally, just a few related thoughts as to why I have put some time into the topic. Caravan towing safety will become an increasingly higher priority for State road authorities as the number of caravan accidents escalates and they are put under pressure to take a more proactive approach to caravan and towing compliance and plating, rather what appears at present to be only occasional random check/blitz approach in some states, inconsistent plating regulations and reactive accident investigations. More regular roadside checking and mandatory education (and perhaps practical training/testing?) seem inevitable if accident trends continue to increase. This of course needs more scarce resources which usually means more money in budgets.
Anyway, I do hope some members find the model helpful and informative. I look forward to feedback and my apologies for the excessive length of my first post which I thought was needed to explain what I have done and why.
Safe towing to all,
PS: Being also a keen reader and a member of the Caravaners Forum, I have also put this post on that forum for the benefit and feedback of our broader caravanning community .
-- Edited by Webmaster on Sunday 18th of August 2019 08:51:04 AM
I did a spreadsheet for everything we put in the car. Frightening how the little things add up. 24kg of things under 1kg not including clothes or food.
Or simply upgrading the tyres, another 6 (2 spares) X 3kg, 18kg we have to reduce elsewhere.
__________________
Procrastination, mankind's greatest labour saving device!
50L custom fuel rack 6x20W 100/20mppt 4x26Ah gel 28L super insulated fridge TPMS 3 ARB compressors heatsink fan cooled 4L tank aftercooler Air/water OCD cleaning 4 stage car acoustic insulation.
One of the most important aspects of van loading that you can not measure on the weighbridge is the yaw inertia.
Yaw inertia is the effort required to start the van turning (spinning) left or right and the energy to stop it from turning once it starts.
High yaw inertia happens when weight is concentrated at the ends of the van rather than over the axles. A van can have high yaw inertia even if the ball weight balance is perfect and the van is not overloaded.
Yawing uncontrollably is what causes vans to snake down the road and then roll over.
Long heavy vans are at greater risk compared to shorter lighter vans.
Bath University in the UK has done some studies on yaw inertia with caravans.
Cheers,
Peter
We only have a car but do try to get the mass in the centre & as low as possible but there is not a lot we can do with the second spare wheel & fuel on the roof.
__________________
Procrastination, mankind's greatest labour saving device!
50L custom fuel rack 6x20W 100/20mppt 4x26Ah gel 28L super insulated fridge TPMS 3 ARB compressors heatsink fan cooled 4L tank aftercooler Air/water OCD cleaning 4 stage car acoustic insulation.
Agree with all of the above. Pity you can't program brains and commonsense towing habits into a spreadsheet!
Programming yaw and roll inertia into a spreadsheet based on load distribution is likely possible, but is a bit out of my non-engineering competence. Hard to program but easy to feel when towing, even with minimal experience (and brains!).
At least the present analyser might assist some people to get a few of the fundamental compliances right before they 'navel gaze' at driving habits and towing experience.
Correct, Peter .... as you may have already seen, the video at the link below, put together following long term joint research by Bath University and Baileys in the UK well illustrates caravan stability and snaking factors, using quite a cool little model. The 4m 26s of a video like this should be compulsory viewing (among other education and testing ) if ever "Licensed to Tow a Caravan" became a motor vehicle driver's licence category.
I know my rig is out of the ordinary but I have one confirmation about yaw inrtia Peter mentioned.
My home made van built very light atm 998kg 16x7ft has a towball load of 85kg. Behind the single axle the 7feet of caravan that end weighs about say 300kg. Yes 7ft of caravan weighs 300kg being full ensuite, wardrobe and half a kitchen, steel tube frame. Make no mistake its built strong.
Recently at low speed in a deserted safe place I tested the rigs stability by trying to initiate sway. It wasnt possible.
Obviously Im not adding speed nor vacuum between passing rigs/trucks but regardless when on a main road it is solid as a rock including during side winds...why?
Low C of G (van has 4" drop axle) floor 400mm from ground, roof height 2300mm. In fact being ultra light and large for its weight, my major concern is that it could more easily- blow away when parked in heavy winds so tie down points are incorporated.
So from my angle you'd understand my regular quizzing as to why many caravans have a tare beyond 2300kg.
So why are caravans so heavy?
Simple-heavy materials. Chipboard, mdf, laminex, full size fridge, the list goes on. Why arent light weight materials used? Cost.
Lightweight Fallata ply weighs half the weight, triple the cost is one example. Large wheel/tyres, twin axles etc
So concluding, if caravanners were suddenly towing a van weighing 1800-2000kg atm only, instead of maxxing out their towing capacity we'd have far less rollovers.
Thats my thoughts but I'm no expert.
__________________
Be nice... if I wanted my school teacher here I would have invited him...
Have to agree with Eaglemax here, years ago We had a 18ft. Tandem axle York towed by a 1967 v8 xr fairmont, never had any dramas, drove at 95 most of the time, tare of this van was 1150kgs due to its aluminium frame, cupboard doors & internal furniture were of thin ply, had double bed & 2 bunks, I now have a 16.5ft. Poptop that tares at 1650kgs mainly because of the heavy internal build, We could take some lessons from Euro vans,
John.
I do appreciate the feedback given so far on this subject.
I have done a v2.0 (and I hope final version) of the Caravan Weights & Masses Analyser which now integrates calculations on another critical aspect of the subject that I had omitted from spreadsheet v1.0, that is the effect on your tow vehicle's front and rear axle loads caused by Tow Bar Overhang or TBO. It is a weight factor that some it seems do not consider either on purpose because it likely highlights non-compliance and restricts their GVM (head in the sand approach?) or simply because of unawareness. I hope the spreadsheet might assist the latter group but I doubt much will influence the former.
My thanks to yobarr for his kind suggestion to also cover this aspect of compliance.
Feel free to test the analyser and let me know if something seems to calculate incorrectly. Lengthy IF, AND, & LOOKUP formulas in Excel all became a bit of a haze as the night wore on!
Cheers
-- Edited by Webmaster on Sunday 18th of August 2019 08:52:22 AM
1) Your vehicle towing capacity should ideally exceed your van ATM.
2) Tug GVM should exceed van ATM by at least 10%
3) Measured ball download should be 10% approx of the measured van weight or 10% of ATM.
4) Stability control device mandatory on all new vans.
5) Tow Ed course compulsary for first time vanners.
6) Maximum speed limit for caravans 100kph.
All valid points to deal with the inherent instability of a trailer towed with an overhung hitch, but nothing that seeks to reduce that fundamental instability.
1. Yaw inertia reduction by concentrating the load over the axles.
2. Reducing the hitch overhang by getting it closer to the axle and choosing a longer wheel base tug to reduce the overhang to wheel base ratio.
3. Increasing the draw bar length to put the trailer wheels further back.
Addressing the above points individually can make a significant improvement. Addressing them all can make a dramatic improvement.
A few yrs back, a brand new tow vehicle and caravan lost control on the Mt Ousley hills (near Wollongong) sending the tow vehicle up over the concrete barrier and destroying both vehicles. Lucky the concrete barrier was there, real carnage would have occur if it wasn't. The cause was later blamed on the way the water tanks were plumbed, all the water drained from the rear tanks into the front tanks increasing the tow-ball weight to the point the steering was controlled by the caravan rather than the driver and sent the front of the tow vehicle up and over the wall.
Often wonder how many times caravan roll overs could have been caused by a similar thing happening, but once it is scattered across the road it would be very hard to determine.
T1 Terry
__________________
You can lead a head to knowledge but you can't make it think. One day I'll know it all, but till then, I'll keep learning.
Any links to any sites or products is not an endorsement by me or do I gain any financial reward for such links
A few yrs back, a brand new tow vehicle and caravan lost control on the Mt Ousley hills (near Wollongong) sending the tow vehicle up over the concrete barrier and destroying both vehicles. Lucky the concrete barrier was there, real carnage would have occur if it wasn't. The cause was later blamed on the way the water tanks were plumbed, all the water drained from the rear tanks into the front tanks increasing the tow-ball weight to the point the steering was controlled by the caravan rather than the driver and sent the front of the tow vehicle up and over the wall. Often wonder how many times caravan roll overs could have been caused by a similar thing happening, but once it is scattered across the road it would be very hard to determine.
T1 Terry
Terry how you going 'ol mate?
If the residue is scattered across the road and the van plated ATM exceeds the tug towing capacity what assumptions do you think the accident investigators will make and more importantly the insurance loss adjuster?
Certainly a red light for closer scrutiny I would suggest at best.
It may surprise you Monty, but I suggest that accident investigators don't make assumptions. That is pure scare mongering BS. Cheers, Peter
So they weigh the residue?
That is the only way they can determine a real outcome. An insurance company is always looking for a reason to withold payment of a claim in which case it is up to the claimant to prove them wrong. Why would anybody take that risk.
Peter, just because it doesn't agree with your view does not mean it is "scare mongering"
A few yrs back, a brand new tow vehicle and caravan lost control on the Mt Ousley hills (near Wollongong) sending the tow vehicle up over the concrete barrier and destroying both vehicles. Lucky the concrete barrier was there, real carnage would have occur if it wasn't. The cause was later blamed on the way the water tanks were plumbed, all the water drained from the rear tanks into the front tanks increasing the tow-ball weight to the point the steering was controlled by the caravan rather than the driver and sent the front of the tow vehicle up and over the wall. Often wonder how many times caravan roll overs could have been caused by a similar thing happening, but once it is scattered across the road it would be very hard to determine. T1 Terry
Good point Terry.After determining that this could/would cause all sorts of balance issues,I fitted taps to the inlets and the outlets of all 6 of my water tanks.(420 litres total) This means that I can maintain a reasonably consistent ball weight,no matter how much water I have on board.Cheers.
A few yrs back, a brand new tow vehicle and caravan lost control on the Mt Ousley hills (near Wollongong) sending the tow vehicle up over the concrete barrier and destroying both vehicles. Lucky the concrete barrier was there, real carnage would have occur if it wasn't. The cause was later blamed on the way the water tanks were plumbed, all the water drained from the rear tanks into the front tanks increasing the tow-ball weight to the point the steering was controlled by the caravan rather than the driver and sent the front of the tow vehicle up and over the wall. Often wonder how many times caravan roll overs could have been caused by a similar thing happening, but once it is scattered across the road it would be very hard to determine.
T1 Terry
Terry how you going 'ol mate?
If the residue is scattered across the road and the van plated ATM exceeds the tug towing capacity what assumptions do you think the accident investigators will make and more importantly the insurance loss adjuster?
Certainly a red light for closer scrutiny I would suggest at best.
Hi Monty, long time no hear, could be the result of my excommunication from that other forum :lol:
At best you would possibly determine total weight, but not weight distribution and that was the real cause of the accident, weight transfer for the rear of the caravan to the front of the caravan. In this case I believe there were 4 water tanks, 2 across the axles, two mounted towards the front. On the down hill run the water transferred to the front tanks increasing the ball weigh sufficiently to affect the tow vehicles ability to steer due to weight transfer from the from axles to the rear axle. Basically, nose up resulting in loss of control. I think the book writer was involved with supporting evidence for the legal battle.
T1 Terry
__________________
You can lead a head to knowledge but you can't make it think. One day I'll know it all, but till then, I'll keep learning.
Any links to any sites or products is not an endorsement by me or do I gain any financial reward for such links
A few yrs back, a brand new tow vehicle and caravan lost control on the Mt Ousley hills (near Wollongong) sending the tow vehicle up over the concrete barrier and destroying both vehicles. Lucky the concrete barrier was there, real carnage would have occur if it wasn't. The cause was later blamed on the way the water tanks were plumbed, all the water drained from the rear tanks into the front tanks increasing the tow-ball weight to the point the steering was controlled by the caravan rather than the driver and sent the front of the tow vehicle up and over the wall. Often wonder how many times caravan roll overs could have been caused by a similar thing happening, but once it is scattered across the road it would be very hard to determine. T1 Terry
Good point Terry.After determining that this could/would cause all sorts of balance issues,I fitted taps to the inlets and the outlets of all 6 of my water tanks.(420 litres total) This means that I can maintain a reasonably consistent ball weight,no matter how much water I have on board.Cheers.
Not absolutely sure on the one involved in the accident, but I have had vans in here with roughly the same tank set up so it seems likely it was a similar set up error that caused the problem. All the tanks were linked with the large diameter filler hose at the bottom and daisy chained from one end to the other, yet each tank had its own overflow.
The first climb up Mt Ousley is long and steep, so the water would have drained to the rear most tank, overflowing onto the road and partially emptying the forward tanks, then a short down hill followed by another long uphill climb. The steep down hill where that accident happened would have allowed the water to return to the front tanks, but drained the rear most tank. A combination of bad weight distribution and inexperienced operator resulted in a loss of control where the tail wagged the dog. The filler was at the bottom of the tank because the outside fill point was near level with the top of the tanks, so no way to actually fill the tanks without the water rushing back out the filler.
The 2 water tanks in our Hino have a similar problem, the right had tank fills but the left hand tank filler point is higher so the water tends to run back out the filler rather than into the tank. Took some complicated plumbing to sort the problem, the breather from the r/h tank into the top of the left hand tank and the l/h tank breather out to under the bus. A snap on hose fitting screws into the filler so both tanks can be filled, otherwise only the r/h tank fills. Not ideal but it works, both tanks are located over the rear axle so weight distribution is side to side rather than front to rear.
T1 Terry
__________________
You can lead a head to knowledge but you can't make it think. One day I'll know it all, but till then, I'll keep learning.
Any links to any sites or products is not an endorsement by me or do I gain any financial reward for such links
The first thing any new vanner needs to determine is water tank positioning and their positive or negative effect on ball download.
Tanks positioned in front of the axle group will impose weight on the ball when they are filled. Full tanks behind the axle group will have the opposite effect.
Water tanks positioned over the axle group are ball weight neutral.
Ball weight needs to be measured with tanks full, half full and empty to arrive at the ideal ball download. Many vans need to have full tanks while travelling whilst others need to be empty depending on positioning.
All vanners need to know the ideal situation with tanks and ball weight before they set off.
Boat water and fuel tanks have internal baffles to prevent a 'sloshing' effect induced by wave motion from making them unstable. It would appear to me that trailer sway is similar, and the sloshing motion of water in the tanks could exacerbate the sway. Maybe RV water tanks should have internal baffles as well?
Boat water and fuel tanks have internal baffles to prevent a 'sloshing' effect induced by wave motion from making them unstable. It would appear to me that trailer sway is similar, and the sloshing motion of water in the tanks could exacerbate the sway. Maybe RV water tanks should have internal baffles as well?
Commercially made plastic water tanks which make up 99% of the tanks used in caravans don't have internal baffles, because the manufacturing processes used (blow moulding or rotomoulding) can not put them in. It is possible to include them into plastic welded or S/S fabricated tanks, but they are much more expensive.
My solution was to use smaller tanks and several of them. Each has an easily accessible tap which selects it for use. This allows full control of where the water comes from and when.
Cheers,
Peter
The first thing any new vanner needs to determine is water tank positioning and their positive or negative effect on ball download.
Tanks positioned in front of the axle group will impose weight on the ball when they are filled. Full tanks behind the axle group will have the opposite effect.
Water tanks positioned over the axle group are ball weight neutral.
Ball weight needs to be measured with tanks full, half full and empty to arrive at the ideal ball download. Many vans need to have full tanks while travelling whilst others need to be empty depending on positioning.
All vanners need to know the ideal situation with tanks and ball weight before they set off.
That is really what it all boils down to, the system being capable of maintaining the water separate in each tank and the operator understanding the need for controlling water tank filling to establish the desired ball weight without adding weight to the van rear to counteract the weight added in front of the axles. It isn't just about ball weight, it is also about minimising the weight behind the axles so a pendulum effect on either axis can't start to build momentum.
One axis, front to back, will cause the porpoise effect that often causes travel sickness for the co driver and can even lead to loss of steering control if it gets bad enough.
The other axis is side to side, the rear goes left while the front goes right, then the whole thing is reversed but with a bit more momentum. The van being heavier than the tow vehicle the tail starts to wag the dog. We have all seen/experienced this one the most but often don't understand why it is happening where it never did before.
Basically, if you need to add weight in front of the axle to gain the desired ball weight, removing half of what is required from behind the axle and adding it in front of the axle will give the best result as far as handling goes.
If you need to remove weight, don't add weight to back of the van, you need to move the excess weight to between the axles.
Fine tuning involves how far forward or behind the axle the weight is, the closer to the axle the better the handling will be.
Just typing that reminds me why I drive a motorhome :lol:
T1 Terry
__________________
You can lead a head to knowledge but you can't make it think. One day I'll know it all, but till then, I'll keep learning.
Any links to any sites or products is not an endorsement by me or do I gain any financial reward for such links