Ventana software support forum

Posted: **Thu Mar 28, 1996 2:44 pm**

Date: 03/28/96 14:36:58
To: SYSD --KODAKR *System-Dynamics

>From: William Bonnell
Mgt.Services Div., Eastman Kodak Company
Bldg. 56-4, KP, Rochester, NY 14652-4530
Subject: Powersim

How can you paste a table from Powersim into excel. I was able to do one
variable at a time but need to do the whole table. Also, I was able to
use the archive object to save a table to disk. I am not able to get the
dde object to work by following the directions in the manual even though
it is supposed to be very similar to the archive object. Can someone
give some clear guidance (step 1, step 2. ...)

Thanks in advance.

___________________________
Bill Bonnell (716) 477-7874
bonnell@kodak.com
---------------------------

Posted: **Fri Apr 05, 1996 10:36 am**

>How can you paste a table from Powersim into excel. I was able to do one
>variable at a time but need to do the whole table. ... Can someone
>give some clear guidance (step 1, step 2. ...)
>

I am in a hurry and I am not able to give you at this time a detailed
guidance (step 1, step 2.
...). Here are some hints. If necessary, Ill come back with a detailed list
of steps later.

Since you have been able to transfer one variable at a time but not a series
of values, I
suggest that you try the following in your dialog Define Dynamic Data
Exchange:

Supposing that you want to transfer both the time values and the time series
for a variable
(say Account) and that the number of results is 30 (or less). Specify
r1c1:r30c2 as Item
(and the name of the Excel-file you want to use as Topic, say RESULTS.XLS).

Also, do experiment with different ways of using Excel. I.e., start the
simulation without having
started Excel. If this does not work, start Excel first. Alternatively,
create an empty file named
RESULTS.XLS and load it first. It sounds frustrating, but DDE is sometimes
frustrating
(blame Bill Gates).

Dont hesitate to come back if you need more help

Prof. Jose J. Gonzalez
Dept. of Computer Science, Agder College
Groosvn. 36
N-4890 GRIMSTAD, Norway
Phone: +47 37 25 32 40 (office) Fax: +47 37 25 30 01 (office)
+47 37 04 70 29 (home) +47 37 04 70 74 (home)
+47 92 09 09 39 (cellular)
Email: Jose.J.Gonzalez@hia.no

Posted: **Mon Apr 08, 1996 2:52 pm**

Bill,

To cut and paste tables, graphs, diagrammes, etc. from Powersim into =
Excel or Word without having the dynamic link do the following. In =
Powersim use the right mouse button to select the area you want to cut =
and paste you will see that a box appears to indicate the selected area, =
then go on to follow the usual cut and paste procedures. The trick is =
using the right mouse button.

Rhoderick van der Wyck
Consultant
Oasis Process Consulting
The Netherlands
Tel. +31 30 6066336
Fax +31 30 6065844
rvdwyck@mailhost.net

Posted: **Mon Apr 08, 1996 3:57 pm**

In response to Bill Bonnells question about DDE and Powersim, I sent him a 9
step process a week and a half ago. With the renewed activity around this
question and Bobs comment about talking to the whole list, here are those
steps:

The Steps
1. Models - Select the model whose variable(s) you want to export. Models
includes the main model and all co-models. Well choose Main.
2. Variables - Choose the variable(s) you want to export. Variables displays
all variables names (scalars) and variable elements (arrays) of the selected
model. Well pick Cash and AccountsReceivable.
3. Transfer - Choose between exporting (To Application) or importing (From
Application) the data. Well select to export (To Application).
4. Orientation - Pick the desired orientation of the data. Vertical means
that the data is sent to a column, while Horizontal means that the data is
stored in a row. For our example, well select Vertical.
5. Values - Decide on transferring the data as single values or a time
series. If you select Single, only one value will be transferred for each
variable during the entire simulation. If you choose Series, several values
will be transferred for each variable. When you choose Series, another
setting will be enabled, i.e., Times. Well pick Series.
6. Times - Determine the times associated with the data in a time series.
From, To - Choose the time associated with the first and last value of each
time series. When exporting data, you should normally select Auto for From
and To.
Step - Pick the interval between successive data points in the time series.
If the current simulation contains a large number of time steps, you may
want to increase the value of Step from its Auto value to a larger number in
order to reduce the number of values in the generated time series.
7. Service - Enter the name of the application with which you are exchanging
(EXCEL, WINWORD, etc.). Well pick EXCEL.
8. Topic - Input the name of the specific application file with which you are
exchanging. The name of our Excel file is accting.xls.
9. Item - Specify the cells where the data is to be placed. The procedure
for this is to specify the entire field where the data will be placed by
specifying the first cell and last cell. The convention used is to refer to
the cells row and column locations and separate them by a colon. For
instance, cell E1 would be r5c1, or row 5, column 1. In our example, well
use the cells r1c1:r20c2 (A1 to B20). I used r1c1:r20c2, since it was two
variables in a model that ran for 20 time steps with a vertical orientation.

Finally, if anyone has any Powersim specific questions in the future, they
can be sent to me directly at: danan@powersim.com

Daniel E. Angelakis
Modeling Consultant
Powersim Corporation