View Single Post
  #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)