|
 MPN
Calculator
Updated 29-April-2004
|
FOR FOOD, FEED AND WATER MICROBIOLOGISTS
Requires
Windows 95/98/NT/XP
and Visual Basic 6 run time library
|
|
MPN Calculator
(VB6 version)
|
Revision:
Build 24, Preinstallation of VBRun60sp6.exe is required. See below for
download).
Build 24 correct minimize error
Build 23 correct LL/UL display.
Build 22 adds a user modifiable list of MPN types.
Build 21 has an improved main form. Increased the number of
dilutions from 6 to 7.
Build 19 adds copy and paste functions.
Build 18 adds mouse enabled data input and improved
data range before an overflow error is encountered.
Build 17 adds the auto calculate mode.
|
|
VBRun60sp6.exe
|
Microsoft Runtime library required by
all VB6 programs. If you are already running VB6 programs you do not
need this download. If you are unsure, try running MPN Calculator (VB6)
first. If it tells you that you need the runtime library come back,
download and run VBRUN60sp6.exe to install it. About 1031 kb
|
|
http://www.winzip.com
|
Go here to obtain a copy of the Unzip
program.
|
|
MPN Calculator (VB3 version)
|
Build 9, 15-Feb-2000
zip file, about 340 kb
(Visual Basic 3 version)
|
|
mpncalcx.zip (Excel version)
|
MS Excel version of calculator
about 79 kb
|
Standard MPN tables are frequently limited to 3 or 4 defined dilutions
and 3, 5, or 10 replicate samples per dilution. The MPN Calculator
estimates MPN values for up to 6 different dilutions, dilutions can be
none standard amounts, the replicates per dilution can vary.. In
addition, the 3-tube 3-decimal dilution series frequently used in food
microbiology and standard water microbiology dilutions are offered as
preprogrammed selections.
Why use an MPN calculator?
I lost my MPN table.
This program replaces paper tables. Tables are used because MPN values
are extremely difficult to compute with a standard calculator. A
programmed calculator or computer works much better.
I have 4 dilutions and my MPN table is for 3 dilutions,
what do I do?.
This program takes input for any number of dilutions (up to 6). So you
don't have to guess or throw out data.
The MPN pattern I have (e.g 1-0-3) doesn't appear in my
paper table.
This program can compute MPN values for any combination or results,
whether the results are probable or not. Note however that combinations
which are absent from tables are considered rare and therefore
improbable.
Missing a tube or a result?
No problem, enter known information and obtain a valid result.
I analyzed, different quantities than specified in the MPN
table. What correction factor should I use?
With the MPN Calculator, enter the data, the calculator does the rest.
The interface and error trapping are almost complete. If you find it
useful and provide feedback, I will provide updates.
LINKS
MPN
Dilution Basics by John Lindquist
FDA BAM MPN from
Serial Dilutions by Wallace E. Garthwright
Please report bugs or problems with these calculators to me
at mcuriale at gmail dot com
.
Thank you.
|