Arbitrage CSV Mapper & Merger

Upload your two CSVs, preview the headers, then map the right columns. After that, merge to add SEK/MWh.

Guided Workflow

  1. Load energy prices: In panel 1, pick your Nord Pool CSV and map the interval and price columns.
  2. Load FX rates: In panel 2, upload the EUR/SEK CSV and confirm the date and rate fields.
  3. Merge & review: Click Merge & Compute SEK/MWh to preview the combined table.
  4. Export data: Download the merged CSV for version control and/or send it straight to the simulator.
  5. Run simulator: Scroll down to the simulator workspace, load the merged rows, and walk through the modelling steps.

Tip: keep DevTools open with “Disable cache” while iterating so you always load fresh scripts.

Upload status
Energy prices
Energy: no file selected
FX rates
FX: no file selected

Tip: shared datasets are fetched from GitHub → /data/ (latest files starting with GUI_ENERGY_PRICES and Växelkurser).

1) Energy Prices
2) EUR/SEK Rates
Step 1: load energy prices → Step 2: load FX rates → Step 3: merge to unlock download & simulator hand-off.
start_utc end_utc area price_eur_per_mwh date_utc eursek price_sek_per_mwh

1) Data (prices in SEK/MWh)

CSV fallback (paste here)

No price rows loaded yet.

2) Build 15-minute timeline

No 15-min timeline yet.

Arbitrage Simulator

Load the merged SEK/MWh price table below and walk through the 15 minute timeline, Swedish villa load model, battery controller, KPIs, and exports — no extra tab required.

Price coverage: —

Quick Checklist

  1. Load price data: Use “Load last merge” or paste CSV, then confirm the ingest status banner.
  2. Build timeline: Click Build 15-min timeline and glance at the preview table.
  3. Generate load: Enter annual kWh and create the Swedish villa profile.
  4. Configure battery: Adjust controller sliders for your scenario.
  5. Run simulation: Execute, study KPIs, daily rollups, and export if needed.

Tip: the ingest banner always shows the active period so you can spot missing data early.

3) Swedish villa load model

No load profile yet.

Average Summer Day (load + price)
Average Winter Day (load + price)

Average Daily Price Spread by Month

4) Battery & controller

Estimated charge/discharge limit will update automatically.
Advanced settings
Run the simulation to view daily load, price, and battery behaviour.
House Load Cost Without Battery (SEK/kWh)
House Load Cost With Battery (SEK/kWh)
Battery Savings vs Baseline (SEK/kWh)
Total Grid Intake (House + Battery Charge + Battery Standby) kW
House Load Served (kW)
Battery Power (+ Discharge / − Charge) kW
Accumulated House Consumption (kWh)
Energy Price (SEK/kWh)
Battery State of Charge (kWh)
Battery VWAP Cost (SEK/kWh)

Simulation not run yet.

Self‑test (loads sample CSVs and merges)

This fills the dropdowns, runs a merge, and enables “Send to Simulator”.