Quattro Pro(r) for Scientific and Engineering Spreadsheets

ISBN-13: 9780387976365 / Angielski / Miękka / 1991 / 110 str.

R. G. Parks; Robert G. Parks

Opis

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.

Spis treści

1. The Spreadsheet.- Help.- Ready Mode.- Menu Mode.- Error Mode.- Cell Types.- Value.- Numbers.- Dates and Times.- Labels.- Label Alignment.- Numbers as Labels.- Repeating Characters.- Formulas.- Operators.- Types of Formulas.- Arithmetic.- Text.- Logical.- Addresses.- Relative.- Absolute.- Moving a Block.- Recalculation.- Mode.- Order.- Functions.- Mathematical Functions.- Statistical Functions.- Database Statistical Functions.- Spreadsheet Statistical Functions.- Logical Functions.- Edit.- F2, the Edit Key.- Cursor Movement Keys.- Files.- Undo Command.- Transcript.- Undo Last Command.- Restore to Here.- Playback Block.- Begin Block.- End Block.- Max History Length.- Single Step.- Failure Protection.- Managing Files.- Screen Display Mode.- ASCII Text.- Graphic Spreadsheet Display.- Printing.- Block.- Headings.- Destination.- Printer.- File.- Binary File.- Screen Preview.- Layout.- Headers and/or Footers.- Break Pages.- Percent Scaling.- Margins.- Dimensions.- Orientation.- Setup Strings.- Format.- Copies.- Adjust Printer.- Spreadsheet Print.- Print To Fit.- Vapor Pressure.- Differential Equations (Runge-Kutta Method).- Differential Equations (Sliding Motion).- 2. Graphs.- XY Graph.- Series.- Text.- First Line.- Second Line.- X-Title.- Y-Title.- Secondary Y-Axis.- Legends.- Fonts.- Customize Series.- Colors.- Fill Pattern.- Markers and Lines.- X- or Y-Axis.- Scale.- Increment.- Format of Ticks.- No. of Minor Ticks.- Alternate Ticks.- Display Scaling.- Mode.- Overall.- Grid.- Insert.- Hide.- Name.- Display.- Create.- Erase.- Autosave Edits.- Reset.- View.- Fast Graph.- Annotate.- Printing.- Destination.- File.- Graphics Printer.- Screen Preview.- Layout.- Orientation.- Inserting a Graph in a Spreadsheet.- Developing the Graph.- Fourier Series.- 3. Matrix Algebra.- Truss Design.- DC Network.- 4. Curve Fitting with Linear Regression.- Damping Force Data Curve.- 5. Database.- Sort.- Sort Keys.- Reset.- Sort Rules.- Search.- Block.- Criteria Table.- Output Block.- Assign Names.- Locate.- Extract.- Unique.- Delete.- Restrict Input.- Data Entry.- Database.- 6. Statistics.- Database Statistics.- Block.- Column.- Criteria.- Spreadsheet Statistics.- Statistical Methods.- Evaluation of Database.- 7. Iterative Calculations.- Solve For.- Formula Cell.- Target Value.- Variable Cell.- Parameters.- Max Iterations.- Accuracy.- Trial and Error Logic.- Vapor Liquid Equilibrium I.- Vapor Liquid Equilibrium II.- 8. Importing Files.- Importing Foreign Files.- Exporting Files.- Importing a Basic File.- 9. Menu Shortcuts and Macros.- Menu Shortcuts.- Macros.- Record.- Paste.- Instant Replay.- Macro Recording.- Name.- Library.- Reading Macro Instructions.- Editing a Macro.- Writing a Macro with Labels.- Debugging.- Standard Breakpoints.- Macro Solve For.