To access the Consumption Table, click on Consumption data under the Invoices section in the sidebar.
Note: when the customer uploads an invoice, it gets saved in the Invoice table and the data is then cleaned and put into the consumption table automatically
-
The Consumption Table displays all UBMS data in a tabular format.
-
It includes information such as energy consumption, associated charges, costs, and details for each project and zone along with the corresponding meter names.
-
Below is a discussion of the table’s contents
1.Project Name: Displays all project names, allows you to search for a specific project by name, and enables grouping by project
2.Zone Name: Displays all zones names, allows you to search for a specific zone by name, and enables grouping by zone
3.Meter Name: Displays all meter names, allows you to search for a specific metre by name, and enables grouping by meter
4.Account Number: The account number assigned by the utility provider to the customer, retrieved from the invoice or defined in the Project Edit section
5.Month: Displays data for each month over the last four years, based on the invoice upload date
6.Meter Status: All active and inactive meters are available. You can use the filter to view either active or inactive meters as needed
7.Utility Provider: All utility providers are listed based on the invoices and the associated organizations
8.Invoice Type : All available data is categorized by fuel type such as water, chilled water, etc and can be filtered based on a specific fuel type
9.Consumption: represents the original usage data for each fuel type, directly sourced from invoices or input systems. It is used as the base for calculations and dashboard analytics.
10.Unit : All units associated with the uploaded invoices are stored in this Column
11.Consumption Energy: Consumption Energy is the cleaned and calculated energy usage derived from raw data, used for accurate reporting and analysis
12.Consumption m3 : represents the original usage data for each fuel type in m3 unit , directly sourced from invoices or input systems. It is used as the base for calculations and dashboard analytics.
13.TCO2: This column represents the carbon emissions calculated based on utility provider data from the uploaded invoices
14.Total Utility Amount(AED): This column shows the total cost associated with each account number based on the uploaded invoices, and is typically used for dashboard calculations
15.Consumption Charges:it is the cost calculated based on actual usage of a utility or resource, typically measured in units (e.g., kWh, liters, or cubic meters) along with time zone
16.Demand Charges :are costs billed based on the peak power usage (kW) during a billing cycle, rather than total energy consumed (kWh).
17.VAT (Value-Added Tax): is a type of indirect tax that is applied at each stage of the supply chain where value is added from production to the point of sale. All these VAT values are derived from the uploaded invoices
18.Sewage:The Sewage section in the Consumption Table records the sewage-related consumption details for each customer. When invoices are uploaded through the system, corresponding sewage consumption data is extracted and stored in this table for tracking and billing purposes
19.Current Reading:The current reading refers to the latest meter value captured from a specific meter. This reading is utilized during the billing process to calculate the consumption and generate accurate bills
20.Premise Number :A premise number is a unique identifier assigned to a specific physical location (or premises) where a utility service (like electricity, water, or gas) is provided.
21.Uploaded At: This column displays the invoice upload date, which is automatically recorded in the Consumption table when a user uploads bills
-There are multiple features in consumption table in consumption table page by using those features we can easily
-Filters are available for both month and meter. By using the month filter, you can select a specific period to view the data. Once a date range is selected, the table should update accordingly
– The Meter Status section allows you to view all active and inactive meters. You can also filter the consumption table by specific details such as project, zone, account number, meter name, and invoice type
– Grouping is also one of the features available. You can group specific rows by simply dragging and dropping them into the grouping area, as shown in the image below
-On the left side of the page, there are two tabs: ‘Columns’ and ‘Filter’. In the ‘Columns’ tab, you can search for specific columns. Each column has a checkbox if you uncheck it, that column will be hidden from the table
-There is another icon between the checkbox and the column name, which is also a feature. If you want to see the total consumption energy for a specific date range, you can drag the Consumption Energy’ field and drop it into the column area to perform the aggregation
-Next, click on the ‘Filters’ tab. Filters allow you to narrow down the data by specific meter, project, zone, or other selected criteria. The table will update automatically based on the applied filters.
-An ‘Export All’ button is available on the left side of the page. When clicked, it downloads all the consumption data into a single file
-The ‘Save View’ button allows you to save the current view or configuration, making it easy to access the same data layout later
-When you right-click on the Consumption table, a context menu appears with several options. From this menu, you can copy the data, copy it with headers, or copy groups with headers. Additionally, you can export the Consumption table using these options
-When you export the consumption table, the file format (e.g., PDF or CSV) is indicated in the exported file, and the entire consumption table is included in the export