Upload Templates
Download the CSV/Excel templates below and populate them with your data before uploading via the API.
All CSV files use , as the delimiter and the date format DD/MM/YYYY. Time intervals follow the 15-minute ISP grid (00:15, 00:30, …, 24:00).
Meter & Consumption Data
| Template |
Columns |
Download |
| Consumos — Meter readings for consumption/generation loads |
Data, Hora, Contador, Energia |
CSV |
| Perdas — Network losses per voltage level |
Data, Hora, BT, MT, AT, AT/RNT, MAT |
CSV |
| Coeficientes fixos — Fixed sharing coefficients per CPE |
Data, Hora, CPE, Coeficiente de partilha |
CSV |
| Custo de oportunidade — Buy/sell opportunity cost per meter |
Data, Hora, Contador, Valor Compra, Valor Venda |
CSV |
| Tarifas ERSE — ERSE retail tariff reference values |
(Excel) |
XLSX |
| DSO allocation file — v2 allocation file from the DSO |
(SGL v2) |
SGL v2 |
Battery & Storage
| Template |
Columns |
Download |
| Bateria — Battery state of charge per resource |
Data, Hora, Recurso, EstadoCargaBateria |
CSV |
| Sizing energy consumed — Historical energy consumed for sizing |
DateTime, Contador, e_c |
CSV |
Electric Vehicles
| Template |
Columns |
Download |
| Charging intervals forecast — Planned EV charging windows |
Data, Hora, Recurso, Carregar |
CSV |
| Driving loads — Energy consumed while driving |
Data, Hora, Recurso, Energia |
CSV |
Heat Pump
| Template |
Columns |
Download |
| Outside temperature — Ambient temperature forecast |
Data, Hora, Recurso, Temperatura |
CSV |
| Water mass usage forecast — Hot water demand forecast |
Data, Hora, Recurso, Massa_Agua |
CSV |
Electric Water Heater
| Template |
Columns |
Download |
| EWH usage — Hot water usage duration per resource |
Data, Hora, Recurso, Duracao |
CSV |
Local Market
| Template |
Columns |
Download |
| Bilateral prices — Bilateral trade prices between producer and consumer |
Data, Hora, Produtor, Consumidor, Preço |
CSV |