0% found this document useful (0 votes)
5 views3 pages

2024 Computation Template Instructions

Uploaded by

denzkie.anvil
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views3 pages

2024 Computation Template Instructions

Uploaded by

denzkie.anvil
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Instructions for Regional and District Offices:

1. Download a copy and accomplish the Excel file: Computation Template – 1 st Sem 2024.
Please make sure that there are official supporting documents for the data inputs that
you will be making in the file. Please note that no supporting documents for the data
input could result in the non-crediting of the rating.

2. Please accomplish first all the yellow cells in the “Dashboard” worksheet.

Note: Please avoid changing or modifying the dimensions and location of the data cell
that are colored yellow. This is to avoid errors when using the compilation program for
the batch processing of the accomplished templates by the BOE. Sufficient cells are
already provided the template to contain the needed data for the KPIs.

3. Then, proceed with accomplishing all the yellow cells in the proceeding worksheets.
Each worksheet accepts data input for each of the 24 Sub KPIs in the latest PGS
Measure R28 of the Department. The existing inputs in the yellow’s cells are just
samples intended to guide the user in accomplishing the form.

4. The accomplished computation templates are to be uploaded in the “Computation


Templates” folder. Please also see the “Instruction – Computation [Link]” file in
the said folder.

5. The supporting documents for each District and Regional Offices are to be uploaded in
the individual folders of the office.
Instructions for the Regional Offices – Checking of the District Office outputs:

1. The designated checker/s of the EMD shall check the accomplished templates of each
ESU under the RO for correct data entry and the presence of supporting documents.

2. Each Sub KPI worksheet in the computation template has a Verification and Checking
entry field in the leftmost columns below the cells for the Sub KPI rating.

3. Upon verification that the data entry for the Sub KPI is correct and backed up by a
supporting document as uploaded by the District Office in their corresponding folder, the
EMD checker shall change the cell under the “Verified and Checked” cell from “Not
Checked Yet” to “Checked” by clicking and selecting “Checked” in the drop-down list. If
errors are found by the EMD checker, he/she may either directly input the corrections or
ask it to be revised by the ESU.

4. In the case that there is no supporting document found in the folder of the District
Office for the Sub KPI, the EMD checker should leave the cell as “Not Checked Yet”.

5. After checking the Sub KPI data input, please input the name of the EMD checker in the
cell beside the “Checked and Verified by:” cell.
6. Repeat this for all the Sub - KPI worksheets in the file of the District Office

Common questions

Powered by AI

Inputting the EMD checker's name next to the "Checked and Verified by:" cell is significant because it ensures accountability and traceability. It identifies the individual responsible for verifying the data, enabling tracking of verification actions and maintaining transparency in the validation process .

If an EMD checker finds incorrect data entries in the Sub KPI worksheet, they may either directly input the corrections themselves or request the ESU to revise the errors. This ensures that the data remains accurate and that any discrepancies are addressed swiftly .

It is important not to alter the dimensions and locations of the yellow cells in the "Dashboard" worksheet to avoid errors during the batch processing of the accomplished templates by the BOE. The template is designed to handle specific data structures, and any changes could disrupt the functionality of the compilation program, leading to potential processing errors .

The responsibilities are divided such that District Offices are responsible for completing the Computation Template and providing supporting documents. Regional Offices, specifically through their EMD checkers, are tasked with verifying the data entries for accuracy and the presence of supporting documents. They ensure the integrity of submissions by marking data as "Checked" only if it meets all requirements and is supported by evidence .

Accomplished computation templates should be uploaded to the "Computation Templates" folder, whereas supporting documents for each District and Regional Office must be uploaded to the individual folders designated for each office. This organized system ensures clear traceability and accountability for all submissions .

The layout of the Computation Template facilitates the data input process by providing specific yellow cells that users need to fill out, ensuring all necessary fields for KPIs are addressed. Sample entries guide users, reducing errors and simplifying the completion process. This structured approach aids in maintaining consistency across completed templates .

If no supporting document is found for a data input, the EMD checker should leave the "Verified and Checked" cell as "Not Checked Yet." This indicates that the data has not been verified due to missing evidence, prompting further follow-up to obtain the necessary documentation .

The verification and checking process by the EMD ensures data integrity by having designated checkers review the data entries for correctness and for the presence of supporting documents. Each Sub KPI worksheet includes a Verification and Checking entry field where the checker marks the data as "Checked" only if it is correct and supported by documents. If errors are found, corrections can be directly inputted or requested for revision, maintaining the integrity and accuracy of the data .

Supporting documents play a crucial role in validating the data inputs for the Sub KPIs in the Computation Template. They serve as proof of the accuracy and credibility of the information provided, enabling verification and preventing the potential misuse or manipulation of data. The absence of these documents can result in the non-crediting of the KPI ratings .

The possible consequence of not providing official supporting documents when inputting data into the Computation Template – 1st Sem 2024 is the non-crediting of the rating. Supporting documents are necessary to validate the data inputs, and the absence of such documentation can lead to the data not being accepted as credible or accurate .

You might also like