I'd like some assistance with modeling an input/output/feedback function.
An example (see attached JPG) was found in an older publication. I'd like to replicate the changes in the I/O and feedback so that a given value (e.g., 6) is constantly held.
Again, please see attached JPG first. Based on the quoted paragraph, the following data is summarized:
Summary of values:
Input value is 3
Output value is 6
Output reading changes to 8 (for unknown reason)
Output deviation = 2
Input value registering 4
Feedback circuit output deviation of 2
Input reduced to 2
Transfer function will double
New output will be 4 instead of 6
Feedback circuit needs its own transfer function which will take the output deviation of 2, reduce it to 1
Output will now return satisfactorily to 6 (because its input has been corrected to 3)
1. First and foremost, can Excel be utilized to mimic this process flow (whether it's based on the initial output reading change from 6 to 8 or from 6 to any other number)?
2. "Icing to the cake"... if yes to #1, can those changes be animated and show the values of the I, O, and feedback at each of these timeslices?
If "no" is the answer to both questions, what are some tools that could accomplish mimicking this particular data flow?
Thank in advance,