ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FZ"7EWorkbook;_VBA_PROJECT_CUR"98_VBAPd0  \plug1 Ba= ThisWorkbook=hL,8X@"1Courier1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0 0000 0.0% 00.0% 00.00000000%                + ) , *  1 1 1  1    1 1          1  1<"@ 1 1<@ 1<  1 <@  1 <@  1 <  1 <  1<  1 < `fCSheet1  ;8 211%310%14%4DSU2DSU3DSU2DNC434%2DNA415%" Mexican American15%210%35%35%433%238%332%27%27%37%37%a22%215%315%a12%26%26%28%214%318%213%313%28%- Persons aged 14 to 19 years6%2,52%- Persons aged 20 to 29 years- Persons aged 30 to 39 years224%320%- Persons aged 40 to 49 years&25-5 Human papillomavirus infection2003-0429%24%39%22%9 Education level (persons aged 22 to 44 years)$ Less than high school# High school graduate$ At least some college- Persons aged 20 to 24 years45%- Persons aged 25 to 29 years- Persons aged 30 to 34 years- Persons aged 35 to 39 years- Persons aged 40 to 44 years- Persons aged 45 to 49 years21%925-6 Treatment for pelvic inflammatory disease (PID) -) Females (aged 15 to 44 years)19958%5%11%7%12%9% Disability status( Persons with disabilities+ Persons without disabilities4%625-7 Fertility problems - Childless females with an, STD or PID (aged 15 to 44 years)33%aDSU23%32%31%a26%19%18%20%925-8 Heterosexually transmitted HIV infection in women6 (aged 13 to 24 years) [realigned to 13-18]725-9 Congenital syphilis (new cases per 100,000 live births)a2815141211981' Mother's race and ethnicity131618563743417895954442428 who never had sexual intercourse (grades 9 through 12) [New]199950%54%53%56%46%52%49%55%57%59%48% Grade 9th61%66%67% 10th 11th47% 12th38% Sexual orientation7 Number of sex partners (past 3 months) None 1 2 to 3 4 or more? who had sexual intercourse, but not in the past 30 months (grades 9 through 12) [New]30%25%34%36%< who used condoms at last intercourse (grades 958%63%65%64%70%73%69%62%51%4 television [Deleted at Midcourse Review]# Tribal, State and local199890%6 detention facilities and jails [Deleted at Midcourse Review]8 nonplan partners of STD patients [Deleted at< enrolled in commercial MCOs (aged 25 years and under) [New]c25%: enrolled in Medicaid MCOs (aged 25 years andc41%; healthcare visits [Deleted at Midcourse Review]9 STD treatment standards [Deleted at Midcourse Review]2 patients (Deleted at Midcourse Review)7 DATA ISSUESa Baseline revised8c New baseline. Objective was previously developmental.V1 Only one race category was recorded; recording more than one race was not an option.2 1999-2002 data.3 2003-2006 data.p4 Respondents were asked to select one race category;selection of more than one race category was not an option.&5 Data are for persons 14 to 19 years. Objective/number DATA SOURCE<25-1a STD Surveillance System (STDSS), ǿֹ, NCHHSTP.<25-1b STD Surveillance System (STDSS), ǿֹ, NCHHSTP.<25-1c STD Surveillance System (STDSS), ǿֹ, NCHHSTP.[25-1d STD Surveillance System (STDSS), ǿֹ, NCHHSTP; National Job Training Program.<25-2a STD Surveillance System (STDSS), ǿֹ, NCHHSTP.<25-2b STD Surveillance System (STDSS), ǿֹ, NCHHSTP.=25-3 STD Surveillance System (STDSS), ǿֹ, NCHHSTP.T25-4 National Health and Nutrition Examination Survey (NHANES), ǿֹ, NCHS.B25-6 National Survey of Family Growth (NSFG), ǿֹ, NCHS.B25-7 National Survey of Family Growth (NSFG), ǿֹ, NCHS."25-8 Realigned to 13-18._25-9 STD Surveillance System (STDSS), ǿֹ, NCHHSTP;National Vital Statistics System -/ Natality(NVSS-N), ǿֹ, NCHS.*25-10 Deleted at Midcourse Review.K25-11a Youth Risk Behavior Surveillance System (YRBSS), ǿֹ, NCCDPHP.K25-11b Youth Risk Behavior Surveillance System (YRBSS), ǿֹ, NCCDPHP.K25-11c Youth Risk Behavior Surveillance System (YRBSS), ǿֹ, NCCDPHP.*25-12 Deleted at Midcourse Review.U25-13 Survey of STD Programs, National Coalition of STD Directors (NCSD);IHS.*25-14 Deleted at Midcourse Review.*25-15 Deleted at Midcourse Review.X25-16a Health Employer and Information Set (HEDIS); National Committee for Quality$ Assurance (NOQA).X25-16b Health Employer and Information Set (HEDIS); National Committee for Quality*25-17 Deleted at Midcourse Review.*25-18 Deleted at Midcourse Review.*25-19 Deleted at Midcourse Review.J Black or African American only, not Hispanic or LatinoH Black or African American only, not Hispanic or Latino      8 BaselineTarget8 Objective Year Baseline 1998 1999 2000 2001 2002 2003 2004 2005 2006 20072010 10.3%10.1%12.1%12.7%13.7%13.6%14.3%11.8%12.8%12.2%13.8%13.5%14.5%13.3%14.2%15.3%15.4%14.8%16.5%17.1%15.6%16.9%18.3%14.0%14.6%12.6%12.5%13.9%16.0%16.4%15.8%16.2%17.9%18.1%10.4%10.2%11.4%12.0%11.3%15.1%13.4%15.7%15.5%18.4%10.9%11.6%11.7%11.0%17.0%19.2%20.2%20.5%20.8%21.1%17.4%19.0%21.3%24.1%19.6%22.1%16.7%15.9%19.3%20.1%23.5%25.3%25.7%14.4%15.0%18.7%17.5%18.8%19.9%20.7%18.0%20.0%23.7%26.2%27.3%11.5%11.2%13.1%12.3%10.5%10.6%825-10 Neonatal STDs [Deleted at Midcourse Review] 825-11a Responsible adolescent sexual behavior - Students825-11b Responsible adolescent sexual behavior - Students825-11c Responsible adolescent sexual behavior - Students825-12 Responsible sexual behavior messages on 825-13 Hepatitis B vaccines offered in STD clinics - 825-14 Screening for sexually transmitted diseases in 825-15 Contracts with managed care providers to treat 825-16a Annual screening for genital chlamydia - Females 825-16b Annual screening for genital chlamydia - Females 825-17 STD screening of pregnant women during prenatal 825-18 Primary care provider compliance with recognized 825-19 Provider referral services for partners of STD 425-1a Chlamydia infections among females attending; family planning clinics (aged 15 to 24 years)19975.0%6.1%5.6%5.9%5.8%6.0%6.4%6.9%7.1%---3.0% Race and ethnicity Race and ethnicity4 American Indian or Alaska Native only6 American Indian or Alaska Native onlya,16.1%18.3%7.9%8.5%8.0%7.8%7.7%8.3%8.8%- Asian or Pacific Islander only/ Asian or Pacific Islander onlya,14.9%16.5%DNC Asian only< Asian only3.3%7.0%6.5%6.7%5.7%@ Native Hawaiian or Other Pacific Islander onlyB Native Hawaiian or Other Pacific Islander only7.3%8.2%5.5%DSU9.3%- Black or African American only/ Black or African American only111.4%113.1% White only White only13.3%13.9%3.9%4.0%4.3%4.6%4.9% 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; White! Hispanic or Latino# Hispanic or Latino5.2%6.2%% Not Hispanic or Latino' Not Hispanic or LatinoDNA111.1%113.0%4 White only, not Hispanic or Latino6 White only, not Hispanic or Latino13.1%13.7%3.7%3.8%4.2%4.4%4.7% Family income level! Family income level Poor Poor Near poor Near poor! Middle/high income# Middle/high income825-1b Chlamydia infections among females attending STD+ clinics (aged 15 to 24 years)a,112.6%115.0%a,112.1%115.9%8.1%115.1%116.4%19.5%110.1%115.2%19.2%110.0%9.7%9.8%9.6%9.9%625-1c Chlamydia infections among males attending STDa,19.4%119.1%a,117.1%118.4%119.3%26.5112.8%113.2%18.5%16.8%118.1%119.4%111.5%112.3%11.9%625-1d Chlamydia infections among females enrolled in= National Job Training Program (aged 24 years or less) [New]2002NABSL6.8%6.6%6.3%9.0%8.7%9.2%7.6%7.5% Select populations Select populations Age groups Age groups/ Females aged 16 to 19 years/ Females aged 20 to 24 years625-2a Gonorrhea - (new cases per 100,000 population)a12212912712211511212119/ American Indian or Alaska Native1 American Indian or Alaska Native9710798102113103117132138( Asian or Pacific Islander* Asian or Pacific Islander27252122 Asian Asian; Native Hawaiian or Other Pacific Islander= Native Hawaiian or Other Pacific Islander( Black or African American* Black or African American White White6569707277@ Black or African American, not Hispanic/LatinoB Black or African American, not Hispanic/Latinoa809823809779763714649623619658/ White, not Hispanic or Latino1 White, not Hispanic or Latino26282931333537 Gender Gender Female Female119126123118116124 Male Male125131109110- Persons aged 15 to 24 years/ Persons aged 15 to 24 years512558551545543514486463469489- Persons aged 25 to 34 years/ Persons aged 25 to 34 years198216220223219211214217231- Persons aged 35 to 44 years/ Persons aged 35 to 44 years718083787681425-2b Gonorrhea - Females aged 15 to 44 years (new1 cases per 100,000 population) [New]27927026727528942304278320354362434953144154153159165139413031261125913238894105111/ Females aged 15 to 24 years640615590598622/ Females aged 25 to 34 years180182189195208/ Females aged 35 to 44 years454648125-3 Primary and secondary syphilis - Domestic; transmission (new cases per 100,000 population)3.22.52.42.12.72.93.30.22.02.62.23.82.83.10.30.40.50.81.01.21.11.31.61.43.622.016.214.312.010.79.57.78.89.711.30.71.51.81.91.70.93.03.74.24.75.15.7 Sexual orientation825-4 Genital herpes infection - Adults (aged 20 to 29 years)1988-9417%--- = 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.24.340.3S25-5 National Health and Nutrition Examination Survey (NHANES), ǿֹ, NCHS8Focus area:25-Sexually Transmitted Diseases - 08-08-20089 Education level (persons aged 20 to 44 years)= Family income level (persons aged 20 to 44 years)TBDR m$ | 6  X& l &v0 V:fVS h"  _ <  {5@UR(  !_!!Y!"_""Y"#_##Y#Q% %''J'(aB))*T7+?,&--}.!/"/t00w1P12J A3 3g C4 15 5F Z6 6 ?7 72+8[88e99:L:::zb;;&<V<<(<[<= ?cc   L@|V.v9UVp.v,  dMbP?_*+%M \\FNCH-HVL-APP1.cdc.gov\PR-DHP7C od,,LetterDINU"(d ,^&tRB(SMTJHP LaserJet 4250 PCL 5eInputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALPaperSizeLETTERMediaTypeAUTOCollateONOutputBinAutoStaplingNoneHPPaperSizeALMConstraintsENV_10EconomodeFalseTextAsBlackFalseHPEnableRAWSpoolingTrueTTAsBitmapsSettingTTModeOutlineGraphicsModeRASTERMODERETChoiceTrueHPDuplicateJobNameOverrideSWFWAlternateLetterHeadFalseHPDocPropResourceDatahpzhl4wm.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPContentOrientationHPContentOrientation_OptionHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPJobByJobOverrideJBJOHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPPaperSizeDuplexConstraintsSTATEMENTHPMediaTypeDuplexConstraintsEXTRA_HEAVYHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1FalseHPManualDuplexPageRotateDriverRotateHPCustomDUplexableRange5.83x8.27_8.5x14HPPrintOnBothSidesManuallyFalseHPPrintInGrayScaleFalseHPStraightPaperPathFalseHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPZPE4wmHPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPJobAccWoPinTrueHPPngPassthroughTruePSAlignmentFileHPZLS4wmHPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEPSServices_DeviceandSuppliesStatusTRUEHPSmartHubInet_SID_263_BID_276_HID_265PSServicesOptionPrnStat_SID_242_BID_270_HID_15521HPConsumerCustomPaperHPCustomHPBornOnDateHPBODHPXMLFileUsedhpc42505.xml,IUPHdLetter o [none] [none]Arial4Pd?SYD0-DSS<Automatic>PR 44600dpiCustom Print SettingsdMicrosoft Office Excel<Domain Users;gp-f-724_Cust_Data;RADSASLaptops;CITGO Master Access Group;CG-CinDataShareLTASReadOnly;GP-Aehp_All;GP-Data2010;EDB_IRIS_APPLICATION_PRODGeneral Everyday Printing . ,EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEIPACDRWDSGATCAPI;F4E8Q;Ki݅&E%9xPPBHAERP"W,,??U} 9} } } } } }  } } C@ @@ @@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ . ///////////// * + + + + + + + +  +  +  +  +  + , - - - - - - - -  -  -  -  -  -                    O P P P P P P P P  P  P  P  P  P Q R S T U V W X Y  Z  Z  [  \  ] _ P P P P P P P P  P  P  P  P  P a R b c d e f g h  i  i  j  \  ] l R m n o o o o o  o  o  o  \  ] q R o o r s t t u V T v \ ] x R o o y h z { | }   \ ]  R           \ ]  R           \ ]  R o o | | | | | | | | \ ]  R o o | | | | |  |  |  |  \  ]  R o o | | | | |  |  |  |  \  ]  R  U X W v U X    X    \  ]  R o o             \  ]  R               \  ]  R               \  ]  P P P P P P P P  P  P  P  P  P  R o o o o o o o  o  o  o  \  ]  R o o o o o o o  o  o  o  \  ]  R o o o o o o o  o  o  o  \  ]  P P P P P P P P  P  P  P  P  P  P P P P P P P P  P  P  P  P  P  R               \  ] _ P P P P P P P P  P  P  P  P  P a R      1         \  ] l R   o o o o o  o  o  o  \  ] q R o o     |        \  ] x R o o     |  |  |  |  \  ]Dnl2 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@  R                  \ ] ! !R ! ! ! ! ! !@ ! !  !  !  ! \ ! ] " "R "o "o "| "| "| "| "| " | " | " | " \ " ] # #R #o #o #| #| #| #| #| # | # | # | # \ # ] $ $R $o $o $| $| $| $| $| $ | $ | $ | $ \ $ ] % %R % % % % % % % %  %  %  % \ % ] & &R &o &o & & & & & &  &  &  & \ & ] ' 'R ' ' ' '  ' '* '  '  '  '   ' \ ' ] ( (R ( ( ( ( ( ( ( (  (  (  ( \ ( ] ) )P )P )P )P )P )P )P )P ) P ) P ) P ) P ) P * *R *o *o *o *o *o *o *o * o * o * o * \ * ] + +R +o +o +o +o +o +o +o + o + o + o + \ + ] , ,R ,o ,o ,o ,o ,o ,o ,o , o , o , o , \ , ] - -P -P -P -P -P -P -P -P - P - P - P - P - P . .P .P .P .P .P .P .P .P . P . P . P . P . P / /R / / / /  / /3 / /  /   / ! / \ / ] 0_ 0P 0P 0P 0P 0P 0P 0P 0P 0 P 0 P 0 P 0 P 0 P 1a 1R 1 1 1" 1 1 1 1| 1 # 1 $ 1 % 1 \ 1 ] 2l 2R 2 2 2o 2o 2o 2o 2o 2 o 2 o 2 o 2 \ 2 ] 3q 3R 3o 3o 3 3& 3' 3' 3| 3 | 3 | 3 | 3 \ 3 ] 4x 4R 4o 4o 4( 4) 4* 4 4| 4 | 4 | 4 | 4 \ 4 ] 5 5R 5 5 5+ 5 5, 5% 5- 5 . 5 / 5  5 \ 5 ] 6 6R 6 6 6 6 6 6 6 6 0 6  6 1 6 \ 6 ] 7 7R 7o 7o 7| 7| 7| 7| 7| 7 | 7 | 7 | 7 \ 7 ] 8 8R 8o 8o 8| 8| 8| 8| 8| 8 | 8 | 8 | 8 \ 8 ] 9 9R 9o 9o 9| 9| 9| 9| 9| 9 | 9 | 9 | 9 \ 9 ] : :R : :2 :2 : :3 : :2 : 4 : 5 : 6 : \ : ] ; ;R ;o ;o ; ; ; ; ; ;  ;  ;  ; \ ; ] < <R < < < <7 <8 <% <9 < / < : < ; < \ < ] = =R = = = =< == = => =  =  =  = \ = ] > >P >P >P >P >P >P >P >P > P > P > P > P > P ? ?R ?o ?o ?o ?o ?o ?o ?o ? o ? o ? o ? \ ? ]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@[@\@]@^@_@ @ @R @o @o @o @o @o @o @o @ o @ o @ o @ \ @ ] A AR Ao Ao Ao Ao Ao Ao Ao A o A o A o A \ A ] B BP BP BP BP BP BP BP BP B P B P B P B P B P C CP CP CP CP CP CP CP CP C P C P C P C P C P D DP DP DP DP DP DP DP DP D P D P D P D P D P E E E E E E E E E E  E } E  E \ E  F_ FP FP FP FP FP FP FP FP F P F P F P F P F P Ga G G? G G G G G G G  G e G  G \ G  Hl H Ho H H H H H Ho H o H o H o H \ H  Iq I I| I I I I I I| I | I | I | I \ I  Jx 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 LZ 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 Ss S S S S S St S Y S T S  S \ S  T TP TP TP TP TP TP TP TP T P T P T P T P T P U U Uo U U U U U Uo U o U o U o U \ U  V V Vo V V V V V Vo V o V o V o V \ V  W W Wo W W W W W Wo W o W o W o W \ W  X XP XP XP XP XP XP XP XP X P X P X P X P X P Y YP YP YP YP YP YP YP YP Y P Y P Y P Y P Y P Z Z Z< Z Z Z Z Z Z Z  Z @ Z 0 Z \ Z  [ [ [ [ [ [ [ [ [ [ z [  [ A [ \ [  \ \P \P \P \P \P \P \P \P \ P \ P \ P \ P \ P ] ]R ] ] ] ] ] ] ] ]  ]  ]  ] \ ]  ^_ ^P ^P ^P ^P ^P ^P ^P ^P ^ P ^ P ^ P ^ P ^ P _ _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@{@|@}@~@@ ` `R `  `  `  `  `  `  `  `  `  `  ` \ `  a aR ao ao ao ao ao ao ao a o a o a o a \ a  b bR bo bo bo bo bo bo bo b o b o b o b \ b  c cR co co co co co co co c o c o c o c \ c  d dR do do do do do do do d o d o d o d \ d  e eR e  e  e  e  e  e  e  e  e  e  e \ e  f fR fo fo f f f f f f  f  f  f \ f  g  gR g  g  g  g  g g g g  g  g  g \ g  h hR h  h  h  h  h  h  h  h  h  h  h \ h  i iP iP iP iP iP iP iP iP i P i P i P i P i P j  jR j! j j" j" j j# j$ j % j $ j & j \ j  k( kR k) k* k k* k k k k + k , k  k \ k  l lP lP lP lP lP lP lP lP l P l P l P l P l P m mR mo mo mo mo mo mo mo m o m o m o m \ m  n nR no no no no no no no n o n o n o n \ n  o oR oo oo oo oo oo oo oo o o o o o o o \ o  p pP pP pP pP pP pP pP pP p P p P p P p P p P q qP qP qP qP qP qP qP qP q P q P q P q P q P r. rR r/ r0 r1 r2 r3 r4 r5 r 6 r 7 r 8 r \ r  s: sR s; s< s= s= s> s? s@ s A s B s C s \ s  tE tR t F t G t H t G t I t I t J t J t I t K t \ t  u uP uP uP uP uP uP uP uP u P u P u P u P u P vL vP vP vP vP vP vP vP vP v P v P v P v P v P wM w wN w w w w w wO w P w Q w R w \ w S x_ xP xP xP xP xP xP xP xP x P x P x P x P x P y y yT y y y y y yU y V y W y X y \ y S z z z Y z z z z z z Z z Y z [ z Y z \ z S { { {o { { { { { {o { o { o { o { \ { S | | |o | | | | | |o | o | o | o | \ | S } } }o } } } } } }o } o } o } o } \ } S ~ ~ ~o ~ ~ ~ ~ ~ ~o ~ o ~ o ~ o ~ \ ~ S   \      ]  ^  _  `  \  SDl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@             \ S    a      b c d e \ S    f       g  h i \ S  P P P P P P P P P P P P P   o      o o o o \ S   o      o o o o \ S   o      o o o o \ S  P P P P P P P P P P P P P  P P P P P P P P P P P P P j  k      l m n o \  p  q      r s t u \  v   w       w x y Z \   P P P P P P P P P P P P P z P P P P P P P P P P P P P { R !| !} !~ ! ! !~ !} ! ! ! \ ! ^ P P P P P P P P P P P P P  R ! ! !~ ! ! ! ! ! !~ ! \ !  R ! ! ! ! ! ! ! ! ! ! \ !  R o o o o o o o o o o \ !  R o o o o o o o o o o \ !  R o o o o o o o o o o \ !  R o o o o o o o o o o \ !  R ! ! ! ! ! !} ! ! !| ! \ !  R           \ !  R      ! ! ! !  \ !  R ! ! ! ! ! ! ! ! ! ! \ !  P P P P P P P P P P P P P  R ! ! ! ! ! ! ! ! ! ! \ ! ' R ! ! ! ! ! ! ! ! ! ! \ !  P P P P P P P P P P P P P  R o o o o o o o o o o \ !  R o o o o o o o o o o \ !Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  R o o o o o o o o o o \ !  R o o o o o o o o o o \ !  P P P P P P P P P P P P P  P P P P P P P P P P P P P   " \ \ \ \  \ \ \  \ " ^ P P P P P P P P P P P P P `   \ \ \ \  \ \ \  \ " k   \ \ \ \  \ \ \  \ " p  o \ \ \ \  \ \ \  \ " w  o \ \ \ \  \ \ \  \ " ~   \ \ \ \  \ \ \  \ "    \ \ \ \  \ \ \  \ "   o \ \ \ \  \ \ \  \ "   o \ \ \ \  \ \ \  \ "   o \ \ \ \  \ \ \  \ "   | \ \ \ \  \ \ \  \ "   " \ \ \ \  \ \ \  \ "    \ \ \ \  \ \ \  \ "    \ \ \ \  \ \ \  \ "    \ \ \ \  \ \ \  \ "  P P P P P P P P P P P P P    \ \ \ \  \ \ \  \ " '   \ \ \ \  \ \ \  \ "  P P P P P P P P P P P P P   " \ \ \ \  \ \ \  \ "   " \ \ \ \  \ \ \  \ "   " \ \ \ \ ! \ \ \  \ "  P P P P P P P P P P P P P  P P P P P P P P P P P P P "  ## \ \ \ \ $ \ \ \ \ \  %  " \ \ \ \  \ \ \  \  &  " \ \ \ \ ' \ \ \ ( \ Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ )  " \ \ \ \  \ \ \  \   P P P P P P P P P P P P P * + ",        \ \ \  ^ P P P P P P P P P P P P  ` + |        \ \ \  k + o        \ \ \  p + |        \ \ \  w + |        \ \ \  ~ +         \ \ \   +         \ \ \   + |        \ \ \   + |        \ \ \   + |        \ \ \   + |        \ \ \   +         \ \ \   +         \ \ \   +         \ \ \   +  "   P P P P P P P P P P P P P  + ".        \ \ \   + "        \ \ \   + "/        \ \ \   P P P P P P P P P P P P  1 + "        \ \ \  2 + "        \ \ \  3 + "-        \ \ \   P P P P P P P P P P P P P  P P P P P P P P P P P P P " + "-        \ \ \  4 + "5        \ \ \  6 + "        \ \ \ Dl4@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 7 + "        \ \ \  8 + "        \ \ \  9 + ",        \ \ \  : + ";        \ \ \   P P P P P P P P P P P P P < P P P P P P P P P P P P P = > #? \ \ \ \ #@ \ \ \ \ \ #@ ^ P P P P P P P P P P P P P  > | \ \ \ \ | \ \ \ \ \ #@  > | \ \ \ \ | \ \ \ \ \ #@  > o \ \ \ \ o \ \ \ \ \ #@  > o \ \ \ \ o \ \ \ \ \ #@  > "A \ \ \ \ ## \ \ \ \ \ #@  > #B \ \ \ \ #@ \ \ \ \ \ #@  > #? \ \ \ \ ## \ \ \ \ \ #@  > #? \ \ \ \ #@ \ \ \ \ \ #@  > "A \ \ \ \ #B \ \ \ \ \ #@  > #B \ \ \ \ #@ \ \ \ \ \ #@  P P P P P P P P P P P P P  > "C \ \ \ \ #B \ \ \ \ \ #@  > "A \ \ \ \ ## \ \ \ \ \ #@  > #? \ \ \ \ #@ \ \ \ \ \ #@  P P P P P P P P P P P P P 1 > " \ \ \ \ #B \ \ \ \ \ #@ 2 > #D \ \ \ \ ## \ \ \ \ \ #@ 3 > #B \ \ \ \ #@ \ \ \ \ \ #@ E P P P P P P P P P P P P P F >  \ \ \ \ "A \ \ \ \ \ #@ G >  \ \ \ \ #H \ \ \ \ \ #@  P P P P P P P P P P P P P I P P P P P P P P P P P P P J > " \ \ \ \ "/ \ \ \ \ \ " Dl@@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ ^ P P P P P P P P  P  P  P  P  P  > | \ \ \ \ | \  \  \  \  \  "  > | \ \ \ \ | \  \  \  \  \  "  > o \ \ \ \ o \  \  \  \  \  "  > o \ \ \ \ o \  \  \  \  \  "  > "K \ \ \ \ ", \  \  \  \  \  "  > " \ \ \ \ "; \  \  \  \  \  "  > L \ \ \ \ | \  \  \  \  \  "  > " \ \ \ \ "M \  \  \  \  \  "  > "N \ \ \ \ "O \  \  \  \  \  "  > " \ \ \ \ "/ \  \  \  \  \  " 0 P P P P P P P P  P  P  P  P  P 1 > L \ \ \ \ | \  \  \  \  \  " 2 > P \ \ \ \ "O \  \  \  \  \  " 3 > " \ \ \ \ "Q \  \  \  \  \  " E P P P P P P P P  P  P  P  P  P F >  \ \ \ \ | \  \  \  \  \  " G >  \ \ \ \ | \  \  \  \  \  "  P P P P P P P P  P  P  P  P  P  P P P P P P P P  P  P  P  P  P - > "M \ \ \ \ "R \  \  \  \  \   9 > " \ \ \ \ "S \  \  \  \  \   D > "O \ \ \ \ " \  \  \  \  \    P P P P P P P P  P  P  P  P  P T P P P P P P P P  P  P  P  P  P U   \ \ \ \ \ \  \  \  \  \  \  P P P P P P P P  P  P  P  P  P V P P P P P P P P  P  P  P  P  P W R X    Y  Z  [  \  \  $]  $^  $]  \  $_ ` P P P P P P P P  P  P  P  P  P  R  \  a  b  Y  c $^ $d  $d  [  [  \  $_  R $^ $d $d $e $f $d $g  $f  $g  $h  \  $_Dl @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@  R o o o o o o o  o  o  o  \  $_ ! !R !o !o !o !o !o !o !o ! o ! o ! o ! \ ! $_ " "R "o "o "o "o "o "o "o " o " o " o " \ " $_ # #R #o #o #o #o #o #o #o # o # o # o # \ # $_ $ $R $ i $  $  $  $  $ j $ c $ Y $ a $ Y $ \ $ $_ % %R % % % % % % % %  %  %  % \ % $_ & &R &# & k & l & m & n & n &  &  &  & o & \ & $_ ' 'R '$h '$f '$p '$p '$p '$p '$p ' $p ' $_ ' $p ' \ ' $_ ( (P (P (P (P (P (P (P (P ( P ( P ( P ( P ( P ) )R )o )o )o )o )o )o )o ) o ) o ) o ) \ ) $_ * *R *o *o *o *o *o *o *o * o * o * o * \ * $_ + +R +o +o +o +o +o +o +o + o + o + o + \ + $_ , ,P ,P ,P ,P ,P ,P ,P ,P , P , P , P , P , P -%B -o -o -\ -\ -\ -\ -\ -\ - \ - \ - \ - \ - \ . .P .P .P .P .P .P .P .P . P . P . P . P . P /%C /P /P /P /P /P /P /P /P / P / P / P / P / P 0q 0P 0P 0P 0P 0P 0P 0P 0P 0 P 0 P 0 P 0 P 0 P 1r 1s 1"t 1 1 1\ 1"u 1\ 1"v 1 \ 1 "v 1 \ 1 \ 1 "w 2_ 2P 2P 2P 2P 2P 2P 2P 2P 2 P 2 P 2 P 2 P 2 P 3a 3s 3| 3 3 3\ 3| 3\ 3| 3 \ 3 | 3 \ 3 \ 3 "w 4l 4s 4o 4 4 4\ 4o 4\ 4o 4 \ 4 o 4 \ 4 \ 4 "w 5q 5s 5 5 5 5\ 5 5\ 5 5 \ 5  5 \ 5 \ 5 "w 6x 6s 6| 6 6 6\ 6| 6\ 6| 6 \ 6 | 6 \ 6 \ 6 "w 7 7s 7 7 7 7\ 7 7\ 7 7 \ 7  7 \ 7 \ 7 "w 8 8s 8 8 8 8\ 8 8\ 8 8 \ 8  8 \ 8 \ 8 "w 9 9s 9| 9 9 9\ 9| 9\ 9| 9 \ 9 | 9 \ 9 \ 9 "w : :s :| : : :\ :| :\ :| : \ : | : \ : \ : "w ; ;s ;| ; ; ;\ ;| ;\ ;| ; \ ; | ; \ ; \ ; "w < <s <"x < < <\ <"y <\ <"z < \ < "z < \ < \ < "w = =s = = = =\ = =\ = = \ = "u = \ = \ = "w > >s >", > > >\ >". >\ >"K > \ > "N > \ > \ > "w ? ?s ?"{ ? ? ?\ ?"| ?\ ?"} ? \ ? "| ? \ ? \ ? "wDl@@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@[@\@]@^@_@ @ @P @P @P @P @P @P @P @P @ P @ P @ P @ P @ P A  As A"y A A A\ A"| A\ A"{ A \ A "u A \ A \ A "w B( Bs B"~ B B B\ B"y B\ B"y B \ B "y B \ B \ B "w C CP CP CP CP CP CP CP CP C P C P C P C P C P D Ds D" D D D\ D" D\ D" D \ D " D \ D \ D "w E Es E"v E E E\ E"} E\ E"w E \ E "| E \ E \ E "w F Fs F" F F F\ F"~ F\ F" F \ F "z F \ F \ F "w G Gs G" G G G\ G". G\ G" G \ G " G \ G \ G "w H Hs Ho H H H\ Ho H\ Ho H \ H o H \ H \ H "w I IP IP IP IP IP IP IP IP I P I P I P I P I P J JP JP JP JP JP JP JP JP J P J P J P J P J P K Ks K K K K\ K K\ K K \ K  K \ K \ K "w L Ls L L L L\ L L\ L L \ L  L \ L \ L "w M Ms M M M M\ M M\ M M \ M  M \ M \ M "w N Ns No N N N\ No N\ No N \ N o N \ N \ N "w O OP OP OP OP OP OP OP OP O P O P O P O P O P P%D PP PP PP PP PP PP PP PP P P P P P P P P P P Q QP QP QP QP QP QP QP QP Q P Q P Q P Q P Q P R Rs R" R R R\ R" R\ R" R \ R " R \ R \ R " S_ SP SP SP SP SP SP SP SP S P S P S P S P S P Ta Ts T| T T T\ T| T\ T| T \ T | T \ T \ T " Ul Us Uo U U U\ Uo U\ Uo U \ U o U \ U \ U " Vq Vs V V V V\ V V\ V V \ V  V \ V \ V " Wx Ws W| W W W\ W| W\ W| W \ W | W \ W \ W " X Xs X X X X\ X X\ X X \ X  X \ X \ X " Y Ys Y Y Y Y\ Y Y\ Y Y \ Y  Y \ Y \ Y " Z Zs Z| Z Z Z\ Z| Z\ Z| Z \ Z | Z \ Z \ Z " [ [s [| [ [ [\ [| [\ [| [ \ [ | [ \ [ \ [ " \ \s \| \ \ \\ \| \\ \| \ \ \ | \ \ \ \ \ " ] ]s ]"K ] ] ]\ ]" ]\ ]" ] \ ] "O ] \ ] \ ] " ^ ^s ^ ^ ^ ^\ ^ ^\ ^ ^ \ ^ " ^ \ ^ \ ^ " _ _s _" _ _ _\ _" _\ _" _ \ _ " _ \ _ \ _ "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@{@|@}@~@@ ` `s `" ` ` `\ `" `\ `" ` \ ` " ` \ ` \ ` " a aP aP aP aP aP aP aP aP a P a P a P a P a P b  bs b"- b b b\ b"/ b\ b"M b \ b "- b \ b \ b " c( cs c" c c c\ c"O c\ c", c \ c " c \ c \ c " d dP dP dP dP dP dP dP dP d P d P d P d P d P e es e"O e e e\ e" e\ e" e \ e " e \ e \ e " f fs f", f f f\ f" f\ f" f \ f "N f \ f \ f " g gs g", g g g\ g" g\ g"M g \ g "M g \ g \ g " h hs h"/ h h h\ h"; h\ h"S h \ h "/ h \ h \ h " i is io i i i\ io i\ io i \ i o i \ i \ i " j jP jP jP jP jP jP jP jP j P j P j P j P j P k kP kP kP kP kP kP kP kP k P k P k P k P k P l ls l l l l\ l l\ l l \ l  l \ l \ l " m ms m m m m\ m m\ m m \ m  m \ m \ m " n ns n n n n\ n n\ n n \ n  n \ n \ n " o os oo o o o\ oo o\ oo o \ o o o \ o \ o " p pP pP pP pP pP pP pP pP p P p P p P p P p P q%E qP qP qP qP qP qP qP qP q P q P q P q P q P r rP rP rP rP rP rP rP rP r P r P r P r P r P sr ss s" s s s\ s" s\ s" s \ s " s \ s \ s " t_ tP tP tP tP tP tP tP tP t P t P t P t P t P ua us u| u u u\ u| u\ u| u \ u | u \ u \ u " vl vs vo v v v\ vo v\ vo v \ v o v \ v \ v " wq ws w w w w\ w w\ w w \ w  w \ w \ w " xx xs x| x x x\ x| x\ x| x \ x | x \ x \ x " y ys y y y y\ y y\ y y \ y  y \ y \ y " z zs z z z z\ z z\ z z \ z  z \ z \ z " { {s {| { { {\ {| {\ {| { \ { | { \ { \ { " | |s || | | |\ || |\ || | \ | | | \ | \ | " } }s }| } } }\ }| }\ }| } \ } | } \ } \ } " ~ ~s ~"{ ~ ~ ~\ ~"v ~\ ~"| ~ \ ~ " ~ \ ~ \ ~ "  s    \  \   \  "  \  \  "Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  s "   \ " \ "  \  "  \  \  "  s "{   \ "| \ "  \  "  \  \  "  P P P P P P P P  P  P  P  P  P   s "   \ " \ "|  \  "w  \  \  " ( s "   \ " \ "  \  "  \  \  "  P P P P P P P P  P  P  P  P  P %F P P P P P P P P  P  P  P  P  P  o o \ \ \ \ \ \  \  \  \  \  \  P P P P P P P P  P  P  P  P  P %G P P P P P P P P  P  P  P  P  P   #@  \ \ \ \ \  \  \  \  \  "  P P P P P P P P  P  P  P  P  P %H P P P P P P P P  P  P  P  P  P  P P P P P P P P  P  P  P  P  P  o o \ \ \ \ \ \  \  \  \  \  \  P P P P P P P P  P  P  P  P  P %I P P P P P P P P  P  P  P  P  P  P P P P P P P P  P  P  P  P  P  o o \ \ \ \ \ \  \  \  \  \  \  P P P P P P P P  P  P  P  P  P %J P P P P P P P P  P  P  P  P  P  P P P P P P P P  P  P  P  P  P           N      \  "  P P P P P P P P  P  P  P  P  P %K P P P P P P P P  P  P  P  P  P  P P P P P P P P  P  P  P  P  P         5      y  \  "  P P P P P P P P  P  P  P  P  P %L P P P P P P P P  P  P  P  P  P  o o \ \ \ \ \ \  \  \  \  \  \  P P P P P P P P  P  P  P  P  P %M P P P P P P P P  P  P  P  P  PDl@@@@@ @ @@@@@@@@@@@@@@@@@ @@ @@@@@@@  P P P P P P P P  P  P  P  P  P  o o \ \ \ \ \ \  \  \  \  \  \  P P P P P P P P  P  P  P  P  P %N P P P P P P P P  P  P  P  P  P  o o \ \ \ \ \ \  \  \  \  \  \ & &&&&&&&&&&&&&       ' ' ' ' ' ' '     ( ((((((((((((( ) )))))))))))))       D:l222@@@@@@@@@@@@@@@@@@@@@@                      0>@d  7 Sheet1 Module1 __SRP_2 __SRP_3oThisWorkbook3  !"#$%&')*+,-./0123456789;<=>?@ABCDFGHIJKLMNOPQRSTUVXY[]^_`abcdefhijklmnopqstuvwxyz{|~"mmxME (6 <<< `@pXJ)Macro recorded 2/18/99 by Thomas C. Soceyle 14%HxI$*\Rffff*1?49eda6a0"  ((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 BExposeTemplateDerivBustomizD2Sheet14(IModule2:Module3Ex__SRP_4 W     ! "(#$%&')*+,-./02N456789:;<=>?1<CmN #)ȠPE`PGb F 9c+KwOE-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@49eda6a0"  ( &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}Module8Module95Module10&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*1A49eda6a0 "   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*1B49eda6a0 "   0( X `<Wh Macro8 Macro* Macro recorded 12/18/2001 by Thomas Socey'B'D HF LJN &B@@oPH"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)DKModule213@__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*1C49eda6a0+" 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!vxArial9Regular9x!@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 Vlkc 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ǺActiveCell.V Cn;R If "Obj5," Then*a2t w l{{?jOffset(0,)s?i=?raw> ^"?"R H se QE -1K9Standardb& errorColumns().Width#79End IfW>" A@W@>1t:\JLoopAArU~| 0  krU $`n__SRP_fgModule26*.u__SRP_100T__SRP_11-2gst find the row which has the titles''''''' aB  'A $$ $B@H j!p' $' $'  Objective j!'p''' a$  '  j%l!p' j% $' $' YearG'jl   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  $' $' -  (|mQxME(6 << <x `::p%H@I$*\Rffff*1F49eda6a0:" .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:usehol''d STATE: ''kk       j%!vj!pArial9'Bold9x'#@9zp9|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'ec STATE:bjecti''d STATE: ''k k       j%!vj!pArial9'Bold9x'#@9zp9|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  j!p j(pdp    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27 j  j!p j(pk k kx kp kh k` ' a3  j%l!'b(p b$B@H 8 &9  &9$9(9*9,9.90q j!p' j $' $' '  j(p '  a'J'L Ja L 'L  L$'N N\'  L $  L  L $ ''J  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q8  j(P j R j%!v LArial9Regular9x#@9z9|9~999 9 9q T X j%!v9Arial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj 9 $'J < D N - #''''''''' a'  '  $' -'d $$' dx ..'''dH %'%'Pd  .' 0 'd  0 'kkkkkk  G'j stop5       8(:Gk  hdashk notk gotsuper  k celllen j!'   G'j stop4pe  'A $$ $B@H1 goto next linetop4 8 &9  &9$9(9*9,9.90q0 j!p'!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'p STATE:ATE:''d STATE:ATE:''kkx       j%!v!vArial9iaBold9xBold#@9z9|9~999 9 9qkd   j(pA add 7 to 15 7 t  j!p j(p kPkH j%l!' '  $!v(  $-----' j!'!''kd   j(p: add 5 to 12  j!p j(p j!p $'' j!p$'''' j!p'p STATE:ATE:''d STATE:ATE:''kk       j%!v!vArial9iaBold9xBold#@9z9|9~999 9 9qkd   j(p> add 7 to 15 7 t  j!p j(p dh     j(p@ add 9 to 18 9  j!p j(p d     j(pC add 11 to 211 to  j!p j(p d     j(pF add 13 to 243  j!p j(p d     j(pI add 15 to 275 to 2  j!p j(p kkkkkxkpkhk`% until stop3 - end of objective titlee d(' a j%l!'b!' b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $'J 'J  j(p'  $'J'L Ja L 'L  L$'N N\ '  L $  L  L $ '$  j(p j L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q  j(P9 R j%!v j%Arial9Regular9x#@9zx9|9~999 9 9qX T X j%!vL Arial9jRegular9x#@9z9|9~999 9 9q'Jk L G'Jj ' $' < D N - #''''''''' a.'  '  $' -'dh $$'pd@ ..'H'd %%' d  0 'd  0 'kkkkkxkp  G'j stop5        8(:k  hdash k not k gotsuperj!pk celllen j!'  G'j stop4  'A $$ $B@H j!p'-- $' j%l!p'@ $-----  ' $-----' j!' k''kx '(p $' '   '   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:!v''dP STATE:''k k       j%!vArial9 Bold9x #@9z 9|9~999 9 9qhk`dX    j(p= add 7 to 15  j!p j(p d       j(p@ add 9 to 18  j!p j(pdx     j(pC add 11 to 21p  j!p j(pd     j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27p1=1  j!p j(pk k k k k k k k until stop2!p until stop1=1 '' '' a$A $$ $B@H j!p' $'B@ $'p j%l!p'$ $-----  8B@A $$ $B@H j!p' $'RC $' j%l!p'B@kH  'd  DATA ISSUES  DATA SOURCEA $$ $B@H$  '  DATA SOURCE' 8!B@ Objective j(p  '  $ $$ 'A $$ $B@H number j!p j(pA  $$ :  $B@Hd  DATA ISSUES', j!p j(p&9$  $ $$ 'A $$ :  $B@H(6kk 8 "9  &9$9(9*9,9.90qh 8 4 8%2(6 8 : 8%2(6 < 8%2(6 >96 B9@ 9q D 8%2x >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$'Nj N\j  L $  L  L $ 'A $$ $B@HAria  j(pRegu  j(P L 'R L'T 'V9 V R 'X R j%!v j%Arial9Regular9x#@9zx9|9~999 9 9q  T X j%!vL Arial9jRegular9x#@9z9|9~999 9 9q'Jkx L G'JjXkPdH  $' $'Z ' $' $' $'no $' n $'b 'f   $'0dH'k8'\normal of '^ 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'b \ '\ ^ '^'`kk       j(pinuati j!p'pd`'b'`kH' Z G ^ '^j` - is not a continuation line j!p \$'d ^ 'fd? ^ ` 'fdp? ^ ` 'fd@? ^ ` 'fd? ^ ` 'fd> ^ 'fk>k>k>k>k>k> Zf Zi Zj Zl Zr ZtG f 'fj Zm ZA ZBG f f $'fj bG f 'fj b ` Z G f 'fj j!p \  \ $'h d f h j(pd0= -" is a continuation line 'd, 19 d j!p j(pk<k<k<k<k<k<  ' until stop1=1k continuesw = 1  'j G j 'jj l!n$ j $$ : $ $$ 9p9rq; l!n(t l!n9v9x9z9|9~9? %9? %9 %9 %9? %9? %999 999 9*9 9 99d9qx:A2:P4$B@H 8 &9  &9$9(9*9,9.90q: 8!vArial9 Bold Italic9x 9z9|9~999 9 9q9B6:B2000$B@H 8 "9  &9$9(9*9,9.90q89A1$!v( R1C1 B@o98ŵAttribute VB_Name = "Module26" Sub PI() ' First find the row which has"titles cvaluonP= 0 oncolmaxstop1haveyear obj;Do Until -1 ^ + Range("A" + Trim(Str(#))).Se0lect@VActiveCell.V_ "=ER If "Obj7." Txhen,]o=Row u2  ) Off@set(0,)C >GIY?~CH@Ɓ3J " nA.1/M"_!NElseb FYLColumzendad`dress#AKC E;IfL8oopC'  forC,!L dh"$ lettep"w3DspacD|$v+ 2mE@_r @Z1@!wherew@ ¦nqA!Ha=(81currc Є?ydK$ With io.Horiz`oalAlignmbeBtxlC! .Verticnt$ .WrapTexqyFaߍ@ .Oria^t 0<P .I x,6Nerc( K1QO1AMak + #7+ 5./  Vno/!~thiscolVolum_Qmax]f404o|nrBsd"A" + Trimr(r))Po n!C δl.Value $ cvx = RTrim(p)|beforeq|Lentzxaftervdiff(a- -zhold MidQx, 10 "2#6"If >'"Race and ethnicity") Or Mother's rGender!Worksite onl0f"Classeps at a"STATE:& 5)g-r (head of house) ThenzA3@Ke7 OAActiveCel!" + ' add 5 to 12A P sp]+ MNAFM 3, Ɂ['A 3-T 5S sPtart 0!lenWAv (HE&?^4ł`@ $19'O$%18OEls`B!T212%EoIf > 0!!WithIFChFaws(SA7:=, 1gth:=( $2 - %)).Font!Q.Nam"A`rial"RaShtylBSDiz!9.5Strikrou$ghTFa4 .SuperscPriptb.OutlineA hadowZUg xlb#N onNColorI xAutomatic$GA=oJ]Iě8TIt`"Ed.7"?: ? pdstoploc( Offset(-0).Addrxessl>,ldApuet"@t׀PtW?a2XaBZ=A[-2t t> p-$}ta@ t EtƶrCtt_@"CbQtQttt ttߦwt}.t).tttp?tIt.Sty.trFt.ttA"t#. $trZr:04t<t$1ſ?m_:: 9B߹1)j! `Z9Z TwZ 1 f= " " + cvalue ' add 11 to 21 ActiveCePll.V^=^sppace : |Else If d iff =pThen {o+:34!Uzb2 +bd5d7Kdnd IfEJstop4|0Do Untild (1)K@F currc@Offset(0, 1).AddressRange(E).Select Wit$h Cioϣ.HorizontalAlignmeDnt"xlCer.Vertice WrapTe2xFa@.Ori@at'P?IndShrinkToFi Merg}>s a;%nE= wXTrim(cc>= R@Clen Len Cgotsuper@-aQH> 0S Y65lettercbHo9 bb ) (+ bE3MidD%,?Ai a"\" 'C FI1 -R`%1-gI$@Etos…%+$sdF2De _Ͽ_M= _M!_M`_Me_M _M._M܆0>._M_M#FormulaR1C>1D"Charac?s(Start:=@,PK gth:=&).FfO#.Name"Arial"StylReg r .Siz9.5ogStrikethroughO?g'.STscripgTruob.Outline#adowUurxlNon '.Color!yxAutom{cOD/($$G, %E%% )%9%Y%z%_"p-u/%+/%/%./%&/%/%/%[/%\E?zckжo Loop?0PYpc05LNot (A"<") AUDN-#O%rhdolla!"Wh`iod oW acxbzer oeѻg  azeroes = "" Hpsw0B hdashFcntiFstop5FDo Untitl ,1v(!+ 1)letterAMid(cvalue, ,If "-" Then6ObElse %>$>olla;"$Y*l .e @period\".\ !CJIj%h*Pcent*%?Kf6 bE+ l"0!1/ '% End IfW  w `"Bcelllenb( Loop 'C#zF4 Selection.NumberFor$maVhd|+ Gh$o+:+ aa\X#`n otrgots>u@d+thiscol/AveC0.ColumЮ )maxwB04`44Konro Range("A" + Tri@m(Str(b)8)).#4'o next linMWith9 G.HorizontalAlign"mxlCerVerticnnWrapT! = Fag .Oria&}.AddInd0? .ShrinkToFi*OBMergr?<[ s{!V|oue`RSbefor1LenO1 91af3?diffp(- holqr1P0od2|6l1 "Race apZethnicity") Or (Mothe`r's rG er.Worksite onlT "Class9atdq "STATE:lt5) -O (head of@ house!)`qt7X -'qA$#p' 12)O addsp+.? #3, w Q3 _A15_Qstarta@nA1 *% /r@ 19zA 18Oq~92oq2tp Px> 0d8<Isi:=C, gth:=(0 2 -0kFf``NamQ"Arial.StylrBLoaSiz89.5 tikIrouga`@ !.Sscrip_e4tb_.OutyA `1_slad2/%UgQxlNNobortx!RAutoicOp`# Else If diff = 8 ThenActiveCell.Va(lueZ" " + cv8' add 7 to 15%O2spaceF mBEnd If'stoploc[(.Offset(-1, 0).AddreXss)*31 Range(start/, 4).Font.BoldTruMid(, B5)"-" c-inueswÍCpedro 0mWith @Characters(Sa~:=, 1@gth:=(`2h - A)À).NamAria l"RAStylGASiz!9.R.Strikethrough xFa .Supcript bsOutline hadUnder  xlb#NonpColorI xAutomaticQ-GA=oJu ` ?/ 09 Or (befor%1)1Q `Z9 Cჿ+ 1o= <ϏfD 11! I}/=/ Ǔ/ ( 1 /D |13R 4K__ _ sX 2_ Q_ R27 ߪ1? ??! SqLoop ' until3ge of obje titlQ14HtDo U`op1_ currc0x0p C).Sel0 |wio_.HorizalAl@ignmenQkx$lCerN.Vler_n|WrapTexpu0.Orieon?Pgb mq.ShrinkToFiBMergsp#"k=J= TrimDogR5!  Qs S= gots Fߜf .F6letp cK1QO1+  ã,g4Pc "\]R gotsuper = 1  8cvalue!Mid(, 1, lettercnt - 1) + >8+VcelllenR)pActiveC2.Vzv1toselect(y2sd3De/*eRange(curr1).SS3With ionB.HorizontalAlignme= xlC erVerticWrapTexNFalseOri@at'X0AddIndShri@nkToFiM(erg}sEn+ #7+ 5./  ˴ End If ' not gotsup er celllenthiscol = Ac tiveCP.Cpolum,/max8Then stop4C1 `pLoop o0nrow0+  8Range("A" + Tri@m(Str())).Seleccvalue(cV ;R+ )2%Offset(1, 0).,(Mid(I(, 5)!"-") Or  " A4"Dz continue>sZ XAAfpedbHNRowO"01;AQbeforpL 0!Withhar4acas@7:= , 1gth:=( $2 - % F" .Nams"Aria l"RaStylBRSiz!9.5ikethroughT,Fa4@SscPriptb.Outline1 hadUnder xlqb#NonNorI xAut@omaticO A"#$M8$p+)$rn M0M7MO-?Mu ?: 9t&c|1)  d 9 oC  1O=2 11! I}=/ "/ ) 1 / / q1_ 3R 4.__ _ so%g%12_ Q_ R 27 71@If+/@Cſ| uu l>1r=r Ws0ourcsiss="R ÅCDo Uŏez @"%?ƥSM+ ion.Dte Shift:=hp0*0?=Ci6O (H"mɩADATA ISSUES"gg@SOURCE/ // qƴLen(endaddress) @- 1 If cvalue = "DATA SOURCE"` Then dsourceswV 4Selection.EntireRow.InPsert CA%veCell.VwObjryxlb;61D._+_+d q*ggY(e A`T0 c`len aσ|.Yf> _ 0stop6pO lettercY Do U@l (U1MT("33 P 0"\|RE\ᑖ`R y׿P ,-W ewGUtO6XFormulaR1C1PtosҫH/$sd&cT,!o,4hDe- U BbHCharac-sЯart:= gth:=Q.R kShRegr,S.S.5gTOyUTruJV;&.OW .SXXeYXYL $$0, %u+)%%%la%%.%%%tSu{+/%;|/% #%ϴline = x@lUnderStyleNone .Col(orIxxAutomaticfEnd WithA@stop6L1!?IfIf lettercntAcellle0n ThVLoop Q 3Els4sourcesNwT0 dh Mid(cvalue, 3, 1) meas 6 lLen!rZ112 2, 2"3 4O45er 2e >= 7J2M7, l - 5*_@ ""UCl~partAJ7 'normalG numpchaBra5 ' secondP0 A"\FjA"0" OrBB A = -2-dash a& digit of first pair D3spac~e-D4 4bn&(f+S>Not @t:@&)oJ $g+ :KmI,, 5? Dcd bi" "@4no !urѰ`, w+@ 0R13o@1`2%32eS!"0G 49 ?j`/0"m\ U2wU!UActiveC.V01 +Ž2t3t4tDi]>#6@  C addCK= iTEtu 43 A_@B{"-7is@at a `tinupon ]LrleC)N(` 3Ld<9 4 A !$0^617P 5 Mp[= `! 6?_?@4____oqU8f2iUjlrt49s!mm:zAB;R0, QM)p|0xLRrt:bpSG (l812,t Te0h?HH.I LP^߱AbqAbq3 .A EUX' PUU_΍ģ+"`19o ra  3{}1d:WonrosgQ @until 1v=0} Tg4 dela(obj1-Rhaveyea}#I s 1 Sheet`.PageSet up .PrintTitleRows = "$" + Trim(Str(d@elrow1H1d)) ":< Ho$bjH))CoPlumn" End With ActiveSheetArea73 .I.LeftHeader9Center Righ(Foo( ( (Margin(Application.InchesToPos(0.75 )1Top!1 Bottom CW 0. 7J0ingFalseȃGridlineCommxl NoorizontallypM 0VertvOri@B}xlLa@ndscap .DraftFirstNumbBxlAukc*OrxlDownThenOverBlackAndWhite Zoom100vAj Range("A2:P4").SelectG |  \) .HF)Aligna0@xlc(* .WrapTex( . 1.AddIlPP +f'.FC N ".Nam7"`Arial !Styl"Bold I VichSizA9l ikethrough.Super`scrip4 bqOutrau hPadowU@3r3xlNoni".@or9xf0D[B6:B2000[n ([![d[[-vU-<.M-^A1Aj.)=upGoto Reference:="0R1C1+Sub rU~| krU $`nrU~| krU $`nModule27y__SRP_12T__SRP_131g_VBA_PROJECTY.st find the row which has the titles''''''' a  'A $$ $B@H j!p' $' $' Measure j!'p''' a$  '  j%l!p' j% $' $' MethodG'j   j%l!p'd  j%l!'  j%l!' kk0 end for First, find the row which as the titlesB@'''N''  ''''''''' a$' aA A $$ $B@Hnumb j!p' $' $-----' j!' ''kP  $' $' -  (      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQSTUWXaZ[\]^_`Rbcdefghijxmnopqrstuvwyz{|}|mxME(6 << <x `::p%H@I$*\Rffff*1G49eda6a0:" .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 '"9  $'* $' $'2 $'2 <   $'9@d'k 0 09@ 0G 'j%2 0  0 no measure'  'd( 0     ' '9'kk       j(pk j!''L' a find where objective title endsN' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $'T $' ''X  j(pR'  j%'J'L Jax 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 Arial9jRegular9x#@9z9|9~999 9 9qx T X j%!v'Arial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #$''''''''' a  '  $' -12'd $p$''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 Module26Q|Module271G49eda6a0Module27| 8x(h`0@pHP8sesO9O.O\EjK8ŗ"8KS:qTy>#,{~?@ABCDEFGHIJKLMNOQRSUVWXZrsellstopit37\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{6C89FF62-1493-45A7-ABA0-73826BE84AAB}#2.0#0#C:\DOCUME~1\lug1\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?49eda6a0Module1mThisWorkbook0j49eda6a0ThisWorkbookC % Sheet10l49eda6a0 Sheet1N 0Module20m49eda6a0 Module2yHModule31@49eda6a0"Module3R`Module40p49eda6a0(Module4<,xModule50q49eda6a0*Module5=Module60r49eda6a0,Module6ɭModule70s49eda6a0.Module7!Module80t49eda6a00Module8 Module90u49eda6a02Module9uIModule101A49eda6a04Module10B`Module111B49eda6a0<Module11w Module120z49eda6a0PModule1288Module131049eda6a0RModule13PModule141149eda6a0TModule14ߕhModule151249eda6a0VModule15FModule161349eda6a0XModule16Module171449eda6a0ZModule17Y4Module181549eda6a0\Module18 Module191649eda6a0^Module19K5Module201749eda6a0Module20Q)Module211C49eda6a0Module218Module221D49eda6a0Module22(Module231;49eda6a0Module23f@ Module240g49eda6a0Module24o X5Module251E49eda6a0Module25w_p(Module261F49eda6a0ngthYstoplockBoldcvalue2sourceswissuesw?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 dir__SRP_06 __SRP_1#PROJECTwm*e0* pHd VBAProject4@j = r I J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst@em32\Se2.tlb#OLE Automation`MSForms>SFFrms3 ED452EE1-E08F-101A-8-02608C4 D0BB4EFM20.DLL#Microsoft : ^ Ob Library/;D1u00}#0#k0 A6C89FF62-1493-45A7-ABA0-73826BE84AAB6DOCUME~1\lug1\L OCALS@Temp\VBE\Sp.exd ; .E .`M AOfficODf@ic 02DF8D04C-5BFAAgB-BDE5IAA420gram Files\Comm ongShared\OFFIChE115O p& 8.0Lp@%BшmCodule1GDou1 2HB1`B,QBm!B+BThisWorkbookGU@T mi@\W]kboku-2o%pC "eaSheeVt! Se:tv 2 ] N |"/2//2*/2//2@Y-/y+/33U33pR4444L<,5j555=6666ɭ7j777!8888R _M39_9Z9_9_B3uI[BS10GiIdR092?0`p];BIJZ11PLCwJJ7J?J?8JKK??K@KaKpK?KߕKK_K?KFL!L0L?_L`LLL?LY4LLL?M MAMPM?M5`EK2M20K\20E1E)|QM{M2'M28?߿Mp{M2M2ſ?UMp{M2M2lfMp]{M2M25o ~Me25Module252hodulLH1(F(, w_!+  T6G6 {6{6{|{Q{7{7 {7=7= =K*y     rU~~~~~~~~~~~~~~~~S )[ٸ{(KKE7    a  i   a   )AYqa   a   1Qq  1a  Qqa     81   PA   Module1 ThisWorkbookSheet1Module2Module3Module4Module5Module6Module7Module8Module9Module10Module11Module12Module13Module14Module15Module16Module17Module18Module19Module20Module21Module22Module23Module24Module25Module26Module27 VBAProjectF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA I q0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel Ai@0FC:\WINDOWS\system32\Stdole2.tlbstdole QyP.E .`M C:\WINDOWS\system32\FM20.DLLMSForms  11Y`blEskJ .C:\DOCUME~1\lug1\LOCALS~1\Temp\VBE\MSForms.exd a1pL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLLOffice I q Macro1 Macro3Macro7Macro8NumericMacro2Dcolsp1PITSMrU       )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 ModulPROJECT76SummaryInformation(:PDocumentSummaryInformation8T0CompObjYme=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="2C2E2F1D774D7B4D7B4D7B4D7B" DPB="585A5B5C5C5C5C5C" GC="848687A59FD0A0D0A02F" [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+'0@H`p Thomas C. Soceylug1Microsoft Excel@j)|Z@՜.+,0 PXl t|  NCHS/OAEHP' Sheet1Sheet1!Print_Titles  Worksheets Named Ranges F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q