Houston Excel SIG: 2002 Meetings Index

	Stock Market Backtest. WebQuery of Historical Stock Prices
	Build Exponential Moving Average and Relative Strength Formulas. Set up Trading signals.
	Use Data Tables to run Sensitivity Analysis
	Use Surface Plots to show results of Sensitivity Analysis.

	Create a Calendar using Formats
	Map Point Demo using Texas Governor 2002 election returns by county.

	Decode historical hurricane tracking text file into numeric data for plotting
	Plot Hurricane Lat Longs on an X,Y chart with a map in the background.
	MapPoint demo to plot Hurricane data.
	Spotfire demo for Hurricane Tracking data.

September 11, 2002 - Creating your own Toolbars, Toolbar Buttons, and Add-ins.

August 14, 2002 - Protecting your Work. Write Once Workbooks

July 10, 2002 - Alan Cherry is scheduled to run this meeting subject to June election results.

June 12, 2002 - ELECTIONS! Alan Cherry will run this meeting.

	Create a Workbook that will automatically get Stock Market data from the internet using a WEB QUERY.
	Then Excel will save the data into an Access Database.

Pivot Tables, Pivot charts and pulling data out of an MS Access Database.

	Simple X,Y Plots. Trend Lines: Linear, Polynomial, Moving Average
	VBA function for Straight Line Linear Interpolation with Array inputs and outputs. smrLinInterp.
	Simple moving average of Stock Data.

	Puzzler: Use Excel to record the current time. Bonus: Record time to the millisecond.
	Using Excel to Process Data and Graph Results from the Leonid Meteor Storm (November 18, 2001).
	Turn an audio recording of Leonid Meteor sightings into a chart that shows meteors per hour as a function of time.

	Puzzler: Sum along a diagonal
	Do's and Don'ts for Good User Interfaces
	Create a vacation/sick employee time card. Color code by whether it is a workday, weekend, holiday, or Impossible (like February 30).