BAE Systems 3 Team WEB

Team Members

Dameon Proctor
Sherise Cosby
Jonathan Rideout
Sabrina Dixon

Project Description

BAE Systems needs a software tool that will allow test technicians to see graphically how each Successive Logarithmic Detection Amplifier (SDLA) device under test is performing against the specifications and previously tested units.
The SDLA has a very large gain, over 70dB, where small variations in test parameters will easily be detected. This software tool will give the test engineers at BAE Systems the ability to see how much performance margin exists and what the expected yield will be. This tool will reduce the cost per unit because time spent in re-tuning and re-testing devices will be reduced due to problem trends being detected early. If a measurement is out of specification, an error box will be displayed to alert the technician as to which parameter is in error. An error file will then be created for later reference.

Project Solution

According to the block diagram, the device parameters data will be downloaded from Hewlett Packard's HP-VEE, an instrumentation program, into an Excel worksheet as the device is being tested.
The Visual Basic code will then prompt the technician for the input parameters specific to that device in order to perform the statistical calculations and show results agains device specifications. These input parameters are: frequency flatness, linearity, frequency response, RF power out and RF phase out. The Statistical Process Control (SPC) anaylsis calculations that will be peformed will be: Average, Standard Deviation, Cpk, and Control Limits. The graphs and run charts for each parameter where SPC is calculated, will be displayed at the command of the test technician.
An Active X code will be invoked in order to extract the data from excel. In order to perform these calculations. Once the device has been tested, an error file will be created by the Visual Basic Code for all tested parameters that are out of specification. Once all calculations are done, the code will interface with Excel to display the Statistical Process Contol (SPC) charts which show how the device is performing against previously tested devices.

Links To Other Sources

BAE System's Website on SDLA's
Miteq's Website on Logaritmic Amplifiers

Project Description
	BAE Systems needs a software tool that will allow test technicians to see graphically how each Successive Logarithmic Detection Amplifier (SDLA) device under test is performing against the specifications and previously tested units. The SDLA has a very large gain, over 70dB, where small variations in test parameters will easily be detected. This software tool will give the test engineers at BAE Systems the ability to see how much performance margin exists and what the expected yield will be. This tool will reduce the cost per unit because time spent in re-tuning and re-testing devices will be reduced due to problem trends being detected early. If a measurement is out of specification, an error box will be displayed to alert the technician as to which parameter is in error. An error file will then be created for later reference.

Project Solution

According to the block diagram, the device parameters data will be downloaded from Hewlett Packard's HP-VEE, an instrumentation program, into an Excel worksheet as the device is being tested. The Visual Basic code will then prompt the technician for the input parameters specific to that device in order to perform the statistical calculations and show results agains device specifications. These input parameters are: frequency flatness, linearity, frequency response, RF power out and RF phase out. The Statistical Process Control (SPC) anaylsis calculations that will be peformed will be: Average, Standard Deviation, Cpk, and Control Limits. The graphs and run charts for each parameter where SPC is calculated, will be displayed at the command of the test technician. An Active X code will be invoked in order to extract the data from excel. In order to perform these calculations. Once the device has been tested, an error file will be created by the Visual Basic Code for all tested parameters that are out of specification. Once all calculations are done, the code will interface with Excel to display the Statistical Process Contol (SPC) charts which show how the device is performing against previously tested devices.

Links To Other Sources
BAE System's Website on SDLA's Miteq's Website on Logaritmic Amplifiers