p2p_model-julia_data_read.jl

##### P2P Data Read #####

using DataFrames
using XLSX

## Data read-in from XLSX file
demand_df = DataFrame(XLSX.readtable(data_file, "Demand"));
mc_df = DataFrame(XLSX.readtable(data_file, "MC"));
res_df = DataFrame(XLSX.readtable(data_file, "Renewables"));
bat_df = DataFrame(XLSX.readtable(data_file, "Storage"));
fit_df = DataFrame(XLSX.readtable(data_file, "FIT"));

## Generation and demand data
res = Matrix(res_df[!,2:end])';      # renewable production of house n
dem = Matrix(demand_df[!,2:end])';   # demand of house n

## Cost data
p_mc = Matrix(mc_df[!,2:end])';         # MC of house n
p_d = bat_df[:,:p_d];                   # price of discharging battery of house n
p_fit = Matrix(fit_df[!,2:end])';       # FIT of house n

## Storage data
α = bat_df[:,:alpha];       # maximum charge rate of battery of house n
β = bat_df[:,:beta];        # maximum discharge rate of battery of house n
η = bat_df[:,:eta];         # battery discharging efficiency of house n
s_min = bat_df[:,:s_min];   # lower storage bound of house n
s_max = bat_df[:,:s_max];   # upper storage bound of house n
s_init = 0;                 # initial storage level

## Transmission data
ϕ = 0.93;                   # transmission loss

## Sets
N = [1:size(dem,1)...];     # houses n in community N
T = [1:size(res,2)...];     # hours t in time horizon T
H = ["H$(N[i])" for i in 1:length(N)];

@info "The model parameter scope is set to" T N