Support Menu
• Online Training / e-Learning
• Project Tracking (TRACtion®)
• Data Analysis Software (Engine Room)
• General Inquiry
• FAQ's

Contact Information
MoreSteam.com
596 Enterprise Dr. Suite B
Lewis Center, OH 43035
Tel: 614.310.1080
Fax: 614.310.1083
Support@MoreSteam.com

Posting Guidelines
If you have a question / issue with a part of the course material please let us know:
1)The name of the course you are taking. “Six Sigma Black Belt”
2)The location in the course related to your questions / issue. “Session 7, Lesson 4 Confidence Intervals”
3)Is your question / issue on:
a.The course page
b.A right hand margin link (specify the link name)
c.Quiz question (specify the number)
d.Practice question (specify the number)
e.Template (specify the name)

















Frequently Asked Questions
Search FAQ's
Keyword or Phrase:
• I am interested in the Six Sigma Black Belt training. Do I have to go through Yellow or Green Belt training first?
MoreSteam.com's Six Sigma Black Belt course includes all of the Yellow Belt and Green Belt content so you can just start with the Black Belt course.
• How long does the Six Sigma Black Belt course take?
You can start the course at any time and can take up to a year to finish the approximate 135 hours of coursework at your own pace.
• How long does the Green Belt course take?
You can start the course at any time and can take up to nine months to finish the approximate 80 hours of coursework at your own pace
• I am researching Six Sigma Green Belt Programs and came across MoreSteam.com's courses. Can you send me a brochure listing your courses?
We don't have brochures as with our course offerings, everything is online. You can find our Course Catalog at: http://www.moresteam.com/university/. Select a course from the drop down list in the Course Catalog, and click on the "Product Overview" to the right for detailed course descriptions.
• Is it possible to have the beginning portion of the Black Belt course presented in a non-English language when enrolling in a Black Belt course?
Yes. The Yellow Belt course, which is a subset of the Six Sigma Black Belt course, is available in Spanish, Portuguese, Italian, French, German and Chinese. We can include any of these languages as the introductory portion of the English-language Six Sigma Black Belt (all for the same Six Sigma Black Belt price).
• Can MoreSteam.com certify me when I finish the Six Sigma Black Belt course?
Yes, but the certification process is in addition to course completion. Participants in the online Six Sigma Black Belt Course may apply for Black Belt certification based upon detailed review of a successful Six Sigma improvement project. Details on certification requirements and costs can be found in the MoreSteam University course catalog at: http://www.moresteam.com/university/. Then select Black Belt Certification from the drop down list in the Course Catalog, and click on the "Product Overview" to the right for detailed information.
• Is certification also on-line?
Certification is based on our review of a successful project. Certification candidates submit project documentation, including evidence of mastery of the tools, and a description of actions taken as part of the project. If the submissions demonstrate mastery of the Six Sigma body of knowledge, then MoreSteam.com would certify the candidate
• I am getting ready to enroll in the online Green Belt course. I wanted to know if it is possible to receive an invoice that will allow me to get reimbursed from my company.
Sure, no problem. MoreSteam.com can invoice your company (if it is an established firm in the U.S. or Canada), or you can pay by credit card, and we'll send a receipt that you can use for reimbursement. In order for MoreSteam to issue an invoice, we first need to receive a purchase order from your company. The purchase order can be faxed with your order form.
• Does your on-line training work with a Mac? My Mac has all other required software such as Excel, Adobe Acrobat, etc.
Many Mac customers have used MoreSteam.com courses and materials without a problem, but we can't say "no problem" to everyone for sure. If you are unsure that your system will work with MoreSteam.com's delivery, we can sign you up for a free demonstration course so that you can check it out. If the demo works, you should be fine. We sometimes have Mac customers who have difficulty with downloadable Excel templates. They do not always operate fully on Apple products.
• I ultimately plan to take the ASQ Six Sigma Black Belt certification exam. Can you email me the course curriculum so I have a way to compare the course content to the ASQ body of knowledge?
You can find our course curriculum online at: http://www.moresteam.com/university/. Just click on the "Courses" link to the right, and select the Six Sigma Black Belt course from the drop down menu. . Many students take the MoreSteam.com Six Sigma Black Belt course to prepare for the ASQ certification. Our latest information is that students going through the MoreSteam.com course have a pass rate of about 80%.
• I have heard of Six Sigma Green Belt and Black Belt courses. But what is the Yellow Belt course? Is it a prerequisite for the Green belt course or not? Thanks.
The Yellow Belt course is not a prerequisite for any other course. The MoreSteam.com Yellow Belt is a 20 hour course oriented toward providing fundamental Six Sigma tools to team members.
• On the course materials listing, you state that the DOE software and book will be shipped within two weeks of starting the course. How quickly do the materials actually ship?
The DOE materials are usually shipped within a day, and take only a few days to arrive for shipping within the U.S.. They are used in Session 8 (out of 11 Sessions in the Black Belt course), so most individuals will have plenty of course work to keep busy until the materials arrive.
• I am looking for information on MoreSteam.com's foreign language courses. Can provide any more information about these offerings as I could not find pricing, etc. on your website.
The course outlines and pricing for the foreign language courses are the same as our English versions. You can find more info. at: http://www.moresteam.com/university/ just select the desired course from the course catalog and click on "Product Overview" or "Course Outline" to the right.
• Could you please send me start dates for the next Six Sigma Black Belt Course?
The course is asynchronous, meaning you can start at any time.
• What is "Lean" Six Sigma?
The "Lean" in "Lean Six Sigma" designates the addition of Lean Methods to the standard Six Sigma DMAIC framework and tool set. Lean methods focus on different process outputs, like cycle time or the flow of materials and information, whereas Six Sigma is generally focused on reducing variability and the incidence of defects. The two approaches work hand in hand, so many companies are combining them into "Lean Six Sigma".
• How is Engine Room delivered?
The delivery is by download of the 30 day trial version. If you decide to extend the license, then we'll give you a website and password to unlock the trial copy and make it permanent. If you want to get started with a no obligation trial, download the trial version at http://www.moresteam.com/engineroom.
• How do I get the latest version of Engine Room?
To upgrade to the latest version of Engine Room for Excel 2002, XP and 2003, click here and select "save" to download the file (make sure pop-up blocking is disabled in your browser). Save to your desktop, close Excel and double-click the file.

Click here for the latest upgrade version of Engine Room for Excel 2007 and select "save" to download the file (make sure pop-up blocking is disabled in your browser). Save to your desktop, close Excel and double-click the file.

If you get the message, "The web page you are viewing is trying to close the window", trying holding down the "Ctrl" key while you click the link.

• Engine Room is slow to load
Engine Room will function if you have a computer that has below the minimum requirements for processor speed and memory. However, there will be a performace degredation.
• I received a message that the file "EngineRoomCustomFunctions.bas" is missing.
Right click here and select "save as" to download the file. Save it to the same location where Engine Room is installed.
• I received a message that the file "diamond.gif" is missing.
Right click here and select "save as" to download the file. Save it to the same location where Engine Room is installed.
• Where is Engine Room installed?
Engine Room is most likely installed in one of the five following paths (may not be in the "c:\" drive - depends on where Excel is installed):
  • C:\Windows\Application Data\Microsoft\AddIns
  • C:\Windows\Profiles\user name\Application Data\Microsoft\AddIns
  • C:\Winnt\Profiles\user name\Application Data\Microsoft\AddIns
  • C:\Documents and Settings\user name\Application Data\Microsoft\AddIns
  • C:\Users\user name\AppData\Roaming\Microsoft\AddIns
You will find a file called EngineRoom.xla (EngineRoom.xlam for Excel 2007) in the folder where Engine Room is installed.

Engine Room templates are stored in a location called ...AddIns\Templates\EngineRoom with the prefix to the location being the same as what you found in the list above.

• I get a message that states, "This copy of Engine Room® is licensed to {name and company} and will not be activated! Contact MoreSteam.com..."
This will happen under the following circumstances:
  • Office® is upgraded or reinstalled
  • Windows® is upgraded or reinstalled
  • Current PC is rebuilt
  • Old PC is replaced with new PC and is built with a "ghost" from old PC
If you used the same user name for the upgrade / reinstall as the original, do the following: (The "name" refers to the name that shows in the "Help About" dialog box for any Office® application under the section "This product is licensed to:")
  1. Open Excel®
  2. Select "Tools" and then "Add-Ins"
  3. Browse to the folder:
    c:\Documents and Settings\your name-id\Application Data\Microsoft\Addins
  4. select "EngineRoom.xla"
  5. Click "OK" to close the browse dialog
  6. Click "OK" to close the "Add-Ins" dialog
  7. Engine Room will install
If you did not use the same name, do the following:
  1. Search your PC for the following files:
    • EngineRoom.xla
    • EngineRoom.chm
    • EngineRoomCustomFunctions.bas
    • Userinfo.xls
    • Diamond.gif
  2. Note the folder that these files are located in
  3. Create a folder called "AddIns" (if it does not already exist) under the folder:
    c:\Documents and Settings\your name-id\Application Data\Microsoft
  4. Move the 5 files above to the "AddIns" folder
  5. Open Excel®
  6. Select "Tools" and then "AddIns"
  7. Click "Browse"
  8. Browse to the AddIns folder and
  9. select "EngineRoom.xla"
  10. Click "OK" to close the browse dialog
  11. Click "OK" to close the "Add-Ins" dialog
  12. Engine Room will install
If none of the above work, follow the instructions for this FAQ which describes how to uninstall and reinstall Engine Room®.
• The install program "freezes" during the installation process.
This will happen if Excel is not installed on your "c:\" drive or part of the installation file may be corrupted.
If you have WinZip, you can open the install file (EngineRoom.exe) with WinZip and manually extract the files:
  1. Close Excel
  2. Make sure the following folder exists on your PC: c:\documents and settings\application data\\microsoft\addins (create it if it doesn't), you may need to enable viewing of hidden folders in "My Documents" --> "Tools" --> "Folder Option..." --> "View" tab
  3. Open the EngineRoom.exe file with WinZip
  4. Click "Extract"
  5. Use the "tree" view to browse to the directory found using this FAQ (may not be on the "c:\" drive)
  6. Select "all files" to extract
  7. Select "overwrite existing files"
  8. Click "Extract"
  9. Open Excel
  10. Select "Tools" and then "Addins"
  11. Check "Engine Room" and click "OK"
• I want to uninstall Engine Room.
  1. Open Excel
  2. Uncheck Engine Room from the list of add-ins
    • Excel XP/2002/2003
      1. Select “Tools” and then “Add-ins”
      2. Uncheck “Engine Room”
      3. Click “OK”
    • Excel 2007
      1. Click the Office icon in the upper left corner
      2. Click “Excel Options”
      3. Click “Add Ins”
      4. Select “Manage: Excel Add-ins” and click “Go”
      5. Uncheck “Engine Room”
      6. Click "OK"
  3. Close Excel
  4. Search your entire PC for the "EngineRoom.xla" (Excel XP/2002/2003) or “EngineRoom.xlam” (Excel 2007). Be sure to enable viewing of hidden files*. It will be in one of the following locations depending on your operating system:
    • C:\Windows\Application Data\Microsoft\AddIns
    • C:\Windows\Profiles\user name\Application Data\Microsoft\AddIns
    • Windows NT: C:\Winnt\Profiles\user name\Application Data\Microsoft\AddIns
    • Windows XP: C:\Documents and Settings\user name\Application Data\Microsoft\AddIns
    • Windows Vista: C:\Users\user name\AppData\Roaming\Microsoft\AddIns
  5. Delete the following files in the folder where EngineRoom.xla/EngineRoom.xlam resides
    • EngineRoom.xla/EngineRoom.xlam (Engine Room add-in)
    • EngineRoom.chm (Help file)
    • userfile.xls/userinfo.xlsx (user information)
    • EngineRoomCustomFunctions.bas (custom functions for hypothesis testing)
    • diamond.gif (for dot plots)
  6. At the same level as the "AddIns" folder you found in 4), there will be a folder called "Templates". In that folder is a folder called "EngineRoom" which contains 35 Engine Room template files
  7. Delete the folder called "EngineRoom"

*To enable viewing of hidden files

Windows XP

  • Open “My Documents”
  • Select “Tools” and then “Folder Options…”
  • Select the “View” tab
  • Click the option called “Show hidden files and folders”
  • Click “OK”
Windows Vista
  • Open “Control Panel”
  • Click “Appearance and Personalization”
  • Click “Folder Options:
  • Click the option called “Show hidden files and folders”
  • Click “OK”
• I don't want Engine Room to load every time I open Excel.
Follow these steps to disable Engine Room:
  • Open Excel
  • Select Tools and then Add-Ins from the Excel menu
  • Deselect (uncheck) Engine Room on the list of add-ins
  • Click OK
  • To reactivate Engine Room, repeat Steps 1 and 2 and for Step 3, select (check) Engine Room on the list of add-ins
• Does Engine Room® work with Office 2000 (Excel version 9)?
Using Engine Room® with Excel version 9 will generate errors in SPC charts and Hypothesis Testing; specifically, out-of-control flags on SPC charts and output charts with hypothesis tests.

Click here to download a version of Engine Room® for Office 2000 / Excel version 9 which removes theses features to prevent errors from being generated. However, other errors may occur. If you have already installed the non-Office 2000 version, you will need to first uninstall Engine Room.

  1. Close Excel
  2. Follow the link above and "save" the file, EngineRoomOffice2000.exe, to your PC; do not select the "run" option
  3. Double-click the file
  4. Engine Room will install
MoreSteam.com does not support this version of Engine Room®.

If you upgrade your version of Excel, you may apply the latest Engine Room® upgrade available from this site.

• The control limits are incorrect for the U-chart in Engine Room.
This is corrected in Engine Room version 3.01. See the FAQ on downloading the latest version of Engine Room.
• I have not been able to download Engine Room and get a message from the website that states, "our records indicate that you have already downloaded Engine Room."
This most likely occurs because you forgot to turn off the pop-up blocker on your browser. Use this direct link to download the Engine Room installation program. Follow these directions:
  • Close Excel
  • Follow the link above and "save" the file, EngineRoom.exe, to your PC; do not select the "run" option
  • Double-click the file
  • Engine Room will install
• I rebuilt my PC and now Engine Room does not load.
You will need to uninstall and then reinstall Engine Room.

First, uninstall Engine Room. Next, download the Engine Room installation program. Follow these directions:

  1. Close Excel
  2. Follow the appropriate link below and "save" the file, EngineRoom.exe, to your PC; do not select the "run" option
  3. Double-click the file
  4. Engine Room will install
If you have already purchased Engine Room, send your Engine Room user ID (sent when you purchased Engine Room) and your key code to Trica Ryckman (tryckman@moresteam.com) and she will send back the unlock code. To get your key code:
  1. Open Excel
  2. Select "Engine Room" then "About Engine Room"
  3. Click "Yes"
  4. Click "Yes"
  5. Click "OK"
  6. Write down the key code
  7. Click "Cancel"
  8. Click "OK"
When you receive your unlock code, follow the above and enter the unlock code in the dialog box under the key code.
• The buttons on spreadsheets generated by Engine Room do not work.
The likely cause of this situation is the Excel macro security is set too high. The solutions is to set the macro security in Excel to "Medium" or lower:
  • Open Excel
  • Select "Tools" then "Macro" then "Security"
  • Change the setting to "Medium" or lower
• I cannot see the buttons on Engine Room generated spreadsheets: Affinity Diagram, CTQC Tree, Fishbone Diagram, Input Screening Report, and Monte Carlo Analysis.
This appears to be an issue with Microsoft Excel or the individual PC and is not related to Engine Room. At this time, the only solution is to run Engine Room on another PC. Other solutions are being investigated.
• How do I install the Excel Analysis Toolpak?
  • Open "Excel"
  • For Excel 2002/2003/XP: On the "Tools" menu, click "Add-Ins".
    For Excel 2007: Click the Office icon in the upper left, "Excel Options", "Add-ins", then "Go" next to "Manage Excel Add-ins"
  • In the "Add-Ins available box", select the check box next to "Analysis Toolpak". Tip: If Analysis Toolpak is not listed, click "Browse" to locate it.
  • In the "Add-Ins available" box, select the check box next to "Analysis Toolpak - VBA". Tip: If Analysis Toolpak - VBA is not listed, click "Browse" to locate it.
  • Click "OK".
  • If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click "Yes" to install it.
  • Follow the directions, you may need your Office installation CD.
  • See this Microsoft article for additional information.
  • Alternatively, enter "load analysis toolpak" in the Microsoft Excel Help search feature.
• If receive the error message "Your spreadsheet contains references to an invalid worksheet".
The error message, "Your spreadsheet contains references to an invalid worksheet" is believed to be a caused by a bug within the Microsoft VBA coding environment within which Engine Room was created. It does not affect the results of any Engine Room feature or function. While it has no impact on Engine Room features, the message can be usually be avoided by saving and closing workbooks from the Excel "File" menu rather than using the "X" in the upper right hand corner. Other possible solutions are:
  1. Use Excel's Detect and Repair feature. You may need the install CD. Open Excel and select "Help" and then "Detect and Repair..."
  2. Uninstall and reinstall Engine Room
    • Follow these instructions to uninstall Engine Room.
    • Do the following to install Engine Room.
      1. Close Excel
      2. Save this file to your desktop: http://www.moresteam.com/engineroom/l4/engineroom.exe
      3. Double-click the file
      4. Engine Room will install
• I get an error message in Engine Room or template that states, "Unable to set the Installed property of the add-in class". Or, I get an error using the Multiple Regression template that states, "Please save your work, exit, and reopen the file." What does this mean?
This error is caused by a problem with Microsoft Excel. The problem is recognized by the development community but not by Microsoft. So far, the cause of the error has not been determined. What appears to happen is that Excel 'forgets' that the Analysis ToolPak add-ins are installed and cannot find them. Here is a work-around that often resolves the issue:
  1. Open Excel.
  2. Select 'Tools' and then 'Add-ins'.
  3. Uncheck the Analysis ToolPak add-ins (should be two of them).
  4. Click 'OK'.
  5. Select 'Tools'and then 'Add-ins'again.
  6. Check the two Analysis ToolPak add-ins.
  7. Click 'OK'.
  8. Try the Engine Room feature or template that was causing the problem.
  9. If this does not work, try closing and reopening Excel between steps 4) and 5).
If this does not resolve the issues, please contact Engine Room support with answers to the following questions:
  1. What versions of Excel, Engine Room and Windows are you using?
  2. Have you installed any software or upgrades recently? If so, what?
  3. Have you uninstalled any software recently? If so, what?
  4. Have you had any computer viruses recently? If so, which ones?
  5. Do you have any other 3rd party Excel add-ins? If so, which ones?
  6. Do you use Citrix (or something similar) to run applications over your network? If so, which applications?
  7. Have you had any memory errors, blue-screens-of-death or any other hardware type problems? If so, what?
• I am using a feature of Engine Room that requires a data sheet. I identify my data sheet and enter my data but, when I try to access Engine Room, I get an error 1004: Method 'Range' of object '_Worksheet' failed.
This is most likely caused by inadvertently deleting a row of the data sheet or pasting data onto a part of the data sheet that caused the data sheet to be corrupted. Possible workaround:
  • Use Edit-->Paste Special-->Values to paste your data into the data sheet. Paste the header row separately.
  • Paste your data before you use Engine Room to identify your data sheet.
  • If you use Engine Room to create a blank data sheet, use Engine Room to re-identify the same data sheet after you paste your data.
• I am using Engine Room 2007. I get messages that templates have been moved or changed. I look in the templates installation folder that is identified when I click on "Installation Locations" in the Engine Room Help menu and the templates are there and have not been changed.
The most likely cause for this is that Excel 2007 has entered "compatibility mode" by opening a file from a previous version of Excel. Even if that file is closed, compatibility mode will cause problems with Engine Room. The work around is to close Excel 2007 and reopen and not open files from previous versions of Excel before using Engine Room.
• When I start Excel, I receive an error: "Compile Error in Hidden Module: DistMon".
DistMon is not part of Engine Room. This error most often occurs because of a problem with an Adobe Acrobat add-in. Please review this Microsoft Knowledgebase article for more information and a recommended resolution.
• How do I configure Internet Explorer to open Office documents in the appropriate Office program instead of in Internet Explorer?
Please refer to this Microsoft article which details how to make the necessary configuration changes.
• The audio on the course page has background noise: popping, crackling, static.
Make sure you have the latest version of Java for your browser. Also, reinstalling will replace any files that may be corrupt. Go to this web site to check your Java version and download the latest update.