Difference between revisions of "Activity Duration Report"

From Globalsight
Jump to navigation Jump to search
 
(→‎Tips)
 
(One intermediate revision by the same user not shown)
Line 29: Line 29:
 
* You can filter the data by ''Web'' or ''Marketing'' by setting the '''Project''' field accordingly<br>
 
* You can filter the data by ''Web'' or ''Marketing'' by setting the '''Project''' field accordingly<br>
 
* The report can be '''sorted and filtered''' based on the information you seek. For example:
 
* 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<br>[[Image:JobMonitoring_image10.png|left|200px]]<br style="clear: both" /><br>[[Image:JobMonitoring_image11.png|left|300px]]<br style="clear: both" />
+
** Initial Sort: Select '''Custom Sort''' from the ''Sort & Filter'' drop-down on the Excel ribbon<br>[[Image:gsreports43.png|left|200px]]<br style="clear: both" /><br>[[Image:gsreports44.png|left|300px]]<br style="clear: both" />
−
** Filter – Freeze Top Row: Select '''Freeze Top Row''' from the Freeze Panes drop-down on the ribbon<br>[[Image:JobMonitoring_image12.png|left|200px]]<br style="clear: both" />
+
** Filter – Freeze Top Row: Select '''Freeze Top Row''' from the Freeze Panes drop-down on the ribbon<br>[[Image:gsreports45.png|left|200px]]<br style="clear: both" />
−
** Filter – Enable Filtering: Select '''Filter''' from the ''Sort & Filter'' drop-down on the ribbon<br>[[Image:JobMonitoring_image13.png|left|200px]]<br style="clear: both" />
+
** Filter – Enable Filtering: Select '''Filter''' from the ''Sort & Filter'' drop-down on the ribbon<br>[[Image:gsreports46.png|left|200px]]<br style="clear: both" />
−
** Filter – Pending Tasks: Hiding all completed and skipped tasks<br>[[Image:JobMonitoring_image14.png|left|200px]]<br style="clear: both" />
+
** Filter – Pending Tasks: Hiding all completed and skipped tasks<br>[[Image:gsreports47.png|left|200px]]<br style="clear: both" />
−
** Filter – Particular Tasks: For example, all tasks that require upload to test the server<br>[[Image:JobMonitoring_image15.png|left|200px]]<br style="clear: both" />
+
** Filter – Particular Tasks: For example, all tasks that require upload to test the server<br>[[Image:gsreports48.png|left|200px]]<br style="clear: both" />
−
** Filter – Clear: You can clear all of the filters, to avoid filtering too much<br>[[Image:JobMonitoring_image16.png|left|200px]]<br style="clear: both" />
+
** Filter – Clear: You can clear all of the filters, to avoid filtering too much<br>[[Image:gsreports49.png|left|200px]]<br style="clear: both" />
  
  

Latest revision as of 05:15, 21 October 2014

Project Management Wiki
Jump to: Home | Main User Guide
Gs color logo on black bg.jpg
General
About GlobalSight
My Jobs | My Activities
My Account
Planning
  1. Create jobs
  2. Add job comments
  3. Quote
  4. Approve quotes
  5. Dispatch jobs
Managing Projects
Following Up Ongoing Jobs
  1. Check general status information
  2. Check job and activity status
  3. Checking the activity duration
  4. View in-progress translations
  5. Download in-progress files
  6. View all comments
  7. Answer queries
Changing Ongoing Jobs
  1. Cancel workflows
  2. Cancel jobs
  3. Re-assign activities
  4. Add and remove resources
  5. Add more time for activities
  6. Skip activities
  7. Complete activities for other users
  8. Reset user details
  9. Add/edit/delete files
  10. Manage TMs
  11. Manage Terminology (Glossaries)
Finalizing
  1. Download the final files
  2. Archive jobs
  3. 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.

Gsreports11.jpg




























Running the report

To run the report:

  1. Click Reports->Activity Duration to open the Activity Duration Report Web Form
    Gsreports10.jpg

  2. Select the Job Name: All or a job from the list
  3. Select the Project: All or the current project
  4. Select the Status: All or Ready, In Progress, Localized and so on
  5. Select the Target Locales: All or a locale from the list
  6. 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
  7. Select a Date Display Format
  8. Click Submit

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

Tips

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
      Gsreports43.png


      Error creating thumbnail: File missing

    • Filter – Freeze Top Row: Select Freeze Top Row from the Freeze Panes drop-down on the ribbon
      Gsreports45.png

    • Filter – Enable Filtering: Select Filter from the Sort & Filter drop-down on the ribbon
      Gsreports46.png

    • Filter – Pending Tasks: Hiding all completed and skipped tasks
      Gsreports47.png

    • Filter – Particular Tasks: For example, all tasks that require upload to test the server
      Gsreports48.png

    • Filter – Clear: You can clear all of the filters, to avoid filtering too much
      Gsreports49.png

Retrieved from "http://www.globalsight.com/wiki/index.php?title=Activity_Duration_Report&oldid=837"