ECE 211 Fall 2009
Circuit Analysis I
Project 3
(due Mon, Nov 9, at the beginning of lecture)
Objectives
To learn the basics of Excel and to compute values to compare to Virtual Lab results.
Required Output
For each problem, you should submit two
printouts of your Excel worksheet, in different
ways:
with values
of input and output variables clearly labeled.
with formulas
shown, rather than values.
This is done with <CTRLbackquote> where
<backquote> (`) is above the <TAB> key.
Note that this is actually a toggle command.
P5.
Consider the following circuit:
Assume first that Rb = 10kΩ, Rload = 300kΩ, and Vin = 1.5V.
(a) What value of Ra will result in Vout = 12V?
(b) What power is absorbed by the opamp to operate this circuit?
(c) What current is flowing into
the output pin of the opamp?
Assume now that the desired value of Vout is 27V.
(Rb and Vin remain the same.)
(d) How do your answers to parts (a), (b), and (c) change?
Assume finally that the original load is changed to Rload = 600kΩ.
(Use Vout = 12V.)
(e) How do your answers to parts (a), (b), and (c) change?
To answer these questions, you should set up an Excel spreadsheet or
worksheet
.
This is so
that you can avoid repeating all of the calculations in parts (d) and (e) when the values of
Vout and Rload change.
Each box in the worksheet is called a
cell
, which is identified by the column (A, B, C…) and
row
(1, 2, 3…).
So, for instance, B3 refers to the contents or value of the cell located at the 3rd
row of the 2nd column of your worksheet.
On the next page, the value of B3 is 200.
Formulas are written in terms of cell identifiers.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '10
 Tessier
 Formulas

Click to edit the document details