| California Scientific BrainMaker Neural Network Software | ||||||
| Home | Applications | What Are Neural Networks | Products | Ordering Info | Tech Support | |
Using DDEs with BrainMakerThis 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:
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 | ||||||