20230705IPC to Staff PR 4 Attachment - Data_Inport_Exports_Losses.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 customer generator exports by class
%%% 8,760 loss factors
%%% Output description:
%%% Imports inputs into MATLAB & creates data tables for each year
opts = spreadsheetImportOptions("NumVariables", 5);
opts.Sheet = string(test_year);
opts.DataRange = "A2:E8761";
opts.VariableNames = ["Date", "Residential", "Small_Comm", "Large_Comm", 
"Irrigation"];
opts.VariableTypes = ["datetime", "double", "double", "double", "double"];
exports_class = readtable([cd '\IPC_Exports_by_Class.xlsx'], opts, "UseExcel", 
false);
clear opts
opts = spreadsheetImportOptions("NumVariables", 1);
opts.Sheet = "Loss_Factors";
opts.DataRange = "A2:A8761";
opts.VariableNames = "Loss_Factors";
opts.VariableTypes = "double";
loss_factors_import = readtable([cd '\IPC_Loss_Factors.xlsx'], opts, "UseExcel", 
false);
clear opts
loss_factors = 1 + (loss_factors_import.Loss_Factors.*Loss_TG);