The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page

Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Using Minitab Software
Forum Username


Elsmar Cove Forum Sidebar
Custom Search
Monitor the Elsmar Forum
Monitor New Forum Posts
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links







Donate and $ Contributor Forum Access
Sponsored Links
Courtesy Quick Links

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


Howard's
International Quality Services

Atul's
Symphony Technologies

Marcelo Antunes'
SQR Consulting

Bob Doering's
Correct SPC - Precision Machining


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest Portal

IEST - Institute of Environmental Sciences and Technology

ASQ - American Society for Quality


Related Topic Tags
minitab (statistical analysis software), macros (in spreadsheets and databases)
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 28th April 2008, 01:59 PM
cnorton4 cnorton4 is offline
Inactive Registered Visitor

 
Registration Date: Sep 2005
Location: USA
 
Posts: 1
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 32
Karma: 10
cnorton4 has less than 100 Karma points so far.
Please Help! How to write Minitab Macros

I've been trying to learn how to write MiniTab macros with a little success. My question is... Does anyone have a good resource for learning how to write macros in MiniTab? I've read all the available help from MiniTab help but it is very basic and not real detailed.

Sponsored Links
  #2  
Old 29th April 2008, 09:43 AM
Allattar Allattar is offline
Appreciated Member

 
Registration Date: Jan 2008
Location: UK
 
Posts: 225
Thanks Given to Others: 15
Thanked 163 Times in 107 Posts
Karma Power: 50
Karma: 3350
Allattar is appreciated, and has over 1700 Karma points.
Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.
Re: Minitab Macros

Heres a simple way to write a macro in Minitab.
Open Minitab and go to the Calc menu, find random data, and normal distribution.

Enter something like 100 rows, where it asks to store results type c1 (alternatively type a name for a column to be created), and give it an average of 10, standard deviation we can leave at 1.

Next go to the graph menu, find the histogram, choose one of the options, say with a distribution fit.
Enter the column with the random data into the histogram dialogue box and click ok.

This should create a simple histogram.

Find the project manager toolbar and look for the history folder. If you cant find the button for it press CTRL+ALT+H.

You should have the commands used to create the random data and the histogram saved here.

Copy these commands, and paste them into notepad.


Enter above those commands on line one GMACRO, on line 2 a name for your macro, and after those commands ENDMACRO.

It should look like this
GMACRO
MYFIRSTMACRO

Random 100 c1;
Normal 0.0 1.0.
Histogram C1;
YFrequency;
Bar.

ENDMACRO

Next save this file, make sure in notepad it is set to all files. If you dont do this notepad saves it as txt. Save the file in to the macro folder inside the Minitab directory. Make sure you save it there to make it easy to use.

Then go back to Minitab, in Minitab call up the command line editor using CTRL+L. In the command line editor type % and the name you saved your macro as.
eg:
%MYFIRSTMACRO
When you run the commands it should generate a column of random data and create a histogram.

Ok this is a very basic way of creating a macro, they can do more, but hopefully it provides a start.
Sponsored Links

  #3  
Old 17th June 2008, 10:08 PM
S Johnson S Johnson is offline
Involved in Discussions

 
Registration Date: Apr 2007
Location: Ft worth, TX USA
 
Posts: 35
Thanks Given to Others: 7
Thanked 12 Times in 5 Posts
Karma Power: 28
Karma: 174
S Johnson is appreciated, and has over 100 Karma points.S Johnson is appreciated, and has over 100 Karma points.
Re: Minitab Macros

I got a Minitab tutorial off of eBay and its pretty good. It was only $10 and I am learning stuff that SSBB in my office don't know how to do, such as macros. Just search on eBay for Minitab Tutorial Package. The seller is netscore (I guess I must include the boilerplate message that I am not the seller). Definitely worth $10. It won't make you an expert at Minitab macros, but it will get you started.
  #4  
Old 2nd February 2009, 12:59 AM
Juan Dude's Avatar
Juan Dude Juan Dude is offline
The Dude Abides

 
Registration Date: Oct 2008
 
Posts: 250
Thanks Given to Others: 277
Thanked 77 Times in 50 Posts
Karma Power: 46
Karma: 1294
Juan Dude is appreciated, and has over 1100 Karma points.Juan Dude is appreciated, and has over 1100 Karma points.Juan Dude is appreciated, and has over 1100 Karma points.Juan Dude is appreciated, and has over 1100 Karma points.Juan Dude is appreciated, and has over 1100 Karma points.Juan Dude is appreciated, and has over 1100 Karma points.Juan Dude is appreciated, and has over 1100 Karma points.Juan Dude is appreciated, and has over 1100 Karma points.Juan Dude is appreciated, and has over 1100 Karma points.
Re: How to write Minitab Macros

Hope this helps: http://users.stargate.net/~pmathews/...xecMacros.html
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Using Minitab Software

Do you find this discussion thread helpful and informational?


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
Smilies 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
Putting Data Macros in a Form Fields - Access 2010 sideoiler Quality Assurance and Compliance Software Tools / Solutions 5 25th March 2012 01:58 AM
Need to Create Macros so that it can copy data to the next row.... ominxs Excel .xls Spreadsheet Templates and Tools 5 13th August 2010 08:06 AM
To write or not to write. That is the question. How many procedures should I write? unitedc ISO 9000, ISO 9001, and ISO 9004 - Questions and Discussions 28 11th June 2009 01:02 PM
Excel tutorials for MACROs and VisualBasic priyal Excel .xls Spreadsheet Templates and Tools 9 6th July 2007 08:04 PM



The time now is 08:36 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272