اسم المؤلف
J. P. Holman
التاريخ
4 سبتمبر 2017
التصنيف
المشاهدات
التقييم

سلسلة مايجب على كل مهندس معرفته عن الأكسل
What Every Engineer Should Know About Excel
J. P. Holman
Southern Methodist University
Contents
1 Introduction 1
1.1 Getting the Most from Excel 1
1.2 Conventions 2
1.3 Outline of Contents .3
2 Miscellaneous Operations in Excel and Word 5
2.1 Introduction .5
2.2 Print Screen or Screen Dump .5
2.3 Custom Keyboard Setup for Symbols in Word 7
2.4 Viewing or Printing Column and Row Headings and Gridlines in Excel .8
2.5 Assorted Instructions .8
2.6 Moving Objects in Small Increments (Nudging) 10
2.7 Formatting Objects in Word, Including Wrapping 11
2.8 Formatting Objects in Excel .11
2.9 Use of Photo-Editing Software in Word, Including Wrapping 11
2.10 Copying Cell Formulas: Effect of Relative and Absolute Addresses 14
2.11 Copying Formulas by Dragging the Fill Handle .15
2.12 Shortcut for Changing the Status of Cell Addresses .17
2.13 Switching and Copying Columns or Rows, and Changing Rows to
Columns or Columns to Rows 17
2.14 Built-In Functions in Excel .18
2.15 Creating Single-Variable Tables Using the DATA/TABLE Command .19
2.16 Creating Two-Variable Tables Using the DATA/TABLE Command 21
Problems .24
3 Charts and Graphs .27
3.1 Introduction .27
3.2 Moving Dialog Windows 27
3.3 Excel Chart Wizard Window Showing Choice of x-y Scatter Charts .28
3.4 Selecting and Adding Data for x-y Scatter Charts .29
3.5 Changing and Adding Data for Charts Using the SOURCE DATA Command .30
3.7 Adding Trendlines and Correlation Equations to Scatter Charts 31
3.8 Equation for R2 .31
3.9 Correlation of Experimental Data with Power Relation .32
3.10 Use of Logarithmic Scales 34
3.11 Correlation with Exponential Functions 35
3.12 Use of Different Scatter Graphs for the Same Data .36
3.12.1 Observations .41
3.13 Plot of a Function of Two Variables with Different Chart Types 41
3.13.1 Changes in Gap Width and Chart Depth on 3-D Displays 44
3.14 Plots of Two Variables with and without Separate Scales 44
3.15 Charts Used for Calculation Purposes or G&A Format 453.15.1 G&A Chart 48
3.16 Stretching Out a Chart from a Single Chart Page 48
3.17 Alternate Chart Sizing Procedure Using MS Word .49
3.18 Calculation and Graphing of Moving Averages .50
3.18.1 Standard Error 54
3.19 Bar and Column Charts 55
3.20 Chart Format and Cosmetics .56
3.21 Surface Charts .58
3.22 Suggested Scatter Graph Setting as Default Chart 59
3.23 An Exercise in 3-D Visualization .63
3.24 Editing Excel Charts Using Word .63
3.25 Editing Excel Tables Using Word 65
3.26 Alternate Procedure .67
3.27 Editing Excel Charts Directly in Word by Using Grouping .69
Problems .72
4 Line Drawings and Embedded Objects in Excel 77
4.1 Introduction .77
4.2 Constructing, Moving, and Inserting Straight Line Drawings 77
4.2.1 Drawing Line Segments in Precise Angular Increments 78
4.3 Inserting Items in Excel with Symbols, Subscripts, and Superscripts 83
4.4 Inserting Equations or Symbols in Word Using Equation Editor .85
4.5 Inserting Equations and Symbols in Excel Using Equation Editor .86
4.6 Construction of Line Drawings from Plotted Coordinates .88
Problems .92
5 Solution of Equations 93
5.1 Introduction .93
5.2 Solutions to Single Nonlinear Equations Using Goal Seek 93
5.3 Solutions to Single Nonlinear Equations Using Solver .95
5.4 Iterative Solutions to Simultaneous Linear Equations 98
5.5 Solutions of Simultaneous Linear Equations Using Matrix Inversion .99
5.5.1 Error Messages .103
5.6 Solutions of Simultaneous Nonlinear Equations Using Solver 103
5.7 Solver Results Dialog Box 110
5.8 Comparison of Methods for Solution of Simultaneous
Linear Equations 111
5.9 Copying Cell Equations for Repetitive Calculations .112
5.10 Creating and Running Macros .113
Problems .118
6 Other Operations 121
6.1 Introduction .121
6.2 Numerical Evaluation of Integrals 121
6.3 Use of Logical IF Statement .125
6.4 Histograms and Cumulative Frequency Distributions 128
6.5 Normal Error Distributions 132
6.6 Calculation of Uncertainty Propagation in Experimental Results .138
6.7 Fractional Uncertainties for Product Functions of Primary Variables 142
6.8 Multivariable Linear Regression .1456.9 Multivariable Exponential Regression 150
Problems .158
7 Financial Functions and Calculations 161
7.1 Introduction .161
7.2 Nomenclature .161
7.3 Compound Interest Formulas 162
7.4 Investment Accumulation with Increasing Annual Payments .168
7.5 Payout at Variable Rates from an Initial Investment .168
Problems .171
8 Optimization Problems 175
8.1 Introduction .175
8.2 Graphical Examples of Linear and Nonlinear Optimization Problems .176
8.3 Solutions Using Solver 179
8.4 Solver Answer Reports for Examples .182
8.5 Nomenclature for Sensitivity Reports 185
8.6 Nomenclature for Answer Reports .186
8.7 Nomenclature for Limits Reports 186
Problems .186
9 Pivot Tables .191
9.1 Introduction .191
9.2 Other Summary Functions for Data Fields .204
9.3 Restrictions on Pivot Table Formulas .207
9.3.1 Ordering of Data Fields and Resultant Graphs .208
9.4 Calculating and Charting Single or Multiple Functions
f(x) vs. x Using Pivot Tables .212
9.5 Calculating and Plotting Functions of Two Variables .216
9.5.1 Display of Formulas and Solve Order .219
Problems .220
References 223
Index
كلمة سر فك الضغط : books-world.net