Thanks for the version 4.0 Excel program. Unfortunately I now get the
message "Cannot resolve circular references," so I guess version 4.0 isn't
going to work. Unless there's something that needs to be done that I'm not
doing.
Oh, well, I understand the model anyway so it's probably no big deal.
Thanks for the version 4.0 Excel program. Unfortunately I now get the
message "Cannot resolve circular references," so I guess version 4.0 isn't
going to work. Unless there's something that needs to be done that I'm not
doing.
Select iteration in the Calculation dialog box in the options menu.
[From Bill Power (980626.
francisco arocha, 980626.9:12 AM EST--
Select iteration in the Calculation dialog box in the options menu.
That did it -- thanks much. I still need the version 4.0 file, but now it
runs. If everyone else can run version 4.0 files, I'd appreciate seeing
them all posted that way.
General note:
To say that the coerced is less strong means that there is a limit on the
amount of output (positive or negative) that the coerced person can
produce, and this limit is less than the limit on the coercer's output. The
sensitivity is not necessarily different in coercer and coerced. In the
spreadsheet as it is now (the one Rick sent me, phase 3 I think), the
coercee actually produces as much output as the coercer, or more.
I like very much Bruce Nevin's current use of the model as a basis for
interpreting behavior. That's what a model is really good for: you
construct the model to explain one thing, and then see that it explains
other things when you change the circumstances or the parameters. This is
what makes a model more general than empirical curve-fitting.
Unfortunately I now get the
message "Cannot resolve circular references," so I guess version 4.0 isn't
going to work. Unless there's something that needs to be done that I'm not
doing.
Rick is using recursion (a formula contains a reference to the cell that it
is in) to simulate feedback. It may be that Excel 4 does not support that.
Things you could do: Verify that, perhaps by looking up "circular
reference" in the help. Upgrade to Excel 5. Depends on how much involvement
you want to have with spreadsheet simulations.
To say that the coerced is less strong means that there is a limit
on the amount of output (positive or negative) that the coerced
person can produce, and this limit is less than the limit on the
coercer's output.
OK. I have revised Bruce Nevin's version 4 spreadsheet to include
output limits. I'm posting the Excel 4 version; coercer and
coercee have the same sensenativity (.5) but different output
maxima. The "Range Limited Output" of the systems is now what
is used in the calculation of the states of qi and qo' (the two
variables that can be controlled by the coercer). The coercer
is currently controlling qi; the (absolute) output limit of the
coercer is 10 times that of the coercee (20000 vs 2000).
I like very much Bruce Nevin's current use of the model as a basis
for interpreting behavior.
Me too! Hooray, Bruce! It would be nice if more of the RTP folks
could get involved in this process.