Creating your topkat vehicle records in excel, Appendix e: loading topkat files from microsoft, Excel – Gasboy TopKAT Operation Manual User Manual
Page 141
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.