How a Coffee Packaging Machine Educated Me Aubrey Kagan 7/18/2014 15 comments One of my first projects was to design a control for a coffee packaging machine. It was in the late 70s and microprocessors were on everybody's lips, but few actually knew anything about them.
Excel-Optimizing Resistor Ratios, Part 1 Aubrey Kagan 6/10/2014 19 comments I have often wondered whether the practice of using a ratio of two resistors to determine a particular output is a fundamental property of electronics or a concerted effort by designers.
Excel: Taken for Granted, Part 1 Aubrey Kagan 5/7/2014 22 comments When I started my blogs on Excel, I launched straight into it without any mention of some of the simple features that you may or may not know. As I move on, I think perhaps I should cover some of these features.
Excel: Conditional Formatting Aubrey Kagan 3/12/2014 40 comments When you right click on an Excel worksheet cell, you can change its numeric type, alignment, background color, and other properties. But did you know that you can have the cell change its format if different conditions are met?
Temperature Measurement, Part 1 Aubrey Kagan 3/6/2014 29 comments This series of Temperature Measurement blogs was first published on the late, lamented forum, Microcontroller Central. I have modified it very slightly.
Analog Isolation Techniques, Part 3 Aubrey Kagan 12/13/2013 6 comments Galvanic isolation of signals can be difficult. Isolation of analog signals can be even more difficult. Here are some techniques to explore and devices to use.
Analog Isolation Techniques: Part 2 Aubrey Kagan 12/12/2013 6 comments Galvanic isolation of signals can be difficult. Isolation of analog signals can be even more difficult. Here are some techniques to explore and devices to use.
Using Solver in Excel, Part 2 Aubrey Kagan 11/7/2013 18 comments One of the add-ins for Excel is Solver. It allows you to easily solve problems with multiple variables. Here's how to install and use it.
Using Solver in Excel, Part 1 Aubrey Kagan 11/6/2013 16 comments One of the add-ins for Excel is Solver. It allows you to easily solve problems with multiple variables. Here's how to install and use it.
Calibration, Part 2 Aubrey Kagan 9/20/2013 7 comments Continuing the discussion from Part 1, how do you ensure accuracy? How do you perform the calibration? On what reference is this calibration technique based? How does noise affect calibration?
Calibration, Part 1 Aubrey Kagan 9/9/2013 20 comments Analog measuring devices should be calibrated to ensure accuracy. How do you perform the calibration? At how many points? And on what is this calibration technique based?
RMS Measurement Aubrey Kagan 8/23/2013 12 comments How do you make a true RMS measurement of a complex (non-sinusoidal) waveform? There are various techniques.
What keeps the Internet of Things from becoming a tangled jumble of incoming data from various connected devices? And within a single device that feeds information into the IoT, how does sensor fusion work?