ETL 1110-2-560
30 Jun 01
C-3. Processing Data
The accumulated survey information is gathered electronically and stored to a failure database. The
failure data entered to date was reviewed and processed for incorporation into this appendix and to
provide actual data for mechanical and electrical equipment in use at navigation locks and dams. The
database was manually manipulated by the process shown in the flowchart in Figure C-3. It was found
during the process that some variations of entries had been entered. Some of the equipment did not apply
or there were errors in the entries. Errors or nonapplicable components that were detected were either
corrected or the data were not used.
SURVEY DATABASE
Locks Enter Data
or View Data
Survey
Data
Enter
Database
STOP Processing
Valid
NO
this entry
Data?
YES
Database manager accepts data for reliability analysis by assigning data entry an
NPRD Part Summary classification
LPMS DATABASE
Pertinent data - (Location ID#, Year Installed, Year Failed or Hours of Operation, NPRD Summary)
Actual and Extrapolated
Sort data by ID#
Sort and Calculate
Hard Cycles for all
USACE Locks from 1900-
Calculate # of operating hours/data entry based on
2000
(hours of operating hours or (Year Failed-Year Installed)/Id#)
6
Calculate total # of Hard Cycles
Calculate failure rate/10 hours per data entry
per data entry per ID#
Group Data
Entries by
NPRD Part
Summary
FAILURE RATE DATA BASE
Apply Reliability
Calc. & incl.
6
Calculate merged failure rates/10 hours
Auto "n" entries
for grouped NPRD Part Summary data entries
n
1/n
λmerged = (П λi)
.%
i=1
Store &
Reliability
Update Data
Summaries
Stop
Figure C-3. Failure database analysis flowchart
C-4. Merged Failure Data
The data for individual components were grouped according to methods used and published by the
Reliability Analysis Center (1995). The following equation from Reliability Analysis Center (1995) was
used to merge the individual failure entries:
C-3
Previous Page
