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.
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.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Arixcel Accounts 1.26 (Windows)
- Arixcel Accounts is a personal accounting add-in to Microsoft Excel. It is a unique tool that combines the rich functionality of personal finance software with the transparency and the ease of use of spreadsheets. With the help of Arixcel accounts you can easily import all your bank statements into a...
- Software downloads 2009-11-05
- DoneEx XCell Compiler 1.9.9 (Windows)
- DoneEx XCell Compiler offers very easy and hassle free Microsoft Excel workbook copy protection. You can compile Excel spreadsheet into EXE application with securely hidden formulas in binary format and protected VBA code. With registration/license management feature you can protect your compiled Excel workbook from illegal copying from one computer...
- Software downloads 2009-11-05
- Walmart unveils 15.6" HP Pavilion G60 laptop for $298
- hmmfor once, i agree with you. why are they still making the celeron...? shouldn't the atom replace that?Intel Celeron?is Inhel still making this 10 year old crap?surplus maybe? ntnti feel 298 is bad for celron processor..but still good option for ppl who r new to these creepy labtops..RE: Walmart unveils...
- Discussion threads 2009-11-04
- 4W WebMerge 2.5.3 (Mac)
- WebMerge generates static HTML pages from your exported database. Build catalogs, ezines, contact lists, image galleries and more, quickly and easily. Works with output from nearly any database or spreadsheet, including Microsoft Access, FileMaker Pro, Panorama, AppleWorks, and Excel. Design templates for your index and details pages in your favorite...
- Software downloads 2009-11-04
- Macnification 1.6.1 (Mac)
- Macnification is a workflow solution for digital electron microscopy. It enables scientists to organize, find, annotate, analyze, adjust, compare and publish microscopic images. All major image file formats can be imported into Macnification, as well as their metadata, which are presented in a fully customizable view. A full-screen image view...
- Software downloads 2009-11-04
- RightNote 1.6.5 (Windows)
- RightNote is a note-taker and note-organizer, that allows you to store and organize all bits of different information in a single place - and find that information almost instantly. Instead of having many pieces of paper lying all over your desk, which may contain contact information, phone numbers, to-do lists,...
- Software downloads 2009-11-03
- OpenOffice.org Portable 3.1.1 (Windows)
- OpenOffice.org Portable (formerly Portable OpenOffice.org) is the complete OpenOffice.org office suite, including a word processor, spreadsheet, presentation tool, drawing package, and database - packaged as a portable app, so you can take all your documents and everything you need to work with them wherever you go. This full-featured office suite...
- Software downloads 2009-11-02
- Cashculator 1.0 (Mac)
- Cashculator - The Mac way to track your cash flow! Cashculator is a different kind of personal finance application - instead of focusing on the past and logging previous transactions, it focuses on future by forecasting your financial situation. Easier than a spreadsheet - it is the simplest way to...
- Software downloads 2009-11-02
- DietController 1.40 (Mac)
- DietController is an easy to use diet and exercise journal. Use with any weight loss plan to accurately track and record your diet. Just enter the foods you eat each day and let our diet software do all the calculations for you. Instant summaries allow you to manage and plan...
- Software downloads 2009-11-01
- Ubuntu 9.10 (Windows)
- Ubuntu is a community developed, Linux-based operating system that is perfect for laptops, desktops and servers. It contains all the applications you need - a web browser, presentation, document and spreadsheet software, instant messaging and much more.
- Software downloads 2009-10-30
- Jaikoz Audio Tagger 3.3.4 (Mac)
- Are you frustrated by missing information in your audio files? This is known as metadata and is stored in a Tag. The Jaikoz Audio Tag Editor is a powerful yet simple to use tool that allows you to organize, edit and correct thousands of these tags with ease. Jaikoz...
- Software downloads 2009-10-29
- The month ahead: Will Droid do damage to the iPhone's mojo?
- Droid, iPhone, and Windows 7IMHO Droid will likely carve out its own niche - but won't really replace the iPhone or the Blackberry.And I think they may be underestimating Windows 7 a bit.I don't understand the Android guysDo you seriously think you can sell a phone OS as a feature?...
- Discussion threads 2009-10-28
- OpenOffice.org 3.2 Beta (Mac)
- This office productivity suite for Mac OS X includes desktop applications such as a word processor, a spreadsheet, a presentation manager, and a drawing program, with a user interface and feature set similar to that of other office suites. OpenOffice.org also works transparently with a variety of file formats, including...
- Software downloads 2009-10-28
- Virtual TimeClock Client '09 Release 3 (Mac)
- The Virtual TimeClock Pro Client is the full featured netowork client for connectivity to the Virtual TimeClock Server. Virtual TimeClock time and attendance software is full featured and powerful, yet easy to manage and use. Designed for the busy owner or manager without a lot of technical expertise, our time...
- Software downloads 2009-10-28
- Virtual TimeClock Server '09 Release 3 (Mac)
- Virtual TimeClock time and attendance software is full featured and powerful, yet easy to manage and use. Designed for the busy owner or manager without a lot of technical expertise, our time clock software can be up and running in a few minutes. Take advantage of powerful auto discovery networking...
- Software downloads 2009-10-28
- OmniGraphSketcher 1.1 beta 1 (Mac)
- OmniGraphSketcher helps you make elegant and precise graphs in seconds, simply by sketching what you want. Specifically designed for reports, presentations, and problem sets where you need to produce sharp-looking graphs on the fly, OmniGraphSketcher combines the data plotting power of charting applications with the ease of a basic drawing...
- Software downloads 2009-10-28
- QODBC Driver for QuickBooks 10.0 (Windows)
- Plug-in to your QuickBooks data. QODBC is an ODBC Driver for Microsoft Windows, which makes the data in QuickBooks Pro Accounting Software easily available to most Windows applications. It allows you to easily link QuickBooks data into your Microsoft Excel spreadsheet, and update it whenever the data changes, run a...
- Software downloads 2009-10-28
- A Better Finder Rename 8.36 (Mac)
- A Better Finder Rename is the most complete renaming solution available on the market today. That's why, since 1996, thousands of hobbyists, professionals and businesses depend on A Better Finder Rename to organize and maintain files. A Better Finder Rename's user interface supports complex renaming tasks without sacrificing ease and...
- Software downloads 2009-10-28
- Dear Microsoft: What's the deal with Windows 7 upgrades?
- Location?38.921473?N 77.066946?WYep, same here ...... stonewalled at every turn. With you ...... I can see, because you've been pulling on Microsoft's scab lately. But in Ed's case, I don't know why they would treat him like that.^o^Message has been deleted..Believe it or not ...... it makes little difference. The...
- Discussion threads 2009-10-27
- NeoOffice 3.0.1 (Mac)
- NeoOffice is a full-featured set of office applications (including word processing, spreadsheet, presentation, drawing, and database programs) for Mac OS X. Based on the OpenOffice.org office suite, NeoOffice has integrated dozens of native Mac features and can import, edit, and exchange files with other popular office programs such as Microsoft...
- Software downloads 2009-10-26
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
-
- Innovate your business' process model, play against the market, compete against others on our scoreboards and WIN! Try INNOV8 2.0: A BPM Simulator
- Enabling Real-World Business Transformation through IBM Service Management Read the EMA Analyst Report
