B.E 5TH SEMESTER CIVIL ENGINEERING (CBCS)
Numerical Methods and Computer Subject code
5CE03
Programming
Jagadambha College of Engineering &
Technology, Yavatmal
JCOET, Yavatmal
Prof. R. J. Raut
, Unit - I
Shred sheet software basics
Introduction to subject, Expressions, mathematical function, conditional execution
function (i.e COUNT, COUNTIF, SUM, SUMIF, AVERAGE, AVERAGEIF, HLOOKUP).
Application to civil engineering problems.
Introduction
A spreadsheet is a computer program or software application used to organize, manipulate, and analyze
data in a tabular format. It consists of a grid of cells arranged in rows and columns, where each cell can
contain text, numbers, formulas, or functions. Spreadsheet software allows users to perform various
tasks with data, such as calculations, data visualization, sorting, filtering, and more.
The primary purpose of a spreadsheet is to facilitate data management and analysis. Users can enter data
into individual cells, perform calculations using formulas and functions, and create visual
representations of their data, such as charts and graphs. Spreadsheets are commonly used in various
fields, including finance, accounting, engineering, education, and research, for tasks such as budgeting,
financial forecasting, data analysis, and reporting.
Popular examples of spreadsheet software include Microsoft Excel, Google Sheets, LibreOffice Calc,
and Apple Numbers. These programs provide a wide range of features and tools for working with data
effectively, making them essential tools for professionals and individuals alike.
The history of spreadsheet software
It dates back to the late 1970s when the concept of electronic spreadsheets was first introduced. Here's a
brief overview of the evolution of some of the most prominent spreadsheet software:
➢ VisiCalc (1979): Developed by Dan Bricklin and Bob Frankston, VisiCalc is widely regarded as the
first electronic spreadsheet software for personal computers. It was initially released for the Apple II
platform and revolutionized the way people performed calculations and analyzed data. VisiCalc
allowed users to create interactive, formula-based spreadsheets, making it a breakthrough tool for
business professionals, accountants, and educators.
➢ Lotus 1-2-3 (1983): Developed by Lotus Development Corporation, Lotus 1-2-3 was one of the
most popular spreadsheet software applications in the 1980s and early 1990s. It integrated
2
, spreadsheet, charting, and database capabilities into a single application, offering features such as
macros, graphing tools, and built-in functions. Lotus 1-2-3 played a significant role in the
widespread adoption of personal computers in business environments.
➢ Microsoft Excel (1985): Microsoft Excel was first released in 1985 for the Apple Macintosh
platform and later for Microsoft Windows. Initially, it faced stiff competition from Lotus 1-2-3, but
eventually surpassed it to become the dominant spreadsheet software worldwide. Excel introduced
features such as a graphical interface, a rich set of functions and formulas, pivot tables, and
extensive customization options. It has since become an indispensable tool for data analysis,
financial modeling, and reporting in various industries.
➢ Quattro Pro (1989): Developed by Borland, Quattro Pro was a popular spreadsheet software
application that competed with Microsoft Excel and Lotus 1-2-3 in the late 1980s and early 1990s. It
offered advanced features such as object-oriented programming, built-in statistical analysis tools,
and support for larger worksheets. Quattro Pro gained a loyal user base but gradually lost market
share to Excel and other spreadsheet software.
➢ Google Sheets (2006): Google Sheets is a web-based spreadsheet software developed by Google as
part of its Google Drive office suite. Launched in 2006, Google Sheets allows users to create, edit,
and collaborate on spreadsheets online, without the need for desktop software. It offers many of the
features found in traditional spreadsheet software, such as formulas, functions, charts, and sharing
capabilities. Google Sheets has gained popularity for its ease of use, real-time collaboration features,
and integration with other Google services.
❖ Spreadsheet overview
Examples and uses of a spreadsheet
Although spreadsheets are used with anything containing numbers, the uses of a spreadsheet are almost
endless. Below are other popular uses of spreadsheets.
1. Finance
Spreadsheets are ideal for financial data, such as your checking account information, budgets, taxes,
transactions, billing, invoices, receipts, forecasts, and any payment system.
2. Forms
Form templates can be created to handle inventory, evaluations, performance reviews, quizzes, time
sheets, patient information, and surveys.
3
Numerical Methods and Computer Subject code
5CE03
Programming
Jagadambha College of Engineering &
Technology, Yavatmal
JCOET, Yavatmal
Prof. R. J. Raut
, Unit - I
Shred sheet software basics
Introduction to subject, Expressions, mathematical function, conditional execution
function (i.e COUNT, COUNTIF, SUM, SUMIF, AVERAGE, AVERAGEIF, HLOOKUP).
Application to civil engineering problems.
Introduction
A spreadsheet is a computer program or software application used to organize, manipulate, and analyze
data in a tabular format. It consists of a grid of cells arranged in rows and columns, where each cell can
contain text, numbers, formulas, or functions. Spreadsheet software allows users to perform various
tasks with data, such as calculations, data visualization, sorting, filtering, and more.
The primary purpose of a spreadsheet is to facilitate data management and analysis. Users can enter data
into individual cells, perform calculations using formulas and functions, and create visual
representations of their data, such as charts and graphs. Spreadsheets are commonly used in various
fields, including finance, accounting, engineering, education, and research, for tasks such as budgeting,
financial forecasting, data analysis, and reporting.
Popular examples of spreadsheet software include Microsoft Excel, Google Sheets, LibreOffice Calc,
and Apple Numbers. These programs provide a wide range of features and tools for working with data
effectively, making them essential tools for professionals and individuals alike.
The history of spreadsheet software
It dates back to the late 1970s when the concept of electronic spreadsheets was first introduced. Here's a
brief overview of the evolution of some of the most prominent spreadsheet software:
➢ VisiCalc (1979): Developed by Dan Bricklin and Bob Frankston, VisiCalc is widely regarded as the
first electronic spreadsheet software for personal computers. It was initially released for the Apple II
platform and revolutionized the way people performed calculations and analyzed data. VisiCalc
allowed users to create interactive, formula-based spreadsheets, making it a breakthrough tool for
business professionals, accountants, and educators.
➢ Lotus 1-2-3 (1983): Developed by Lotus Development Corporation, Lotus 1-2-3 was one of the
most popular spreadsheet software applications in the 1980s and early 1990s. It integrated
2
, spreadsheet, charting, and database capabilities into a single application, offering features such as
macros, graphing tools, and built-in functions. Lotus 1-2-3 played a significant role in the
widespread adoption of personal computers in business environments.
➢ Microsoft Excel (1985): Microsoft Excel was first released in 1985 for the Apple Macintosh
platform and later for Microsoft Windows. Initially, it faced stiff competition from Lotus 1-2-3, but
eventually surpassed it to become the dominant spreadsheet software worldwide. Excel introduced
features such as a graphical interface, a rich set of functions and formulas, pivot tables, and
extensive customization options. It has since become an indispensable tool for data analysis,
financial modeling, and reporting in various industries.
➢ Quattro Pro (1989): Developed by Borland, Quattro Pro was a popular spreadsheet software
application that competed with Microsoft Excel and Lotus 1-2-3 in the late 1980s and early 1990s. It
offered advanced features such as object-oriented programming, built-in statistical analysis tools,
and support for larger worksheets. Quattro Pro gained a loyal user base but gradually lost market
share to Excel and other spreadsheet software.
➢ Google Sheets (2006): Google Sheets is a web-based spreadsheet software developed by Google as
part of its Google Drive office suite. Launched in 2006, Google Sheets allows users to create, edit,
and collaborate on spreadsheets online, without the need for desktop software. It offers many of the
features found in traditional spreadsheet software, such as formulas, functions, charts, and sharing
capabilities. Google Sheets has gained popularity for its ease of use, real-time collaboration features,
and integration with other Google services.
❖ Spreadsheet overview
Examples and uses of a spreadsheet
Although spreadsheets are used with anything containing numbers, the uses of a spreadsheet are almost
endless. Below are other popular uses of spreadsheets.
1. Finance
Spreadsheets are ideal for financial data, such as your checking account information, budgets, taxes,
transactions, billing, invoices, receipts, forecasts, and any payment system.
2. Forms
Form templates can be created to handle inventory, evaluations, performance reviews, quizzes, time
sheets, patient information, and surveys.
3
