:: 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.



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.

ITF14

ITF14 is a 14 digits barcode used to mark the external containers of products with a EAN identifier. It is based on the I2of5 barcode. ITF14 barcodes usually contain a top and bottom bar (or a rectangle) called the Bearers bar. The purpose of the Bearers bar is to make sure that the barcode is read completely.

Barcode Font Names and Sizes

ConnectCode ITF barcode supports up to seven different heights. These barcodes are provided in seven fonts with different names. The barcode names are appended with characters like "S1" or "S2" etc... with each one of them representing a different height. The list below illustrates the seven different fonts that is supplied for ITF.

  • CCodeITF_S1
  • CCodeITF_S2
  • CCodeITF_S3
  • CCodeITF_S4
  • CCodeITF_S5
  • CCodeITF_S6
  • CCodeITF_S7


ITF14 Character Mappings

All characters supported by the barcode is as shown below. All of them have a simple a direct mapping.

Control Character Barcode Font Character
Start Character (Top/Down Bearers Bar)'{'
Stop Character (Top/Down Bearers Bar)'}'
Start Character (Rectangle Bearers Bar)'|'
Stop Character (Rectangle Bearers Bar)'~'


Data Character Barcode Font Character
00' '
01'!'
02'"'
03'#'
04'$'
05'%'
06'&'
07'''
08'('
09')'
10'*'
11'+'
12','
13'-'
14'.'
15'/'
16'0'
17'1'
18'2'
19'3'
20'4'
21'5'
22'6'
23'7'
24'8'
25'9'
26':'
27';'
28'<'
29'='
30'>'
31'?'
32'@'
33'A'
34'B'
35'C'
36'D'
37'E'
38'F'
39'G'
40'H'
41'I'
42'J'
43'K'
44'L'
45'M'
46'N'
47'O'
48'P'
49'Q'
50'R'
51'S'
52'T'
Data Character Barcode Font Character
53'U'
54'V'
55'W'
56'X'
57'Y'
58'Z'
59'['
60'\'
61']'
62'^'
63'_'
64'`'
65'a'
66'b'
67'c'
68'd'
69'e'
70'f'
71'g'
72'h'
73'i'
74'j'
75'k'
76'l'
77'm'
78'n'
79'o'
80'p'
81'q'
82'r'
83's'
84't'
85'u'
86'v'
87'w'
88'x'
89'y'
90'z'
91191 (ASCII Decimal Value)
92192 (ASCII Decimal Value)
93193 (ASCII Decimal Value)
94194 (ASCII Decimal Value)
95195 (ASCII Decimal Value)
96196 (ASCII Decimal Value)
97197 (ASCII Decimal Value)
98198 (ASCII Decimal Value)
99199 (ASCII Decimal Value)


The ITF14 Check Digit

For example, the calculation of the check digit of the data string "0001234567890" is calculated as follows.

Data0001234567890
Starting from the last digit, multiply by 3 followed by 1.
*3*1*3*3*1*3*1*3*3*1*3*1*3
Sum : (0*1) + (0*3) + (0*1) + (1*3) + (2*1) + (3*3) + (4*1) + (5*3) + (6*1) + (7*3) + (8*1) + (9*3) + (0*1) = 85
If Sum Modulo 10 equals 0, the result is 0. Otherwise the result is 10 - (Sum Modulo 10)
Modulo 10 :10 - (85 % 10) = 5
Data to be encoded00012345678905
Mapping00 = ' ' , 01 = '!' , 23 = '7' , 45='M' , 67='c' , 89 = 'y' , 05 = '%'


The characters "{ !7Mcy%}" can then be keyed in to the text editor with the appropriate font selected to generate a ITF14 barcode with check digit.


Using ConnectCode's ITF14 Barcode Font

For example, to encode the data "0001234567890", you can key in the following in your text editor and choose the ITF14 barcode font.

Input (Into the Encoder or VB formulas): 0001234567890 (Generate Check Digit)

Manual Input: { !7Mcy%}

Output:



Input (Into the Encoder or VB formulas): 0001234567890 (With Rectangle Bearers Bar)

Manual Input: " !7Mcy%"

Note - The first " is Ascii 147 and the second one is Ascii 148.

Output:



If you are using the Encoder, it will automatically put in the start/stop characters for you and allow you to choose the optional check character. On top of that, automatic padding of '0' to make the data contain 14 digits will be carried out.




 

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