California Scientific  *  BrainMaker Neural Network Software  *   800-284-8112 * 916-372-6800
California Scientific      BrainMaker Neural Network Software
Home Applications What Are Neural Networks Products Ordering Info Tech Support
What are NN's
Designing NN's
MMX Computers
References
Reviews of BrainMaker
Why BM is best

Products
BrainMaker
BrainMaker Professional
Competitor
Genetic Training
Intro to NN Book
Do I need Professional?
NN Books For Sale

Ordering Info
International Shipping
Order Form
Price List
Upgrade Order Form

Tech Support
Running Competitor
Financial Networks
Is my data OK?
Using hidden neurons
Large datasets
BrainMaker's precision
Predicting Horses
Setting Min/Max

Year 2000

Article Reprints
Testing Concrete
Decoding Sequences
Hospital Costs

Downloads
MMX test software
order form
upgrade form
Pro Forma invoice

Applications

Stocks
Currency Predictions
Corporate Bonds
S&P 500 Index
Stock Price Prediction
Stock Prophet
Natural Gas Prices

Business
Direct Mail
Credit Scoring
Real Estate Appraisal
Bad Cops
Finding Gold
Jury Summoning
Highway Maintenance

Medical
Breast Cancer
Hospital Expenses
Functional Recovery
Heart Attack Diagnosis
ER Test ordering
Psychiactric Care
Giant Cell Arteritis

Sports
Thoroughbreds
Thoroughbreds 1
Dog Racing

Science
Solar Flares
Protein Sequencing
Mosquito Identification
Spectroscopy
Weather Forecasting
Predicting El Nino
Air Quality

Manufacturing
Welding Quality
Plastics Testing
IC Quality Control
Paper Quality
Concrete Testing
Beer Quality
Enzyme Synthesis
Steam Quality

Pattern Recog.
Speech Recognition
Article Classification
Working with Chaos
Chemical Drawings
Sequence Prediction

Using DDEs with BrainMaker

This demonstration illustrates the use of Dynamic Data Exchange (DDE) to pass data from a client application into BrainMaker for processing and send the results back to the client. Here, Microsoft Excel is the client. This process is documented in Chapter 11 of the BrainMaker manual.

A PowerPoint demonstration of this process is available here. If you don't have PowerPoint, you can download a viewer from Microsoft here.

If you have Excel installed on your computer, you can download two test files, an Excel spreadsheet and a BrainMaker network in DDE.zip. Each contains DDE links to the other, so they must be opened in the following way:

  1. Open ddetest.xls in Excel. You will be asked whether you wish to update all linked information. Do not answer just yet.
  2. Start BrainMaker and read the network file ddelogic.net.
  3. In Excel, answer Yes to the open dialog in order to update all linked information.
  4. If you are asked whether you wish to start BRAINMAK.EXE, answer No.
  5. You will be prompted to select a data source. The highlighted entry will be "brainmak|ddelogic.net". Click OK.

The data links are now active in both directions. Notice that columns 3 through 6 in Excel are filled with data computed by BrainMaker. Notice that the displayed data in BrainMaker correspond to the last row of data in Excel, i.e., row 5.

In BrainMaker, under the Edit menu, select "Data Link" to display the link information. There are three fields. The first is the application, which is the name of the running program. The second is the topic, which is interpreted by Excel as the spreadsheet filename; in general, though, an application can interpret topic any way it wants. The third field is the item, which specifies the exact data to be processed by BrainMaker. The syntax of the item field is specified by the client application; here it is given so Excel will understand it. BrainMaker asks Excel for a rectangle of data from row 2 to row 5, i.e. 4 rows of data, and from column 1 to column 2, i.e. 2 columns of data. The number of rows is the number of facts that BrainMaker will process via DDE, and the number of columns must be the number of input neurons of the running network.

Click Done to end the dialog without changing the open link.

In Excel, click on any cell in column 3 through 6 and row 2 through 5. Notice the formula, which requests data from BrainMaker. "f3n2", for example, means the second output neuron value in the third fact.

In Excel, edit any value in the first two columns. Notice that the values in columns 3 through 6 follow this change. Each time you change a value in the rectangle of data requested by BrainMaker, the block's new values are sent to BrainMaker for processing and the block of output values are sent back to Excel.

Home Applications What Are Neural Networks Products Ordering Info Tech Support
California Scientific      BrainMaker Neural Network Software

California Scientific
Sales@CalSci.com • 800-284-8112 • 916-372-6800