datasheets.com EBN.com EDN.com EETimes.com Embedded.com PlanetAnalog.com TechOnline.com   UBM Tech
UBM Tech
Home    Bloggers    Blogs    Article Archives    Messages    About Us   
Tw  |  Fb  |  In  |  Rss
Aubrey Kagan
Latest Content
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 2
Aubrey Kagan  
6/18/2014   11 comments
Aubrey Kagan has completed the series on Excel that he set out to write nearly two years ago.
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: Using the Validate Data Feature
Aubrey Kagan  
6/2/2014   4 comments
In this blog I will attempt to show how to use the data validate feature to simplify data input to a worksheet.
Excel: Taken for Granted, Part 3
Aubrey Kagan  
5/27/2014   38 comments
Documentation of all projects is important, and Excel provides a method for that by allowing comments to be associated with a cell.
Excel: Taken for Granted, Part 2
Aubrey Kagan  
5/22/2014   32 comments
Moving around an Excel worksheet, especially a large one, can be challenging.
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.
Temperature Measurement, Part 5
Aubrey Kagan  
4/25/2014   34 comments
This is the conclusion of Aubrey Kagan's series on temperature measurement.
Temperature Measurement, Part 4
Aubrey Kagan  
4/25/2014   39 comments
The topic of integrated temperature sensors.
Temperature Measurement, Part 3
Aubrey Kagan  
4/21/2014   17 comments
The basic sensor is normally just a diode, and you could stick with just that if it suits your purposes.
Temperature Measurement, Part 2
Aubrey Kagan  
4/3/2014   13 comments
In this blog I will deal with converting the temperature into electronic signals and start with purely analog conversion.
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.
Microsoft Excel: Tips & Tricks for Lookup Tables
Aubrey Kagan  
1/30/2014   20 comments
Excel includes lookup tables that can be accessed in an interesting number of ways. The tables Aubrey Kagan presents here are vertical, but there will always be an equivalent function in the horizontal axis.
Excel Curve Fitting & Linearization, Part 2
Aubrey Kagan  
1/9/2014   8 comments
Excel has capabilities to do curve fitting based on collected data -- and it's far easier than doing the work by hand.
Excel Curve Fitting & Linearization, Part 1
Aubrey Kagan  
1/8/2014   26 comments
Excel has capabilities to do curve fitting based on collected data -- and it's far easier than doing the work by hand.
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.
Analog Isolation Techniques: Part 1
Aubrey Kagan  
12/11/2013   Post a comment
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.
Trace Signals From Behind Closed Doors
Aubrey Kagan  
10/24/2013   6 comments
A repost from the former Microcontroller Central of a blog on modular, portable 'scope/data acquisition system.
Using Data Tables in Excel
Aubrey Kagan  
10/2/2013   18 comments
Using the Data Table capability in Excel to explore the results of varying one or two component values in a circuit.
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.
Explore Design Sensitivity Using Excel's Scenario
Aubrey Kagan  
8/9/2013   1 comment
Excel can not only perform some of your design calculations, it offers a relatively quick way to perform "what-if" analysis.
Use Excel Goal Seek to Solve Design Equations
Aubrey Kagan  
6/21/2013   Post a comment
Aubrey (long accused of being an Excel evangelist) offers a tip on a quick way to solve design equations using, well, Excel.




latest blogs
Here is the third of three short tech nuggets, by Rich Nowakowski from TI, before our “Ask the Experts” session on Wednesday, July 23, at 1:00 p.m. ET (10:00 a.m. PT).
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?
Supercapacitor technology is gaining momentum for improving the reliability of engine starting, extending battery life, expanding temperature range, and reducing replacement costs.
Here is the second of three short tech nuggets before our “Ask the Experts” session on Wednesday, July 23 at 1:00 p.m. ET (10:00 a.m. PT).
Here is the first of three short tech nuggets before our "Ask the experts" session on Wednesday, July 23 at 1:00 p.m. ET (10:00 a.m. PT).
flash poll
educational resources
 
follow Planet Analog on Twitter
Planet Analog Twitter Feed
like us on facebook
our partners
Planet Analog
About Us     Contact Us     Help     Register     Twitter     Facebook     RSS