GInaFiT Geeraerd and Van Impe Inactivation
Contents
1. This requirement can be verified by looking under the Excel worksheet tab Data Solver should be visible in the right corner as indicated in the next figure GInaFiT Version 1 6 2 E Cu wj Bn ie What If Group Ungroup Subtotal J Y Outline If the Solver is not appearing under the worksheet tab Data it needs to be installed This is to be performed by following this procedure e Click the File tab E Home Insert Page Layout Formulas Data Review pis pis E th lg Bi Connections Al is EXT Properties From From From From Other Existing Refresh Access Web Text Sources Connections Ally Edit Links Get External Data Connections Al E f gt N N gt e The Microsoft Office Backstage view opens Home Insert Page Layout Formulas Data Review Vit lg Save GAY Save As Recent Workbooks j Open af Close Info New Print Save amp Send Help dome EJ Exit e Click Options e The Options dialog box appears Select Add Ins GInaFiT Version 1 6 General View and manage Microsoft Office Add ins Formulas Proofing Add ins Save Name Location Type Active Application Add ins Ginafit C Users LeticiaH Documents GinaFiT xla Excel Add in Advanced Oplosser invoegtoepassing C Officel4 Library SOLVER SOLVER XLAM Excel Add in language Customize Ribbon Inactive Application Add ins2. GInaFiT Version 1 6 21 Coroller L I Leguerinel E Mettler N Savy and P Mafart 2006 General model based on two mixed Weibull distributions of bacterial resistance for describing various shapes of inactivation curves Applied and Environmental Microbiology 72 6493 6502 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 Geeraerd A H V P Valdramidis and J F Van Impe 2005 GInaFiT a freeware tool to assess non log linear microbial survivor curves nternational Journal of Food Microbiology 102 95 105 Geeraerd A H and J F Van Impe 2007 GinaFiT Revealing the time dependence of microbial survival under food processing food preservation or environmental stress conditions In Nychas G J E Taoukis P Koutsoumanis K Van Impe J and Geeraerd A Eds 5th International Conference Predictive Modelling in Foods Conference Proceedings 163 164 Agricultural University of Athens Athens ISBN 978 960 89313 7 4 5th International Conference Predictive Modelling in Foods Athens Greece 16 19 September 2007 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 Acknowledgem
3. gt E Send gt 1 Publish gt Close E zu 21 e Select Add Ins Excel Options x LU zB Change the most popular options in Excel Formulas Proofing Top options for working with Excel Save v Show Mini Toolbar on selection V Enable Live Preview Show Developer tab in the Ribbon Customize V Always use ClearType Color scheme Bue v Trust Center ScreenTip style Show feature descriptions in ScreenTips 1 Create lists for use in sorts and fill sequences Edit Custom Lists When creating new workbooks Advanced I Resources Use this font Body Font E Font size nE Default view for new sheets Normal View Include this many sheets 3 Personalize your copy of Microsoft Office Username AnnemieG Choose the languages you want to use with Microsoft Office Language Settings e At the bottom of the Add Ins screen select Excel Add Ins under the drop down list next to manage It is likely but not guaranteed that Excel Add Ins is already appearing here Then proceed by hitting the button Go GInaFiT Version 1 6 15 Excel Options Popular Formulas Proofing Save Advanced Customize Trust Center Resources a View and manage Microsoft Office add ins Add ins Name Location Analysis ToolPak Analysis ToolPak VBA Custom XML Data Euro Currengy Tools
4. Financial Symbol Smart tag lists Headers and Footers Hidden Rows and Columns Hidden Worksheets Internet Assistant VBA Invisible Content Person Name Outlook e mail recipients Wizard Opzoeken Wizard Voorwaardelijke som Add in Analysis ToolPak Publisher Microsoft Corporation Location C Program Files Microsoft Office Office Description Bevat hulpprogramma s voor het analyseren van statistische en technische gegevens ice Office1 2 Library Analysis ANALYS32 XLL Office12 Library Analysis ATPVBAEN XLAM es Microsoft Office Office1 2 OFFRHD DLL Office Office 2 Library EUROTOOL XLAM es Microsoft Shared Smart Tag MOFL DLL les Microsoft Office Officel 2 OFFRHD DLL jiles Microsoft Office Officel2 OFFRHD DLL jes Microsoft Office Officel 2 OFFRHD DLL rosoft Office Officel2 Library HTML XLAM jes Microsoft Office Officel 2 OFFRHD DLL s Microsoft Shared Smart Tag FNAME DLL Soft Office Officel 2 Library LOOKUP XLAM rosoft Office Officel 2 Library SUMIF XLAM 12 Library Analysis ANALYS32 XLL Excel Add in Excel Add in Document Inspector Excel Add in Smart Tag Document Inspector Document Inspector Document Inspector Excel Add in Document Inspector Smart Tag Excel Add in Excel Add in Manage Excel Add ins In the Add In screen tick the Add In GInaFiT when present in the list or select the GInaFIT xla file by browsing to the directory selected at the start of this installation procedure Add In
5. Solver Add in has to be ticked in the list i e the v should be visible before the Solver Add In Alternatively it may be the case that the Solver name is indicated with Its equivalent name in the language of your Windows version If this is the case select the Solver with this other name SC 008 Add Ins available X Analysis ToolPak Analysis ToolPak VBA Conditional Sum Wizard Euro Currency Tools Internet Assistant VBA Lookup Wizard vi Solver Add in Cancel Browse Automation Ier olver Add in Tool For optimization and equation solving e Press OK Al xl Add Ins available Analysis ToolPak Analysis ToolPak VBA Conditional Sum Wizard Euro Currency Tools Internet Assistant VBA Lookup Wizard Solver Add in Browse Automation zu olver Add in Tool For optimization and equation solving GInaFiT Version 1 6 5 e The Solver should now be visible in the right corner under the Excel menu tab Data as indicated in the next figure EP aE 2 2 2 Show Detit 24 Solver E Jon 2 Hide Detall What If Group Ungroup Subtotal Analysis Outline Analysis Installation of GInaFiT xla It is suggested to place the file GInaFiT xla in the directory c Program Files Microsoft Office Office14 ADDINS or in a similar directory for an Office version in a language different from English Nevertheless
6. compared The time for a 4 decimal reduction can be useful to summarize the information present in a data set for example if a common survivor curve shape can not be selected for a range of different conditions tested 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 or when using a too limited number of data points observations in comparison with the number of parameters in the model type chosen the number of parameters ranges from 2 to 5 for the ten model types available Further illustration on the use of GlInaFiT can be found in Geeraerd et al 2005 If the use or interpretation of GlnaFiT results would raise questions please contact us at annemie geeraerd biw kuleuven be References Albert I and P Mafart 2005 A modified Weibull model for bacterial inactivation International Journal of Food Microbiology 100 197 211 Bigelow W D and J R Esty 1920 The thermal death point in relation to typical thermophylic organisms Journal of Infectious Diseases 27 602 Buchanan R L Golden M H and Whiting R C 1993 Differentiation of the effects of pH and lactic or acetic acid concentration on the kinetics of Listeria monocytogenes inactivation Journal of Food Protection 56 474 478 484 Cerf O 1977 A review Tailing of survival curves of bacterial spores Journal of Applied Microbiology 42 1 19
7. placing at any other location like for example C temp is always possible Start MS Excel with a blank work sheet e Click the File tab Mr Ce Home Insert Page Layout Formulas Data Review E sx x FED A F Bs Connections A iy Lig Rl Af Propertie z From From From From Other Existing Refresh z Access Web Text Sources Connections Ally Edit Link Get External Data Connections Al CES B C D E E 2 3 4 e The Microsoft Office Backstage view opens GInaFiT Version 1 6 6 o Home Insert Page Layout Formulas Data lg Save li Save As Ey Open G Close Recent Workbooks Info New Print Save amp Send Help EJ Exit e Click Options e The Options dialog box appears Select Add Ins Excel Options General ed View and manage Microsoft Office Add ins Formulas Proofing Add ins Save Name Location Type Ee tangue Active Application Add ins Ginafit C Users LeticiaH Documents GinaFiT xa Excel Add in Advanced Oplosser invoegtoepassing C e Office14 Libray SOLVER SOLVER XLAM Excel Add in Inactive Application Add ins Analysis ToolPak C e Officel 4 Library Analysis ANALYS32 XLL_ Excel Add in alysis ToolPak VBA C fficel4 Library Analysis ATPVBAEN XLAM Excel Add in jachment C Users LeticiaH Documents attachment ashx Excel Add in stom XML Data C Microsoft Office Officel4 OFFRHD DLL Document Inspector e KMU
8. the directory selected at the start of this installation procedure r 31 Browse pu JOLLEXCLICERI NN Organize New folder 6s Search Downicods P HOUS eme gt E Microsoft Excel Euro Currency Tools V Ginafit 4t Favorites rn aooe 4 amp Downloads Automation 3 Dropbox T Recent Places GinaFiT MI NE Analysis ToolPak VBA Cancel Browse 4 dj Libraries 3 Documents b d Music E Pictures B Videos Solver Add in Tool for optimization and equation solving f Computer t ii Network z e Press OK and please read carefully the two screens appearing e From this moment on the button GInaFiT will be present in the Worksheet tab Add Ins last tab Insert Page Layout Formulas Cut Calibri u Aasa E Wrap Text eem Ea Copy 7 aste Y GP Format Painter 2 EH Merge amp Cente Clipboard Alignment GInaFiT Version 1 6 8 Home NEM Bigelow and Esty 1920 Log Linear Regression Insert Page Layout Formulas Data Review View Add Ins Geeraerd et al 2000 Log Linear Shoulder Geeraerd et al 2000 Log Linear Tail Geeraerd et al 2000 Log Linear Shoulder Tail Mafart et al 2002 Weibull Mafart et al 2002 Weibull Fixed p parameter Albe
9. 37 6 5 00 9 16 9 44 0 08 4D reduction is reached at 21 84 units of time 7 7 00 9 28 9 35 0 01 Inactivation model identified 8 9 00 9 24 9 11 0 02 N NO exp kmax t exp kmax SI 1 exp kmax SI 1 exp kmax t 9 12 00 8 30 8 39 0 01 For identification purposes reformulated as 10 1400 7 92 7 80 0 02 Log10 N Log10 NO kmax t Ln 10 Log10 Exp kmax SI 1 Exp kmax SI 1 Exp kmax t 11 16 00 718 7 19 0 00 as can be derived from E 10 50 pe iE AH Geeraerd C H Herremans and J F Van Impe 2000 Structural model requirements 13 24 00 4 91 472 0 04 to describe microbial inactivation during a mild heat treatment Intemational Journal of 14 26 00 427 4 10 0 03 Food Microbiology 59 3 185 209 15 2800 3 28 3 48 0 04 16 Least Sum of Squared Error 0 33 17 P 1200 19 20 21 2 23 24 z 25 3 26 3 27 28 E 200 30 31 32 0 00 a 0 00 500 10 00 1500 2000 25 00 30 00 2 Time 35 Measured identified 36 37 38 a M 4 gt M Sheeti_Geeraerd Shoulder Sheeti Sheet2 Sheet3 7 pal Ready GInaFiT output when selecting the Geeraerd et al 2000 Log Linear Shoulder Menu Item for the case study at hand GInaFiT Version 1 6 20 A short advice on the use of GInaFiT The tool is useful for testing ten different types of microbial survival models on user specific experimental data relating the evolution of the microbial population with time The ten model types are 7 classi
10. Analysis ToolPak C e Officel4 Library Analysis ANALYS32 XLL_ Excel Add in C fficel4 Library Analysis ATPVBAEN XLAM Excel Add in C Users LeticiaH Documents attachment ashx Excel Add in C J Microsoft Office Officel4 OFFRHD DLL Document Inspector C s microsoft shared Smart Tag MOFL DLL Action uro Currency Tools C Office Officel4 Library EUROTOOL XLAM Excel Add in Financial Symbol XML C s microsoft shared Smart Tag MOFL DLL Action Headers and Footers s licrosoft Office Officel4 OFFRHD DLL Document Inspector Hidden Rows and Columns 2 soft Office Officel4 OFFRHD DLL Document Inspector Hidden Worksheets soft Office Officel4 OFFRHD DLL Document Inspector Invisible Content 2 Microsoft Office Officel4 OFFRHD DLL Document Inspector Microsoft Actions Pane 3 XML Expansion Pack Document Retated Add ins No Document Related Add ins Disabled Application Add ins Add in Ginafit Publisher Compatibility No compatibility information available Location CAUsersiLeticiaHDocumentsiGInaFiT xla Description Manage Excel Add ins E e At the bottom of the Add Ins screen select Excel Add Ins under the drop down list next to Manage It is likely but not guaranteed that Excel Add Ins is already appearing here Then proceed by hitting the button Go General View and manage Microsoft Office Add ins Formulas Proofing Add ins Save Name Location Type Active Application Add
11. GInaFiT Geeraerd and Van Impe Inactivation model Fitting Tool Developed under the supervision of 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 Albert and Mafart 2005 Geeraerd et al 2005 Coroller et al 2006 Version 1 6 Office 2010 amp 2007 March 2012 Copyright 2003 2012 Katholieke Universiteit Leuven Belgium GInaFiT Version 1 6 1 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 On publishing presenting the results obtained with GInaFiT you are kindly invited to refer to A H Geeraerd V P Valdramidis J F Van Impe 2005 GInaFiT a freeware tool to assess non log linear microbial survivor curves International Journal of Food Microbiology 102 95 105 and to the original research publications for the model s you selected for your case study as provided in the Excel result sheet s and this user manual Feedback If you would have comments or suggestions regarding the installation use or content of GInaFiT or if you would be willing to provide a sho
12. Top options for working with Excel Save iv Show Mini Toolbar on selection amp Enable Live Preview Show Developer tab in the Ribbon Advanced Customize V Always use ClearType Colorscheme Blue Trost Center x ScreenTip style Show feature descriptions in ScreenTips x Create lists for use in sorts and fill sequences Edit Custom Li When creating new workbooks Resources Use this font Body Font x Font size iy Default view for new sheets Normal View Include this many sheets B O Personalize your copy of Microsoft Office Username AnnemieG Choose the languages you want to use with Microsoft Office Language Settings e At the bottom of the Add Ins screen select Excel Add Ins under the drop down list next to manage It is likely but not guaranteed that Excel Add Ins is already appearing here Then proceed by hitting the button Go Excel Options Popular 2 P Im View and manage Microsoft Office add ins Formulas Proofing Add ins Save Location Advanced Customize Inactive Application A Trust Center Resources Analysis ToolPak Analysis ToolPak VBA Custom XML Data Euro Currengy Tools Financial Symbol Smart tag lists Headers and Footers Hidden Rows and Columns Hidden Worksheets Internet Assistant VBA Invisible Content Person Name Outlook e mail recipients Wizard Opz
13. UROTOOL XLAM Excel Add in Financial Symbol Smart tag lists es Microsoft Shared Smart Tag MOFL DLL Smart Tag Headers and Footers niles Microsoft Office Officel2 OFFRHD DLL Document Inspector _ Hidden Rows and Columns iles Microsoft Office Officel2 OFFRHD DLL Document Inspector Hidden Worksheets iles Microsoft Office Officel2 OFFRHD DLL Document Inspector Internet Assistant VBA uitrosoft Office Officel 2 Library HTMLXLAM Excel Add in Invisible Content ies Microsoft Office Officel2 OFFRHD DLL Document Inspector Person Name Outlook e mail recipients s Microsoft Shared Smart Tag FNAME DLL Smart Tag Wizard Opzoeken Asoft Office Officel 2 Library LOOKUP XLAM Excel Add in Wizard Voorwaardelijke som rosoft Office Officel2 Library SUMIF XLAM Excel Add in Resources Add in Analysis ToolPak Publisher Microsoft Corporation Location C Program Files Microsoft Office Officel 2 Library Analysis ANALYS32 XLL Description Bevat hulpprogramma s voor het analyseren van statistische en technische gegevens Manage Excel Add ins e The item Solver Add in has to be ticked in the list i e the v should be visible before the Solver Add In Alternatively it may be the case that the Solver name is indicated with its equivalent name in the language of your Windows version If this is the case select the Solver with this other name Add ins es Add Ins available Analysis ToolPak Analysis ToolPak VBA C
14. aH Documents attachment ashx Excel Add in EE Custom XML Data C Microsoft Office Office14 OFFRHD DLL Document Inspector Date XML C s microsoft shared Smart Tag MOFL DLL Action lg Aii Euro Currency Tools C Office Officel4 Library EUROTOOL XLAM Excel Add in Financial Symbol XML C s microsoft shared Smart Tag MOFL DLL Action Headers and Footers Microsoft Office Officel4 OFFRHD DLL Document Inspector Hidden Rows and Columns C Microsoft Office Officel4 OFFRHD DLL Document Inspector Hidden Worksheets C Microsoft Office Officel4 OFFRHD DLL Document Inspector Invisible Content C Microsoft Office Officel4 OFFRHD DLL Document Inspector Microsoft Actions Pane 3 XML Expansion Pack Document Related Add ins No Document Related Add ins e Disabled Application Add ins s Add in Ginafit Publisher Compatibility No compatibility information available Location C Users LeticiaH Documents GInaFiT xla Description Manage ExcelAadins s e At the bottom of the Add Ins screen select Excel Add Ins under the drop down list next to manage It 1s likely but not guaranteed that Excel Add Ins 1s already appearing here Then proceed by hitting the button Go GInaFiT Version 1 6 10 Inactive Application Add ins Analysis ToolPak Analysis ToolPak VBA Customize Ribbon Quick Access Toolbar Microsoft Actions Pane 3 Document Re
15. c icrosoft shared Smart Tag MOFL DLL Action uro Currency Tools C Office Officel4 Library EUROTOOL XLAM Excel Add in Financial Symbol XML C s microsoft shared Smart Tag MOFLOLL Action c c c c Customize Ribbon m Headers and Footers Microsoft Office Officel4 OFFRHD DLL_ Document Inspector Hidden Rows and Columns J Microsoft Office Officel4 OFFRHD DLL Document Inspector Hidden Worksheets Microsoft Office Officel4 OFFRHD DLL_ Document Inspector Invisible Content Microsoft Office Officel4 OFFRHD DLL Document Inspector Microsoft Actions Pane 3 XML Expansion Pack Document Related Add ins cument Related Disabled Application Add ins Add in Ginafit Publisher Compatibility No compatibility information available Location C Users LeticiaH Documents GinaFiT xla Description Manage Excel Add ins x Go e At the bottom of the Add Ins screen select Excel Add Ins under the drop down list next to Manage It is likely but not guaranteed that Excel Add Ins is already appearing here Then proceed by hitting the button Go GInaFiT Version 1 6 7 Excel Options General Formulas Proofing Save Language Advanced Customize Ribbon Quick Access Toolbar Ca Trust Center t View and manage Microsoft Office Add ins Add ins Name Active Application Add ins Ginafit Oplosser invoegtoepassing Inactive Application Add ins Ana
16. cal log linear curves ii curves displaying a so called shoulder before a log linear decrease is apparent iii curves displaying a so called tail after a log linear decrease iv survival curves displaying both shoulder and tailing behavior v concave curves vi convex curves vii convex concave curves followed by tailing viii biphasic inactivation kinetics ix biphasic inactivation kinetics preceded by a shoulder and x curves with a double concave convex shape The models were originally published as Bigelow and Esty 1920 Cerf 1977 Geeraerd et al 2000 Mafart et al 2002 Albert and Mafart 2005 Geeraerd et al 2005 and Coroller et al 2006 Next to the obtained parameter values the following statistical measures are automatically reported standard errors of the parameter values the Sum of Squared Errors the Root Mean Sum of Squared Errors the R and the adjusted R In addition t 5 the time needed for a 4 log reduction of the initial microbial population as originally proposed by Buchanan et al 1993 is also automatically reported for data sets covering at least 4 decimal reductions 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 is obvious On the other hand if the end user does not have a clear idea yet two or more of the different model types available can be tested and
17. ents Annemie Geeraerd is associate professor at the Division MeBioS Mechatronics Biostatistics and Sensors at the Biosystems Department at KULeuven www mebios be My colleagues Benny Depre Maarten Hertog and Bram Van de Poel are gratefully acknowledged for their help in realizing this GlInaFiT Version 1 6 and its manual Dr Vicente Gomez CSIC Spain is gratefully acknowledged for reporting a bug in Version 1 5 Mieke Janssen Arnout Standaert Vasilis Valdramidis and Karen Vereecken at that time working at KULeuven BioTeC Department of Chemical Engineering are gratefully acknowledged for their help in testing an earlier version of this tool as well as Marie Cornu who was affiliated with AFSSA now ANSES in Paris for her help to establish an earlier French version Concerning the test phase of the language independent version of GInaFiT from Version 1 4 2 on the following persons are especially to be acknowledged Antonio Valero Diaz Department of Food Science and Technology University of Cordoba Spain Laurent Guillier Ecole Nationale V t rinaire d Alfort Maisons Alfort France Philipp Hammer Institute for Hygiene and Food Safety Federal Research Center of Nutrition and Food Kiel Germany and Xiaohe Wu College of Food Science amp Nutritional Engineering China Agriculture University Beijing China GInaFiT Version 1 6 22
18. ge Excel Add ins Cancel e Inthe Add In screen untick the Add In GInaFiT e A screen appears press OK on that screen e Delete the GlInaFiT xla file from the directory selected at the start of the installation procedure Installation of GInaFit Office 2007 An essential requirement Please carefully consider the following essential requirement before proceeding to the installation of GInaFiT Office 2007 the MS Excel Add In Solver is installed This requirement can be verified by looking under the Excel worksheet tab Data Solver should be visible in the right corner as indicated in the next figure EEF amp e What If Group Ungroup Subtotal Analysis Y 2 Hide Detall Outline GInaFiT Version 1 6 11 If the Solver is not appearing under the worksheet tab Data it needs to be installed This is to be performed with the procedure e Hit the Office Button this is the Circle with the Office logo in the upper left corner of the Excel application e Hit the button Excel Options gl c copi _ Recent Documents 1 case study Ecoli 566 xls vi D oen amp k x Convert ld A Save As gt Print gt 2 Prepare gt Send gt A Publish gt Close E Excel Options x Exit Excel zu 21 e Select Add Ins Excel Options 3 LE m Change the most popular options in Excel Formulas Pro
19. ins Ginafit C Users LeticiaH Documents GinaFiT xla Excel Add in Advanced Oplosser invoegtoepassing C e Officel4 Library SOLVER SOLVER XLAM Excel Add in language Customize Ribbon Inactive Application Add ins Analysis ToolPak CA elOfficeL amp LibraryAnalysisANALYS32 XLL Excel Add in Quick Access Toolbar Analysis ToolPak VBA C nfficel4 Library Analysis ATPVBAEN XLAM Excel Add in Attachment C Users LeticiaH Documents attachment ashx Excel Add in Aem Custom XML Data CA Microsoft Office Officel4 OFFRHD DLL_ Document Inspector Date XML Ch simicrosoft shared Smart Tag MOFLDLL Action Trust Center Euro Currency Tools C Office Officel4 Librany EUROTOOLXLAM Excel Add in Financial Symbol XML Ci smicrosoft shared Smart Tag MOFLDLL Action Headers and Footers CA Microsoft Office Officel4 OFFRHD DLL_ Document Inspector Hidden Rows and Columns C Microsoft Office Officel4 OFFRHD DLL Document Inspector Hidden Worksheets CA Microsoft OfficeVOfficeL4VOFFRHD DLL Document Inspector Invisible Content CA Microsoft Office Officel4 OFFRHD DLL Document Inspector Microsoft Actions Pane 3 XML Expansion Pack Document Related Add ins No Document Related Add ins Disabled Application Add ins Add in Ginafit Publisher Compatibility No compatibility information available Location CAUsersiLeticiaHDocumentsXGInaFiT xla Description SS A Excel Add ins GInaFiT Version 1 6 4 e The item
20. lated Add ins No Document Related Add ins Disabled Application Add ins C e Officel4 Library Analysis ANALYS32 XLL_ Excel Add in C fficel4 Library Analysis ATPVBAEN XLAM G Users LeticiaH Documents attachment ashx Excel Add in Attachment ans Custom XML Data C Microsoft Office Officel4 OFFRHD DLL Date XML C s microsoft shared Smart Tag MOFL DLL Toteni Euro Currency Tools C5 Office Office14 Libray EUROTOOL XLAM Financial Symbol XML C s microsoft shared Smart Tag MOFL DLL Headers and Footers C Microsoft Office Officel4 OFFRHD DLL Hidden Rows and Columns C Microsoft Office Officel4 OFFRHD DLL Hidden Worksheets C Microsoft Office Officel4 OFFRHD DLL Invisible Content C Microsoft Office Officel4 OFFRHD DLL Excel Options tena h General zb r td View and manage Microsoft Office Add ins Formulas Proofing Add ins Save Name Location Type D language Active Application Add ins Ginafit G Users LeticiaH Documents GInaFiT xla Excel Add in Advanced Oplosser invoegtoepassing C e Officel4 Library SOLVER SOLVER XLAM Excel Add in Excel Add in Document Inspector Action Excel Add in Action Document Inspector Document Inspector Document Inspector Document Inspector XML Expansion Pack Add in Ginafit Publisher Compatibility No compatibility information available Location C Users LeticiaH Documents GInaFiT xla Description lt gt Mana
21. lysis ToolPak Analysis ToolPak VBA Attachment Custom XML Data Date XML Euro Currency Tools Financial Symbol XML Headers and Footers Hidden Rows and Columns Hidden Worksheets Invisible Content Location C Users LeticiaH Documents GinaFiT xla C e Officel4 Library SOLVER SOLVER XLAM C e Officel 4 Library Analysis ANALYS32 XLL C fficel 4 Library Analysis ATPVBAEN XLAM Users LeticiaH Documents attachment ashx C Microsoft Office Officel4 OFFRHD DLL C swmicrosoft shared Smart Tag MOFL DLL C Office Office 4 LibranEUROTOOL XLAM C smicrosoft shared Smart Tag MOFL DLL C Microsoft Office Officel4 OFFRHD DLL C Microsoft Office Officel4 OFFRHD DLL CA Microsoft Office Officel4 OFFRHD DLL C Microsoft Office Officel4 OFFRHD DLL Type Excel Add in Excel Add in Excel Add in Excel Add in Excel Add in Document inspector Action Excel Add in Action Document Inspector Document Inspector Document Inspector Document inspector Microsoft Actions Pane 3 XML Expansion Pack Document Related Add ins No Document Related Add ins Disabled Application Add ins Add in Ginafit Publisher Compatibility No compatibility information available Location ChUsersiLeticiaH Documents GlnaFiT xla Description Manage Excel Add ins e In the Add In screen tick the Add In GInaFiT when present in the list or select the GlInaFiT xla file by browsing to
22. mmands 16 2 Select the model to be applied out of the ten different models available as can be seen in the figure below GInaFiT Version 1 6 19 Insert Formulas Page Layout Data Bigelow and Esty 1920 Log Linear Regression Geeraerd et al 2000 Log Linear Shoulder N Geeraerd et al 2000 Log Linear Tail E Geeraerd et al 2000 Log Linear Shoulder Tail F Mafart et al 2002 Weibull Mafart et al 2002 Weibull Fixed p parameter Albert and Mafart 2005 Weibull Tail Corroler et al 2006 Double Weibull Cerf 1977 Biphasic Model Geeraerd et al 2005 Biphasic Shoulder Disclaimer amp Bibliographic reference About GInaFiT 3 A new sheet is inserted with the same name as the name of the original sheet followed by the name of the model selected e g Sheet would result in Sheet1 Geeraerd Shoulder Tail The result is demonstrated below Home Insert Pagelayout Formulas Data Review View Add Ins GinaFit Menu Commands AB40 bd f A B c D E F G H 1 J K L M N o P a R s T t measurea iaentimiea 1 Time LOG10 N LOG10 N Squared difference Parameters Paramete Standard Error 2 0 00 9 58 9 47 0 01 SI Shoulder length 8 61 0 54 Mean Sum of Squared Error 0 0303 3 1 00 9 66 9 47 0 04 kmax 0 71 0 02 Root Mean Sum of Squared Error 0 1741 4 2 00 9 45 9 47 0 00 LOG10 N0 9 47 0 08 R Square 0 9947 5 3 00 9 44 9 46 0 00 R Square adjusted 0 99
23. oeken Wizard Voorwaardelijke som ice Office 2 Library Analysis ANALYS32 XLL Officel2 Library Analysis ATPVBAEN XLAM es Microsoft Office Officel2 OFFRHD DLL Office Office 2 Library EUROTOOL XLAM jes Microsoft Shared Smart Tag MOFL DLL les Microsoft Office Officel2 OFFRHD DLL les Microsoft Office Officel 2 OFFRHD DLL miles Microsoft Office Officel 2 OFFRHD DLL icrosoft Office Officel2 Library HTML XLAM les Microsoft Office Officel 2 OFFRHD DLL s Microsoft Shared Smart Tag FNAME DLL oft Office Officel 2 Library LOOKUP XLAM Fosoft Office Officel 2 Library SUMIF XLAM Excel Add in Excel Add in Document Inspector Excel Add in Smart Tag Document Inspector Document Inspector Document Inspector Excel Add in Document Inspector Smart Tag Excel Add in Excel Add in Add in Analysis ToolPak Publisher Microsoft Corporation Location C Program Files Microsoft Office Officel 2 Library Analysis ANALYS32 XLL Description Bevat hulpprogramma s voor het analyseren van statistische en technische gegevens Manage Excel Add ins e Inthe Add In screen untick the Add In GInaFiT e Delete the GInaFiT xla file from the directory selected at the start of the installation procedure GInaFiT Version 1 6 18 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 LOGIO N cha Home Insert Page Layout F GInaFiT Menu Co
24. ofing Top options for working with Excel Save W Show Mini Toolbar on selection V Enable Live Preview Advanced Show Developer tab in the Ribbon Customize V Always use ClearType Colorscheme Blue v Trust Center X SereenTip style Show feature descriptions in ScreenTips Create lists for use in sorts and fill sequences Edit Custom Lists When creating new workbooks Resources Use this font Body Font Font size u iv Default yiew for new sheets Normal View Include this many sheets 3 si Personalize your copy of Microsoft Office Username AnnemieG Choose the languages you want to use with Microsoft Office Language Settings e At the bottom of the Add Ins screen select Excel Add Ins under the drop down list next to manage It is likely but not guaranteed that Excel Add Ins is already appearing here Then proceed by hitting the button Go GInaFiT Version 1 6 12 Excel Options Popular I View and manage Microsoft Office add ins Formulas Proofing Add ins Name Location Advanced tive Applicatic Customize agains Analysis ToolPak C nfice Office12 Libray Analysis ANALYS32 XLL Excel Add in Analysis ToolPak VBA Officel2Librar Analysis ATPVBAEN XLAM Excel Add in Trust Center Custom XML Data i niles Microsoft Office Officet2 OFFRHD DLL Document Inspector Euro Currency Tools Office Officel2 Library E
25. onditional Sum Wizard Euro Currency Tools Internet Assistant VBA Lookup Wizard Solver Add in Cancel Browse Automation ie foal prese z olver Add in Tool for optimization and equation solving e Press OK GInaFiT Version 1 6 13 Add Ins available Analysis ToolPak Analysis ToolPak VBA Conditional Sum Wizard Euro Currency Tools Internet Assistant VBA EXE Ew EM M Add in Lookup Wizard Browse Automation E olver Add in Tool For optimization and equation solving e The Solver should now be visible in the right corner under the Excel menu tab Data as indicated in the next figure amp What If Group Ungroup Subtotal Analysis Outline Installation of GInaFiT xla It is suggested to place the file GInaFiT xla in the directory c Program Files Microsoft Office Office12 ADDINS or in a similar directory for an Office version in a language different from English Nevertheless placing at any other location like for example C temp is always possible Start MS Excel with a blank work sheet e Hit the Office Button this is the Circle with the Office logo in the upper left corner of the Excel application e Hit the button Excel Options GInaFiT Version 1 6 14 e id 9 c eap El 3 d Recent Documents New 1 case study Ecoli 566 xls fA f A Convert LG ld A Save As gt em Print gt gr Prepare
26. rt and Mafart 2005 Weibull Tail Corroler et al 2006 Double Weibull Cerf 1977 Biphasic Model Geeraerd et al 2005 Biphasic Shoulder Disclaimer amp Bibliographic reference About GInaFiT How to remove GInaFiT Start MS Excel with a blank work sheet Click the File tab Home Insert Page Layout Formulas Data Review ta D piz i i a Connections 4 ii Z Al ET Properties From From From From Other Existing Refresh x Access Web Text Sources Connections Ally Edit Links Get External Data Connections Al E f e The Microsoft Office Backstage view opens GInaFiT Version 1 6 9 Home Insert Page Layout Formulas Data lg Save lil Save As Ey Open Gf Close Recent Workbooks Info New Print Save amp Send Help E Exit e Click Options e The Options dialog box appears Select Add Ins General i P E View and manage Microsoft Office Add ins Formulas Proofing Add ins Save Name Location Type le Language Active Application Add ins Ginafit G Users LeticiaH Documents GInaFiT xla Excel Add in Advanced Oplosser invoegtoepassing C e Officel4 Library SOLVER SOLVER XLAM Excel Add in Customize Ribbon Inactive Application Add ins Analysis ToolPak C e Officel4 Library Analysis ANALYS32 XLL_ Excel Add in 1 Quick Access Toolbar Analysis ToolPak VBA C fficel4 Library Analysis ATPVBAEN XLAM Excel Add in Attachment G Users Letici
27. rt user testimonial please contact annemie geeraerd g biw kuleuven be associate professor at www mebios be Your comments and user testimonials are highly appreciated Updates Possible future updates will be accessible via the KULeuven MeBioS homepage http www biw kuleuven be biosyst mebios AppliedResearch food chain safety and quality html amp the KULeuven BioTeC homepage http cit kuleuven be biotec downloads php Compatibility with different Microsoft Office Excel 9 versions The GInaFiT version that you have obtained together with this manual is compatible with Microsoft Office Excel 2010 and Microsoft Office Excel 2007 and in principle it should work for any language though we did obviously not test for every language Installation instructions are provided below GInaFiT Version 1 6 is not compatible anymore with Microsoft Office Excel 2003 also called Microsoft Office Excel amp XP If you would be interested in receiving Version 1 6 as it contains a bug fix in comparison with Version 1 5 for Microsoft Office Excel 2003 XP please contact annemie geeraerd biw kuleuven be Installation of GInaFiT Office 2010 For the installation instructions for GInaFiT Office 2007 please refer to page 11 of this manual An essential requirement Please carefully consider the following essential requirement before proceeding to the installation of GInaFiT in Office 2010 the MS Excel Add In Solver is installed
28. s Add Ins available Analysis ToolPak IT Analysis ToolPak VBA I Conditional Sum Wizard Internet Assistant VBA Lookup Wizard Risk v Solver Add in Automation Look in Favorites Press OK and please read carefully the two screens appearing From this moment on the button GInaFiT will be present in the Worksheet tab Add Ins last tab GInaFiT Version 1 6 E test e amp amp X Pi m Toos File name Files of type add ins xla x1 16 16 00 Bigelow and Esty 1920 Log Linear Regression Geeraerd et al 2000 Log Linear Shoulder Geeraerd et al 2000 Log Linear Tail Geeraerd et al 2000 Log Linear Shoulder Tail Mafart et al 2002 Weibull Mafart et al 2002 Weibull Fixed p parameter Albert and Mafart 2005 Weibull Tail Corroler et al 2006 Double Weibull Cerf 1977 Biphasic Model Geeraerd et al 2005 Biphasic Shoulder Disclaimer amp Bibliographic reference About GInaFiT 733 rex How to remove GlInaFiT Start MS Excel with a blank work sheet e Hit the Office Button this is the Circle with the Office logo in the upper left corner of the Excel application e Hit the button Excel Options A Prepare iE Send ig Publish case study Ecoli 566 xls e Select Add Ins GInaFiT Version 1 6 17 Excel Options LU Change the most popular options in Excel Formulas Proofing
Download Pdf Manuals
Related Search