Modelling in Excel

What is Excel?

Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Excel Environment and Useful Features

• Objectives of the one day workshop
• Working in the Excel environment
• Setting up worksheets
• Formatting and entering formulas

One day financial modelling workshop. Basic functions and methods in Excel. Foundation for three day modelling workshop.

Excel Techniques 1

• Explanation of time value of money and financial mathematics
• Financial functions
• Naming cells
• Numbers and conditional formatting
• Producing a working financial calculator

Excel Techniques 2

• Combo boxes and controls
• Commenting cells
• Printing
• Data validation
• Buttons
• Recording simple macros
• Documenting and protecting
• Final working financial calculator

Presentation - Data, Tables and Charts

• Importing text data into Excel
• Linking to databases
• Sorting and ordering techniques
• Filters and subtotals
• Creating a dynamic summary
• Modifying and refreshing data in a pivot table
• Creating and customising a chart
• Questions and Answers

what is spreadsheet modelling?

A spreadsheet model uses a spreadsheet to explore different possible answers. These models are usually financial, mathematical or scientific. This is sometimes called “what if” modeling and shows what will happen to the results if you change some of the data within a spreadsheet. It can also be used to discover simple rules within the model. In the context of the examination, you may be asked to build a simple spreadsheet model and change data within the model, or even the model itself, to produce different results.

What are the advantages of using Excel Modelling?

Modeling of a problem in excel means - creating a generalized way of solving a problem. Modeling is different from solving problem for once as it is meant to be reusable, variables well defined to represent input and output, generalized and well explained, understandable to a general user ( of that domain). So precisely Excel Modeling means: 

1.creating a well structured model for a particular type or group of problems 

2. It is reusable 

3. It is generalized

4. Result /output is well structured

The systems life cycle

The Systems development life cycle (SDLC), or Software development process in systems engineering, information systems and software engineering, is a process of creating or altering information systems, and the models and methodologies that people use to develop these systems. In software engineering, the SDLC concept underpins many kinds of software development methodologies. These methodologies form the framework for planning and controlling the creation of an information system^[1]: the software development process.

the system life cycle is a process of stages which occur during the development of a new ICT system.

The systems life cycle (SLC) is a methodology used to describe the process for building information systems, intended to develop information systems in a very deliberate, structured and methodical way, reiterating each stage of the life cycle. The systems development life cycle, according to Elliott & Strachan & Radford (2004), "originated in the 1960's,to develop large scale functional business systems in an age of large scale business conglomerates. Information systems activities revolved around heavy data processing and number crunching routines

Publishing ICT NEWSPAPER

difference between air conditioner and central air conditioner

How does an air conditioner work?

An air conditioner transfers heat from the inside of a building, where it is not wanted, to the outside. Refrigerant in the system absorbs the excess heat and is pumped through a closed system of piping to an outside coil. A fan blows outside air over the hot coil, transferring heat from the refrigerant to the outdoor air.  Because the heat is removed from the indoor air, the indoor area is cooled.

 How does an central air conditioner work?

Central air conditioners have two separate components: the condenser and the evaporator. The condenser unit is usually located outside the house on a concrete slab. The evaporator coil is mounted in the plenum or main duct junction above the furnace.

Most central air conditioners are connected to a home's forced-air distribution system. Thus, the same motor, blower, and ductwork used for heating are used to distribute cool air from the air conditioning system. When a central air conditioner is operating, hot air inside the house flows to the furnace through the return-air duct. The hot air is moved by the blower across the cooled evaporator coil in the plenum and is then delivered through ducts to cool the house. When the air conditioner works but the house doesn't cool, the problem is probably in the distribution system.

disadvantages of robotic surgery

DISADVANTAGES:

• >> Robotic surgery is a new technology and its uses and efficacy have not yet been well established.
• >>It is costly and affordability would be limited.
• >>The size of the systems have relatively large footprints and relatively cumbersome robotic arms.Use in smaller patients will be be difficult.
• >>The size could also alter the direct access to the patient during surgery.