ULR - Unlimited Learning Resources
HOME PRODUCTS ORDER ABOUT US
RELATED INFORMATION

Other Six Sigma products
Six Sigma Suite

RELATED PRODUCTS
Becoming Lean

Acheiving Excelence

Corrective Action

 

Green Belt XL FAQ

An Excel based Six Sigma product that combines the power of SPC analysis and Management tools with the simplicity of Microsoft© Excel.An Excel based Six Sigma product that combines the power of SPC analysis and Management tools with the simplicity of Microsoft© Excel.Green Belt XL can be used by Six

Installation:

Installation Problems:

Errors:

    I am using Excel 97. How do I install Green Belt XL?

      After you have downloaded the software, you will want to launch Excel and select the Add-Ins option from the Tools menu. Select the Green Belt XL option from the list and then select OK. The Green Belt XL icons
      ( and ) should be visible on the toolbar, and Green Belt XL should be available from the Excel Tools menu.

    I am using Excel 2000/XP. How do I install Green Belt XL?

      In Excel 2000 and XP, the Green Belt XL icons ( and ) should be visible on the toolbar, and Green Belt XL should be available from the Excel Tools menu.

    I am using Excel 97 and Green Belt XL is not shown in the list of Add-Ins. Now what?

      If Green Belt XL is not shown in the list, select the Browse button in the Add-Ins dialog box. Navigate to the installed directory (default is C:\Program Files\Green Belt XL), then select the ExcelSPC.xla file.

    I am using Excel 2000/XP and I do not have COM Add-Ins in my Tools menu. How can I add this option?

      If COM Add-Ins is not shown, select Customize from the Tools menu. In the Commands tab, select Tools from the list of Categories on the left. Scroll then select the COM Add-Ins option from the list at the right. Drag the selection to Excel's Tools menu (within the application workspace, not the dialog box), then drop it in a convenient spot on the list.

    The Create SPC Chart icon is not visible on the toolbar; however, the Create SPC Chart option is available on the Tools menu. What should I do?

      Ensure that Excel's Standard toolbar is turned on. In Excel, select Customize from the Tools menu. In the Toolbars tab, Standard should be checked. If this is not the problem, the Reset button on the Toolbar tab has been selected and the icons will not be shown. The icons should reappear when Excel is reopened.

    The Create SPC Chart icon is not visible on the toolbar AND the Create SPC Chart option is not available on the Tools menu. I am using Excel 97. What should I do?

      Ensure that the Green Belt XL software has been installed. If the installation was successful, Select the Add-Ins option from the Tools menu. Select the Green Belt XL option from the list. If Green Belt XL is not shown in the list, select the Browse button in the Add-Ins dialog box. Navigate to the installed directory (default is C:\Program Files\Green Belt XL), then select the ExcelSPC.xla file.

    The Create SPC Chart icon is not visible on the toolbar AND the Create SPC Chart option is not available on the Tools menu. I am using Excel 2000/XP. What should I do?

      Ensure that the Green Belt XL software has been installed. Select the COM Add-Ins option from the Tools menu. (Note that this is a different selection from the Add-Ins option). Select the Green Belt XL option from the list. If Green Belt XL is not shown in the list, select the Add button in the COM Add-Ins dialog box. Navigate to the installed directory (default is C:\Program Files\Green Belt XL), then select the ExcelSPC.dll file.

    After selecting the file from the Add-Ins box, I get an error that says, "Excel has caused an error in ExcelSPC.dll." How do I fix this?

    After selecting the file from the Add-Ins box, I get an error that says, "Invalid Page Fault." How do I fix this?

    I am getting an EXCEL.EXE Print Preview error. Is there a way to fix this?

      This error is usually encountered due to a conflict with certain printer drivers and an OffscreenBuffer. One work around might be to make the graph smaller so that it will easily fit on a single page. We have also discovered that there is a way to turn off that buffer and it resolves this error in most cases, but you must manually add in a new registry key and a string value that is = to True. If you are not familiar with the Windows registry we recommend you consult someone who is before attempting this. You can do serious damage to your windows installation by altering things in there without advanced knowledge of the Windows registry.

      • Click Start, select Run, enter "regedit" (without the quotes) and click OK.

      • On the left hand "explorer view" navigate to HKEY_CURRENT_USER\Software\Quality America, Inc.\SPC IV Excel.

      • Right-click on the folder and choose New\String Value. This will create a new entry in the right panel.

      • The default name is "New Value #1." Change that to NOB and press Enter.

      • Right-click on the NOB key and choose Modify. In the Value data: field type "True" without the quotes and click OK.

      • Close and exit regedit.

    See Also:
    SPC-PC IV (The Ultimate Desktop SPC Package) -- A powerful, easy to use analysis and reporting tool that can import and interpret data from a variety of sources. Data may be stored in .qdb spreadsheet files or any ODBC-compliant database or spreadsheet (such as Excel).
    eNet SPC (Global and intra-company connectivity) -- A web-based SPC software providing an optimal solution for distributing information to your customer-base, your supplier-chain, or your representatives in the field, requiring only a browser!
    QA-ActiveSPC (The Custom Solution) -- An ActiveX Development tool allows easy integration of custom SPC features into your existing software
    Shop Floor Pro (Real time Analysis for process improvement) -- Designed specifically for shop floor use, featuring ease of real-time data entry with or without gages
    Six Sigma Software Suite
    Six Sigma Books & Training Materials