The Petroleum Institute of East Africa (PIEA) is the professional body for the oil and gas industry in the EA region. PIEA Is tasked with the mandate of capacity building in the industry by engaging petroleum associations and stakeholders in the EA region in the establishment of harmonized standards & practices.
We developed a standardized excel templates for the client which would be shared with the stake holders. We then developed macros to extract data from the templates and generate csv files.
We also developed a web portal with different access levels, the stakeholders would use this portal to upload the generated CSV files. Interested third parties would access the portal to request data and upon payment would receive the datasets.