beautypg.com

Gasboy TopKAT Operation Manual User Manual

Page 142

background image

Appendix E: Loading TopKAT Files from Microsoft® Excel®

Creating Your TopKAT Vehicle Records in Excel

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

Chart 1

Limit Code

Limit Cutoff Quantity

0

5

1

15

2

20

3

25

4

35

5

50

6

100

7

200

8

300

9

999

Chart 2

Auth Code

Product Codes Allowed

0

All

1

1

2

2

3

3

4

4

5

1, 2

6

1, 3

7

2, 3

8

1, 2, 3

9

1, 3, 4

Column

Data

Enter

A

Key #

1- to 5-digit key number (refer to

“Sequential Numbering Hint”

on

page E-3

)

B

Veh #

1- to 5-digit vehicle number

C

Dept #

1- to 4-digit department or account number

D

Limit Code

1-digit limitation code (refer to

“Chart 1”

on

page E-2

)

E

Auth Code

1-digit authorization code (refer to

“Chart 2”

on

page E-2

)

F

Check Code

1-digit check digit code (refer to

“Chart 3”

on

page E-3

)

G

Lockout Status 1-character lockout status

H

PIN

1- to 4-digit PIN

I

Beg. Odom

1- to 6-digit beginning odometer. Use 0 for this initial set up. This instructs the TopKAT
to initialize the record using the odometer received the first time the key is used.

J

Last Odom

1- to 6-digit last odometer. Use 0 for this initial set up. This instructs the TopKAT to
initialize the record using the odometer received the last time the key is used.

K

Qty.

8-digit (xxxxx.xxx) total quantity. Use 0 for initial setup.

L

Max Fuel

1- to 2-digit maximum fuelings per day (1 - 15). This is the maximum number of times
the vehicle can fuel in a 24-hour period.

M

Today’s Fuel

Enter 2-digit number for fuelings today. Use 0 for this initial file set up.

N

Fuel to Date

Enter 2-digit number for fuelings to date. Use 0 for this initial file set up.