Scribd
Upload
37 views4 pages

Euler Excel Addin

This add-in allows for the exchange of matrices between Excel and the freeware program EULER. It provides commands to copy matrices between the two programs. To install, place the files in a folder and add it as an Excel add-in. The commands under the Edit menu then allow selecting a matrix in one program and pasting it into the other. Wrapped matrices from EULER will be rearranged before pasting into Excel. The add-in is designed to make it easy to compare matrix results between the different environments.

Uploaded by

Thanh Bình Huỳnh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
37 views4 pages

Euler Excel Addin

This add-in allows for the exchange of matrices between Excel and the freeware program EULER. It provides commands to copy matrices between the two programs. To install, place the files in a folder and add it as an Excel add-in. The commands under the Edit menu then allow selecting a matrix in one program and pasting it into the other. Wrapped matrices from EULER will be rearranged before pasting into Excel. The add-in is designed to make it easy to compare matrix results between the different environments.

Uploaded by

Thanh Bình Huỳnh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Foxes Team

Addin for exchanging matrices between EXCEL and EULER


v.1.0, Oct. 2003
by Foxes Team

Introduction

EULER is a very nice freeware program for quick and interactive computations with vectors and
matrices, real and complex numbers. In general, EULER is a numerical matrix system. (EULER is
not a MatLab clone, but very similar to this program).
Many times we need to compare matrix results in different environment.
This little addin allows the exchange of matrices between Euler and Excel

How to install it

Unzip and place all the files in a folder of your choice. This addin are contained entirely in this
directory. Your system is not modified in any other way.
Now, follow the usual procedure for installing Excel Addins:
1) Open Excel
2) Select <Addins...> from the <Tools> menu
3) In the Addins Manager, search for and select euler_excel.xla
4) Click OK

If all goes right you should see a welcome pop-up and two new entries added at the <Edit> menu

• Copy Matrix to EULER


• Paste Matrix from EULER

(If you have an Italian version of Excel you should see this command in Italian)

How to use it

Use these commands is very easy.

Copy Matrix from Excel to Euler

Select in the matrix that you want to export and then click on the command " Copy Matrix to
EULER" in Edit menu

Foxes Team Pagina 1 24/10/2003


Foxes Team

Now, switch to Euler text window


In Euler you have to assign a matrix or a vector to a variable.
Assume to assign the above matrix to "A" variable
At the Euler prompt write A =
Now press CTRL+V or click the "Paste commands" from the Edit menu

The program will copy the following string after the assign "=" symbol
A = [ 1, 1, 1, 1, 1, 1, 1;-2, 2, 3, 4, 5, 6, 7; 1, 0, 3, 7, 12, 18, 25; 1, 1, 4, 11, 23, 41, 66; 1, 2, 6, 17, 40, 81,
147; 1, 3, 9, 26, 66, 147, 294; 1, 4, 13, 39, 105, 252, 546]

Pressing ENTER you will complete the assignment. The Euler screen will look like the following

Copy Matrix from Euler to Excel

We can perform the reverse operation: copy a vector or a matrix from Euler into Excel. To do this
simply select the matrix output

Press CTRL+C or click the "Copy Text" from the Edit menu

Foxes Team Pagina 2 24/10/2003


Foxes Team

Now, switch to EXCEL window and select the right-upper cell that you want and click the
" Paste Matrix from EULER" from the Edit menu
All the cells will be filled with the matrix entries

Wrapped matrix

When the matrix becomes larger, Euler automatically wraps the matrix columns. The paste
command of this addin rearranges the columns before coping them into Excel

Example Compute the inverse of A matrix


Give
>longformat
>inv(A)

The result will show in the wrapped format: first the columns 1 to 4 and then the columns 5 to 7
If you want to port this matrix into Excel simply select all matrix output.

Now press the CTRL+C

Foxes Team Pagina 3 24/10/2003


Foxes Team

Now, switch to EXCEL window and select the right-upper cell that you want and click the
" Paste Matrix from EULER" from the Edit menu
All the cells will be filled with the matrix entries

Euler_Excel.xla is freeware. Have fun with it

October, 2003

Foxes Team Pagina 4 24/10/2003

You might also like