Import the CSV file downloaded from the Monitoring Panel into the previously downloaded ** file with statistics ** for convenient work with data.

Importing Statistics

1. Open the "Statistics" file in Microsoft Excel.

2. Click Data > Get External Data > Import Text File.

   

3. Select the required file and click Get Data.

   

4. In the window that appears, select Delimited and click Next.

   

5. Specify the separators as in the screenshot below and click Next.

   

6. Select an existing data sheet and click OK.

   

Setting up the calculation of total and average mileage

1. Select the distance column and click Edit > Find > Replace.

   

2. In the Find: field, specify a point. In the Replace with field, specify a comma. Then click Find Next.

   

3. Now the data is displayed separated by commas.

   

Link to this article: here