邢唷> NM f2\p Administrator Ba== Nt18X@"1媅SO1媅SO1媅SO1媅SO1嗈媅SO1嗈媅SO1嗈媅SO1嗈媅SO1嗈媅SO1嗈媅SO1嗈媅SO1嗈媅SO1嗈媅SO1媅SO1 h6I{縹 Light1,6媅SO16媅SO16媅SO1媅SO1媅SO1媅SO14媅SO1 媅SO1媅SO1 媅SO14媅SO1 媅SO1<媅SO1?媅SO1>媅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\)3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "k3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_-q6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-{;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_->_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-yyyy\-m\-d\ hh:mm:ss0_                                     P P  €    a>     攆f   `                x@ @  X X x@ @ x@ @ X x@ @ x@ @ x@ @   X x@ @ X  x@ @ x@ @ x@ @  x@ @   x@ @  x@ @  X  X x@ @ x@ @  x@ @ x@ @  x@ @  x@ @  !x@ @ !X ||ZM<} " "_ef#,##}<} " "_ef#,##}<} " "_ef#,##}<} " "_ef#,##}<} " "_ef#,##}<} " "_ef #,##}<} " "_蘈#,##}<} " "_蘈#,##}<} " "_蘈#,##}<} " "_蘈#,##}<} " "_蘈#,##}<} " "_蘈 #,##}<} " "_23#,##}<} " "_23#,##}<} " "_23#,##}<} " "_23#,##}<}  " "_23#,##}<}! " "_23 #,##}-}# " "_}<}$ " "_#,##}<}% " "_?#,##}<}& " "_23#,##}(}' " "_}<}( " "_俏#,##}<}) a" "_骑#,##}P}* " "_#,##" "_}}- 鷠" "_蝌#,##" "_"-"? _-;_ }}. " "_ゥ#,##???" "_???"-"? ???_-;_ ???}(}/ " "_}(}0 " "_}<}1 鷠" "_€#,##}<}4 " "_#,##}<}5 " "_#,##}<}6 " "_#,##}<}7 " "_#,##}<}8 " "_#,##}<}9 " "_ #,##}<}: 淲" "_霚#,##}}; ???" "_蝌#,##???" "_???"-"? ???_-;_ ???}}< ??v" "_虣#,##" "_"-"? _-;_ }x}=" "_膊#,##膊" "_ 膊"-"? 膊_-;_}(}>汏" "_}(}F " "_}(}G " "_}(}L汏" "_}(}M " "_}(}N汏" "_}(}S汏" "_}(}U汏" "_}(}V " "_}(}W " "_!20% - :_寚eW[湗r 1J20% - :_寚eW[湗r 1 ef籴 !20% - :_寚eW[湗r 2J"20% - :_寚eW[湗r 2 ef !20% - :_寚eW[湗r 3J&20% - :_寚eW[湗r 3 ef眄 !20% - :_寚eW[湗r 4J*20% - :_寚eW[湗r 4 ef蛱 !20% - :_寚eW[湗r 5J.20% - :_寚eW[湗r 5 ef蓦 !20% - :_寚eW[湗r 6J220% - :_寚eW[湗r 6  ef怙 !40% - :_寚eW[湗r 1J40% - :_寚eW[湗r 1 蘈雌 !40% - :_寚eW[湗r 2J#40% - :_寚eW[湗r 2 蘈 !40% - :_寚eW[湗r 3J'40% - :_寚eW[湗r 3 蘈圹 !40% - :_寚eW[湗r 4J+40% - :_寚eW[湗r 4 蘈鏅 !40% - :_寚eW[湗r 5J/40% - :_寚eW[湗r 5 蘈阶 !40% - :_寚eW[湗r 6J340% - :_寚eW[湗r 6  蘈凄 !60% - :_寚eW[湗r 1J 60% - :_寚eW[湗r 1 23帺 !60% - :_寚eW[湗r 2J$60% - :_寚eW[湗r 2 23舭 !60% - :_寚eW[湗r 3J(60% - :_寚eW[湗r 3 23缮 !60% - :_寚eW[湗r 4J,60% - :_寚eW[湗r 4 23賔 ! 60% - :_寚eW[湗r 5J060% - :_寚eW[湗r 5 23浡 !!60% - :_寚eW[湗r 6J460% - :_寚eW[湗r 6  23┬ "€~vR詋 #h槝+h槝 DTj% $h槝 18h槝 1 DTjDr %h槝 28h槝 2 DTj?⒏ &h槝 38h槝 3 DTj23帺 'h槝 4*h槝 4 DTj(頬0頬 俏 €8^膲)}Y0}Y 骑 a *Gl;`BGl;` DrDr+€'^,€ '^[0] -梴j梴 蝌 鷠 .纇錱USCQ:_寚eW[湗r 1 Dr 5:_寚eW[湗r 2>!:_寚eW[湗r 2 韢1 6:_寚eW[湗r 3>%:_寚eW[湗r 3 ゥ 7:_寚eW[湗r 4>):_寚eW[湗r 4  8:_寚eW[湗r 5>-:_寚eW[湗r 5 [浾 9:_寚eW[湗r 6>1:_寚eW[湗r 6  p璆  :-N2-N 霚 淲 ;搹鶴j搹鶴 蝌 ???????????? ??? <搹eQj搹eQ 虣 ??v  =鑜蕬^ 鑜蕬 膊膊膊 膊XTableStyleMedium2PivotStyleLight16`,H Select select)v SQL StatementVV  ;4A 01W(g錧 zf[b0101W(g錧 z4020103豏錱€b/gN錧 z0104塠hQ錧 z0105Km貇錧 z01070W(嶅] z0108 S愶峞h乭N!n砽錧 z0109愬] z0112蜽^0W Nzz魰錧 z鷁Q{N膲Rf[b0201鷁Q{f[50207蜽aN膲R0208螛of鞻梘03 痵僗N齹恘錧 zf[b0303痵僗錧 z0308 鷁Q{痵僗N齹恘擽(u錧 z0309賬抍4l褃f[N錧 z0310齹恘N≧汻錧 z03110Wt酧o`褃f[0313痵僗u`錧 z04蟸NmNtf[b0402錧 zt0403"崱Rt0405Of[0408蟸Nmf[0414?b0W_裇Nt0415錧 z 愾N0416褢崌錧 z0417D崸N膵0O05 5uP[N酧o`錧 zf[b05015uP[酧o`錧 z05020504愥O錧 z0505Q軂錧 z0506鷁Q{5ulNzf齹S0520irT€Q錧 z06 Pg檈NSf[錧 zf[b0601 鄀:g^椦慯\Pg檈錧 z0602貧RP[Pg檈N錧 z0603擽(uSf[0604Sf[錧 zN錧z0612褢^\Pg檈錧 z07petf[b0703擽(uirtf[0704邁f[0705餢f[08Y齎韹f[b0801駛韹10 :g癶N5ul錧 zf[b1001 :g癶緥6R 愂SvQ陙≧S1002 5ul錧 z蔛vQ陙≧S1003陙≧S1004Km€b/gN闚hV1005錧N緥1006 菑 z艌YN6R錧 z1007:g癶5uP[錧 z11lQqQtf[b1101誰f[1102篘汻D崘nt1103砇≧N>yO軴湒1104W0WD崘nt1105蜽^tEselect jgdm,jgmc,zyh,zymc,xz,xqh_id,count(*) as zyrs from( select b.jgdm,b.jgmc,c.zyh,c.zymc,d.bj,d.xqh_id,a.* from jw_xjgl_xsjbxxb a,zftal_xtgl_jgdmb b,zftal_xtgl_zydmb c,zftal_xtgl_bjdmb d where substr(trim(a.xh),1,2)='18' and length(trim(a.xh_id))=11 and a.xh not in (select xh from wbd2018) and a.xh not in('18201040229','18202070220','18205010226','18211030141','18201050143','18204150126','18205060241') and a.zyh_id not in('0422','0424','0906') and a.jg_id=b.jg_id and a.zyh_id=c.zyh_id and a.bh_id=d.bh_id ) group by jgdm,jgmc,zyh,zymc,xz,xqh_id order by jgdm,zyh!h:S 7f[6R 7NN T饄 7f[b T饄 7廭鱏 7T 7S!h:SWS!h:S韘pe 7NN(W!h f[upe 7f[b栥Nx 7NN鉔x 7 2020TNN遙硚l廵Qf[u篘pe臽礠N葔h   7梴:g褃f[N€b/g 7遙l徍NpeD桍N4 71 N1S11A2F22E3J33I4N44A5F558f9kcc PK!檗[Content_Types].xml瑧薔0E鱄鼉-J湶@%閭菐洽|廊$韶钵UL襎B l,3鳛;鉹得槣B+$G]ミ7O侪V墎苈嚌f胱_勐譑韃P肤kPDIr紖.叺jw第2et o喠燸蓴疩 yt),懟b-F@)$皲r帶h 淋Eq怸$4h#銄:4[CjFO9櫵k巂{緓鲮_?鵊=┹捽G商旣缁晓囖~鏌峡Hм 驀廮銮胒2h}薩~z裾笴{洠#>"1|贻g1,P[擎儚$F"夽稢u_F鹞Q畠m>鋹G\罌婫譨8f饜1赼躨€踛.寐2sO&>B'(躝!検n-汍(J$氠KO絚;V>!朷蓸3力襸焫D&#+愔B$,]琳杕zF] QoD盞旁4拺嬩p汕&/$xz)篾,凨.圂N 9捻鯟簩m$椾廿1f"{旄盥I欂w1(蝾1閭2{嚚gJv蝴!翓籣@4)D結p/obf棚pI徊L浨Vvms鈱幬bf咑潰 妻僿 :ln質M鶹Ye瞔U='X`Ow.)騹+d噚苬9\n$%Jb膚i^7m迖:鍸轼!戌A8峳W€#竪j!玽ゞ釒%伏w=慐 d鸸e 睕2Qk倁缹畉 "桘"j眳Snjo诘狌:殬$痬o亦奎破暴.Дq+稈覌53粧掐F ?馗粜"箛lgカ惧猳稃朷{[僬S\u+>tW軯v:r9菔篈佫E'5&辻l3%鍜n|矻0ㄤ羯%螐矜黅e&皃3幋屒檤徣h9滫攠&23嵬檧覨=煸t睮zZY.珦纱 $足0嚀&櫌k貂 \甞碀閾%{芼6壀僁}5▽はe羑ze椔㈤`裀闣b詒G熲-? @勦 饓騍觋晈3/佑粚iE@ N瞥X{憨割\瀂]jg鸫E7泟秾n餌熀Yt承8沰梈魯)2[4陯W备ǒAn37心4馧[~B葘鸭錙嵩~苨【澚 蔢騮胈$程箰=$⒃:椁 &s彃稿鏽爥!歔 釐%讋打йN朴)K禹茍瞭>畏Z`%囝a49鯉鑲逩ba浆 8!施5'n瞅D稁繊聰:I荘:庤^菝\掣若{Q譿疱Jv餥芿麳]雏侅驛2hV洕Zm A(4坏N胫{僞7l4O|顳儍v扎岯俍I,詢J咱崀衺掯3`4廳F;k7PK! 褠煻'theme/theme/_rels/themeManager.xml.rels剰M 0匃倃oo雍&輬协勪5 6?$Q祉 ,.嘺緳i粭澤c21h:闀q毩m胳嶡RN壻;d癭値o7g慘(M&$R(.1榬'J摐袏T鶂8V"＆A然蠬鱱}狇|$絙{朠除8塯/]As賲(⑵锑#洩L蔥汉倪PK-!檗[Content_Types].xmlPK-!ブх6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!鸍zq theme/theme/theme1.xmlPK-! 褠煻' theme/theme/_rels/themeManager.xml.relsPK]  f2 9覸Sg誸  d褚MbP?_*+€%3%&C&9,{ &P u qQ &N u槂& 匓(?' 匓(?(惽泷x L LL f@L@E7@ ~ L@ SU L > L LLM@L@E@@ ~ L@ SU L > L LLV@L@E(@ ~ L@ SU L > L LLN@L@E>@ ~ L@ SU L > L LLE@L?E @ ~ L@ SU L > L L L@V@L@E&@ ~ L@ SU L > L L LN@L@E>@ ~ L @ SU L > L L LV@L@E(@ ~ D"@ V W M F M M MN@M@X$@ ~ D$@ VW M F M M M@P@M@X@ ~ D&@ VW M F M MMQ@M@X@ ~ L(@ S U L > L LLM@L@E@@ ~ L*@ SU L >! L LL繳@L@E*@ ~ L,@ SU L" ># L LL€V@L@E$@ ~ L.@ SU L$ >% L LL€V@L@E$@ ~ L0@ SU L& >' L LLN@L@E>@ ~ L1@ SU L( >) L LL€E@L?E@ ~ D2@ R* T+ D, E- D DD@V@D@E&@ ~ D3@ RT D. E/ D DD@V@D@E&@ ~ D4@ RT D0 E1 D DD€V@D@E$@ ~ D5@ RT D2 E3 D DD€M@D@E?@ ~ D6@ RT D4 E5 D DDM@D@E@@ ~ D7@ RT D6 E7 D DDV@D@E(@ ~ D8@ RT D8 E9 D DD繴@D@E"@ ~ D9@ RT D: E; D DDN@D@E>@ ~ L:@ S< U= L> >? L LL@V@L@E&@ ~ L;@ SU L@ N L LL@V@L@EG@ ~ L<@ SU LA >B L LL繴@L@E"@ Dl(~ppppppp~pp~ppppp~ppppppp~p V@! V@" V@# V@$ V@% V@& V@' V@( V@) V@* V@+ V@, V@- V@. V@/ V@0 V@1 V@2 V@3 V@4 V@5 V@6 V@7 V@8 XI~ L=@ SU LC >D L L L€V@L@E$@ ~ !L>@ !SU !LE !>F !L !L!LV@L@E(@ ~ "L?@ "SU "LG ">H "L "L"L@V@L@E&@ ~ #D@@ #RI #TJ #DK #EL #D #D#DV@D@E(@ ~ $D€@@ $RT $DM $EN $D $D$D繴@D@E"@ ~ %DA@ %RT %DO %EP %D %D%D€M@D@E?@ ~ &D€A@ &RT &DQ &ER &D &D&D€N@D@E=@ ~ 'DB@ 'RT 'DS 'ET 'D 'D'D€N@D@E=@ ~ (L€B@ (SU (UV (LW (>X (L (L(LF@L?E@ ~ )LC@ )SU )LY )>Z )L )L)L€V@L@E$@ ~ *L€C@ *SU *L[ *>\ *L *L*LF@L?E@ ~ +DD@ +D] +H^ +D_ +E` +D +D+DV@D@E€G@ ~ ,L€D@ ,Sa ,Ub ,Lc ,>d ,L ,L,L@V@L@E&@ ~ -LE@ -SU -Le ->f -L -L-L繳@L@E*@ ~ .L€E@ .SU .Lg .>h .L .L.L€V@L@E$@ ~ /LF@ /SU /Li />j /L /L/LV@L@E(@ ~ 0L€F@ 0SU 0Lk 0>l 0L 0L0LF@L?E@ ~ 1LG@ 1SU 1Lm 1>n 1L 1L1LF@L?E@ ~ 2L€G@ 2SU 2Lo 2>p 2L 2L2LF@L?E@ ~ 3DH@ 3Rq 3Tr 3Ds 3Et 3D 3D3D繱@D@E5@ ~ 4D€H@ 4RT 4Du 4Ev 4D 4D4D€U@D@E,@ ~ 5DI@ 5RT 5Dw 5Ex 5D 5D5DJ@D@EC@ ~ 6D€I@ 6RT 6Dy 6Ez 6D 6D6DL@D@EA@ ~ 7DJ@ 7RT 7D{ 7E| 7D 7D7DM@D@E@@ 8O8OOOOOO#8A\瓳 %7#8A@Y@8 %7~ 8 K@孈6: ppp~pppp~pp~~pppppp~pppp>@s@@m    "" 88#'(*,23737,2(*#'7ggD f2 ?w檞  d褚MbP?_*+€%&?'?(?)?"&U} P} m  }">@  m 7ggD 鄥燆鵒h珣+'迟0HP`x IdeallAdministratorMicrosoft Excel@€踷硤@c贳u;@~*v胀諟.摋+,0 PXd lt|  Select selectSQL Statement'Select select'!Print_Titles 工作表 命名范围  !"#$%&'()*+,-./0123456789:;<>?@ABCDFGHIJKLRoot Entry F燸/WorkbookxSummaryInformation(=DocumentSummaryInformation8E