Aubrey Kagan is a senior design engineer with Emphatec Inc., Markham, Ontario, Canada. He received a BSEE from Technion, Israel Institute of Technology, Haifa, Israel, and an MBA from the University of Witwatersrand, Johannesburg, South Africa. He also wrote "Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers." Email address: akagan@emphatec.com
3 results found for Aubrey Kagan, displaying items 1 - 3
October 2, 2008[Ideas For Design] Use Excel To Develop A Traceability Matrix: Backstory
A subrequirement that derives from multiple primary requirements can be achieved using the concatenation of the cells in the reference coupled with a line-feed character. For example, if CEI requirements 1.3.3 and 1.3.4 drive requirement 2.1.9 of the lower document, cell D11 would contain the Excel formula =A4 & CHAR(10 )& A5. To achieve the multiple line effect, the cell should be formatted to allow Wrap Text (in the Alignment...
March 16, 2006[Ideas For Design] Use Excel To Calculate A-D Level-Shifter Resistor Values
Many times, the need arises to interface single-supply analog-to-digital converters (ADCs) and comparators to real-world signals like 5 V. Of course, it's possible to condition the signal using operational and/or instrumentation amplifiers. But few engineers realize that it's often possible to achieve the level shifting using a resistor network (Fig. 1). Critics of this technique point out that the resistor network can load the...
February 3, 2005[Ideas For Design] Use Excel To Develop A Traceability Matrix
In large projects, a single contractual document often known as the Contract End Item (CEI) governs the final product design. Each requirement of the contract is individually numbered to allow for performance verification of the end item. Because the projects are usually complex, this set of requirements is broken down and allocated to different subsystems. These subsystems also have a set of requirements, and each requirement must be traceable to a requirement above...
