Inżynieria Rolnicza
Home page
Place of Work
Title : Modelling of temperature field in the ground with the use of spreadsheet
Key words : modelling temperature field, heat pump, spreadsheet, differential net, simulation, Visual Basic for Applications
Summary :

Modern world faces the challenge of satisfying constantly growing energy demand on one hand and increasing food demands on the other. New ways, alternative to conventional energy sources have been searched for. Heat pumps obtaining energy from the interior of the Earth have become very popular recently. In order to use them effectively, software that simulates temperature distribution in the ground are indispensable. Thanks to them, temperature state on any depth may be precisely determined and consequently controlling devices of heat pumps operation may be controlled optimally, etc. The paper herein presents an example of using the spreadsheet of MS Office with implemented language Visual Basic Application (VBA) for modelling temperature field in the ground. The authors' objective is to present and verify the usability of this solution for modelling the temperature distribution in the ground during the operation of a heat pump. On the basis of differential equation describing heat conduct in the ground, discretization of two-dimensional flat panel (differential net model) was carried out and then implementation in VBA language. Results of numerical simulation were set with real temperature measurements in the next stage. As a conclusion, it was found that spreadsheet is useful in modelling temperature field in the ground. This device is especially useful for teaching purposes.

Please use the following format to cite the selected article : Sporysz, M., Kurpaska, S., Molenda, K., Szczuka, M., Roczkowska-Chmaj, S. (2013). Modelling of temperature field in the ground with the use of spreadsheet. Inzynieria Rolnicza, 2(143), 317-328.
Download :
Current affiliation
If you see any errors, please contact: Redakcja PTIR