|
|
|
Homepage
Smith Chart
Component Scaling
Fresnel Zone
Power Factor
Spurious Mixer Products
Ohm's Law
Microstrip / Stripline
RLC Combinations
Cascaded System Calculator
Delta-Wye Calculator
Inductance Calculator
Frequency Conversion Calculator
Noise Figure Calculator
2-Way Path Loss Calculator
Radar Blind Speed Calculator
Rectangular Cavity Resonance Calculator
Voltage Divider Calculator
VSWR | Return Loss | Gamma Calculator
|
VBA Code Sample
Butterworth Bandpass Filter
Butterworth Lowpass Filter
Capacitance
Helical Resonator
Coaxial Cable
Complex Numbers
Attenuator Calculator
Directional Coupler Calculator
Doppler Shift Calculator
Filter Calculator
Near Field Calculator
1-Way Path Loss Calculator
Propagation Time Calculator
Radar Horizon Calculator
Skin Depth Calculator
Units Conversion Calculators
Voltage Conversion Calculator
|
The newest addition to RF Cafe's spreadsheet (Excel) based engineering
and science calculator -
Espresso Engineering Workbook™ (click to download)
is a functional Smith Chart that plots a series of user-defined impedance points. RF Cafe Espresso Engineering Workbook™ is
provided at no cost,
compliments of my generous sponsors.
The original calculators are included, but with a vastly expanded and improved
user interface. Error-trapped user input cells help prevent entry of invalid values.
An extensive use of Visual Basic for Applications (VBA*) functions now do most of the heavy lifting with calculations,
and facilitates a wide user-selectable choice of units for voltage, frequency, speed,
temperature, power, wavelength, weight, etc. In fact, a full page of units conversion
calculators is included. A particularly handy feature is the ability to specify
the the number of significant digits to display. Drop-down menus are provided for
convenience.
I been adding new calculators
on a regular basis.
For the time being, the VBA code is password protected. At some
point, a version might be made available with full access, but during the development
stage, I prefer to not expose all my hard work for easy poaching.
A lot of effort has been expended validating calculations, including references
from books, magazines, and other software. As always, you are advised to check results
against other sources if something seems off. If you do find an error, please report
it to me ASAP so it can be corrected with the next release.
The file is in an xlsx format compatible back to Excel 2007 - and it
may work for even earlier versions.
* Note: Because
VBA code is used, you must allow Excel security to enable macros.
This edition includes the following calculators:
Posted on September 21, 2023
|
