Kenexis logo  
 
home services software training resources about us contact us
 
 
 

 

  Spreadsheet Tools


Kenexis has developed a number of software tools that are used in our work processes, a selection of these tools are available here...

SS-05 - Confidence Limit Worksheet
This spreadsheet calculates the failure rate of a component to user selectable degrees of confidence (e.g., 70% as recommended by IEC 61508).
SS-05 Confidence Worksheet (XLS - 16k)

SS-04 - Common Cause Failure Estimator
This spreadsheet employs the methodology presented in the ISA 84.01 TR2 technical report to estimate the beta factor that should be used for common cause failure percentage in various circumstances.
SS-04 Common Cause Failure Estimator (XLS - 36k)

SS-03 - FMEDA Worksheet
This spreadsheet provides a framework for doing a simple failure modes, effects, and diagnostics analysis. This spreadsheet is ideal for determining the overall failure characteristics of a multiple component system, such as two transmitters used to calculated differential pressure, or a solenoid, actuator, valve combination with partial stroke testing.
SS-03 FMEDA Worksheet Template (XLS - 18k)

SS-02 - Input Device Failure Conversion Tool
In many cases, failure statistics presented by equipment vendors take the form of fail high, fail low (inherent), fail dangerous undetected, and fail dangerous detected (a.k.a., fail low - diagnostics). This spreadsheet tool takes that raw data and converts it into safe and dangerous failures as function of whether the device trips upscale or downscale.
SS-02 Input Device Failure Conversion Tool (XLS - 16k)

SS-01 - Proven in Use Worksheet
This spreadsheet provides a checklist for issues to be considered when establishing proven-in-use justification for a component. The tool also includes the ability to perform a 70% confidence limit calculation for component failure rate.
SS-01 Proven in Use Worksheet (XLS - 18k)