Services

. . . providing business with data, spreadsheet & reporting solutions.

Our services revolve around sound data design principles - get that right, and the rest follows. The following outlines some steps taken to develop effective and usable spreadsheets. These steps are not necessarily sequential, but overlap and support one another. . .

Data Structure & Design

Everything in a spreadsheet depends on sound data design. The nature & structure of the data in the spreadsheet should enable rich business insights & reporting. Maximise the potential with superior design.

Data Validation & Cleansing

Data entered or imported to the spreadsheet can be validated & cleansed on a number of levels. We are experienced in developing algorithms that can identify data errors based on your rules, and rectify.

Data Entry & Restriction

Data entry can be restricted so data conforms to your business rules. The most common and simplest is the Excel 'Data Validation' using defined lookup lists that provide in-cell drop down lists.

Formulae & Functions

As a development principle we always use formulae to solve a problem before using VBA - its faster & cheaper. When required, specialised functions can be developed.

Data Import & Transformation

We have developed many solutions that involve data imports - for example, data from corporate or external sources. Often this data needs to be be checked and transformed before the import to a form suitable for the import, and subsequent reporting.

Automation with Excel VBA

For times when the standard Excel offering will not solve a requirement, we can develop macro code (VBA) to manage the business needs.