Polar Orbiting- The satellite passes near or passes the north and south poles of the equator on the top or bottom approximately 90 degrees.
Geostationary Orbit – An orbit, which places the object directly above the equator and remains stationary in the sky circling the Earth at the same rate of spin.
Syntax – A set of rules used to combine commands in a programming language
Latitude – Gives a location north or south of the equator
Longitude – Gives a location east and west of Greenwich, England
Remote Sensing – Examining without touching
Nautical Mile – A unit of measure equaling one minute of arc along any meridian. There are 60 nautical miles in one degree of latitude
Knots – A unit of speed equal to one nautical mile per hour
RADAR – Radio Distance and Ranging. Records how long it takes the signal to bounce off an object
CERSER – Center of Excellence in Remote Sensing Education and Research
CReSIS – Center for Remote Sensing Ice Sheets
Datum- singular form information gathered
Data – plural form information gathered
.csv – Comma Separated Values
.ht – height file
MHz- One million cycles per second (Hertz)
.xlsx- extension for Microsoft Excel
.txt- text file
^p- paragraph mark
,^p- comma paragraph mark
Formulas used in excel:
=(C1-360) : C1 was a longitude ranging from 0-360º. This formula converted that longitude to a + or – longitude ranging from 0-180º.
=IF((Sheet1!$A26/$I/$1)=INT(Sheet1!$A26/$I$1),Sheet1!A26,””) this function compared a division calculation to an integer division calculation. Used for reducing the number of lines visible in a spreadsheet.
=IF((H1=”0″),”0″, -(H1)): If depth reading is in H column, converts it to a negative for graphing purposes.
=IF ((D1=0), M, If ((E1=C),C,A)): An IF statement nested within a second IF statement. This function set a cell to M, A, or C depending on the data in cells D1 and E1.
=IF(may14_05!$A2/ROUNDUP(COUNT(may14_05!$A:$A)/32000,0)=INT(may14_05!$A2/ROUNDUP(COUNT(may14_05!$A:$A)/32000,0)),may14_05!A2,””): This function compared a division calculation to an integer division calculation. Used for reducing the number of lines visible in a spreadsheet to 32000 lines or less.
=COUNTA(A:A): Total lines in column A
=COUNTIF(J:J,”M”) : number of M lines in column J
=COUNTIF(J:J,”C”) : number of C lines in column J
=COUNTIF(J:J,”A”): number of A lines in column J
=IF(S1!$A1/ROUNDUP(COUNT(S1!$A:$A)/200,0)=INT(S1!$A1/ROUNDUP(COUNT(S1!$A:$A)/200,0)),S1!A1,””) This formula was use to reduce lines to 200 to convert the files into .CSV files for Google map.
