AWG Generation vs Weather — Date & Hour Wise Correlation
ℹ️Weather data from Open-Meteo API for Windsor Place, New Delhi (28.6139°N, 77.2090°E).
Hourly AWG generation from Cost Sheet 2 flow meter data (93 days: Nov'25–Jan'26).
Actual vs GEN-L model output shown per hour. Select date to view correlation.
Select Date for Hourly Analysis
Loading...
Avg Temp
—
Avg Humidity
—
Actual AWG Total
—
Model AWG Total
—
Actual AWG L/hr (Flow Meter)
GEN-L Model Output (Temp+Humidity)
Humidity % / 1.5
Hourly Correlation Table
—
Hour
Temp (°C)
Humidity (%)
Wind (km/h)
GEN-L Model (L/hr)
Actual AWG (L/hr)
Variance
Match %
Select a date above to load data
Today Hourly Bottles
AWG Daily Generation History
Last 30 days
Actual (L)
Projected (L)
📊 Actual vs Projected Generation — Flow Meter Analysis
Actual AWG (L/day)
Projected (GEN-L model, L/day)
% Achieved
pH Level
7.4
Optimal: 6.5 – 8.5
TDS Level
42 ppm
Max 100 ppm (BIS)
QC Pass Rate
98.7%
Target ≥ 98%
QC Log Entry — Staff enter details below with their login ID
New QC Check Entry
Latest Status per Stage (auto-updated from entries)
9-Stage Purification Summary
Real-time
Stage
Last Action
Date / Time
pH
TDS
Operator
Notes
Status
No entries yet. Use form above to log QC activity.
24h pH Log
Within Range
24h TDS Log
Below Limit
Revenue YTD − Expenses YTD (Le Meridien)
Loading...
Sep 2025 – Feb 2026
Revenue YTD
₹53,71,713
Op. Expenses YTD
₹37,52,696
CAPEX
₹37,60,874
ℹ️ About the ₹88.1L figure: The Excel Summary Sheet shows Total Expenses = ₹88,11,425.
This includes: Pre-operation expenses Apr–Aug'25 (₹49.4L: setup, rent, salaries, equipment before revenue started)
+ Operational expenses Sep'25–Feb'26 (₹38.7L). The ₹76.3L shown previously was CAPEX ₹37.6L + OpEx ₹38.7L (Sep-Feb only).
Full picture below includes all three components.
ROI — Full Investment Recovery Analysis
Revenue YTD (Sep'25–Feb'26)
₹52.6L
4,73,112 bottles invoiced
CAPEX (Equipment / Machinery)
₹37.6L
Machinery, tanks, bottling line
Pre-Op Expenses (Apr–Aug'25)
₹49.4L
Setup period before revenue
Operational Expenses (Sep–Feb)
₹38.7L
Salary, elec, consumables, water
Total Investment (All-In)
₹88.1L
CAPEX + Pre-Op + Sep-Feb OpEx
Net P&L vs OpEx Only
−₹22.4L
Revenue − (Sep-Feb OpEx only): 135%
Revenue vs Total Investment (CAPEX + Op.Expenses)
70% recovered
Total Deployed: ₹75,13,570Est. break-even: ~4 monthsRevenue So Far: ₹53,71,713
Month-on-Month Summary — Income & Expenditure
MoM P&L Table
Sep'25–Feb'26
Month
Bottles
Revenue (₹)
Op.Expenses (₹)
Monthly P&L (₹)
Cumulative Rev (₹)
Cumul. P&L (₹)
Payment
Add Invoice / Transaction
🔒 Finance data entry requires Finance or Admin access