Chapter 10, Problem 18ICA

You have a large stock of several values of inductors and capacitors, and you are investigating how many possible combinations of a single capacitor and a single inductor chosen from the ones you have in stock will give a resonant frequency between specified limits.

Create two cells to hold a minimum and maximum frequency the user can enter.

Calculate the resonant frequency (f_R) for all possible combinations of one inductor and one capacitor, rounded to the nearest integer. For a resonant inductor/capacitor circuit, the resonant frequency in hertz [Hz] is calculated by

$f_{\text{R}}=\frac{1}{2\pi \sqrt{LC}}$

In this equation, L is the inductance in units of henry [H] and C is the capacitance in units of farads [F]. Note that the capacitance values in the table are given in microfarads. Automatically format each result to indicate its relation to the following minimum and maximum frequency values.

• $f_{\text{R}}>f_{\text{MAX}}$: The cell should be shaded white with light gray text and no border.
• $f_{\text{R}}<f_{\text{MIN}}$: The cell should be shaded light gray with dark gray text and no border.
• $f_{\text{MIN}}<f_{\text{R}}<f_{\text{MAX}}$: The cell should be shaded white with bold black text and a black border.

If done properly, the table should appear similar to the table that follows for f_MIN = 2500 and f_MAX = 7777. After you have this working properly, modify the frequency input cells to use data validation to warn the user of an invalid value entry.