FORMAT OF PROCESSED FILES (LEVEL 1)

FILENAMES:

iphex_Duke_rain_gauge_PMM-###-PROCESSED-DDMMMYY-DDMMMYY-L1.xlsx

WHERE ### IS THE GAUGE NUMBER
THE FIRST DDMMMYY IS THE START OF THE PERIOD OF RECORD
THE SECOND DDMMMYY IS THE END OF THE PERIOD OF RECORD

INSIDE THE FILE THE FORMAT IS:

COLUMN 1: CUMULATIVE RAINFALL AMOUNT, MM
COLUMN 2: DATE, DD-MMM-YY
COLUMN 3: TIME, HH:MM:SS (TIME IS IN EDT)
COLUMN 4: QUALITY FLAG

FILES ENDING .CSV ARE THE SAME EXCEPT COLUMNS DELIMITED WITH COMMAS.

QUALITY FLAG DETAIL:

C: CLOGGED GAUGE (I.E., STANDING WATER WAS FOUND IN THE GAUGE TOP). THIS FLAG
   WILL BE PLACED ON ALL DATA BETWEEN THE LAST VISIT AND THE DATE IT WAS FOUND IN
   THIS STATE. 
K: GAUGE WAS FOUND KNOCKED OVER. THIS FLAG WILL BE PLACED ON ALL DATA BETWEEN
   THE LAST VISIT AND THE DATE IT WAS FOUND. DATA WITH THIS FLAG HAS BEEN JUDGED
   TO BE VALID BUT THERE IS NOT 100% CERTAINTY SINCE THERE IS NO WAY TO TELL
   ON WHICH DATE THE GAUGE WAS KNOCKED OVER.
T: TIME SHIFT HAS BEEN DETECTED OR DESCRIBED HERE AND FIXED.
M: MISSING PERIOD. THERE WILL ALWAYS BE TWO OF THESE FLAGS IN A ROW, ONE TO
   INDICATE THE START DATE/TIME OF THE MISSING PERIOD AND THE SECOND TO INDICATE
   THE END. THE AMOUNT IN COLUMN 1 WILL STAY THE SAME.
O: DATA HAVE NOT FAILED ANY OF THE QUALITY CHECKS DESCRIBED ABOVE.