Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
below is the list of hypothetical student numbers, the last digit is the
check digit. What I'd like to know is the check digit scheme used. Mod 10 algorithm doesn't work. I tried Verhoeff algorithm but it's to complicated for me. Here's the first 20 in the series... please help me. i've been trying to figure this out since yesterday. trial and error is so frustrating already. i'd appreciate also if someone can show me how to implement in vb 017012217014 017012217028 017012217031 017012217045 017012217059 017012217062 017012217076 017012217080 017012217093 017012217108 017012217111 017012217125 017012217139 017012217142 017012217156 017012217160 017012217173 017012217187 017012217190 017012217205 -- Best, Markus |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Markus,
So far it looks like a Mod 11 scheme with weight 4 on 11th digit and weight 8 on 10th digit. It dont know such a system and I could not find it in the web. Provide some more numbers with different digits for leftmost 9 digits. Regards, Bernd |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi Bernd P,
below are the additional numbers, .... 017012218000 017012218013 017012218027 017012218030 017012218044 .... 017012219009 017012219012 017012219026 017012219030 .... 017012220000 017012220014 017012220028 017012220031 -- Best, Markus "Bernd P" wrote: Hello Markus, So far it looks like a Mod 11 scheme with weight 4 on 11th digit and weight 8 on 10th digit. It dont know such a system and I could not find it in the web. Provide some more numbers with different digits for leftmost 9 digits. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a check digit | Excel Programming | |||
Creating a Check Digit | Charts and Charting in Excel | |||
Mod-10 Check Digit | Excel Worksheet Functions | |||
Check last digit in cell | Excel Programming | |||
Mod-10 Check Digit | Excel Worksheet Functions |