Figure 1 – Production Database Sample 7.1.2 Operational States Database Contains records of equipment status and delay events including status type, delay cause, date, shift, and duration (seconds). Figure 2 – Operational States Database Sample 7.2 Data Processing and KPI Calculation Both databases were imported into Power BI. Only production-related records were considered for analysis. Mechanical availability and utilization were calculated using operational status times, and a consolidated summary table was created including: ● Date ● Shift ● Equipment ● Availability (%) ● Utilization (%) ● Drilled meters ● Productivity (m/h)
RkJQdWJsaXNoZXIy MTM0Mzk2