| 1 | Processing Summary |
| 3 | Items received from collection | 14,203 | 100.0% | 480 GB | — | Baseline. Matches vendor Collection Manifest. |
| 4 | Duplicates removed (global dedup) | 1,221 | 8.6% | 42 GB | — | Expected. Custodian-attribution preserved on masters. |
| 5 | Items loaded to review | 12,981 | 91.4% | 421 GB | — | Feeds review environment. |
| 6 | Total exceptions (not loaded) | 1,022 | 7.2% | 17 GB | — | Detail in rows 8–15 below. |
| 7 | Exception Breakdown |
| 9 | Password-protected | 612 | 4.3% | 2.1 GB | REMEDIATE | Ask vendor for bulk crack pass; 400 are standard Office. Custodian re-ask for the rest. |
| 10 | Corrupt containers — partial recovery possible | 208 | 1.5% | 8.2 GB | REMEDIATE | Two PSTs from J. Sanders. Recovery ~75% expected. $1,400 estimate. |
| 11 | Zero-byte files | 121 | 0.9% | 0 GB | ABANDON | Noise. Filenames logged in Exceptions tab for the record. |
| 12 | Unsupported file types (proprietary CAD) | 81 | 0.6% | 4.3 GB | ABANDON | Not responsive on this matter. Preserved raw. |
| 13 | Bad OCR / low-text-yield images | 67 | 0.5% | 1.1 GB | DEFER | Do not push to TAR/GenAI. Route through linear review. |
| 14 | Encrypted volumes — key unavailable | 28 | 0.2% | 1.3 GB | ESCALATE | All from custodian K. Nguyen. Escalate to Client for direct outreach. Do not press. |
| 15 | Timestamp anomaly (epoch-zero) | 5 | 0.04% | < 0.1 GB | DEFER | Note in production narrative. Common artifact. |
| 16 | Family & Dedup Detail |
| 18 | Parent documents | 7,842 | 60.4% | | | Of loaded items. |
| 19 | Attachments | 5,139 | 39.6% | | | Family relationships preserved via GroupID. |
| 20 | Cross-custodian duplicates suppressed | 889 | 6.3% | | | CustodianList field populated on master document. |
| 21 | Near-duplicates (85%+ similarity) | 2,411 | 18.6% | | | Grouped for batching, not suppressed. |
| 22 | Email threads identified | 1,338 | — | | | Inclusive threading applied. Avg 4.2 messages/thread. |
| 23 | Custodian Distribution |
| 25 | Sanders, J. (GC) | 6,240 | 5,802 | 438 | 7.0% | Includes the 2 corrupt PSTs. Remediation-eligible. |
| 26 | Reyes, M. (SVP Sales) | 3,102 | 2,890 | 212 | 6.8% | Normal profile. Nothing to escalate. |
| 27 | Nguyen, K. (VP Ops) | 2,801 | 2,530 | 271 | 9.7% | Elevated. Drives the encrypted-volume escalation. |
| 28 | Zhang, L. (CFO) | 1,410 | 1,320 | 62 | 4.4% | Normal. |
| 29 | Delaney, P. (Board Chair) | 650 | 439 | 39 | 6.0% | Materially less than declared usage. Follow up on personal-device use. |
| 30 | Cost & Remediation Estimate |
| 32 | Password crack — Office | 400 | $8 | | $3,200 | Batch rate confirmed with vendor. |
| 33 | Password crack — archives | 212 | $60 | | $12,720 | May reduce via custodian re-ask; try that first for ~80 files. |
| 34 | PST partial recovery | 2 PSTs | $700 | | $1,400 | Fixed price agreed. |
| 35 | Custodian re-collection — Delaney | 1 | $3,500 | | $3,500 | Includes personal-device scoping conversation. |
| 36 | Total remediation ask | | | | $20,820 | Break-even: ~470 additional responsive docs at $45/doc review cost. |