Step2: Overall Usage.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2
3
4
5
6
7
8	OVERALL USAGE SUMMARY (JULY - JUNE)
9	Academic Year	Footfall			Transaction (Issue/Ret.)			No. of Working Days (W1)	Avg. Footfall Per Day (X=A/W1)	Avg. Trans. Per Day (Y=B/W1)	eAccess Usage			Overall Physical Usage / Per Day (X+Y)	Overall Avg. Usage / Per Day (X+Y+Z)	Strength		% Usage / day			Remarks
10	Academic Year	Student (a)	Faculty (b)	Total (A)	Student (c)	Faculty (d)	Total Trans. (B)	No. of Working Days (W1)	Avg. Footfall Per Day (X=A/W1)	Avg. Trans. Per Day (Y=B/W1)	Total eAccess (c)	No. of Working Days (W2)	Avg. eAccess Per Day (Z=c/W2)	Overall Physical Usage / Per Day (X+Y)	Overall Avg. Usage / Per Day (X+Y+Z)	No of Student (S)	No. of Faculty (F)	Footfall (X/(S+F)*100)	Trans. (Y/(S+F)*100)	eAccess (Z/(S+F)*100)	Remarks
11	2018-19	34,324	708	35,032	44,058	2,209	46,267	252	139.02	183.60	12,223	365	33.49	322.62	356.10	0	0	#DIV/0!	#DIV/0!	#DIV/0!
12	2019-20	28,988	539	29,527	21,783	1,216	22,999	158	186.88	145.56	24,776	366	67.69	332.44	400.14	0	0	#DIV/0!	#DIV/0!	#DIV/0!
13	2020-21	692	159	851	1,308	509	1,817	165	5.16	11.01	8,099	365	22.19	16.17	38.36	2,279	128	0.21	0.46	1
14	2021-22	16,566	363	16,929	14,173	875	15,048	243	69.67	61.93	8,469	365	23.20	131.59	154.80	2,339	138	3	3	1
15	2022-23	42,566	904	43,470	22,978	1,258	24,236	257	169.14	94.30	12,564	365	34.42	263.45	297.87	2,237	131	7	4	1
16	2023-24	52,109	1,665	53,774	29,091	2,002	31,093	238	225.94	130.64	5,474	366	14.96	356.58	371.54	1,982	140	11	6	1
17	2024-25	67,524	1,477	69,001	30,421	1,387	31,808	254	271.66	125.23	8,362	365	22.91	396.89	419.80	2,233	140	11	5	1
18	2025-26	53,203	1,415	54,618	24,901	1,188	26,089	244	223.84	106.92	49,799	365	136.44	330.77	467.20	2,565	155	8	4	5
19	Monthly Usage (2025-26) / W			4,552			2,651
20	Total Monthly Usage (Trans+Footfall) - X			7,202
21	Reqular Students & Faculties - Y			2,720
22	Monthly Usage % 2025-26) [y/x*100]			37.77
23
24
25	OVERALL USAGE SUMMARY (eAccess)
26	Period: 1st July - 30th June
27	Academic Year	*eResources (Jan-Dec)	OPAC	IR	OER	Website	Blog	Remote Access (Knimbus) (Mar.19 - Mar.21)	Plagiarism Check	TOTAL	No. of days	Avg. Users Per Day	Remarks
34	2024-25	151	2961	0	42	3743	1191	0	274	8362	365	22.91	IR outsourcing done from NDLI \| Remote Access outsourcing done
35	2025-26	0	39409	0	155	7377	2858	0	0	49799	365	136.44
36
37
38
39
40	Academic Year	Footfall	Transaction	eAccess
41	2025-26	54,618	26,089	49,799
42	2024-25	69,001	31,808	8362
43	2023-24	53,774	31,093	5474
44	2022-23	43,470	24,236	12564
45	2021-22	16,929	15,048	8,469
46
47
48
49
50
51
52
53
54
55	Academic Year	Footfall	Transaction	eAccess
56	2020-21	851	1,817	8,099
57	2021-22	16,929	15,048	8,469
58	2022-23	43,470	24,236	167,399
59
60
61
62
63
64
65
66
67
68
69
70
71	Academic Year	Footfall	Transaction	eAccess
72	2021-22	16,929	15,048	8,469
73	2022-23	43,470	24,236	167,399
74	2023-24	53,774	31,093	5,474
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90	Academic Year	Footfall	Transaction	eAccess
91	2022-23	43,470	24,236	167,399
92	2023-24	53,774	31,093	5,474
93	2024-25	69,001	31,830	7,804
94
95
96
97
98
99
100
101
102
103
104
105
106