Re: Calculating a generalized inverse matrix


"Ying-Foon Chow" <yfchow.cuhk@xxxxxxxxx> a écrit dans le message de
news:1194924998.787047.48670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Indeed, this problem is much easier in other matrix programming
languages mentioned in Paige Miller's post, but I just thought Excel
is easier for demonstration purpose. By the way, the "brute force"
method that I was told elsewhere is to get add-ins that can do
singular value decomposition, and I think I can get the pointers by
searching Google.

The PopTools add-in for Excel from CSIRO
www.cse.csiro.au/poptools/

has SVD as part of its matrix tools.

HTH
Z


.

Relevant Pages

  • Re: Does a complex Excel VBA Password provide additional security
    ... Excel does not store the password as text, ... basically with a brute force method. ... Excel 2003 VBA password may be a max of 32 characters and the password may ... to match a complex password. ...
    (microsoft.public.excel.programming)
  • Re: Workbook password security
    ... Type 'Excel Password' into Google and you'll find dozens of them. ... enough to make a brute force attack take too long anyway. ... WORKSHEET passwords that are easily worked around, not the WORKBOOK ...
    (microsoft.public.excel)
  • Re: Removing trailing zeros
    ... Much more elegant than my brute force approach! ... Norman Harker MVP ... Excel and Word Function Lists ...
    (microsoft.public.excel.misc)
  • Re: Switching from Jan-1 yields 1/1/2006, should be 2007
    ... Excel assumes the current year. ... Tutorials and Custom Solutions ... Any thoughts on a formatting method apart from a brute force ...
    (microsoft.public.excel.programming)