| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I invert a complex matrix
How do I do an inversion of a matrix containing complex numbers.
The "minverse" function doesn't recognise complex numbers. Even a small venture into Visual basic has proven unsuccessful. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I invert a complex matrix
I think you have reached the outer edge of the Excel mathematical envelope.
(And mine!) Its a problem for Mathimatica, MathCad or Maple I am just experimenting with TK Solver and will see the documentation mentions this. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Greg Conway" wrote in message ... How do I do an inversion of a matrix containing complex numbers. The "minverse" function doesn't recognise complex numbers. Even a small venture into Visual basic has proven unsuccessful. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I invert a complex matrix
Damn I can do it in SageMath, or on my programmable calculator but I was
hoping to be able to do it in excel. "Bernard Liengme" wrote: I think you have reached the outer edge of the Excel mathematical envelope. (And mine!) Its a problem for Mathimatica, MathCad or Maple I am just experimenting with TK Solver and will see the documentation mentions this. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Greg Conway" wrote in message ... How do I do an inversion of a matrix containing complex numbers. The "minverse" function doesn't recognise complex numbers. Even a small venture into Visual basic has proven unsuccessful. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I invert a complex matrix
I downloaded some VB code from http://www.alglib.net/matrixops/complex/inv.php
But I'm not a VB programmer and I'm struggling to do anything usefull with it. "Bernard Liengme" wrote: I think you have reached the outer edge of the Excel mathematical envelope. (And mine!) Its a problem for Mathimatica, MathCad or Maple I am just experimenting with TK Solver and will see the documentation mentions this. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Greg Conway" wrote in message ... How do I do an inversion of a matrix containing complex numbers. The "minverse" function doesn't recognise complex numbers. Even a small venture into Visual basic has proven unsuccessful. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Matrix functions on complex numbers | Excel Worksheet Functions | |||
| finding and summing data in somewhat complex matrix. | Excel Worksheet Functions | |||
| How to compute the inverse of a matrix with some complex elements | Excel Worksheet Functions | |||
| Invert a matrix larger than 52 x 52 using MINVERSE | Excel Worksheet Functions | |||
| Matrix operations with complex numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
