A few people have have asked if and if I still planned to post an update to http://forum.sbrforum.com/handicappe...tml#post256487.
The short answer is yes, but only after I put together some better documentation.
In the meantime, however, interested parties can download the attached demo spreadsheet. I've recoded many of the functions in C++ , so if want to check it out you'll also need the matrix.dll library included in the .zip file. Copy the DLL to your \Windows\System32\ directory and you'll be ready to go.
Feel free to copy the VBA functions and wrapper code into your own spreadsheets. You can also call the DLL functions directly from other programming languages. Not all the included functions are demoed and most won't be of use to 99%+ of posters. Many of the functions I personally use all the time, others I virtually never use.
The main reason I rewrote much of the was to speed up large matrix operations. Inversions are much faster than with the Excel built-in function (and without any size limits) as are calculations involving nested matrix operations (as would be the case, for example, with generalized regressions). I also coded an Eigenvalue/vector solver for symmetric matrices which should useful to anyone delving into Principal Component Analysis.
Anyway, this comes with absolutely no warranties, ... , etc. etc. If anyone finds any of this useful -- great.
The short answer is yes, but only after I put together some better documentation.
In the meantime, however, interested parties can download the attached demo spreadsheet. I've recoded many of the functions in C++ , so if want to check it out you'll also need the matrix.dll library included in the .zip file. Copy the DLL to your \Windows\System32\ directory and you'll be ready to go.
Feel free to copy the VBA functions and wrapper code into your own spreadsheets. You can also call the DLL functions directly from other programming languages. Not all the included functions are demoed and most won't be of use to 99%+ of posters. Many of the functions I personally use all the time, others I virtually never use.
The main reason I rewrote much of the was to speed up large matrix operations. Inversions are much faster than with the Excel built-in function (and without any size limits) as are calculations involving nested matrix operations (as would be the case, for example, with generalized regressions). I also coded an Eigenvalue/vector solver for symmetric matrices which should useful to anyone delving into Principal Component Analysis.
Anyway, this comes with absolutely no warranties, ... , etc. etc. If anyone finds any of this useful -- great.