Macros and VBA tend to make MS Excel spreadsheets unstable and create problems when changing versions. Prodegee does not use either of the two. This makes it more robust and reliable.
Each cell is colour coded to make it easier for you to understand what type of information it holds.
Prodegee is multi language. It supports up to three languages at a time, being English the one that is always available while the other two can be changed by translating the labels from CONFIG into any another language.
Prodegee can produce and consolidate financial statements for any combination of up to nine different types of stakeholders.
Some accounts (the ones in grey) come by default. As for the rest, you can easily define your own accounts from the tab CONFIG
Many fields provide lists that restrict the potential input values to avoid mistakes and the entering of inconsistent values.
When a user forgets to enter a value that can be easily assumed, Prodegee assumes it.
Many cells have help boxes that inform on what needs to be entered there.
Prosegee uses a combination of help boxes and background colors to inform on errors that could compromise the integrity of the model.
In a database table each row constitutes one register and each column a field. Many spreadsheets do not respect such basic principle but instead organise information inconsistently.
In general, Input Fields (in green) are always in a block located on the left of the worksheet to make it easier to copy-paste content in blocks, for example for updating into a new version.
Having the data organised in a database structure makes it very easy to apply filters.
The database structure, with each record in one row, makes the activation and deactivation of data very easy, which is a requirement for effective sensitivity analysis.
An image is worth more than thousand numbers and Prodegee knows it. This is why it uses charts to evaluate information.
Sheets are protected to prevent formulae from been modified, which could affect its integrity. The workbook is however, unprotected to:
Prodegee allows to create a new tab which can then be used as a Dashboard since the workbook is unprotected. To create it, simply click on the + sign that appears to the right of the tabs, in order to insert a new worksheet.