Manual for GInaFit_V1_3_2
Contents
1. The thermal death point in relation to typical thermophylic organisms Journal of Infectious Diseases 27 602 617 Cerf O 1977 A review Tailing of survival curves of bacterial spores Journal of Applied Microbiology 42 1 19 Geeraerd A H C H Herremans and J F Van Impe 2000 Structural model requirements to describe microbial inactivation during a mild heat treatment International Journal of Food Microbiology 59 185 209 Mafart P O Couvert S Gaillard and I Leguerinel 2002 On calculating sterility in thermal preservation methods application of the Weibull frequency distribution model International Journal of Food Microbiology 72 107 113 GinaFit Version 1 3 2 5 Acknowledgements Annemie Geeraerd is a Postdoctoral Fellow of the Fund for Scientific Research Flanders Belgium F W O Vlaanderen working at BioTeC Bioprocess Technology and Control Research Group of KULeuven Mieke Janssen Arnout Standaert Vasilis Valdramidis and Karen Vereecken KULeuven BioTeC are gratefully acknowledged for their help in testing earlier versions of this tool as well as Marie Cornu AFSSA France for her help to establish the French version Current research at BioTeC in predictive modelling in foods is supported by the Research Council of the Katholieke Universiteit Leuven as part of projects OT 99 24 the Institute for the Promotion of Innovation by Science and Technology in Flanders as part of pr2. 33 34 35 i 8 00 12 00 Pai 36 37 38 x M 4 gt gt Sheet1_Geeraerd_Shoulder_Tail Sheet1_Log_Linear Sheet1 Sheet2 Sheet3 lt rif Ready NUM E Start C WINDOWS syste H 34 Floppy 4 E My Documents casestudy_manual W Corel PHOTO PAINT SAW 2 33PM Figure 2 Result when modelling the data represented in Figure 1 using the full model as described in Geeraerd et al 2000 The tool can be used in two ways On one hand for end users having already a qualitative idea of the general shape of their survival curves the choice for one of the model types may be obvious On the other hand if the end user does not have a clear idea yet the different types can be tested and compared based on some reported statistical measures Additionally the tool has some built in features testing for mis use for example when trying to identify a model with tailing on data not having a tail References Albert I and P Mafart 2003 A modified Weibull model for bacterial inactivation In J F M Van Impe A H Geeraerd I Legu rinel and P Mafart Eds Predictive Modelling in Foods Conference Proceedings Katholieke Universiteit Leuven BioTeC Belgium pp 143 145 ISBN 90 5682 400 7 Selected for the Special Issue of International Journal of Food Microbiology following the Fourth International Conference on Predictive Modelling in Foods June 15 19 2003 Quimper France Bigelow W D and J R Esty 1920
3. C temp is always possible 2 Start MS Excel with a blank work sheet 3 Select Tools Add Ins at Tools Data Window Help 4c ae Spelling ma SuboClorrect Share Workbook Track Changes Merge workbooks Protection Slo Ree Goal Seek Scenarios Auditing F Solver Macro F zE r Mptions Wizard 4 In the Add In screen tick the Add In GInaFiT_v132 when present in the list or select the GInaFiT_v132 xla file by browsing to the directory selected under item number 1 Add Ins e a Add Ins available Access Links Analysis ToolPak Analysis ToolPak YEA Sutosave Add in Conditional Sum Wizard Euro Currency Tools l Ginafit Browse Look in jo 20030724 x fe GInaFit xla Find Files that match these search criteria inaFik_ 132 Cancel Advanced File name l x Text or property x Find Now Files of type Add Ins xla xli x Last modified any time New Search 1 File s Found 5 Push OK 6 When selecting I agree after reading some messages repeated on page 2 of this manual the menu item GInaFiT will be present in the Worksheet Menu Bar next to the Help Menu 0 ow Help ainaFiT Bigelow and Esty 1920 Log Linear Regression 1i hill IHI Cerf 1977 Biphasic Model Geeraerd et al 2000 Log Linear Shoulder m Geeraerd et al 2000 Log Linear Tail Geeraerd et
4. al 2000 Log Linear Shoulder Tail Mafart et al 2002 Weibull Mafart et al 2002 Weibull Fixed p parameter Albert and Mafart 2003 Weibull Tail Disclaimer amp Support About GInaFiT 7 To remove GlInaFit un tick the item GInaFiT in the list of Add Ins and delete the GInaFiT_v132 xla file from the directory chosen under item number 1 GinaFit Version 1 3 2 3 How to use GInaFiT 1 Select the data to be modelled in the excel sheet The first column should be time the second column should be LoglO N Lt or od SP LER jd Arial 10 11 F to hI m D OO Co iM iH Dr m Ba y D hI hd L a a co ea a A a 6 ew 10 11 12 13 Figure 1 Selection of the data to be modelled 2 Select the model to be applied out of the eight different model structures available as can be seen in the figure below ow Help tlnaFiT Tr Ca Bigelow and Esty 1920 Log Linear Regression non iil IHI Cerf 1977 Biphasic Model Geeraerd et al 2000 Log Linear Shoulder m Geeraerd et al 2000 Log Linear Tail Geeraerd et al 2000 Log Linear Shoulder Tail Mafart etal 2002 Weibull Mafart et al 2002 Weibull Fixed p parameter Albert and Mafart 2003 Weibull Tail Disclaimer amp Support 4 amp bout SInaFit 3 A new sheet is inserted with the same name as the name of the original sheet followed by the name of the model selecte
5. GInaFiT Geeraerd and Van Impe Inactivation model Fitting Tool Developed by Dr Annemie Geeraerd as support of a range of microbial inactivation models published in Bigelow and Esty 1920 Cerf 1977 Geeraerd et al 2000 Mafart et al 2002 and Albert and Mafart 2003 Version 1 3 July 2004 Copyright 2003 2004 Katholieke Universiteit Leuven Belgium GinaFit Version 1 3 2 Disclaimer and Support Disclaimer GInaFiT and this manual come without ANY WARRANTY and are provided AS IS The software GInaFiT is copyrighted by the Katholieke Universiteit Leuven KULeuven Belgium It is not permitted to include GInaFit in any other application The program is for research purposes only and should not be solely relied upon for any reason Acknowledgements If you would like to report results obtained with GInaFiT may we ask to acknowledge Annemie Geeraerd Katholieke Universiteit Leuven Belgium and the original research publications for the model s you selected for your case study as provided in the Excel result sheet s and the user manual Feedback If you would have comments or suggestions regarding the installation use or content of GInaFiT please send these comments and suggestions to annemie geeraerd cit kuleuven ac be or jan vanimpe cit kuleuven ac be Updates Possible future updates will be published on the KULeuven BioTeC homepage which can be found at http www kuleuven ac be cit biotec Requ
6. d e g Sheet would result in Sheet _Geeraerd_Shoulder_Tail The result is demonstrated in Figure 2 GinaFit Version 1 3 2 4 EJ Microsoft Excel casestudy_manual a x i Fie Edit Yiew Insert Format Tools Chart Window Help Acrobat 7 amp X De eee BRAY KB M hy e Arial 12 Pia ee Oe Ae Chart Area f A e gt ETT F G H Measured Predicted 1 Time LOG10 N LOG10 N Squared difference Parameters Paramete Standard Error 2 0 03 S_ Shoulder length 2 15 0 96 Mean Sum of Squared Error 1 2172 3 0 03 k_max 3 69 1 06 Root Mean Sum of Squared Error 1 1033 4 0 28 LOG10 N_res 2 25 0 60 R Square 0 9250 gt 0 09 LOG10 NO 9 67 0 73 R Square adjusted 0 5928 6 0 51 7 sor Inactivation model identified 8 2 35 N NO N_res exp k_max t exp k_max S_N 1 exp k_max S_l 1 exp k_max t J N_res 1 42 For identification purposes reformulated as 0 06 LOGIO N LOG10 10 LOG10 NO 10 LOG10 N_res exp k_max t exp k_max S_N 1 fexp k_max S_l 1 exp k_may 0 00 as can be derived from J i 0 20 A H Geeraerd C H Herremans and J F Van Impe 2000 Structural model requirements 13 Least Sum of Squared Error 8 52 to describe microbial inactivation during a mild heat treatment International Journal of 14 Food Microbiology 59 3 165 209 15 16 17 18 19 20 21 22 8 00 23 24 gZ 25 26 4 27 26 29 30 31 32
7. irements of GInaFit e MS Excel 97 or higher e The MS Excel Add In Solver is installed if not the Solver can be retrieved on your Office installation CD ROM When installed the solver can be retrieved via the menu item Tools Solver at Tools Data Window Help Ac Es Spelling F7 AuboLlorrect Share Workbook Track Changes d lok Merge Workbooks Protection Goal Seek Scenarios Auditing d am t Add Ins Customize Options Wizard The solver xla file is expected to be installed in its standard location which is respectively v C Program Files Microsoft Office Office Library solver for Office 97 or 2000 v C Program Files Microsoft Office Office10 Library solver for Office XP Y C Program Files Microsoft Office Office macrolib solveur for Office 97 or 2000 French version If this is not the case GInaFiT will give a compilation error upon installation If the item Solver is not present in the menu item Tools but the solver xla file is present on the computer the solver has to be added to MS Excel in the same way as described below for GInaFiT GinaFit Version 1 3 2 2 Installation of GInaFiT 1 Itis suggested to place the file GInaFiT_v132 xla in the directory Y C Program Files Microsoft Office Office Addins for Office 97 or 2000 v C Program Files Microsoft Office Office 10 Addins for Office XP Nevertheless placing at any other location like for example
8. oject STWW 980366 the Fund for Scientific Research Flanders FWO Vlaanderen as part of project G 0213 02 the Belgian Program on Interuniversity Poles of Attraction and the Second Multi annual Scientific Support Plan for a Sustainable Development Policy initiated by the Belgian Federal Science Policy Office and the European Commission as part of project QLK1 CT 2001 01415 GinaFit Version 1 3 2 6
Download Pdf Manuals
Related Search