Linking with Excel

Using reports, Netica can send the beliefs it calculates to an Excel spreadsheet.  Described elsewhere is Netica's ability to learn from cases using Excel.

How To:  From the Report menu, toggle the options  Horizontal Format and Include Names, depending on how you want the report to look in Excel (the other options are ignored).  Select the nodes of interest, and then choose Report Links to Paste in Excel.  The belief links (AKA hot-links) will be placed in the clipboard (the destination choice is ignored).

Then, click in a single cell of any Excel sheet, and paste.  Once you have pasted, the belief numbers will appear in Excel, and will automatically change whenever they change in Netica (for example, as a response to entering a finding).

Beautifying:  While the pasted cells are still selected, you may want to choose Format Cells… from Excel, click on the Alignment tab of the dialog box which appears, and then choose Horizontal Left.  It may look better to widen some of the columns.  You can delete any of the pasted names or numbers you are not interested in, and cut and paste the others to move them around.  They can be used as the input for any equation, etc., just like any other cell in Excel.

Netica Exits:  If you stop the Netica program, while Excel with the links is still running, the belief numbers used will simply be the last ones Netica produced.  If you restart Netica then Excel will continue to use the old numbers until you tell it to reconnect to Netica by clicking on any cell with a link in it, then clicking in the "fx" text box for editing the cells contents, and then clicking the green check-mark, or pressing the enter key.

Alternately, you can choose Edit Links… from the menu, and in the dialog box that comes up, click on the first link and then shift - click on the last one so they are all selected, and then click the Update Values button, and then the Close button.  After the dialog box is gone, the links will be reconnected and will remain so.

Excel Exits:  If you stop Excel while Netica is still running, and then restart Excel and open the spreadsheet with links, the reconnection will be made automatically.  If some nets have to be read into Netica because Excel refers to them, and/or compiled or updated, that will happen automatically.

Troubleshooting:  To troubleshoot Excel links with Netica, or to control their behavior, check the following:

Edit Links… They should have "A" in the "Update" column to update automatically.

Tools Options Calculation Update remote references should be checked

Tools Options General Ignore other applications should NOT be checked

Tools Options Edit Ask to update automatic links

 Edit Paste Special is not required when pasting the links.