MS Office applications



Spreadsheet programs are often used for modelling business processes and financial constructions. These programs are used by many people for many purposes, but ad-hoc applications are often lead to intransparent, unreliable models that are difficult to check and maintain. Very often, these models are used only once, even very similar applications are created from scratch.

ModelOffice Ltd offers a better way. We follow the Model-View-Controller (MVC) programming philosophy, which mean that during the development phase we separate the business logic layer (Model) from the presentation layer (View). The business logic is encapsulated into separated moduls and applications can reuse them later for their special purposes. Even very complex models can be created using this development method.

In case of programs developed in MS Excel the business logic is implemented in class modules, using VBA code. VBA is an object-based programming language, so it gives us the possibility to map the business rules and the ralationships among them to object-hierarchies. If a new business rule emerges, the existing applications can easily be updated thank to the MVC development pattern.

Input data can be placed on the Excel sheet, but databases can be used too. The spreadsheet itself is a well-known and familiar user interface, but forms are also can be used if they are requested.

Outputs generated by the aplication can be put into a workbook , but databases can be chosen for this purpose too. Reports can automatically be generated if it is a requirement (e.g: pivot tables). The same is true for diagramms for the easier interpreatation of the results.

We create detailed documentation (User's Guide) to every application.