Gasboy Fleet PLUS - Manual (Page 58)

Performing Device Import (Cards, Keys, Tags, or Manual Entries) Performing Device Import (Example)
Page 5-6 MDE-5079 Gasboy Fleet PLUS Installation and Implementation Guide to Passport Authorization Server (PAS) · December 2013
8 Take the data from this sheet and make some changes to it using tables and formula’s to
prepare it for entering back into the FHO by placing it back into our EXPORTED file

(see Figure 5-9 ).
Figure 5-9: Example Exported File
Note: Ensure that you FORMAT the cells that you want to concatenate as TEXT if they start
with leading zero’s, otherwise Excel will not include them into your new column. To do
this, simply highlight the entire column, and select Format > Text.
9 Create a column that combines the SYS_ID and the KEY number to enter back into our
IMPORT file. To do this use a function named “CONCATENATE” followed by the two
cells we want to add together.
Figure 5-10 shows the new column that has the new formula applied to the cells.
Figure 5-10: Formatted Cells