WHO Vaccine January 2014 n rnn nrnnnr ID: 607161
Download Pdf The PPT/PDF document "Transport route profiling qualification..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
WHO Vaccine Transport route profiling qualification Technical supplement to WHO Technical Report Series, No. 961, 2011 Annex 9: Model guidance for the storage and transport of time and temperaturesensitive pharmaceutical products January 2014 \n\r\n\n \n\r\n\n\n\r !"#$%&'$()*"#$%$+,(-." /0\r 1! 2!34 ). \r5 /5 6) )5..5\r /6 \r/\r\r \r \n/\r\r )*"#$%$+'(-." . 1! 2!7\r .8\r\r ). /5\r.8* )8 )\r55 )858\n8\n58) \n55\r.) ) /\r !9\r . *./\r )5.88/).!7.) 5)55. )5.)5 :\r5 \r .88\r \r5..\r\r/8\r)5 ) ..\r!; \r. *5\r\n. )8\r5 \r \r/85 ! /5 /0/8\r)8).5\r /5!\n/ \r. /\r /\r8)80\r\n* \r.\r!7 /8)\r ). \r! \r//)\r. ). !7.\r /) * \r /5! 755."7 )4)5 Acknowledgments 7 ) \r5.=:9\n;* \r?. 58\r../)@\r .5;*..50\nA9 /-,585\n B\n@\r55\n?0?5\n 5\n\r=? \r8; \n57.)! 755."7 )4)5& Contents \n!\n"#$%&!34. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!+!/C5 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!&7\r !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!+!%\n '! 5\r. \r4.!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!%!@\r \r.* "\r-55!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!&\r85!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!$8 \r8!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!,9!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!'\r8 \r!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!& \n\r \r \n\r \n\n ( ) 'Annex 1*+, \n ) \n ,\n( " 755."7 )4)5$ Abbreviations ;9B?;559B?9\r9 /557)7 5D D)5?=7?=57.D).5D)599 5777.\r7.- .55\r5 755."7 )4)5, Glossary , \n% -75\r. 2 5)5. ). \n 5 85!. /%\n)\n0./1-5 / 5)\r558505. 8 . 5/) / \r. \r5 !2 .\n\n3402.341- ./\r5. \r .-\r.\r. /8. )55 !78../.5/ \n\r\r 8 \n\r55 \r 5.8/.8 \r\n \r\r8 \r8\r\n )\n\r 05 \r\r/ !25 \n%-7 )77 5 .: 85 !! )..55.)5: \r /5\n5..55 . 5\r \n \r/8 2\n55)5 \r52!$ \n%-7 )77.55.)5: 85 !! )..)5)5850)58 \r /52!$\n\n6%\n)\n-75 )/\r\r5.\r54. /\r\r\r \r55\r5 5)5 \r)5 \r.\r. \r55\r5 5 !3\n -7 ).)\r !7\n " -8 . 5..-5\r. \r \r5 \n. 5\n ).)-5\r\r5).)5\r)50 \n 5. \n\r85 !7 )\n /%\n)\n07/1-95.\r)54.\r58 8 . \n 55\r\n5).))58\r\r5/8/ \r\r5 .\r\r 5)5 !7\n\n %\n,%-8\r5\r\r). 8\r5\r\r)\r. )\r\r5. \n \r ) \r\r ).\n /C55/8.55 *. \r5\r \r5 )5 5 4\r\n\r5 5.8/ \r 5\n/5 \r55 !\r \n\n5\r.\r5\r5 97553E!&%"\r5)7.\r?\r5\r5 "?D8)7.- ?\r5\r5 7 ;.\n!/\r9)).FDF+!,3%! \r \r !" \n\n# \r \n$%\r\r ! 755."7 )4)5' /%\n)\n-95.\r \r. \r) 5 5)55 . -\r.\r5555!/%\n)\n,-\r\r\r4)5/5\r5\r5\r . \n\r555 5 \n4.\r5555!+,,\n " -5. 5 5.\r505\r" 5\n58505. \r. /.\r.!+\n\n\r, \n7 % 0+\r71- ) 5 )5)\r5\n5 ) ) \r. \r) \r\r\r5\r )))5 !\r\r5 \r5\r 5/))558 \r).5..\r. !+%",-\r5.\r 5\n/C5 \r 5)5 ) ) \r55 \r82\r\r\r5)*5) \r8!8 , \n% 9 -5\r 8.5. 58 85\r\r))).) \r.5 -\r)\r. !8 , \n% 5%-*5 577 * \r. \r 2 5/\r) \rF !7. ) \r .8/ .\r))(8\r.\r/8\r5.)5\n/ \r /8\r!8 \n , \n% ,\n\n %\n,%088+771-8.55\r\r55\n \r \r-\r)\r.5\r \rF-\r)\r.. \n \r\r\r*). 8\r\r!8\n, , \n% ,) -5\r./.\r\r577.8/* \r\r !:\n\n-95.\r ).\r\r85\r5\r \n\r. 5 \n.\r \n\r 8 . 5 8\r5 .-\r.\r5555! 97553E!&%"&\n\r '( \n\n \n)* \r'+,\n \n ' - \n! 755."7 )4)5 1. Introduction 7 55 . /.)85..\r 5 '!+!&\r'!+!$)7553 E!%'\n\n*%" \n\n\r \n \r+\n+ \n!@\r \r.577. ) 55 ) 5 \n)50\r \n\r).48)\r\r5\r*\r /!7/ 8\r \r.\r .855\r*\r / 555.\r). ) 85!7 5 \r . \n\r50 \n 0 \r\r 8 .!7 \r5.\r 5/ .\r)) 5 .\r \r\r*5( / \r55\rG\r5:.\r!54 5 / \r\n/ \r/.5.*!7.).\r).)*5 5/ \r\r ./.) ) 5)5 \n.\r \r\r ) !3) 4 )58 58 ).54)5*5 5 \r)\r5 !7 . \r/\r5C55.755. ")\r \r \r)\r \r+ \n \n \n;6%\n)\n= 5*) )755. \n.\r 5\r 5 \r / 5)4.8 5 ) ) 5*5/ \r!7858 5 !;5 . /)85.\r/)*/ ! +\n 0) 6%, 1-; / /8/8 \r85\r 5\r 5)5.)4.). 55\r5 4. 5)5 @32!7 \n.\r \r 4)5 \r. 5.5@3\r 5\r 5 (\r 4./ / 5)5./5 @3 \r 5\r 08)5))5\r +\n 0)\n\n1-; / /8\r5.\r 5\r / ./\r 5)55 )855\r5 4. 5)5\r \r !7 .\r +\n -; / /8)\r5.\r \r5\r5\r 4. 08). \r\r. 5/ \r!7 .\r , "FF !!F.\r5\r5 F\r5. F +'+&F +'+&!\r) 7 85855. \r 4)5! 755."7 )4)5+ +\n -8) )\r5.\r / \r) 54. \n 5\r 8 . \n\r \r\r). \r\r\r5\r !7 \r .\r 1.1 Requirements 3 5 84.55 \r5. 55 .5 8)8\r \r 5 \r/.5! )5 )\r 55 \n).54)5) 5 \r)\r5 \r// \r ) 25)5\r /. 58/ .! 1.2 Objectives 7/C5)755. \r -/8- .\r8) / ./5\r 50 5\r\r5 2*5 \r /0!\r 5/ "!5. \r 8 .55.. \r / 8 .(/!5).\r55(5!.\r)5 \r ).5)\r5 (\r!.\r)\r. \r /. )4)5) 5 (!\r 5)\r5. \r/ \r8 \r \r 48 5\r85.55/\r. \r\r.\r! 1.3 Target readership 7 \r5. \r/ \r/8 85 /)*\r /.! \r /\r/8 /)\r4)8 /..\r /5\r\r / 8 .! 755."7 )4)5% 2. Guidance 7)\r. ) ) \r8 55.\r558 \r /55!H*.")%I) . .\r/)\r \n .. 558)5 )5!\n48)\r55\r \r/ .0 \r\r\r\r\r))5\n5) /C5!8 0\n./. \r/ .\r58,-&. !5 5\r)458. ))\r8 !\n5 5\r .8\r.\r/8 .\r.*.../)\r ;9B? 5/)5!7 . \r5)) ./855 5 5!7 5\r "7)\r))5 \r(?\r ) . * ! \r\r 52(.\r8 (?\r) \r\n\rF52()()\r ( \r .. \r5\r 2(. . !!\n. . 275 . \r)555\r558)55\r!\n.\r5/55\r\n/\n/5 .555).\r 5\r8! . )& 5 )8 5 \r\r/ 58\r! 5 . 8 55\r\r5 5 . . ) 5)5 .)C\r.!3.. )))\r8/855 \r !-0.1;èá 48\n5 /).8)\r\n\r5. \r5!7 . \r)8 0 \n5 5 \r\r\r.8/\r)\r). \r8\r5.8 / 48))5).5) ! 2.1 Associated materials and equipment 7). \r4.\r\r55.\r\r\r) ";559B? ;9B?25/)\r\r5\r\r.\r) / 48 !7 .;9B?.\r). 5 .)5 \r/ \r\r555 ! 7585\r )5 ! 755."7 )4)5 \r5 \r/\r58-..\r\n . 5)5 )\r55)458\n. \r5\r\r!7 8 .)8\r\r 58 !J\r /* 2!7 /* \r5;9B? !) ) \r8 .\r .5.\n\r/* . 8..5 ).)\r /\r4\r\r* 555 !J\r/* \r/55) ./.!75 8\r\n )\n\r 05 \r\r/ *5\r).\r5!;*5 \r 85 )5/)\r8 . ).\r! 2.2 Understanding temperature exposure: the degree-hour concept 5\n\r\r5\r77\r5\n * \r./. \r/\r.)\r5 858#L#+L2\n ).4/.\r5")./. # .*../\r.)\r5\n55 8/\n \r!)./. # .../\r.)\r5\n55 8\r/ \r!5) \r /5\r\n77\r5 0)\r.! 5 8584)\r/8/8 / ).55 \r./. !\n\r\r \n./.\r .5 ! \r/\n5)5\r8\r\r.)\r8\n.)8\n5 \n. 55 5 ) 2\r. \r\r\r))\r!7 )5 5/5\r ;9B? (.* \r)) \n\r)) 5 ) \n5/55\r\r5.\r \n+ 55!75 )\r!./. .\r\r)) \r5. !;5\r 8 \r / *)* //\r. \r55\r))." \n" 75/5 \r)505.0 )5\r))5 \r\r\r 5 )58))5 * .! .5\r 5 8*5 ... \r5!7 \r/5 \r\r\r55\r).\r! 755."7 )4)5 M7.* \r- !M7.5\r ! \nM7.\r))5L/./\r.\r./!C8\n ). \r-* )5!7 5/5.\r.*..\r-* )55 4)\r!7 5\r\r)G\r5:.\r\r 5/\r5!'! 2.3 Study protocol 5. \r85!7 \r/\r\r/) \r8/ !75 \r5 5\n \r\r) \r85\r \r \r5\r)"!0\n\r* 12 \r\n*"7 .5\r8))"5)./.)(55)..\r8\r(\r)5)0 \n 0 \r / 8 .(4)5) .\r!/!,\r \n*"9)\r\r ) . / \r5\r /\r !\r8\n\r 5\r/5 \r !8\n 5 58 .5 5//5\r;9B?: !H*.\n))5\r ././555\r !5!' \n12.4;Ñ°8\r).\r 2) .\r 5/ \r) \r8!H*." .\r8\r\r8(\r8\r\r8()\r50-\r\r-))\n5)\n5!\r!%\r-%3 7 . / .5 . \r8\r\r4)./\r\r8 \r!75 \r\r ))5 5*5\r.)5 \n5 8\r!!%\n*\n !!\n ..\n\r /8!7 55\r *..5\r 5\r2!\r8\n\r \r/55\r8\r ,0 \r82\n/ .8/ /.85 !)!%475..\r , . \r)5/!!!\n 5\r2\n.\r) \r)\r5\n\r\n \r)\r/!8 * . 5 .) 50 \r5\r\r\r \r5 \r!7 855 /I) . !!( \n* \n9.) \r8 . .\r . !3 . 5 . )\r5 !.\r . 50 5\r5 !7 /5- \r\r\r\r5 ! 755."7 )4)5 ! \n*9 /)58 \r8\r)8 \r ! 2.4 Carrying out the study .58 \r8 8 .5\n-\r.!)5 ).\r\r5\n;9B? /55\r\r \r\r85/ !/ ) "!'" \r85 . /\r\r5!78. \r \r \r8 5\n/C5 \r5\r \n5\r 5 \r ) !7 . /\r\r0;9B?: !/!\n "\r55./.* \n5;9B? \r) \n-\r/*..\r8*\r5!950\r5 )!5!% # "7 \r8.. / \r \r\r)8/)\r5\r55 !\r!%# \n\r\r\r\r / 5\r5\r\r /) \r8/ ! / \r5)5 .\r\r\r8 ;9B? \r\r\r\r!!3 \r -0.1;èá5\r08).5 .\r)5;9B? \r \r8! 0 ./)5485 .\r\r / 08 ).!7 5\r "50./( .\r\r.( 5(\r \n5!)!% 7\r555 / \r8: )!7;9B? \r/..\r 5\r \r5 .\r).5\r. ) .!7 \r55\r .)50. ).4\r50 .! 2.5 Data retrieval 7;9B? . /55\r\r\r\r /!/ ) "!% \n7 / 55 . ;9B?). .!7\r5. /5 \r 5\r/8 \r8.\r\r\r \r5!7. )\r56)*.-\r\r\r\r \r- \r55.8;9B?/\rC8!/!%# ?)5)/)\r \r \r8! ;9B?: )\r! 755."7 )4)5& 5!% \n*9/\r\r8 \r\r.. 5 ) \r \r8\n5\r"?. (\r\r\r (?... (?*... (\r!,\n* 7 /8* .\r/5\r\r)8 \r.\n\r5) !558 \r/\r)\r) 5 !;9B?.)5(;9B?\r8 \rF \r(). /)\r(B );9B?! 2.6 Organizing and analysing the data 75 ).).\r) 58 ) 8 .55\r8 55\r\r\r\r \r) . 5 !H5 .\n5;*5/5\r855\r6 7/!+ ,-\r/8\r\r !+ ,-H55\n5\r/;*5 \r 5)5. "; \r. / \r5 ;9B?\r54 !7.5\r\r)5 .5) \r. !+ ,-5\r-)55. ;*5)."\r ! 755."7 )4)5$ 8\n *25\n, )\n25 % ,) \n\n\n + ,-75. \r5.* )) . \r- \r * /5.\r) 8!7/*.\n.9 5\r * \r.\n !5$ /5.\r\n8 5\r5/ \r! \n .5-)-./5\n) ).5) \r 5 \r80!H*.\n 5.8/ \r)-4)\r5\r/* \r555 5\r-)\n5-)\r.-)5 ././ \r\r/ \r! \n 55\r)\r5 58/ )( 5/ \r / ) \r50 \r/85\r \n.5\r 5./! 2.6.1 Method A for passive containers with known performance characteristics: ?\r )\r / -5 )*5\r /8- \r).5) \r 5\n 55\r\r- !7 - \r5 6.5. ./. 5 8/.*.. )*.5\r/* \r555 ), "FF !!F..N \r\r F55N48F4 N5F58 ! * EDLM interval0.25hrs Elapsed time (hours)Shipment AShipment BShipment CShipment DShipment E0.0026.722.022.023.918.80.2529.124.522.325.219.00.5026.827.022.726.219.30.7521.630.022.927.120.51.0020.931.524.327.720.81.2521.133.026.128.420.91.5021.234.525.728.421.51.7518.934.725.523.122.02.0015.933.025.618.722.3............46.0024.09.63.923.515.846.2524.010.54.623.019.146.5023.610.73.423.620.046.7523.110.99.123.821.447.0023.325.711.824.021.247.2523.425.914.424.121.047.5023.326.019.424.420.847.7523.526.221.124.220.648.0023.626.119.023.920.4Degree hrs91295792510401042 Temperature (°C) 755."7 )4)5, /\r .)77\r5\r5. ./. 5 8//\r... .)77!7 .*\r.5 )5 .\r /!\n\n \n -7.\r\r 5/\r/ \r/8\r\r ) \r/5 \r-* 55 / \r./ .)\r5 .*..!,\rC \r-* ) 055)./\r5.!5 )77/\r) \r #L-0.1;èç#+L-0.1;èç\n #,L-0.1;èç!H.7/\r\n0* . $+ !-0.1;èç 48\r\n\n\r /#,L-0.1;èç).5)5. !7 \r/8.8$+*,\r\r\r5 $\r- * 7/!8\n *8\n 9% 5,% \n ?#@,5550) \r 5 5558. 5 * )+\r- !H*.\n555 \r5 ./.)#$&L-0.1;èç\n5\r))& \r 5\r $&-,2O&M\n$\r- )5\r)! *.\n 5 . )\r- )! )08/ ) 5 \r5) 5)5!\n \n -5 .5 )*5 550) 55\r ))55 \r\r5).)\r ./. 5\r5. ! 5 * ) \r- !7/& *.! .5.5 \n.\r\r 5/\r ) \r!,\rC \r-* ) 055)./\r5.!H *.\n #,L-0.1;èá!H.7/\r\n0* . $+ !-0.1;èá 48\r\n\n\r L-0.1;èá#,L-0.1;èá5)5. !7 \r/8.8$+*,\r\r\r $\r- * 7/!8\n *8\n 9% 5,% ?#@,5550) \r 5 .-) 5 * )-'%\r- !H*.\n5\r/* \r5 ./.)-L-0.1;èá\n.)) Degree hrs91295792510401042Minus 48 x 5-240-240-240-240-240Net degree hrs672717685800802 Elapsed time (hours)Shipment AShipment BShipment CShipment DShipment EDegree hrs-410.0-396.0-450.0-436.0-375.0Minus 48 x 5-240-240-240-240-240Net degree hrs-650-636-690-676-615 Temperature (°C) 755."7 )4)5' \r 5\r - #,2OM-,,\r- ).)! *.\n 5 . .\r- )!7 \r5 ) /)!45 , \n% \n -7 .5.*./.\rC88) /\r .)\r5\n\r\r. \n )..\r5\r\r!@\r 5\r \n./..8)5\n/\r//\r .)\r55 )C8!7 ..\r\r 5/\r/5/ \r\r 55. 5 ! 2.6.2 Method B for designing and testing packaging solutions 7)\r\r\r-55 5 / \r\r )( 5/\r / )5\r5 .\r )50 \r/85\r .5\r 5./!7.\r) .\r 5/ 55 )\n \r).7/ *.!55\r \r\r6 8\r\n . )& 5 )8 5 \r\r/ 58\r!H 7/\r !7 . \r. 88 \r5/8. \r!A% 925\n, )\n , \n% ,) \n,)) , )05 8) .) \n5 )" 755."7 )4)5 . \rP8G.:\n . .* \r .\r-\r %\r%,2!. 8G. .:!\r \r \r$.0/ )/);9B? 5\r))$+ !5 \r) \r * /5 \r \r./.!)58\r 5\r \r-* %,2!.9\r8.* ) , ( * \r8. ). \r ! ..8/. * \r 8 5\r 5 \n$\r 2!.; 58G 5 :\n$\r !; . 9\r;08\r))\n8 8 ..)\r5! 5/\r5!\r5\r5/8 / \r\r55\r). )) \n 5 88 \r\r \r .)\r).5\r48 *5\r.* )) . !7 )5/ \r5 5./.!7.\r\r 5/\r. )/C5 "7\r\r)\r /).)G :!7 5./. ./ !7 ) ..585.))!H*.\n) * 55 \r)C8\n 5. !7))550) 5 .\r*)* 5/5\r558 .8/85 . 5./5 .!H55 \n./.5 \r/ 5./ /5 !55 \r/). \r\n\r\r)/ .\r!7\r \r ../)\r- \nG\r5:\n 5 .\r ! \r/ /\rC \r\r)\r )8.6)*.#I! 5\r 5/ .;*5 \r 5) 5 !0 /);9B?\r\r5 .)\r ) / !H *.\n/ \r\r 7/$\r- \r5!7 4 . * \r . .;2!H& .*5 5\r #I )8.\n\r5),\r- ! 755."7 )4)5+ A% *+%, , ,\n,. 9%B\n A% *+%, , ,\n,. 9%B\n ?C .).*. \n8\n )) * .E9 5 \r-5\r\n \r\r48)58! 755."7 )4)5% References 97553E!&% \r2!&\n\r '+( \n\n \n)* \r'+,\n \n' ' - 9 5\n!)7 5 72 ,P\n;\r?\n%\n)\r \r0\n,( ), "FF !!F..N \r\r F55N48F4 N5F5 8 ! * 755."7 )4)5 Annex 1 Spreadsheet for generating step charts 7 \r \r/ ;*5!5/\r\r)\r )8 ! ;*5: G0:)5)\r 5.5 \r5) 5 .\r !7 \r \r 5\r5 .*!7 5/\r ;*5: 5)! STEP 1: Extend rows as needed. In cell B9 enter EDLM recording interval in hours. STEP 2: Extend data entry columns as needed. Enter temperature data in columns B to n. STEP 3: Highlight cell H8. Select: Data|What-If Analysis|Goal Seek.STEP 4: Set 'To value' cell = 1.0 for 100% of maximum shipment degree-hours, 110% for maximum shipment degree-hours + 10% etc.STEP 5: Set 'By changing value' cell = cell E8. The click OK.STEP 6: Use data in Columns A and K to generate a step profile graph. EDLM interval: 0.25hrs2 sigma min:0.26Target heat under curve factor:1.00 Elapsed time 2 sigma min2 sigma max (hours)Shipment AShipment BShipment CShipment DShipment E0.0026.722.019.623.918.8240.2529.124.519.825.219.0240.5026.827.019.626.219.3240.7521.630.019.427.120.519.6229.59241.0020.931.519.127.720.8241.2521.133.019.328.420.9241.5021.234.519.528.421.5241.7518.934.719.723.122.020.8034.61242.0015.933.019.718.722.3242.2513.930.019.315.422.7242.5013.126.418.313.722.9242.7511.624.017.413.124.315.4531.69243.0010.622.016.712.026.1243.259.919.516.011.025.7243.509.117.414.910.225.5243.758.915.514.39.725.610.5625.9323.5324 Temperature (°C)Mean between min and max 755."7 )4)5 *.\nG\r5)5: / !!7 0)5 )\r 5 +,\r- ) !7 *584 5 . .P2\n5 * \r+,\r- !7* ). \r\r/. 5 ) \r !8/\r8).;*55 .! 42.5023.624.319.019.920.12242.7523.024.319.218.620.219.7024.732243.0023.224.219.418.820.42243.2523.424.219.319.020.62243.5023.324.119.020.320.52243.7523.324.019.021.020.219.4224.2022.362244.0023.423.919.020.920.22344.2523.323.819.020.820.22344.5023.323.819.020.720.22344.7523.223.719.021.020.220.2023.902345.0023.123.619.020.920.22345.2523.023.420.820.820.22345.5023.024.020.620.722.02345.7523.024.420.720.221.820.7024.232346.0022.825.020.519.921.92346.2522.925.220.518.621.72346.5023.025.320.218.821.72346.7523.125.520.019.021.420.2125.412347.0023.325.719.820.321.22347.2523.425.919.621.021.02347.5023.326.019.420.920.82347.7523.526.219.221.020.620.6026.1122.672348.0023.626.119.020.920.423Degree hrs671850721735809850 755."7 )4)5 EDLM interval:0.25hrs2 sigma min:=J205/MAX(B205:F205) Elapsed time 2 sigma min2 sigma max (hours)Shipment AShipment BShipment CShipment DShipment E=J$27=A12+$B$8=J$27=A13+$B$8=J$27=A14+$B$8=PERCENTILE.INC(B12:F15,$E$8)=PERCENTILE.INC(B12:F15,0.977)=J$27=A15+$B$8=J$27=A16+$B$8=J$27=A17+$B$8=J$27=A18+$B$8=PERCENTILE.INC(B16:F19,$E$8)=PERCENTILE.INC(B16:F19,0.977)=J$27=A19+$B$8=J$27=A20+$B$8=J$27=A21+$B$8=J$27=A22+$B$8=PERCENTILE.INC(B20:F23,$E$8)=PERCENTILE.INC(B20:F23,0.977)=J$27=A23+$B$8=J$27=A24+$B$8=J$27=A25+$B$8=J$27=A26+$B$8=PERCENTILE.INC(B24:F27,$E$8)=PERCENTILE.INC(B24:F27,0.977)=AVERAGE(G15:H27)=I27=A27+$B$8=J$43 Temperature (°C)Mean between min and max STEP 1: Extend rows as needed. In cell B9 enter EDLM recording interval in hours. STEP 2: Extend data entry columns as needed. Enter temperature data in columns B to n. STEP 3: Highlight cell H8. Select: Data|What-If Analysis|Goal Seek.STEP 4: Set 'To value' cell = 1.0 for 100% of maximum shipment degree-hours, 110% for maximum shipment degree-hours + 10% etc.STEP 5: Set 'By changing value' cell = cell E8. The click OK.STEP 6: Use data in Columns A and K to generate a step profile graph.Target heat under curve factor: =A185+$B$8=J$187=A186+$B$8=PERCENTILE.INC(B184:F187,$E$8)=PERCENTILE.INC(B184:F187,0.977)=AVERAGE(G175:H187)=I187=A187+$B$8=J$203=A188+$B$8=J$203=A189+$B$8=J$203=A190+$B$8=PERCENTILE.INC(B188:F191,$E$8)=PERCENTILE.INC(B188:F191,0.977)=J$203=A191+$B$8=J$203=A192+$B$8=J$203=A193+$B$8=J$203=A194+$B$8=PERCENTILE.INC(B192:F195,$E$8)=PERCENTILE.INC(B192:F195,0.977)=J$203=A195+$B$8=J$203=A196+$B$8=J$203=A197+$B$8=J$203=A198+$B$8=PERCENTILE.INC(B196:F199,$E$8)=PERCENTILE.INC(B196:F199,0.977)=J$203=A199+$B$8=J$203=A200+$B$8=J$203=A201+$B$8=J$203=A202+$B$8=PERCENTILE.INC(B200:F203,$E$8)=PERCENTILE.INC(B200:F203,0.977)=AVERAGE(G191:H203)=I203=A203+$B$8=J203Degree hrs=SUM(B12:B204)*$B$8=SUM(C12:C204)*$B$8=SUM(D12:D204)*$B$8=SUM(E12:E204)*$B$8=SUM(F12:F204)*$B$8=SUM(J12:J204)/$B$8 755."7 )4)5& 7555 / \rG\rC \r:.!7G ..*:5. / %!5)5/50)\r!7 . \r). 5!7G ..:5.\r .)\r). 5!7\r))5 5) Q;Q+2 55\r\r 05 !7 ./ \r\r- 5*584* ) 5 .\n.\r/8G7\r5)5:5 /8 !H8\n:./.\r.*:5. 55/ ..\r ..*) ))/50\r\r / .5 \r5.! 755."7 )4)5$ Revision history 9 ..8 3 )5 \r