Description:

To calculate Batch Class PPM

 

Steps:

Formula to calculate PPM is as below:
Batch Class PPM = (Total no. of Page count) / (Duration)
where,
Total no of page count = Sum of all pages executed in particular batch class
Duration = (Total time taken by the batch in all modules) -(Total time taken by operator in Review & Validation )

The above value is then rounded off.
I checked the reports database of your system and the calculation is as below:

 

Example:
1. Total number of Page count for BC4:
select dbo.pages_per_batch_class_1.pageCount from dbo.pages_per_batch_class_1 where batch_class_filter_name like ‘BC4%’

Result: 6188 pages

2. Duration:
Time taken by all modules:
select SUM(report_ephesoftv4.dbo.throughput_common_module_data.duration_of_execution_in_minutes) from dbo.throughput_common_module_data where batch_class_id=’BC4′;
Result: 13832.4836595911 (minutes)

Time taken by operator in Review & validation module:
select SUM(report_ephesoftv4.dbo.throughput_common_module_data.duration_of_execution_in_minutes) from dbo.throughput_common_module_data where batch_class_id=’BC4′ and module_name IN (‘Review Document module’,’Validate Document module’);
Result: 0.197616670513526 (minutes)

3. Batch class PPM = 6188/(13832.48 – 0.19) = 0.44
Capture(1).JPG

Rounder off value = 0
Capture1.JPG

Was this article helpful to you?

Abhishek Jain

Comments are closed.