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...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.展开更多
The Agricultural Policy/Environmental eXtender (APEX) model has five different interfaces used to process and build simulation projects. These interfaces utilize different input databases that lead to different model ...The Agricultural Policy/Environmental eXtender (APEX) model has five different interfaces used to process and build simulation projects. These interfaces utilize different input databases that lead to different model default values. These values can result in different hydrologic, crop growth, and nutrient flow model outputs. This study compared structural and input value differences of the ArcAPEX and Nutrient Tracking Tool (NTT) interfaces. Long-term, water quality data from the Rock Creek watershed, located in Ohio were used to determine the impact of the differences on computation time, parameter sensitivity, and streamflow, total nitrogen (TN), and total phosphorus (TP) simulation performance. The input structures were the same for both interfaces for all files except soils, where NTT assigns three soil files per field, rather than a single one in ArcAPEX. As a result, computation times were three times as long for NTT as for ArcAPEX. There were twelve sensitive parameters in both cases, but the order of sensitivity was different. Both interfaces simulated streamflow well, but ARCAPEX simulated evapotranspiration, TN, and TP better than NTT, while NTT simulated crop yields better than ArcAPEX. However, none of the models met all of the performance criteria for either interface. Therefore, more work is needed to ensure models are properly calibrated before being used for scenario analysis. While it is acceptable for the values to be different from the SSURGO database, there is no documentation explaining the rationale for the modifications from the original source. This is one of the examples that highlights lack of detailed documentation that would be useful to model users. Overall, the results indicate that different interfaces lead to different model simulation results and, therefore, the authors recommend users specify the interface used and any modifications made to the associated databases when reporting model results.展开更多
The biophore model of sulfonylurea herbicides (the training set contains 31 compounds) was obtained by using the advanced APEX-3D method. On the basis of the identilied biophore model, the activities of some known ALS...The biophore model of sulfonylurea herbicides (the training set contains 31 compounds) was obtained by using the advanced APEX-3D method. On the basis of the identilied biophore model, the activities of some known ALS inhibitors were predicted.Most of the predictions were in good agreement with experiments. The quality of the biophore model has been proved to be reliable. This research suggests a new approach for designing the new series of ALS inhibitors.展开更多
文摘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.
文摘The Agricultural Policy/Environmental eXtender (APEX) model has five different interfaces used to process and build simulation projects. These interfaces utilize different input databases that lead to different model default values. These values can result in different hydrologic, crop growth, and nutrient flow model outputs. This study compared structural and input value differences of the ArcAPEX and Nutrient Tracking Tool (NTT) interfaces. Long-term, water quality data from the Rock Creek watershed, located in Ohio were used to determine the impact of the differences on computation time, parameter sensitivity, and streamflow, total nitrogen (TN), and total phosphorus (TP) simulation performance. The input structures were the same for both interfaces for all files except soils, where NTT assigns three soil files per field, rather than a single one in ArcAPEX. As a result, computation times were three times as long for NTT as for ArcAPEX. There were twelve sensitive parameters in both cases, but the order of sensitivity was different. Both interfaces simulated streamflow well, but ARCAPEX simulated evapotranspiration, TN, and TP better than NTT, while NTT simulated crop yields better than ArcAPEX. However, none of the models met all of the performance criteria for either interface. Therefore, more work is needed to ensure models are properly calibrated before being used for scenario analysis. While it is acceptable for the values to be different from the SSURGO database, there is no documentation explaining the rationale for the modifications from the original source. This is one of the examples that highlights lack of detailed documentation that would be useful to model users. Overall, the results indicate that different interfaces lead to different model simulation results and, therefore, the authors recommend users specify the interface used and any modifications made to the associated databases when reporting model results.
文摘The biophore model of sulfonylurea herbicides (the training set contains 31 compounds) was obtained by using the advanced APEX-3D method. On the basis of the identilied biophore model, the activities of some known ALS inhibitors were predicted.Most of the predictions were in good agreement with experiments. The quality of the biophore model has been proved to be reliable. This research suggests a new approach for designing the new series of ALS inhibitors.
