Linear Interpolation with Excel
Many people want to interpolate data they have digitized with Dagra in Microsoft Excel. Unfortunately Excel doesn’t provide an interpolation function but there is a simple approach.
Digitize Datasheets with Dagra
Numerical data from graphs in PDF datasheets can be easily incorporated into your analysis. Use Dagra to digitize the data: Import the graph from the datasheet into Dagra
Compare Data Sources
Often it is informative to plot one set of data on top of another. While light-emitting diodes are created by combining several colors on a single chip. Although your eye sees color in discrete bands, careful selection of the composite colors can appear ‘white’.
Here the spectrum of two TT Electronics Ledium Series light emitting diodes are plotted with the CIE tristimulus curves.
Using Digitized Data in Matlab
Graphs digitized with Dagra can be loaded into Matlab in three ways:
LoadDagra.mfunction for Matlab.
- Copied onto the clipboard and pasted into Matlab’s command line window, or
- Exported into a text file and imported using Matlab’s
The easiest method is using the
LoadDagra.m function because you don’t need to create a separate file or fill up Matlab’s command buffer with the imported data.
Pasting Digitized Data into Excel
Graphical data digitized using Dagra can be quickly transferred to Microsoft Excel, or any spreadsheet, using the system clipboard. Simply copy the data from Dagra. You can choose which series you want to copy. Then switch to Excel and choose Paste from the Home tab.
Energy falling on an Infrared Sensor
Dagra was used in this example to trace the transmittance of a Fresnel lens so the data could be used in MathCad.
The goal of the project was to estimate how much energy from the skin of a person would be focused onto an infrared sensor. The lens had a lot of strong absorption bands in the wavelengths we were interested in so tracing the transmission from the manufacturer’s datasheet helped provide a more accurate model.