The APEXeditor, an Excel-based tool has been developed using the Visual Basic for Applications (VBA) to provide a graphical user interface (GUI) to the Agricultural Policy Environmental eXtender (APEX) model. APEX, in its native form, requires users to edit text files for modifying input files; therefore a GUI interface can aid users in modification of these files and reduce errors. Microsoft Excel is a popular spreadsheet program that has the largest user base among scientists and researchers, thus providing a relatively common platform in which stages the tool. The APEXeditor requires minimal additional learning to operate the tool for those who already have basic level of knowledge in Excel. The user can load APEX input files into the spreadsheet tool and the GUI offers meta information and provides functions to edit, write, and run the APEX model. Ultimately, the APEXeditor substitutes existing GUI programs such as WinAPEX or ArcAPEX that require installation or additional licensing. A series of scripts were developed as a back-end engine that automates data formatting and editing of linked APEX input ASCII files including database libraries. The simple architecture of the tool helps users maintain the quality of the data and allows error-free editing of APEX model inputs to characterize the system under study. This tool is suitable for all kinds of applications and has been successfully used for the creation of APEX model runs in numerous studies.
KeywordsSimulation ModelsAPEXExcelVisual BasicGraphical User Interface
Williams, J.R. (1990) The Erosion Productivity Impact Calculator (EPIC) Model: A Case History. Philosophical Transactions of the Royal Society of London B, 329, 421-428. https://doi.org/10.1098/rstb.1990.0184
Williams, J.R. and Izaurralde, R.C. (2005) The APEX Model. BRC Rep. 2005-02. Blackland Res. Center, Texas A&M Univ., Temple. https://doi.org/10.1201/9781420037432.ch18
Wang, X., Williams, J.R., Gassman, P.W., Baffaut, C., Izaurralde, R.C., Jeong, J. and Kiniry, J.R. (2012) EPIC and APEX: Model Use, Calibration, and Validation. Transactions of the American Society of Agricultural and Biological Engineers, 55, 1447-1462. https://doi.org/10.13031/2013.42253
Taylor, R.A.J., Jeong, J., White, M. and Arnold, J.G. (2015) Code Modernization and Modularization of APEX and SWAT Watershed Simulation Models. International Journal of Agricultural and Biological Engineering, 8, 81-94.
Gassman, P.W., Williams, J.R., Wang, X., Saleh, A., Osei, E. and Hauck, L.M. (2010) Invited Review Article: The Agricultural Policy/Environmental eXtender (APEX) Model: An Emerging Tool for Landscape and Watershed Environmental Analyses. Transactions of the American Society of Agricultural and Biological Engineers, 53, 711-740. https://doi.org/10.13031/2013.30078
U.S. Department of Agriculture, Natural Resources Conservation Service (2017) Effects of Conservation Practices on Water Erosion and Loss of Sediment at the Edge of the Field: A National Assessment Based on the 2003-06 CEAP Survey and APEX Modeling Databases. 74 p.
Boyd, R. and Green, C. (2018) A Framework for Improving the Effectiveness of the Colorado River Basin Salinity Control Program 2018-2023. Bureau of Land Management National Operations Center, Denver, 20 p.
Steglich, E.M., Osorio, J., Doro, L., Jeong, J. and Williams, J.W. (2018) Agricultural Policy/Environmental eXtender Model User Manual Version 1501. Blackland Research and Extension Center, Temple. https://epicapex.tamu.edu/manuals-and-publications/7
Tuppad, P., Winchell, M.F., Wang, X., Srinivasan, R. and Williams, J.R. (2009) ArcAPEX: ArcGIS Interface for Agricultural Policy Environmental Extender (Apex) Hydrology/Water Quality Model. International Agricultural Engineering Journal, 18, 59-71.
Magre, M., Williams, J.R., Harman, W.L., Gerik, T., Greiner, J., Francis, L., Steglich, E. and Meinardus, A. (2006) WinAPEX Users Guide Version 1.0. Blackland Research and Extension Center, Texas A& M System, Temple. http://agrilife.org/epicapex/files/2014/09/winapexv0604_nov2006.pdf
Siemers, M., Plotkin, S. and Gassman, P.W. (2014) Interactive APEX (i_APEX) User’s Guide Using APEX2110 and APEX0806. CARD Technical Reports, 40.
Clarke, N., Bizimana, J.C., Dile, Y., Worqlul, A., Osorio, J., Herbst, B., Richardson, J.W., Srinivasan, R., Gerik, T.J., Williams, J., Jones, C.A. and Jeong, J. (2016) Evaluation of New Farming Technologies in Ethiopia Using the Integrated Decision Support System (IDSS). Agricultural Water Management, 180, 267-279. https://doi.org/10.1016/j.agwat.2016.07.023
Doro, L., Jones, C., Williams, J.R., Norfleet, M.L., Izaurralde, R.C., Wang, X. and Jeong, J. (2017) The Variable Saturation Hydraulic Conductivity Method for Improving Soil Water Content Simulation in EPIC and APEX Models. Vadose Zone Journal, 16, 1-14. https://doi.org/10.2136/vzj2017.06.0125
Zilverberg, C.J., Williams, J.W., Jones, C., Harmoney, K., Angerer, J., Metz, L.J. and Fox, W. (2017) Ecological Modelling. Process-Based Simulation of Prairie Growth. Ecological Modelling, 351, 24-35. https://doi.org/10.1016/j.ecolmodel.2017.02.004
Zilverberg, C.J., Angerer, J., Williams, J.W., Metz, L.J. and Harmoneye, K. (2018) Sensitivity of Diet Choices and Environmental Outcomes to a Selective Grazing Algorithm. Ecological Modelling, 390, 10-22. https://doi.org/10.1016/j.ecolmodel.2018.10.007
Chavez, C.J., Enciso, J., Meki, M.N., Jeong, J. and Singh, V.P. (2018) Simulation of Energy Sorghum under Limited Irrigation Levels Using the EPIC Model. Transactions of the American Society of Agricultural and Biological Engineers, 61, 121-131. https://doi.org/10.13031/trans.12470
Le, K.N., Jha, M.K., Reyes, M.R., Jeong, J., Doro, L., Gassman, P.W., Hok, L., de Moraes Sá, J.C. and Boulakia, S. (2018) Evaluating Carbon Sequestration for Conservation Agriculture and Tillage Systems in Cambodia Using the EPIC Model. Agriculture, Ecosystems & Environment, 251, 37-47. https://doi.org/10.1016/j.agee.2017.09.009
Worqlul, A.W., Dile, Y.T., Bizimana, J.C., Jeong, J., Gerik, T.J., Srinivasan, R., Richardson, J.W. and Clarke, N. (2018) Multi-Dimensional Evaluation of Simulated Small-Scale Irrigation Intervention: A Case Study in Dimbasinia Watershed, Ghana. Sustainability, 10, 1531. https://doi.org/10.3390/su10051531
Zhang, L., Juenger, T.E., Osorio, J.M. and Behrman, K.D. (2018) Sensitivity Analysis of the APEX Model for Assessing Sustainability of Switchgrass Grown for Biofuel Production in Central Texas. BioEnergy Research, 11, 69-85. https://doi.org/10.1007/s12155-017-9878-8
Meki, M.N., Kiniry, J.R., Worqlul, A., Kim, S., Williams, A.S., Reilley, J. and Osorio, J.M. (2019) A Field and Simulation-Based Assessment of Vetivergrass Bioenergy Feedstock Production Potential in Texas. (Manuscript Submitted for Publication)
Sharifi, A., Lee, S., McCarty, G.W., Lang, M.W., Jeong, J., Sadeghi, A.M. and Rabenhorst, M.C. (2019) Enhancement of Agricultural Policy/Environment eXtender Model (APEX) Model to Assess Effectiveness of Wetland Water Quality Functions. Water, 3, 606-618. https://doi.org/10.3390/w11030606
Zhao, J., Chu, Q., Shang, M., Meki, M.N., Norelli, N., Jiang, Y., Yang, Y., Zang, H., Zeng, Z. and Jeong, J. (2019) APEX Simulation of Spring Peanut Management in the North China Plain. Agronomy, 9, 443. https://doi.org/10.3390/agronomy9080443
Goehring, N. (2017) Modeling Salt Movement and Halophytic Crop Growth on Marginal Lands with the APEX Model (Master’s Thesis). University of Nevada, Reno, NV. https://scholarworks.unr.edu/bitstream/handle/11714/2761/Goehring_unr_0139M_12429.pdf?sequence=1&isAllowed=y