SBS - The Best Value in QMS software

Is there a way to import Column Descriptions in Minitab?

Proud Liberal

Quite Involved in Discussions
#1
Is there a way to import column descriptions in Minitab? I originally had long column titles that I imported from Excel along with the data. Minitab then kindly truncated them to 32 characters. With over 60 columns of data, I don't want to enter this information manually into the column description form one column at a time.

Then, I want to print the description on any charts generated (nearly 500 with the data split by cavity).

Any ideas???
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
To my knowledge, you can only import the column name and data into Minitab. The Column Description must be typed in or pasted in individually.
 
A

allan-M

#4
Well, you mentioned macros...
Seems there might be, but it uses methods most of us probably don't brush up against very often

Check out the minitab help. Close to the bottom of the navigation tree there is a section for minitab automation

The sample code for setting a column commend has been pasted in below.

I don'y know how to do any of this, but it looks theoretically possible

__________________________________________
Create a Minitab Application object and add a Column object to the Columns collection of the active worksheet. Then define and populate the array "arrSales" with the column information, retrieve the Column object (MtbColumn), name it "Sales," and place the information in arrSales into the "Sales" column. Finally, set the Comment property of the new column.

Dim MtbApp As Mtb.Application
Dim MtbColumns As Mtb.Columns
Dim MtbColumn As Mtb.Column
Dim arrSales(1 To 8) As Double
arrSales(1) = 94
arrSales(2) = 99
arrSales(4) = 92
arrSales(5) = 106
arrSales(6) = 116
arrSales(7) = 113
arrSales(8) = 108

Set MtbApp = New Mtb.Application
Set MtbColumns = MtbApp.ActiveProject.ActiveWorksheet.Columns
Set MtbColumn = MtbColumns.Add(, , 1)

MtbColumn.Name = "Sales"
MtbColumn.SetData arrSales, 1, 8

MtbColumn.Comment = "Sales data for 1999"
 
Thread starter Similar threads Forum Replies Date
T Brexit Transition Arrangements & Import into the EU EU Medical Device Regulations 3
J Does Pakistan Medical Device Import License allows parallel import? Other Medical Device Regulations World-Wide 0
Q ISO 14001:2015 accredited but import most product - CB Raised minor NC on Life Cycle Perspective ISO 14001:2015 Specific Discussions 2
M Informational Commission Regulation (EU) 2019/319 of 6 February 2019 amending previous regulations as regards health certification at import into the Union concerni Medical Device and FDA Regulations and Standards News 0
JoshuaFroud Import of X-Ray emitting device into Chile Other Medical Device Regulations World-Wide 0
Ajit Basrur Any recommended courses to FDA and CBP Import Process? Other Medical Device Regulations World-Wide 0
Marc vBulletin to Xenforo Import Problem Reports 28180928 Elsmar Cove Forum Suggestions, Complaints, Problems and Bug Reports 25
A Brazil - Import Medical Device Spare Parts - Without license Other Medical Device Regulations World-Wide 5
H How to Import Medical Devices into the United States 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
W Connecting IndySoft MET/CAL Import Module to a Fluke MET/TEAM Calibration and Metrology Software and Hardware 1
J Lebanon Import Requirements Other Medical Device Regulations World-Wide 2
J US import requirements for bench testing without 510k Other US Medical Device Regulations 3
M Implications of an import detention Other US Medical Device Regulations 3
S Import of Medical Equipment into Cambodia Other Medical Device Regulations World-Wide 1
A Singapore - Requirements for Import of Medical Devices for Clinical Trial Other Medical Device Regulations World-Wide 2
pittmatj ANVISA Import Permit for Brazilian Customs Other Medical Device Regulations World-Wide 1
J Import of an Investigational Device from a Contract Manufacturer 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 9
G PPAP - Stock Fasteners - Import APQP and PPAP 7
P Import-Export of Medical Device components into the US 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 24
bio_subbu India CDSCO issues FAQ on Registration & Import of Medical Devices in India Other Medical Device Regulations World-Wide 0
AnaMariaVR2 FDA Puts Japanese Manufacturer on Import Alert after Disastrous Inspection US Food and Drug Administration (FDA) 1
M FSMA Regulations and Santa's Import Operation Funny Stuff - Jokes and Humour 4
bio_subbu CDSCO Issues final guidance documents on Registration & Import of Medical Devices Other Medical Device Regulations World-Wide 0
J SFDA Labeling Requirements prior to import to any Chinese territory China Medical Device Regulations 2
N Europe import Regulations? Customers are requesting us to sign OEM/ODM Agreements EU Medical Device Regulations 7
N Export & Import of Unapproved Device in USA for Service Purpose Only 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
S Import Requirements for Pill Cutter in India Other Medical Device Regulations World-Wide 3
G Transfer of Import Licenses - Medical Device Regulations in South Africa Other Medical Device Regulations World-Wide 5
L Do I need to have an Authorized Indian Agent to import Medical Devices into India? ISO 13485:2016 - Medical Device Quality Management Systems 5
T How to renew a certificate (Form 41) and an Import License (Form 10) in India? Other Medical Device Regulations World-Wide 2
P Import and Border Control of Medical Devices in various countries Other Medical Device Regulations World-Wide 1
bio_subbu CDSCO issues Guidance Document for Import & Registration of APIs, and Formulations Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 0
S Animal Origin and Human Origin Products Import Requirements Other Medical Device Regulations World-Wide 7
G New FDA Import Codes "Affirmations of Compliance" 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
J Does ITAR regulate the import of Raw Materials used in Machining AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
Y Certificate of Exportability (Section 802) - Import for Export Quality Assurance and Compliance Software Tools and Solutions 1
G Import to Export through a Distributor - Class II Medical Device 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
K Medical Device Import/Export Translation Requirements for each country EU Medical Device Regulations 25
P Import of medical devices to Brazil without registration possible ? Other Medical Device Regulations World-Wide 5
E Starting to write a Quality System Manual - Import/export medical devices - Need help ISO 13485:2016 - Medical Device Quality Management Systems 1
W GM to Import More Cars, UAW Angry World News 0
A Import Data Integrity Software Quality Assurance 2
5 CAR (Corrective Action Report) for low-buck import Nonconformance and Corrective Action 7
K Seeking sample quality objective(s) for IMPEX (Import / Export) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
W Flic barcode scanner - How to import into Microsoft Suite? Quality Assurance and Compliance Software Tools and Solutions 2
N How to find column number for the last non-empty column? Using Minitab Software 0
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
A PFMEA - How long should the recommended actions remain in the recommended actions column? APQP and PPAP 3
S How to fulfill PFMEA "requirement" column? FMEA and Control Plans 2
S FMEA column column ''therblig motion'' for a given potential failure FMEA and Control Plans 12

Similar threads

Top Bottom