ࡱ; -cfghij T8\p Administrator Ba= ThisWorkbook=Df8X@"1[SO1[SO1[SO1[SO1[SO1[SO1[SO1Arial1[SO1h>[SO1,>[SO1>[SO1[SO1[SO1[SO1[SO1[SO1 [SO1[SO1[SO1 [SO1[SO1[SO1 [SO1[SO1[SO1[SO1 [SO1[SO1[SO1@Arial1@Arial1@Arial1@Arial1@Arial1@Arial1@Arial1@Arial1 [SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1Arial1[SO1[SO1[SO1[SO1 [SO1[SO1 [SO1>[SO1[SO1[SO1 [SO1[SO1[SO14[SO1 [SO1[SO1 [SO14[SO1<[SO1?[SO1>[SO1[SO1[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\)""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)0_);[Red]\(0\)0.00_);[Red]\(0.00\)0_  0.0_ yyyy/m/d\ h:mm:ssyyyy\/m\/d\ h:mm:ss                8 8 8 8 8 8 8 8 8 8 8 8 9 9 9 9 9 9      P :P      ; %  &  8 8 8    !  "  #  $  <  = > ?a   @  Aff B C D`   E F G  H 9 9 9 9 9 9    ""@ @ 1""@ @ 1|@ @ 7 1 1d@ @  1 1 1 1t@  1 1 1|@  1 1|@  1 1<@ @  1 1d@  1   1|@ @ 7 1t 1<@ @ 81 *1<@ @ ,1<@ @ .1<@ @ 1 .1<@ @ 51 0@ @ 2!@ @ 2@ @ 31<@ @ 1 41|@ @ 7 1@ @ 1\ 61|7 1D 1T 1T @ @ 1@ @  @ @ 1@ @ +@ @ +1@ @ @ @ 1@ @ )1@ @ /@ @ ""@ @ J1<@ @ K87 L8 M87 N8 O87 P8 ||k}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}A} 00_)ef[$ -}A} 00_)ef [$ -}-} 00_)}A} 00_)L[$ -}-} 00_)}-} 00_)}A} 00_)L[$ -}-} 00_)}-} 00_)}A} 00_)23[$ -}-} 00_)}-} 00_)}A}  00_)23[$ -}-}! 00_)}-}%?_)}A}( ?_)[$ -}-}- ?_)}-}. ?_)}-}/ ?_)}-}; ?_)}(}=  ?_)}A}> a?_)[$ -}-}? ?_)}}}B }?_)[$ -##0.  }}C ?_)[$ -???##0.??? ??? ???}-}D ?_)}-}E ?_)}A}F }?_)[$ -}A}I e?_)[$ -}}}J ????_)???[$ -???##0. ??? ???}}K ??v?_)̙[$ -##0.  }(}L  ?_)}-}M ?_)}A}N ?_)[$ -}A}O ?_)[$ -}-}P ?_)}A}Q ?_)[$ -}A}R ?_) [$ -}x}S?_) [$##  }-}X ?_)}-}Y ?_)}-}Z ?_)}-}\ ?_)}-}] ?_)}-}` ?_)}-}d ?_)}-}e ?_)}-}f ?_)}-}g ?_)}-}i ?_)}-}k ?_)}-}o ?_)}-}v ?_)}-}{ ?_)}-}| ?_)}-}} ?_)}-} ?_) 20% - @wr 1; 20% - @wr 1 % 20% - @wr 2;" 20% - @wr 2 % 20% - @wr 3;& 20% - @wr 3 % 20% - @wr 4;* 20% - @wr 4 % 20% - @wr 5G. 20% - @wr 5 ef % 20% - @wr 6G2 20% - @wr 6  ef % 40% - @wr 1; 40% - @wr 1 % 40% - @wr 2G# 40% - @wr 2 L渷 % 40% - @wr 3;' 40% - @wr 3 % 40% - @wr 4;+ 40% - @wr 4 % 40% - @wr 5G/ 40% - @wr 5 L % 40% - @wr 6;3 40% - @wr 6 % 60% - @wr 1; 60% - @wr 1 % 60% - @wr 2G$ 60% - @wr 2 23ږ % 60% - @wr 3;( 60% - @wr 3 % 60% - @wr 4;, 60% - @wr 4 % 60% - @wr 5G0 60% - @wr 5 23 %! 60% - @wr 6;4 60% - @wr 6 %"~vRk #hh $h 1h 1 %h 21h 2%? &h 3h 3 'h 4h 4(]5]  %+8^ĉ %)8^ĉ 10*8^ĉ 10 2+8^ĉ 11,8^ĉ 11 2-8^ĉ 1218^ĉ 12 % .8^ĉ 2/8^ĉ 2 %/8^ĉ 2 238^ĉ 2 2 % 08^ĉ 3 18^ĉ 428^ĉ 4 2 38^ĉ 548^ĉ 5 2 58^ĉ 668^ĉ 6 2 78^ĉ 788^ĉ 7 2 98^ĉ 8:8^ĉ 8 2 ;8^ĉ 9/8^ĉ 9 %< 8^ĉ_hQVL?e:SRNx=(c  >}Y5}Y  a% ?Gl;`+Gl;` %@'^A '^[0] B{c{ }% ChgUSCQT\e 707 7]_e 7le08 7Xe 709 7^Oe 7ge 711 7ne 712 7Oe 713 7vte 714 7}ve 715 7W[e 716 7T<\e 717 7T(KQe 718 7Pe 719 7Ξe 720 7PPe 721 7dOe 722 7rue 723 7ؚq\e 724 7b\ye 725 74le 726 7NaNe 727 7~e 728 7ofe 729 7g\KQ\[e 730 7We 731 7e\e 732 7NlOe 733 7e 734 7^ge 735 7dbe 736 737 7NlOe 738 7!/Oe 739 7? fe 740 7nfs|e 741 7TX TKQe 742 7`e 743 7LN\[+RKQe 744 7OWee 745 7)nKQe 746 7_fe 747 7O[e 748 7ՈVe 749 7Ne 750 7TXTX\e 751 7re 752 7&O%fe 753 7kTe 754 7]e 755 7s]e 756 7We 781 7zRNe 797 798 7 YV@~-NVM|NX 7checkXL 7checkXZuS 7/f&TQQgf[u 7sfzjh 7 csrq 7 xslx 7 xxxs 7 nj 7 bj 7 zy 7 gdxl 7xy 7xh 7 ksh 7 checkKSH 7 checkXSLX 7 checkXXXS 7 checkYesNo 7 41 7 42 7f[u{|W 7f[u{|W 7 01 7 checkXSLX 7 checkXSLX 7 checkXXXS 7 checkXXXS 702 7hQe6R 7^hQe6R 7f[`Nb__ 7checkMZ 70 71 7&T 7/f 7 41 7 42 7 checkZZMM 7 checkZZMM 7 checkZZMM 7 10 7 11 7 12 7 13 7]N Nf[>y>yXT 7eZQ>ml;NNX 7O 7?elb{|W 7?elb{|W 7?elb{|W 7 checkNJ 7checkNJ 7checkNJ 72 73 74 75 76 77 78 79 7t^~ 7xm 7xxxsmsfncxsNN'Y{| 7 checkZYDL 7 checkZYDL 701 7Tf[ 7NN'Y{| 702~Nmf[ 703lf[ 704Yef[ 705ef[ 706SSf[ 707tf[ 708]f[ 7Qf[ 7NN'Y{| 7 checkZYDL 710 7;Sf[ 711QNf[ 712{tf[ 713z/gf[ 709 7 checkZYDL 7 zydl 7f[S 7'`+R 7Queg 7?elb 7f[u{|W 7f[`Nb__ 7t^~ 7NN 7;ef[S 7b| Ty 7checkXH 7s~ 7f[6R 7 checkCName 7 checkSfzjh StudentEntry 706 7ׂe 7checkNJ 7 gdxlm 7 mz 7 zzmm 7 xslxm 72.5 7^gkN 7xz 7checkXZ 7checkXZ 7checkXZ 75 7f[6R 7 ؚ!h,gNyf[uOo`U_eQ 71 7!  hQe6R T ^hQe6R 9hncf[u`QkXQNy OY hQe6R _kXy 71 kXQf[u@b(Wt^~ OY 1 , 2 , 3  ^gkN SNxh-N@b gvt^~{|W0_kXy. 7- kXQf[u@b(Wb|v Ty Y ^(uetf[b 0 {:g| 0FO N_Ǐ100*NW[&{ _kXy$&* 7( _{:NIlW[SNS+T ^'YNI{N1 N NǏ16*NIlW[ OY _ N _kXy% 7* kXQf[uvuS ^ N_Ǐ40*NW[&{ OY 16314915541426 _kXy' 7$ kXQf[uvf[S ^ N_Ǐ40*NW[&{ OY 122054114 _kXy! 7= kXQf[uvle SNkXQ Ile  Ve T ~>T\e I{levNy0SNxh-N@b gvle{|W0OY Ile 0_kXy09< 73SkX 7u b sY _kXy0OY sY YgNNS:NcknxvE\lNS ^_kXy |~OꁨRub 7xb 7eQf[eg 7 rxrq 7;kXQf[uvQueg X)YoZZZ:[*]-`b!c"d#Uf%,gr&Fh'jb)Xl+ccB~-z4nA_)k:~yw T8   dMbP?_*+%&ffffff?'ffffff?(?)?M.Microsoft Print to PDFP/ 4dXXA4GIS4DINU"$,?]{~SMTJ{084F01FA-E634-4D77-83EE-074817C03581}RESDLLUniresDLLPaperSizeA4OrientationPORTRAITResolutionResOption1ColorModeColor,V4DM p"O4wMH5L*@VDocumentUserPasswordDocumentOwnerPasswordDocumentCryptSecurity" d333333?333333?&<3cAU} {} |} }} |} |} |} @|} M{} N}{} ~{} {~eb6fee|eXi&W e Z Z q; k vL v7 Y Z Y Y ZS Z Z Z oV Z Z o5 Yb @,[[^^[[[[[[[[[[[[[[[ X\ a (__\\\\\\\\\\\\\\\,ZZ]]ZZZZZZZZZZZZZZZ e Z Z ] ] Z Z Z Z  Y  Y  Z  Z  Z Z Z Z Z Z Y Y Y Z` `Z Y YY  Y  Y  Y  Y  YY Y Y Z ZY ke8 me oe pe qe rg vg xe {e V h hQ wM zR h h h h  h  h  h  h  h h h h h h V j c c uK xO c c cP c  m  l   l  l  cU n4 cW m cX p6 Z yy@BH0xT<(  ~  <PIICC@],@]9 $< _Yhg<~~ i <IICC@tA],5@Y9 $<_ Y h g< >@d7 Sheet1ggDh4hM:SW2 T8 $:v  dMbP?_*+%&ffffff?'ffffff?(?)?MS OneNote 2013/ 4dXXA4DINU"SMTJSend to Microsoft OneNote 15 DriverRESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITResolutionDPI600ColorMode24bpp" dXX333333?333333?&<3U} @~} } ~} !~} }  }  }  @ @       !"%&'(  U T   [ ~  ~ ~ ^ ~  ~ ~ ~  ~ ~ ~ ? ~ 0  (   )  - *  . +  / ,            ~ 2 1                   !    "    #    $      ~  % ~ !~ ! ! !~ " " " " %~ % %& %~ &~ & &' &~'(@lFF88<8888888888888888888888 )*+,-./023456789:;<=>?@ABCDEFGHI) *~ **~@ *~  +~ ++~@ +~  ,~ ,,~@ ,~  -~ --~@ -~ .~ .Y.~@ .~ /~ / /~@ /~ 0~ 00~@ 0~  2~ 2 2~ 2~ 3~ 3 3~ 3~ 4~ 4 4~ 4~ 5~ 5 5~ 5~ 6~ 6 6~ 6~ 7~ 7 7~ 7~ 8~ 8 8~ 8~! 9~ 9" 9~# 9~ :~ :$ :~% :~ ;~;$@ ;~& ;~ <~ <' <~( <~ =~ =) =~* =~ >~ >+ >~, >~ ?~ ?- ?~. ?~ @~ @/ @~0 @~ A~ A1 A~2 A~ B~ B3 B~4 B~ C~ C5 C~6 C~ D~ D7 D~8 D~ E~ E9 E~: E~ F~ F; F~< F~ G~ G= G~> G~ H~ H? H~@ H~ I~ IA I~B I~Dr l <<<<<<<888888888<8888888888888JKLMNOPQRSTUVWXYZ[\]^_`abcdefghi J~ JC J~D J~ K~ KE K~F K~ L~ LG L~H L~ M~ MI M~J M~ N~ NK N~L N~ O~ OM O~N O~ P~ PO P~P P~ Q~ QQ Q~R Q~ R~ RS R~T R~ S~ SU S~V S~ T~ TW T~X T~ U~ UY U~T U~ V~ VZ V~[ V~ W~ W\ W~] W~ X~ X^ X~_ X~ Y~ Y` Y~a Y~ Z~ Zb Z~c Z~ [~ [d [~e [~ \~ \f \~g \~ ]~ ]h ]~i ]~ ^~ ^j ^~k ^~ _~ _l _~m _~ `~ `n `~o `~ a~ ap a~q a~ b~ br b~s b~ c~ ct c~u c~ d~ dv d~w d~ e~ ex e~y e~ f~ fz f~{ f~ g~ g| g~} g~ h~ h~ h~ h~ i~ i i~ i~D l8888888888888888888888888888888jklqrstuvwxz{|}~,,,,,,,, j~ j j~ j~ k~ k k~ k~ l~ l l~ l~ q~ q q  q r r r r s s s s t t t t u u u u v v v v w w w wx z~ z z~ z~ {~ { {~ {~ |~ | |~ |~ }~ } }~ }~ ~~ ~ ~~ ~~ ~  ~ ~ ~  ~ ~ ~  ~ ~ ~  ~ ~ ~  ~ ~ ~  ~ ~ ~  ~ ~ ~  ~ ~ ~:? rN s< ~9@ r= s< ~9@ t> s< ~9@ t? s< ~9@ t@ s< ~9@ tA s< ~9@ tB s< ~9 @ tC s<Dr l8888888888 8888888888888<<<<<<<,,,, :"@ tD s< ~9 E tF s< ~9 G tH s< ~9 J tI s< 4<<88PH  0(   >@d 7 Sheet5ggD T8 L #+3;CKS1  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U     ddddddddd d d d d dddddddddddddddddddDl  !"#$%&'()*+,-./0123456789:;<=>? d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?dDl @ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_dDl `abcdefghijklmnopqrstuvwxyz{|}~`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~ddDl ddddddddddddddddddddddddddddddddDl ddddddddddddddddddddddddddddddddDl ddddddddddddddddddddddddddddddddDl ddddddddddddddddddddddddddddddddDl      ddddddddd d d d d dddddddddddddddddddDl  !"#$%&'()*+,-./0123456789:;<=>? d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?dDl @ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_dDl `abcdefghijklmnopqrstuvwxyz{|}~`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~ddDl ddddddddddddddddddddddddddddddddDl ddddddddddddddddddddddddddddddddDl dddddP PH00(  >@   7 Sheet6ggD ch  .   ''"System%fY)h- . --'  ,'  '  '  '  -  @ !)- 2 )- 2 ѧ2 eѧ2  ֤ 2 Ա2 g-- - ,--'-- )----+2 PдѧĿţȲ (2 `ó40ַ硰  2 p16314915541426 - 2 pr -- - - ,--'-- J)----+2 PдѧѧţȲ %2 `40ַ硰  2 p 122054114 - 2 p -- - - ,--'-- )K----%2 HMΪ֣԰ *2 XMȴڵ1  +2 hM16֣硰  2 xM - 2 xg -- - - ,--'-- )----.2 Pдѧ֤֤ţ (2 `ȱΪ18λ硰  %2 p140602199907061024 - 2 p} -- -,--'-- L)+2 @ֻСŮ +2 P硰Ů +2 `֤Ϊȷľ +2 p֤ţDZϵͳ 2  ---,--'-- )M+2 @Oдѧijڣʽ *2 PO硰2002-01-12,   +2 `O֤Ϊȷ (2 pOľ֤ţDZ "2 OϵͳԶ --,--'--  --'--  --- @ !-- @ !-JJ- @ !J-- @ !-- @ !-LL- @ !L-- @ !-  - - @ !i- - @ !i-J J- @ !iJ- - @ !i- - @ !i-L L- @ !iL- - @ !i- -- @ !-((- @ !(-- @ !-  -- @ !-- @ !-- @ !-  - @ ! --'-   Microsoft YaHei UI- -,- . -- ---- . -'- 'NANIrU@@@@~x ^dh"jAkHi ggg2ldg|gggg`D vgg"Kg"Kbgzgggg ggg2lggggg xD ggg2ldg|gggg`D HiHiHi@HiHi`HiHiHi0HiHiPHiHi Hi( Hi HiX Hi Hi Hi Hi Hi(HiHiHHi Hi ggg2ldg|gggg`D HipHiPgg"Kg"Kbgzgggg ggg"Kg@g2l(g@gggg xPD  a&o "a $h "a  "a   "a  "a "a $h  "a  "a  "a  "a  "a $h  $h !$h $$h %$h ($h )$h ,"a -"a 0"a 1"a 4"a 5&o 8&o 9"a <"a ="a @$hX0//Z&xRRME(@P06 <8,,Ph>0hRVHZ8@ʀh @8 @vh @^x @%Ϣ%ꀌX  @  @ꀈ @fBh@jH @Nx@n@ʘBp !@r8B#vhB%ʘzB')@~B+ꘂ(B-ꘆX3B/ꘊB1꘎B3ꘒB5ꘖB7ꘚH5B9ꘞxgB;꘢B=꘦B?ꘪBA꘮8ABC꘲h BE꘶BG꘺BI꘾BK(BMXBOXBQZBSjBUBWH$BYxB[B]B_*Ba8&Bch6Be8BgDBi Bk(*BmXBo BqBs+Bu}BwH) Byx+ B{"/ B}&2B* g B.8 B2h B6  B: )B> BB(!E BFX!G BJ!V BN!HR! BV"* BZH", B^x"7 Bb"!Bf" Bj#E Bn8#G Brh#I Bv# Bz#e B~# Bꘂ($ BꘆX$ Bꘊ$=B꘎$Bꘒ$Bꘖ%BꘚH%"Bꘞx%B꘢%B꘦%rBꘪ&tB꘮8&B꘲h&"B꘶& B꘺&B꘾&B,H˵6A%TBLHpHXxHʘBʀ @ʀP @\8ph @ꀆ( @` @  @b  @d BPB|@ʀl @@ꀎ @0@B 4phB"tB$ʘxB&ʘ|B(0*@ꘀ`B,ꘄB.ꘈB0ꘌB2ꘐ .B4ꘔPB6ꘘ]B8ꘜ_B:꘠hB<꘤?B>꘨@B@꘬pBB꘰BD꘴!BF꘸6BH꘼0BJ`BLBNBP4BR iBTPBVBX%BZ#B\ B^@ #B`p %Bb 'Bd Bf CBh0 Bj` Bl +Bn Bp  Br gBtP iBv ~Bx ,Bz  . B|$ X B~(@ Z B,p h B0 -B4  B8 B<0 B@` BD >BH U BL  BP  BTP BX@B\6 B` Bd Bh@ Blp$BpH BtY Bx[ B|0f Bꘀ`Bꘄ BꘈxBꘌzBꘐ BꘔP Bꘘ!BꘜB꘠B꘤B꘨@%B꘬pB꘰B꘴ B꘸ B꘼0B`B 0 ( H 8 !HX!!@ h (@8@ 8 #`  0 Xh H  ` % 8h&` & h#P $%H% p $0 H"x%$hh p 8#px&p@x0X"Hx0 &Pp P xp 8 (!#XX$&H @!P`8(#%@8&P`"x"#0h(Xx `($ P  " Nh 23A200000000@`,7('n [*\R1*#278$*\Rffff*0=5b1e8699(*\Rffff*0=5b1e8699\0    08  @ ` Dp 8 0 P0pD084P. ..*8(h>"$$ &Hp>R^(F `*`$   0$P x ^^ ,x   "( P  p   "     8  X "x     " H  h   "     0  P "p     " @  `   "  ""0"X$    "( P p  "   8 X"x    "  H h  "   0 P"p    " @ `  "   ( H"h    " 8 X x "    @$`    " 0 P p "    8"X    " ( H h "    0"P x   "  "@"h"$    @"`   " 0P p " ,(:0 x^^0p@һṹҳ]$H=Public Const sheetNameValueTJ As String = "2ʵͳ"]$Ϣ2Public Const IntroSheetName As String = "˵"]$H]$˵] x ¼ܵУ]$8¼ͷ] "ִ һǿУ ĵԪĿ] h6ִ һǿУ ĵԪΪϹĿ] ÿһкϼеֵ] "һǿУʱ¼Ԫ] Ϣ] %---ģУ¼ĸԪ] 8---ģУ¼ĵԪ]  Уʱ洢ַ] (¼ʱرհť]  ¼ܵУǷвϹ] X ¼ܵУ Ƿظ] #¼ܵУǷظ] %/¼ЧǰǷдϢ ״̬] #У鷽ķֵ]$)¼ʼк]$ )ѧѧſʼλ]$)ѧ֤ſʼλ]DP¼ΪյĿ]"/ǷΪЧ ͳ 5ֶΪյĸ] "C¼ȥոִнȥ˿ո򷵻true򷵻false] HPcellԭʼĵݣϵͳûнԶûĴ֮ǰcell] 7ϴдϢʱڵ,ӦĿʼʱʼֵһ] x] ] RڸݱʶòͬķʱжǷforѭ Cell_SelectionChangeҪõñ]$¼ʡصȼ¼ڵ]$+sheet±Ƿ] @]$h)е]$p) Ա]$8& ѧ]$+]$h,϶]$#϶ʱ]$%϶ԭ] -Oʶ϶ǷͨУ 0-δͨУ 1-ͨУֵΪ 2-ͨУֵΪ] $Oʶ϶ʱǷͨУ 0-δͨУ 1-ͨУֵΪ 2-ͨУֵΪ&ʡµصʼԼ]$0. Ĵʼ]$, Ĵн]$`-Ĵʼ]$(-Ĵؽ]$3)Ĵcode]$X- ʼ]$+ н]$,ʼ]$,ؽ]$.(code]$ - ʼ]$+ н]$P,ʼ]$],ؽ]$5(code]$_H. ຣʼ]$g, ຣн]$hx-ຣʼ]$-ຣؽ]$?)ຣcode]$/ ½ʼ]$- ½н]$@.½ʼ]$.½ؽ]$Ap*½code]$8- ʼ]$ + н]$!h,ʼ]$,ؽ]$6(code]$, ʼ]$* н]$0+ʼ]$+ؽ]$`'code]$(. ʼ]$- н]$X.ʼ]$X.ؽ]$4)code]$Z4ʼ]$i2 н]$j 3ʼ]$3ؽ]$P.code]$. ʼ]$$, н]$%H-ʼ]$-ؽ]$#x(code]$- ʼ]$+ н]$ ,ʼ]$#,ؽ]$*@ 'code]$%/ ʼ]$&p - н]$'8.ʼ]$6 .ؽ]$ h)code]$8 - ӱʼ]$C+ ӱн]$D ,ӱʼ]$,ӱؽ]$ 0 'ӱcode]$0 ʼ]$*` . н]$+(/ʼ]$ /ؽ]$X*code]$ - ʼ]$+ н]$ ,ʼ]$g,ؽ]$+ 'code]$i1 㶫ʼ]$}P / 㶫н]$~0㶫ʼ]$)  0㶫ؽ]$,H+㶫code]$+  1 ʼ]$. x/ н]$/  0ʼ]$X 0ؽ]$2 +code]$Z / ʼ]$g @ - н]$h  .ʼ]$ p .ؽ]$-8 )code]$  - ʼ]$ h + н]$  ,ʼ]$  ,ؽ]$) 'code]$  - ʼ]$ 0 + н]$  ,ʼ]$E ` ,ؽ]$>(!'code]$G  0 ʼ]$U X!. н]$V  /ʼ]$ !/ؽ]$6A +code]$ !/ ʼ]$  - н]$ !.ʼ]$* P.ؽ]$@"*code]$, 0 㽭ʼ]$6 H". 㽭н]$7 /㽭ʼ]$ x"/㽭ؽ]$!*㽭code]$ "0 ʼ]$ - н]$ ".ʼ]$E @.ؽ]$$#*code]$G p0 ʼ]$H 8#- н]$I .ʼ]$Y h#.ؽ]$ *code]$[ #/ ɽʼ]$e , ɽн]$f #-ɽʼ]$ 0-ɽؽ]$#)ɽcode]$ `0 ʼ]$ ($- н]$ .ʼ]$xX$.ؽ]$=*code]$z$0 ʼ]$- н]$$.ʼ]$ .ؽ]$ $*code]$P2ɹʼ]$!%/ ɹн]$"0ɹʼ]$H%0ɹؽ]$,ɹcode]$x%1 ɽʼ]$. ɽн]$%/ɽʼ]$r/ɽؽ]$%%+ɽcode]$t@. ʼ]$&+ н]$p,ʼ]$8&,ؽ]$"(code]$ h&1 Ϻʼ]$ . Ϻн]$ &/Ϻʼ]$/Ϻؽ]$&+Ϻcode]$08ʡũܾʼ]$&8ʡũֽܾ]$ 23A200000000`AʡũܾcodeAttribute VB_Name = "" Public TypalueCo8lum8p 'c@nIndex As I@ntegerTø P'SngEndn _ 'һṹ0ҳ"Const sheet{V1 p1 '/ATJD2`ͳƀ m8sgS8 bϢ8 ro ˵ 3Area3Kdme0totalCountJu¼ܵУ  $startTitl7 ' ͷ atLeaOneNNulD 'ִ tǿA ĵԪĿ\Ϲ`J;Money;Varia>'ÿһкϼֵK Err or@ -ʱ/A>A{C/ e Ms>gAD rgoldRang@e '---AԀģЄ ĸFTargen Vqfuncti@onArgsh'0">@ַfisSaveButton}CAʱرťhas(}Boolean{'L0Щ7 ThXeSa@X e ظIdNum}n@8ida_Ч?\״̬checkMethodXQAa1a0ķSaRowSq0= r+ʼxAxbabyIDBj8= 2 'ѧѧaλæcc(ard5֤Dim is1i(ΪEv- ТFΪPЧ A 5hֶc &removeSpaceFlatBȥոp @aˡ2tru efalse ce`ԭ1A |πûнԶûwG֮Kc9 ur@@*)Long 'ϴ<дNA@,Ŀʼʱs@ֵһ&rna$'`eW`cAbi sF S)2ڸݱʶòͬ0-E! жϡ?forѭ C_SeleRJChQõñ gb(head"Ir= 3tHصQ0& Susf9R0v± ! nottinueQ$Aq NÑPlu2W:104 'gRwge r:= 6 'ԱM w xz= 1 ѧ/ birthday2EڿysDifficultyGrade 29 'Ā϶ oi@ntif yDVs30 '1ʱO@6@ReasonT1Sԭ\sO ?0eU@/* ͨX 0-δ 1-"F 2:Q *_1_%]__S!'񼸂PU`1Լ4SiChuanShie 17`ĴC_.`@.9 OqQXo 19pa  QX~409'Code@5tpcؔ6H8aiN/41/ 1t _ P b> I  444{4TYzZM792 '8ؖM.80y@= -L8<01L90>4XK54CKJiLin90ȼTK-,J91JO95A%V%b/%2B:%GuiZhout%97 ''t%10, %&D6&o112&a&L&!&HeiLong111 U'}2e(i3)1>3|cv)30P~Q:+Fu*Q@Bި4*PAp ccs(316(419Q!xo&3aHuBeiр142@Zo 4 ? P0143N$o571{4;qTMJaÓ15' 57> o ` /!5/$}5o1o`o9&e?&15?& t600A O @ Hס60'yQXo89{1ALLpiaoN0?929819O&B& 83Q& _Q8Q=_T99ec&uNa199ϏH 98IL_ P /!98_Q/&q& 215L4&Gu@>Dp&&P<N21  *3424Ch34 35  J Integer = 2351 'ʼ Public Const Ch ongQi XE nd As 92 Code ~50;c! GuangXiShiStart4 '=407 ' ]QX<408σ<=54=g>45<HeNan54MpM-6= -L56x2 'L769WK, KۘJuK77@UP-8j6 ,GK78x6 'K8W%!4%BTr%88jp%o9z0- &9>0@L&30<80Le'Str!@"6A" 'a'NXias' t'R2' 6'O114'pN`'A&`ZheJi'11e㽭'2 rS'|12/V'2 u'33 'Az''53253/t 26d   3326RQ3397A'364ḏBeiJ:?'@i'O'40 ߯ 4aRϏ4111aShan'3341qɽ'  429  _R30_& 3568&?Q'?<#357i'ɞO _58&? oa580yo 37~0a 2"FSy>_:R:71PqM 7.'Ϗ86ˆ3ŒNeiMengG 8 'xɹϜ)? 87i / /!87eOD(/99b'_Y|15OGD7bb9@@?o(b(^ bq(ɽ _PPS2[ʼ Public Const ShanDongQXEnd As Integer = 4210 'ؽ~Code |37v cD  AnHuiSh@iStart2BƇ<27 '9QX:28ǁy;359;w<4ugDHa361"8ϺL36>2{zM363CMRN7BN.VNO=OHeiL@JiangNKen1252ũܾ5NV126@w< ' RYlgLP1I(Pg p,g\HZHHg{gg pgHZH23O` Hg#xg( #k g4g5g6g78g79gg:g p;g(h&k8 g$ 8 g2<OhO gn  @ f 8Fg   gh8 gB g.8qnlg8/ 8/ <N"qP Pk PPg8/ 8/ L8/ <N"qP khx Pgzx @HZH=Hg p>g7\~gV?Ia (gV@Ia (`g>`qmlh`qnl0 gjh @`E(x(0gh0gxg`Ag g>ll4gxlHZpHABHgg"lg:gggg, gg2g`!gKFg4@ggNkPPggg2g^PCODO( PggLgLPEI(PgdHZH0+HgNHZpHFHgg pGg&gG |gLPHI(PgdHZH0+HgVhIIPP( PghHZH !"#HgJ#h@P(PggLPJI(PgdHZH0+HgNHZpHFHggg\HZHHg\HZHHg\HZHHg{hH" P8H0@ h`x 8`zHPHi aS SK*  rU@@~~~~~~~~~4~~~~~~~~~ ~ ~ ~~~~~~"QjDG]T    a#a #aA 01a!aAqAq!aAQaA  89A9q999:A:q:::;1;a;;;;<A<q<<<=1=a====!>A>q>>qaA   a #Q!  VBAProject ThisWorkbookSheet1Sheet6ӡԤߺУ麯ShowFormSheet5 PrintFormF1C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLLVBA A qPF  E:\office2013\Office15\EXCEL.EXEExcel 1p0FC:\Windows\System32\stdole2.tlbstdole aL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLLOfficeMSForms A.E .`M C:\WINDOWS\system32\FM20.DLL e*'@|G2:2C:\Users\lenovo\AppData\Local\Temp\VBE\MSForms.exd  Free checkTheSame FF Oo` &m F&m  0]\Ohpev Ncknx N}ge!jgT QۏLdk!hVBE7.DLLUnprotectS @(~ 1qaz. PasswordProtect Nxh f 6A 23A200000000 , JJ  8Phpx CellsClearContentsF&t qdeleteRowNoPro A65530 RangeEndRowcheckedRequiredStartwriteLog writeLogRedaddCommentXQStartclearCommentsXQStartbeginCheck_commentcallFunctionXQStart regCheckFunccheckTheSameXQNewGetRowOrColIndexcheckDMB deleteRowsetCellValueCountXQgetCellValueCountXQTabsetCellValueXQ setDMBCode removeSpaceXQ A5 Column FAILUREClearComments A9:IV65536InteriorColorIndex 4`nx[_YhgT hgǏ z-N RsQexcel `  `n1`6d5F3vuuJݞ! ]nHJ~!q" a &TRS[penc"N1Ybhg1Y% )nc:y "l gg~b0Rf[uOo` elۏL!hName -NOo`Y N  ,Y $DF Worksheet xM0A π a % ai (PFICGKHko+?b FH+DYr R 0"hk )"h value - , * g͑ Ypenc g w Oo` h ۏLOck(~ :Rows Delete dk!k!h-N RdN :LeHepencY T0NNSR!h1Y%sS9eL:NeHepenc * gOo` g w Oo` h ۏLOck Select !hǏ! SUCCESS  1 checkLen*x 0P$o checkLen checkNum* checkNum checkVal* checkVal checkInt* checkInt checkTerm1 checkTerm checkYesNo1 checkYesNo checkDiffName1 checkDiffName checkDiffCode1 checkDiffCode checkIDCardType1 checkIDCardType checkSqyyName1 checkSqyyName checkYear1 checkYear checkBirthday checkNull checkRequired checkStuName checkBirthdaycheckBirthdayNecessary IsIDNumber checkSchCode checkFamType checkRXDate checkYear checkMonthcheckXJH checkPhoneNum checkBankcheckXn checkOptioncompare compareDeccheckLencheckIntcheckValcheckNum checkIsInt checkIsNumber checkMoney checkMoneyTJcheckPersonNumcheckIdNumLink checkxzandxlcheckS checkSFZJLXcheckS1 checkCName ,{ Lvpency  N:Nzzhg checkName hg checkXH @ a >kXQ Ncknx_{:NIlW[ ^'YN1 NǏ16*NW[&{ hg checkCName s~ ^kXQ Ncknxy_{:NW[kpeW[bIlW[ ^'YN1 NǏ100*NW[&{N NS+TyrkW[&{ hg $kXQ Ncknx y_{:NpeW[ 'YNI{N .kXQ Ncknx ySN:Nzz0kXQ R^_{:N MOhg 4kXQ Ncknx ySN:Nzz0kXQ R^_{'YNI{N MO N NǏ &kXQ Ncknx y N:Nzz N^_{:N ,kXQ Ncknx y N:Nzz N^_{'YNI{N HkXQ Ncknx ySN:Nzz kXQ N_{:Ntepe 'YN0 tepeMO^ NǏ @kXQ Ncknx y N:Nzz N_{:Ntepe 'YN0 tepeMO^ NǏ N NǏ 8kXQ Ncknx ySN:Nzz kXQ R_{:Ntepe 'YNI{N  N^ NǏ 0kXQ Ncknx y N:Nzz N_{:Ntepe 'YNI{N checkSfzjh &kXQ Ncknx VNN{|W:Nzzhg E\lN *kXQ Ncknx y_{:Nf[uNShg HkXQ Ncknx y N:Nzz N^_{'YNI{N1MO N NǏ18MOhg checkZjlx kXQ Ncknxhg `kXQ Ncknx y N:Nzz N^_{'YNI{N1MO N NǏ40MO1upeW[T'Y\W[kQ~b hg checkXJH fkXQ Ncknx ySN:Nzz N:Nzz^_{'YNI{N1MO N NǏ40MO1upeW[T'Y\W[kQ~b hg checkKSH checkBank 2kXQ Ncknx y5b1e86998]wQQpex`Xf0=5b1e8699NXf&xZ!hQpe0B5b1e869a!hQpe~`i;N z^0<5b1e85d1;N z^Ux`'ShowForm095b1e85d1iShowFormnw Sheet50@5b1e8699s Sheet5hPrintForm0;5b1e85d1uPrintFormʘHx0`x OhL]$=ՔN/³0?GGئƢ[D!GԅѪ׏'?NCL5FU ]Hޚi9N]w `cvC+BXCK`{:ʜ DW@buɊ~qXC#}oUBtT`B|!8compare Excel+` VBA`Win16~`Win32`Win64x`Mac`VBA6#`VBA7#` VBAProject`stdole``Officeu`MSFormsC` ThisWorkbook|` _Evaluate` Sheet1` Sheet6` ӡԤX` (Browse_Prints` Worksheets`Visible` PrintPreview` ߺ`(checkedRequiredStartR`rowIndex6d` columnIndexP` cellValue@` ActiveSheet%N`Cells`(writeLog{u`contentl`Sheets ` (msgSheetName'` (curMsgRow/` (writeLogRedm`nLene,` Charactersrg`FontU` ColorIndex`(addCommentXQStartS` sheetIndex ` errorInfo` AddComment`Interior;`Color2F`CommentHs`(clearCommentsXQStart7` ClearCommentsf`sheet2RecordNum`ffTotalNumColumn`xlNone`(beginCheck_comment;D` checkMethodHd`(errorMsg'|`(callFunctionXQStart `typeVal#`isValidateCount8`valueK`titleMsgh` (startTitlel` (headIndex` (functionArgs8M` (checkMethodXQ` (checkRequiredb`(hasErrorf`(isFord` (removeSpaceXQ`Trim@` (checkStuNamec` (checkCNameV`(checkLeng`functionArgsArr`Split)`(checkNumh`(checkValK`(checkInt`resZjlx0`(getCellValueCountXQc` (IsIDNumber-*`(checkIdNumLinkUz` (checkSFZJLX*`(checkDMB`(checkS)`(checkS1#` (checkBankUw` (checkYear6`(checkXn` (checkMonth` (checkBirthday`ChrK~`(checkBirthdayNecessary` (checkPhoneNum` (checkOption,`(sysDifficultyGradeNameFlag`(indentifyDateFlag ` (hasErrorIdNum` (setDMBCoded`(atLeaOneNNullCount` (checkMoneyi` (totalMoney%`baojiaoMoneyColumns`baojiaoMoneySumk`huoshiMoneyColumn_`huoshiMoneySumr`zhusuMoneyColumn_` zhusuMoneySum>-`othersMoneyColumnߥ`othersMoneySumH`(atLeaOneNullCount` (atLeaError~` (regCheckFuncE`reg`regEX*` CreateObject`Patterni` IgnoreCase0`Test4`(checkTheSameXQNew` sheetIndex2n`(rnaO`Range `xlUp`Row` ClearContents{`i``cardID1[?` (cardIDColumn-h`ja`cardID2\?` (hasTheSame`(GetRowOrColIndexf`keyWordF`kbn1`cZ`Findn`WhatC`LookInP`xlValueso`LookAtO`xlWhole`Columni`value1`flag`rowData1`Count0v`rowNummR`(AreasheetIndexH` codeValue` (columnPlus` (deleteRow` Unprotect?`Password`RowsU`Deletex`(setCellValueCountXQ]`colIndex`(deleteRowNoPro`(setCellValueXQ`length1S`length2T`Replacef` i`(!ValueColumType` columnNamew`(sheetIndexValue1` (AreaSheetName`(readmeSheetName` (totalCount-`(rgold`(TargetF` (isSaveButtoná`(hasErrorInValidateU` (dataRowStart` (babyIDColumn` isNullRowNum8`(removeSpaceFlag` (cellContent`(cna`(notContinueBoolt` (genderColumn~`(xzColumn6`(birthdayColumn0`(sysDifficultyGradeNameColr`(indentifyDateCol&`(indentifyReasonCol*9`(SiChuanShiStart:` (SiChuanShiEndN`(SiChuanQXStart` (SiChuanQXEndv` (SiChuanCode`(HaiNanShiStartf` (HaiNanShiEnd` (HaiNanQXStartm` (HaiNanQXEndB ` (HaiNanCode`(YunNanShiStart 9` (YunNanShiEndq` (YunNanQXStart` (YunNanQXEndo` (YunNanCodevk`(QingHaiShiStart‹` (QingHaiShiEnd`(QingHaiQXStart ` (QingHaiQXEnd]` (QingHaiCodeL`(XinJiangShiStart `(XinJiangShiEnd`(XinJiangQXStartq` (XinJiangQXEnd}` (XinJiangCode`(XiZangShiStart$|` (XiZangShiEndT` (XiZangQXStart` (XiZangQXEndo` (XiZangCode,` (JiLinShiStart` (JiLinShiEnd` (JiLinQXStarth` (JiLinQXEnd` (JiLinCode`(GuiZhouShiStart` (GuiZhouShiEnd@`(GuiZhouQXStarto` (GuiZhouQXEndL ` (GuiZhouCode`(HeiLongJiangShiStart`(HeiLongJiangShiEnd`(HeiLongJiangQXStartm`(HeiLongJiangQXEndf`(HeiLongJiangCode`(FuJianShiStart1` (FuJianShiEnd` (FuJianQXStarti` (FuJianQXEnd` (FuJianCodez` (HuBeiShiStartJK` (HuBeiShiEnd` (HuBeiQXStartM` (HuBeiQXEnd&` (HuBeiCode`(TianJinShiStart` (TianJinShiEnd`(TianJinQXStartm` (TianJinQXEnd(` (TianJinCode` (HeBeiShiStarti` (HeBeiShiEndq` (HeBeiQXStart` (HeBeiQXEnd:` (HeBeiCodeU)`(LiaoNingShiStart`(LiaoNingShiEndF'`(LiaoNingQXStart` (LiaoNingQXEnd` (LiaoNingCode{` (HuNanShiStart` (HuNanShiEnds` (HuNanQXStartl` (HuNanQXEndy` (HuNanCodeF`(GuangDongShiStartI`(GuangDongShiEndQ^`(GuangDongQXStartHY`(GuangDongQXEnd!(` (GuangDongCodeH`(ChongQingShiStart``(ChongQingShiEnd}`(ChongQingQXStart+J`(ChongQingQXEndMu` (ChongQingCodeҬ`(GuangXiShiStart` (GuangXiShiEnd)`(GuangXiQXStart` (GuangXiQXEnd` (GuangXiCodeYg` (HeNanShiStart^` (HeNanShiEndU.` (HeNanQXStart` (HeNanQXEndϥ` (HeNanCodeȕ` (GanSuShiStart;` (GanSuShiEnd` (GanSuQXStartb` (GanSuQXEndP>` (GanSuCodeN`(BingTuanShiStart`(BingTuanShiEnd*`(BingTuanQXStartB` (BingTuanQXEnd` (BingTuanCode*`(NingXiaShiStart` (NingXiaShiEnd`(NingXiaQXStart` (NingXiaQXEnd.` (NingXiaCode`(ZheJiangShiStart]L`(ZheJiangShiEndi`(ZheJiangQXStart` (ZheJiangQXEndΣ` (ZheJiangCode`(JiangXiShiStarta&` (JiangXiShiEndb`(JiangXiQXStartab` (JiangXiQXEnd` (JiangXiCode`(BeiJingShiStart` (BeiJingShiEnd`(BeiJingQXStart5` (BeiJingQXEnd` (BeiJingCodeR`(ShanXiShiStart` (ShanXiShiEndGx` (ShanXiQXStart~` (ShanXiQXEnd{` (ShanXiCode&k`(ShangXiShiStartS` (ShangXiShiEnd1`(ShangXiQXStartg` (ShangXiQXEndw` (ShangXiCode`(JiangSuShiStart` (JiangSuShiEndL`(JiangSuQXStartj` (JiangSuQXEndn` (JiangSuCode%`(NeiMengGuShiStartǺ`(NeiMengGuShiEnd+`(NeiMengGuQXStart#`(NeiMengGuQXEnd` (NeiMengGuCode{`(ShanDongShiStart)`(ShanDongShiEnd6`(ShanDongQXStart+` (ShanDongQXEndA` (ShanDongCodeLJ` (AnHuiShiStartp` (AnHuiShiEndf ` (AnHuiQXStartI` (AnHuiQXEndj` (AnHuiCoded`(ShangHaiShiStart`(ShangHaiShiEnd6'`(ShangHaiQXStartk` (ShangHaiQXEnd ` (ShangHaiCode&`(HeiLongJiangNongKenStart`(HeiLongJiangNongKenEndWj`(HeiLongJiangNongKenCode` У麯&`IDNumber4 `Wm`UCase5 `sj`Tk` IsNumeric$*`Right ` (checkSchCode` (checkFamType` (checkRXDate*`(checkXJHF`years`value2` (compareDecN` maxIntLen1` maxDoubleLen` intLength`intValue`douValue` (checkIsIntR` (checkIsNumberG` (checkMoneyTJC`(checkPersonNum `IdNum>` isGenderRight ` isBirthRight` genderValue` genderValue11` birthValue` birthValue1~`year6n`year1w`month`month1`day`day1;`arr u` (checkxzandxl]`XLValueh @P @@8 @@@ x @ EhG@ @ J@ J@  @h @ @B @ @ @F(x x6@H` @H R@p0 HR@( T@J @ pY@ Y[ a@L( @ 8 d@ H d kxn [$*\Rffff*0<5b1e85d1*\R1*#3c7*\R1*#12d*\R1*#121*\R0*#17$*\Rffff*0=5b1e8699*\R1*#11c*\R1*#42$*\Rffff*0>5b1e8699*\R0*#2*\R0*#f*\R0*#1*\R0*#1a h"hp:x.6" "H.p D  :L \(HP\X\x\>^":  4`, p$ >^,J8 P ~h(PV `^,~    \ .d ,L @\Hh p* x* ,,(000D8000000,0  0( 4$0 42@ 4nX 4 p 0  0,  , ,+. /: /H / z@ / ` / h 4Vx 4V 4> 8 j 4 4> 80 8 @ (P 8>x <0x 8  8" 8 8 4 . ,  , (2 H  X *4h  +$N      `^ @ H 4LP d N   $& 4 $ LHd`PVx,J 4LdPNhx  \ \ \ x"hp2$@60 h*x :   (,@px a--------------------------------------------ʼУ-----------------------------------------]X]p+ijһ͵ıʶкź͸ʽ3:1;2] ʶ(ĬϱʶԶʶ)](ijһ͵ıʶ飨кź͸ʽ] ijһͱʶľֵ]Զʶ]%Ѽ¼ΪյкŷŽ](]@] 2!,'*"ȡĿ *0ĿȷģٽдУA@.1qaz:$2B@0|k1qaz:$2B@81qaz:$2B@81qaz:$2B@8 L$J!DB@-$ÿοʼʱѴϢsheet,'NϢ¼ʼ'.ôУУ¼Ƿд֣׶ϢУ 2(4'#Ĭ϶ѼδͨУ'Ĭ϶δͨУ L$J!DB@-$ÿοʼʱѴϢsheet, A65530$2%%!' A@@ ȡxcna = Worksheets(1).Range("1:1").Find(What:="*", After:=[a1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Column 6A5$2%%!$'nFAILUREA@F&+ȡǷУɹ־Ԫ񣬲ֵʼΪ0'hռ¼ʼΪ0$2!DB@j. A9:IV65536$2%!b(X ` 8" ʱִd ʼУ鰴ť¼ʱִ.ȷʼ Уرexcel $ܵݶʧʧ :ܰʾ$. 8dp1qaz:$2B@0|Hk@k8.$2!b(X)ҳǩΪɫ   "ûвҵѧϢ޷У飡A@.'`1qaz:$2B@0|k'ôУУ¼Ƿд$2!дϢ£A@F    <  'G"ִ һǿУ ĵԪĿ'F6ִ һǿУ ĵԪΪϹĿ''v'@"һǿУʱ¼Ԫ'|DǷΪЧ¼ 'bN¼УǰǷд' > n ,@ <, >'@ @D ,+ , ', > <   $$D $$D, $X'B $$D $$D $$D, $X'F F$2%D!~''  -$'  :$'H > H H >$H B F |A@x | P,һؼֶȫ򽫸ɾ B h+( h 'h8"ϢеĸдϢɾ J N | N N | L$J%<B@>z Ѹɾ J N | 'N b''|kk k L h : ɾЧ L$(' L A@6B Ѹɾdp  L A@6H Ѹɾk@ L h ˴Уɾ h:Чݣ֤У鶼ʧܼΪЧݣA@.k *дϢ鿴ϢA@.$2!b(X L$JB@HdH'A@2У֤ظ '%ִУظݷ,ûظǷҪɾЧ Уͨ!A@..$2!b(XSUCCESSA@F:+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 A65530$2%%!' A@@d*ظݣ鿴ϢA@.$2!b(X L$JB@Hkkx1qaz:$2B@01qaz:$2B@01qaz:$2B@0oq-------------------------------------------------ظijһ------------------------------------------------]0]H` A65535 B%%!'2Scripting.Dictionary$.VO8O  B%!~'X>ȡѧ Z X%"ѧ໤֤ݽб Z Z V%\-֤Ų Z VB@^&#addһΪkeyڶΪvaluekk P!`'RSheet2$2G:G7B@ R 2!d%f P!,G17,bq .Pox p [Attribute VB_Name = "" '-( У&l Sub Free () Dim rowDat aNum%typeValue 'ijһ͵ıʶкźʽ3:1;2"?bsTA '2(Ĭ `ԶCvalEntity8: 7,ľֵh`Row '>_ isNullArr(500) As Integer 'Ѽ¼@Ϊյā`ŽÁP sheetCount a&umCG !Works. 'ȡ" If H <> 3 ThenAt MsgBox "GģٽдA@"(1).Protect Password:=`"1qaz DE0xit #En0d IfKUnFpH 2).h 3_ Sgs(msgB).Cell]learCo{nts 'ÿؼʱѴϢ`,C7cur]A= 1 '  hasError=FalBskô/УǷ!֣ ׶A lApplication.Sc!ynUpdng sysDifficultyGradeFla 0f`r϶Ѽδͨ !cinde)rfy`eO y F`o1\j2 To]atLe`aOneN= I!? һǿA" M?TΪϹOtotalMoneyAw,e!4"ߏ!e"c`Qc_ijs ziPe1jЧOOs7In E R'A!мȰ8Idcr"oo2l113ReЅserve m$ar1paqF,AnoB$xay(Po zm0mcNext o/Ra>r   p*ZFor W = 0 To UBound(arr)+r!VarlGCInt(Left(JoinJ(W)), InStr ",") - T1)/mv627Righ7Len64A?typeValueAWorksheets(1).Cell, Q).visf= FalDsenIf (<> "" ThenbsT;9@Split(,0 "-"onroZw:5ALn)L{C)3BA.callFunctionXQStaHrt D(n1 , D, is@idateCt3Nex?*CA, > 1A 'һؼֶ򽫸ɾisNullRo wArr(Num)@5a%_ ^ a + 1  'Ϣе %! TpcurMsg#@4`_ "Smsg"Name).s(x).Delete 'ѸĿ@:r AX p&=   hasE$rr= EInew ;  End If_WW1q12Z< '7ЧoaXData@Gqj Trd2<_(3oE~Os-@ ?;2!qrft^>_OBox "ˀУ֢f`" &s& "! ݣ֤ @ʧܼJ"o u O` vA Хbu :Tab.ColorIndex26 __P_S*cτvo(){S0d  checkXQNew P 'ظ/9NotXpn 'ִ"A!,qxA 'Ҫ}}# Ͱ! -4142setqgueXPQ 2,!8SUCCESS" `'ȡ! ɹ־Ԫ񣬲ֵΪ0urnaP Range("A655 30").@2(xlUp"/ up P AQna&q4444_4_4DProtect Password:="1qaz" Worksheets(2).Protect Pas 3`End Sub '--ظijһ-? x checkTheSame()Dim myDic As Objt,KeyVari8ant , varDatarna = Ac tiveS.Range("A65535").(xlUp).Row '1 Set@ idNumH= CreateJ("Scripting.tionary"bI@O8", " O" & R).value 'ȡѧ @##For Each car1% In''໤֤BбC IfF@<> "" anNoG?.Ex,is)B '8G@AA.AddE, Nul@l 'addһΐkeygCAIfIN$exƒ Cmy=.sWith "BF2GmG:G@ClearContent41@Resize(B.Count)A@pplica.FFunon.Transpos 'D4O`= 0hL A u !rU@@@~xa / * Q0! A#@>"!+A)&A%1 15:Q91=1111q!."'02A2223A333/4Q444Q556Q667q778Q88>>!?Pa?AABBB"DDDQEEFF1GCG?HHHaII!JQJJqKK?LL1M!NaNN!OaOPaPPQaQQRqRR!SaSSTqTTTqUU1VAWWXXYZ[Q[[[\Q\\\]q]]1^ Wq__1aaaaabdQdeeAeqeefAfqffHiggn @q` Zpg  g@ Hi(ggz(x Z00g ZH0H0g ZH0H0g0@,H0Hix dgglTg00( (gg8Hd@`TdSggf (Zxgj`(Zx0g0*Kdgj`(Zx0g" Kg~(x`Z0gg+,g&-xlg<x  `,xg.g&/xlg<x  `,xg0g&1xlg<x  `,xg2g&3xlg<x  `,xg4g&5xlVg6,g7g&8xlg6,g9g&:xlg6,g;g&<xl@g6,g=g&>xlg6,g?g&@xlg6,gAg&Bxl*g6,gCg&Cxlxg6,gCg&Dxlg6,gDggLgEK(g6( x xFxgF g`G Ox`HO0OHIO`JxgKgJx xggBJ@( F @x0xgLTSgMK g*( x xg (Zxxg*xxFxgF  g`G Ox`HO0OHNO`JxgKgJx xggBJ@( F @x0xgLTSgOKJ g*( x xgj`(Zx0g0PK gpa, ggqa,gg6,@xxFxgF  g`G Ox`HO0OHQO`JxgKgJx xggBJ@( F @x0xgLTSg.Kg6,@xxFxgF gHRIxx,(pxgdpx`Cpqn?[H7lxH gG Ox`HO0OHSOpXO@TO(`JxX@(jgdpx`Cpqn?[H7lxH4gG Ox`HO0OHUOpXO@VO(pOTO`JxX@(jgdpx`Cpqn?[H7lxH6gG Ox`HO0OHWOpXO@TO(`JxX@(jgdpx`Cpqn?[H7lxHjgG Ox`HO0OHXOpXO@VO(pOTO`JxX@(ggKgJx xggBJ@( F @x0xgLTSg0Kg6,@xxFxgF gHRIxx,(pxg6px`KxxgG Ox`HO0OHYOpXO@TO(`JxX@(tgdpx`Cpqn?[H7lxHtgG Ox`HO0OHZOpXO@TO(`JxX@(ggKgJx xggBJ@( F @x0xgLTSg2Kg6,@xxFxgF gHRIxx,(pxgG Ox`HO0OH[OpXO@\O(pO]O`JxX@(gKgJx xggBJ@( F @x0xgLTSg4KPg6,@xxFxgF gHRIxx,(pxg6px`KxgG Ox`HO0OH^OpXO@_O(pOTO`JxX@(g6px`KxgG Ox`HO0OH`OpXO@_O(pOTO`JxX@(ggKgJx xggBJ@( F @x0xgLTSgaKg8x  xg$xxg*Kxg`G Ox`HO0OHbO`JxgKgJx xPggcKxg*KJg`G Ox`HO0OHdO`JxgKgJx xlgg8(apaxFxpgF *g`G Ox`HO0OHdO`JxgKgJx xfgg6( x xFxggJgg*xxFxgF Dg`G Ox`HO0OHeO`JxgKgJx xggggBJ@( F @x0xgLTSgfK* g\( fIxx0FxgF g`G Ox`HO0OHgO`JxgKgJx xgggBJ@( F @x0xgLTSghKj!g*xxFxgF !g`G Ox`HO0OHiO`JxgKgJx xggBJ@( F @x0xgLTSgjK"g*xxFxgF N"g`G Ox`HO0OHkO`JxgKgJx xggBJ@( F @x0xgLTSglK#g*xxFxgF #g`G Ox`HO0OHiO`JxgKgJx xggBJ@( F @x0xgLTSgmK%g*xxFxgF >%gG Ox`HO0OH[OpXO@\O(pO]O`JxX@(gKgJx xggBJ@( F @x0xgLTSgCK&g6,@x xFxgF &g`G Ox`HO0OHnO`JxgKgJx xggBJ@( F @x0xgLTSgoK&(g*x!xFxgF 'g`G Ox`HO0OHpO`JxgKgJx xggBJ@( F @x0xgLTSgqKf)g*x"xFxgF  )g`G Ox`HO0OHrO`JxgKgJx xggBJ@( F @x0xgLTSgsK"+g6,@x#xFxgF *gG Ox`HO0OHtO"X$XO@uO("$OvO`JxX@(gKgJx xggBJ@( F @x0xgLTSgwK,g*x%xFxgF v,gG Ox`HO0OHtO"X$XO@xO("$OyO`JxX@(gKgJx xggBJ@( F @x0xgLTSgDK.g6,@x#xFxgF 2.gG Ox`HO0OHtO"X$XO@zO("$O{O`JxX@(gKgJx xggBJ@( F @x0xgLTSg|K>0g*x&xFxgF /gG Ox`HO0OHtO"X$XO@}O("$O~O`JxX@(gKgJx xggBJ@( F @x0xgLTSgK1g8xB'FxgF 01g`G Ox`HO0OHO`JxgKgJx xggBJ@( F @x0xgLTSg;Kv3g\( ;Ixx0FxgF 2g`G Ox`HO0OHgO`JxgKg pgJx x3gg6xx*Kx3g q3gg rgggBJ@( F @x0xgLTSgK6g6,@x#xFxgF 4gG Ox`HO0OHtO"X$XO@xO("$OO`JxX@(gKgJx xg pl6ggVq>[xx*C7lxV5g qf6gVr>[xx*T7lx5g rf6gg`G Ox`HO0OHO`JxgKg pFgJx xg pgggBJ@( F @x0xgLTSgK:g,g6,@xxFxgF 7g`G Ox`HO0OHO`JxgKgJx x<:gg`q>q>2[xx*C7lx886:g`r>r>2[xx*T7lx86:g`pOpO&[xx*C7lx9g`G Ox`HO0OHO`JxgKgJx xg pF6:gg`G Ox`HO0OHO`JxgKgJx xg pFgggBJ@( F @x0xgLTSg?K<g\( ?Ixx0FxgF ;g`G Ox`HO0OHgO`JxgKgJx x;gggBJ@( F @x0xgLTSgK=g\( Ixx0FxgF 2=g`G Ox`HO0OHgO`JxgKgJx x8=gggBJ@( F @x0xgLTSgK?g\( Ixx0FxgF >g`G Ox`HO0OHgO`JxgKgJx x>gggBJ@( F @x0xgLTSgK@g\( Ixx0FxgF .@g`G Ox`HO0OHgO`JxgKgJx x4@gggBJ@( F @x0xgLTSgKBg\( Ixx0FxgF Ag`G Ox`HO0OHgO`JxgKgJx xAgggBJ@( F @x0xgLTSgKCg\( Ixx0FxgF *Cg`G Ox`HO0OHgO`JxgKgJx x0CgggBJ@( F @x0xgLTSgK Eg\( Ixx0FxgF Dg`G Ox`HO0OHgO`JxgKgJx xDgggBJ@( F @x0xgLTSgKFg\( Ixx0FxgF &Fg`G Ox`HO0OHgO`JxgKgJx x,FgggBJ@( F @x0xgLTSgKHg\( Ixx0FxgF Gg`G Ox`HO0OHgO`JxgKgJx xGgggBJ@( F @x0xgLTSgKxIg\( Ixx0FxgF Ig`G Ox`HO0OHgO`JxgKgJx xggBJ@( F @x0xgLTSgKJg\( Ixx0FxgF Jg`G Ox`HO0OHgO`JxgKgJx xJgggBJ@( F @x0xgLTSgKtLg\( Ixx0FxgF Lg`G Ox`HO0OHgO`JxgKgJx xLgggBJ@( F @x0xgLTSgKNg\( Ixx0FxgF Mgg`G Ox`HO0OHgO`JxgKgJx xMgggBJ@( F @x0xgLTSg9K~Og\( 9Ixx0FxgF Og`G Ox`HO0OHgO`JxgKgJx x"OgggBJ@( F @x0xgLTSgAK@Qg\( AIxx0FxgF Pg`G Ox`HO0OHgO`JxgKgJx xPggD( AIxx((xggBJ@( F @x0xgLTSgKTSgxgHx)xT7lxRgxg(XgX@K0Rg(x(RgXKnRgxRgXKRgxRgXKRgxg@Sggxg.0xxggLgg8hdSnX@0(phxpxX@(gg.*gggg"ggҋ D Hilg& 8gg @HZ g& ^gD0g"Xgg"gggp@HlP,2Jgg" +Kg6*Kzgg gggXgHPZpPHPHgg28kpg"p^g~ @0HPZpPHKPH0g XXBgg ^gggBpppX@gp @0HPZpPHg8g0D80PHhgzp @0HPZpPHPHgq(0hH0PZpPHPHgg ggp@g8|V X@Xpp>80PHHi(Jgg^Zgv(x ZHHg0@&Hggt Zxg(@,xHiP Jgg^Zgv(x ZHHg0@&HHi (Dggg| Zx``x`gLgp>g g&NgpOg2*0gxqH Zxxggg(D ,x` a$h  "a "a *~  &o  . . $h "a  0  . $h  *~  &o $h  *~ !*~ $ &oV(()xMEX> LL  <` `@ F(`Hk  iH P`   iH Zx`"0k I\ I< 8I>@# XI^(  h0`   "I\ I< I>  r(`k -I\ It I< I>( Iv0  x `k BIz I\ I< I>( I|80  `kx I I~ ` H` ( I + ` k I\ I i8` ( `kp ""I~ I& I(p I<( I>0 @*p 6 `  I\ I.  @ `Hk !I\( 8 I< X IB x I~ (  P `h$xk &I\  I< 0 IB  D ` ,I\  I.  F `8Hk@ 0I\ ` I<  IB  I~@ (   `  5I~ 8 I\ X I< x IB @* @2 @@ ` 0k8 QI\ X I< x IB `&`H`J8  H(( P x0( 8%X x 8 x (`@@@ P(2@ @ @ @ @ @x @` @H ` (@@F 2@p @X @ @ @ @x @` @H @F NLJ@ @  @ @8 @P @hx @` @H 8PHhP8P@x `82v@ @ @ @ @~ @x @0` @`H @0 @x @ @ @ @ 1@ @` pFr@p @xX @@ @( @ @ @ @  @ @ @ @hx @p 0@X n@@ @( @ @8 @ @ @  @H PxPh@ xP@ @ @ @ @r @ @ Z x X (p@ @@ 2L@X @ @ @x @` @H @0 Xp8p@ p@ @h @ 0J4@ @,X @PP @H @0 @ @ @. @ @  @  8 @p H   @ p @X p@@  @8 @0 @2 @! !!X"! h! ` !@\ 0! @ X!!`@!"2@! @ @! @!x @!` @"H @("0 @@" @ @p" @" @ 8X#8$#@#x#X#@Z h#@#2@# @# @# @ @$ @ $x @` @P$H @0 0 %  X%%p%%@% %@ 0%%2@% @% @ @ @% @x  P n [$*\Rffff*0>5b1e8699*\R1*#3c7*\R1*#12d*\R1*#121$*\Rffff*0=5b1e8699*\R0*#f$*\Rffff*0B5b1e869a*\R0*#17*\R1*#42*\R1*#46*\R1*#5fc B       B n  B h p2 p `B x 8 $z 8 " @ pHB  8  $0 X$`  xB  b8(0 0 J DH  8 H >  D`  @ P `  h p x  B  f( 4jH $  "j  (  "~    .& <P h 0,x <  *, <  .,( <X p .,    0,  6,0 hx6, 8, (86,P (,  (, (8 ,,P   f   @6Xp>`x&  XHBPp hx $**&(*P`j`h&  ,@BHh ^p$**4jP` hpx6`&( P`Bh ` $6 H  Hd8(x Hj(@ Hj(p( Hj( x & B n $X6h H 86( Hjp( H &P xB b   $@6PhHp& 8 ,HxB f   $0 6@ X  H`  86x (  6<X!(! 0" &8" `"p"Bx"" f" $#(8 #$H# X# T`h# &# # #$ $$X`($$&$$ $ ,$  $$$8$$&%(X`@%(&%( % ,%$6 &(68&$P&  X& `&$*h&$x&(t`&(&&(  ' ,0'$`' $ h'p' Bx'' ^' $((\(@(@`H(&( ( ( @()B)0) `8) $)*)) `) &P* x* **B** b* $(+*8+H+ `P+ &+ ,  ,B(,H, bP, $,*,, `, &p- - -B-- b- @. $`.*x...&/ @/ P/X/B`// ^/ / $06 080X`@0&0 00B00 ^1 `1 $1*11X`1&2 (2 82@2BH2h2 ^p2 2 $2*33T` 3&x3 3 33B33 n3 X4 $x464"44&X5 5 55B55 n5 86 $X6*x6"66&@7 h7x7B77 n7 8 $886X8"p88& 9 H9 X9`9Bh99 P9$9*9::&: : ::B:; R;$h;8;;X`;&;  < 0<8<B@<`<  bh< $<,\<=@` =&`= = = = D=,6= > (> 0>8>@>BH>h> jp> $>6?"?@?&? ? @ @HV@  `@L\h@  @ @ `@ &pA  A A  AAABAA    jA "$`BB6BB d`B & C HC XCb``C hfC ,f0D ``D &D  E  0E 8E `@E &F (F  8F@FHFBPFpF ^xF $F.\F G@`(G&hG G G FGGBGH  Z H $H&\HH@`H&I (I 8I >@IIBII   ZI $J(\(JPJ@`XJ&J J J @JKB K@K  VHK $K&\KK@`K& L HL  XL >`LLBLL ZL $0M(\HMpM@`xM&M M  M @M 8NB@N`N ZhN $N(\NO@`O&PO xO  O @O OBOO ZP $`P(\xPP@`P&P Q  Q @(Q hQBpQQ VQ $Q&\R(R@`0R&pR R  R >R RBRS Z S $S(\SS@`S&T 0T  @T @HT TBTT VT $U&\ UHU@`PU&U U UBUU  ZU $XV.\pVV@`V&V W W H(WpWBxWW ZW $X4\ XXX@``X&X X X LX0YB8YXY |`Y $Y*\Y(Z(0Z@`XZ&Z Z  Z BZ [B([H[ |P[ $[(\[\@`\&X\ \ \ @\\B\] |] $],\]]@`]&^ @^ P^$DX^^B^^ d^ x_ $_6_.H_`(`( 0`2@`( P`1``( p`2`( `1`` `J`. a8a@aHa Pa fXaB a a<.ab 0bHb$hb$"bb b b \pc B c,c 0 d@Pd"d ^d 6ePeheee0eHe@f`fhfpfxff f "(g Pg .pgB &g g$gBg (h 8h "Hh  Xh "`h phxhh h  i 8i Pi piB i""i 6ii i iii i8jPj22Xj"j ~j  j j  jj jBk F k  zhk(kk k k k *k l l l lB ll*m 48mpm xmB n^n v0n Pn XnB n tn o o o oB o*o p (pB p^p vp q qB q q "q r8 r2Xrr rr rr r rs" s0Hs xs(sss&ss tt t tB Xu`uVuu 8u |0v Pv: `v4&v$v2w"xw@wHw Pw Xw w-----------------------------------------УУдϢʾ ע----------------------------------------------------------- Ԫ] < > B%D'@ @':d(':ki--------------------------------------------д־ ¼ϢʾһϢ-------------------------------------------- H N L$J,D N 'NiX--------------------------------------------д־ ¼ϢúɫʾϢ--------------------------------------------( H'R H N L$J,D R N L$J%D%T!V(X N 'Nipi--------------------------------------------עʼУ飩-------------------------------------errorInfoע 1Worksheets(sheetIndex).Unprotect Password:="1qaz" ^ < > \$2%DB@` < > \$2%D!b(dW ӻɫ < > \$2%D!f(4ii--------------------------------------------ɾעʼУ飩-------------------------------------x1Worksheets(sheetIndex).Unprotect Password:="1qaz" < > \$2%DB@j < l > n < > \$2%D!b(Xd` p < > \$2%D!b(Xk0i(r---------------------------------------------ʼУ Ƿӻɾעõķ----------------------------0 t Уʧ\If Worksheets(sheetIndex).Cells(rowIndex, columnIndex).Comment Is Nothing Then 'жעΪ \ < > vA@ZV ע) Else 'ΪգȥǰעDclearCommentsXQStart sheetIndex, rowIndex, columnIndex 'ע=addCommentXQStart sheetIndex, rowIndex, columnIndex, errorMsgEnd If1 MsgBox "" & rowIndex & "" & errorMsgA Else 'УɹжǷעУʧʱעȥ8 clearCommentsXQStart sheetIndex, rowIndex, columnIndex= If removeSpaceFlag Then 'ȥո,ʾ writeLog "" & rowIndex & "У" & columnIndex & "Уַ" & Chr(34) & cellContent & Chr(34) & "а˿ոϵͳԶΪ"ElseEnd Ifki----------------------------------------------------------------------------------------------------------------------------------y--------------------------------------------ݱʶöӦķ(ʼУ)-----------------------------------------------------------------------------------------------------------------------------------------------------------------------ѴϢдб( < > \$2%D'~  > \$2%D'Iȡбͷ Ϊϲеıͷ  > \$2%D' < e  > \$2%D'kp0' z checkLen*)ΪУ z $'checkLen'z z checkNum*e-ΪNumberУ z $'checkNum'z z checkVal*e-ΪֵУ z $'checkVal'z z checkInt*e-ΪֵУ z $'checkInt'z z checkTerm1e-"ǡ"Ϊ1' checkTerm'z z checkYesNo1e/"ǡ"Ϊ1' checkYesNo'z zcheckDiffName1e2ѼΪ1' checkDiffName'z zcheckDiffCode1e2ѼΪ1' checkDiffCode'z zcheckIDCardType1e4֤Ϊ1'checkIDCardType'z zcheckSqyyName1e2ԭΪ1' checkSqyyName'z z checkYear1e. У1' checkYear'z z checkYeare/ У1' checkYear'z z checkBirthdaye2 У1' checkBirthday'zk z_=================================1 ִеķǿУ==========================================ѴϢдб checkNullKT \ < >$'  < е Ϊգ'v')УʱдϢ vA@FRMsgBox "" & rgold.Row & "е" & Chr(10) & titleMsg & "Ϊգ"k \  < > vA@r'a=================================2 ִѧУ========================================== checkNameKT \ < >A@@ȥոķ < > \$2%D!~$'~ ~$'  < е ;дȷΪ֣ȴ1ܳ16ַ'v'%УʱдϢ vA@F%isValidateCount = isValidateCount + 1k \  < > vA@r'X================================= ִа༶ԺϵУ================================== checkCNameKT \ < >A@@ȥոķ  > \$2%D'Qȡбͷ ༶'d 'k ~ $'  < е ZдȷΪĸֻ֣ȴ1ܳ100ַҲַ'v'%УʱдϢ vA@Fk \  < > vA@r'Z================================= ִеijУ==========================================checkLenKT ~ $'  ,$'$ ` ΪDZΪ̶ȹ < е .дȷΪաд򳤶ȱΪ$ λ'v$ ed ΪDZΪȷΧ < е 4дȷΪաд򳤶ȱڵ$ λҲ$ λ'v$ ed ΪDZΪ̶ȹ < е &дȷΪգҳȱΪ$ λ'v$ ed ΪDZΪȷΧ < е ,дȷΪգҳȱڵ$ λҲ$ λ'vk'0УʱдϢ vA@Fk@ \  < > vA@r'h================================= ִеijУ飨Numberͣ==========================================checkNumKT ~ $'  ,$'$@ ΪDZΪ̶ȹ < е GдȷΪգдұΪ0λȲ$ λ'v$ ed ΪDZΪ̶ȹ < е ?дȷΪգұΪ0λȲ$ λ'vk'0УʱдϢ vA@Fkp \  < > vA@r'[=================================ִֵΧУ==========================================ѴϢдбcheckValKT ~ $'  ,$' < е $дȷΪ֣ڵ$ Ҳ$'v'-УʱдϢ vA@F& isValidateCount = isValidateCount + 1k \  < > vA@r'_=================================ִеΪֵУ==========================================ѴϢдбcheckIntKT ~ $'  ,$'$@ ΪDZΪ̶ȹ < е 8дȷΪգдΪڵ$ҳȲ$ λ'v$eEΪΪ̶ < е 0дȷΪգұΪڵ$ҳȲ$ λ'vk'0УʱдϢ vA@Fk \  < > vA@r'`================================= ִе֤У========================================== checkSfzjhKT \ <$'S ȡд ~$'~  < е &дȷ֤Ϊգ'v'0УʱдϢ vA@Fd"  ֤ ~ < е *дȷΪѧ֤ţ'v'4УʱдϢ vA@F$%isValidateCount = isValidateCount + 1d! ~ >$'S ֤У >֤У < е *дȷΪѧ֤ţ'v'8УʱдϢ vA@F(%isValidateCount = isValidateCount + 1d).֤ͨУ飬ԶɳںԱ ~ < >$'kkd ~$'  < е EдȷΪգҳȱڵ1λҲ18λ'v'8УʱдϢ vA@F(%isValidateCount = isValidateCount + 1kkk \  < > vA@r'X================================= ִ֤У================================== checkZjlxKT checkZjlx ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd89setDMBCode "checkZjlx", sheetIndex, rowIndex, columnIndexk \  < > vA@r'Z================================= ִѧŵУ==========================================checkXHKT ~$'  < е ]дȷΪգҳȱڵ1λҲ40λֺʹСĸдɣ'v'0УʱдϢ vA@Fkh \  < > vA@r'\================================= ִѧŵУ==========================================checkXJHKT ~$'  < е cдȷΪգΪճȱڵ1λҲ40λֺʹСĸдɣ'v'0УʱдϢ vA@Fk \  < > vA@r'\================================= ִпŵУ==========================================checkKSHKT ~$'  < е ]дȷΪգҳȱڵ1λҲ40λֺʹСĸдɣ'v'0УʱдϢ vA@FkP \  < > vA@r'[=================================ִпУ==========================================ѴϢдб checkBankKT ~$'  < е $дȷΪ֣ڵ$ Ҳ$'v'-УʱдϢ vA@Fk \  < > vA@r'W=================================ִУ==========================================ѴϢдб checkYearKT ~ $'  < е *дȷʽ20122002ȣ'v'-УʱдϢ vA@Fk( \  < > vA@r'W=================================ִѧУ==========================================ѴϢдбcheckXnKT ~$'  < е )дȷʽ2012-2013ȣ'v'-УʱдϢ vA@Fk \  < > vA@r'W=================================ִ·У==========================================ѴϢдб checkMonthKT ~$'  < е &дȷʽ0112ȣ'v'-УʱдϢ vA@Fk@ \  < > vA@r'g=================================3 ִеУ(DZ)==========================================ѴϢдб checkDateKT ~ $' 2Уʧ < е дȷдʽΪ"$xxxxxxxx"$ 20130221'v'-УʱдϢ vA@Fk` \  < > vA@r'g=================================ִеѧУ飨==========================================ѴϢдбcheckDateNecessaryKT& ~$' 2Уʧ < е дȷдʽΪ"$ xxxx-xx-xx"$ 2013-12-21'v'-УʱдϢ vA@Fk \  < > vA@r'g=================================ִеıҵУ飨==========================================ѴϢдб checkBirthdayKT! ~ $' 2Уʧ < е дȷдʽΪ"$xxxxxx"$ 201312'v'-УʱдϢ vA@Fk \  < > vA@r'J=================================10 У绰====================== checkPhoneKT ~$'  < е дȷдʽΪ"$-̶绰 ֻ"$ 'v'%УʱдϢ vA@Fk \  < > vA@r'L=================================checkOption У鱸ע ====================== checkOptionKT ~B$'  < е )дȷȲܳ200ַ'v'%УʱдϢ vA@Fk \  < > vA@r'\================================= ִ϶ѼУ================================== checkDiffNameKT checkDiffName ~ < >$'  < е дȷ'v'(УʱдϢ' vA@FdX=setDMBCode "checkDiffName", sheetIndex, rowIndex, columnIndex ~$1ͨУֵΪ'd'kk \  < > vA@r'd================================= ִ϶У(DZ)==========================================checkIdentityDateKT% ~ $' 2Уʧ < е дȷдʽΪ"$ xxxx-xx-xx"$ 2013-02-21'v'-УʱдϢ vA@F'd  ~$X$϶ȼΪգ϶Ϊլ'  ~$e](϶ȼƲΪգ϶ڲΪ'd8 < е vдȷ롰Ѽ϶ơͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơǷͨУ'v'0УʱдϢ' vA@F'k@k8 \  < > vA@r'd================================= ִ϶ԭУ(DZ)==========================================checkIdentityReasonKT'0,1,100' ~ $'  < е 6дȷȱڵ1λҲ100λ'v'0УʱдϢ vA@Fd   ~$r1϶ȼΪգ϶Ϊ,϶ԭΪ   ~$ew8϶ȼƲΪգ϶ڲΪգ϶ԭΪ   ~$e < е dдȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬'v'0УʱдϢ vA@F'd < е дȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơ϶ʱ䡱ǷͨУ'v'0УʱдϢ vA@F'kEkE \  < > vA@r'X================================= ִ֤У==================================checkIDCardTypeKTcheckIDCardType ~ < >$'  < е дȷ'v'(УʱдϢ vA@FdXD?setDMBCode "checkIDCardType", sheetIndex, rowIndex, columnIndexkD \  < > vA@r'T================================= ִУ==================================checkMZKTcheckMZ ~ < >$'  < е дȷ'v'(УʱдϢ vA@FdB8 setDMBCode "checkMZ", sheetIndex, rowIndex, columnIndexkxB \  < > vA@r'T================================= ִòУ================================== checkZZMMKT checkZZMM ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd(A9setDMBCode "checkZZMM", sheetIndex, rowIndex, columnIndexk@ \  < > vA@r'P================================= ִѧУ==================================checkXLKTcheckXL ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd?7setDMBCode "checkXL", sheetIndex, rowIndex, columnIndexkX? \  < > vA@r'T================================= ִѧϰУ================================== checkXXXSKT checkXXXS ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd>9setDMBCode "checkXXXS", sheetIndex, rowIndex, columnIndexk= \  < > vA@r'T================================= ִרҵУ================================== checkZYDLKT checkZYDL ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fdp<: setDMBCode "checkZYDL", sheetIndex, rowIndex, columnIndexk(< \  < > vA@r'T================================= ִѧУ================================== checkXSLXKT checkXSLX ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd:9setDMBCode "checkXSLX", sheetIndex, rowIndex, columnIndexk: \  < > vA@r'P================================= ִ꼶У==================================checkNJKTcheckNJ ~ < >$'  < е дȷ'v'(УʱдϢ vA@FdP98 setDMBCode "checkNJ", sheetIndex, rowIndex, columnIndexk9 \  < > vA@r'T================================= ִѧУУ================================== checkXXXZKT checkXXXZ ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd79setDMBCode "checkXXXZ", sheetIndex, rowIndex, columnIndexkp7 \  < > vA@r'P================================= ִѧУ==================================checkXZKTcheckXZ ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fk06 \  < > vA@r'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd4A setDMBCode "checkDisableType", sheetIndex, rowIndex, columnIndexk4 \  < > vA@r'T================================= ִвмУ==================================checkFamilyIncomeTypeKTcheckFamilyIncomeType ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd 3EsetDMBCode "checkFamilyIncomeType", sheetIndex, rowIndex, columnIndexk2 \  < > vA@r'v=================================14 checkGender ִǷΪСŮУ--================================== checkGenderKT checkGender ~ < >$' '-ԱдУ֤Ź < е дȷ'v'(УʱдϢ vA@Fd(1< setDMBCode "checkGender", sheetIndex, rowIndex, columnIndexk0 \  < > vA@r'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoKT checkYesNo ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fdh/:setDMBCode "checkYesNo", sheetIndex, rowIndex, columnIndexk / \  < > vA@r'u=================================14 checkYesNo ִǷΪǡУ--================================== checkSqyyNameKT checkSqyyName ~ < >$'  < е дȷ'v'(УʱдϢ vA@Fd- checkSqyyName \ < >A@kx- \  < > vA@r']=================================checkTerm ִѧУ--==================================r=================================checkAtLeastOneNNull ִһΪǿ--==================================checkAtLeastOneNNullKT  'A"ִ һǿУ ĵԪĿ ~$ ~=Ϲ  ~ ' > KTF  ~ ' KTF  ~ ' KTF  ~ ' KTF  ~ 'nH+dϹ  'F6ִ һǿУ ĵԪΪϹĿ    'k*'n*i*_--------------------------------------------ʽ------------------------------------- ]VBSCRIPT.REGEXP$.7RegExΪʽ (4 ȫֿvba\ת  (.ʽ (5ǷִСд ~ %'3 ִ.i8)-----------------------------------------------------------° Уظ˵Ѿûиʽ------------------------------------------------------------V-----------------------------------------------------------1ѧ׶ڱڲ(sheetѧ׶ A65535 $J%%!'*cna = getTotalColumnCount(sheetIndexValue) L$J!DB@1&ÿУظʱʱѴϢsheet,'NϢ¼ʼX==============================ѧ׶ڱڲ==================================0ðÿԪغ֮ǰнбȽ      $J%D'      $J%D'   .ѧͬ˵ظݹ  еݺ͵ ֤ظ!!!!'v vA@F*ѴϢ'k%%%ix%-----------------------------------------------------------һ ֵȡֵ------------------------------------------------------------ֵҵֵڵлkeyWord ҵĹؼ'kbn л ֵΪ rowrowH']the find result object   "  A1:A65535 \$2%%.  row !'d# !$'k#k#ix#------------------------------------------------------ ִڹУ(Ϊ)-------------------------------------------------------------value value1 cellУ鲻ȷfalseУȷtrue (0˵ΪDZ &$'z "k"k"]',ijһļ¼ A65535 0$J%%!'.B' 0 ~row$'*=ȡ  * .  0$J%D ~ , ',d !y!k!   * * ,   0$J%DX &X LжϹǷcell  0$J%D!~'2 2X < > 4 $J%D(~'y@ k8  #ʱcountĿΪùеĿi------------------------------------------------------ ִɾijһвexcelܱģ-------------------------------------------------------------sheetIndex rowNum к(1qaz: \$2B@8 . \$2%<B@>/ Ѹɾ- Worksheets(sheetIndex).Protect Password:=123i------------------------------------------------------ ָcellֵ-------------------------------------------------------------1qaz: \$2B@8 ~ < B \$2%D(~i------------------------------------------------------ ȡָcellֵ------------------------------------------------------------- < B \$2%D!~'i------------------------------------------------------ ִɾijһвexcelûб-------------------------------------------------------------sheetIndex rowNum кP . \$2%<B@>/ Ѹɾi------------------------------------------------------ ָcellֵ------------------------------------------------------------- 1qaz: \$2B@8 ~ < B \$2%D(~i------------------------------------------------------ ݴеֵǰʱѾͨУ飩------------------------------------------------------------- ]   < B \$J%D!~X '@',ijһļ¼ A65535 0$J%%!'.F 0 ~row$'*Aȡ  * .  0$J%D ~ , ',d yk   * * ,   0$J%D!~X '& & @X 1жϹǷcell  0$J%D!~'2 2X < B 4 \$J%D(~y8d0 < B 4 \$J%D(~k i------------------------------------------------------ ݴеֵǰʱѾͨУ飩------------------------------------------------------------------------------------------------------------------- ȥcellеĿո------------------------------------------------------------- ] Ԫ]  3Blength1ʾcellԭijȣlength2ʾִȥոַ'ĬΪûȥո2 Worksheets(sheetIndex).Unprotect Password:="1qaz" < B \$2%D!~'& &'H HGzj*"ԪΪգȥո & 'J%length2Ϊոһγֵλ Jַո & $L'& &X < B \$2%D(~'ki------------------------------------------------------ ȡָcodeֵ-------------------------------------------------------------Attribute VB_Name = "ߺ" '-%УдϢʾ ע&( Function checkedRequiredStart(rowIndex, column ) { 'ԪDim cellValue As Sng= A;veSheet.Cs6If-" Then*F_FalseETrund If E)[дՀ־ ¼oBoһkqmwriteLog(cont8ent]iXs(XmsgB)[curMsgRow, 1)JCK + 1?D Dúɫ,CE ERedVFnLen7@LZ.Characters(1D, ).F7.`Colorl31*SS Ȫʼ` errafoaddCommQXQ#s|", ,  0tA'Works().Unprotect Password:="1qazey.A ( ..Itrior#=<65535 '1ɫ>% d/.VisiblAЇĠ_?ɾEClearsCk΅"BB ?+0+ 5`&[*2Recp)Num A:HtffTotal`?um u\4&UE15l lqXOO .ExlNondu?(u_L?%K (Ƿ4*õķo)beginC_c#LHGpMethodLLuwLЋNot3 'aaWʧ|u'46 IsB hing4жϑ<Ϊw?d\ W MAO@' 'ȥ§4 'cDt à 'L a'//O O25/<' #Box "" &D& "ʀi6$ɹq1!!&ʱđQ ' z r'Qemo pac0eFla(10qո,|ʾ/&S)XУַChr(34) Ct& w"а ͳԶ Ϊ%˻< 'A/ '!qL/Z/ݱʶ@XӦ#Y([)O-O@Uдб Function callXQStart(typeVal, sheetInde@x, row$c olumnisRidateCount) value = Works().Cells(UDtitleMTsgGsT,, ) 'б̀If 0"" Then 'Ϊϲxеn/J - 1 L(ElseDtheadG=! ;CEnd IffDArgs!"0"JÅ Like "checkLen*MУGĄ Mid9& #EH%O H&NumL&@ber&& &@&&ֵLC&M%@b%Inta9?nE9- 'AW9Term1L"ǡ" L"1? 7 YesNo -kk ? DiffNameѼa?%D~ CodslA! `IDCardT*'֤Ͷ;:`._CSqyy;ɀԭ;Q0] e? !WYearZ?M`?:]  :iX}/ E/ ar)   BirthdayLڏA_ _ ] Select Caselp '=!21 ִǿq ?ѴϢG aNull MethodXQ@Requiredxp Not ATerrorӪ"`" &V"!f& "Ϊգ/0hasE`TrA 'qȱ% fwriteLo\g E ' Box 5 gold.RowO & Chr(10) = T)beginC_commentjɊ ,?isFo^r.o+.2.р/?_Ky-{O removeSpa+|I+H~Len/`'S@R/OS _ArS plit(, x","b  (D0)J0 A?UBound "1Bi 'MΪDZ[Ϊ̶a2JMppaΪաsaswm1)|λoh''2'Χ''ߗƗ'£v(LMr(2oHsP(s*1*j****&vbq`q*^)5w)Nm __=rr=)=)__u>>>N{{ң{ >0λHfgNS SSSsS___ oooof0/~m> End If 8hasError = True 'УʱдϢwriteLog eRMsg2beginCheck_comment sheetIndex, cMethodX@Q, row o0lumnCisBF} '=ֵxā.Bдб틑Case "oVal" |mE (value, functionArgs)NFIf NotQ Then  IArSplit(, ","f0"" &Fp"еtitle@дȷΪ֣0ڵL*(0)AҲ1^?A.́ ' isidate(Cou c=.+ 179uoncknVmiamΪֵmm/mIntw>n n nU@go _d= 01b '!kΪDZΪۄ_}_}C}(!DD{W2BλElse)1) *)'m)sgS@o_T^(oTwo OIoWW dSSOTkO ST֤_{>RSfzjhR resZjlxJgetC(ellPku#kXQ(4) 'ȡ>F)BTrim/X W ""9/*O7 5U͢7_Fo/o/o/o/o/NO P?/Qѧ _`???/ ' OݑIsIDNumbercgN>H%_ ;ˁucA?$?$?$?$?$?$?$$p$Ϣ $writeLog errorMsg''isValidateCou nt = "+ 1#OElse '֤ͨУ飬Զ@Ա'checkMeth0odXQSIdNumLink(value, rowIndex, column)_nd If}E$&?S`FZJLXC>8I@f Not Txhen!"Ř`"`" &\"еtit le@дȷΪգȱڵ1λ18@ "g*hasE@*Tru偣ʱдځEڇ ?Lg?&I  7 b eginCAx_comme sheetu{x,ߛ`For= '=A ִ㔼`C=)Ca"bjZj,lx4Tkn=cpDMB((, Ę1?; z`xxrpp ۃ'set-Code j. QZb]g]is.+.ѧŵğO..XH.P.{Sjj~j\-i<& iiii40iֺʹСĀдk O2jj2#'-?.. o]4._o.+..ϏK]XJ...1...?,..sߘؘO/O/A^ O/O/O/nO/O/&O/O/O/O/O/O/+B/O/O/$^KSO/ _/?^O/O/oO/O/O/O/... ...ڳ writeLog errorMsg  B@End If>beginCheck_comment sheetIndex, cMethodXQ , rowolumn isFor = Tru e '=ִпУ.ѴЀϢдб틁Case "oBank"|\(va0lue)If Not Th]a]3]Ye B Ao,Birthday,/O-t- 'QuʧJYE!-oo`&!.ΪChr(34xl A\0221߰;11111[1111111,41ѧ!a111 1Necessary/2 C/2(2&__ ) If Not checkMethodXQ Then 'Уʧ errorMsg = "" & rowIndex"е title-& "д ʽΪ%Chr(34)@x-xx  2013-12-21첄"hasEXWTrue '(u(дϢ$write0Log End IfbeginC_comment sheet,, `olumn?isFort '=ִko@Pдб?Case "Birthdapy" 'Hś=GE(value, functionArgs)?I`@ZSxx9U12?_ ?_:?c?c?c.?c]10 ᄵ绰 gN[PhoneRZNumCZXW]S-̶# ֻ$/V;?=RRQPPPPsJE OpBQע sP(f`LU66(0m(?A(aȲܳ200ַ_PF%9%% %%SV_[N`c=$ ϶ѼO&HPDiffNamP "'֨}0DMB(#, ~1o*_SD S****OO?9)))Lsys!iculty GradeFlaq0?O-O-0ElseOE'setCod? u0Trip"xͨ1)ֵΪ|uq1u2ouOA C OCOCOCOR ?Bu(ǁ>)oxCId`ityDatexD8B//DDD?D//0'"02-21"  hasError = True 'ʱд ϢwriteLog eOMsg/indentifyDa@teFlag0!3ElseQIf sysDifficultyGr@adeNam.1 Andrim(@value)8"" Then 'u϶ȼΪ Հҁ ?i1k\"2\<> ] /C/2/A\" & rowIx"titleдȷ롰Ѽfjͬdʱ>=ͨEǷ ]z?checkMethodXQIFa^A`n jEfIf<@beginC!_comm} shHeet>, j,BolumnqisFƖ?  '= ִBLԭH(DZ)> Case "BIŸtyReason" 'O0functionArgsAh0,1,100T+@HLen#, ) )NotK5We_~_~ȁ{ڵ 1λ@ d_v oF_Cײ˟Om-Em,-SoF loxl = onon ]    4 (` `0 Or O )/{o4sssssʱtsStߥ O7?O7߭Pu  m] //, Ś[ OBր́M,DCardType aDMB(, , 1r`o7@6666to.o.o.L--!F'setPCod&³SumnIndex End IflbeginCheck_comment sheet, c2MethodXQ , row0ol, errorMsgbisFor = True!! '= У1= ACase "bZ"  qSDMB(, value, 1),If Not ThenHC"" &"еʀ `title д첆;hasElAe 'XʱдϢ*writeLog Els}' set@[CodHj, R%U(Bò!ZZMM]XQ ]"]cL9`]ol]]] ]] ]] ']d.ɮ?^(?^ __==¼ѧ^OHXL^^_^_^_o_ _g-///^/^//'/0' 0k0exWQ0J/|ϰ{/XXS/ B^)='X0 OO 6ODO_NO&0O0000 '2o.o_T..00000Ͼ60,0רҵ00//ZYD` 0000oI000SV00ooo000* o 0#0kT0000'0000060 O`--D` 0 8 'Ϲ85qtotalB3+Select~ "H%OIb@aojiaoBC:iS"? _ huoshi H?   zhusu G?  others H   Sc*'?%] '2?3>pG>6+ n1 'ִ һǿУ ĵԪϹ atLeaError = + titleMsg + " "End DIfisFTTrue!1Sel ect  Function '-(" 5 re@gCheck(, value")dDimEX As ObjXSet= C reate("VBSCRIPT.REGEXP")'RegExΪZ6@EX.Glob '0Ѹ' Ŕ9P8123eue@ָ@alֵ`XsetCellV alueCXQ [j, colDv _`$b).?WQ ȡWX?Wp g+ SA#t-&%I wûС oNoomV>}˩v v!(v?v e?v?vow?vd 8=1 ݴ րƀֵǰʱaѾͨУS/Code(y"+, _=2DimlData1UdeWUX@ H?CStr(Ssn?cZRH]H0 '}Qļ¼WopArea ).Range("A65535").2(xlUpow 'ЎGetP7OrCd(,S*, "") 'QY! 0G i0Tod'If _ `).c`i, 1)`R TheRHes+ 1+Els~ 1EBiQ j^ + -q 1I"}j, 3!A1() 'жArǷ!ȋ5qc2, 2 $Y)' 7 +umnPlusV H26OOqO & ue "dY#qULUU@VU_?A` 'Ŀ|_]removeSpa|ceu%x#a]3As Zing 'Ԫ7-len gth1 Integer, 328 'tԭȣaַaw &FaKaΪQ&R?=+DX?1>@4 LenSw1K0J; 'Ϊ/qW2Inwqwc i iaһγֵλAܰ If length2 <> 0 Then 'ַ0 value1 = Replace( , " "")dWorksheets( Index).Cell s(row, 8colRbCS tr_VremoveSpXQ-True|End If Function  '-2 ȡָcodeֵ3#DZi~xME(6 << ` X I\ xI< I> `@ ```k(  I~ @ `k I~ I @ `kh .I~ @ +`  <iiB`H`H``` @`   UI~ @ `   aI~ @ `` (  mI~ @ `  yI~ I @  ` h I~ @ 0 `  I~ @  `  I~ @ P `  I~ @  `  I~ @ @  ` P I& p I  D( `  I&  I   `  I&  I  X `  I~ 8 I   ` I~  I   ` H %I~ h I   ` &&7I~  I   ` x  ]I~ @ (`   iI~  `   rI~ @ H`   ~I~ @ `   I~ @ ` 0 %%I PI< pIB ` ` `J````@ ` @ ` @  `  @ ` 8 I XI< xIB ` `@ p`@k8  I~ @ `   I~ @ ` X  I~ @ `k I~ I @ ( H`` (X @ 0pP 8%8XH0@ @ @ (Hh8P@ (@ @ h X p8@ H @ @ @(x@X@ h@@ @ @ xx@ x@ @ @  1@n [$*\Rffff*0B5b1e869a$*\Rffff*0>5b1e8699  B       (  B "2 0 8@H P XB  " " (0 8@H P&2(8 @HP X `B  2@P X`h p nx  B  ,($X"H    "8` "4 @ H   B ( 0 8 X h p x    0 B H P 6X       | H h B   0       x p  B        8HPX`h xp  B  (0P`hpx |  (B @H$Px | 0 PB hpfx |  B  ( 0  B :P`x    p B        .B     (0 8 .B   0@HPX` hB  &(PX`hDp4 (HPX`h pB  &0X`hp x ( " D4P  B    "0 8 <@  B PXp x&  "  (  $0  "X            ! !> ! `!4! ! !! !! ! h" "B """"""""" # # #B ## # ### $ $ $B $$ $$%%% %(% 0% % %B &&&(&8&@&H&P&X& `& & 'B 0'8'@'`'p'x'''' ' H( h(B ( &( $( ( (&)*0)"`)$))())*8*X*h*p* * 2* *"* +@+  H+`+x+(+++ + h, ,B ,,,$,, - "-8-"@-h-p-x-  - . (.B @.H.P.2p.. ... . . (/ H/B `/h/,p/////// |/ X0 x0B 000000000 0 1 1B 1 "1 "11  12 2  22 24(2 "`2p28x22 222 22-----------------------------------------1 ,дϢʾ Ϣsheet--------------------------------------- ʱ0 Ϊʱ1 Ԫ] < > \$2%D'@ @'d'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseʽȷtrue]H^[\u4e00-\ue863]{1,16}$'  ~$'d'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------` ~ ,ΪDZ'd'kzk]reg = "^((19)|(20))\d{2}-((((0?[13578])|(1[02]))-((0?[1-9])|([12][0-9])|(3[01])))|(((0?[469])|(11))-((0?[1-9])|([12][0-9])|(30)))|((0?2)-((0?[1-9])|([12][0-9]))))$"^\b[1-3]\d{3}(0[1-9]|1[0-2])$'  ~$'d'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------] reg = "^((19)|(20))\d{2}-((((0[13578])|(1[02]))-((0[1-9])|([12][0-9])|(3[01])))|(((0[469])|(11))-((0[1-9])|([12][0-9])|(30)))|((02)-((0[1-9])|([12][0-9]))))$"^((19)|(20))\d{2}((((0[13578])|(1[02]))((0[1-9])|([12][0-9])|(3[01])))|(((0[469])|(11))((0[1-9])|([12][0-9])|(30)))|((02)((0[1-9])|([12][0-9]))))$'  ~$'d'kih-----------------------------------------4 У֤---------------------------------------Ϲ򷵻trueϹ򷵻false]7905842163790584280Ȩ] 10X98765432P0У $$''ȥո]h B f 6)׶֤Ϊ,ΪͨУ'z(k Gzj $$Gzj *[0-9X]Gzj   $' G 'j   $  '  ' $   $G'ji8----------------------------------------5 -УѧУѧУʶ 42λһλΪֻx-------------------------------------------------------------ʽȷfalseʽȷtrue](^[1-9]\d{40}[\dx]$'  ~$'d'kiz----------------------------------------6 -У黧 -------------------------------------------------------------ʽȷfalseʽȷtrue@].^(\u519c\u6751)|(\u53bf\u9547)|(\u57ce\u5e02)$'  ~$'d'kiu-----------------------------------------7 Уѧʱ-------------------------------------------------------------ʽȷfalseʽȷtrue]H'^(((19)|(20))\d{2})((0[0-9])|(1[0-2]))$'  ~$'d'kiq-----------------------------------------7 У-------------------------------------------------------------ʽȷfalseʽȷtrue` ~ ,ΪDZ'd'kzxkp]^((19\d{2})|(2\d{3}))$'  ~$'d('kiq-----------------------------------------7 У·-------------------------------------------------------------ʽȷfalseʽȷtrue]^((0[0-9])|(1[0-2]))$'  ~$'d'kiv-----------------------------------------9 Уѧ-------------------------------------------------------------ʽȷfalseʽȷtrue]^\d{4}[0-7]\d{3}[0-3]\d{7}$'  ~$'dh'kXiPv-----------------------------------------10 У绰-------------------------------------------------------------ʽȷfalseʽȷtrue0]^\b((1(([38]\d)|(4[57])|(5[0-35-9]))\d{8})|(0((10)|(2[\d]))-[2-9]\d*)|(0[3-9]\d{2}-[2-9]\d*))\b'  ~$'d'kiv-----------------------------------------11 Уп-------------------------------------------------------------ʽȷfalseʽȷtrue]8^[1-9]\d{14,20}$'  ~$'d 'k i -----------------------------------------checkXn Уѧ磨2012-2013-------------------------------------------------------------ʽȷfalseʽȷtrueP]]1^(20\d{2}-20\d{2})|(19\d{2}-19\d{2})|(1999-2000)$'  ~$ ~-$'$$ 'dX 'kH d@ 'k0 i( -----------------------------------------checkOption У鱸ע磨Сvalue2-------------------------------------------------------------ȲС200false 򷵻true &'z0 k( &  'd 'k i ------------------------------------------------------ȽϴС(Сڵڷtrue)----------------------------------------------------------------'value1value2false 򷵻true &X'& X' &  'Dd 'Dk i ------------------------------------------------------ȽϴС(Сڵڷtrue)-dec---------------------------------------------------------------'value1value2false 򷵻true( &$4'& $4' &  'd'ki}------------------------------------------------------У鳤--------------------------------------------------------------- ,$'' ~$/ΪDZ'kzk ,-±0ʼֵΪָάõ± ~$$4 ~$$4'zkd ˵У̶ ~$$4'zkki}------------------------------------------------------У---------------------------------------------------------------X ,$'' ~$/ΪDZ'kzk ~$& Ϊz` ~.e+Сz0 ~$4e% С0zk ,-±0ʼֵΪָάõ± ~$$4 ~$$4'zhk`d ˵У̶ ~$$4'zkki------------------------------------------------------УֵΧ--------------------------------------------------------------- ,$'' ~'z(k  ~$) Ϊz ~$4e) С0zk ~$4$$4 ~$4$$4'zpkhi`------------------------------------------------------Уֳ(Number,ΪҲΪСС0)--------------------------------------------------------------- ,$'' ~$/ΪDZ'k@z8k0 ~$% Ϊz ~$4e% С0zk$'+󳤶$'.Сλ ~.''' "˵ûС ~$4' $$4'zk d С ~ ~. $'DԪֵλ ~ ~. $' $$4 $$4'z8 k0 k( i -----------------------------------------checkIsInt У鲻С0-------------------------------------------------------------ʽȷfalseʽȷtrue ] ^0|[1-9]\d*$'  ~$'d'ki-----------------------------------------checkIsNumber УΪNumber-------------------------------------------------------------ʽȷfalseʽȷtrue ' ~$'ki-----------------------------------------checkMoney У0-9999-------------------------------------------------------------ʽȷfalseʽȷtrue(]^(([1-9](\d{0,3})|0)|0)$'  ~$'d'ki-----------------------------------------checkMoneyTJ У0-9999Сһλ-------------------------------------------------------------ʽȷfalseʽȷtrue]0^([1-9]\d{0,7})$'  ~$'d'ki-----------------------------------------checkPersonNum У׶԰һ------------------------------------------------------------ʽȷfalseʽȷtrueH]^(([1-9]\d{0,3}))$'  ~$'d'kpih-----------------------------------------checkIdNumLink У֤ԱͳûдǷһ------------------------------------------------------------ʽȷfalseʽȷtrue If colIndex = jhrIDColumn Then checkIdNumLink = True Exit Function End If]%Ա֤ǷӦ]$ں֤ǷӦ]ڵһγֵ±]"Ա,Ԫ֮ڵ]$ݺŽȡ]!,Ԫ֮ڵ] "ݺŽȡ]8P#]h%·]] $' $'  (ڶλΪΪ < r T$J,DdڶλΪżΪŮŮ < r T$J,Dk $' $' $'     < v T$J,D'i8-----------------------------------------checkxzandxl УдѧǷдѧǺ------------------------------------------------------------ǺϷfalse ǺϷtrue]дѧǷдѧǺ]ѧ,Ԫд]  < t T$J,Dd < t T$J,Dk'i-----------------------------------------У鿼šѧšѧ -------------------------------------------------------------ʽȷfalseʽȷtrue]X^[a-z|A-Z|0-9]{1,40}$'  ~$'dp'k`iXz-----------------------------------------У֤ -------------------------------------------------------------ʽȷfalseʽȷtruep]$^[\u4e00-\ue863a-z|A-Z|0-9]{1,18}$'  ~$'d@'k0i(v-----------------------------------------Уѧš -------------------------------------------------------------ʽȷfalseʽȷtrue]x^[a-z|A-Z|0-9]{0,40}$'  ~$'d 'ki-----------------------------------------2 УԺϵơ༶꼶-------------------------------------------------------------ʽȷfalseʽȷtrue ~ (ΪDZ'd'kzk](+^[a-zA-Z0-9\u4e00-\ue863\(\)\\]{1,100}$' ~'  ~$e'dh'kXiPH[Attribute VB_Name = "У麯" '-%1 ,дϢ ʾ sh`eet$ʱ0! Ϊ1 Function checkRequired(bIndex, row coluDmn ) 'ԪDim cellValu@e As Sng= Work5s8).C s(;If2" Then0K gFalseE{Trund If E-2"ѧ ҪΪ8& !ʽȷuf7'At1wStu(vgDplreh @"^[\u4e00-\ue863]{1,16}$5@_@ CA(, aBW Wa k 18twN ot p eric(Mid, 1 7@ %Like "*j,X]o For= 1 To 17CTqWńԁ]111sps( + ; i! * TNexts Mod 1@Right)c, Tm3 [;53-!P0ʶ 42λһΠx?BAQSc`hCode1P 40}[\dx]kB߂&Ykg_Y/\Yo_6 " ___ckFamT2!VL ?#Q5 뷅 qg`OȽ С()s &B  !*compa6r! #!CIn=1h#2"Y%%I t  compare = TrueEnd If Function '-2Ƚϴ(СڵȀڷto)-dec3S5value1 2^false )m  {Dec(, )[ C 2 2If(1 >- The1%FZ€a^XУ鳤>h]heckLDen], fDArgsNArr@9Split(, "," c QEb@""aQ (0) 0 'ΪDZdfH emxxit H (UBoundAG*2*±0ʼֵΪָõx F4)0 >= _#1)X) AH( E3' (E'˵\̶\s! H!? * y%#?:鮡tInt"c&b+@ v^k# = O`oK o6`Ws= a0߿-p?Ps?P?P?P?P7pX??Pg1(?P ?P?P h,O$? ?PONB?P?Ph?P?P?+ ?PK1PֵΧ}PValPPq0P`2T'1=AJeJJoQ2EQ7 KE/# )L?@=0tN?OEy_ 5q?/*-s/ֱ(fber,Ϊ Ҳaa)o1P111 110'K?6k^0 7r7*en 'Ϊ Exit FunctionhElseIf CDec(value) <= 0 ThС0#nd If *maxIntLL= f}ArgsArr(1) '󳤶=Double@2@СB>λ iCe! (, s*= i_F0k.?.e%`yHber.Ϊ8*_.0s.g#. = h @-Is@eriK,,C (BMoney "(0-9_%8((?W(("W(\d{0,3})|0!_,k_,} *C_,6E_, '_,--TJ=#tһλ?D,ckTJ]D7})??D.N_40qD?rPersonp6׶ɀһooov ߏ01ck/1o1o1'IdLinkԱͳûдʀǷһOooo` (, rowIndex, covlw'f /jhrIDColumnl' Fj2!vo521isGe rRight As BooleaCEϡӦSBirth/+len@ʦ2eg|'qһγֵ±=[gb c` in(g 'Q ,tĀڵݟ4er1J ȡom bqe?a" year, QBVariant '1l month, bday, @arr;1'QT.17,Z7Y= (80АZMod 211 'ڶ0Ϊ@ ѳ2  8Sh@eets(sIndexValue1).Cell s(rowT, ge:rColumn) = ""Else 'λΪż@$IyŮ ynd8 If^g yearXMid(birthq, 1, 4)month5, 2day7&I')W+ G+  RcheckIdNumLinkCTrue EFunctio`n '-%xzandxl Удѧ8Ǻ& %fa@[@t10 %($XLBl, Gcol¥eDim isXZRight As Boolean '3UA XZString '@,ԪCbG arrCI f )e"" The@c'C &xzHǽ܄3| Gh/4L @7A$Jšѧy#8ʽJe1KS(vGreg)7^[a-z|A-Z|0-9]{1,40}$/ =CqU(, *> XSF(6"-Fa"_z3#-֤a x(_,y,FZJLX V- 'c-\u4e00-\ue86H3L/18_/e)R//0 !%$0]_0 _0U01?]0..u0S1.ok2"kԺơ༶jEAkCName, fxArgsArrFCB"b]Q" 0- 'ΪDZ_sRBB@ GJaSExit siu=f>&UU>\(\)\\qV10VT O T`ZgZrZOZkE++Root Entry0j.:@QWorkbook/ OlePres000~_VBA_PROJECT_CUR"0ShowForm VBFramef&CompObjaoPrintForm- VBFramef &CompObj ao PROJECTVBA!dir [__SRP_b2j__SRP_c4__SRP_d;j__SRP_e|Xfl__SRP_a=Sheet1+D__SRP_fWX ThisWorkbook$}Sheet6Sheet5ShowForm__SRP_2#PrintForm__SRP_3__SRP_4~__SRP_5 &__SRP_02__SRP_1"V_VBA_PROJECT4;N z^6__SRP_6'-Ou__SRP_7(__SRP_8)__SRP_9"j]wQQpe %h[!hQpe ,ȁSbpSȉ *$;PROJECTwm5Ole 9CompObj.:hSummaryInformation(1<DocumentSummaryInformation8@VERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} ShowForm Caption = "UserForm1" ClientHeight = 3180 ClientLeft = 45 ClientTop = 375 ClientWidth = 4710 StartUpPosition = 1 ' End  }t  Microsoft Forms 2.0 Embedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} PrintForm Caption = "UserForm1" ClientHeight = 3180 ClientLeft = 45 ClientTop = 375 ClientWidth = 4710 StartUpPosition = 1 ' End  }t  Microsoft Forms 2.0 Embedded Object9qID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=ߺ Module= Module=У麯 Module= Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} BaseClass=ShowForm Module=ӡԤ BaseClass=PrintForm Document=Sheet5/&H00000000 Document=Sheet6/&H00000000 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="898B2533293329372D372D" DPB="1210BE355A525A52A5AE5B528A333A1A93980024C3DB288437A711B23CB4B664FE802EFDD5" GC="9B9937CCC1CDC1CD3E" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C ߺ=104, 104, 872, 528, Z =0, 0, 0, 0, C У麯=52, 52, 820, 476, =0, 0, 0, 0, C ShowForm=0, 0, 0, 0, C, 26, 26, 1150, 503, C ӡԤ=78, 78, 846, 502, C PrintForm=0, 0, 0, 0, C, 52, 52, 1176, 529, C Sheet5=0, 0, 0, 0, C Sheet6=0, 0, 0, 0, C W0* pHd VBAProject4@j = r n [ J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\Syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE15\MSO.0DLL#M 1@5.0 Ob LibraryKMSForms>SFrms3D452EE1-E08F`A-8-02608C@4D0BB4 SINDOWS\sSFM20L'B _&/;"1jIqAHq00}#:0Bq# 50 A122AF265-4027-477C-B7E4-C100DD323ADC6Users\lenovo\AppData\Local\Tem`p\VBEb7.xexdc`aOOb5zL#xME(SLSS<N0{00020819-0000-0000-C000-000000000046}H 0%@88n [xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Z#puJݞ! F ]nHJ~!q"x ]nHJ~!q"uJݞ!ME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0%@p%,%Hx@x8n [$*\Rffff*0A5b1e8699`xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Zh#pM0A π Fn1`6d5F3vuxn1`6d5F3vuM0A πME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0%@p%r%Hx@x8n [$*\Rffff*0@5b1e8699` xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 LqnxME(SPSSS0{2D42E31A-4DC0-40F6-90D6-176EAF9A5791}{D46D4C45-5583-4E5F-AC01-BA9C454710D8}8 jX n %%XX n [ " 0 8"HP Xh xȡ'p B@loHȷX p'p B@loQAttribute VB_Name = "ShowForm"  Bas|0{2D42E31A-4DC0-40F6-90D6-176EAF9A5791}{D46D4C45-5583-4E5F-AC01-BA9*4710D8} dGlobalSpacoFalse CreatablPredeclaIdTru BExpo se0TemplateDerivCustomizD'ȡ P Sub CancelButton_Click() notContinueBoolT Me.HDidZEnd! 'ȷq ,onfՏ,-Fl;/^LeʘxME(SPSSS0{CD51E109-0E53-45AC-BCF6-B27CB188E893}{2E3C305E-F6A5-4FE5-B359-3617869BA120}x8 0%h8%8pn [xAttribute VB_Name = "PrintForm" " Bas0{CD51E109-0E53-45AC-BCF6-B27CB188E893}{2E3C305E-F6A5-4FE5-B359-3617869BA120} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizDrU@@@8`8a`brU@@@@~xbrU@@@brU@@@~z   rowIndex columnIndexcontent sheetIndex errorInfo checkMethoderrorMsgtypeValisValidateCountregvalue sheetIndex2keyWordkbnvalue1flagrowNumcolIndex QA#functionArgsArrvalue2IDNumber functionArgsIdNumXLValuejrU@@@P`OO@`P@1`P``1aOOOOXq ` 1OOOh! `1OOOOOh `1OOOOOP`AaOO@A`OX ` 1h `aOOOOOP `11OO`A `1QaOOOOX ` 1QOOOPQ`11OO``1QaOOOO`q!`a1QOOOOXA#` 1QOOObrU@@@8 0a'''1'`A#q#DrU@@@xbxMEh 0Xn ["  ( Hh xѧϢӡģ$2(4ѧϢӡģ$2B@6ѧϢӡģ$2(4oAttribute VB_Name = "Ԥ" Sub Browse_Print () Worksheets("ѧϢlģ").VisiblaTrue"d^P@review2cEHnd ThisWorkbookThisWorkbookSheet1Sheet1ߺ]wQQpeXfУ麯!hQpe;N z^ShowFormShowFormӡԤSbpSȉPrintFormPrintFormSheet5Sheet5Sheet6Sheet6 FMicrosoft Excel 2003 Biff8Excel.Sheet.89q Oh+'0@HTd | lenovoMicrosoft Excel@&@ ՜.+,0HP X`hp x  УרѧϢ¼ Ϣ  !"#$%&'()*+,-./01356789:<>?@ABCEFGHIJKLMNOPQRSTUVXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|~      !#%&'()*+,-./01234678;=>?ABCD  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}      !"#$%&'()*+,./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefgijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,./0123456789;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abdeghij