COC Processing – Data Entry
Choose which form you want to fill in.
Choose which form you want to fill in.
Thank you po sa lahat ng nagmahal samin na mga e-cos sa RMMSCD LF.
Thank you mga ma’am and sir, we’ll miss you po. Muahhh
© 2026 E-COS · Developed by Junny I. Padayao · v94.91
Department of Energy
Oil Industry Management Bureau
Retail Market Monitoring and Special Concerns Division
For issuance of Certificate of Compliance (COC) – LFRO data entry form
Finished with this record?
For issuance of Certificate of Compliance (COC) – TSRO data entry form
Finished with this record?
Pick a saved record, complete the additional details, then download the Word certificate.
Outlet, owner, address, tracking number and recommendation come from the saved record – change them in the evaluation form. The reference code, date of issuance and validity can be edited below and are saved back to the record.
Tap a title to open or close it.
The workflow in three moves
Fill in the evaluation
Open LFRO or TSRO and complete the form.
Save the record
Kept in this browser. Editing updates the same record.
Export your files
Excel, Database, COC and Memo in Word.
The main menu
Each tile opens one screen. How the menu looks depends on the menu style chosen in Settings.
Inside an evaluation form
APPLICATION RECORD AND RETAIL OUTLET
LOCATION
VALIDATION OF DOCUMENTARY REQUIREMENTS
TECHNICAL EVALUATION · UNDERGROUND TANKS
MANDATORY STANDARDS AND REQUIREMENTS
EVALUATION, FIELD VALIDATION, RECOMMENDATION
Always visible at the bottom of the screen.
Outlet details
Name, owner, contact, tracking number. Required fields are flagged if empty.
Location
Region, Province, City, Barangay in that order. The Island fills in by itself.
Documents
Pick New or Renewal. Only that checklist can be ticked.
Tanks
Units and capacities separated by commas, for example 16, 24. Totals are worked out for you.
Standards
Tick what the submitted documents show.
Recommendation
Choose the outcome. Give reasons if a COC will not be issued.
Save
Reopen a saved row to edit it. Saving updates the same record.
What each record can produce
Pick the right tool
Map view
See saved outlets as coloured pins, set a pin and jump to the record.
QR code
Make QR codes for links and text, such as seals, memos and certificates.
Quick Analyst
Load Excel or CSV tables, link them, graph the result and turn it into slides.
Presentation Maker
Data to PowerPoint in the COC look. Preview, reorder and present.
Map view · saved outlets on a map
Recommendation
Outlet name
Owner · LFRO
Find an outlet
Search by name, owner or address, or filter by recommendation.
Open a pin
Tap a pin to see tracking number, decision and validity.
Set the pin
Place or move the pin, use your location, or paste coordinates or a Google Maps link.
Go to the record
Open the record, or make its COC or Memo.
Quick Analyst · from files to a PowerPoint
Add files
Drop CSV or Excel files, many at once. Or try the sample data.
Link tables
Optional. Join two tables on a shared column like an ID.
Choose result
Pick the columns you want in your result.
Graph
Build a chart from the result rows.
Download
Preview, start the slideshow or make the PowerPoint.
Presentation Maker · data to PowerPoint, in the COC look
Bring in the data
Open from the main menu. It opens in its own full-screen panel.
Check the slides
Preview each slide. Reorder, add section dividers, edit speaker notes.
Present or export
Start the slideshow, or download the PowerPoint or a PDF.
Slides swap places when you reorder them. Back to COC returns you to the menu.
QR code · seals, memos and certificates
Enter link or text
Type or paste what the code should open.
Check it
The quishing guard warns about risky links.
Download
Print-ready export, or batch from a CSV.
Keep a record
Every code goes in the register.
Quick Analyst and Presentation Maker load only when you first open them
The first open may take a moment. The QR code generator works offline.
Separate forms for each outlet type that mirror the Evaluation Excel templates. Required fields are checked before you can save, and the first empty one is pointed out to you.
Choose Region, then Province, City / Municipality and Barangay from built-in Philippine lists. The Island fills in by itself, and you can still type a place that isn’t listed.
Pick New or Renewal / Change name / Change owner, and only the document checklist for that type can be ticked.
Enter the number of units and the capacities for each product (for example 16, 24). Totals are worked out for you, and text that isn’t a number is flagged.
Tick the mandatory and minimum standards. Chips at the bottom show documents ticked, standards ticked, total units and total capacity in KL as you go.
Type 25102026 and it becomes 25/10/2026. Date and time received uses the date-and-time picker.
Save a record, reopen it to edit, and save again to update it without creating a duplicate. Records are kept in this browser, so back them up regularly.
Saved records come first, each with Excel, COC and Memo buttons. Tiles count LFRO, TSRO and records that need attention, and the search box looks through outlet, owner, address, reference code and tracking number.
Use the Sort by menu in the Worklist (date, outlet, owner, needs attention, recommendation, province, reference code, date saved) or tap a column heading in the saved records tables. Your choice is remembered on this device.
In the Worklist style, a clock runs on new forms from your first keystroke until you save. The save popup shows how long it took and flags a personal best, and each record shows its time.
On by default. It shows your fastest time, your average time and how many records you saved today at the top of the Worklist; turn it off in Settings if you prefer.
On the main menu, swipe left or right (or use a two-finger trackpad swipe, the left and right arrow keys, or tap the two dots at the bottom) to switch between the Worklist and Geometric styles.
On the Geometric style, the tiles rise in one after another, the statistics count up and the LFRO / TSRO bar fills, and the shapes drift slowly in the background. You can turn this off in Settings; it is also off automatically if your device is set to reduce motion.
When the app opens on the Worklist style, it first shows the Geometric style, then swipes into the Worklist. Tap or press any key to skip it, or turn it off in Settings.
On the Worklist, the stat boxes, chips and rows rise in when the app opens and the headline numbers count up. Records that need attention have a soft pulse, the list glides smoothly when you filter or search, and a newly saved record flashes when you return to the menu. Rows and buttons respond to touch with a ripple. You can turn this off in Settings; it is also off automatically if your device is set to reduce motion.
When a saved record beats your fastest time, confetti drops on the save pop-up for a few seconds.
At the bottom of the LFRO and TSRO forms, tap Back to main menu to leave without scrolling to the top. Back to top takes you back up to keep editing. Unsaved entries are kept as a draft.
Fill the LFRO or TSRO template for one record, build the combined DATABASE sheet, or download all records as a ZIP. After saving a record, the pop-up has Copy for Excel for that record’s Database row.
Choose a saved record, add the reference code, trade name, invoice number, date and amount, then download the COC as a Word file.
Outlet, owner, address and dates come from the saved record. Choose the salutation, and the address is laid out on one, two or three lines to fit.
Save every LFRO and TSRO record into one file. Restore by adding only the missing records or by replacing everything, and undo the last restore if it wasn’t what you wanted.
Choose Office Live, Geometric or Worklist, and switch between light, dark and white looks. The layout works on phones, and the guide links to Viber for sending feedback.
When the app opens, shapes orbit the DOE emblem, the “COC Hub” title appears, and the screen opens onto the menu. Click, tap or press Esc to skip. You can turn it off or preview it in Settings.
See every saved outlet that has a latitude and longitude on a satellite map with place and road names. Pins are coloured by recommendation, and an orange pin means the COC expires within 90 days. For an outlet with no coordinates, press Find on Google Maps, check the place, then paste its coordinates to save them. It needs internet; without it the positions are shown without a map.
Click a record’s tile in the Worklist to open its record window. Add photos or PDFs of the paper documents, view them full size, rotate and zoom, and open the Excel, COC and Memo from the same window. Scans stay on this computer and are not part of the Backup file.
In the Worklist, press Download CSV (next to Database and Map view) to save every LFRO and TSRO record into one CSV file that opens in Excel. It includes the form fields, the COC details and the COC released date. A Record ID column at the end lets the app recognise each record.
Press QR Engine in the Worklist, or the QR CODE tile in the Geometric menu. Make QR codes for seals, memos and certificates, with a quishing guard, print-ready export, batch from CSV and a register. It works offline.
In the Worklist, press Upload, choose Excel database and pick the monitoring spreadsheet. Choose rows to add or add everything new. Records are added without an evaluation and show an Imported tag. Upload a newer sheet to update existing records (fill blanks, refresh dates) and review repeated rows side by side.
In the Worklist, press Upload, choose CSV file and pick a CSV made by Download CSV. The app shows how many records are new, then you choose Add everything, Add missing records only or Replace everything. Replace can be undone from Settings, Backup and restore.
Use it to record COC evaluations for LFRO and TSRO outlets. You fill in the evaluation form, save the record, then export Excel files, a Database sheet and Word documents (Certificate of Compliance, Memo, Letter and Blindcopy).
Your records are saved only in this browser, on this computer.
The light/dark switch at the top of the page changes the look. The gear icon opens Settings, where you can choose the menu style (Office Live, Geometric or Worklist). In Geometric, pick LFRO or TSRO first, then Evaluation, COC or Memo. Worklist lists your saved records, each with Excel, COC and Memo buttons, and a search box (outlet, owner, address, reference code or tracking number). The icon beside the gear opens this guide.
If the owner's name looks like a person's name, you must choose a salutation before the file will download.
Found a problem or have a suggestion? Send it to us on Viber.
Open Viber, tap the QR scanner and scan this code.
The button works if Viber is installed on this device.
Please include:
Changes apply right away and are remembered on this device.
Click, tap or press Esc to skip it while it plays. It is skipped when your computer is set to reduce motion, and it does not play again when the app refreshes itself.
Send saved records to a SharePoint list. Desktop app only; it needs internet when you press Send. Ask your IT admin for these four details.
The Help button sits in the bottom-right corner. F1 always opens the help chat.
Leave it empty to show only the greeting. You can also type my name is … in the chat.
A short list opens when something is empty or looks wrong. It does not open when everything is fine. You can still choose Download anyway, except where the file cannot be made.
The entry fields and the code that fills the Excel and Word templates are locked. This check compares the running file with its saved fingerprints and tells you if anything changed.
When this is off, files are saved without a Save as window, into the “COC Evaluation” folder inside Downloads.
Takes effect the next time the app starts. F11 switches full screen on or off at any time.
The log (app.log) records start-up, saves and errors. It never contains your records.
Save two sets of initials here (one entry each). They are remembered on this device.
Saves every LFRO and TSRO record into one file. Keep a copy away from this computer (flash drive, email, cloud folder).
Woof, thanks for using this! No pressure at all, but if you’d like to treat me to a coffee, here’s how.
Thank you either way.
Pick a saved record, complete the details, then download the Word file.
Outlet, owner, address, date / time received and tracking number come from the saved record – change them in the evaluation form. The date of issuance (printed as the date on all 3 pages: memo, letter and blindcopy; left blank if empty) and validity, reference code, business name and amount entered here are saved to the record and carry over to the COC page.
Department of Energy
Oil Industry Management Bureau
Retail Market Monitoring and Special Concerns Division