Activity Duration Report

Project Management Wiki

General
About GlobalSight
My Jobs | My Activities
My Account

Planning
Create jobs Add job comments Quote Approve quotes Dispatch jobs

Following Up Ongoing Jobs
Check general status information Check job and activity status Checking the activity duration View in-progress translations Download in-progress files View all comments Answer queries

Changing Ongoing Jobs
Cancel workflows Cancel jobs Re-assign activities Add and remove resources Add more time for activities Skip activities Complete activities for other users Reset user details Add/edit/delete files Manage TMs Manage Terminology (Glossaries)

Finalizing
Download the final files Archive jobs Resolve differences (optional)

Support
Support | FAQs | Training
System Requirements
Logging in

You can check the time taken for each activity in a workflow by running the Activity Duration Report report.

The Activity Duration report shows the duration, key dates and status of each task, based on the attributes defined.

Click Reports->Activity Duration to open the Activity Duration Report Web Form
Select the Job Name: All or a job from the list
Select the Project: All or the current project
Select the Status: All or Ready, In Progress, Localized and so on
Select the Target Locales: All or a locale from the list
Set the Creation Date Range:
- Starts: Enter a number of hours/days/weeks/months ago
- Ends: Enter now or a number of hours/days/weeks/months ago
Select a Date Display Format
Click Submit

The resulting Excel report provides detailed schedule and status information. Generating the report can take a few minutes.

Tips for using the report:

You can convert minutes to days by adding a Column N, with the formula =L2/(24*60). You can then apply the formula to the entire column
You can also calculate the number of work or business days between availability and completion by adding a Column O, with the formula =NETWORKDAYS(I2,K2). You can then apply the formula to the entire column
You can filter the data by Web or Marketing by setting the Project field accordingly
The report can be sorted and filtered based on the information you seek. For example:
- Initial Sort: Select Custom Sort from the Sort & Filter drop-down on the Excel ribbon
  
  Error creating thumbnail: File missing
- Filter – Freeze Top Row: Select Freeze Top Row from the Freeze Panes drop-down on the ribbon
- Filter – Enable Filtering: Select Filter from the Sort & Filter drop-down on the ribbon
- Filter – Pending Tasks: Hiding all completed and skipped tasks
- Filter – Particular Tasks: For example, all tasks that require upload to test the server
- Filter – Clear: You can clear all of the filters, to avoid filtering too much

Contents