beautypg.com

Sequential numbering hint, Chart 3, Save your file – Gasboy TopKAT Operation Manual User Manual

Page 143

background image

Chart 3

Code

Required Manual Keypad Entries

0

No entries

1

Odometer entry

2

Manual entry

3

Odometer and manual entry

4

Vehicle PIN

5

Odometer and vehicle PIN

6

Manual entry and vehicle PIN

7

Odometer, manual entry, and vehicle PIN

MDE-4338A TopKAT™ Fuel Management System Operation Manual · February 2009

Page E-3

Creating Your TopKAT Vehicle Records in Excel

Appendix E: Loading TopKAT Files from Microsoft® Excel®

3

Save your file.

Sequential Numbering Hint

When entering data into the Key # field, it is simplest and easiest to manage if you use
sequential numbers. MS-Excel makes it easy to enter sequential numbers:

1

After you have entered the first two sequential numbers in A3 and A4, highlight these cells.

2

There should now be a tiny square on the bottom right of cell A4. Drag that square down to the
row number equaling the number of vehicles you will be entering into the TopKAT, plus two.
(that is, if you have 700 vehicles in your fleet, drag the square down to cell A702). The
following graphic shows how this will look for the first few cells.