FINCAP – Financial Stability

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH is running Rural Financial Insitutions Programme.
For this they need a tool that can convert vague incomplete verbal answers in a statitical data that can be further used for diffrent numeric manipulations. Since the data need to collected from rural areas where the internet connectivty is not available and so it could not be a web based solution. The peoples being scanned has very little knowledge about financial management so sometimes it would become very difficult to get the proper information so a hard paper form cannot be a solution.

Here we suggested a solution using the excel and VBA for excel. A huge database though impractical but still this was the only solution at that time in the current limitations.