Applicant triage built around messy real data
ApplicantSorter (WPF)
Desktop .NET tool that takes applicant CSVs, matches them against ranking data, and exports files that are easier for collaborators to review.
ApplicantSorter turns messy CSV intake into review-ready files. The hard part is matching inconsistent real-world data without losing the context reviewers need.
Systemübersicht
Architektur
Two imperfect data sources enter a deterministic pipeline. Normalization makes them comparable, rules classify each row, and the export keeps both the source context and the decision trace.
- 01
Source files
- CSVApplicant CSV
- CSVRanking data
- 02
Normalization
- Countries + subjects
- .NET 8University names
- 03
Decision engine
- Ranking match
- C#Category + reason
- 04
Review files
- CSVAccepted / Rejected
- ClosedXMLEU / non-EU workbooks
Entscheidungsprotokoll
Technologieentscheidungen
Wofür jede Technologie verantwortlich ist und warum sie zum Projekt gehört.
AufgabeImport, normalization, and classification rules
Warum diese WahlThe pipeline is strongly typed, file-oriented, and rule-heavy. C# keeps the transformations explicit and testable.
AufgabeInput and lightweight exchange
Warum diese WahlIt matches the files already supplied by collaborators and avoids imposing a new intake system before the sorting step.
AufgabeComparable country, subject, and university values
Warum diese WahlApplying rankings to raw labels would produce unreliable results. Canonical values make the later rules explainable.
AufgabeReadable review workbooks
Warum diese WahlReviewers need the original columns plus ranking and reasoning fields. XLSX supports that richer handoff better than CSV alone.