Excel spreadsheet from a JPG image
Solved
niko
-
st -
st -
Hello,
I need to convert a lot of 2 or 3-variable graphs into an Excel spreadsheet.
That is, be able to extract the values of the points present on the curves according to the different scales of the graphs.
I have a scanner and Excel at my disposal, but I'm not sure how to proceed because the cumbersome method would be to manually point out all my points, note them down, and insert them into a table, which would take too much time.
Does anyone have an idea, please? Maybe this has happened to some people before..
Thank you in advance
Have a nice day
Best regards
I need to convert a lot of 2 or 3-variable graphs into an Excel spreadsheet.
That is, be able to extract the values of the points present on the curves according to the different scales of the graphs.
I have a scanner and Excel at my disposal, but I'm not sure how to proceed because the cumbersome method would be to manually point out all my points, note them down, and insert them into a table, which would take too much time.
Does anyone have an idea, please? Maybe this has happened to some people before..
Thank you in advance
Have a nice day
Best regards
Configuration: Windows Vista Firefox 3.0.6
7 réponses
Hello
I found my happiness, a software in English indeed exists, it was inconceivable to me that no one thought of it among scientists, engineers or other academics...
Here is the link http://digitizer.sourceforge.net/
I think that professionals have much more powerful software, but this one is already quite good and I believe it will save me considerable time, you can re-point, set scales and even recognize graphs directly, to be used with caution..
Thank you for your help and your exchanges in any case
Best regards
I found my happiness, a software in English indeed exists, it was inconceivable to me that no one thought of it among scientists, engineers or other academics...
Here is the link http://digitizer.sourceforge.net/
I think that professionals have much more powerful software, but this one is already quite good and I believe it will save me considerable time, you can re-point, set scales and even recognize graphs directly, to be used with caution..
Thank you for your help and your exchanges in any case
Best regards
st
Perfect. That's exactly the answer to the question asked. Thank you!
No: the "heavy" method that you dislike is still the only feasible one!
Even with OCR (optical character recognition) software you could convert a table of values, but not the graphics themselves...
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂
Even with OCR (optical character recognition) software you could convert a table of values, but not the graphics themselves...
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂
Hello,
thank you for your response even if it's not the one I hoped for :-)
I still wonder if with software that could reference the axes and the graduations like GIS software with which we can geo-reference maps, I could manage to carry out this operation, but I can't see myself doing this with ArcGIS… I continue to look for a method, I tried to import an image into Excel but you can't create a graph on top of it unless you input data, the only thing I could do is retrieve the data and see if after creating scatter plots they match the original graph (not very useful)
best regards, have a nice day.
thank you for your response even if it's not the one I hoped for :-)
I still wonder if with software that could reference the axes and the graduations like GIS software with which we can geo-reference maps, I could manage to carry out this operation, but I can't see myself doing this with ArcGIS… I continue to look for a method, I tried to import an image into Excel but you can't create a graph on top of it unless you input data, the only thing I could do is retrieve the data and see if after creating scatter plots they match the original graph (not very useful)
best regards, have a nice day.
Get in touch with one of our French technopoles (south-west of Paris, Sophia Antipolis, Inovallée - ZIRST de Meylan, Futuroscope...), or with the research department of one of our leading industries (EADS, Thales, CNES ...), or even with one of our prestigious schools teaching robotics (Polytechnique, ENST, ENSTA, Arts & Métiers, INSA de Strasbourg, ISIA, ISIMA de Clermont-Ferrand ...).
Maybe you will find information on a device capable of "reading" a drawing by recording its coordinates point by point, while remaining within your budget and technological skills.
Don't dream: Throughout the 23,300 discussions contained in this forum, to my knowledge, no one has made a similar request... You therefore have an infinitesimal probability of finding someone likely to provide you with the trick you wish for!
Best regards.
--
Retirement is great! Especially in the West Indies... :-)
☻ Raymond ♂
Maybe you will find information on a device capable of "reading" a drawing by recording its coordinates point by point, while remaining within your budget and technological skills.
Don't dream: Throughout the 23,300 discussions contained in this forum, to my knowledge, no one has made a similar request... You therefore have an infinitesimal probability of finding someone likely to provide you with the trick you wish for!
Best regards.
--
Retirement is great! Especially in the West Indies... :-)
☻ Raymond ♂
Thank you very much for your information,
you can imagine that this hard work is part of my job, I am a geologist and need to gather as much data as possible from publications in order to conduct a study later on.
Thank you for your probability :-) but I am not discouraged at all, I will try the mentioned addresses perhaps.
Best regards
you can imagine that this hard work is part of my job, I am a geologist and need to gather as much data as possible from publications in order to conduct a study later on.
Thank you for your probability :-) but I am not discouraged at all, I will try the mentioned addresses perhaps.
Best regards
In addition to the organizations and schools mentioned above, it seems to me that in the world of sewing there are machines for making patterns, capable of reading and reproducing the sketches of pattern makers and designers ...
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂