2025 LAPORAN HARIAN KEGIATAN.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	X	Y	Z	AA	AB
1		0
2		Januari 2025
3			TANGGAL	REKAM MEDIS							R Tindakan				POLI UMUM				POLI SPESIALIS
4	HARI KERJA	HARI	TANGGAL	TOTAL	UMUM	BPJS	PJL	Mobile JKN	Onsite	Proporsi	TOTAL	UMUM	BPJS	PJL	TOTAL	UMUM	BPJS	PJL	TOTAL	UMUM	BPJS	PJL	PNBP		JML RESEP	RP OBAT	TOTAL PNBP
5	1	KAMIS	2	52	11	40	1	19	21	47,50%	8	5	3		5	5	0		47	6	40	1	2.220.000		9	820.100	3.040.100
6	2	JUMAT	3	55	10	44	1	21	23	47,73%	23	3	20		13	2	11		39	5	33	1	1.685.000		6	286.400	1.971.400
7	3	SENIN	6	61	14	47		19	28	40,43%	25	6	19		16	3	13		44	9	35		2.770.000		6	316.800	3.086.800
8	4	SELASA	7	54	9	44	1	21	23	47,73%	3	0	3		8	1	7		46	8	37	1	1.650.000		12	834.000	2.484.000
9	5	RABU	8	33	8	25		14	11	56,00%	7	1	6		5	1	4		26	5	21		1.115.000		4	312.000	1.427.000
10	6	KAMIS	9	51	10	41		20	21	48,78%	7	2	5		7	2	5		45	8	37		1.425.000		6	720.000	2.145.000
11	7	JUMAT	10	22	8	14		9	5	64,29%	8	6	2		5	2	3		12	3	9		2.620.000		3	152.800	2.772.800
12	8	SENIN	13	48	15	33		18	15	54,55%	11	6	5		7	5	2		40	9	31		2.125.000		8	699.000	2.824.000
13	9	SELASA	14	39	11	26	2	11	15	42,31%	6	2	4		9	2	7		28	7	19	2	1.840.000		4	596.000	2.436.000
14	10	RABU	15	29	7	22		7	15	31,82%	4	2	2		2	0	2		26	7	19		1.230.000		7	1.131.300	2.361.300
15	11	KAMIS	16	49	7	41	1	16	25	39,02%	10	3	7		11	2	9		38	5	32	1	860.000		4	254.600	1.114.600
16	12	JUMAT	17	43	9	32	2	10	22	31,25%	12	6	6		10	2	8		31	5	24	2	1.850.000		2	319.500	2.169.500
17	13	SENIN	20	45	15	28	2	6	22	21,43%	14	5	9		8	2	6		35	11	22	2	2.255.000		15	1.445.800	3.700.800
18	14	SELASA	21	33	3	28	2	2	28	7,14%	3	0	3		3	0	3		28	1	25	2	560.000		1	3.900	563.900
19	15	RABU	22	31	10	21		4	17	19,05%	10	2	8		1	1	0		29	8	21		1.640.000		6	347.100	1.987.100
20	16	KAMIS	23	45	9	36		7	29	19,44%	8	2	6		12	3	9		33	6	27		875.000		6	980.300	1.855.300
21	17	JUMAT	24	43	13	29	1	4	25	13,79%	6	1	5		6	5	1		35	7	28		1.720.000		8	924.500	2.644.500
22		SENIN	27
23		SELASA	28
24		RABU	29
25	18	KAMIS	30	41	19	22		10	12	45,45%	2	1	1		8	5	3		32	14	18		2.545.000		11	741.300	3.286.300
26	19	JUMAT	31	42	14	28		9	19	32,14%	11	5	6		6	3	3		35	8	27		2.000.000		5	538.100	2.538.100
27																											0
28
29			JUMLAH	816	202	601	13	227	376	37,8%	178	58	120	0	142	46	96	0	649	132	505	12	32.985.000		123	11.423.500	44.408.500
30				816	24,75%					37,36%	178				142				649					ave		92.874	7.401.417
31		prediksi akhir bulan		816
32				rata rata pasen harian		42,9
33
34			Target Kunjungan bulan ini			950	950					Capaian sd hari ini		85,89%	%
35			kekurangan target bulan lalu				134
36
37
38			JAN	FEB	MAR	APR	MEI	JUNI	JULI	AGT	SEPT	OKT	NOV	DES	RERATA
39		HARIAN	41,3	41,1	37	46,5	54	43,5	42,39	41,5	45,3	42,2	52,0		44,25
40		PERUBAHAN		-0,50%	-10,00%	25,70%	16,10%	-19,40%	-2,50%	-0,90%	9,16%	-6,9%	23,2%		3,39%
41		kunjungan	909	730	666	745	972	783	975	378	906	970	1039		824,82
42		HK	22	18	18	16	18	18	23	22	22	23	21		20
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