beautypg.com

Creating your topkat vehicle records in excel, Appendix e: loading topkat files from microsoft, Excel – Gasboy TopKAT Operation Manual User Manual

Page 141

background image

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

Page E-1

Creating Your TopKAT Vehicle Records in Excel

Appendix E: Loading TopKAT Files from Microsoft® Excel®

Appendix E: Loading TopKAT Files from Microsoft

®

Excel

®

Creating Your TopKAT Vehicle Records in Excel

1

Open Microsoft

®

(MS) Excel

®

and create a form (worksheet) that looks identical to the screen

below.

2

Enter your vehicle information starting in row 3 of the form.

• Each row will be for one vehicle record. All columns must be filled in according to the

field sizes shown in row 2.

• To display the header rows, split the screen by pulling the tiny bar in the right corner of the

Excel chart until it is below row 2. The split screen appears as shown below.

• You can use the MS-Excel drag, copy, and paste functions to quickly fill in the form.

The following table describes the data to be entered in the columns. If you need additional
information on these fields, refer to the appropriate section of this document.