ATEBION Business Modeller
- Lots of spreadsheets.
- Different financial systems.
- Different databases.
- Bring all this information together each month, see variances and investigate "what ifs".
- Build a full business model and be able to improve it and alter as and when there is a benefit.
- Reliable and error free.
- Easy to understand.
- Require the minimum of time to assemble each month so that you have the maximum time to consider appropriate actions.
Using powerful new innovative software, it is now possible to link tens, hundreds or even thousands of sheets into one super model, all arranged in an modifiable tree structure making navigation very easy, just like folders in a file manager. It allows accountants, and financial planners to assemble an overall Chart of Accounts as electronic tree structures - from the top down or from the bottom up.
You don’t need knowledge of advanced mathematics or programming to design, create and maintain a model. All you need is a clear understanding of your organisation, how things are calculated, and what information and reports they require.
Easily combine different file formats into a single model where additional columns, rows and sheets can be created. Create, substitute or modify trees or branches or groups of sheets that may have been updated by different operators. Inter-relationships of the component sheets are defined unambiguously and with meaningful descriptions attached to every cell in each and every sheet.
Columns and rows from different sheets can be brought together into individual reports and exported to other systems if required. No matter how big the sheets, it takes only seconds to create variances.
Using equations instead of formulae, the system allows you to model the way YOU operate without having to find workarounds.
Others can follow your logic because each equation uses meaningful names. Add comments to offer even greater clarity.
For example, try expressing this as a single formula in a spreadsheet:
Staff Cost + Equipment Cost + Overhead cost = Unit Cost * Workload
{Staff cost includes on-cost. Equipment cost needs to be looked at again.}
Recent research by one of the UK’s leading auditors has shown that 90% of all spreadsheets with more than 150 rows contain errors of one sort or another.
Atebion has unique and comprehensive diagnostic tools for validating equations and finding logical errors.
It simplifies audit checking by an order of magnitude - as our many existing users can testify.
For many Financial Directors, this is its greatest asset: the ability to completely eliminate all those
logical discrepancies and errors that are almost inevitable when using conventional spreadsheets.
Use your OWN language to build your model.
Bid farewell to such complex expressions as '=COUNTA(J$2:J$101)' and '=+L50+SUM('Funding'!L16:L21)'.
Go back to plain English.
Atebion is robust. It allows you to experiment with
the model with confidence. You do not need to know how to re-arrange an equation to play "what ifs".
This cuts down mistakes and giving you confidence. At any time you can decide which values in the model are to be
known and which values are unknown and therefore to be calculated. This means you can reverse inputs and outputs without
changing your model. In spreadsheets you would need to re-design and more importantly, physically re-structure,
your sheets and know how to re-arrange equations for each “what if” situation.
Many real systems involve feedback processes; for example cross-charging overheads: 'A' depends on 'B'
which itself depends on 'A'. These can only be solved by the use of simultaneous equations.
Atebion solves these automatically, without the user even realising that
advanced mathematics has been employed.
- A facility to define limits for particular cells, for example to ensure that you stay within budgets and resource restraints
- An optimisation facility to find the minimum or maximum value of a chosen cell.
We have many standard models available for customisation. Full training and assistance in building models is available on a consultancy basis if desired. Alternatively, a bureau service is available to build and manage models to your specification.
Please contact us for a no obligation demonstration and judge for yourself.
If you experience any problems with
this website, please send email to
webmaster@gwacc.com