a = 6378137;
f = 1/298.257223563;
e = sqrt(2*f - f^2);
ellipsoid = [a e];
utmstruct= defaultm('utm');
utmstruct.zone = '10N';
utmstruct.geoid = ellipsoid;
utmstruct = defaultm(utm(utmstruct));

startRow = 3;
incr = 2;
numPts = 47;
endRow = startRow + (numPts - 1) * incr;

startCol = 'C';
range = strcat(startCol, num2str(startRow), ':', startCol, num2str(endRow));
degLat = xlsread('MARS_Post-AUV_Survey-04_18-Apr-06.xls', 'RPL', range);
startCol = 'D';
range = strcat(startCol, num2str(startRow), ':', startCol, num2str(endRow));
minLat = xlsread('MARS_Post-AUV_Survey-04_18-Apr-06.xls', 'RPL', range);
lat = degLat + minLat/60.0

startCol = 'F';
range = strcat(startCol, num2str(startRow), ':', startCol, num2str(endRow));
degLon = xlsread('MARS_Post-AUV_Survey-04_18-Apr-06.xls', 'RPL', range);
startCol = 'G';
range = strcat(startCol, num2str(startRow), ':', startCol, num2str(endRow));
minLon = xlsread('MARS_Post-AUV_Survey-04_18-Apr-06.xls', 'RPL', range);
lon = -(degLon + minLon/60.0)

[e, n] = mfwdtran(utmstruct, lat, lon)
xlswrite('MARS_Post-AUV_Survey-04_18-Apr-06.xls', n, 'RPL', 'AL3');
xlswrite('MARS_Post-AUV_Survey-04_18-Apr-06.xls', e, 'RPL', 'AM3');


