Compile Error in Hidden Module frmGetRange When using any tool in Quantum XL, SPC XL, or DOE Pro that uses Excel’s refEdit control, the user receives an error starting with “Compile error in hidden module: frmGetRange” Solution – Disable Safe Mode in ActiveX Settings Please consult your IT department before making these changes From Excel […] The post Support – Compile in Hidden Module frmGetRange appeared first on SigmaZone.| SigmaZone
File format or File Extension is not Valid While the “file format or file extension is not valid” error is typical, some users have also reported the error “QuantumXLAddIn.xlam is not a valid add-in” or a Windows Security Popup “Action Blocked: Your administrator caused Windows Security to block this action. Contact your help desk” which has the […] The post Support – File Format or Extension Not Valid appeared first on SigmaZone.| SigmaZone
Step 1: Office Repair Microsoft has excellent instructions for how to repair Microsoft Office. They can be found at the url https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b or by clicking the button below. If these instructions resolve your issue, then there is no need to proceed further. Microsoft’s Instructions To Repair Office Step 2: Office Reinstall If repairing Office doesn’t […] The post Excel Repair and Reinstall appe...| SigmaZone
Symptom: When using DOE Pro (all builds), Excel stops working or crashes when creating a design, running regression, optimizing or plotting. Cause: Office 365 version 2012 and 2102 are incompatible with some Excel 4 Macro code. Solution: Download latest installer of DOE Pro from the Update Page. v2101 build 13628.20274 Go To Updates Page Some […] The post DOE Pro Stops Unexpectedly appeared first on SigmaZone.| SigmaZone
I have had many requests to explain the math behind the statistics in the article Roger Clemens and a Hypothesis Test. The math is usually handled by software packages, but in the interest of completeness I will explain the calculation in more detail. A t-Test provides the probability of making a Type I error (getting […] The post Calculating Type I Probability appeared first on SigmaZone.| SigmaZone
Owners of Quantum XL 2013 recieve a discount when purchasing Quantum XL 2016. For more information contact sales@sigmazone.com. To use your discount code, go to the Quantum XL Purchase page and click “Buy Now”. You will be taken to our eCommerce Partner’s website MyCommerce (see the image below). First, adjust the quantity then click “Order Now”. […] The post Support – How To Use A Coupon Code When Purchasing Quantum XL appeared first on SigmaZone.| SigmaZone
How to launch Quantum XL, SPC XL, DOE Pro XL, or Snapsheets XL This support article explains how to start an Add-In independently from Excel. If you would like Quantum XL or SPC XL to start each time Excel starts, then please see these articles. – Auto-start Quantum XL– Auto-start SPC XL Instructions for Quantum […] The post Support – How to Start SigmaZone’s Excel Add-Ins appeared first on SigmaZone.| SigmaZone
A commonly asked question is “Where do I find my serial number”? Your serial number (also called a CD Key) is very important. We, like most software companies, keep track of legal users by using this key. Method #1: If you still have the software installed, select “About” from the product’s menu. The serial number […]| SigmaZone