## To Excel

In Datapage+ version 2011 and later the specific excel reports (Data, Variable, PPAP, ISIR, XBarR, Spreadsheet) are accessible from the To Excel toolbar icon on the side bar.

When you click this icon, the software displays the Excel Output dialog box; it allows you to choose the report type to export as an .xls or .csv file, depending on the type of output.

Excel Output dialog box

Output - This area defines two output options for your report.

- Directory - Use this if you want the software to automatically save the report with an automatically generated name to the specified directory. Use the Browse button to select the desired directory. The exact file name that will be generated uses this format: "<Report type> yyyy-mm-dd--hh-mm-ss.xls" based off of the time when the report was generated. yyyy represents the four digit year, mm the two digit month, dd the two digit day; hh the hour in 24 hour time, mm the minutes, and ss the seconds. <Report type> refers to the type of report selected in Report Type area.

- File name - Use this if you want to give the output a specific name. Type or use the Browse button to select the directory and file name to which you want to output the data.

Report Type - This area defines the report type and the final file format.

- Save as - This list lets you choose the report type to export. Available types are:

- - Data Report - Exports as either .xls or .csv.

  - Variable Report - Exports as either .xls or .csv.

  - PPAP Report - Exports as either .xls or .csv.

  - Spreadsheet Report - Exports as either .xls or .csv.

  - ISIR Report - The ISIR Report (Initial Sample Inspection Report) is only available as an .xls export.

  - XBarR Report - This report is only available as an .xls export.

  - Editor Report - This report exports selected measured values and marks out-of-tolerance values in a red color.

- Save as type - This defines the output format as either an excel (xls) or a comma separated value (csv).

XBarR Option - This area becomes available for selection if you select XBarR Report as the report type. It lets you specify options specific to an XBarR report.

- Select month - Use the icon to chooses a day in a month. Data for the entire month will be exported.

- Subgroup size - This sets the number of individual observations per subgroup.

- Verifier - In this box you can define an automatic signature that will appear for each subgroup.

- Shift - If marked, this check box splits the measured data into two parts, a night shift and a day shift.

- From X to Y - This becomes enabled if Shift is marked. It defines a time range for the day shift, where X represents the first box, the shift's start time, and Y represents the shift's closing time. The time format must be in 24-hour time. Data within this range will be assigned to the day shift portion of the report. Data within the range after the closing time of Y but before the next day's start time of X will be assigned to the night shift portion of the report.

Don't show this dialog - This hides the Excel Output dialog box for the remainder of the session. Once you have a report and an output directory or file defined, and you mark this check box and then click OK, Datapage+ will automatically output using the specified report to the selected directory or file whenever you click the To Excel icon from the side bar. The dialog box remains hidden until you mark the Show dialog when create XLS/CSV file option available from the General tab of the Options dialog box, accessible from Tools | Options.

OK - This outputs the report to the specified directory or file and closes the dialog box. You can view the text on the status bar while the report generates to view the status of the report. It displays Generating... in red text when processing and when the report generation is done, the text changes to Finished.

Cancel - This closes the dialog box without creating a report.

For a customized excel report, see the "Exporting Customized Excel Reports".

To Export a Report with the Excel Output dialog box Visible:

1. Select the transactions and features or feature variables you want to export.

2. Click the To Excel icon from the sidebar.

3. Fill out the Excel Output dialog box.

4. Click OK. A message box appears, informing you when the report was created.

Sample Exported Excel Report

A sample Variable report, exported to as an Excel File