Nsites · City of Indianapolis Charter School Intelligence Platform

OEI Financial Validation Lab

Nsites CQ2 calculation, source traceability & replication validation

Reviewer: Allan Bell - Nsites
Run sealed 04 Sep 2026 · 18:16 UTC
Sequencing evidence

Validation Workflow Audit Log

The log proves the required order: source documents → extraction → mapping → formula → Nsites result → lock → comparison reveal.

All 24 Nsites results were sealed at 18:16:27 UTC. The first comparison target was read at 18:16:40 UTC — 13 seconds later. No target value was in engine memory during calculation.
  1. STEP 1
    Source package received
    28 expected files; 28 present (1 duplicate).
    2026-09-04 18:10:02 UTC
  2. STEP 2
    Manifest reconciliation completed
    24 GREEN · 3 YELLOW · 0 RED · 1 GRAY.
    2026-09-04 18:10:40 UTC
  3. STEP 3
    Documents classified
    Validation roles assigned; CQ2 reports quarantined as targets.
    2026-09-04 18:11:15 UTC
  4. STEP 4
    Extraction run
    134 raw values extracted with page/sheet coordinates.
    2026-09-04 18:11:58 UTC
  5. STEP 5
    Entity mapping applied
    School / network / affiliate / consolidated levels assigned per metric.
    2026-09-04 18:12:30 UTC
  6. STEP 6
    Framework version resolved
    FY2024-25 → 2025-26 framework; FY2023-24 → 2023-24 framework.
    2026-09-04 18:12:55 UTC
  7. STEP 7
    Nsites calculations executed
    Target values not loaded into engine memory during this step.
    2026-09-04 18:14:00 UTC
  8. STEP 8
    Nsites results LOCKED
    24 numeric/qualitative results hashed and sealed.
    2026-09-04 18:16:27 UTC
  9. STEP 9
    Salesforce/CAP comparison revealed
    4 CAP differences surfaced, none overwritten.
    2026-09-04 18:16:40 UTC
  10. STEP 10
    Published CQ2 comparison revealed
    Targets read from CQ2 report PDFs.
    2026-09-04 18:16:48 UTC
  11. STEP 11
    Variance and match status computed
    See validation matrix.
    2026-09-04 18:17:05 UTC
  12. STEP 12
    Exceptions routed
    6 review exceptions created; all reset to Pending review.
    2026-09-04 18:17:20 UTC
  13. STEP 13
    Exceptions - Review Needed released for approval
    No item is approved until a permitted reviewer acts; live decisions appear in the workflow log below.
    2026-09-04 18:17:45 UTC
  14. STEP 14
    City/Donovan proof report generated
    Available in Exports.
    2026-09-04 18:18:00 UTC
Live approval trail

Exceptions - Review Needed approval log

Every submit, approve, reject and reopen action taken in Exceptions - Review Needed, with the acting role and timestamp.

No approval actions recorded yet. All 6 review exceptions are pending in Exceptions - Review Needed.