MPN returns the MPN value for the three counts given for the 5 tube Fecal Coliform MPN Procedure (Standard Methods 9221 C) . Count1 is the 10mL reading, Count2 is the 1mL reading, and Count3 is the 0.1mL reading. If different sample volumes are used, the MPN value should be adjusted by multipling the result.
Syntax:
MPN(10mL Count, 1mL count, 0.1mL count)
Example:
MPN(3,0,1) - returns 11
MPN(C4,D4,E4) - returns 6.1 where cells C4,D4, and E4 equal 1.
NOTE:
Table 9221.IV. MPN Index for Various Combinations of Positive Results When Five Tubes Are Used per Dilution (10 mL, 1.0 mL, 0.1 mL). Readings not in Standard Methods (such as 434) were taken from Metcalf and Eddy Wastewater Engineering, 3rd Edition Table F-1.
READING MPNVALUE
000 1
001 1.8
002 3.6
003 5.4
004 7.2
005 9
010 1.8
011 3.6
012 5.5
013 7.3
014 9.1
015 11
020 3.7
021 5.5
022 7.4
023 9.2
024 11
025 13
030 5.6
031 7.4
032 9.3
033 11
034 13
035 15
040 7.5
041 9.4
042 11
043 13
044 15
045 17
050 9.4
051 11
052 13
053 15
054 17
055 19
100 2
101 4
102 6
103 8
104 10
105 12
110 4
111 6.1
112 8.1
113 10
114 12
115 14
120 6.1
121 8.2
122 10
123 12
124 15
125 17
130 8.3
131 10
132 13
133 15
134 17
135 19
140 11
141 13
142 15
143 17
144 19
145 22
150 13
151 15
152 17
153 19
154 22
155 24
200 4.5
201 6.8
202 9.1
203 12
204 14
205 16
210 6.8
211 9.2
212 12
213 14
214 17
215 19
220 9.3
221 12
222 14
223 17
224 19
225 22
230 12
231 14
232 17
233 20
234 22
235 25
240 15
241 17
242 20
243 23
244 25
245 28
250 17
251 20
252 23
253 26
254 29
255 32
300 7.8
301 11
302 13
303 16
304 20
305 23
310 11
311 14
312 17
313 20
314 23
315 27
320 14
321 17
322 20
323 24
324 27
325 31
330 17
331 21
332 24
333 28
334 31
335 35
340 21
341 24
342 28
343 32
344 36
345 40
350 25
351 29
352 32
353 37
354 41
355 45
400 13
401 17
402 21
403 25
404 30
405 36
410 17
411 21
412 26
413 31
414 36
415 42
420 22
421 26
422 32
423 38
424 44
425 50
430 27
431 33
432 39
433 45
434 52
435 59
440 34
441 40
442 47
443 54
444 62
445 69
450 41
451 48
452 56
453 64
454 72
455 81
500 23
501 31
502 43
503 58
504 76
505 95
510 33
511 46
512 64
513 84
514 110
515 130
520 49
521 70
522 95
523 120
524 150
525 180
530 79
531 110
532 140
533 180
534 210
535 250
540 130
541 170
542 220
543 280
544 350
545 430
550 240
551 350
552 540
553 920
554 1600