ASTROMOD: a computer program integrating vegetation dynamics modelling, environmental modelling and spatial data visualisation in Microsoft Excel

Berardi, Andrea

doi:10.1016/s1364-8152(02)00011-7

Cited by 7 publications

(2 citation statements)

References 36 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Excel is familiar to the large majority of scientists and students and by using VBA not necessarily becomes familiar with a new software environment (Diggle at al, 2003). The advantage of using Excel as a development environment is that it provides capabilities that allow for the preanalysis manipulation of data and the visualization of test output and results (Berardi at al, 2002). Effectiveness is generally defined as the capability in achieving an established goal (Berk at al, 2005).…”

Section: Literature Reviewmentioning

confidence: 99%

Creation and Use of Internal Matrix Database Functions in VBA MS Excel Environment for Bulk Data Processing

Dydowicz¹

2015

JSSD

View full text Add to dashboard Cite

Section: Literature Reviewmentioning

confidence: 99%

Creation and Use of Internal Matrix Database Functions in VBA MS Excel Environment for Bulk Data Processing

Dydowicz¹

2015

JSSD

View full text Add to dashboard Cite

“…A custom application with a vegetation dynamics model combined with models of environmental determinants was developed within Microsoft Excel (Berardi, 2002). The purpose of the application was to predict vegetation change within the Astroni crater, a state nature reserve near Naples, Italy.…”

Section: Development and Application Of A Spreadsheet-based Spatial D...mentioning

confidence: 99%

Development and Application of a Spreadsheet-Based Spatial Decision Support System (SDSS)

Sugumaran

Oryspayev

DeGroote

2011

International Journal of Decision Support System Technology

View full text Add to dashboard Cite

Spatial decision support systems (SDSS) are decision support tools which have been used widely in addressing complicated issues involving a spatial component. The use of SDSS has increased greatly over the last few decades especially in fields such as planning, natural resources management, and environmental science. Traditionally, SDSS have been developed with Geographic Information Systems (GIS) technology as a major component and used in application areas in which the use of GIS technology has been common. GIS software is often expensive and requires significant expertise, which can lead to under-utilization of GIS-based SDSS. In this paper, we describe the development of a freely available SDSS extension developed for Microsoft Excel, a very commonly used spreadsheet application. The purpose of this SDSS is to expand potential SDSS use to a wider potential audience for research, management, and teaching purposes.

show abstract

A dynamic decision model for the optimal use of forest biomass for energy production

Frombo¹,

Minciardi

Robba

et al. 2016

Energy Syst

View full text Add to dashboard Cite

The use of forest biomass for energy production requires a careful attention to the sustainable silvicultural practices. This is a complex task because of the different environmental and economic issues to be taken into account. To this aim, suitable tools must be used as regards the representation of the dynamics of forest biomass and the economic assessment. In this paper, a user-friendly optimization-based decision support system (DSS) that can help decision makers in the optimal management of forest biomass use for energy production is presented. Attention is focused on the forest system in order to take into account sustainable silvicultural practices and on the minimization of costs for the collection plans over years. Specifically, a non linear optimization model (that includes forest growth models) is formalized, aiming at determining, over a certain period, the optimal exploitation policy of forest biomass through a single plant whose location and size are assumed known, in order to minimize costs and to respect silvicultural constraints. The decision model is solved through a receding horizon approach and is applied to the case study of Val Bormida (Savona Province, Italy). Different tests and sensitivity analysis have been performed to validate the model and the approach. From an application point of view, observing the obtained results, it is evident that results are strongly influenced by the old average age of the vegetation in the specific case study. However, depending on the species, different trends for the results of annual mean increment and harvesting plans are observed

show abstract

ASTROMOD: a computer program integrating vegetation dynamics modelling, environmental modelling and spatial data visualisation in Microsoft Excel

Cited by 7 publications

References 36 publications

Creation and Use of Internal Matrix Database Functions in VBA MS Excel Environment for Bulk Data Processing

Creation and Use of Internal Matrix Database Functions in VBA MS Excel Environment for Bulk Data Processing

Development and Application of a Spreadsheet-Based Spatial Decision Support System (SDSS)

A dynamic decision model for the optimal use of forest biomass for energy production

Contact Info

Product

Resources

About