Chapter 3 Practical 5

A

 

 

Comparison of Energy Demand and Consumption of a Particular Indian State Using Graphical Tools

Aim:
To analyze and compare the trends in energy demand and consumption of a selected Indian state over a significant period (e.g., 10-15 years) using graphical tools. The objective is to understand the growth patterns, identify key drivers, correlate them with socio-economic development, and assess the sustainability of the state's energy trajectory.

Principle:
Energy is a fundamental driver of economic development and social progress. The relationship between a state's growth and its energy use can be understood through several key metrics:

• Energy Consumption: The total amount of energy (in GWh or MU) actually used by all sectors within the state.

• Energy Demand (Peak Demand): The maximum power (in MW or GW) required by the state grid at any given moment. It represents the system's highest load and is a critical metric for infrastructure planning.

• Per Capita Electricity Consumption: A direct indicator of the standard of living and economic activity, calculated as Total Energy Consumption / Population.

• Sectoral Composition: The breakdown of energy consumption among key sectors like Industrial, Domestic, Agricultural, and Commercial.

Tracking these metrics over time reveals the state's developmental trajectory, the success of energy efficiency measures, and the challenges in meeting growing needs. Graphical visualization is essential to identify patterns, correlations, and anomalies that may not be apparent in raw data tables.

Materials Required:

• Data Sources:

  • Primary Source: Annual Reports and Load Generation Balance Reports (LGBR) from the Central Electricity Authority (CEA), Government of India.

  • State-specific Data: State Electricity Board websites (e.g., MSEB, TSSPDCL), and economic surveys of the state.

  • Socio-economic Data: Census of India data and state domestic product (SDP) data from the Ministry of Statistics and Programme Implementation (MOSPI).

• Software:

  • Data Compilation: Microsoft Excel or Google Sheets.

  • Graphical Tools: Excel's charting features are sufficient.

• Key Parameters to Extract:

  • Total Energy Consumption (in Million Units, MU)

  • Peak Energy Demand (in Megawatts, MW)

  • Per Capita Electricity Consumption (in kWh)

  • Sector-wise Energy Consumption (Industrial, Domestic, Agricultural, Commercial)

Procedure:

Step 1: Selection of State and Data Collection

• Select one Indian state (e.g., Maharashtra, Tamil Nadu, Gujarat, Karnataka, or your home state).

• Visit the CEA website (www.cea.nic.in) and navigate to "Reports" -> "Annual Reports" or "Load Generation Balance Report".

• Collect data for the chosen state for at least a 10-year period (e.g., 2010-11 to 2022-23).

• In parallel, collect data for the state's population (https://censusindia.gov.in/census.website/data/population-finder) and Gross State Domestic Product (GSDP) https://esankhyiki.mospi.gov.in/catalogue-main/catalogue/tableview/6996ee75895697ccb9ca46f0 or (https://mospi.gov.in/themes/product/6-gross-domestic-product  or https://mospi.gov.in/product/more/6-Data) for the same period.

  * India Energy and Climate Dashboard https://iced.niti.gov.in/state-report/andhra-pradesh 

  * Fuel Consumption data  https://iced.niti.gov.in/energy/fuel-sources/coal/consumption#state 

  * Electricity data dashboard  https://cea.nic.in/dashboard/?lang=en

  * Trendline or Linear Curve fit or future position collector https://www.pearson.com/channels/calculators/linear-regression-calculator

Step 2: Data Compilation and Calculation

• Create a master table in Excel.

• Calculate the Compound Annual Growth Rate (CAGR) for key parameters to understand the average annual growth.

  • Formula: CAGR in percentage = [(Ending Value / Beginning Value)^(1/Number of Years) - 1] * 100

     

Step 3: Graphical Representation and Analysis
Create the following graphs to visualize the trends:

1. Trend Line Graph: Plot Total Energy Consumption (MU) and Peak Demand (MW) on a dual-axis chart (Consumption on primary Y-axis, Demand on secondary Y-axis) against the Year on the X-axis. This shows the parallel growth of overall usage and system stress.

2. Clustered Column Chart: Plot Sector-wise Consumption for the first and last years of your study period (e.g., 2010-11 vs. 2022-23). This visualizes how the energy consumption mix has evolved.

3. Combination Chart: Plot Per Capita Consumption (kWh) and GSDP (in ₹ Cr) on a dual-axis line chart. This helps correlate energy use with economic growth.

4. Pie Charts: Create two pie charts showing the percentage share of different sectors for the first and last year to show the structural change in energy consumption.

Step 4: Interpretation

• Analyze what each graph reveals about the state's energy story.

• Correlate trends with real-world events (e.g., a surge in demand linked to a new industrial policy, a slowdown during the COVID-19 pandemic, the impact of a good monsoon on agricultural consumption).

---

Observations & Data Analysis (Hypothetical Data for the State of "Industria")

Table 1: Compiled Energy and Economic Data for Industria State (2010-2023)

Year	Total Energy Consumption (MU)	Peak Demand (MW)	Per Capita Consumption (kWh)	GSDP (₹ Crore)	Sectoral Consumption (MU) - 2023
2010-11	65,000	10,500	850	8,50,000	Ind: 45%, Dom: 25%, Agri: 20%, Comm: 10%
2015-16	88,000	14,200	1,050	12,50,000	...
2020-21	1,05,000	16,800	1,180	15,00,000	...
2022-23	1,20,000	19,500	1,300	18,00,000	Ind: 40%, Dom: 30%, Agri: 18%, Comm: 12%
CAGR	4.5%	4.7%	3.2%	5.8%

(Ind: Industrial, Dom: Domestic, Agri: Agricultural, Comm: Commercial)

Graphical Outputs (Descriptive):

• Graph 1: Trend of Total Consumption vs. Peak Demand

  • Observation: Both lines show a strong upward trend. Peak Demand has grown slightly faster (CAGR 4.7%) than total energy consumption (CAGR 4.5%), indicating that the maximum rate at which energy is needed is growing faster than the total quantity used. This points to increased simultaneity of usage, posing a challenge for grid management.

• Graph 2: Sectoral Share Comparison (2010-11 vs. 2022-23)

  • Observation: The industrial sector's share has decreased from 45% to 40%, while the domestic and commercial shares have increased. This is a classic sign of economic maturation and urbanization, where the services sector and residential comfort gain prominence.

• Graph 3: Correlation of Per Capita Consumption and GSDP

  • Observation: The two lines show a strong positive correlation. As GSDP grew at 5.8% CAGR, per capita consumption grew at 3.2% CAGR. The gap suggests improvements in energy efficiency, meaning the state is generating more economic output per unit of energy consumed over time.

Result:
The analysis of Industria State from 2010-11 to 2022-23 reveals a period of robust growth in energy consumption (CAGR 4.5%) and peak demand (CAGR 4.7%), closely tracking its economic expansion (GSDP CAGR 5.8%). A key finding is the structural shift in the state's energy mix, with the industrial sector's share declining in favor of the domestic and commercial sectors, indicating urbanization and a growing service economy. The state has also shown progress in energy efficiency, with economic growth outpacing the growth in per capita energy use.

Discussion:

• Link to Syllabus and Theory: This practical directly applies concepts of energy economics, development indicators, and sustainable development. It demonstrates the Energy Ladder hypothesis, where economies transition from industrial to service and domestic-centric energy use.

• Drivers of Demand: The growth can be attributed to:

  • Economic: Industrial expansion and growth in the services sector.

  • Social: Rising household incomes leading to the acquisition of more appliances (ACs, heaters), and increased electrification of rural areas.

  • Policy: Government schemes like the UJALA LED bulb campaign may have moderated the growth of domestic consumption, while separate agricultural feeder schemes (like in Gujarat) might have altered agricultural consumption patterns.

• Sustainability and Future Challenges:

  • The consistent growth in peak demand (Graph 1) highlights a critical challenge for grid stability and requires investment in peak power plants or demand-side management (e.g., time-of-day pricing).

  • The shift in sectoral share has implications for the daily load profile, with domestic and commercial sectors causing high evening peaks.

  • The continued high growth necessitates a parallel focus on renewable energy integration to meet demand without a proportional increase in carbon emissions.

• Limitations: The analysis uses aggregated data, which may mask regional disparities within the state. Furthermore, it does not differentiate between energy sources (coal, hydro, solar, wind), which is crucial for a complete environmental assessment.

Conclusion:
This practical successfully utilized graphical tools to demystify the energy trajectory of Industria State. The graphs provided a clear, visual narrative of growth, structural change, and improving efficiency. The analysis confirms that energy is a vital enabler of economic development but also underscores the escalating challenges in managing peak demand and ensuring the sustainability of the energy supply. For a comprehensive energy policy, this demand-side analysis must be combined with a similar study of the state's energy supply mix.

Viva Voce Questions:

1. Why is Peak Demand a more critical planning parameter for grid managers than Total Energy Consumption?

   • Total energy consumption (in MU) is about the total quantity of energy needed over a period. Peak demand (in MW) is about the instantaneous rate of consumption. Grid infrastructure (transformers, transmission lines) must be built to handle the maximum possible load (the peak), not just the average. A higher peak demand requires more robust and expensive infrastructure.

2. What does a decreasing share of the industrial sector in energy consumption, coupled with a rising GSDP, indicate about the state's economy?

   • It indicates that the state's economy is likely transitioning towards a more service-oriented structure. It also suggests that industries within the state are becoming more energy-efficient, producing higher economic value (GSDP) per unit of energy consumed. This is a sign of economic maturation.

3. Based on your graphs, which sector's growth seems to be the most correlated with the rising peak demand? Justify your answer.

   • The domestic sector is often a key driver of peak demand, especially during the evening hours when lighting, cooking, and entertainment appliances are used simultaneously. The graph showing an increase in the domestic sector's share supports this, as residential usage tends to be highly coincident, creating a sharp peak.

4. If you were to extend this study, what additional data would you incorporate to get a fuller picture of the state's energy scenario?

   • I would incorporate data on the energy supply mix (breakdown by thermal, hydro, solar, wind) to understand the environmental impact (carbon emissions). I would also analyze data on transmission and distribution (T&D) losses, as high losses indicate inefficiency in the system and a gap between energy generated and energy billed.

5. Calculate the Energy Intensity of Industria State for 2010 and 2023 (Energy Intensity = Total Energy Consumption / GSDP). What does the trend tell you?

   • 2010-11: 65,000 MU / 8,50,000 Cr = 0.076 MU/₹Cr

   • 2022-23: 1,20,000 MU / 18,00,000 Cr = 0.067 MU/₹Cr 

   • Trend: The energy intensity has decreased. This means the state is now using less energy to produce one unit of economic output, indicating improved energy efficiency across its economy.

 SECTION B

 

 

 Comparison of Energy Demand and Consumption of Andhra Pradesh Using Graphical Tools

 

Course: Energy Economics / Environmental Studies / Data Analytics 

Level: Graduate (Masters/PhD) 

Duration: 4-6 Hours 

Mode: Mobile-friendly (Excel/Google Sheets compatible)

 

 1. OBJECTIVES

Upon completion, students will be able to:

- Extract and analyze state-level energy data from official Indian government portals

- Compare primary energy consumption vs. electricity demand patterns

- Create publication-ready visualizations using spreadsheet tools

- Interpret energy transition trends and policy implications

- Calculate energy intensity metrics for industrial vs. domestic sectors

 

 2. DATA SOURCES (Mobile-Accessible)

Portal	URL	Data Available	Mobile Access
**India Energy & Climate Dashboard (ICED)**	<https://iced.niti.gov.in/state-report/andhra-pradesh>	State energy profile, fuel mix, sector-wise consumption	Responsive web design
**Fuel Consumption Database**	<https://iced.niti.gov.in/energy/fuel-sources/coal/consumption#state>	Coal, oil, gas consumption by state	Filterable tables
**CEA Electricity Dashboard**	<https://cea.nic.in/dashboard/?lang=en>	Real-time electricity demand, generation, peak load	Interactive charts
**BEE India Energy Scenario**	<https://beeindia.gov.in>	Sectoral energy consumption statistics	PDF reports

 

 

 3. EXPERIMENTAL PROCEDURE

 Phase 1: Data Collection (90 minutes)

 Step 1.1: Andhra Pradesh Energy Profile

Action: Visit https://iced.niti.gov.in/state-report/andhra-pradesh on your mobile browser

 

Extract the following data points:

- Total energy consumption (latest year available)

- Energy mix composition (Coal, Oil, Gas, Renewables, Nuclear)

- Per capita energy consumption

- Sector-wise breakdown (Agriculture, Industry, Domestic, Commercial)

 

Recording Format: Create a table in Google Sheets/Excel with columns:

Metric

Value

Unit

Year

Source

 

Step 1.2: Fuel Consumption Trends

Action: Navigate to https://iced.niti.gov.in/energy/fuel-sources/coal/consumptionstate

 

Tasks:

1. Select "Andhra Pradesh" from state dropdown

2. Extract coal consumption data for last 5 years (2019-2024)

3. Note industrial vs. power sector split

4. Record import dependency percentage

 

Mobile Tip: Screenshot the charts or use the "Download CSV" option if available

 

 Step 1.3: Electricity Specifics

Action: Access CEA Dashboard https://cea.nic.in/dashboard/?lang=en

 

Collect:

- Peak electricity demand (MW) - monthly for latest year

- Total energy consumption (MU - Million Units)

- Generation mix (Thermal, Hydro, Renewable, Nuclear)

- Distribution losses percentage

- Rural vs. Urban electrification rates

 Phase 2: Data Organization (60 minutes)

 

 Dataset 1: Primary Energy Consumption (MTOE - Million Tonnes Oil Equivalent)

Year	Coal	Oil	Natural Gas	Renewables	Nuclear	Total
2019-20	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Sum]
2020-21	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Sum]
2021-22	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Sum]
2022-23	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Sum]
2023-24	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Extract]	\[Sum]

 

 Dataset 2: Electricity Demand vs. Supply

Month	Peak Demand (MW)	Energy Met (MU)	Deficit (%)	Source Mix (Thermal/RE/Hydro)
Apr
May
...
Mar

 

 Phase 3: Graphical Analysis

 

Using Google Sheets or Excel Mobile App, create the following visualizations:

 

 Chart 1: Energy Mix Evolution (Stacked Area Chart)

- X-axis: Years (2019-2024)

- Y-axis: Consumption (MTOE)

- Series: Coal, Oil, Gas, Renewables, Nuclear

- Analysis Question: Identify the transition trend from fossil fuels to renewables

 

 Chart 2: Sector-wise Consumption (Pie Chart + Trend)

- Create pie charts for 2019-20 and 2023-24 side by side

- Sectors: Agriculture, Industry, Transport, Residential, Commercial

- Analysis Question: Which sector shows maximum growth? Why?

 

 Chart 3: Electricity Demand Pattern (Line + Bar Combo)

- Primary Y-axis: Monthly Peak Demand (Line chart)

- Secondary Y-axis: Energy Consumption (Bar chart)

- X-axis: Months (Apr-Mar, Indian financial year)

- Analysis Question: Identify seasonal patterns and peak stress months

 

 Chart 4: Comparative Intensity Metrics (Radar Chart)

Calculate and plot:

- Per capita electricity consumption (kWh/person)

- Energy intensity (TOE/₹ lakh GSDP)

- Industrial share (%)

- Renewable penetration (%)

- Distribution losses (%)

 

Compare AP with national average (data from ICED national dashboard)

 

 

 

 Phase 4: Advanced Analysis (60 minutes)

 

 Calculation 1: Energy Elasticity

Energy Elasticity = (% Change in Energy Consumption) / (% Change in GSDP)

 

- Calculate for 2019-20 to 2023-24

- Interpretation:

  - >1: Energy-intensive growth

  - <1: Decoupling of energy and growth

 

 Calculation 2: Carbon Intensity

Using emission factors:

- Coal: 2.4 tCO2/tonne

- Oil: 2.8 tCO2/tonne 

- Gas: 2.0 tCO2/tonne

- Estimate total CO2 emissions from fossil fuel consumption

 

 Calculation 3: Capacity Utilization Factor

From CEA data:

Plant Load Factor (PLF) = (Actual Generation / Maximum Possible Generation) × 100

 

Compare thermal PLF vs. renewable PLF

 

 

 4. DISCUSSION QUESTIONS

 

1. Energy Transition: Andhra Pradesh has significant renewable potential (solar/wind). Analyze the gap between installed capacity and actual generation. What are the grid integration challenges visible in the demand-supply data?

 

2. Agricultural Load: AP has high agricultural electricity consumption. How does this affect the load curve? What is the impact on grid stability and subsidy burden?

 

3. Industrial Shift: Compare pre-2020 and post-2020 industrial energy consumption. What policy implications can you draw regarding the state's industrialization strategy?

 

4. Peak Management: Identify the top 3 peak demand months. What strategies (demand response, storage, time-of-day pricing) would you recommend based on the deficit patterns?

 

5. Inter-state Comparison: If data is available, compare AP with neighboring states (Telangana, Karnataka, Tamil Nadu) on renewable penetration and energy efficiency metrics.

 

 

 

 5. DELIVERABLES

 

Submit a PDF report (created via Google Docs/Word Mobile) containing:

 

 Section A: Data Tables (20%)

- Raw data extracted from all three portals

- Intermediate calculation tables

- Metadata (source, date of access, limitations)

 

 Section B: Visualizations (30%)

- Minimum 5 charts with proper titles, labels, and legends

- Source citations below each chart

- Brief interpretation (2-3 sentences per chart)

 

 Section C: Analysis (30%)

- Answers to discussion questions

- Policy recommendations (200 words)

- Limitations of data and methodology

 

 Section D: Mobile Workflow Documentation (20%)

- Screenshots of data extraction process

- Tools used (apps, versions)

- Challenges faced and solutions

 

 

 

 6. MOBILE-FRIENDLY TOOLS GUIDE

 

| Task | Recommended App | Alternative |

||-|-|

| Data Entry | Google Sheets | Excel Mobile, Numbers (iOS) |

| Charts | Google Sheets built-in | Canva, Chart Maker |

| PDF Report | Google Docs | Word Mobile, WPS Office |

| Screenshots | Native screenshot tool | Screen Master, Firefox Screenshot |

| File Sharing | Google Drive | Dropbox, OneDrive |

 

Pro Tips for Mobile Users:

- Enable "Desktop Site" mode in browser for better dashboard functionality

- Use split-screen mode (Android) or floating windows to compare data sources

- Save offline copies of web pages using "Add to Home Screen" or Pocket app

- Voice-to-text for quick note-taking during data extraction

 

 

 

 7. EXPECTED OUTCOMES

 

Students should demonstrate:

- ✅ Accurate data extraction from government portals

- ✅ Correct application of energy conversion factors (MTOE, MU, kWh)

- ✅ Clear visualization of temporal and sectoral trends

- ✅ Critical analysis of energy policy effectiveness

- ✅ Understanding of grid management challenges in renewable-rich states

 

 

 

 8. REFERENCES

 

1. NITI Aayog. (2024). *India Energy and Climate Dashboard*. Retrieved from https://iced.niti.gov.in

2. Central Electricity Authority. (2024). *National Electricity Dashboard*. Ministry of Power, GoI.

3. Bureau of Energy Efficiency. (2024). *India Energy Scenario Report 2024*. Retrieved from https://beeindia.gov.in

4. Ministry of Coal. (2024). *Coal Statistics*. Government of India.

5. U.S. Energy Information Administration. (2025). *Country Analysis Brief: India*.

 

 

 

 9. ASSESSMENT RUBRIC

 

Criteria	Excellent (90-100)	Good (75-89)	Average (60-74)	Needs Improvement (<60)
Data Accuracy	No errors, proper units	Minor unit errors	Some data gaps	Significant inaccuracies
Visualization Quality	Publication-ready, insightful	Clear, labeled	Basic, cluttered	Missing or unclear
Analysis Depth	Policy-relevant insights	Good interpretation	Descriptive only	Superficial
Mobile Workflow	Innovative solutions	Documented well	Basic documentation	Poor or missing

 

 

 

SECTION C

Aim:
To collect, organize, and graphically analyze time-series data on the energy demand and consumption of a selected state, and to interpret the trends, patterns, and discrepancies between the two metrics using data visualization techniques in Microsoft Excel or Google Sheets.

Principle:
Energy planning requires a clear understanding of two key metrics:

1. Energy Demand: The total amount of energy required by all consumers in a state to meet their desired activities. It is a theoretical peak requirement, often measured in Megawatts (MW) for electricity.

2. Energy Consumption: The actual amount of energy used over a period of time (e.g., a year). It is measured in energy units like Gigawatt-hours (GWh) for electricity or Million Tonnes of Oil Equivalent (MTOE) for total energy.

The difference between demand (peak requirement) and consumption (total usage) is crucial. Demand dictates the need for power generation capacity, while consumption determines the total fuel required and resulting emissions. Graphical tools like line charts, bar charts, and stacked area charts are ideal for visualizing trends, seasonal patterns, and correlations between these metrics and drivers like economic growth.

Materials Required:

1. Computer with Internet Access

2. Data Visualization Software: Microsoft Excel or Google Sheets.

3. Data Sources:

   • Central Electricity Authority (CEA), India: https://cea.nic.in/ (Go to "Reports" > "Monthly Reports" > "Executive Summary" for state-wise data,  >  year > page 31 ).

   • National power portal , India: https://npp.gov.in

   • State Electricity Distribution Companies (DISCOMs): (e.g., MSEB for Maharashtra, TSSPDCL for Telangana). Their annual reports often contain rich historical data.

   • U.S. Energy Information Administration (EIA): https://www.eia.gov/ (for US states - use "State Energy Data System (SEDS)").

Procedure:

Phase 1: Selection of State and Data Acquisition (2-3 Hours)

1. Select a State: Choose a state known for its significant energy profile (e.g., Maharashtra - industrial hub, Tamil Nadu - renewable leader, California - high demand and progressive policies).

2. Acquire Data: Locate and download data for at least a 10-year period.

   • For Consumption (Annual): Find "Energy Sales" or "Energy Generated" data. This is typically in GWh or MU (Million Units, where 1 MU = 1 GWh).

   • For Demand (Peak/Daily): Find "Peak Demand Met" data. This is typically in MW or GW.

   • For Context: Also download data on Population and Gross State Domestic Product (GSDP) for the same years to understand drivers of energy use.

Phase 2: Data Preparation and Cleaning (1 Hour)

1. Create a Master Table in Excel/Sheets:

   Year	Peak Demand (MW)	Energy Consumption (GWh)	GSDP (Crore INR/ USD)	Population (Millions)
   2013	Value	Value	Value	Value
   2014	Value	Value	Value	Value
   ...	...	...	...	...
   2023	Value	Value	Value	Value

2. Calculate Derived Metrics:

   • Per Capita Consumption: = Energy Consumption / Population (GWh per million people, or convert to kWh per person).

   • Energy Intensity of Economy: = Energy Consumption / GSDP (GWh per Crore INR). This measures how much energy it takes to produce a unit of economic output.

Phase 3: Graphical Analysis and Visualization (2-3 Hours)
Create the following charts to tell the story of the state's energy landscape.

1. Chart 1: Dual-Axis Line Chart for Demand vs. Consumption

   • Purpose: To compare the trends of peak demand and total consumption on one chart.

   • How to Make:

     • Select columns Year, Peak Demand (MW), and Energy Consumption (GWh).

     • Go to Insert > Chart > Line Chart.

     • Right-click on the Energy Consumption data series in the chart, choose "Format Data Series" and select "Secondary Axis".

     • Format the chart: Add a title ("Peak Demand vs. Energy Consumption in Maharashtra (2013-2023)"), axis titles, and a legend.

2. Chart 2: Stacked Area Chart for Energy Mix (If Data Available)

   • Purpose: To visualize how the sources of energy (coal, hydro, solar, wind, gas) have changed over time.

   • How to Make:

     • Create a table with yearly data for the share of different energy sources.

     • Select all the data, including the year and source columns.

     • Go to Insert > Chart > Area Chart > Stacked Area.

3. Chart 3: Scatter Plot with Trendline (Consumption vs. GSDP)

   • Purpose: To identify the correlation between economic growth and energy consumption.

   • How to Make:

     • Select the columns for GSDP and Energy Consumption.

     • Go to Insert > Chart > Scatter Chart.

     • Right-click a data point, select "Add Trendline". Choose Linear and check "Display R-squared value on chart".

Phase 4: Interpretation and Report Writing (2 Hours)
Analyze the charts and write a concise report.

---

Observations & Data Analysis:

Table 1: Sample Data Snapshot for Maharashtra (2018-2023)

Year	Peak Demand (MW)	Energy Consumption (GWh)	GSDP (₹ Lakh Cr)	Per Capita Consumption (kWh)
2018	22,432	1,15,000	26.5	1,150
2019	23,000	1,20,500	28.1	1,180
2020	20,150	1,05,000	26.8	1,020
2021	24,400	1,18,000	29.5	1,130
2022	25,500	1,28,000	32.2	1,210
2023	28,000	1,35,000	35.0	1,260

Chart 1: Peak Demand vs. Energy Consumption in Maharashtra (2013-2023)
(Students will paste their Dual-Axis Line Chart here)

• Visual Analysis: The chart shows that both peak demand and energy consumption have a strong upward trend. The dip in 2020 is clearly visible due to the COVID-19 lockdowns. Peak demand appears to be growing at a slightly faster rate than total consumption post-2020.

Chart 3: Correlation between GSDP and Energy Consumption
(Students will paste their Scatter Plot here)

• Trendline Equation: y = 3500x + 20000

• R² Value: 0.92

• Interpretation: The high R² value (0.92) indicates a very strong positive correlation between economic activity (GSDP) and energy consumption in Maharashtra. The equation suggests that for every ₹1 Lakh Cr increase in GSDP, energy consumption increases by approximately 3,500 GWh.

---

Discussion:

1. Trend Analysis:

   • The consistent rise in both demand and consumption aligns with the state's economic and population growth. The post-2020 "rebound effect" shows a rapid recovery and even acceleration in energy use.

   • The fact that peak demand is growing faster than total consumption is a critical finding for planners. It suggests a increasing simultaneity of use—more people and industries are using high-power appliances at the same time (e.g., during evening hours). This strains the grid more than a gradual increase in total consumption would.

2. The 2020 Anomaly:

   • The sharp drop in both metrics in 2020 is a clear indicator of the impact of the COVID-19 pandemic. The lockdowns led to the closure of industries and commercial establishments, which are major energy consumers, leading to a temporary reduction in both peak load and total energy use.

3. Policy and Sustainability Implications:

   • The strong correlation with GSDP highlights the challenge of decoupling economic growth from energy consumption. The state's growth is still heavily reliant on increasing energy use.

   • The rising peak demand implies a need for investments in peak power plants (often expensive and gas-fired) or, more sustainably, in demand-side management (DSM) programs. DSM includes initiatives like:

     • Time-of-Day (TOD) tariffs to incentivize off-peak usage.

     • Promoting energy efficiency to flatten the demand curve.

     • Developing grid-scale battery storage to store solar energy generated during the day for use during peak evening hours.

Conclusion:

This practical demonstrated that graphical tools are indispensable for transforming raw energy data into actionable insights. The analysis for Maharashtra revealed not just a simple story of growth, but a more complex narrative where the pattern of consumption (peak demand) is becoming as important as the total amount. The strong link between economic activity and energy use underscores the ongoing challenge of sustainable development. The findings suggest that future energy policy must focus not only on adding generation capacity but also aggressively on managing demand, improving energy efficiency, and integrating storage solutions to ensure a reliable and sustainable energy future for the state.

Viva Voce Questions:

1. What is the fundamental difference between energy "demand" (MW) and "consumption" (GWh), and why is this difference important?

   • Demand (MW) is the rate at which energy is used at a specific instant (like the speed of a car). It determines the capacity of power plants and grid infrastructure needed.

   • Consumption (GWh) is the total amount of energy used over a period (like the total distance traveled). It determines the total fuel needed, costs, and emissions.

   • Importance: A grid must be built to handle the peak demand, even if that peak only lasts for a few hours a year. High demand growth requires building new power plants, while high consumption growth requires securing more fuel supplies.

2. What does the COVID-19 dip in your charts tell you about the primary drivers of energy consumption in your chosen state?
   The sharp dip indicates that industrial and commercial activities are the primary drivers of the state's energy consumption, as these were the sectors most affected by the lockdowns. Residential consumption likely increased slightly, but not enough to offset the drop from the commercial and industrial sectors.

3. If you were a state energy minister, what would the fact that peak demand is rising faster than total consumption tell you about what your policy focus should be?
   It would tell me that my focus should shift from just building more power plants (supply-side management) to demand-side management (DSM). My policies would prioritize incentives for energy efficiency, smart meters with time-of-use pricing, and programs to encourage consumers to shift their energy use away from peak hours.

4. Why did we create a scatter plot of Energy Consumption vs. GSDP? What does a high R-squared value imply?
   We created it to quantify the relationship between economic growth and energy use. A high R-squared value (close to 1) implies that a very large portion of the change in energy consumption can be explained by the change in economic output (GSDP). It suggests the state's economy is still heavily dependent on energy-intensive activities.

5. What other graph could you use to show how the contribution of solar and wind energy has changed over time?
   A stacked area chart or a 100% stacked column chart would be perfect. It would visually show the absolute or relative growth of renewables (solar, wind) compared to conventional sources (coal, gas) over the selected years, highlighting the transition towards a cleaner energy mix.