ࡱ>  I\p Bill Klein Ba==`Tl$<8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1xArial1xArial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1QTahoma1QTahoma1QTahoma1 Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0 00000mmmm\ d\,\ yyyy                + ) , *   !"@@  "@@ ("@@   " ""@@ * * * * " !"@  " @  "@  "@  " @  " @    "@@  "@  "@ * @  "  "  "  "@@  "@  "@  " !  "@ @ @@  @  @    @    @ @   @ @ @ @@ @ @ !@ @  @ @  ""@ @  "@ @  "!@ @  "@ @  "@ @  "@ @  "@ @  "!@ @  " @  !@ @ ""@ @  "@ @  "@ @  "!@ @  "@ @  "@ @  "@ @  "@ @  "!@ @  " @  !@ @  "!@ @  " @  "@ @  !@ @  "@  "@  "@  "!@   @ @ 8  !@ @ 8  @ @ 8  !@ @ ""!@ @   !@ @ 8  !!@ @ 8  !@ @ 8  @ @8@ @  "@ @  "@ @   !@ @8 "@ @  "!@ @   !@ @ !  !@   ! @  U@   @   P @ @ @ @ @ @ @   @  @  Q@ "@ @ "@ @  "Q@ @  @ @   Q@   Q @  Q@   Q@   PQ @ ! @! " ! ! ! !    (  @ @  "@ @  "@ @  "!@ @  "! @ "  @ @ @@ @  "@  "@@ @ @  " @ !  x@@)  x@)  x  @)  x@)  x)  x )  x @ )  x )  x )   #"@@  0"@  0 " @   @@   @ !@@ !@ !@@ *@@ * @ *@ *   @@ @   @ @    @@ @   @ !@ @ !@  "@@ "@  " @  @@  @ @   @@  @ @ @ @  "@ @ "@ @ @ @ @ @  @@  @   @  @@   @  @  @  @    @ @@ @ @@ @  @   @  @ @  @ @  Q@ @  Q@ @   @    @   @    @   P @ @ @ @ @  @@  @  @@ @  @  @@  @  U@@  U@ (U@  @@ @ "U@ "U@  Q@@  P  Q@  Q@@ Q@ Z@ @ Z@ Z@ Z@ @ Z@ Z@ @ @ @ @ @ @  U@  U@  PU @   @  @ @ @ @ @ @  x@@)  x@)  x  @)  x@)  x)  x )  x @ )  x )  x ) `!6 Information-Instructions^=Daily Data Entry ;B-92 TB-83abZ  3  @@  -|tAvg.SumDATEMax.Min.Dry-bulbWet-bulb Dew Point24 Hours Ending at ObservationAt ObservationStation&Supplemental Readings at______________Air Temperature (F)Time of beginningCountyTime of ending+Rain, Melt- ed Snow etc. (in. & hundredths)&Snow, Ice Pellets, Hail (in. & tenths)24 Hour AmountsAt Obsn.+Snow, Ice Pellets Hail, Ice on ground (in.)StateDate (Month & yr.) PRECIPITATION!Ane- mometer Dial Reading (Miles)24 Hour MovementWIND)Gage Reading or Amount Added + 2Reading When Tank Filled or Amount Removed -Amount of Evapora- tion,EVAPORATION (inches & hundredths) )Time of Complete Observation (Local time)Standard Time in UseWATER TEMP. (F)ADDITIONAL DATA / REMARKSOBSERVERSTATION NUMBERGreatestAdjusted TotalU.S DEPARTMENT OF COMMERCE NOAA NATIONAL WEATHER SERVICE 0 4 z @RECORD OF EVAPORATION AND CLIMATOLOGICAL OBSERVATIONSKWS FORM B-92 Excel97 version Bill Klein , Authormaxminobsrainnew snow snow on grnd 24 hr windevap water max water minremarksDateStation:County:State:Time: Std Time: Observer: Station no: NW Mi HortLeelanauMI8:00AM 20-6012-03Bill Klein/Myron Anderson TIME (L.S.T.)3SUPPLEMENTARY RECORD OF CLIMATOLOGICAL OBSERVATIONSSTATION MONTH/YEARCOUNTYSTANDARD TIME IN USEAIR TEMPERATURE F____ FEET ABOVE GROUNDSOILSTATE TEMPERATURESDry BulbWet Bulb RM or DP _____ Inches8 Inches 20 Inches 40 InchesMOISTURE4 Inches 8 Inches____ Height Above Grnd. DIR 16 PTMaxMinSTATION INDEX NUMBER0 SOD 4 Inches12 Inches MOVEMENT OR SPEEDPWS FORM B-83a (1/99) Excel97 VersionU.S. DEPARTMENT OF COMMERCE- NATIONAL OCEANIC AND ATMOSPHERIC ADMINISTRATION- NATIONAL WEATHER SERVICE-  Soil Tempsbare 4 in maxbare 4 in minsod 4 in maxsod 4 in min12 in at obsAuthor: Bill Klein *NW Michigan Horticultural Research StationMichigan State UniversityTraverse City, MI 49684(Acknowledgements: This spreadsheet may be modified for the input of additional measurements or observations. Some general and some specific Excel knowledge is helpful if you plan to make any changes or modifications to this workbook. Please credit the original author if modifications are made.EMonth:Year:FEB0BARE 4 InchesgInstructions and General Information: This Exel spreadsheet is designed to be used in Excel97. It was written to aid in the recording of monthly weather records from a NWS Cooperative Observation Site. The two Weather Service forms that have been recreated in this workbook are Form B-92 (Record of Evaporation and Climatological Observations) and Form B-83a (Supplementary Record of Climatological Observations). I suggest that the original file continue to be saved as a template with new copies being made and named each month (enter your general information into the template and then you will only need to change the date when you make a new copy at the beginning of the month). Each sheet (B-92 and B-83a) is sized to print on 8.5 x 11 paper. The sheets are protected to keep the formatting and formulas intact. The daily data entry sheet should be the only sheet needed until you selct the individual forms (sheets) at the end of the month for printing. When entering daily data, use the tab key to move horizontally across the row. When the daily data is entered it is automatically tranfered to the forms. %#`jr0" k}t"P#3#|3 %33&2&I'%'y:5(,(s4)6*+ -p V0bJdb,b0JdbbbJdJdН0ws_b-92.xls:/y3G6}/y|3GY/y?|3Gеb>/yk}/y3G3GI0T0bt00-m0 bzm00b 000bbb0b0bt,0b0 bPercent0]-tb0\pb0f|T0"T0@0"T0# ?b $0 4@0\bFиb{AAN\bbI_\bF<b@0b֜z00@b0d{0PdT0Pb0db0b}0XST0bbbbz0b0bbb0 bb0U0b b,b0t@bb0$"|tAvg. I 8s<  dMbP?_*+%,MHP LaserJet 4 Plus@w XX@MSUDOHP LaserJet 4 Plus<d "dXX??cU8@ lyK yK 8mailto:kleinw@pilot.msu.edu I %J?J^b  dMbP?_*+%,MHP LaserJet 4 Plus@w XX@MSUDHP LaserJet 4 Plus<d "MXX??cU} } } } } } ]} } } } } .} } %T0@ b@ b Dm с ,,,b,b , ,p ,b , ,,,,F,F,b,0,,F,b,,b,Fb,,,,,bO,b 6 "=# 7 $># 8 &? o q p~ H@ 9 $@# : %n# < +A#  *;  ,B '  a  5 * + , - . / 0 1  2  3  4  -b  c d e f~ !? .g .g .g /g 0g .g .g /g  .g  .g  5g  1g  2g 2g 2g 2g~ !@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !@ .g .g .g /g 0g .g .g /g .g .g 5g 3g 4g 4g 4g 4g~ !@ .g .g .g /g 0g .g .g /g .g .g 5g 3g 4g 4g 4g 4g~ !@ .g .g .g /g 0g .g .g /g .g .g 5g 3g 4g 4g 4g 4g~ ! @ .g .g .g /g 0g .g .g /g .g .g 5g 3g 4g 4g 4g 4g~ !"@ .g .g .g /g 0g .g .g /g .g .g 5g 3g 4g 4g 4g 4g~ !$@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !&@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !(@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !*@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !,@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !.@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !0@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !1@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !2@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !3@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !4@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !5@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !6@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !7@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !8@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !9@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !:@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4g~ !;@ .g .g .g /g 0g .g .g /g  .g  .g  5g  3g  4g 4g 4g 4gDl 8 ,T0!,b",b#,m$,с ~ !<@ .g .g .g /g 0g .g .g /g .g .g 5g 3g 4g 4g 4g 4g~ !!=@ !.g !.g !.g !/g !0g !.g !.g !/g ! .g ! .g ! 5g ! 3g ! 4g !4g !4g !4g~ "!>@ ".g ".g ".g "/g "0g ".g ".g "/g " .g " .g " 5g " 3g " 4g "4g "4g "4g~ #!?@ #.g #.g #.g #/g #0g #.g #.g #/g # .g # .g # 5g # 3g # 4g #4g #4g #4g$))))))))))( <P4  ( @ ~  <XR XPP?   M+]4@XR4 Aيz`0g (<)Insert month in the follwing format: MMM< ( ~~  <R XPP? RBy]4@R5 Bيz`0g ;<<Insert the county in which the weather station is located. < : ;@A ~~  < S XPP?  k]4@ S,6 Cيz`0g U<VInsert the 2 letter abbreviation for the state where the weather station is located. < T U@A ~~  <S XPP? ]4@S6 Dيz`0g D<EInsert the name of the weather station which you are reporting for. <C C D@A ~~  <S XPP? ;]4@S|7 Eيz`0g 4<5Insert the time of observation followed by AM or PM.< 4@A xx  6LTXPP? R;B]4@LT$8 Fيz`0gX L<MInsert time zone i.e. E (eastern standard time), DE (eastern daylight time) <` K L xx  6TXPP? .; ]4@T8 Gيz`0gX [<\Insert NWS station identifier followed by climate zone in the following format xx-xxxx-xx < Z [in~~  <U XPP?  \; ]4@Ut9 Hيz`0g <Insert observers name. <u  .~~   <xU XPP? I_]4 @xU: Iيz`0g !<"Enter daily maximum temperature. <  !@V~~   <U XPP? ._X]4 @U: Jيz`0g !<"Enter daily minimum temperature. <  !i~~   <@V XPP? _L]4 @@Vl; Kيz`0g )<*Enter temperature from observation time. < ( )xx   6VXPP? _&]4 @V< Lيz`0gX X<YEnter 24 hr rainfall or water equivilent from snow, etc (inches, tenths and hundreths). < W X~~   <W XPP? _ U]4 @W< Mيz`0g -<.Enter 24 hour snowfall in inches and tenths. < , -~~  <lW XPP? U_ ]4@lWd= Nيz`0g ?<@Enter amount of snow on ground at observation in whole inches. <7 > ?~~  <W XPP? ._ ]4@W > Oيz`0g <Enter 24 hour wind total. <|  ~~  <4X XPP?  _ ]4@4X> Pيz`0g 9<:Enter 24 hour evaporation amount (tenths and hundreths). <& 8 9"~~  <X XPP?  )_ ]4@X\? Qيz`0g <<=Enter 24 hr maximum water temperature from evaporation pan. <, ; <~~  <X XPP?  \_ B]4@X Rيz`0g :<;Enter 24 hr minimum water temperature from evaporation pan< +P : ~~  <`Y XPP?  )_]4@`Y Sيz`0g f<gEnter any comments about the weather at observation time or changes to equipment or observation time. < e fn~~  <Y XPP? ]4@Y@ Tيz`0g C<DEnter 24 hr soil temperature maximums and minimums as appropriate. <` B Cn~~  <(Z XPP?  B]4@(Z@ `w'-U )<*Enter year in the following format: yyyy < ( ) Bill Klein Bill Klein Bill Klein  Bill Klein  Bill Klein Bill Klein Bill Klein Bill Klein  Bill Klein  Bill Klein Bill Klein Bill Klein Bill Klein Bill Klein Bill Klein Bill Klein Bill Klein Bill Klein  Bill Klein  Bill Klein  Bill Klein> @PA    I 'WN  dMbP?_*+%,&?'?(?)?MHP LaserJet 4 Plus@w XX@MSUDOHP LaserJet 4 Plus<d "UXX??cU} } } } } } } } } } } ]} } t} } } .} } t} } 'T0@ b@Pb,b@lсC ,,,b,b ,: , ,b ,b ,,b,,,,b,0,,b,,,b,,b,b,,,b, 7 88%Z NW Mi Hort8888 798Z Leelanau 9: 7 ;8ZMI 7 <88"Z @ @Z BP FEB 2002 =9 Z 8:00AM 7 <;(9ZE (           ! "              ?       $  @ >  > > > > A  B B @ A~ D?6,9& ZE09#ZE49ZEEEEFGHHH  I389#ZJ<9# ZF@9Z6FD9#Z GHKH9#ZLL9#Z EP9Z MT9#Z ~ N@OX9&ZP\9ZP`9#ZPPPPQRSSS  Td9 ZUh9ZQl9ZOQp9Z RSVt9ZWx9Z P|9Z X9Z ~ N@O9ZP9ZP9ZPPPPQRSSS  T9 ZU9ZQ9ZOQ9Z RSV9ZW9Z P9Z X9Z ~ N@O9ZP9ZP9ZPPPPQRSSS  T9 ZU9ZQ9ZOQ9Z RSV9ZW9Z P9Z X9Z ~ N@ O9Z  P9Z  P9Z  PPPPQRSSS  T9 Z  U9Z  Q9 Z  O Q9Z  RS V9Z  W9Z  P: Z  X:Z ~ N@ O: Z  P : Z  P: Z  PPPPQRSSS  T: Z  U: Z  Q: Z  O Q : Z  RS V$: Z  W(: Z  P,: Z  X0: Z ~ N@ O4: Z  P8: Z  P<: Z  PPPPQRSSS  T@: Z  UD: Z  QH: Z  O QL: Z  RS VP: Z  WT: Z  PX: Z  X\: Z ~ N @ O`: Z  Pd: Z  Ph: Z  PPPPQRSSS  Tl: Z  Up: Z  Qt: Z  O Qx: Z  RS V|: Z  W: Z  P: Z  X: Z ~ N"@ O: Z  P: Z  P: Z  PPPPQRSSS  T: Z  U: Z  Q: Z  O Q: Z  RS V: Z  W: Z  P: Z  X: Z ~ N$@O: ZP: ZP: ZPPPPQRSSS  T: ZU: ZQ:ZOQ: Z RSV: ZW: Z P:Z X: Z ~ N&@O:ZP:ZP:ZPPPPQRSSS  Tp: ZU:ZQ:ZOQ:Z RSV;ZW;Z P;Z X ;Z ~ N(@O;ZP;ZP;ZPPPPQRSSS  T; ZU ;ZQ$;ZOQ(;Z RSV,;ZW0;Z P4;Z X8;Z ~ N*@O<;ZP@;ZPD;ZPPPPQRSSS  TH; ZUL;ZQP;ZOQT;Z RSVX;ZW\;Z P`;Z Xd;Z ~ N,@Oh;ZPl;ZPp;ZPPPPQRSSS  Tt; ZUx;ZQ|;ZOQ;Z RSV;ZW;Z P;Z X;Z ~ N.@O;ZP;ZP;ZPPPPQRSSS  T; ZU;ZQ;ZOQ;Z RSV;ZW;Z P;Z X;Z ~ N0@O;ZP;ZP;ZPPPPQRSSS  T; ZU;ZQ;ZOQ;Z RSV;ZW;Z P;Z X;Z ~ N1@O;ZP;ZP;ZPPPPQRSSS  T; ZU;ZQ<ZOQ<Z RSV<ZW <Z P<Z X<Z ~ N2@O<ZP<ZP <ZPPPPQRSSS  T$< ZU(<ZQ,<ZOQ0<Z RSV4<ZW8<Z P<<Z X@<Z ~ N3@OD<ZPH<ZPL<ZPPPPQRSSS  TP< ZUT<ZQX<ZOQ\<Z RSV`<ZWd<Z Ph<Z Xl<Z ~ N4@Op<ZPt<ZPx<ZPPPPQRSSS  T|< ZU<ZQ<ZOQ<Z RSV<ZW<Z P<Z X<Z ~ N5@O<ZP<ZP<ZPPPPQRSSS  T< ZU<ZQ<ZOQ<Z RSV<ZW<Z P<Z X<Z ~ N6@O<ZP<ZP<ZPPPPQRSSS  T< ZU<ZQ<ZOQ<Z RSV<ZW<Z P<Z X<Z ~ N7@O<ZP<ZP<ZPPPPQRSSS  T= ZU=ZQ=ZOQ =Z RSV=ZW=Z P=Z X=Z ~ N8@O =ZP$=ZP(=ZPPPPQRSSS  T,= ZU0=ZQ4=ZOQ8=Z RSV<=ZW@=Z PD=Z XH=Z ~ N9@OL=ZPP=ZPT=ZPPPPQRSSS  TX= ZU\=ZQ`=ZOQd=Z RSVh=ZWl=Z Pp=Z Xt=Z ~ N:@Ox=ZP|=ZP=ZPPPPQRSSS  T= ZU=ZQ=ZOQ=Z RSV=ZW=Z P=Z X=Z ~ N;@O=ZP=ZP=ZPPPPQRSSS  T= ZU=ZQ=ZOQ=Z RSV=ZW=Z P=Z X=Z D4lP ,T0!,b",b#,b$,сC%8 & @ ~ N<@ O=Z  P=Z  P=Z  PPPPQRSSS  T= Z  U=Z  Q= Z  O Q=Z  RS V=Z  W=Z  P= Z  X=Z ~ !N=@!O= Z!!P> Z!!P> Z!!PPPPQRSSS ! T> Z!!U > Z!!Q>!Z!!O!Q> Z! !RS!V> Z!!W> Z! !P >!Z! !X$> Z! ~ "N>@"O(>!Z""P,>!Z""P0>!Z""PPPPQRSSS " T4>! Z""U8>!Z""Q<>"Z""O"Q@>!Z" "RS"YD>!Z""ZH>!Z" "[L>"Z" "\P>!Z" ~ #N?@#OT>"Z##PX>"Z##P\>"Z##PPPPQRSSS # ]`>" Z##^d>"Z##_h>#Z##O#`l>"Z# #RS#Vp>"Z##Wt>"Z# #Wx>#Z# #X|>"Z# $N#$% %##$% %#$aaaaabcaaa #$ T$ %# #$U$ %#$bcQcaVWPd %e)%WPD$%#B)%$D$%#B%fffffghfi % j%#% k$ %# B#%l% %#B %mno %&%YZ[p &) &q &'& & #& & r>#Z Bill Klein/Myron Anderson&rrrrrr &$ &&s>Z 20-6012-031 xPH 0(  >@!2%%&&&&       &&&&  I (pA  dMbP?_*+%,&?'?(?)?MHP LaserJet 4 Plus@w XX@MSUDOHP LaserJet 4 Plus<d "RXX??cU} } } (T0@0hb@h@b@с@@@,b,b ,b ,b ,b ,b ,,b,,,,b,0,,b,,,b,{,,z0,,,b, _ t D$ ` E>Z NW Mi Hort  F 5>&Z @ @Z BP FEB 2002uuuuuuuuuv G>Z Leelanau L ?ZMI   H? ZE   C I K"     J J J M  T ^  wX    N O N O N O r  \  Q xR xS x] xP xU xV xR xS xP >W >W >W >W      zY  {Z  zY  {Z( ||yyyyyyyyy}}}}~~ ??Z 8:00AMSSSSSSS(?%Z  S,?Z  S0? Z S4? Z SSSSS8? ZSSSSSSSSSSS~ @@$LC#Z 8:00AM$SSSSSS$S\C#Z" $ S`C# Z" $ SdC# Z"$ ShC# Z"$ SSSS$SlC#Z"$SSSSSSSSSSS~ %?@%pC$Z 8:00AM%SSSSSS%SC$Z# % SC$ Z# % SC$ Z#% SC$ Z#% SSSS%SC$Z#%SSSSSSSSSSS &# &&C%Z Bill Klein/Myron Anderson& &[&&C&Z 20-6012-03&++++++>@<d!2*%&&&&         Oh+'0 PX| Cooperative Observer Formsr B-92, B-83a Bill Klein Bill KleinMicrosoft Excel@9*@\'= ՜.+,D՜.+,D PXd lt| MSU1  Information-InstructionsDaily Data EntryB-92B-83a  Worksheets 8@ _PID_HLINKSAp-Smailto:kleinw@pilot.msu.edu  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz|}~Root Entry FWorkbookSummaryInformation({DocumentSummaryInformation8