ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry F@^9Workbookk_VBA_PROJECT_CUR"p^@^VBAp^p^ \pnemcgr00 Ba= ThisWorkbook=xK:$8X@"1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1$Arial1Arial1xArial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri"$"#,##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,\ ;[Black]\-#,##0,;\ \-\-'"#,##0,"*"\ ;[Black]\-#,##0,;\ \-\-'"#,##0,\ ;[Black]\-#,##0,"*";\ \-\-'"#,##0,\ "*";[Black]\-#,##0,;\ \-\-*%#,###,"(2)*"\ ;[Black]\-#,##0,;\ \-\-)$"*"\ #,##0,\ ;[Black]\-#,##0,;\ \-\-)$#,##0,\ ;[Black]"*"\ \-#,##0,;\ \-\-#,##0;\-#,##0;0;@#,##0;\-#,##0;@!#,##0,\ ;[Black]\-#,##0,;\ 02-"*"\ "[2]"\ \ #,##0,\ ;[Black]\-#,##0,;\ \-\-&!"*"\ #,##0,\ ;[Black]\-#,##0,;\ @#,##0,\ ;[Black]\-#,##0,""*"\ #,##0,\ ;[Black]\-#,##0,"* [2]"\ ;[Black]"* [2]"&!#,##0,\ ;[Black]\-#,##0,\ ;\ \-\-                                                                      ff + ) , *      P  P         `            a>  "  1"<@ @ 1"< @ 1<@ @ 1"    (8  (   )8 3<@ @  @ 1"<@@  ,@ @    ,7  )8 )8 )8 )8 !8 )x  ,@  ,  $  (@   ,@   ,@   ,@   $@   $@   $@   $@   $@   (@ 7   ,@ 7   ,@ 7   ,@ 7    8    (8 (8 @ (0 8 @     8 @ 8 "8@ "0@ 8@ @ 8@ "8@@ "0 @ *8@@ *0@ *0 @ "8 @ 0@ "0@ 8@ @ 8@    *8@ 1<@  8  8   8@@ "0@  (8@  0@ 1<@ ||P}A} \ \-\-,#ef;_(@_) }A} \ \-\-,#ef;_(@_) }A} \ \-\-,#ef;_(@_) }A} \ \-\-,#ef;_(@_) }A} \ \-\-,#ef;_(@_) }A} \ \-\-,#ef ;_(@_) }A} \ \-\-,#L;_(@_) }A} \ \-\-,#L;_(@_) }A} \ \-\-,#L;_(@_) }A} \ \-\-,#L;_(@_) }A} \ \-\-,#L;_(@_) }A} \ \-\-,#L ;_(@_) }A} \ \-\-,#23;_(@_) }A} \ \-\-,#23;_(@_) }A} \ \-\-,#23;_(@_) }A} \ \-\-,#23;_(@_) }A}  \ \-\-,#23;_(@_) }A}! \ \-\-,#23 ;_(@_) }A}" \ \-\-,#;_(@_) }A}# \ \-\-,#;_(@_) }A}$ \ \-\-,#;_(@_) }A}% \ \-\-,#;_(@_) }A}& \ \-\-,#;_(@_) }A}' \ \-\-,# ;_(@_) }A}( \ \-\-,#;_(@_) }}) }\ \-\-,#;_(@_)    }}* \ \-\-,#;_(@_) ??? ??? ??? ???}-}/ \ \-\-,#}A}1 a\ \-\-,#;_(@_) }A}2 \ \-\-,#;_(@_) }A}3 \ \-\-,#?;_(@_) }A}4 \ \-\-,#23;_(@_) }-}5 \ \-\-,#}}7 ??v\ \-\-,#̙;_(@_)    }A}8 }\ \-\-,#;_(@_) }A}9 e\ \-\-,#;_(@_) }x}:\ \-\-,#;_(  }}; ???\ \-\-,#;_(??? ???  ??? ???}-}= \ \-\-,#}U}> \ \-\-,#;_( }-}? \ \-\-,#}(}Q4\ \-\-,#}<}R4\ \-\-,#4;_(}<}S4\ \-\-,#4;_(}<}T4\ \-\-,#4;_(}<}U4\ \-\-,#4;_(}<}V4\ \-\-,#4;_(}<}W4\ \-\-,#4;_(}<}Y4\ \-\-,#4;_(}<}Z4\ \-\-,#4;_(}<}[4\ \-\-,#4;_(}<}\4\ \-\-,#4;_(}<}]4\ \-\-,#4;_(}<}^4\ \-\-,#4;_(}<}_4\ \-\-,#4;_(}<}`4\ \-\-,#4;_(}<}a4\ \-\-,#4;_(}<}b4\ \-\-,#4;_(}<}c4\ \-\-,#4;_(}(}d4\ \-\-,#}(}e4\ \-\-,#}(}f4\ \-\-,#}(}g4\ \-\-,# 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L湸 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ٗ % 60% - Accent3M( 60% - Accent3 23֚ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`[Sheet1 Controlled Foreign Corporations Total assetsTotal receipts Income taxesNForeign corporations with current earnings and profits (+) before income taxes)Distributions out of earnings and profitsTotal Subpart F income%Receipts by foreign corporations from#Payments by foreign corporations toBeginning of year End of yearTotal All sources All other related partiesUnrelated partiesAll recipients)Not previously taxed earnings and profits(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)(11)(12)(13)(14)(15)(16)(17)(18)(19)(20)(21)(22)(23)(24)(25)(26)(27)(28)(29)(30)#Raw materials and energy production$Agriculture, forestry, and fishing "Oil and gas extraction UtilitiesGoods production#Construction #Manufacturing Food manufacturing 6Beverage and tobacco product manufacturing Beverage manufacturingTobacco manufacturing2Textile mills and textile product mills Apparel manufacturing(Leather and allied product manufacturing#Wood product manufacturing Paper manufacturing )Petroleum and coal products manufacturingChemical manufacturing)Pharmaceutical and medicine manufacturingOther chemical manufacturing*Plastics and rubber products manufacturing)Nonmetallic mineral product manufacturingPrimary metal manufacturing&Fabricated metal product manufacturingMachinery manufacturing-Computer and electronic product manufacturing:Electric equipment, appliance, and component manufacturing&Transportation equipment manufacturing,Other transportation equipment manufacturing+Furniture and related product manufacturingMiscellaneous manufacturing(Distribution and transportation of goodsWholesale and retail trade!Wholesale trade Other wholesale trade"Retail trade Food and beverage stores(Clothing and clothing accessories storesGeneral merchandise storesOther retailersTransportation and warehousingWarehousing and storage Information8Finance, insurance, real estate, and rental and leasing Depository credit intermediation#Nondepository credit intermediation$Services $Nature of business not allocable .Mining (except oil and gas) Support activities for mining(Heavy and civil engineering constructionBasic chemical manufacturing=Soap, cleaning compound, and toilet preparation manufacturing&Communications equipment manufacturing;Semiconductor and other electronic component manufacturing ,Other computer and electronic manufacturing !Other miscellaneous manufacturing Electronics and appliance storesHealth and personal care stores)Electronic shopping and mail-order housesAir transportationWater transportationTruck transportationOther transportation4Newspaper, periodical, book and directory publishersSoftware publishers-Motion picture and sound recording industriesBroadcasting (except internet)Finance and insurance,Credit intermediation and related activities+Activities related to credit intermediationInsurance carriers"Real estate and rental and leasingRental and leasing services!Other rental and leasing services+Computer system design and related services$Custom computer programming services Computer systems design services1Other computer system design and related services'Management of companies and enterprises,Scientific research and development services6Other professional, scientific, and technical services9Management, scientific, and technical consulting servicesHAdministration and support and waste management and remediation services!Health care and social assistance#Arts, entertainment, and recreation-Other services (except public administration).Dividends paid to controlling U.S. corporationConstruction of buildingsSpecialty trade contractors)Insurance carriers and related activitiesEducational services&Number of U.S. corporation returns [1]Number of foreign corporations<Agencies, brokerages, and other insurance related activitiesDCommercial and industrial machinery and equipment rental and leasing0Professional, scientific, and technical services7NOTE: Detail may not add to totals because of rounding.?Current earnings and profits (less deficit) before income taxes0Current earnings and profits before income taxes>Current earnings and profits (less deficit) after income taxes/Current earnings and profits after income taxesAll related parties, totalU.S. corporation filing returnBDomestic corporations controlled by U.S. corporation filing returnEAny foreign corporations controlled by U.S. corporation filing returnb* Data should be used with caution because of the small number of returns on which they are based.%Support activities for transportation0Architectural, engineering, and related servicesAccommodation and food servicesAll industries [1] Number of returns is not additive because some U.S. corporations had Controlled Foreign Corporations in more than one industrial sector. The industrial activity of the parent corporation filing the return often differs from that of the Controlled Foreign Corporations.[2] Value is less than $500.%Previously taxed earnings and profitsUIndustrial sector and selected industrial subsector of Controlled Foreign CorporationX[All figures are estimates based on a sample--money amounts are in thousands of dollars]/Printing and related support activities Rubber products manufacturingHMotor vehicle, vehicle body and trailer, and vehicle parts manufacturing*Paint, coating, and adhesive manufacturing/Computer and peripheral equipment manufacturing#Motion picture and video industriesSound recording industries.Data processing, hosting, and related services Real estate!Food services and drinking places-Mining, quarrying, and oil and gas extraction-Medical equipment and supplies manufacturing GMotor vehicle and motor vehicle parts and supplies merchant wholesalers4Electrical and electronic goods merchant wholesalers>Machinery, equipment, and suppliers merchant wholesalers 2Drugs and druggists' sundries merchant wholesalers6Apparel, piece goods, and notions merchant wholesalers1Chemical and allied products merchant wholesalers5Petroleum and petroleum products merchant wholesalersMotor vehicle and parts dealers?Building materials and garden equipment and supplies dealers 'Publishing industries (except internet)WSecurities, commodity contracts, and other financial investments and related activities+Funds, trusts, and other financial vehicles3Advertising, public relations, and related servicesPlastics products manufacturingGProfessional and commercial equipment and supplies merchant wholesalersDLessors of nonfinancial intangible assets (except copyrighted works) AccommodationTelecommunications [3]Other information services [4]:Source: IRS, Statistics of Income Division, November 2011.Table 1. U.S. Corporations and Their Controlled Foreign Corporations: Number, Assets, Receipts, Earnings, Taxes, Distributions, Subpart F Income, and Related Party Transactions, by Industrial Sector and Selected Industrial Subsector of Controlled Foreign Corporation, Tax Year 20081Grocery and related products merchant wholesalers#[3] Includes North American Industry Classification System (NAICS) code 518111 (Internet Search Providers) which was previously included with the 'Internet service providers, web search portals, and data processing services' industrial subsector (not included in Table 1 for Tax Year 2008).P[4] Includes North American Industry Classification System (NAICS) codes 516110 (Internet publishing and broadcasting) and 518112 (Web search portals) which were previously included with the 'Internet service providers, web search portals, and data processing services' industrial subsector (not included in Table 1 for Tax < Year 2008).9 :^;;;I"<y<=>?AvBm9C D E F G[IJFLOfP=.RSCUccNB4c =_MA  $`ߗWci  dMbP?_*+%&?'?(?)?MSnagIt 9C odXXLetterDINU"SMTJSnagIt 9 PrinterInputBinMANUALRESDLLUniresDLLOrientationPORTRAITPaperSizeLETTERResolutionOption3ColorMode24bpp"dXX??&U} *PH} I} F} UF} } } U} } *} } } } U} } *} }  } U } } }  } }  } U } } }  } G @@ @@@AEJJ     J B B m m > nn p rs t t t t  x  yz  v  r{ t t vrrsssw vrrssss nnq t t uuuu  t  t  t  ~  t t uu t t t     t t t    Dooquuuuuuuuu}uuu|||||| k B B C B B B B B  B  B  B  B  C B B B B! B" D# B$ B% B& B' B( B) D* B+ B, B- N.lLL@Lk@Ov#2qBO$tBO,I#ՕBO:DcBOc(=BO@p>_B O`q2hB O\@;B O^eB O@ UB OYNBOI^M8BOWA6BO6A2BO,I#ՕBO]xBOgWLBORBOt6oBO812BOؐ BOe͔BO ?;yBO@lyRBOOőjXBOmBO<BX #B R/[z@\@]@}ZB]-fZB]cvNB]{94B]LܱB]R*0)B ]e*I5B ]L+B ]T,B ]xB ],]PB]TVA]w B]i@ A]cvNB]2B]X"mB] B]< B~ ^ A]~ FB]CIB]?u.B]"B `.$B `<29B `4A `?A `PdA `)B `@Ÿ A `3 A ` 8L]A ``A~ `r `A~ `b `<29B `aKA `@`A `@zA `!A~ a A `ԹcB `hܐB `R&A~ `2ѓA `KA `wA~ ` ZXr B T` _Q@_u@ `4)B `SuB `VZB `1A `VYA `'A ` A `iCoA `OA$ `Gc1`@S*aa4k `I% `VZB ` iAA~ `N `ѰA `@|A~ ` `0ZB `;B `oA~ `2> `UA `qMA~ ` Z(X*B S2_@V@_0w@`w+B`t,B`m#B`\A`)A``A `c9A `x޴A ` );[A `%A `A`J :`6``m#B` 2^A~ a~`@A`^EA~ ``P!B`q"B`0xA~ `<`@[A`@A~ `Z{K B R3\@\@$@]ְ}B]ޮ}B]btB]eaAB]TGB]ͰG=B ]FB ]8QB ]KkzCB ]qT2B ]F-B]p~aEB]`<B]P B]btB]ࠆOeB]< M>B]F:B]I&n[B]:+B]zgtB]@D\~B] ?bB]g,:B]Ǫ@B]@>UB]W]BYPNuB S4_Pp@_@`HyB`M B`D qdB`BQA`A`hlA `A `yA `A `yA `@A`Z>Z`|2`n-`D qdB`A~ `8`BA`ƼA~ axA`f|B`\B`A~ `*T`@A`2A~ aڵOZeB T_ `@_b@`@A`A`lAH`:w]`J`|M`BKUe``jXBUa>Saθa8+Aa*a(A`lA$`"xa8iAa&m$`=Q``^ɦA`HA$`I-Ga2I a` `9/`ZA Ta_I@_ `@` /A`@^A`.AH`↔P`M `J9t;`^OZ`Zd`+E``.aжa2`O`.A`&AaZ `M`%2A~ ```|A` A$`ʄo`"3`j%`B`O`ZϝRA T_X@_`~@`0B`5B`{B`'A~ `Aw`@hIA `@A~  `fz `bA `A `IA`&QW`N^"`Zl,`{B`P7A~ `fS4`IA`"}A~ axA`hpB`R`B` R_ A~ `@`A` vA~ aڵOZ` =B S5_@_e@`j}B`P=}B`p|B`<AB`B`M>B`59B`A[B`p*B`1vtB`00}B`bB`E(:B`~t"?B`@UB` BZ$tB T6_f@_@`2?B`.a ?B`D@B`"#B`iA`蔒A `ФhB `zA `s1A `lA `yA`@A` pA`8A`D@B`B`@ܸA`@3A`B~ a&S `dr:B` `z?B`̌B`PBA`K+A` T*B~ `CbZ8B T7_J@_y@`0MqQ@B`=B`;B`$B`@A`xZ B ` 8B `A `h B `,HA `@A` mA`qA`6A`;B`J_#B~ `&;` jA`|uk!B~ ``[8}_2B`'9B`'B`A`jB`0g B~ `Z83B U8_F@_u@` :B`p*G7B`[(Y0B`x;B`:A`xrB `uB ` A `B `"A `eA~ `>jM`A~ `=!<`[(Y0B`0.B~ `D:`cA`# B~ ``((B`*Cy-B`x$B`wX A`WA`p.A~ `Z&B U9_"@_L@`/B`D@^B`S&B`E(A`naA`+A ``#A `m9MA `VhPA `0`A `3A`2}7Aa" `#a`S&B`d$ Baz` `fB~ ``y+6B`J %B`x!+B~ a~H `@rA`n\A~ `Z^`!B T:_G@_]@`OA`sWA`ptAHb[`ΡbJ8`ʗaF` `g8`Y`V aab``ptA`}A`A T<_C@_K@`@A`,A`iDAH`$`N`n"`:m.``>i(a.aޘ(aRWav~0a2`iDA`*PA`V|!`X`2hw``h5A``dA$`Ŷo`w-`i`Ԧ0`Z!VA T=_G@_^@``A`OA`l2AHb`b`L`*``.`Naada"|l`l2A`1A`&&`Q`ry``wA`](A`3A`a!``d g`Z]hA T>_@Q@_{@`Ļ*B`JJP%B` $B`mA`FA~ `: < `9fA `xA `]A `.A `ц$A`zQ(`bd`o>"` $B` 3zH B`wA``0A`ӵB~ ``HXB`֔%B`pB`rA`ாA` i A~ `ZH_ B T_W@_s@`J B`B`g$BH`q`b"`""t`"`3^`B*J-`^(apaC`"`g$B``WA``z `A~ ``acA`SB`A`y6`f~(`:;A~ `Z8{A T?_E@_b@`k5B` 4B`цHB`@A`eA~ `.ќB `VkA `TA `,EA `OA `3GA`jb`f*(`7`цHB`O3B` mB`8B`&6(Ba7A`^jJV~ !"#$%&'()*+,-./0123456789:J;<=>? T@ _@z@_*@ `eYB `@n\B `@(SB `:ϙ&B `pA `,رD#B `(A(B ` NA `f7 b%B `$OB `l1B `eA `\{A `{A `@(SB `O =B `t B `"B `E}<5B~ a `xnioIB `x.RB `4;B `] B `q\dB `a1B~ `  ZjFB !Ub!_Q@_@!`/B!`Hͽ).B!`+)B!`SxA!`3A!`A! `ZuqA! `o&A! `ղA! `A! `fA!`Fh`B|`j&!`+)B!`!B!`Q$`,cpB$`ilA$`'\`#V$`\FA~ $`$`$nB$`4B$`p0A$`@A$`@b0A$` aA~ $`$ZxtB %UB%_j@_@%`x;B%`1>B%`p4B%`p'|IA%`(A%`0qA% `{FA% `}A% `A% ` xVA% `5A%` A%`6oA%`9A%`p4B%`B%`@)A%`GA%`8CB~ %aBOp%`".B%`BZ2B%`YB%`0;A%`PA%``sB~ %a %Z+B &TC&_v@_@&`pW(B&`'B&`9{(B&` @A~ &`Y}&`@l&A& `!`A~ & `NM{& ``N7A& `H!A& `@xA~ &`f&`:A~ &`#!&`9{(B&`Б B&``CA&`@A&`ٓB~ &a 3A&`b B&`'B&`ղq B&`PKA&`A&`{eA~ &`Ƒ&ZH&a!B 'U'_s@_@'`HUB'`B'`4!$B'`,k^A~ '`!KE'` A' `IA~ ' `^WB' `A' `@ A' `A'` !`l`~'`4!$B'`CA'`QA'`4A'`TA~ 'a 3A'`BB'`B'`pƶA'`@}:A'`A'`@eԞA~ '`Ƒ'ZMB (U(_J@_i@(`JYB(`l?!DB(`rB(`aCA~ (`7D8(`:A( `i.wA~ ( `*9( `A( `EP7A( `4A(`FE`nLR`Xf(`rB(`fA(`lA~ (`|D(`hGA~ (`(`B(`4 [>B(`XOB(`pzA~ (`;(``HA~ (`(Z`B )TD)_U@_0q@)`r,B)`~u,B)`8`B)`0Y=XA)`CA)`A) ` '@A) `A) `pA) `R[A) ` A)`D^6`nj:`s*:)`8`B)`A)`7A)` .A)`@0A~ )`)`2B)`UB)`8ݥ,B)` lA)`4A)`1iA~ )a`VA)ZLdMB *TE*_b@_t@*`5+B*`Ǚ'B*`hMs%B*`` |A*`8#A*`@*3A* `07A* `эA* `mE A* `5A* ` A*`A*`"w`BM*`hMs%B*`T͸B*` L~A*`@|FA*`0EA~ *a~H*` B*`L%B*`2YoB~ *`2[*``\A*`A~ *`*Zo}!B +TF+_P|@_x@+`L$.B+`ˌ/B+`CC)B+`gA+`CA+`A+ ` *]A+ `A+ ` f>A+ `ƝA+ `]DA~ +`**Q+`1,A~ +`=;+`CC)B+`8K B+`YmA+`iA+`ز\0B~ +aƌm+`Z0#B+` /(B+`hYB+`@A+`&5A+` A~ +azUJ+Z^#B ,TG,_}@_@,`}]2B,`s3B,`bY7B,``tA,`d!A,`?FA, `A, `FVA, `h A, `A, `A,`HA~ ,`Wt,`tA,`bY7B,`hLB,`A,`rA,`lLaB~ ,aB,`ёUE0B,`'=6B,`@ZFB,`, A,`A,`фB~ ,af],ZL0B -TH-_h@_v@-`wMKB-`qKB-`_ NB-`B-`T-QA-`t}B- `h޴iB- `#A- `XB- `@A- `VOA-``XA-` A-` K$A-`_ NB-`0B-`E~9B-`8^jB-`|yB~ -a-`K*FFB-`*(MB-`c83B-`\B-`ZB-`ʥ!8 B~ -ab-Zh!_CB .U._b@_v@.` 0B.`=P2B.`x3B.`B~ .`d_|.`IB. `LB~ . `J7-w. `PAB. `@ [BA. `6A.`>iA~ .`2 h.`]A.`x3B.`B.`iHB.`ol A.` A~ .ci@.`z.B.`ę1B.`1B.`` GA.``A.`H B~ .a4.Z.ڡ&B /Ud/_@_@_8@/`İ%B/` .2s"B/`4#B/`FWA~ /`.k/`A7A/ `A~ / ` a/ `g7A/ `xA/ `A~ /` I/`@A~ /`ʶE/`4#B/`$UxIB/`&=A/` 0xA/`С ,A~ /a9@/` y$B/`H&$B/`0 B/`P!A/`A/` RA~ /`/ZؐB 0Ue0_0q@_@0``5B0`6B0`~:B0`6B0`B kA0`1B0 `_B0 `A0 `1B0 ``t4A0 ``t/A0`u A0`A0`PA0`~:B0`1B0`ع B0`pA0`x#B~ 0aٙ0`Z3B0`:B0`B B0`4x` B0`"A0`VB~ 0a0Z!1B 1Uf1_g@_@}@1`T]\B1`-B1`tEy(B1`@4A~ 1`nv@J1`A1 `%pA~ 1 `*E1 `A1 ` A1 `A1`"`"o;`M1`tEy(B1`-\A1`N5A1`:rA1`A~ 1`1``p B1`08PB1` A1`@7A1`5A1`@YnaA~ 1`1ZP B 2TI2_P@_@2`g2B2`.3B2` 43B2` jjA2`sOA2`pA2 `qlA2 `zA2 ` =8A2 `s?A2 `Љ; A2`OxA2`MA2`+7A2` 43B2`Pa1B2`[A2``=A2`(dXB~ 2aNz 2` s*B2`Z2B2``B2`/A2` A2`h' B~ 2ajۈ2Z~,B 3TJ3_Pq@_@3`1dPB3`WjLB3`@2 XB3b3`ISA3bcc3 ``}}B3 ``tA3 `F[B3 ``IjA3 `0XA3`cA3`RXA3`.A3`@2 XB3`^DB3`:"B3`R> B3`_e9B3a B3`7OKB3`@ ^{XB3`#9B3`|B3`B3` Y0B3aВB3ZyRB 4U4_g@_@4`"h+NB4`o"IB4`@ŧہVB4b`¦4`@kA4b@ 4 `PU fB4 ` A4 `\QA4 `A4 `` 'A4`6A4`GA4`RXA4`@ŧہVB4`CB4`"B4`B4`y8B4aE B4`'9U+IB4`WB4`[q8B4`IB4`pHwA4`.=].0B4aϒB4Z>APB 5UK5_\@_Pu@5`M B5`D?Z_B5`p|ruB5` ^A~ 5`Fcz5`:A5 `@ęA~ 5 `檿y5 ` IA$5 `nV`#Ja `p/`6 (5`p|ruB5`iA5`$A5`:A5`ȝA~ 5a @5`B5`HbB5`3A5`@`A5`@6 A5`{A~ 5a@5ZȄB 6TL6_G@__@6`A6`TA6` LAH6`~Mk1` `r`#`D`d `c7aV`aV``a, aw6` LA6`VA6``A~ 6`j%:6`6hIA~ 6ah A6`RNA6`08A6`'A6`f`} 6`4A~ 6a 6ZA 7TM7_؋@_@7`VHB7`:1S&IB7`DoGB7`<B7`RdGA7`-sB7 `T[ڭB7 ` pjA7 `<B7 `lB7 ` A7`afA7`dA7`@d]A7`DoGB7`-B7`IgA7`fn B7`佸#B~ 7`ڛ7`6xA?B7`0DEB7`,B7`0lB7`; B7`(!B~ 7`nm7ZB9`I4"B9` 0DA9`0MA9`|EB~ 9aq9Z|k35B :RN:\@\]@:]iB:]2iB:]R+tB:]Y #1B:]x<` B:] o+B: ]Q3B: ] B: ]v10B: ]j!B: ]fYB:]Xf B:]OA:]*A:]R+tB:]@8N~QB:](H%B:]ۊs-B:]_5UFB~ :]>E:]ɼoB:]pD3CsB:]].\B:]h6B:]}?7B:]yPB:] A:Y hiB ;SO;_@_`@;`1hB;` {>hB;`0sB;`0B;` B;`o)B; `M(02B; `C B; `0R.B; `li±B; `TzB;`0\ B;`љA;` !A;`0sB;`EPB;`,o$B;`f*B;`_2EB~ ;`)#;`@aSOnB;`rB;`[B;`ڐ6B;`q5B;`,PB;`wA;Z@|qhB <TP<_V@_@<``vcB<`ֆcB<`YlB<`ڨ41)B<`[(B<`&$B< `2Ʊ,B< `bB< `F'B< `P&B< `SB<`خ;B<`@A<`P A<`YlB<`h{CLB<`PD$B<`Sp$B<`L:BB~ <`&<`uF[eB<`ԕkB<`PVB<`OU5B<`Ow2B<`IB<`@A<Z`B =U=_]@_y@=``64B=`^B=`@a"B=`[`Tfb= `WA~ = `~SnY= `ځA$= `z`yB`'`ނ``[%=`@a"B=`@ܼA=`.MX`r2=`@A~ =`=`:CQ!B=`]_Z"B=``B=`A=`A=`0 A~ =a"=Z4B >U>_@c@_@>`4B>`kB>`֠B>`tA~ >`*W?>`CuA> `A~ > `^?> `vA$> `rR?`N~2`* ``\>`֠B>`A>``A~ >`:T>`|A~ >>p><B>`'9A>``BWA>`GA>`AeA~ >`2o@>ZB ?U?_0v@_@?`L,B?` =*B?`6B?` ]A?`3A?`lA? `33A? `RA? `֑A? `@A? `A~ ?`2?`ZA~ ?`~,g[?`6B?`«GB?`ЙCFA?`A?`İaB~ ?`*?`7tf2B?`!6B?`Ql$B?`tpB?` #A?`c' B~ ?aN?Z<'BD|Bl @ABCDEFGHIJKLMNOPQRSTUVWXJYZ[\]^_ @U@_y@_@@`\)B@`",B@`[x3B@`PA@`iA@`pFA@ `pA@ `7A@ `;A@ `mgA@ `uA@`A@`~dA@`8lA@`[x3B@`H B@``;kA@`@0A@`RB~ @a@`ԟQ/B@`Oa2B@`_J$B@``15B@`A@`v<B~ @aR@Z9 B AUA_^@_P@A`FBA`BGBA`֏?BA`SĮBA`AA`| BA `p PBA `jAA ` BA ``PAA `\>AA`@[JA~ A`2%MA`6AA`֏?BA`c}/BA`BA`0AA`*&B~ AarA`z /BA`Vx86?BA`c܅t2BA`xR^BA`b>_AA`5V+(B~ AaRIAZ&V)B BUB_U@_t@B`gBB`HkBB`Yw+BB`AB`nN+`ؘ]B `A~ B `tU(B `BAB `vAB `q9R`k` %`FB B`Yw+BB`iA~ B`r0B`}AAB` A~ B`B`~CAB`%MBB`AB`A~ B`FrB`iA~ B`BZPA CUC_T@_ x@C`8BC`ABC`X1BC`[A~ C`wMC`LAC `}A~ C `:fHC `@AC `OAC `lAC`ROm`޹J`rO-C`X1BC`1A~ C`IC`qAC`A~ C`C`еeBC`?BC` $A~ C`fTC`qAC`'oA~ CaVCZ~B DUD_d@_@D`,rBD`ll?BD`Ҳ#BD`eA~ D`*hD`AD `/|A~ D `*dD `3A$D `g`=X@`V&`*%` D`Ҳ#BD`@RAD`AA~ D`XqD`^A~ Da|D`:'v?!BD`>]#BD` RBD`GAD``ZAD`ZB~ Da$VDZ4B EUE_G@_`r@E`OBE`\Z1BE`ܮ`DBE`@( A~ E` x'nE`O%AE `A~ E `5jE ``̋AE `@AE `vAE`BV`&RG`e$E`ܮ`DBE`;{%BE`:AE`0o BE`94B~ E`E`>BE`7DBE``5.X(BE`AE`[rBE``XB~ Ea@EZxk=B FUQF_@@_,@F`"IBF`?~IBF`@`ASBF`@_A3BF`aAF`o BF `BF `PAF `&gBF `x^BF `(sBF`@]yAF`NAF``mAF`@`ASBF`s=y'1BF`HBF`h)BF`={'B~ F`gF`v0PNBF`UzSBF`lyAL`5)AL`n`/L`kA~ L`LZ͈8A MUTM_M@_h@M`V)AM`}BM`` BM`@ A~ M`@M`kAM `(A~ M `v>M ` AM `AM `9aBjN`0^0` 9M`` BM`nAM`2R`-M` XA~ M`M`9pBM`&uBM`@-wA~ M`fGM`AM`@ˉA~ M`MZ B NUUN_3@_T@N`, /BN`0>.2AR`AHR`}[`b`J`6h`*`W`6`R'1aaNh`R`AR`@bARazj`6R`A~ R`R`p2AR`0"IGAR`OmAR`J`B&CR`@]A~ R`RZ iA SVlS_J@_l@S`HBS`pTfBS`MBS`A~ S`?S`] AS `aA~ S `&֎S `ItAS `cA~ S a"0 S`A ASa(` 4S`MBS`@\A~ Sa- S`O`AS`L6A~ S`S`=NAS`hBS`+AS`иA~ S`S`!՚A~ S`SZ d-A TVmT_J@_c@T`pAT`f=AT`У4AHT`Ξ.`2`п`VAE`x`3``aIa2iaT`У4AT`ATa`5"`nf`T`pkAT`vZA$T`pf`͂ `.`=*`TZ0< /A UVU_g@_8@U`@eBU`JBU`t7BU`@ùA~ U`^3GU`zAU `@K1zA~ U `LGU `@cAU `=&AU `AU`<(`JYZ偋B ZToZ_U@_p@Z`BZ`$|:BZ`HUEBZ`TA~ Z` DZ`rAZ `@2A~ Z `QzBZ `@&A$Z `>k`{``jd `Z1`vZ`HUEBZ`^AZ`5`;(Z`TA~ Z`LZ` LBZ`h]BZ`YHAZ`A~ Z`rI^Z`{A~ Z`>JZZ8$B [Tp[_k@_}@[`BO*B[`ra+B[`| B[`d?A[`A[`DXA[ `A[ `)A[ `pXA[ `A[ `yEpA[`aE`ʟr[`{&A[`| B[`_DA[`A~ [`"q3;[` A~ [`[`j.B[` B[`gA[`@@A[`aQA[`sNA~ [`[Z0IyB \Sq\_P@_@\`D$B\`q#B\`0B\`A\`~A\`A\ `nA\ `ۯYA\ `LA$\ `46`N(` `.`0\`0B\`2A~ \`S\`xA\` LA~ \`\`>B\`,]B\`xB~ \`1\`pnA\`K`A~ \aXRA\Z߂B ]T]_D@_@]`pcjB]`2B]`N!B]`A]`.A]`T8A] ` A~ ] `U}] `A$] `~Z`Jab `ba`]`N!B]`{7A~ ]aʝ]`oA]`A~ ]`]`h^aB]`DB]`~A~ ]a&0]``CA]`@A~ ]aXRA]ZoB ^T^_>@_P@^`&(B^` ]B^`.*B^`ZA~ ^`+^`bA^ `@^CA~ ^ `Fw5^ `1A$^ `l`Jav8a/d`'^`.*B^`ZA^a`|^`@A~ ^`^`@A'B^`kxEB^`SA~ ^`Z^`@X3A^`A A~ ^`^ZPqA _Sr__>@_s@_` B_`pVTB_`ivKA_`ݳ=`Zgu&`vv>_ `hA~ _ `f[%_ `8A$_ `f`Fkca[`"`R_`ivKA_` (-A_aFq`d+_`dMA~ _`_``*^A_`YA_`>>A_`` _`9A~ _`_Z@bAD;l^j^l~~Jj `abcJdefghijklmnopMqrstJuvwxyz{|}~ `S`_o@_(@``IEDB``UCB``F2+B``cB``WA`` қ*A` ` v[B` `@A` `2aB$` `ư\c`28a.)+`Y`2UT``F2+B``r:B``A~ ``>`` A~ `aѦ``C٪'B``M)B```Q*A`` k`sTc``0QA~ `a6`ZD%B aSa_e@_p|@a`u0Aa`jAa`EAa`8WAa`Y7`r_sa `y9A~ a `*O5a `XPA$a `)c`,T`a.@`ya`EAa`DNA~ a`{Ja`7[nAa`n`a` Aa`BAa`$Aa`,`2l`-o`aZA bSb_`l@_@b`D(Bb`6Bb`XBb`܆A~ b`Niab`5Ab `0CA~ b `]b `phAb `mHAb ` h`dA` `~zfVb`XBb`Ab`@qAb`AP#Ab`@,A~ b`b`@yYBb`gBb`PAb``]Ab`@Ab` OA~ bc@S@bZuB cRZc\@\@c] Bc]!Bc]27dBc]2g *Bc]CtBc]6Ep!Bc ]"VuABc ]`nBc ]X?Bc ]O 'Bc ]]Bc]LBMBc]@m@ Ac]xBc]27dBc]w+Bi `x?$WBi`p&Ai`GAi`/fAi`ưmQBi`SΈ4Bi`pbAi`(ˣBi`&B~ iai`ʝIBi`UTQBi`"6Bi`qAi`*~$ Bi`hD(B~ ia~pPiZYctHB jTj_ z@_̞@j`YfbBj`@ aBj`M.@Bj`Q Bj`B kUvk_f@_0~@k`[Bk`@MYBk`t |u7Bk`XBk`Ak`PqTAk `h Bk `2XAk `\`Bk `Ak `6Ak`-Ak`,Ak`୿Ak`t |u7Bk` A~ k`jk`0Ak`a%A~ kafk`&5Bk`HH7Bk``Ak` ?"Ak`9Ak`@giA~ ka^)kZ5B lUl_0s@_D@l`5%h@Bl`dR@Bl`N$Bl`пbAl`@3Al`PzAl ` Al `v%Al `YҘAl `@(7Al `?CAl`UAl` Al`zMAl`N$Bl``SlA~ l`>l`~Al`-DA~ lal`d'"Bl`2#Bl`^A~ l`J̃>l`TAl`A~ l`lZ B mTm_h@_@m`7gAfBm``dBm`JP,Bm`LBm`LAm`pYBm `2%!Bm `JTAm ` Bm `H3Bm `@fAm`p3kAm`@CAm` Bm`JP,Bm`\fRBm`^Am`yAm`hB~ m`m` 4"Bm`WY-Bm`l3jBm`;Am`pǿAm`]9B~ m`mZ`."B nSwn_P@_j@n`d+JBn`TbGIBn`&Bn`ΛBp`mA~ p`vvAGp`Ap`@'A~ paN8ApZPB qUq_a@_`y@q`6Bq`Y6Bq`Qa Bq``BA~ q`Xe=q`aAq `~A~ q `-<q `)A$q `Qr_`T[<`*#aG*`v%q`Qa Bq` VCAq`*d `^O8q`13A~ qa@Aq`x#0;Bq`@91 Bq`A~ q`&<q`@rAq`@jaA~ qa& [qZ B rUyr_A@_`@r`ܫ+Br`WBr`@rBr``N`x`*s;r `pA0r `b3 `"uzaz WaZ*Ca"a.2ar`@rB$r`7@a%A```?ap@r`sBr`KBr`֤bAr`Rv `ڵ=r`Bx]A~ ra@rZB sTs_X@_@\@s`eAs`As`hAHs`!F`*Y`zD+`K`(`td0aV/a7a```>s`hA$s`Taab8`0K`s`PWAs`A$s`¹;Ra`;`78`sZvA tR]t\@\@@t]ޜBt]xn}Bt]=2>sBt]b2OBt]꠰Bt] wKBt ]GQ}QBt ]4Bt ]@j*PBt ](CBt ]#w:Bt]89'Bt]t%Bt]|Bt]=2>sBt]=VBt]2yV&Bt]Nq-Bt]PB~ t]nt%t]99lBt]蒄qBt]1gVBt]1Bt]5Bt]1IB~ t]>ڢtYZfhB uSu_@_h@u`@z]Bu`@d7]Bu`@BoUBu`\Xp"Bu``鵠Au``6yBu `&Bu `rAu ` @ $Bu `xپ Bu `P:4Bu`P>Au``[{DAu` vAu`@BoUBu`Cb:Bu`\cNBu`ۉgBu`b^-B~ u` u`HOBu`T^,cTBu`{ 7Bu`by!Bu` :Bu`p]'B~ u`uZ zMB vTv_s@_@v`QY Bv`HL Bv`V2'Bv`@aA~ v`v$Uv`2Av `T7IA~ v `Jv `@[A$v `fJ7N`!.?`( ```6Ev`V2'Bv`BAv`bkR`2vv`2A~ va8Av`l[Bv`4m Bv` Av`XAv`47TAv`#HA~ va<AvZrB wTzw_@_@w`4)QBw`o%QBw`FBw`ě߮Bw` Aw`c^rBw `jBw `Aw `(MBw ` KAw ` ~loAw` .5Aw`@LAw``Aw`FBw`o-Bw`{Bw`,dDBw`duB~ waw`?Bw`KQDBw`ͼ.Bw`FrBw`\Aw`^B~ waAwZ錯:B xU{x_ t@_h@x`вAx`@{Bx`Bx`^_`rq-`'2x ` A~ x `˜+x `L;A$x `"D9O`H`"5ang47`؃x`Bx`Ax`g#A~ x`>Xx``cA~ x`x`RAx`6Bx`O$MAx`oA~ x`xZx``AA~ x`xZElA yU|y_pt@_h@y`ۡ\By`pٺBy`By`A~ y`g{/y`Ay `@^A~ y `hT+y `SA$y `˪b`ބR`FaM2;`"@y`By`>AA4Aı*|`&lA~ |a2+|Z0"B }T}_q@_@}`P #B}`!B}`)QB}`݇A}`Є*A}`hA~ ~`J~ZD9e.B S~_@@_ɼ@` سB` qB`qgB`tKfIB`3B`_JGB `* [^LB `tMfB `c1JB ` AB `7B`[$B`eG?#B`(yB`qgB`|MB` B`= #B`+ GB~ `ZS`@XGdaB`=eB`NB` [K3B`Vf1B`GBB~ `Z@ [BD?l  t>J S_@_@`e+B``.B`ȷ)B` kA`A`A `o"A `tA `2A `< RA `CWA`V`F`U`ȷ)B`+IB` uA`@2}A` gA~ an`\aj/%B`[|H)B`߽kA`@?zOA`dA`(`:A~ aZk%B S_N@_`u@`ޞ B`HngB``׍.AH`E` `b9`Nk`| `Lt_``qavPy` ```׍.A$`=;`6`2`r1``'hA``ʛ'A$`b` `)`*3,`Z@PA S_]@_pu@`& B`(x B`pA`A`2O`N `$GA~ `6QZO `aA$ `vЖ$`~I$aM`vw`"]`pA`OGA`q`I`ܝA~ ``0qQA`A`@BA`R8`|`>)A~ `Z0WbA S_ `@_}@`JB`7B`T@uAH`bD`Vb.`\}`: B`f`3`Pa`]`fK`T@uA`*jA`ȶ`A`Wab`yJA`"qA`jA`:4`a`~z`ZKxnA S_Y@_@`μcK$B`6K9+B`B``eA`oA` I^A `MA `&A `^A `@aA `֣A`Zh`nGw`r>`B`@H A`FE`RlN`[ҞA~ aBA`b/B`,KB`PA`@ZA`A` 4A~ a#AZ$B T_O@_y@`xʷB`pӥ B`A`{XA~ `h#`^ ZA `@qA~ `ۥ  `@gA$ `EO`ʜPH`aJ%`P&`A`yA``8`OIH`oHaBA`PA`pOA`A`J7`*2` A~ a#AZp)A T_D@_t@`(B`nB`lzB`A`"A`@A `%A `/A `pA ` A `&ÙAazOa&Xg]`V"`lzB`"A`J `^"`A~ ``05r(B`̘B`zA`@A~ `FQb`t5RA~ `Z B S_t@_@`׫vB`@jB`+pB`rUA~ `vAmj`@A `@ qA~ `*h `[A `A `A`V`*1`* #`+pB`)E~A~ ` o`t,A`@!A~ ``0 . B`&B`PdA`A`*"A`@_A~ ahUAZp= B K^dL@dR@e>meR e:Qb f.3g@fBJeZjg@efgJXgg5AgDIAee:Qb geegee$e e.lAe%Dg.geQ .  B hBiiiiiiiiiiiiiiiiiiiiiiiiiiiiii jBiiiiiiiiiiiiiiiiiiiiiiiiiiiiii hBiiiiiiPPPPPPPPPPPPPPPPPPPPPPPP jBiiiiiiiiPPPPPPPPPPPPPPPPPPPPPP jBiiiiiiiiiiiiiiiiiiiiiiiiiiiii jBiiiiiiiiiiiiiiiiiiiiiiiiiiiiii$,>VTTTTTT>@ddijA   z/       7 Sheet1ggD dirLSheet1 Module1Module2   !"#$%&'()*+,-./012345678:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWY[\]^_`bdefghijklmnopqrstuvwxyz{|}~H0* pHd VBAProject4@j = r 5L J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\STDOLE2.TLB# Automation`E OfficEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram obs\CommonMicrosoft Shared\OFFICE12\MSO.DLL#M 1q Ob LibraryK  Module1G#du1* 2 HB1plBE,BZ!B+BqThisWorkbookG@T@sisW rkbo 2 $5$_l"B#$Sheet+BAS@#eut;AG2B#IJG^2O^2J^2O^$2OO9UI^B</J#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}H(%H0(85LxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ZxMEP6 LLL<<<80%  `xkH``0@"l B$Microso*@h ic@xX @H @8 e@( ent@ ReT2@ on.L(@8 siPK@  ppx8@o `@ p`p885L$*\Rffff*014c35e8e7*\R1*#33b*\R1*#10d*\R1*#10d*\R1*#10d"$=00 HX `h x8 "a4:D202 $%!& "!(0 "!*B@,k oͰAttribute VB_Name = "Module1" Sub DeleteSummary_Rows()  For Each c In ActiveSheet.Range("a4:D202").CellsjrIfbStr(c.Value, "0") <> 0 Then)-c.Entire{.End IfNext  K*rU~~~~~~~~~~~a nP3]NB  a p  a   ^ UxMEP6 LL<<<x 00%8<$@hh @X 4`kDD`6zj1 P8@T @D @84 @P0 @ @  @h @ @ nt@ an@ xp@ @@ @X @ @  @(x @ph @X @T @D Se@4 li@$ @H x@` @ @ @0 @x Cy@ t&@@ dI@X Mk@ @ `@| @l @\ p03@L go` 3@H @p8 go@( c@ @ @ @H @` @ @0 et@ Mk@ YF@x @ @ @p @`  @P\ @hL @ < @8, @ Se@ d @ @ @ @ @ ee@X @p @(  @@ @ @ @p ?`@` @P @ @ o@ 0 @, MS@ @0 @H @ ?5L$*\Rffff*014c35e92c*\R1*#33b*\R1*#10d*\R1*#222*\R1*#10dD"   ,0 ` h p ,  `       ( r`+h  Sx"a$%.&%(&%0X `"ah %"%     EG @   H 6` Ux p6@ PEX px     format_table_final Macro% Macro recorded 6/18/2008 by jrmill00j1 Macro1 Macroj1% Macro recorded 5/15/2008 by jrmill00`Zactivecell.offset(x,y) allows for referring to cells relative to the current selected cell e.g., activecell.offset(2,3) would reference the cell 2 rows down and three columns over; (0,1) would be same row one column over]E5$B@Hl.Offs 8!( 8%:!( 8%:!( 8%:!(b" '6 8!(b 8%:en 8!( 8!(lue) <"* [2]" ;[Black]"* [2]" <(> 8!( electio#,##0, ;[Black]"*" -#,##0, <(>* dx"*" #,##0, ;[Black]-#,##0, <(>e kHd@ 8!( 8!(ormat "[2]" ;[Black]"[2]" <(>d#,##0, ;[Black]-#,##0, <(> Selekk 6 '6## 8%:B@H 6 8%:B@Hlse ` veCell  $%&B@H .H 8!( 8%:!( 8%:!( 8%:!( 8%:!( 8%:!( 8%:!( 8%:!(b  - 8!(ESV 8%:!(ESV 8%:!(ESV 8%:!(ESV 8%:!(ESV 8%:!(ESV, 3).S 8!@B@, DdP 8%:B@Hk0( Value oPAttribute VB_Name = "Module2" Sub format_table_final() 'h Mac ro6 recorded 6/18/2008 by jrmill00N O31C5/15C'activecell.offset(x,y) allowsferring (to (slathe current seplectZe @e.g., 22,3) would0ence C%E 2 r?down and re3olumns over; @ (0,1)!be s on Dim x As Integer Range("E5").SkDo Whil(e AOCOValue <> "P" OrIOCV0, 2). _U 4K 6 :x, G9 If1]9Then bs(F) < 500 A@tM0 `ion.NumberF""* [2]];[BlackDaElseK5c -4992 #,##@;`-4O&?az` X ,If A!?5 +\?5354$8w$#E#l+%ix + 1hX$|1, 0˅aLoop'-xCG@_ b _1 To 5  Sheet.A7s(b, 3O!,' 2.) 3$ 4 r5m'FrESV/bw 'yu}koo]0E@ntireC}.DvteK}pX1_.]?6SNext b4Q __SRP_09__SRP_1 X^__SRP_2Z__SRP_3 ag )Module1 ThisWorkbookSheet1 VBAProjectF@C:\Program obs\Common obs\Microsoft Shared\VBA\VBA6\VBE6.DLLVBA 1 Y0F4C:\Program obs\Microsoft Office\Office12\EXCEL.EXEExcel Qy@0FC:\WINDOWS\system32\STDOLE2.TLBstdole aPL-[DR?C:\Program obs\Common obs\Microsoft Shared\OFFICE12\MSO.DLLOffice a`DeleteSummary_Rows Module2Macro1format_table_final a4:D195FFa Range Cells Value 0EntireRow Deletea D5 FF ."* [2]" ;[Black]"* [2]"NumberFormat 4#,##0, ;[Black]"*" -#,##0, 4"*" #,##0, ;[Black]-#,##0, &"[2]" ;[Black]"[2]" ,#,##0, ;[Black]-#,##0, Select ESV E5 E3 a4:D199 a4:D202 rU   14qrU~|  19Q9 i =:X %h$ @h8A(lh580lA8:X((H]@68(l=( 5( l?4lh8(krU $`nrU~|  1a A     (T'X%:h%$ TTT$ (TaD:h]<4(X%(%0$ (0__SRP_4c __SRP_5 gThisWorkbook_VBA_PROJECT a:]<(%(x%$ (XTTa4:D]<$(%(%$ (a:]<|)T0T6DX4+pz+T$ (TaD:h]@T5DS(h%( %T$ (TD00a4:]@)T06D4aT$ (TaD4(h]c0$ (0a(X]<')T06DU%:h%T $ TT+T$ (TaD(h ]gT5D%:h%T $ TT%:h %T $ TTaT$ (TaD4(h]c0$ (0a(X]<')T06D_%:h %T $ TT%:h %T $ TT kzpzE(h%( %T$ (TD00)T05DNGkzDh%( %T$ (TD00)T05D*( l(XhL 6l @(X%T$ @T4  T54T$ (TaD:h]<4(X%(%0$ (0a:]<(%(x%$ (XTTa4:D]<$(%(%$ (a:]<|(8%(%H$ (Ha:]<(%(%$ (`\\a<:L]<,(%(%$ (a:]<(p%(P%$ (0,,a :]<)T0TH\,6DX4`<0  T$ (TaD:h]/4(X%(%0$ (0a:]/(%(x%$ (XTTa4:D]/$(%(%$ (a:]/|(8%(%H$ (Ha:]/(%(%$ (`\\a<:L]/,)T0TH\6DX4`<6T$ (TaD00u)T05D E(h%( %T$ (TD00)T05Dv l~L@="U 0\Ll-T0TH\,D4X4$|`<,0 UkrU $`n/_l#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}H(%H0(85LxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2a  *\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.6#0#C:\Program Files\Microsoft Office\Office12\EXCEL.EXE#Microsoft Excel 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\STDOLE2.TLB#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.4#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 12.0 Object Library 5LModule1014c35e8e7Module1ZThisWorkbook054c35e8c8ThisWorkbook_l5 Sheet1064c35e8c8 Sheet1J05Module2014c35e92c0Module2UPpP0: P Jѵ=ѲǙq@^ha Jv2A\ZGm0D&0#%() b Excel+ VBAWin16~Win32MacVBA6#Project1  stdole` VBAProject Officeu Module1b _EvaluateMacro1NRange  ThisWorkbook| Sheet1(DeleteSummary_RowsRcZ ActiveSheet%NCellsValueK EntireRowDeletexWorkbookk Module2c Worksheet(format_table_finalxo ActiveCellOffset SelectionZ NumberFormatR EntireColumn_B_var_c_Defaultj_B_var_bl1 H@ID="{686CDEE9-EB25-4197-BFDA-81289C7E163D}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module2 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="8A88993A3E3E3E3E3E3E3E3E" DPB="2B29389DD89ED89ED8" GC="CCCEDF4021E022E0221F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 29, 1476, 763, C ThisWorkbook=0, 0,PROJECTPROJECTwmnSummaryInformation(DocumentSummaryInformation8  0, 0, C Sheet1=0, 0, 0, 0, C Module2=22, 29, 1480, 763, C Module1Module1ThisWorkbookThisWorkbookSheet1Sheet1Module2Module2Oh+'0HPdx  cjohat00 nemcgr00Microsoft Excel@b@S嗴@v^՜.+,0 PX|  Internal Revenue Service Sheet1  Worksheets F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89qCompObjr