![]() ![]() Modifications: If you wish to see or modify the macros, they are accessed from the Tools> Macro> Visual Basic Editor menu item. It will also draw two charts: the Temperature vs Time and growth equation Y vs Time. The macro will solve the growth equation and update the calculation cells in column C and the graphical data cells in column F. Once legal values have been entered for each variable, you may click the Clear button in column A to have the Clear macro initialize the calculation cells in column C, clear the graphical data column F and delete any existing charts.Ĭlicking the Solve button in column A first calls Clear then calls the Solve macro. ![]() The pop-up comment note that appears when the name cell above a variable's cell is pointed to with the mouse lists any restrictions on the legal range of values for that variable. Make any desired changes to the chart settings in column A.Įnter an initial value for each model variable in column B. MicrobialGrowthModelAData.xls Macro> Security to Medium, then close and reopen the file to enable the macros. Comment Notes from Excel File: MicrobialGrowthModelAData.xls Comment Notes from Excel File: MicrobialGrowthModelAData.xls Current version: FebruIn worksheet column A:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |