%%?Automate?the?Data?Import?Process
%?This?script?imports?data?from?the?Zonal?hourly?spreadsheets?provided?by
%?ISO?New?England?（www.iso-ne.com）.?The?folder?containing?these
%?spreadsheets?should?be?specified?below.?By?default?it?is?assumed?to?be?a
%?folder?called?“Data“?in?the?same?folder?as?this?script.?The?data?that?is
%?read?in?is?saved?as?a?MAT-file?in?the?same?folder.

folder?=?‘Data‘;
%?Example:?folder?=?‘C:\Temp\Data‘;

%?By?default?the?sheet?name?is?ISONE?CA.?However?it?can?easily?be?changed
%?to?ME?CT?VT?NH?RI?SEMASS?WCMASS?or?NEMASSBOST?to?extract?zonal?data
sheetname?=?‘ISONE?CA‘;

%?Import?data?for?2004
if?strcmp（sheetname?‘ISONE?CA‘）
????NEData?=?dataset（‘XLSFile‘?sprintf（‘%s\\2004_smd_hourly.xls‘folderyr）?‘Sheet‘?‘NEPOOL‘）;
else
????NEData?=?dataset（‘XLSFile‘?sprintf（‘%s\\2004_smd_hourly.xls‘folderyr）?‘Sheet‘?sheetname）;
end
%?Add?a?column?‘Year‘
NEData.Year?=?2004?*?ones（length（NEData）1）;
????
%?Import?data?for?other?years
for?yr?=?2005:2009

????%?Read?in?data?into?a?dataset?array
	x?=?dataset（‘XLSFile‘?sprintf（‘%s\\%d_smd_hourly.xls‘folderyr）?‘Sheet‘?sheetname）;
????
????%?Add?a?column?‘Year‘
????x.Year?=?yr*ones（length（x）1）;
????
????%?Concatenate?the?datasets?together
????NEData?=?[NEData;?x];
end

%?Calculate?numeric?date
NEData.NumDate?=?datenum（NEData.Date?‘mm/dd/yyyy‘）?+?（NEData.Hour-1）/24;

save（[folder?‘\‘?genvarname（sheetname）?‘_Data.mat‘]?‘NEData‘）;

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件??????28160??2010-03-29?11:40??Electricity?Load?&?Price?Forecasting\Data\Holidays.xls

?????文件????????464??2010-11-11?15:13??Electricity?Load?&?Price?Forecasting\Data\Where?to?get?data.txt

?????文件???????1465??2010-11-11?15:12??Electricity?Load?&?Price?Forecasting\importData.m

?????文件?????693503??2010-11-11?15:56??Electricity?Load?&?Price?Forecasting\Introduction?to?Load?&?Price?Forecasting?Case?Study.pdf

?????文件?????300125??2011-05-06?11:23??Electricity?Load?&?Price?Forecasting\Load\Data\DBLoadData.mat

?????文件?????244979??2018-05-07?18:55??Electricity?Load?&?Price?Forecasting\Load\Data\testSet.mat

?????文件?????437685??2010-09-10?10:24??Electricity?Load?&?Price?Forecasting\Load\Data\trainSet.mat

?????文件???????1370??2011-05-06?11:22??Electricity?Load?&?Price?Forecasting\Load\fetchDBLoadData.m

?????文件????????844??2010-06-09?08:00??Electricity?Load?&?Price?Forecasting\Load\fitPlot.m.lnk

?????文件??????51399??2010-11-11?15:38??Electricity?Load?&?Price?Forecasting\Load\Forecaster.prj

?????文件??????17706??2010-11-11?15:42??Electricity?Load?&?Price?Forecasting\Load\Forecaster.xlsx

?????文件???????2582??2010-09-09?16:16??Electricity?Load?&?Price?Forecasting\Load\genPredictors.m

?????文件??????14277??2010-09-07?14:38??Electricity?Load?&?Price?Forecasting\Load\html\CalibrationReport.html

?????文件??????19468??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN.html

?????文件???????3610??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN.png

?????文件??????15322??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_01.png

?????文件???????8138??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_02.png

?????文件???????9688??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_03.png

?????文件???????7847??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_04.png

?????文件???????8663??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_05.png

?????文件??????14609??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_06.png

?????文件??????14465??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_07.png

?????文件??????14500??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_08.png

?????文件??????14642??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_09.png

?????文件??????14389??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_10.png

?????文件??????14421??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_11.png

?????文件??????14795??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_12.png

?????文件??????14998??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_13.png

?????文件??????14458??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_14.png

?????文件??????15139??2010-09-10?10:40??Electricity?Load?&?Price?Forecasting\Load\html\LoadscriptNN_15.png

............此處省略121個(gè)文件信息