Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- ULS Design Functions 2.13
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Fitting high order polynomials
Recent Comments
Tag Archives: digitize scanned image
DigitGraph Spreadsheet and WebPlot Digitiser
I have posted here previously a spreadsheet that allows XY data to be extracted from images of graphs, maps or other images of objects in a single plane: How to digitise a scanned image. I have updated the instructions for the … Continue reading
Posted in Charts, Charts, Computing - general, Curve fitting, Drawing, Excel, UDFs, VBA
Tagged DigitGraph, digitize scanned image, Excel, UDF, VBA, WebPlot Digitizer
5 Comments
Daily Download 10: Excel Digitiser
See How to digitise a scanned image and Digitising logarithmic scales. This spreadsheet provides a function to retrieve coordinates of lines traced over a scanned image. Download from: http://interactiveds.com.au/software/DigitGraph.zip Example images:
Posted in Drawing, Excel, Newton, UDFs, VBA
Tagged DigitGraph, digitize scanned image, Excel, UDF, VBA
Leave a comment
Digitising logarithmic scales
At the suggestion of the Exceltipsmonster, I have modified the DigitGraph spreadsheet presented in the previous post to also work with logarithmic scales. Dowload the updated spreadsheet from here. The function now has two additional optional arguments, Xlog and Ylog: =DigitGraph(Shape Name, … Continue reading
Posted in Excel, UDFs, VBA
Tagged digitize scanned image, Excel, loarithmic scale, UDF, VBA
4 Comments
How to digitise a scanned image
For instance, suppose we had a graph from a technical paper, and we wanted to extract numerical data from the graph lines. One way would be to measure the points by hand and calculate the numbers by scaling from the … Continue reading