Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default check digit scheme: mod 10 or what?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 806
Default check digit scheme: mod 10 or what?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default check digit scheme: mod 10 or what?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a check digit Patrick Excel Programming 1 February 20th 06 05:18 PM
Creating a Check Digit Ilan Charts and Charting in Excel 1 December 3rd 05 12:43 PM
Mod-10 Check Digit Union70 Excel Worksheet Functions 1 March 24th 05 11:35 PM
Check last digit in cell NacellesEng Excel Programming 1 March 14th 05 09:26 PM
Mod-10 Check Digit Union70 Excel Worksheet Functions 4 March 8th 05 07:58 AM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"