Logic Architect

A complete Excel-based development tool - database, report generator and logic.
 

Logic Architect Review

Logic Architect enables you to bring Microsoft Excel's speed of development to the creation of systems far beyond the range of normal spreadsheets. It provides a complete development environment which is entirely worksheet based, and normally requires no user VBA programming. It includes a full relational database (multi-user if required) which can be retrieved through functions, browsed, queried and updated entirely within worksheets; a powerful report generator and worksheet-based file processing and program logic tools. Any area in your worksheets can be used to display data from a database file, either as a form (one record at a time) or as an independently scrollable table. Controls are provided to select and browse the data, which may also (optionally) be updated. There is extensive validation, generation of default values, automatic generation of drop-down lists and user help text. Optional automatic formatting can give the worksheet the look and feel of a forms-based system, and windows can be created and sized automatically. Temporary database files can be generated dynamically. In the multi-user version, the data may be simultaneously updated by many users on a network. The report generator produces multi-sheet report sets with user selection and drill-down capability, which can be used by any Excel user even without Logic Architect installed. Reports can include lists, cross-tabs and charts, all of which are regenerated dynamically in response to user selections. Excel formatting can be used. A system's processing is handled through Logic Sheets (worksheets in a predefined format), which provide extensive capabilities to handle and update data from worksheets, database files and other types of file. Data can easily be sorted, merged, joined or cross-tabbed in a variety of ways. Logic is defined using Excel formulae, and processes can be run using buttons or menus, or automatically in response to worksheet events.