Worth Data 802 RF User's Guide

for WindowsUser GuideData Integration Add-In for Excel®™KKwwiikkCCoouunntt RRFF

73. Lookup and Update. If you want to update existing worksheet data,check the Lookup on Field box. Otherwise, skip to item 8. If you douse the Lookup

84. Select Number of Transaction Prompt Statements to establish thenumber of fields of data to be collected during each transaction. This will also be

98. Select the desired Update Mode for all Input fields. This tells KwikCountRF how to update data in the non-indexed columns. There are three ways to

109. Active Worksheet Linkage allows you to store up to three KwikCount field-linkage and prompt setups for easy access. This is very useful for using

11Once you have configured your RF Terminal(s), defined a set of prompts,and attached KwikCountRF to you worksheet, all you have to do is clickon the

12newest. If you are interested in seeing a more deltailed listing of theTransaction Manager's activity, you can enable Detailed Listing whichwil

13Reviewing the DataWhen you have finished collecting data, you should review the data in theworksheet and then save the worksheet.New Items Added Som

14Chapter 4 • Sample ApplicationsWe have included a few sample worksheets so you will have a basic idea ofhow KwikCount RF might be used in real-world

15few punctuations while Code 128 supports the complete alphabet. KwikCount includes an Item ID Generator feature that will help you tocreate a column

16• Pull down the Worth Data menu in Excel and select KwikCountRF,then Collect RF Terminal Data.• Set the Field Count to 2• Click on the first "I

License Agreement for 1 UserCarefully read all the terms and conditions of this agreement.This program is licensed to one user to use on one CPU. If t

17Subtract will remove items from a quantity count. This works well for adjustments, shipping totals, or other debits.• Then Click on the Collect Data

18the RF Terminal in the Excel worksheet.Data collected for Shipped items would use Data Option Subtract in theKwikCount RF Receive dialog.Data collec

19Chapter 5• Labels and Label PrintingWorth Data offers several software options that will allow you to create yourown bar code labels. Our LabelRIGHT

20Chapter 6 • Using UPC Bar CodesUPC SpecificationsUPC symbols are found on almost all grocery productsand many other retail items. The UPC code most

21Chapter 7 • Code 39 and Code 128Code 39Code 39 (or Code 3 of 9) is the de facto standard of non-retail American industry. It is widely used in the a

22Code 128Code 128 is a very powerful bar code, combining an extensive character setand variable length with compactness and error checking. The chara

23Chapter 8• Questions and AnswersWhat version of Excel do I need?KwikCount RF requires Excel 2000 or later.How should my Excel Item List be formatted

24

Table of ContentsChapter 1Chapter 2Chapter 3Chapter 4Chapter 5Chapter 6Chapter 7Chapter 8Introduction . . . . . . . . . . . . . . . . . . . . . . . .

1CHAPTER 1 • IntroductionKwikCount RFKwikCountRF is an Add-In for Microsoft Excel 2000 or later. KwikCountRF'sfeatures are designed to smoothly i

2CHAPTER 2 • KwikCount RF SetupGetting ready to use KwikCount RFRun Setup From The CDInsert the KwikCount RF CD in your computer. The installer should

3The Item ID GeneratorYou may want to consider using the Item ID Generator if:• If you want to use bar codes for your data collection and do not alrea

4The Generator works by:• Inserting a new column to the left of the range you have specified.• Looking at the range you have specified and placing a v

5"Statements" that results in a program used by the Transaction Managerto control the operation of your RF Terminal(s).When you click on the

6Chapter 3 • Collecting Data using the RF TerminalKwikCount RF is simple and intuitive enough for most people to jump rightin. Don't hesitate to