GHSIM Developed in Spreadsheet Quattro Pro Simulates the Interactive Greenhouse
A computer model, GHSIM, was formulated in Quattro Pro spreadsheet format. GHSIM was designed having individual pages calculating simulated activities necessary for greenhouse production. Pages were arranged by alphabetical topics starting with the “Area” used in the greenhouse. Time advanced by 1 day for each 10 s of real time. The time advance in the program can be paused to make setting changes interactively. Pest infestation occurred as probabilities accumulated, and the pest population spread through the greenhouse based on proximity and density of pests. Pest control was simulated by a pesticide application capable of partially reducing populations; repeated applications could effectively eliminate a pest. Crop growth was simulated by iterative acccumulation of biomass using Euler integration of daily plant growth. The daily growth increment was calculated using the first derivative of the Richard's Function. Large pest populations negatively impacted the daily growth increment, and pesticide applicaions would remove the inhibition of growth. Additional features proposed include light and temperature effects on the plant growth rate and accumulated biomass.