Exporting DERIVE into Excel
By Foxes Team , rev. Sept 2003
The file
DERIVE.XLA is a Excel-addin-macro useful for transferring vectors and matrices
from DERIVE to Excel and vice versa.
File
DERIVE.XLA for Excel 97 (derive21xla.zip ver. Aug,
2000 38KB)
Sometimes,
we need, also, to exchange vectors and matrices between DERIVE and Excel. For
example, simply, to make well refined reports and graphs, or to test algorithms
in different environment.
The file
DERIVE.XLA is a Excel-addin-macro that contains function to transfer vectors
from DERIVE to Excel and reverse. From Excel to DERIVE is also possible to
transfer matrices.
Use
In
DERIVE, highlight the vector or the matrix you want to copy and click the
"copy expressions" in "Edit" menu (or by ctrl+c). Switch on
Excel, select the cell that you want the first element to copy and click
"Paste Matrix from DERIVE" command in the "Edit" menu.
Matrix (n x m) are written in the same way as in DERIVE. Vectors are always
written in vertical. On the contrary, if you want copy a rectangular matrix (as
well row vector or column vector) from Excel, select the matrix's cells and
click "Copy matrix to DERIVE" command in "Edit" menu.
Switch to DERIVE, click "Author Expression" and give the usually
ctrl+v sequence for pasting. Notes that, if you have copied a vertical vector
in Excel you get a "vertical vector" in DERIVE and vice versa.
New
feature:
Exporting
Matrix into Excel. Now it is possible to export rectangular matrix into EXCEL.
Save
Formatting: The decimal, exponential, end fractional format are tranfered into
EXCEL in the original format.
Installation
DERIVE.XLA
is a "addin macro" for Microsoft Excel 97 and can be installed
following the normal procedure for all other .XLA files. Synthetically:
1) in
Excel , select "Addin…" from the "Tools" menu list
2) click
"Search" button; find out and select the DERIVE.XLA file
3) now,
in the list box you should see "Derive" checked. Click Ok .
If all is
ok you should find the news functions "Paste vector from DERIVE" and
"Copy matrix to DERIVE" in the "Edit" menu.
In this
way, every time Excel runs, the macro DERIVE.XLA will be load automatically.
To turn
off the macro, simply unchecked "Derive" in the list shown at the
point (3).
A second
simpler procedure exists:
1) open
DERIVE.XLA from the "file" menu of Excel
Apparently,
you do not see anything change in the active chart, because XLA files are
invisible, but you should see the two news functions "Paste vector from
DERIVE" and "Copy matrix to DERIVE" in the "Edit"
menu; this mean that the macro are correctly loaded.
This
simply installation hold out only to the end of a session. When you will run
Excel again, you have to re-open DERIVE.XLA.
Top