5. Upload Departments and Complaint Types

5.1 What is This Phase?

You will create:

• Departments (Water, Sanitation, Electricity, etc.)
• Designations (Engineer, Manager, Supervisor, etc.)
• Complaint Types (Water not coming, Garbage not collected, etc.)

5.2 Download the Template

Step 1: Find the Common Master section

Step 2: Run the download cell

Step 3: Open Common and Complaint Master.xlsx

5.3 Fill Sheet 1: Departments & Designations

Example Data:

Department Name*	Designation Name*
WATER DEPARTMENT	engineer
WATER DEPARTMENT	manager
WATER DEPARTMENT	supervisor
SANITATION	engineer
SANITATION	supervisor
ELECTRICITY	technician

Important:

• You can add multiple designations for one department
• Department names must be EXACTLY the same spelling

5.4 Fill Sheet 2: Complaint Types

Example Data:

Complaint Type*	Complaint sub type*	Department Name*	Resolution Time (Hours)*	Search Words
Water Issues	Tap broken	WATER DEPARTMENT	24	water,tap,broken
Water Issues	No water supply	WATER DEPARTMENT	12	water,supply,no water
Garbage	Not collected	SANITATION	8	garbage,waste,collection
Street Light	Not working	ELECTRICITY	48	light,street,bulb

Important:

• Department Name must match EXACTLY with Sheet 1
• Resolution Time is in hours
• Search Words help citizens find complaints (use commas)

5.5 Upload and Process

Step 1: Save the Excel file

Step 2: Upload in the notebook

Step 3: Run the processing cell

5.6 Check Results

✅ PHASE 3 COMPLETE

Departments Created: 3

Designations Created: 6

Complaint Types Created: 4