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

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.