ࡱ>   Root Entry Fd#ӗWorkbook-u_VBA_PROJECT_CUR"+*SoɗpɗVBA Soɗpɗ  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~ \pemw6 Ba= ThisWorkbook=hL,8X@"1Courier1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##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 00000000000% 0.0% 00.0                + ) , *  1 1 1  1   1  1        1  1<"@ 1 1<@ 1<  1 <@  1 <@  1 <  1<  1 <  1 <  <  < `@Sheet1  ;8 p812-10 High blood pressure control (age adjusted, aged 812-11 Taking action to help control blood pressure (age812-12 Blood pressure monitoring - Persons who know 812-13 Mean total blood cholesterol levels in mg/dL (age812-14 High blood cholesterol levels (age adjusted, aged812-15 Blood cholesterol screening - Adults screened 812-16 LDL-cholesterol level in CHD patients 912-1 Coronary heart disease (CHD) deaths (age adjusted, per 100,000 standard population)1999a203NABSL195187180172160---b162 Race and ethnicity/ American Indian or Alaska Nativea148133118120112( Asian or Pacific Islandera1241161091059990 AsianaDNCDNA; Native Hawaiian or Other Pacific Islander( Black or African Americana248242235227220204 Whitea200193184177170157! Hispanic or Latinoa169158147139127% Not Hispanic or Latinoa204197188181174161@ Black or African American, not Hispanic/Latinoa250244237230223207/ White, not Hispanic or Latinoa201194185179171159 Gender Femalea161155148142136125 Malea2602509 Education level (persons aged 25 to 64 years)$ Less than high schoola,19719519121043101# High school graduatea,180179176178276373$ At least some collegea,136135133232330 Disability status( Persons with disabilitiesDNC+ Persons without disabilities112-2 Knowledge of symptoms of heart attack and< importance of calling 911 (age adjusted, aged 20 years and over)2001c46%50%4 American Indian or Alaska Native onlyc42%- Asian or Pacific Islander onlycDNC Asian onlyc30%@ Native Hawaiian or Other Pacific Islander onlycDSU- Black or African American onlyc41% White onlyc48% 2 or more racesc39%9 American Indian or Alaska Native; Whitec43%2 Black or African American; Whitec32%4 White only, not Hispanic or Latinoc49%< Education level (persons aged 25 years and over)c37%c50%c47%812-3a Artery-opening therapy within an hour of symptom onset [New]2000-044.0%6.0% Race and ethnicity1 American Indian or Alaska Native5.0%* Asian or Pacific Islander Asian= Native Hawaiian or Other Pacific Islander* Black or African American2.9% White# Hispanic or Latino' Not Hispanic or LatinoB Black or African American, not Hispanic/Latino1 White, not Hispanic or Latino Gender Female Male> Education level (persons aged 25 years and over)& Less than high school% High school graduate& At least some college Disability status* Persons with disabilities- Persons without disabilities912-3b Percutaneous intervention (PCI) within 90 minutes$ of symptom onset [New]0.64%0.67%0.34%0.59%0.49%0.66%0.61%812-4 Persons trained in cardiopulmonary resuscitation< (CPR) within 1 year (age adjusted, aged 20 years and over)c8%12%c9%c6%c10%c11%c5%c7%c3%/12-5 Out-of-hospital cardiac arrest - timely$ electrical shock therapy112-6a Heart failure hospitalizations (per 1,000. population, aged 65 to 74 years)199713.213.412.313.311.911.712.511.211.16.56 American Indian or Alaska Native only4,5DSU/ Asian or Pacific Islander only Asian onlyB Native Hawaiian or Other Pacific Islander only/ Black or African American only4,520.04,522.54,519.94,517.34,519.24,524.04,518.54,515.6 White only4,59.94,59.64,59.14,59.34,58.84,58.34,58.74,57.84,58.2 2 or more races; American Indian or Alaska Native; White4 Black or African American; White4DSU6 White only, not Hispanic or Latino11.513.011.69.810.115.314.513.712.912.413.5; Education level (persons aged 65 to 74 years)112-6b Heart failure hospitalizations (per 1,000. population, aged 75 to 84 years)26.727.727.126.426.123.024.326.323.74,521.44,525.24,522.34,531.34,528.14,525.54,521.74,525.04,532.44,521.54,522.04,519.14,520.14,517.74,519.74,518.625.025.424.425.321.322.622.824.029.231.031.126.627.425.526.931.623.3; Education level (persons aged 75 to 84 years)112-6c Heart failure hospitalizations (per 1,0001 population, aged 85 years and over)52.749.950.447.949.545.746.144.444.526.54,547.04,542.74,541.84,540.74,538.54,546.44,536.64,535.24,541.14,540.34,540.24,535.54,539.74,535.04,536.24,534.04,535.450.248.851.549.646.444.346.243.358.847.843.956.849.044.747.3> Education level (persons aged 85 years and over)812-7 Stroke deaths (age adjusted per 100,000 standard population)a626158565350b50a4845413835a535148a828279767470a605954a47464057a8383807771555249a6362a,122122121223324a,116117116216316a,17172736512-8 Knowledge of early warning symptoms of strokec78%83%c77%c61%c70%c80%c74%c59%c79%c82%c76%c65%c83%c75%812-9 High blood pressure (age adjusted, aged 20 years1988-94a26%631%b14%7DSU6DSU6DNC7DNA6DNADSU" Mexican American628%a,738%643%a,724%629%a24%a27%630% Family income level Poora31%635% Near poor634%! Middle/high incomea30%637% Select populations$ Persons with diabetes43%652%' Persons without diabetes24% 18 years and over)a25%636%<b68%a15%627%a,723%a,726%a35%639%a18%633%632%638%? Persons with disabilities (persons aged 20 years and over)a34%644%< Persons without disabilities (persons aged 20 years and over)a22%46%654%23%- adjusted, aged 18 years and over)1998a84%93%b98%8DSUa,890%a,887%97%a,888%95%a,883%92%78%a78%a85%a,884%a86%94%a83%a81%89%a82%90% Geographic location4 Urban (metropolitan statistical area)7 Rural (nonmetropolitan statistical area)7 Persons with disabilities (replaces with$ activity limitations)a,987%= Persons without disabilities (replaces withouta,985%98%84%< whether their blood pressure is high or low (age889%8DNA886%87%a,8DSU892%890%88%91%891%a93%a,992%a,990%- adjusted, aged 20 years and over)20662021992056201720461987206620462031991-94208 20 years and over)21%617%17%18%616%719%615%721%22%a19% Education level620%a23%618%a20%19%; within preceding 5 years (age adjusted, aged 1867%73%80%858%68%868%869%75%867%76%59%74%a,868%70%64%71%58%66%69%63%a,969%a,966%7 DATA ISSUESa Baseline has been revised.b Target has been revised.8c New baseline. Objective was previously developmental.<1 Total of 46 reporting States and the District of Columbia.z2 Total of 43 reporting States and the District of Columbia. Data are not directly comparable to those of previous years.z3 Total of 36 reporting States and the District of Columbia. Data are not directly comparable to those of previous years.34 Data by race and ethnicity may be under reported.V5 Only one race category was recorded; recording more than one race was not an option.6 2001-2004 data.p7 Respondents were asked to select one race category;selection of more than one race category was not an option.k8 Respondents were asked to select one or more races and identify one race as best representing their race.>9 Due to survey design error, data are for July-December only. Objective/number DATA SOURCEP12-1 National Vital Statistics System - Mortality (NVSS-M), ob, NCHS.B12-2 National Health Interview Survey (NHIS), ob, NCHS.\12-3a National Registry of Myocardial Infarction (NRMI-4), National Acute Myocardial+ Infarction Project, CMS.\12-3b National Registry of Myocardial Infarction (NRMI-4), National Acute MyocardialB12-4 National Health Interview Survey (NHIS), ob, NCHS.G12-5 Potential:Medical Expenditure Panel Survey (MEPS), AHRQ.C12-6a National Hospital Discharge Survey (NHDS), ob, NCHS.C12-6b National Hospital Discharge Survey (NHDS), ob, NCHS.C12-6c National Hospital Discharge Survey (NHDS), ob, NCHS.P12-7 National Vital Statistics System - Mortality (NVSS-M), ob, NCHS.B12-8 National Health Interview Survey (NHIS), ob, NCHS.T12-9 National Health and Nutrition Examination Survey (NHANES), ob, NCHS.S12-10 National Health and Nutrition Examination Survey (NHANES), ob, NCHS.A12-11 National Health Interview Survey (NHIS), ob, NCHS.A12-12 National Health Interview Survey (NHIS), ob, NCHS.S12-13 National Health and Nutrition Examination Survey (NHANES), ob, NCHS.S12-14 National Health and Nutrition Examination Survey (NHANES), ob, NCHS.A12-15 National Health Interview Survey (NHIS), ob, NCHS.]12-16 Potential:National Health and Nutrition Examination Survey (NHANES), ob, NCHS.H Black or African American only, not Hispanic or LatinoJ Black or African American only, not Hispanic or Latino--- = Data are not available.BBSL = Baseline data available for this year. See Baseline column."DNA = Data have not been analyzed.5DNC = Data for specific population are not collected.bDSU = Data do not meet the criteria for statistical reliability, data quality, or confidentiality.NA = Not applicable. [NOTE:Data may include revisions, and may differ from those shown previously. Any displayed?age-adjusted data are adjusted to the 2000 standard population.  8 BaselineTarget8 Objective Year 2010 )Focus area:12 - Heart Disease and Stroke rD  z B [ # P  m r:-]%  y L O *Fn6t<o7nl4?  l x!@!B" "#V#$H$~$F$|$0%%Z&&J''X((b))}*n/++@+,-e ..;.J//k200/0h2 4 V79^;=4cc  T7]?tϣ_'2GJbyg/  dMbP?_*+%2&HFi&?'?)?M\\FNCH-HVL-APP1.nchs.cdc.gov\PS o_LetterPRIV0''''P\KhCl=/PIUPH dLetter [none] [none]Arial4Pd?EMW6<Automatic>_1200dpidType new Quick Set name here j.k k m m -EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"_??U} 2}   C@  @ @  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ +o,,,,,,,,,,, (i )j )g )g )g )g )g )g )g  )g  )g  )k *l *m -j6/8@/<@/@@.D@.H@.L@.P@.T@  *n i g g g g g g g g  g  g  h                                                                     !  "     #  $   % % % % %   &  $   % % % % %   '  (   ) * + , -   .  /   0 1 2 3 4   5  6    7 8 9 :   ;  <   = > ? @  A     B  C   D E F G  H     I  J   K L M N  O     P               Q  R   S T U V  W     X  Y   Z E F ,  -     [               \  ]   ^ _ _ `  a     b  c   d e f g  h     i  j   k l l m  n     o               p  $   q q q q  q     r  $   q q q q  q     i               s               t               u v w            x               Dl.r @! @" @# @$ @% @& @' @( @) @* @+ @, @- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @ y v z         x !{ !v !| ! ! ! ! ! ! !  !  ! x "} "v "~ " " " " " " "  "  " x # #v # # # # # # # #  #  # x $ $v $ $ $ $ $ $ $ $  $  $ x % %v % % % % % % % %  %  % x & &v & & & & & & & &  &  & x ' 'v ' ' ' ' ' ' ' '  '  ' x ( (v ( ( ( ( ( ( ( (  (  ( x )5 )v ) ) ) ) ) ) ) )  )  ) x *; *v * * * * * * * *  *  * x +\ +v + + + + + + + +  +  + x , ,v , , , , , , , ,  ,  , x -P - - - - - - - - -  -  -  .Q .v . . . . . . . .  .  . x /X /v / / / / / / / /  /  / x 0 0 0 0 0 0 0 0 0 0  0  0  1\ 1v 1 1 1 1 1 1 1 1  1  1 x 2b 2v 2w 2 2 2 2 2 2 2  2  2 x 3i 3v 3 3 3 3 3 3 3 3  3  3 x 4o 4 4 4 4 4 4 4 4 4  4  4  5p 5v 5 5 5 5 5 5 5 5  5  5 x 6r 6v 6w 6 6 6 6 6 6 6  6  6 x 7i 7 7 7 7 7 7 7 7 7  7  7  8 8 8 8 8 8 8 8 8 8  8  8  9 9 9 9 9 9 9 9 9 9  9  9  : : : : : : : : : :  :  :  ; ; ; ; ; ; ; ; ; ;  ;  ;  < < < < < < < < < <  <  <  = = =q = = = = = = =  =  =  > > >q > > > > > > >  >  >  ? ? ? ? ? ? ? ? ? ?  ?  ? Dl@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @ @ @ @ @ @ @ @ @ @ @  @  @  A A A A A A A A A A  A  A  B B B% B B B B B B B  B  B  C C C% C C C C C C C  C  C  D D D% D D D D D D D  D  D  E E E E E E E E E E  E  E  F F F% F F F F F F F  F  F  G G G% G G G G G G G  G  G  H H H H H H H H H H  H  H  I I Iq I I I I I I I  I  I  J J Jq J J J J J J J  J  J  K K Kq K K K K K K K  K  K  L L L L L L L L L L  L  L  M M Mq M M M M M M M  M  M  N N Nq N N N N N N N  N  N  Oi O O O O O O O O O  O  O  P P P P P P P P P P  P  P  Q Q Q Q Q Q Q Q Q Q  Q  Q R R R R R R R R R R  R  R  S S S S S S S S S S  S  S T T T T T T T T T T  T  T U U Uq U U U U U U U  U  U V V Vq V V V V V V V  V  V W W W W W W W W W W  W  W X X X X X X X X X X  X  X Y Y Y Y Y Y Y Y Y Y  Y  Y Z Z Z% Z Z Z Z Z Z Z  Z  Z [ [ [% [ [ [ [ [ [ [  [  [ \ \ \% \ \ \ \ \ \ \  \  \ ] ] ] ] ] ] ] ] ] ]  ]  ]  ^ ^ ^% ^ ^ ^ ^ ^ ^ ^  ^  ^ _ _ _% _ _ _ _ _ _ _  _  _ Dl` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @ ` ` ` ` ` ` ` ` ` `  `  `  a a aq a a a a a a a  a  a b b bq b b b b b b b  b  b c c cq c c c c c c c  c  c d d d d d d d d d d  d  d  e e eq e e e e e e e  e  e f f fq f f f f f f f  f  f gi g g g g g g g g g  g  g  h h h h h h h h h h  h  h  i i i i i i i i i i  i  i  j jv j j j j j j j j  j  j  k k k k k k k k k k  k  k  ly lv l l l l l l l l  l  l  m{ mv m| m m m m m m m  m  m  n} nv n n n n n n n n  n  n  o ov o o o o o o o o  o  o  p pv p p p p p p p p  p  p  q qv q q q q q q q q  q  q  r rv r r r r r r r r  r  r  s sv s s s s s s s s  s  s  t tv t t t t t t t t  t  t  u5 uv u u u u u u u u  u  u  v; vv v v v v v v v v  v  v  w\ wv w w w w w w w w  w  w  x xv x x x x x x x x  x  x  yP y y y y y y y y y  y  y  zQ zv z z z z z z z z  z  z  {X {v { { { { { { { {  {  {  | | | | | | | | | |  |  |  }\ }v } } } } } } } }  }  }  ~b ~v ~ ~ ~ ~ ~ ~ ~ ~  ~  ~  i v             Dl @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ o            p v           r v            i                         q q          i                          ! ! ! ! ! ! ! ! ! "                        "      q q q q q q "   q q q       "   q q q       "            "            "   q q q       "   q q q       "   q q q       "            "            " ]           "            "               ! ! ! ! ! ! ! " ! "   ! ! ! ! ! ! ! ! ! "               q q q q q q q q q "   q q q q q q q q q "   q q q q q q q q q "               q q q q q q q q q "Dl @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @   q q q q q q q q q " i                          ! ! ! ! ! ! ! ! ! !                        !      q q q q q q !   q q q       !   q q q       !                 !            !   q q q       !   q q q       !   q q q       !            !            ! ]           !            !               ! ! ! ! ! ! ! ! ! !   ! ! ! !  !! !" !# !$ !% ! &              q q q q q q q q q !   q q q q q q q q q !   q q q q q q q q q !               q q q q q q q q q !   q q q q q q q q q ! i            '            (  !) !* !+ !, !- !. !/ !0 !1 !2            Dl @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @            !2      q q q q q q !2   q q q       !2   q q q       !2   3 4 5 6 7 8 9 : ; !2   5 < = > ? @ A B C !2   q q q       !2   q q q       !2   q q q       !2            !2            !2 ]           !2            !2               !D !E !F !G !H !I !J !I !K !2   !L !) !M !N !O !P !. !Q !R !2 S              q q q q q q q q q !2   q q q q q q q q q !2   q q q q q q q q q !2               q q q q q q q q q !2   q q q q q q q q q !2 i            T            U  V   W X Y Z [  \               ]   ^ _ ` a a  \   b   Z c d ^ _  \ #  $   % % % % %  \ &  $   % % % % %  \ '  e   f g h i j  \Dl @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ .  k   l Y m c d  \ 5  n   o ^ _ p `  \ ;  V   W X q m [  \ B  r   s t u h v  \ I  k   l Y w x d  \ P            Q  k   l Y w x y  \ X  z   { l q m [  \ [            \  |   } } ~     b            i            o            p  $   q q q q q  \ r  $   q q q q q  \ i             v                       y v           { v |          } v            v            v            v            v            v            v           5 v           ; v           \ v            v           P           Dl @ @ @ @ @ @ @ @ @  @  @  @  @  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ Q v              X v                             \ v              b v              i v              o               p v              r v              i                                                            y               {               }  q               q                                             q               q               q             5                              ;  %             \                              P               Q               X                                            Dl  @! @" @# @$ @% @& @' @( @) @* @+ @, @- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @                ! ! ! ! ! ! ! ! ! !  !  !  "o " " " " " " " " "  "  "  #p # # # # # # # # #  #  #  $r $ $ $ $ $ $ $ $ $  $  $  % % % % % % % % % %  %  %  & & & & & & & & & &  &  &  ' ' ' ' ' ' ' ' ' '  '  '  (i ( ( ( ( ( ( ( ( (  (  (  )# ) ) ) ) ) ) ) ) )  )  )  * * * * * * * * * *  *  *  + + + + + + + + + +  +  +  ,y , , , , , , , , ,  ,  ,  -{ - - - - - - - - -  -  -  .} . .q . . . . . . .  .  .  / / /q / / / / / / /  /  /  0 0 0 0 0 0 0 0 0 0  0  0  1 1 1 1 1 1 1 1 1 1  1  1  2 2 2q 2 2 2 2 2 2 2  2  2  3 3 3q 3 3 3 3 3 3 3  3  3  4 4 4q 4 4 4 4 4 4 4  4  4  55 5 5 5 5 5 5 5 5 5  5  5  6 6 6 6 6 6 6 6 6 6  6  6  7; 7 7% 7 7 7 7 7 7 7  7  7  8\ 8 8 8 8 8 8 8 8 8  8  8  9 9 9 9 9 9 9 9 9 9  9  9  :P : : : : : : : : :  :  :  ;Q ; ; ; ; ; ; ; ; ;  ;  ;  <X < < < < < < < < <  <  <  = = = = = = = = = =  =  =  > > > > > > > > > >  >  >  ? ? ? ? ? ? ? ? ? ?  ?  ? Dl@ @A @B @C @D @E @F @G @H @I @J @K @L @M @N @O @P @Q @R @S @T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @ @ @ @ @ @ @ @ @ @ @  @  @  Ao A A A A A A A A A  A  A  B B B B B B B B B B  B  B  C C C C C C C C C C  C  C  D D D D D D D D D D  D  D  E E E E E E E E E E  E  E  F F F F F F F F F F  F  F  G G G G G G G G G G  G  G  H H H H H H H H H H  H  H  Ii I I I I I I I I I  I  I  J# J J J J J J J J J  J  J  K K K K K K K K K K  K  K  L L L L L L L L L L  L  L  My M M M M M M M M M  M  M  N{ N N N N N N N Nq N  N  N  O} O O O O O O O O O  O  O  P P P P P P P P P P  P  P  Q Q Q Q Q Q Q Q Q Q  Q  Q  R R R R R R R R R R  R  R  S S Sq S S S S S S S  S  S  T T Tq T T T T T T T  T  T  U U Uq U U U U U U U  U  U  V5 V V V V V V V V V  V  V  W; W W W W W W W W W  W  W  X\ X X X X X X X X X  X  X  Y Y Y Y Y Y Y Y Y Y  Y  Y  ZP Z Z Z Z Z Z Z Z Z  Z  Z  [Q [ [ [ [ [ [ [ [ [  [  [  \X \ \ \ \ \ \ \ \ \  \  \  ] ] ] ] ] ] ] ] ] ]  ]  ]  ^ ^ ^ ^ ^ ^ ^ ^ ^ ^  ^  ^  _ _ _ _ _ _ _ _ _ _  _  _ Dl` @a @b @c @d @e @f @g @h @i @j @k @l @m @n @o @p @q @r @s @t @u @v @w @x @y @z @{ @| @} @~ @ @ ` ` ` ` ` ` ` ` ` `  `  `  a a a a a a a a a a  a  a  b b b b b b b b b b  b  b  c c c c c c c c c c  c  c  do d d d d d d d d d  d  d  e e e e e e e e e e  e  e  f f f f f f f f f f  f  f  g g g g g g g g g g  g  g  h h h h h h h h h h  h  h  i i i i i i i i i i  i  i  j j j j j j j j j j  j  j  k k k k k k k k k k  k  k  li l l l l l l l l l  l  l  m# m m m m m m m m m  m  m  n n n n n n n n n n  n  n  o o o o o o o o o o  o  o  p p p p p p p p p p  p  p  qy q q q q q q q q q  q  q  r{ r r r r r r r rq r  r  r  s} s s s s s s s s s  s  s  t t t t t t t t t t  t  t  u u u u u u u u u u  u  u  v v v v v v v v v v  v  v  w w wq w w w w w w w  w  w  x x xq x x x x x x x  x  x  y y yq y y y y y y y  y  y  z5 z z z z z z z z z  z  z  {; { { { { { { { { {  {  {  |\ | | | | | | | | |  |  |  } } } } } } } } } }  }  }  ~P ~ ~ ~ ~ ~ ~ ~ ~ ~  ~  ~  Q              Dl @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ X                              \               b               i               o                                                                           i               #                                             y               {               }  q               q                                             q               q               q             5                               ;  %             \                                 P               Q  H             X  -                            Dl @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @                   -                             o               p                r  -             i               #                                             y               {               }  q               q                                             q               q               q             5                              ;  %             \                              P               Q               X                              \               b               i                o              Dl @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ p               r  !             i               #               "               u  #      $      %                y  &      '      % {  (      q      % }  )      *      %               %   +      *      %   +      $      %   q      ,      %   q      *      %   q            % 5  -      '      % ;  '      .      % \  +      *      %   /      $      % P               Q  0      *      % X  1      2      %                \  3      4      % b  5      .      % i              %                  '      .      %   6      0      % o                             Dl @ @ @ @ @  @  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @  @ @  @ @   7      .      %                  8      $      % i               # q q             $9$$$$$$$$$$$ ^ _ ` a b c %: %; %< %= %> %? %@ %A %B %C %D %E d e f d &F&&&&&&&&&&& 'G''''''''''' H IDl...@@@@@@@@@ @ @ @ @ @@@@@@ J K L K M N O P Q R S T U V W X Y Z [*h><d   7 Sheet1 Module1{ThisWorkbook%Sheet1&IModule20  !"#$%&'()*+,-./123456789:<=>?mѷ(< <<<xp@pX@8o recorded 2/18/99 by Thomas C. Socey e%HGx"Attribute VB_Name = "Module1" mC #xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2<CmN #<;Í2bFEܺX F)aoLMYxME (SLSS<N0{00020820-0000-0000-C000-000000000046}0(%` % %`h8@HHxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2$+myxMExpGx"Attribute VB_Name = "Module2" OmRxMEModule3 ;{Module4IModule5 TModule6_(< <<<xp@px@8o recorded 2/19/99 by Thomas C. Socey"%HGx"Attribute VB_Name = "Module3" $+m<,xMExpGx"Attribute VB_Name = "Module4" $+m=xMExpGx"Attribute VB_Name = "Module5" $+mɭxMExpGx"Attribute VB_Name = "Module6" $+m!xMEModule7jModule8uModule9 !Module10}xpGx"Attribute VB_Name = "Module7" $+m xMExpGx"Attribute VB_Name = "Module8" Oh+'0HPhx Thomas C. Soceyemw6Microsoft Excel@;ɗ@j)|Z@oɗ՜.+,D՜.+,D PXl t|  NCHS/OAEHP Sheet1Sheet1!Print_Titl$+muIxMExpGx"Attribute VB_Name = "Module9" OmBxME(<< <<xp@pX@ 8o recorded 12/18/2001 by Thomas Socey4%HGx$Attribute VB_Name = "Module10" #wmwxMEP<<<<< <<Module11Module12Module13Module14<xp@p@ 8o recorded 12/18/2001 by Thomas Socey<%HG$Attribute VB_Name = "Module11" $+m8xMExpGx$Attribute VB_Name = "Module12" $+mxMExpGx$Attribute VB_Name = "Module13" $+mߕxMExpGx$Attribute VB_Name = "Module14" $+mFxMExpModule15Module16Module17Module18Gx$Attribute VB_Name = "Module15" $+mxMExpGx$Attribute VB_Name = "Module16" $+mY4xMExpGx$Attribute VB_Name = "Module17" $+mxMExpGx$Attribute VB_Name = "Module18" /mKxModule19^Module20KModule219EModule22G      !"#$%&'()*+,-./012345678:;<=>?@ABCDEFHIJKLMNOPQRSTUWXYZ[\]^_`bcdefghijklmnopqrtuvwxyz{|}~MEp `@Ib `G"  , H P`x   0@HPX`hpx   *  d$B@H &here start of superscripting footnotes'f fa j%l'h h$B@H j%l!p'n n'r5 n$'t tfn n r $'n 8!vEMArial9ARegular9x!@9zK9|9~999 9 9k j!'em  G'fjP $here end of superscripting footnotes:\po%Attribute VB_Name = "Module19" Sub Boldfncol(currcell) @ Range@s .Select 'here start of superscripting footnotes 4stop(it30 Do Until (="1 q p1>ActiveC.Offset0(0, 0dp1F)c*Val)-3ue WvlenLen(Uletter21MidO, "2If "fn" Then7S'3, B-* With oion.Fon qB .EAriA@ctiveC.Offset(0, 0dp1)cр*Val)- ue WvlenaLen(Ul@etter2MidO, 2If "fn" Then7S'h3, B-* @ With oion.Fon qB .ņArialStylBRegular Siz 8.5!Q2 .S@kethrough@I0FalsOY.S@ Trc bàOutlineD\ Shadow Under xlFJNon5@ColorIx AutomaticNLEnd Ifthiscos̮umLmaxL xEr1 Loop+C~e~ mxME(<<< <@x8++xp%HG$Attribute VB_Name = "Module21" #wmxMEP<<<<< <<<xp@p@8o recorded 4/22/2002 by Thomas Soceydu%HG$Attribute VB_Name = "Module22" $+mfModule23VModule24a]Module25"sEModule26)uxMExpGx$Attribute VB_Name = "Module23" /mo xME@47c2d5fa:" .8@HPX`h p$    0 @ ` p  0   (08 6@ x  $ @P `     82( `p   0 8@H h .      ( *0` hx2    (08 @ HXh x  < P`px   " ( 8 H P X ` h p x  "             ( 0 H  P ` Zx           0 @ X h p x              0 @ H P X ` h p   $       (  @ P :`        0 @0P (@HPX `*p   40h        >  `0p08@H`hpx *  (0 8 @4P  6  <0p  >  BX p x         ( 0@P ` p < 8HX`p   " 08@HPX`h"p0 8HZ` (@PX` p    (08@HPXp $   ( 8 :H          0 H ` p(    8 @ H P h p x   *     !!!! !(!0!8!@! H!4X!!!!!!! !" "0"8"@" H" P"0`"""""""# #(#0#8#P#X#`#h# p#*## ######$$$$ $ ($ 0$4@$x$ $ $6$$ % %< %`% x% %>%% % %B&H& `& h& p& x& & & && .&& & &&'  '('0'8'@'H'P'X' `' h'x'' ' '' '''''((((<0( p((((( (((((((( ( )")8)H)X)h)p)x))))))"))))**** *(*0*8*@*H*P*h* p**Z**++++ +(+0+8+ @+P+`+x++++ +++ ++++ ,, ,(,8, @,P,`,h,p,x,,,,, ,$,, --(- 8-H- `- p- $- - - - <-"(.P. X.h.p.x. . . . . . .0./ /@/`/h/p////////// /*/(0 80H0X0`0h0p0x00000 0 0400 1 1601h1 1 1<11 1 1>2H2 `2 h2Bx22 2 2 2 2 2 3 33303  H3X3`3h3p3 x3$3 3333 4  4 $84 `4 p4 4 444 4424 $5 @5 P5 h5 p5 5 5 (5 $5 @5 886 p6 x6 6 B6 (6 27 @7 H7 P7X7`7h7p7x777 7777 7 7 778 8  8 (80888P8 h8 x8 8 8 8 8 8 8 8 8 8888 9 9(90989H9X9p9D9$9 9 :: : (:8:"H:p:::::::::::":;;(;8;@;H;P;X;`;h;p;x;;;; ;; ; ; ; ;< <8<P<h< < << <<<<<==== = 2@= <x= = == = =>>  > (> 0>@> P>p>x>>>>> >>>>> ? ? ?0?@? H? P? *X? ?? ? ?? ? $? 0?@ 8@H@X@`@x@@@@@@@@@AA A 0A@AHAPAXA`AhAhpALA (B@HB&BB B 0B&C(C @C HCPCXC`ChCpCCC C C  CDC8D@DHD XDhDpDxDDDDDDDDDE(E0E8E@EHEPEXE`EhEpExEE E EEEEEEEE E E E F  F (F 0F 8F @F HF PF XF`FhF FFFFFFFF FFFFG( Fir found a new objective $'# looking for a measureS  ' SOURC  G'j$ 'B@ $' $' $' $'    $'$d'k 0 0numb 0G 'j 0  0 no measure$'  'd( 0     '  ' 'kk       j(p $k j!'A ' a find where objective title ends` ' a$ j%l!'b9. b$B@H 8 &9  &9$9(9*9,9.90q j!p'9@ $' $' '>96  j(p9'  %2'J'L Ja L 'L  L$'Nld N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q   j(P R j%!v Arial9 Regular9x#@9z 9|9~999 9 9qx T X j%!v'XArial9Regular9x#@9zia9|9~999 9 9q'Jk L G'Jj j% $'ia < D N - #9''''''''' a  '  $' -''d $$'$d` ..''d0 %%'d  0 'd  0 'kkkkkk  G'j stop5       8(: of k  hdashk not. sk gotsupersecondk celllen j!'  G'j stop4\  'A $$ $B@H- goto next line j!p' $' ' no $' ' '   '  $' $' Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household)G ^   j(p; add 5 to 12  j!p j(p' j!p $' j!p$' `'' j!p' STATE:''d STATE:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pkxkp j%l!' '  $!v(  $-----' j!'''k d 6 Not a new objective. These are objective title lines   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''k k       j%!vArial9Bold9x#@9z9|9~999 9 9q k d   j(p> add 7 to 15  j!p j(pdX     j(p@ add 9 to 18  j!p j(pd    j(pC add 11 to 21  j!p j(pdp    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pk k kx kp kh k` ' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q8  j(P R j%!vArial9Regular9x#@9z9|9~999 9 9q T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #''''''''' a  '  $' -'d $$'dx ..''dH %%'d   0 'd  0 'kkkkkk  G'j stop5       8(:k  hdashk notk gotsuperk celllen j!'  G'j stop4  'A $$ $B@H1 goto next line 8 &9  &9$9(9*9,9.90q0 j!p' $' ' $' '   '  $' $' Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household)   j(p? 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kkx       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(pA add 7 to 15  j!p j(pkPkH j%l!' '  $!v(  $-----' j!'''kd   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pdh     j(p@ add 9 to 18  j!p j(pd    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pkkkkkxkpkhk`% until stop3 - end of objective titled(' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q  j(P R j%!vArial9Regular9x#@9z9|9~999 9 9qX T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #''''''''' a  '  $' -'dh $$'d@ ..''d %%'d  0 'd  0 'kkkkkxkp  G'j stop5       8(:k  hdashk notk gotsuperk celllen j!'  G'j stop4  'A $$ $B@H j!p' $' j%l!p' $-----   $-----' j!'k''kx ' $' '   '   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''dP STATE:''k k       j%!vArial9Bold9x#@9z9|9~999 9 9qhk`dX   j(p= add 7 to 15  j!p j(pd     j(p@ add 9 to 18  j!p j(pdx    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pk k k k k k k k until stop2 until stop1=1 '' '' aA $$ $B@H j!p' $' $' j%l!p' $-----  8B@A $$ $B@H j!p' $' $' j%l!p'kH  'd  DATA ISSUES  DATA SOURCEA $$ $B@H  '  DATA SOURCE' 8!B@ Objective j(p  '  $ $$ 'A $$ $B@Hnumber j!p j(pA  $$ :  $B@Hd  DATA ISSUES', j!p j(p  $ $$ 'A $$ :  $B@Hkk 8 "9  &9$9(9*9,9.90qh 8 4 8%2(6 8 : 8%2(6 < 8%2 >96 B9@ 9q D 8%2 >96 B9@ 9q 8 F 8%2(6 8 H 8%2(6 8!vArial9 Bold Italic9x 9z9|9~999 9 9qd   '  'J'L Ja L 'L  L$'N N\  L $  L  L $ 'A $$ $B@H  j(p  j(P L 'R L'T 'V V R 'X R j%!vArial9Regular9x#@9z9|9~999 9 9q  T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jkx L G'JjXkPdH  $' $'Z ' $' $' $' $' $'    $'dH'k8'\normal'^ normal'`'b'd'f'h 0 0'^$ dash and second digit of first pair'\. space and dash and second digit of first pair 0 ' \ '\d 0 ^ '^'bkk 0 ^ '^  # no measure'  ' \ '\d`     ' '' \ '\kkd 0 \ '\ ^ '^'`kk       j(p j!p'd`'b'`kH' Z G ^ '^j - is not a continuation line j!p \$'d ^ 'fd? ^ ` 'fdp? ^ ` 'fd@? ^ ` 'fd? ^ ` 'fd> ^ 'fk>k>k>k>k>k> Zf Zi Zj Zl Zr ZtG f 'fj Zm ZA ZBG f f $'fj bG f 'fj b ` Z G f 'fj j!p \  \ $'h d f h j(pd0= -" is a continuation line 'd, 19 d j!p j(pk<k<k<k<k<k<  ' until stop1=1k continuesw = 1  'j G j 'jj l!n$ j $$ : $ $$ 9p9rq; l!n(t l!n9v9x9z9|9~9? %9? %9 %9 %9? %9? %999 999 9*9 9 99d9qx:A2:P4$B@H 8 &9  &9$9(9*9,9.90q: 8!vArial9 Bold Italic9x 9z9|9~999 9 9q9B6:B2000$B@H 8 "9  &9$9(9*9,9.90q89A1$!v( R1C1 B@o98ŵAttribute VB_Name = "Module26" Sub PI() ' First find the row which has"titles cvaluonP= 0 oncolmaxstop1haveyear obj;Do Until -1 ^ + Range("A" + Trim(Str(#))).Se0lect@VActiveCell.V_ "=ER If "Obj7." Txhen,]o=Row u2  ) Off@set(0,)C >GIY?~CH@Ɓ3J " nA.1/M"_!NElseb FYLColumzendad`dress#AKC E;IfL8oopC'  forC,!L dh"$ lettep"w3DspacD|$v+ 2mE@_r @Z1@!wherew@ ¦nqA!Ha=(81currc Є?ydK$ With io.Horiz`oalAlignmbeBtxlC! .Verticnt$ .WrapTexqyFaߍ@ .Oria^t 0<P .I x,6Nerc( K1QO1AMak + #7+ 5./  Vno/!~thiscolVolum_Qmax]f404o|nrBsd"A" + Trimr(r))Po n!C δl.Value $ cvx = RTrim(p)|beforeq|Lentzxaftervdiff(a- -zhold MidQx, 10 "2#6"If >'"Race and ethnicity") Or Mother's rGender!Worksite onl0f"Classeps at a"STATE:& 5)g-r (head of house) ThenzA3@Ke7 OAActiveCel!" + ' add 5 to 12A P sp]+ MNAFM 3, Ɂ['A 3-T 5S sPtart 0!lenWAv (HE&?^4ł`@ $19'O$%18OEls`B!T212%EoIf > 0!!WithIFChFaws(SA7:=, 1gth:=( $2 - %)).Font!Q.Nam"A`rial"RaShtylBSDiz!9.5Strikrou$ghTFa4 .SuperscPriptb.OutlineA hadowZUg xlb#N onNColorI xAutomatic$GA=oJ]Iě8TIt`"Ed.7"?: ? pdstoploc( Offset(-0).Addrxessl>,ldApuet"@t׀PtW?a2XaBZ=A[-2t t> p-$}ta@ t EtƶrCtt_@"CbQtQttt ttߦwt}.t).tttp?tIt.Sty.trFt.ttA"t#. $trZr:04t<t$1ſ?m_:: 9B߹1)j! `Z9Z TwZ 1 f= " " + cvalue ' add 11 to 21 ActiveCePll.V^=^sppace : |Else If d iff =pThen {o+:34!Uzb2 +bd5d7Kdnd IfEJstop4|0Do Untild (1)K@F currc@Offset(0, 1).AddressRange(E).Select Wit$h Cioϣ.HorizontalAlignmeDnt"xlCer.Vertice WrapTe2xFa@.Ori@at'P?IndShrinkToFi Merg}>s a;%nE= wXTrim(cc>= R@Clen Len Cgotsuper@-aQH> 0S Y65lettercbHo9 bb ) (+ bE3MidD%,?Ai a"\" 'C FI1 -R`%1-gI$@Etos…%+$sdF2De _Ͽ_M= _M!_M`_Me_M _M._M܆0>._M_M#FormulaR1C>1D"Charac?s(Start:=@,PK gth:=&).FfO#.Name"Arial"StylReg r .Siz9.5ogStrikethroughO?g'.STscripgTruob.Outline#adowUurxlNon '.Color!yxAutom{cOD/($$G, %E%% )%9%Y%z%_"p-u/%+/%/%./%&/%/%/%[/%\E?zckжo Loop?0PYpc05LNot (A"<") AUDN-#O%rhdolla!"Wh`iod oW acxbzer oeѻg  azeroes = "" Hpsw0B hdashFcntiFstop5FDo Untitl ,1v(!+ 1)letterAMid(cvalue, ,If "-" Then6ObElse %>$>olla;"$Y*l .e @period\".\ !CJIj%h*Pcent*%?Kf6 bE+ l"0!1/ '% End IfW  w `"Bcelllenb( Loop 'C#zF4 Selection.NumberFor$maVhd|+ Gh$o+:+ aa\X#`n otrgots>u@d+thiscol/AveC0.ColumЮ )maxwB04`44Konro Range("A" + Tri@m(Str(b)8)).#4'o next linMWith9 G.HorizontalAlign"mxlCerVerticnnWrapT! = Fag .Oria&}.AddInd0? .ShrinkToFi*OBMergr?<[ s{!V|oue`RSbefor1LenO1 91af3?diffp(- holqr1P0od2|6l1 "Race apZethnicity") Or (Mothe`r's rG er.Worksite onlT "Class9atdq "STATE:lt5) -O (head of@ house!)`qt7X -'qA$#p' 12)O addsp+.? #3, w Q3 _A15_Qstarta@nA1 *% /r@ 19zA 18Oq~92oq2tp Px> 0d8<Isi:=C, gth:=(0 2 -0kFf``NamQ"Arial.StylrBLoaSiz89.5 tikIrouga`@ !.Sscrip_e4tb_.OutyA `1_slad2/%UgQxlNNobortx!RAutoicOp`# Else If diff = 8 ThenActiveCell.Va(lueZ" " + cv8' add 7 to 15%O2spaceF mBEnd If'stoploc[(.Offset(-1, 0).AddreXss)*31 Range(start/, 4).Font.BoldTruMid(, B5)"-" c-inueswÍCpedro 0mWith @Characters(Sa~:=, 1@gth:=(`2h - A)À).NamAria l"RAStylGASiz!9.R.Strikethrough xFa .Supcript bsOutline hadUnder  xlb#NonpColorI xAutomaticQ-GA=oJu ` ?/ 09 Or (befor%1)1Q `Z9 Cჿ+ 1o= <ϏfD 11! I}/=/ Ǔ/ ( 1 /D |13R 4K__ _ sX 2_ Q_ R27 ߪ1? ??! SqLoop ' until3ge of obje titlQ14HtDo U`op1_ currc0x0p C).Sel0 |wio_.HorizalAl@ignmenQkx$lCerN.Vler_n|WrapTexpu0.Orieon?Pgb mq.ShrinkToFiBMergsp#"k=J= TrimDogR5!  Qs S= gots Fߜf .F6letp cK1QO1+  ã,g4Pc "\]R gotsuper = 1  8cvalue!Mid(, 1, lettercnt - 1) + >8+VcelllenR)pActiveC2.Vzv1toselect(y2sd3De/*eRange(curr1).SS3With ionB.HorizontalAlignme= xlC erVerticWrapTexNFalseOri@at'X0AddIndShri@nkToFiM(erg}sEn+ #7+ 5./  ˴ End If ' not gotsup er celllenthiscol = Ac tiveCP.Cpolum,/max8Then stop4C1 `pLoop o0nrow0+  8Range("A" + Tri@m(Str())).Seleccvalue(cV ;R+ )2%Offset(1, 0).,(Mid(I(, 5)!"-") Or  " A4"Dz continue>sZ XAAfpedbHNRowO"01;AQbeforpL 0!Withhar4acas@7:= , 1gth:=( $2 - % F" .Nams"Aria l"RaStylBRSiz!9.5ikethroughT,Fa4@SscPriptb.Outline1 hadUnder xlqb#NonNorI xAut@omaticO A"#$M8$p+)$rn M0M7MO-?Mu ?: 9t&c|1)  d 9 oC  1O=2 11! I}=/ "/ ) 1 / / q1_ 3R 4.__ _ so%g%12_ Q_ R 27 71@If+/@Cſ| uu l>1r=r Ws0ourcsiss="R ÅCDo Uŏez @"%?ƥSM+ ion.Dte Shift:=hp0*0?=Ci6O (H"mɩADATA ISSUES"gg@SOURCE/ // qƴLen(endaddress) @- 1 If cvalue = "DATA SOURCE"` Then dsourceswV 4Selection.EntireRow.InPsert CA%veCell.VwObjryxlb;61D._+_+d q*ggY(e A`T0 c`len aσ|.Yf> _ 0stop6pO lettercY Do U@l (U1MT("33 P 0"\|RE\ᑖ`R y׿P ,-W ewGUtO6XFormulaR1C1PtosҫH/$sd&cT,!o,4hDe- U BbHCharac-sЯart:= gth:=Q.R kShRegr,S.S.5gTOyUTruJV;&.OW .SXXeYXYL $$0, %u+)%%%la%%.%%%tSu{+/%;|/% #%ϴline = x@lUnderStyleNone .Col(orIxxAutomaticfEnd WithA@stop6L1!?IfIf lettercntAcellle0n ThVLoop Q 3Els4sourcesNwT0 dh Mid(cvalue, 3, 1) meas 6 lLen!rZ112 2, 2"3 4O45er 2e >= 7J2M7, l - 5*_@ ""UCl~partAJ7 'normalG numpchaBra5 ' secondP0 A"\FjA"0" OrBB A = -2-dash a& digit of first pair D3spac~e-D4 4bn&(f+S>Not @t:@&)oJ $g+ :KmI,, 5? Dcd bi" "@4no !urѰ`, w+@ 0R13o@1`2%32eS!"0G 49 ?j`/0"m\ U2wU!UActiveC.V01 +Ž2t3t4tDi]>#6@  C addCK= iTEtu 43 A_@B{"-7is@at a `tinupon ]LrleC)N(` 3Ld<9 4 A !$0^617P 5 Mp[= `! 6?_?@4____oqU8f2iUjlrt49s!mm:zAB;R0, QM)p|0xLRrt:bpSG (l812,t Te0h?HH.I LP^߱AbqAbq3 .A EUX' PUU_΍ģ+"`19o ra  3{}1d:WonrosgQ @until 1v=0} Tg4 dela(obj1-Rhaveyea}#I s 1 Sheet`.PageSet up .PrintTitleRows = "$" + Trim(Str(d@elrow1H1d)) ":< Ho$bjH))CoPlumn" End With ActiveSheetArea73 .I.LeftHeader9Center Righ(Foo( ( (Margin(Application.InchesToPos(0.75 )1Top!1 Bottom CW 0. 7J0ingFalseȃGridlineCommxl NoorizontallypM 0VertvOri@B}xlLa@ndscap .DraftFirstNumbBxlAukc*OrxlDownThenOverBlackAndWhite Zoom100vAj Range("A2:P4").SelectG |  \) .HF)Aligna0@xlc(* .WrapTex( . 1.AddIlPP +f'.FC N ".Nam7"`Arial !Styl"Bold I VichSizA9l ikethrough.Super`scrip4 bqOutrau hPadowU@3r3xlNoni".@or9xf0D[B6:B2000[n ([![d[[-vU-<.M-^A1Aj.)=upGoto Reference:="0R1C1+Sub __SRP_2__SRP_3($gModule27y__SRP_4Tst find the row which has the titles''''''' a  'A $$ $B@H j!p' $' $' Measure j!'p''' a$  '  j%l!p' j% $' $' MethodG'j   j%l!p'd  j%l!'  j%l!'#kk0 end for First, find the row which as the titles'''N''  ''''''''' a"$' aA $$ $B@H j!p' $' $-----' j!'$''kP  $' $' -  (|mxME(6 << <x `::p%H@G$*\Rffff*3?47c2d5fa:" .8@HPX`h p$    0 @ ` p  0   (08 6@ x  $ @P `     82( `p   0 8@H h .      ( *0` hx2    (08 @ HXh x  < P`px   " ( 8 H P X ` h p x  "             ( 0 H  P ` Zx           0 @ X h p x              0 @ H P X ` h p   $       (  @ P :`        0 @0P (@HPX `*p   40h        >  `0p08@H`hpx *  (0 8 @4P  6  <0p  >  BX p x         ( 0@P ` p < 8HX`p   " 08@HPX`h"p0 8HZ` (@PX` p    (08@HPXp $   ( 8 :H          0 H ` p(    8 @ H P h p x   *     !!!! !(!0!8!@! H!4X!!!!!!! !" "0"8"@" H" P"0`"""""""# #(#0#8#P#X#`#h# p#*## ######$$$$ $ ($ 0$4@$x$ $ $6$$ % %< %`% x% %>%% % %B&H& `& h& p& x& & & && .&& & &&'  '('0'8'@'H'P'X' `' h'x'' ' '' '''''((((<0( p((((( (((((((( ( )")8)H)X)h)p)x))))))"))))**** *(*0*8*@*H*P*h* p**Z**++++ +(+0+8+ @+P+`+x++++ +++ ++++ ,, ,(,8, @,P,`,h,p,x,,,,, ,$,, --(- 8-H- `- p- $- - - - <-"(.P. X.h.p.x. . . . . . .0./ /@/`/h/p////////// /*/(0 80H0X0`0h0p0x00000 0 0400 1 1601h1 1 1<11 1 1>2H2 `2 h2Bx22 2 2 2 2 2 3 33303  H3X3`3h3p3 x3$3 3333 4  4 $84 `4 p4 4 444 4424 $5 @5 P5 h5 p5 5 5 (5 $5 @5 886 p6 x6 6 B6 (6 27 @7 H7 P7X7`7h7p7x777 7777 7 7 778 8  8 (80888P8 h8 x8 8 8 8 8 8 8 8 8 8888 9 9(90989H9X9p9D9$9 9 :: : (:8:"H:p:::::::::::":;;(;8;@;H;P;X;`;h;p;x;;;; ;; ; ; ; ;< <8<P<h< < << <<<<<==== = 2@= <x= = == = =>>  > (> 0>@> P>p>x>>>>> >>>>> ? ? ?0?@? H? P? *X? ?? ? ?? ? $? 0?@ 8@H@X@`@x@@@@@@@@@AA A 0A@AHAPAXA`AhAhpALA (B@HB&BB B 0B&C(C @C HCPCXC`ChCpCCC C C  CDC8D@DHD XDhDpDxDDDDDDDDDE(E0E8E@EHEPEXE`EhEpExEE E EEEEEEEE E E E F  F (F 0F 8F @F HF PF XF`FhF FFFFFFFF FFFFG( Fir found a new objective $'# looking for a measure 'P  G'j` ' $' $' $' $'    $'Xd'k 0 0 0G 'j 0  0 no measure'  'd( 0     ' ''kk       j(pk j!'' a find where objective title ends' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '0  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ 'B@H  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q   j(P2 R j%!vArial9Regular9x#@9z9|9~999 9 9qx T X j%!vtalicArial9zRegular9x#@9z9|9~999 9 9q'Jk L G'Jj a $'L < D N - # ''''''''' a  '  $'R -'d $$'9d` ..'9|'d0 %%'9d X 0 'd  0 'kkkkkk  G'j stop5J        8(:Hk  hdashk not$k gotsuper$k celllen j!'  G'j stop4  'A $$ $B@H- goto next line j!p' $' 'H $' 'no   '  $'` $'f Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household)   j(p; add 5 to 12  j!p j(p j!p $'` j!p$' '' j!p' STATE:''d STATE:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pkxkp j%l!' '  $!v(  $-----' j!'''k d 6 Not a new objective. These are objective title lines   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''k k       j%!vArial9Bold9x#@9z9|9~999 9 9q k d   j(p> add 7 to 15  j!p j(pdX     j(p@ add 9 to 18  j!p j(pd    j(pC add 11 to 21  j!p j(pdp    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pk k kx kp kh k` ' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q8  j(P R j%!vArial9Regular9x#@9z9|9~999 9 9q T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #''''''''' a  '  $' -'d $$'dx ..''dH %%'d   0 'd  0 'kkkkkk  G'j stop5       8(:k  hdashk notk gotsuperk celllen j!'  G'j stop4  'A $$ $B@H1 goto next line 8 &9  &9$9(9*9,9.90q0 j!p' $' ' $' '   '  $' $' Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household)   j(p? 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kkx       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(pA add 7 to 15  j!p j(pkPkH j%l!' '  $!v(  $-----' j!'''kd   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pdh     j(p@ add 9 to 18  j!p j(pd    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pkkkkkxkpkhk`% until stop3 - end of objective titled(' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q  j(P R j%!vArial9Regular9x#@9z9|9~999 9 9qX T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #''''''''' a  '  $' -'dh $$'d@ ..''d %%'d  0 'd  0 'kkkkkxkp  G'j stop5       8(:k  hdashk notk gotsuperk celllen j!'  G'j stop4  'A $$ $B@H j!p' $' j%l!p' $-----   $-----' j!'k''kx ' $' '   '   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''dP STATE:''k k       j%!vArial9Bold9x#@9z9|9~999 9 9qhk`dX   j(p= add 7 to 15  j!p j(pd     j(p@ add 9 to 18  j!p j(pdx    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pk k k k k k k k until stop2 until stop1=1 '' '' aA $$ $B@H j!p' $' $' j%l!p' $-----  8B@A $$ $B@H j!p' $' $' j%l!p'kH  'd  DATA ISSUES  DATA SOURCEA $$ $B@H  '  DATA SOURCE' 8!B@Measure j(p  '  $ $$ 'A $$ $B@Hnumber j!p j(pA  $$ :  $B@Hd  DATA ISSUES', j!p j(p  $ $$ 'A $$ :  $B@Hkk 8 "9  &9$9(9*9,9.90qh 8 4 8%2(6 8 : 8%2(6 < 8%2 >96 B9@ 9q D 8%2 >96 B9@ 9q 8 F 8%2(6 8 H 8%2(6 8!vArial9 Bold Italic9x 9z9|9~999 9 9qd   '  'J'L Ja L 'L  L$'N N\  L $  L  L $ 'A $$ $B@H  j(p  j(P L 'R L'T 'V V R 'X R j%!vArial9Regular9x#@9z9|9~999 9 9q  T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jkx L G'JjXkPdH  $' $'Z ' $' $' $' $' $'    $'dH'k8'\normal'^ normal'`'b'd'f'h 0 0'^$ dash and second digit of first pair'\. space and dash and second digit of first pair 0 ' \ '\d 0 ^ '^'bkk 0 ^ '^  # no measure'  ' \ '\d`     ' '' \ '\kkd 0 \ '\ ^ '^'`kk       j(p j!p'd`'b'`kH' Z G ^ '^j - is not a continuation line j!p \$'d ^ 'fd? ^ ` 'fdp? ^ ` 'fd@? ^ ` 'fd? ^ ` 'fd> ^ 'fk>k>k>k>k>k> Zf Zi Zj Zl Zr ZtG f 'fj Zm ZA ZBG f f $'fj bG f 'fj b ` Z G f 'fj j!p \  \ $'h d f h j(pd0= -" is a continuation line 'd, 19 d j!p j(pk<k<k<k<k<k<  ' until stop1=1k continuesw = 1  'j G j 'jj l!n$ j $$ : $ $$ 9p9rq; l!n(t l!n9v9x9z9|9~9? %9? %9 %9 %9? %9? %999 999 9*9 9 99d9qx:A2:P4$B@H 8 &9  &9$9(9*9,9.90q: 8!vArial9 Bold Italic9x 9z9|9~999 9 9q9B6:B2000$B@H 8 "9  &9$9(9*9,9.90q89A1$!v( R1C1 B@o98ĵAttribute VB_Name = "Module27" Sub TSM() ' First find the row which has"titles cval&uonP= 0 oncol#maxstop1haveyear obj;Do Until -1 ^+ Range("A" + Trim(Str(#))).S`elect@VActiveCell.V_ "=R If "Measure" Then+\nG IthodH@ƁL4 " A/10M" `!OElseFc FLColumzendaddrelss#AC E ;IfLoop'C'  f4orC,L dh"$ lettep"w3DspacD|$v+ 2nt`}Y@this~be`!af!@diffcoA ~nuesw ped~dda8ehJ^WMid(# , 1, 5)"-Tj ka!IA![K `e0k E 3`bCE)n7+ cN-xK ) ' Xu^a new K ೦_6 U 6 `lo oking`a mgW ]aa "E]eALend9!A+ =1LAI2, n2L!oI4k( 4GI5K >= 7 8>@l -0)nPuB#Q"0" OrDzp!d !`g! CK#no _4c" Not ( )1 qqerw ZR@/ C2Lp$!1`q2t>3t'  startlobX>mE@_r @Z1@!wherew@ ¦nqA!Ha(81currc 'ЄydK$ With io.Horiz`oalAlignmeBtxlC! .Verticnt$ .W@rapTexqyFaߍ .Oriyat 0<P .Ind0?q.ShrinkT8oFiBMerg¶ 1%^ (\xe{_%qfO{i !len_}  gotsupB<E> x,6Nerc( K1QO1AMak + #7+ 5./  Vno/!~thiscolVolum_Qmax]f404o|nrBsd"A" + Trimr(r))Po n!C ̴ll.ValueH cvx = RTrim(8)|before|Lentzx aftervdiff(a- -!zhold Midx, 10 "2#6"If >'"Race and ethnicity") Or Mother's rGender!Worksite onl0f"Classes at a"STATE:& 5)g-r (head of house) ThenzgA@Ke7 OAActiveCe!" + ' add 5 to 12A P sp]+ MNAFM 3, Ɂ['A 3-T 5S sPtart 0!lenWAv (HE&?^4ł`@ $19'O$%18OEls`B!T212%EoIf > 0!!WithIFChFaws(SA7:=, 1gth:=( $2 - %)).Font!Q.Nam"A`rial"RaShtylBSDiz!9.5Strikrou$ghTFa4 .SuperscPriptb.OutlineA hadowZUg xlb#N onNColorI xAutomatic$GA=oJ]Iě8TIt`"Ed.7"?: ? pdstoploc( Offset(-0).Addrxessl>,ldApuet"@t׀PtW?a2XaBZ=A[-2t t> p-$}ta@ t EtƶrCtt_@"CbQtQttt ttߦwt}.t).tttp?tIt.Sty.trFt.ttA"t#. $trZr:04t<t$1ſ?m_:: 9B߹1)j! `Z9Z TwZ 1 f= " " + cvalue ' add 11 to 21  ActiveCell.V^=^space : |Else If @diff =pThen {o+u34!Uzb2V bd5d7Kdnd IfEJAstop4|0Do Until (1)K@F currc@Offset(0, 1).Ad dressRange(E).S elect WiHth Cioϣ.HorizontalAlignment"xlCer.Vertice WrapTdexFa@.Ori@at'P?IndShrinkToFi Merg}}s a;%nE= wXTrim(c>= R@Clen Len Cgotsuper@-aQ> 0S Y65lettercbHo9 bb ) (+ b3MidD%~,Ai a"\" '-C FI1 -R`%1-gI$@Etos?…%+$sdF2De __M= _M!_M`_Me_M _M._M܆}0._M_M#FormulaR1|C1D"C harac?s(Start:=@,APKgth:=&).FfO#.Name"Arial"StylReg rA .Siz9 .5ogStrikethrough?g'.ST scripgTruob.Outlin>e#adowUurxlNon '.Color!yxAutom{cOD/($$G, %E%% )%9%Y%z%_"p-u/%+/%/%./%&/%/%/%[/%\E?zckжo Loop?0PYpc05LNot (A"<") ADN-#O%rhdohlla!"Whq`iod oW acxbzeroeѻf  azeroes = "" Lpsw0B hdashFcntiFstop5FDo Untitl ,1v(!+ 1)letterAMid(cvalue, ,If "-" Then6ObElse %>$>olla;"$Y*l .e @period\".\ !CJIj%h*Pcent*%?Kf6 bE+ l"0!1/ '% End IfW  w `"Bcelllenb( Loop 'C#zF4 Selection.NumberFor$maVhd|+ Gh$o+:+ aa\X#`n otrgots>u@d+thiscol/AveC0.ColumЮ )maxwB04`44Konro Range("A" + Tri@m(Str(b)8)).#4'o next linMWith9 G.HorizontalAlign"mxlCerVerticnnWrapT! = Fag .Oria&}.AddInd0? .ShrinkToFi*OBMergr?<[ s{!V|oue`RSbefor1LenO1 91af3?diffp(- holqr1P0od2|6l1 "Race apZethnicity") Or (Mothe`r's rG er.Worksite onlT "Class9atdq "STATE:lt5) -O (head of@ house!)`qt7X -'qA$#p' 12)O addsp+.? #3, w Q3 _A15_Qstarta@nA1 *% /r@ 19zA 18Oq~92oq2tp Px> 0d8<Isi:=C, gth:=(0 2 -0kFf``NamQ"Arial.StylrBLoaSiz89.5 tikIrouga`@ !.Sscrip_e4tb_.OutyA `1_slad2/%UgQxlNNobortx!RAutoicOp`# ElseIf diff = 8 ThenActiveCell.Va(lueZ" " + cv8' add 7 to 15%O2spaceF mBEnd If'stoploc[(.Offset(-1, 0).AddreXss)*31 Range(start/, 4).Font.BoldTruMid(, B5)"-" c-inueswÍCpedro 0mWith @Characters(Sa~:=, 1@gth:=(`2h - A)À).NamAria l"RAStylGASiz!9.R.Strikethrough xFa .Supcript bsOutline hadUnder  xlb#NonpColorI xAutomaticQ-GA=oJu ` ?/ 09 Or (befor%1)1Q `Z9 Cჿ+ 1o= <ϏfD 11! I}/=/ Ǔ/ ( 1 /D |13R 4K__ _ sX 2_ Q_ R27 ߪ1? ??! SqLoop ' until3ge of obje titlQ14HtDo U`op1_ currc0x0p C).Sel0 |wio_.HorizalAl@ignmenQkx$lCerN.Vler_n|WrapTexpu0.Orieon?Pgb mq.ShrinkToFiBMergsp#"k=J= TrimDogR5!  Qs S= gots Fߜf .F6letp cK1QO1+  ã,g4Pc "\\R gotsuper = 1  8+VcelllenR)pActiveC2.Vzv1toselect(y2sd3De/*eRange(curr1).SS3With ionB.HorizontalAlignme= xlC erVerticWrapTexNFalseOri@at'X0AddIndShri@nkToFiM(erg}sEn+ #7+ 5./  ʹ End If ' not (gotsuper @celllenthiscol = A@ctiveCP.Colum,/max8Then@ stop4C1 `Loop `onrow0+ 8Range("A" + Trim(Str())).Seleccvalue(cV ;R+)2%Offset(1, 0 ).,(Mid((, 5)!"-") Or  " A4"Dy continu|esZ XAAfpedbHNRowO"01;QbeforpxLenJe@na0fter@diff(D- B \ 7 RW͘@>"DTv@add 5 to 12N space _O/holdA/!O`P3, 6l3`5start0@72 0 /E"STATE:"3019/18Elseo!2^2%i > 0!!Withhahracas@7:=, 1gth:=( $2 - %F" .Nams"Arial"RaStylBRSiz1!9.5ikethroughYTFa4@Sscriptb.Outlinec hadU0nder xlb#NonN(orI xAutomaticO A"#$M8$p+)$rn M0M7MO-?Mu ?: 9t&c1)  d 9 oC  1O=2 11! I=/ "/ ) 1 / / q1_ 3R 4.__ _ so%g%12_ Q_ R 27 71@If+/@Cſ| u l>1=r W`sourcsiss="R CDo Uŏez @"%?ƥSM+Aion.Dte Shift:=hp0*0?=Ci6O (H"mɩADATA ISSUES"ggSOURCE/. // pɴ Len(endaddress) - 1 If cvalue = "DATA SOURCE" Then dsourceswV 4Selection.EntireRow.Insert CA%veCell.VwMeasure" *onrok.+ s2Mid, 1, l) + Trim (Str(#)) 2Range("A").k a@number""L &I)j":#UElse -zISSUESzissuz?rxlb;61D._+_+d q*ggg(e A`T0 c@len? Ac|.Yf> _ 0stop6pO lettercY Do U l (U1MT("33 P 0"\|RE\ᑖ@R^ yP ,-W ewGUtOt6XFormulaR1C1PtosH/$sd&cT,!o,4hDe- U BbHCharac-sЯart := gth:=Q.R kSRegr,S.S.5gTOyUTruJV&.OWx .SXXeYXYL w$$0,%u+)?%%%la%%.%%%tSu{+/%;|/% $%дine = xl@UnderlStyleNone .Col(orIxAutomaticfEnd WithA@stop6L1!?IfIf lettercntAcellle0n ThVLoop Q 3Els4sourcesNwT0 dh Mid(cvalue, 3, 1) meas 6 lLen!rZ112 2, 2"3 4O45er 2e >= 7J2M7, l - 5*_@ ""UCl~partAJ7 'normalG numpchaBra5 ' secondP0 A"\FjA"0" OrBB A = -2-dash a& digit of first pair D3spac~e-D4 4bn&(f+S>Not @t:@&)oJ $g+ :KmI,, 5? Dcd bi" "@4no !urѰ`, w+@ 0R13o@1`2%32eS!"0G 49 ?j`/0"m\ U2wU!UActiveC.V01 +Ž2t3t4tDi]>#6@  C addCK= iTEtu 43 A_@B{"-7is@at a `tinupon ]LrleC)N(` 3Ld<9 4 A !$0^617P 5 Mp[= `! 6?_?@4____oqU8f2iUjlrt49s!mm:zAB;R0, QM)p|0xLRrt:bpSG (l812,t Te0h?HH.I LP^߱AbqAbq3 .A EUX' PUU_΍ģ+"`19o ra  3{}1d:WonrosgQ @until 1v=0} Tg4 dela(obj1-Rhaveyea}#I s 1 Sheet.`PageSetup .PrintTitleRows = "$" + Trim(Str(de lrow1H1)2) ":< HobjH))Col(umn" En@d With ActiveSheet.Area73 .I.LeftHeader9Center Righ(Foo( ( (Margin(Application.InchesToPos(0.75 )1Top!1 Bottom CW 0. 7J0ingFalseȃGridlineCommxl NoorizontallypM 0VertvOri@B}xlLa@ndscap .DraftFirstNumbBxlAukc*OrxlDownThenOverBlackAndWhite Zoom100vAj Range("A2:P4").SelectG |  \) .HF)Aligna0@xlc(* .WrapTex( . 1.AddIlPP +f'.FC N ".Nam7"`Arial !Styl"Bold I VichSizA9l ikethrough.Super`scrip4 bqOutrau hPadowU@3r3xlNoni".@or9xf0D[B6:B2000[n ([![d[[-vU-<.M-^A1Aj.)=upGoto Reference:="0R1C1+Sub __SRP_5#g_VBA_PROJECT-dir__SRP_0 rU $`nt0* pHd VBAProject4@j = r G J< rstdole>stdole b%X*\G{00020430-C 0046}#2.0#0#C:\WIN\SYSTEM\StdOle2.tlb#OLE AutomatioFnZMSForms>BSFCr@ms3BD452EE1-E08F-1 01A-8-02608C4D0BB4 BDOWS\system32\FM20.DLL#Microsoft : [ Ob Library/;D~1~r~~00}#0~#hc2d5faModule27| X(0 pPh`Hx8oHc8/ݚ~HB.?jȍD!:J=WH9s<J:VIC LNEo uX!J3.krLNŽKn&ԏ*QA.I,h.6s$lKHezj<%BTBdKAЧV-Cߒ#eN+B+yJצ@4|TjFۥ8!-abĽBY?ŵ!u72ߢ IFf`9ժ^^`JOx$WBb :n_Gi,HA[LIOkbX"}? E˗ҿYuA*:" `n9~HgQq<5J9F/q} {lBIY^6G?2(9fN*^U@u?pMb%&نWLyhx@DF8V^GotoExcel+VBAWin16~Win32MacVBA6# VBAProjectstdole`MSFormsCOfficeuModule1b _EvaluateMacro1NRange  ThisWorkbook|Sheet1Module2cModule3dMacro3NCellsModule4eModule5fModule6gModule7hModule8iModule9jModule10UMacro7N SelectionZ NumberFormatRModule11VMacro8NReplacefWhatC ReplacementLookAtOxlPart< SearchOrderxlByRows MatchCaseModule12WModule13XModule14YModule15ZModule16[Module17\Module18]Module19^ Boldfncolcurrcell6currsellstopit37\currp1kg ActiveCellOffsetValValueKvlenYletter2+FontU FontStyleSize Strikethrough" Superscript SubscriptV OutlineFontOShadow UnderlinexlUnderlineStyleNoneNd ColorIndex xlAutomatic@thiscolHColumnimaxcol5Module20zBoldfncModule21{NumericQ Application* DisplayAlerts StatusBarʜcvalueonrowwoncolP'stop1/Qhaveyear$objrowvTrim@StrRTrimRowstop20Q endaddressAddressdh\letterspacaddspace&Xcnt+beforeafterXdiffc continuesw stoppedrowlclett1"lett2#lett3$lett4%lettrCstartlocӮstop31Qstop42Qcelllen\cZhdollarR2hperiods#hpercentbzeroesazeroesnpswkhdash%gcntsstop53Qholdvhold2hold3start3 len3|len2| CharactersrgStartLengthYstoplockBoldcvalue2sourceswissuesw?ay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WIN\SYSTEM\StdOle2.tlb#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{A78349A2-A7CD-445E-8406-857DE157E77D}#2.0#0#C:\DOCUME~1\ths5\LOCALS~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSO97.DLL#Microsoft Office 8.0 Object Library  G mModule12o47c2d5faModule1mUThisWorkbook0j47c2d5f4ThisWorkbookC % Sheet10l47c2d5f4 Sheet1N 0Module22p47c2d5fa Module2yHModule32q47c2d5fa"Module3R`UModule42r47c2d5fa(Module4<,xModule52s47c2d5fa*Module5=Module62t47c2d5fa,Module6ɭModule72u47c2d5fa.Module7!Module82v47c2d5fa0Module8 Module92w47c2d5fa2Module9uIModule102x47c2d5fa4Module10BUModule112y47c2d5fa<Module11w }Module122z47c2d5faPModule1288Module133047c2d5faRModule13P Module143147c2d5faTModule14ߕh Module153247c2d5faVModule15FModule163347c2d5faXModule16Module173447c2d5faZModule17Y4Module183547c2d5fa\Module18Module193647c2d5fa^Module19K5Module203747c2d5faModule20Q)Module212n47c2d5faModule21Module223847c2d5faModule22(}Module233947c2d5faModule23f@Module243:47c2d5faModule24o X5Module253;47c2d5faModule25w_pModule263>47c2d5faModule26Q| Module273?47DeletexShiftxlUp EntireRowInsertr endaddress2wHorizontalAlignmentS@xlLeft9VerticalAlignmentʡxlCenterWrapText} Orientationw AddIndent2W ShrinkToFitA MergeCellsکBordersC"xlDiagonalDownJ@ LineStylewxlNone xlDiagonalUp xlEdgeToph xlContinuous[Weight1xlMedium xlEdgeBottomxlInsideVerticaljMxlInsideHorizontalstop64Q lettercntXRletter3+ FormulaR1C1StoselectCsdselect]celllen2IDeselectmeas@lenpart1-} numpchars second2second1part10part21part32delrow1X ActiveSheet%N PageSetupPrintTitleRows1sPrintTitleColumns PrintAreaP LeftHeader CenterHeaderD RightHeader LeftFooter CenterFooter RightFooter|S LeftMargin]InchesToPointsI RightMargin[ TopMargini BottomMarginu HeaderMargin8 FooterMargin PrintHeadings)nPrintGridlines@ PrintCommentsxlPrintNoCommentsCenterHorizontallyCenterVerticallyI xlLandscape&Draft:FirstPageNumber%OrderAxlDownThenOver BlackAndWhiteZoomdelrow2XRowsU RowHeightMergeq_ ClearContents{ ReferenceeModule22|Macro2N TextToColumnso DestinationлDataType%? xlDelimited TextQualifierConsecutiveDelimiterxx SemicolontComma0KSpace Other OtherCharԕ FieldInfoModule23}Module24~ AttractiveVgotsuper SearchFormat ReplaceFormat Module25Dcolsp1SColumnsp9 ColumnWidthModule26PI^Module27TSMWorkbookk Worksheet _B_var_cvalue4 _B_var_onrow~; _B_var_oncol| _B_var_maxcol _B_var_stop1_B_var_haveyear _B_var_objrow _B_var_Str _B_var_TrimmT _B_var_RTrimr _B_var_stop2_B_var_endaddress _B_var_dh _B_var_letter$_B_var_letter3h/ _B_var_spac_B_var_addspace/ _B_var_cnt<<_B_var_thiscolTL _B_var_beforeX _B_var_after _B_var_diff9_B_var_continuesw_B_var_stoppedrow{ _B_var_Midp_B_var_l  _B_var_lett1 _B_var_lett2 _B_var_lett3 _B_var_lett4 _B_var_lettr0_B_var_startloc\ _B_var_stop3 _B_var_stop4_B_var_currcell7_B_var_celllen``_B_var_gotsuperq _B_var_stop6!_B_var_lettercnt[_B_var_toselect_B_var_sdselectt_B_var_Deselect _B_var_c_B_var_hdollar5_B_var_hperiod&_B_var_hpercent}_B_var_bzeroes"_B_var_azeroesr _B_var_psw| _B_var_hdash+ _B_var_cnts,  _B_var_stop5  _B_var_hold _B_var_hold2+ _B_var_hold3, _B_var_start3D _B_var_len3X _B_var_len2W_B_var_stoploc__B_var_cvalue2'_B_var_sourcesw_B_var_issueswB_B_var_endaddress2٨_B_var_celllen2R! _B_var_meas5_B_var_lenpart1T_B_var_numpchars3_B_var_second2;_B_var_second1: _B_var_part1\ _B_var_part2] _B_var_part3^_B_var_delrow1G\_B_var_delrow2H\_Defaultj _B_str_Date{B1 E3 5 = =Q SUWY[]_ 9?25<!>#>)7+B-C/D F 0 A78349A2-A7CD-445@E-8406_7DE157E77DH.DOCUME~1\ths5\@LOCALS@Temp\VBE\DK.exd2 .E .`M ACOfficDOf@icB 02DF8D04C-5BFA_B-BDER5@AA@420PROGRAM FILES\MICROSOFT OFFICE\MSO97d#p 8.0d"BmÏodule1Gďou1U 2HB1UB,Bm!B+BThisWorkbookG@ThiWko@k![A 2 o%pC "eySheet! Se 9t 2 N "w"/2//J2*/2//2-/y+/3j333=R4444L<,5j555=6666ɭ7j777!8888 9_9Z9_9_3PuI[BM:10GIdR092?03~BIJ1-1PLC}JwJJJ?J?8JKK??Kq@KaKpK?KKKK?KFL!L0L?_L`LL?L?LY4LLL?M M?AMPM?Mf5`K2IM20K2.0E1E)QM{M2M2MؿMp{M2M2?UM{p{M2M2lfMp{Mn2M25&o Mp{M2M2y1``,0w_!`D+Module26G4odule26 F2FnH |{TQ{7{7 {7{7#{=sK*yrU~~~~~~~~~h )6^`[I5(    )AYq1Qq1Qqa     )  Module1 ThisWorkbookSheet1Module2Module3Module4Module5Module6Module7Module8Module9Module10Module11Module12Module13Module14Module15Module16Module17Module18Module19Module20Module21Module22Module23Module24Module25Module26Module27 VBAProjectF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA I q0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel Ai@0FC:\WIN\SYSTEM\StdOle2.tlbstdole QyP.E .`M C:\WINDOWS\system32\FM20.DLLMSForms ))Q`Iͧ^D}W} .C:\DOCUME~1\ths5\LOCALS~1\Temp\VBE\MSForms.exd )1pL-[DR 2C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSO97.DLLOffice  PI TSM9rU __SRP_1' PROJECTwmPROJECT)SummaryInformation(,  tModule1Module1ThisWorkbookThisWorkbookSheet1Sheet1Module2Module2Module3Module3Module4Module4Module5Module5Module6Module6Module7Module7Module8Module8Module9Module9Module10Module10Module11Module11Module12Module12Module13Module13Module14Module14Module15Module15Module16Module16Module17Module17Module18Module18Module19Module19Module20Module20Module21Module21Module22Module22Module23Module23Module24Module24Module25Module25Module26Module26Module27Module27ID="{EAE9E685-C70F-11D2-9E0E-10005A74EBCD}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module2 Module=Module3 Module=Module4 Module=Module5 Module=Module6 Module=Module7 Module=Module8 Module=Module9 Module=Module10 Module=Module11 Module=Module12 Module=Module13 Module=Module14 Module=Module15 Module=Module16 Module=Module17 Module=Module18 Module=Module19 Module=Module20 Module=Module21 Module=Module22 Module=Module23 Module=Module24 Module=Module25 Module=Module26 Module=Module27 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="6361601DDD21DD21DD21DD21" DPB="DCDEDF98211022102210" GC="55575623B69D B79DB762" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=110, 110, 558, 448, C ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Module2=44, 44, 492, 382, C Module3=22, 22, 470, 360, C Module4=22, 22, 470, 360, C Module5=44, 44, 492, 382, C Module6=44, 44, 492, 382, C Module7=66, 66, 514, 404, C Module8=54, 54, 691, 511, C Module9=27, 27, 664, 484, C Module10=81, 81, 718, 538, C Module11=-38, 23, 599, 480, C Module12=135, 135, 753, 573, Module13=0, 0, 0, 0, C Module14=0, 0, 0, 0, C Module15=108, 108, 726, 546, Module16=81, 81, 718, 538, C Module17=108, 108, 726, 546, Module18=135, 135, 753, 573, C Module19=135, 135, 753, 573, C Module20=162, 162, 780, 600, C Module21=-91, 80, 527, 518, Module22=0, 0, 618, 438, C Module23=27, 27, 645, 465, Module24=-30, -7, 588, 431, Module25=132, 132, 665, 469, Module26=0, 0, 541, 345, Module27=22, 22, 559, 367, Z es  Worksheets Named Ranges F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q4 $, Root Entry Fd#oWorkbook-u_VBA_PROJECT_CUR"+*SoɗpɗVBA Soɗpɗ   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Oh+'0HPhx Thomas C. Soceyemw6Microsoft Excel@;ɗ@j)|Z@oɗ՜.+,D՜.+,D PXl t|  NCHS/OAEHP Sheet1Sheet1!Print_Titl      % !"#$& (D*+,-./0123456789:;<=>?@ABC'EFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~es  Worksheets Named Ranges F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q4 $, DocumentSummaryInformation8xCompObjm