QnetTool 2000

Automated QnetTool Recall

More sophisticated integration requirements can benefit from the automatic network retrieval capabilities built into QnetTool. Windows based spreadsheet and database applications today have sophisticated macro and programming languages that allow you to build your own custom applications. For a spreadsheet, this can range from a simple macro that automates a single task, to the creation of sophisticated custom applications that contain menus, dialogs, etc. When QnetTool execution is combined with relatively simple macros in your data application, complete automation of network recall can be achieved. An example of simple integration from within a spreadsheet would involve creating a small macro that asks the user what data (or cell range) to use for inputs and where to place the answers on output. The macro would automatically copy the input data, load QnetTool and paste the results back into the spreadsheet when QnetTool is finished. QnetTool would be loaded in automatic mode so that no user interaction is necessary and all computations and tasks take place in the background. A typical macro required to do this would be about 10 lines. It is also possible to connect your macros to "custom buttons" placed directly in your spreadsheet. This simple level of integration provides your data application with powerful access to Qnet neural networks.

To execute QnetTool in automatic mode, it must be run with the following options:

drive:\path...\QnetTool drive:\path...\yourfile.NET RUN

When QnetTool is run with the name of a network definition file as a command argument, it becomes the active network during execution. The "RUN" option (it must appear after the network file) tells QnetTool to load the clipboard data, run through recall mode and copy the answers back to the clipboard. QnetTool automatically terminates after completing these tasks. No user interaction is necessary.

example:

C:\QnetV2K\QnetTool C:\QnetV2K\Samples\OpticalCharacterRec\OptCharRecTrained.net RUN

Sample Excel Macro