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

Code 93

Code 93 is a high density barcode that contains two check characters called the C and K check characters. The regular Code 93 barcode supports 47 characters.

  • Uppercase Alphabets 'A'..'Z'
  • Numerics '0'..'9'
  • Punctuations ' ','$','%','+','-','.','/'
This barcode can also be extended using four shift characters to uniquely represent all the 128 ASCII characters. ConnectCode Code 93 barcode font/encoder supports both the basic and extended version of the barcode.

ConnectCode Code 93

ConnectCode Code 93 barcode supports up to seven different heights. These barcodes with seven different heights 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 Code93.

  • CCode93_S1
  • CCode93_S2
  • CCode93_S3
  • CCode93_S4
  • CCode93_S5
  • CCode93_S6
  • CCode93_S7
Note - If you are running the trial version, the font name will have the word "_Trial" appended to it.

Character Mappings

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

Code 93 Regular

Data Character Barcode Font Character Code93 Value
'0''0'0
'1''1'1
'2''2'2
'3''3'3
'4''4'4
'5''5'5
'6''6'6
'7''7'7
'8''8'8
'9''9'9
'A''A'10
'B''B'11
'C''C'12
'D''D'13
'E''E'14
'F''F'15
'G''G'16
'H''H'17
'I''I'18
'J''J'19
'K''K'20
'L''L'21
'M''M'22
'N''N'23
'O''O'24
'P''P'25
'Q''Q'26
'R''R'27
'S''S'28
'T''T'29
'U''U'30
'V''V'31
'W''W'32
'X''X'33
'Y''Y'34
'Z''Z'35
'-''-'36
'.''.'37
' '(space)' '(space)38
'$''$'39
'/''/'40
'+''+'41
'%''%'42
Shift 1ASCII 19343
Shift 2ASCII 19444
Shift 3ASCII 19545
Shift 4ASCII 19646
Start CharacterASCII 19747
Stop CharacterASCII 19848


Code 93 Extended

ConnectCode Code 93 barcode font is able to support the full 128 ASCII characters. However, as the substitution mechanism is not easy to perform manually, it is recommended to use this barcode through the Software Encoder or the supplied VB formulas.

Code93 Check Character
(Modulo 47)

For example if the data "12345678" is to be encoded as a barcode. The check character is calculated as follows.

  
ASCII Characters12345678 
Code 93 Values12345678 
From the rightmost digit, multiply the value by a weight starting from 1. If the weight is greater than 20, restart the value from 1. Sum up all the values.
Check C Weight*8*7*6*5*4*3*2*1 
Check Digit C Sum :1*8 + 2*7 + 3*6 + 4*5 + 5*4 + 6*3 + 7*2 + 8*1 = 120
Modulo 47 Check Digit C :120 % 47 = 26 'Q'
Code 93 Values with Check Digit C1234567826
From the rightmost digit, multiply the value by a weight starting from 1. If the weight is greater than 15, restart the value from 1. Sum up all the values.
Check K Weight*9*8*7*6*5*4*3*2*1
Check Digit K Sum :1*26 + 2*8 + 3*7 + 4*6 + 5*5 + 6*4 + 7*3 + 8*2 + 9*1 = 182
Modulo 47 Check Digit K :182 % 47 = 41 '+'


The characters "┼12345678Q+Ă" can then be keyed in to the text editor with the appropriate font selected to generate a Code 93 barcode with check characters.

How to use the Code 93 barcode font

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

Input (Into the Encoder or VB formulas): 12345678

Manual Input: ┼12345678Ă

ASCII 197 and 198 are used as the start/stop characters.

Output:



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

Input (Into the Encoder or VB formulas): ABCD

Manual Input: ┼ABCDĂ

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.




 

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