Ok, here's one that I really have had no luck searching for...
I'm writing a little sheet to test some navigators on their basic speed/distance/time calculation skills. Ignore the clocks in Row 1, they're unrelated.
What I'd like is to simulate some basic acceleration / deceleration characteristics of a vehicle against a speed demand set point that the user enters. Obviously, no vehicle can go from any speed to another instantaneously, so I'd like my end users to have to take this into account when setting their demand speed.
Simply put, I'd like the actual speed in cell H4 to always target the demand speed in H3 and always return a result, but lag behind the demand speed slightly when changing.
I appreciate this is very basic - vehicles will have individual acceleration curves which are obviously non-linear, and acceleration and deceleration will be different to each other. But, for now, a simple linear control to limit the rate of change cell H4 would be terrific.
Cheers in advance,
Roy K.
Bookmarks