I'm new to this forum and have only just started to realise the benefits of using Excel in a capacity other than office related work! I've been using it a lot recently as part of my Motorsport Engineering degree to model the behaviour of certain principles. My latest is an indepth analysis of a vehicle suspension system.
I am trying to simulate the effect of a car wheel going over a bump of, for example 25mm. I have created a graph with x and y axis representing distance. I have then plotted two lines that represent the top and bottom wishbones of a suspension (these are at slight angles from the horizontal, as per my required design). What I am now trying to do is create a function where you enter a specific bump height into a cell, and this moves the lines up accordingly. The problem is that these lines have to pivot at the y intercept (as they would on a car), which means the line will be moving in an arc rather than straight up. Another problem is that both lines must remain the same length, set by my required design. The idea behind this is to assess the change in camber as the vehicle hits the bump. I have been working on it for days and tried all sorts of combinations with no luck. Any ideas would be much appreciated! I have included the workbook for reference.
Many thanks!!
Bookmarks