Applied Physics 186 or Instrumentation 2 is a course on Digital Image Processing. For our first activity, we searched for old hand drawn plots of scientific data. The aim of the activity is to reproduce the plot using a spreadsheet software.
Figure 1 is a plot of Butyl rubber's continuous and intermittent stress relaxation at 130 Centigrade and 50% elongation. The y-axis is the ratio of stretched and unstretched length. The x-axis is time in hours. For this activity, the plot of interest is the continuous stress relaxation (Fig. 2).
Figure 1. Hand-drawn plot of Butyl rubber's stress relaxation
Figure 2. Original plot was cleaned using MS Paint to display only the plot of continuous stress relaxation
To reproduce this plot, the numerical values of each data point was determined. As a digital image, the pixel location of each data point can be easily obtained. I used Inkscape, a vector graphics program, to determine each pixel location.
To convert each data point to numerical values, one must determine the conversion factor for the x and y axes.
To reproduce this plot, the numerical values of each data point was determined. As a digital image, the pixel location of each data point can be easily obtained. I used Inkscape, a vector graphics program, to determine each pixel location.
To convert each data point to numerical values, one must determine the conversion factor for the x and y axes.
conversion factor (CF) = (Nmax-Nmin)/(Pmax-Pmin)
For the y-axis,
CF = (10-0)(340.39-109.24)
where 340.39 and 109.24 are the pixel locations corresponding to 10 and 0 along the y-axis. The same procedure is done for the x-axis.
The numerical value for a data point is simply,
N = CF x (P-Pmin)
Armed with the numerical value of each data point, a reproduction of the original plot can be easily generated using the OpenOffice Calc and applying cubic spline smoothing.
For the y-axis,
CF = (10-0)(340.39-109.24)
where 340.39 and 109.24 are the pixel locations corresponding to 10 and 0 along the y-axis. The same procedure is done for the x-axis.
The numerical value for a data point is simply,
N = CF x (P-Pmin)
Armed with the numerical value of each data point, a reproduction of the original plot can be easily generated using the OpenOffice Calc and applying cubic spline smoothing.
Figure 3. Original plot and reproduction. Both axes are retained to ensure that the plots are properly scaled
References:The superposition of the reproduction and original was easily generated with David's tip from Dr. Soriano's blog. Thanks to Dr. Soriano for the advice and the CS Lib staff for allowing me to use the journals without finishing my registration.
I give myself a 10 in this activity. I finished it on time and I like the final plot. Conversion was successful, with small deviations that can be from the image being skewed when it was photocopied or scanned. Some difficulty was encountered during the superposition of the reconstruction with the original data. One must remember to restart their OpenOffice Calc after uploading the original image as bitmap area fill.
I give myself a 10 in this activity. I finished it on time and I like the final plot. Conversion was successful, with small deviations that can be from the image being skewed when it was photocopied or scanned. Some difficulty was encountered during the superposition of the reconstruction with the original data. One must remember to restart their OpenOffice Calc after uploading the original image as bitmap area fill.
2. E. David. Inserting Images as Background for OpenOffice Calc Graphs. 2008.
No comments:
Post a Comment