%% Import data from spreadsheet
% Script for importing data from the following spreadsheet:
%
%    Workbook: /home/wela/DW/MEDRC/Input/CanadianLP.xlsx
%    Worksheet: CanadaStringency
%
% Auto-generated by MATLAB on 08-Sep-2022 22:24:33

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

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

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

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

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




%% Clear temporary variables
clear opts
dates = tbl.dates;
dates = [year(dates) month(dates) day(dates)];

%% Import data from spreadsheet
% Script for importing data from the following spreadsheet:
%
%    Workbook: /home/wela/DW/MEDRC/Input/CanadianLP.xlsx
%    Worksheet: CanadaStringency
%
% Auto-generated by MATLAB on 08-Sep-2022 22:33:59

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

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

% Specify column names and types
opts.VariableNames = ["StringencyIndex", "NewCasesrhs", "PositivityRatelhs", "Lockdown", "Reopening", "Lockdown1", "Reopening1", "Lockdown2", "Reopening2", "Lockdown3", "Reopening3"];
opts.VariableTypes = ["double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double"];

% Import the data
datareg = readtable("../Input/CanadianLP.xlsx", opts, "UseExcel", false);

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

%% Clear temporary variables
clear opts