ࡱ> ML  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKUhOPQRSTVeWaYZ[\]^_`bcdflgjkmnwpqrstuviRoot Entry F “`}dɓN'Workbook_VBA_PROJECT_CUR"NUē0_ēVBA`qWē|ē f2ɀ\p'Y0W|~ Ba= ThisWorkbook=t-"8X@"15[SO15[SO15[SO15[SO15[SO1 5[SO1$5[SO1h5[SO15[SO15[SO15[SO15[SO1.5Times New Roman15[SO15[SO15[SO1@5[SO1h5[SO1"5 N[_GB231215[SO1[SO1 [SO1h8[SO1,8[SO18[SO18[SO1[SO1[SO1[SO14[SO1 [SO1[SO1 [SO14[SO1<[SO1?[SO1>[SO""#,##0;""\-#,##0""#,##0;[Red]""\-#,##0""#,##0.00;""\-#,##0.00#""#,##0.00;[Red]""\-#,##0.007*2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ?,:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\)0.00_);[Red]\(0.00\)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                     P P        a> , *   ff   ! "` + )       # $ %       1<@  @ @  $@ @ 1 $@ @   (@ @ 0@ @  8@  <@ 8w@ @ 8 !  8 !0  0 8@ 8@  xU   xU   xPU  ||U9!T}-}00_)}-}00_)}-}00_)}-}00_)}A}00_)ef[$ -}A}00_)ef [$ -}A}00_)L[$ -}A}00_)L[$ -}-}00_)}A}00_)L[$ -}A}00_)L[$ -}A}00_)L [$ -}A}00_)23[$ -}A}00_)23[$ -}-}00_)}-}00_)}A} 00_)23[$ -}-}!00_)}-}#00_)}A}$00_)[$ -}A}%00_)?[$ -}A}&00_)23[$ -}-}'00_)}A}(00_)[$ -}A}+a00_)[$ -}U},00_)[$ -##0.}}/}00_)[$ -##0.  }}000_)[$ -???##0.??? ??? ???}-}100_)}-}200_)}A}3}00_)[$ -}A}600_)[$ -}A}700_)[$ -}A}800_)[$ -}A}900_)[$ -}A}:00_)[$ -}A};00_) [$ -}A}<e00_)[$ -}}=???00_)[$ -???##0.??? ??? ???}}>??v00_)̙[$ -##0.  }x}@00_)̙[$##  !20% - :_eW[r 1C20% - :_eW[r 1 %!20% - :_eW[r 2C"20% - :_eW[r 2 %!20% - :_eW[r 3C&20% - :_eW[r 3 %!20% - :_eW[r 4C*20% - :_eW[r 4 %!20% - :_eW[r 5O.20% - :_eW[r 5 ef %!20% - :_eW[r 6O220% - :_eW[r 6  ef %!40% - :_eW[r 1O40% - :_eW[r 1 L %!40% - :_eW[r 2O#40% - :_eW[r 2 L渷 %!40% - :_eW[r 3C'40% - :_eW[r 3 %!40% - :_eW[r 4O+40% - :_eW[r 4 L %!40% - :_eW[r 5O/40% - :_eW[r 5 L %!40% - :_eW[r 6O340% - :_eW[r 6  Lմ %!60% - :_eW[r 1O 60% - :_eW[r 1 23 %!60% - :_eW[r 2O$60% - :_eW[r 2 23ږ %!60% - :_eW[r 3C(60% - :_eW[r 3 %!60% - :_eW[r 4C,60% - :_eW[r 4 %! 60% - :_eW[r 5O060% - :_eW[r 5 23 %!!60% - :_eW[r 6C460% - :_eW[r 6 %"~vRk #h+h I}%$h 1=h 1 I}%O%h 2=h 2 I}%?&h 3=h 3 I}%23'h 4/h 4 I}%(]5]  %8^ĉ) 8^ĉ_Sheet1*c+}Y5}Y  a% ,Gl;`GGl;` %OO-'^. '^[0] /{o{  }% 0hgUSCQeQoeQ ̙ ??v% ? $ ]vc @lʑ^ lʑ  XTableStyleMedium9PivotStyleLight16`3K3ubGl;`hXf[yR{| kN~f[yVV ejxk; InsertLine xk;zr863 A@@ 1.,cPUSMO~{z 000000000000000T|N000000T|5u݋00000( ,  7^S 7Ty 7#N 7]\OUSMO 7gbgb__ 7cPUSMO 7Yl 7 ?a&Tl:NzyNDR 7 lR0y>y0ZQSZQ^ 7Tf[0[Yef[ 7?elf[ 7lf[ 7SSf[ 7-NVef[ 7-NVf[ 7Yef[ 7e.stet0VfN`b0ZSirf[ 7z/gf[ 7yr+Rc:y:NnxO3ubpenceQv gHe'` (WSb_echeR_/T(u[ b`SNǏ NRek/T(u[: Office2003:]wQ- y-[hQ'`-[[hQ'`--N sQ핇ech ͑eSb_ech /T(u[ Office2007:Office c!Excel y!ON-N_! ON-N_n c (W ON-N_ [݋Fh-N b [n ! /T(u@b g[ 0 R_O(u,gkeW[ Ne~rFhQ mRU_ cmR3ubpencU_ ,gGl;`hsQeO!hpenc gHe'` YNsQ cc:yhg f[yR{| I{U_W[kvpenc/f&T cĉ[eQ:[f 7f[yR{| 7Kb:gSx0000000000000000000000_kX  7N~f[y 7 l0i`0R0e``xvz 7klN``0\s^txvzlKQ`;NIN``Syf[>yO;NIN>yO;NINЏRS(+TVEqQN;NINЏR) VYlKQ`;NINxvz >yO;NIN|^yef^xvz lRy>yvQNf[yZQS 7ZQ^ 7 ZQSZQ^vQNf[ylKQ`;NINTf[yf[b/gTf[ 7-NVTf[SNeTf[SeTf[SsNYVTf[;f[&Otf[f[Tf[vQNf[y?el~Nmf[[‰~Nmf[_‰~Nmf[k~Nmf[SU\~Nmf[uNR~Nmf[~Nm0Wtf[~Nm``S~NmSNLu~Nmf[Vl~Nmf[:SW~Nmf[t~NmvQNf[y 7{t~Nmf[peϑ~Nmf[Of[[f[b/g~Nmf[u`~Nmf[RR~Nmf[W^~Nmf[Dn~Nmf[sX~Nmf[irD~Nmf[]N~Nmf[QQg~Nmf[QN~Nmf[N~Nmf[^Q{~Nmf[FUN~Nmf[NyO~f[NS~f[sXNu`~f[VE~f[~f[vQNf[y?elf[t?el6R^L?ef[VE?elf[?elf[vQNf[ytlf[l_Sf[lf[VElf[lf[vQNf[y>yOf[S>yOf[t>yOf[el[>yOf[pet>yOf[^(u>yOf[k>yOf[>yO0Wtf[?el>yOf[eS>yOf[SS>yOf[yf[>yOf[~Nm>yOf[QN>yOf[>yO_tf[lQqQsQ|f[>yON{|f[~~>yOf[SU\>yOf[y)R>yOf[>yOf[vQNf[yNSf[StNS~Nmf[NS>yOf[NSf[SNSSNS0Wtf[NSu`f[:SWNSf[NS|~] zNSKmf[NSĉRf[NS?eV{f[Ruf[NSf[vQNf[yletleSf[ -NV\peleeW[Sf[υf[ eSN{|f[NlOf[NLulexvz lexvzvQNf[yVEbeuVE~NmVE?elVEQNVEeSVEsQ|VE~~hQt'`VE~Txvz VExvzvQNf[y-NVSf[S-NVSf[tSSe.sf[-NVS-NVSNS-NVя0sNSNS-NVSSvQNf[yNLuSf[SNLuSf[tNLuSN2mS^2mS2mS'k2mSo2m0'Y m2mSNLuSSvQNf[yStSf[SSb/g-NVSYVSNSSf[vQNf[y[Yef[te^ySY[YeSN[Ye[OYeWcwYe OepQYeSYe -NVl[YeNlON-NV\pele[YeS_N[Ye[Yef[vQNf[yef[tezf[ef[ybċSNef[яNef[sNef[TSOef[lef[?Qzef[\peleef[-NVef[vQNf[y YVef[tNelkef[Neef[Oςef[ef[lVef[YVef[vQNf[ynff[kf[0Wtf[>yOf[_tf[^(uf[Ilxvz -NV\pelexvzYVxvzf[vQNf[yeteSeNReNN~%{t^dN5uƉ Odf[ ef[N Odf[vQNf[yVfNf[ 7e.sf[`bf[chHhf[ZSirf[VfN0`bNe.sf[vQNf[y 7SOTf[SOtSO{tf[SO>yOf[SO~Nmf[SOlf[f[!hSOf[>yOSOf[zbSOf[SOSSOf[vQNf[y{t``S 7{tf[tNel 7beuNQV{{t 7~~L:N{t 7ONt 7"RNO{t 7NRDn{t 7uNNЏ\O{t 7%{t 7VEFUR{t 7RNNRe{t 7e8n{t 7"?eё{t 7Qg~Nm{t 7DnsX{t 7 RR1\NN>yOO{t 7 lQqQ{tNlQqQ?eV{ 7 lQqQ[hQNqS:g{t 7lQqQkSu{t 7lQqQgR{t 7 5uP[FURT5uP[?eR{t  7:SWSU\{t 7^?e^~~{t 7eSz/g{t 7QN{t 7{tf[vQNf[y 7YeSSb-NVYeS0YVYeSI{  7Yef[St 7Yef[ 7_St 7Ye>yOf[ 7Ye_tf[ 7Ye~Nmf[ 7Ye{tf[ 7kYef[ 7Yeb/gf[ 7f[MRYef[ 7nfYef[SbRI{Yef[0-NI{Yef[I{  7ؚI{Yef[ 7bNYef[ 7Yef[vQNf[y 7eSSU\S 7eS0Wtf[ 7eS_tf[ 7eSWNf[ 7eSf[vQNf[y 7z/gf[0z/gS 7SOf[ 7t~Nm 7^(u~Nm 7{tf[ 7>yOf[  7YVNef[ 7ef[  7eSf[  7+D1-4 2017t^w>yyTxvz3ubGl;`hcPUSMOkXQ  70N5g31eMR\Gl;`hv5uP[echS0Rw>yyT>yVYzjsslxhc@vip.163.com 7R[be>>?w??s@7ANIB`wCDEFGccBOUj_ KU f2ɀ  _PT dMbP?_*+%8&~?'~?(\.?)\.?MHP LaserJet Professional M12164 4Xv~=%tHj"Q?SDDMHP LaserJet Professional M1216n 0Z(d3Ԟ4" dX `? `?&`U} } } 3 } 3} f}  } f} } } 3 } }   @ :@ h@  l @0 l 8 8 8 8 8 8 8 K+LLLLLLLLLLL MNOOOOOOOOOO P,QQQQQQQQQQQ RSSSSSSSSSST H H H H H H H I- H  H  A  HGFBBFBBBCBBD ~ G@FBBFBBBCBBD ~ G@FBBFBBBCBBD ~ G@FBBFBBBCBBD ~ G@ FBBFBBBCBBD ~ G@ FBBFBBBCBBD ~ G@ FBBFBBBCBBD ....".....5(  ~  <\M CC@o],@U9$< mRU_<@)>@dd"     7b PkX ?aa b &T /ecY6R|4 vQ[eQeHe ?aa&T  > cUSCQ cUSCQ@   7 Sheet2ggD f2ɀ 4Klp;uyK~ӂ[k dMbP?_*+%8&ffffff?'ffffff?(?)?"8333333?333333?&<3=U} \\ \  \ \\\\\\\\\\\\\\\\\\\\ J J J J J J J J J J J! J" J# J$ J% J& J' J( J) J* J+ J, J- J. J/ J0 J1 J2 J3 J4 J5 J6D@l \!"\#\$\%\&\'\(\)\*\+\,\-\.\/\0\1\2\3\4\5\6\7\8\9:\;\<\=\>\?\ J7 !J8 "J9 #J: $J; %J< &J= 'J> (J? )J@ *JA +JB ,JC -JD .JE /JF 0JG 1JH 2JI 3JJ 4JK 5JL 6JM 7JN 8JO 9JP :JQ ;JR <JS =JT >JU ?JVD@l@\A\B\CD\E\F\G\H\I\J\K\L\M\N\O\P\Q\R\S\T\U\V\W\X\Y\Z\[\\\]\^\_\ @JW AJX BJY CJZ DJ[ EJ\ FJ] GJ^ HJ_ IJ` JJa KJb LJc MJd NJe OJf PJg QJh RJi SJj TJk UJl VJm WJn XJo YJp ZJq [Jr \Js ]Jt ^Ju _JvD@l`\a\b\c\d\e\f\g\h\i\j\k\l\m\n\o\p\q\r\s\t\u\vw\x\yz\{|\}\~\\ `Jw aJx bJy cJz dJ{ eJ| fJ} gJ~ hJ iJ jJY kJ lJ mJ nJ oJ pJ qJ rJ sJ tJ uJ vJ wJ xJ yJ zJ {J |J }J ~J JD@l\\\\\\\\\\\\\\\\\\\\\\\\\\\\ J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J JD@l\\\\\\\\\\\\\\\\\\\\\\\\\\\ J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J JD@l\\\\\\\\\\\\\\\\\\\\\\\\\\\\ J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J JD@l\\\\\\\\\\\\\\\\\\\\\\\\\\ J J J J J J J J J J J J J J J J J J J J J J  J  J  J  J J J J J J JD@l\\\\\\\\ \ \ \ \\ J J J J J J J J J J J J J  J! J""PH00(  >@ 7 Sheet3ggD !jWW1ThisWorkbookXISheet1 Sheet2'  !"#$%&()*+,-./012345689:;<=>?@ACDEFGHIJKLMNPQRSTUVWXY[\]^_`abcdfghijklmnopqrstvwxyz{|}~dkGH"xMEP $@  140 "4HX` x  .'& &A 걨ܱ *%,%.$(b & '& A6:L6$0B@H 2B@4xA &$0B@H 6B@8 2B@: & &A 걨ܱ$,,.o7Attribute VB_Name = "ģ1" Sub InsertLine() \.rProcDataInvoke_Func \n14 "i 6 Do While IsEmpty(ActiveWor@kbook.sheets("걨ܱ").Cells(i, "A"))PFalseTXci + 1!Loop Range("A6:L6GSelection.Copy " & Xi). USN.0Past>"learContents'ggi - 5 End  HL#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2H/7#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et2" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2걨ܱ$,%. PAѧƷ$,#wHQ0!jWW2 7!jWW3B2!jWW4 O!jWW5ZxMExx Attribute VB_Name = "ģ2" \cHdxME He#xME (SLSS<N0{00020819-0000-0000-C000-000000000046} >@3i@ QHr@B @D P TiV ^F{i@  XxP%xPP; "  4(`hpx J     J8   ^  (20 hpx    ( 0    h px j    ( " 0 8 "@ HX]`x F'B'& &B 걨ܱ *%,%.$(bA'H'J'L'N P &C 걨ܱ$,%. PAѧƷ$,%.[ H'Hyk P P &D 걨ܱ$,%. PAѧ$,%.[ J'JyXkP P &J 걨ܱ$,%.Ը &I 걨ܱ$,%.'Lk &J 걨ܱ *%,%.$('Nk Hŵ &A 걨ܱ$,%.>¼ѧƷѡ󣬱ӡѧƷࡱѧѡ BЧԼ$R'D'@x Jeŵ &A 걨ܱ$,%.>¼ѧѡ󣬱ӡѧơѧѡ BЧԼ$R'D'@x( Leŵ &A 걨ܱ$,%.2¼ԸתΪѡԸ⡱򡰷񡱣 BЧԼ$R'D'@x Neŵ &A 걨ܱ$,%.¼ϵ绰 BЧԼ$R'D'@xd & '&koooAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046}|GlobalSpacFalse dCreatablPredeclaIdTruBExposeTemplateDerivBustomizD2 P Sub _BeforeCl9(Cancel As Boole@an) Dim style, respon{  cvbExjmation i 6o WhiIsEmpt`y(Act^A.sheets("걨ܱ").Cells(i, "B"))(v=@xkisinejUyyS phoneFor j1 To 1834E IfBR\/C"/9ѧƷT9j9A ThePDebug.ont 6?!<{Exit 2 End IfNext j ?271G c?DN?A@p?v ">? /c= SJb"Ԁ" OrB "IC" >TKNot jj)a? OhMsgBox("@ŵ" &$ "ab& "¼fѡ󣬱@ӡ%!!",ŗ"ЧԼќ"A= gDoNE/FO f%l`5 UԸΪ̀ѡ7򡰷|$ 2O////nn*ϵooo6o`T{0i + ^GLo0op  ᗄSave(@ByVal AsUI, .Open(;H b8" oph=Attribute VB_Name = "ģ3" Sub isnot() End X #wHvxMExx Attribute VB_Name = "ģ4" #wHǴxMExx Attribute VB_Name = "ģ5" Hc#xSheet3e_VBA_PROJECTovdiruPROJECTwmME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et3" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD20* pHd VBAProject4@j = r &UW J< rstdole>stdoleh%^*\G{00020430-C 0046}#2.0#0#C:\Windows\syst em32\e2.0020813-0000-0000-C000-000000000046}#1.7#0#C:\Program Files\Microsoft Office\Office14\EXCEL.EXE#Microsoft Excel 14.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE14\MSO.0DLL#M 1q Ob Li`braryKMSFor ms>SFrms$3D452EE1-E0D8F`A-8-02608C4D0BB4SFM20L'B &/;"1jIqAHq00}#0Bq# р0@C1C16A0C-2BCB-4DBF-9DF9-350AE5151H.Users\ADMINI~1\AppData\Local\Temp\Exce0l8.0\0.eq&)Lc>b\I~1\Appģ1!jWW1ThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2ģ2!jWW2ģ3!jWW3ģ4!jWW4ģ5!jWW5Sheet3Sheet3 ID="{120D4601-D80F-401B-9AFE-CBC63E5BB1B1}" Module=ģ1 DocumPROJECT/SummaryInformation(DocumentSummaryInformation8$CompObjhent=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Module=ģ2 Module=ģ3 Module=ģ4 Module=ģ5 Document=Sheet3/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="D7D53813D83DAB41AB41AB41AB41" DPB="AEAC414CCFF4A7F5A7F5A7" GC="85876AA1967997799786" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] ģ1=53, 277, 879, 843, ThisWorkbook=68, 169, 894, 735, Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C ģ2=-95, 228, 731, 794, ģ3=580, 235, 1406, 801, ģ4=125, 125, 924, 738, ģ5=100, 100, 1084, 614, C Sheet3=0, 0, 0, 0, C SKqќ/-Oh+'0HP`t lenovo ϵͳMicrosoft Excel@F>@8@NUēa *\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.7#0#C:\Program Files\Microsoft Office\Office14\EXCEL.EXE#Microsoft Excel 14.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.5#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE14\MSO.DLL#Microsoft Office 12.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{C1C16A0C-2BCB-4DBF-9DF9-452E50AE5151}#2.0#0#C:\Users\ADMINI~1\AppData\Local\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E.`M  &UWH !jWW10158d29a18 !jWW1"MThisWorkbook0258d29a18=ThisWorkbooke Sheet10358d29a18[ Sheet1L0% Sheet20458d29a18] Sheet2/7H%!jWW20558d29a18^!jWW2Q0`}!jWW30658d29a18`!jWW3dx!jWW40758d29a18d!jWW4v}!jWW50858d29a18f!jWW5Ǵ} Sheet30958d29a18i Sheet3c%Hx`0|r>E'$SKqќ/-`+uEF!j5]EAM1:mOͽ]b"OnSF/< 9#`(Ai$|HrWBE@)8Gbs-3( 41+Excel+`VBA`Win16~`Win32`Win64x`Mac`VBA6#`VBA7#` VBAProject`stdole``Officeu`MSFormsC`ģ1c` _Evaluate` InsertLine?`i``IsEmpty `ActiveWorkbook` Worksheets`Cells`Range ` SelectionZ`Copyƿ` ActiveSheet%N`Paste`ClearContents{` ThisWorkbook|`Workbook_BeforeClose`Cancel`stylep`response`vbExclamation`xkisin:`ejxkisin`yyisin ` phoneisino`ja`MsgBoxR`Workbook_BeforeSave l`SaveAsUI`Workbook_Open`Sheet1`Sheet2`ģ2c`ģ3c`isnot.`ģ4c`ģ5c`Sheet3`![]_aegi=  ՜.+,0HP X`hpx   걨ܱ ѧƷ ѧejxkxk  Χ FMicrosoft Excel 2003 Biff8Excel.Sheet.89q