Databases Reference
In-Depth Information
'End If
'Clean Up built strings for next pass
cellstr$ = "": funcstr$ = ""
Next row
Next col
'Add Heading Parameters to ColRpt Sheet
Workbooks(CalcBook).Worksheets("ColRpt").range("H3").Value =
Trim(str(UtilScans)) & "/" & Trim(str(NoScans))
Workbooks(CalcBook).Worksheets("ColRpt").range("H4").Value =
str(OhmMin)
Workbooks(CalcBook).Worksheets("ColRpt").range("D3").Value =
Val(frm10ADA.TextBox_GageR.Text)
Workbooks(CalcBook).Worksheets("ColRpt").range("D4").Value =
Val(frm10ADA.TextBox_GageRT.Text)
Workbooks(CalcBook).Worksheets("ColRpt").range("L3").Value =
Val(frm10ADA.TextBox_BridVolt.Text)
Workbooks(CalcBook).Worksheets("ColRpt").range("L4").Value =
str(OhmMax)
End Sub
10.5
THE FINAL REPORT
What started as a raw data file of text has been transformed into an Excel Workbook that contains
eight Worksheets. Each generated sheet does a specific analysis and serves a selected purpose. The
name of each generated sheet and the function it serves are listed below.
SGData
— The original strain gage data file is imported into this Worksheet.
SGDefects
— This is a copy of the SGData sheet. Defective strain gages on this sheet are
highlighted in red, and good strain gages are highlighted in green.
RowRpt
— A row-by-row analysis of each resistor on the substrate.
ColRpt
— A column-by-column analysis of each resistor on the substrate.
STDEV
— This sheet contains the calculated standard deviations using the data in all the
data sets.
AVG
— This sheet contains the calculated means (or averages) using the data in all the data
sets. Elements in the process that do not meet Six Sigma quality standards are highlighted.
ORAVG
— This sheet contains the results of a new analysis that omits outliers in the original
data set. The means, standard deviations, and data points utilized in the new analysis are
all listed in matrix format.
Compare
— A sheet that compares the results of the AVG sheet with the results from the
ORAVG sheet. Note that the results will be identical in the case where no outliers are
present in the first data set.
10.6
SAVING THE FINAL REPORT
Saving the final report always poses some vexing questions. First, should the user have the ability
to choose the name the final report is saved under? Although this may seem like a good idea, the
reality is that letting users choose the file names for automated reports usually proves to be
problematic. Often, the names they choose do not lend themselves well to sorting or even indicating
exactly what the file contains and under what conditions the analysis was run.
