EE 600 – Assignment 8 Some Spreadsheet Problems One of the many useful tools available to you is the spreadsheet. This tool can be programmed to provide a wide variety of quick answers to problems that you will encounter. In class I gave you three examples of the use of this tool. Your assignment is to program three similar examples, use your programs to answer a few questions, and then turn in your spreadsheets together with your solutions. Problem 1: Do problem 4.14 on page 143 using a spreadsheet model. Problem 2: A company needs to provide three reference voltages on a PC board for their circuits. They have available a power supply that is 5V +/- 1%. The reference voltages they need to produce are 1.25 volts, 2.75 volts, and 4.0 volts. The 1.25 volt reference needs to be +/- 2%, the 2.75 reference needs to be +/- 4%, and the 4.0 reference needs to be +/- 7%. The company has decided to produce these voltages by using a resistor divider chain. You can purchase resistors at 0.1%, 1%, 5%, or 10% tolerances.
This is the end of the preview.
access the rest of the document.