Skip to main content
main-content

Über dieses Buch

Engineers and scientists can use spreadsheets to help them quickly solve technical problems. Ideal for analyzing and manipulating data, Quattro Pro spreadsheet software from Borland International, also turns out to be an excellent tool for technologists requiring database management, mathematical functions, graphing data, statistics, regressive analysis, matrix arithmetic, and more. In this book, professional engineer Robert G. Parks describes the specific functions of Quattro Pro 3.0 that benefit scientists and engineers in a range of disciplines. The book contains numerous examples with clearly defined steps to help technologists integrate Borland's powerful software into their daily work lives.

Inhaltsverzeichnis

Frontmatter

Introduction

Abstract
Before the advent of the digital computer and the electronic calculator, an engineer used a manual spreadsheet called a tabular calculation for the presentation of alternate plans on feasibility studies, physical properties of chemical mixtures and similar problems. The tools were a slide rule, a sharp pencil and a large eraser. It often took hours or days to accomplish what is done electronically now in minutes and even seconds. However, the engineer and scientist still do not have access to many dedicated scientific electronic spreadsheets. They depend for the most part upon those developed for business and accounting purposes. For general applications there are some mathematical packages that will present the data in tabular form and some that will interact with specific spreadsheets.
Robert G. Parks

1. The Spreadsheet

Abstract
For the interest of the occasional spreadsheet user, the discussions of Quattro Pro Version 3.0, at the beginning of each chapter will include a summary of the implementing commands. The first chapter summary will include the key operations, precedence of calculations, and functions. Those aspects of Quattro Pro that are of special interest for engineering and scientific calculations will be expanded with examples.
Robert G. Parks

2. Graphs

Abstract
The text and numeric information contained in a spreadsheet is provided in detail. By contrast a graph will present the same text and data as an overall view and more clearly display the trends of the variables.
Robert G. Parks

3. Matrix Algebra

Abstract
Matrix operations are a problem solving tool in all branches of science and engineering. Matrices can be used in the calculation of primary stresses of a truss. The analysis of electronic circuits relies heavily on the use of matrices. Matrix algebra was used by Heisenberg in a parallel development of quantum mechanics: in fact the Schrödinger wave equation and the matrix mechanics of Heisenberg are mathematically equivalent.
Robert G. Parks

4. Curve Fitting with Linear Regression

Abstract
With test data it is often necessary to determine a relationship between the two sets of numbers, for interpolation and extrapolation. It is possible to graph the data as linear, semi-log or log plots to determine the equation and constants. The XY line then is a visual estimate of the average point positions. A more accurate method is to determine the equation of the graph of data statistically by using linear regression. The linear regression method can be used not only for linear data but for any type of curve that can be rewritten in a linear form.
Robert G. Parks

5. Database

Abstract
In addition to the spreadsheet integrated software, Quattro Pro has the added dimension of a database. The dedicated database programs that relate the data in several different files based upon comman elements are usually a programmable relational database. Quattro Pro is not a relational database. The entire database is held in the memory by Quattro Pro. The larger the Quattro Pro database, the larger the RAM requirement, but the access and processing time is reduced.
Robert G. Parks

6. Statistics

Abstract
The two sets of statistical functions of Quattro Pro are identical except for the method of designating the block for the calculation. The standard statistics functions set the block by cell location, as in @COUNT(B5…B30). The database statistics functions use the Block, Column, and Criteria as in Table 6.1. Since the database is memory based, the standard statistical functions can be used if the cell locations are known. To have the best of both worlds, either the database or the standard statistical functions can be used on a spreadsheet if the column headings are in a database format.
Robert G. Parks

7. Iterative Calculations

Abstract
Quattro Pro provides an iterative method of calculation in the Tools menu, Solve For. By using Solve For, an equation can literally be solved backwards; similar to a trial and error calculation. If a given result is required, the variable that will produce that result can be determined. The variable is adjusted by iteration until the equation balances using the specified result.
Robert G. Parks

8. Importing Files

Abstract
One of the most important features of Quattro Pro is the ability to share files with other programs. Spreadsheets and data files generated with the programs (Table 8.1) can be transferred into the current spreadsheet. Complete or extracted portions of files from Quattro Pro can be exported to these same programs.
Robert G. Parks

9. Menu Shortcuts and Macros

Abstract
At times it would appear that many repetitive keystrokes are needed to access the menus. Quattro Pro allows the creation of shortcuts to access a command with a single key. If repetitive typing is necessary to make up the spreadsheet, then the Macros can be of use.
Robert G. Parks

Backmatter

Weitere Informationen