BMW Summry June-21.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	BMW ClientWise Scanned Report DateWise"
2
3	Vehicle	Amritsar 7	Operator Name :	Amritsar Enviro care
4
5	Hospital No.:	61678	Hospital Name :	Smt. Paarvati Devi Hospital
6
7	Contact No.	9815330103	Period	1-06-2021 to 30-06-2021
8
9	Customer ID:	61678	District	Amritsar
10
11	Bed Capacity	75	Contact Person
12
13	Sr. No.	Collection Time	Red Bags	Red Bags Wgt (Kgs)	Yellow bags	Yellow bags Wgt(kgs)	Blue Bags	Blue bags Wgt(kgs)	Cytotoxic	Cytotoxic wht(kgs)	Others Bags	Others Wgt(kgs)	Whites Bags	Whites Wgt(kgs)	Total Bags	Total Wgt(kgs)
14	6/1/2021	10:59:04	16	22.17	3	7.89	1	7.3							20	37.36
15	6/2/2021	11:06:03	11	11.2	10.72										15	21.92
16	6/3/2021	12:50:13	6	14.04	3	11.26									9	25.3
17	6/4/2021	10:17:22	6	14.83	2	8.88									8	23.71
18	6/5/2021	13:58:03	15	27.75	3	10.29									18	38.04
19	6/6/2021
20	6/7/2021	10:23:05	12	13.69	6	28.33	2	18.56							20	60.58
21	6/8/2021	11:14:52	10	12.03	2	6.83									12	18.86
22	6/9/2021	10:31:57	12	16.43	3	10.11									15	26.34
23	6/10/2021	13:25:06	10	11.68	4	10.64	1	5.83							15	28.15
24	6/11/2021	9:55:04	9	14.07	1	8.4									10	22.47
25	6/12/2021	9:58:03	8	14.27	1	3.56	4	41.82							13	59.65
26	6/13/2021	8:52:09	4	8.65	2	4.78									6	13.43
27	6/14/2021	10:09:38	10	8.2	2	3.31									12	11.51
28	6/15/2021	10:40:04	12	13.66	5	12.67	3	23.47							20	49.8
29	6/16/2021	10:46:31	13	26.94	2	5.39									15	32.33
30	6/17/2021	13:34:25	13	19.33	4	15.02	1	5.85							18	40.2
31	6/18/2021	10:08:03	11	14.14	3	19.77	2	13.41							16	47.32
32	6/19/2021	10:07:05	13	30.84	4	14.85									17	45.69
33	6/20/2021	9:39:00	5	11.58	1	7.76	1	12.77							7	32.11
34	6/21/2021	10:16:03	4	4.52	1	3.26									5	7.78
35	6/22/2021	10:32:09	13	27.05	5	25.58	2	18.91							20	71.54
36	6/23/2021	10:24:04	13	23.1	3	7.72	1	15.48					1	0.96	18	47.26
37	6/24/2021	10:10:17	10	13.43	1	3.18	10	13.46							12	30.07
38	6/25/2021	10:37:10	7	12.26	2	6.2									9	18.46
39	6/26/2021	10:00:03	14	30.48	4	16.93									18	47.41
40	6/27/2021	9:39:02	6	9.56	2	14.57									8	24.13
41	6/28/2021	10:59:03	5	8.66	2	4.99	2	17.65							9	31.3
42	6/29/2021	10:25:04	11	16.9	4	10.21	2	21.63							17	48.74
43	6/30/2021	9:57:38	6	7.57	2	5.57									8	13.14
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