spreadsheet

(redirected from planning system)
Also found in: Dictionary, Thesaurus, Financial.
Related to planning system: Planning permission

spreadsheet

a computer program that allows easy entry and manipulation of figures, equations, and text, used esp for financial planning and budgeting
Collins Discovery Encyclopedia, 1st edition © HarperCollins Publishers 2005

spreadsheet

(application, tool)
(Or rarely "worksheet") A type of application program which manipulates numerical and string data in rows and columns of cells. The value in a cell can be calculated from a formula which can involve other cells. A value is recalculated automatically whenever a value on which it depends changes. Different cells may be displayed with different formats.

Some spreadsheet support three-dimensional matrices and cyclic references which lead to iterative calculation.

An essential feature of a spreadsheet is the copy function (often using drag-and-drop). A rectangular area may be copied to another which is a multiple of its size. References between cells may be either absolute or relative in either their horizontal or vertical index. All copies of an absolute reference will refer to the same row, column or cell whereas a relative reference refers to a cell with a given offset from the current cell.

Many spreadsheets have a "What-if" feature. The user gives desired end conditions and assigns several input cells to be automatically varied. An area of the spreadsheet is assigned to show the result of various combinations of input values.

Spreadsheets usually incorporate a macro language, which enables third-party writing of worksheet applications for commercial purposes.

In the 1970s, a screen editor based calculation program called Visi-Calc was introduced. It was probably the first commercial spreadsheet program. Soon Lotus Development Corporation released the more sophisticated Lotus 1-2-3. Clones appeared, (for example VP-Planner from Paperback Software with CGA graphics, Quattro from Borland) but Lotus maintained its position with world-wide marketing and support - and lawyers! For example, Borland was forced to abandon its Lotus-like pop-up menu.

While still developing 1-2-3, Lotus introduced Symphony, which had simultaneously active windows for the spreadsheet, graphs and a word processor.

Microsoft produced MultiPlan for the Macintosh, which was followed by Excel for Macintosh, long before Microsoft Windows was developed.

When Microsoft Windows arrived Lotus was still producing the text-based 1-2-3 and Symphony. Meanwhile, Microsoft launched its Excel spreadsheet with interactive graphics, graphic charcters, mouse support and cut-and-paste to and from other Windows applications. To compete with Windows spreadsheets, Lotus launched its Allways add-on for 1-2-3 - a post-processor that produced Windows-quality graphic characters on screen and printer. The release of Lotus 1-2-3 for Windows was late, slow and buggy.

Today, Microsoft, Lotus, Borland and many other companies offer Windows-based spreadsheet programs.

The main end-users of spreadsheets are business and science.

Spreadsheets are an example of a non-algorithmic programming language.

This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

spreadsheet

Software that simulates a paper spreadsheet (worksheet), in which columns of numbers are summed for budgets and plans. It appears on screen as a matrix of rows and columns, the intersections of which are called "cells." The cells are filled with (1) labels, (2) numeric values or (3) formulas.

Labels are descriptive text such as "Rent" and "Gross Sales." Values are the actual numeric data, and formulas command the spreadsheet to do the calculations; for example, SUM CELLS A5 TO A10.


Labels, Values and Formulas
In this Microsoft Excel example, the labels are in cells A1, A2 and A3, and numeric values are in B1 and B2. The formula in B3 is "subtract B2 from B1." In Excel, typing the equals sign starts the formula creation.







The Formulas
Formulas are the spreadsheet's magic, and they are easy to create. You click a cell and then press the key (+, -, etc.) of the arithmetic operation that affects it. For example, the creation of a formula might be "the contents of this cell PLUS the contents of this cell DIVIDED BY the contents of this cell."

The Ripple Effect
After numbers are added or changed, the formulas recalculate the data automatically or with the press of a key. Since the contents of any cell can be calculated with or copied to any other cell, a total of one column can be used as a detail item in another column. For example, the total from a column of expense items can be carried over to a summary column showing all expenses. If the contents of a cell in the detail column changes, its column total changes, which is then copied to the summary column, and the summary total changes.

What If?
The ripple effect lets you create a plan, plug in different assumptions and immediately see the impact on the bottom line. This "what if?" capability makes the spreadsheet indispensable for budgets, plans and other equation-based tasks.

It Started with VisiCalc
One of the major forces behind the personal computer revolution in the 1980s, the spreadsheet originated with VisiCalc in 1978 for the Apple II, followed by SuperCalc, Multiplan, Lotus 1-2-3 and others. See VisiCalc, OLAP, analytical database engine and XL abc's.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
The company markets the RayStation treatment planning system and RayCare, the next-generation oncology information system, worldwide.
The planning system must be looked into as part of plans to make the UK Brexit-ready."
The Abu Dhabi Department of Urban Planning and Municipalities (DPM) is leading a project to develop a capital investment planning system (CIPS) that will automate processes and bring together all government capital projects across the emirate.
RaySearch markets the RayStation treatment planning system to clinics all over the world.
Toni Schiavone, Cymdeithas yr Iaith Gymraeg Sustainable Communities spokesperson, said the groups and individuals agree to support planning legislation that states the purpose of the planning system is to manage land in a way that's sustainable environmentally, that tackles poverty and promotes the Welsh language.
Also, the dedicated sales and support team at AlphaXRT are highly experienced in the field of radiation therapy treatment planning systems and serve all radiation therapy centres in Australia and New Zealand.
Hitachi is highly experienced in the field of radiation therapy treatment planning systems serving 300 Japanese radiation therapy centers with a dedicated sales and support unit with over 30 employees.
He said: "The real issue is that we're not building enough houses, and we're not building enough houses because we've got an antiquated planning system that's so bureaucratic." Morgan rejected claims the Government's Help to Buy scheme was fuelling a housing boom.
Chairman Steve Morgan said the group had 16,600 plots locKed in the planning system that could deliver about 120 new developments, but that only a "minority" were expected to progress in the next year due to the complex approval process.
This means that the system stands out as the most intuitive treatment planning system for creating all advanced radiation treatments.

Full browser ?