Exact Globe+

Excel Add-in: explanation function HR_DATA

Introduction

With the function HR_DATA you can add data for a specific resource to the worksheet.  

Explanation of the fields

Company
Select the company for which you want to retrieve Exact data. If you select ‘Default’ the data will be taken from the default company. If you select a company, the data from the selected company will be displayed. 

The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.

Function
Select the function you want to use. In this case you choose 'HR_DATA'.

Resource
In this field you enter the resource for whom you want to get the data.

Column
In this field you enter the field you want to display in your worksheet. If you do not select a field, the name of the resource will be displayed.

Example

HR_DATA("     1",5,"sur_name")
This function shows the last name of resource 1 in company 5.