Re: GTIN Generated from UPC

Carl

=MOD(10-MOD(SUMPRODUCT(--(MID(E3,{1,3,5,7,9,11},1)))*3+SUMPRODUCT(--
(MID(E3,{2,4,6,8,10},1))),10),10)

is the formula for the UPC checkdigit (12 digits)

Just add digits 12 & 13 (to the even/odd sections)

=MOD(10-MOD(SUMPRODUCT(--(MID(E3,{1,3,5,7,9,11,13},1)))*3+SUMPRODUCT(--
(MID(E3,{2,4,6,8,10,12},1))),10),10)

There are probably some on-line tools that you can use to check the
calculation...



To: From: "cmcmillan3" < Date sent: Thu, 01 Jun 2006 12:56:23 -0000
Subject: [EDI-L] GTIN Generated from UPC

> Does anyone have a tool or know the math to create a GTIN based on a
> UPC code? I had a little utitlity that did this in Excel but I cannot
> find it. I need to create 3 GTIN's and am going crazy.
> Any help is appreciated.
> -Carl
>
>
>
>
>
>
> ...
> Please use the following Message Identifiers as your subject prefix: <SALES>,
> <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
>
> Job postings are welcome, but for job postings or requests for work: <JOBS> IS
> REQUIRED in the subject line as a prefix.
>
> Access the list online at: http://groups.yahoo.com/group/EDI-L
> RSS feed is: http://rss.groups.yahoo.com/group/EDI-L/rss
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> __________ NOD32 1.1572 (20060601) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>

Earl Wertheimer
http://www.spe-edi.com