Executive Overview
Plant-wide telemetry & reliability intelligence
Plant Metered Consumption
604.0 MWh
19 Process Feeders • Apr - Sep 2026 total
Source: Power_Monthly!C11 Details →
Solar Share of Demand
49.0%
295.8 MWh self-consumed on-site
Source: Power_Monthly!N11 Details →
GEB Grid Import (HT)
308.2 MWh
51.0% site electricity from grid
Source: Power_Monthly!D11 Details →
Diesel DG Output
27.8 MWh
Aug OLTC outage caused 15.9 MWh
Source: Power_Monthly!I11 Details →
Net Reconciliation Gap
4.2% Avg
Net generation vs feeder sum
Source: Power_Daily Details →
Power & Solar Alerts
8 Open
Transformer OLTC, solar trip, high gap
Source: Telemetry Alerts Details →

Needs Action This Week (Top Power & Solar Issues)

Urgent grid, transformer, solar generation, and metering telemetry actions

ID Severity Area Key Finding & Operational Risk Owner Target Date Status Action

Top Process Feeder Consumption (kWh)

Major production lines & sub-panels by monthly draw

Source: Feeders

Energy Supply Mix (Grid, Solar, DG)

Monthly balance showing solar on-site vs grid import and DG

Source: Power_Monthly

Plant Action Register & Audit Alerts (27 Items)

Click any row to open the evidence drawer, link to source chart, update status and save notes

Source: Alerts Tab
ID Severity Area Finding & Evidence Source Tab Owner Target Status
Slip-Number Compliance Critical Gap: 9.2% Overall
Out of 499 recorded breakdowns across Apr-Sep 2026, only 46 entries (9.2%) have a registered maintenance slip number. June and July had 0% slip recording. This limits root-cause tracking, spares allocation, and ERP synchronization.
Total DMR Entries
1,880
Apr - Sep 2026 deduplicated logs
Source: DMR_Data
Breakdown Entries
499
26.5% of total entries
Source: Maint_Monthly!D11
Preventive (PM) Entries
719
38.2% of total entries
Source: Maint_Monthly!E11
Breakdowns / Day Logged
2.80
Oct MTD running high at 3.50/day
Source: Maint_Monthly!H11

Repeat-Failure Leaderboard (Apr - Oct 2026)

Sumproduct on theme flags in DMR data (blenders, sealing, valves, lifts, AC)

Source: Repeat_Equip
Equipment / Theme All Entries Breakdowns BD % Peak Month

Breakdown Breakdown by Building & Line

Distribution across WP, DP, Utility, UB, and Admin

Source: DMR_Data

Critical Equipment Reliability Engineering: MTBF & MTTR Analytics

Mean Time Between Failures (MTBF = Operating Hours / Breakdowns) & Mean Time To Repair (MTTR = Downtime / Breakdowns)

World-Class Maintenance Benchmarks
Equipment System Classification Operating Hrs Breakdowns Downtime (hrs) MTBF (hrs) MTTR (hrs) Availability % Root Cause Pattern

DMR Maintenance Master Log Explorer (1,966 Records)

Search by equipment, details, category, slip number, or building

Source: DMR_Data
Date Bldg Area Equipment Details & Work Done Category Slip No.
Showing 1 to 25 of 1,966 entries
Compressor-3 Down 69 Days with Zero Standby Capacity
Air Compressor-3 (100 CFM) has been logged as B/D continuously since 1 August 2026. The entire seasoning plant is operating on Compressor 1 and Compressor 2 with no N+1 backup. Any trip halts packaging pneumatics immediately.
Thermodynamic Anomaly: Boiler-1 (300 kg) burns MORE LPG/hr than Boiler-2 (1000 kg)
B-1 average consumption is 35.56 kg/hr (peaking at 45.3 kg/hr) vs B-2 at 24.31 kg/hr. Hypothesis Labels may be swapped between reports, short-cycling on B-1, or incorrect LPG meter allocation. Steam flow meters (pending work #2) are on hold.

Plant System Availability Tracker (Sep - Oct 2026)

Operating availability percentage and downtime days across key equipment

Source: Availability

Compressor Monthly Run-Hours & B/D Status

Run-hours for Comp 1, Comp 2, and Comp 3 (highlighting Aug-Oct shutdown)

Source: Util_Monthly & Util_Daily

Boiler Specific LPG Consumption (kg/hr)

B-1 (300 kg) vs B-2 (1000 kg) specific burn rates

Source: Boiler_LPG

Water Balance: 55.6% Unaccounted vs Main Line Meter

Monthly main line volume vs metered sub-lines (DP, WP, RO, ETP, STP, Borewell)

Source: Water
Month Days Main Line (kL) DP (kL) WP (kL) RO (kL) DP+WP+RO Unaccounted Gap (kL) Unaccounted % Main kL / Day

Dedicated Boiler Performance & Combustion Diagnostics

Filter by boiler unit and period to inspect fuel efficiency, cost, and steam output

Running Hours
644.0 hrs
Cumulative period log
LPG Consumed
16,251.9 kg
16.25 metric tonnes
Specific Burn Rate
25.24 kg/hr
Blended consumption rate
Total Fuel Cost
₹14.30 Lakhs
@ ₹88/kg contract
Steam Generated (Est.)
211.3 tonnes
~13.0 kg steam / kg LPG

Equipment Changeover & Duty Balancing Protocols

Operational recommendations for standby and dual-duty machinery

Reliability Protocol
Air Compressors Changeover Crisis
Comp-1 (143 CFM New) and Comp-2 (143 CFM Old) run ~10h/day each without standby due to Comp-3 69-day breakdown. Recommendation: Rotate weekly lead/lag cycles between Comp-1 and Comp-2 to prevent localized motor thermal fatigue. Expedite Comp-3 overhaul immediately.
Process Chillers Load Sharing
Chiller-1 (15TR) operates as primary duty chiller while Chiller-2 (5TR) serves as auxiliary buffer. Recommendation: Alternate lead unit during low-ambient night shifts to equalize compressor operating hours.
Emergency Diesel Generators (DG-1 & DG-2)
Both 500 kVA generators ran heavily during the August OLTC outage (14,991 kWh). Recommendation: Schedule bi-weekly 15-minute off-load crank runs and execute 250h B-check filter replacements.

Running-Hours Overhaul & Servicing Alerts

Preventive overhaul thresholds (500h, 1500h, 2500h, 4000h)

Source: Util_Daily
Equipment Cumulative Hrs Threshold Hours Left Status Action

Line-Wise UPS System Telemetry & Availability Explorer (29 Units)

Real-time backup power status, kVA capacity, and line availability from UPS Master

Sr Building Protected Equipment / Line System kVA Rating Make Commission Date Serial Number Line Availability Status

Daily Power Meter Reading

Enter today's register readings. Consumption & plant reconciliation calculate automatically.

Auto-saved on this device
Tuesday

Line / Feeder Meters

19 sub-panels · previous reading is auto-locked from yesterday

kWh

Plant Supply Meters

GEB grid import, solar, and diesel generation for the day

Testing & Data Tools

Start fresh, then verify the sheet data so any glitch is caught before you rely on it

Local test workspace
Data source: empty / fresh. No sheet data is being showcased yet.
Fresh workspace. Wipe starts empty · Load fills from the sheet · Verify checks the sheet for glitches.
OLTC Transformer Failure (10-16 Aug): ~11.0 MWh Solar Lost & ~12.8 MWh Extra DG
Because the 372 kWp rooftop solar plant is grid-tied without islanding synchronisation, solar generation shut down during the grid outage. DG ran continuously, generating 14,991 kWh diesel power costing ~₹3.5+ Lakhs.
Metered Consumption
—
No data loaded
Source: Power_Monthly
Grid Import (HT)
—
No data loaded
Source: Power_Monthly
Solar Used On-Site
—
No data loaded
Source: Power_Monthly
DG Output (Diesel)
—
No data loaded
Source: Power_Monthly

Daily Power Reconciliation & Gap Analysis

Net supply (Grid+Solar+DG-Export) vs metered consumption (gaps >10% flagged)

Source: Power_Daily

Solar Daily Output & Low-Generation Threshold

372 kWp plant daily kWh (days <1,000 kWh highlighted)

Source: Solar_Daily

Top Feeder Consumption (kWh)

Major process lines & utility building sub-panels

Source: Feeders

Grid Outages Impact Register

Estimated solar lost and DG diesel generation during cuts

Source: Outages
Date Outage Event Solar Lost (kWh) DG Generated (kWh)

Line-Wise & Area-Wise Electrical Energy Telemetry

Filter metered process lines, utility panels, and analyze Sunday idle base-loads

Feeder / Process Line Apr 2026 Jun 2026 Jul 2026 Aug 2026 Sep 2026 Apr to Sep Shift Sep Avg Sunday Sep Avg Weekday Sunday Idle Base Load %

Nandasan 372 kWp Solar Plant Technical Performance & CUF Analysis

Yield benchmarks, capacity utilization factor (CUF), and inverter performance

Solar Plant Health: 94.2% PR
Specific Yield (Apr-Sep)
895.8 kWh / kWp
Benchmark: 4.90 kWh/kWp/day
Capacity Utilization (CUF)
17.8 %
Plant peak capacity: 372 kWp
Self-Consumption Fraction
88.8 % On-Site
11.2% exported to GEB grid

AMC, Statutory Inspections & Servicing Register (44 Items)

Live status recalculated from the current "As-of Date" (default: 28-Oct-2026)

Source: AMC_Tracker Tab
6 OVERDUE
10 DUE SOON (≤45 Days)
28 CURRENT / OK
Sr Service / Equipment Equipment Tag Vendor Frequency Last Serviced Next Due Date Days to Due Status

Pending Maintenance & Engineering Works Log (36 Items)

Classified by operational workflow state and recommended engineering priority

Source: Pending_Works
Open / In Progress 0
On Hold 0
No Status Recorded (Needs Owner) 0
Closed 0

Telemetry Data Profile & Source Ingestion Verification

Parsed 18 sheets from SA_Seasoning_Master_Analysis_Oct2026.xlsx with live formula evaluations

All 18 Tabs Verified
Sheets Found
18 Tabs
Summary, Alerts, DMR_Data, Outages, etc.
Cleaned DMR Records
1,966 Rows
Apr to 8-Oct-2026 deduplicated
Daily Telemetry Records
192 Days
Power daily, Solar daily, Running hours

Telemetry Anomaly Detection & Trend Pattern Intelligence Matrix

Automated statistical pattern recognition detecting measurement spikes, frozen meters, and thermodynamic deviations

7 Pattern Anomalies Flagged
Anomaly Pattern Observed Telemetry Evidence Magnitude / Severity Affected Source Pattern Classification Automated Status
Reconciliation High-Gap & Negative Days 14 days exhibit supply-to-consumption gap >10% or negative net supply Critical Gap (±18%) Power_Daily Meter Time Synchronization / Unmetered Tap FLAGGED
Frozen Sub-Meter Telemetry Amchur line meter locked at 10,692 kWh since April; Chilli flakes reading zero High Distortion Feeders Hardware CT/PT Display Lockout FLAGGED
Boiler Specific Burn Rate Inversion Boiler-1 (300 kg) burns 35.6 kg/hr vs Boiler-2 (1000 kg) burning 24.3 kg/hr +46.3% Burn Inversion Boiler_LPG Flow Meter Allocation / Short Cycling FLAGGED
Solar Inverter Trip Masking "Cloudy weather" copy-pasted across 80 consecutive days (4 Jul - 24 Sep) Medium Blindspot Solar_Daily Log Copy-Paste Masking Inverter Trips FLAGGED
April Solar Generation Total Typo FY Summary states 71,771 kWh vs verified daily sum of 61,771 kWh +10,000 kWh Typo Power_Monthly Human Data-Entry Cell Error FLAGGED
Admin Sub-Panel Measurement Spike 23-Sep opening reading artifact caused erroneous daily feeder consumption spike Spurious Reading Feeders Register Reset Artifact FLAGGED
Maintenance Slip Registry Compliance Gap Only 9.2% of breakdown entries (46 of 499) possess a registered slip number 90.8% Traceability Void DMR_Data ERP / Work-Order Process Non-Compliance FLAGGED

Data Quality Issues Found & Recommended Audit Fixes

Discrepancies identified in raw logs requiring management correction

8 Documented Anomalies

Live Automated Data Validation Engine

Automated tests executed against in-memory tables

Power & Solar Executive Intelligence Center

Engineering reports designed to optimize power consumption, eliminate grid outage loss, verify feeder reconciliation, and maximize solar ROI.

Controlled Plant Forms & Mobile Data Capture Suite

12 Controlled Forms

Replaces manual Excel sheets with server-validated, mobile-first forms, offline draft auto-saving, role clearance enforcement, and real-time alert triggers.

Drafts Auto-Saved to Device
Form 1

Daily Maintenance Entry (DMR)

Log breakdown, preventive, corrective, or project maintenance activities.

Ready
Form 2

Official Breakdown Work-Order Slip

Mandatory slip assignment. Cannot close without registered cause, spares field, and end time.

Ready

My Permissions & Server-Side Access Control (RBAC)

Server Enforced

Role-based access control enforced on the SERVER for every API endpoint, returning 403 Forbidden on violations. Menu items are role-aware.

Current Active User: Vikram Malhotra (Plant Head)
VM

Vikram Malhotra

head@plant.demo • Area: All Facilities
JWT Authentication Active Lockout Protection: 5 Failed Attempts (15m lockout)
Active Clearance Scope: Full read access across all plant telemetry; exclusive final approval for critical alert resolution, monthly report sign-off, and KPI target governance.

Demo: Switch Role (8 Seed Users - 1-Click Authentication)

Authenticates with real bcrypt hashed credentials & JWT token
RP
Ramesh Patel
Operator/Technician

C/R/U own entries until submitted; R own area (DP); X approve.

SS
Suresh Sharma
Supervisor

R area; U corrections with reason; A daily entries by 10:00 next day.

KR
Kavita Rao
Maintenance Head

R all maint/util; A breakdown closure & verify; C/U pending works & AMC.

AV
Arun Verma
Utilities Engineer

R/A power, solar, DG, boiler, water, compressors; C/U thresholds.

PM
Pooja Mehta
EHS/QA Lead

R all alerts; C/U/A safety, fire & AHU records; close safety alerts.

VM
Vikram Malhotra
Plant Head

R all; final A for critical alerts & monthly sign-off; manage KPI targets.

NG
Neha Gupta
Data Owner

C/U master data (equipment, meters, boilers, vendors, dropdowns, rules).

AD
Sys Admin
Admin

Manage users, roles, area assignments, password reset, audit log view.

Interactive Server RBAC Verification Gate

Click any action below to dispatch a live HTTP request to FastAPI. Verifies that the server returns 403 Forbidden for unauthorized actions.

Ready for test

Full 8-Role Operational Permissions Matrix (C=Create, R=Read, U=Update, A=Approve, X=None)

Enforced on the SERVER for every API endpoint; not merely cosmetic in the UI.

Governance Standard: ISO 9001 & Plant Operations
Platform Capability Technician Supervisor Maint Head Utilities Eng EHS/QA Lead Plant Head Data Owner Admin
Daily Maintenance (DMR) C / R / U (Own) R / U / A (Area) R / U / A (All) R (Utilities) R (All) R (All) R (All) C / R / U / A
Breakdown Slips & Closure C / R / U (Own) R / U / A (Close) A (Verify/Close) C / R / U (Util) R (All) R (All) R (All) Full Closure
Utilities, Boilers & Water C (Own Log) R / U (Area) R / U (All) C / R / U / A R (All) R (All) R (All) Full Access
Safety, Fire & Interlocks C (Log) R / U R (All) R (All) C / R / U / A (Close) A (Critical Close) R (All) Full Access
Pending Works & AMC R (View) C / U (Area) C / U / A (All) C / U (Util) R (All) R (All) R (All) Full Access
KPI Targets Governance ✗ Blocked ✗ Blocked ✗ Blocked ✗ Blocked ✗ Blocked ✓ Manage Targets ✗ Blocked ✓ Full Access
Monthly Pack Sign-Off ✗ Blocked ✗ Blocked ✗ Blocked ✗ Blocked ✗ Blocked ✓ Exclusive Sign-Off ✗ Blocked ✓ Override
Master Data Management R (Read Only) R (Read Only) R (Read Only) R (Read Only) R (Read Only) R (Read Only) ✓ C / U / D ✓ C / U / D
System Audit Trail Log ✗ Blocked ✗ Blocked ✗ Blocked ✗ Blocked ✗ Blocked ✓ View ✓ View ✓ Full Admin View