NAMeS Excel™ Reports

1. Overview *

1.1 What is a NAMeS™ Excel™ Report? *

1.2 Requirements *

2. Exporting Data From NAMeS * 2.1 Exporting Data to the Database *

2.2 Selecting Frames to Export to Excel™ *

2.2.1 Selecting Frames from the List Control *

2.2.2 Exporting the Data To Excel™ *

3. Generating Reports in Excel™ * 3.1 Generating Assembly Reports in Excel™ *

3.2 Generating Standard Trend Charts *

3.3 Generating Customized Charts *

3.4 Printing and Print Previewing *

4. Saving Changes *


1. Overview

1.1 What is a NAMeS Excel™ Report?

The Excel™ Report generated by NAMeS can be used to generate Assembly Reports, and it can also generate simple SPC plots.

The Assembly Reports currently display:

The simple SPC plots currently can display more than one dimension on one plot. For each dimension the chart can have the values for each sample, the lower specification limit, and the median value. The value of the horizontal scale can be labeled either with the actual sampling dates, or with just the index of that sample (for example, "1", "2", "3", "4").

1.2 Requirements

In order to generate an Excel™ Reports with the NAMeS, it is necessary to have "Frame NAMeS" installed on the computer. However, once generated, the reports can be viewed on any computer with the correct version of Microsoft™® Excel™.

Currently, the Excel™ reports only work properly in Excel™ Version 7.0a, also known as "Microsoft Excel for Windows 95, Version 7.0a." Version 7.0a corrects some Visual Basic errors that will prevent Version 7.0 from working on some computers. Also Version 7.0a seems to have the "Y2K" patch included. Version 7.0a can be obtained from Microsoft if you own Microsoft Excel.

Due to errors in the way "Excel 97™" handles printing and charts, it is highly recommended that Excel™ 97 not be used for NAMeS Excel™ Reports.


2. Exporting Data From NAMeS

The first step to generating a report is to actually measure the welds as described in the Frame NAMeS manual.

2.1 Exporting Data to the Database

Once the welds have been measured, the programmed dimensions will be exported to the master database by pressing the Database button. The dimensions that are sent to the database are currently programmed by N. A. Technologies into the frame or assembly file; therefore, it is not currently possible for the user to directly modify the list of dimensions.

Figure 1 Press the "Data Base" button to export the frame to the database.

After you press the database button, the following dialog will be displayed. Usually the correct button to press is Add Project to Database. The Just Generate Report of Previously Added Data button will NOT export the current frame into the database, but will allow you to make a report out of data already in the database.

Figure 2 Press the "Add Project to Database" button to export the frame.

Once it has been chosen to add the project to the database, a dialog will come up asking if the existing data in the database should be replaced. Click on Yes. This reason that data is in the database even if you never exported it is because there is blank data in the database from when you created your project!

Figure 3 Say yes to overwrite the existing data, or to add data for the first time.

Once Yes is clicked, NAMeS will export the current frame into the database. All dimensions will be calculated, but only those selected by the "frame template" will be exported to the database.

**NOTE** Any errors or crashes while exporting to the database likely arise from an incorrect installation of DAO or of the actual database file. Make sure that your database file (*.mdb) is not read-only. Try re-installing DAO with the NAMeS Install Disk (reboot if it the install program asks you to). If you are prompted reboot your computer afterwards and it still crashes, try re-installing yet another time. (Certain Microsoft DLLs must be installed correctly before DAO can install.)

2.2 Selecting Frames to Export to Excel

After exporting your data to the database (or after choosing to just use previously added data), the following dialog will be displayed. This dialog allows the selection of measured frames for each of the various assemblies that have been programmed into NAMeS.

Figure 4 The Generate Reports dialog is used to select frames to report on.

The first step to generating a report is choosing a range of valid dates. All dates within the range shown on the left will be queried to see if frames within those dates exist. The start of the date range is selected in the From box by clicking in the box with the date in it. The end of the date range is selected from the To box by clicking it.

Once the date has been chosen, select the desired model to generate a report of. The Model will default to the current model loaded into NAMeS. Clicking on the arrow beside the Model combo box will bring up a list of all models that have data in the database.

Selecting a model in the Model box will cause a list of all "compatible models" to be displayed in the right-hand list. A compatible model is an assembly that has welds with the same names and weld types as the selected model. The models may differ in material thicknesses, or perhaps the welds join slightly different parts, but the welds themselves are the same. Choose all of the compatible models that reports or SPC charts are needed for. Note that the currently selected Model will always be selected in the Compatible Models box.

2.2.1 Selecting Frames from the List Control

The list control at the bottom of the Generate Reports window should list all of the frames in the database that meet the conditions of the date, model, and compatible models set above. If the desired frames do not appear in the list, make sure that the frames have been added to the database, and that the correct date and models are chosen.

Select a frame from the list just as you would select files in most Windows™ programs. Left click to choose a single file. Hold down CTRL and left click to select multiple files. Hold down SHIFT and click to select a range of files. The titles at the top of each column of data can be clicked to organize the frames according to that type of data. For example, to organize the data by the "Technician", click on the column header that reads "Technician"

Figure 5 These reports are sorted by the Technician.

For more information on the information in this window, see the Frame NAMeS Manual.

2.2.2 Exporting the Data To Excel

Once the desired frames have been selected from the lower list, click on the Excel Report button. To export a tab delimited file to another piece of software, click on the Export Data button. (This dialog may disappear soon.)

Figure 6 Press the Excel Report button to start excel.


3. Generating Reports in Excel

When Excel first starts, it opens up the NAMeS Data Reporting dialog. The Standard Trend Charts are trend charts of a selected dimension generated for every weld. The Customized Charts are charts with only selected welds and dimensions. Press the Assembly Reports button to generate reports for each of the frames that were exported. Both the Printing button and the OK button reveal the print controls so that charts and reports can be printed after they have been generated.

Figure 7 This dialog automatically opens when Excel starts.

3.1 Generating Assembly Reports in Excel

From the "NAMeS Data Reporting" dialog, press the Assembly Reports button in order to have excel automatically generate reports for all of the exported frames. There is no status bar, but a dialog will be displayed for each frame that has a dimension that is outside of the specification limits that have been set.

Figure 8 This warning dialog indicates that at least one was not in specification for "Frame1".

Once the reports have been generated, press the Printing or OK button to bring up the list of reports on the display tab. For the example in section "3.4 Printing and Print Previewing" only one report was generated.

After clicking the Printing or OK button, the different worksheets will become available. Click on the Assembly Report tab to view the raw assembly reports. These can be customized by hand; however, you can not just save any changes, see section "4. Saving Changes".

Figure 9 An assembly report showing a 15053_364 from 5/21/99.

The above example shows a 15053_364 frame manufactured on 5/21/1999 by Line 4, measured by James Day. Note that the 2.33mm Vertical Leg Length of "4-Lap" located at M16 is shorter than the Lower Specification Limit of 2.90.

Also note that the date is displayed as 5/21/99. Excel 7.0a claims to be year 2000 compliant; however, the dates are still displayed as 5/21/99 and 10/10/00 when NAMeS exports "05/21/1999" and "10/10/2000" to Excel.

3.2 Generating Standard Trend Charts

Press the Standard Trend Charts button on the NAMeS Data Reporting dialog to generate standard trend charts.

This section not yet written.

3.3 Generating Customized Charts

Press the Customized Charts button on the NAMeS Data Reporting dialog to generate custom charts.

This section not yet written.

3.4 Printing and Print Previewing

Once a report or chart has been generated, it will be listed on the "Display" tab of the Excel™ report. To get to the Display tab, either click on the tab at the bottom of the Excel™ window, or click on Printing on the "NAMeS Data Reporting" dialog if you have not yet done so.

Figure 10 The printing controls are located on the Display worksheet.

Any generated reports, standard charts, or customized charts will be shown in the three lists on the Display tab. Click on the names of the reports and charts to select them. The Select All checks will select all of the items in the list box above.

If the Print Preview checkbox is checked, the Print button does a Print Preview of all of the selected items. If the Print Preview box is not checked, then the Print button will attempt to print the selected reports. (A printer will need to be available to the computer to print.)

Pressing the Generate Reports button will re-open the "NAMeS Data Reporting" dialog.


4. Saving Changes

This section not yet written.

In order to not have the Auto_Open script erase all changes made to the excel file, you will need to choose Tools, then Macro…, then choose "Auto_Open" and Edit. Then delete or comment out all of the Auto_Open macro.

I'm sure Excel™ is a registered trademark and copywrited by Microsoft.