To start the program, invoke the procedure spreadsheet with no arguments; to quit the spreadsheet program, type exit. A spreadsheet is a program that displays information in two dimensions on the screen. It can also compute some of the information automatically. Below is an example of a display from our spreadsheet program. This file was auto-generated via the gen_examples_pod.pl program that is also included in the examples directory. Example programs. The following is a list of the 85 example programs that are included in the Spreadsheet::WriteExcel distribution. 'Example: a_simple.pl' A get started example with some basic features. Example: A Spreadsheet Program. The intersection of a row with a column is called a cell; for example, the cell c4 contains the number 6500. The column letters ( a through f) and row numbers are provided by the spreadsheet program, as is the information on the bottom few lines, which we'll talk about later.
- What Are Spreadsheets And Examples
- List Three Examples Of Spreadsheet Programs
- List Three Examples Of Unfair Labor Practices
- Examples Of Spreadsheets In Excel
The following is a list of spreadsheets.
- 1Free and open-source software
- 2Proprietary software
Free and open-source software[edit]
Cloud and on-line spreadsheets[edit]
- Sheetster – 'Community Edition' is available under the Affero GPL
- Tiki Wiki CMS Groupware includes a spreadsheet since 2004 and migrated to jQuery.sheet in 2010.[1]
- Airtable - a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet.
Spreadsheets that are parts of suites[edit]
- Gnumeric — for Linux. Started as the GNOME desktop spreadsheet. Reasonably lightweight but has very advanced features.[2]
- KSpread — following the fork of the Calligra Suite from KOffice in mid-2010, superseded by KCells in KOffice and Sheets in the Calligra Suite.[3]
- LibreOfficeCalc — developed for MS Windows, GNU/Linux, BSD and Apple Macintosh (Mac) operating systems by The Document Foundation. The Document Foundation was formed in mid-2010 by several large organisations such as Google, Red Hat, Canonical (Ubuntu) and Novell along with the OpenOffice.org community (developed by Sun) and various OpenOffice.org forks, notably Go-oo. Go-oo had been the 'OpenOffice' used in Ubuntu and elsewhere. Started as StarOffice in the late 1990s, it became OpenOffice under Sun and then LibreOffice in mid-2010. The Document Foundation works with external organisations such as NeoOffice and Apache Foundation to help drive all three products forward.[4]
- NeoOffice Calc — for Mac. Started as an OpenOffice.org port to Mac, but by using the Mac-specific Aquauser interface, instead of the more widely used X11 windowing server, it aimed to be far more stable than the normal ports of other suites.[5]
- OpenOffice.orgCalc — for MS Windows, GNU/Linux and the Apple Macintosh. Started as StarOffice. Sun changed the name to OpenOffice.org and developed a community of developers (and others) between the late 1990s and mid-2010. Oracle gave it to the Apache Foundation in 2011. IBM contributed their fork of OpenOffice.org, IBM Lotus Symphony, to Apache a few weeks later.[6]
- Siag — for GNU/Linux, OpenBSD and Apple Mac OS X. A simple old spreadsheet, part of Siag Office.[7]
- Sheets — for MS Windows, GNU/Linux, FreeBSD, Apple Mac OS X and Haiku. Part of the extensive Calligra Suite. Possibly still mainly for Linux, but ports have been developed for other operating systems.[8]
Standalone spreadsheets[edit]
Proprietary software[edit]
Online spreadsheets[edit]
- EditGrid – access, collaborate and share spreadsheets online, with API support; discontinued since 2014
- Google Sheets – as part of Google Docs
- iRows – closed since 31 December 2006
- JotSpot Tracker – acquired by Google Inc.
- Smartsheet – Online spreadsheet for project management, interactive Gantt, file sharing, integrated with Google Apps[9]
- ThinkFree Online Calc – as part of the ThinkFree Office online office suite, using Java
Spreadsheets that are parts of suites[edit]
- Ability Office Spreadsheet – for MS Windows.
- Apple iWorkNumbers, included with Apple's iWork '08 suite exclusively for Mac OS X v10.4 or higher.
- AppleWorks – for MS Windows and Macintosh. This is a further development of the historical Claris Works Office suite.
- WordPerfect OfficeQuattro Pro – for MS Windows. Was one of the big three spreadsheets (the others being Lotus 123 and Excel).
- EasyOffice EasySpreadsheet – for MS Windows. No longer freeware, this suite aims to be more user friendly than competitors.
- Framework – for MS Windows. Historical office suite still available and supported. It includes a spreadsheet.
- IBM Lotus Symphony – freeware for MS Windows, Apple Mac OS X and GNU/Linux.
- Kingsoft Office Spreadsheets 2012 – For MS Windows. Both free and paid versions are available. It can handle Microsoft Excel .xls and .xlsx files, and also produce other file formats such as .et, .txt, .csv, .pdf, and .dbf. It supports multiple tabs, VBA macro and PDF converting.[10]
- Lotus SmartSuiteLotus 123 – for MS Windows. In its MS-DOS (character cell) version, widely considered to be responsible for the explosion of popularity of spreadsheets during the 80s and early 90s.[citation needed]
- MarinerPakMariner Calc – for Apple Macintosh. Full featured and light weight.
- Microsoft OfficeExcel – for MS Windows and Apple Macintosh. The proprietary spreadsheet leader.
- Microsoft Works Spreadsheet – for MS Windows (previously MS-DOS and Apple Macintosh). Only allows one sheet at a time.
- PlanMaker – for MS Windows, GNU/Linux, MS Windows Mobile and CE; part of SoftMaker Office
- Quattro Pro – part of WordPerfect Office
- StarOffice Calc – Cross-platform. StarOffice was originally developed by the German company Star Division which was purchased by Sun in 1998. The code was made open source and became OpenOffice.org. Sun continues developing the commercial version which periodically integrates the open source code with their own and third party code to make new low price versions.
Stand alone spreadsheets[edit]
- As-Easy-As – from Trius, Inc.; unsupported; last MS-DOS and Windows versions available with free full license key.
Multi-dimensional spreadsheets[edit]
Spreadsheets on different paradigms[edit]
- DADiSP – Combines the numerical capability of MATLAB with a spreadsheet like interface.
- Resolver One – a business application development tool that represents spreadsheets as IronPython programs, created and executed in real time and allowing the spreadsheet flow to be fully programmed
Spreadsheet-related developmental software[edit]
- ExtenXLS – Java Spreadsheet Toolkit.
Specifications[edit]
Program | Rows (per sheet) | Columns (per sheet) | Total Cells (per sheet) | Sheets | Total Cells (per workbook) |
---|---|---|---|---|---|
Gnumeric | 16,777,216 | 16,384 | 274,877,906,944 | 142,648 | 603,103 |
KSpread | 32,767 | 32,767 | 1,073,676,289 | 130,645 | 953,923 |
LibreOffice Calc 6.0.1 and 5.4.5 | 1,048,576 | 1,024 | 1,073,741,824 | 1,024 | 1,099,511,627,776 |
Lotus 1-2-3[11] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
Microsoft Excel 2003 | 65,536 | 256 | 16,777,216 | 65,531 | 1,099,427,741,696 |
Microsoft Excel 2007, 2010, 2013 and 2016[12][13][14] | 1,048,576 | 16,384 | 17,179,869,184 | Limited by available memory | Limited by available memory |
OpenOffice.org Calc 2[15] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
OpenOffice.org Calc 3.0, 3.1 and 3.2[16][17] | 65,536 | 1024 | 67,108,864 | 256 | 17,179,869,184 |
OpenOffice.org Calc 3.3[18] | 1,048,576 | 1024 | 1,073,741,824 | 256 | 274,877,906,944 |
Pyspread | ~80 000 000 (limited by sum of row heights) | ~30 000 000 (limited by sum of column widths) | Limited by available memory | Limited by available memory | Limited by available memory |
Resolver One | limited by machine memory* | limited by machine memory* | limited machine memory* | limited by machine memory* | limited by machine memory* |
-* 32-bit addressable memory on Microsoft Windows, i.e. ~2.5 GB.
Historical[edit]
- VisiCalc The first widely used normal spreadsheet with A1 notation etc.
- Lotus 1-2-3 Took the market from Visicalc in the early 1980s.
- Lotus Improv Novel design that went beyond A1 notation.
- Multiplan Early version of Excel.
- 20/20 Multiplatform competitor to 1-2-3 with database integration and real-time data updating.
- 3D-Calc multi-dimensional spreadsheet for Atari ST[19]
- SuperCalc – CP/M-80 Included with early Osborne computers. It also was ported to MS-DOS and to Microsoft Windows.
- Dynacalc — from Computer Systems Center, similar to VisiCalc. It was designed to run on Microware's OS-9, a Unix-like operating system.[20]
- VP Planner – Similar in look and feel to Lotus 1-2-3, but included 5 level multi-dimensional database[21]
- Wingz Multi Dimensional preadsheetS from Informix (1988)
- Boeing Calc – was a spreadsheet package written by subsidiary of aviation manufacturer Boeing (1985).
See also[edit]
References[edit]
- ^Spreadsheet, Tiki.
- ^'Gnumeric', Office (downloads), Gnome.
- ^The KOffice Project.
- ^LibreOffice.
- ^NeoOffice.
- ^OpenOffice.org.
- ^'Scheme In A Grid'. NU: Siag. 2000-12-07. Retrieved 7 March 2017.
- ^The Calligra Suite.
- ^Apps Marketplace Profile, Google.
- ^Spreadsheets, Kingsoft.
- ^'Limitations of 1-2-3 for Windows'. IBM. Archived from the original on 2013-01-03. Retrieved 2008-04-10.
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.
- ^'What is the maximum number of cells in an OpenOffice.org spreadsheet?'. FAQ. OpenOffice.org. Retrieved 2008-04-10.
- ^'What's the maximum number of rows and cells for a spreadsheet file?'. Calc FAQ. OpenOffice.org. Archived from the original on 2009-05-04. Retrieved 2008-11-04.
- ^'OpenOffice.org 3.0 New Features'. 3.0 Features. OpenOffice.org. Retrieved 2008-11-10.
- ^'OpenOffice.org 3.3 New Features'. 3.3 Features. OpenOffice.org. Retrieved 2010-12-13.
- ^Frank Schoonjans, '3D-Calc', Atari ST.
- ^'Dynacalc'(PDF) (manual). Tandy. Retrieved April 13, 2015.
- ^Stephenson, James; Brothers, Kent; Mitchell, Dave (December 1, 1986). VP-Planner: Spreadsheet Flexibility with Database Powe. Paperback Software International, Stephenson Software. ISBN0-87142021-X.
Retrieved from 'https://en.wikipedia.org/w/index.php?title=List_of_spreadsheet_software&oldid=907702731'
A spreadsheet or worksheet is a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas and the data in cells. A good example of how a spreadsheet may be utilized is creating an overview of your bank's balance.
Spreadsheet overview
Below is a basic example of what a MicrosoftExcel spreadsheet looks like, as well as all the important features of a spreadsheet highlighted.
In the above example, this spreadsheet is listing three different checks, the date, their description, and the value of each check. These values are then added together to get the total of $162.00 in cell D6. That value is subtracted from the check balance to give an available $361.00 in cell D8.
Introduction to Parallel Algorithms and Architectures: Arrays Trees Hypercubes provides an introduction to the expanding field of parallel algorithms and architectures. This book focuses on parallel computation involving the most popular network architectures, namely, arrays, trees, hypercubes, and some closely related networks. Introduction to parallel algorithms and architectures leighton pdf.
Difference between a workbook, worksheet, and spreadsheet
Because the terms spreadsheet, workbook, and worksheet are so similar, there can be a lot of confusion when trying to understand their differences. When you open Microsoft Excel (a spreadsheet program), you're opening a workbook. A workbook can contain one or more different worksheets that can be accessed through the tabs at the bottom of the worksheet your currently viewing. What's often most confusing is that a worksheet is synonymous with a spreadsheet. In other words, a spreadsheet and worksheet mean the same thing. However, most people only refer to the program as a spreadsheet program and the files it creates as spreadsheet files.
Examples of spreadsheet programs
Today, Microsoft Excel is the most popular and widely used spreadsheet program, but there are also many alternatives. Below is a list of spreadsheet programs that can be used to create a spreadsheet.
- Google Sheets - (online and free).
- iWork Numbers - Apple Office Suite.
- LibreOffice -> Calc (free).
- Lotus 1-2-3 (discontinued).
- Lotus Symphony - Spreadsheets.
- Microsoft Excel.
- OpenOffice -> Calc (free).
- VisiCalc (discontinued).
Examples and uses of a spreadsheet
Although spreadsheets are most often used with anything containing numbers, the uses of a spreadsheet are almost endless. Below are some other popular uses of spreadsheets.
Finance
Spreadsheets are ideal for financial data, such as your checking account information, budgets, taxes, transactions, billing, invoices, receipts, forecasts, and any payment system.
Forms
Form templates can be created to handle inventory, evaluations, performance reviews, quizzes, time sheets, patient information, and surveys.
School and grades
Teachers can use spreadsheets to track students, calculate grades, and identify relevant data, such as high and low scores, missing tests, and students who are struggling.
What Are Spreadsheets And Examples
Lists
Managing a list in a spreadsheet is a great example of data that does not contain numbers, but still can be used in a spreadsheet. Great examples of spreadsheet lists include telephone, to-do, and grocery lists.
Sports
Spreadsheets can keep track of your favorite player stats or stats on the whole team. With the collected data, you can also find averages, high scores, and statistical data. Spreadsheets can even be used to create tournament brackets.
What is an active worksheet?
An active worksheet is the worksheet that is currently open. For example, in the Excel picture above, the sheet tabs at the bottom of the window show 'Sheet1,' 'Sheet2,' and 'Sheet3,' with Sheet1 being the active worksheet. The active tab usually has a white background behind the tab name.
How many worksheets open by default?
In Microsoft Excel 2016 and earlier and OpenOffice Calc, by default, there are three sheet tabs that open (Sheet1, Sheet2, and Sheet3). In Google Sheets, your spreadsheets starts with one sheet (Sheet1).
In Microsoft Excel 365, by default, there is only one sheet tab that opens (Sheet1).
What is the length limit of a worksheet name?
Not to be confused with the file name, in Microsoft Excel, there is a 31 character limit for each worksheet name.
How are rows and columns labeled?
In all spreadsheet programs, including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1,048,576). All columns are labeled with letters from A to Z, then with two letters. For example, after the letter Z, the next column is AA, AB, AC, .., AZ and then incrementing to BA, BB, BC, etc., to the last column XFD.
When working with a cell, you combine the column with the row. For example, the very first cell is in column A and on row 1, so the cell is labeled as A1.
Why not use a word processor instead of a spreadsheet?
While it may be true that some of the things mentioned above could be done in a word processor, spreadsheets have a huge advantage over word processors when it comes to numbers. Battlefield hardline highly compressed game. It would be impossible to calculate multiple numbers in a word processor and have the value of the calculation immediately appear. Spreadsheets are also much more dynamic with the data and can hide, show, and sort information to make processing lots of information easier.
Download an example of a spreadsheet file
List Three Examples Of Spreadsheet Programs
We've created a Microsoft Excel spreadsheet that can be downloaded and opened in any spreadsheet program including Microsoft Excel. This spreadsheet helps illustrate some of the capabilities of a spreadsheet, formulas, and functions used in a spreadsheet, and allows you to experiment more with a spreadsheet.
The same spreadsheet is also available on Google Sheets. Visit the link below to open the spreadsheet in view mode in Google Sheets. If you want to edit any of the values, click File and then Make a copy option to save it to your Google Drive.
List Three Examples Of Unfair Labor Practices
Related spreadsheet pages
Examples Of Spreadsheets In Excel
Absolute cell reference, Active cell, Business terms, Cell, Column, Formula, Gnumeric, Google Sheets, Gridlines, Multiplan, Office, Office 365, Office Online, Pivot table, Relative cell reference, Row, Sheet tab, Software terms, Spreadsheet terms, Workbook