Levels of Complexity

Prodegee defines four levels of complexity:

  1. Programming it: It is the most complex level. To preserve the integrity of the model, I reserve access to the code. This is why instead of an open source licence I have opted for a Creative Commons one, which is more suited for a spreadsheet of this level of complexity.

  2. Populating it: It defines a second degree of complexity. It requires a certain level of understanding of how Prodegee works, which can be attained by someone with a minimum level of MS Excel experience and the understanding of basic accounting principles, who is willing to read and follow the manual. I can carry out this task if I am available and the project employs my services, but it is not essential.

  3. Modifying it:: Once populated, it is relatively easy to modify data in order to carry out financial statements. Doing so requires some level of familiarity with Prodegee in order to identify where the data points are located. It is recommended to use the manual as a reference tool when in doubt, without having to read it in detail.

  4. Using the Dashboard: It is by far the easiest. It does not require any experience in using Prodegee, but just a very basic knowledge of MS Excel in order to use the dashboard, with lists to select items from and cells to fill in with the desired values, all in one tab tailored to the needs of the user. A Dashboard can be prepared by those who learnt to modify values and it only requires very basic MS Excel programming skills.

I typically use Dashboards when presenting data to stakeholders, very especially to high profile officials such as the secretary of a ministry or the power regulator.