{QuantQraft} Solutions for Excel®.
Tools for engineers, quants, analysts and applied scientists
{QuantQraft} Matrix+Vector for Excel®
Solve linear algebra problems from within Excel®
- Whether you are an engineer, statistician, financial analyst, applied scientist, student, teacher or otherwise a practitioner of linear algebra,
whether you need to
- solve systems of simultaneous linear equations,
- find least-squares solutions to generate a linear best-fit or solve over-determined linear equations systems,
- compute matrix decompositions such as Cholesky decomposition, LU decomposition, QR decomposition and singular value decomposition,
- determine the eigenvalues or singular values of a matrix,
- compute various matrix and vector norms, matrix rank and trace,
- the matrix inverse or the Moore-Penrose pseudo inverse (e.g., for under-determined linear equation systems),
- matrix and vector norms, distance measures and angles, vector projections and convolutions or
- carry out various other operations on matrices and vectors,
and
whether you want to
- use the matrix and vector operations like any other worksheet function from within cells and cell ranges in Microsoft Excel 2003 - 2010, or
- embed them in your own VBA macros -
{QQmatrix} for Microsoft Excel will do the job for you.
{QQmatrix} is an add-in that will add numerous additional worksheet functions to your Excel installation.
{QQmatrix} offers an extensive toolbox of more than a hundred worksheet functions for meeting your needs when you have to deal with calculations that involve matrix and vector operations, in addition to the few built-in matrix functions (TRANSPOSE, MMULT, MINVERSE or MDETERM).
{QQmatrix} can process matrices and vectors containing more than a million elements.
The built-in Excel Solver, for instance, has a limitation that is set to a mere 200 decision variables for systems of linear equations. For the linear solver provided by {QQmatrix}, on the other hand, the number of decision variables is only limited by the maximum number of columns in a worksheet (16,384 in Excel 2007 or a later version). Excel 2003 matrix functions such as MMULT, MINVERSE and MDETERM are limited to matrices with less than 6,000 elements.
For a (100x100 = 10,000-elements) matrix, the computation will appear near-instantaneous to the user. Depending on your hardware, a matrix with 1 million elements may require less than 2 seconds (e.g. quadcore 2.2GHz) to obtain, for instance, the inverse matrix. Smaller matrices require a fraction of a second of processing time, whether for inversions, QR factorizations, eigenvalue or singular value decompositions, as well as for other computationally intensive matrix operations. Performance comparisons between {QQmatrix} and the few native matrix functions available in Excel indicate that {QQmatrix} can carry out the inversion or multiplication of test matrices with 1 million elements at a fraction of the time MINVERSE and MMULT need.
We invite you to make your own comparisons in your spreadsheet environment by using the free {QuantQraft} trial edition, which offers the full capacity of the fully licensed edition (click the button "Download Trial" at the bottom of this page). The trial version does not require a registration.
The {QQmatrix} functions are embedded in the function wizard. Their use does not differ from that of native Excel worksheet functions.
System Requirements
- Microsoft Windows XP SP3 or a later Windows version
- Microsoft Excel 2003 or later Excel version
- Microsoft .NET Framework version 4.0 or later (an update to 4.0 is available as a free download from the Microsoft website, if you own an older Windows version in which the Framework had not yet been integrated).
- <15 MB free hard disk space
The {QQmatrix} functions are grouped into 3 categories:
- functions whose output is a rectangular array (prefix “QQm”)
- functions whose output is a 1-dimensional vector (prefix “QQv”)
- functions whose output is a scalar (a single real number) (prefix "QQs")
You can embed {QQmatrix} functions in other worksheet functions. The input arguments within a {QQmatrix} function can consist of the results of other {QQmatrix} functions. For instance, calculate a matrix product using QQmMultiply, then envelop this function with QQmElements, in order to count the number of elements in the resulting matrix product.
You can apply other factors to the outcome of a {QQmatrix} function. If for instance, you multiply a {QQmatrix} function by a factor (like -0.5), the factor is applied to each cell in the QQ output range.
A {QQmatrix} function can be fully embedded in a native Excel function (such as INDEX).
In order to embed {QQmatrix} functions in your own VBA macros, use the syntax
Application.Run("{QQmatrix} function name", function argument(s))
You can utilize the {QQmatrix} functions in your VBA “Sub” routines as well as in any of your user-defined VBA Functions. A VBA function, like MyVBA_2norm shown in the screenshot below, that contains one or several {QQmatrix} functions can be entered in a cell range like any other worksheet function.
An Excel workbook offering numerous examples can be downloaded here.
After installing {QQmatrix}, the Excel ribbon will sport a new menu, {QuantQraft}. Click the button 'Taskpane' to display the {QQmatrix} taskpane on the right-hand side of the Excel window. If you place your cursor in a cell that contains a {QQmatrix} function, the taskpane will offer information about the function, its syntax and arguments.
Alternatively, you can select a {QQmatrix} function from the dropdown list near the top of the taskpane.
Likewise, the Excel function wizard offers information about the function beneath your cursor.
The 'Make Array' button of the taskpane converts a 'normal' formula to an array formula, envelops it in curly brackets { and } and expands it so as to cover the worksheet range required to show the complete array. Thus, it reliefs the user from having to guess the proper size of the cell range, to select it and then to press the key combination <Ctrl> + <Shift> + <Enter>.
A succinct alternative to the more detailed information shown in the taskpane is the key combination <Ctrl> + <Shift> + <A>. Enter a function name in a worksheet cell, e.g. =QQmEigen. Then, before you have to enter the arguments, press <Ctrl> + <Shift> + <A> and Excel will display the syntax and names of the function arguments in the function editor.
Continue typing, by entering values for the function arguments.
Take a test drive: download the free {QQmatrix} trial edition, by clicking the "Download Trial" button further below, and see for yourself. The trial edition offers the full capabilities of the permanent edition, for a limited period of time. A registration is not required.
An Excel workbook containing examples can be downloaded here.
A single-user permanent license for the QQmatrix add-in is available for just $89.00. Information about volume discounts is available here.
Your order will be processed in the webstore of one of our international e-commerce retail partners such as U.S.-based Plimus (http://home.plimus.com/ecommerce/buyers). More information about the order, payment and delivery process is available on our FAQ page.
The word clouds were created by using Wordle, courtesy of www.wordle.net
