Number of Docs Assigned: is the Total documents assigned in the project.
Report Date is the date in the mid of the project.
EndDate is the end date of the Project.
Fig 2 is the pivot table, I just want a formula to find what is the "QC will get Completed" in the end of the project based on the current QC Productivity at the mid of the project.
Formula Used:
QC Completed till Date =Sum (if(QCDatecoded<=ReportDate,[Docs Qced]))
QC Hrs till date =Sum (if(QCDatecoded<=ReportDate, [QCReview Hours]))
QC Productiviy till date ="QC Completed till date "/"QC Hrs till date"
Basically, in the middle of the project, I just want to estimate what is the number of documents will get QCed in the end of the project, based on the current productivity.
Sample excel sheet:
QC Reviewer
Date Coded
QCReview Hours
Docs Qced
Ganesh
04-Sep Fri
1
16
Jason
04-Sep Fri
1
17
Mithun
04-Sep Fri
1
23
Mamta
04-Sep Fri
1
25
Pascal
04-Sep Fri
1
14
Total
04-Sep Fri
5
95
Ganesh
07-Sep Mon
1
14
Jason
07-Sep Mon
1
17
Mithun
07-Sep Mon
1
23
Mamta
07-Sep Mon
1
23
Pascal
07-Sep Mon
1
14
Total
07-Sep Mon
5
91
Ganesh
08-Sep Tue
1
20
Jason
08-Sep Tue
1
17
Mithun
08-Sep Tue
1
23
Mamta
08-Sep Tue
1
26
Pascal
08-Sep Tue
1
18
Total
08-Sep Tue
5
104
Ganesh
09-Sep Wed
1
20
Jason
09-Sep Wed
1
22
Mithun
09-Sep Wed
1
23
Mamta
09-Sep Wed
1
26
Pascal
09-Sep Wed
1
18
Please see the qvw attachement for further clarification.
