Home | Programming Resources | * General FAQ * HTML for the Conceptually Challenged * Home Page Builder 2.0 * The CareWare Idea Anti-Spam Electric Duet Excel 7.0 Spreadsheets Home Automation Home Page Builder 2.0 — Help JavaScript Object Tree Browser JavaScript Signal Generator / Spectrum Analyzer Perl / CGI Scripts, C++ Programs Phase-locked loops Regular Expression Laboratory Speak & Search Speech to Text TCP/IP Utilities Version 2.0 Where did my files go? Share This Page

 Summary

 Serious ...

 ZIP format Excel format Description Web List Creator weblist.xls This spreadsheet contains an HTML generator program that converts a boring list of spreadsheet data into a nice-looking HTML page. See my Favorite Places list for an example of its output. Fast Chart fastchart.xls This spreadsheet generates a chart of simple mathematical functions very fast (on a fast machine, anyway). It has mouse controls that interactively change the chart's appearance in real time. It is intended to give math students an intuitive, visual sense of the behavior of mathematical functions. For a background on the use of computers in math education, see my article Computer Math . Unit Conversions conv.xls This spreadsheet provides an easy way to convert units from one basis to another. It includes Length, Area, Volume, Mass, Metric Units (for us dumb Americans), Time and Temperature. Also see my online JavaScript Unit Conversions . Linear Interpolation interpolation.xls This spreadsheet performs the linear interpolation function. Given two x,y data pairs, it calculates the necessary constants to find any intermediate values along an imaginary straight line that connects them. This is important for students to learn, as it has many practical uses in the real world outside the classroom. Another way of saying this: if given two data pairs, for the function y = mx + b , this spreadsheet finds m and b , and these values can then be applied to other points on the line.

 ... and fun

 NOTE: These two spreadhseets won't run correctly if downloaded in place in .XLS format, probably because of an MSIE 3.0 bug. You may want to click on the Excel format links and save the files from Excel right away, and only run them outside the browser.

 ZIP format Excel format Description Earth-Moon Orbit orbit.xls This spreadsheet calculates the path a spacecraft has to travel to go from Earth to the Moon and back again. The user gets to choose the initial position and velocity and discover whether NASA has a very hard job doing this sort of thing. It has nice graphics — a picture of the Earth and the Moon form a backdrop for an animated, orbiting spacecraft. Lissajous Patterns lissajous.xls This spreadsheet creates a nice animation of a constantly changing Lissajous pattern created by two sine functions. You get to choose the "frequencies" of the sine functions, thereby creating any number of interesting moving patterns. Some of my friends tell me they can't stop playing with it. The rest I haven't heard from.

These Pages Created and Maintained using    Arachnophilia.

### Main Page

 Home | Programming Resources | * General FAQ * HTML for the Conceptually Challenged * Home Page Builder 2.0 * The CareWare Idea Anti-Spam Electric Duet Excel 7.0 Spreadsheets Home Automation Home Page Builder 2.0 — Help JavaScript Object Tree Browser JavaScript Signal Generator / Spectrum Analyzer Perl / CGI Scripts, C++ Programs Phase-locked loops Regular Expression Laboratory Speak & Search Speech to Text TCP/IP Utilities Version 2.0 Where did my files go? Share This Page