:: Subscribe to our newsletter
 
Articles / Directory
02/10/2012
Latest version of TraderCode(v5.5) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



1/04/2011
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



9/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



1/02/2009
Launch of NeuralCode(v1.0) for
Neural Networks Trading.



8/06/2008
Launch of ConnectCode Excel Training Courses. Get this
Free Excel Training (over 100 pages) now.



7/23/2008
ConnectCode Text Manager - add-in that enhances your productivity when working with text in Excel.



6/17/2008
ConnectCode Number Manager - add-in that enhances your productivity when working with numbers in Excel.



6/3/2008
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



2/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of
TinyGraphs - add in for creating sparklines and tiny charts in Excel.

UCC/EAN Barcode

UCC/EAN is an international barcode format used widely by many different companies. It uses a list of Application Identifiers (AI) for identifying the structure and format of the data in the barcode. For example, AI 00 is used for identifying a 18 digits Serial Shipping Container Code.

The UCC/EAN uses the Code 128 barcode font and specifically the Code 128 Auto character set.

Barcode Font Details

UCC/EAN uses the Code128 barcode fonts as shown below.

  • CCode128_S1
  • CCode128_S2
  • CCode128_S3
  • CCode128_S4
  • CCode128_S5
  • CCode128_S6
  • CCode128_S7
Character Mappings

UPC/EAN barcodes support only numeric characters. However the data characters do not have a direct mapping as in other barcodes. The mapping of the characters depends on a Parity Map table. The mechanism is complex and thus it is recommended to use the Encoder or Macros / Formulas provided in ConnectCode to generate these barcodes.

Control Characters

Data Character Barcode Font Character
EAN13/EAN8/UPCA Start Character'['
EAN13/EAN8/UPCA Stop Character']'
EAN13/UPCA Center Guard Bar Character'-'
UPCE Start Character'{'
UPCE Stop Character'}'
EXT2/EXT5 Start Character'<'
EXT2/EXT5 Separator Character'+'


Text Only Characters without barcode bars and spaces (This is only avaliable in the fonts with Human Text)

Data Character Barcode Font Character
'0''!'
'1''"'
'2''#'
'3''$'
'4''%'
'5''&'
'6''''
'7''('
'8'')'
'9''*'


Left Odd Parity

Data Character Barcode Font Character
'0''0'
'1''1'
'2''2'
'3''3'
'4''4'
'5''5'
'6''6'
'7''7'
'8''8'
'9''9'


Left Even Parity

Data Character Barcode Font Character
'0''o'
'1''p'
'2''q'
'3''r'
'4''s'
'5''t'
'6''u'
'7''v'
'8''w'
'9''x'


Right Parity

Data Character Barcode Font Character
'0''a'
'1''b'
'2''c'
'3''d'
'4''e'
'5''f'
'6''g'
'7''h'
'8''i'
'9''j'


How to use the UCC/EAN Barcode Font

It is recommended to use the Encoder or Visual Basic formulas provided to generate UCC/EAN barcodes as there are several steps required for transforming the input data to characters recognized by the barcode font. For example, to encode AI 00 (Serial Shipping Container Code) with the data 123456789012345675


Input (Into the Encoder or Visual Basic formulas):

(00)123456789012345675

The brackets are used to identify the AI(Application Identifier) in the Encoder.

Output:





Concatenating multiple AIs in a UCC/EAN Barcode

Input (Into the Encoder or VB formulas):

(00)123456789012345675(12)1A

Multiple AIs in can be concatenated together as shown above. A total of up to 8 AIs concatenation is supported by ConnectCode.

Output:






 


Copyright (c) 2007-2015, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners