Role-Based Resource Allocation Forecast: Bulk Edit

Modified on Fri, 17 Nov, 2023 at 6:40 PM

Bulk Edit is an easy way to add and update the allocation of multiple resources on a single project, or on multiple projects.


In this article, you will learn:

          how to access the bulk edit functionality.

          the steps to update the resource forecasts.




How to access the Resource Forecast Bulk Edit Functionality? 


The Resource Forecast Bulk Edit functionality is available from:


From a Project Dashboard

Select Tools (top right of the page) and then select Bulk Edit.



From a Project Workspace

The Resource Forecast Bulk Edit function can be accessed by selecting the Bulk Edit menu link in the left navigation panel or by selecting the Bulk Edit option under the Tools menu.






Steps to update resource forecasts


Step 1: Download the data file

  • Select Resource Forecast on the left of the Bulk Edit dialog 


  • Select the date range that you want to edit resources for. 



  • If you want to download existing data from the project/s into the file make sure the Include Existing Data flag is set to Yes. To extract a blank upload file, set it to No.


  • Select whether you would like to download and edit the resource allocation forecasts in headcount percentage or in hours. 



  • Click on the Download button.



Step 2: Edit the data file


Make your required changes to the file that you downloaded. 


Extract example:Please see the table at the bottom of this page for a full description of each column.



Step 3: Upload the data file


When you are happy with your changes, select UPLOAD in the Bulk Edit dialog and select the file you want to upload.

The progress bar will indicate when the upload process is completed and if any errors occurred during the upload process, they will be listed below the progress bar. 




Remember - changes will only be applied if you have the right permissions to the projects to make resource changes. If you do not have permission to edit the projects in your data file the changes will not be made.




Data File Column Description


Each line in the upload file contains the details for a single resources allocation to the project for the period you selected when downloading the file.


Column & TitleDescriptionData TypeWhat happens if this field is left blank?
A. AllocationIdFluid unique ID for the allocation record. If EDITING EXISTING resource allocation, do NOT change this field.
Leave the field blank if you want to add a new allocation record.
NumberThe record will be added as a new entry unless a record already exists for the project, resource and role combination.
B. ResourceRefThe USERNAME of the resource. You can find someone's username by searching for them using global search from the top nav. The text in brackets after their name is their Fluid username.

If there are no resources matching the ResourceRef value, then the row will be skipped.
Alphanumeric (numbers & text)This value is mandatory. If no value is specified, the row will be skipped.
C. ProjectNameThe name of the project the resource allocation applies to.TextThis column is for information only and is not processed on upload.
D. ProjectRefThe External Reference for the project the resource is allocated to. The External Reference can be found under Project Settings for the project.

If both ProjectRef and ProjectId (column E) values are set, they need to represent the same project in order for the entry to be processed. If only the ProjectRef value is specified and there is no AllocationId value set, Fluid will ignore the entry if it finds more than one project with the same ProjectRef as ProjectRef are not unique.
Alphanumeric (numbers & text)If both ProjectId (column E) and ProjectRef are blank Fluid will not process the entry. Otherwise the ProjectId value will be used to uniquely identify the project.
E. ProjectIdThe project Unique Id. The unique Id can be found in the top meta-data section of the Project Workspace.

If both ProjectId and ProjectRef (column E) values are set, they need to represent the same project in order for the entry to be processed.  If only the ProjectId value is specified, then it needs to match an existing project for the entry to be processed.
NumberIf both ProjectId and ProjectRef (column D) are blank Fluid will not process the entry. Otherwise the ProjectRef value will be used to uniquely identify the project.
F. RoleThe assigned or specified position (role) of the resource within the business and the project (such as Business Analyst, Technician, Consultant, etc).

Note that it is not possible to create multiple records for the same resource and role combination for a given project.
TextMandatory field. Remember to use the roles that have been configured for your instance.
G onwards. Monthly/Hourly Resource Allocation

The number of columns depends on Date Range selected on download. 


Monthly or Hourly resource allocation will depend on selection before download.
The allocation as a percentage of one Full Time Employee (FTE) for each month in turn: e.g.
0 - No allocation.
1- 100% allocated.

0,5 - half allocated.


OR 


the allocation in number of hours per month,


depending on whether you dowloaded the forecast as headcount or hours version.


Note that is your instance is set to prevent resource over-allocation, the new allocation will not be recorded if it results in the resource being over-allocated.

DecimalNo allocation will be recorded for that month.
Last column. DeleteRecordDeleting a financial forecast record will result in the resource being removed from the project community if the resource does not have an allocation for another role. A resource can only be removed from a project if:
  • there is no actuals amount posted for the resource and role combination

and

  • there is no forecast allocation for the resource and role combination in locked months
Yes / NoThe record will not be deleted.

 


Financial administrators can get an extract of all users in Fluid with ResourceRef and ResourceID details using the Resource Plans Upload.








Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article