This report is made in support to the international open data movement, and to generate insights to help optimize the procurement process of procurement entities. For this report, State University Data is used, although the method is applicable to all procuring entities in general.
Please note that Layertech is not giving any conclusive statements about the agencies and organizations mentioned in this report. We highly encourage that additional research and validation be conducted when using the information stated in this report.
This report is a use-case created under the Open Contracting Grant of Hivos. The views and insights in this document do not necessarily reflect those of Hivos.
Kindly take time to read the notes, recommendations, scope and delimitation mentioned in this report.
This is document is under CC3 License. This is produced by Layertech. Please do not use the information without proper credit and/or Link to our website. For more information, comments and suggestions, please contact learning@layertechlab.com or visit www.OCDEX.tech
The Annex C of the 2016 Implementing Rules and Regulations of the Government Procurement Reform Act (GPRA) Defines the Minimum, Maximum, and Recommended Operational Timeline for each step of the procurement process.
Below are visual timelines for the procurement of Goods and Services, Infrastructure Projects, and Consulting Services.
For more details, please refer to the 2016 Implementing Rules and Regulations of the GPRA LAW found HERE.
This report is made in
support to the international open data movement, and to generate business
insights from open procurement data to help suppliers be more efficient and
competitive when joining government procurement.
Please note that Layertech is not giving any conclusive
statements about the agencies and organizations mentioned in this report.
We highly encourage that additional research and validation be conducted when
using the information stated in this report.
This report is a use-case
created under the Open Contracting Grant of Hivos. The views and insights in
this document do not necessarily reflect those of Hivos.
Kindly take time to read the notes, recommendations and delimitation mentioned in this report.
This is document is under CC3 License. This is produced by Layertech. Please do not use the information without proper credit and/or Link to our website. For more information, comments and suggestions, please contact learning@layertechlab.com or visit www.OCDEX.tech
PhilGEPS releases Philippine procurement datasets in excel format. These are downloadable in their official PHILGEPS OPEN DATA PORTAL.
Below is a mapping Layertech and Partners in Legazpi made to convert PH-based procurement datasets to OCDS format. This is being used by partner researchers, developers, and students to create localized procurement monitoring tools.
PRE-REQUISITE: You must have R and R Studio BOTH installed in your computer. If you don’t, download the installers on the following links and install them to your computer!
R - https://cran.stat.upd.edu.ph R Studio - https://www.rstudio.com/
Once your have R and R Studio both up and running, we can now proceed to the filtering!
STEP 1 – Go to www.PHILGEPS.GOV.PH and go to the “Open Data” Section. Try downloading the excel files they have over there. We often use the datasets of the Invitations to Bid and Notices of Award.
STEP 2 – The files are in XLSX format. We prefer to export them to CSV because its easier to ingest and because csv is #OPENData format. So yeah. ALSO! Make sure that the rows do not have blanks on the top. The top row will automatically become the ‘header’ once it is ingested in R Studio so make sure the top row is the row that contains the column labels (except if you you key in more lines of course, so let’s keep it simple).
STEP 3 – Ingest the CSV file in RStudio as a dataframe. Normally, we do the following:
DATA_FRAME_NAME = read.csv("PATH/TO/FILE.csv")
STEP 4 – Now that you have a dataframe in R, you can now perform basic operations on it. For example, we normally filter the name of the agency that we are interested in. For example we do something like:
JUL_SEP_2018_sub <- subset(JUL_SEP_2018, Organization.Name=="DEPARTMENT OF HEALTH - REGIONAL OFFICE V")
We now have a NEW Dataframe, with only the data from Department of Health Regional Office 5. 🙂 But remember! The stings are case sensitive so you have to make sure that you are inputting the correct name. You can do a quick search in the raw table and copy-paste the parameter just to be sure 🙂
You can perform several other operations on the dataframe! You can remove columns, count occurrences, join two or more dataframes, and more. To find out more operations, you can google for “R Cheatsheets” for commands and examples.
STEP 5 – If you are satisfied with your final dataframe, we request that you save it as a CSV file through the following commands:
This is because, chances are, some other researcher, or concerned citizen (who isn’t familiar with R) would need the dataset you just made. Sharing is Caring! 🙂
STEP 6 – Finally, you can share your cleaned datasets in our repository! We will make sure to credit you with your preferred name/nickname. Send us your dataset and we will upload it for you (for now. We are working on a way so that you can upload by yourself :) )
All data uploaded will be available as open datasets. They are free for all, so that we can encourage more and more researchers, advocates, to use data and be data-driven in their decision making.
Thank you very much! For more information, kindly email support@layertechlab.com. From time to time, we conduct hands-on trainings! Please let us know if you are interested!
The IT industry has come a long way to its existing shape where it is playing a very dominant role in our sphere of life. It has made revolutionary changes in information gathering and dissemination as well as in global communication. The advancement in the field of information technology helped many people in terms of storing, retrieving, transmitting information, and in communicating. Today, people are still looking for ways and inventing things that will benefit those in the future generation.
At present, the figures being presented at Philippine Government Electronic Procurement System (PhilGEPS) is too technical that the public is having difficulties in understanding its contents.
With such findings, the researchers believed that a well-managed, web-based, Open Contracting Data Standard(OCDS)-based, Monitoring System that uses data visualization can improve the current state on how the taxpaying public understand the procurement process of the Philippines.
The proposed SeeLog: OCDS Based Procurement Portal will provide the compliance checking of the documents of the tendered items/services. A module will also be provided by the researchers that will mark low-rated procurement transactions for future investigation. The public, on the other hand, will be provided by a Freedom wall where they can show their thoughts and comments. The module will also track the complaints sent by the general public and send it to the concerned parties as feedback mechanisms.
Note: SeeLog is developed by graduating Bicol University IT Students, as interns, under Layertech Software Labs and Bicol University partnership for the OCDEx Project.
The next step would be a pilot phase, integration to live OCDEx portal.
Open Contracting Portal
Test
Do you like our site?
Please consider making a kind donation to help us maintain and improve our work.
Cookie Consent
This website uses cookies or similar technologies, to enhance your browsing experience and provide personalized recommendations. By continuing to use our website, you agree to our Privacy Policy.
Cookies
This website uses cookies or similar technologies, to enhance your browsing experience and provide personalized recommendations. If you think that's ok, just click "Accept all". You can also choose what kind of cookies you want by clicking "Settings".
Read our Privacy Policy