Barcode suffix ean128
 

Hello
Can someone help me with a formula to generate the last digit of my barcode
string. ean128 (13+1 digits))

as in eksample.

A1=1234567890123
B1= "formula to generate" = "1234567890123 1" (1 is generated)
C1="B1 barcode print font (need help with this also :-)

This site does generate code http://www.gs1.no/kontrollsifferberegning/
but it takes a lot of time since i have to cut and paste each number.

Can anybody help?

Barcode suffix ean128
 

We need to be told the algorithm used.
Please confirm that this site gives the correct answer, then a formula can
be developed
http://www.ean-int.org/barcodes/supp...git_calculator
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Kurt EAN128" <Kurt wrote in message
...
Hello
Can someone help me with a formula to generate the last digit of my
barcode
string. ean128 (13+1 digits))

as in eksample.

A1=1234567890123
B1= "formula to generate" = "1234567890123 1" (1 is generated)
C1="B1 barcode print font (need help with this also :-)

This site does generate code http://www.gs1.no/kontrollsifferberegning/
but it takes a lot of time since i have to cut and paste each number.

Can anybody help?

Barcode suffix ean128
 

Using the algorithm from

and

I have come with this formula
=10-MOD(SUMPRODUCT(VALUE(MID(A1,ROW($A$1:$A$13),1)),{3 ;1;3;1;3;1;3;1;3;1;3;1;3}),10)

where A1 is the cell holding the 13-digit number. Do not change A1:A13 -
this gets the numbers {1,2,3...} Do not alter semicolons ; to commas, since
I am working in rows not columns

This formula incorrectly give 10 when the SUMPROUDCT part evaluates to zero.
SO we need to modify the formula to

=MOD(10-MOD(SUMPRODUCT(VALUE(MID(A1,ROW($A$1:$A$13),1)),{3 ;1;3;1;3;1;3;1;3;1;3;1;3}),10),10)

The trouble with using ROW is that someone might insert a reo into the
worksheet and this will mess up the formula. Here is an alternative
=MOD(10-MOD(SUMPRODUCT(VALUE(MID(A1,{1;2;3;4;5;6;7;8;9;10; 11;12;13},1)),{3;1;3;1;3;1;3;1;3;1;3;1;3}),10),10)

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Kurt EAN128" <Kurt wrote in message
...
Hello
Can someone help me with a formula to generate the last digit of my
barcode
string. ean128 (13+1 digits))

as in eksample.

A1=1234567890123
B1= "formula to generate" = "1234567890123 1" (1 is generated)
C1="B1 barcode print font (need help with this also :-)

This site does generate code http://www.gs1.no/kontrollsifferberegning/
but it takes a lot of time since i have to cut and paste each number.

Can anybody help?

Barcode suffix ean128
 

Hi Bernard
This site shows you how to calculate what I think the OP is looking for (
EAN/UCC 14 ) not EAN128: http://www.morovia.com/education/utility/upc-ean.asp,
just scroll down to EAN/UCC14, you will see the calculation.
If the OP can confirm.
Regards
John
"Bernard Liengme" wrote in message
...
We need to be told the algorithm used.
Please confirm that this site gives the correct answer, then a formula can be
developed
http://www.ean-int.org/barcodes/supp...git_calculator
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Kurt EAN128" <Kurt wrote in message
...
Hello
Can someone help me with a formula to generate the last digit of my barcode
string. ean128 (13+1 digits))

as in eksample.

A1=1234567890123
B1= "formula to generate" = "1234567890123 1" (1 is generated)
C1="B1 barcode print font (need help with this also :-)

This site does generate code http://www.gs1.no/kontrollsifferberegning/
but it takes a lot of time since i have to cut and paste each number.

Can anybody help?

Barcode suffix ean128
 

Forgot to give sites for algorithm
http://www.usps.com/cpim/ftp/pubs/pu...#_Toc481397334
http://www.ean-int.org/barcodes/supp...git_calculator

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Bernard Liengme" wrote in message
...
Using the algorithm from

and

I have come with this formula
=10-MOD(SUMPRODUCT(VALUE(MID(A1,ROW($A$1:$A$13),1)),{3 ;1;3;1;3;1;3;1;3;1;3;1;3}),10)

where A1 is the cell holding the 13-digit number. Do not change A1:A13 -
this gets the numbers {1,2,3...} Do not alter semicolons ; to commas,
since I am working in rows not columns

This formula incorrectly give 10 when the SUMPROUDCT part evaluates to
zero. SO we need to modify the formula to

=MOD(10-MOD(SUMPRODUCT(VALUE(MID(A1,ROW($A$1:$A$13),1)),{3 ;1;3;1;3;1;3;1;3;1;3;1;3}),10),10)

The trouble with using ROW is that someone might insert a reo into the
worksheet and this will mess up the formula. Here is an alternative
=MOD(10-MOD(SUMPRODUCT(VALUE(MID(A1,{1;2;3;4;5;6;7;8;9;10; 11;12;13},1)),{3;1;3;1;3;1;3;1;3;1;3;1;3}),10),10)

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Kurt EAN128" <Kurt wrote in message
...
Hello
Can someone help me with a formula to generate the last digit of my
barcode
string. ean128 (13+1 digits))

as in eksample.

A1=1234567890123
B1= "formula to generate" = "1234567890123 1" (1 is generated)
C1="B1 barcode print font (need help with this also :-)

This site does generate code http://www.gs1.no/kontrollsifferberegning/
but it takes a lot of time since i have to cut and paste each number.

Can anybody help?

I’m was preparing data in an Excel spreadsheet for import into an OpenBravoPOS database, and I needed to generate check digits for my custom barcodes. So here’s the Excel formula I came up with to generate a 13-digit barcode check digit. generate barcode ean128 with excel
please check http://www.1earthadventures.com/2010...omment-page-1/ for more