-
Notifications
You must be signed in to change notification settings - Fork 0
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Make the TOTAL PROJECT COST data field in General Info mirror the COMPUTED total cost in the matrix on Investment Cost per Funding Source (rather than as freehand) #206
Comments
The purpose of the total project cost field is to serve as reference in checking the breakdown by funding source and by region. If you allow it to be autocomputed instead you won't know which of the breakdown is correct or if any of them are correct. |
I'd rather it just mirrors the grand total in the Investment Cost by
Funding Source. At the encoder level, they should not be able to submit the
PAP if the Investment targets per funding source and the Investment targets
by Region do not match.. Thus, after they harmonize the 2 tables, the Data
Field on the Total Project Cost in General Information need only rely on
the Grand Total of the Investment Target per funding source.
Or better yet, maybe do away with the total project cost field. As long as
the figures in the Investment Targets per funding source and per region
match, then that should suffice. Sa PIPOL wala naman nang Total Cost field,
it just prompts encoders to ensure that the tables match.
Sa reviewer side kasi sa PIPS, may adjustments often na ginagawa sa mga
targets during review/ checking, but wala kasing validation process sa
account ng reviewer. So kahit nagedit na si reviewer (IPD) ng targets sa
per funding source and per region, walang prompt na lumalabas that the
Total Project cost field ay hindi naupdate.
Regards,
*MARICAR H. TAYCO*
Planning Officer
Investment Programming Division
Planning and Monitoring Service
*Department of Agriculture*
Elliptical Road, Diliman, Quezon City 1100
www.da.gov.ph
*CONFIDENTIALITY NOTICE: The contents of this email message and any
**attachments
are intended solely for the addressee(s) and may contain **confidential
and/or privileged information and may be legally protected from **disclosure.
If you are not the intended recipient of this message or their agent, **or
if this message has been addressed to you in error, please immediately
alert **the sender by reply email and then delete this message and any
attachments. If **you are not the intended recipient, you are hereby
notified that any use, **dissemination, copying, or storage of this message
or its attachments is strictly **prohibited.*
…On Wed, Jan 24, 2024 at 10:21 AM Mark Lester Bolotaolo < ***@***.***> wrote:
The purpose of the total project cost field is to serve as reference in
checking the breakdown by funding source and by region. If you allow it to
be autocomputed instead you won't know which of the breakdown is correct or
if any of them are correct.
—
Reply to this email directly, view it on GitHub
<#206 (comment)>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCFCQSATS5SMKGEDY3LNS6TYQBV2NAVCNFSM6AAAAABB2QEDKSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMBXGI2DANBQHA>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Consistency =/= correctness To illustrate: sample total project cost: 9sample regional breakdown:
sample funding source breakdown:
Since they match, the system will accept the inputs as correct. However, the true total project cost is 9 which means something is missing. A potentially correct breakdown would be: correct sample regional breakdown:
correct sample funding source breakdown:
The reason why it's there is to have a reference in case some records go missing in the database or other users Now, I think the problem is not with the encoders but the reviewers since the system prevents encoders from endorsing PAPs whose investment cost per funding source and per region do not match the total cost reported. The code responsible for this is: // validate consistency of breakdowns with inputted total cost
if (totalCost != null) {
// check if inputted total cost is not equal to investment per funding source grand total
if (totalCost!.round() != fsInvestmentTotalRow.grandTotal.round()) {
// add an issue if the two do not match
issues
.add('Total cost is not the same as breakdown per funding source.');
}
// check if inputted total cost is not equal to investment per region grand total
if (totalCost!.round() != regionalInvestmentTotalRow.grandTotal.round()) {
// add an issue if the two do not match
issues.add('Total cost is not the same as breakdown per region.');
}
} Given this, my recommendations would be:
For your consideration. |
Encoders are required to provide an annual breakdown of their investment targets in the Investment Cost per Funding Source; we suggest that whatever will be automatically computed as the total cost ("TOTAL" column, which could be sum of all Funding Sources), should be automatically mirrored in the Data Field, "Total Project Cost (in absolute PHP)" found in the General Information section. This is to do away with the need for encoders to have to edit this data field every time they have to revise/ edit the annual breakdown in the Funding Source table.
The text was updated successfully, but these errors were encountered: