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






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.



3/5/2008
Release of
ConnectCode Deluxe Add-In - a collection of commonly used add-ins for Excel. It includes Formula Report Generator, Dynamic Ranges Namer, Conditional Row Deletion, Scheduler and many more.



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.


Links:
Barcode Software

Free Excel Templates

ConnectCode Asset Tracking Spreadsheet is a free Excel Template designed to help you track assets easily with barcodes. This template allows you to setup asset or inventory records , generate barcodes out of serial numbers, and print the barcodes on commonly used labels (like Avery(TM)) with an inkjet or laser printer. The barcodes may be subsequently pasted on the items you will like to track.

When time arises that you need to retrieve information on an item, simply scan the barcode on the item (using an off the shelf barcode scanner or key in the Serial number manually). With this, you will be able to track your assets and inventories efficiently.

All the source codes and fonts for the barcode are provided for further customizations.

Download Free Excel Template for Asset Tracking




Working with the Template

  1. To work with the template, you first customize / modify the records in the AssetData worksheet for all your trackable assets. You can also do this by clicking the Manage Records button.
  2. When you have finished defining the records, you click the Generate Barcodes on A4 button to create a printable page of barcodes containing all the serial numbers of your assets.
  3. You can then print the barcodes on a laser or inkjet printer with an A4-sized paper, and stick these barcodes on your assets.
  4. When you need to retrieve the information of a particular asset, you can set the keyboard focus on the Enter Serial Number (or Scan Barcode) field, and point your scanner at the barcode that is sticked onto a particular asset.
  5. When a barcode is scanned, its serial number will be automatically used to retrieve the information of that asset.

TrackAsset Worksheet

  • Enter Serial Number - Use a barcode scanner to scan the Serial Number or key in the Serial Number through the Combo Box. The detailed information of the record will be retrieved and displayed.
  • Manage Records - Launch the Data->Form command to manage the records in the AssetData worksheet. Alternatively, manage the records by updating the AssetData worksheet directly.
  • Generate Barcodes - Generate the Serial Numbers in the AssetData worksheet as Code 39 barcodes on a A4 (3 x 10 labels) sized paper.

AssetData Worksheet

This worksheet contains all the asset records information.

Barcodes on A4 (3 x 10) Worksheet

Print this worksheet after generating the barcodes in the TrackAsset worksheet.




 

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


Trademark Acknowledgements

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