]po[ Estimate to Complete

This package implements "Estimate to Complete (ETC)" or "Estimate Time to Complete", a project management tool used to track and forecast the performance of projects and individual tasks. ]project-open[ ETC allows users to conveniently enter their estimates how many hours they need to complete a task. The entry form has been added to the normal timesheet entry screen, effectively avoiding additional effort on the resource side.

Please contact us if you have questions or need training to rollout this functionality in your organization.

Estimate to Complete Entry

The following screenshot shows a project ("Motor Development") where the current user is assigned to perform "Brainstorm Concepts" with 100%.

The user is also assigned to perform other tasks, but without a specific percentage assignment. Therefore no ETC entry fields are shown.

image:estimate-to-complete-entry.png

 

Estimate to Complete Reporting

After the manual entry of ETC values by users as above, the "Project Tasks" tab of a project may show values similar to the following:

  • The ETC of the "Search Patents" and "Review Comp products" is 0.0, because these tasks have been finished.
  • The calculation of the ETC of "Brainstorm concepts" is shown below.

image:estimate-to-complete-tasks.png

 

Estimate to Complete Debugging

The following table with the detailed values entering in the calculation of ETC is available in the task's detail page. You can get there by clicking on the task's link ("Brainstorm Concepts" in the example above).


Indicator Value Comment
Time Planning
Start 2017-03-22    
Scheduled start of task
End 2017-05-09    
Scheduled end of task
Time Passed -27.3   Days since task start.
Negative values indicatate that the task will start in the future.
Time Passed % -40.6   Progress of the task as a percentage between start- and end date.
Values < 0 indicate that the task will start in the future.
Values > 100 indicate that end date of the task has passed.
Hour Based Planning
Planned Hours 552.0   Estimation of the work needed to complete the task.
Typically imported from MS-Project or entered manually.
Billable Hours 552.0   Normally same as planned units, but used for invoicing customers.
Logged Hours 141.0   Hours logged by employees in the timesheet.
Logged Hours % 25.6   Logged hours as a percentage of planned hours.
This corresponds to the resources consumed
(ignoring resources other than logged hours).
Percent Completed 24.2   How much of the task has been finished (percent)?
Entered manually by the PM normally.
Should be greater or equal to logged hours %, otherwise the task is late.
Resources Assigned 400.0   How many resources have been assigned to the task (percent)?
One resource counts as 100%.
Estimate to Complete
Estimate to Complete
(Planned)
418.5   Based on the number of hours left to work, according to planned hours and percent completed.
Estimate to Complete
(Earned Value)
442.3   Based on the logged hours that it took to achieve the current percent completed.
Estimate to Complete
(Manually Entered)
463.9   Based on manually entered ETC values (during timesheet entry), taking planned ETC as a default if no estimates are available.
Watch out for outdated ETC estimates!
Estimate at Completion
Estimate at Completion
(Planned)
552.0   = Planned Hours.
Estimate at Completion
(Earned Value)
583.3   Based on the logged hours that it took to achieve the current percent completed.
Estimate at Completion
(Manually Entered)
604.9   Based on manually entered ETC values (during timesheet entry), taking planned ETC as a default if no estimates are available.
Watch out for outdated ETC estimates!

Estimate to Complete History

The history of the ETC entries by each users are available on the task's detail page. You can get there by clicking on the task's link ("Brainstorm Concepts" in the example above).

[image:estimate-to-complete-history.png]

 

References


Package Documentation

Procedure Files

tcl/intranet-estimate-to-complete-procs.tcl       Estimate to Complete 

Procedures

im_estimate_to_complete_task_details_component       Returns information about ETC and other estimation types. 
im_estimate_to_complete_task_history_component       Returns information about ETC and other estimation types. 

SQL Files

sql/postgresql/intranet-estimate-to-complete-create.sql        
sql/postgresql/intranet-estimate-to-complete-drop.sql        
sql/postgresql/upgrade/upgrade-5.0.2.2.0-5.0.2.2.1.sql        

Content Pages

 

 


 


  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

E-08907 Hospitalet de Llobregat (Barcelona)

 Tel Europe: +34 932 202 088
 Tel US: +1 415 429 5995
 Mail: info@project-open.com