期刊名称:International Journal of Computer and Information Technology
印刷版ISSN:2279-0764
出版年度:2013
卷号:2
期号:5
页码:1026
出版社:International Journal of Computer and Information Technology
摘要:The paper presents applications in Excel 2010 that are implemented in economic activity in the modern society of today and tomorrow. If you have planned the distribution of goods from production to consumption we use transport problems. As we know linear programming represents a method of problem solving decision problems. It presented also an allocation problem that it can occur in various decision-making situations like: allocation works on machines, assignment of personnel in various regional centers, distributions agents to perform certain activities. Many real-life projects are complex and expensive and their production on time and within budget is not of any task. Typical certain activities cannot start before the other to finish. Decision problems containing uncertainty is not known when the likelihood of states of nature. These problems can be addressed in several ways, and accordingly there are several decision criteria. Because it by applying various criteria can get different advice is good decision agent to understand very well the existing criteria and to select the one that fits best, adverse to the best gain. In conclusion it presented application for: regret criterion, optimist criterion and pessimist criterion. It presented decisional analysis problems using solver. In Microsoft Excel 2010 are available a lot of categories of functions like: functions or type date and time, financial functions, logic functions, mathematical and trigonometric functions, statistical functions, database functions, external functions, engineering functions and user-defined functions. It also presented charts, applications with scenarios, goal seek, solver, pivot table and lists
关键词:component: solver; pivot tables; lists; charts; ; scenarios; allocation problem; project management; data and time ; functions; financial functions; logic functions; mathematical and ; trigonometric functions; statistical functions; database functions; ; engineering functions; user-defined functions