Sorting Data

[ag162]

Hello,
Here is my situation. I'm attempting to save a lot of time here.
I have an Customer Excel form for my reports and I have to type my data in manually. Ok, instead of printing to .rtf and typing from each report, I sent my data to data page and now, I want to take the data from the data values page and copy and paiste into the excel form. My only problem is that I don't know how to change the format. My Excel form has the qty from left to right and the values going down.

Part # 1 2 3 4 etc
X
Y
Z

X
Y
Z

Data page gives the following:
1 X Y Z X Y Z X Y Z
2
3
4

I've created a blank excel page, pasted my data from data page and now I need the data sorted as above. Does anyone have any ideas???????

Thanks in Advance,
A.Gore

[T Miller]

You could record a macro and then you would only have to do it once then run macro..just an idea

[ag162]

Ok,
sounds good,,,,but I don't know s##it about macros. lol I need an example.

A.Gore

[Matthew D. Hoedeman]

MAN, you are REALLY going about it the HARD WAY!

Copy the dat, then click:

EDIT
PASTE SPECIAL
Mark the TRANSPOSE box.

OR

In Datapage, change the report 'direction'. You can have the columns DATE or VARIABLE

[ag162]

Many thanks Matt!!!! You deserve a cold brew!

A.Gore

[ag162]

Is there a way that data page will show just the deviation amounts instead of the measured values?

A.Gore

[Matthew D. Hoedeman]

Is there a way that data page will show just the deviation amounts instead of the measured values?

A.Gore

YEP! Open Datapage, go to OPTIONS ~ DATA REPORT OPTIONS and mark DEVIATION instead of DATA VALUE.

[david phillips]

Open Datapage Editor

Select Parts to Edit
Click on Part #

Window will pop up with Left column in alpha Numeric order of dimensions
2nd column will be blank
3rd column will be Nominal

in the 2nd Column I type in a description of the dimension
Most of the time I Copy the Name of the features in the CMM Program
then Copy and Paste the same into column 2

When completed EDIT>Save

Variable Sets
If Dimension order needs to be changed from the CMM Program Measured order
View>Variable Sets
Click on Part #
Variable Set Drop Down Meas_Order
Variable Set List Field will Show Dimensions in Measured Order
Variable List Field will be in alpha numeric Order

Click on New
Type name of new file

Variable Set List Field will be Blank
By clicking on dimensions in Variable List
Click on left Arrow
keep doing this till features you want to report are all in Variable Set list
Click on Save
Close window
Close DataPage Editor



Open DATAPAGE for Windows RT
Options>System Options
Delimiter to Use when saving reports to a file: COMMA
Save>apply>Close
Reports>Spreadsheet Report
Part drop down scroll to Part #
Variable Set Drop down Scroll to "Inspection" or what it was named in the Variable Set
Transactions Click on Parts to be reported
Click ok
Reports>Variable Alias Report
Click ok

File>Save to File>Save Current Report
File name field, name file " " alias.txt
Drives>location to save file
close alias report
File>Save to File>Save Current Report
File name field, name file " " data.txt
Drives>location to save file
close spreadsheet Report

IMPORTING Data into excel
Start excel
open inspection sheet
Click on Datapage spreadsheet tab

Data>Import External Data>Import Data
follow path to saved " "data.txt

Text import wizard step 1 of 3
Click "Delimited"
File origin: 437: Oem United states
Next
Step 2 of 3 Delimiters
Click on COMMA
if any others are checked: UNCHECK them
Next
Step 3 of 3
Finish

click on Row # for column header
Data>Filter> Auto Filter



IMPORTING Alias Data into excel
Click on Datapage Variable alias tab

Data>Import External Data>Import Data
follow path to saved " "alias.txt

Text import wizard step 1 of 3
Click "Delimited"
File origin: 437: Oem United states
Next
Step 2 of 3 Delimiters
Click on COMMA
if any others are checked: UNCHECK them
Next
Step 3 of 3
Finish

If Ø is used Variable description list it will show up as ≠
just use edit replace


COPING alias description and dimension list to inspection sheet

Copy Dimension Alias
click on Page1 tab
Click on upper left cell in Description
edit>paste>special>Values

Do the same for Dimensions


Data input to inspection sheet

Click on Datapage spread sheet Tab
find stats count head drop down
Click on down arrow scroll to 1st part #
Copy nominal, tolerances and measured data

click on Page1 tab
click on top blank nominal cell
Edit>Paste>Paste Special>Values
repeat as necessary

[ag162]

Wow!!! Thanks David and Matt. I will work on this. Thanks again for the information.

A.Gore