- Excel Desktop Client new !
The EASA system is highly configurable to meet functional requirements specified by a User and implemented in an EASA application (an “EASAP”).
To a large extent, the particular resource requirements above will define the EASA system architecture.
The simplest EASA system combines several EASA computational roles within a single physical machine.
This configuration has the same capabilities of a distributed architecture.
This default single EASA machine provides a simple, way to get going, see Get started with EASA Evaluation on Windows
This architecture is not generally used in production as it will likely struggle under any significant User load. In particular, the Excel resource requirements (memory and CPU) will exceed the single machine's capacity above a modest number of simultaneous Users.
One common configuration involves a backend database and a combined EASA/EASAP Server, below.
The EASA/EASAP Server hosts a user interface, creates database queries, and retrieves result sets.
A similar architecture involves specialized computation on a machine called a Compute Server.
This computation may require Matlab, a C program, a batch script, or other proprietary software.
This type of system may utilize a single-user license on the Compute Server and allow the EASA/EASAP Server to manage a queue of submissions. One User's EASAP may be granted temporary software license access to execute a task. When the task completes, the license will be released to the next User EASAP instance in the queue.
The diagram below shows two EASAP/Excel Servers, though typically in practice there are many more.
A very common use of Excel uses a spreadsheet to conduct an analysis of a business 'case' or 'case record'.
Historically an Author would use the Excel Range Wizard to automatically generate an EASAP with an Excel 'look and feel' and whose GUI elements were linked to an actual spreadsheet running on an Excel Server.
The Excel Desktop Client provides an alternative interface. This functionality involves very specific GUI objects to select a single business case and VBA support has been added to allow a business analysis of the case within an Excel Client.
An Excel Client is an Excel spreadsheet on the User's desktop machine initialized with existing case data from a database
An Excel Client has the built-in capability to write a case record back to the database via an EASA Ribbon→Save click.
An EASAP launches an Excel Client after a case is selected by a User with CASE VIEWER.
This novel architecture is outlined below,