Exetools  

Go Back   Exetools > General > General Discussion

Notices

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 09-15-2017, 06:37
psgama psgama is offline
Friend
 
Join Date: Jul 2014
Posts: 101
Rept. Given: 0
Rept. Rcvd 6 Times in 6 Posts
Thanks Given: 12
Thanks Rcvd at 75 Times in 44 Posts
psgama Reputation: 6
I solved it.

*SPOILER ALERT* FOR THOSE WHO WISH TO TAKE A CRACK AT IT.






I broke the equation down to the factors that made sense and worked out the patterns from there. In Excel if A2 contained the DevID the serial number would equal


Code:
*****SPOILER ALERT******
=((10000+(RIGHT(A2,1)+3)+((LEFT(RIGHT(A2,2),1)+7)*10)+((LEFT(RIGHT(A2,3),1)-3)*100))*857)+660

A complex problem broken down into patterns of numbers based on an input / output table of 10 original pairs. I'm feeling pretty darn good right now!

Last edited by psgama; 09-18-2017 at 01:52.
Reply With Quote
The Following 4 Users Say Thank You to psgama For This Useful Post:
bolo2002 (09-15-2017), niculaita (09-17-2017), silver (09-15-2017), tonyweb (09-15-2017)
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
one newbie question SubzEro General Discussion 7 03-12-2015 06:05
Newbie needs help again MrCracking General Discussion 6 03-22-2004 19:51
Newbie need help MrCracking General Discussion 2 03-10-2004 05:38
Newbie needs help :) Please. knight General Discussion 1 02-25-2004 15:42


All times are GMT +8. The time now is 17:12.


Always Your Best Friend: Aaron, JMI, ahmadmansoor, ZeNiX, chessgod101
( Since 1998 )