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
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
Ouch! Turns out my formula does not work for every case. I guess I was premature.
Arcs_n_Sparks
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
Quote from: Arcs_n_Sparks on August 26, 2006, 12:16:00 PM
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
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
Quote from: Arcs_n_Sparks on August 26, 2006, 03:59:01 PM
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
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!
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
Quote from: Oldman on August 26, 2006, 04:51:10 PM
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
Quote...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...
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
Quote from: Arcs_n_Sparks on August 26, 2006, 06:36:00 PM
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
Quote from: robs on August 26, 2006, 06:38:54 PM
Quote from: Arcs_n_Sparks on August 26, 2006, 06:36:00 PM
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
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
Quote from: Arcs_n_Sparks on August 26, 2006, 07:13:25 PM
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
Arcs_n_Sparks - Very good. Yes, it checks out. GIS application? Do I have a stalker? ;)
Thanks a million.
rob
Quote from: robs on August 26, 2006, 07:16:24 PM
Quote from: Arcs_n_Sparks on August 26, 2006, 07:13:25 PM
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
Arcs_n_Sparks - Very good. Yes, it checks out. GIS application? Do I have a stalker? ;)
Thanks a million.
rob
I am merely responding to the information you posted on the forum... 8) 8) 8)
Arcin' & Sparkin'
QuoteThe answer to your problem (at least for the series you provided) is:
(1st digit * 0.1) + (2nd digit * 25.6) ...You can plug it into an Excel spreadsheet and verify
Gee I could have told you that! You see the 1st D (digit) * 38 + the 2nd D (digit) * 38 = D squared to the 38 power and when I plug it into her spreadsheet no verification is needed as the equation only grows~~!
;D
Quote from: Oldman on August 27, 2006, 01:31:52 AM
QuoteThe answer to your problem (at least for the series you provided) is:
(1st digit * 0.1) + (2nd digit * 25.6) ...You can plug it into an Excel spreadsheet and verify
Gee I could have told you that! You see the 1st D (digit) * 38 + the 2nd D (digit) * 38 = D squared to the 38 power and when I plug it into her spreadsheet no verification is needed as the equation only grows~~!
;D
Olds,
Hopefully, you have an accountant for your business.... :D
Am I missing something.???
If 10x + 0 =1.0, then x=0.1
If 4x +y=26, where x=0.1
Then 0.4 +y=26
And y=25.6
TomG,
Missing nothing. Two equations with two unknowns will always yield a solution. The only question was whether the solution held over the range of numbers robs had. Fortunately, it was a linear progression.
Arcs_n_Sparks
Quote from: Arcs_n_Sparks on August 27, 2006, 09:31:09 AM
TomG,
Missing nothing. Two equations with two unknowns will always yield a solution. The only question was whether the solution held over the range of numbers robs had. Fortunately, it was a linear progression.
Arcs_n_Sparks
What he said.