- Determine if timesheet has > 40 hours. If so, proceed.
- Create a SPLIT row for each timesheet row, with Input Type Code = Non-Bill.
- Divide 40 by total timesheet ours. Store this value.
- Multiply each timesheet cell by the stored value, and enter the result into that cell.
- Take the difference (original cell value – new cell value), and enter in same cell on Split row.
- The end result will be 40 hours total on Billable rows, and overtime hours on Non-Billable rows.
199 results
-
This process workflow with gel script forces billable hours on timesheet down to 40 hours, and sets overtime hours to non-billable. Timesheets with 40 or fewer hours are not touched. Process kicks off upon submission of timesheet. Steps are: -
The process is built to clear the random timesheet locks that happens occasionally. There are three Processes and one lookup component and one job definition in the package.- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
- The Lookup PRLock Check (Timesheet) (Id: REGO_PRLOCK_CHECK) should be used to update the GEL parameters for the above process.
- PRLock (Timesheets) Record Removal All (ID: rego_prlk_rc_rmv_all) This deletes ALL prtimesheet locks.
- Rego Remove Timesheet Locks (ID: rego_rmv_ts_locks). This process is run as a job “PrLock Clear for Timesheet Locks” which performs the same functionality as the above two processes. The process and job definition are separate XOG files.
- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
-
The process is built to clear the random timesheet locks that happens occasionally. There are three Processes and one lookup component and one job definition in the package.
- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
- The Lookup PRLock Check (Timesheet) (Id: REGO_PRLOCK_CHECK) should be used to update the GEL parameters for the above process.
- PRLock (Timesheets) Record Removal All (ID: rego_prlk_rc_rmv_all) This deletes ALL prtimesheet locks.
- Rego Remove Timesheet Locks (ID: rego_rmv_ts_locks). This process is run as a job “PrLock Clear for Timesheet Locks” which performs the same functionality as the above two processes. The process and job definition are separate XOG files.
- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
-
The process is built to clear the random timesheet locks that happens occasionally. There are three Processes and one lookup component and one job definition in the package.
- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
- The Lookup PRLock Check (Timesheet) (Id: REGO_PRLOCK_CHECK) should be used to update the GEL parameters for the above process.
- PRLock (Timesheets) Record Removal All (ID: rego_prlk_rc_rmv_all) This deletes ALL prtimesheet locks.
- Rego Remove Timesheet Locks (ID: rego_rmv_ts_locks). This process is run as a job “PrLock Clear for Timesheet Locks” which performs the same functionality as the above two processes. The process and job definition are separate XOG files.
- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
-
The Timesheet Smoothing Process Workflow kicks-off when an individual timesheet is Submitted. It splits each transaction on the timesheet when total timesheet actuals exceed total weekly availability for the resource. Total weekly availability is determined by multiplying resource availability rate by the number of workdays in the week. Non-workdays include weekends, holidays, PTO, and other scheduled days off, as set on the resource calendar. If timesheet actuals <= total weekly availability, then the timesheet remains unchanged. But if timesheet actuals > total weekly availability, then the following occurs. Each timesheet transaction is reduced by a calculated percentage that will reduce the total regular hours to equal the total weekly availability. Then the remaining transaction hours are placed in a “Split” row for that task on that day, with an Input Type Code set based on a process parameter (which parameter can be set within the script action on the process). Note: If a single day has overtime hours, but the total timesheet actuals <= total weekly availability, no splitting occurs. -
The Timesheet Smoothing Process Workflow kicks-off when an individual timesheet is Submitted. It splits each transaction on the timesheet when total timesheet actuals exceed total weekly availability for the resource. Total weekly availability is determined by multiplying resource availability rate by the number of workdays in the week. Non-workdays include weekends, holidays, PTO, and other scheduled days off, as set on the resource calendar. If timesheet actuals <= total weekly availability, then the timesheet remains unchanged. But if timesheet actuals > total weekly availability, then the following occurs. Each timesheet transaction is reduced by a calculated percentage that will reduce the total regular hours to equal the total weekly availability. Then the remaining transaction hours are placed in a “Split” row for that task on that day, with an Input Type Code set based on a process parameter (which parameter can be set within the script action on the process). Note: If a single day has overtime hours, but the total timesheet actuals <= total weekly availability, no splitting occurs.
-
The Timesheet Smoothing Process Workflow kicks-off when an individual timesheet is Submitted. It splits each transaction on the timesheet when total timesheet actuals exceed total weekly availability for the resource. Total weekly availability is determined by multiplying resource availability rate by the number of workdays in the week. Non-workdays include weekends, holidays, PTO, and other scheduled days off, as set on the resource calendar. If timesheet actuals <= total weekly availability, then the timesheet remains unchanged. But if timesheet actuals > total weekly availability, then the following occurs. Each timesheet transaction is reduced by a calculated percentage that will reduce the total regular hours to equal the total weekly availability. Then the remaining transaction hours are placed in a “Split” row for that task on that day, with an Input Type Code set based on a process parameter (which parameter can be set within the script action on the process). Note: If a single day has overtime hours, but the total timesheet actuals <= total weekly availability, no splitting occurs.
-
Course description: “Is there a way to simplify time tracking? Time is a function 90% of companies use. What are ways to have time be less of a burden to users? How can you minimize the negative perception? This session will discuss options within CA PPM or outside CA PPM to make time tracking less of a burden for all.” Download file is the presentation slide deck. -
Resource Availability – 4 Weeks displays all resources with their total allocated hours by week, and an average availability percent (4 Wk Avail %) for next four weeks. This report also displays Resource Primary Role and Employment Type. User can further narrow their search by Resource Name, Resource Type & Week Start Date. User can use exact dates or relative dates for Week Start Date filter parameters. -
Time by Task report displays monthly time logged to Tasks for all filtered investments. It also displays total Actual hours associated with a task. User can further narrow their search by OBS Type & Path, Charge Code, Project Name, Task Name, Task Charge Code, Task Status and Month End Date. User can use exact dates or relative dates for Month End Date filter parameters. -
Assignments by Task Over Time report display all assignments by task for all resources. Information can be drilled down to yearly, quarterly or monthly level. This report helps in determining the tasks a user is assigned to or how many hours a user is assigned to a task. You can further narrow your search by OBS Type & Path, Project ID, Project Name, Task Name, Assignment Resource, Is project Active?, Is Template? And Month End date. -
Project Time Summary report provides the project manager a single place to view Actual hours, Allocation hours, ETC hours and EAC hours for all filtered projects. It also displays Project ID, Project Name and Project Manager. User can further narrow their search by OBS Type & Path, Project Name, Project ID, Project Manager, Task Name, Project Status, Project Stage, Project Role, Is Active? and Is Template?. -
Capacity Graph report provides the Resource Managers & PMO a single place to view Monthly Availability, Allocations, Actuals and Assignments for one or more active resources. Information is displayed in the form of a line chart. Legend displays the color associated with each metric. Mouse over the line chart displays hours associated with that corresponding metric. This report provides Managers a simple means to analyze: Allocations vs. Availability, Allocations vs. Actuals, Allocations vs. ETC and ETC vs. Availability and helps in determining the areas of improvement. User can further narrow their search by OBS Type & Path, Month Start Date, Resource Name, Resource Manager, Primary Role & Employment Type. -
Missing Time by OBS report displays Resource whose timesheets are missed. There is Clustered Column Chart which displays Timesheets count by Resource. Also, there is table view of Resource, Resource Manager, Time Period Start and Finish Dates, Total Hours and Timesheet status. User can narrow their search by OBS Type & Path and Project Manager, Resource Manager, Resource, Timesheet Status and Time Period Start Date (Relative or Specific Date Range). -
Missing Time by PM report displays Resources whose timesheets are missed by Project Manager. There is Clustered Column Chart which displays missed timesheets count by Project Manager. Also, there is table view of Project Manager, Resource, Time Period Start and Finish Dates, Total Hours and Timesheet status. User can narrow their search by OBS Type & Path and Project Manager, Resource Manager, Resource, Timesheet Status and Time Period Start Date (Relative or Specific Date Range). -
Missing Time by RM report displays Resources whose timesheets are missed by Resource Manager. There is Clustered Column Chart which displays missed timesheets count by Resource Manager. Also, there is table view of Resource Manager, Resource, Time Period Start and Finish Dates, Total Hours and Timesheet status. User can narrow their search by OBS Type & Path, Resource Manager, Resource, Timesheet Status and Time Period Start Date (Relative or Specific Date Range). -
Project Time Summary report provides view of Allocation hours, EAC hours, ETC hours and Actual hours for Projects. User can further narrow their search by OBS Type & Path and Project Manager. -
Actuals & ETC by Resource Assignment report provides project managers a single place to view Actuals and ETC associated with resources across multiple Tasks and Projects. It displays the following: Actual and ETC Hours by Start Date: Stacked Column chart that displays the total Actual hours and ETC hours per month of fiscal period. Grey color indicates Actuals and Purple indicates ETC hours during that month. Grid: Displays Investment name, Task, Assigned resource ETC and Actual hours per month of fiscal period. It also displays aggregated column and row totals for Actuals and ETC hours. You can further narrow your search by OBS Type, OBS Path & Start Date range. -
Allocation Compliance by PM report provides project managers a single place to view Available hours, Allocation Hours and Allocation Percentage of Investment Team Resources. It considers the investments of selected project manager and it displays the following: Allocation Details Grid: Displays Resource and its Allocated hours, Available hours and Allocation percentage (Allocated hours/Available Hours) Allocation Percent by Resource: Column chart that displays Allocation Percentage for various resources during the selected Time frame. You can further narrow your search by Project Manager & Month Start Date range. -
Allocation Compliance by RM report provides resource managers a single place to view Available hours, Allocation Hours and Allocation Percentage of Resources. It considers the resources of selected resource manager and it displays the following: Allocation Details Grid: Displays Resource and its Allocated hours, Available hours and Allocation percentage (Allocated hours/Available Hours) Allocation Percent by Resource: Bar chart that displays Allocation Percentage (top 10) for various resources during the selected Time frame. You can further narrow your search by Resource Manager & Month Start Date range. -
Timesheet compliance is a dashboard containing multiple visualizations that shows timesheet compliance data under various scenarios. Dashboard shows count of timesheets grouped by Status and total available timesheets. % Time Compliance – Gauge graph that shows percentage of completed timesheets against overall timesheets. Compliance by Resource Manager – Grid section that shows percent timesheet compliance by resource manager. Timesheet count by Employment type and Timesheet Status – Stacked column chart, each column represents Employment type and sections of the column represent count of timesheets by Status. Count of Timesheets by Months – Stacked column chart, each column represents a month and sections of the column represent count of timesheets by Status. Dashboard also const of two grid sections displaying number of Open timesheets by Organization and Vendor. -
This video covers the process of accessing timesheets within Clarity, both as a team member and as a Project or Resource Manager. -
This video covers the process of adding tasks to the timesheet using Populate and Add Task, using the timesheet notes functionality, entering timesheet data, updating ETC via the timesheet, and submitting the timesheet. -
This video reviews how to return and approve Clarity timesheets as a Project or Resource Manager. -
This video reviews the process of creating Timesheet Adjustments – making changes to a timesheet after it has been posted. -
Rego’s training video that walks through the Time Entry and Approval process for Clarity PPM – Modern User Experience. This video was created using Clarity PPM version 15.6. -
** No Download - Do not Add to Cart ** As Clarity's Modern UX continues to evolve with each release, so has the transition conversation among Clarity Product Owners and Administrators. It's no longer a question of "if" and "when;" the question is, how? In this webinar, we'll explore some best practices that enable a successful shift from Classic to Modern. Through a collaborative discussion of overarching strategies to a step-by-step checklist, this session is designed to help you quickly position your users to take advantage of Clarity's latest and greatest capabilities. Nothing to Download - See Link below. http://info.regoconsulting.com/when-to-move-to-modernux-aug-2020 -
Rego’s Clarity Adoption Metrics package consists of two sets of metrics: Project metrics, and Resource metrics. Project metrics measure how effectively project managers are using Clarity to manage their projects. Resource metrics measure how effectively resource managers are using Clarity to manage resources. Metrics are scored on a scale of 0 to 5, with higher scores indicating greater adoption and use. All metrics can be viewed numerically or graphically, and can be broken out by OBS. In addition, metric data can display as a 12-month rolling history to help identify trends. Project metrics can also display by lowest / highest adoption rates for a specific resource metric or all resource metrics. There is a variety of way to view the Adoption Metric data, therefore, Rego has made this simple by creating an Adoption Metrics object that contains multiple tabs. Each tab displays one or more of the Project or Resource Adoption Metrics. Based on the nature of the Metrics some tabs will allow the ability to use a pull down menu to select a specific Adoption Metric. There is also a Metrics trending view that pulls monthly snapshots of the metrics. Project metrics consist of the following: - Project Status Reporting – Measures how well PMs create and publish project status reports.
- Project Risk Adoption – Measures how well Risks are being used and managed.
- Project Issue Adoption – Measures how well Issues are being used and managed.
- Project Schedule – Measures how well PMs create tasks and keep the project schedule current.
- Project Baseline – Measures whether or not baselines exist.
- Project Zero ETC’s – Measures how well the PM assigns resources to tasks with ETCs.
- Project Past ETC’s – Measures how many improperly scheduled tasks the PM has.
- Project Milestone / Key Tasks – Measures how well PMs create and manage Milestones / Key Tasks.
- Project Schedule Variance – Measures how effectively PMs manage their schedules.
- Project Effort Variance – Measures how effectively PMs manage their project efforts.
- Project Budget Variance – Measures how effectively PMs manage budgets or cost plans.
- Project Unfilled Roles – Measures project roles with allocations that are already started or starting within the next 30 days.
- Project Data Quality – Measures how effectively PMs complete the Description, Stage, Progress, Objective, and Sponsor/Business Owner fields.
- Project Commitment – Measures the hard allocations for a project over a two week time frame.
- Resource Clarity Usage – Measures how often users log into Clarity.
- Resource Timesheet – Measures if timesheets post in a timely manner.
- Resource Allocation – Measures how well RMs keep total resource allocations within the expected range for future time periods.
- Resource Actualy Utilization – Measures how well Resource allocations match actuals.
- Resource Allocation Date in the Past – Measures how many resources are open for time entry with dates in the past.
- Resource Data Quality – Measures how well RMs complete the Resource Manager and Primary Role fields and optionally the Skill and Employment Type fields.
- Resource Commitment – Measures how much resource available time is committed to projects.
-
Rego’s Clarity Adoption Metrics package consists of two sets of metrics: Project metrics, and Resource metrics. Project metrics measure how effectively project managers are using Clarity to manage their projects. Resource metrics measure how effectively resource managers are using Clarity to manage resources. Metrics are scored on a scale of 0 to 5, with higher scores indicating greater adoption and use. All metrics can be viewed numerically or graphically, and can be broken out by OBS. In addition, metric data can display as a 12-month rolling history to help identify trends. Project metrics can also display by lowest / highest adoption rates for a specific resource metric or all resource metrics. There is a variety of way to view the Adoption Metric data, therefore, Rego has made this simple by creating an Adoption Metrics object that contains multiple tabs. Each tab displays one or more of the Project or Resource Adoption Metrics. Based on the nature of the Metrics some tabs will allow the ability to use a pull down menu to select a specific Adoption Metric. There is also a Metrics trending view that pulls monthly snapshots of the metrics. Project metrics consist of the following: - Project Status Reporting – Measures how well PMs create and publish project status reports.
- Project Risk Adoption – Measures how well Risks are being used and managed.
- Project Issue Adoption – Measures how well Issues are being used and managed.
- Project Schedule – Measures how well PMs create tasks and keep the project schedule current.
- Project Baseline – Measures whether or not baselines exist.
- Project Zero ETC’s – Measures how well the PM assigns resources to tasks with ETCs.
- Project Past ETC’s – Measures how many improperly scheduled tasks the PM has.
- Project Milestone / Key Tasks – Measures how well PMs create and manage Milestones / Key Tasks.
- Project Schedule Variance – Measures how effectively PMs manage their schedules.
- Project Effort Variance – Measures how effectively PMs manage their project efforts.
- Project Budget Variance – Measures how effectively PMs manage budgets or cost plans.
- Project Unfilled Roles – Measures project roles with allocations that are already started or starting within the next 30 days.
- Project Data Quality – Measures how effectively PMs complete the Description, Stage, Progress, Objective, and Sponsor/Business Owner fields.
- Project Commitment – Measures the hard allocations for a project over a two week time frame.
- Resource Clarity Usage – Measures how often users log into Clarity.
- Resource Timesheet – Measures if timesheets post in a timely manner.
- Resource Allocation – Measures how well RMs keep total resource allocations within the expected range for future time periods.
- Resource Actualy Utilization – Measures how well Resource allocations match actuals.
- Resource Allocation Date in the Past – Measures how many resources are open for time entry with dates in the past.
- Resource Data Quality – Measures how well RMs complete the Resource Manager and Primary Role fields and optionally the Skill and Employment Type fields.
- Resource Commitment – Measures how much resource available time is committed to projects.
-
Rego’s Clarity Adoption Metrics package consists of two sets of metrics: Project metrics, and Resource metrics. Project metrics measure how effectively project managers are using Clarity to manage their projects. Resource metrics measure how effectively resource managers are using Clarity to manage resources. Metrics are scored on a scale of 0 to 5, with higher scores indicating greater adoption and use. All metrics can be viewed numerically or graphically, and can be broken out by OBS. In addition, metric data can display as a 12-month rolling history to help identify trends. Project metrics can also display by lowest / highest adoption rates for a specific resource metric or all resource metrics. There is a variety of way to view the Adoption Metric data, therefore, Rego has made this simple by creating an Adoption Metrics object that contains multiple tabs. Each tab displays one or more of the Project or Resource Adoption Metrics. Based on the nature of the Metrics some tabs will allow the ability to use a pull down menu to select a specific Adoption Metric. There is also a Metrics trending view that pulls monthly snapshots of the metrics. Project metrics consist of the following: - Project Status Reporting – Measures how well PMs create and publish project status reports.
- Project Risk Adoption – Measures how well Risks are being used and managed.
- Project Issue Adoption – Measures how well Issues are being used and managed.
- Project Schedule – Measures how well PMs create tasks and keep the project schedule current.
- Project Baseline – Measures whether or not baselines exist.
- Project Zero ETC’s – Measures how well the PM assigns resources to tasks with ETCs.
- Project Past ETC’s – Measures how many improperly scheduled tasks the PM has.
- Project Milestone / Key Tasks – Measures how well PMs create and manage Milestones / Key Tasks.
- Project Schedule Variance – Measures how effectively PMs manage their schedules.
- Project Effort Variance – Measures how effectively PMs manage their project efforts.
- Project Budget Variance – Measures how effectively PMs manage budgets or cost plans.
- Project Unfilled Roles – Measures project roles with allocations that are already started or starting within the next 30 days.
- Project Data Quality – Measures how effectively PMs complete the Description, Stage, Progress, Objective, and Sponsor/Business Owner fields.
- Project Commitment – Measures the hard allocations for a project over a two week time frame.
- Resource Clarity Usage – Measures how often users log into Clarity.
- Resource Timesheet – Measures if timesheets post in a timely manner.
- Resource Allocation – Measures how well RMs keep total resource allocations within the expected range for future time periods.
- Resource Actualy Utilization – Measures how well Resource allocations match actuals.
- Resource Allocation Date in the Past – Measures how many resources are open for time entry with dates in the past.
- Resource Data Quality – Measures how well RMs complete the Resource Manager and Primary Role fields and optionally the Skill and Employment Type fields.
- Resource Commitment – Measures how much resource available time is committed to projects.
-
Time by Assignment report displays time logged to assignments and its associated actuals on monthly basis for all filtered investments. It also displays total ETC and Actual hours associated with an assignment. User can further narrow their search by OBS Type & Path, Investment Type, Investment Charge Code, Investment Name, Task Name, Resource Name, Assignment Start Date and Assignment Finish Date. User can use exact dates or relative dates for Assignment Start and Finish Dates filter parameters. -
Time by Stage and Timescale – Grid report displays hours for all tasks on projects by their stage for a user-defined time period. Information can be drilled down to Year, Quarter or Monthly level. Using this report, Management can determine if excess time is being spent on a certain task stage within a project You can further narrow your search by Month Start Date, OBS Type & Path, Is Project Active? And Is Template? -
Time by Stage and Timescale – Graph report is a stacked column chart that displays hours for all tasks on projects by their stage for a user-defined time period. Using this report, Management can determine if excess time is being spent on a certain task stage within a project You can further narrow your search by Month Start Date, OBS Type & Path, Is Project Active? And Is Template? -
Time by Investment report displays time spent by resources on investment(s). User can view only the investments that he has access to view. Information can be drilled to Yearly, Quarterly or Monthly level. User can further narrow their search by OBS Type & Path, Investment Name, Month Start Date and Is Project Active?. -
This portlet provides a view into the number of timesheets that were expected to be completed for a specified time period(s) as well as the number of timesheets that were completed and the percent complete. This can also be filtered by OBS so that a company can see timesheet compliance at the OBS level. -
This portlet provides a view into the number of timesheets that were expected to be completed for a specified time period(s) as well as the number of timesheets that were completed and the percent complete. This can also be filtered by OBS so that a company can see timesheet compliance at the OBS level.
