In Progress

Translate data from graps into a spreadsheet

Attached are 2 high-resolution images with 8 graphs each.

I need to transform each of the graphs into an Excel table (16 alltogether).

How to do it:

You will need to open the graphs in the graphics editor (Preview on Mac or Paint on Windows, or like...) and pick up coordinates of datapoints in pixes. Then convert these coordinates into meaningful data values and put both in excel spreadsheet.

For example for graph1 if you set 0 as the start of the coordinate space, point (100mm,100%) will have coordinates (4520,2034). This means that 100% on the vertical scale is 2034 pixels. Horizontal scale is logarithmic, which means that the interval between 10mm and 100mm can be mapped to 4520 pixels.

If we then take point (1361, 2034) it can be converted into (20mm,100%) using logarithmic scale: 10^(1361/4520 +1) = 20mm. The "+1" is because the graph is plotted in the 2nd range of the logarithmic scale (from 10 to 100).

You will need to figure out proper calculations for graphs that have more than 1 log range.

Deliverable: one excel file with 16 sheets. Each sheet should have two tables and an Excel graph.

Table 1: coordinates of all data points in pixels.

Table 2: values translated from the graphs

Graph: excel graph based on Table 2, which will look identical to the original graphs.

Skills: Data Entry, Excel, Mathematics

See more: look up translate, look translate, look for translate, log into, like translate, how to translate, how to graphs, how to graph data, how do you graph data, graph to data, graph this data, graphs with data, graphs of data, graphs for data, graphs data, graphs and data, graph of data, graph how to, graph and data, excel for windows 8, example of graphs, data to graph, data on a graph, data in graphs, data graphs

About the Employer:
( 3 reviews ) Toronto, Canada

Project ID: #1286158

Awarded to:

pishty

I am interested in your project. Please check your inbox for more details.

$80 USD in 5 days
(30 Reviews)
5.6

11 freelancers are bidding on average $128 for this job

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$225 USD in 7 days
(23 Reviews)
5.6
lambadi09

Hi, Ready to provide the (x,y) coordinates of the points in the graphs.

$50 USD in 3 days
(3 Reviews)
3.0
stefanobenamati

Bachelor degree in computer science with 10+ years experience in image processing. I got an automatic method to perform this task with big precision.

$50 USD in 2 days
(1 Review)
1.6
daniell2326

i send you a personal message

$30 USD in 5 days
(0 Reviews)
0.0
ValentinAnd

I have experence to do such job

$100 USD in 2 days
(0 Reviews)
0.0
praveena130186

I am very hardworking and work as per the client's instructions. Can do a sample work to show my ability

$100 USD in 10 days
(0 Reviews)
0.0
mmadhu999

Please give me this job to prove my self. I do work efficiently becouse I am a Mathematical student.

$75 USD in 7 days
(0 Reviews)
0.0
amarothman

I can start immediately. I can type 100 word in 1 minute. Please select me for this job. I had attend a few course about computer. I apply all the knowledge about in daily work. I know how to use Microsoft office, SP More

$250 USD in 7 days
(0 Reviews)
0.0
Irko

I wouldn't call myself a nerd ... but this job suits me well. I work accurately and fast and have lots of experience with excell and formulas and graphs.

$250 USD in 4 days
(0 Reviews)
0.0
PETRA

You can send me your graphs.

$200 USD in 7 days
(0 Reviews)
0.0