One Hour App
Home Up Past Meetings Notes Tips Directory Links of Interest Site Map

What is the One Hour App?

One of the members put a very good question to me at the October 2001 meeting.   "We've see a lot of tools and commands you can do in Excel, but what can you USE Excel FOR?"  

Our mission says:  ... each SIG meeting will be designed around starting and finishing a problem within the meeting. ... 

So we created the "One Hour App": a section of the meeting where we build a simple, real world application from scratch. starting with some basics.

I need some ideas from members for projects that are 
     a) well defined, 
     b) have non-proprietary data that can be published 
     c) can be made workable in 60 minutes, and
     d) are interesting, non-trivial, real-world problems.

Ideas that I am kicking around are:

bullet

Investing in Stock or Funds:  If I follow a rule for when to get in and when to get out, how well would that have worked over the last 3 years?

bullet

Time Sheets: to track time by Project, Task, and Person.   Consolidate by Project and Client.   Link to related documents.

bullet

Surveys:  Create an Excel based questionnaire form.    Use drop down boxes,  and tests for completeness.   Have people fill it out via Email.   Add their completed questionnaire to a "database" for analysis.   Analyze the results graphically.    Use Pivot Tables to compare results demographically. 

Please forward other ideas to me and we will get them on the schedule.

 

 

 

For questions or comments concerning content on this website: Stephen Rasey
Design of this site by Cheryl D. Wise
Copyright © 2000-2004 by WiserWays. All rights reserved.
Revised: 2005-07-10 01:09 .