1.
Accessing OGPS
2. Annex Tables
3. Allocated Budget Tables
4. General Entry Form
5. Contingencies
6. Common Errors and Solutions
7. Request for Access
OPEX and GAE Planning System (OGPS)
Accessing OGPS
• OGPS PROD Link: [Link]
• Must be connected via Maynilad network or VPN
• Log-in is automatic via AD
• Click the button in the upper left portion of the screen
• Click Shared
• Click OGPS
• Items under OGPS
OPEX and GAE Planning System (OGPS)
Annex Tables
• Click OGPS then Annex Tables
• The Annex Tables contain the annex files found in the Budget Manual
• The list of Budget Units, Cost Category & Elements, Facility Master List, Allocated Costs, List of Trainings,
and Contracted Non-stock Materials & Services
OPEX and GAE Planning System (OGPS)
Allocated Budget Tables
• Click OGPS then Entry Forms • Click Allocated Budget Tables
• The Allocated Budget Tables contain the Annex G - Allocated costs and other rates from the Budget Manual
• The allocated budget per service will be automatically reflected to the Budget Entry Forms
OPEX and GAE Planning System (OGPS)
Budget Entry Form
• Click OGPS then Entry Forms • Select folder of your Division • Click Budget Entry Form
• Budget Summary sheet shows the totals per OPEX, GAE categories, and per Facility
• Select the Cost Center or group to show the summary
• Complete the Explanations to Variance column
OPEX and GAE Planning System (OGPS)
Budget Entry Form
General Budget Assumptions
• General Budget Assumptions sheet is the main budget entry form
• The entry is per Cost Center and Cost Element
• Data entry is similar to Excel, you can copy, paste, or delete single or multiple cells at once
• Column width can be adjusted at the top row
• Right click on the title column/row to Hide or Unhide selected columns/row
• Use the scroll bars on the right and bottom to move through the tables
• Click inside the entry form table, click the arrow in the upper right to expand the selected table
• Use the scroll bars on the right and bottom to move through the tables
• Click the arrow in the upper right to minimize the table
• In the Searchable Material/Service column, there is dropdown button for selection
• The search bar can also be used instead of scrolling the dropdown window
• Search for the material/service code or standard SAP descriptions, check Annex J of the Budget Manual
• The Unit of Measure and Vendor/Service Provider columns will automatically be populated after
selecting an item in the Searchable Material/Service column
• Use the Manual Material/Service column if the item is not available in the Searchable Material/Service column
• Also input the Unit of Measure and Vendor/Service Provider
• Entry in both the Searchable and Manual column at the same line is not allowed
• If the Header under the Detail columns is not blank, data entry is required
• Detail columns will either have a searchable dropdown or free text entry
• The Foreign Currency column can be used if the rates are not in pesos
• The default is blank, meaning the rates are in PHP
• The Justification and Notes columns are free text entry cells
• Justification – supporting details for review of Budget Management
• Notes – can be used as needed
• The next set of columns are Segmentation columns
• For each Segmentation column data entry is required
• Refer to the Budget Manual for the more details on each dropdown selection
• Scroll to the right to show the Rate columns
• If entered from Searchable Material/Service column, the Rate columns will be automatically populated
• If entered from Manual Item/Service column, the Rate needs to be entered per month
• Scroll to the right to show the Quantity columns
• The Quantity columns will only open if there is a Rate in the same month
• The Quantity needs to be entered per month
• Scroll to the right to show the Budget columns
• The Budget columns will automatically multiply the Rate & Quantity columns
• For entries that only the budget is known, enter the amount in the Rate column and put one (1) in the
Quantity column of the same month
OPEX and GAE Planning System (OGPS)
Budget Entry Form - Budget per Facility
• Budget Per Facility sheet is used to assign budget specific to a facility
• The entry is per Facility, Cost Center, and Cost Element
• The data entry is the same with General Budget Assumptions sheet but entered per Facility
• The Facilities per Cost Center is based from the master list of Asset Information & Mapping
• The data entry is the same with General Budget Assumptions sheet but entered per Facility
• The Facilities per Cost Center is based from the master list of Asset Information & Mapping
• Click the Item button to change the number of item rows to display per Facility
• This is the view for Item 01 option or one row per Facility
• Click the Item button to change the number of item rows to display per Facility
• This is the view for Item 01 - 05 option or five rows per Facility
OPEX and GAE Planning System (OGPS)
Budget Entry Form - Contingencies
• Contingencies sheet is for the contingency budget per Cost Center and Cost Element
• Input the Specific Item/Cost, Particulars/Activity, Justification, and Unit of Measure details
• Input the Quantity and Rate to calculate the Amount
• The Contingencies total amount won’t be added to the General Budget Assumptions total
OPEX and GAE Planning System (OGPS)
Budget Entry Form - Extraction
• Extraction sheet is used to download all budgeted items for the current year and previous year
• Click inside the table you want to extract
• Click the Export button at the middle of the menu bar
• A new window will appear
• Click the Export button at the lower right screen
• A new window will appear
• Wait for the process to finish
• Open the downloaded Excel file
OPEX and GAE Planning System (OGPS)
Common Errors and Solutions
• Blank Tables – the tables remain blank or only white
• Error Message:
• "An unexpected error has occurred"
• "We can't load this visualization"
• Solution:
• Refresh individual tables
• Refresh whole page
• Check the network connection or VPN
• Error Message – Unable to refresh contents of widget. User does not have access to any
members
• Solution:
• Select another Cost Center, Cost Element, or Facility with access
• Refresh individual tables
• Refresh whole page
• Error Message – Unable to paste cell(s). Value not in Pick List
• Solution:
• Select another value in the dropdown selection
• Check if the value is in the dropdown selection
• Error Message – Unable to fetch data. The back-end connection was unexpectedly closed
• Solution:
• Check the network connection or VPN
• Refresh individual tables
• Refresh whole page
• Error Message – Unable to load requested view
• Solution:
• Check the network connection or VPN
• Refresh individual tables
• Refresh whole page
• OGPS site not loading / [Link] site error
• Solution:
• Check the network connection
• Check connection to VPN
OPEX and GAE Planning System (OGPS)
Request for Access
• Email to Service Desk
• Request to add AD of new user to OGPS Prod
• Indicate your Division and Department
• Indicate the user you will copy or replace access
• cc Budget Management and SCOPE
• Service Desk Portal
• Create ticket in portal
• Inform Budget Management and SCOPE
• Indicate your Division and Department
• Indicate the user you will copy or replace access