Import Rates from Excel

OBJECTIVE

The Import Rates from Excel option is used to transfer multiple hourly rates to maestro* from an Excel file.

This file may have been created manually or by exporting hourly rates from maestro*.

This option can be very useful for updating the hourly rates file whose use will soon become mandatory.

 

Steps

Import rates

  1. Click the Import Rates from Excel icon.
  2. Select a file by selecting its location in the window and clicking Accept.

 

The data is displayed on the screen.

  1. Click Validate the Table.

 

The system displays the incorrect data in red to ensure these values exist: Employee, trade code, region and union code.

The Hourly Rate and Sector fields are mandatory.

The data can be corrected on the screen and reconfirmed by clicking Validate the Table again.

  1. Click Apply to import the hourly rates.
  2. Click Exit to leave the import screen.

 

See also

Last modification: September 20, 2024