PERHITUNGAN IKAL PROVINSI.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	S	T	U	V	W	X	Y	Z	AB	AC	AD	AE	AF	AG	AH	AI	AK	AL	AM	AN	AO	AP	AQ	AR	AT	AU	AV	AW	AX	AY	AZ	BA	BC	BD	BE	BF	BG	BH	BI	BJ	BL	BM	BN	BO	BP	BQ	BR	BS	BU	BV	BW	BX	BY	BZ	CA	CB	CD	CE	CF	CG	CH	CI	CJ	CK
1	PROVINSI
2
3	No		1	2	3	4	5	6	7	8	9	10
4	Lokasi		JT1	JT2	JT3	JT4	JT5	JT6	JT7	JT8	JT9	JT10
5	Parameter	Residu Tersuspensi (mg/L)
6		Oksigen Terlarut (DO) (mg/L)
7		Ammonia (N-NH3) (mg/L)
8		Fosfat (PO4-P) (mg/L)
9		Minyak & Lemak (mg/L)
10	Indeks Kualitas Air Laut		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
11	Peringkat		Sangat Kurang	Sangat Kurang	Sangat Kurang	Sangat Kurang	Sangat Kurang	Sangat Kurang	Sangat Kurang	Sangat Kurang	Sangat Kurang	Sangat Kurang
12	Rata-rata		0.00											Sangat Kurang
13
14	1	JT1								2	JT2							3	JT3							4	JT4							5	JT5							6	JT6							7	JT7							8	JT8							9	JT9							10	JT10
15		Water Quality Index Calculator									Water Quality Index Calculator								Water Quality Index Calculator								Water Quality Index Calculator								Water Quality Index Calculator								Water Quality Index Calculator								Water Quality Index Calculator								Water Quality Index Calculator								Water Quality Index Calculator								Water Quality Index Calculator
16		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal			Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal		Parameter	Test Result	Units	Q-value	Weighing Factor	Real Weighing Factor	Subtotal
17		TSS		mg/L	NM	0.22	NM	NM			TSS		mg/L	NM	0.22	NM	NM		TSS		mg/L	NM	0.22	NM	NM		TSS		mg/L	NM	0.22	NM	NM		TSS		mg/L	NM	0.22	NM	NM		TSS		mg/L	NM	0.22	NM	NM		TSS		mg/L	NM	0.22	NM	NM		TSS		mg/L	NM	0.22	NM	NM		TSS		mg/L	NM	0.22	NM	NM		TSS		mg/L	NM	0.22	NM	NM
18		DO		mg/L	NM	0.20	NM	NM			DO		mg/L	NM	0.20	NM	NM		DO		mg/L	NM	0.20	NM	NM		DO		mg/L	NM	0.20	NM	NM		DO		mg/L	NM	0.20	NM	NM		DO		mg/L	NM	0.20	NM	NM		DO		mg/L	NM	0.20	NM	NM		DO		mg/L	NM	0.20	NM	NM		DO		mg/L	NM	0.20	NM	NM		DO		mg/L	NM	0.20	NM	NM
19		NH3-N		mg/L	NM	0.19	NM	NM			NH3-N		mg/L	NM	0.19	NM	NM		NH3-N		mg/L	NM	0.19	NM	NM		NH3-N		mg/L	NM	0.19	NM	NM		NH3-N		mg/L	NM	0.19	NM	NM		NH3-N		mg/L	NM	0.19	NM	NM		NH3-N		mg/L	NM	0.19	NM	NM		NH3-N		mg/L	NM	0.19	NM	NM		NH3-N		mg/L	NM	0.19	NM	NM		NH3-N		mg/L	NM	0.19	NM	NM
20		O-PO4		mg/L	NM	0.18	NM	NM			O-PO4		mg/L	NM	0.18	NM	NM		O-PO4		mg/L	NM	0.18	NM	NM		O-PO4		mg/L	NM	0.18	NM	NM		O-PO4		mg/L	NM	0.18	NM	NM		O-PO4		mg/L	NM	0.18	NM	NM		O-PO4		mg/L	NM	0.18	NM	NM		O-PO4		mg/L	NM	0.18	NM	NM		O-PO4		mg/L	NM	0.18	NM	NM		O-PO4		mg/L	NM	0.18	NM	NM
21		Minyak Lemak		mg/L	NM	0.21	NM	NM			Minyak Lemak		mg/L	NM	0.21	NM	NM		Minyak Lemak		mg/L	NM	0.21	NM	NM		Minyak Lemak		mg/L	NM	0.21	NM	NM		Minyak Lemak		mg/L	NM	0.21	NM	NM		Minyak Lemak		mg/L	NM	0.21	NM	NM		Minyak Lemak		mg/L	NM	0.21	NM	NM		Minyak Lemak		mg/L	NM	0.21	NM	NM		Minyak Lemak		mg/L	NM	0.21	NM	NM		Minyak Lemak		mg/L	NM	0.21	NM	NM
22
23					TOTAL:	1.00	0.00	0.00						TOTAL:	1.00	0.00	0.00					TOTAL:	1.00	0.00	0.00					TOTAL:	1.00	0.00	0.00					TOTAL:	1.00	0.00	0.00					TOTAL:	1.00	0.00	0.00					TOTAL:	1.00	0.00	0.00					TOTAL:	1.00	0.00	0.00					TOTAL:	1.00	0.00	0.00					TOTAL:	1.00	0.00	0.00
24		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00			NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00		NM = Not Measured, tidak ada data analisis untuk parameter terkait				Water Quality Index =		0.00
25						Water Quality Rating =		Sangat Kurang							Water Quality Rating =		Sangat Kurang						Water Quality Rating =		Sangat Kurang						Water Quality Rating =		Sangat Kurang						Water Quality Rating =		Sangat Kurang						Water Quality Rating =		Sangat Kurang						Water Quality Rating =		Sangat Kurang						Water Quality Rating =		Sangat Kurang						Water Quality Rating =		Sangat Kurang						Water Quality Rating =		Sangat Kurang
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