FACTOID # 23: Wisconsin has more metal fabricators per capita than any other state.
 
 Home   Encyclopedia   Statistics   States A-Z   Flags   Maps   FAQ   About 
   
 
WHAT'S NEW
RELATED ARTICLES
People who viewed "Spreadsheet" also viewed:
 

SEARCH ALL

FACTS & STATISTICS    Advanced view

Search encyclopedia, statistics and forums:

 

 

(* = Graphable)

 

 


Encyclopedia > Spreadsheet

A spreadsheet is a computer application that simulates a paper worksheet. It displays multiple cells that together make up a grid consisting of rows and columns, each cell containing either alphanumeric text or numeric values. A spreadsheet cell may alternatively contain a formula that defines how the contents of that cell is to be calculated from the contents of any other cell (or combination of cells) each time any cell is updated. Spreadsheets are frequently used for financial information because of their ability to re-calculate the entire sheet automatically after a change to a single cell is made. Application has the following meanings: In general, an application is using something general to some more conrete. ... Generally speaking, the term alphanumeric refers to anything that consists of only letters and numbers. ... In mathematics and in the sciences, a formula (plural: formulae, formulæ or formulas) is a concise way of expressing information symbolically (as in a mathematical or chemical formula), or a general relationship between quantities. ... FINANCIAL is the weekly English-language newspaper with offices in Tbilisi, Georgia and Kiev, Ukraine. ...


In 1971, Rene K. Pardo and Remy Landau filed a patent on a spreadsheet related algorithm. Visicalc is usually considered the first electronic spreadsheet (although this has been challenged), and it helped turn the Apple II computer into a success and greatly assisted in their widespread application. Lotus 1-2-3 was the leading spreadsheet of DOS era. Excel is now generally considered to have the largest market share. VisiCalc was the first spreadsheet program available for personal computers. ... The 1977 Apple II, complete with integrated keyboard, color graphics, sound, a plastic case and eight expansion slots. ... Lotus 1-2-3 is a spreadsheet program from Lotus Software (now part of IBM). ... This article is about the family of closely related operating systems for the IBM PC compatible platform. ... Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS. It features calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. ...

Contents

History

Paper spreadsheets

The word "spreadsheet" came from "spread" in its sense of a newspaper or magazine item (text and/or graphics) that covers two facing pages, extending across the center fold and treating the two pages as one large one. The compound word "spread-sheet" came to mean the format used to present book-keeping ledgers—with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were, traditionally, a "spread" across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper ruled into rows and columns in that format and approximately twice as wide as ordinary paper. Book keeping normally refers to the practice of keeping accounting records, but it is also a common euphemism for working as a bookmaker or bookie. ... The general ledger, sometimes known as the nominal ledger, is the main accounting record of a business which uses double-entry bookkeeping. ...


Early implementations

Batch spreadsheet report generators

The concept of an electronic spreadsheet was outlined in the 1961 paper "Budgeting Models and System Simulation" by Richard Mattessich. The subsequent work by Mattessich (1964a, Chpt. 9, Accounting and Analytical Methods) and its companion volume, Mattessich (1964b, Simulation of the Firm through a Budget Computer Program) applied computerized spreadsheets to accounting and budgeting systems (on main-frame computers in FORTRAN IV). Batch Spreadsheets dealt primarily with the addition or subtraction of entire columns or rows - rather than individual cells.


LANPAR spreadsheet compiler

Key invention in the development of electronic spreadsheets was made by Rene K. Pardo and Remy Landau, who filed in 1971 U.S. Patent 4,398,249  on spreadsheet automatic natural order recalculation algorithm in 1970. While the patent was initially rejected by the patent office as being a purely mathematical invention, following 12 years of Appeals, Pardo and Landau won a landmark court case at the CCPA (Predecessor Court of the Federal Circuit) overturning the Patent Office in 1983 with the world's first software patent - establishing that "something does not cease to become patentable merely because the point of novelty is in an algorithm." This case helped establish the viability of software patents. Flowcharts are often used to graphically represent algorithms. ... Software patent does not have a universally accepted definition. ...


The actual software was called LANPAR - LANguage for Programming Arrays at Random. This was conceived and entirely developed in the summer of 1969 following Pardo and Landau's recent graduation from Harvard University. Co-inventor Rene Pardo recalls that he felt that one manager at Bell Canada should not have to depend on programmers to program and modify budgeting forms, and he thought of letting users type out forms in any order and having computer calculating results in the right order. The software was developed in 1969.[1]


LANPAR was used by Bell Canada, AT&T and the 18 operating telcos nationwide for their local and national budgeting operations. LANPAR was also used by General Motors. Its uniqueness was the incorporation of natural order recalculation,[2] as opposed to left-to-right, top to bottom sequence for calculating the results in each cell that was used by Visicalc, Supercalc and the first version of Multiplan. Without natural order recalculation the users had to manually recalculate the spreadsheet as many times as necessary until the values in all the cells had stopped changing.


The LANPAR system was implemented on GE400 and Honeywell 6000 on line timesharing systems enabling users to program remotely via computer terminals and modems. Data could be entered dynamically either by paper tape, specific file access, on line, or even external data bases. Sophisticated mathematical expressions including logical comparisons and "if/then" statements could be used in any cell, and cells could be presented in any order.


Autoplan/Autotab spreadsheet programming language

In 1968, three former employees from the General Electric computer company headquartered in Phoenix, Arizona set out to start their own software development house. A. Leroy Ellison, Harry N. Cantrell, and Russell E. Edwards found themselves doing a large number of calculations when making tables for the business plans that they were presenting to venture capitalists. They decided to save themselves a lot of effort and wrote a computer program that produced their tables for them. This program, originally conceived as a simple utility for their personal use, would turn out to be the first software product offered by the company that would become known as Capex Corporation. "AutoPlan" ran on GE’s Time-sharing service; afterward, a version that ran on IBM mainframes was introduced under the name "AutoTab". (National CSS offered a similar product, CSSTAB, which had a moderate timesharing user base by the early 70s. A major application was opinion research tabulation.) AutoPlan/AutoTab was not a WYSIWYG interactive spreadsheet program, it was a simple scripting language for spreadsheets. The user defined the names and labels for the rows and columns, then the formulas that defined each row or column. GE redirects here. ... Nickname: Location in Maricopa County and the state of Arizona Coordinates: , Country State County Maricopa Incorporated February 25, 1881 Government  - Type Council-Manager  - Mayor Phil Gordon (D) Area  - City  515. ... Capex Corporation was a Software house based in Phoenix, Arizona founded by three ex employees of GE Corporation. ... Alternate uses: see Timesharing Time-sharing is an approach to interactive computing in which a single computer is used to provide apparently simultaneous interactive general-purpose computing to multiple users by sharing processor time. ... SAS 8 on an IBM mainframe, seen here via one of its user interfaces, classic 3270 emulation. ... [NCSS alumni with access to archives of publications and sources are encouraged to expand on the following material. ... For the Chumbawamba album, see WYSIWYG (album). ... There are several conceptual views of interactivity, the most general being the contingency view. ...


Interactive spreadsheets

Interactive spreadsheets became possible when computer displays became available. Except for LANPAR- which allowed many users in real time and online to timesharing systems to simultaneously program or run their spreadsheets from their computer terminals across the country - earlier implementations were mainly designed around batch programs and certainly none of these batch programs allowed for forward referencing of cells or natural order recalculation. In the early 1970s text based computer displays began to be used as input/output devices for interactive transaction processes. This was sufficient for early interactive spreadsheets to be implemented. The lack of on-line historical material relating to such systems, and their limited coverage in academic and commercial publications, makes it hard to assess their level of innovation and ultimate impact. A computer display monitor, usually called simply a monitor, is a piece of electrical equipment which displays viewable images generated by a computer without producing a permanent record. ...


APLDOT modeling language

An example of an early "industrial weight" spreadsheet was APLDOT, developed in 1976 at the United States Railway Association on an IBM 360/91, running at The Johns Hopkins University Applied Physics Laboratory in Laurel, MD.[3] The application was used successfully for many years in developing such applications as financial and costing models for the US Congress and for Conrail. APLDOT was dubbed a "spreadsheet" because financial analysts and strategic planners used it to solve the same problems they addressed with paper spreadsheet pads. The United States Railway Association was the Corporation created by federal law that oversaw Conrail. ... Conrail 6114, a GE Dash 8-40CW, leads a train westbound out of Altoona, Pennsylvania. ...


VisiCalc

The spreadsheet concept became widely known in the late 1970s and early 1980s because of Dan Bricklin's implementation of VisiCalc. VisiCalc was the first spreadsheet that combined all essential features of modern spreadsheet applications, such as WYSIWYG interactive user interface, automatic recalculation, status and formula lines, range copying with relative and absolute references, formula building by selecting referenced cells. PC World magazine has called VisiCalc the first electronic spreadsheet.[4] Daniel S. Bricklin (born 16 July 1951) is the co-creator, with Bob Frankston, of the VisiCalc spreadsheet program. ... VisiCalc was the first spreadsheet program available for personal computers. ... For the Chumbawamba album, see WYSIWYG (album). ... PC World is a global computer magazine published monthly by IDG. It offers advice on various aspects of PCs and related items, the Internet, and other personal-technology products and services. ...


Bricklin has spoken of watching his university professor create a table of calculation results on a blackboard. When the professor found an error, he had to tediously erase and rewrite a number of sequential entries in the table, triggering Bricklin to think that he could replicate the process on a computer, using the blackboard as the model to view results of underlying formulas. His idea became VisiCalc, the first application that turned the personal computer from a hobby for computer enthusiasts into a business tool. VisiCalc was the first spreadsheet program available for personal computers. ... Application software is a subclass of computer software that employs the capabilities of a computer directly and thoroughly to a task that the user wishes to perform. ...

Screenshot of VisiCalc, the first PC spreadsheet.
Screenshot of VisiCalc, the first PC spreadsheet.

VisiCalc went on to become the first "killer app", an application that was so compelling, people would buy a particular computer just to own it. In this case the computer was the Apple II, and VisiCalc was no small part in that machine's success. The program was later ported to a number of other early computers, notably CP/M machines, the Atari 8-bit family and various Commodore platforms. Nevertheless, VisiCalc remains best known as "an Apple II program". Image File history File links VisiCalc_(IBM_PC's_Killer_Application). ... Image File history File links VisiCalc_(IBM_PC's_Killer_Application). ... A killer application (commonly shortened to killer app) is a computer program that is so useful that people will buy a particular computer hardware, gaming console, and/or an operating system simply to run that program. ... The Apple II was one of the most popular personal computers of the 1980s. ... In computer science, porting is the adaptation of a piece of software so that it will function in a different computing environment to that for which it was originally written. ... CP/M is an operating system originally created for Intel 8080/85 based microcomputers by Gary Kildall of Digital Research, Inc. ... An Atari 800XL, one of the most popular machines in the series. ... Commodore, the commonly used name for Commodore International, was an American electronics company based in West Chester, Pennsylvania which was a vital player in the home/personal computer field in the 1980s. ...


Lotus 1-2-3 and other MS-DOS spreadsheets

The acceptance of the IBM PC following its introduction in August, 1981, began slowly, because most of the programs available for it were ports from other 8-bit platforms. Things changed dramatically with the introduction of Lotus 1-2-3 in November, 1982, and release for sale in January, 1983. It became that platform's killer app, and drove sales of the PC due to the improvements in speed and graphics compared to VisiCalc. IBM PC (IBM 5150) with keyboard and green screen monochrome monitor (IBM 5151), running MS-DOS 5. ... Lotus 1-2-3 is a spreadsheet program from Lotus Software (now part of IBM). ...


Lotus 1-2-3, along with its competitor Borland Quattro, soon displaced VisiCalc. Lotus 1-2-3 was released on January 26, 1983, started outselling then-most-popular VisiCalc the very same year, and for a number of years was the leading spreadsheet for DOS. Borland Software Corporation is a software company headquartered in Austin, Texas. ... Quattro Pro is a spreadsheet program developed by Borland and now sold by Corel, most often as part of Corels WordPerfect Office. ... is the 26th day of the year in the Gregorian calendar. ... For the Jimi Hendrix song, see 1983. ... VisiCalc was the first spreadsheet program available for personal computers. ... This article is about the family of closely related operating systems for the IBM PC compatible platform. ...


Microsoft Excel

Microsoft had been developing Excel on the Macintosh platform for several years at this point, where it had developed into a fairly powerful system. A port of Excel to Windows 2.0 resulted in a fully functional Windows spreadsheet. The more robust Windows 3.x platforms of the early 1990s made it possible for Excel to take market share from Lotus. By the time Lotus responded with usable Windows products, Microsoft had started compiling their Office suite. Starting in the mid 1990s continuing through 2008, Microsoft Excel has dominated the commercial spreadsheet market. Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS. It features calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. ... The first Macintosh computer, introduced in 1984, upgraded to a 512K Fat Mac. The Macintosh or Mac, is a line of personal computers designed, developed, manufactured, and marketed by Apple Computer. ... Microsoft Office is an office suite from Microsoft for Microsoft Windows and Apple Mac OS X operating systems. ...


Apple Numbers

Numbers is Apple Inc.'s spreadsheet software, part of iWork. It focuses on usability and the elegance of chart presentation. Numbers completed Apple's productivity suite, making it a viable competitor to Microsoft Office. Since it is a 1.0 product, it lacks features such as Pivot tables. Numbers is a spreadsheet application developed by Apple Inc. ... Apple Inc. ... iWork is a suite of applications created by Apple Inc. ... Microsoft Office is an office suite from Microsoft for Microsoft Windows and Apple Mac OS X operating systems. ... A pivot table is a powerful data summarization tool found in spreadsheet programs. ...


OpenOffice.org

OpenOffice.org Calc is a freely available, open-source program modelled after Microsoft Excel. Calc can both open and save in the Excel (XLS) file format.[citation needed] Calc can be acquired as both an installation file and a portable program, capable of being run from a device such as a USB memory drive. It can be downloaded from the OpenOffice.org website. OpenOffice. ... Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS. It features calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. ...


Web based spreadsheets

With the advent of advanced web technologies such as Ajax circa 2005, a new generation of online spreadsheets has emerged. Equipped with a rich Internet application user experience, the best web based online spreadsheets have many of the features seen in desktop spreadsheet applications. Some of them have strong multi-user collaboration features. Some of them offer real time updates from remote sources such as stock prices and currency exchange rates. The World Wide Web and WWW redirect here. ... AJAX redirects here. ... This is a list of online spreadsheets. ... For the geographical term, see ria. ... It has been suggested that Real-time computing be merged into this article or section. ... See stock (disambiguation) for other meanings of the term stock In financial terminology, stock is the capital raised by a corporation, through the issuance and sale of shares. ...


Other products

A number of companies have attempted to break into the spreadsheet market with programs based on very different paradigms. Lotus introduced what is likely the most successful example, Lotus Improv, which saw some commercial success, notably in the financial world where its powerful data mining capabilities remain well respected to this day. Spreadsheet 2000 attempted to dramatically simplify formula construction, but was generally not successful. Lotus Improv was a spreadsheet program from Lotus Development that took the n-dimesional modeling design and hierarchic UI of Javelin and moved it to modern platforms. ... Data mining is the process of sorting through large amounts of data and picking out relevant information. ... Spreadsheet 2000 was a spreadsheet program for Apple Macintosh computers, published by Casady and Greene, a distributer of many smaller Mac releases. ...

  • A list of old spreadsheet software
    • Advantage
    • Boeing Calc 3D
    • Lotus Improv[5]
    • Javelin Software
    • Lotus Jazz for Macintosh
    • Lucid 3D
    • MultiPlan
    • PowerStep for NeXT Step
    • ProCalc
    • Borland's Quattro Pro
    • Silk
    • SuperCalc
    • Surpass
    • Lotus Symphony
    • TWIN
    • TurboCalc
    • VP Planner
    • Wingz for Macintosh
    • Target Planner Calc for CP/M and TRS-DOS[6][7]

Javelin Software Corporation (1984-1988) was a company in Cambridge, Massachusetts which developed an innovative DOS-based modeling product, also called Javelin, and later Javelin Plus. ... Quattro Pro is a spreadsheet program developed by Borland and now sold by Corel, most often as part of Corels WordPerfect Office. ...

Concepts

Cells

A "cell" can be thought of as a box for holding a datum. A single cell is usually referenced by its column and row (A2 would represent the cell below containing the value 10). Its physical size can usually be tailored for its content by dragging its height or width at box intersections (or for entire columns or rows by dragging the column or rows headers). It has been suggested that this article or section be merged with Geodetic system. ...

My Spreadsheet
A B C D
01 value1 value2 added multiplied
02 10 20 30 200

An array of cells is called a "sheet" or "worksheet". It is analogous to an array of variables in a conventional computer program (although certain unchanging values, once entered, could be considered, by the same analogy, constants). In most implementations, many worksheets may be located within a single spreadsheet. A worksheet is simply a subset of the spreadsheet divided for the sake of clarity. Functionally, the spreadsheet operates as a whole and all cells operate as global variables within the spreadsheet ('read' access only except its own containing cell). For the microarray in genetics, see SNP array. ... In computer science and mathematics, a variable (pronounced ) (sometimes called an object or identifier in computer science) is a symbolic representation used to denote a quantity or expression. ... A computer program is a collection of instructions that describe a task, or set of tasks, to be carried out by a computer. ... In mathematics and the mathematical sciences, a constant is a fixed, but possibly unspecified, value. ... In computer programming, a global variable is a variable that is accessible in every scope. ...


A cell may contain a value or a formula, or it may simply be left empty. By convention, formulas usually begin with = sign. In computer science, a value is a sequence of bits that is interpreted according to some data type. ... In mathematics and in the sciences, a formula (plural: formulae, formulæ or formulas) is a concise way of expressing information symbolically (as in a mathematical or chemical formula), or a general relationship between quantities. ...


Values

A value can be entered from the computer keyboard by directly typing into the cell itself. Alternatively, a value can be based on a formula (see below), which might perform a calculation, display the current date or time, or retrieve external data such as a stock quote or a database value.

The Spreadsheet Value Rule Computer scientist Alan Kay used the term value rule to summarize a spreadsheet's operation: a cell's value relies solely on the formula the user has typed into the cell.[8] The formula may rely on the value of other cells, but those cells are likewise restricted to user-entered data or formulas. There are no 'side effects' to calculating a formula: the only output is to display the calculated result inside its occupying cell. There is no natural mechanism for permanently modifying the contents of a cell unless the user manually modifies the cell's contents. In the context of programming languages, this yields a limited form of first-order functional programming.[9] Alan Curtis Kay (born May 17, 1940) is an American computer scientist, known for his early pioneering work on object-oriented programming and windowing graphical user interface design. ... Functional programming is a programming paradigm that treats computation as the evaluation of mathematical functions and avoids state and mutable data. ...

Automatic recalculation

A standard of spreadsheets since the mid 80s[citation needed], this optional feature eliminates the need to manually request the spreadsheet program to recalculate values (nowadays typically the default option unless specifically 'switched off' for large spreadsheets, usually to improve performance). Some earlier spreadsheets required a manual request to recalculate, since recalculation of large or complex spreadsheets often reduced data entry speed. Many modern spreadsheets still retain this option.


Real time update

This feature refers to updating a cell's contents periodically when its value is derived from an external source - such as a cell in another "remote" spreadsheet. For shared, web-based spreadsheets, it applies to "immediately" updating cells that have been altered by another user. All dependent cells have to be updated also.


Formula

Animation of a simple spreadsheet that adds two values keyed into A1 and A2, showing the result in A3. The "formula" is keyed into A3
Animation of a simple spreadsheet that adds two values keyed into A1 and A2, showing the result in A3. The "formula" is keyed into A3

When a cell contains a formula, it often contains references to other cells. Such a cell reference is a type of variable. Its value is the value of the referenced cell or some derivation of it. If that cell in turn references other cells, the value depends on the values of those.


By convention, the left hand side, of what is normally considered a formula, is omitted and assumed to be the cell itself.


In the above example the formula in the cell "C2" might be either:-

  • =A2+B2 or
  • =SUM(A2:B2) (A2 is start of a cell range and B2 its end).

A formula identifies the calculation needed to place the result in the cell it is contained within. A cell containing a formula therefore has two display components; the formula itself and the resulting value. The formula is normally only shown when the cell is selected by "clicking" the mouse over a particular cell; otherwise it contains the result of the calculation (in this case 30). (A common error in spreadsheet usage is when a cell, previously holding a formula, is accidentally directly over-keyed by a value from the keyboard. Most modern spreadsheets allow selective "locking" of cells to prevent this, though many users do not take advantage of this feature.) For the card game, see Calculation (game). ...


The available options for valid formulas depends on the particular spreadsheet implementation but, in general, most arithmetic operations and quite complex nested conditional operations can be performed by most of today's commercial spreadsheets. Modern implementations also offer functions to access remote data and applications.


A formula may contain a condition (or nested conditions) - with or without an actual calculation - and is sometimes used purely to identify and highlight errors. In the example below, it is assumed the sum of a column of percentages (A1 through A6) is tested for validity and an explicit message put into the adjacent right hand cell.

 =IF(sum(A1:A6) > 100, "More than 100%",sum(A1:A6)) 

A spreadsheet does not, in fact, have to contain any formulas at all, in which case it could be considered merely a collection of data arranged in rows and columns (a database) like a calendar, timetable or simple list. Because of its ease of use, formatting and hyperlinking capabilities, many spreadsheets are used solely for this purpose. This article is about computing. ... A hyperlink, or simply a link, is a reference in a hypertext document to another document or other resource. ...


Locked cell

Once entered, selected cells (or the entire spreadsheet) can optionally be "locked" to prevent accidental overwriting. Typically this would apply to cells containing formulae but might be applicable to cells containing "constants" such as a kilogram/pounds conversion factor (2.20462262 to eight decimal places).


Data format

A cell or range can optionally be defined to specify how the value is displayed. The default display format is usually set by its initial content if not specifically previously set, so that for example "31/12/2007" or "31 Jan 2007" would default to the cell format of "date". Similarly adding a % sign after a numeric value would tag the cell as a percentage cell format. The cell contents are not changed by this format, only the displayed value. In mathematics, a percentage is a way of expressing a number as a fraction of 100 (per cent meaning per hundred). It is often denoted using the percent sign, %. For example, 45% (read as forty-five percent) is equal to 45 / 100, or 0. ...


Some cell formats such as "numeric" or "currency" can also specify the number of decimal places. Decimal, or denary, notation is the most common way of writing the base 10 numeral system, which uses various symbols for ten distinct quantities (0, 1, 2, 3, 4, 5, 6, 7, 8 and 9, called digits) together with the decimal point and the sign symbols + (plus) and − (minus) to...


This can allow invalid operations (such as doing multiplication on a cell containing a date), resulting in illogical results without an appropriate warning.


Text format

Each cell (like its counterpart the "word" in a word processor) can be separately defined in terms of its displayed format. Any cell or range of cells can be highlighted in several different ways such as use of bold text, colour, font, text size and so on. A word processor (also more formally known as a document preparation system) is a computer application used for the production (including composition, editing, formatting, and possibly printing) of any sort of viewable or printed material. ...


These attributes typically do not alter the data content in any way and some formatting may be lost or altered when copying spreadsheet data between different implementations or software versions. In some implementations, the format may be conditional upon the data within the cell - for example, a value may be displayed red if it is negative. Look up attribute in Wiktionary, the free dictionary. ...


Named cells

In most implementations, a cell can be "named" so that even if the cell is "cut and pasted" to a new location within the spreadsheet, its reference always remains intact. Names must be unique within the spreadsheet and, once defined, can then be used instead of a "normal" cell reference.


Cell reference

A cell reference is the name of some cell in some spreadsheet. Most cell references indicate another cell in the same spreadsheet, but a cell reference can also refer to a cell in a different sheet within the same spreadsheet, or (depending on the implementation) to a cell in another spreadsheet entirely, or to a value from a remote application.


A typical cell reference in "A1" style consists of one or two case-insensitive letters to identify the column (if there are up to 256 columns: A-Z and AA-IV) followed by a row number (e.g. in the range 1-65536). Either part can be relative (it changes when the formula it is in is moved or copied), or absolute (indicated with $ in front of the part concerned of the cell reference). The older "R1C1" reference style consists of the letter R, the row number, the letter C, and the column number; relative row or column numbers are indicated by enclosing the number in square brackets. Most current spreadsheets use the A1 style, some providing the R1C1 style as a compatibility option.


When the computer calculates a formula in one cell to update the displayed value of that cell, cell reference(s) in that cell, naming some other cell(s), cause the computer to fetch the value of the named cell(s).


A cell on the same "sheet" is usually addressed as:-

 =A1 

A cell on a different sheet of the same spreadsheet is usually addressed as:-

 =SHEET2!A1 (that is; the first cell in sheet 2 of same spreadsheet). 

Some spreadsheet implementations allow a cell references to another spreadsheet (not the current open and active file) on the same computer or a local network. It may also refer to a cell in another open and active spreadsheet on the same computer or network that is defined as shareable. These references contain the complete filename, such as:-

 ='C:Documents and SettingsUsernameMy spreadsheets[main sheet]Sheet1!A1 

In a spreadsheet, references to cells are automatically updated when new rows or columns are inserted or deleted. Care must be taken however when adding a row immediately before a set of column totals to ensure that the totals reflect the additional rows values - which often they do not!


A circular reference occurs when the formula in one cell has a reference that directly -- or indirectly, through a chain of references, each one pointing to another cell that has another reference to the next cell on the chain -- points to the one cell. Many common kinds of errors cause such circular references. However, there are some valid techniques that use such circular references. Such techniques, after many recalculations of the spreadsheet, (usually) converge on the correct values for those cells. A circular reference, sometimes referred to as a run-around, is a series of references where the last object references the first, thus causing the whole series of references to be unusable. ...


Cell Ranges

A reference to a range of cells is typically of the form (A1:A6) which specifies all the cells in the range A1 through to A6. A formula such as "=Sum(A1:A6)" would add all the cells specified and put the result in the cell containing the formula itself.


Sheets

In the earliest spreadsheets, cells were a simple two-dimensional grid. Over time, the model has been expanded to include a third dimension, and in some cases a series of named grids, called sheets. The most advanced examples allow inversion and rotation operations which can slice and project the data set in various ways.


Remote Spreadsheet

Whenever a reference is made to a cell or group of cells that are not located within the current physical spreadsheet file, it is considered as accessing a "remote" spreadsheet. The contents of the referenced cell may be accessed either on first reference with a manual update or more recently in the case of web based spreadsheets, as a near real time value with a specified automatic refresh interval.


Charts

An example histogram of the heights of 31 Black Cherry trees.
An example histogram of the heights of 31 Black Cherry trees.

Many spreadsheet applications permit charts, graphs or histograms to be generated from specified groups of cells which are dynamically re-built as cell contents change. The generated graphic component can either be embedded within the current sheet or added as a separate object. Binomial name Prunus serotina Ehrh. ... This article does not cite any references or sources. ... For the histograms usage in digital image processing, see Image histogram and Color histogram. ...


Programming issues

Just as the early programming languages were designed to generate spreadsheet printouts, programming techniques themselves have evolved to process tables (also known as spreadsheets or matrices) of data more efficiently in the computer itself. In mathematics, a matrix (plural matrices) is a rectangular table of elements (or entries), which may be numbers or, more generally, any abstract quantities that can be added and multiplied. ...


Spreadsheets have evolved into powerful programming languages; specifically, they are functional, visual, and multiparadigm languages. Functional programming is a programming paradigm that treats computation as the evaluation of mathematical functions and avoids state and mutable data. ... Visual Programming in Mindscript A Visual programming language (VPL) is any programming language that lets users specify programs by manipulating program elements graphically rather than by specifying them textually. ... This does not cite any references or sources. ...


Many people find it easier to perform calculations in spreadsheets than by writing the equivalent sequential program. This is due to two traits of spreadsheets.

  • They use spatial relationships to define program relationships. Like all animals, humans have highly developed intuitions about spaces, and of dependencies between items. Sequential programming usually requires typing line after line of text, which must be read slowly and carefully to be understood and changed.
  • They are forgiving, allowing partial results and functions to work. One or more parts of a program can work correctly, even if other parts are unfinished or broken. This makes writing and debugging programs much easier, and faster[citation needed]. Sequential programming usually needs every program line and character to be correct for a program to run. One error usually stops the whole program and prevents any result.

A spreadsheet program is designed to perform general computation tasks using spatial relationships rather than time as the primary organizing principle[citation needed]. This article is about the idea of space. ... Intuition is an unconscious form of knowledge. ...


It is often convenient to think of a spreadsheet as a mathematical graph, where the nodes are spreadsheet cells, and the edges are references to other cells specified in formulas. This is often called the dependency graph of the spreadsheet. References between cells can take advantage of spatial concepts such as relative position and absolute position, as well as named locations, to make the spreadsheet formulas easier to understand and manage. This article just presents the basic definitions. ...


Spreadsheets usually attempt to automatically update cells when the cells on which they depend have been changed. The earliest spreadsheets used simple tactics like evaluating cells in a particular order, but modern spreadsheets compute a minimal recomputation order from the dependency graph. Later spreadsheets also include a limited ability to propagate values in reverse, altering source values so that a particular answer is reached in a certain cell. Since spreadsheet cells formulas are not generally invertible, though, this technique is of somewhat limited value.


Many of the concepts common to sequential programming models have analogues in the spreadsheet world. For example, the sequential model of the indexed loop is usually represented as a table of cells, with similar formulas (normally differing only in which cells they reference). In computer science a for loop is a programming language statement which allows code to be repeatedly executed. ...


Shortcomings

While spreadsheets are a great step forward in quantitative modeling, they have deficiencies. At the level of overall user benefits, spreadsheets have three main shortcomings.

  • Spreadsheets have significant reliability problems. Research studies estimate that roughly 94% of spreadsheets deployed in the field contain errors, and 5.2% of cells in unaudited spreadsheets contain errors.[10]
  • The practical expressiveness of spreadsheets is limited. Several factors contribute to this limitation. Implementing a complex model requires implementing detailed layouts, cell-at-a-time. Authors have difficulty remembering the meanings of hundreds or thousands of cell addresses that appear in formulas.[citation needed]
  • Productivity of spreadsheet modelers is reduced by the cell-level focus of spreadsheets. Even conceptually simple changes in spreadsheets (such as changing starting or ending time or time grain, adding new members or a level of hierarchy to a dimension, or changing one conceptual formula that is represented as hundreds of cell formulas) often require large numbers of manual cell-level operations (such as inserting or deleting cells/rows/columns, editing and copying formulas, re-laying out worksheets).

These three deficiencies in high-level benefits have deeper causes that, ironically, flow directly from the signature strength of spreadsheets (that they capture the structure of models in terms of WYSIWYG sheet layout for authors and report users).

  • Spreadsheets capture model logic in terms of sheet layout, especially contiguous layout of cells in a table. Spreadsheets have weak or nonexistent methods to capture higher level structures such as named variables, segmentation dimensions, and time series.
  • Formulas are subordinated to the cell layout. This forces the sheet layout to carry the structure of the model, not variables and formulas that relate variables. This also causes a large proliferation of cells, formulas and cell-level tasks even when only a few basic concepts are involved in a model. This forces authors to think and work at the level of cells instead of at the level of the natural concepts and structures of the model.
  • Formulas expressed in terms of cell addresses are hard to keep straight and hard to audit. Research shows that spreadsheet auditors who check numerical results and cell formulas find no more errors than auditors who only check numerical results [10].
  • Proliferation of error-prone manual cell-level operations contributes to all three of the high-level problems listed above.

Other problems associated with spreadsheets include:[11][12]

  • Some sources advocate the use of specialized software instead of spreadsheets for some applications (budgeting, statistics)[13][14][15]
  • Many spreadsheet software products, such as Excel (versions prior to 2007) and OpenOffice.org Calc, have a capacity limit of about 65,000 rows.[16] This can present a problem for people using very large datasets, and may result in lost data.
  • Lack of auditing and revision control. This makes it difficult to determine who changed what and when. This can cause problems with regulatory compliance. Lack of revision control greatly increases the risk of errors due the inability to track, isolate and test changes made to a document.
  • Lack of security. Generally, if one has permission to open a spreadsheet, one has permission to modify any part of it. This, combined with the lack of auditing above, can make it easy for someone to commit fraud.
  • Because they are loosely structured, it is easy for someone to introduce an error, either accidentally or intentionally, by entering information in the wrong place or expressing dependencies among cells (such as in a formula) incorrectly.[17][18]
  • The results of a formula (example "=A1*B1") applies only to a single cell (that is, the cell the formula is actually located in - in this case perhaps C1), even though it can "extract" data from many other cells, and even real time dates and actual times. This means that to cause a similar calculation on an array of cells, an almost identical formula (but residing in its own "output" cell) must be repeated for each row of the "input" array. This differs from a "formula" in a conventional computer program which would typically have one calculation which would then apply to all of the input in turn. With current spreadsheets, this forced repetition of near identical formulae can have detrimental consequences from a quality assurance standpoint and is often the cause of many spreadsheet errors. Some spreadsheets have array formulas to address this issue.
  • Trying to manage the sheer volume of spreadsheets which sometimes exists within an organization without proper security, audit trails, the unintentional introduction of errors and other items listed above can become overwhelming.

While there are built-in and third-party tools for desktop spreadsheet applications that address some of these shortcomings, awareness and use of these is generally low. Revision control (also known as version control (system) (VCS), source control or (source) code management (SCM)) is the management of multiple revisions of the same unit of information. ... This article describes how security can be achieved through design and engineering. ... For other uses, see Error (disambiguation). ... It has been suggested that Real-time computing be merged into this article or section. ... Quality assurance, or QA for short, is the activity of providing evidence needed to establish quality in work, and that activities that require good quality are being performed effectively. ... In the video game industry, a third-party developer is a developer that is not directly tied to the primary product the consumer is using. ...


See also

Look up spreadsheet in
Wiktionary, the free dictionary.

Wiktionary (a portmanteau of wiki and dictionary) is a multilingual, Web-based project to create a free content dictionary, available in over 151 languages. ... The following is a list of spreadsheets. ... This is a list of online spreadsheets. ... Sum redirects here. ... Windows, GNOME and KDE keys for cut and pasting: Control + x (cut), Control + c (copy), Control + v (paste) In human-computer interaction, cut and paste or copy and paste is a user interface paradigm for transferring text, data, files or objects from a source to a destination. ... To meet Wikipedias quality standards, this article or section may require cleanup. ...

References

  1. ^ Rene Pardo - Personal Web Page
  2. ^ http://www.renepardo.com/articles/spreadsheet.pdf
  3. ^ portal.acm.org – APLDOT
  4. ^ PC World - Three Minutes: Godfathers of the Spreadsheet
  5. ^ http://web.archive.org/web/20020606140158/simson.net/clips/91.MIPS.ImprovPowerStep.html
  6. ^ http://query.nytimes.com/gst/fullpage.html?res=940DE4DF1138F930A25750C0A96E948260 THE EXECUTIVE COMPUTER; Lotus 1-2-3 Faces Up to the Upstarts By Peter H. Lewis Published: March 13, 1988
  7. ^ Linux Spreadsheets
  8. ^ Kay, Alan (September 1984). "Computer Software". Scientific American 251 (3): 52-59.  – Value Rule
  9. ^ Burnett, Margaret; Atwood, J., Walpole Djang, R., Reichwein, J., Gottfried, H., and Yang, S. (March 2001). "Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm". Journal of Functional Programming 11 (2): 155-206.  – spreadsheets as functional programming
  10. ^ a b Stephen G. Powell, Kenneth R. Baker, Barry Lawson (2007-12-01). A Critical Review of the Literature on Spreadsheet Errors. Retrieved on 2008-04-18.
  11. ^ Philip Howard (2005-04-22). Managing spreadsheets. IT-Directors.com. Retrieved on 2006-06-29.
  12. ^ Raymond R. Panko (2005-01). What We Know About Spreadsheet Errors. Retrieved on 2006-09-22.
  13. ^ Is Excel Budgeting a Mistake?
    Excel's critics say that Excel is fundamentally unsuited for budgeting, forecasting, and other activities that involve collaboration or consolidation. Are they correct?
  14. ^ http://www.cs.uiowa.edu/~jcryer/JSMTalk2001.pdf Problems With Using Microsoft Excel for Statistics
  15. ^ Spreadsheet Addiction
  16. ^ Apple Discussion: Topic : Is there a limit to the number of rows in a Numbers spreadsheet?
  17. ^ Excel spreadsheets in School budgeting - a cautionary tale (2001)
  18. ^ Public reports of spreadsheet errors collated by the European Spreadsheet Risks Interest Group (EuSpRIG).

Alan Curtis Kay (born May 17, 1940) is an American computer scientist, known for his early pioneering work on object-oriented programming and windowing graphical user interface design. ... Year 2007 (MMVII) was a common year starting on Monday of the Gregorian calendar in the 21st century. ... is the 335th day of the year (336th in leap years) in the Gregorian calendar. ... 2008 (MMVIII) is the current year, a leap year that started on Tuesday of the Anno Domini (or common era), in accordance with the Gregorian calendar. ... is the 108th day of the year (109th in leap years) in the Gregorian calendar. ... Year 2005 (MMV) was a common year starting on Saturday (link displays full calendar) of the Gregorian calendar. ... is the 112th day of the year (113th in leap years) in the Gregorian calendar. ... Year 2006 (MMVI) was a common year starting on Sunday of the Gregorian calendar. ... is the 180th day of the year (181st in leap years) in the Gregorian calendar. ... Year 2006 (MMVI) was a common year starting on Sunday of the Gregorian calendar. ... is the 265th day of the year (266th in leap years) in the Gregorian calendar. ...

External links

History of spreadsheets

General information

This article is about operating systems that use the Linux kernel. ... The Open Directory Project (ODP), also known as dmoz (from , its original domain name), is a multilingual open content directory of World Wide Web links owned by Netscape that is constructed and maintained by a community of volunteer editors. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... Look up excel in Wiktionary, the free dictionary. ...

Research organizations


  Results from FactBites:
 
Spreadsheet - Wikipedia, the free encyclopedia (1391 words)
Those spreadsheet programs can be used to tabulate many kinds of information, not just financial records, so the term "spreadsheet" has developed a more general meaning as information presented in a rectangular table, usually generated by a computer.
Spreadsheets qualify as programming languages because all or most of them are Turing complete, except for the obvious memory/storage issue, which all real programming languages fail too; they can do loops via cyclic dependencies, and have more than enough logic.
It is often convenient to think of a spreadsheet as a mathematical graph, where the nodes are spreadsheet cells, and the edges are references to other cells specified in formulas.
Spreadsheet - definition of Spreadsheet in Encyclopedia (1005 words)
Those spreadsheet programs can be used to tabulate many kinds of information, not just financial records, so the term "spreadsheet" has developed a more general meaning as information (= data = facts) presented in a rectangular table, usually generated by a computer.
A spreadsheet program is designed to perform general computation tasks using spatial relationships rather than time as the primary organizing principle.
When the professor found an error, he had to tediously erase and rewrite a number of sequential entries in the table, triggering Bricklin to think that he could replicate the process on a computer, using a flboard/spreadsheet paradigm to view results of underlying formulas.
  More results at FactBites »

 
 

COMMENTARY     


Share your thoughts, questions and commentary here
Your name
Your comments

Want to know more?
Search encyclopedia, statistics and forums:

 


Press Releases |  Feeds | Contact
The Wikipedia article included on this page is licensed under the GFDL.
Images may be subject to relevant owners' copyright.
All other elements are (c) copyright NationMaster.com 2003-5. All Rights Reserved.
Usage implies agreement with terms, 1022, m