Gasboy Fleet PLUS - Manual (Page 60)

Performing Device Import (Cards, Keys, Tags, or Manual Entries) Performing Device Import (Example)
Page 5-8 MDE-5079 Gasboy Fleet PLUS Installation and Implementation Guide to Passport Authorization Server (PAS) · December 2013
Figure 5-14 shows the result of copy/paste action.
Figure 5-14: Edited Name and Vehicle Number Fields
12 Make a group rule from the Limit and Auth fields using the LOOKUP function of Excel. See
example from the Gasboy Data sheet.
Note: The lookup vector is using “$”’s before the cells. This makes the loopkup vector table a
constant so when we copy the cells down for all the vehicles, Excel keeps that lookup
table as a CONSTANT and does not copy the relative values.
13 Repeat the same process for the Auth-type Column, refer to step 10 to 11 on page 5-7 .