• If the SKYCONDITION column reports a value of OVC or BKN, then report the last three digits in the CEILING column and multiply by 100.
o For example, OVC110 should report 11000 in the CEILING column
• If there are multiple values, use the lowest OVC or BKN numeric value
o For example, SCT015 SCT020 OVC030 should report 3000 in the ceiling column
• All other observations (i.e. CLR, FEWXXX, SCTXXX) should report “N/A” in the CEILING column.
Example of my Excel sheet:
SkyCondition Ceiling
SCT110
OVC110
OVC100
CLR
OVC110
BKN017 BKN027 OVC041
OVC012
CLR
CLR
Bookmarks