UPI-Metrics Matrix #1.xls

	A	B	C	D	E	F	G	H	I	J	M
1	Service Name	Available (Y=1, N=0)	Year Implemented (2020-1 to 2023-4)	Number of Requests	Payment Required (Y=1, N=0)	Online Payment (Y=1, N=0)	Action Taken (Updated=1, None=0, Deleted=-1)	Screenshot/URL Provided (Y=1, N=0)	Weighted Score Calculation (Formula)		Total Digital Ready Score
2	Alumni Forum	1	3	100	0	0	0	1	1	9
3	Digital Academic Calendar	1	3	11	1	1	1	1	0	10
4	Digitisation of Library	1	3	22	1	1	1	1	0.1235955056	10.37078652
5	Online Admission System	1	3	33	1	1	1	1	0.2471910112	10.74157303
6	Online Attendance Mgmt.	1	3	22	1	1	1	1	0.1235955056	10.37078652
7	Online Courses LMS	1	3	40	1	1	1	1	0.3258426966	10.97752809
8	Online Examination	1	3	44	1	1	1	1	0.3707865169	11.11235955
9	Online Fee Payment	1	3	66	1	1	1	1	0.6179775281	11.85393258
10	Online Grievance Redressal	1	3	12	1	1	1	1	0.01123595506	10.03370787
11	Online Issuance Certs	1	3	12	1	1	1	1	0.01123595506	10.03370787
12	Online Leave Mgmt.	1	3	13	1	1	1	1	0.02247191011	10.06741573
13	Scholarship Portal	1	3	14	1	1	1	1	0.03370786517	10.1011236
14	Student Dashboard	1	3	15	1	1	1	1	0.04494382022	10.13483146
15
16
17
18				Total Digital Ready Score						134.7977528
19				Average Service Score						10.36905791
20				Count of Available Services						13
21				Count of Services with Online Payment						12
22
23				Your campus is Digi Ready %						80
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100