Math Problem

[robs]

Off-topic but maybe someone can help.

An applicaton outputs values in sets of 3. The values in the third collumn are the result of the first and second. How are the values in the third collumn obtained knowing only the values from the first two collumns?

1st  2nd     3rd (result)
10   0   1
20   0   2
30   0   3
40   0   4
50   0   5
60   0   6
70   0   7
80   0   8
90   0   9
100   0   10
110   0   11
120   0   12
130   0   13
140   0   14
150   0   15
160   0   16
170   0   17
180   0   18
190   0   19
200   0   20
210   0   21
220   0   22
230   0   23
240   0   24
250   0   25
04   1   26
14   1   27
24   1   28
34   1   29
44   1   30
54   1   31
64   1   32
74   1   33
84   1   34
94   1   35
104   1   36
114   1   37
124   1   38
134   1   39
144   1   40
154   1   41
164   1   42
174   1   43
184   1   44
194   1   45
204   1   46
214   1   47
224   1   48
234   1   49
244   1   50
254   1   51
8   2   52
18   2   53
28   2   54
38   2   55
48   2   56
58   2   57
68   2   58
78   2   59
88   2   60
98   2   61
108   2   62
118   2   63
128   2   64
138   2   65
148   2   66
158   2   67
168   2   68
178   2   69
188   2   70
198   2   71
208   2   72
218   2   73
228   2   74
238   2   75
248   2   76
2   3   77   
12   3   78
22   3   79
32   3   80
42   3   81
52   3   82
62   3   83
72   3   84
82   3   85
92   3   86
102   3   87
112   3   88
122   3   89
132   3   90
142   3   91
152   3   92
162   3   93
172   3   94
182   3   95
192   3   96
202   3   97
212   3   98
222   3   99
232   3   100
242   3   101

[Arcs_n_Sparks]

robs,

The answer to your question:

Divide the first number by 10, using only the integer remainder. Add that to 26 times the 2nd number.

Arcs_n_Sparks

[Arcs_n_Sparks]

Ouch! Turns out my formula does not work for every case. I guess I was premature.

Arcs_n_Sparks

[robs]

Thanks anyway Arcs_n_Sparks. Don't let it drive you made. I didn't sleep last night.

I do think that 26 is involved somehow. each group of 0, 1, 2, 3 is 26 in length.

I was also going this route (ie. for the number 14)
4 * 8 = 32
10 - 5 (which is the 4 + 1) = 5
32 - 5 = 27

Doesn't work for all though. Going this route I don't know how 0,1,2,3 (2nd collumn come to play)

rob

[robs]

Ouch! Turns out my formula does not work for every case. I guess I was premature.

Arcs_n_Sparks

Arcs-

Thanks, you got me much much closer than I was. So it looks like once we get to 3
for the second collumn, everything is off by 1. I double checked my data - it is accurate.

Thanks again!
rob

[Arcs_n_Sparks]

robs,

The problem is complicated because there are not the same "number of numbers" for each sequence of the second digit. 25 numbers for 2nd number = 0, 26 for 2nd number = 1, then back to 25 digits for 2nd number = 2 and 3. Are you sure your application is generating the sequence you published?

Arcs_n_Sparks

[robs]

robs,

The problem is complicated because there are not the same "number of numbers" for each sequence of the second digit. 25 numbers for 2nd number = 0, 26 for 2nd number = 1, then back to 25 digits for 2nd number = 2 and 3. Are you sure your application is generating the sequence you published?

Arcs_n_Sparks

Yes I'm sure. I was able to obtain a second sample. I will post soon.
rob

[Oldman]

You guys are hurting my brain... *Olds goes off to work on something he can handle... Ms. Olds.  ::) *

At least with her I understand the math.... Let's see 5 foot 2, with eyes of Blue and a double D 38.......   I like her math better  ;D

Sorry about the jack...but let's face it.... my math problem is in hand!

[robs]

New Sample: (1-101 hasn't changed). I wish I could talk about the application but I can't.
The type of application isn't relevant. I don't want anyone loosing sleep over this.

1st# 2nd#   Translates to
10   0   1
20   0   2
30   0   3
40   0   4
50   0   5
60   0   6
70   0   7
80   0   8
90   0   9
100   0   10
110   0   11
120   0   12
130   0   13
140   0   14
150   0   15
160   0   16
170   0   17
180   0   18
190   0   19
200   0   20
210   0   21
220   0   22
230   0   23
240   0   24
250   0   25
04   1   26
14   1   27
24   1   28
34   1   29
44   1   30
54   1   31
64   1   32
74   1   33
84   1   34
94   1   35
104   1   36
114   1   37
124   1   38
134   1   39
144   1   40
154   1   41
164   1   42
174   1   43
184   1   44
194   1   45
204   1   46
214   1   47
224   1   48
234   1   49
244   1   50
254   1   51
8   2   52
18   2   53
28   2   54
38   2   55
48   2   56
58   2   57
68   2   58
78   2   59
88   2   60
98   2   61
108   2   62
118   2   63
128   2   64
138   2   65
148   2   66
158   2   67
168   2   68
178   2   69
188   2   70
198   2   71
208   2   72
218   2   73
228   2   74
238   2   75
248   2   76
2   3   77   
12   3   78
22   3   79
32   3   80
42   3   81
52   3   82
62   3   83
72   3   84
82   3   85
92   3   86
102   3   87
112   3   88
122   3   89
132   3   90
142   3   91
152   3   92
162   3   93
172   3   94
182   3   95
192   3   96
202   3   97
212   3   98
222   3   99
232   3   100
242   3   101
252   3   102
6   4   103
16   4   104
26   4   105
36   4   106
46   4   107
56   4   108
66   4   109
76   4   110
86   4   111
96   4   112
106   4   113
116   4   114
126   4   115
136   4   116
146   4   117
156   4   118
166   4   119
176   4   120
186   4   121
196   4   122
206   4   123
216   4   124
226   4   125
236   4   126
246   4   127
0   5   128
10   5   129
20   5   130
30   5   131
40   5   132
50   5   133
60   5   134
70   5   135
80   5   136
90   5   137
100   5   138
110   5   139
120   5   140
130   5   141
140   5   142
150   5   143
160   5   144
170   5   145
180   5   146
190   5   147
200   5   148
210   5   149
220   5   150
230   5   151
240   5   152
250   5   153
4   6   154
14   6   155
24   6   156
34   6   157
44   6   158
54   6   159
64   6   160
74   6   161
84   6   162
94   6   163
104   6   164
114   6   165
124   6   166
134   6   167
144   6   168
154   6   169
164   6   170
174   6   171
184   6   172
194   6   173
204   6   174
214   6   175
224   6   176
234   6   177
244   6   178
254   6   179
8   7   180
18   7   181
28   7   182
38   7   183
48   7   184
58   7   185
68   7   186
78   7   187
88   7   188
98   7   189
108   7   190
118   7   191
128   7   192
138   7   193
148   7   194
158   7   195
168   7   196
178   7   197
188   7   198
198   7   199
208   7   200
218   7   201
228   7   202
238   7   203
248   7   204
2   8   205
12   8   206
22   8   207
32   8   208
42   8   209
52   8   210
62   8   211
72   8   212
82   8   213
92   8   214
102   8   215
112   8   216
122   8   217
132   8   218
142   8   219
152   8   220
162   8   221
172   8   222
182   8   223
192   8   224
202   8   225
212   8   226
222   8   227
232   8   228
242   8   229
252   8   230
6   9   231
16   9   232
26   9   233
36   9   234
46   9   235
56   9   236
66   9   237
76   9   238
86   9   239
96   9   240
106   9   241
116   9   242
126   9   243
136   9   244
146   9   245
156   9   246
166   9   247
176   9   248
186   9   249
196   9   250
206   9   251
216   9   252
226   9   253
236   9   254
246   9   255
0   10   256
10   10   257
20   10   258
30   10   259
40   10   260
50   10   261
60   10   262
70   10   263
80   10   264
90   10   265
100   10   266
110   10   267
120   10   268
130   10   269
140   10   270
150   10   271
160   10   272
170   10   273
180   10   274
190   10   275
200   10   276
210   10   277
220   10   278
230   10   279
240   10   280
250   10   281
4   11   282
14   11   283
24   11   284
34   11   285
44   11   286
54   11   287
64   11   288
74   11   289
84   11   290
94   11   291
104   11   292
114   11   293
124   11   294
134   11   295
144   11   296
154   11   297
164   11   298
174   11   299
184   11   300
194   11   301
204   11   302
214   11   303
224   11   304
234   11   305
244   11   306
254   11   307

[robs]

You guys are hurting my brain... *Olds goes off to work on something he can handle... Ms. Olds.  ::) *

At least with her I understand the math.... Let's see 5 foot 2, with eyes of Blue and a double D 38.......   I like her math better  ;D

Sorry about the jack...but let's face it.... my math problem is in hand!

...math problem in hand. double D 38. Very clever Oldman.

I would have made this into a contest for pucks if I could afford it. That would have produced a quick answer!

I think I hooked Arcs in. The beast has him. I'm guessing he's an engineer of some sorts...or very competitive.

rob

[Oldman]

...math problem in hand. double D 38. Very clever Oldman.

The neat part of my math problem is...she really is 5 foot 2 with eyes of blue and those are truely double D 38s.... but the hardest part is the division... just can't make up my mind on that one. However, the 1 + 1 = 2 I got down pat.  ;D

Ok I won't jack this thread anymore...

[Arcs_n_Sparks]

robs,

I won't touch the Oldman post  ;)

The answer to your problem (at least for the series you provided) is:

(1st digit * 0.1) + (2nd digit * 25.6)

Arcs_n_Sparks

[robs]

robs,

I won't touch the Oldman post  ;)

The answer to your problem (at least for the series you provided) is:

(1st digit * 0.1) + (2nd digit * 25.6)

Arcs_n_Sparks

Arcs_n_Sparks -
I will verify. You can be king for the rest of the weekend. I will make it up to you some day.

Profesion?

rob

[robs]

robs,

I won't touch the Oldman post  ;)

The answer to your problem (at least for the series you provided) is:

(1st digit * 0.1) + (2nd digit * 25.6)

Arcs_n_Sparks

Unbelievable. You win all the marbles. I won't forget this.

Just to clarify - it's (digits in 1st column * 0.1) + (digits in 2nd column * 25.6)

Thanks Arcs

rob

[Arcs_n_Sparks]

robs,

Yes, you have the math correct. You can plug it into an Excel spreadsheet and verify. The 25.6 suggests a binary progression, which is probably expected for your GIS application, but somewhat unusual.

Arcs_n_Sparks