ࡱ> $bw{#  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FaDgPi%@Workbook5,=_VBA_PROJECT_CUR"32MgHMgVBAMg0 Mg \paaq2 Ba= ThisWorkbook=hL,8X@"1)Courier1)Arial1)Arial1)Arial1)Arial1)Arial1)Arial1)Arial1)Arial1@)Arial"$"#,##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.000%000 000000                + ) , *  1 1 1  1   1 1     1    1<"@ 1 1<@ 1<  1 <@  1 <@  1 <  1 <  1<  1 < `6Sheet1  ;8 821-13b School-based health centers with oral health 821-14 Community-based health centers with oral health 821-15 Recording and referral of children and youth with821-16 Oral and craniofacial State-based surveillance 821-17a State and local dental programs directed by 821-17b Indian Health Service and Tribal dental programs 821-1a Dental caries experience - Primary teeth - Young* children (aged 2 to 4 years)#11988-9418%---124%11% Race and ethnicity Race and ethnicity4 American Indian or Alaska Native only6 American Indian or Alaska Native only#21999-00a,2,376%NABSL1DNA- Asian or Pacific Islander only/ Asian or Pacific Islander only#33DSU1DNC Asian only Asian only#41993-943,434%@ Native Hawaiian or Other Pacific Islander onlyB Native Hawaiian or Other Pacific Islander only#5DNC1DSU- Black or African American only/ Black or African American only#6a,3DNA White only White only#7 2 or more races 2 or more races#89 American Indian or Alaska Native; White; American Indian or Alaska Native; White#92 Black or African American; White4 Black or African American; White! Hispanic or Latino# Hispanic or LatinoDSU" Mexican American$ Mexican Americana34%135%% Not Hispanic or Latino' Not Hispanic or LatinoDNA324%126%4 White only, not Hispanic or Latino6 White only, not Hispanic or Latino313%120% Gender Gender Female Female19%121% Male Male1 Education level (head of household)$ Less than high school& Less than high school29%# High school graduate% High school graduate$ At least some college& At least some college12% Disability status Disability status( Persons with disabilities* Persons with disabilities+ Persons without disabilities- Persons without disabilities721-1b Dental caries experience - Primary or permanent2 teeth - Children (aged 6 to 8 years)52%153%42%a,2,391%3,490%3,579%a64%169%3DNA349%156%a,348%149%54%151%50%65%43% Select populations Select populations! 3rd grade students# 3rd grade students60%421-1c Dental caries experience - Permanent teeth -) Adolescents (aged 15 years)61%51%a,2,388%3,4DSU158%aDNAa,368%361%63%160%59%621-2a Untreated dental decay - Primary teeth - Young16%119%9%a,2,368%3,430%a30%128%322%311%116%118%26%521-2b Untreated dental decay - Primary or permanenta28%129%21%a,2,372%3,471%3,539%336%326%a47%141%335%137%125%32%25%130%44%30%a18%33%221-2c Untreated dental decay - Permanent teeth -20%15%a,2,369%a36%a,327%318%115%22%17%aDSU621-2d Untreated dental decay - Adults (aged 35 to 44 years) years)27%3DNC34%140%347%323%123%150%b15%021-3 No permanent tooth loss due to caries or= peridontal disease - Adults (aged 35 to 44 years)138%b40%a23%127%a31%134%a29%142% Education levela14%a40%147%921-4 Complete tooth loss - Older adults (aged 65 to 74b22%a,3DSUaDNCa,326%a,329%122%143%111%821-5a Periodontal diseases - Gingivitis - Adults (aged 35 to 44 years)48%41%a,2,396%64%351%345%45% Education level921-5b Destructive periodontal disease - Adults (aged 35 to 44 years)14%a,259%a25%333%320%114%112%35%28%621-6 Early detection of oral and pharyngeal cancers1990-95635%b51%/ American Indian or Alaska Native624%( Asian or Pacific Islander629% Asian6DNA; Native Hawaiian or Other Pacific Islander( Black or African Americana22%621% Whitea39%637%a32%@ Black or African American, not Hispanic/Latino/ White, not Hispanic or Latino39%638%640%633%6DNC321-7 Annual examinations for oral and pharyngeal= cancers - Adults (age adjusted, aged 40 years and over)13%7DSU712%77%714%6%a,76%715%a12%5%10%121-8a Dental sealants - Children (aged 8 years)23%132%a,2,363%3,520%329%24%521-8b Dental sealants - Adolescents (aged 14 years)a,2,346%110%a,319%921-9 Community water fluoridation - Proportion of U.S. population served199262%66%67%69%75%< Education level (persons aged 25 years and over) and over)199656%a,335%31%a,341%40%55%38%327%47%46%350%a44%a60%37%* Children aged 2 to 17 years49%: Children at first school experience (aged 5 years)= Children, adolescents, and young adults aged 21 to 19 years;<200% of poverty levela26%, Adults aged 18 years and over, Adults aged 65 years and over4 Dentate adults aged 18 years and over* Edentate adults 18 and over> Adults aged 18 years and over with disabilities% long-term care facilities1997319%' youth (aged under 19 years)b66%a,333%a20%36%/ component - Dental sealants [New]2001-02+ component - Dental care [New] componentsa52%53%57%70%b75%; cleft lip or palate (number of States and D.C.)a163251/ systems (number of States and D.C.)- Craniofacial surveillance systems03941987 DATA ISSUESa Baseline revisedb Target revised1 1999-2004 data.!2 Data are for IHS service areas.p3 Respondents were asked to select one race category;selection of more than one race category was not an option.4 Data are for California.5 Data are for Hawaii.6 1996-2000 data.k7 Respondents were asked to select one or more races and identify one race as best representing their race. Objective/number DATA SOURCE21-1a #1,#3,#5-#22<# :X National Health and Nutrition Examination Survey (NHANES), ob, NCHS.N #2 Oral Health Survey of Native Americans, 1999-2000, IHS.e #4 California Oral Health Needs Assessment of Children, Dental Health Foundation, 1993-94.21-1b #1,#3,#6-#23:e #5 Hawai'i Children's Oral Health Assessment, 1999, State of Hawaii Department of Health.21-1c #1,#3,#5-#22:21-2a #1,#3,#5-#22:21-2b #1,#3,#6-#23:21-2c #1,#3,#5-#22:21-2d #1,#3-#22:21-3 #1,#3-#22:21-4 #1,#3-#22:21-5a #1,#3-#22:21-5b #1,#3-#22:T21-6 Surveillance, Epidemiology, and End Results (SEER) Program, NIH, NCI.B21-7 National Health Interview Survey (NHIS), ob, NCHS.21-8a #1,#3,#4,#6-#23:21-8b #1,#3-#22:521-9 ob Fluoridation Census, ob, NCCDPHP.<21-10 Medical Expenditure Panel Survey (MEPS), AHRQ.=21-11 National Nursing Home Survey (NNHS), ob, NCHS.<21-12 Medical Expenditure Panel Survey (MEPS), AHRQ.\21-13a School-Based Health Care Census, National Assembly of School Based Health Care.\21-13b School-Based Health Care Census, National Assembly of School Based Health Care.921-14 HRSA, Bureau of Primary Health Care (BPHC).D21-15 Association of State and Territorial Dental Directors.D21-16 Association of State and Territorial Dental Directors.C21-17a Association of State and Territorial Dental Directors.<21-17b Indian Health Service, Division of Oral Health.J Black or African American only, not Hispanic or LatinoH 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 Baseline 199819992000 2001200220032004 2005200620072010 #10#11#12#13#14#15#16#17#18#19#20#21#22#23821-10 Annual dental visits (age adjusted, aged 2 years 821-11 Use of oral health care system by residents in 821-12 Annual preventive dental services for low-income 821-13a School-based health centers with oral health Focus Area 21: Oral Health / public health professionals [New]; directed by public health professionals [New] j  ( r 0 rH=!c" A a   W  <*UFI]h_]!0 r $~!"EC"":|$%S%z&'V( *+M-k/p1>2\ 2 +3I _3} 3 cc  d;Y"v*2:BJR$ZAb^j{rz ),37<<<  dMbP?_*+%;8&R&"Arial,Regular"&9FA21 Oral Health Data Table Page &P&?'?)?M\\FNCH-HVL-APP1.cdc.gov\PR-DE1S od,,LetterPRIV0''''\KhC]J "d,,??U} 2} } } } } }  } } } ?8 @ @@ @@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ *"++++++++++++++ & ' ' ' ' ' ' ' '  '  '  '  '  ' ' ( ) ) ) ) ) ) ) )  )  )  )  )  ) )                                                                                                                           ! "            $ %  &       '     ) *  +            - .  +            0 1  &       '     3 4  &         '        6   &         '        8   9         '        ;   <         =        ?   @                    A         B        D   E         F        H                    J   K         L        N            B        O                    Q   R                 T                    V   W                 Y                    [   @                 ]   @                                    D"l4 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@ ^               !_ ! ! !` ! ! ! ! ! !  ! a !  !  !  !b " " " " " " " " " "  "  "  "  "  " # # # #c # # # # # #  #  #  #  #  #b $ $ $ $ $ $ $ $ $ $  $  $  $  $  $b % % %! %d % % % % % %  %  %  %  %  %b &$ &% & &e & & & & & &  &  &  &  &  &b ') '* ' '+ ' ' ' ' ' '  '  '  '  '  'b (- (. ( (+ ( ( ( ( ( (  (  (  (  (  (b )0 )1 ) )& ) ) ) ) ) )  ) ' )  )  )  )b *3 *4 * *& * * * * * *  * ' *  *  *  *b +6 + + +& + + + + + +  + ' +  +  +  +b ,8 , , ,9 , , , , , ,  , ' ,  ,  ,  ,b -; - - -f - - - - - -  - g -  -  -  -b .? . . .h . . . . . .  .  .  .  .  .b / / / /i / / / / / /  / j /  /  /  /b 0D 0 0 0k 0 0 0 0 0 0  0 l 0  0  0  0b 1H 1 1 1 1 1 1 1 1 1  1  1  1  1  1 2J 2 2 2m 2 2 2 2 2 2  2 n 2  2  2  2b 3N 3 3 3o 3 3 3 3 3 3  3 j 3  3  3  3b 4O 4 4 4 4 4 4 4 4 4  4  4  4  4  4 5Q 5 5 5p 5 5 5 5 5 5  5  5  5  5  5b 6T 6 6 6` 6 6 6 6 6 6  6  6  6  6  6b 7V 7 7 7q 7 7 7 7 7 7  7  7  7  7  7b 8Y 8 8 8 8 8 8 8 8 8  8  8  8  8  8 9[ 9 9 9@ 9 9 9 9 9 9  9  9  9  9  9b :] : : :@ : : : : : :  :  :  :  :  :b ;s ; ; ; ; ; ; ; ; ;  ;  ;  ;  ;  ; <u < < <v < < < < < <  <  <  <  <  <b = = = = = = = = = =  =  =  =  =  = >w > > > > > > > > >  >  >  >  >  > ?x ? ? ?y ? ? ? ? ? ?  ? j ?  ?  ?  ?zDl@@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  A  A  Az B B B B B B B B B B  B  B  B  B  Bz C C C! C| C C C C C C  C  C  C  C  Cz D$ D% D D& D D D D D D  D ' D  D  D  Dz E) E* E E+ E E E E E E  E  E  E  E  Ez F- F. F F+ F F F F F F  F  F  F  F  Fz G0 G1 G G& G G G G G G  G ' G  G  G  Gz H3 H4 H H& H H H H H H  H ' H  H  H  Hz I6 I I I& I I I I I I  I ' I  I  I  Iz J8 J J J9 J J J J J J  J ' J  J  J  Jz K; K K Kf K K K K K K  K } K  K  K  Kz L? L L L~ L L L L L L  L  L  L  L  Lz M M M M M M M M M M  M a M  M  M  Mz ND N N N N N N N N N  N j N  N  N  Nz OH O O O O O O O O O  O  O  O  O  O PJ P P P P P P P P P  P  P  P  P  Pz QN Q Q Qv Q Q Q Q Q Q  Q a Q  Q  Q  Qz RO R R R R R R R R R  R  R  R  R  R SQ S S S S S S S S S  S  S  S  S  Sz TT T T T T T T T T T  T  T  T  T  Tz UV U U Uy U U U U U U  U  U  U  U  Uz VY V V V V V V V V V  V  V  V  V  V W[ W W W@ W W W W W W  W  W  W  W  Wz X] X X X@ X X X X X X  X  X  X  X  Xz Y Y Y Y Y Y Y Y Y Y  Y  Y  Y  Y  Y Z Z Z 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* a a+ a a a a a a  a  a  a  a  a b- b. b b+ b b b b b b  b  b  b  b  b c0 c1 c c& c c c c c c  c ' c  c  c  c d3 d4 d d& d d d d d d  d ' d  d  d  d e6 e e e& e e e e e e  e ' e  e  e  e f8 f f f9 f f f f f f  f ' f  f  f  f g; g g g g g g g g g  g  g  g  g  g h? h h h~ h h h h h h  h  h  h  h  h i i i i i i i i i i  i F i  i  i  i jD j j j j j j j j j  j  j  j  j  j kH k k k k k k k k k  k  k  k  k  k lJ l l l l l l l l l  l  l  l  l  l mN m m m m m m m m m  m F m  m  m  m nO n n n n n n n n n  n  n  n  n  n oQ o o o o o o o o o  o  o  o  o  o pT p p p p p p p p p  p  p  p  p  p qV q q q q q q q q q  q  q  q  q  q rY r r r r r r r r r  r  r  r  r  r s[ s s s@ s s s s s s  s  s  s  s  s t] t t t@ t t t t t t  t  t  t  t  t u u u u u u u u u u  u  u  u  u  u v v v v v v v v v v  v  v  v  v  v w_ w w w w w w w w w  w  w  w  w  w x x x x x x x x x x  x  x  x  x  x y y y y y y y y y y  y  y  y  y  y z z z z z z z z z z  z  z  z  z  z { { {! { { { { { { {  {  {  {  {  { |$ |% | | | | | | | |  |  |  |  |  | }) }* } } } } } } } }  }  }  }  }  } ~- ~. ~ ~ ~ ~ ~ ~ ~ ~  ~  ~  ~  ~  ~ 0 1  &         '       Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 3 4  &       '     6   &       '     8   9       '     ;               ?   ~                           D               H               J               N               O               Q               T               V               Y               [   @             ]   @            s               u                                             x                                                              ! |            $ %  &       '     ) *  +            - .  +            0 1  &       '     3 4  &       '     6   &       '    Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 8   9       '     ;          L     ?   ~                           D               H               J               N               O               Q   R            T               V               Y               [   @            ]   @                                                                                                                '     $ %         '     ) *  +            - .  +            0 1  &       '     3 4  &       '     6   &       '     8   9       '     ;               ?   @                          Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ D               H               J               N   R            O               Q   z            T          =     V               Y               [   @            ]   @                                                                                          9               &       '     # %  &       '     ( *  +            , .  +            / 1  &       '     2 4  &       '     5   &       '     7   9       '     :               >   @               W            C   <            G               I               M              Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@                P          F     S               U               X               Z   @            \   @                                                                           +                                     '     # %         '     ( *  +            , .  +            / 1  &       '     2 4  &       '     5   &       '     7          '     :               >   ~                      B     C               G               I          B     M                              P               S          B     U              Dl@@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ X                    Z   ~                 \   ~                                                                                                                                            &                 $ %  &                 ) *  +                 - .  +                 0 1  &                 3 4  &                 6   &                 8   9                 ;                    ?   @                                     D                    H                    J                    N   `                                     Q   v                 T   `                 V   b                 Y                    [   @                 ]   @                                    Dl @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@                     ! ! ! ! ! ! ! ! ! !  !  !  !  !  ! " " " " " " " " " "  "  "  "  "  " # # # # # # # # # #  # ' #  #  #  # $ $ $ $ $ $ $ $ $ $  $  $  $  $  $ % % % %& % % % % % %  % ' %  %  %  % &$ &% & && & & & & & &  & ' &  &  &  & ') '* ' '+ ' ' ' ' ' '  '  '  '  '  ' (- (. ( (+ ( ( ( ( ( (  (  (  (  (  ( )0 )1 ) )& ) ) ) ) ) )  ) ' )  )  )  ) *3 *4 * *& * * * * * *  * ' *  *  *  * +6 + + +& + + + + + +  + ' +  +  +  + ,8 , , ,9 , , , , , ,  , ' ,  ,  ,  , -; - - - - - - - - -  -  -  -  -  - .? . . .@ . . . . . .  .  .  .  .  . / / / / / / / / / /  /  /  /  /  / 0D 0 0 0 0 0 0 0 0 0  0  0  0  0  0 1H 1 1 1 1 1 1 1 1 1  1  1  1  1  1 2J 2 2 2 2 2 2 2 2 2  2  2  2  2  2 3N 3 3 3R 3 3 3 3 3 3  3 F 3  3  3  3 4 4 4 4 4 4 4 4 4 4  4  4  4  4  4 5Q 5 5 5 5 5 5 5 5 5  5  5  5  5  5 6T 6 6 6 6 6 6 6 6 6  6  6  6  6  6 7V 7 7 7 7 7 7 7 7 7  7  7  7  7  7 8Y 8 8 8 8 8 8 8 8 8  8  8  8  8  8 9[ 9 9 9@ 9 9 9 9 9 9  9  9  9  9  9 :] : : :@ : : : : : :  :  :  :  :  : ; ; ; ; ; ; ; ; ; ;  ;  ;  ;  ;  ; < < < < < < < < < <  <  <  <  <  < = = = = = = = = = =  =  =  =  =  = > > > > > > > > > >  >  >  >  >  > ? ? ? ? ? ? ? ? ? ?  ?  ?  ?  ?  ?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  A  A  A B B B B B B B B B B  B  B  B  B  B C C C C C C C C C C  C  C  C  C  C D7 D D D D D D D D D  D  D  D  D  D E> E E E E E E E E E  E  E  E  E  E F F F F F F F F F F  F  F  F  F  F G G G G G G G G G G  G  G  G  G  G HG H H H H H H H H H  H  H  H  H  H II I I I I I I I I I  I  I  I  I  I JM J J J J J J J J J  J  J  J  J  J K K K K K K K K K K  K  K  K  K  K LP L L L& L L L L L L  L  L  L  L  L MS M M M& M M M M M M  M  M  M  M  M NU N N N& N N N N N N  N  N  N  N  N OX O O O O O O O O O  O  O  O  O  O PZ P P P& P P P P P P  P  P  P  P  P Q\ Q Q Q& Q Q Q Q Q Q  Q  Q  Q  Q  Q R R R R R R R R R R  R  R  R  R  R S S S S S S S S S S  S  S  S  S  S T T T T T T T T T T  T  T  T  T  T U U U U U U U U U U  U  U  U  U  U V V V V V V V V V V  V  V  V  V  V W W W W W W W W W W  W  W  W  W  W X X X X X X X X X X  X  X  X  X  X Y Y Y Y Y Y Y Y Y Y  Y  Y  Y  Y  Y Z# Z Z Z Z Z Z Z Z Z  Z  Z  Z  Z  Z [( [ [ [ [ [ [ [ [ [  [  [  [  [  [ \, \ \ \  \ \ \ \ \ \  \  \  \  \  \ ]/ ] ] ]& ] ] ] ] ] ]  ]  ]  ]  ]  ] ^2 ^ ^ ^& ^ ^ ^ ^ ^ ^  ^  ^  ^  ^  ^ _5 _ _ _& _ _ _ _ _ _  _  _  _  _  _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@{@|@}@~@@ `7 ` ` `  ` ` ` ` ` `  `  `  `  `  ` a> a a a a a a a a a  a  a  a  a  a b b b b  b b b b b b  b  b  b  b  b cC c c c  c c c c c c  c  c  c  c  c dG d d d d d d d d d  d  d  d  d  d eI e e e e e e e e e  e  e  e  e  e fM f f f  f f f f f f  f  f  f  f  f g g g g g g g g g g  g  g  g  g  g hP h h h h h h h h h  h  h  h  h  h iS i i i i i i i i i  i  i  i  i  i jU j j jK j j j j j j  j  j  j  j  j k k k k k k k k k k  k  k  k  k  k l l l l l l l l l l  l  l  l  l  lo m m m m m m m m m m  m  m  m  m  m n n n n n n n n n n  n ' n  n  n  no o o o o9 o o o o o o  o  o  o  o  oo p p p p& p p p p p p  p ' p  p  p  po q$ q% q q q q q q q q  q ' q  q  q  qo r) r* r r+ r r r r r r  r  r  r  r  ro s- s. s s+ s s s s s s  s  s  s  s  so t0 t1 t t& t t t t t t  t ' t  t  t  to u3 u4 u u& u u u u u u  u ' u  u  u  uo v6 v v v& v v v v v v  v ' v  v  v  vo w8 w w w9 w w w w w w  w ' w  w  w  wo x; x x x x x x x x x  x  x  x  x  xo y? y y y@ y y y y y y  y  y  y  y  yo z z z z z z z z z z  z  z  z  z  zo {D { { { { { { { { {  {  {  {  {  {o |H | | | | | | | | |  |  |  |  |  | }J } } } } } } } } }  }  }  }  }  }o ~N ~ ~ ~ ~ ~ ~ ~ ~ ~  ~  ~  ~  ~  ~o O                   Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Q                   o T                   o V                   o Y                    [   ~                o ]   ~                o s                    u                   o                                 L       o                                 '       o                    o    &         '       o $ %  &         '       o ) *  +                o - .  +                o 0 1  &         '       o 3 4  &         '       o 6   &         '       o 8   9         '       o ;                   o ?   @                o                    o D                   o H                    J                   o N                   o O                    Q                   o T                   o V                   oDl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Y                    [   @                o ]   @                o                                                      !    !   "                        &   &  &    &    &   "    &   &  &    &    &   "    &         !"-7&'()*+,.2/013:4568J9;?<=>@EABCDFMGHIKLNYOPQRSTUVWX[x]^_`abcdefghijklmnopqrstuvZyz{|}~&  &    &    &   "    &   &  &    &    &   "    &   &  &    &    &   " 7   &   &  &    &    &   " >   &   &  &    &    &   "    &   &  &    &    &   "    &   &  &    &    &   " G                    I   &   &  &    &    &   " M   &   &  &    &    &   " #                    P   &   &  &    &    &   " S   &   &  &    &    &   " U   &   &  &    &    &   " X                    Z   &   &  &    &    &   " \   &   &  &    &    &   "                                         $  %                 &                       % '     (           &   % )     *           &Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@   %                 & #  %      +    ,       & (  % -                & ,  %      .    .       & /  %                 & 2  %      @    @       & 5  %      @    @       & 7  %          R       & >  % /     .    .       &   %                 & C  % 0     z    o       & G                    I  % .                & M  %                 & #                    P  %                 & S  % 1     b           & U  % 2     v           & X                    Z  % *     3           & \  %      /    /       & r                    4  %      5    `        6                    7  %      o    +        t  % v     +            8                    9  % :         (        ;  % q     q    b        <  %      b    q        =  % z     .    /        >  %                 Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ ?  % ,                                                         @  A K                                       A h                   A h                   A &                 #  A &                 (  A                  ,  A B                 /  A &                 2  A &                 5  A &                 7  A                  >  A @                   A                  C  A B                 G                    I  A                  M  A                  #                    P  A @                 S  A @                 U  A @                 X                    Z  A @                 \  A @                                                         C  %      R    (       D                    Dl@@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@   %      ,           D   % E         (       D   % &     9    (       D #  % &     9    9       D (  %                 D ,  %                 D /  % 9                D 2  % &     @    @       D 5  % &     @    @       D 7  % F                D >  %                 D   %          R       D C  %          G       D G                    I  %          (       D M  %          (       D                                         H  I W                                                         J  I                                                          K  A L M  N v y      !  O   P                                         Q   R             S    T                                         U                    V   !W                 TDl @!@"@#@$@%@ &@ '@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@ :@;@ <@=@>@?@                     ! ! ! ! ! ! ! ! ! !  !  !  !  !  ! " " " " X " " " " " "  "  "  " T "  " Y # # # # # # # # # #  #  #  #  #  # $ $ $ $ $ $ $ $ $ $  $  $  $  $  $ % % % %!Z % % % % % %  % ![ % [~ % !$@ %  %!Z &"\"&"""""""""""""" ' ( ) * + , -#] .#^ /#_ 0#` 1#a 2#b 3#c 4#d 5#e 6 7 8 9 :$f":$$$$$$$$$$$$$$ ;%g";%%%%%%%%%%%%%% <h =i >j ?kDJ l444@@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@[@\@]@^@_@ @l Am Bi Cj Dk El Fn Go Hp Ii Jj Kk Ll Mq Ni Oj Pk Ql Rr Si Tj Uk Vl Wn Xo Ys Zi [j \k ]l ^t _iD@l`@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@{@|@}@~@@ `j au bi cj dv ei fj gw hi ij jx ki lj my nz o{ pi qj rn so t| ui vj w} x~ y z { | } ~ D@l@@  D>@   7 Sheet1 Module1{ThisWorkbook*-Sheet1.IModule20  !"#$%&'()*+,-./123456789:<=>?mѷ(< <<<xp@pX@8o recorded 2/18/99 by Thomas C. Socey%H}Ix"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 #Y4A.Ҿ> FxESE 3xME (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$+myxMExp}Ix"Attribute VB_Name = "Module2" "mRxME Module3 ;x__SRP_2M__SRP_3PoModule4R(6 <<< $`@pxJ)Macro recorded 2/19/99 by Thomas C. Socey 14"%Hx}I$*\Rffff*2549087ddf"  ( &B@Ho`XAttribute VB_Name = "Module3" Sub Macro`3() L.Descrip0tiontX recorded 2/19/99 by Thomas C. Soc eyProcDataZInvoke_FuncAZ \n146 Cells.Select End rU~| 0  krU $`an$+m<,xMExp}Ix"Attribute VB_Name = "Module4" $+m=xModule5 ]Module6hModule7sModule8~MExp}Ix"Attribute VB_Name = "Module5" $+mɭxMExp}Ix"Attribute VB_Name = "Module6" $+m!xMExp}Ix"Attribute VB_Name = "Module7" $+m xMExp}Ix"Attribute VB_Name = "Module8" $+muIxMExpModule90Module10)9__SRP_4__SRP_5 "o}Ix"Attribute VB_Name = "Module9" "ZmBxME(6 < << 6`@pXJ )Macro recorded 12/18/2001 by Thomas Socey 144%Hx}I$*\Rffff*2649087ddf "   0( X `%hx Macro7 Macro* Macro recorded 12/18/2001 by Thomas Socey@ 8(:oհAttribute VB_Name = "Module10" Sub Macro7() L.Descri`ptionvX recorded 12/18/2001 by Thomas SoceyPro cDataZInvoke_FuncZ \n146' '!w),  Selec].NumberForma t6@4End  rU~| 0  krU $`nJmwModule11__SRP_6__SRP_7!oModule12xMEP6 <<<< <<< >`@pJ )Macro recorded 12/18/2001 by Thomas Socey 14<%Hx}I$*\Rffff*2749087ddf "   0( X `<Wh Macro8 Macro* Macro recorded 12/18/2001 by Thomas Socey'B'D HF LJN &B@@ssoPH"Attribute VB_Name = "Module11" Sub Macro8() L.Descri`ptionvX recorded 12/18/2001 by Thomas SoceyPro cDataZInvoke_FuncZ \n146' '!w),  Cells.Replace What:="'",  menLookAxlPart, SearchOsr _ &:=xlByRows,NtchCase:=False End rU~| 0  krU $`n$+m8xMExp}Ix$Attribute VB_Name = "Module12" $+mModule13Module14Module15Module16xMExp}Ix$Attribute VB_Name = "Module13" $+mߕxMExp}Ix$Attribute VB_Name = "Module14" $+mFxMExp}Ix$Attribute VB_Name = "Module15" $+m     !"#$%&'()*+,-./0123456789;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[]_abcdefghijklmnpqrstuvwxy{|}~xMExp}Ix$Attribute VB_Name = "Module16" $+mY4xMEModule17Module18 Module19^Module20%:Kxp}Ix$Attribute VB_Name = "Module17" $+mxMExp}Ix$Attribute VB_Name = "Module18" /mKxMEp `@Ib `}I"  , H P`x   0@HPX`hpx   *  d$B@H &here start of superscripting footnotesP 'f fa j%l'h h$B@H j%l!p'n n'r5 n$'t tfn n r $'n 8!vArial9Regular9x!@9z9|9~999 9 9k j!'  G'fjP $here end of superscripting footnoteso%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~ rU~| krU $`nModule21\@__SRP_8\T__SRP_9^gModule22 $`  'A $$ $B@H j!p' $' $'  Objective j!''' a  '  j%l!p' $' $' YearG'j   j%l!p'd  j%l!'  j%l!'kkx0 end for First, find the row which as the titles'''t''  ''''''''' a' aA $$ $B@H j!p' $' $-----' j!'''k  $' $' -  ( found a new objective $'# looking for a measure '  2mxME(6 << <x `++p%H@}I$*\Rffff*2849087ddf+" 8 .P $  0 HX` h x     0  (H hpx 6  (0 8H P$`        882p  0 H Xx   .  @ P` h p *x 2  8 HXh x     0@HPX`hpxZ    ( 0 8 @ H  P ` p                ( 8 H  P ` p x        $     8  H X  p  :        0 H  `  p 0    (@HPXpx *  (08@ H P4`        (8@ H>P 0(08H`hpx *  (08@HPX` h p4*H Xhx  6  8 @<P  >  B0x         ( 8 H Xh   (08@PZh  0HX`h x     08@HPX`x $   0 @ :P           0(@h(08@ H*X  4Ph*  (08@HPX`h    0 @ X x         !!!! !*0!`! p!!!!!!!!!!! ! !4!("@"`"x"*"" """""#### #(# 0# 8#6X## # #<#$ $ $>0$p$ $ $B$$ % % % %  % (% 0%8% .@%p% x% %%% %%% % & & &8&H& h& x&&&&&&&&&&&&&'Z '''''''''' '''((( ( 0(@(H( X(h(p(x( (( ((( ((((())))0) @)$P)x) ))) )) ) ) $* 0* @* P* <p*"** ***+ + +  + 0+ @+ P+0`+++++++, ,(,0,8,P,X,`,h, p,*,, ,,,,,,---- - (- 0-4@-x----*-. .(.8.@.H.P.X.`.h.p.x. . .6.. . /</P/ h/ p/>// / /B/80 P0 X0 `0 h0 p0 x00000  00000 0$1 (181H1X1 x1 1 $1 1 1 1 2(202 H2P22X2 $2 2 2 2 2 2 3 ( 3 $H3 @p3 83 3 3 4 B4 (X4 24 4 4 44444445 55(5@5 X5 `5 h5p5x5 5 5 5555 5 5 6 6  6 (6 06 86 @6 H6 P6X6`6h6 6 6666666D6$@7 h7 x777 77"77788 8(80888@8H8P8"X8888888888888899  9(9 09 @9 X9 p999999 9 :(: 0:8:@:X:p:x::::: 2: <: 0; @;P; `; h;;; ; ; ;; ;;;<<<0< @<P<X<h<p< x< <<<< < < *< == =  =(= 0= $8= 0`== =====>> >0>8>P>`>h>>> > >>>>>>>h>LP? ?@?&@(@ @@ 0H@&x@@ @ @@@@@@@A $(APAXA`AhApAxAAAA A A8ABB0BHBPBXB`BhBBBBBBB BBBCCCC C(C0C8C@C  HCDXCCCC CCCCCCCDD0DHD`DxDDDDDDDDDDDDD  D6E8E6PEE 2E 6EF(F6HFFFFFFGG0GHGXGxGGGGGGGGG GG HH H0HPHXH pHH<HH HI I I(I0I8I@IHIPIXI`IhI >pII II I (` ,DATA2010 In-house processing --- Please wait (( First find the row which has the titles''''''' a$tG'j ' $' $' $' $'    $'d'kp 0 0 0G 'j 0  0 no measure'  'd 0     ' ''kk       j(pkP j!'' a find where objective title ends' a j%l!'b b$B@H j!p' $' $' '  j(p  $'t t*   $'  j(p 8!vArial9Regular9x!@9z9|9~999 9 9qd letter2 $' < D N - #''''''''' a  '  $' -'dX $$'d0 ..''d %%'d  0 'd  0 'kkkxkpkhk`  G'j stop5       8(:k  hdashk notk letter 2k celllen j!'  G'j stop4  'A $$ $B@H- goto next line j!p' $' ' $' '   '  $' $' 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:''kxkp       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pkHk@ j%l!' '  $!v(  $-----' j!'''kd 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:''kXkP       j%!vArial9Bold9x#@9z9|9~999 9 9q k d   j(p> add 7 to 15  j!p j(p j!p$' STATE: j!p'   j%!vArial9Bold9x#@9z9|9~999 9 9qH k@ d8     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(pkh k` kX kP kH k@ ' a j%l!'b b$B@H j!p' $' $' '  j(p  $'t t*   $'  j(p 8!vArial9Regular9x!@9z9|9~999 9 9qd letter2 $' < D N - #''''''''' a  '  $' -'d $$'dp ..''d@ %%'d  0 'd  0 'kkkkkk  G'j stop5       8(:k  hdashk notk letter 2k celllen j!'  G'j stop4  'A $$ $B@H1 goto next line 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:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(pA add 7 to 15  j!p j(p j!p$' STATE: j!p'   j%!vArial9Bold9x#@9z9|9~999 9 9qkkk 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 9q0k(d    j(p> add 7 to 15  j!p j(p j!p$' STATE: j!p'   j%!vArial9Bold9x#@9z9|9~999 9 9qkd     j(p@ add 9 to 18  j!p j(pdP    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pdp    j(pI add 15 to 27  j!p j(pkkkkkkkk% until stop3 - end of objective titled' a j%l!'b b$B@H j!p' $' $' '  j(p  $'t t*   $'  j(p 8!vArial9Regular9x!@9z9|9~999 9 9qd letter2 $' < D N - #''''''''' a  '  $' -'d $$'d ..''d %%'d`  0 'd8  0 'kkkkkk  G'j stop5       8(:k  hdashk notk letter 2k celllen j!'  G'j stop4  'A $$ $B@H j!p' $' j%l!p' $-----   $-----' j!'k''k ' $' '   '   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(p j!p$' STATE: j!p'   j%!vArial9Bold9x#@9z9|9~999 9 9qkdx     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(pkkkkkkkxkp until stop2 until stop1=1 '' '' aA $$ $B@H j!p' $' $' j%l!p' $-----  8B@A $$ $B@H j!p' $' $' j%l!p'k  '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@Hk@ k8  8 "9  &9$9(9*9,9.90q 8 4 8%2(6 8 : 8%2(6 < 8%2 >96 B9@ 9q  D 8%2 >96 B9@ 9qP 8 F 8%2(6 8 H 8%2(6 8!vArial9 Bold Italic9x 9z9|9~999 9 9q d   '  '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'Jk L G'Jjkd  $' $'Z ' $' $' $' $' $'    $'d'k'\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 ^ '^'bk`kX 0 ^ '^  # no measure'  ' \ '\d     ' '' \ '\kkd 0 \ '\ ^ '^'`k8k0       j(p j!p'd'b'`k' Z G ^ '^j - is not a continuation line j!p \$'d ^ 'fd( ^ ` 'fd ^ ` 'fd ^ ` 'fd ^ ` 'fdh ^ 'fk@k8k0k(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(pd? -" is a continuation line 'd, 19 d j!p j(pk@?k8?k0?k(?k ?k?  ' until stop1=1k continuesw = 1A $$ $B@H 8 &9  &9$9(9*9,9.90qh>  'j G j 'jjA j $$ :  $B@H 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!vArial9Italic9x 9z9|9~999 9 9q< l!n$ j $$ : $ $$ 9p9rqP< l!n(t l!n9v9x9z9|9~9? %9? %9 %9 %9? %9? %999 999 9*9 9 99d9q; ' j$$: j$$ $B@H  8B@ $$: $$ $B@H  8B@, This section will bold the objective titles0 See if a focus area or Leading Health IndicatorA2$B@H j!p$' Focus Leadi Steps j!$!v(  j!$!v(z1:1$B@H  8B@2:2$B@H  8B@1.1$B@H0@ 8(  '  $1 'A1:  $B@H 8 "9  &9$9(9*9,9.q(8 8B@A1$B@H j!p' $' $'  - Z j(pd7A1:L1$B@H 8B@A1$B@H*--- D A T A 2 0 1 0 --- In-house System - Z j(pA1:A3$B@H 8!vArial9Bold9x 9z9|9~999 9 9q6k68 end for See if a focus area or Leading Health IndicatorR1C1 B@Processing complete (o66Attribute VB_Name = "Module21" Sub Numeric() Application.DisplayAlertsAlFalse DStatusBarDATA2010 In-house processing --@- Pleawaity' First find the row which hastitles cvalu7on(= 0 oncolz max stop1havey&eObjDo Until p1 /+  Range("A" + Trim(Str())).Sele ct VActiveCell.V_ "=R If "Obj7." Then,]o=Row:@ A2J@E@ \G) Offset(0,)C ߏ>GIY~CH@Ɓ3J " Aۗ.1/M"_!NEF FYL`Columzendaddr#]AFA"EIffLoop #' for #v,Qv,v dh"$ lette/wa#"spac|o#Z+ 3ntxCX@this~be`!af@diffco ~ nuesw ped~dYd!0ehJ^WMid(# , 1, 5)"--Tj ka!IIA![K `e0+ E 3`bCE)~7+ cNxK ) ' Xu^a pnew KC_ U 6 `looFkء`a murAaW @[ "E]eALend9!A+ =1LjI2, 2L3!)4;4,5+ >= 7 @ > @l -0)wnPu!A#Q"0" Or Zp!d #g! CK#no _4c" Not ( )1 qqerw ZR@/ C2Lp$!1`q2t>3t'  startlobX>mE@_r @Z1@!wherew@ ¦nqA!Ha(81currc ЄydK$bOd _o`?gi lenoK!3 )/%> b$erNP4"*p׵KT -   Withv 1F.ArialE2 .StylRegularC.Sizq8,.5O".`ikethrougD\.Supe@rscripTruqbv/.OutlineQ `%Sha2d = _XUnder!xl"Non .(orIxAutompcJߑ]B2My',sR0-aA"<")2D̴ = "N") And Not T(c-#DT@hen h@dollar~"Lperiod!Lcent'bzeProes&a#&psw$0rash1cntH#stop5#Do Until 1K ;(+ 1)AletteMid(cvalu(e, ,If F"-" \C hdCN\1Else.J$fF$*l .e .\ !CJIj%h*eo%%57jD 'z%+ "0d*'% EIfW   @n= celllenb( Loop 'C# 04 Selection.NumberFor,mať+H+ h$o+ G9aa\X#`noto2M+Othiscol"A veC 0.Cpolum(max/4`,34onropsdRange("A" + Trim(Str(ar))).c goto nextp lin9sf Vwg&Rlb efore Le>ntk.af3odiffp2(- hoVl s1r0,2{@<6(0t p"@Race apCethnicity9Or"y!Mother's r ) Gender.Worksite onl "Class atd1 "STpATE:,5:) -O (head of house!)`t7A! h1?$aD*d!' @add 5 )18 =spa+'+] p"3, y Y3@ _15_startaon[/ *@% ? 19@A 18AA92?q2vtY 3p > j With)#Cha;MGs S:=C, gth:=(10 2 -TFone.NamO"Arial!StylrBPK#oaSiz9."5_ .]ik!`Iroug1Fa`u vscrip1xRrb_f.OutQcA `1.Shadwrj/%UPxlNoi`QuorIxRAutoicO#$M852 }:0 "GN7N_>L = addspace + ActiveCell.Value  End IfLstoploc(Offset(-1, 0).AddressV) 9371 Range(sta$rtW, `).Font.Bold3Tr If @Mid(cv, x5)("-" Then guc(inuesw C 03RWithICharacters(Sa:=, 1@gth:=(`24 -7)Ã" .NameA\Ar0ial"RAStbyi= "ASDiz! 9.5Strikethrough Fa`z 3upcriptbsOut hadb`Under xlb#Nonlġ>,ColorI xAutomaticQDA=oG]I8TI7: ?"7927mOO B1gB  11! t`Q_CRP/ / @_ 3R 41_s_ X 2$Q_ R b27 oЅ?3P& 1q 4 Do U ntil op1 currc%H40&  ).Sel`=.Trim_ fR!5 @o @je$ )%letaǣ "*OGU7Y2,  -PW V 2Selection.Font .Name = "Arial"!StylTRe gularXSi"zN8.5NStrikethrough}False,uperscript*Tru )b'ROutlinej>hadowUnder3)xlNonXColorIxAutomaticEnd WithE ' lette,r2cMid(cvalue(, 1) If@ Not ( "`<") A@GDUNNN-N#@Then)hdo6l*"@ hiod cenbzeroeJsa ps0Z9ascnt$stop5-Do Untitl 1@+(+ 16D0 dN`)KaKC@L#V0"-" + #%g+ 5./  Vno0R.~othiscol A@veCr.umx>maxY40E4onrғsdRange("A" + Tr(im(()) ).`goto next 1+[ӌ{ VouaRrSmbefor1LenTOyaf0?d(iff(- chol0od2|6l`1 "Race anicitry`Or!Mother's r) Ge.Worksit`e onlT " Classatdq "STATE:l5) -O (head of house!)`_qt7D 4?"'a-$#' 1O addsp+.[-@3, Un3 _5_QsptartanA1 *% /r@ 19@fA 18OA92/q2yt\ P> m'#l.Characters(Sta rt:=s03, Length:=(len2 - 3)).Fo nt .Name = "A`rial"DvStylNBoldLSiz!9.5EStriket@hroughqFalse)up cript'bsOutlineb&hadow`Under&xFlNonfColorIxAutomatic}End With If QIf diff8 Then ActiveCell.ValuBẇ" + cv' add 7 to 1x  spaceM$ h@2,Mid(M ,, 6)O :"STATE:"<=NN b5212:0?t?n=.SnAn .n.SnnB .n?nm tpst`oplocZ)NOffset(-G0).Address0P3`1^Range( l,  #.T|ru@fal{ k, 5)"-gc`inuesP*pedrxRowOa~ 1 3En ~7 F52 ( ϑQ!/Sue/S0?႟Sc+ % oYu9 19 @D 18?A9]2&q2 ?_(sp > 0)C_gϞϞϞhϞ>g}.Ϟ).ggOg g_TgG.gϞg?Ϟ&A"Ϟ# ?.$OOI "  N&A@JJG @D:d  - /6/6Ԑ/6T/6ԣ/6/6/6?/6_U/6V/6/6/6/6/66 6 Al69 Or (beforq1)[77`N9BmAsp;ace + ActiveCell.Value " Els DIf diff = 10 Then `v T""~cvt ' add 11 to L21!R/sp>1 letter2Mid)a)o# "*"GSlJ# 2, -?`5  eWith #9ion.Font .Name"Ar0ial"!StylBRegulDarSiz8.5 StrikethroughFan.Superscript@Tr)bZ Outlinehadow`UnderA xlB&Non'@ColorIxAutomatic'!;ቀP`c` Y`Z Not ("<") A0MDN-#achdol% "&h0!iodo'acen#bzeroesw8ao ps#\hdasǁ/?gcnt /'Aa5@ ?7&d/d(r+H R0%R}"-_S_ vF[ "$)$)*./.-(z {m % 7% :/ d5u=+ "0oofCo. ??????????RE=`RQLo*'d2LmvU"'NumberForwAu>+ #7+ 5./ y 9Vno~ 2mothis8col um_Ymaxc}ol Then stop4 = 1 Loop 't donr,ow+ pRange("A" + Trim(Str(V))).@Select c valueQActiveCelll.V&RV5)#2 KOffset(1, 0)XIf (Mid(I(, 5)!"-") Or  " And 4"D,continueś,pedňRowDEXIf 0;1;QbeforpLenJe@nafterC@diff(yD- B \ 7<͘@"DTv@add 5 `to 12! sppace@ hold^AM p3, 66'A 3 ,T 5S start 0!len7?2 0 /E"STATE:"30919/18Else!ۿ2^2%iG > 0!With h,Chahracas@7:=, 1gth:=( $2 - %F" .Nams"Arial"RaStylBRSiz1!9.5ikethroughTFa4@Superscriptb.Outline hadUnder  xlb#NonNColorI xAutomatic$DA=oG]I8SIt@w`[7MO ?Mz #@JueMJb _D`/20=11( Jo6m62-6206#6.6 q16.66.6+p6I6W.S6y.66< .66E65 5592v1)6?2 6`.79"7m/7߱Ӂ 1gB  11! sIl"H_C_CR( 1A/ / @_ 3R 48_s_ X 2_ Q_ R B27 օ?3P& 1:u`NlB>1=  GsourcSÝissT}C="2CDo U:ET=>3O ѻ%{Halue If Mid(cv, 1, 5@) = "-"` ThenSelection.Dte Shift:=xlUpLRange("A" + Trim(Str(onrow)))./.|uA[veCell.V yW#O )CR 2 eOffset( z0) 9End If0@"" >A' st(op141Els"DATA ISSUES`" Or 3 SOURCE")  , l6Len(endaddress) - (@X;T@ sourcesw EntireRow.Inser>tC {"ObjAve" @+.@6dGµl)P mU1numberA~"@ $o)5":@ !JZPYiss~u=!#? ??;(FB_(k/Wit h ` .HorizontalAlignmentxlLefK-dVficmC ero WrapTex Fab.Ori`a0OAddInd`tShri@nkToFi Mergbs 'a%G'Borders(xlDiagonalDown).LineStyle` xlNo*nƪ G..Up{k6EdgeT\opI(C9i nuous).Weigha$xlM ediumCo(lor-xAutom@3c$ZBot@ & 3D# . d ' /xl`ide-OGg4wF .Nam$"Ari4al|g.'"BLol`;ic}S4izA9ikethrough@5 .Sup.pcrip4bsA.Outl1 ?Shadoz .U>rbN:6  } gg(eE0 cPlen ac|.d> _ 0љ6pO lette rcY DoD U@l (U1MT("33 !n, 0Ϗ"\NBF\#`R^ y!P ,-G  u/3 > OTFormulaR1C!ttos"ΟH/$sd&6T,!o,4hDe- U BOHCharac-sar gth:=N?  RkSReZgr,S*.S.5.TOyUTriVfOW7F.X_}XeYX?z Դ End Wipth 0p ActiveCell.Characters(Start:=sdselect, Length:=De").Font .Name = "Aria l")IStyl.Regular0Siz+9.5VStriket@hroughDFalseup} cript#bs&Outlineu-hadow`Under-xFlFSNon= 7%A7, l - 5h/"|m6`?p`!%7 '@normalG0n0umpc05 ' seconda(0!  iaam.iA#@5! "0" Or"X!W2dash a digit of first pairH"3space D4 Nz(f+S >NHot @ttD&)oJ $g+ :KmI,, 5? Dd bi" "@4no !urѰ`, w+@ 0nXI137P 0@  !  qek%#uo 3 + 4  o(f V0"O YXa *ars;*E*) Vqi`[1q2t3t4t+rIiR6 p addCK!(tu 43B_@B{"-7is@at a `tinupon ]4|rle N(`3Ld<Ǟ4 A />0^6 ? jrt a5 M  ߽}  1 o n 6h ? `@@4____q U8f2ijlrt49s!mոm:AB;R0()p|0S41 v,bpSG (l812,be Te0h?H?H,II ActiveCell.Value = parPt1 +823 Else @If Not (dh~"-") Then ' is a continuation lin vVqX= "b "E1>9 m  :Enpd If o0nrow+ B16Loopdul stop16= - es Rang e("A"Trim(Str(obj.))).Select Wpith 5. HorizalAlignmen"tGxlCerVerticWrapTexFa{.Oriq= 0BAdd8IndG ShrinkToFiKMergBs AA1 del71: - 1) haveyear1 C O @e))U":AWendaddressUFU.Borders(xlDiagonalDown).LStylxlNoYUp sEdgeTop@B&bCousAe . Weigh`xl@MediumCPolorAnx*x@lAutom ;cCg2A Bot@???-I`nside%\4n?,ch_5pn.F/C.NamaB"Arial"%F"ItalibcSiz.~ikethrougl%Supa@ScripJmbsuOutA`@ had U}~rGG`._9C9$aSheet.PageSPetup(PtTitleRow"$*S|Ũ umnB D3a̅,.Area"" .LeftHea('頪ersR!{S FooteAE sp Margin App0+2`.InchesToPoints(0.75y@"onNooaq 1.cHooj#oo0. nj"aingA&5aGrid!6 1&Comq}xly"No5X-#Lly CS/@*xlLandscap.Draf/H .FirstO1v @vuOv@BlackAndWhitQR!} Zoom10ْ g;25D(Cx gDShift:=xlUJI2r(Cln.!'`sg will bold the ÀMqve t!RB'e ifpfocu1Jor L0G ( (l to𡥓2"W cvMid(-, 1, 1`"F" Or 7B<Steps""+H0әj.B= Tru'՜4u14Q"1:1 &R"2:y 1.?AbH՚16.ql*Len( _Ga-ql"1hS"A1<2G!2kq_TfheDǺ  `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 '  G'j ' $' $' $' $'    $'d'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' $' $' '  j(p8 '  '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%!v`"Arial9Regular9x#@9z9|9~999 9 9qx T X j%!v Arial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - # ''''''''' a  '  $' -'d $$'d` ..''d0 %%'<d  0 'd @' 0 'kkkkkk  G'j stop5 '      8(:k  hdashk not0(k gotsuperP(k celllen j!'  G'j stop4  'A $$ $B@H- goto next line j!p'( $' ' $' '   '  $' $' 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:!x''d STATE:''kk       j%!v Arial9Bold9x#@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 $'X0 j!p$' '' j!p' STATE: ''d STATE: ''k k       j%!vArial9Bold9x1#@9z9|9~999 9 9q k d    j(p> add 7 to 153  j!p j(pdX      j(p@ add 9 to 18  j!p j(pd  4  j(pC add 11 to 21  j!p j(p dp    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'87 $' $' 'x7  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p8 L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q8  j(P9 R j%!vArial9Regular9x#@9z9|9~999 9 9q T X j%!v0:Arial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - # ''''''''' a<  '  $' -'d $$'dx ..'H='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' $' 'xA $' '   '  $' $' Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household) @C  j(p? 12  j!p j(p j!p $'C 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     s7 !"#$%&'()*+,-./012345689:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrvwxyz}~ "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_cT__SRP_d(+gModule27y__SRP_e,Tst find the row which has the titles''''''' a '  'A $$ $B@H j!p' $' $' MeasureX j!''' a  '  j%l!p' $' $' 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@}I$*\Rffff*2;49087ddf:" .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 measureP( 'elllen  G'jG ' $' $' $'o $'p $   $'$d'k 0 0$ 0G 'j 0  0 no measure r'  'd( 0     '  ''kk       j(p k j!'ty (' a find where objective title ends ' add j%l!'b(p 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(p9 L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q   j(P R j%!v  Arial9 Regular9x#@9z9|9~999 9 9qx T X j%!v titleArial9Regular9x#@9z 9|9~999 9 9q'Jk L G'Jj ' $' < D N - # ''''''''' aBold  '  $' -'d $$' d` . .' 'd0 %%'p d  0 'd  0 'kkkkkk  G'j stop5       8(: jk  hdash k not k gotsuper k celllen j!'F  G'j stop4  ' A $$ $B@H- goto next line add j!p' $' ' $' 'h   '  $' $' Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household)N '  j(p; add 5 to 12  j!p j(pj j!p $'L'T j!p$'B@H'' 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_fg_VBA_PROJECT|-dir__SRP_0 rU $`nv0* pHd VBAProject4@j = r }I 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~#h087ddfModule27|XhP`px@ H8(0_LfF,FϪH”H>?"ȴ=Lܻi!'D"H*7F?NGEIA/0V Lh4Q7xJEUG_D[)D% -s٣٧FW6ʱBJ,F<@†i/ 5hNWO+DVCEYSrdJd78H ʏM3Lλk3i8pM^?Vl 04F)_ e͎DVQ[MJK5v4#@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?uay  *\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{D1412978-C637-416D-B88E-9C461FFCD9CA}#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  }I  mModule11e49087ddfModule1mUThisWorkbook0a49087ddcThisWorkbookC % Sheet10c49087ddc Sheet1N 0Module21f49087ddf Module2yHModule32549087ddf"Module3R`Module41h49087ddf(Module4<,xModule51i49087ddf*Module5=Module61j49087ddf,Module6ɭModule71k49087ddf.Module7!Module81l49087ddf0Module8 Module91m49087ddf2Module9uIModule102649087ddf4Module10B`Module112749087ddf<Module11w Module121p49087ddfPModule1288Module131q49087ddfRModule13PModule141r49087ddfTModule14ߕhModule151s49087ddfVModule15FModule161t49087ddfXModule16Module171u49087ddfZModule17Y4Module181v49087ddf\Module18Module191w49087ddf^Module19K5Module201x49087ddfModule20Q)Module212849087ddfModule218Module222=49087de0Module22(}Module232049087ddfModule23f@Module242149087ddfModule24o X5 Module252249087ddfModule25w_pModule262:49087ddfModule26Q|Module272;49DeletexShiftxlUp 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 D1412978-C637-416D-B88E-9C461FFCD9CAH.DOCUME~1\ths5\LOCALS@Temp\VBE\DK.exd2 .E .`M ACOffi"cDOf@ijcB 02DF8D04C-5BFA_B-BHDE5@AA@420PROGRAM FILES\MICROSOFT OFFICE\MSO97Ìd# 8.0d"EBmÏoduleT1Gďou1T 2HB1UB,Bm!B +BThisWorkbookG@ThiWko@nk!A 2 o%qpC "eySheet! Se 9t 2 N "w"/*2//2*/2//2ͯ-/y+/3333RpR44544L<,U5555S=66566ɭU7777S!88588 U9_9Z9_9_3uI[ BM:10GIdR0%92?0`0];BIkJ11PLCwJߡJJ?J?8JKK??Kq@KaKpK?KߕKKK?KFL!L0L?_L`LLL?LY4LL?L?M MAMPM?1M5`EKK2M20Kr20E1E)QM{M2M28?|ؿMp{M2'M2}߿Mp{M2M2ÿlfwMp{M2M25do Mp{M2M2y1``,0w_!`D+Module26G4odule26 F2FnH |{TQ{7{7 {7{7#{=sK*y    rU~~~~~~~~~~~~~~Y )