QA Tool

Ward Count Extractor

Upload a colored workbook and extract per-student ward counts from sheet 12 directly in the app.

Verification targets shown in table: ANC M=24, Pediatric M/E/N=12/6/6, PNC M/E/N=6/6/6, Gynae M=6, FP M=6, Labor M/E/N=12/6/6, Total=102.

Internal Engine Audit (No Upload)

Based on current scheduler configuration: passed 0 / 40 students.

Upload .xlsx

Internal Engine Audit Preview (first 20 students)

studentSerial	actual_total_days	expected_total_days	ANC_M_required	PEDIATRIC_M_required	PEDIATRIC_E_required	PEDIATRIC_N_required	PNC_M_required	PNC_E_required	GYNAE_M_required	LABOR_M_required	LABOR_E_required	ANC_total	LABOR_total	PNC_total	PEDIATRIC_total	GYNAE_total	FP_total
1	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	28	22	24	6	6
2	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	27	23	24	6	6
3	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	27	23	24	6	6
4	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	27	23	24	6	6
5	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	27	23	24	6	6
6	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	27	28	23	24	6	6
7	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	27	28	23	24	6	6
8	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	27	28	23	24	6	6
9	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	27	28	23	24	6	6
10	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	28	22	24	6	6
11	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	28	22	24	6	6
12	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	28	22	24	6	6
13	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	28	22	24	6	6
14	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	28	22	24	6	6
15	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	27	23	24	6	6
16	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	27	23	24	6	6
17	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	27	23	24	6	6
18	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	28	27	23	24	6	6
19	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	27	28	23	24	6	6
20	114	38.5	2.5	8.5	4	2.5	2	2	6	2	2	27	28	23	24	6	6