Audio By Carbonatix
As an example, if ECG database for say Maamobi is exported into Excel (CSV or any format), that will give a certain number of individual accounts that fairly represents each household when you sort it out based on their digital addresses.
The data would have columns for primary account holders’ names and mobile phone numbers. Now you can create additional columns for number and details of people living at each digital address. You can simply use the COUNT formula to count from the NIA database the number of people registered with the same digital address.
You can then use “IF” and other formulas combined to pick the names and phone numbers of all persons registered by the NIA with the same digital address and paste them in separate columns against the primary ECG account holder that match that digital address.
You can then populate the rest of your adapted ECG database. You can use any other parameters to rank the level of need of each household, if you want to. This will take only a few hours to do, even with my limited skills in the use of Excel Macros.
Once you have this base document, you can do two things:
First of all, due to the urgency of the situation, you can just pay a certain minimum amount to each household, based on the number of persons living at that digital address, via mobile money, working with the Telcos.
For homeless people, you can aggregate them under the Gender Ministry Household. Since the Ministry has already documented Kayayes and the rest of them, they have all the phone numbers of these individuals.
So make one bulk mobile money transfer to the Gender Minister and the Ministry can make onward transfers to the registered individuals.
Secondly the government can also upload the base data onto an online portal, and ask people in each community who need help from government to visit the portal, locate their names and check a box.
Make it known that the list of those who receive help would be subsequently published for transparency and accountability. That way, only those who really need help will take advantage of it.
Latest Stories
-
TCDA to establish 16,000 hectares of tree crop enclaves across all 16 regions
17 minutes -
Pending applications won’t halt Kpandai parliamentary rerun – Kwame Akuffo
18 minutes -
Adwoa Safo says her political future lies with Bawumia rather than Kennedy Agyapong
24 minutes -
Black Stars to face Germany in pre-World Cup friendly on March 30
32 minutes -
Hiving off AG’s powers to OSP without amending Article 88 is unconstitutional – Kwame Akuffo
39 minutes -
AG has constitutional authority over OSP, including power to enter nolle prosequi – Kwame Akuffo
1 hour -
Visa, Absa Bank Ghana launch Absa Pay, Ghana’s first issuer wallet
1 hour -
Ghana-U.S. partnership deepening under new policy direction – Deputy Assistant Secretary
2 hours -
GPL 2025/26: I am ‘unfairly treated’ – Karim Zito hits back at critics
2 hours -
Health Ministry holds first Midwives’ Innovation Hackathon, showcases bold frontline solutions
2 hours -
Ghana: How the theft of a small engine part is fueling pollution, crime, and a deadly health crisis
2 hours -
Jubilee House confronts corruption as new survey signals shifts in bribery trends
2 hours -
Rickie Hurtubiase wins Gridco Centre of the world Golf Club championship
2 hours -
Black Galaxies hold first training session ahead of South Africa friendly
2 hours -
Mothercare School pupils shock Medical Trust Fund with ¢8000 donation following clarion calls for support
2 hours
