New Page 3

"EasyWebWare™ User Interface"

Selection hierarchy ( Document Control). Each application is described by a hierarchy of entities with calculations on the lowest level. The calculation set is a group of related items that can be identified and are used as “what if” scenarios. Once entered, an internal temporary work is created where the “what if” scenarios can be reworked, saved, copied, etc. The EasyWebWare™ Tool application sets up in a hierarchical or tree structure with entities from the top down until the calculation set level. Each Calculation set is the lowest portion of the tree. The calculation set can be individually saved (think of it as sets of “what ifs” that are worked with). The calculation set is a self contained or functionally independent group of work sheets. One displayed web page is a typical calculation set. The creation of all entities and calculation sets is under control of the user (not programmers).

You can

Link cells with hierarchy by using "Entities". One can link workbook data with the entity (or a part of entity if entity has multiple parts) hierarchy. User via UI selects a cell to be linked with the entity and every time the cell on the web is filled – the corresponding part of the entity if filled automatically.
EasyWebWare™ additional functionality. The following functionality is made available with the EasyWebWare tool.
Convert range. Convert to Web only a selected range. This allows the user to hide an intermediate results or admin data. Even non-converted formulas take part in the calculation. There is also an ability to skip a worksheet even though all its formulas and data will be a part of calculation.
Hide and show. Based on the user provided formula values via UI, the user can control appearance/disappearance of the selected range or the entire worksheet.
Worksheet splits. Using UI the user can split a single worksheet into multiple web pages to improve visibility and design efficiency.
Security. Applications and proprietary data are safe from theft since computations and data are stored on a secure server. What the outside world sees is what you want them to see in the web browser. User can assigns rights to use different sheets as read only or apply protection to workbook elements and protect from viewing or changes. Different users through access rights may see only the data they have rights to see. Specific objects can be hidden based on a set of rights. One could allow the user to create their own “What Ifs”, but not to see certain type of data like formulas used to create tax calculations, or not allow a set of users to perform functions such as save or delete. An Example might be the users of a parts department not being able to see Human resources data. Another example is the Manager of a department may be able to see specified HR information (not all) of his department, but not another section or department.
Override with constant. Normally the user’s input in a cell will override its prior content. Using UI the user can select such cells to preserve their content if no user input to the cell has occurred. The cell on the web will be represented as an input box where the user can enter the value. If this has happened, the entered value will be used in calculation and the original value or formula will be ignored. If no input has been entered – the original value or formula will be used in the calculation.
Override with formula. Special UI allows the user at runtime (in the browser) to change particular formulas (selected at conversion time). MS Spreadsheet object is used to maintain Excel-like appearance to the user.
HTML/XML communication. HTML/XML interface allows “behind the scene SQL calculation execution”, which consists of the following steps: accepting an HTML/XML document from the other application, authenticating access rights and validating HTML/XML data, storing input data, calculating, sending back results or error messages. The entire HTML/XML conversation is performed in the real time mode (for instance: 6 years assignment with approximately 1000 iterations each year takes about 5 sec.)
Replace. Using UI the user can select a formula which contains a workbook/worksheet name, a place in the main workbook to substitute for and an event to start the replace. This allows the user to use additional logic or logic and UI from different workbooks based on runtime value of the formula-driver. Thus, the user can create a single workbook with UI and logic and then keep adding new ones within the time without ever rebuilding the system

User’s Output.

Excel Dump. There is a run time capability to convert web pages into excel worksheets. Tool’s UI allows the user to pre-select web pages as a group and store them, then in runtime the user only needs to select a group to convert them to Excel. There is also a runtime interface to select web pages to be converted right away.
Printing. The same pre-select and runtime technique is used for printing.