The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
UL - Underwriters Laboratories - Health Sciences
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

Excel files for DOE (Design of Experiments)


Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Sponsor Links




Courtesy Quick Links


Links that Cove visitors will find useful in your quest for knowledge:

International Standards Bodies - World Wide Standards Bodies

ASQ - American Society for Quality

International Standards Organization - ISO Standards and Information

Howard's
International Quality Services


Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum


Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining


Ajit Basrur
Claritas Consulting, LLC


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Some Related Topic Tags (Not all threads are Tagged)
design of experiments (doe), microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 4.00 average. Display Modes
  Post Number #1  
Old 16th March 2010, 03:28 AM
MAGESHAKUMAR

 
 
Total Posts: 1
Please Help! Excel files for DOE (Design of Experiments)

If any body have DOE in excel please provide me.

Sponsored Links
  Post Number #2  
Old 16th March 2010, 07:04 AM
Miner's Avatar
Miner

 
 
Total Posts: 3,983
Re: DOE - Design of Experiments - Shainin

Try the search function in the blue menu bar above. I have seen 1 or 2 DOE files in Excel in this forum, but they are very limited to a few basic full factorial designs. DOEs by nature are highly variable in structure, so you will not find much in the way of an Excel file. You really need specialized software.
Thanks to Miner for your informative Post and/or Attachment!
Sponsored Links

  Post Number #3  
Old 25th August 2010, 04:39 AM
Ingo1966's Avatar
Ingo1966

 
 
Total Posts: 42
Re: Excel files for DOE?

Hello,

I use MiniTab for DoE Calculation. But in my Training Classes I also show some Excel Files which give the Participant a better picture how these Test Matrices can be analysed.

Hope it helps

Last edited by Ingo1966; 27th August 2010 at 03:56 AM.
Thank You to Ingo1966 for your informative Post and/or Attachment!
  Post Number #4  
Old 18th September 2011, 04:37 AM
Ingo1966's Avatar
Ingo1966

 
 
Total Posts: 42
Re: Excel files for DOE?

I have forgotten to attache an Excel Example.

Here is one Example of a D-Optimal 3 Factors on 3 Level in 15 runs with simulated data's.

I have other DoE Excel Examples for teaching purposes:
If someone is intrested don't hesitate to contact me.
My Excel Files are free for use.

Standard Yates L8 --> 3 Factors and 4 Factors
Simple L9 --> 2 Factors on 3 Level
CCD --> 3 Factors 3 level in 15 runs
Box Behnken Design --> 4 Factors 3 Level in 27 runs
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls D_Optimal.xls (175.0 KB, 776 views)
Thank You to Ingo1966 for your informative Post and/or Attachment!
  Post Number #5  
Old 12th August 2014, 09:05 AM
Quentos

 
 
Total Posts: 1
Re: Excel files for DOE (Design of Experiments)?

Hi,

My Name is quentos, am really ineterested in some of your Excel Add-in for design of Experiment data Analysis and planning.

Wishing u a speedy recovery from your eye surgery.

Quentos
  Post Number #6  
Old 30th November 2016, 03:02 AM
shiv47

 
 
Total Posts: 1
Re: Excel files for DOE?

Can You share DoE Templates for easy use in Excel?
1. Standard Yates L8 --> 3 Factors and 4 Factors
2. Simple L9 --> 2 Factors on 3 Level
3. CCD --> 3 Factors 3 level in 15 runs
4. Box Behnken Design --> 4 Factors 3 Level in 27 runs
  Post Number #7  
Old 1st December 2016, 02:08 PM
Ingo1966's Avatar
Ingo1966

 
 
Total Posts: 42
Re: Excel files for DOE?

attached some Excel DoE but I strongly recommend statistical Software for application. The Excel Files are only for teaching purposes.
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls Box_Behnken_V2.xls (198.0 KB, 42 views)
File Type: xls Central Composite.xls (318.5 KB, 36 views)
File Type: xls L8_4Factors.xls (188.0 KB, 42 views)
Thank You to Ingo1966 for your informative Post and/or Attachment!
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

Bookmarks



Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Emoticons are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
SPC data from multiple Excel files Excel_Enthusiast Statistical Analysis Tools, Techniques and SPC 5 23rd July 2014 08:56 AM
Taguchi L4 Orthogonal Array Design of Experiments (DOE) in an Excel spreadsheet mlaurie Excel .xls Spreadsheet Templates and Tools 3 26th February 2013 03:08 PM
Excellent Reference for MS Excel .xls files Ashok GS Excel .xls Spreadsheet Templates and Tools 9 13th April 2010 01:12 PM
Gage R&R .xls spreadsheet in Excel that allows you to set up experiments Dave W 2005 Excel .xls Spreadsheet Templates and Tools 9 9th May 2007 02:03 AM
Exporting Ford's 'FMEA Plus' Files to Excel chrissramey Excel .xls Spreadsheet Templates and Tools 13 5th July 2002 03:26 PM



The time now is 06:04 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


 
 


NOTE: This forum uses "Cookies" - A Peachfarm Internet Property