The Solar Ledger

Rigorous data, system architectures, and real analysis for modern solar

In my previous post, we established the economic baseline for an unbuffered 1,200 W plug-in solar system. The annual balance sheet works: even with zero net metering credits, an entry-level kit pays for itself in roughly six years.

However, that baseline analysis exposed an acute operational flaw: the shoulder-season surplus paradox. For example, on a sunny March day the modeled 1,200 W system would have produced 8.96 kWh of AC power, but Leg 1 household demand would only have absorbed 2.70 kWh. The remaining 6.25 kWh (69.8% of daily production) would have flowed out through the meter, uncredited onto the distribution grid. Under Virginia’s plug-in solar law’s “use-it-or-lose-it” rules, that power is a zero-dollar gift to the utility.

This brings us to the next phase of the evaluation: Adding a local battery to a plug-in solar array. A battery on a 120V plug-in circuit saves excess generation, allowing it to be used later as solar production wanes. However, the central question is not whether storage works, but whether the capital cost of adding kilowatt-hours of storage pays off by capturing that uncredited surplus.

Modeled System Setup

A 1200 W peak capacity solar array connected to an all-in-one AC-coupled plug-in solar plus storage system with:

  • A microinverter
  • Battery management system
  • Current transformer (CT) clamps

Unlike traditional hybrid inverters that manage large central arrays, these units are module-level power electronics (MLPE) devices, converting direct current (DC) from solar panels into alternating current (AC) right at the source while simultaneously managing energy flow to a connected battery. The CT clamps allow measuring energy flows to and from the grid, so the system can prevent power export.

Some systems like this do exist, but they aren’t currently available to purchase in Virginia. I expect that to change after Virginia’s new plug-in solar law comes into effect January 1, 2027.

Modeling the Daily Capture Curve: The March 28 Benchmark

To evaluate how effectively battery storage preserves the economic value of excess generation, I ran an analysis of five storage sizes (1, 3, 5, 7, and 9 kWh) against a 24-hour period starting with the first solar generation on March 28, 2026.

To model realistic battery physics, I assumed an 80% usable Depth of Discharge (DoD) window (e.g., cycling between 10% and 90% state-of-charge to protect cell longevity). I chose the five battery sizes to demonstrate the incremental value gained from larger capacities:

Battery Size (kWh) Usable Capacity (kWh - 80% DoD)
1 0.8
3 2.4
5 4
7 5.6
9 7.2

The boundary conditions for the modeled day were set by the smart meter readings from Dominion Power Virginia and the power generation curve using pvlib:

Parameter Value Notes
Model Start March 28, 2026 7:30:00 - 7:59:59 The first period of solar production in the analyzed day
Model End March 29, 2026 7:00:00 - 7:29:59 Last period immediately preceding resumption of solar electricity generation in the modeled 24 hour period
1,200 W Solar DC Generation 9.47 kWh DC 8.96 kWh AC potential
Daytime Leg 1 Demand 2.70 kWh AC 2.85 kWh DC consumed by inverter
Excess Solar Available to Shunt to Battery 6.62 kWh DC
Nighttime Leg 1 Demand 2.08 kWh AC Consumed across 21 intervals between sunset and sunrise
Total Leg 1 Demand 5.26 kWh AC 3.18 kWh daytime + 2.08 kWh overnight

The model assumptions also included storing the excess energy directly as DC with a 95% round-trip efficiency. The DC electricity was only converted to AC to meet the needs of Leg 1 electrical demand, with a 95% efficiency across the AC inverter.

Household Power Leg 1 Modeled Results

Battery Size (kWh) Daytime Solar AC Energy Delivered (kWh) Nighttime Battery AC Energy Delivered (kWh) Total Energy Delivered (kWh) Remaining Grid Reliance (kWh)
Solar-Only 2.7 0 2.7 2.56
1 2.7 0.74 3.44 1.82
3 2.7 2.08 4.78 0.48
5 2.7 2.08 4.78 0.48
7 2.7 2.08 4.78 0.48
9 2.7 2.08 4.78 0.48

Due to high solar panel output in full sun and mild spring weather, combined with relatively low household energy consumption, a 3 kWh battery is sufficient to store enough energy to meet the overnight demand on leg 1 of the electrical system.

Leg 1 energy use vs energy supplying source

You’ll notice that even with the largest battery size, the household system still imported 0.48 kWh from the grid for Leg 1. This occurs because the scenario begins with the battery at 0% state of charge. As the sun rises, initial solar production is insufficient to cover Leg 1 usage, resulting in 0.48 kWh imported before solar generation overtakes demand.

Diurnal energy integration: cumulative solar generation and leg 1 demand

The above graph shows the total energy generated by the solar panels (green area) relative to total energy consumption (red area) throughout the day, clearly demonstrating the significant excess production by the solar panels.

The below graph shows the state of charge of the different battery storage sizes modeled and their ability to capture the excess energy. The accumulation rises throughout the day, up to the system limits and begin discharging to leg 1 as solar production dips below demand.

Battery storage charge state

The battery state of charge shows the profile of energy accumulation during the day and subsequent discharge overnight to meet household demand on leg 1. The 3 kWh battery was the minimum size necessary to store enough energy to provide 100% of the overnight energy use on leg 1. The 9 kWh battery was the only system able to capture 100% of the excess generated energy. However, due to the limited power usage in the scenario, much of the excess would need to be used on subsequent days for it all to be consumed.

Battery Size (kWh) Percent of DC Surplus Captured Percent of Overnight Demand Met Percent of Leg 1 Demand Met Percent of Total Household Energy Demand Met
Solar-Only 0.0% 0.0% 51.4% 25.7%
1 12.4% 35.7% 65.5% 32.8%
3 37.2% 100.0% 90.9% 45.5%
5 62.0% 100.0% 90.9% 45.5%
7 86.8% 100.0% 90.9% 45.5%
9 100.0% 100.0% 90.9% 45.5%

Insights

  • Near-Total Leg 1 Self-Sufficiency: On a temperate day, when the household energy demand is low, adding modest storage transforms the performance of the branch circuit. A 3 kWh battery is sufficient to enable meeting 90.9% of leg 1 energy demand on the modeled day.
  • The Single-Leg Saturation Ceiling: The 1,200 W solar array actually generated more power than the total household consumption for the analysis period. This highlights the fundamental limitation of a single-circuit plug-in architecture, even if storage eliminates 100% of Leg 1's grid reliance, on mild, sunny days the array would generate more energy than that single circuit would use.

While batteries significantly enhance the value of a photovoltaic system during shoulder seasons, how long would it take for utility savings to offset the initial investment? My next post will analyze year-round performance and system economics.

Tags: #Solar #PlugIn #Balcony #BatteryStorage #Modeling

Modeling the Standalone Value of Plug-In Solar in Northern Virginia

When Virginia passed House Bill 395, allowing plug-in solar systems up to 1,200 W starting January 1, 2027, it created a distinct class of distributed generation. Unlike traditional rooftop net-metered arrays, plug-in solar operates under strict physical and regulatory guardrails: it connects directly to a standard household branch circuit, bypasses utility interconnection review, and is explicitly excluded from net metering.

In Virginia, plug-in solar is strictly “use-it-or-lose-it.” Any generation not consumed behind your electric meter at the exact instant of production flows back into the distribution grid without credit.

This raises an immediate practical question for Northern Virginia homeowners and renters: Does an unbuffered 1,200 W plug-in system deliver enough real-world bill reduction to justify its upfront cost?

To answer this, I modeled a year of generation using historical weather and insolation data from Bailey’s Crossroads, Virginia (August 1, 2025 – July 31, 2026), paired against my actual split-phase residential load data downloaded from Dominion Electric Virginia.

The Fallacy of the “Average Day”

Financial models for solar often rely on annual averages. Over the modeled 12-month period, Bailey’s Crossroads received 1,568.57 kWh/m² of total daily solar insolation, translating to a daily mean of 4.30 kWh/m².

Note: This is the maximum possible energy that could be captured, however a photovoltaic system is only able to capture about ~15-20% of the available solar energy.

A daily average of 4.30 kWh/m² might suggest a steady, predictable stream of energy (kWh). The real distribution tells a different story.

Metric Insolation (kWh/m²)
Maximum 8.58
95th Percentile 7.73
75th Percentile (Q3) 6.07
50th Percentile (Median) 4.09
25th Percentile (Q1) 2.64
5th Percentile 1.12
Minimum 0.30

Daily insolation value for Bailey's Crossroads, VA August 1, 2025 through July 31, 2026

(Note: Visualizing the daily swing from 0.30 to 8.58 kWh/m² makes it obvious why designing around a simple mean fails.)

Sunlight arrives in feast-or-famine cycles, driven by seasonal changes and weather impacts to useful daylight, as well as changes in ambient temperatures impacting the efficiency of the photovoltaic panels to convert the irradiance into usable electricity.

Three Days, Three Realities

To evaluate how a standard 1,200 W array (plugged into Leg 1 of a standard 120/240V split-phase service) performs against household demand, consider three specific days from the model.

Daily generation vs power usage example trigraph

1. The Winter Floor: January 10, 2026

Heavy cloud cover, short daylight window, low ambient temperature.

On heavily overcast winter days, available irradiance collapses. On January 10, the array produced just 0.357 kWh DC, resulting in 0.339 kWh AC delivered to the household after inverter conversion losses.

  • Household Context: Total household demand was 22.13 kWh (11.07 kWh on Leg 1).
  • Grid Export: 0.00 kWh (0%).
  • Demand Offset: The system offset 3.1% of Leg 1 demand, or 1.5% of total household energy.

There is zero waste here—every watt generated is consumed instantly by baseline appliances—but the raw offset is negligible.

2. The Spring Surplus Paradox: March 28, 2026

High irradiance, cool air temperatures 50-60°F (10-16°C), low household load.

March 28 represents prime operating conditions: high insolation paired with cool ambient temperatures that keep panels operating near peak electrical efficiency. The 1,200 W system produced 8.956 kWh AC, losing only 0.037 kWh to inverter clipping.

  • Household Context: Mild weather meant no heating or cooling; total household consumption was just 10.05 kWh (5.03 kWh on Leg 1).
  • Demand Offset: The array provided 2.704 kWh toward Leg 1 demand, covering 53.8% of that circuit's daily energy.
  • Grid Export: 6.252 kWh (69.8%) flowed backward out of the home.

Under HB 395, this 6.25 kWh export earned exactly $0.00. It served neighboring loads on the local transformer while providing zero financial return to the system owner.

3. The Midsummer Thermal Penalty: July 4, 2025

Clear skies, high peak sun, ambient high temperature of 103°F.

July 4 delivered strong insolation (7.47 kWh/m²), well above the annual average. Under Standard Test Conditions (77°F / 25°C), a 1,200 W array would run near capacity for several hours. Instead, the system generated 6.699 kWh AC.

Why didn't generation peak at 1,200 W? Thermal derating.

Photovoltaic silicon exhibits a negative temperature coefficient of maximum power, typically degrading output by -0.35% to -0.45% per degree Celsius above 25°C. On a 103°F / 39.4°C summer afternoon, roof-level or balcony panel cell temperatures would routinely surpass 65°C (149°F), shedding 15% to 20% of rated nameplate capacity.

  • Household Context: Air conditioning and continuous charging of the EV drove total household demand to 64.03 kWh (32.02 kWh on Leg 1).
  • Grid Export: 0.00 kWh (0%).
  • Demand Offset: The system covered 20.9% of Leg 1 demand (10.5% of total household demand).

EV charging was 1,440 W continuous throughout the day until after sunset, meaning that every kilowatt-hour generated by the 1,200 W array was consumed behind the meter. Note: EV charging is really only on one household leg but for this analysis it was split evenly between the two legs.

The Annual Economics: Does Standalone Plug-In Solar Pay Off?

A single day in March might make plug-in solar look inefficient, but energy economics depend on the entire 365-day balance sheet. The modeled system generated 1,958 kWh over the course of the year. By looking at the Leg 1 electrical demand and the vs. generated power instead of simple sums, I determined the following balance of the use of the energy:

  • Direct Self-Consumed Energy: 1,015 kWh (51.5%)
  • Uncredited Grid Export: 943 kWh (48.20%)

Payback Calculation

In Northern Virginia, Dominion Energy’s residential Schedule 1 all-in rate sits at roughly $0.172 per kWh (including base generation, distribution, and fuel adjustments).

  1. Annual Retail Savings: 1,015 kWh * $0.172 / kWh = $174.58

  2. Capital Expenditure (CapEx): A quality, compliant UL 3700-certified 1,200 W balcony kit (three ~400 W panels, integrated microinverter, mounting hardware, and outdoor-rated disconnect cord) retails for roughly $1,000.

  3. Simple Payback Period: $1,000 (system cost) / $174.58 (savings per year) = 5.73 years

Even without net metering credits and discarding more than 50% of production, the standalone 1,200 W system pays for itself well within the standard 20-to-25-year lifespan of standard solar hardware. For renters and homeowners alike, it serves as a viable, low-friction tool to reduce electric bills.

The total household electricity consumption over the analytical period was 6,737 kWh. The 1,015 kWh of solar electricity that was consumed represents approximately 15% of total electricity used. If all of the generated electricity could have been self-consumed this would have represented approximately 29% of total energy usage, a not-insignificant increase in value.

The Unresolved Dilemma

While the baseline economics work, the data exposes an obvious structural inefficiency:

  1. Summer and winter production are suppressed—winter by short, overcast days, and summer by thermal derating right when air conditioners demand peak power.

  2. Spring production is heavily wasted, with roughly 70% of generation dumped back into the grid uncredited because midday baseloads on a single leg are too small to absorb it.

The standalone system works, but it leaves substantial energy on the table. In the next post, I examine what happens when you introduce behind-the-meter storage: Can a small, modular battery capture that 70% spring surplus and shift it into evening peak hours—and does the added hardware justify its cost?

Tags: #Solar #PlugIn #Balcony #BatteryStorage #Modeling

Introduction

Evaluating the true potential of a plug-in solar system starts with understanding your actual household energy demand. To figure out whether a DIY plug-in solar setup makes sense for my home, I analyzed my electricity usage over a full 12-month period—from August 1, 2025 through July 31, 2026.

While utility billing cycles rarely align perfectly with calendar months, I used a linear regression cost model to overcome this. As discussed in my previous article on building an open data pipeline and cost impact model, this approach lets me calculate energy consumption and estimated costs for any custom date range with high accuracy.

Why Split Usage by 2?

A key technical detail when evaluating plug-in solar is how standard North American residential electrical panels work. Most homes receive 240V split-phase power divided into two separate 120V “legs” or lines. Because standard plug-in solar microinverters plug into a standard 120V wall outlet, they only feed power into one of those two legs.

To estimate how much electricity usage a single-leg solar setup can offset, I divide total household energy consumption by two. Assuming a clean 50/50 balance between Leg 1 and Leg 2 is an approximation, but it is the only practical approach available given that my utility only provides whole-home consumption in 30-minute blocks.

Estimating that each leg represents 50% of energy consumption holds up best during peak summer months, which account for the bulk of my annual grid import. My central air conditioner runs on a 240V circuit, drawing power equally across both legs simultaneously, and it represents roughly half of my summer electricity consumption. The remaining ~50% of summer consumption primarily consists of discrete 120V loads whose phase distribution is unmetered.

In the winter, when the AC is idle, almost all consumption shifts to those 120V circuits. Because I haven’t mapped individual branch circuits to their respective legs, I can't be as confident about how evenly balanced that winter usage really is, but without panel-level monitoring an even split remains the most sensible estimate.

Annual Usage Breakdown & Monthly Highlights

Here is the breakdown of my energy consumption across all 12 months, along with the estimated daily usage per leg:

Month Average Daily Energy Usage per Leg (kWh) Total Monthly Energy Usage per Leg (kWh) Monthly Cost per Leg Effective Rate per kWh
August (2025) 15.0 465.2 $76.99 $0.17
September 10.2 305.8 $52.64 $0.17
October 7.0 216.2 $38.96 $0.18
November 5.5 164.4 $31.05 $0.19
December 7.8 241.8 $42.87 $0.18
January (2026) 8.2 253.6 $44.67 $0.18
February 7.8 217.6 $39.17 $0.18
March 7.4 228.8 $40.88 $0.18
April 6.1 181.5 $33.66 $0.19
May 6.6 203.9 $37.08 $0.18
June 14.1 421.5 $70.32 $0.17
July 15.1 468.6 $77.51 $0.17

Looking at the monthly trends, November 2025 represented the lowest usage month of the year at 328.8 kWh total (an average of 5.5 kWh/day per leg). On the opposite end, July 2026 hit the highest usage peak at 937.2 kWh total (an average of 15.1 kWh/day per leg).

The total estimated cost for the single leg of energy over this 12-month period was $585.77. This figure represents the absolute maximum theoretical savings a plug-in solar system could have achieved under Dominion Energy Virginia's rate structure. Because a standard plug-in solar setup cannot generate enough electricity to fully offset this demand (even if oversized by 25%) this amount sets a firm ceiling on expected cost savings.

Estimated daily energy usage per leg of household power over the course of a year

Energy consumption changes significantly across the seasons due to heating and cooling demands:

  • Shoulder Seasons (Fall & Spring): During spring and autumn, my heating and cooling systems stay off most of the time. Opening windows handles temperature control, leading to the lowest electrical demand of the year.
  • Winter Heating Demand: Because my home uses natural gas for primary heating rather than an electric heat pump, winter electricity demand remains modest. However, daily usage still rises compared to shoulder seasons because the furnace fan requires electric power to circulate warm air.
  • Summer Peak Demand: Air conditioning drives the largest electricity load by far, doubling or tripling daily usage compared to spring and fall months.

Note: I started charging my EV at my house in June. Charging raised my total electricity usage for June and July but the overall trends for the year remain consistent, I’ve now just raised my baseline electricity usage.

Conclusion & What's Next

By analyzing a full year of energy consumption, I established a clear understanding of the maximum impact a plug-in solar system can have. In the next post, I’ll demonstrate the grid-power offset potential of the previously modeled 1,200 W and 1,500 W systems at a more granular level and the expected payback periods.

Tags: #Solar #PlugIn #Balcony #Modeling

Modeling 1,200W vs. 1,500W in Virginia

When exploring plug-in solar, a natural first question is: How much electricity will this system actually generate every day?

To answer this with mathematical precision rather than marketing guesswork, I modeled daily solar generation for my residence in Fairfax County, Virginia over a full 365-day year (August 2025 to July 2026). Using physics-based modeling and hyper-local historical weather data, here is what the data reveals about plug-in solar generation, the impact of panel “overpaneling,” heat penalties, and potential real-world saving.

1. Regulatory Context: Why the 1,200 W Inverter Cap?

Under Virginia’s plug-in solar law, residential plug-in solar devices up to 1,200 Watts DC per dwelling unit can be connected directly into standard 120V household wall outlets without formal utility pre-approval, interconnection fees, or complex electrical panel upgrades.

However, a solar array with a nameplate capacity of 1,200 W would rarely reach that limit due to weather effects (clouds, heat, or time of year). Commercial installations typically oversize their arrays about 25% to be able to reliably generate the expected amount of energy. Virginia’s plug-in solar law does not allow for oversizing but it’s an interesting analysis to see the extra value you would get from an oversized array with a microinverter that would limit the output to 1,200W.

2. The Modeling Setup: 1,200 W vs. 1,500 W Arrays

Using the physics-based Python pvlib library (implementing NREL’s benchmark PVWatts DC model) combined with 30-minute irradiance, ambient temperature, and wind speed data from the Open-Meteo API for Fairfax County, VA (38.85° N, -77.13° W), I simulated two fixed, South-facing (180° azimuth) arrays tilted at 38.85°:

  • Baseline Array: 1,200 W DC nameplate capacity paired with a 1,200 W inverter (95% DC-to-AC efficiency).
  • Oversized Array: 1,500 W DC nameplate capacity (25% more panel capacity) paired with the same 1,200 W max inverter output limit.

3. Average Daily Generation & Dollar Savings

Below is a graph of how much energy each system would produce based on an average of the days across the entire year:

Average daily solar power generation from a 1,200 W array vs.

The table below gives greater detail and the expected savings if 100% of the generated, energy displaced electricity that otherwise would have been pulled from the grid.

System Configuration Raw Daily Generation (kWh) Daily Output Limited to 1,200 W (kWh) Energy Lost to Clipping Estimated Daily Value ($0.18/kWh) Estimated Annual Value
1,200 W Solar Array 5.344 kWh 5.343 kWh 0.02% ~$0.96 / day ~$350 / year
1,500 W Solar Array 6.683 kWh 6.589 kWh 1.41% ~$1.19 / day ~$432 / year

Clipping occurs when the solar array outputs more power than enough power for the microinverter to produce 1,200 W AC. A legally compliant microinverter would limit the output to 1,200 W (clipping) so that the system remains compliant with the law.

My average cost of electricity is $0.18/kWh. However, this cost depends on total usage. In my county, we have three different categories of costs that scale differently: * Strictly Proportional Charges (generation, transmission, fuel, deferred fuel cost charge, sales and use surcharge, and state/local consumption tax scale linearly with consumption. * Partially Proportional Charges: distribution service charge consists of a fixed monthly customer charge plus a variable per-kWh rate. * Capped Non-Proportional Charges: County utility tax contains a fixed base fee plus a capped variable rate.

The Power of “Overpaneling”

By oversizing the panel array by 25% (1,500 W total panels feeding a 1,200 W max output), the total delivered daily output increases by 23.33% (from 5.34 kWh to 6.59 kWh per day). Even though peak midday generation exceeds the 1,200 W inverter limit on clear days. Based on this average output value, only 1.41% of total potential annual power would be lost to clipping.

4. Hardware & Purchasing Costs: Is Oversizing Worth It?

Retail rigid solar panels (300 W to 400 W nameplate ratings from major manufacturers like Renogy, BougeRV, Aptos, or EcoFlow) typically cost $120 to $180 per panel ($0.40–$0.55 per Watt).

  • Baseline 1,200 W Hardware: Four 300 W panels (~$600 total panel cost).
  • Oversized 1,500 W Hardware: Five 300 W panels (~$750 total panel cost).

Adding one extra 300 W panel costs approximately $150. At $0.18 per kWh, generating an additional 1.25 kWh per day provides $0.225/day ($82.12/year) in extra value. That extra panel pays for itself in under 20 months.

5. High vs. Low Days: The Counterintuitive “Heat Penalty”

Solar production isn't just a function of daylight hours; temperature plays a massive role due to the solar panel temperature coefficient (-0.0047 / °C).

  • Clear Spring Day (March 28, 2026 - High Temp 49°F):
    • 1,200 W Array Output: 8.96 kWh (clipped)
    • 1,500 W Array Output: 10.11 kWh (clipped)
    • Cool ambient temperatures keep panel efficiency near maximum, yielding over 10 kWh in a single day!

Modeled solar power generation on March 28, 2026 for 1,200 W vs 1,500 W array

  • Hot Summer Day (July 4, 2026 - High Temp 103°F):
    • 1,200 W Array Output: 6.70 kWh
    • 1,500 W Array Output: 8.37 kWh
    • Extreme summer heat derates panel output, and atmospheric haze/humidity reduces solar intensity—producing about 75% of the daily output of a crisp spring day despite longer daylight hours!

Modeled power generation on July 4, 2026 for a 1,200 W vs.

6. What's Coming Up Next: Real Household Demand Analysis

Knowing how much power your panels generate on paper is only half the battle. Because plug-in solar operates on a single 120V circuit leg without net metering, any power produced above your home's instantaneous demand flows out to the grid for free.

In my next post, I'll look at real smart meter data from my home! I'll analyze 30-minute interval electrical load profiles across single-phase circuits to calculate exact real-time self-consumption and uncompensated exports. Stay tuned!

Tags: #Solar #PlugIn #Balcony #Modeling

To evaluate the true financial returns of plug-in solar and battery storage, generalized assumptions must be replaced with high-resolution empirical data. Minute-by-minute data would enable excellent modeling, however this requires specialized equipment installed in the breaker box and a dedicated data capture system. Fortunately, most utilities offer 30-minute utility meter interval readings you can download from your account. With this data , plus past bills, meteorological data, and a physics-based photovoltaic (PV) simulation, I was able to create an excellent model of the actual utility power offset and the projected impact to my bill.

1. Data Extraction: Navigating Utility Export Limitations

The utility industry established the Green Button Energy Service Provider Interface (ESPI) XML standard to allow consumers to download energy usage data. However, data collection from my utility revealed two critical limitations in Green Button XML exports:

  • UI Restrictions & Date Limits: The customer portal's XML export tool enforces a restriction limiting downloads strictly to the trailing 13 months, blocking access to historical multi-year data.
  • Low Data Precision: Green Button XML exports round consumption readings to whole integer kilowatt-hours (1 kWh resolution), obscuring subtle household power dynamics.

To overcome this, I chose to build my data pipeline using my utility’s “Download Detailed Data” Excel (.xlsx) export option. This format provides continuous 30-minute interval readings at three decimal places of precision (0.001 kWh). An automated Python ETL script parses these workbooks, aligns intervals chronologically, and ingests them into a local DuckDB time-series database. 

2. Bill Parsing & Tariff Structure Regression

Standard solar calculators assume an average flat electricity rate, but real utility tariffs consist of complex, multi-tiered line items. To model financial savings accurately, I created a Python script to extract the 21 meaningful line items from the monthly PDF bill statements. I used ordinary least squares (OLS) linear regressions with the data to classify fee behavior into three structural categories:

  1. Strictly Proportional Charges: Generation, transmission, fuel, deferred fuel cost, sales/use surcharge, and state/local consumption taxes scale linearly down to zero with lower kWh usage.

  2. Partially Proportional Charges: Distribution service charges consist of a fixed monthly base customer fee of $11.23 plus a variable per-kWh rate.

  3. Capped Non-Proportional Charges: The local utility tax consists of a \$0.60 base fee plus a variable rate capped at a maximum of \$4.00/month.

When solar generation reduces grid energy consumption, fixed customer base fees and tax caps remain untouched while variable supply and distribution rates scale down proportionally.

3. Satellite Solar Irradiance & Performance Modeling

Solar generation potential was derived using historical meteorological data retrieved from the Open-Meteo API for my county. The dataset provides 30-minute resolution Global Horizontal Irradiance (GHI), Direct Normal Irradiance (DNI), Diffuse Horizontal Irradiance (DHI), ambient temperature, and wind speed.

Photovoltaic DC output was calculated using the physics-based PVWatts DC model implemented via Python's pvlib library (utilizing benchmarks established by my favorite National Lab - the National Laboratory of the Rockies, formerly NREL):

  • System DC Rating: 1,200, 1,300, 1,400, and 1,500 W
  • Array Orientation & Tilt: Fixed South-facing (Azimuth \= 180°), 38.85° tilt angle (equal to site latitude)
  • Temperature Coefficient: -0.0047 / °C
  • Inverter Conversion Efficiency: 95.0% DC-to-AC
  • Battery Round-Trip Efficiency: 95.0%

4. Interval Simulation & Split-Phase Logic

For each 30-minute block, AC solar generation is calculated:

$$\text{Solar AC (kWh)} = \left(\frac{\text{DC Power (W)} \times 0.5\text{ hrs}}{1000}\right) \times \text{Inverter Efficiency}$$ Net grid energy draw is then evaluated under an assumed 50/50 split-phase load across two 120 V legs (while this is not an ideal assumption, it’s the the best approximation I can make given the data I have available):

  • Solar-Only Configuration (Single-Phase Injection): Solar offsets Leg 1 only. Any generation exceeding Leg 1's simultaneous load ($0.5 \times \text{Grid Demand}$) cannot cross phases and flows back to the utility grid uncredited. As a result, the maximum possible power offset is limited to 50% of Grid Demand:

$$\text{Grid Draw} = \max(0, 0.5 \times \text{Grid Demand} – \text{Solar AC}) + 0.5 \times \text{Grid Demand}$$

  • Solar + Battery Configuration: A 2.0 kWh modular LiFePO₄ battery buffers excess generation on Leg 1 before it reaches the main service panel, eliminating single-phase export losses and discharging to offset aggregate household demand over time:

$$\text{Grid Draw} = \text{Grid Demand} – (\text{Solar AC} \times \text{Battery Efficiency})$$

Tags: #Solar #PlugIn #Balcony #BatteryStorage #Modeling

Why Online Calculators Lie

Residential solar is undergoing a major structural transformation. Home solar adoption has historically been defined by large-scale rooftop installations requiring steep upfront capital investments, complex municipal permitting, structural engineering assessments, and formal utility interconnection agreements. Today, a new class of accessible technology (plug-in/balcony solar solar) is gaining massive popularity. In Virginia, for example, a recent law will make plug-in solar systems up to 1,200 W DC legal starting January 1, 2027 (the full text of the law can be found on the Virginia Legislative Information System). Rather than requiring hard-wiring into a main breaker panel through a dedicated circuit, these micro-systems plug directly into standard residential AC outlets.

Despite growing consumer interest, evaluating the true financial return of small-scale plug-in systems remains surprisingly difficult. Most web-based solar estimators rely on crude monthly averages and oversimplified financial assumptions that fail to capture the realities of utility rate structures and instantaneous power demand. Standard solar estimators fall victim to three fundamental analytical blind spots:

1. The Naive Proportionality Assumption

Standard calculators typically estimate savings by multiplying total annual solar kWh generation by a single average electricity rate (e.g., $0.18/kWh). In reality, utility bill tariffs are non-linear. Electric bills are composed of fixed monthly customer service charges, fixed administrative fees, step-down tax rates, and capped municipal taxes. Reductions in electricity consumption lower variable energy supply charges, but leave fixed customer base fees entirely untouched.

2. The Interval Simultaneity Problem

Electricity generation and household consumption must match instantaneously in real time. If a 1.2 kW solar array generates 900 Watts of power at 1:00 PM on a sunny afternoon, but household baseload demand is only 300 Watts, the remaining 600 Watts will flow back into the grid. Plug-in solar in the US doesn't allow for net-metering, this excess daytime energy yields zero financial credit.

3. The Split-Phase Injection Blind Spot

Crucially, standard solar models overlook a foundational physical constraint of North American residential electrical architecture: 120V/240V split-phase service. Power is delivered across two separate 120 V legs (Leg 1 and Leg 2). A standard 120 V plug-in solar microinverter connects to a single branch receptacle wired exclusively to one leg. Solar power injected into Leg 1 cannot cross over in real time to offset 120 V loads running on Leg 2. Even if total household demand equals or exceeds instantaneous solar generation, any solar output exceeding Leg 1's isolated load flows straight back through the meter uncredited, while Leg 2 continues drawing full paid power from the grid.

By failing to account for single-phase injection and real-time simultaneity, conventional whole-home analyses severely overestimate the self-consumption of solar-only setups—and consequently drastically undervalue the economic necessity of local battery storage.

Tags: #Solar #PlugIn #Balcony #BatteryStorage

Rigorous data analysis, system architectures, and the business of modern solar.

In my opinion, discussions surrounding solar adoption collapse into two extremes: ideological enthusiasm or vendor sales pitches. Both tend to gloss over the practical engineering constraints and economic analysis that determine whether a system actually delivers value.

The Solar Edge is an independent, data-driven blog focused on unpacking the real-world mechanics and value of solar power. It is fundamentally an analytical working notebook. The goal is to develop a deep, first-principles understanding of distributed energy resources by modeling them openly, documenting edge cases, and confronting the friction points where hardware meets policy.