Grid Storage Model

Enter MW GEN GRID dd per timestamp — positive charges the battery from grid, negative generates to grid. All other columns recalculate live from the workbook formulas.

+ Onboard premise →

Assumptions

Storage size (J1) MWh

Round-trip factor × on H

Time series

Tap a series to toggle on / off · plotted in date-time order

Quick add: MW

Hourly schedule

Green column = your input · everything else is derived

Date	Hour	MW GEN GRID dd	ChargeFromGridMWhIF(C>0, \|C/2\|, 0)	ChargeFromGridD × 2	GenGridMWhIF(C<0, \|C/2\|, 0)	GenGridF × 2	Storage Capacity±D/F × factor	SOCpSOCe / J1	SOCeΣ H (running)

Self-contained model of Maryana.xlsx · Sheet1. SOCe is a continuous running sum of Storage Capacity (H) across all rows in order.
D=IF(C>0,ABS(C/2),0) · E=D*2 · F=IF(C<0,ABS(C/2),0) · G=F*2 · H=IF(C>0,D*factor,-F*factor) · I=SOCe/J1 · L=L(prev)+H