%% Import data from spreadsheet
% Script for importing data from the following spreadsheet:
%
%    Workbook: /home/wela/DW/MEDRC/Input/CanadianLP.xlsx
%    Worksheet: yInterac2
%
% Auto-generated by MATLAB on 08-Sep-2022 23:16:11

%% Setup the Import Options and import the data
opts = spreadsheetImportOptions("NumVariables", 1);

% Specify sheet and range
opts.Sheet = Sheet;
opts.DataRange = "A2:A850";

% Specify column names and types
opts.VariableNames = "edate";
opts.VariableTypes = "datetime";

% Specify variable properties
opts = setvaropts(opts, "edate", "InputFormat", "");

% Import the data
tbl = readtable("/home/wela/DW/MEDRC/Input/CanadianLP.xlsx", opts, "UseExcel", false);

%% Convert to output type
edate = tbl.edate;
datesy = [year(edate) month(edate) day(edate)]; 


%% Clear temporary variables
clear opts tbl edate





%% Import data from spreadsheet
% Script for importing data from the following spreadsheet:
%
%    Workbook: /home/wela/DW/MEDRC/Input/CanadianLP.xlsx
%    Worksheet: yInterac2
%
% Auto-generated by MATLAB on 08-Sep-2022 23:18:46

%% Setup the Import Options and import the data
opts = spreadsheetImportOptions("NumVariables", 4);

% Specify sheet and range
opts.Sheet = Sheet;
opts.DataRange = "B2:E850";

% Specify column names and types
opts.VariableNames = ["value", "volume", "ABM", "POS"];
opts.VariableTypes = ["double", "double", "double", "double"];

% Import the data
datay = readtable("/home/wela/DW/MEDRC/Input/CanadianLP.xlsx", opts, "UseExcel", false);

%% Convert to output type
datay = table2array(datay);

%% Clear temporary variables
clear opts