Data Alchemist

🚀 Data Alchemist

Transform messy spreadsheets into clean, validated data with AI-powered tools

Upload Your Data Files

Upload all three required files in sequence: Clients → Workers → Tasks

1
Clients
2
Workers
3
Tasks

Progress: 0/3 files uploaded

1

Clients

Upload client data with priorities and task requests

ClientID, ClientName, PriorityLevel (1-5), RequestedTaskIDs, GroupTag, AttributesJSON

Drag & drop files here or click to browse

.CSV.XLSX.XLS
2

Workers(Waiting...)

Upload worker skills, availability, and capacity data

WorkerID, WorkerName, Skills, AvailableSlots, MaxLoadPerPhase, WorkerGroup, QualificationLevel

Upload previous files first

3

Tasks(Waiting...)

Upload task requirements and scheduling constraints

TaskID, TaskName, Category, Duration, RequiredSkills, PreferredPhases, MaxConcurrent

Upload previous files first

📋 Required Data Relationships

🔗 Cross-References:

• Clients.RequestedTaskIDs must match existing TaskIDs in Tasks file

• Tasks.RequiredSkills must have matching workers with those skills

• Workers.AvailableSlots should align with Tasks.PreferredPhases

⚖️ Priority Levels:

• Client PriorityLevel: 1-5 (higher = more important)

• Worker QualificationLevel: 1-10 or text levels (Junior, Senior, etc.)

📅 Phase Management:

• AvailableSlots: JSON array like [1,3,5]

• PreferredPhases: Range "1-3" or array [2,4,5]