Assignment%208%20-%20computer%20modeling

Assignment%208%20-%20computer%20modeling - EE 600...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
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.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/13/2011 for the course EE 1101 taught by Professor Hendr during the Spring '11 term at Minnesota State University, Mankato.

Ask a homework question - tutors are online