you mean like some type of program where you input the DOB and it automatically returns the code? i'd love to see something like that, unfortunately i'm not a programmer, although if someone was interested that had programming skills i could provide them with the info on how the DOB code works to make it a reality.
Yeah basically that's what I'm looking for.
This is where I've gotten to so far (based on looking at your excel file).
For dates from 14-04-1967 to 16-09-1989
Code 1 = (numDays % 4) * 64
Code 2 = (numDays / 4) % 256
Code 3 = numDays / 1024 + 216
For dates from 17-09-1989 to 04-06-2079
Code 1 = (numDays % 8) * 32
Code 2 = (numDays / 8) % 256
Code 3 = numDays / 2048 + 224
where numDays is the difference in days between the DOB and the lowest date (i.e. 14-04-1967).
% returns the remainder after division. (5 % 2 = 1).
/ returns the whole number (what's it called?) after division (5 / 2 = 2).