Rules & formulas

Scoring calculation map

Every score follows ten deterministic steps — no machine learning. Trace any number back to a raw input and a published rule.

REWS_ThresholdsREWS_Raw_DataREWS_ScoringGrading_WeightsGrading_InputGrading_ScoringDecision_MatrixDashboard

REWS engine

Steps 1–5

RAG → risk band → escalate

Grading engine

Steps 6–9

Domains → letter → renewal

Decision lookup

Step 10

Regulator + AB actions

Rule set

REWS_Thresholds

Editable rules

Per indicator: direction (Higher / Lower), Green & Amber boundaries, RAG scores (100 / 60 / 20), and category weight.

Green score = 100 · Amber score = 60 · Red score = 20
Category weights (sum = 100%):
  Governance 15% · Financial 20% · Assessment 20%
  Technology 10% · Compliance 20% · Training & Outcome 15%

Code	Indicator	Dir	Green	Amber	Wt
G1	Leadership changes (Chairperson/CEO) in last 12 months	Lower	0	1	15%
G2	Statutory committees non-functional (Board/Audit/Grievance)	Lower	0	1	15%
G3	Unresolved conflict-of-interest cases reported	Lower	0	1	15%
F1	Net worth	Higher	50	0	20%
F2	YoY revenue growth	Higher	5	-10	20%
F3	Maximum statutory/vendor payment delay	Lower	30	90	20%
A1	Pass-rate deviation from national benchmark (abs.)	Lower	10	20	20%
A2	Batches with missing assessment evidence	Lower	2	5	20%
A3	Reassessment / appeal rate	Lower	3	7	20%
T1	Data security incidents	Lower	0	1	10%
T2	Missing mandatory integrations (Kaushal Verse/SIDH/ABC)	Lower	0	1	10%
T3	System downtime (assessment/LMS platform)	Lower	4	12	10%
C1	MIS/data non-submission instances	Lower	0	2	20%
C2	Average delay in regulatory reporting	Lower	7	20	20%
C3	Regulatory violations / show-cause notices	Lower	0	1	20%
L1	Learner dropout rate	Lower	10	20	15%
L2	Placement / employment rate	Higher	50	30	15%
L3	Trainer vacancy rate	Lower	10	25	15%

Rule set

REWS_Raw_Data

Input values

One row per AB · 18 raw monitoring values (G1–L3). No formulas on this sheet — feeds REWS_Scoring.

Input layout: AB Code | AB Name | G1 G2 G3 | F1 F2 F3 | A1 A2 A3 | T1 T2 T3 | C1 C2 C3 | L1 L2 L3

Rule set

REWS_Scoring

Live formulas

Indicator RAG score

IF direction = "Higher":
  score = 100  IF raw ≥ green
        = 60   ELSE IF raw ≥ amber
        = 20   ELSE                      → Red

IF direction = "Lower":
  score = 100  IF raw ≤ green
        = 60   ELSE IF raw ≤ amber
        = 20   ELSE                      → Red

Category scores

governance = AVERAGE(G1, G2, G3)
financial  = AVERAGE(F1, F2, F3)
assessment = AVERAGE(A1, A2, A3)
technology = AVERAGE(T1, T2, T3)
compliance = AVERAGE(C1, C2, C3)
training   = AVERAGE(L1, L2, L3)

Composite health → risk

composite_health = Σ (category_score × category_weight)
composite_risk   = 100 − composite_health

Risk band

risk_band = "High"    IF composite_risk > 45
          = "Medium"  ELSE IF composite_risk > 25
          = "Low"     ELSE

Red flags & escalation

red_flag_count = COUNT of indicator scores = 20

escalation =
  "ESCALATE"   IF risk_band = High OR red_flags ≥ 3
  "WATCHLIST"  ELSE IF risk_band = Medium OR red_flags ≥ 1
  "ROUTINE"    ELSE

monitoring_cadence =
  High   → Monthly desk + surprise audit ≤ 30 days
  Medium → Quarterly desk + half-yearly audit
  Low    → Annual review (standard cycle)

Design note: ≥3 red flags escalate even if composite band is Low — a severe red cannot be diluted by averaging.

Rule set

Grading_Weights

Editable weights & bands

Domain weights (must sum to 100%), letter-grade cut-offs, and risk-linked deductions.

Domain	Weight
D1 Governance & Institutional Capacity	10%
D2 Financial Sustainability	10%
D3 Qualification Design & Curriculum (QP-NOS alignment)	10%
D4 Training Delivery & Trainer Quality	15%
D5 Assessment Quality & Integrity	15%
D6 Industry Engagement & Learner Outcomes	15%
D7 Technology & Innovation Enablement	10%
D8 Future Planning, Grievance Redressal & Governance Response	15%

Min	Grade	Category
≥ 85	A+	Excellence
≥ 70	A	High Performing
≥ 55	B	Compliant / Satisfactory
≥ 40	C	Needs Improvement
≥ 0	D	Non-Compliant / At Risk

Risk deduction (pts): High = 8 · Medium = 3 · Low = 0

Rule set

Grading_Input

Input values

Assessed domain scores 0–100 per AB (D1–D8). Feeds Grading_Scoring.

Input layout: AB Code | AB Name | D1 | D2 | D3 | D4 | D5 | D6 | D7 | D8

Rule set

Grading_Scoring

Live formulas

Weighted composite

weighted_composite = Σ (domain_score[i] × domain_weight[i])  for i = D1…D8

Risk-linked deduction

risk_deduction = 8 IF REWS band = High
               = 3 IF REWS band = Medium
               = 0 IF REWS band = Low

final_grade_score = MAX(0, weighted_composite − risk_deduction)

Letter grade

letter = "A+" IF final ≥ 85
       = "A"  ELSE IF final ≥ 70
       = "B"  ELSE IF final ≥ 55
       = "C"  ELSE IF final ≥ 40
       = "D"  ELSE

Renewal readiness

renewal =
  "NOT READY"     IF letter = D OR risk_band = High
  "CONDITIONAL"   ELSE IF letter = C OR risk_band = Medium
  "READY"         ELSE

Rule set

Decision_Matrix

Lookup table

Action auto-match

tier = High   IF risk_band = High OR letter = D
    = Medium IF risk_band = Medium OR letter ∈ {B, C}
    = Low    ELSE  (A+ / A with Low risk)

regulator_actions, ab_actions, global_precedent = Decision_Matrix[tier]

Low

A+ / A · routine monitoring

Medium

B / C · watchlist · QIP

High

D · escalate · show cause

Rule set

Dashboard

360° combined view

Pulls live outputs from REWS_Scoring + Grading_Scoring + Decision_Matrix for each AB.

Portfolio columns:
  AB Code · Name · Category
  REWS Composite Risk Score
  REWS Risk Band
  Red-flag Count
  Escalation Trigger
  Grading Score
  Letter Grade
  Grade Category · Renewal Readiness
  Regulator Action · AB Action

Portfolio summary:
  COUNT ABs by risk_band ∈ {Low, Medium, High}
  COUNT ABs letter ∈ {A+, A} · COUNT letter = D

Rule set

AB_Master

Reference context

No scoring formulas — provides entity type, sector, region, tenure, QP/NOS and annual certifications for differentiated monitoring context.