the Power of Excel and Bar Coding
for Inventory Control
Excel has always been a powerful tool for tracking and controlling inventory; however, fast data entry of the inventory transactions has been missing. At last portable bar code readers have been seamlessly integrated with Excel, making inventory control practical.
Worth Data has bridged the gap between portable bar code readers and Excel with KwikCount/EX™, an Add-In for Excel.
KwikCount/EX imports data from a portable bar code reader into an Excel worksheet effortlessly. The portable bar code reader becomes an integral part of Excel.
The TriCoder is a battery-powered portable data collector capable of storing over 200,000 item numbers and associated quantities. With the KwikCount/EX software, use the TriCoder to:
After you have collected inventory transactions in the TriCoder Portable Bar Code Reader, attach the TriCoder to your PC and start Excel. Using the KwikCount/EX add-in, you can identify which worksheet columns you wish the TriCoder data to be flowed into. To update existing Excel worksheets, simply designate which field sequence (i.e. the stock number) is the controlling “key” or “lookup” field and then link it to the appropriate column in the worksheet.
When the data is downloaded from the TriCoder to Excel, the field identified as the “lookup” field is read and that column is searched until matched. Once the “lookup field” is matched, KwikCount searches that row and updates the additional field columns according to your linking specifications.
When the data is flowed into the corresponding columns for each field in the same row as the “lookup” field, the data is accumulated, subtracted, or overwritten according to the linking instructions you have specified. Receipts can be added, shipments can be subtracted, new physical counts can be overwritten, or data can be written into a new row.
KwikCount/EX provides the flexibility to control and mange your inventory in whatever way you need within Excel. You can set reorder points, safety stock levels, seasonal adjustments, minimum order quantities, etc., according to your requirements- and with NO PROGRAMMING! Use Excel formulas to create your tailored reports.
KwikCount/EX can be used for:
KwikCount uses the highly acclaimed TriCoder Portable Reader as an input device, supporting the following interfaces:
Multiple uploads, using one or more TriCoders are supported, allowing accumulation in the uploads to the worksheet. There is also an option to automatically generate a new column of item numbers, which then can be printed as a bar code label in convenient item or shelf sizes.
Also, if you need to print bar code labels related to your inventory, LabelRIGHT for Windows can print labels based on data exported from your Excel worksheets!
If you are interested in a standalone inventory solution take a look at our KwikInventory Software Suite.
Using KwikCount/EX with a TriCoder:
How To Install KwikCount/EX Excel Add-In: