File DERIVE21.XLA for Excel 97/2000/XP
Ver. 8-sept-2002

Fix the following bug:
Incorrect exponential value imported into Derive
Example: 1.23456E-26 instead of 1.23456*10^-26 (Derive does not recognize the E for exponential form)

The file DERIVE21.XLA is an Excel-addin-macro useful for transferring vectors and matrices from DERIVE to Excel and vice versa. 
The macro works with DERIVE for Window ver 4 (all version) and  5 (5.0 - 5.02)

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

DERIVE21.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 DERIVE21.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 Matrix from DERIVE" and "Copy Matrix to DERIVE" in the "Edit" menu. 
In this way, every time Excel runs, the macro DERIVE21.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 DERIVE21.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 Matrix 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 DERIVE21.XLA.
NB. If there is the old derive.xla (rev. 97), you must remove it, before installing DERIVE21.xla



This software is free.
I will appreciate every your suggestions and bug reports. 
:-) 
In the meantime, have fun! 

By Leonardo Volpi
Foxes Team
E-mail: volpi.leonardo@enel.it
E-mail: leovlp@libero.it
 