{QuantQraft} Solutions for Excel®.

Below are a number of Frequently Asked Questions related to our products, their pricing, licensing, the purchase process in general, the system requirements and the installation process. If you have any questions that are not covered in this list, we would be happy to answer them.

• Which are the system requirements for a {QuantQraft} software product? 
• How will a purchase be processed?
• How do I register and activate a {QuantQraft} software product?
• Which are the license terms for a {QuantQraft} software product?
• What is your privacy policy?
• How do Excel array functions work?
• Do you offer discounts?
• Can I transfer the software from my old PC or notebook to a new machine?

 

 

 

for all {QuantQraft} software products:

The add-ins work under Windows 7 and Excel 2010 and are fully backward-compatible. The oldest compatible platforms are Windows XP SP3 and Excel 2003.

• Microsoft® Windows XP SP3 or a later Windows version
• Microsoft Excel® 2003 or a later Excel version
• Microsoft® .NET Framework version 4.0 or a later release (if it is not already comprised in your Windows installation, it is available as a free Windows update from the Microsoft website; the {QuantQraft} products check if the Framework 4.0 is already installed on your PC - if not, they will suggest to you to download NF4.0).

back

 

 

Your order will be processed through one of our international e-commerce retail partners such as U.S.-based Plimus (http://home.plimus.com/ecommerce/buyers). The purchase transaction is routed through a webstore hosted by the e-commerce partner. {QuantQraft} sells its products to the e-commerce retailer, who resells them to end users. Your vendor is the e-commerce partner, who will also issue a printable invoice, process your payment, send a license code and a download link for the software to you via e-mail. Upon request, Plimus will also deliver a CD-ROM in addition to the download.

The webstore offers several payment methods such as credit card (online or via phone or fax), bank transfer, Paypal or Google Checkout, as well as invoicing in a variety of currencies.

When you decide to buy a {QuantQraft} product, the purchase will be processed through an encrypted connection (Secure Socket Layer SSL protocol) with the e-commerce webstore. Your credit card details or Paypal account data will not be revealed to {QuantQraft} or any other party but the e-commerce retail partner.

 

Your vendor will be the e-commerce partner. {QuantQraft}, as the developer, sells its software to the retail partner, which resells it to end users.

Invoicing will take place by e-mail directly after your order has been placed with the e-commerce retail partner. Upon completion of the payment transaction, the e-commerce partner will deliver the ordered {QuantQraft} products to the e-mail address you entered in the order form. Delivery will be effected by enabling the customer to download the software from the webstore, by using a download link in the order confirmation e-mail. You will also be able to print out an invoice.

 back

 

 

1. The folder in which you install {QQmatrix} contains, among other files, the text file QQlicCode.txt.

 

Its only content is a long string of printable characters: your license code. The license code is of the type: Evaluation Code, Serial Code or Activation Code.

2. The Trial or Evaluation version of {QQmatrix} offers the full functionality for a limited period of time: 30 days from the date of the installation.
A registration or activation is not necessary. The Evaluation Code is already embedded in the trial version.

 

3. Registration = Entering a SERIAL CODE: When you purchase a license, you receive a Serial Code by e-mail.
 a. Copy and paste this Serial Code into the text file QQLicCode.txt (overwriting any existing string in the file).
 b. Alternatively, Excel menu: {QuantQraft} - {QQmatrix} - License: copy and paste the received Serial Code into the 'License Code' box

, overwriting any existing code.

 

4. Activation = Entering an ACTIVATION CODE:
Activation grace period = within 30 days after the registration, your license must be activated, i.e., tied to your machine code, by overwriting the Serial Code with the Activation Code. You can continue to use {QQmatrix} during this period without restrictions, but an Activation Code will have to be entered in order to use {QQmatrix} for longer than the activation grace period.
 a. Excel menu {QuantQraft} - {QQmatrix} - License: please look up your PC's unique Machine Code in the license dialogue window.
 b. Copy and paste the both the Serial Code and the Machine Code into an e-mail and request your Activation Code from {QuantQraft}.
 c. After receiving the Activation Code (usually within 24 hours), please overwrite the Serial Code with the Activation Code (either in your file QQlicCode.txt or via the Excel license dialogue). 

Please check the spam filter of your mailbox, if the Activation Code does not arrive within 2 business days in your inbox. Your spam filter may have blocked the mail.

back

 

 

This is a legal agreement between you (either an individual or an entity) and {QuantQraft}.

By installing the software you received from {QuantQraft} or from an e-commerce retail partner of {QuantQraft}, you are agreeing to be bound by the terms of this Agreement.

1. GRANT OF LICENSE TO USE. The {QuantQraft} product that accompanies this license is referred to herein as "SOFTWARE." {QuantQraft} grants to you as an individual, a personal, non-exclusive license to use the SOFTWARE within your Microsoft Excel application. {QuantQraft} grants to you the limited right to use only one copy of the SOFTWARE on a single computer in the manner set forth in this agreement. If you are an entity, {QuantQraft} grants you the right to designate one individual within your organization to have the right to use the SOFTWARE in the manner provided above. {QuantQraft} reserves all rights not expressly granted.

1a. EVALUATION or TRIAL VERSIONS. If the SOFTWARE is licensed as an evaluation version or trial version, the following also applies. The license is valid for thirty (30) days after acceptance of the agreement.

Any applications you produce using the SOFTWARE may only be used for testing and evaluation purposes and may not be redistributed.

2. COPYRIGHT. The SOFTWARE is owned by {QuantQraft}, or its eCommerce retail partner, and is protected by national copyright laws as well as international treaty provisions.

3. OTHER RESTRICTIONS. You may not sublicense, rent or lease the SOFTWARE, but you may transfer the SOFTWARE and accompanying written materials on a permanent basis, provided you retain no copies in your possession and the recipient agrees to the terms of this Agreement. You may not reverse-engineer, decompile, or disassemble the SOFTWARE.

4. OWNERSHIP OF SOFTWARE. You own the magnetic or other physical media on which the SOFTWARE is recorded. However, {QuantQraft} retains title and ownership of the SOFTWARE recorded on the original disk and all subsequent copies of the SOFTWARE, regardless of the form or media in or on which the original and other copies exist. The SOFTWARE is licensed, not sold.

5. LIMITED WARRANTY. THE SOFTWARE AND ACCOMPANYING WRITTEN MATERIALS (INCLUDING INSTRUCTIONS FOR USE) ARE PROVIDED "AS IS". {QuantQraft} warrants that the SOFTWARE will perform substantially in accordance with the accompanying written material. {QuantQraft} does not warrant uninterrupted or error-free operation of the SOFTWARE. The warranty period for the SOFTWARE expires sixty days after the purchase.

NO WARRANTIES. {QUANTQRAFT} EXPRESSLY DISCLAIMS ANY WARRANTY FOR THE SOFTWARE. THE SOFTWARE AND ANY RELATED DOCUMENTATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OR MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK ARISING OUT OF USE OR PERFORMANCE OF THE SOFTWARE REMAINS WITH YOU. NEITHER {QUANTQRAFT} NOR ANYONE ELSE WHO HAS BEEN INVOLVED IN THE CREATION, PRODUCTION OR DELIVERY OF THE SOFTWARE SHALL BE LIABLE UNDER ANY LEGAL THEORY FOR ANY INDIRECT, CONSEQUENTIAL OR INCIDENTAL DAMAGES (INCLUDING DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS LOSSES, BUSINESS INTERRUPTION, LOSS OF GOODWILL) ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE, OR ANY OTHER CLAIM BY ANY PARTY EVEN IF {QUANTQRAFT} HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. NO LIABILITY FOR CONSEQUENTIAL DAMAGES. YOU AGREE TO INDEMNIFY AND HOLD {QUANTQRAFT} HARMLESS FROM AND AGAINST ANY CLAIMS, DAMAGES, OR LOSS YOU MAY SUFFER RESULTING FROM ANY CLAIMS BY END USERS OF THE SOFTWARE OR OF ANY WORK OR OF ANY APPLICATION CONTAINING THE SOFTWARE OR ANY WORK, FOR ANY REASON WHATSOEVER, INCLUDING ANY INDIRECT, CONSEQUENTIAL OR INCIDENTAL DAMAGES (INCLUDING DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION, OR ANY OTHER PECUNIARY LOSS) ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE, OR ANY OTHER CLAIM BY ANY PARTY EVEN IF {QUANTQRAFT} HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Because some states/jurisdictions do not allow the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you.

CUSTOMER REMEDIES. The entire liability of {QuantQraft} and your exclusive remedy shall not exceed the price you paid for the SOFTWARE.

6. GENERAL. If any provision of this Agreement is found to be unlawful, void or unenforceable in your jurisdiction, then that provision shall be severed from this Agreement and shall not affect the validity and enforceability of any of the remaining provisions.

 back

 

 

 

{QuantQraft} will never sell, trade, rent, share or otherwise make available your e-mail address, contact details or personal information to third parties, except to comply with subpoena or search warrants.

When you decide to purchase a {QuantQraft} product, the purchase is processed by one of our e-commerce retail partners and payment processors, which are located in the US or the European Union, like Plimus.com, through an encrypted connection (Secure Socket Layer SSL protocol). Your credit card or Paypal account details will not be revealed to {QuantQraft} or to any other party but the e-commerce retail partner that processes the payment.

This website contains links to other sites such as Wikipedia or Amazon. Please be aware that {QuantQraft} is not responsible for the privacy practices of other websites.

 back

 

 

 

Excel functions each fall in one of two categories, if one uses the dimension of their output as the criterion:

1. functions whose result is a single value
2. functions whose result consists of an entire matrix, a vector or an array of values: array formulas

The result of a single-valued function can be displayed in a single worksheet cell, whereas a multiple-valued output must be arranged in a rectangular cell range, one value per cell, as we  cannot simply stack the values one on top of the other in a single cell, to make the result visible and workable for the user.

However, we cannot simply copy the formula to the other cells in the worksheet range. Excel would not understand that the functions in adjacent cells are components of a single array and would calculate them as though they are independent from each other - unless we tell Excel to treat all the cells in the range we select for the output as a coherent rectangular array: a matrix.

We do this by finishing the formula input with a somewhat awkward key combination.

1. First, enter the function that is to return an array of values in the top-left corner cell of the output range.
2. While your cursor is still positioned in this corner cell, expand the selection to encompass the entire output range, by holding down the left mouse button while dragging the cursor down and to the right.
3. While the top-left corner cell is still highlighted, hold down <Ctrl> and <Shift> and then hit <Enter >. The formula in the corner cell will be copied to all other cells in the selected range and Excel will display the calculation results: not the same value in each cell, as if the formulas were independent, but a different element of the output matrix in each cell. Excel will envelop your formula in curly brackets, { and }.

This key combination <Ctrl> + <Shift> + <Enter> is the (only) method to advise Excel to interpret a function result as a matrix, or data array, that needs to be displayed over a rectangular cell range rather than in a single cell.

Do not try to envelop your cell formula in curly brackets, { and } , by using the keys on your keyboard - Excel would not understand your intention and reply with an error message.

Built-in Excel array functions that require the key combination <Ctrl> + <Shift> + <Enter> are, for instance, MMULT, MINVERSE and TRANSPOSE.

 

The {QuantQraft} taskpane offers the button 'Make Array', which converts the 'normal' Excel formula under your cursor to an array formula and expands so that it covers the entire cell range needed to display the output array. Thus, it reliefs you from the burden to manually select a cell range of the right size for the array formula and then to press <Ctrl> + <Shift> + <Enter>.
1. Menu {QuantQraft - QQmatrix} : click the button 'Taskpane' to display the QQmatrix taskpane to the right of the Excel application window.
2. Then place the cursor in the cell that contains the {QQmatrix} function. The function argument 'Dimension' must have the value 1 to make use of 'Make Array'.
3. If the output range already contains an Excel array formula, activate the 'Overwrite' option before you click 'Make Array', so that the existing array can be changed/overwritten.
4. Click the 'Make Array' button. Note that cell contents in the target range will be overwritten by the array formula.

 

back

 

 

Yes.

We offer the following volume discounts for all {QuantQraft} software products:

• 2 - 5 licenses - 10%
• 6 - 10 licenses - 15%
• 11 - 20 licenses - 20%
• more than 20 licenses - 30%

 

We also offer coupons that grant a discount (in addition to any volume discounts) to reference customers:

• If you order the {QuantQraft} product on behalf of an academic institution, company or government agency;
• if the e-mail address you use for your order is registered with your organization (as opposed to an anonymous, free e-mail provider such as @yahoo.com, @live.com or @gmail.com);
• and if you allow us to mention the name of your organization as one of our customers on www.quantqraft.biz,

we would be happy to quote a reduced price for the {QuantQraft} product you are interested in.

back

 

 

Yes.

The activation process locks the license to a single PC or notebook. This is to prevent software piracy: unlimited, unlicensed distribution.

Customers known to us (normally through their e-mail address) can re-install the {QuantQraft} software on a new machine, send us the serial number and new machine ID and ask for a fresh activation code. Installation on new machines should be limited to a reasonable number of occurrences, though (e.g., not as many as 4 or 5 installations on new machines within a few months).

back

 

For its built-in Excel functions, Microsoft offers the feature of function tooltips, which pop up as soon as the user starts to enter the function name in a cell. Such a tooltip displays the names of the function arguments. The tooltips are triggered by a Microsoft feature called IntelliSense.

 

Unfortunately, Microsoft does not yet offer any programmatic "hook" that would make possible the use of IntelliSense for Excel add-in functions.

{QuantQraft} add-ins offer two alternatives to the missing IntelliSense feature. These alternativew also display information about the function and its arguments to the user when a function is being entered:

1. The key combination <Ctrl> + <Shift> + <A>
2. The {QuantQraft} taskpanes.

Enter the 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. Continue typing, by entering values for the arguments.

 

 

The {QuantQraft} taskpane is a user interface panel that is docked to the right side of the Excel application window. The user can hide, close and re-open it via the 'Taskpane' button in the Excel ribbontab or commandbar.

The taskpane offers information about {QQmatrix} and its worksheets functions, e.g. about the function syntax and each
argument.
It automatically shows function-related explanations if it recognizes a {QQmatrix} function name in the cell beneath your cursor.
Alternatively, you can select the name of any function from the dropdown list in the taskpane, irrespective of the selected worksheet cell..

Click the 'Function Wizard' button to display Excel's 'Insert Function' dialogue.
If your cursor is in a cell that already contains a function - whether a built-in Excel function such as =SUM() or a {QuantQraft} function
such as =QQmEigen() - the wizard will offer a window in which you can enter values for the function arguments.
If the cell does not contain a function, select a category - like 'QQ Matrix', 'QQ Vector', 'QQ Scalar' - and then choose the function
you want to insert in the active worksheet cell.

Use the 'Make Array' button to convert and expand a 'normal' function in the cell beneath your cursor to an Excel array formula.
If the target range already contains an Excel array formula, activate the 'Overwrite' option to allow {QQmatrix} to change its formulas.

The taskpane can be displayed or hidden by clicking the 'Taskpane' button in the {QQmatrix} ribbon/commandbar.

 

 

 

 

back