clear all
%% Import data from text file.
% Script for importing data from the following text file:
%
%    C:\Users\Manuel\Documents\MATLAB\Lidar\1.csv
%
% To extend the code to different selected data or a different text file,
% generate a function instead of a script.

% Auto-generated by MATLAB on 2013/06/05 18:58:20

%% Initialize variables.
filename = 'C:\Users\Manuel\Documents\MATLAB\Lidar\1.csv';
delimiter = ',';
startRow = 2;

%% Format string for each line of text:
%   column1: date strings (%s)
%	column2: double (%f)
%   column3: double (%f)
%	column4: double (%f)
%   column5: double (%f)
%	column6: double (%f)
%   column7: double (%f)
%	column8: double (%f)
%   column9: double (%f)
%	column10: double (%f)
%   column11: double (%f)
%	column12: double (%f)
%   column13: double (%f)
%	column14: double (%f)
%   column15: double (%f)
%	column16: double (%f)
%   column17: double (%f)
%	column18: double (%f)
%   column19: double (%f)
%	column20: double (%f)
%   column21: double (%f)
%	column22: double (%f)
%   column23: double (%f)
%	column24: double (%f)
%   column25: double (%f)
%	column26: double (%f)
%   column27: double (%f)
%	column28: double (%f)
%   column29: double (%f)
%	column30: double (%f)
%   column31: double (%f)
%	column32: double (%f)
%   column33: double (%f)
%	column34: double (%f)
%   column35: double (%f)
%	column36: double (%f)
%   column37: double (%f)
%	column38: double (%f)
%   column39: double (%f)
%	column40: double (%f)
%   column41: double (%f)
%	column42: double (%f)
%   column43: double (%f)
%	column44: double (%f)
%   column45: double (%f)
%	column46: double (%f)
%   column47: double (%f)
%	column48: double (%f)
%   column49: double (%f)
%	column50: double (%f)
%   column51: double (%f)
%	column52: double (%f)
%   column53: double (%f)
%	column54: double (%f)
%   column55: double (%f)
%	column56: double (%f)
%   column57: double (%f)
%	column58: double (%f)
%   column59: double (%f)
%	column60: double (%f)
%   column61: double (%f)
%	column62: double (%f)
%   column63: double (%f)
%	column64: double (%f)
%   column65: double (%f)
%	column66: double (%f)
%   column67: double (%f)
%	column68: double (%f)
%   column69: double (%f)
%	column70: double (%f)
%   column71: double (%f)
%	column72: double (%f)
%   column73: double (%f)
%	column74: double (%f)
%   column75: double (%f)
%	column76: double (%f)
%   column77: double (%f)
%	column78: double (%f)
%   column79: double (%f)
%	column80: double (%f)
%   column81: double (%f)
%	column82: double (%f)
%   column83: double (%f)
%	column84: double (%f)
%   column85: double (%f)
%	column86: double (%f)
%   column87: double (%f)
%	column88: double (%f)
%   column89: double (%f)
%	column90: double (%f)
%   column91: double (%f)
%	column92: double (%f)
%   column93: double (%f)
%	column94: double (%f)
%   column95: double (%f)
%	column96: double (%f)
%   column97: double (%f)
%	column98: double (%f)
%   column99: double (%f)
%	column100: double (%f)
%   column101: double (%f)
%	column102: double (%f)
%   column103: double (%f)
%	column104: double (%f)
%   column105: double (%f)
%	column106: double (%f)
%   column107: double (%f)
%	column108: double (%f)
%   column109: double (%f)
%	column110: double (%f)
%   column111: double (%f)
%	column112: double (%f)
%   column113: double (%f)
%	column114: double (%f)
%   column115: double (%f)
%	column116: double (%f)
%   column117: double (%f)
%	column118: double (%f)
%   column119: double (%f)
%	column120: double (%f)
%   column121: double (%f)
%	column122: double (%f)
%   column123: double (%f)
%	column124: double (%f)
%   column125: double (%f)
%	column126: double (%f)
%   column127: double (%f)
%	column128: double (%f)
%   column129: double (%f)
%	column130: double (%f)
%   column131: double (%f)
%	column132: double (%f)
%   column133: double (%f)
%	column134: double (%f)
%   column135: double (%f)
% For more information, see the TEXTSCAN documentation.
formatSpec = '%s%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%[^\n\r]';

%% Open the text file.
fileID = fopen(filename,'r');

%% Read columns of data according to format string.
% This call is based on the structure of the file used to generate this
% code. If an error occurs for a different file, try regenerating the code
% from the Import Tool.
dataArray = textscan(fileID, formatSpec, 'Delimiter', delimiter, 'EmptyValue' ,NaN,'HeaderLines' ,startRow-1, 'ReturnOnError', false);

%% Close the text file.
fclose(fileID);

%% Post processing for unimportable data.
% No unimportable data rules were applied during the import, so no post
% processing code is included. To generate code which works for
% unimportable data, select unimportable cells in a file and regenerate the
% script.

%% Convert the contents of column with dates to serial date numbers using date format string (datenum).
dataArray{1} = datenum(dataArray{1}, 'yyyy-mm-dd HH:MM:SS');

%% Allocate imported array to column variable names
Timestamp = dataArray{:, 1};
pressuremmHg = dataArray{:, 2};
temperatureC = dataArray{:, 3};
humidity = dataArray{:, 4};
precipitation01 = dataArray{:, 5};
spd_20_horz_minms = dataArray{:, 6};
spd_20_horz_maxms = dataArray{:, 7};
spd_20_horz_meanms = dataArray{:, 8};
spd_20_horz_stdms = dataArray{:, 9};
spd_20_vert_minms = dataArray{:, 10};
spd_20_vert_maxms = dataArray{:, 11};
spd_20_vert_meanms = dataArray{:, 12};
spd_20_vert_stdms = dataArray{:, 13};
dir_20_minDeg = dataArray{:, 14};
dir_20_maxDeg = dataArray{:, 15};
dir_20_meanDeg = dataArray{:, 16};
dir_20_stdDeg = dataArray{:, 17};
wind_measure_20_quality = dataArray{:, 18};
spd_39_horz_minms = dataArray{:, 19};
spd_39_horz_maxms = dataArray{:, 20};
spd_39_horz_meanms = dataArray{:, 21};
spd_39_horz_stdms = dataArray{:, 22};
spd_39_vert_minms = dataArray{:, 23};
spd_39_vert_maxms = dataArray{:, 24};
spd_39_vert_meanms = dataArray{:, 25};
spd_39_vert_stdms = dataArray{:, 26};
dir_39_minDeg = dataArray{:, 27};
dir_39_maxDeg = dataArray{:, 28};
dir_39_meanDeg = dataArray{:, 29};
dir_39_stdDeg = dataArray{:, 30};
wind_measure_39_quality = dataArray{:, 31};
spd_59_horz_minms = dataArray{:, 32};
spd_59_horz_maxms = dataArray{:, 33};
spd_59_horz_meanms = dataArray{:, 34};
spd_59_horz_stdms = dataArray{:, 35};
spd_59_vert_minms = dataArray{:, 36};
spd_59_vert_maxms = dataArray{:, 37};
spd_59_vert_meanms = dataArray{:, 38};
spd_59_vert_stdms = dataArray{:, 39};
dir_59_minDeg = dataArray{:, 40};
dir_59_maxDeg = dataArray{:, 41};
dir_59_meanDeg = dataArray{:, 42};
dir_59_stdDeg = dataArray{:, 43};
wind_measure_59_quality = dataArray{:, 44};
spd_81_horz_minms = dataArray{:, 45};
spd_81_horz_maxms = dataArray{:, 46};
spd_81_horz_meanms = dataArray{:, 47};
spd_81_horz_stdms = dataArray{:, 48};
spd_81_vert_minms = dataArray{:, 49};
spd_81_vert_maxms = dataArray{:, 50};
spd_81_vert_meanms = dataArray{:, 51};
spd_81_vert_stdms = dataArray{:, 52};
dir_81_minDeg = dataArray{:, 53};
dir_81_maxDeg = dataArray{:, 54};
dir_81_meanDeg = dataArray{:, 55};
dir_81_stdDeg = dataArray{:, 56};
wind_measure_81_quality = dataArray{:, 57};
spd_99_horz_minms = dataArray{:, 58};
spd_99_horz_maxms = dataArray{:, 59};
spd_99_horz_meanms = dataArray{:, 60};
spd_99_horz_stdms = dataArray{:, 61};
spd_99_vert_minms = dataArray{:, 62};
spd_99_vert_maxms = dataArray{:, 63};
spd_99_vert_meanms = dataArray{:, 64};
spd_99_vert_stdms = dataArray{:, 65};
dir_99_minDeg = dataArray{:, 66};
dir_99_maxDeg = dataArray{:, 67};
dir_99_meanDeg = dataArray{:, 68};
dir_99_stdDeg = dataArray{:, 69};
wind_measure_99_quality = dataArray{:, 70};
spd_120_horz_minms = dataArray{:, 71};
spd_120_horz_maxms = dataArray{:, 72};
spd_120_horz_meanms = dataArray{:, 73};
spd_120_horz_stdms = dataArray{:, 74};
spd_120_vert_minms = dataArray{:, 75};
spd_120_vert_maxms = dataArray{:, 76};
spd_120_vert_meanms = dataArray{:, 77};
spd_120_vert_stdms = dataArray{:, 78};
dir_120_minDeg = dataArray{:, 79};
dir_120_maxDeg = dataArray{:, 80};
dir_120_meanDeg = dataArray{:, 81};
dir_120_stdDeg = dataArray{:, 82};
wind_measure_120_quality = dataArray{:, 83};
spd_130_horz_minms = dataArray{:, 84};
spd_130_horz_maxms = dataArray{:, 85};
spd_130_horz_meanms = dataArray{:, 86};
spd_130_horz_stdms = dataArray{:, 87};
spd_130_vert_minms = dataArray{:, 88};
spd_130_vert_maxms = dataArray{:, 89};
spd_130_vert_meanms = dataArray{:, 90};
spd_130_vert_stdms = dataArray{:, 91};
dir_130_minDeg = dataArray{:, 92};
dir_130_maxDeg = dataArray{:, 93};
dir_130_meanDeg = dataArray{:, 94};
dir_130_stdDeg = dataArray{:, 95};
wind_measure_130_quality = dataArray{:, 96};
spd_132_horz_minms = dataArray{:, 97};
spd_132_horz_maxms = dataArray{:, 98};
spd_132_horz_meanms = dataArray{:, 99};
spd_132_horz_stdms = dataArray{:, 100};
spd_132_vert_minms = dataArray{:, 101};
spd_132_vert_maxms = dataArray{:, 102};
spd_132_vert_meanms = dataArray{:, 103};
spd_132_vert_stdms1 = dataArray{:, 104};
dir_132_minDeg = dataArray{:, 105};
dir_132_maxDeg = dataArray{:, 106};
dir_132_meanDeg = dataArray{:, 107};
dir_132_stdDeg = dataArray{:, 108};
wind_measure_132_quality = dataArray{:, 109};
spd_134_horz_minms = dataArray{:, 110};
spd_134_horz_maxms = dataArray{:, 111};
spd_134_horz_meanms = dataArray{:, 112};
spd_134_horz_stdms = dataArray{:, 113};
spd_134_vert_minms = dataArray{:, 114};
spd_134_vert_maxms = dataArray{:, 115};
spd_134_vert_meanms = dataArray{:, 116};
spd_134_vert_stdms = dataArray{:, 117};
dir_134_minDeg = dataArray{:, 118};
dir_134_maxDeg = dataArray{:, 119};
dir_134_meanDeg = dataArray{:, 120};
dir_134_stdDeg = dataArray{:, 121};
wind_measure_134_quality = dataArray{:, 122};
spd_166_horz_minms = dataArray{:, 123};
spd_166_horz_maxms = dataArray{:, 124};
spd_166_horz_meanms = dataArray{:, 125};
spd_166_horz_stdms = dataArray{:, 126};
spd_166_vert_minms = dataArray{:, 127};
spd_166_vert_maxms = dataArray{:, 128};
spd_166_vert_meanms = dataArray{:, 129};
spd_166_vert_stdms = dataArray{:, 130};
dir_166_minDeg = dataArray{:, 131};
dir_166_maxDeg = dataArray{:, 132};
dir_166_meanDeg = dataArray{:, 133};
dir_166_stdDeg = dataArray{:, 134};
wind_measure_166_quality = dataArray{:, 135};

%% Clear temporary variables
clearvars filename delimiter startRow formatSpec fileID dataArray ans;
%erstelle Datumswerte für Timestamp
formatOut = 'yyyy-mm-dd HH:MM:SS';
time = datestr(Timestamp,formatOut,'local')