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
- A Better Finder Rename 8.42 (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-11-24
- RightNote 1.6.8 (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-24
- Office Starter 2010: The fine print on Microsoft's Works replacement
- For me, non-starterA crippled, incompatible, ad supported product makes little sense to me, when Open Office and Google are alternatives.ExactlyThere's already a portable version of OpenOffice that runs on a USB stick - nothing new here.The excluded formats are used in only about 1% of documentsIt is well-known that macros...
- Discussion threads 2009-11-23
- 1st Mac Mailer 3.6 (Mac)
- 1st Mac Mailer is mass-mailing software used by various e-commerce providers to deliver personalized email messages to their customers when they are needed to be notified about different events. These e-notifications vary from simple email notifications about product updates or new product releases to more complex newsletters and invoices. If...
- Software downloads 2009-11-22
- Will Microsoft's Silverlight dampen the appeal of Google's Chrome OS?
- MS is the past Google is the future so NopeGoogle is the old MS, MS is the old IBM. PC_DOS never made it, MS_DOS did. The driving factor was openness and innovation.Today and in the near future, Google has bothToday MS sees profit only and based on thatdrives...
- Discussion threads 2009-11-20
- GS-Calc 8.0 (Windows)
- GS-Calc is a spreadsheet that will help you to better organize your data. Track your expenses and incomes, create reports, search and edit databases, perform statistical calculations. GS-Calc does the job quickly, easily and efficiently. You can install it on any portable storage device and carry it with you. The...
- Software downloads 2009-11-20
- Trend View 4.1 (Windows)
- Trend View is a spreadsheet program to help you find trends and features in data. It can open any size data file not limited by row or column size, read from databases, plot assorted 2D, 3D and false colour graphs, and supports math formulas. The data and graphing windows are...
- Software downloads 2009-11-19
- Querious 1.0b12 (Mac)
- Querious is a new MySQL database management application written from the ground up exclusively for Mac OS X Leopard. Unlike mindless Mac OS X versions of applications made for Windows or Linux, Querious is a stunning new app that is precise and easy to understand, giving you full control without...
- Software downloads 2009-11-19
- WCT (Workbook Comparison Tool) 2.2 (Windows)
- WCT is an add-in for Microsoft Excel. It compares and merges workbooks, worksheets or specific ranges with own smart algorithm. It detects added and deleted data in spreadsheet. Comparison results are shown exactly as they looks in original Excel workbook. Modifications are marked with color in Report Window and can...
- Software downloads 2009-11-19
- Office 2010 Beta 2: More than just a bunch of pretty icons
- Of course its better, they stole ideas fromOf course 2010 is better, they stole (oops, innovated) most of the new ideas from Office MVPs that built add ins to previous versions. (There is a very silent revolt going on in the MVP ranks over it and many long term...
- Discussion threads 2009-11-18
- Explore the Windows 7 Application Compatibility List for IT Professionals
- In this edition of the Windows Vista and Windows 7 Report, Greg Shultz examines the Windows 7 Application Compatibility List for IT Professionals spreadsheet and provides you with an overview of what you can find in it.
- Download resources 2009-11-18
- EasyProject Manager 1.7 (Mac)
- EasyProject Manager is for teams that need to collaborate on projects. It allows you to share and collaborate with your teammates without getting in the way. No complicated charts or reading manuals to figure out how to use it. With EPM your team shares the same information updated real time....
- Software downloads 2009-11-18
- Hayahaya Flow 1.1.2 (Windows)
- Creating flowchart easily in Excel. Fowcharting and spreadsheet are now seamless. Hayahaya Flow is made as add-in software for Microsoft Excel. You can add Auto shapes and connectors only click button on the toolbar.So you can create flowchart easily in Excel. The created flowchart is consists of autoshape. So you...
- Software downloads 2009-11-18
- Cashculator 1.0.1 (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...
- Software downloads 2009-11-15
- Advanced Directory Printer 1.55 (Windows)
- Advanced Directory Printer is a Windows based application designed to print or export a list of directories, subdirectories, and files. Information fields include file name, type, extension, size, creation time/date, last access date, last write time/date and file attributes, and you can choose which fields to print or export. Advanced...
- Software downloads 2009-11-13
- Are Your Documents Locked and Loaded?
- Have you ever gone to the printer to pick up your output only to find that Betty from Accounting picked it up by mistake? This can be a serious problem, especially if the document in question is a sensitive spreadsheet, an employee evaluation, or top-secret information about an upcoming stock...
- Sponsored content 2009-11-12
- Genetic Sequence Binary Factor Grouping 2.1.1 (Windows)
- Deriving genetic sequence number band groups and group sequences from mRNA scan CEL V3 files is performed via a set of C/C++ routines delivered in source code that may easily get recompiled. Building group charts requires spreadsheet software. This is an easy and fast method for reviewing and referencing genetic...
- Software downloads 2009-11-11
- European Football Yearbook And Result Database 1995-96 1.1 (Windows)
- European Football Yearbook And Result Database exists to provide the football punter with computer-ready football results and league tables in an easy to use Microsoft Access database. These interactive reports can easily be exported into spreadsheet applications, to help with the development and analysis of football betting systems. If you...
- Software downloads 2009-11-11
- European Football Yearbook And Result Database 1994-95 1.1 (Windows)
- European Football Yearbook And Result Database exists to provide the football punter with computer-ready football results and league tables in an easy to use Microsoft Access database. These interactive reports can easily be exported into spreadsheet applications, to help with the development and analysis of football betting systems. If you...
- Software downloads 2009-11-11
- European Football Yearbook And Result Database 1993-94 1.1 (Windows)
- European Football Yearbook And Result Database exists to provide the football punter with computer-ready football results and league tables in an easy to use Microsoft Access database. These interactive reports can easily be exported into spreadsheet applications, to help with the development and analysis of football betting systems. If you...
- Software downloads 2009-11-11
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Learn more about tools to grow your business
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Save time with the UPS Business Essentials Guide
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
Meet Doc
-
-
Here to help you with your Document Management Needs
- Check out Doc’s Blog on ZDNet
- Help your company, help the earth I want to share with you the Environmental Defense Fund Paper Calculator, which allows you to gauge your organization's environmental impact.
- Which is Greener: Paper or Digital? The Answer May Surprise You Anything we can do to reduce paper consumption is good. But what about the impact of digital waste?
-
Produced by
ZDNet and -
