L2 Plus Data Management

Managing data on L2 Plus series software for advanced force measurement.

L2 Plus Series Software for Advanced Force Measurement

Data Management

The Better Solution

Table of Contents

Page

data management

4 4 4 6 7 7 7 8

Printouts

13 14 14 15 17 18 19 20 21 21 21 21 21 21 22 22 22 22 22 22

6.0 6.1

6.4

Post Test Setup

Standard Reports

6.4.1

Export Raw Data Export Results

Graph Report Run Report Batch Report

6.1.1 6.1.2

6.4.1.1 6.4.1.2 6.4.1.3 6.4.1.4 6.4.1.5

File Locations

6.2

Metlogix Directory Runs Directory Archive Directory Exports Directory

Statistics Report Tolerance Report

6.2.1 6.2.2 6.2.3 6.2.4

Automatic Printouts On-demand Printouts

6.4.2 6.4.3 6.4.4

10 10 11 11 12 12 12 12

Exporting Data and Results

Printout Settings

6.3

Automatic Export

Print Report Header Print Column Headers

6.3.1 6.3.2

6.4.4.1 6.4.4.2 6.4.4.3 6.4.4.4 6.4.4.5 6.4.4.6 6.4.4.7 6.4.4.8 6.4.4.9 6.4.4.10

On-Demand Export (Share)

Export Results

Print Grid lines

6.3.2.1 6.3.2.2 6.3.2.3 6.3.2.4

Export to Clipboard

Print Header Logo Print Footer Logo

Export Image

Export Raw Data

Print User Name in Header Print Date/Time in Header Print Page Number if Footer Print Custom Text in Header Print Custom Text in Footer

starrett.com

6.0 Data Management Data management is the collecting and saving of data from your test runs and the reporting of result using printouts. L2 Plus Series software is designed to allow data to be managed easily. Files of raw data from a test run or files of your results are saved in a .csv format. This makes it easy to convert into Microsoft ® Excel ® , Word ® or Access ® for advanced data management and reporting, and the ability to interface your data and result into 3rd-party statistical process control applications. L2 Plus Series systems can save up to 100,000 rows of data for a test run. The maximum test run duration is 48 hours. This would include a cyclic test or a creep test. Therefore, the typical sampling rate for a 48 hour test is 5Hz. 6.1 Post Test Setup The Post Test stage has functions that may be used to manage your results and data: • Export Raw • Export Results • Print Results • Runs Limit The Pre Test stage also effects how data is collected. The Sampling Rate (Hz) is used to specify the frequency that data is collected during a test run. The Sampling Rate (Hz) may be set from 0.001 to 2000 Hz.

Post Test Stage

6.1.1 Export Raw Data The Export Raw option lets you specify how your raw data for a test run is saved. You have the following options: • No • Overwrite • Auto Number When Export Raw = No, data is not exported to the Exports sub- directory. No .csv file of your raw data for a test run is saved. When Export Raw = Overwrite, a .csv file is created for each test run. The .csv file has a row based on the Sampling Rate that was setup in Pre Test for this test setup. “Overwrite” means that the current .csv file for this test is over-written with new data at the completion of each test run, e.g. there is only one (1) .csv file for this test. The .csv file is named [Test Name]_RawData and is saved to the Metlogix/Exports directory. NOTE When Overwrite is selected, there is always only one (1) .csv file for the test setup. At the completion of a test run, the data from the previous run is replaced by the new data.

A .csv file that was created using Auto Number. A new .csv file is created for each test run. Shown are files for test run #4 and #5.

Pre Test Stage

Specify the data acquisition rate. 100 Hz is 100 data samples per second.

A .csv file that was created using Overwrite. Only one file per test setup.

Metlogix/Exports Directory Default location for exported raw data

When Export Raw = Auto Number, a new .csv file is created at the completion of each test run. If there were ten (10) test runs, there would be ten (10) .csv files, e.g. one .csv file for each test run. The .csv naming convention is [Test Name]_RawData[Run Number]. NOTE When Auto Number is selected, a .csv file is created for each test run within the batch.

Export Raw options

starrett.com

6.1.2 Export Results The Export Results option is used when you want to create a .csv file of only the results (coefficients) measured and reported in each test run. When using Export Results, you have the following options: • No • Overwrite • Auto Number • Append When Export Results = No, results are not exported to the Exports sub- directory. No .csv file of your results for a test run is saved. When Export Results = Overwrite, a .csv file is created for each test run. The .csv file has a row containing the results. “Overwrite” means that the current .csv file for this test is over-written with new results at the completion of each test run, e.g. there is only one (1) .csv file for this test. The .csv file is named [Test Name]_Results and is saved to the Metlogix/Exports directory. NOTE When Overwrite is selected, there is always only one (1) .csv file for the test setup. At the completion of a test run, the data from the previous run is replaced by the new data. When Export Results = Auto Number, a new .csv file is created at the completion of each test run. If there were ten (10) test runs, there would be ten (10) .csv files, e.g. one .csv file for each test run. The .csv naming convention is [Test Name]_Results[Run Number]. NOTE When Auto Number is selected, a .csv file is created for each test run within the batch. When Export Results = Append, a .csv file is created at the completion of the first test run with the results displayed on a single row. If there were ten (10) test runs, there would be ten (10) rows, e.g. one .csv file

Post Test Stage Setting Export Results to Append option

When APPEND is selected, there is a single .csv file for the test setup. Each test run reports its results to this .csv file. Results occupy a row on the file for each test run. Selecting APPEND will add a new row with the results from the just complete test run. All previous test runs have their result on a row within the file.

with a row added at the completion of each test run. The .csv naming convention is [Test Name]_Results. NOTE

When Append is selected, a .csv file is created for the test with a unique row for each test run within the batch.

6.2 File Locations The Metlogix directory is the primary and default location for all files associated with your L2 Plus system. The Metlogix directory is created when you launch your L2 Plus for the first time. 6.2.1 Metlogix Directory The Metlogix directory is the root for your L2 Plus System. There are two sub-directories associated with data and results: • Runs • Exports 6.2.2 Runs Directory The Runs Directory stores individual files for each test run. These Run files, when supplied with the Test file, may be analyzed by another user on another L2 Plus System. The other user must copy the Test file into their Tests directory and then copy all of the Run files into their Runs directory. When they open the test, each of the test runs will be listed in the Runs List. Run files are saved as [Test Name]_[Run Number].mlxrundata. Using Settings-File Locations, you have the ability to map your Runs files to another location other than the Exports directory. For example, you can map your Run files to a network server or to a secondary hard disk device connected via USB to your L2 Plus workstation, or to another directory accessible by another L2 Plus System.

Metlogix Directory Shown are sub-directories within Metlogix

Runs Directory Stored individual test run files

starrett.com

6.2.3 Archive Directory The Archive directory is an “overflow” location for your test runs. When a test has exceeded its specified Runs Limit (Post Test option), the oldest run within the Runs List is automatically saved to the Archive directory. Using the Import Run function, you may import a test run from the Archive directory and compare that run with the run(s) within your current and active test setup. This can be useful for benchmarking a historical run from the Archive directory to a current run. NOTE You may import any run from the Archive directory, even a run from a different test. NOTE Use the Multi-Run function when comparing an imported run with a current run. NOTE An imported archived run is displayed with a prefix “T”.

Metlogix Directory

Selecting the “Import Run” function opens the Archive directory where you can select the archived run(s) to import for analysis.

Archive Directory Stores individual test run files once Runs Limit is exceeded within a test

Imported test runs have a Prefix “T”. Its original runs number is not retained when imported, so the number after the “T” indicates the number of imported runs. If two runs had been imported, they would be labeled T-1 and T-2. The run’s original runs number is maintained in the Archive directory.

Full Graph view Shows one (1) imported run for comparison to active runs

Use the Multi-Run function to display multiple runs. Next, use the Multi-Run analysis tool to measure variations.

Active and Imported Run from Archive Directory Measure using Multi-run Tool

starrett.com

6.2.3 Exports Directory The Exports directory is where all exported .csv files are saved to by default. Raw data files and result files are saved to the Exports directory either automatically at the completion of a test run, or on- demand when the operator selects the Share function. Using Settings-File Locations, you have the ability to map your .csv files to another location other than the Exports directory. For example, you can map your .csv files to a network server or to a secondary hard disk device connected via USB to your L2 Plus workstation. NOTE Exported .csv files are saved to the default Exports directory. You may change where your exported files are saved using the File Locations Setting. 6.3 Exporting Data and Results Data and results may be exported automatically or on-demand using the Share function.

File Locations Setting Map files to other directories besides the Metlogix directory

Export Results .csv

Export Results to Clipboard for copying into Word, etc.

Export .bmp image of graph

Export Raw Data .csv

Share Function Exports files on-demand

6.3.1 Automatic Export Data and Result files may be exported automatically by configuring the Post Test options for your test setup. When Export Raw or Export Results are set to any option other than No, export files are exported automatically to the designated file location.

If you are viewing one of the data view displays, the options are: • Export Results • Export to Clipboard • Export Image • Export Raw Data

Exports Raw Data automatically at end of test run.

Export Results .csv

Post Test Stage

Export Results to Clipboard Export .bmp image of graph

Exports Results automatically at end of test run.

6.3.2 On-Demand Export (Share) The Share function appears on the footer of the views used to display your graphs or data tables. Selecting the Share function will display an option menu. The menu options will change based on the view you are looking at. If you are looking at a full graph view, the options on the menu are: • Export Image • Export Raw Data

Export Raw Data .csv

Share Function Exports files on-demand

Export .bmp image of graph

Share Options from Full Graph view

Export Raw Data .csv

starrett.com

6.3.2.1 Export Results Selecting the Share + .csv target will export the results from the currently displayed data table, e.g. for a single test run. The export is identical to exporting as a “Overwrite Export” had you used the Post Test Export Results option. Export to Clipboard The Export to Clipboard function is similar to a traditional “cut & paste”routine. When the clipboard symbol is selected, the highlited rows from the data table is copied to the clipboard where it can be pasted into a Microsoft Word or Excel document. 6.3.2.2 The Export to Clipboard is available on views with a data table only. The clipboard cannot be used to copy and paste an image, e.g. graph trace. NOTE The Export to Clipboard function is available with views having a data table. It exports the table data only.

6.3.2.3 Export Image The Export Image function is used when you want to create and copy an image of your graph from a test run. The image is saved as a .bmp and is used as a clipboard image. The image can be pasted into Microsoft Word or Excel. Export Raw Data Selecting the Share + Raw Data target will export the raw data points from the currently displayed data table or from the graph, e.g. for a single test run. The export is identical to exporting as a “Overwrite Export” had you used the Post Test Export Raw option. 6.3.2.4

Share Function Copy message displays when data is copied to clipboard

6.4 Printouts Reports may be printed out from the display view. Reports are associated with the current view being displayed.

From Display View

Prints this report type

Full Graph view

Graph Report

Split Graph - Data view

Run Report (Graph and Run Data)

Split Graph - Data view with Statistics

Statistics Report

Data view

Batch Report

Data view with Statistics Data view with Tolerance

Statistics Report Tolerance Report

Printout Formats Print reports by selecting the Printer symbol from the main menu. Report layouts print landscape. You may change to a portrait layout by selecting the Page Format symbol from the L2 Plus main menu.

Executes a printout of the current display view.

Edit page layout: •

Change from landscape to portrait

•

Set margins

Page Layout dialog

Main System Menu Execute a printout or change the page layout settings

starrett.com

6.4.1 Standard Reports Your L2 Plus system provides a set of common report formats. These are described in the following sections. User may also use the .csv files to create more complex reports using Microsoft Word, Excel and Access.

6.4.1.1 Graph Report The Graph report prints from the full graph view. The Graph report prints the full graph with the result markers - WYSIWYG (What You See Is What You Get). You may print the Graph report with multiple graph traces using the Multi-run function, however, the only markers that are displayed are for the “active” test run. The “active” test run always displays with a black trace line. Graphs may print with grid lines or without. Graphs may include selected coefficients when you add a coefficient into any of the Custom Text entry boxes in Printout Settings. Coefficients can be printed in the header boxes or in the single footer box. To print a coefficient on a graph report, enter the coefficient label into the Custom Text entry box using the Printout Settings from the main Settings.

Print Full Graph Report

Graph .bmp is printed in the center of the printout. Other options are justified left or right. Graph .bmp is printed with grid lines.

Printout Settings Use to set global printout formatting and common general information, e.g. User, Date/Time, Page Numbers, etc.

You can include critical coefficients in your header or footer. Shown is where the coefficient DPt is included in the custom header text. The coefficient must be bracketed and can include informative text afterwards. When a coefficient is entered into the header, this coefficient will appear in the header of all printouts.

Print Full Graph Report Report shows a specific coefficient (DPt) in the printout header

starrett.com

6.4.1.2 Run Report The Run report is printed from the split Graph-Data view. Select the test run from the table and the associated graph trace is displayed. Select the Print symbol from the Main System Menu. The Run table data is printed at the top of the graph image.

The test runs’ data results are displayed above the graph image and below the header information. If there are many coefficients, the additional coefficients will print on a separate page.

Print Run Report Report shows Run #5, its coefficients and the graph with markers

6.4.1.3 Batch Report The Batch report is printed from the full Data view. The full Data view displays all test runs and their coefficients in a table. Test runs are identified, which each test runs displaying on a row.

Print Batch Report Use Multi-Run function and report all test runs

starrett.com

6.4.1.4 Statistics Report The Statistics report prints from the full Data view or from the split Graph-Data view. Statistics are not displayed, nor can a Statistics report print when using tolerances. You must use the Tolerance report for printing tolerance information and result.

Print Batch Report Use Multi-Run function and report all test runs with statistics

6.4.1.5 Tolerance Report When tolerances are used, you may print a Tolerance report from any Data view, e.g. full or split graph-data. The Tolerance reports will print in a WYSIWYG format. You cannot print a report with both tolerances and statistics.

Print Tolerance Report Use Multi-Run function and report all test runs with tolerance

starrett.com

6.4.2 Automatic Printouts You may print reports automatically by specifying the Print Results option in the test setup’s Post Test stage. The default for Print Results = No. No report is printed at the completion of a test run. If you specify Print Results = Graph, a Graph report is printed at the completion of a test run. If you are displaying a full graph at the completion of your runs, a full Graph report will print. If you are displaying a split Graph-Data view, a Run report will print at the completion of your test runs. If you specify Print Results = Data, a Batch Report is printed. This result table for the selected test run. If statistics or the tolerance view is used, the associated statistics or tolerance report will print. If you specify Print Results = Both, a Run Report is printed. This will include the graph and the result table for the selected test run. 6.4.3 On-Demand Printouts On-demand printouts use the Print symbol from the Main System Menu. While at the display view of your result, select the Print symbol. The report associated with that view will print.

Post Test Stage Setup Print Results = No. No automatic printout at completion of a run

Executes a printout of the current display view.

Post Test Stage Setup Print Results = Graph Prints Graph Report at completion of a test run

Post Test Stage Setup Print Results = Data Prints Batch Report at completion of a test run

Main System Menu Execute a printout or change the page layout settings

Post Test Stage Setup Print Results = Both Prints Run Report at completion of a test run

6.4.4 Printout Settings The Printout Setting is used to globally format your printouts. All printouts will use these settings options on all printouts.

6.4.4.3 Print Grid lines Graphs are displayed with grid lines. When you print a report that uses the graph image, you have the option to print with or without the grid lines. If Print Grid lines = Yes, the report will print the graph image with grid lines. If Print Grid lines = No, the report will print the graph image without grid lines. Both the y-axis and x-axis lines are printed, including their numerical values and labels. 6.4.4.4 Print Header Logo You can setup your reports to print your company logo in the header. You first must create a .bmp file of your logo with a height no greater than 300 pixels (25 pixels is recommended). Next, you will rename your .bmp file to “Headerlogo”. Then, save this file in your Metlogix/ LogosAndBitmaps directory. You can choose to print your header logo and position the logo center, left or right on your printout.

6.4.4.1 Print Report Header You may specify that all printouts output with a header when this option = Yes. All reports will print with a header. If this option = No, all reports will print without a header. When the Print Header option = No, the Print Custom Text in Header options will not print even if you have enter information in the Settings. 6.4.4.2 Print Column Headers Print Column Headers refers to the column labels used in your Data views. These labels are generally the name used to distinguish your results (coefficients). A Column Header example would be LPt. If Print Column Headers = Yes, all reports using the data view information will print with these headers. If the Print Column Headers = No, reports using the data view information will print row information without the column labels.

Printouts Setting Setup global layout for all reports

starrett.com

6.4.4.5 Print Footer Logo You can setup your reports to print your company logo in the footer. You first must create a .bmp file of your logo with a height no greater than 300 pixels (25 pixels is recommended). Next, you will rename your .bmp file to “Footerlogo”. Then, save this file in your Metlogix/ LogosAndBitmaps directory. You can choose to print your footer logo and position the logo center, left or right on your printout. Print User Name in Header When User Names are setup for your operators, you may specify that the User Name prints in the Header. 6.4.4.6 The user who is logged into the system at the time the report is printed (either print automatically or printed on-demand), has their User Name printed in the header. The User Name may be printed in the center, left or right on the header. Print Date/Time in Header You may time stamp your printouts using the Print Date/Time in Header option. 6.4.4.7 The Date and Time may be printed in the center, left or right on the header. The Date and Time represent the actual date and time that the printout was executed either automatically or on-demand. 6.4.4.8 Print Page Number in Footer You may print page numbers on your printouts using the Print Page Number in Footer option. The Page Number may be printed in the center, left or right on the footer. Print Custom Text in Header There are three rows reserved in the header for printing custom text. The text may be up to 100 characters, including spaces, in length. Additionally, you may print coefficients in any of these three rows using a bracket and the coefficient name, e.g. [LPt]. NOTE 6.4.4.9

6.4.4.10 Print Custom Text in Footer There is a single row reserved in the footer for printing custom text. The text may be up to 100 characters, including spaces, in length. Additionally, you may print coefficients in this rows using a bracket and the coefficient name, e.g. [LPt]. NOTE

If using a coefficient in your custom text, please note that this coefficient will always be printed on all reports. If the coefficient was reported as an out-of-range value (XXXXX), the XXXXX is printed in this location.

No information is printed when left blank. Custom text prints left-to-right.

If any of the rows are left blank, no information is printed. Custom text prints left-to-right.

Corporate Headquarters The L. S. Starrett Company 121 Crescent Street Athol, MA 01331 USA Tel: 978-249-3551 Starrett Metrology Division Starrett Kinemetric Engineering, Inc. 26052-103 Merit Circle Laguna Hills, CA 92653 USA Tel: 949-348-1213

Page 1 Page 2 Page 3 Page 4 Page 5 Page 6 Page 7 Page 8 Page 9 Page 10 Page 11 Page 12 Page 13 Page 14 Page 15 Page 16 Page 17 Page 18 Page 19 Page 20 Page 21 Page 22 Page 23

www.starrettmetrology.com

Made with FlippingBook - professional solution for displaying marketing and sales documents online