STEP2:OVERALL USAGE SUMMARY.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
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		Avg. eAccess Per Day (Z=e/W2)	Overall Avg. Physical Usage / Day (X+Y)	Overall Avg. Usage Per Day (X+Y+Z)	Strength		% Usage / day
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 (e)	No. of Working Days (W2)	Avg. eAccess Per Day (Z=e/W2)	Overall Avg. Physical Usage / 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)
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	167,399	365	458.63	263.45	722.07	2,237	131	7	4	19
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	38,734	1,181	39,915	17,890	822	18,712	164	243.38	114.10	49,799	365	136.44	357.48	493.92	2,565	155	9	4	5
19	Total	242,769	5,815	179,583	163,812	9,456	141,460
20	Monthly Usage (2025-26) / W			3,326			2,651
21	Total Monthly Usage (Trans+Footfall) - X			5,977
22	Reqular Students & Faculties - Y			2,720
23	Monthly Usage % 2025-26) [y/x*100]			45.51
24
25
26
27
28
29
30
31
32
33
34
35
36
37	OVERALL USAGE SUMMARY (eAccess)
38	Period: 1st July - 30th June
39	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
40	2018-19	381	348	9425	0	694	175	998	202	12223	365	33.49	IEL, ASCE & ASME, Elsevier (SoP)
41	2019-20	2348	2254	9632	0	2429	1062	6632	419	24776	366	67.69	ASCE (Jan.-Dec.2020) \| Knimbus Remote - Mar.19-Mar.21
42	2020-21	113	2265	1344	209	2846	773	183	366	8099	365	22.19	ASCE (Jan.-Dec.2021) \| INFED Remote w.e.f. Jan2021 -
43	2021-22	322	3173	0	74	3348	612	104	868	8501	365	23.29	ASCE (Jan.-Dec.2021) \| IR not working
44	2022-23	1553	3972	154835	7	4817	905	75	1235	167399	365	458.63	ASCE (Jan.-Dec.2022) \| No. of Searchers performed \| Plagiarism - BPharm Students practice
45	2023-24	214	0	0	0	3900	595	0	765	5474	366	14.96	ASCE (Jan.-Dec.2024) Renewal not done \| INFED Remote Access PC HD Corrupt - outsourcing done \| IR not working
46	2024-25	151	2961	0	42	3743	1191	0	274	8362	365	22.91	IR outsourcing done from NDLI \| Remote Access outsourcing done
47	2025-26	0	39409	0	155	7377	2858	0	0	49799	365	136.44
48
49
50
51
52	Academic Year	Footfall	Transaction	eAccess
53	2024-25	69,001	31,808	8362
54	2023-24	53,774	31,093	5474
55	2022-23	43,470	24,236	12564
56	2021-22	16,929	15,048	8,469
57
58
59
60
61
62
63
64
65
66	Academic Year	Footfall	Transaction	eAccess
67	2020-21	851	1,817	8,099
68	2021-22	16,929	15,048	8,469
69	2022-23	43,470	24,236	167,399
70
71
72
73
74
75
76
77
78
79
80
81
82	Academic Year	Footfall	Transaction	eAccess
83	2021-22	16,929	15,048	8,469
84	2022-23	43,470	24,236	167,399
85	2023-24	53,774	31,093	5,474
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100