Excel spreadsheets for downloading

Excel spreadsheet for Codex method criteria

As an alternative to specifying analytical methods in Codex Standards, Codex has adopted method criteria, i.e. Codex has a set of method performance characteristics for which there have been established numeric values. The laboratories can choose which method to use as long as the criteria are fulfilled. The method criteria are calculated based on the ML (maximum level) and the Horwitz' ratio. This Excel spreadsheet calculates the values for you.

Excel spreadsheets related to specific NMKL procedures (free downloading)

NMKL procedure No. 4, 3. Ed., 2009:  Validation of chemical analytical

• Procedure 4 Add 1 (Attachement 1)
• Procedure 4 Add 2 (Attachement 2)
• Procedure 4 Add 3 (Attachement 3)
• Procedure 4 Add 4 (Attachement 4)
• Procedure 4 Add 5 (Attachement 5)
• Procedure 4 Add 6 (Attachement 6)

NMKL procedure No. 5, 2. Ed. 2003: Estimation and expression of measurement uncertainty in chemical analysis

•  (Swedish version) (English version)

 NMKL procedure No. 8, 4. Ed. 2008: Measurement of uncertainty in quantitative microbiological examination of foods

• Procedure 8 Attachment 

NMKL procedure No. 20, 2007: Evaluation of results from qualitative methods

• Procedure 20 Attachment 

NMKL procedure No. 27, 2013: Measurement uncertainty in sensory analysis

• Procedure 27 Attachment