Appendix A-3 for analyzing core temperatures forTEMPERATURES a critical limit APPENDIX A-3- Spreadsheet - SPREADSHEET FOR ANALYZING CORE FOR A CRITICAL LIMIT Instructions Date Precooker Shift Enter the temperature data in the FREQ column of the of each test. Batch Then click the button to run to data Species Size Read the results below 1st Measurement DegC 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 Tally Marks 2nd Measurement Freq CumFrq 1 2 3 4 5 6 5 4 3 2 1 / // /// //// ///// ////// ///// //// /// // / 1 3 6 10 15 21 26 30 33 35 36 DegC 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 Tally Marks CumFrq 1 2 3 4 5 6 5 4 3 2 1 / // /// //// ///// ////// ///// //// /// // / Results 1st Test Time 1 3rd Measurement Freq 1 3 6 10 15 21 26 30 33 35 36 Tally Marks 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 Results 2nd Test 12:00 N 12:10 Time 3 0:10 N 36 Freq 12:15 Elapsed Time (Min) 64.0 Mean 66.0 Mean StDev 2.45 StDev 2.45 StDev Lower Limit = Avg - (3*SD) 56.7 Lower Limit = Avg - (3*SD) 58.7 Lower Limit = Avg - (3*SD) Lowest ACTUAL core Temp 59 R - Correl Coef 0.999 RJ_Crit_.10 N= RJ_Crit_.10 N= 36 0.975 RJ_Crit_.05 N= RJ_Crit_.05 N= 36 0.969 Normal? Normal? Minimum Log Lethality Decision WAIT 0.999 R - Correl Coef 36 0.975 RJ_Crit_.10 N= 36 0.969 RJ_Crit_.05 N= Yes, Normal, p>= .100 Normal? Decision Criteria Yes, Normal, p>= .100 56.7 1st Test Lower limit 2nd Test Lower Limit 58.7 2nd Test Lower Limit Decision Manager: Decision Criteria 1st Test Lower limit Minimum Log Lethality 0.6 0:15 N 36 Mean R - Correl Coef CumFrq Results 3rd Test Time 2 Elapsed Time (Min) Operator: DegC RELEASE Minimum Log Lethality 8.4 Decision HACCP: September/October Food Protection Trends 351