Excel Add-in: explanation function PROJ_TOTAL_EMP

Introduction

With the PROJ_TOTAL_EMP you can include the transaction totals per employee in the worksheet.

Explanation of the fields

Company
Select the administration from which you want to retrieve the 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   'PROJ_TOTAL_EMP'.

Project code
Select the project you want to use.

Resource
Select the resource you want to use.

From date - to date
In this field you can enter a date range for which you want to retrieve information.

Activity
In this field you can select a specific activity.

Value
Indicate the amount (0) or number of hours (1).

Example

PROJ_TOTAL_EMP("ONTWPR2003","     2","1/1/2002","4/9/2002","ASSEMBLY",0,5)
The function results in the transaction totals for project code "ONTWPR2003" for resource number 2 from 1 January 2002 through 9 April 2002 for the activity "ASSEMBLY" in amounts (parameter 0) for company 5.