17P-WIND-0485: Lab 01 - Operation Research Software Packages

This assignment provides an introduction to several software packages used in operations research. It covers TORA, a GUI for database development and administration, including its features and background. LINGO, a comprehensive package for expressing and solving optimization models, is discussed, highlighting its uses and benefits. The document also introduces MS Excel, emphasizing its spreadsheet capabilities for data manipulation and analysis, along with its basic operations and tools. Finally, AMPL, an algebraic modeling language for complex mathematical problems, is presented, detailing its background, uses, and modeling language features. The objective is to familiarize the reader with these tools and their applications in the field of operations research, providing insights into their functionalities and capabilities for solving diverse problems. The assignment is contributed by a student and is available on Desklib, a platform for AI-based study tools.

Lab #01 1
Introduction to operation research software packages:
1.TORA 2. LINGO 3. AMPL 4. EXCEL
Introduction:
Operations research uses various optimization algorithms to help make decisions related to highly
complex problems. Operations research (OR) is an analytical method of problem-solving and decision-
making that is useful in the management of organizations. In operations research, problems are broken
down into basic components and then solved in defined steps by mathematical analysis.
Objective
.To be familier with operation research and softwares used to study it
Explanation:
TORA:
TOra is a free software database development and administration GUI, available under the GNU
General Public License. It features a PL/SQL debugger, an SQL worksheet with syntax
highlighting, a database browser and a comprehensive set of database administration tools. In
addition to Oracle Database support, support for MySQL, PostgreSQL and Teradata databases
has been added since the initial launch. It uses the Qt, and can use the qScintilla2 library. The
Oracle connector uses the Oracle Template Library. TOra was originally written by Henrik
Johnson and copyright by GlobeCom AB, which was acquired by Quest Software. Start of
conversion to being maintained as open source project was made on 2005-02-17 with version
1.3.15. QT4 conversion took place in 2009 with version 1.4.Background:
TORA is a free software database development and administration GUI, available under the GNU
General Public License. It features a PL/SQL debugger, an SQL worksheet with syntax highlighting, a
database browser and a comprehensive set of database administration tools
Feature:
 Handles multiple connections.
 Asynchronus database communication. UI mostly responsive when accessing database.
 Requires no installation on the database side to be fully functional.
 Advanced SQL worksheet.
 Code completion(temporarily disabled in version 3.0).
 Explain execution plan.
 Execution statistics.
 Parse error location indicion.
 Chart visualization of result.
Syed murad ali shah 17pwind0485 ORlab

Lab #01 2
 PL/SQL block parsing.
 Table & view editing.
Introduction to LINGO:
Lingo provides a completely integrated package that includes a powerful language for expressing
optimization models, a full featured environment for building and editing problems and a set of fast built
in solvers. lingo is a computer-aided optimization software that solves linear, non-linear, and mixed
integer linear and non-linear programs. It is developed by lingo Systems Inc. ... A trial version for
assessing the software may be downloaded from the lingo Systems web site
Background:
Lingo was invented by John H. Thompson at Macro Mind in 1989, and first released with Director 2.2.
Jeff Tanner developed and tested Lingo for Director 2.2 and 3.0, created custom X Objects for various
media device producers, language extension examples using X Factory including the X Factory
application programming interface (API), and wrote the initial tutorials on how to use Lingo. Dave
Shields tested and documented Object-based Lingo for Director 3.13 and 4.0. He ran build scripts to
create weekly releases for testing, originated the Macromedia Knowledge Base, created examples of how
to write Lingo XTRA plug-ins in C++, and assembled the Golden Master disks of Macromedia Director
that were shipped to the duplicator.
Uses:
 to create user interfaces,
 to make changes in raster graphics,
 learn about vector graphics and 3D computer graphics
Benefits:
Syed murad ali shah 17pwind0485 ORlab

Lab #01 3
 Easy Model Expression
 Convenient Data Options
 Powerful Solvers
 Model Interactively or Create
 Turn-key Applications
 Extensive Documentation
INTRODUCTION TO MS EXCEL
INTRODUCTION:
MS EXCEL is a powerful spreadsheet that is easy to use and allows you to store, manipulate, analyze,
and visualize data. It can handle maximum data. It save much time. Microsoft Excel is a spreadsheet
developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools,
pivot tables, and a macro programming language called Visual Basic for Applications
OBJECTIVE:
• To know about Excel’s basic operations and tools
• create simple worksheets
• Use formulas
• Format worksheets
• to use Excel’s functions
• Understand how to sort
Syed murad ali shah 17pwind0485 ORlab

Lab #01 4
Introduction to AMPL:
A Mathematical Programming Language (AMPL) is an algebraic modeling language to describe and
solve high-complexity problems for large-scale mathematical computing (i.e., large-scale optimization
and scheduling-type problems).
Background:
It was developed by Robert Fourier, David Gay, and Brian Kernighan at Bell Laboratories. AMPL
supports dozens of solvers, both open source and commercial software, including CBC, CPLEX, Fort
MP, Gurobi, MINOS, IPOPT, SNOPT, KNITRO, and LGO.
Uses:
AMPL integrates a modeling language for describing optimization data, variables, objectives, and
constraints; a command language for browsing models and analyzing results; and a scripting language for
gathering and manipulating data and for implementing iterative optimization schemes.
modeling language features:
 Broad support for sets and set operators. AMPL models can use sets of pairs, triples, and longer
tuples; collections of sets indexed over sets; unordered, ordered, and circular sets of objects; and
sets of numbers.
 General and natural syntax for arithmetic, logical, and conditional expressions; familiar
conventions for summations and other iterated operators.
 Automatic handling of linear and convex quadratic problems in continuous and integer variables.
Syed murad ali shah 17pwind0485 ORlab