Presenting Econ004RM.xls

[From Bill Powers (2003.02.24.1033 MST(]

Rick Marken (2003.02.24.0830)]

I tried Econ004RM.xls on an older version of Excel that I have here at
work and it
got upset at one of the Macro statements. Has anyone else tried it? If so,
has it
worked for you?

I'm still trying to get a copy of Excel. I downloaded the free Reader, but
while it shows the spreadsheet (very nice and neat layout), it can't run
macros.

The source code I sent you was for Turbo Pascal 7.0, not Delphi. I think
you have Turbo, and the code ought to compile and run under just about any
version of TP.

Best,

Bill P.

[From Bill Powers (2003.02.24.1418 MST)]

Rick Marken (2003.02.24.1150) --

>When you make changes or updates to the Turbo model, let me know and
I'll update

the Excel model. And when I make changes to the Excel model I'll let you
know and
you can change the Turbo model (if you like the changes). Let's see if we
can work
on it this way.

That should work.

Do you have a copy of Keynes' General Theory? I'm interested in your
comments (or anyone's) about how Keynes got to his equations on p. 63,
chapter 6.

Income = consumption + investment
Saving = income - consumption
Therefore saving = investment

I really don't think these equations are justified by what precedes them,
although there are so many words and so few actual mathematical operations
that it's hard to say. It seems to me that the above equation ought to have
a term for rate of savings in it: if "investment" is the amount actually
spent on capital equipment and "saving" is the amount put aside into an
account and not spent on anything, then for a given time period,

income = consumption + saving + investment

in which case the equation saving = investment would not hold true. The
more I mull over what is in Keynes, the more I get the impression that this
guy simply wasn't used to constructing system models and didn't know how to
do it. I don't see any reason for these really simple relationships to be
hard to understand or explain.

Best,

Bill P.

[From Rick Marken (2003.02.23.1130)]

Bjorn Simonsen (2003.02.23.09:00 CET)

I enjoy myself very much following the economic debate (Bill, Bill and
Rick). My leisure time is limited and I am still behind with all your
letters. If I become up-to-date with all the stuff you have presented I am
sure I'll participate more. This is interesting.

Perhaps the attached spreadsheet will make it a little easier to follow. I hope
many of you who are interested in the economics discussion will have Excel or a
spreadsheet program capable of running .xls files. Econ004RM.xls is my
transcription of Powers' ECON004b (which was written in Delpi, I believe) into
Excel.

When you open the spreadsheet you will be asked whether you want to enable the
macros. Say yes. Then you will see the main layout of the model in the
spreadsheet. The top three boxes are three sets of control systems: one set for
the plant manager (producer), another for the wage earning consumer and the third
(far right) for the capital income consumer. The three lower boxes are the three
main components of the economic "environment": plant, wage earning household and
capitol income household.

The control system variable names are pretty self explanatory. For instance, refRw
is the reference for variable Rw. The "environmental variables", like Rw, are less
self explanatory so they are commented (indicated by the red triangles in the
corner of cells). For example, when you hold the cursor over the red triangle in
the cell labeled Rw you see "Savings, $" so you know that Rw is the wage
consumer's savings in dollars.

You can enter your own parameters in the cells that are colored light green. For
example, you can enter a new value for refVm (which really should be called refVp
since it is the reference for Vp, the plant's inVentory of goods, but it's called
refVm in Bill's program so I'll keep it for now).

There are three buttons in the upper right. The "Run Model" button will run 2000
iterations of the model. Pressing this button always runs the model from whatever
state it is currently in (it starts the iterations with the level of cumulative
variables left from the last run, if there was one). The "Dynamic Graphs" button
shows a graph of selected variables, as in Bill's Econ004 model. After going to
the dynamic graphs you return to the "Basic Model" sheet by pressing the "Back to
Model" button next to the graphs. Finally, the "Reset Model" button resets the
variables in the model; in particular, it resets the cumulative variables to the
starting values shown in the "Accumulator Initialization" cells next to the
cumulative variables. If you don't press the "Reset Model" button, then each press
of the "Run Model" and "Dynamic Graphs" buttons runs the model starting at the
current state of all variables.

The parameters in the model are currently the same as those set in Bill's Econ004,
except for the reference for Vp (refVm) which is much lower than the value Bill
used. But I wanted to see if the model works OK when the plant manager has a
reference for inventory that is pretty low. I think refVp should probably be close
to 0, and the model works with this reference.

As far as I can tell, the model currently matches, in performance and details of
code, Bill's Econ004b version. I like the spreadsheet version of the model, not
only because the spreadsheet probably makes the model more accessible to more
people, but also because it makes it easier for me to see the relationships
between variables in the model and directly change the code that influences those
relationships. And Excel has a "trace" feature that puts arrows in showing
dependencies between cells. This makes it easy to see, for example, which
variables are affected by the outputs of the plant manager control systems
(outputVm, outputIm and outputRm).

Anyway, here it is. Enjoy. Experiment with new references and gains (the slowing
factors are currently irrelevant since all systems are proportional controllers at
the moment). Try different starting values for the accumulators. Most important,
try new relationships between economic environmental variables.

Dick Robertson,2003.02.22.1550CST]

So far, whatever the flaws in Rick's attempts to model leakage I was interested
in, and remembered well, the forecast with which he went out on a limb a couple
years back. Wherever it came from, it seems so far to have been rather
prescient.

Yes. I think Bush's persistent pursuit of tax cuts in the face of evidence that
they have no beneficial effect will test the leakage notion even further. As the
rich continue to get richer, leakage should continue to increase, resulting in
higher unemployment and inflation (both of which we are starting to see). I think
the dividend tax cut should really push it over the edge.

Best regards

Rick

Econ004RM.xls (95 Bytes)

···

--
Richard S. Marken
MindReadings.com
marken@mindreadings.com
310 474-0313

[From Rick Marken (2003.02.24.0830)]

I tried Econ004RM.xls on an older version of Excel that I have here at work and it
got upset at one of the Macro statements. Has anyone else tried it? If so, has it
worked for you?

Attached is Econ004RMb.xls, which should work in all recent versions of Excel.

Best

Rick

Econ004RMb.xls (96 Bytes)

···

--
Richard S. Marken, Ph.D.
Senior Behavioral Scientist
The RAND Corporation
PO Box 2138
1700 Main Street
Santa Monica, CA 90407-2138
Tel: 310-393-0411 x7971
Fax: 310-451-7018
E-mail: rmarken@rand.org

[From Rick Marken (2003.02.24.1150)]

Bill Powers (2003.02.24.1033 MST)

Rick Marken (2003.02.24.0830)]

>I tried Econ004RM.xls on an older version of Excel that I have here at
>work and it
>got upset at one of the Macro statements. Has anyone else tried it? If so,
>has it
>worked for you?

I'm still trying to get a copy of Excel. I downloaded the free Reader, but
while it shows the spreadsheet (very nice and neat layout), it can't run
macros.

I think it will work if you continue in Pascal and I do the Excel. If you can get
Excel that would be nice but I don't think it's absolutely necessary. I'm hoping
that the Excel version can get some of the non-programmers (and Mac users) in on
the economics discussion.

The source code I sent you was for Turbo Pascal 7.0, not Delphi. I think
you have Turbo, and the code ought to compile and run under just about any
version of TP.

I thought it looked familiar;-) I don't want to get involved in writing in Turbo
because I want to stick with one machine (the Mac) and I don't want to mess with
other people's computers (Linda lets me use her PC but I know that it interferes
with her work).

When you make changes or updates to the Turbo model, let me know and I'll update
the Excel model. And when I make changes to the Excel model I'll let you know and
you can change the Turbo model (if you like the changes). Let's see if we can work
on it this way.

Is there anyone else out there on CSGNet who is interested in working on the
economic modeling?

Best regards

Rick

···

--
Richard S. Marken, Ph.D.
Senior Behavioral Scientist
The RAND Corporation
PO Box 2138
1700 Main Street
Santa Monica, CA 90407-2138
Tel: 310-393-0411 x7971
Fax: 310-451-7018
E-mail: rmarken@rand.org