Pre-Loan Condition Check Completion Percent Calculator
Audit applicable pre-loan condition checks with explicit exclusions/weights and unresolved indices; no assertion that a completed checklist makes a loan safe.
Description
Pre-loan checklists can include nonapplicable requirements and unequal weights.
Pre-loan checklists can include nonapplicable requirements and unequal weights. Applicable completion differs from completion of every listed item.
Audit applicable pre-loan condition checks with explicit exclusions/weights and unresolved indices; no assertion that a completed checklist makes a loan safe.
When to use Pre-Loan Condition Check Completion Percent Calculator
Use this tool to audit applicable pre-loan condition checks with explicit exclusions/weights and unresolved indices; no assertion that a completed checklist makes a loan safe.
Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
How to use Pre-Loan Condition Check Completion Percent Calculator and understand its results
- Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
- Enter requiredCheckWeights, completedCheckFlags, notApplicableCheckFlags using the field table and calculation rules, then run the tool.
- Read applicableCheckCount, applicableWeightedCompletionPercent, uncompletedApplicableCheckIndices. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| requiredCheckWeights | Required check weights | list of number | Required |
| completedCheckFlags | Completed check flags | list of number | Required |
| notApplicableCheckFlags | Not applicable check flags | list of number | Required |
Align positive weights with binary completion and nonapplicability flags. Exclude nonapplicable weight, require some applicable weight and return count, weighted percentage and zero-based unresolved applicable indices.1
Paired lists must be nonempty and have equal lengths.
completion percent = 100 × completed applicable weight/total applicable weight Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| applicableCheckCount | Applicable check count | number |
| applicableWeightedCompletionPercent | Applicable weighted completion percent | number |
| uncompletedApplicableCheckIndices | Uncompleted applicable check indices | list of number |
{
"input": {
"requiredCheckWeights": [
1,
2,
3
],
"completedCheckFlags": [
1,
0,
1
],
"notApplicableCheckFlags": [
0,
1,
0
]
},
"output": {
"applicableCheckCount": 2,
"applicableWeightedCompletionPercent": 100,
"uncompletedApplicableCheckIndices": []
}
}Limitations and assumptions
A completed checklist does not establish that a loan is safe.
Numbers and computed results must be finite; overflow produces an error. Numeric lists are limited to 100,000 entries; the rules above may require smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.
Alternative or Complementary methods
Use Condition Check Interval During Tour Stops Scheduler: Plan arrival/periodic/optional departure checks on caller tour-stop ordinal windows, without duplicate coincident departure checks or conservation completeness guarantee. For a complementary task, use Catalogue Record Completeness Field Counter: Audit caller-required catalogue fields across aligned records, distinguishing complete records from pooled field coverage; actual schema/presence criteria are caller established.
References
Similar or alternative tools
- Condition Check Interval During Tour Stops Scheduler
Plan arrival/periodic/optional departure checks on caller tour-stop ordinal windows, without duplicate coincident departure checks or conservation completeness guarantee.
- Catalogue Record Completeness Field Counter
Audit caller-required catalogue fields across aligned records, distinguishing complete records from pooled field coverage; actual schema/presence criteria are caller established.