Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Importing column properties for multiple columns from excel spreadsheet

Topic Options

- Start Article
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Importing column properties for multiple columns from excel spreadsheet

Oct 7, 2011 2:35 PM
(1602 views)

How do I import column properties for multiple columns of data from an excel spreadsheet? I'm looking at measurement data for a large number of manufactured features and need to calculatge process capability for each column of data where each column has a different LSL and USL. I have the measurement data and spec limits in an excel spreadsheet. I could manually enter spec limits for each column, but I'm sure there is an easier way to do this.

3 REPLIES 3

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Importing column properties for multiple columns from excel spreadsheet

The capability platform (under the graphs menu) allows you to import column specifications

-Dave

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Importing column properties for multiple columns from excel spreadsheet

I tried to import spec limits using the "Get Limits" option in the control charts dialog but it doesn't seem to work. The limits file looks to be properly formatted according to the information in JMP help, see the example below. I get an error (No matching columns in Limits File) and it immediately kicks me into a spec limits entry dialog.

Column 1 _LSL _Target _USL

testA 0 1

testB 2 3

The testA and testB values match column headings in the original table. I've tried spec limits files in both orientations to no avail.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Importing column properties for multiple columns from excel spreadsheet

With Control Charts, you may need to separate measures into individual columns.

Did you try using **Tables>Split** to reformat your spec limits?

**_LimitsKey A B**

---------- -- --

_LCL 0 2

_Avg

_UCL 1 3

This arrangement works for me.