Commented index for EXCEL-worksheets.

Related Sites:
Seminar talk (slides and links), November 1998.

Most of the worksheets indexed here were prepared for specific purposes in specific classes, and some may be hard to follow outside that context. We will continue to get more general-purpose examples and more accessible instructions, aiming at eventually getting one coherent library. Suggestions and feedback are always welcome.

EXCEL skills: Detailed listing of skills and links to sample worksheets. (Kawski, 6/98)
Directory listing (filenames only in ftp-directory).
fx.xls: A programmed demo making a table for a function of a scalar variable, incl. plot, fill-down, and relative addresses.  (Kawski, 1997)
arclength.xls: Demo (incl.pictures) for estimating arclength of parabola compared to arc of the sine. ((no exciting EXCEL features)) (Kawski, 1999)
continuity.xls: Interactive live WORKSHEET for zooming on a graph for continuity at point. Focus on continuity at a point, epsilon-delta characterization. ((Minor bugs: For some combination of function y=f(x), value of delta and eps the scaling of the axes is far from optimal.)) ( Kawski, 9/98)
derivative.xls: Interactive live WORKSHEET for zooming on a graph for derivative at point. Focus on approximability by linear function, Precursor to epsilon-delta characterization. ((Minor bugs: For some combination of function y=f(x), value of delta and eps the scaling of the axes is far from optimal.)) ( Kawski, 9/98)
quadratic.xls: MODEL WORKSHEET for manually fitting a curve through data points: Enter comments, data, make a table from formula, define names, simultaneoulsy plot data points and function graph, format the chart. For elaborate step-by-step instructions see here. ( Kawski, 6/98)
discover_e.xls: Numerical differentiation of functions a^x and b^x. Overlay graphs of a^x, b^x and their numerical derivatives. Observe that derivatives are constant multiples of orig function. Vary values of a, b (and of numerical differentiation increment h) until obvious match happens. Further exploration: Find the multiplicative constant as function of base a. (Kawski, 10/1998)
exponent.xls: A ready-to-use workbook to graphically demonstrate that the families of functions y=a^x and y=b^(kx) with b fixed agree. Simply tune several values of k until graphs match. (Kawski, 9/1998)
dydx.xls: A programmed demo for numerical approximations for derivative of a function fo a single variable. Various difference quotients compared: backward, central, forward etc.  (Kawski, 1997)
linear3.xls: A quick VERY INTERACTIVE look at tables and graphs of linear functiosnof two variables z=mx+ny+b. What do the coefficients tell?  (Kawski, 1997)
linear.xls: Tables of linear functions (single variable review, focus functions of two variables): Recognizing linearity, completing tables with few given data, finding formula for a linear function from e.g. three data-points.  (Kawski, 1997)
carloan.xls: Table of a function for 2 variables (monthly payments).  (Kawski, 1997)
partials.xls: Tables and plots for first and second order partial derivatives (incl. mixed partials) from numerical differentiation. Successive differentiation versus directly using second order divided differences.  (Kawski, 1997)
discriminant.xls: A VERY INTERACTIVE worksheet to get a feel for the discriminant: saddles - maxima - minima  (Kawski, 1997)
chnrule.xls: Chain-rule numerically: Composing a t -> (x,y) -> z.  (Kawski, 1997)
heateqn.xls: A template for the numerical solution of the heat equation. (Essentially a specification of the IC and boundary data, and a ready-made workspace for the calculations.)  (Kawski, 1997)
heatsoln.xls: A sample numerical solution of the heat equation.  (Kawski, 1997)
elliptic.xls: A template for the numerical solution of Laplace's equation. This is brandnew, has not been used in class and is intended for demonstrations. Conceivable uses include exploration of numerical instabilities etc.
( Kawski, 1998, updated w/ instructions for macros 2014, for Office 2010)
speed.xls: Three different parameterizations of the circle. Plots and tables illustrate effects clearly. ( Kawski, 1998)
Fourier approx of heartbeat for calculus II:
heartbeat.xls: Sample data of electro-cardiogram for Fourier analysis. ( heartsol.xls sample solution, heartbeat.html proud picture). Sample data of electro-cardiogram for Fourier analysis. See also MATLAB-pages ( Kawski, 1999)