|
[ Dec. 2001 ] [ Nov. 2001 ] [ Oct. 2001 ] [ Sept. 2001 ] [ August 2001 ] [ July 2001 ] [ June 2001 ] [ May 2001 ] [ April 2001 ] [ Mar. 2001 ] [ Feb. 2001 ] [ Jan 2001 ]
[ About Braincel ] [ Financial Function Links ]
|
6:30-7:15 pm
|
General
Questions and Problems from the Audience
Puzzler: As you create a list, one column will be the
"Primary Key", that is a column where no duplicates are
allowed. A Social Security Number, is an
example. As a person enters data into a list, how can you
check that each new entry is not a duplicate of a previous entry?
Solutions: PuzzlerLists.zip |
| 7:15-8:00 pm |
Using Neural
Networks in Spreadsheets (Alan Cherry)
Braincel, an Excel add-in, will promote an alternative to linear (or
non-linear) regression models for forecasting.
See About Braincel for more information and
Links. |
|
8:00-8:10 pm
|
(Break) |
| 8:10-9:00 pm |
Using Excel
Financial Functions in the Real World. (Rasey)
The basics of discounted cash flow analysis
NPV, - Net Present Value
IRR, - Internal Rate of Return (a.k.a. DCFROR)
the mortgage and annuity functions FV, PV, PMT.
See Financial Function Links on
the Web. |
[ About Braincel ] [ Financial Function Links ]
Files used in the presentation:
 |
The Puzzler Solution (annotated): Entering_Unique_Lists.zip
(231 KB Zipped, 420 KB Unzipped XL97)
|
|
neuro1.zip (740KB
zipped, 2.7MB unzipped.) Contains:
 |
the Braincel Presentation.xls, |
|
Rockdata.xls (the log analysis Braincel test), |
|
NeuroStock.xls Monthly (1926-2001) data of Dow
Jones Industrial Average, Aaa Bond Ratings, Baa Bond Ratings, GDP, and
other macro economic data. Regression
analysis. Quite a handy reference of economic
data. |
|
|
Nural Net.zip
(Alan Cherry's VB Neural Net Excel addin)
|
|
PVFunctions.zip (5 KB
Zipped. Sorry, this is the file I started
with. The one I finished with was not saved. I
will recreate it. Check back again. |
|
