Mine Resources from Project Data
Timeline can add resources from project data. The program processes and extracts the number of unique resource values by combining them into groups.
Click Add resource type and select the Mine resource from data option. The window opens showing attribute columns uploaded into the project. Map columns with resources and create Resource types for the scenario. Follow the description below to mine resources in different use cases:
- Case 1: The data file contains column(s) with resources.
Drag and drop the Resources label to one or several columns. Resource type is extracted from the column header. The quantity of resources is calculated by the sum of unique resources in the column.
How it works
For example, in the table below resources are grouped by columns. Each column has an appropriate header for resource naming such as "Assistant" and "Manager". Drag and drop the Resources label to columns to map them. Click Mine resources to create corresponding resource types for the scenario.
Resources Resources Assistant Manager Location Thomas Moore Sam Lemon Atlanta Thomas Moore Tori Stevens Atlanta Robin Neal Kira Marrow Dallas
As a result, the program creates resource types called "Assistant" and "Manager" and displays their quantity. The quantity is the number of unique rows in a column.
- Case 2: The data file contains a column with resources. The category of each resource is placed in another column.
In this case, the Resource types label works in pair with the Resources label. Drag and drop the Resource types label to a column that contains resources grouped by some attribute. Then map the Resources label with a column that contains resources. The program calculates the number of unique resource values for each resource group.
Important. You can map only one column with the Resource types label. Each resource can belong only to one type. In case the resource relates to several types, the program connects it to the first met type and increases its quantity. Other resource occurrences will be ignored.
How it works
Example 1: The table contains a column with managers and a column with the departments they work in. The goal is to create a resource type having a name of a department and showing the number of managers it includes.
Map the column "Department" with the Resource types label and the column "Manager" with the Resources label. Click Mine resources to create corresponding resource types for the scenario.
Resource types Resources Department Manager SALES Sam Lemon SALES Sam Lemon FINANCE Kira Marrow PROCUREMENT Tori Stevens FINANCE Robin Neal SALES Rod Lever FINANCE Thomas Moore
The program checks how many unique values each resource type has in the column with the Resources label.
For the SALES resource type: the managers are Sam Lemon and Rod Lever, so the quantity is 2.
For the FINANCE resource type: the managers are Kira Marrow, Robin Neal, and Thomas Moore, so the quantity is 3, and so on.
Example 2: A resource can be a part of several resource types. The goal in the example below is to create a resource type having a name of a location and showing the number of managers in a certain office. The Resource types label refers to the "Location" column and the Resources label to the "Manager" column. The same manager works in 2 offices. The program associates only the first occurrence of resources with the corresponding type (Rod Lever - Chicago) and skips others. As a result, for Chicago the quantity of managers is 1, and for Detroit is 0.
Resource types Resources Location Manager Chicago Rod Lever Detroit Rod Lever
Mine resource demand from project data
Timeline can automatically distribute resource values according to the schema based on the project data:
- Select Mine resource from data for adding resources.
- Map the resources using one of the guidelines above.
- Click Fill in resource demand for all nodes.
The program adds resources to the scenario and displays them in General settings. For all nodes connected with these resources, Timeline adds their resource demand.