ࡱ> bdr  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FPDH>Workbook;V_VBA_PROJECT_CUR"98@ G>PDH>VBA09G>&H>  \p Lesley Agress Ba= ThisWorkbook=hL,8X@"1PCourier1PArial1PArial1PArial1PArial1PArial1PArial1PArial1PArial1PArial"$"#,##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 000000%000 0.0% 00.0% 00.0 000%00 000.0 "$"0.00                + ) , *  1 1 1  1    1 1        1     1<"@ 1 1<@ 1< 1   1 <@  1 <@  1 <  1 < 1  1<"@ 1<@ 1<   1<  1 < `eSheet1  ;8 +827-21b Increased taxes on smokeless tobacco (number of 927-1a Cigarette smoking - Adults (age adjusted, aged 18 years and over)24%BSL23%22%21%---12% Race and ethnicity Race and ethnicity4 American Indian or Alaska Native only6 American Indian or Alaska Native only135%36%31%30%34%33%28%25%27%- Asian or Pacific Islander only/ Asian or Pacific Islander only113%DNC Asian only Asian only14%13%11%@ Native Hawaiian or Other Pacific Islander onlyB Native Hawaiian or Other Pacific Islander onlya,1DSUDSU- Black or African American only/ Black or African American only125%20% White only White only 2 or more races 2 or more races32%29%9 American Indian or Alaska Native; White; American Indian or Alaska Native; White35%44%40%39%43%2 Black or African American; White4 Black or African American; White37%! Hispanic or Latino# Hispanic or Latino19%17%18%16%15%% Not Hispanic or Latino' Not Hispanic or Latino4 White only, not Hispanic or Latino6 White only, not Hispanic or Latino Gender Gender Female Female Male Male26%< Education level (persons aged 25 years and over)> Education level (persons aged 25 years and over)$ Less than high school& Less than high school# Less than 9 years% Less than 9 years 9 to 11 years! 9 to 11 years38%# High school graduate% High school graduate$ At least some college& At least some college 13 to 15 years" 13 to 15 years" 16 years or more$ 16 years or more10%9%8% Family income level! Family income level Poor Poora33% Near poor Near poora30%! Middle/high income# Middle/high income Disability status Disability status( Persons with disabilities* Persons with disabilitiesa,232%+ Persons without disabilities- Persons without disabilitiesa,223% Sexual orientation Sexual orientation Select populations Select populations$ Persons with diabetes& Persons with diabetes' Persons without diabetes) Persons without diabetes Age groups Age groups@ Persons aged 18 to 24 years (not age adjusted)B Persons aged 18 to 24 years (not age adjusted)a28%NA@ Persons aged 25 to 44 years (not age adjusted)B Persons aged 25 to 44 years (not age adjusted)a27%@ Persons aged 45 to 64 years (not age adjusted)B Persons aged 45 to 64 years (not age adjusted)a25%9 Persons aged 65 years and over (not age; Persons aged 65 years and over (not age adjusted) adjusted)a11%827-1b Spit tobacco use - Adults (age adjusted, aged 18a2.5%2.3%0.4%1DSU11.1%1.5%1.3%12.9%2.5%2.6%0.5%2.8%13.2%3.0%0.3%0.2%4.9%4.3%4.5%4.1%3.5%3.8%3.9%3.6%2.4%2.7%1.7%1.6%2.2%1.9%1.2%1.0%1.4%a2.7%a2.8%23.2%22.5%2.1%3.7%a3.5%3.1%a3.2%2.9%a1.7%a1.8%527-1c Cigar smoking - Adults (age adjusted, aged 18a2.4%11.9%12.6%12.8%4.4%4.2%2.0%a2.3%a2.1%23.7%3.3%22.3%a2.2%a3.0%a0.9%1.1%0.9%927-1d Other tobacco use - Adults (age adjusted, aged 18; years and over) [Deleted at Midcourse Review]827-2a Adolescent use of tobacco products in past month. - Students (grades 9 through 12)1999DNAa40%45%$ Parents' education level& Parents' education level Grade Grade 9th grade 9th grade 10th grade 10th grade 11th grade 11th grade42% 12th grade 12th grade50%41%427-2b Adolescent use of cigarettes in past month -* Students (grades 9 through 12), Students (grades 9 through 12)627-2c Adolescent use of spit tobacco in past month -7%1%4%5%2%3%6% 10th grade 11th grade 12th grade927-2d Adolescent use of cigars in past month - Students# (grades 9 through 12)827-2e Adolescent use of bidis in past month - Students) (grades 9 through 12) [New]2000311%36%34%33%32%31%310%35%227-3a Initiation of cigarette use - Children and< adolescents (percent of at risk, aged 12 to 17 years) [New]2002a6.7%6.6%6.8%b4.1%a7.4%8.6%8.2%6.9%a5.1%a4.2%a4.9%4.7%4.0%4.8%a7.2%7.2%7.5%7.3%a7.1%6.7%7.8%5.9%a6.1%7.1%7.0%a6.8%6.5%a5.0%4.6%7.7%5.8%6.0%6.3%5.7%227-3b Initiation of cigarette use - Young adults= (percent of at risk, aged 18 to 25 years) [New]7.4%8.7%b4.4%a5.3%a5.6%5.2%7.6%8.3%10.0%a4.6%7.9%a7.3%8.9%a5.2%5.3%a8.3%9.0%10.7%a6.0%6.2%a7.6%8.1%8.0%9.6%8.8%627-4a Average age at first tobacco use - Adolescents# (aged 12 to 17 years)a14.714.915.0b17.6a14.014.214.114.814.5a15.015.215.1a15.115.3aDSUa14.514.614.4aDNA14.7a14.6aDNC727-4b Average age at first tobacco use - Young adults# (aged 18 to 25 years)a19.018.919.0b20.9a18.918.818.418.7a19.618.519.719.218.619.619.519.1a17.918.019.4a19.2a18.819.3127-5 Smoking cessation attempts by adults (age- adjusted, aged 18 years and over)a45%47%46%b80%a47%48%55%a48%51%53%52%49%54%62%a42%a46%a44%a41%a49%a43%56%a57%59%60%57%427-6 Smoking cessation during pregnancy - Females8 during first trimester (aged 18 to 49 years)114%9 Education level (persons aged 25 to 49 years)a7%a21%7 Persons with disabilities (replaces with$ activity limitations)a,2DSU= Persons without disabilities (replaces without327-7 Smoking cessation attempts by adolesc< ents -2001a61%b64%a53%a62%61%64%a65%63%58%a58%a64%a63%827-8a Managed care organization coverage for treatment$ of nicotine dependency1997-9875%100%227-8b Medicaid program coverage for treatment of= nicotine dependency (number of States and D.C.)2451427-8c Insurance coverage for treatment of nicotine6 dependency [Deleted at Midcourse Review]427-9 Exposure to tobacco smoke at home - Children$ (aged 6 years and under)a20%b6%a,127%a,120%a22%a,122%a32%a26%a13%< Nonsmokers (age adjusted, aged 4 years and over)1988-94a84%447%545%644%b56%a,193%a,183%" Mexican Americana,174%441%537%634%a,185%470%568%662%a,184%444%542%643%a81%443%641%a87%452%549%648%a85%455%554%651%451%551%649%a79%435%533%, Persons aged 4 to 11 years459%560%658%- Persons aged 12 to 17 years553%653%, Persons aged 4 to 17 years458%557%656%* Persons aged 18 and over541%- Persons aged 18 to 24 yearsa90%460%555%654%- Persons aged 25 to 44 years- Persons aged 45 to 64 years442%640%0 Persons aged 65 years and overa74%19941998-99a69%771%77%3,860%7,868%3,870%7,872%7DNC869%7,869%76%7,871%766%74%69%775%80%73%756%66%755%68%757%765%777%82%70%772%81%781%85%957%7,960%968%1059%7,1061%1068%1170%7,1172%1178% Age grous763%' (number of States and D.C.)) (number of States and D.C.)a0024591722a10111214152327! of States and D.C.)a11710218 transportation (number of States and D.C.)16181931a2020262934a66813= laws - Jurisdictions with <=5% illegal buy rate6 among minors (number of States and D.C.)3( among minors (Territories)120130131122b8a22= Adolescents and young adults - Internet (grades 6-12) [New]333%345%337%328%338%335%339%347%343%350% 6th grade 7th grade 8th grade: Adolescents and young adults - Magazines and, newspapers (grades 6-12) [New]67%369%367%360%372%354%356%375%368%71%72%65%84%86%87%95%14,15DSU16,15DSU17,15DSU18,15DSU7,15DSU19,15DSU20,15DSU21DSU22DSU23DSU14,1582%16,1582%17,1580%18,1580%7,1583%19,1582%20,1580%21DNA22DNA23DNA14,1581%16,1581%17,1583%18,1585%7,1586%19,1587%20,1587% 14,15,2476% 16,15,2476% 17,15,2477% 18,15,2479% 7,15,2480% 19,15,2481% 20,15,2483%21,2483%22,2482%23,2483%2180%2280%2382%2188%2288%2389%83%88%90%78%79%14,1583%16,1583%18,1584%7,1585%19,1585%20,1584%14,1572%16,1573%17,1575%18,1577%7,1579%19,1580%20,1582% 14,15,2481% 16,15,2482% 17,15,2479% 18,15,2478% 7,15,2479% 19,15,2480% 20,15,2482%21,2484%22,2483%23,2485%2185%2285%2383%2183%2284%2384%16,1580%17,1578%18,1582%19,1581%14,1564%16,1565%17,1566%18,1566%7,1568%19,1572%20,1573% 16,15,2481% 17,15,2481% 18,15,2482% 7,15,2481% 19,15,2483% 20,15,2485%23,2484%2184%2388%2176%2279%2379%' of States and D.C.) [New]# of Territories) [New] of Tribes) [New] and D.C.)a2828309 nitrosamines in cigarette smoke (nanograms/ cigarette) [New]2003-04121.525108.1109.46 compounds in cigarette smoke (nanograms/993.7929.5894.3< in cigarette smoke (microgram/cigarette) [New]707.0637.4636.3> cigarettes (dollars per standard U.S. package of cigarettes)$0.63$0.65$0.76$0.77$1.00$1.12$1.17$1.31$1.35$1.46$2.00 States and D.C.)c37 DATA ISSUESa Baseline revisedb Target revised8c New baseline. Objective was previously developmental.k1 Respondents were asked to select one or more races and identify one race as best representing their race.>2 Due to survey design error, data are for July-December only.*3 Data exclude persons of Hispanic origin.4 1999-2002 data.5 2001-2004 data.6 2003-2006 data.7 2001-2002 data.l8 Respondents were asked to select only one race category;selection of more than one race was not an option.Z9 Category is labeled 'Below' by the Current Population Survey; see technical information.`10 Category is labeled 'Borderline' by the Current Population Survey; see technical information.[11 Category is labeled 'Above' by the Current Population Survey; see technical information.$12 Total of 7 territories reporting.$13 Total of 6 territories reporting.14 1997-1998 data.}15 Respondents were asked to select one race/ethnicity category; selection of more than one race/ethnicity was not an option.16 1998-1999 data.17 1999-2000 data.18 2000-2001 data.19 2002-2003 data.20 2003-2004 data.21 2004-2005 data.22 2005-2006 data.23 2006-2007 data.?24 Persons of Hispanic origin did not select a racial category.X25 Laboratory extraction efficiency has improved since 2003. See technical information. Objective/number DATA SOURCEA27-1a National Health Interview Survey (NHIS), ob, NCHS.A27-1b National Health Interview Survey (NHIS), ob, NCHS.A27-1c National Health Interview Survey (NHIS), ob, NCHS.*27-1d Deleted at Midcourse Review.L27-2a Youth Risk Behavior Surveillance System (YRBSS), ob, NCCDPHP.L27-2b Youth Risk Behavior Surveillance System (YRBSS), ob, NCCDPHP.L27-2c Youth Risk Behavior Surveillance System (YRBSS), ob, NCCDPHP.L27-2d Youth Risk Behavior Surveillance System (YRBSS), ob, NCCDPHP.P27-2e National Youth Tobacco Survey, American Legacy Foundation and ob.D27-3a National S<urvey on Drug Use and Health (NSDUH),SAMHSA.D27-3b National Survey on Drug Use and Health (NSDUH),SAMHSA.D27-4a National Survey on Drug Use and Health (NSDUH),SAMHSA.D27-4b National Survey on Drug Use and Health (NSDUH),SAMHSA.B27-5 National Health Interview Survey (NHIS), ob, NCHS.B27-6 National Health Interview Survey (NHIS), ob, NCHS.M27-7 Youth Risk Behavior Surveillance System (YRBSS), ob, NCCDPHP.X27-8a Addressing Tobacco in Managed Care Survey, Robert Wood Johnson Foundation.W27-8b Health Policy Tracking Service, National Conference of State Legislators.*27-8c Deleted at Midcourse Review.B27-9 National Health Interview Survey (NHIS), ob, NCHS.S27-10 National Health and Nutrition Examination Survey (NHANES), ob, NCHS.N27-11 School Health Policies and Programs Study (SHPPS), ob, NCCDPHP.Y27-12 Current Population Survey (CPS), U.S. Department of Commerce, Bureau of theS Census and U.S. Department of Labor, Bureau of Labor Statistics.[27-13a State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP, OSH.[27-13b State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,[27-13c State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,[27-13d State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,[27-13e State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,\27-13f State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,\27-13g Potential:State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP, OSH.\27-13h Potential:State Tobacco Activities Tracking and Evaluation System (STATE), ob,\27-13i State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,=27-14a State Synar Enforcement Reporting, SAMHSA, CSAP.=27-14b State Synar Enforcement Reporting, SAMHSA, CSAP.\27-15 State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,O27-16a National Youth Tobacco Survey, American Legacy Foundation and ob.O27-16b National Youth Tobacco Survey, American Legacy Foundation and ob.:27-17a Monitoring the Future Study (MTF), NIH, NIDA.:27-17b Monitoring the Future Study (MTF), NIH, NIDA.:27-17c Monitoring the Future Study (MTF), NIH, NIDA.[27-18a State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,\27-18b Potential:State Tobacco Activities Tracking and Evaluation System (STATE), ob,\27-18c Potential:State Tobacco Activities Tracking and Evaluation System (STATE), ob,\27-19 State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,R27-20a Office on Smoking and Health, ob, NCCDPHP and Division of Laboratory' Sciences, ob, NCEH.R27-20b Office on Smoking and Health, ob, NCCDPHP and Division of LaboratoryR27-20c Office on Smoking and Health, ob, NCCDPHP and Division of Laboratory[27-21a State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,[27-21b State Tobacco Activities Tracking and Evaluation System (STATE), ob, NCCDPHP,&Focus area:27-Tobacco Use - 08-14-2008J Black or African American only, not Hispanic or LatinoH Black or African American only, not Hispanic or Latino20032004200520062007    8 BaselineTarget8 Objective Year 19982010 827-10 Exposure to environmental tobacco smoke - 827-11 Smoke-free and tobacco-free schools 827-12 Indoor worksite policies that prohibit smoking 827-13a Smoke-free indoor air laws - Private workplaces 827-13b Smoke-free indoor air laws - Public workplaces 827-13c Smoke-free indoor air laws - Restaurants (number 827-13d Smoke-free indoor air laws - Public 827-13e Smoke-free indoor air laws - Day care centers 827-13f Smoke-free indoor air laws - Retail stores 827-13g Smoke-free indoor air laws - Tribes (number) 827-13h Smoke-free indoor air laws - Territories (number)827-13i Smoke-free indoor air laws - Bars (number) [New] 827-14a Enforcement of illegal tobacco sales to minors 827-14b Enforcement of illegal tobacco sales to minors 827-15 Retail license suspension for sales to minors 827-16a Exposure to tobacco advertising and promotions - 827-16b Exposure to tobacco advertising and promotions - 827-17a Adolescent disapproval of smoking - 8th graders 827-17b Adolescent disapproval of smoking - 10th graders 827-17c Adolescent disapproval of smoking - 12th graders 827-18a Evidence-based tobacco control programs (number 827-18b Evidence-based tobacco control programs (number 827-18c Evidence-based tobacco control programs (number 827-19 Preemptive tobacco control laws (number of States827-20a Sales-weighted average tobacco-specific 827-20b Sales-weighted average polyaromatic hydrocarbon 827-20c Sales-weighted average volatile organic compounds827-21a Combined federal and average state tax on --- = 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.=    `Y(#    2PeZ)}3kln=:   !YS"""o":# #O-${$J$`%/%u%&l&)''(U($(p)*F*+,p--`. .u2//gi0711H22C2933d 74 e4 4[ 5 5[ &6 6{ 7L $8 b8 8\99n::H;;oQ<<]==}>(4??|@,AgACEF.G JYLN`QSr rV XJ YYF1[ ]^h`/cc   A 'aB]x9Y71Syn Q)q-FCKPTYV  dMbP?_*+%M \\FNCH-HVL-APP1\PR-DHP17C 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;CITGO Master Access Group;CG-CinDataShareLTASReadOnly;EDB_IRIS_APPLICATION_PROD;EDB_AUTHENTICATED_USERS;EDB_TASNET_PRODGeneral Everyday Printing . ,EXCEL.EXEC:\PROGRA~1\MICROS~2\OFFICE11\EXCEL.EXEIPACDRWDSGATCAPI;F4E8Q;Ki݅&E%9xPPBHAERP"I,,??U} 2} `0} } } } }  } } C@ @@ @@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ 6M 7777777777777 ,[ -\ -U -V -U -U -U -W -U  -U  -X  -X  -X  -] .^ /_ /\ /` / / / / /P  /Q  /R  /S  /T  /a [ +Z U V U U U W U  U  X  X  X  Y  0                   1`               (    0                   1`                   1`                   1`             " 1` #  $ $ $ $ $  $ $   & 1` '       (     * 1` '            , 1`   -   - .   .   0 1`   1 2 3 4   5         7 1`   $ $ $ 8     $       : 1` ;  < = > > >    ?  ?     A 1`                  N 1` '        (         C 1` '                 E 0                  G 1`      ( ;  ;  =  =  =   I 1` J                 L 0                  N 1`   - -     .    .     P 1`         (  ;  ;     R 1` S  8  1 1 1           U 1` .   .     J    J     W 1` <  < > < > >  >  ?  ?     Y 1`                  [ 1`      \ \  \  ]  ^     ` 0                 Dnl2 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@ b 1` c   -         !e !1` !f ! ! ! ! ! ! ! J ! J ! J !  !  "h "1` " " " "( "( "( "; " ; " ; " = "  "  #j #0 # # # # # # # #  #  #  #  #  $l $1` $m $ $- $ $- $- $ $  $  $  $  $  %o %1` %p % % % % % %( % ( % ( % ( %  %  &r &1` & & & & & & & &  &  &  &  &  't '0 ' ' ' ' ' ' ' '  '  '  '  '  (v (1` ( ( ( ( ( ( ( (  (  (  (  (  )x )1` ) ) ) ) ) ) ) )  )  )  )  )  *z *0 * * * * * * * *  *  *  *  *  +| +1` +} + + +J + + + +  +  +  +  + ~ , ,1` , , , , ,J ,J ,J ,  ,  ,  ,  , ~ - -1` - - - - - - - -  -  -  -  - ~ . .0 . . . . . . . .  .  .  .  .  / /1` / / / /\ /\ /] /] /  /  /  /  / ~ 0[ 00 0 0 0 0 0 0 0 0  0  0  0  0  1 10 1 1 1 1 1 1 1 1  1  1  1  1  2 21` 2 2 2 2 2 2 2 2  2  2  2  2  3 30 3 3 3 3 3 3 3 3  3  3  3  3  4 41` 4 4 4 4$ 4 4 4 4  4 $ 4  4  4  5 51` 5 5 5 5 5 5 5 5  5  5  5  5  6 61` 6 6 6 6$ 6 6 6 6  6 $ 6  6  6  7" 71` 7 7 7 7$ 7 7 7 7  7 $ 7  7  7  8& 81` 8 8 8 8 8 8 8 8  8  8  8  8  9* 91` 9 9 9 9 9 9 9 9  9  9  9  9  :, :1` : : : :$ : : : :  : $ :  :  :  ;0 ;1` ; ; ; ;$ ; ; ; ;  ; $ ;  ;  ;  <7 <1` < < < <$ < < < <  < $ <  <  <  =: =1` = = = =$ = = = =  = $ =  =  =  >A >1` > > > > > > > >  >  >  >  >  ?N ?1` ? ? ? ? ? ? ? ?  ?  ?  ?  ? 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@[@\@]@^@_@ @C @1` @ @ @ @ @ @ @ @  @  @  @  @  AE A0 A A A A A A A A  A  A  A  A  BG B1` B B B B B B B B  B  B  B  B  CI C1` C C C C C C C C  C  C  C  C  DL D0 D D D D D D D D  D  D  D  D  EN E1` E E E E E E E E  E  E  E  E  FP F1` F F F F F F F F  F  F  F  F  GR G1` G G G G G G G G  G  G  G  G  HU H1` H H H H H H H H  H  H  H  H  IW I1` I I I I I I I I  I  I  I  I  JY J1` J J J J J J J J  J  J  J  J  K[ K1` K K K K K K K K  K  K  K  K  L` L0 L L L L L L L L  L  L  L  L  Mb M1` M M M M M M M M  M  M  M  M  Ne N1` N N N N N N N N  N  N  N  N  Oh O1` O O O O O O O O  O  O  O  O  Pj P0 P P P P P P P P  P  P  P  P  Ql Q1` Q Q Q Q Q Q Q Q  Q  Q  Q  Q  Ro R1` R R R R R R R R  R  R  R  R  Sr S1` S S S S S S S S  S  S  S  S  Tt T0 T T T T T T T T  T  T  T  T  Uv U1` U U U U U U U U  U  U  U  U  Vx V1` V V V V V V V V  V  V  V  V  Wz W0 W W W W W W W W  W  W  W  W  X| X1` X X X X X X X X  X  X  X  X ~ Y Y1` Y Y Y Y Y Y Y Y  Y  Y  Y  Y ~ Z Z1` Z Z Z Z Z Z Z Z  Z  Z  Z  Z ~ [ [0 [ [ [ [ [ [ [ [  [  [  [  [  \ \1` \ \ \ \ \ \ \ \  \  \  \  \ ~ ][ ]0 ] ] ] ] ] ] ] ]  ]  ]  ]  ]  ^ ^0 ^ ^ ^ ^ ^ ^ ^ ^  ^  ^  ^  ^  _ _1` _ _ _ _ _ _ _ _  _  _  _  _ 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@{@|@}@~@@ ` `0 ` ` ` ` ` ` ` `  `  `  `  `  a a1` a a a a$ a a a a  a $ a  a  a  b b1` b b b b b b b b  b  b  b  b  c c1` c c c c$ c c c c  c $ c  c  c  d" d1` d d d d$ d d d d  d $ d  d  d  e& e1` e e e e e e e e  e  e  e  e  f* f1` f f f f f f f f  f  f  f  f  g, g1` g g g g$ g g g g  g $ g  g  g  h0 h1` h h h h$ h h h h  h $ h  h  h  i7 i1` i i i i$ i i i i  i $ i  i  i  j: j1` j j j j j j j j  j  j  j  j  kA k1` k k k k k k k k  k  k  k  k  lN l1` l l l l l l l l  l  l  l  l  mC m1` m m m m m m m m  m  m  m  m  nE n0 n n n n n n n n  n  n  n  n  oG o1` o o o o o o o o  o  o  o  o  pI p1` p p p p p p p p  p  p  p  p  qL q0 q q q q q q q q  q  q  q  q  rN r1` r r r r r r r r  r  r  r  r  sP s1` s s s s s s s s  s  s  s  s  tR t1` t t t t t t t t  t  t  t  t  uU u1` u u u u u u u u  u  u  u  u  vW v1` v v v v v v v v  v  v  v  v  wY w1` w w w w w w w w  w  w  w  w  x[ x1` x x x x x x x x  x  x  x  x  y` y0 y y y y y y y y  y  y  y  y  zb z1` z z z z z z z z  z  z  z  z  {e {1` { { { { { { { {  {  {  {  {  |h |1` | | | | | | | |  |  |  |  |  }j }0 } } } } } } } }  }  }  }  }  ~l ~1` ~ ~ ~ ~ ~ ~ ~ ~  ~  ~  ~  ~  o 1`                 Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ r 1`             t 0             v 1`    $         x 1`             z 0             | 1`            ~  1`            ~  1`            ~  0              1`            ~ [ 0              0              0             [ 0              0              1 3 ~         J   0              1 $ ~   $  $  $  $   1  ~            1  ~           " 1 $ ~   $  $  $  $  & 1  ~           * 1  ~           , 1 $ ~   $  $  $  $  : 1 1 ~   .      (  A 1  ~   1    .    N 1  ~   ;  ;  <  >  C 1  ~   S        E 0             G 1 8 ~           I 1 2 ~   4    -     0            Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ N 1  ~           U 1  ~           W 1  ~           r 1  ~           t 0              0              1 - ~         ;   1 3 ~     J  J     1  ~            1  ~           [ 0              0              1 1 ~         ( >  0              1 $ ~   $  $  $  $ >  1  ~          >  1  ~          > " 1 $ ~   $  $  $  $ > & 1  ~          > * 1  ~          > , 1 $ ~   $  $  $  $ > : 1  ~     =    < > A 1 1 ~   .       > N 1 ( ~   ?  ?     > C 1 4 ~   -    J   > E 0             G 1 1 ~         ; > I 1 1 ~   .       >  0             N 1  ~          > U 1  ~          > W 1  ~          >Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ r 1  ~          > t 0              0              1  ~     <  (   >  1 1 ~         ( >  1  ~          >  1 5 ~   1  J    J > [ 0              0              1 ^ ~   ^    ^  ^   0              1 $ ~   $  $  $  $   1  ~            1  ~           " 1 $ ~   $  $  $  $  & 1  ~           * 1  ~           , 1 $ ~   $  $  $  $  : 1  ~           A 1 ^ ~   ]    ^  ^  N 1  ~           C 1 \ ~   \  ^  \  \  E 0             G 1  ~           I 1  ~   ?         0             N 1  ~           U 1  ~           W 1  ~           r 1  ~           t 0              0            Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  1  ~       ^     1  ~   ]      ]   1 ^ ~   ]  ^  ^  ^   1 ] ~   ]    ^  ]  [ 0              0              1 = ~   ?  ?     ^  0              1 $ ~   $  $  $  $ ^  1  ~          ^  1  ~          ^ " 1 $ ~   $  $  $  $ ^ & 1  ~          ^ * 1  ~          ^ , 1 $ ~   $  $  $  $ ^ : 1 < ~   >    ?   ^ A 1 = ~   ?  ?     ^ N 1  ~     ?  \  \ ^ C 1 ; ~   >  ?  ?  ? ^ E 0             G 1 \ ~   ]  ]  ]  ^ ^ I 1  ~     (  ;  ; ^  0             N 1  ~          ^ U 1  ~          ^ W 1  ~          ^ r 1  ~          ^ t 0              0              1  ~         \ ^  1 = ~          ^  1 = ~   <  >    ? ^Dl@@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@  1  ~   =  ;    =    =  ^ [ 0                   0                   1  ~ ~                0                   1  ~ ~                1  ~ ~                1  ~ ~               " 1  ~ ~               & 1  ~ ~               * 1  ~ ~               : 1  ~ ~               A 1  ~ ~               N 1  ~ ~               C 1  ~ ~               E 0                  G 1  ~ ~               I 1  ~ ~                0                  N 1  ~ ~               U 1  ~ ~               W 1  ~ ~               r 1  ~ ~               t 0                   0                   1  ~ ~                1  ~ ~                1  ~ ~                1  ~ ~               [ 0                   0                   0                 Dl @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@  1  ~ ~ ~ ~             ! !0 ! ! ! ! ! ! ! !  !  !  !  !  " "1 " "~ "~ "~ "~ " " "  "  "  "  "  # #1 # #~ #~ #~ #~ # # #  #  #  #  #  $ $1 $  $~ $~ $~ $~ $ $ $  $  $  $  $  %" %1 %$ %~ %~ %~ %~ % % % $ %  %  %  %  && &1 &  &~ &~ &~ &~ & &  &   &   &  &  &  '* '1 ' '~ '~ '~ '~ ' ' '  '  '  '  '  (, (1 ( (~ (~ (~ (~ ( ( (  (  (  (  (  )7 )1 ) )~ )~ )~ )~ ) ) )  )  )  )  )  *0 *1 * *~ *~ *~ *~ * * *  *  *  *  *  +: +1 + +~ +~ +~ +~ + + +  +  +  +  +  ,A ,1 , ,~ ,~ ,~ ,~ , , ,  ,  ,  ,  ,  -N -1 - -~ -~ -~ -~ - -  -  -  -  -  -  .C .1 . .~ .~ .~ .~ . . .  .  .  .  .  /E /0 / / / / / / / /  /  /  /  /  0G 01 0 0~ 0~ 0~ 0~ 0 0 0  0  0  0  0  1I 11 1 1~ 1~ 1~ 1~ 1 1 1  1  1   1  1  2` 20 2 2 2 2 2 2 2 2  2  2  2  2  3b 31 3 3~ 3~ 3~ 3~ 3 3 3  3 ! 3  3  3  4e 41 4 4~ 4~ 4~ 4~ 4 4 4  4  4  4  4  5h 51 5 5~ 5~ 5~ 5~ 5 5 5  5  5  5  5  6r 61 6 6~ 6~ 6~ 6~ 6 6 6  6  6  6  6  7[ 70 7 7 7 7 7 7 7 7  7  7  7  7  8" 80 8 8 8 8 8 8 8 8  8  8  8  8  9# 91 9 9~ 9~ 9~ 9~ 9 9 9  9 $ 9 % 9  9 & : :0 : : : : : : : :  :  :  :  :  ; ;1 ;$ ;~ ;~ ;~ ;~ ; ; ;  ;  ; $ ;  ; & < <1 <' <~ <~ <~ <~ < <! <  <   <  <  < & = =1 =( =~ =~ =~ =~ = = = ! =  =  =  = & >" >1 >$ >~ >~ >~ >~ > >$ > $ > $ > $ >  > & ?& ?1 ? ?~ ?~ ?~ ?~ ? ?  ? ) ?  ?  ?  ? &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@[@\@]@^@_@ @* @1 @ @~ @~ @~ @~ @ @ @ * @ + @ , @  @ & A, A1 A$ A~ A~ A~ A~ A A$ A $ A $ A * A  A & B7 B1 B B~ B~ B~ B~ B B B  B  B  B  B & C0 C1 C C~ C~ C~ C~ C C C  C  C  C  C & D: D1 D- D~ D~ D~ D~ D D$ D  D  D . D  D & EA E1 E/ E~ E~ E~ E~ E E  E  E * E 0 E  E & FN F1 F1 F~ F~ F~ F~ F F F 2 F  F  F  F & GC G1 G3 G~ G~ G~ G~ G G G . G 4 G 5 G  G & HE H0 H H H H H H H H  H  H  H  H  IG I1 I6 I~ I~ I~ I~ I I! I 7 I  I  I  I & JI J1 J8 J~ J~ J~ J~ J J$ J 9 J : J ; J  J & K` K0 K K K K K K K K  K  K  K  K  Lb L1 L L~ L~ L~ L~ L L L  L $ L  L  L & Me M1 M M~ M~ M~ M~ M M M  M   M . M  M & Nh N1 N N~ N~ N~ N~ N N N  N  N < N  N & Or O1 O O~ O~ O~ O~ O O O  O  O  O  O  P[ P0 P P P P P P P P  P  P  P  P  Q= Q0 Q Q Q Q Q Q Q Q  Q  Q  Q       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrstuvwxyz{|}~ Q  R> R1 R? R~ R~ R~ R~ R R @ R @ R @ R A R  R B S S0 S S S S S S S S  S  S  S  S  T T1 TC T~ T~ T~ T~ T T D T E T F T G T  T B U U1 UH U~ U~ U~ U~ U U I U J U I U A U  U B V V1 VK V~ V~ V~ V~ V V L V I V I V A V  V B W" W1 WM W~ W~ W~ W~ W W$ W $ W $ W $ W  W B X& X1 XN X~ X~ X~ X~ X X F X J X O X A X  X B Y* Y1 Y? Y~ Y~ Y~ Y~ Y Y @ Y @ Y @ Y A Y  Y B Z, Z1 Z? Z~ Z~ Z~ Z~ Z Z D Z @ Z P Z @ Z  Z B [7 [1 [Q [~ [~ [~ [~ [ [ [  [  [  [  [ B \0 \1 \Q \~ \~ \~ \~ \ \ \  \  \  \  \ B ]: ]1 ]? ]~ ]~ ]~ ]~ ] ] A ] R ] F ] @ ]  ] B ^A ^1 ^? ^~ ^~ ^~ ^~ ^ ^ F ^ @ ^ @ ^ A ^  ^ B _N _1 _N _~ _~ _~ _~ _ _ @ _ J _ F _ A _  _ BDl`@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@{@|@}@~@@ `C `1 `? `~ `~ `~ `~ ` ` F ` @ ` @ ` A `  ` B aE a0 a a a a a a a a  a  a  a  a  bG b1 bS b~ b~ b~ b~ b b R b R b F b F b  b B cI c1 c? c~ c~ c~ c~ c c A c J c @ c J c  c B d` d0 d d d d d d d d  d  d  d  d  eb e1 eT e~ e~ e~ e~ e e e  e F e @ e  e B fe f1 fT f~ f~ f~ f~ f f f  f G f G f  f B gh g1 gT g~ g~ g~ g~ g g g  g A g J g  g B hr h1 hT h~ h~ h~ h~ h h h  h  h  h  h B i[ i0 i i i i i i i i  i  i  i  i  jU j0 j j j j j j j j  j  j  j  j  kV k1 kW k~ k~ k~ k~ k k X k X k X k Y k  k Z l l0 l l l l l l l l  l  l  l  l  m m1 m[ m~ m~ m~ m~ m m$ m \ m ] m ^ m  m Z n n1 n_ n~ n~ n~ n~ n n ` n a n a n b n  n Z o o1 o_ o~ o~ o~ o~ o o c o d o a o e o  o Z p" p1 pM p~ p~ p~ p~ p p$ p $ p $ p $ p  p Z q& q1 qW q~ q~ q~ q~ q q e q f q Y q b q  q Z r* r1 rW r~ r~ r~ r~ r r X r ^ r X r X r  r Z s, s1 sg s~ s~ s~ s~ s s c s h s i s \ s  s Z t7 t1 tQ t~ t~ t~ t~ t t t  t  t  t  t Z u0 u1 uQ u~ u~ u~ u~ u u u  u  u  u  u Z v: v1 v[ v~ v~ v~ v~ v v c v \ v b v b v  v Z wA w1 wW w~ w~ w~ w~ w w Y w X w X w X w  w Z xN x1 xW x~ x~ x~ x~ x x e x f x Y x b x  x Z yC y1 yW y~ y~ y~ y~ y y Y y ^ y ^ y \ y  y Z zE z0 z z z z z z z z  z  z  z  z  {G {1 {j {~ {~ {~ {~ { { f { X { f { f {  { Z |I |1 |k |~ |~ |~ |~ | | \ | \ | \ | \ |  | Z }` }0 } } } } } } } }  }  }  }  }  ~b ~1 ~T ~~ ~~ ~~ ~~ ~ ~ ~  ~ l ~ Y ~  ~ Z e 1 T ~ ~ ~ ~      X  f    ZDl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ h 1 T ~ ~ ~ ~      \  Y    Z r 1 T ~ ~ ~ ~            Z [ 0                  m 0                  n 1` o  p p  p p  q  q  p    r  0                   1` s   t  1 S  2  u  2    r  1` v                r  1` o  q w x    3  q  y    r ! 1` $  $ $ $ $ $  $  $  $    r % 1` s  z   p z  y  w  z    r ) 1` o  p q  p q      p    r + 1`   z y  z {    y  q    r / 1`   x t w x |  p  $  $    r 6 1`   $ $ $ $ $  $  $  $    r 9 1` }  z 2   z  q  p  t    r @ 1` o  p p q p q  q  q  p    r O 1` s  z   p z  y  w  t    r B 1` o  p p  p q      p    r D 0                  F 1` ~  z t q p z  p  t  t    r H 1`   q q  q     2  q    r K 0                  M 1` }   5   5  5        r O 1`    3 q S 2  S  8  4    r Q 1` }   2  5   2  5  5    r T 1`   5  3 5       5    r V 1` s  z z p z z  p    w    r X 1` s  z  p z   t  w  w    r Z 1`   w  p z t  q  t  y    r _ 0                  a 1`    q q  p  2  5      rDl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ d 1` o  p  q    q  5  p    r g 1` ~  t t  p p  q  t  p    r i 0                  k 1` ~   w p z w    z  w    r n 1`   p   q       q    r q 1`                 r s 0                  u 1`   y x p t t  p    y    r w 1` o  p q q q q  q    p    r y 0                  { 1`      u   u  x  u    ~  1` ~  t p q z p  t  t      ~  1` }   2  2           ~  0                   1`      S 5      S    ~ [ 0                   0                   1`                   0                   1`           $        1`                   1`           $       ! 1`           $       % 1`           $       ) 1`                  + 1`           $       / 1`           $       6 1`           $       9 1` $          $       @ 1`                  O 1`           $       B 1`                 Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  0                  M 1` $                 O 1` $          $       Q 1` $          $       T 1`           $       V 1`           $       X 1` \          $       Z 1` $          (       _ 0                  a 1`           $       d 1`           $       g 1`           $       i 0                   0                   1`           $        0                   1`                  [ 0                   0                   1  ~ ~ ~               0                   1 M ~ ~ ~   $    $    $    1 T ~ ~ ~               1 Q ~ ~ ~              ! 1 M ~ ~ ~   $    $    $   % 1 Q ~ ~ ~              ) 1 Q ~ ~ ~              + 1 M ~ ~ ~   $    $    $   9 1  ~ ~ ~   x    {       @ 1  ~ ~ ~              O 1  ~ ~ ~   {    |       B 1  ~ ~ ~   |          Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ D 0                  F 1  ~ ~ ~   |           H 1  ~ ~ ~       u    x    0                  M 1 T ~ ~ ~              T 1 T ~ ~ ~              V 1 T ~ ~ ~              q 1 T ~ ~ ~              s 0                   0                   1  ~ ~ ~       {    x    1  ~ ~ ~               1  ~ ~ ~               1  ~ ~ ~              [ 0                   0                   0                 ! [ 0                   0                   1` "                " [ 0                   0                   0                  [ 0                   0                   1`           ^        0                   1` #          $        1` #                  1` #          $       ! 1` #          $       % 1`                 Dl@@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ ) 1`           ^       + 1` T          \       / 1` T          $       6 1` T          >       9 1`                  @ 1`           \       O 1`                  B 1`           ]       D 0                  F 1`           ]       H 1`           ^       _ 0                  a 1`           ?       d 1`                  g 1`                  [ 0                  #b 0                   0                   0                   0 $     $   $    $      0 $                  0      $   $    $     ! 0      $   $    $     % 0                  ) 0                  + 0      $   $    $     / 0      $   $    $     6 0      $   $    $     9 0 $     $   $    $      0                  @ 0                  O 0                 Dl @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@ B 0                  !D !0 ! ! ! ! ! ! ! !  !  !  !  !  "F "0 " " " " " " " "  "  "  "  "  #H #0 # # # # # # # #  #  #  #  #  $K $0 $ $ $ $ $ $ $ $  $  $  $  $  %M %0 % % % % % % % %  %  %  %  %  &T &0 & & & & & & & &  &  &  &  &  'V '0 ' ' ' ' ' ' ' '  '  '  '  '  (q (0 ( ( ( ( ( ( ( (  (  (  (  (  )s )0 ) ) ) ) ) ) ) )  )  )  )  )  *y *0 * * * * * * * *  *  *  *  *  + +0 + + + + + + + +  +  +  +  + ~ , ,0 , , , , , , , ,  ,  ,  ,  , ~ - -0 - - - - - - - -  -  -  -  - ~ . .0 . . . . . . . .  .  .  .  . ~ / /0 / / / / / / / /  /  /  /  / ~ 0 00 0 0 0 0 0 0 0 0  0  0  0  0 ~ 1 10 1 1 1 1 1 1 1 1  1  1  1  1 ~ 2 20 2 2 2 2 2 2 2 2  2  2  2  2 ~ 3[ 30 3 3 3 3 3 3 3 3  3  3  3  3  4#c 41 48 4 4 4q 4 4 4 4  4  4  4  4 ! 5[ 50 5 5 5 5 5 5 5 5  5  5  5  5  6#d 60 6 6~ 6 6 6 6 6 6  6  6  6  6 ! 7 70 7 7 7 7 7 7 7 7  7  7  7  7  8 80 8 8~ 8 8 8 8 8 8  8  8  8  8 ! 9 90 9 9~ 9 9 9 9 9 9  9  9  9  9 ! : :0 : :~ : : : : : :  :  :  :  : ! ;! ;0 ; ;~ ; ; ; ; ; ;  ;  ;  ;  ; ! <% <0 < <~ < < < < < <  <  <  <  < ! =) =0 = =~ = = = = = =  =  =  =  = ! >+ >0 > >~ > > > > > >  >  >  >  > ! ?6 ?0 ? ?~ ? ? ? ? ? ?  ?  ?  ?  ? !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@[@\@]@^@_@ @/ @0 @ @~ @ @ @ @ @ @  @  @  @  @ ! A9 A0 A A~ A A A A A A  A  A  A  A ! B@ B0 B B~ B B B B B B  B  B  B  B ! CO C0 C C~ C C C C C C  C  C  C  C ! DB D0 D D~ D D D D D D  D  D  D  D ! ED E0 E E E E E E E E  E  E  E  E  FF F0 F F~ F F F F F F  F  F  F  F ! GH G0 G G~ G G G G G G  G  G  G  G ! HK H0 H H H H H H H H  H  H  H  H  IM I0 Iy I~ I I I I  I  I  I  I  I  I ! JO J0 Jw J~ J J J J  J  J  J  J  J  J ! KQ K0 Kx K~ K K K K  K  K  K  K  K  K ! LT L0 L L~ L L L L L L  L  L  L  L ! MV M0 M M~ M M M M M M  M  M  M  M ! NX N0 N N~ N N N N N N  N  N  N  N ! OZ O0 O O~ O O O O O O  O  O  O  O ! P_ P0 P P P P P P P P  P  P  P  P  Qa Q0 Q Q~ Q Q Q Q Q Q  Q  Q  Q  Q ! Rd R0 R R~ R R R R R R  R  R  R  R ! Sg S0 S S~ S S S S S S  S  S  S  S ! Ti T0 T T T T T T T T  T  T  T  T  Uk U0 U U~ U U U U U U  U  U  U  U ! Vn V0 V V~ V V V V V V  V  V  V  V ! Wq W0 W W~ W W W W W W  W  W  W  W ! Xs X0 X X X X X X X X  X  X  X  X  Y Y0 Y Y Y Y Y Y Y Y  Y  Y  Y  Y  Z Z0 Z Z~ Z Z Z Z  Z Z  Z  Z  Z  Z ~ [ [0 [ [~ [ [ [ [ [ [  [  [  [  [ ~ \ \0 \ \~ \ \ \ \ \ \  \  \  \  \ ~ ] ]0 ] ]~ ] ] ] ] ] ]  ]  ]  ]  ] ~ ^[ ^0 ^ ^ ^ ^ ^ ^ ^ ^  ^  ^  ^  ^  _#e _0 _ _ _ _ _ _ _ _  _  _  _  _ 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@{@|@}@~@@ `" `1` `# ` `$$ `$$ `$$ `$% `$& ` $' ` $( ` ") ` "* ` " a[ a0 a a a a a a a a  a  a  a  a  b#f b0 b b b b b b b b  b  b  b  b  c" c1` c+ c c", c", c"- c". c"/ c "/ c ") c "0 c "1 c " d[ d0 d d d d d d d d  d  d  d  d  e#g e0 e e e e e e e e  e  e  e  e  f2 f1` f3 f f$4 f$4 f$4 f$% f$& f $5 f "6 f "/ f "7 f " g[ g0 g g g g g g g g  g  g  g  g  h#h h0 h h h h h h h h  h  h  h  h  i8 i1` i"9 i i"9 i"9 i"9 i") i": i "; i "* i "1 i "< i " j[ j0 j j j j j j j j  j  j  j  j  k#i k0 k k k k k k k k  k  k  k  k  l" l1` l= l l"> l"* l"* l"0 l"0 l "? l "@ l "< l "A l " m[ m0 m m m m m m m m  m  m  m  m  n#j n0 n n n n n n n n  n  n  n  n  o" o1` oB o o$C o$C o$C o$5 o$D o $( o "- o ": o "0 o " p[ p0 p p p p p p p p  p  p  p  p  q#k q0 q q q q q q q q  q  q  q  q  r[ r0 r r r r r r r r  r  r  r  r  s#l s0 s s s s s s s s  s  s  s  s  t[ t0 t t t t t t t t  t  t  t  t  u#m u1` u$$ u u$$ u$$ u$$ u$4 u$% u $& u $C u "6 u "E u " v[ v0 v v v v v v v v  v  v  v  v  w#n w0 w w w w w w w w  w  w  w  w  xF x0 x x x x x x x x  x  x  x  x  yG y1` y$$ y y$4 y$$ y$$ y$4 y$$ y $% y $% y $H y $& y " z[ z0 z z z z z z z z  z  z  z  z  {#o {0 { { { { { { { {  {  {  {  {  |F |0 | | | | | | | |  |  |  |  |  }I }1` }J } }$$ }J }$$ }J }K } K } K } L } M } N ~[ ~0 ~ ~ ~ ~ ~ ~ ~ ~  ~  ~  ~  ~  #p 0       HDE          Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ ! 1` O  "0 "0 " " "  "  "  "  "  " [ 0                  #q 0                  P 0                  Q 1  ~ ~   S   8    S      0                   1 R ~ ~   S   T    T      1  ~ ~                1 U ~ ~   V   W    X     " 1 V ~ ~   Y   Z    [     & 1  ~ ~               * 1  ~ ~               : 1 - ~ ~               A 1  ~ ~               N 1  ~ ~   4   1    8     C 1 J ~ ~          S     E 0                  G 1 . ~ ~   S   8    4     I 1  ~ ~   8       8     t 0                   0                  \ 1  ~ ~               ] 1 - ~ ~      1    1     ^ 1 - ~ ~      4    3      1 J ~ ~   8             1 J ~ ~   1   4    5      1  ~ ~   -   S    3      1 5 ~ ~          4     [ 0                  #r 0                  _ 0                  ` 1  ~ ~              aDl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  0                   1 b ~ ~   c   d    c    a  1  ~ ~              a  1 e ~ ~   c   f    g    a " 1 h ~ ~   b   i    i    a & 1  ~ ~              a * 1  ~ ~              a : 1 j ~ ~   j           a A 1  ~ ~              a N 1   ~ ~               a C 1  ~ ~   j           a E 0                  G 1  ~ ~              a I 1  ~ ~              a t 0                   0                  \ 1   ~ ~          5    a ] 1 k ~ ~      {    y    a ^ 1  ~ ~               a  1  ~ ~   j           a  1  ~ ~               a  1  ~ ~           l    a  1  ~ ~          a    a [ 0                  #s 1`     m    n    n  o  p  0                   1` q  r s t u v  w  x  y  z  p  1`                 p  1` q  r s t u v  w  x  y  z  p " 1`           x  y  z  p & 1` {  | } ~            p * 1`                 pDl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ , 1`           x  y  z  p 0 1`           x  y  z  p 7 1`           x  y  z  p : 1`                 p A 1`                 p N 1`                 p C 1`                 p E 0                  G 1`     o o           p I 1`         m    m    p  0                  N 1`                 p U 1`                 p W 1`                 p r 1`                 p [ 0                  #t 1`           m      p  0                   1` q  r s t u v  w  x  y  z  p  1`                 p  1` q  r s t u v  w  x  y  z  p " 1`           x  y  z  p & 1`                 p * 1`                 p , 1`           x  y  z  p 0 1`           x  y  z  p 7 1`           x  y  z  p : 1`                 p A 1`                 p N 1`                 p C 1`                 p E 0                 Dl@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ G 1`         n  o  n    p I 1` k                p  0                  N 1`                 p U 1`                 p W 1`                 p r 1`                 p [ 0                  #u 1`     k            p  0                   1` q  r s t u v  w  x  y  z  p  1`                 p  1` q  r s t u v  w  x  y  z  p " 1`           x  y  z  p & 1` {                p * 1`                 p , 1`           x  y  z  p 0 1`           x  y  z  p 7 1`           x  y  z  p : 1`                 p A 1`                 p N 1`                 p C 1`                 p E 0                  G 1`   k            m  p I 1`     a a j           p  0                  N 1`                 p U 1`                 p W 1`                 p r 1`                 p [ 0                 Dl@@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@ @ @@ #v 0                   1 $' ~ ~ ~ ~            " [ 0                  #w 0                   0                  [ 0                  #x 0                   0                  [ 0                  #y 0                   1`   " " " " "@  "@  "  "1  "1  $$ [ 0                  #z 0                   0                   0 % ~ ~ ~ ~ ~ ~          % [ 0                  #{ 0                   0                   0 % ~ ~ ~ ~ ~ ~        %  % [ 0                  #| 0                   1 % ~ ~ ~ ~          %  % [ 0                  #} 0                   0                   1` &  & & & & &  &  &  &  &  & [ 0                  # 0                   1  ~ ~  $C "9 ";  "7  "1  "  "A  " ' 2'''''''''''' ~ Dl2 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@  ! " # $( %( &( '( (( )( *( +( ,( -( .( /( 0( 1( 2( 3(  4(  5(  6(  7(  8( 9( :( ;( <( =( >( ?(D@l@@A@B@C@ D@E@ F@G@H@I@J@K@L@M@N@O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@^@_@ @ A B C D) D3)))))))))))) E* E4************ F G H I J K L M N  O! P" Q# R$ S% T& U' V( W) X* Y+ Z, [- \. ]/ ^0 _1Dl22`@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@{@|@}@~@@ `2 a1 b3 c1 d4 e1 f5 g1 h6 i1 j7 k8 l9 m8 n: o1 p; q< r= s1 t> u? v@ wA xB yC z1 {D |8 }E ~8 FD@l@@@@@@@@@@@ 1 G H I H J H K 1 L 1v>"@E EE   7 Sheet1 Module1 __SRP_2 __SRP_3oThisWorkbook3  !"#$%&')*+,-./0123456789;<=>?@ABCDFGHIJKLMNOPQRSTUVXY[]^_`abcdefhijklmnopqstuvwxyz{|~"mmxME (6 <<< `@pXJ)Macro recorded 2/18/99 by Thomas C. Soceyle 14%Hx]<&J$*\Rffff*164a263c5e"  ((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<CmN #bc B~0= FpWFsC٦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$+myxMExp]<&Jx"Attribute VB_Name = "Module2" "mRxME (6 <<< $`@pxJ)Macro recorded 2/19/99 by Thomas C. Socey 14"%Hx]<&J$*\Rffff*174a263c5e"  ( &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 gModule6rxp]<&Jx"Attribute VB_Name = "Module4" $+m=xMExp]<&Jx"Attribute VB_Name = "Module5" $+mɭxMExp]<&Jx"Attribute VB_Name = "Module6" $+m!xModule7}Module8Module95Module10&9MExp]<&Jx"Attribute VB_Name = "Module7" $+m xMExp]<&Jx"Attribute VB_Name = "Module8" $+muIxMExp]<&Jx"Attribute VB_Name = "Module9" "ZmBxME(6 < << 6`@pXJ )Macro recorded 12/18/2001 by Thomas Socey 144%Hx]<&J$*\Rffff*184a263c5e "   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<%Hx]<&J$*\Rffff*194a263c5e "   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!Module13Module14MExp]<&Jx$Attribute VB_Name = "Module12" $+mxMExp]<&Jx$Attribute VB_Name = "Module13" $+mߕxMExp]<&Jx$Attribute VB_Name = "Module14" $+mFModule15Module16Module17 Module18      !#$%&'()*+,-./0123456789:;<=>?ѷ<&Jx$Attribute VB_Name = "Module15" $+mxMExp]<&Jx$Attribute VB_Name = "Module16" $+mY4xMExp]<&Jx$Attribute VB_Name = "Module17" $+mxMExp]<&Jx$Attribute VB_Name = "Module18" /mKxMEModule19"^Module20)DKModule21@__SRP_afTp `@Ib `]<&J"  , 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 '        !"#$%&'()*+,-./0123456789:;<=>?@ABCKFGIJLTMNOPQRSVsXYZ[\]^_`abcdefghijklmnopqUtuvwxyz{|}~2mxME(6 << <x `++p%H@]<&J$*\Rffff*1:4a263c5e+" 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 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Ǻ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*.Wu__SRP_100T__SRP_11-2gst find the row which has the titles''''''' aH  'A $$ $B@H' j!p'$ $' $'  Objective j!'L '' a  'B@  j%l!p' j $' $'T YearG'j'X   j%l!p'd  j%l!'9|  j%l!'9kk0 end for First, find the row which as the titlesgu'''N''  ''''''''' a' aA $$ $B@H j!p'Z $' $-----' j!'''kP  $' $' -  (|mQxME(6 << <x `::p%H@]<&J$*\Rffff*1=4a263c5e:" .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'b ''f  G'j0 ''^ $' d $' $'nd $' o    $'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' is $'ti $'p ''  j(p'  'f'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(PX. R j%!v$Arial9'Regular9x#@9z9|9~999 9 9qx T X j%!vhnicitArial9Regular9x#@9znl9|9~999 9 9q'Jk L G'Jj ty ( $' < D N - #j!p''''''''' a  '  $' -'d $$'d` ..' 'd0 %ia%'Boldd z 0 'd  0 'kkkkkk  G'j stop5       8(:k  hdashk not k gotsuper k celllen j!'x5  G'j stop4  'A $$ $B@H- goto next line6 j!p' $' '86 $' '    '  $' $' Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household) @8  j(p; add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pkxkp j%l!' '  $!v(  $-----' j!'''k d 6 Not a new objective. These are objective title lines   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''k k       j%!vArial9Bold9x#@9z9|9~999 9 9q k d   j(p> add 7 to 15  j!p j(pdX     j(p@ add 9 to 18  j!p j(pd    j(pC add 11 to 21  j!p j(pdp    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pk k kx kp kh k` ' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q8  j(P R j%!vArial9Regular9x#@9z9|9~999 9 9q T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #''''''''' a  '  $' -'d $$'dx ..''dH %%'d   0 'd  0 'kkkkkk  G'j stop5       8(:k  hdashk notk gotsuperk celllen j!'  G'j stop4  'A $$ $B@H1 goto next line 8 &9  &9$9(9*9,9.90q0 j!p' $' ' $' '   '  $' $' Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household)   j(p? 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kkx       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(pA add 7 to 15  j!p j(pkPkH j%l!' '  $!v(  $-----' j!'''kd   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pdh     j(p@ add 9 to 18  j!p j(pd    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pkkkkkxkpkhk`% until stop3 - end of objective titled(' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q  j(P R j%!vArial9Regular9x#@9z9|9~999 9 9qX T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #''''''''' a  '  $' -'dh $$'d@ ..''d %%'d  0 'd  0 'kkkkkxkp  G'j stop5       8(:k  hdashk notk gotsuperk celllen j!'  G'j stop4  'A $$ $B@H j!p' $' j%l!p' $-----   $-----' j!'k''kx ' $' '   '   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''dP STATE:''k k       j%!vArial9Bold9x#@9z9|9~999 9 9qhk`dX   j(p= add 7 to 15  j!p j(pd     j(p@ add 9 to 18  j!p j(pdx    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pk k k k k k k k until stop2 until stop1=1 '' '' aA $$ $B@H j!p' $' $' j%l!p' $-----  8B@A $$ $B@H j!p' $' $' j%l!p'kH  'd  DATA ISSUES  DATA SOURCEA $$ $B@H  '  DATA SOURCE' 8!B@ Objective j(p  '  $ $$ 'A $$ $B@Hnumber j!p j(pA  $$ :  $B@Hd  DATA ISSUES', j!p j(p  $ $$ 'A $$ :  $B@Hkk 8 "9  &9$9(9*9,9.90qh 8 4 8%2(6 8 : 8%2(6 < 8%2 >96 B9@ 9q D 8%2 >96 B9@ 9q 8 F 8%2(6 8 H 8%2(6 8!vArial9 Bold Italic9x 9z9|9~999 9 9qd   '  'J'L Ja L 'L  L$'N N\  L $  L  L $ 'A $$ $B@H  j(p  j(P L 'R L'T 'V V R 'X R j%!vArial9Regular9x#@9z9|9~999 9 9q  T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jkx L G'JjXkPdH  $' $'Z ' $' $' $' $' $'    $'dH'k8'\normal'^ normal'`'b'd'f'h 0 0'^$ dash and second digit of first pair'\. space and dash and second digit of first pair 0 ' \ '\d 0 ^ '^'bkk 0 ^ '^  # no measure'  ' \ '\d`     ' '' \ '\kkd 0 \ '\ ^ '^'`kk       j(p j!p'd`'b'`kH' Z G ^ '^j - is not a continuation line j!p \$'d ^ 'fd? ^ ` 'fdp? ^ ` 'fd@? ^ ` 'fd? ^ ` 'fd> ^ 'fk>k>k>k>k>k> Zf Zi Zj Zl Zr ZtG f 'fj Zm ZA ZBG f f $'fj bG f 'fj b ` Z G f 'fj j!p \  \ $'h d f h j(pd0= -" is a continuation line 'd, 19 d j!p j(pk<k<k<k<k<k<  ' until stop1=1k continuesw = 1  'j G j 'jj l!n$ j $$ : $ $$ 9p9rq; l!n(t l!n9v9x9z9|9~9? %9? %9 %9 %9? %9? %999 999 9*9 9 99d9qx:A2:P4$B@H 8 &9  &9$9(9*9,9.90q: 8!vArial9 Bold Italic9x 9z9|9~999 9 9q9B6:B2000$B@H 8 "9  &9$9(9*9,9.90q89A1$!v( R1C1 B@o98ŵAttribute VB_Name = "Module26" Sub PI() ' First find the row which has"titles cvaluonP= 0 oncolmaxstop1haveyear obj;Do Until -1 ^ + Range("A" + Trim(Str(#))).Se0lect@VActiveCell.V_ "=ER If "Obj7." Txhen,]o=Row u2  ) Off@set(0,)C >GIY?~CH@Ɓ3J " nA.1/M"_!NElseb FYLColumzendad`dress#AKC E;IfL8oopC'  forC,!L dh"$ lettep"w3DspacD|$v+ 2mE@_r @Z1@!wherew@ ¦nqA!Ha=(81currc Є?ydK$ With io.Horiz`oalAlignmbeBtxlC! .Verticnt$ .WrapTexqyFaߍ@ .Oria^t 0<P .I x,6Nerc( K1QO1AMak + #7+ 5./  Vno/!~thiscolVolum_Qmax]f404o|nrBsd"A" + Trimr(r))Po n!C δl.Value $ cvx = RTrim(p)|beforeq|Lentzxaftervdiff(a- -zhold MidQx, 10 "2#6"If >'"Race and ethnicity") Or Mother's rGender!Worksite onl0f"Classeps at a"STATE:& 5)g-r (head of house) ThenzA3@Ke7 OAActiveCel!" + ' add 5 to 12A P sp]+ MNAFM 3, Ɂ['A 3-T 5S sPtart 0!lenWAv (HE&?^4ł`@ $19'O$%18OEls`B!T212%EoIf > 0!!WithIFChFaws(SA7:=, 1gth:=( $2 - %)).Font!Q.Nam"A`rial"RaShtylBSDiz!9.5Strikrou$ghTFa4 .SuperscPriptb.OutlineA hadowZUg xlb#N onNColorI xAutomatic$GA=oJ]Iě8TIt`"Ed.7"?: ? pdstoploc( Offset(-0).Addrxessl>,ldApuet"@t׀PtW?a2XaBZ=A[-2t t> p-$}ta@ t EtƶrCtt_@"CbQtQttt ttߦwt}.t).tttp?tIt.Sty.trFt.ttA"t#. $trZr:04t<t$1ſ?m_:: 9B߹1)j! `Z9Z TwZ 1 f= " " + cvalue ' add 11 to 21 ActiveCePll.V^=^sppace : |Else If d iff =pThen {o+:34!Uzb2 +bd5d7Kdnd IfEJstop4|0Do Untild (1)K@F currc@Offset(0, 1).AddressRange(E).Select Wit$h Cioϣ.HorizontalAlignmeDnt"xlCer.Vertice WrapTe2xFa@.Ori@at'P?IndShrinkToFi Merg}>s a;%nE= wXTrim(cc>= R@Clen Len Cgotsuper@-aQH> 0S Y65lettercbHo9 bb ) (+ bE3MidD%,?Ai a"\" 'C FI1 -R`%1-gI$@Etos…%+$sdF2De _Ͽ_M= _M!_M`_Me_M _M._M܆0>._M_M#FormulaR1C>1D"Charac?s(Start:=@,PK gth:=&).FfO#.Name"Arial"StylReg r .Siz9.5ogStrikethroughO?g'.STscripgTruob.Outline#adowUurxlNon '.Color!yxAutom{cOD/($$G, %E%% )%9%Y%z%_"p-u/%+/%/%./%&/%/%/%[/%\E?zckжo Loop?0PYpc05LNot (A"<") AUDN-#O%rhdolla!"Wh`iod oW acxbzer oeѻg  azeroes = "" Hpsw0B hdashFcntiFstop5FDo Untitl ,1v(!+ 1)letterAMid(cvalue, ,If "-" Then6ObElse %>$>olla;"$Y*l .e @period\".\ !CJIj%h*Pcent*%?Kf6 bE+ l"0!1/ '% End IfW  w `"Bcelllenb( Loop 'C#zF4 Selection.NumberFor$maVhd|+ Gh$o+:+ aa\X#`n otrgots>u@d+thiscol/AveC0.ColumЮ )maxwB04`44Konro Range("A" + Tri@m(Str(b)8)).#4'o next linMWith9 G.HorizontalAlign"mxlCerVerticnnWrapT! = Fag .Oria&}.AddInd0? .ShrinkToFi*OBMergr?<[ s{!V|oue`RSbefor1LenO1 91af3?diffp(- holqr1P0od2|6l1 "Race apZethnicity") Or (Mothe`r's rG er.Worksite onlT "Class9atdq "STATE:lt5) -O (head of@ house!)`qt7X -'qA$#p' 12)O addsp+.? #3, w Q3 _A15_Qstarta@nA1 *% /r@ 19zA 18Oq~92oq2tp Px> 0d8<Isi:=C, gth:=(0 2 -0kFf``NamQ"Arial.StylrBLoaSiz89.5 tikIrouga`@ !.Sscrip_e4tb_.OutyA `1_slad2/%UgQxlNNobortx!RAutoicOp`# Else If diff = 8 ThenActiveCell.Va(lueZ" " + cv8' add 7 to 15%O2spaceF mBEnd If'stoploc[(.Offset(-1, 0).AddreXss)*31 Range(start/, 4).Font.BoldTruMid(, B5)"-" c-inueswÍCpedro 0mWith @Characters(Sa~:=, 1@gth:=(`2h - A)À).NamAria l"RAStylGASiz!9.R.Strikethrough xFa .Supcript bsOutline hadUnder  xlb#NonpColorI xAutomaticQ-GA=oJu ` ?/ 09 Or (befor%1)1Q `Z9 Cჿ+ 1o= <ϏfD 11! I}/=/ Ǔ/ ( 1 /D |13R 4K__ _ sX 2_ Q_ R27 ߪ1? ??! SqLoop ' until3ge of obje titlQ14HtDo U`op1_ currc0x0p C).Sel0 |wio_.HorizalAl@ignmenQkx$lCerN.Vler_n|WrapTexpu0.Orieon?Pgb mq.ShrinkToFiBMergsp#"k=J= TrimDogR5!  Qs S= gots Fߜf .F6letp cK1QO1+  ã,g4Pc "\]R gotsuper = 1  8cvalue!Mid(, 1, lettercnt - 1) + >8+VcelllenR)pActiveC2.Vzv1toselect(y2sd3De/*eRange(curr1).SS3With ionB.HorizontalAlignme= xlC erVerticWrapTexNFalseOri@at'X0AddIndShri@nkToFiM(erg}sEn+ #7+ 5./  ˴ End If ' not gotsup er celllenthiscol = Ac tiveCP.Cpolum,/max8Then stop4C1 `pLoop o0nrow0+  8Range("A" + Tri@m(Str())).Seleccvalue(cV ;R+ )2%Offset(1, 0).,(Mid(I(, 5)!"-") Or  " A4"Dz continue>sZ XAAfpedbHNRowO"01;AQbeforpL 0!Withhar4acas@7:= , 1gth:=( $2 - % F" .Nams"Aria l"RaStylBRSiz!9.5ikethroughT,Fa4@SscPriptb.Outline1 hadUnder xlqb#NonNorI xAut@omaticO A"#$M8$p+)$rn M0M7MO-?Mu ?: 9t&c|1)  d 9 oC  1O=2 11! I}=/ "/ ) 1 / / q1_ 3R 4.__ _ so%g%12_ Q_ R 27 71@If+/@Cſ| uu l>1r=r Ws0ourcsiss="R ÅCDo Uŏez @"%?ƥSM+ ion.Dte Shift:=hp0*0?=Ci6O (H"mɩADATA ISSUES"gg@SOURCE/ // qƴLen(endaddress) @- 1 If cvalue = "DATA SOURCE"` Then dsourceswV 4Selection.EntireRow.InPsert CA%veCell.VwObjryxlb;61D._+_+d q*ggY(e A`T0 c`len aσ|.Yf> _ 0stop6pO lettercY Do U@l (U1MT("33 P 0"\|RE\ᑖ`R y׿P ,-W ewGUtO6XFormulaR1C1PtosҫH/$sd&cT,!o,4hDe- U BbHCharac-sЯart:= gth:=Q.R kShRegr,S.S.5gTOyUTruJV;&.OW .SXXeYXYL $$0, %u+)%%%la%%.%%%tSu{+/%;|/% #%ϴline = x@lUnderStyleNone .Col(orIxxAutomaticfEnd WithA@stop6L1!?IfIf lettercntAcellle0n ThVLoop Q 3Els4sourcesNwT0 dh Mid(cvalue, 3, 1) meas 6 lLen!rZ112 2, 2"3 4O45er 2e >= 7J2M7, l - 5*_@ ""UCl~partAJ7 'normalG numpchaBra5 ' secondP0 A"\FjA"0" OrBB A = -2-dash a& digit of first pair D3spac~e-D4 4bn&(f+S>Not @t:@&)oJ $g+ :KmI,, 5? Dcd bi" "@4no !urѰ`, w+@ 0R13o@1`2%32eS!"0G 49 ?j`/0"m\ U2wU!UActiveC.V01 +Ž2t3t4tDi]>#6@  C addCK= iTEtu 43 A_@B{"-7is@at a `tinupon ]LrleC)N(` 3Ld<9 4 A !$0^617P 5 Mp[= `! 6?_?@4____oqU8f2iUjlrt49s!mm:zAB;R0, QM)p|0xLRrt:bpSG (l812,t Te0h?HH.I LP^߱AbqAbq3 .A EUX' PUU_΍ģ+"`19o ra  3{}1d:WonrosgQ @until 1v=0} Tg4 dela(obj1-Rhaveyea}#I s 1 Sheet`.PageSet up .PrintTitleRows = "$" + Trim(Str(d@elrow1H1d)) ":< Ho$bjH))CoPlumn" End With ActiveSheetArea73 .I.LeftHeader9Center Righ(Foo( ( (Margin(Application.InchesToPos(0.75 )1Top!1 Bottom CW 0. 7J0ingFalseȃGridlineCommxl NoorizontallypM 0VertvOri@B}xlLa@ndscap .DraftFirstNumbBxlAukc*OrxlDownThenOverBlackAndWhite Zoom100vAj Range("A2:P4").SelectG |  \) .HF)Aligna0@xlc(* .WrapTex( . 1.AddIlPP +f'.FC N ".Nam7"`Arial !Styl"Bold I VichSizA9l ikethrough.Super`scrip4 bqOutrau hPadowU@3r3xlNoni".@or9xf0D[B6:B2000[n ([![d[[-vU-<.M-^A1Aj.)=upGoto Reference:="0R1C1+Sub rU~| krU $`nrU~| krU $`nModule27y__SRP_12T__SRP_131g_VBA_PROJECT.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 ' a A $$ $B@H j!p'; $' $-----' j!'P<''kP  $' $' -  (|mxME(6 << <x `::p%H@]<&J$*\Rffff*1>4a263c5e:" .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  '8=  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'0B $' $' '`B  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ 'B@H  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q   j(P2 R j%!vArial9Regular9x#@9z9|9~999 9 9qx T X j%!vtalicArial9zRegular9x#@9z9|9~999 9 9q'Jk L G'Jj a $'L < D N - # ''''''''' a  '  $'R -'d $$'9d` ..'9|'d0 %%'9d X 0 'd  0 'kkkkkk  G'j stop5J        8(:Hk  hdashk not$k gotsuper$k celllen j!'  G'j stop4  'A $$ $B@H- goto next line j!p' $' 'H $' 'no   '  $'` $'f Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household)   j(p; add 5 to 12  j!p j(p j!p $'` j!p$' '' j!p' STATE:''d STATE:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pkxkp j%l!' '  $!v(  $-----' j!'''k d 6 Not a new objective. These are objective title lines   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''k k       j%!vArial9Bold9x#@9z9|9~999 9 9q k d   j(p> add 7 to 15  j!p j(pdX     j(p@ add 9 to 18  j!p j(pd    j(pC add 11 to 21  j!p j(pdp    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pk k kx kp kh k` ' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q8  j(P R j%!vArial9Regular9x#@9z9|9~999 9 9q T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #''''''''' a  '  $' -'d $$'dx ..''dH %%'d   0 'd  0 'kkkkkk  G'j stop5       8(:k  hdashk notk gotsuperk celllen j!'  G'j stop4  'A $$ $B@H1 goto next line 8 &9  &9$9(9*9,9.90q0 j!p' $' ' $' '   '  $' $' Race and ethnicity Mother's race and ethnicity Gender  Worksite only  Classes at STATE:  $----- &Race and ethnicity (head of household)   j(p? 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kkx       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(pA add 7 to 15  j!p j(pkPkH j%l!' '  $!v(  $-----' j!'''kd   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''d STATE:''kk       j%!vArial9Bold9x#@9z9|9~999 9 9qkd   j(p> add 7 to 15  j!p j(pdh     j(p@ add 9 to 18  j!p j(pd    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pkkkkkxkpkhk`% until stop3 - end of objective titled(' a j%l!'b b$B@H 8 &9  &9$9(9*9,9.90q j!p' $' $' '  j(p'  'J'L Ja L 'L  L$'N N\'  L $  L  L $ '  j(p L 'R L'T  L 'X b$B@H 8 &9  &9$9(9*9,9.90q  j(P R j%!vArial9Regular9x#@9z9|9~999 9 9qX T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jk L G'Jj  $' < D N - #''''''''' a  '  $' -'dh $$'d@ ..''d %%'d  0 'd  0 'kkkkkxkp  G'j stop5       8(:k  hdashk notk gotsuperk celllen j!'  G'j stop4  'A $$ $B@H j!p' $' j%l!p' $-----   $-----' j!'k''kx ' $' '   '   j(p: add 5 to 12  j!p j(p j!p $' j!p$''' j!p' STATE:''dP STATE:''k k       j%!vArial9Bold9x#@9z9|9~999 9 9qhk`dX   j(p= add 7 to 15  j!p j(pd     j(p@ add 9 to 18  j!p j(pdx    j(pC add 11 to 21  j!p j(pd    j(pF add 13 to 24  j!p j(pd    j(pI add 15 to 27  j!p j(pk k k k k k k k until stop2 until stop1=1 '' '' aA $$ $B@H j!p' $' $' j%l!p' $-----  8B@A $$ $B@H j!p' $' $' j%l!p'kH  'd  DATA ISSUES  DATA SOURCEA $$ $B@H  '  DATA SOURCE' 8!B@Measure j(p  '  $ $$ 'A $$ $B@Hnumber j!p j(pA  $$ :  $B@Hd  DATA ISSUES', j!p j(p  $ $$ 'A $$ :  $B@Hkk 8 "9  &9$9(9*9,9.90qh 8 4 8%2(6 8 : 8%2(6 < 8%2 >96 B9@ 9q D 8%2 >96 B9@ 9q 8 F 8%2(6 8 H 8%2(6 8!vArial9 Bold Italic9x 9z9|9~999 9 9qd   '  'J'L Ja L 'L  L$'N N\  L $  L  L $ 'A $$ $B@H  j(p  j(P L 'R L'T 'V V R 'X R j%!vArial9Regular9x#@9z9|9~999 9 9q  T X j%!vArial9Regular9x#@9z9|9~999 9 9q'Jkx L G'JjXkPdH  $' $'Z ' $' $' $' $' $'    $'dH'k8'\normal'^ normal'`'b'd'f'h 0 0'^$ dash and second digit of first pair'\. space and dash and second digit of first pair 0 ' \ '\d 0 ^ '^'bkk 0 ^ '^  # no measure'  ' \ '\d`     ' '' \ '\kkd 0 \ '\ ^ '^'`kk       j(p j!p'd`'b'`kH' Z G ^ '^j - is not a continuation line j!p \$'d ^ 'fd? ^ ` 'fdp? ^ ` 'fd@? ^ ` 'fd? ^ ` 'fd> ^ 'fk>k>k>k>k>k> Zf Zi Zj Zl Zr ZtG f 'fj Zm ZA ZBG f f $'fj bG f 'fj b ` Z G f 'fj j!p \  \ $'h d f h j(pd0= -" is a continuation line 'd, 19 d j!p j(pk<k<k<k<k<k<  ' until stop1=1k continuesw = 1  'j G j 'jj l!n$ j $$ : $ $$ 9p9rq; l!n(t l!n9v9x9z9|9~9? %9? %9 %9 %9? %9? %999 999 9*9 9 99d9qx:A2:P4$B@H 8 &9  &9$9(9*9,9.90q: 8!vArial9 Bold Italic9x 9z9|9~999 9 9q9B6:B2000$B@H 8 "9  &9$9(9*9,9.90q89A1$!v( R1C1 B@o98ĵAttribute VB_Name = "Module27" Sub TSM() ' First find the row which has"titles cval&uonP= 0 oncol#maxstop1haveyear obj;Do Until -1 ^+ Range("A" + Trim(Str(#))).S`elect@VActiveCell.V_ "=R If "Measure" Then+\nG IthodH@ƁL4 " A/10M" `!OElseFc FLColumzendaddrelss#AC E ;IfLoop'C'  f4orC,L dh"$ lettep"w3DspacD|$v+ 2nt`}Y@this~be`!af!@diffcoA ~nuesw ped~dda8ehJ^WMid(# , 1, 5)"-Tj ka!IA![K `e0k E 3`bCE)n7+ cN-xK ) ' Xu^a new K ೦_6 U 6 `lo oking`a mgW ]aa "E]eALend9!A+ =1LAI2, n2L!oI4k( 4GI5K >= 7 8>@l -0)nPuB#Q"0" OrDzp!d !`g! CK#no _4c" Not ( )1 qqerw ZR@/ C2Lp$!1`q2t>3t'  startlobX>mE@_r @Z1@!wherew@ ¦nqA!Ha(81currc 'ЄydK$ With io.Horiz`oalAlignmeBtxlC! .Verticnt$ .W@rapTexqyFaߍ .Oriyat 0<P .Ind0?q.ShrinkT8oFiBMerg¶ 1%^ (\xe{_%qfO{i !len_}  gotsupB<E> x,6Nerc( K1QO1AMak + #7+ 5./  Vno/!~thiscolVolum_Qmax]f404o|nrBsd"A" + Trimr(r))Po n!C ̴ll.ValueH cvx = RTrim(8)|before|Lentzx aftervdiff(a- -!zhold Midx, 10 "2#6"If >'"Race and ethnicity") Or Mother's rGender!Worksite onl0f"Classes at a"STATE:& 5)g-r (head of house) ThenzgA@Ke7 OAActiveCe!" + ' add 5 to 12A P sp]+ MNAFM 3, Ɂ['A 3-T 5S sPtart 0!lenWAv (HE&?^4ł`@ $19'O$%18OEls`B!T212%EoIf > 0!!WithIFChFaws(SA7:=, 1gth:=( $2 - %)).Font!Q.Nam"A`rial"RaShtylBSDiz!9.5Strikrou$ghTFa4 .SuperscPriptb.OutlineA hadowZUg xlb#N onNColorI xAutomatic$GA=oJ]Iě8TIt`"Ed.7"?: ? pdstoploc( Offset(-0).Addrxessl>,ldApuet"@t׀PtW?a2XaBZ=A[-2t t> p-$}ta@ t EtƶrCtt_@"CbQtQttt ttߦwt}.t).tttp?tIt.Sty.trFt.ttA"t#. $trZr:04t<t$1ſ?m_:: 9B߹1)j! `Z9Z TwZ 1 f= " " + cvalue ' add 11 to 21  ActiveCell.V^=^space : |Else If @diff =pThen {o+u34!Uzb2V bd5d7Kdnd IfEJAstop4|0Do Until (1)K@F currc@Offset(0, 1).Ad dressRange(E).S elect WiHth Cioϣ.HorizontalAlignment"xlCer.Vertice WrapTdexFa@.Ori@at'P?IndShrinkToFi Merg}}s a;%nE= wXTrim(c>= R@Clen Len Cgotsuper@-aQ> 0S Y65lettercbHo9 bb ) (+ b3MidD%~,Ai a"\" '-C FI1 -R`%1-gI$@Etos?…%+$sdF2De __M= _M!_M`_Me_M _M._M܆}0._M_M#FormulaR1|C1D"C harac?s(Start:=@,APKgth:=&).FfO#.Name"Arial"StylReg rA .Siz9 .5ogStrikethrough?g'.ST scripgTruob.Outlin>e#adowUurxlNon '.Color!yxAutom{cOD/($$G, %E%% )%9%Y%z%_"p-u/%+/%/%./%&/%/%/%[/%\E?zckжo Loop?0PYpc05LNot (A"<") ADN-#O%rhdohlla!"Whq`iod oW acxbzeroeѻf  azeroes = "" Lpsw0B hdashFcntiFstop5FDo Untitl ,1v(!+ 1)letterAMid(cvalue, ,If "-" Then6ObElse %>$>olla;"$Y*l .e @period\".\ !CJIj%h*Pcent*%?Kf6 bE+ l"0!1/ '% End IfW  w `"Bcelllenb( Loop 'C#zF4 Selection.NumberFor$maVhd|+ Gh$o+:+ aa\X#`n otrgots>u@d+thiscol/AveC0.ColumЮ )maxwB04`44Konro Range("A" + Tri@m(Str(b)8)).#4'o next linMWith9 G.HorizontalAlign"mxlCerVerticnnWrapT! = Fag .Oria&}.AddInd0? .ShrinkToFi*OBMergr?<[ s{!V|oue`RSbefor1LenO1 91af3?diffp(- holqr1P0od2|6l1 "Race apZethnicity") Or (Mothe`r's rG er.Worksite onlT "Class9atdq "STATE:lt5) -O (head of@ house!)`qt7X -'qA$#p' 12)O addsp+.? #3, w Q3 _A15_Qstarta@nA1 *% /r@ 19zA 18Oq~92oq2tp Px> 0d8<Isi:=C, gth:=(0 2 -0kFf``NamQ"Arial.StylrBLoaSiz89.5 tikIrouga`@ !.Sscrip_e4tb_.OutyA `1_slad2/%UgQxlNNobortx!RAutoicOp`# ElseIf diff = 8 ThenActiveCell.Va(lueZ" " + cv8' add 7 to 15%O2spaceF mBEnd If'stoploc[(.Offset(-1, 0).AddreXss)*31 Range(start/, 4).Font.BoldTruMid(, B5)"-" c-inueswÍCpedro 0mWith @Characters(Sa~:=, 1@gth:=(`2h - A)À).NamAria l"RAStylGASiz!9.R.Strikethrough xFa .Supcript bsOutline hadUnder  xlb#NonpColorI xAutomaticQ-GA=oJu ` ?/ 09 Or (befor%1)1Q `Z9 Cჿ+ 1o= <ϏfD 11! I}/=/ Ǔ/ ( 1 /D |13R 4K__ _ sX 2_ Q_ R27 ߪ1? ??! SqLoop ' until3ge of obje titlQ14HtDo U`op1_ currc0x0p C).Sel0 |wio_.HorizalAl@ignmenQkx$lCerN.Vler_n|WrapTexpu0.Orieon?Pgb mq.ShrinkToFiBMergsp#"k=J= TrimDogR5!  Qs S= gots Fߜf .F6letp cK1QO1+  ã,g4Pc "\\R gotsuper = 1  8+VcelllenR)pActiveC2.Vzv1toselect(y2sd3De/*eRange(curr1).SS3With ionB.HorizontalAlignme= xlC erVerticWrapTexNFalseOri@at'X0AddIndShri@nkToFiM(erg}sEn+ #7+ 5./  ʹ End If ' not (gotsuper @celllenthiscol = A@ctiveCP.Colum,/max8Then@ stop4C1 `Loop `onrow0+ 8Range("A" + Trim(Str())).Seleccvalue(cV ;R+)2%Offset(1, 0 ).,(Mid((, 5)!"-") Or  " A4"Dy continu|esZ XAAfpedbHNRowO"01;QbeforpxLenJe@na0fter@diff(D- B \ 7 RW͘@>"DTv@add 5 to 12N space _O/holdA/!O`P3, 6l3`5start0@72 0 /E"STATE:"3019/18Elseo!2^2%i > 0!!Withhahracas@7:=, 1gth:=( $2 - %F" .Nams"Arial"RaStylBRSiz1!9.5ikethroughYTFa4@Sscriptb.Outlinec hadU0nder xlb#NonN(orI xAutomaticO A"#$M8$p+)$rn M0M7MO-?Mu ?: 9t&c1)  d 9 oC  1O=2 11! I=/ "/ ) 1 / / q1_ 3R 4.__ _ so%g%12_ Q_ R 27 71@If+/@Cſ| u l>1=r W`sourcsiss="R CDo Uŏez @"%?ƥSM+Aion.Dte Shift:=hp0*0?=Ci6O (H"mɩADATA ISSUES"ggSOURCE/. // pɴ Len(endaddress) - 1 If cvalue = "DATA SOURCE" Then dsourceswV 4Selection.EntireRow.Insert CA%veCell.VwMeasure" *onrok.+ s2Mid, 1, l) + Trim (Str(#)) 2Range("A").k a@number""L &I)j":#UElse -zISSUESzissuz?rxlb;61D._+_+d q*ggg(e A`T0 c@len? Ac|.Yf> _ 0stop6pO lettercY Do U l (U1MT("33 P 0"\|RE\ᑖ@R^ yP ,-W ewGUtOt6XFormulaR1C1PtosH/$sd&cT,!o,4hDe- U BbHCharac-sЯart := gth:=Q.R kSRegr,S.S.5gTOyUTruJV&.OWx .SXXeYXYL w$$0,%u+)?%%%la%%.%%%tSu{+/%;|/% $%дine = xl@UnderlStyleNone .Col(orIxAutomaticfEnd WithA@stop6L1!?IfIf lettercntAcellle0n ThVLoop Q 3Els4sourcesNwT0 dh Mid(cvalue, 3, 1) meas 6 lLen!rZ112 2, 2"3 4O45er 2e >= 7J2M7, l - 5*_@ ""UCl~partAJ7 'normalG numpchaBra5 ' secondP0 A"\FjA"0" OrBB A = -2-dash a& digit of first pair D3spac~e-D4 4bn&(f+S>Not @t:@&)oJ $g+ :KmI,, 5? Dcd bi" "@4no !urѰ`, w+@ 0R13o@1`2%32eS!"0G 49 ?j`/0"m\ U2wU!UActiveC.V01 +Ž2t3t4tDi]>#6@  C addCK= iTEtu 43 A_@B{"-7is@at a `tinupon ]LrleC)N(` 3Ld<9 4 A !$0^617P 5 Mp[= `! 6?_?@4____oqU8f2iUjlrt49s!mm:zAB;R0, QM)p|0xLRrt:bpSG (l812,t Te0h?HH.I LP^߱AbqAbq3 .A EUX' PUU_΍ģ+"`19o ra  3{}1d:WonrosgQ @until 1v=0} Tg4 dela(obj1-Rhaveyea}#I s 1 Sheet.`PageSetup .PrintTitleRows = "$" + Trim(Str(de lrow1H1)2) ":< HobjH))Col(umn" En@d With ActiveSheet.Area73 .I.LeftHeader9Center Righ(Foo( ( (Margin(Application.InchesToPos(0.75 )1Top!1 Bottom CW 0. 7J0ingFalseȃGridlineCommxl NoorizontallypM 0VertvOri@B}xlLa@ndscap .DraftFirstNumbBxlAukc*OrxlDownThenOverBlackAndWhite Zoom100vAj Range("A2:P4").SelectG |  \) .HF)Aligna0@xlc(* .WrapTex( . 1.AddIlPP +f'.FC N ".Nam7"`Arial !Styl"Bold I VichSizA9l ikethrough.Super`scrip4 bqOutrau hPadowU@3r3xlNoni".@or9xf0D[B6:B2000[n ([![d[[-vU-<.M-^A1Aj.)=upGoto Reference:="0R1C1+Sub Module26Q|Module271>4a263c5eModule27|`Xp 8hxP@(0,r$;L-W*NdrnJ{ 5$SjA!.83F{PV&*I#qN9!.#ENP S-m6K>i1_$AF+mB*e]WBZ/FAzO]g?Ʈ)N?N+͗tII'm0NV* RN5g"3-aM_C+M*Ib0e݄֑LӾJ^TH*%@DF8V^GotoExcel+VBAWin16~Win32MacVBA6# VBAProjectstdole`MSFormsCOfficeuModule1b _EvaluateMacro1NRange  ThisWorkbook|Sheet1Module2cModule3dMacro3NCellsModule4eModule5fModule6gModule7hModule8iModule9jModule10UMacro7N SelectionZ NumberFormatRModule11VMacro8NReplacefWhatC ReplacementLookAtOxlPart< SearchOrderxlByRows MatchCaseModule12WModule13XModule14YModule15ZModule16[Module17\Module18]Module19^ Boldfncolcurrcell6cur      !"$%&'()+,-./012345789:;<=>?@ABCDEFGHIJKLMNOPRSTVWXY[rsellstopit37\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  ]<&J   mModule1164a263c5eModule1mThisWorkbook0a4a263c5dThisWorkbookC % Sheet10c4a263c5d Sheet1N 0Module20d4a263c5d Module2yHModule3174a263c5e"Module3R`Module40g4a263c5d(Module4<,xModule50h4a263c5d*Module5=Module60i4a263c5d,Module6ɭModule70j4a263c5d.Module7!Module80k4a263c5d0Module8 Module90l4a263c5d2Module9uIModule10184a263c5e4Module10B`Module11194a263c5e<Module11w Module120q4a263c5dPModule1288Module130r4a263c5dRModule13PModule140s4a263c5dTModule14ߕhModule150t4a263c5dVModule15FModule160u4a263c5dXModule16Module170v4a263c5dZModule17Y4Module180w4a263c5d\Module18Module190x4a263c5d^Module19K5Module200y4a263c5dModule20Q)Module211:4a263c5eModule218Module221;4a263c5eModule22(Module23124a263c5dModule23f@Module240^4a263c5dModule24o X5Module251<4a263c5eModule25w_p(Module261=4a263c5engthYstoplockBoldcvalue2sourceswissuesw?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*c0* pHd VBAProject4@j = r ]<&J 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 AFEF79Y-F01F-4E09-93]847125E666F36DOCUME~1\LKA7\LOCALS@Temp\VBE\S.exd ; .E .`M OffDicOf@ic 02DF8D04C -5BFAAgB-BDE5IAA420gram Files\CommongShared\OFFICE115O p& 8.0Lp@%BmCodule1GDou1 2 HB1B,Bm!B+BThisWorkbooPkG@T miE@\W]kboku2o%pC "ea`Sheet! See:t 2ע N |U"/2//2*/2//2@-/y+/U3333pR4j444L<,5555=6j666ɪ7777!8j888R _M39_9Z*9_9_34uI[BS10GIdR092?0`p];BIJ11PLCwJJJ?J?8JKK??K@KaKpK?KߕKKK?KFL!L?0L?_L`LLL?LY4LLL?M MAMPM?M5`E,K2M20K20E1ſE)QwM{M2M28?ؿMp]{M2M2?U|Mp{M2M2lf߿Mp{M2M2ſ5o ~Me25Module252hodulLH1(F(, w_!+  T6G6 {6{6{|{Q{7{7 {7=7= =K*y     rU~~~~~~~~~~~~~~~~S )֍J';S*   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`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 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(:QDocumentSummaryInformation8U0CompObjZme=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="72707101E705E705E705E705" DPB="E4E6E79B2B0C2C0C2C0C" GC="56545525B5E526E626E6D9" [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+'0HPh Thomas C. SoceyLesley AgressMicrosoft Excel@!x;&@j)|Z@G>՜.+,0 PXl t|  NCHS/OAEHP' Sheet1Sheet1!Print_Titles  Worksheets Named Ranges F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q