blue bar
Logic Architect - simplifying data management

Excel and data

We are specialists in building models in Excel. Our data-driven approach combines maximum flexibility with ease of maintenance.

Most business workbooks exist to record and analyse data. How this data is stored and then managed is, we believe, one of the most important factors in creating effective workbooks. We have developed a range of tools in VBA which simplify the maintenance, analysis and reporting of the data. The benefit to the user is in ease of maintenance of the data and the flexibility possible in how the data can be analysed and reported.

Our approach

Our approach for new models is:

We are also experienced at working with existing workbooks and deriving maximum benefit from the existing data structure.

For more information on this, please see the Database page.

Template workbooks

Another situation we often see is where a workbook is being used as a "template", where it is reused for a number of different data sets. A common example of this is a quote system where quotes are prepared for different clients. Often such workbooks will contain multiple worksheets of the same design, but with different data.

Normally the resulting workbooks are each stored separately. The problem with this approach comes when the user wants to change the design of the workbook. The new design can easily be applied to any new data sets, but it is almost impossible to get existing data into the new design without laborious retyping or copying and pasting. We have developed a solution to this problem, which allows the data to be separated from the workbook and stored in xml files, or alternatively allows multiple datasets to be stored inside the workbook. This makes it easy either to load different data sets into a single worksheet or to load data into amended versions of a master workbook. For more information on this, please see the Template page.

To follow up...

If you are interested in this and would like us to look at any Excel problem you may have, please use our Contact page.

Cookies are used for navigation purposes within this website.