20230705IPC to Staff PR 4 Attachment - Data_Import_LnR.pdf

%%% Programmed by:  Andrés Valdepeña Delgado             01/06/2021
%%% Contact info:   [e-mail]
%%% Revised by:     Shelby McNeilly                      04/12/2022
%%% Revised by:     Andrés Valdepeña Delgado             01/23/2023
%%% Revised by:     Shelby McNeilly                      01/27/2023

%%% Input description:
%%% 2020‐2022 historical timestamps, load, wind, solar, RoR hydro & COGEN
%%% Output description:
%%% Imports inputs into MATLAB & creates data timetables for each year
opts = spreadsheetImportOptions("NumVariables", 6);
opts.Sheet = string(test_year);
opts.DataRange = "A2:F8761";
opts.VariableNames = ["Start_Date", "Load", "Wind", "Solar", "Hydro", "COGEN"];
opts.VariableTypes = ["datetime", "double", "double", "double", "double", 
"double"];
data = readtable([cd '\IPC_L&R_Data_NoDR.xlsx'], opts, "UseExcel", false);
clear opts
Data_TT = table2timetable(data);