-
No matter how hard we try, many organizations cannot pry Excel out of the hands of project and resource managers. In this class we will explore possibilities that give up the battle and embrace Excel as a great data entry tool. We will show some neat case studies on quick Excel integrations deployed at customers. -
This allows users without admin access to see the timeslice settings and also allows the data to be exported to excel easily. Many organizations like to document their timeslice settings which is a manual process as you cannot export the timeslice page to excel. This allows them to periodically export the portlet results to excel to meet their documentation requirements. -
The Dashboard: Project Status Single-line portlet gives an overview of the project overall status as well as the status indicators on the "current" status report object. The portlet will pull the "id" from the page it is placed on, so this portlet is usually placed on the project dashboard tab. This portlet displays the report date, symbols relating to the overall status, scope, schedule, cost/effort, and the overall explanation across a single line in the portlet. -
The Dashboard: Project Information portlet gives a set of high-level information about the project. The portlet will pull the "id" from the page it is placed on, so this portlet is usually placed on the project dashboard tab. The portlet displays the name, project ID, project manager, description, start date, finish date, baseline start, and baseline finish. -
The Missing Time by RM portlet displays all missing or late timesheets for resources for which the logged in user has resources (logged in user is the RM). Resources will be listed if they are open for time entry, have a track mode of Clarity, and have timesheet that is not posted (accommodates for hire and termination dates). Resource managers may use this portlet to determine the timesheet status of all resources in open time periods. The portlet will display an indicator based on timesheet status, the status, period start, resource name, and actual hours for the timesheet. -
The License Count by OBS portlet displays license type information by a selected OBS for active users. The portlet is used to determine what kind of license a specific user has and the OBS in which he or she resides. It can be helpful for determining specific amount of licenses used by different departments within the organization. -
The License Count by OBS portlet displays license type information by a selected OBS for active users. The portlet is used to determine what kind of license a specific user has and the OBS in which he or she resides. It can be helpful for determining specific amount of licenses used by different departments within the organization. -
The Give PM Collaboration Manager Rights workflow process can be run through the "Execute a Process" job. The workflow will execute a query that gives a Project Manager the Collaboration Manager rights to their projects. Often times, PMs are not set as Collaboration Managers when the project is created. This script can be run to automatically give a PM the Collaboration Manager rights to their projects, without having to go through the projects one by one.

