Hi there,
Well, I have a curve obtained from a table with two columns filled with values of Distance and dots.
I need to automatically associate the number of dots to the distance, but the curve has 2 zeros so the associated dots
must be dividied into 3 regions :
(1) 9 yards to first zero =~18 yards (the dots are negative)
(2) distances above zero 18 - to 30 yards (the dots have positive values)
and
(3) distances above 30 yards and below 60 yards. (the dots again are negative)
Ex table:
Distance Dots
9 -3,8
10 -3.1
15 -0.8
20 +0.2
25 +0.3
30 0
35 -0.6
40 -1.5
45 -2.4
48 -3
50 -3.4
55 -4.6
60 -6
Find bellow the full table.
Negatives dots (distances up to first zero 18/19 yards)
(resolution half dot)
Positive dots between 18 to 30 yards
Negatives dots again above 30 yards
the standards dots range (+6 ; +5.5 ; +5;+...0...-5 ; -5,5 ; 6)
example: dot -3 (first region) the nearest value from the table gives 10 yards and also 48 yards (region 3)
How to automatically indicate for each dot (resolution say half dot) the corresponded value in yards?
I need a new table in dots of half dot resolution indicate for each half-dot the correspondent distance (the closest value) in yards as follows :
+0.5 dot corrsponds 24 yards
0 dot ; 18 and 30 yards
-0,5 dot ; 16 and 34 yards
-1 dot ;14 and 37 yards
-1.5 dot ; 13 and 40 yards
-2 dot ; 12 and 43 yards
-2,5 dot ...
-3 dot ...
-3,5 dot ...
-4 dot...
-4,5 dot...
-5 dot ...
-5,5 dot ...
-6 dot ...
And so on...for dots (-6 to +6 dots) not covered by the table are not indicated
Here it's the full table "Yards x dots"
Yards dots
9 -3,8
10 -3,1
11 -2,5
12 -2,0
13 -1,5
14 -1,1
15 -0,8
16 -0,5
17 -0,3
18 -0,1
19 0,1
20 0,2
21 0,3
22 0,3
23 0,3
24 0,4
25 0,3
26 0,3
27 0,2
28 0,2
29 0,1
30 0,0
31 -0,1
32 -0,2
33 -0,3
34 -0,5
35 -0,6
36 -0,8
37 -0,9
38 -1,1
39 -1,3
40 -1,5
41 -1,6
42 -1,8
43 -2,0
44 -2,2
45 -2,4
46 -2,6
47 -2,8
48 -3,0
49 -3,2
50 -3,4
51 -3,7
52 -3,9
53 -4,1
54 -4,4
55 -4,6
56 -4,9
57 -5,1
58 -5,4
59 -5,7
60 -6,0
Well, I have a curve obtained from a table with two columns filled with values of Distance and dots.
I need to automatically associate the number of dots to the distance, but the curve has 2 zeros so the associated dots
must be dividied into 3 regions :
(1) 9 yards to first zero =~18 yards (the dots are negative)
(2) distances above zero 18 - to 30 yards (the dots have positive values)
and
(3) distances above 30 yards and below 60 yards. (the dots again are negative)
Ex table:
Distance Dots
9 -3,8
10 -3.1
15 -0.8
20 +0.2
25 +0.3
30 0
35 -0.6
40 -1.5
45 -2.4
48 -3
50 -3.4
55 -4.6
60 -6
Find bellow the full table.
Negatives dots (distances up to first zero 18/19 yards)
(resolution half dot)
Positive dots between 18 to 30 yards
Negatives dots again above 30 yards
the standards dots range (+6 ; +5.5 ; +5;+...0...-5 ; -5,5 ; 6)
example: dot -3 (first region) the nearest value from the table gives 10 yards and also 48 yards (region 3)
How to automatically indicate for each dot (resolution say half dot) the corresponded value in yards?
I need a new table in dots of half dot resolution indicate for each half-dot the correspondent distance (the closest value) in yards as follows :
+0.5 dot corrsponds 24 yards
0 dot ; 18 and 30 yards
-0,5 dot ; 16 and 34 yards
-1 dot ;14 and 37 yards
-1.5 dot ; 13 and 40 yards
-2 dot ; 12 and 43 yards
-2,5 dot ...
-3 dot ...
-3,5 dot ...
-4 dot...
-4,5 dot...
-5 dot ...
-5,5 dot ...
-6 dot ...
And so on...for dots (-6 to +6 dots) not covered by the table are not indicated
Here it's the full table "Yards x dots"
Yards dots
9 -3,8
10 -3,1
11 -2,5
12 -2,0
13 -1,5
14 -1,1
15 -0,8
16 -0,5
17 -0,3
18 -0,1
19 0,1
20 0,2
21 0,3
22 0,3
23 0,3
24 0,4
25 0,3
26 0,3
27 0,2
28 0,2
29 0,1
30 0,0
31 -0,1
32 -0,2
33 -0,3
34 -0,5
35 -0,6
36 -0,8
37 -0,9
38 -1,1
39 -1,3
40 -1,5
41 -1,6
42 -1,8
43 -2,0
44 -2,2
45 -2,4
46 -2,6
47 -2,8
48 -3,0
49 -3,2
50 -3,4
51 -3,7
52 -3,9
53 -4,1
54 -4,4
55 -4,6
56 -4,9
57 -5,1
58 -5,4
59 -5,7
60 -6,0