ࡱ> bm  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FJsRWorkbook9b&_VBA_PROJECT_CUR"76q0gwVBAsPk  \paaq2es Ba= ThisWorkbook=hL,8X@"16Courier16Arial16Arial16Arial16Arial16Arial16Arial16Arial16Arial16Arial"$"#,##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 0000000 00.0 000.000% 0.0% 00.0%00                + ) , *  1 1 1  1   1   1         1  1<"@ 1 1<@ 1<  1 <@  1 <@  1 <  1 <    1<  1 < `RTSheet1  ;8 !18.817.917.617.627.036.247.0624-1e Deaths from asthma - Older adults (per million1 population, aged 65 years and over)a69.565.460.858.154.451.352.3b47.0a116.689.882.475.373.773.571.0a110.3110.395.683.379.285.7a64.460.656.955.251.048.4a81.472.158.955.652.547.146.0a68.764.752.6a112.1111.696.684.284.180.586.7a63.259.556.454.850.647.8a84.279.574.570.366.563.166.2a48.445.441.341.037.534.733.0324-2a Hospitalizations for asthma - Children (per4 10,000 population, aged under 5 years)199845.653.665.656.259.062.759.949.343.325.04 American Indian or Alaska Native only6 American Indian or Alaska Native only5,6DSU5DSU- Asian or Pacific Islander only/ Asian or Pacific Islander onlyDNC Asian only Asian only@ Native Hawaiian or Other Pacific Islander onlyB Native Hawaiian or Other Pacific Islander only- Black or African American only/ Black or African American only5,682.45,6103.05118.95102.75111.45119.85117.8571.0578.2 White only White only5,629.55,631.9541.3537.6538.5539.1534.8535.4528.0 2 or more races 2 or more races9 American Indian or Alaska Native; White; American Indian or Alaska Native; White2 Black or African American; White4 Black or African American; White4 White only, not Hispanic or Latino6 White only, not Hispanic or Latino33.141.647.640.341.444.636.330.657.665.182.771.475.879.661.855.3924-2b Hospitalizations for asthma - Children and adults; (age adjusted per 10,000 standard population, aged 5 to 64 years)! aged 5 to 64 years)12.512.012.411.45,628.45,627.9524.0525.0528.5529.5525.7522.4523.95,67.85,68.057.256.957.458.556.357.156.517.513.914.49.58.68.4124-2c Hospitalizations for asthma - Adults (age> adjusted per 10,000 standard population, aged 65 years and over)17.721.219.321.422.430.428.623.75,627.35,645.6532.1525.1538.1557.1534.6530.4535.15,612.45,614.3513.2515.2515.1520.2519.2522.3517.524.626.723.127.929.139.436.839.130.314.118.714.9924-3a Hospital emergency department visits for asthma -; Children (per 10,000 population, aged under 5 years) years)1995-97150.07159.68153.79148.380.06DSU7,10DSU8DSU9DSU6407.2 7,10380.18388.09401.8101.7 7,10125.08113.69105.67DSUa102.3785.98124.39110.1195.57230.18181.89184.8924-3b Hospital emergency department visits for asthma -> Children and adults (per 10,000 population, aged 5 to 64 years)71.1769.9859.6957.450.06191.7 7,10162.38170.79181.3653.47,1057.8845.2940.4782.4869.6966.757.9757.2849.4948.0924-3c Hospital emergency department visits for asthma -: Older adults (per 10,000 population, aged 6529.5731.5830.9922.8a,6DSU7,6DSU8123.9623.17,1025.3822.4916.2a37.9740.4834.4921.8826.0924.1824-4 Activity limitations - Among persons with asthma (age adjusted)1997a10%8%9%7%b6%a,11DSUa,1114%11%12%a,1110%6%13%17%5%10%a12%a8% Family income level Poora14%14%15% Near poor! Middle/high income4%524-5 School or work days lost - Among persons with< asthma, due to asthma (age adjusted mean number,2002c6.14.9cDSUc9.5c5.7c2.1c5.5c9.8c6.0c15.7c3.3524-6 Patient education - Among persons with asthma2 (age adjusted, aged 18 years and over)8.4%13.8%12.4%30.0%11DSU1111.2%17.5%10.7%117.8%12.9%12.5%7.8%15.8%13.7%1111.3%10.8%117.9%13.0%9.1%16.4%13.5%7.1%9.6%10.4%a7.7%14.0%7.9%a10.0%10.2%a8.0%14.5%13.4%324-7a Appropriate asthma care - Receiving written9 asthma plans from health care provider (age adjusted)c32%35%38%c37%33%c31%c36%43%c34%32%36%! Family income level Poorc27%28% Near poorc33%31%# Middle/high income624-7b Appropriate asthma care - Receiving proper-use3 instructions with prescribed inhalers2003c96.0%98.8%c94.0%c96.3%c98.7%c94.3%c96.1%c93.8%c96.5%c95.8%c93.9%c95.7%c96.8%824-7c Appropriate asthma care - Receiving education on; early signs, symptoms and responses to asthma episodesc68%71%c70%c67%c59%c69%c63%c64%c65%624-7d Appropriate asthma care - Receiving medication= regimens that prevent need for more than 1 beta3 agonist inhalation canister per monthc80%92%c75%c81%c91%c71%c76%c82%c78%c72%c77%c84%524-7e Appropriate asthma care - Receiving long-term> management care after any hospitalization due to asthma87%c79%c86%c73%c88%924-7f Appropriate asthma care - Receiving assistance in= reducing exposure to environmental risk factors (age adjusted)c42%49%50%c41%c49%57%40%c43%51%52%44%46%724-8 State-based asthma surveillance systems (number of States)23243743424-9 Activity limitations due to chronic lung and; breathing problems (age adjusted, aged 45 years and over)a2.5%2.5%2.4%2.3%2.2%b1.9%111.1%a,112.5%112.3%2.6%2.9%3.0%2.1%112.5%4.4%5.5%8.1%6.0%6.2%8.5%5.8%10.0%a2.1%1.5%1.4%1.6%1.3%1.8%1.2%a2.6%a,112.4%a,112.6%112.6%a2.4%@ Persons aged 45 to 64 years (not age adjusted)a1.9%1.7%2.0%1.9%9 Persons aged 65< years and over (not age adjusted)a3.3%3.4%3.3%3.6%3.2%3.5%3.1%a2.7%2.7%a1.7%a4.4%4.7%3.9%4.5%4.2%3.7%a5.6%5.3%5.7%5.0%6.4%5.1%a3.8%3.8%4.1%4.0%; (COPD, excluding asthma) - Adults (age adjusted: per 100,000 standard population, aged 45 yearsa123.9119.4118.9118.7112.8118.8b62.3a91.888.380.983.678.678.8a47.645.944.137.138.2a83.578.177.078.276.170.977.9a129.7126.5125.2125.4119.5a60.754.954.554.253.448.751.8a126.9123.7122.8122.4122.5116.7123.1a84.379.077.172.079.1a133.1130.2129.6129.4129.8124.1130.9a100.8100.4101.0100.9102.397.4103.4a163.1154.9150.3148.4145.4137.5142.9; Education level (not age adjusted, persons aged 45 to 64 years)a,151.8148.4148.7149.7263.3359.5461.3a,129.1128.4128.1229.5327.9430.1a,17.517.316.927.537.647.9% obstructive sleep apnea1 symptoms of obstructive sleep apnea2000* Race and ethnicity (of driver) Gender (of driver)= Education level (of driver, persons aged 45 to 647 DATA ISSUESa Baseline revisedb Target revised8c 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.4 Total of 31 reporting States (not including the District of Columbia). Data are not directly comparable to those of previous years.35 Data by race and ethnicity may be under reported.V6 Only one race category was recorded; recording more than one race was not an option.7 1998-2000 data.8 2001-2003 data.9 2004-2006 data.10 For 1998 data, persons were asked to select only one race category;selection of more than one race category was not an option.l11 Respondents were asked to select one or more races and identify one race as best representing their race. Objective/number DATA SOURCEO24-1a National Vital Statistics System - Mortality (NVSS-M), ob, NCHS.O24-1b National Vital Statistics System - Mortality (NVSS-M), ob, NCHS.O24-1c National Vital Statistics System - Mortality (NVSS-M), ob, NCHS.O24-1d National Vital Statistics System - Mortality (NVSS-M), ob, NCHS.O24-1e National Vital Statistics System - Mortality (NVSS-M), ob, NCHS.C24-2a National Hospital Discharge Survey (NHDS), ob, NCHS.C24-2b National Hospital Discharge Survey (NHDS), ob, NCHS.C24-2c National Hospital Discharge Survey (NHDS), ob, NCHS.S24-3a National Hospital Ambulatory Medical Care Survey (NHAMCS), ob, NCHS.S24-3b National Hospital Ambulatory Medical Care Survey (NHAMCS), ob, NCHS.S24-3c National Hospital Ambulatory Medical Care Survey (NHAMCS), ob, NCHS.B24-4 National Health Interview Survey (NHIS), ob, NCHS.B24-5 National Health Interview Survey (NHIS), ob, NCHS.B24-6 National Health Interview Survey (NHIS), ob, NCHS.A24-7a National Health Interview Survey (NHIS), ob, NCHS.A24-7b National Health Interview Survey (NHIS), ob, NCHS.A24-7c National Health Interview Survey (NHIS), ob, NCHS.A24-7d National Health Interview Survey (NHIS), ob, NCHS.A24-7e National Health Interview Survey (NHIS), ob, NCHS.B24-7f National Health Interview Survey (NHIS), ob, NCHS.P24-8 Behavioral Risk Factor Surveillance System (BRFSS), ob, NCCDPHP.B24-9 National Health Interview Survey (NHIS), ob, NCHS.O24-10 National Vital Statistics System - Mortality (NVSS-M), ob, NCHS.\24-11a Potential:National Health and Nutrition Examination Survey (NHANES), ob, NCHS.\24-11b Potential:National Health and Nutrition Examination Survey (NHANES), ob, NCHS.\24-12 Fatality Analysis Reporting System (FARS), Department of Transportation (DOT);J National Highway Traffic Safety Administration (NHTSA)./Focus area:24-Respiratory Diseases - 04-23-2008J Black or African American only, not Hispanic or LatinoH Black or African American only, not Hispanic or Latinoa,c20b26a,c2.4%a,cDNCb1.4%524-12 Fatal motor vehicle crashes where excessive E sleepiness is a factor - All ages (percent of all drivers& involved in a fatal crash)     8 BaselineTarget8 Objective Year Baseline 1998 1999 2000 2001 2002 2003 2004 2005 2006 20072010 824-10 Deaths from chronic obstructive pulmonary disease824-11a Medical evaluation - Persons with symptoms of 824-11b Long-term medical management - Persons with 224-1a Deaths from asthma - Children (per million- population, aged under 5 years)1999a1.7NABSL2.12.42.21.82.0---b0.9 Race and ethnicity Race and ethnicity/ American Indian or Alaska Native1 American Indian or Alaska NativeaDSUDSU( Asian or Pacific Islander* Asian or Pacific Islander Asian AsianaDNCDNA; Native Hawaiian or Other Pacific Islander= Native Hawaiian or Other Pacific Islander( Black or African American* Black or African American7.77.57.89.1 White White1.51.3! Hispanic or Latino# Hispanic or Latino% Not Hispanic or Latino' Not Hispanic or Latinoa1.92.61.72.3@ Black or African American, not Hispanic/LatinoB Black or African American, not Hispanic/Latino9.2/ White, not Hispanic or Latino1 White, not Hispanic or Latino Gender Gender Female Female Male Male2.72.83.32.5424-1b Deaths from asthma - Children and youth (per5 million population, aged 5 to 14 years)a3.13.13.0a9.910.17.610.48.88.51.41.2a3.33.43.2a10.110.67.910.79.08.0a1.81.61.1a2.1a4.13.5824-1c Deaths from asthma - Adolescents and adults (per6 million population, aged 15 to 34 years)a5.65.34.75.04.44.1b1.9a17.815.715.913.714.013.812.8a3.72.93.7a2.8a6.15.85.55.2a18.316.216.614.314.614.513.3a3.94.0a5.44.54.23.63.8a5.96.14.85.1; Education level (persons aged 25 to 34 years)$ Less than high school& Less than high schoola,111.119.6<111.516.528.3312.149.9# High school graduate% High school graduatea,112.2111.018.1110.628.936.148.048.0$ At least some college& At least some collegea,13.013.613.613.523.032.542.6024-1d Deaths from asthma - Adults (per million. population, aged 35 to 64 years)a15.515.114.714.212.7b8.020.5a11.811.87.410.9a44.746.244.345.239.838.836.7a11.710.89.39.7a14.011.711.2a15.615.315.014.813.0a45.847.245.146.440.839.937.7a11.410.59.9a19.517.918.217.315.416.012.111.111.511.0; Education level (persons aged 35 to 64 years)a,125.9126.4125.8125.8125.7125.7226.8324.3423.4a,121.2120.3120.2120.5120.5218.6316.8416.5a,18.7--- = 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.   M X   [ ]  p !YB v d T 8 G ) ! u )  mc|# bRANZ?g@ L  Yb!(""r#$$?%W&&12''_<(|((8))I0*}**m++ +R=,},," -eT--F..d/0Q3 5 8n9:<*=;>u??!@J)AAQB6CsDyEFiF FC%G}G*HpUHHH7InI,J#KbKLZYLLL"(Mg`MM.[NVOcc   \HYuN&n3FOjօfJ$%  dMbP?_*+%M\\fnch-hvl-app1\PR-DHP2?d,,Letter.HP LaserJet 4100 PCL 62xeMKQ9W/c02TqF Z q@?/ԅnZmD#7SH/> tso6m 7ߕ; c -+U2l kx 6 ٢ [ݸnpIp1 f4c i;bl"C*&Wy2+b_CKx MEp&TKaE ! 6^|6FY[<ќEr^ݐDWЮߞ]{JTJf:pn1T[o֍i%)eq -t˰6 `!$n‡pñ[Q"W;,,??U} 1} } } } } }  } } HC@ @@ @@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ 0 1111111111111 * + + + + + + + +  +  +  +  +  + , - - - - - - - -  -  -  -  -  -                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Dnl2 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@               ! ! ! ! ! ! ! ! !  !   !  !  !  !  " " " " " " " " " "  "  "  "  "  # # # # # # # # # #  #  #  #  #  $ $ $ $ $ $ $ $ $ $  $  $  $  $  % % % % % % % % % %  %  %  %  %  & & & & & & & & & &  &  &  &  &  ' ' '  ' ' '! '" '# '" ' $ ' % '  '  ' & ( ( ( ( ( ( ( ( ( (  (  (  (  (  ) ) ) ) ) ) ) ) ) )  )  )  )  ) & * * * * * * * * * *  *  *  *  * & + + + + + + + + + +  +  +  +  + & , , , , , , , , , ,  ,  ,  ,  , & - - -' - - -( -) -* -+ - , - - -  -  - & . . .. . . . ./ .0 . .  .  .  .  . & / / /1 / / / / / / /  /  /  /  / & 0 0 02 0 0 03 0! 04 05 0 " 0 " 0  0  0 & 1 1 16 1 1 17 18 19 1: 1 ; 1 < 1  1  1 & 2 2 2= 2 2 20 2 2> 2 2  2  2  2  2 & 3 3 3 3 3 3 3 3 3 3  3  3  3  3  4 4 4? 4 4 4$ 4@ 4A 4A 4 B 4 C 4  4  4 & 5 5 5D 5 5 5E 5F 53 5! 5 G 5 $ 5  5  5 & 6H 6 6 6 6 6 6 6 6 6  6  6  6  6  7J 7 7K 7 7 7L 7M 7N 7O 7 P 7 Q 7  7  7  8S 8 8T 8 8 8U 8V 8W 8X 8 Y 8 [ 8  8  8  9] 9 9^ 9 9 9` 9` 9a 9b 9 c 9 d 9  9  9  : : : : : : : : : :  :  :  :  :  ;e ; ; ; ; ; ; ; ; ;  ;  ;  ;  ;  <f < <g < < <h <i <; <j < k < k <  <  < l = = = = = = = = = =  =  =  =  =  > > > > > > > > >m >  >  >  >  > l ? ? ?n ? ? ?_ ?o ?p ?q ? p ? ! ?  ?  ? lDl@@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 A A A A A A A A A A  A  A  A  A l B B Br B B Bs Bt Bu Bv B w B x B  B  B l C C Cy C C Cz C C C C { C | C  C  C l D D D} D D Do D~ Dz D D | D  D  D  D l E E E E E E E E E; E  E < E  E  E l F F F F F F F F F F  F  F  F  F l G G G G G G G G  G G  G  G  G  G l 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  I  I  I l J J J J J J J J J J  J { J  J  J l 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  MS 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  O O O O O O O O O O  O  O  O  O  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  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  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  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  X X X X X X X X! X" X Z X # X  X  X  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  [ [ [. [ [ [/ [0 [1 [2 [ 3 [ 4 [  [  [  \ \ \5 \ \ \6 \7 \8 \9 \ : \ # \  \  \  ] ] ] ] ] ] ] ] ] ]  ]  ]  ]  ]  ^ ^ ^; ^ ^ ^< ^= ^> ^? ^ @ ^ A ^  ^  ^  _ _ _B _ _ _C _D _E _F _ G _ H _  _  _ 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@{@|@}@~@@ ` ` ` ` ` ` ` ` ` `  `  `  `  `  aI a a a a a a a a a  a  a  a  a  bJ bK bL b bM bN bO bP bQ b R b S b T b  b U c c c c c c c c c c  c  c  c  c  dW dK dX d dX dY dY dY dY d Y d Y d Y d  d U e[ eK eX e eX e\ e\ e\ e\ e \ e \ e \ e  e U f^ fK f\ f f\ fY fY fY fY f Y f Y f Y f  f U g` gK g\ g g\ gY gY gY gY g Y g Y g Y g  g U hb hK hc h hd he hf hg hh h i h j h k h  h U im iK in i io ip iq ir is i t i u i v i  i U jx jK j\ j j\ jY jY jY jY j Y j Y j Y j  j U kz kK k\ k k\ kY kY kY kY k Y k Y k Y k  k U l| lK l\ l l\ lY lY lY lY l Y l Y l Y l  l U m mK mY m mY mY mY mY mY m Y m Y m Y m  m U n nK nY n nY nY nY nY nY n Y n Y n Y n  n U o oK oX o oX oY oY oY oY o Y o Y o Y o  o U p~ pK pX p pX pY pY pY pY p Y p Y p Y p  p U q q q q q q q q q q  q  q  q  q  r rK r r r r r r r r  r  r  r  r U s sK s s s s s s s s = s  s  s  s U 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  v v v v v v v v v v  v  v  v  v  w wK w w w_ w w~ w w; w  w  w z w  w  x x x x x x x x x x  x  x  x  x  yW yK yX y yX yY yY yY yY y Y y Y y Y y  y  z[ zK zX z zX z\ z\ z\ z\ z \ z \ z \ z  z  {^ {K {\ { {\ {Y {Y {Y {Y { Y { Y { Y {  {  |` |K |\ | |\ |Y |Y |Y |Y | Y | Y | Y |  |  }b }K } } } } } } } }  }  }  }  }  ~m ~K ~ ~ ~ ~ ~ ~ ~ ~  ~  ~  ~  ~  x K \  \ Y Y Y Y  Y  Y  Y    Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ z K \  \ Y Y Y Y Y Y Y   | K \  \ Y Y Y Y Y Y Y    K Y  Y Y Y Y Y Y Y Y    K Y  Y Y Y Y Y Y Y Y    K X  X Y Y Y Y Y Y Y   ~ K X  X Y Y Y Y Y Y Y                  K )         *    K                                                           K                           W K X  X Y Y Y Y Y Y Y   [ K X  X \ \ \ \ \ \ \   ^ K \  \ Y Y Y Y Y Y Y   ` K \  \ Y Y Y Y Y Y Y   b K             m K             x K \  \ Y Y Y Y Y Y Y   z K \  \ Y Y Y Y Y Y Y   | K \  \ Y Y Y Y Y Y Y    K Y  Y Y Y Y Y Y Y Y    K Y  Y Y Y Y Y Y Y Y    K X  X Y Y Y Y Y Y Y   ~ K X  X Y Y Y Y Y Y Y                  K              K    <  o <                                  Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@                                           W              [     \   \   \   ^  \            `  \            b              m              x  \            z  \            |  \                                                      ~                                                                                                                              W              [     \   \   \   ^  \            `  \            b              m              x  \            z  \           Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ |  \                                                      ~                              ;                                                                                                     W              [  \   \   \   \   ^  \            `  \            b              m              x  \            z  \            |  \                                                      ~                                                                       !              " # $  %  %  &  %  %  % ' % '  (Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@               V # )           ( Z # )  \ \ \ \ \ \ \ \  ( ] # )           ( _ # )           ( a # * !+  &  % !,  &  & & % '  ( l # -  '  %  %  '  '  ' . % '  ( w #  \   !/ !0      ( y #  \          ( { #  \          (  # $  %  '  &  .  .  % 1 ' .  (  # $  %  %  &  %  %  % ' % '  (  # * !+ !2  % !,  &  & & % '  ( } # -  '  %  %  %  '  % . % '  (                # 3 !2 !2 !2  &  &  & % & %  (  # 4  1  .  '  .  .  . 1 . 1  ( 5              6 # 7 !, !8 !9 !8 !/ !, !/ !/ !,  ( : # 7 !+ !2 !,  & !+ !, !2 !2 &  ( ; # 4  .  .  .  .  .  1 < 1 <  (               =              >               ? @      A                    V ? B            Z ? \      \      ] ? B            _ ? B            a ? C            l ? D      F     Dl@@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ w ? E                 y ? B                 { ? B                  ? F      >            ? @      #            ? G                 } ? D      F                               ? H      5            ? @      %           5                   6 ? I                 : ? B                 ; ? J                                    K                   L K "M  #N    #O          #P                    V K Q                #P Z K Q  \    \          #P ] K Q                #P _ K Q                #P a K R  #S    #T          #P l K U  #V    #W          #P w K \                #P y K \                #P { K \                #P  K "X  #Y    #O          #P  K "M  #Z    #W          #P  K [  #S    #\          #P } K ]  #^    #W          #P                   Dl @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@  K "_  #`    #a          #P ! !K !"b ! !"c ! ! ! !#d !  !  !  !  ! #P "5 " " " " " " " " "  "  "  "  "  #6 #K #e # ##f # # # #"g #  #  #  #  # #P $: $K $h $ $#i $ $ $ $#Z $  $  $  $  $ #P %; %K %j % %#k % % % %#l %  %  %  %  % #P & & & & & & & & & &  &  &  &  &  'm ' ' ' ' ' ' ' ' '  '  '  '  '  (n ( ( ( ( ( ( ( ( (  (  (  (  (  )o )? )p ) ) ) ) ) )!q )  )  )  )  ) !r * * * * * * * * * *  *  *  *  *  +W +? +B + + + + + + +  +  +  +  + !r ,[ ,? ,\ , , , , , ,\ ,  ,  ,  ,  , !r -^ -? -s - - - - - - -  -  -  -  - !r .` .? .B . . . . . . .  .  .  .  . !r /b /? /s / / / / / /!t /  /  /  /  / !r 0m 0? 0u 0 0 0 0 0 0!q 0  0  0  0  0 !r 1x 1? 1v 1 1 1 1 1 1!w 1  1  1  1  1 !r 2z 2? 2B 2 2 2 2 2 2 2  2  2  2  2 !r 3| 3? 3B 3 3 3 3 3 3 3  3  3  3  3 !r 4 4? 4x 4 4 4 4 4 4!y 4  4  4  4  4 !r 5 5? 5p 5 5 5 5 5 5!q 5  5  5  5  5 !r 6 6? 6s 6 6 6 6 6 6!t 6  6  6  6  6 !r 7~ 7? 7u 7 7 7 7 7 7!q 7  7  7  7  7 !r 8 8 8 8 8 8 8 8 8 8  8  8  8  8  9 9? 9p 9 9 9 9 9 9!z 9  9  9  9  9 !r : :? :p : : : : : :!y :  :  :  :  : !r ;{ ; ; ; ; ; ; ; ; ;  ;  ;  ;  ;  <| <? <} < < < < < <!~ <  <  <  <  < !r = =? = = = = = = =! =  =  =  =  = !r > >? >x > > > > > >!r >  >  >  >  > !r ? ? ? ? ? ? ? ? ? ?  ?  ?  ?  ? 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 # B B B B B B B B B B  B  B  B  B  CW C CB C C C C C C C  C  C  C  C # D[ D D\ D D D D D D D  D  D  D  D # E^ E EB E E E E E E E  E  E  E  E # F` F FB F F F F F F F  F  F  F  F # Gb G G G G G G G G G  G  G  G  G # Hm H H H H H H H H H  H  H  H  H # Ix I I I I I I I I I  I  I  I  I # Jz J JB J J J J J J J  J  J  J  J # K| K KB 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 # 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 # O~ O O O O O O O O O  O  O  O  O # 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 # 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  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 # 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  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  Z Z Z Z Z Z Z Z Z Z  Z  Z  Z  Z ! [ [ [ [ [ [ [ [ [ [  [  [  [  [  \W \ \B \ \ \ \ \ \ \  \  \  \  \ ! ][ ] ]\ ] ] ] ] ] ] ]  ]  ]  ]  ] ! ^^ ^ ^B ^ ^ ^ ^ ^ ^ ^  ^  ^  ^  ^ ! _` _ _B _ _ _ _ _ _ _  _  _  _  _ !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@{@|@}@~@@ `b ` ` ` ` ` ` ` ` `  `  `  `  ` ! am a a a a a a a a a  a  a  a  a ! bx b b b b b b b b b  b  b  b  b ! cz c cB c c c c c c c  c  c  c  c ! d| d dB 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 ! 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 ! 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  i  i  i  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 ! l{ l l l l l l l l l  l  l  l  l  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 ! o o o o o o o o o o  o  o  o  o ! 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  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 ! t t t t t t t t t t  t  t  t  t  uW u uB 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 ! w^ w wB w w w w w w w  w  w  w  w ! x` x xB x x x x x x x  x  x  x  x ! yb y y y y y y y y y  y  y  y  y ! zm z z z z z z z z z  z  z  z  z ! {x { { { { { { { { {  {  {  {  { ! |z | |B | | | | | | |  |  |  |  | ! }| } }B } } } } } } }  }  }  }  } ! ~ ~ ~ ~ ~ ~ ~ ~ ~ ~  ~  ~  ~  ~ !                   !Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@                   ! ~                  !                                      !                   ! {                   |                  !                   !                   !                                                                            !                    W  B                ! [  \                ! ^  B                ! `  B                ! b  B                ! m                  ! x  B                ! z  B                ! |  B                !   B                !                   !   B                ! ~                  !                                      !                   ! {                   |  B                !Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@   B                !      - '!"#$%&(,)*+.5@/012346:789;?<=>AGBCDEFHIJKLMNOQnSTUVWXYZ[\]^_`abcdefghijklPopqrstuvwxyz{|}~                  !                                                           ?       !          !                    W ? B                ! [ ? \      \          ! ^ ?                 ! ` ? B                ! b ?       !          ! m ?       !          ! x ?       !          ! z ? B                ! | ? B                !  ? s      !          !  ?       !          !  ?       !          ! ~ ?       !          !                     ?       !          !  ?       !          ! {                   | ?       !          !  ?       !          !  ?       !          !                                                 $  $  $  $  .                                      Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@                     #  " " " " " "  "  "  "                        V # Q Q                Z # Q  \ \ \ \ \  \  \  \     ] # Q Q                _ # Q Q                a #   " " " " "  "  "  "     l #   " " " " "  "  "  "     w # \ \  " " " "  "    "     y # \ \   " #            { # \ \                 #  " " " " " "  "  "  "      #  " " " " " "  "  "  "      #   " " " " "  "  "  "     } #   " " " " "  "  "  "                         #  " " " " " "  "  "  "      #  " " " " " "  "  "  "                         #  " " " " " "  "  "  "      #  " " " " " "  "  "  "      #  " " " " " "  "  "  "                         #  " " " " " "  "  "  "     5                   6 #  " "  "  "  "  "   "  "   "      : #   " " " " " "  "  "  "     ; # " " " " " " "  "  "  "                        %                                     Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@                                                                                   ! " v   #  $                                               %   & ' ( )  *  +         ,   -  . /  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                   I  [   \ ] ^ _  `  a       R  b   c d c e  f  g       \  h   i i j k  l  m                          %                   n \ \                                    %                   o \ \                                    %                                       p    "/$?"I +?"~jt?~  "@        / q                  D l@@@@@@@@@ @ @ @ @ @@@@@ @ @@@@@@@@@@@@@  p     \ \ \  \  \  \    /  p \    \ \ \  \  \  \    /  p     \ \ \  \  \  \    /  p     \ \ \  \  \  \    /  p     \ \ \  \  \  \    /  p     \ \ \  \  \  \    /  p     \ \ \  \  \  \    /  p \    \ \ \  \  \  \    /  p \    \ \ \  \  \  \    /  p \    \ \ \  \  \  \    / r                    p     \ \ \  \  \  \    /  p     \ \ \  \  \  \    / s                                      I p \    \ \ \  \  \  \    / R p \    \ \ \  \  \  \    / \ p \    \ \ \  \  \  \    / &t &&&&&&&&&&&&&       'u 'v 'w 'x 'y 'z '{D0l2 @!@"@#@$@%@&@'@(@)@*@ +@,@ -@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@ '| !'} "'~ #' $' %' &' ' ( ) * +( +((((((((((((( ,) ,))))))))))))) - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?Dl22@@A@B@C@D@E@F@G@ @ A B C D E F G>@  7 Sheet1 Module1 __SRP_2 __SRP_3oThisWorkbook01  !"#$%&')*+,-./0123456789;<=>?@ABCDFGHIJKLMNOPQRSTUVXY[]^_`abcdefhijklmnopqstuvwxyz{|~"mmxME (6 <<< `@pXJ)Macro recorded 2/18/99 by Thomas C. Socey 14%HxI$*\Rffff*1[498ee2fe"  ((8A1:INDIRECT(IV1)$B@HoPH˰Attribute VB_Name = "Module1" Sub Macro`1() L.Descrip0tiontX recorded 2/18/99 by Thomas C. Soc eyProcDataZInvoke_FuncAZ \n146 Range("A1:INDIRECT(IV1)").Select End rU~| 0  krU $`anmC #xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Sheet12(IModule2:Module3Ex__SRP_4 W<CmN #:BD1ʛ FK"Ny!xME (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$+myxMExpIx"Attribute VB_Name = "Module2" "mRxME (6 <<< $`@pxJ)Macro recorded 2/19/99 by Thomas C. Socey 14"%HxI$*\Rffff*1]498ee2fe"  ( &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 $`n$+m<,xME__SRP_5ZoModule4\Module5 gModule6rxpIx"Attribute VB_Name = "Module4" $+m=xMExpIx"Attribute VB_Name = "Module5" $+mɭxMExpIx"Attribute VB_Name = "Module6" $+m!xModule7}Module8Module93Module10&9MExpIx"Attribute VB_Name = "Module7" $+m xMExpIx"Attribute VB_Name = "Module8" $+muIxMExpIx"Attribute VB_Name = "Module9" "ZmBxME(6 < << 6`@pXJ )Macro recorded 12/18/2001 by Thomas Socey 144%HxI$*\Rffff*1^498ee2fe "   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 $`9n__SRP_6 #__SRP_7oModule11__SRP_8JmwxMEP6 <<<< <<< >`@pJ )Macro recorded 12/18/2001 by Thomas Socey 14<%HxI$*\Rffff*1_498ee2fe "   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 $`9n$+m8x__SRP_9oModule12!Module13Module14MExpIx$Attribute VB_Name = "Module12" $+mxMExpIx$Attribute VB_Name = "Module13" $+mߕxMExpIx$Attribute VB_Name = "Module14" $+mFModule15Module16Module17 Module18      !#$%&'()*+,-./0123456789:;<=>?@ABCEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdegiklmnopqrstuvwxyz{|}~xMExpIx$Attribute VB_Name = "Module15" $+mxMExpIx$Attribute VB_Name = "Module16" $+mY4xMExpIx$Attribute VB_Name = "Module17" $+mxMExpIx$Attribute VB_Name = "Module18" /mKxMEModule19"^Module20)DKModule21R@__SRP_afTp `@Ib `I"  , 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!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~|  k  '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*1`498ee2fe+" 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$G'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(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  '  $' -'d $$'d` ..''d0 %%'d  0 'd  0 'kkkkkk  G'j stop5       8(:k  hdashk notk gotsuperk 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:''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 ) (+ bE3M     m1 !"#$%&'()*+,-./023456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklopqrs|uvwxyz{n}~idD%,?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_e'-T__SRP_fgModule27y__SRP_10.T`nrU~| krU $`ne0* pHd VBAProject4@j = r I J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.st find the row which has the titles''''''' a  'A $$ $B@H j!p' $' $' Measure 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*1c498ee2fe:" .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 '  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(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  '  $' -'d $$'d` ..''d0 %%'d  0 'd  0 'kkkkkk  G'j stop5       8(:k  hdashk notk gotsuperk 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:''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_11g_VBA_PROJECTt.dir__SRP_04M Module26Q|Module271c498ee2feModule27|(8X@p x`0]L O{ՃgЉjE{{ڶfEȠ1aE+GU8!(iJCz+ fKMj  *WK UQX=Lˆq^<0_OzXr@"ȘUI"Hx2HC 54@GHQ%Y jITE |$D wJs*~S `biHNF M'RHf.:CՍbyCEWJy9*J55xh5@XN*J5DOՀECD4$IĞ1pg;qtHlurU!Nf|N#kB#Ks}(ISFrq. nHcIB K#xtF3ݶTSPˆJp4dX@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| CharactersrgStartLeay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\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:\WINDOWS\system32\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{FEF79043-F01F-4E09-9330-847125E666F3}#2.0#0#C:\DOCUME~1\LKA7\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\Common Files\Microsoft Shared\OFFICE11\MSO.DLL#Microsoft Office 8.0 Object Library  I   mModule11[498ee2feModule1mThisWorkbook0a498ee2feThisWorkbookC % Sheet10c498ee2fe Sheet1N 0Module21B498ee2fe Module2yHModule31]498ee2fe"Module3R`Module41D498ee2fe(Module4<,xModule51E498ee2fe*Module5=Module61F498ee2fe,Module6ɭModule71G498ee2fe.Module7!Module81H498ee2fe0Module8 Module91I498ee2fe2Module9uIModule101^498ee2fe4Module10B`Module111_498ee2fe<Module11w Module121L498ee2fePModule1288Module131M498ee2feRModule13PModule141N498ee2feTModule14ߕhModule151O498ee2feVModule15FModule161P498ee2feXModule16Module171Q498ee2feZModule17Y4Module181R498ee2fe\Module18Module191S498ee2fe^Module19K5Module201T498ee2feModule20Q)Module211`498ee2feModule218Module221a498ee2feModule22(Module231W498ee2feModule23f@Module241X498ee2feModule24o X5Module251@498ee2feModule25w_pModule261b498ee2fengthYstoplockBoldcvalue2sourceswissuesw?DeletexShiftxlUp 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 tlb#OLE Automation`MSForms>SFFrms3ED452EE1-E08F-@101A-8-02608C4D0BB4EFM20.DLL#Microsoft E: ^ Ob Library/;D1u00}#0F#0 FEF79-F01F-4E 09-93847125E666F3H.DOCUME~1\LKA7\LOCALS@Temp\VBE\DK.exd2 .E .`M ÁOfficāOf@ic5 02DF8D04C-5BFA_B-BDE5@AA420@gram Files\Co0mmonG_Shared\OFFICE115Og& 8.0 h@%"module1*Go@uB1 2HB1BE,Bm!B+BThisWorkbookGT@Ti@W²kbok! 2o%p8C "eA|ShXeet! Se:t 2u N x"/2//2*/2//2f -/y+/3U333pR4444L<,5555=6666ɭ7777!8888 9_9Z9_9_B3uI[BM:10GIdR092?0``];BIJ11PLCwJJoJ?J?8JKK??K@KaKpK?KߕKKK?KFL!L0L?_L`LLL?LY4LLL?M MAMPM?M5`EK%2M20K20E1E)QM{MN2M28?ؿMp{M2M2?UMp{M2M2lfMp{M2M25o Mp{M2{Mxle25(HP18HP,w_!0+Module26GodDu6 F2F{|{Q{7{7 {7{7==sK*y     rU~~~~~~~~~~~~~~~V )rj@\VBA6\VBE6.DLLVBA I q0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel Ai@0FC:\WINDOWS\system32\Stdole2.tlbstdole QyP.E .`M C:\WINDOWS\system32\FM20.DLLMSForms  11Y`C N0q%f .C:\DOCUME~1\LKA7\LOCALS~1\Temp\VBE\MSForms.exd a1pL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLLOffice I q Macro1 Macro3Macro7Macro8NumericMacro2PITSMrU __SRP_1PROJECTwmPROJECT5SummaryInformation(84     )Macro recorded 2/18/99 by Thomas C. Socey 14 )Macro recorded 2/19/99 by Thomas C. Socey )Macro recorded 12/18/2001 by Thomas Socey (Macro recorded 4/22/2002 by Thomas SoceyAModule1Module1ThisWorkbookThisWorkbookSheet1Sheet1Module2Module2Module3Module3Module4Module4Module5Module5Module6Module6Module7Module7Module8Module8Module9Module9Module10Module10Module11Module11Module12Module12Module13Module13Module14Module14Module15Module15Module16Module16Module17Module17Module18Module18Module19Module19Module20Module20Module21Module21Module22Module22Module23Module23Module24Module24Module25Module25Module26Module26Module27Module27ID="{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="1C1E1F3D275D2B5D2B5D2B5D2B" DPB="383A3B3C3C3C3C3C" GC="545657456F607060709F" [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 Oh+'0HPhx Thomas C. SoceyjirlesMicrosoft Excel@Ik@j)|Z@(%DocumentSummaryInformation880CompObj=m՜.+,0 PXl t|  NCHS/OAEHP' Sheet1Sheet1!Print_Titles  Worksheets Named Ranges F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q