论文部分内容阅读
设计合理的决策支持系统(DSS)是一种基于软件的互动系统,旨在帮助决策者根据不同来源定义和解决问题,编译有用的信息。基于农场提供的最大增氧效率的有效数据,利用MicrosoftExcel2007电子表格设计了一款用于鱼塘机械增氧工艺管理的决策支持系统。该系统的使用将有助于农民和推广人员选择高效的增氧机和确定机组数量,并且在保证各鱼塘保持溶解氧含量在安全范围内的情况下,算得各鱼塘增氧机的功率和运转时间。电子表格方式适合于3种温水生长的鱼,分别为罗非鱼、梭鱼和鲤鱼。在设定实地条件下,电子表格计算结果与参考数据进行比较,结果表明电子表格结果符合参考值。在田间以机械(MAP)和非机械(NMAP)增氧数据对电子表格进行验证。利用该系统管理MAP能增产3.3%,与NMAP相比还节省了61.80%的水交换。试验结果表明,对于不同池塘水环境和鱼种类,决策支持系统精度提高的进一步研究中可以应用电子表格。
Well-designed Decision Support System (DSS) is a software-based interactive system designed to help decision makers to compile useful information based on different sources of definition and problem solving. Based on valid data on the maximum aeration efficiency provided by farms, a decision support system for fish tank mechanical aeration process management was designed using the Microsoft Excel 2007 spreadsheet. The use of this system will help farmers and extension workers to select efficient aerators and determine the number of units and, at the same time guaranteeing that dissolved oxygen levels in all fish ponds are within safe limits, calculate the power of the aerator in each fish pond And running time. The spreadsheet approach is suitable for three species of warm-blooded fish, tilapia, barracuda and carp. When setting the field conditions, the spreadsheet calculation result is compared with the reference data, and the result shows that the spreadsheet result accords with the reference value. Spreadsheet validation with both mechanical (MAP) and non-mechanical (NMAP) aerobic data in the field. Using this system to manage MAP increased production by 3.3%, saving 61.80% of the water exchange compared to NMAP. The experimental results show that spreadsheets can be applied to further studies on the accuracy of decision support systems for different pond water environments and fish species.