RangeFinder MIC and RangeFinder Disk are MS Excel spreadsheet calculators that are freely available to the public. They have the capacity to provide first estimates of QC ranges for studies that have followed the CLSI M23 standard to establishing ranges. They also have the capacity to identify outlier laboratories.
Details of the statistics behind the spreadsheets can be found in “Turnidge J1, Bordash G. Statistical methods for establishing quality control ranges for antibacterial agents in Clinical and Laboratory Standards Institute susceptibility testing. Antimicrob Agents Chemother. 2007 Jul;51(7):2483-8. Epub 2007 Apr 16.”
Instructions for using these programs are available on the first sheet of each file.
Please note that these spreadsheets are deliberately NOT locked down, so that users may adapt them should they feel the need. However, because of internal formulas, links and hyperlinks, changes to the spreadsheet can result in errors. Any changes should only be performed be experienced Excel users.
PLEASE SAVE A SEPARATE MASTER OF EACH FILE TO A SEPARATE STORAGE FOLDER IN CASE THE WORKING VERSION BECOMES CORRUPTED OR HAS DEVELOPED CRITICAL IRREVERSIBLE DELETION.
If assistance is required, please contact John Turnidge (author) at firstname.lastname@example.org.
If you are looking for ECOFFinder, click here.