ࡱ> 1<4  !"#$%&'()*+,-./035;6789:>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FpQ2FWorkbook?]ETExtDataJ_VBA_PROJECT_CUR"pQpQ  @\pR Ba= ThisWorkbook=m38X@"1&Arial10[SO10[SO10[SO1[SO1[SO1[SO1 [SO1[SO14[SO1[SO18[SO1h8[SO1<[SO1 [SO1>[SO14[SO1 [SO1,8[SO1[SO1[SO18[SO1[SO1?[SO+""#,##0;""\-#,##05""#,##0;[Red]""\-#,##07""#,##0.00;""\-#,##0.00A""#,##0.00;[Red]""\-#,##0.00i*2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ W))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ y,:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ g+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ /\$#,##0_);\(\$#,##0\)9\$#,##0_);[Red]\(\$#,##0\);\$#,##0.00_);\(\$#,##0.00\)E \$#,##0.00_);[Red]\(\$#,##0.00\)                + , $ )   -   *    /  *  . >     `  /  ,   -    .  ,  3           $ 1 4 P P * a>   ff7   9 1 5 +    1  1   1"<@ @ "<@ @ 1"<@ @ "<@ @ :_eW[r 4!20% - :_eW[r 2 h!20% - :_eW[r 1 eQ!20% - :_eW[r 3!20% - :_eW[r 4:_eW[r 1!20% - :_eW[r 5:_eW[r 2cUSCQ=to_date('2014-07-01','yyyy-mm-dd')and fzrq<=to_date('2014-07-31','yyyy-mm-dd'))b left join (select codeno,code from code t where codetypeno like '%XZQH%')a on b.ssqx=a.codeno left join (select xkzxh,fwmc,LBBH,fwlb,zysl,bzzysl,jldw,bz from gfzy_xkzmx t )c on b.xkzxh=c.xkzxh left join (select sqdh,slbh,ysqd,jyd,yszd from gfzy_spzb t)d on b.slbh=d.slbh order by b.USMO Ty   @ %-  dMbP?_*+%& ` `?' ` `?(?)?" dX333333?333333?Ud >@<$ bbAggD  @  a%=LKZ[  dMbP?_*+%&?'?(?)?" dX??U} >} )>}  >} >} $>} m @}  @a      A A A A A B B C C C C C Dk@D@ C C C C CD`l@D@ C C C C CD`l@D@ C C C C CD`l@D@ C C C C CDl@D@ C C C C CDl@D@ C C C! C CDl@D@ C" C# C$ C CDl@D@ C% C& C$ C C Dl@D@ C' C( C$ C C Dl@D@ C) C* C+ C C Dl@D@ C, C- C! C C Dl@D x@ C. C/ C0 C C Dl@D@ C1 C2 C C CDl@D@ C3 C4 C C CDl@D@ C5 C6 C! C CDl@D@ C7 C8 C9 C CDl@D@ C: C; C+ C CDl@D@ C< C= C> C CDl@D@ C? C@ CA C CDl@D@ CB CC CD C CD`m@D`@ CE CF CG CH CD`m@D@ CI CJ C C CD`m@D@ CK CL C> C CDm@D@ CM CN C$ C CD`m@D@ CO CP CQ C CD`m@D@ CR CS CQ C CD`m@D@ CT CU CQ C CD`m@D@ CV CW C C CD`m@D@ CX CY C! C CDm@D@ CZ CY C! C CDm@D@Dlb\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ !"#$%&'()*+,-./0123456789:;<=>? C[ C\ C C C Dm@D@ !C] !C^ !C0 !C !C!Dm@D@ "C_ "C` "Ca "C "C"Dm@D@ #Cb #Cc #C0 #C #C#Dm@D@ $Cd $Ce $C0 $C $C$Dm@D@ %Cf %Cg %C9 %C %C%Dm@D@ &Ch &Ci &C &Cj &C&D n@D@ 'Ck 'Cl 'C 'C 'C'D n@D@ (Cm (Cn (C (C (C(D n@D@ )Co )Cp )C+ )C )C)D@n@D@ *Cq *Cr *C *C *C*D@n@D@ +Cs +Ct +CA +C +C+D n@Dq@ ,Cu ,Cv ,C ,C ,C,D n@D@ -Cw -Cx -C -C -C-D@n@D@ .Cy .Cz .CA .C{ .C.D@n@D@ /C| /C} /CA /C /C/D`n@D@ 0C~ 0C 0C 0C 0C0D`n@D@ 1C 1C 1CA 1C 1C1D`n@D@ 2C 2C 2C 2C 2C2Dn@D@ 3C 3C 3C 3C 3C3Dn@D@ 4C 4C 4C 4C 4C4Dn@D@ 5C 5C 5C 5C 5C5Dn@D@ 6C 6C 6CG 6C 6C6Dn@D~@ 7C 7C 7CG 7C 7C7Do@D@ 8C 8C 8C 8C 8C8Do@D@ 9C 9C 9C 9C 9C 9Do@D@ :C :C :C+ :C :C :Do@D@ ;C ;C ;C0 ;C ;C;Do@D@ <C <C <CG <C <C<Do@D@ =C =C =C+ =C =C=Do@D@ >C >C >C0 >C >C>Do@D@ ?C ?C ?C> ?C ?C?Do@D@Dl\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @C @C @C @C @C@Do@D@ AC AC AC> AC ACADo@D@ BC BC BC> BC BCBDo@D@ CC CC CC CC CCCDo@D@ DC DC DC0 DC DCDD o@D@ EC EC EC> EC ECED o@D@ FC FC FC FC FCFD@o@D@ GC GC GC> GC GCGD@o@D@ HC HC HC HC HCHD@o@D@ IC IC ICa IC ICID`o@D@ JC JC JC JC JCJDo@D@ KC KC KC9 KC KCKDo@D@ LC LC LC LC LCLDo@Ds@ MC MC MC MC MCMDo@D@ NC NC NC NC NCNDo@D@ OC OC OC0 OC OCODo@D@ PC PC PC PC PCPDo@D@ QC QC QC! QC QCQDo@D`{@ RC RC RC RC RCRDo@D@ SC SC SC+ SC SCSDo@D@ TC TC TCa TC TCTDp@D@ UC UC UC0 UC UCUDp@D@ VC VC VC VC VCVDp@D@ WC WC WCG WC WCWDp@D@ XC XC XC XC XCXDp@D@ YC YC YCG YC YCYDp@Dy@ ZC ZC ZC ZC ZCZD p@D@ [C [C [CA [C [C[D@p@D@ \C \C \C \C \C\Do@D@ ]C ]C ]CQ ]C ]C]Do@D@ ^C ^C ^CQ ^C ^C^Do@D@ _C _C _CQ _C _C_Do@D@Dl\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\` `C `C `C0 `Cl `C`D@p@D@p>@<  $ bbAggDSheet1  @ %\  dMbP?_*+%&?'?(?)?"d??U} $ > ?">@<$ bbAggDSheet2   !"#$%&()*+,-./012345678:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstvwxyz{|~ .'E``````````````````````````` m0 pH VBAProject@j="8 4UT n<zrs@tdole>stdol@e h^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\e2.tlb#OLE AutomationEOfficEOficE E2DF8D04C-5BFA-101B-BHDE5MAAC4 2Egram Files\C ommonMicrosoft Shared\OFFICE12\MSO.DLL#M 1q Ob Library`VBIDE>BIDTEVBApQpQdir Sheet1~Sheet2 '~E1575.3/ 6E6EX T.OLB0Visual Basic for A pplicas Extensibility "BBThisWorkbookGVAi@WrPkboU 2 BH·1A~Ƶ,QB["B+Sheet1GU¸S@e@tMH2NA222R2+V}<jxA#<q@xauu F =I~BSw x =I~BSw q@xauuME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@\\04U$*\Rffff*0>5597c1344xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2<jx+V#<m/KAq Fc1؀N7ēcxc1؀N7ēcm/KAq ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@\\04U$*\Rffff*0?5597c1344xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ToDOLE =__SRP_09__SRP_1 u__SRP_2}rU~~~~w  9iwb ModuleName i FromVBProject ToVBProjectOverwriteExistingstrkeyValue ValueType WorkBookName Email_AddressSubjectBody CC_email_add AttachmentlengthFullPathFragMarkpathf 9q ( 98rU~| 7Y i ) q 1 q a QYY 1a Qa9 )9t," x$ x xHt $ 0ltp x$ x lp=2tpx$" x$ x x  >\(`%x$ x d \W< :L ]@)x\5<V=[x x $ " x$ x xP,$ $tpx\<,F\`:d %tx$ Xx \t ` ,Q\X)xt`X <X <X <X <X <X <X <X < X < X <9*#T*#P*#L*#H X <2TPLH X < X <X <!X <"X <X <cX4(X,TPLHxt`\l$ XQlx'X:\ %lx \l QXtllt ,Qlp lpTPT 8lPT @cTo,4TtxplX0 8  0 x  0   0   0   0   x l xK.\(`%px p d \#)p\<\ `%',%'<%'L%p$ p ( )p\ :` %p$ @p p(p'L%:`$%$ pp!:`%%p$ (p,p(p'L%:`&%$ ppY'( p$ p Tl(*#$(*F%\$ (\,2($)p\5(p'L%:`)%$ ppr:`*  + ,  +:L-%p$ (p,p6(p'L%:`.%$ pp!:`/%p$ (p,p(p'L%:`0%$ pp!:`1%p$ (p,p(p'L%:`2%$ pp!:`3%p$ (p,ppx Qp[tt=?tW :`4%:<5%f%px pp6 tu5L%\(`%px p d \6)p\x4xt8 ($p\0 P  0   0   0 P  0 8   0 H  0   0 0  0   0 H   0  0        __SRP_3 ;__SRP_44__SRP_5 B__SRP_6rU $`$`$`$`,!`aDI`0==#$q`$`0` Iay0/0, `a( `0$9 `$a `$ `<`A00000$`(`a&$)`(Q`y/,y`//$`$`nrU  ! I i$4q  `rU @nrU 9a4`rU @nrU H9!4__SRP_7B__SRP_8__SRP_9BThisWorkbook`rU @n@Attribute VB_Name = "ThisWorkbook" Bas0{0-6}| _VBA_PROJECT'PROJECTPROJECTwm hSummaryInformation( a   ID="{604A11B2-F47B-4D26-BED0-F2BAAA7BD71A}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="7F7D71F48F0C0A100A100A100A10" DPB="FEFCF075108B8E8C8E8C8E" GC="7D7F73F28D708E708E8F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C ThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Oh+'0|   (4<DLtRguest@ג@TWPS Office *NNHr՜.+,D՜.+,\   (\dDocumentSummaryInformation8lKSOProductBuildVer2052-9.1.0.4715