ࡱ> ybtc  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`akdefghijlrmnopqsuBvx{|}~Root Entry FS@R]g]u^Workbook0~Ole 2_VBA_PROJECT_CUR"$Pf,f  !"#$%&'()*+,-./013456789:;<=>@BCDEFGHIJKLMNOPQRSTUVWXYZ[\]_`abdeghijklmnopqrstuvwyz{}t6DD zL#< &Iq\ OFg_KM}tFp5xg_KM}tFp5 &Iq\ OME(SLSS6" \pDELL Ba= ThisWorkbook=98X@"1r[SO1r[SO1r[SO1r[SO1r[SO1r[SO1r[SO1rArial1r[SO1h>r[SO1,>r[SO1>r[SO1@r[SO1r[SO10r[SO1r[SO1r[SO1r[SO1rArial1Qr[SO1r[SO1r[SO1r[SO1r[SO1 r[SO1r[SO1 r[SO1@r[SO1r[SO1r[SO1r[SO1@r[SO1r[SO1 r[SO1r[SO1 r[SO1>r[SO1r[SO1 r[SO1r[SO1r[SO14r[SO1 r[SO1r[SO1 r[SO14r[SO1<r[SO1?r[SO1>r[SO1r[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_                 # # # # # # # # # # # # $ $ $ $ $ $      P %P      & # #  ' ( )a   *  +ff , - .`   $ $ $ $ $ $ / 0 1  2    ""@ @ @ @ @ @ @ @ @ @ !@ @ ""@ @  @ @  1@ @  1@ @  1 1 1  1 1 1 #1 1@ @ 1 1@ @ 1@  1@  1 1@ @  @ @ 1 1 1 1@ @  1@ @  x@ @ 7  x@ @ , x@ @ ,  1@ @ 1 1@ @ 1@ @ 1 1  , 1@ @ 1@ @ !1@ @ !1 1 1|@  1 1  1|@ @ 7 1<@ @  1|7 1@ @ "1@  @ @ 1@ @  1 1 1 ||~^R}-} 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?_)[$ -}-}. ?_)}}}1 }?_)[$ -##0.  }}2 ?_)[$ -???##0.??? ??? ???}-}3 ?_)}-}4 ?_)}A}5 }?_)[$ -}-}8 ?_)}A}9 ?_)[$ -}A}: ?_)[$ -}-}; ?_)}A}< ?_)[$ -}A}= ?_) [$ -}A}> e?_)[$ -}}}? ????_)???[$ -???##0. ??? ???}}@ ??v?_)̙[$ -##0.  }(}A  ?_)}x}B?_)̙[$##  }-}J ?_)}-}L ?_)}-}M ?_)}-}N ?_)}-}O ?_)}-}P ?_)}-}Q ?_)}-}S ?_)}-}T ?_)}-}U ?_)}-}Y ?_)}-}[ ?_)}-}\ ?_)}-}_ ?_)}-}a ?_)}-}i ?_)}-}j ?_)}-}r ?_)}-}s ?_)}-}z ?_)}-}{ ?_)}-}| ?_)}-}} ?_)!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 1C40% - :_eW[r 1 %!40% - :_eW[r 2O#40% - :_eW[r 2 L湸 %!40% - :_eW[r 3C'40% - :_eW[r 3 %!40% - :_eW[r 4C+40% - :_eW[r 4 %!40% - :_eW[r 5O/40% - :_eW[r 5 L %!40% - :_eW[r 6C340% - :_eW[r 6 %!60% - :_eW[r 1C 60% - :_eW[r 1 %!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 #hh $h 1h 1 %h 21h 2%? &h 3h 3 'h 4h 4(]5]  %+8^ĉ %)8^ĉ 1218^ĉ 12 % *8^ĉ 2/8^ĉ 2 %+ 8^ĉ_hQVL?e:SRNx,(c  -}Y5}Y  a% .Gl;`+Gl;` %/'^0 '^[0] 1{c{ }% 2hgUSCQ-N7-N  e% ?QcQ ???%????????? ??? @eQoeQ ̙ ??v% A 0 ]vc   Blʑ^ lʑ  XTableStyleMedium9PivotStyleLight1683ffff̙̙3f3fff3f3f33333f33333\`"+a ؚ!h,gNy[^~NmOo`U_eQZNxhOo`VV!  =- KmՋ@b g!hĉRv^SbpSOo`gffl@F>xMOhS AA@A@   1 71 xm 7sfzjh 7 familyMembers suortMembersfamilyYearIncomedisasterDescribe burstDescribe 7poorStudentEntryfamilyDebtAmountfamilyDebtReason checkDiffName[V~+R Ty checkSqyyCode3ut1uxkuNOO checkSqyyName3ut1u Ty checkYesNo 7 checkGender 7 checkYesNo checkSfzjhel T 7^S/f 7 Ty 7{|W 7/f/f 7&T 7sY 77u 7'`+R7u 7vQN 7e 7USN 7d[?Q 7pXP[sY 7QQgNO 7Vu 7V~p 7mQNN 7SkX /f b &T ^_kXy 7 checkNum0,6,2 Y T 71 7[e[SVclassIdentifyReasongradeIdentifyReasons~[at^~[acheckLen0,1,33[V~+R Ty 7sysDifficultyGradeName 7 indentifyDate 7indentifyReason 7 checkDiffName 7yr+RV 7V 7N,V 7 NV 7TyYgkXQ R [e 0 [SV _N_{ TekXQN TeǏ!h0kXQ[vVI{~ S/f yr+RV  V  N,V  NV -NvvQ-NN*N ^_kXy 7/f&TNOO 7/f&Td[?Q 7/f&TUSN[^P[sY 7/f&TkuNP[sY 7,gN/f&Tku 7 /f&T6rk'N1YRRR 7 /f&T[-N g'Yu` 7/f&TNO6eeQ[^ 7 /f&TQp^\bObP[sY 7[^NGWt^6eeQ 7 [^/f&TmS6q~p[ 7 6q~p[wQSO`Qc 7 [^/f&TmSzSaYNN 7 zSaYNNwQSOc 7[^ k:Pё 7[^ k:PSV 7[^NSpe 7a{QNSpe 7ku{|+R 7 [^;N6eeQegn{|WfamilyIncomeTypeNameJkXQf[u[^;N6eeQegn{|W SNxh-Nv[^;N6eeQegn{|WۏLkXQ Y ]D0VYё0%m40e4TvQNRR6eeQ 0 LN6eeQ I{ ^_kXy 7checkDisableType 7checkFamilyIncomeTypecheckFamilyIncomeType 7ƉRku,TRkuzfRkuvQNkuku{|+R 7]D0VYё0%m40e4TvQNRR6eeQyOё0W,g{Qё0W,gu;m901YNOiё~b0cS`N0QybQ.U[^"N_v6eeQX[>kS)Ro` gN8RS~)R0hy0ZSi_6eeQ a{Q90b(vb){Q9 LN6eeQ vQN^S_eQ[^v6eeQ[^6eeQegn{|W 7 checkYear 7checkIdentityReason 7SkX /f b &T ^_kXy 7RRRNSpe 7 otherInfo 7[^bXT1YNNpe 71 7Nt^~ 7t^~ 72 7Nt^~ 73 7 Nt^~ 74 7 Nt^~SN N 75 7Vt^~ 76 7Vt^~SN N 77 7Nt^~ 78 7Nt^~SN N 79 7mQt^~ 710 7'`+RsY 7mQt^~SN N 7 checkYear 7 checkYear 7 isFiveHome 7 isPoorLow 7isOrphan 7isAloneParents 7 isDisability 7isParentsDisability 7disabilityCategoryName 7disabilityCategoryCode 7isParentsLabor 7isFamilyDisease 7isFiledPoorFamily 7isLowIncomeFamily 7 isJlsyfzl 7familyIncomeTypeCode 7isFamilyDisaster 7 isFamilyBurst 7jtcysyrs 7ldlrk 7sysDifficultyGradeCode 7 checkLen0,1,33 7& kXQvQ[NNq_T͑'YFO*g(WRv[^~NmOo` ^ NǏ100*NW[&{0^_kXy! 7checkLen0,1,100 7  ؚ!h,gNy[^~NmOo`U_eQ 7checkLen0,1,100 checkLen0,1,60 7 checkYesNo 7checkLen0,1,40 71 7 otherMessage 7vQN 7/f&TQQgyrVO{Q 7/f&TQQgNOO7b 7vQNOo` 7isCountryLowFamily 7isCountrySupport 7(kXQQQgyrVO{Q0QQgNOO7b0^chzaSvsQOo` Q[ NǏ40*NW[&{0^_kXy 7SkX /f b &T ^_kXy 70SkX /f b &T ykX /f R /f&TUSN[^P[sY ySkX &T Lhg0^_kXy 7,SkX /f b &T ykX /f R /f&Td[?Q ySkX &T Lhg0^_kXy 7<SkX ƉRku 0 ,TRku 0 zfRku 0 vQNku 0 ,gN/f&Tku y-NkXQ &T Ry NkXQ0^_kXy 7#pek ^_kXy 7% kXQf[u[^NSpe 'YN0 NNSpe NǏ99 OYSkXQ 6 ^_kXy  7( kXQf[u[^RRRNSpe 'YN0 NNSpe NǏ99 OYSkXQ 2 ^_kXy"# 7' kXQf[u[^1YNNSpe 'YN0 NNSpe NǏ99 OYSkXQ 2 ^_kXy!" 7'kXQf[u[^a{QNSpe 'YN0 NNSpe NǏ99 OYSkXQ 4 ^_kXy 7*kXQt^~[a Q[ NǏ33*NW[&{ OY [^`Qc^\[ ~N[ ^_kXy 7PyYgkXQ R [V~+R Ty 0 [e _N_{ TekXQN TeǏ!h0kXQv[SV Q[ NǏ30*NW[&{ OY [^NSOY RRR\ ^_kXy 7*kXQs~[a Q[ NǏ33*NW[&{ OY [^`Qc^\[ ~N[ ^_kXy 7checkSpLen0,1,100 7 checkInt0,2,0 DyYgkXQ R [V~+R Ty 0 [SV _N_{ TekXQN TeǏ!h0kXQVI{~[veg \?H@m A1BCE@ F aG mH tI NJs/KT4LYvMN:P_Q.USXWZ|.[SL\O]ccBĘ7ɹq1   w'  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 {} {}  { OJOYOOOR&`{@ m o M M N a N N N \V N N N N N z \X N N N N N, N a a a a N S S S X: n !Vg "V5 #V~ ^ @p xq Zr P r P O O O O O O  [  O  O  O  O O O [ O O O P P P O O O O O O.  O !O "O #O Qs Q  i O OT O Q Q Q O O O O _j O W7  S8 !S9 "U1 #U2gi iO ki li mj nj oj pj qj rj sj tj uj vjwT xj yjzT {j|TTTTTTTT T TT O c- t v d d@ dA dB dC dD  dR  dE  dF  d  dG eH dI dS dJ dK dL dM dN dO dP ei ek dQ d k k k f6  f/ !f0 "f3 #f4 h u w h gh h h h+ h+  h  h+  h+  h+  h+ h+ h hU h+ h h+ h h h h h h h h l+ l+ l h?  h !h "h #h-TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS{ {{{ & ngv(   vj N:tX?>]4v6@:t{[ /nB 3r3( <kXQf[uvY T<~~  <(;tCC@],@(;t}[4W(:t9 $< _Yhg<~~ i <;tCC@8],5@;t|[WP;t9 $<_ Y h g<"v6admin>@dinjn7 Sheet1ggDh8hj:SW2_1  Tb  dMbP?_*+%&ffffff?'ffffff?(?)?M.Microsoft Print to PDFP/ 4dXXA4GIS4DINU"$,?]{~SMTJ{084F01FA-E634-4D77-83EE-074817C03581}RESDLLUniresDLLPaperSizeA4OrientationPORTRAITResolutionResOption1ColorModeColor,V4DM p"O4wMH5L*@VDocumentUserPasswordDocumentOwnerPasswordDocumentCryptSecurity" dXX333333?333333?&<3U} K} E} #E} !E}  J}  J}  JT@ , , , , , ,,,,, I C C I L DDDD JDDDD J DD? F D DD D DDDGD DD@ F D DD? F D!DDDD DDGH D  D? F; H D  D5@ F< H D  D6@ F= H D  D@ G> H DDGHDDGHDDGHDDGH D D#D D D D$D? D D D%D@ D D DD@ D D DD@ D D D&D@ D D D'D@ D D D(D@ D D D)D @ D D D"D"@ D D D*D$@ DDDDD DD D# D DD? D$ DDlF <<<<<<<<<<<<<<<<<<<< !"#$%&'()*+,-. @/0:1:2:3:4Y@5679:;<=>? D D@ D% D !D!D@ !D !D "D"D@ "D "D #D#D@ #D& #D $D$D@ $D' $D %D%D@ %D( %D &D&D @ &D) &D 'D'D"@ 'D" 'D (D(D$@ (D* (D)D *\V*D? *EY *D] +\V+D@ +EZ +D] ,\V,D@ ,E[ ,D] -\V-D"@ -E\ -D].D /KW/D? /E^ /De 0KW0D@ 0]_ 0De 1KW1D@ 1]` 1De 2KW2D@ 2]a 2De 3KW3D@ 3y 3De 4KW4D@ 4Eb 4De 5KW5D@ 5Ec 5De 6KW6D @ 6Ed 6De7D9DbDD:DbDD;DbDD<DbDD =Df =bl =bm =Dn >Df >bo >bp >Dn ?Df ?bq ?br ?DnBfX<<<<<<<<< <<<< <<<<<<<< 88@ABCDEFGH,I,J,K,L,M,N,O,P,Q,R,S, @Df @bs @bt @Dn ADf Abu Abv ADn BDf Bbw Bbx BDn CDf Cby Cbz CDn DD Db{ Db| DDn ED Eb} Eb~ EDn FD Fb Fb FDnGDbDD HDHD? HF HH IDID@ IF IH JDJD@ JG JH KDKD@ KG KH LDLD@ LG LH MDMD@ MG MH NDND@ NG NH ODOD @ OG OH PDPD"@ PG PH QD QD QG QH RD RD RG RH SD SD SG SH,|8888888<<<<<<<<<88PH  0(   >*@555 7 Sheet5ggD    dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3UPH00(  >@ 7 Sheet6ggD VBA/@kRf/ fThisWorkbook / __SRP_42 __SRP_5 ?y  <,<0<4<8<<<N0{00020819-0000-0000-C000-000000000046}` `k@ i `i % % %`@"$ &( *@l ic@\ @0L ownW@x< @H, \@` M@ Layo@ eDow@ onWW@ eWWW@ @8 lWWW@ @  @P @| @hl T@\ Actu@L @< @, @ T@ @( @@ @ @ @ه[$*\Rffff*0=5f5b5d5f*\R0*#f*\R0*#1*\R0*#14$*\Rffff*0>5f5b5d5f*\R0*#2$*\Rffff*0<5f5b5d424 "      )ǷȷϽҪexcel籣棬"$"ȷ"$", $"&ϵͳҪмУ飬粻棬"$"ȡ"$"? $$ '  & A@(dP'k@o80Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 P Sub _BeforeSave(ByVal AsUI As Boolean, _ Cancel) isButtonmMsgBox("ȷϽҪÄex " & Chr(34)"ȷJ ,10ͳУA?", vbOKcC63If L4 0ThenBD@A򲢴z EŠPP= gEnd Irf AiAm rU   9 Q )  q $4 a9  ` x"l "   " "\ ''' :\lL:<, :::|l\L:<,^z6$lL, l\L, u  $< TlL, l\L, 4XrU @,`#n8/=H#<ppn@z \ F `RM I  x `RM I  ppn@z \ ME PSLSS006"Sheet1A3__SRP_a^,__SRP_b cSheet6f~<<<N0{00020820-0000-0000-C000-000000000046}( ,` @\ ).`h %i x%%*%@`\ه[*\R1*#220$*\Rffff*0@5f5b5d624  "  &  HX`p xڵԪʱ Continue? 2Hi$  41A@ k 123A@4oxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2'ڵԪʱ P$( Sub Works_BeforeDoueClicka(ByVal Target As Range, @CancelBoolean)  If MsgBox("Continue?", vbYesNo, "Hi") Then3  " End If CDec23n@48CrU P 1Y4 0  XrU @4 `\#n<jx#<)NCz- FT@#p+xT@#p+)NCz-ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` %6 %`h8@\\0ه[$*\Rffff*0B5f5b5d624xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2__SRP_ex__SRP_f|BSbpSȉ  ~]wQQpe zrU 14`rU @ndkkxMEP :0@ه["  ( HhxѧϢӡģ$<(>ѧϢӡģ$<B@@ѧϢӡģ$<(>oAttribute VB_Name = "Ԥ" Sub Browse_Print () Worksheets("ѧϢlģ").VisiblaTrue"d^P@review2cEnd rU~|   1a B   B  h p B  ( 0@2` p  B  8 8@ $x 8 " pB  x 8  $ $  HP xXB  4(0*X$ 8BP0h!  ( 0 8 @  B   4 $H  "p   "   .  0 0@ p  *   .  8 .H  x  0   6w?;!xME(6 LLx D` @ IF `IH `J P` iR4- Z` 8 I\ XIF xI^  b`   iR l` 8  I\ XIF xIH In  xX`   'I\ IF 8IH  8`  2I\ I IF IH I  ` x GI I\ IF IH I  ` X EI xI` `  `  SI + ` P jI\ pI i`  `  {I` (I, HI. @0 8 `  I\ I4  B ` k@ I\  `עIF ----I^ I`@  D@ ` I\  ----I4 ---- F `k I\  IF  ,I^  XI`  ----  ` @ I` ` ----I\   ^IF  I^ ----@0 ־@H @J ----  ` H I\ h IF  %I^ `,i--`L----`N R` 0  I` 1Wo@ .Unp 8 X@ B %` @Bl  H %NF |<~F@Hh !r@0X F@`H !r@D h@x4 ----@$ ----@ @ ---- `X`x@Fl ȥ`\ F<N ע@h @X 1 M@H x & @D @(4 @@$ @ @  h ه[$*\Rffff*0?5f5b5d62*\R1*#337*\R1*#10d*\R1*#101 B        0@6X 8 6 P`(x  0(0  f8  >&8 ` Xp h `*x j&P x ` (8P X Hp(x H0(x H(p` H(  &  `    H( H( H( H(  &  n `p  8( H(  &  b h       &X! ! ,!!!! f! X" x""" " 8"(" 6#(# p$ &x$ $$$$ f$ H%(`% % T% &% &(&0& $H& &p&$X&$&&$ '$(' 8'@' H' X'$t`'$&'$ ( ( $( ( ((H( ^P( ("((@(&8) `)p) x)))) b) 0*@*`* zh* &* +  +(+H+ fP+ +++ t+ &X, , ,,, b, (- H-`-p-x-&. (. 8.@.H.h. ^p.. ./@/&P/ x// //// ^/ @0 `0p00X0&0 1 1 1(1H1 ^P1 1 111T2&X2 2 2222 n2 83 X3p3"33&84 `4 p4x444 j4 5 85X5"h55& 6 H6X6`66 n6 6 787"H7p7&8 (8 88@8`8 Ph88888&x9 9 9999 R9@:X:p:Xx:&: : ;;;8; b@; ;$;;@;&0<X< `<p<$x<,<<<<<<<= j = =="==&p> >>>H> ?L? X?`? h? &@ 8@ @@ P@X@`@h@@ Z@ @A A@(A&hA AAAAAA jA "hBBBB dB &(C PC`CbhC hC ,8D hD &E (E 8E@E HE &F 0F @FHFPFXFxF ^F F&F G@(G&hG GG&GGGG ZH `H&xHH@H&H I I&(IPIXIxI ZI I,J0J@8J&xJ JJ,JJJK |K K$KK(K@L&HL pL L"LLLL |L `M xMM@M&M NN N@NHNhN |pN N$O0O@8O&xO OO$OOOP dP xP P@P&P Q(Q20QhQ xpQ Q6R.@RpRR( R2R( R1R( R2R( R1RSSJ(SxSSSSS fSB  T  T<(ThT TT$T$TUU U \U B  (V,HV 0xV@V"V ^W 6pWWWWX0 XHPXXXXXXX X "Y Y .YB  Y Z$ZB8Z Z Z Z Z Z ZZZ Z x[ [ [ [B  ["[ \(\0\ 8\@\H\ P\8p\\2\\ ]  ]0] 8]@] H]X] Fx]]] ] ] *]^ ^ ^ ^B  ^^*_ 4H__ _B `< ` J@``` h` a  aB  8a*@apa xaB b<b J0bPb XbB  c c "(c Pc8pc2cc cd (d0d 8d @dPd"pd0d d(dee e L0ee&eee ee eB  hfpfVff 8g @g `g:pg4g$gh"(hPhXh`h hhB  hi6i@iPiXi`ihipi i-----------------------------------------УУдϢʾ ע----------------------------------------------------------- Ԫ] F H L%N'J J0'Dd('Dki--------------------------------------------д־ ¼ϢʾһϢ-------------------------------------------- R X V$T,N X 'XiX------------------------------------------------------ ȡָcellֵ------------------------------------------------------------- F ^ \$<%N!`'Zi--------------------------------------------д־ ¼ϢúɫʾϢ-------------------------------------------- R'd R X V$T,N d X V$T%N%f!h(j X 'Xii--------------------------------------------עʼУ飩-------------------------------------errorInfoע 1Worksheets(sheetIndex).Unprotect Password:="1qaz" n F H \$<%NB@p F H \$<%N!r(tW ӻɫ F H \$<%N!v(>ii--------------------------------------------ɾעʼУ飩-------------------------------------1Worksheets(sheetIndex).Unprotect Password:="1qaz" F H \$<%NB@z F | H ~ F H \$<%N!r(jd  F H \$<%N!r(jkpihr---------------------------------------------ʼУ Ƿӻɾעõķ----------------------------X  Уʧ F H \$<%N!vd жעΪ \ F H A@lV עd"Ϊգȥǰע \ F HA@xN ע \ F H A@lwk1 MsgBox "" & rowIndex & "" & errorMsgd :УɹжǷעУʧʱעȥ \ F HA@x ,#ȥո,ʾ FУ HУַ"$" "$""а˿ոϵͳԶΪA@Pd`kXkPiH----------------------------------------------------------------------------------------------------------------------------------y--------------------------------------------ݱʶöӦķ(ʼУ)-----------------------------------------------------------------------------------------------------------------------------------------------------------------------ѴϢдб8 F H \$<%N'`  H \$<%N'Iȡбͷ Ϊϲеıͷ  H \$<%N' F e  H \$<%N'k0'  checkLen*)ΪУ  $'checkLen'  checkNum*e-ΪNumberУ  $'checkNum'  checkVal*e-ΪֵУ  $'checkVal'  checkInt*e-ΪֵУ  $'checkInt'  checkTerm1e-"ǡ"Ϊ1' checkTerm'  checkYesNo1e/"ǡ"Ϊ1' checkYesNo' checkDiffName1e2ѼΪ1' checkDiffName' checkDiffCode1e2ѼΪ1' checkDiffCode' checkIDCardType1e4֤Ϊ1'checkIDCardType' checkSqyyName1e2ԭΪ1' checkSqyyName'  checkYear1e. У1' checkYear'  checkSpLen*e0ΪУ  $' checkSpLen'kP _=================================1 ִеķǿУ==========================================ѴϢдб checkNullKT \ F H$'  F е Ϊգ'')УʱдϢ A@PRMsgBox "" & rgold.Row & "е" & Chr(10) & titleMsg & "Ϊգ"k0 \  F H A@'a=================================2 ִѧУ========================================== checkNameKT \ F HA@@ȥոķ F H \$<%N!`'` `$'  F е ;дȷΪ֣ȴ1ܳ20ַ''%УʱдϢ A@P  'k` \  F H A@'Z================================= ִеijУ==========================================checkLenKT ` $'  ,$'$ ` ΪDZΪ̶ȶ F е .дȷΪաд򳤶ȱΪ$ λ'$ ed ΪDZΪȷΧ F е 4дȷΪաд򳤶ȱڵ$ λҲ$ λ'$ ed ΪDZΪ̶ȶ F е &дȷΪգҳȱΪ$ λ'$ ed ΪDZΪȷΧ F е ,дȷΪգҳȱڵ$ λҲ$ λ'kH '0УʱдϢ A@Pk \  F H A@'Z================================= ִеijУ========================================== checkSpLenKT ` $'  ,$'$ ` ΪDZΪ̶ȶ F е .дȷΪաд򳤶ȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ F е 4дȷΪաд򳤶ȱڵ$ λҲ$&λֻΪַ֣'$ ed ΪDZΪ̶ȶ F е &дȷΪգҳȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ F е ,дȷΪգҳȱڵ$ λҲ$&λֻΪַ֣'kx'0УʱдϢ A@Pk8 \  F H A@'h================================= ִеijУ飨Numberͣ==========================================checkNumKT ` $'  ,$'$@ ΪDZΪ̶ȶ F е GдȷΪգдΪ֣0λȲ$λСλ$ λ'$ ed ΪDZΪ̶ȶ F е ?дȷΪգұΪ֣0λȲ$λСλ$ λ'kh'0УʱдϢ A@Pk( \  F H A@'[=================================ִֵΧУ==========================================ѴϢдбcheckValKT ` $'  ,$' F е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@P& isValidateCount = isValidateCount + 1k8 \  F H A@'_=================================ִеΪֵУ==========================================ѴϢдбcheckIntKT ` $'  ,$'$@ ΪDZΪ̶ȶ F е 4дȷΪգдΪ$ҳȲ$ λ'$eEΪΪ̶ F е 0дȷΪգұΪڵ$ҳȲ$ λ'k!'0УʱдϢ A@PkH! \  F H A@'`================================= ִе֤У========================================== checkSfzjhKT \ F$Z'S ȡд  F е &дȷ֤Ϊգ''0УʱдϢ A@Pd  ֤ ` H$'O ֤У :֤У F е *дȷΪѧ֤ţ''4УʱдϢ A@P  'kd `$'  F е EдȷΪգҳȱڵ1λҲ18λ''4УʱдϢ A@Pkkk \  F H A@'X================================= ִ֤У================================== checkZjlxKT checkZjlx `1$'  F е дȷ''(УʱдϢ A@Pd checkZjlx \ F HA@k` \  F H A@'\================================= ִѧŵУ==========================================checkXJHKT `0, 1, 50$'  F е KдȷΪգΪճȱڵ1λҲ50λ''0УʱдϢ A@Pk \  F H A@'`================================= ִѧϢIDУ==========================================checkXJHKT `$'  F е EдȷΪգҳȱڵ1λҲ50λ''0УʱдϢ A@Pkh \  F H A@'[=================================ִпУ==========================================ѴϢдб checkBankKT `$'  F е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@Pk \  F H A@'W=================================ִ꼶У========================================== checkYearKT checkYear `$'  F е дȷ''(УʱдϢ A@Pdp checkYear \ F HA@kH \  F H A@'W=================================ִѧУ==========================================ѴϢдбcheckXnKT `$'  F е )дȷʽ2012-2013ȣ''-УʱдϢ A@Pk \  F H A@'W=================================ִ·У==========================================ѴϢдб checkMonthKT `$'  F е &дȷʽ0112ȣ''-УʱдϢ A@Pk` \  F H A@'g=================================3 ִеУ(DZ)==========================================ѴϢдб checkDateKT `$' 2Уʧ F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-02-21''-УʱдϢ A@Pk \  F H A@'c=================================ִеУ飨==========================================ѴϢдбcheckDateNecessaryKT& `$' 2Уʧ F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-12-21''-УʱдϢ A@Pk \  F H A@'g=================================ִеijУ飨==========================================ѴϢдб checkBirthdayKT! `$' 2Уʧ F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-12-21''-УʱдϢ A@Pk \  F H A@'J=================================10 У绰====================== checkPhoneKT `$'  F е дȷдʽΪ"$"-̶绰 ֻ"$" ''%УʱдϢ A@Pk@ \  F H A@'L=================================checkOption У鱸ע ====================== checkOptionKT `B$'  F е )дȷȲܳ200ַ''%УʱдϢ A@Pk \  F H A@'\================================= ִ϶ѼУ================================== checkDiffNameKT checkDiffName ` $'  F е дȷ''(УʱдϢ' A@Pd checkDiffName \ F HA@ `$1ͨУֵΪ'd 'k k \  F H A@'d================================= ִ϶У(DZ)==========================================checkIdentityDateKT% `$' 2Уʧ F е дȷдʽΪ"$"xxxxxxxx"$" 20130221''-УʱдϢ A@P'dH  `$X$϶ȼΪգ϶Ϊլ'  `$e](϶ȼƲΪգ϶ڲΪ'd F е vдȷ롰Ѽ϶ơͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơǷͨУ''0УʱдϢ' A@P'kk \  F H A@'T================================= ִУ==================================checkMZKTcheckMZ `$'  F е дȷ''(УʱдϢ A@PdXcheckMZ \ F HA@k0 \  F H A@'d================================= ִ϶ԭУ(DZ)==========================================checkIdentityReasonKT'0,1,30' ` $'  F е 5дȷȱڵ1λҲ30λ''0УʱдϢ A@Pd   `$r1϶ȼΪգ϶Ϊ,϶ԭΪ   `$ew8϶ȼƲΪգ϶ڲΪգ϶ԭΪ   `$e F е dдȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬''0УʱдϢ A@P'd F е дȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơ϶ʱ䡱ǷͨУ''0УʱдϢ A@P'kEkE \  F H A@'X================================= ִ֤У==================================checkIDCardTypeKTcheckIDCardType ` $'  F е дȷ''(УʱдϢ A@PdXDcheckIDCardType \ F HA@k(D \  F H A@'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType ` $'  F е дȷ''(УʱдϢ A@PdBcheckDisableType \ F HA@kB \  F H A@'T================================= ִвмУ==================================checkFamilyIncomeTypeKTcheckFamilyIncomeType ` $'  F е дȷ''(УʱдϢ A@PdHAcheckFamilyIncomeType \ F HA@kA \  F H A@'v=================================14 checkGender ִǷΪСŮУ--================================== checkGenderKT checkGender `1$' '-ԱдУ֤Ŷ F е дȷ''(УʱдϢ A@Pdx? checkGender \ F HA@kH? \  F H A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoKT checkYesNo ` $'  F е дȷ''(УʱдϢ A@Pd= checkYesNo \ F HA@k= \  F H A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkSqyyNameKT checkSqyyName ` $'  F е дȷ''(УʱдϢ A@PdH< checkSqyyName \ F HA@k< \  F H A@']=================================checkTerm ִѧУ--================================== checkTermKT checkTerm ` $ F е дȷ''(УʱдϢ A@Pk: \ checkTerm ` $ F H A@'r=================================checkAtLeastOneNNull ִһΪǿ--==================================checkAtLeastOneNNullKT  'A"ִ һǿУ ĵԪĿ `$ `=Ϲ  ` ' H KTF  ` ' KTF  ` ' KTF  ` ' KTF  ` 'n8dϹ  'F6ִ һǿУ ĵԪΪϹĿ    'kh8'nX8iP8_--------------------------------------------ʽ-------------------------------------]VBSCRIPT.REGEXP$.7RegExΪʽ (4 ȫֿvba\ת  (.ʽ (5ǷִСд ` %'3 ִ.i6-----------------------------------------------------------° Уظ˵Ѿûиʽ------------------------------------------------------------V-----------------------------------------------------------1ѧ׶ڱڲ(sheetѧ׶ A65535 $T%0%!'*cna = getTotalColumnCount(sheetIndexValue) V$T!NB@1&ÿУظʱʱѴϢsheet,'XϢ¼ʼX==============================ѧ׶ڱڲ==================================0ðÿԪغ֮ǰнбȽ      $T%N'       $T%N'  .ѧͬ˵ظݶ  еݺ͵ ֤ظ!!!!' A@P*ѴϢ'k8303(3i 3-----------------------------------------------------------һ ֵȡֵ------------------------------------------------------------ֵҵֵڵлkeyWord ҵĹؼ'kbn л ֵΪ rowrow']the find result object   $" (& A1:A65535 \$<%0%.  row !'dH1 !*'k01k(1i 1------------------------------------------------------ ִڹУ(Ϊ)-------------------------------------------------------------value value1 cellУ鲻ȷfalseУȷtrue .0˵ΪDZ ,$'z/k/k/]h'2ijһļ¼ A65535 6$T%0%!'4B' 6 `row$'0=ȡ  0 4  6$T%N ` 2 '2d.y.k.   0 0 2   6$T%NX ,X LжϹǷcell'y0.k(. #ʱcountĿΪùеĿi------------------------------------------------------- ִɾijһвexcelܱģ-------------------------------------------------------------sheetIndex rowNum к1qaz< \$<B@: 4 \$<%>B@@/ Ѹɾ- Worksheets(sheetIndex).Protect Password:=123ix,------------------------------------------------------ ָcellֵ-------------------------------------------------------------1qaz< \$<B@: ` F ^ \$<%N(`i+------------------------------------------------------ ִɾijһвexcelûб-------------------------------------------------------------sheetIndex rowNum к 4 \$<%>B@@/ Ѹɾi*------------------------------------------------------ ָcellֵ-------------------------------------------------------------@ 1qaz< \$<B@: ` F ^ \$<%N(`i)------------------------------------------------------ ݴеֵǰʱѾͨУ飩------------------------------------------------------------- ]   F ^ \$T%N!`X 'J'2ijһļ¼ A65535 6$T%0%!'4F 6 `row$'0Aȡ  0 4  6$T%N ` 2 '2d'y'k'   0 0 2   6$T%N!`X ', , JX 1жϹǷcell  6$T%N!`'H HX F ^ J \$T%N(`y&d& ,ESheets(sheetIndex).Cells(rowIndex, colIndex + columnPlus).value = "0"dx& F ^ J \$T%N(`kH&k@& i(&------------------------------------------------------ ȥcellеĿո------------------------------------------------------------- ] Ԫ]  3Blength1ʾcellԭijȣlength2ʾִȥոַ'ĬΪûȥո2 Worksheets(sheetIndex).Unprotect Password:="1qaz" F ^ \$<%N!`', ,'L LGzj*"ԪΪգȥո , 'N%length2Ϊոһγֵλ Nַո , $P', ,X F ^ \$<%N(`'k#i#------------------------------------------------------ ȥַ------------------------------------------------------------- ]P -[\uFF00-\uFF06][\uFF09-\uFFFF]|[\s,;'<> "?^]+'  `$'Rd"'Rk"i""Attribute VB_Name = "ߺ"  '-%УдϢʾ &( Function checkedRequiredStart(rowIndex, c olumn )  { 'Ԫ@Dim cellValue As rSng= A;veShePet.Cs6If-" Then*F_Fal4seETrund If < E)[д־ ooһkqmwriteLog(content]iX`s(msgB)[curMsgRow, 1)JCK + 1:D ȡ AֵLJpHDgetBCountXQ(sADʴ A?WorksHEQy.vA`%2GúɫCG3 GRedVHnLen EKzKRcR.Characters(1, ).F].Color73?VJxx&!ʼs+#` errafoåaddCommwXQCVUů,  0™'TUnprotect Password:="1qa>z e\N.A ( I0rior#=<65 535 '1ɫ>% d/.Visi1 6K YesNo -k2 ? DiffNameѼa?%D~ CodslA! 'HBIDC0ardTpM֤ xo(/  kSqyyԭ _ _ "] e? ? kYearZ?MA_ _ ]  :iSpiiBE\ V11j BLvSelect Case =Q)1 ִǿ1?OC 3~N8ulldxMethodXQ7Required Nod3"@"" &Ǝ"xtitleдȷ"ΪաB"`ΪA<1)λ0+El4seuO2]OA+ΧOex!'''ڵ3v(Ҳ謹1-2?-%,?-= 1T`jT?-TTTT &S "SeS&SSf{F{&R`'R?,IiahasE!@ 'BaʱдPOρ d͏| || c| } }-{}g|Sp} sBY??a='/TgB Qooo_ I?W?W?Wߊ ?dSSSSor?ߊ?P֤/)RSfz jhR re sZjlx0EgetCell kujXQ(x, rowInde2) 'ȡд@ If resZjlx = "" Thenberr orMsgf" & "title-& "ȷ֤Ϊգ"ahasETrue 'УʱдϢ&writeLog lElse*avcheckMethodXQrIsIDNumber(value, column|C,@' @'NoLt  'O`σ8Ϊѧ6"AEisValidateCountrM+ 1_WEndm ?SMKSFZJLXcK)H_A??DbҳFڵ1λହ18e?H ?HO>G{/?   beginC_comme]sheetDNi(, isForh '= ִЃcA=Case ~"BTJ@DHMB((, "1"4mk>$55?y& ?y2y1}/1ww\o0O!LsetCodz, )'w8&,U-ZZ-/qO-*B-ѧ஺ŵ- -XJH-EJ-Len"0, 1, 50O-% O..O/I!c#ccc50c 22222%]_._._._.O.*.ID..d\. .S9[л.\....??0- ---/-------:֟+-)п'pдб Case "checkBank" thMethodXQ = T(value)`If Not`a@Then2;errorMsgk"" & rowIndex "е title-& "дΪ֣ڵӂ'functionArgsA rr(0),Ҳ +18zha sEcaTrue 'Уʱ writeLog '@End Ifb eginCA_comment sPheet\,o,columnD A'isForB  '=ִ꼶K 5aYearhҳDMB(B, ¶, 1H@BXN\ El seIc set*Codd+K?E{IS W _Xck?E_X XY==YѧY\ хXnO]\Xn"[cʽ 2012-3ȣ^"__C__JUU8_'*·ݟ*{*0hYMonth**P-*EtX@?\X?& ?7*0112*}**KI*V*UR]*O'3 UA+(DZ)+++Date" CPo,`,Birthday,v,, 'ʧYO7O/H.Ϊ!Chr(34rbx-xx  ᭁ[-0\10 000 j0000000?,0죨0ѩ_00 0NecessaryO1r CO1H1&1(11@1 _V__$1113-1 111J writeLog error`Msg  E nd If|beginCheck_comment sheetIn@dex, c2MethodXQ, row0olu mn ~isFor = True '=ִеijУ<4ѴϢдб@Case "qBirthday"| ' jNecessary(value)#@If Not Then '焹 ~ʧ$%^#"" &i"AS Otitleдȷ@ʽΪA C@hr(34) x1-xx  2013-12-21@"+h8asE+ 'yʱn\(J10 K绰pSb'(\Pphone3ZNumvYvX,TTT-̶# $VTSSRQP???LEOptionBQ౸ע P&CQ㣣P, 66?Ъ_Q_Q_QȲ200ַKK?% %#1, c /% " aѼqOGODiffN&Bu(})o{BId`ityDatexOC@CĿAAComsgQE"q1S02?> GGG DDyiPntifJ-808i> A/EQnȼn!E 1a-/F? indentifyDateFlag = 1  4ElseIf sysDifficultyGradeNam2 And Trim(value) <> "" Then '϶ƲΪգ 2,errorMs"" & rowIx"еʀ title& "дȷ롰`Ѽoxͬ2|zͨУт!PǷ"ihasEj@xTrue 'ʱdдϢcheckMet hodXQ@Fa@ writeLog W x0 2EIfbeginCA6_comm sheet}, <,`olumnD W6isForD_ '= ִÀj^ = ĵԪ=\"\Money(Z) A:B <> 0Z 'aG Ϲ GPtotanl Q+CgSelect tޘ m"baojiaoC:1 Sum-, huoshic _ Bzhusu?L# others?l# _ ATsJ 'e?f =pG>6>>>Ϊe@A7c+ h+ " J"`~u Ft '-ʽo-  reg[B(})8DimaEX As0 ObjISet= Create("VBSCRIPT.RE@GEXP")q'RegExΪ8G EX.GlobalpF~'ȫֿ''vba\תPattern RIgnoreB8= FaǷִСд3TestgGB.phin#$O  ° 4˵Ѿûpt 1ѧڲ -B}SameXQNew(Wp2) 'w(n*aS!s:.Range("A65535").P(xlUp).R$ow'cge`Exit 2@e%7if!LDataCount 0 ' һa(¼C(Num`Szs(pAreagf (xlUp@jow `'E HF/ -Ul $0,#e) '>C`For i % To @1C`Fs(i, 3b>r'+ (p=#5o2a i'j.5 + c V-i DC(jp, 3)MB#Y) 'ж(dǷf'&A eSbS)Aj @'ʱcAQʀĿΪ0Ѓw ?]OEbHɾ.в exģ?F1 ' ňsdeleteP\h,*Ejv).UnprotAaoPassw`|:="1qaz"'obs().D 'Ѹl!'rA}).P123_ ָ¨c'ֵ?(sett@@?,t).(#(pW/)BδA֐] ư>Σǰ@ʱ1Ѿͨ˱)?Code%bW8dzT<, c 2QL2p|y,HC=  S]___@a[B=? {9Q~as* Count = 8+ 1 a |Else DtExit For V nd If&Ne0xt i` jrowDataP To  +- mvalue1Str(Sheets(Areas Index).Cells(j, 3).0)xDIf KcV.) Then 'жϹȏ'+codne#QO2O& !nv, col +umnPlus,J?A.qB}AIP","M2'2"0"S)"Ej Function '-2 ȥâĿո&D  removeSpaceXQ(gN,as#MIDimeiAs ring 'Ԫ8Ah'7le@ngth1 Integer, %c2h 'ʾ#ԭijȣaִ"!ַ cFa`[ 'ĬΪûF' W(ork!s!).Unprotect Password:="1qazDƋtxd Len( /p'0yM '1Ϊa%$c 2 Ina , "( ")12һγֵλÃf2 <> 3A5'%g ReplQ"E+L ETru%|?zs- 2a$?8zecialCharacter#+!9regp"[\uFF00R-b6]9FF]|[\s,;'""?^]+s/`CheckAE(,ACu `F*] "<S!V __SRP_8l__SRP_9 Xf!__SRP_6J0  0   0   0   0   0   0 X  0 8  0   0   0 $  0   0   <:4%DX%h$ h dD)hDJ$%DX%h$ h dDC)hD5px(<lhD0   <:4%DX%h$ h dD)hDJ$%DX%h$ h dDC)hD5x(<lhD0   0    0        rU ,`//(`00` 1///(`08!`Q////0I` ///<q`q/////<`/////,`//( `/0 ` 9Q09 ` ay///,a `//8 `1////,`//8`1////8`1////0)` 1///(Q`/nrU~| prU '_ 'һṹ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 TheSa@_ĮIdN\um]n idaै_Чǰ>\״̬checkMethodXQAA1A0ķRaRowSq0= `r+пʼx!xcardID"J8= 3 'ѧ֤aλ Dim isy)!Ϊեne&򌿴?Ϊ a 5ֶ c f'removeSpaceFlam:ȥո@zHaˡ+truefalse]g4eAc ԭa*tûнԶûo@<֮Cc ur@*)Long 'ϴдEGa!9,ӦĿʼʱֵ҈F rna eB',cq^isFPOi.ڸݱʶò8ͬp)B ;for@ѭ C_SeleFChNҪÀñ^,headI2(+ʡصȱ& Sqs9= 2 '2r±P! nottinueQ$AqPJPlubS7104 'd?sysDifficultyGr8adeq729 '@ wtsintif yDGs30 '1ʱ?6@ReasonT1Sԭ\sO ?W6$1 ͨJ 0-δ 1-"A< 2:Q6*_'_% __S @ꀘP @__SRP_7!hQpe F}__SRP_10__SRP_11[ n08H0rU~|      R<< <8 /@ه[$*\Rffff*0C5f5b5d63  B       (  B  B    p (08@ HB  n ( @B `,h$"H H PX `6  t&xRRME (@V006 <VhH0hX\P`H`@ʘxBʀ @ʀ4 @ꀆD @.L @%Ϣ˵%ꀞ@V  @Z  @dh\  @fBhX@‐@ʀd @x@jz@ʘ0BlH~ @JXhB!ʘpB#%@&@%—Z(BVHpH^pHʀ @$ @b8Hh @ꀘP @T @X  @ꀚ^ @0Bꀈ` @Xt@ꀠ| @6 BʘnpB"ʘrB$pHPxh p(08H0X@XT0'=ه[*\R1*#220$*\Rffff*0>5f5b5d5f(*\Rffff*0>5f5b5d5f\077    08  @ ` Dp 8 0 P0pD084P. ..(8(`>"$(@>`R^FX `*0$`  $  ^(^^^0p@һṹҳ]$H=Public Const sheetNameValueTJ As String = "2ʵͳ"]$Ϣ(J2Public Const IntroSheetName As String = "˵"]$H]$˵P] p ¼ܵУ]$¼ͷ] x"ִ һǿУ ĵԪĿ] 6ִ һǿУ ĵԪΪϹĿ] ÿһкϼеֵ] "һǿУʱ¼Ԫ] Ϣ] %---ģУ¼ĸԪ] 8---ģУ¼ĵԪ]  Уʱ洢ַ] ¼ʱرհť]  ¼ܵУǷвϹ] @ ¼ܵУǷظ] #¼ܵУǷظ] %/¼ЧǰǷдϢ ״̬--] h#У鷽ķֵʾ ]$)¼ʼк----]$)ѧ֤ſʼλ]D0¼ΪյĿ--]X"/ǷΪЧ ͳ 5ֶΪյĸ] "C¼ȥոִнȥ˿ո򷵻true򷵻false'D] PcellԭʼĵݣϵͳûнԶûĴ֮ǰcellݻ] 7ϴдϢʱڵ,ӦĿʼʱʼֵһ] ,] X] RڸݱʶòͬķʱжǷforѭ Cell_SelectionChangeҪõñ]$¼ʡصȼ¼ڵ------]$0+sheet±NǷ]  ]$hH)е]$X,϶Ы]$p#϶ʱ]$%϶ԭ] -Oʶ϶ǷͨУ 0-δͨУ 1-ͨУֵΪ 2-ͨУֵΪf] $Oʶ϶ʱǷͨУ 0-δͨУ 1-ͨУֵΪ 2-ͨУֵΪAAttribute VB_Name = "" Public TypalueCo8lum8p 'c@nIndex As I@ntegerTø P'SngEndn       !"#$%&'()*+,-./0123456789:<=>k|ACDEFPHIJKLMNO@QRSTUVWXYZ[\]^_`abcdefghijl{nopqrstuvwxyz}~tFc~xME(6 << <8 `@ I\ `IF IH H`J 0`  I` ====@ === `p I` @   `  I` @ ====+`` ivKTi^ `xH `H`|` `~ `X  I` @ ==== `  I` Ϣ@  `H  I` ====@ ==== `  I` @  `8 I` XI Ϣ@   ` I` Ϊ@   `H I` @ $  ` I` @ Ϊ p `8 I` A@P@ ` I` @ @ `@ I, `(30)I ]))) D `  I, ----I   `@  I, ` falsI 2163  ` I`  'I   `@ I` ` I   ` ++I`   I   `@ I` ` I ===  ` //I`  I   x `@  I` @   `  I`  P `  I` @  `  I` @  @`  I` @ Ϣ 0` ""I IF ----I^ ---` ` `N`N`re``--@ ----` У@ ----` ----@ ----` ȷ@  `p ""I` \u2EI \uFE@ {0,2 `  I` @ 0    @  p 0P x  t(% "x " 0 8 4H   ( B @ H 4P       h  B             B   6    ( 0 8 |@   B  08HPX`h xp  B   ( 8X`hpx x P pB  | p B $ |  B fHX`hpx |   B 8@H`px  ( HB `hp:x   (08 @  B  (0 8 @P X` hp x .B @ H X hx  .@B px  B X`x &D4 X `hp B `h &  ( 08D@4  (08 @B    & HPX` hD    "  H P  $X  "          ! !(! 0!>H! !4! ! !! !" "B """ """" "# "#0# 8# <@### ## #B P$  X$p$ x$&$$$$$  $D$8%P%X% `% %"% %% $% "% &  & (& 0&P&`&&&& &>& &4' H' P'X' `'h' p' ' (B 0(8(@(X(h(p(x((( (  ) @)B X)`) h) x))) )  * @*B X*`* h******* * X+ x+B +++++++++ + , ,B ,,,,---- - (- - -B . &. $@. h. .&.*.".$/@/(`//////0 0 200h0"000  0018 1X1`1 h1B 112&2@2 H2&X22222D242 30383@3H3 P3X3`33333333333 3 x4 4B 444444555 5-----------------------------------------1 ,дϢʾ Ϣsheet--------------------------------------- ʱ0 Ϊʱ1e1 Ԫ] F H \$<%N'Jch Jre'd'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseעȥʽȷtruex]^([\u2E80-\uFE4Fo]{1,20}[a-zA-Z]{0,20}|[a-zA-Z]{0,20}[\u2E80-\uFE4Fo]{1,20}|[\u2E80-\uFE4Fo]{1,20}[a-zA-Z]{0,20}[\u2E80-\uFE4Fo]{1,20}|[a-zA-Z]{0,20}){1,20}$'޸ģУƧ  `$'d@'k0i(|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------'0 `$Ϣ'zpkh]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]))))$"$Z^((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'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------]^((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====== ]790584216379058420Ȩ====] 10X987654320УxK v$$z'v'ȥո'] ^  v6)׶֤Ϊ,ΪͨУ'z(k  vGzjд v$$Gzj" v*[0-9X]Gzj ' x $'~ ~G '~j | v $ ~ '|H | '~== v$  ~ $G'j====iz-----------------------------------------У֤ -------------------------------------------------------------ʽȷfalse ʽȷtrue ]x,^[\u4e00-\ue863a-z|A-Z|0-9|()|]{1,18}$'  `$'d'ki----------------------------------------5 -УѧУѧУʶ 42λһλΪֻx-------------------------------------------------------------======ʽȷfalse`$ʽȷtrue ]^[1-9]\d{40}[\dx]$'д  `$'d'kixz----------------------------------------6 -У黧 -------------------------------------------------------------ʽȷfalse======ʽȷtrue=c]h.^(\u519c\u6751)|(\u53bf\u9547)|(\u57ce\u5e02)$'  `$'dX'kHi@u-----------------------------------------7 Уѧʱ-------------------------------------------------------------ʽȷfalseA@ʽȷtrue==]'^(((19)|(20))\d{2})((0[0-9])|(1[0-2]))$'  `$'d('kiq-----------------------------------------7 У-------------------------------------------------------------ʽȷfalseϢʽȷtrue `fNam ,ΪDZ'kzk]x^((19\d{2})|(2\d{3}))$'  `$'d'kiq-----------------------------------------7 У·-------------------------------------------------------------ʽȷfalse'ʽȷtrue]^((0[0-9])|(1[0-2]))$'  `$'d('kiv-----------------------------------------9 Уѧ-------------------------------------------------------------ʽȷfalseʽȷtrue]h^\d{4}[0-7]\d{3}[0-3]\d{7}$'  `$'d'kiv-----------------------------------------10 У绰-------------------------------------------------------------ʽȷfalseʽȷtrue]^\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 'k i v-----------------------------------------11 Уп-------------------------------------------------------------ʽȷfalseʽȷtrue]X^[1-9]\d{14,20}$'  `$'d 'kp ih -----------------------------------------checkXn Уѧ磨2012-2013-------------------------------------------------------------ʽȷfalseʽȷtruep]]1^(20\d{2}-20\d{2})|(19\d{2}-19\d{2})|(1999-2000)$'  `$ `-$'$$ 'd 'k d 'k i -----------------------------------------checkOption У鱸ע磨Сvalue2-------------------------------------------------------------ȲС200false 򷵻true ,'z k ,  'd 'k i ------------------------------------------------------ȽϴС(Сڵڷtrue)----------------------------------------------------------------'value1value2false 򷵻true ,X', X' ,  'Ddx'Dkhi`------------------------------------------------------ȽϴС(Сڵڷtrue)-dec---------------------------------------------------------------'value1value2false 򷵻true ,$4', $4' ,  'dH'k8i0}------------------------------------------------------У鳤--------------------------------------------------------------- ,$'' `$/ΪDZ'k8z0k( ,-±0ʼֵΪָάõ± `$$4 `$$4'zkd ˵У̶ `$$4'z@k8k0i(}------------------------------------------------------У--------------------------------------------------------------- ,$'' `$/ΪDZ'k0z(k  `$& Ϊz `.e+Сzk ,-±0ʼֵΪָάõ± `$$4 `$$4'z0k(d ˵У̶ `$$4'zkki------------------------------------------------------Уֳ(Number,ΪС0)--------------------------------------------------------------- ,$'' `$/ΪDZ'kzkֲɼӷ<^(([1-9][0-9]*)|(([0]\.\d{1,2}|[1-9][0-9]*\.\d{1,2}))|0{1})$'  `$zk `$% Ϊz `$4e% С0zk$'+󳤶$'.Сλ `.''' "˵ûС `$4' $$4'z k d С ` `. $'DԪֵλ ` `. $' $$4 $$4'z k k i------------------------------------------------------УֵΧ--------------------------------------------------------------- ,$'' `'z(k  `$) Ϊz `$4e) С0zk `$4$$4 `$4$$4'zpkhi`------------------------------------------------------Уֳ(Number,ΪҲΪСС0)--------------------------------------------------------------- ,$'' `$/ΪDZ'k@z8k0 ֲɼӷ<^(([1-9][0-9]*)|(([0]\.\d{1,2}|[1-9][0-9]*\.\d{1,2}))|0{1})$'  `$zk `$% Ϊzx `$4e% С0zHk@$'+󳤶$'.Сλ `.''' "˵ûС `$4' $$4'zpkhd С ` `. $'DԪֵλ ` `. $' $$4 $$4'zkki-----------------------------------------checkIsInt У鲻С0-------------------------------------------------------------ʽȷfalseʽȷtrue ]` ^0|[1-9]\d*$'  `$'d'kxip-----------------------------------------checkIsNumber УΪNumber-------------------------------------------------------------ʽȷfalseʽȷtruex ' `$'kxip-----------------------------------------checkMoney У0-9999-------------------------------------------------------------ʽȷfalseʽȷtrue ]8 ^(([1-9](\d{0,3})|0)|0)$'  `$'dX'kHi@-----------------------------------------checkMoneyTJ У0-9999Сһλ-------------------------------------------------------------ʽȷfalseʽȷtrueP ] ^([1-9]\d{0,7})$'  `$'d('ki-----------------------------------------checkPersonNum У׶԰һ------------------------------------------------------------ʽȷfalseʽȷtrue ](^(([1-9]\d{0,3}))$'  `$'d'ki-----------------------------------------checkIdNumLink У֤ԱͳûдǷһ------------------------------------------------------------ʽȷfalseʽȷtrue@ If colIndex = jhrIDColumn Then checkIdNumLink = True Exit Function End If]%Ա֤ǷӦ]$ں֤ǷӦ]ڵһγֵ±]("Ա,Ԫ֮ڵ]@$ݺŽȡ]X!,Ԫ֮ڵ]p"ݺŽȡ]#]%·]] $' $'  (ڶλΪΪ F  Z$T,NdڶλΪżΪŮŮ F  Z$T,Nk( $' $' $' -  -  F  Z$T,N'i}------------------------------------------------------У鳤---------------------------------------------------------------0 ,$']^[\u4e00-\ue863]{1,100}$'' `$/ΪDZ'kpzhk` ,-±0ʼֵΪָάõ± `$$4 `$$4  `$'d'kzkd ˵У̶ `$$4  `$'d@'k0z(k ki-----------------------------------------У鿼šѧšѧ -------------------------------------------------------------ʽȷfalseʽȷtrue](^[a-z|A-Z|0-9]{1,40}$'  `$'d 'k i <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 @"^([\u2E80-\uFE4Fo]{1,20}[a-zA-Z]{0A|] |c )C"$" '޸@ԁYƧy3C@(, =DFω ɓD=3D8Ϊ2012-05-09(v) zBirthd ay*?@$Trimd>h ##Exit M/AfgaL'`1 ^((19)|(20))\d{2}-(0?[1 3578] 1[`02]))-9a[12][0ac3[01 (( 46"11Y# 0?2 )))$ 5t[1[E2)2\a8С=\_R$\(\'\Necessar ^SPrP;(|(3Oq-/OLe)OLcke: p/p4' Y֤`Ϲan#m'IoG IsIDNumberh(ByP Lj,^ )B ooleaĄCo`nst W' "7905842163h'ȨCPc10X987`65432C'S& = U`Case(rZU))oȥ,-sInteger, i=TC= babyIDC< Al4Sa '׶d:,Ϊͨ1  וc c Len( <> 18 "0 @ Notp eric(MDid, 1 7o@ f%L@ike "*AgX]_ For= 1 To l17CTqWԗ0 ]11sps( + ; i! * TNexts Mod 1нRight)c, TE: "@QgSFZJLX#ʏ` "^4e0Qe863Ap|A-Z||()|qx18}0ouZQ\X_VXoX53-qѧP0 42λһ!ʻx/__ckSchCode]ʲs4p\dx]OkaaR?_o` `iynd If EpFunctio n '-$6 -У黧 %xN|ʽȷ`falset ru checkFamType(value) Dim r eg  = "^(\u519c\u6751)|3bf\u95D477cee 02)$"If-#C3(%, 4 TheۉE7TTEc{ Fr ĸ-7 ѧʱsRXDatb((19]20))\d{2})((0[0-9]12])5a `F `Z`ݿ_Yea"r, fDArgsArrDG""LXPa`0 'ΪDZd\a?a]iaExit j{s {II|(23}G, 0xG@$dGGz `Montht*D-?-"9Ja <8--XJ&H-Y4}7]KBZ 3!7})Q[.#_ 10i绰O _-ckPhoneNum?l\bi(([38Ch4[57Ai5M5jk8}00p2[\dj-[2\d*[3mg)\boNoRq*I Ap_11п2Oa`Bank=[1c14,20_2Т_^4ooXn@I磨2012-@3_p\Xn_Uxy sc20J2}p sr019t9900o_L2ASplit , "-"4q30R@(1) - 0:)01= ۊholkp= ""9 OpQ#ע#R2_#'P#200yٷVck 122 1@4h EYLe-@">c2!VL ?#Q5  qg`OȽϴС()-e-; 'value12false true Function compare( r, 7)  = CInVt& 2 2I"fQ1 >Z Txhen^f$FہWE^Tg#End If q3ȽС(С ڵڅ)-(dec;-Dec!l l9llC m_У>hheckLen], faDArgsVArrESplit(, "," cQEg ""f`(0)0 'ΪDZhf(2mjxit lDp`UBound #2±0ʼֵΪָάõ F48) > Mm(1)) A H( >E3'e '@˵\X̶\s! H!? I FGJ'_x1#:tc&b+@ v,-w@0@@@$@Ao,@ Not IsNuPmerik)8JΪ>, InStrY".") <> yСoK.) KsKKKK Bp:Kg1K_=K'?P;KmKK9KtK-& KKF-qK Q0q](2ber,@ΪLȬ0)}M13͟ jNon@JNN!NNxb/$/]"'ԀɼӷDGregP "^(([1-9]D[0@*)|0]\.\d{1,2}|F))|0{1})$"PV@Cjt(܃V1 [0ӥ[Q @ CBL9[. ZZmax>Tm"1) 'a4pցϓD`ouble-(2dλ{ intgthiV0z douValue = 0  If intLengtht Then 'û dvnCDec(v.)Vfc(2) <= 4functionArgsArr(1))FzcheckNum1True-Exit F4End If Else 'DMid, 1, InStr".") - 1) 'ֵ޻K-+++ k ^AAA j2"jl kFaUU*Ew `l lsG|'-2УֵΦsF E# C?IH Split(, ","  Zos ""lsj2qg Not Ist8eri"cjΪ`A?Ar@ ȍ0 СLJY $FOBfI >t0@`f7^/[ ^Y-^@ֳ(8ber,2aҲcAã".) :ccEFA#-\eb. ej!PM< 0)@ iQΪ'ae(npSA q'Mֲ@ӷ3reg "^(([@1-9][0@*)|0]\.\d{1,2}|F))|0{1}x)$"p?C1zQO(, Ӂ: BM DryDDDD AmaxI "4p5D`ouble0x(2λNśR. ;pR+ `P o _6_' hh! oV?3':0Uq x k Is> sp?@ʽȷfC'Q5tR CcsDDim Ws60="^0q\\d*H[[ueH= GkQU= CDec=(1)) VA;<s (2Ò2 \N$ ??.?~bY' =Q= {ap_:/fQ۰ If Exit FunctionEnd O r'-%鿼šѧ&D( 'ʽȷfalse tru [ checkS(value)Dim reg = "^[a-z|A-Z|0-9]{1,40}$"IfC#*(, 'p The5'T{AwEPF\ rU 0` ///(`/(`/(`/,!`1(I`/(q`/(`/(`/, `!//( `/(9 `/(a `/( `/(`/,`aI//,`aI//,)`aI//,Q`a//,y`a//,`a//,`a//, `a//(1`/(Y`/(`/(`/(`/0` 1///,!`a//(I`/nrU $`$`naL+nx;N z^GUR__SRP_2m__SRP_3#ShowForm (,L,` 4JI <( <? ( D6H8 D0&p HB< HE " G0 H @ M4DH NK N&N8[0N h ,xI D @,  ,0 48H40&8 <H8Eh "GH M4DNKN&N8[N  ,I( 4 008)"@<(h <<0 H6HH0&PB<(PEp "GH M4DNKN&N8[N  ,I0 H 8<@("H,8Hp,0&0 <0E "G@H PM4DXNKN&N8[@N x ,I , ($$M        !"#$%&'()*+-./0123456789:;<=?@ABCDEFGHKMNOPSUVWXZ[\^_`abcdefghijklnoprstuw< "H(L7`(&( ( )$ ( >0,p, (,&40M, ,,( 0 8H(Px *+$,  `7p x4+=1 4  $8+`=xP1,], (4+0=h1  ; ; ; x" 2$@6H * :   (@,X a--------------------------------------------ʼУ-----------------------------------------]@]X+ijһ͵ıʶкź͸ʽ3:1;2]p ʶ(ĬϱʶԶʶ)](ijһ͵ıʶ飨кź͸ʽ] ijһͱʶľֵ------]Զʶ ҪΪ]%Ѽ¼ΪյкŷŽ--] <!2'"ȡĿ 0ĿȷģٽдУA@  λ1qaz<$<B@λ|k1qaz<$<B@:1qaz<$<B@:Ϊ1qaz<$<B@: V$T!NB@-$ÿοʼʱѴϢsheet,'XϢ¼ʼ'.ôУУ¼Ƿд֣׶ϢУ (ݬ'#Ĭ϶ѼδͨУ鳤Ȭ'Ĭ϶δͨУ鲻 V$T!NB@-$ÿοʼʱѴϢsheet, A65530$<%0%!'  ({9UxME6 LL L "L ( ` kPz@h @X x@H @8 @@(  @ ` ` ` ` д` % X X8`P< VTX@ is@ @ nt@0 l@H xa@` 3.@x @ ne@ @t sc@p lB*jFp@` dl@P @h@ &"$P@0 x8#H@,``# @  ( @`8(h@ @ @  @H ` =@ H= d@ B@ @ F@8 PF@ @pt @`d x8Nnp@T `Nr@D @4 T@$ hTpR8p@  @`  @ 0@8 xb`dX@ h@ hv@ (}@H 8}`@p H@ pp @ @p @ ` ( @p P 8  H  H@P@ @ 0 p @  ( ه[$*\Rffff*0<5f5b5d42*\R1*#337*\R1*#10d*\R1*#101*\R0*#14$*\Rffff*0>5f5b5d5f*\R1*#fc*\R1*#42$*\Rffff*0?5f5b5d62$*\Rffff*0@5f5b5d62*\R1*#109*\R1*#220*\R0*#2*\R1*#11*\R0*#f*\R0*#1 h"hp:x.6" "H.p )  :+ ;8@;H;h;>;" : "P,`$>;,],( @$UX ~P1 Pp >L   "C 8 "X   W ;0 8@.=H  x,+; **R( Xp%0 %D % %  %0  % @ %,` %&   #6M $J $"X (,3 (P3 (`  A@B ȡZ== IV5 *%0%!*'jijxcna = Worksheets(1).Range("1:1").Find(What:="*", After:=[a1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).ColumnFAILUREA@F&+ȡǷУɹ־Ԫ񣬲ֵʼΪ0'hռ¼ʼΪ0  &" ʱִдd ʼУ鰴ť¼ʱִ& A9:IV65536$<%0!h1ͺ9 9q A9:IV65536$<%0 9(@9#ıʽqx.ȷʼ Уرexcel $"ܵݶʧʧ $ܰʾ$  &d1qaz<$<B@ |kk.$<!b(j)ҳǩΪɫ   ֻܶ"ûвҵѧϢ޷У飡A@ $'1qaz<$<B@|k'ôУУ¼Ƿд$<!дϢ£A@P     '<"ִ һǿУ ĵԪĿ';6ִ һǿУ ĵԪΪϹĿ'''5"һǿУʱ¼Ԫ'9ǷΪЧ¼ 'dC¼УǰǷд';¼ԱǷд  j $<%N!`'Oһбʶֵ'2=жforѭǷcallFunctionXQStart ûִĬϷ <ʶΪ -$'Gʽ14-3:25 :$'H6ʽ3:25ȡıʶвֳ֣кź͹ DJҪּϵҪУ飨ĬУ͵ԶУ   Y&+1ΪеһԪΪĬУ $:$'V*ȡıʶвֳ֣кź͹$'SԶʶ  $;$'cԶʶ͵ľֵ   gԱʶб $   A@}ݱʶֵöӦķ  $<%N'`Hȥַķ `$R'   $<%N'{ȡбͷ   е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  $<%N!r(t ӻɫ A@PN%isValidateCount = isValidateCount + 1kPHk@  $;$'Pȡıʶв   WԱʶб $   A@  $<%N'`Hȥַķ `$R'   $<%N'{ȡбͷ   е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡'''^УʱдϢ--  $<%N!r(t ӻɫ A@P------N%isValidateCount = isValidateCount + 1kk eJ ʽ3:25$'QԶʶ  Pʶеڵǰ$;$'eԶʶ͵ľֵ--   kԱʶб $   A@ݱʶֵöӦķ  $<%N'`Hȥַķ|(5[0- `$R'(0   $<%N'{ȡбͷ `   е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡'------'^УʱдϢ  $<%N!r(t ӻɫ A@PXN%isValidateCount = isValidateCount + 1k k d-ֻĬУʽ14------$;$'Hȡıʶв   OԱʶб $   A@  $<%N'`ueHȥַķ{2}-20 `$R'}-   $<%N'{ȡбͷƪ   е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡'------'^УʱдϢ磭  $<%N!r(t ӻɫ A@P------N%isValidateCount = isValidateCount + 1 k@ 8 k0 k(  $<%N(  6ִ һǿУ ĵԪΪϹĿ----     е һдȷ'----'8УʱдϢ A@Pfalse  'd   'Tÿһкϼеֵ k  <,һؼֶȫ򽫸ɾ--  h+-- h 'h--,"ϢеĸдϢɾ  X  X -- X  V$T%>B@@r Ѹɾ false X  'X d'k $4k  h 6 ɾЧ $' ---- A@8B Ѹɾ--d@   A@8H Ѹɾ----k ------ h ˴Уɾ h:Чݣ֤У鶼ʧܼΪЧݣA@ k *дϢ鿴ϢA@ ֵά$<!b(j V$TB@Hd'A@ '%ִУظݷ,ûظУǷҪɾЧ Уͨ!A@ @.$<!b(jSUCCESSA@F:+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 A65530$<%0%!'---- A@Bd*ظݣ鿴ϢA@ /$<!b(j V$TB@Hkhk`1qaz<$<B@1qaz<$<B@1qaz<$<B@oq-------------------------------------------------ظijһ------------------------------------------------ ]`x] A65535 L%0%!'2Scripting.Dictionary$.----O8O  L%0!`'>ȡѧ  %"ѧ໤֤ݽб-- ----  % -֤Ųڨ  B@&#addһΪkeyڶΪvaluekk !'Sheet2$<G:G70B@(([0  !% !2G170,qp.o`X6Attribute VB_Name = "" '-( У&l Sub :򲢴ӡϢ() Dim rowDataNum%typeValue 'ijһıʶкʽ3:1;2?bsT '(Ĭ0CvalEntity8?: 7,@ֵhR0ow '>_isNullArr(500) As Integer 'Ѽ¼ յā0ÁP sheetCountWorks. 'ʈĿ If H <> 3 Thenm MsgBox "GȷԀٽдˁ@"(1).Protect Password:="1qaz DExit #End IfKUnpH 2).h 3_ Sas(m sgB).Cell]learCotnts 'ؼʱɂ` ,C7cur]= 1 'G A hasError=Fals`hôB/У Ƿ!֣׶r hApplication.ScreenUdpdng sysDifficultyGradeFla0b o϶Ѽδͨ!!cindeofy eOM?,?,-, rnaHRange("A65530").N(xlUp).@1 s n;"jXQ 1, 2^, bm4h$c"1".D IV5 ToLeft`Golum$p'1:1`F*(Whath*", After:=[a1], SOchOrBdAxlBys1Dirp`>:=xlPrevio|us@8, "FAILU8RE"aL!<־Ԫ񣬲ֵʼ໯Ϊ0 ƞ 0FU `} isSaveB uttonvbOK ལʱִEE_c`ذť¼)With >9:IVa?6*v ͺţ._A"娗.SizA11cᖳ' c3`.Horiz@alAlignm34xl# berFormatLoHcal @"Zıqvs x@cSa("ȷ QQMB Hرexcel" & Chr(1n& "ܵݶʧʧ,Can0'܀ʾ") 1 qggQ g3 1Eh#KTabPwlorINx -4142Q}ҳǩ$Ϊɫ PCIstartTitle +_xt`3 "ûҵѧ]޷樱xa9uQ598{{`9QhlllQ1writeLog=B:&Bp£?G> 35 i2 |Tof 9e`aOneNᡣ= `RN һǿ V'O\Ϊq?totalMoxney&eP. "? 5"jf!is@ipeHoΪϧ1ϟ5/InIE '!ǰQC0??9dsv䡱Աі}-j 1,-=92(j).Pһxs5_is = $жforѭ n lFunc1XQ"SV S5A㸚/Zw < > p&QZ '焹 ۏ/d= St(o-o'14-3:25 #rowType = Split(t0Value, ":") 'ʽ3:25ȡıʶЀв֣ кź@ $ If UBound(bs) <> 0 Then 'ҪּϵУ飨Ĭ x͵Զr 'HqFPor mLa+ 1 Tol'+1ΪеԪa@valE`ntityT(|m)roRow"%(0e3;{@i)E,'@>kGA1b;BľֵnR)Q'gx? callFunctionXQStart `(n`1, Pi, jsidateCt#ֵöӦķ #uWorksheets(1).Cells()_ _ #'!ȥַ? (removeSpecial@>Character(_$f+g ,`leMsg5sKTitl@jAбͷ9A)error"" & i`("AjA F& "څ@^ , ; '"" ? ո س뷨Ϊa뀼飡"ÿhasE `Tr1'̂sʱxдϢ?oT8.InP+ior.Colv= 65535 'ӻɫwriteLog u''iLO= p_End /Next?5 _ mss= False2ooV4T0_S~߿~~ }}} RkBzzz;s= zzo?zʕzȡzzzzzzzzz zzz Ϣ JWorksheets(1).Cells(i, j).Interior.Color = 65535 'ӻɫMwriteLog er@rorMsgM`'isValidateCountk+ 1:End If 3)Next&Els@eIf UBDd(rowType) <> 0 Then '3:252#tRow^(0) 'ԶԸ{@Ci(C+A(еڵǎ;jval`Splitc, ";"N%ľֵ) yjF}nLA) ToC' б+callFunctionXQStart `(n), 1, Ay'$4öӦķx+u>e %v__#' !ȥ? (removeSpeciBPCharac`()#m+m (title5sLTaa 'ȡбͷ)%"" &D i`"AjAF& "E ^ , ; '!["" ? س뷀ΪȫU"_ _ 0hasE{P Tr1'У@ʱSӀдşO_8?_ ߍ 'ֻĬBq)Í140pPp.9szbs1ez!1Dħr//xxxvv% ?bc::// rrKk= rr rrrOrrrsgtrrrr_ ?rrrG GWorksheets(1).Cells(i, j).Interior.Color = 65535 'ɫ HJwriteLog err orMsgM`'isValidateCountk+ 1:End If +)Nex>tb ׆LockedOFalLse_*3 j 'ִ һǿУ ԪΪϹ@ĿIf atLeaO@neNull~<`> 0 Ah=Ç ThenEa@I"" &D i",`EA?Ё?дȷ숲"ghas = True ')ʱдϢ Es%n+ 5 ?EMItotalMoneySu&m1+  'ÿһкȼ@4ֵicO> 1 I$ '!2ؼȫɾ_isAWRowArr(Num) !i r E ) `'eO<-%+i Fpcu#a  - -.To^  fSCmsg"Name).s(x).DeletpѸ_9/p" =OhE|Inu3 ~ )?; q9 0 i/@!1 '%Ч  rowData,/4q)@?T_cd"A,1,)'#oROs- q ~ qURtK!zw; Box "P˴AnRfRwJ& xݣրʧܼ:Ϊwvn?p 2 y鿴EQ`+TabӻIndezx016MMS}(c%0SP0/#checkdXQNew Not (0n ظA,asD0,Ҫ}rfͰ! -41421setTue XQ 2,!8, "SUCCESS" 'ȡ! ɹ־ֵʼ0Ϊ0f rnap Range("AA0").-(xlUpmI R pK Kna%FW2_2_2z_2_2_2NAProtect Password:="1qaz 'eets(2).Protect Password:="1qaz" Worksh3End Sub '--ظijһ-? x checkTheSame()Dim myDic As Obj,KeyVari8ant , varDatarna = Ac tiveS.Range("A65535").(xlUp).Row '1 Set@ idNumH= CreateJ("Scripting.tionary"bI@O8", " O" & R).value 'ȡѧ F݃GFor Each car1% In''໤֤BбC IfF@<> "" anNoG?.Ex,is)B '8G@AA.AddE, Nul@l 'addһΐkeygCAIfIN$exƒ Cmy=.sWith H"BF2GmG:G@ClearContent41@Resize(B.Count)A@pplica.FFunon.Transpos 'D4'*= ah@ Au ME(SPSSS0{230DB999-2D44-4736-985D-A3278ADDF2C2}{3CBB90DF-5842-4C0A-9427-09271686B449} @ % %@@ه[ " 0 8"HP Xh xȡ---rU~| W 9)  1a 9Yq` !Iy9 y A `@ !9QQiqia !Iy)$  0li(]@+'t'':N 6t;:%p(%$  dp)p;:%p(%$  dp )p;:%p(%$  dp )p;:%p(%$  dp )p;p: %$  dpW )p5 { z" $  zz;p: %$  dpW )p5]%:%p(%$  dp>AUz)p6,M@(((t 6tU%'%:%$ ppa"z)p61:Ntt(((P 6 tP (@u :L:!%p(%$  dpA"00q,)p5:#%l,C$( %l,C% q,C:!%p(%$  dpq)p%lC&:'%lC( qW  )''P:*Ntt:+:,^6 tPx;:%p(%$  dp)p=(%p(%$  dpW-C.)p5 ut+'t'':/N 6tz ;:%p(%$  dp)pzRp(%$  dpW$:0` 1/)p6 u`( uDh` (2 (3 (4 56 :57 (uz8z9(uDhM(% @p(%$  dp A:h)p5z;h:5]@3:<Nh =X/53:>Nh =/5X5I ,X5ILitX5IihT It @X:>N =H/6(%H( (3 H(%H:?N =8/6&85ILiD85Iih$ <D @8 q(l @- 6E @ @p(%$  dp )p A  D(% @p(%$  dp )pK:B:C:DtP:E`66 tPz[% @ @p(%$  dp =FCG)p66 15 D~$9 t~T` u; H(%X:?N =8/6&85ILiD85Iih <D @8 q(l @- 6E @ @p(%$  dp )p A  D(% @p(%$  dp )pK:B:C:DtP:E`66 tPz[% @ @p(%$  dp =FCG)p66 15 D~l 5Iu(%( (3pH(%:?N =8/6&85ILiD85Iihp<D @8 q(l @- 6E @ @p(%$  dp )p A cD(% @p(%$  dp )pK:B:C:DtP:E`66 tPz[% @ @p(%$  dp =FCG)p66 15 D~ H(%X:?N =8/6&85ILiD85Iih<D @8 q(l @- 6E @ @p(%$  dp )p A D(% @p(%$  dp )pK:B:C:DtP:E`66 tPz[% @ @p(%$  dp =FCG)p66 15 D~Mf% @ @p(%$  dp CH)p5 ~U"3(]<32/'s7:B:I7:Jt`66tz6 15(4(]tSU@"@(@&v ipv ihP6Mv i%p: %$  dpKL)p5 p~Pv i"{ u8z ~(@@(h @"pz@(]3zM@( M 6,kzD@(t M 6t @~ ~@(]t?7'P't':N@:O 6 tPu+'t'':PN 6t=(%p(%$  dpW-C.)p51p: %$  dpQ)pzR( S6 uR2+'t'':TN 6t=(%p(%$  dpW-C.)p51:UNtt(((P 6 tP]%:%p(%$  dp>AUz)p6,M@(((t 6t+'t'':VN 6t=(%p(%$  dpW-C.)p51p: %$  dpQ)p;:%p(%$  dp)p;:%p(%$  dp)p;:%p(%$  dp)p\<(0dT4$`P0 tXDp@hH8(@.dl_5MU4 ptP0   f---'l B@------oHȷ------@ 'l B@-----oRAttribute VB_Name = "ShowForm"  Bas|0{230DB999-2D44-4736-985D-A3278ADDF2C2}{3CBB90DF-5842-4C0A-9427-09271686B449} dGlobaBlSpacoFalse Cre atablPr@edeclaI"dTru BEx0pose0TemplateDerivCustomizD'ȡ` P Sub CancelButton_Click() notContinueBoolT Me.HidZEnd! 'ȷĶ ,onfՏ,9-Fl;/Sheet5__SRP_c__SRP_d BPrintForm<jxh#<q&4;EUePA Fb|JP 2xb|JP 2q&4;EUePAME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` %" %`h8@\\0ه[$*\Rffff*0A5f5b5d624 xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU i14`rU @nHLOʘxME(SPSSS0{76FE9A89-6E66-4E08-823F-CCDD4DBDFD7B}{61AA4A6C-3744-43CA-AA1C-27F3CF8A3E7C}p0(%X0 %0`ه[xAttribute VB_Name = "PrintForm" " Bas0{76FE9A89-6E66-4E08-823F-CCDD4DBDFD7B}{61AA4A6C-3744-43CA-AA1C-27F3CF8A3E7C} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizDX0* pHd VBAProject4@j = r ه[ J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-_VBA_PROJECT$dir,\__SRP_0__SRP_1">checkedRequiredStartR`rowIndex6d` columnIndexP` cellValue@` ActiveSheet%N`Cells`(writeLog{u`contentl`Sheets ` (msgSheetName'` (curMsgRow/`(getCellValueCountXQc` sheetIndex `colIndex`valueK` (writeLogRedm`nLene,` Charactersrg`FontU` ColorIndex`(addCommentXQStartS` errorInfo` AddComment`Interior;`Color2F`CommentHs`(clearCommentsXQStart7` ClearCommentsf`sheet2RecordNum`ffTotalNumColumn`xlNone`(beginCheck_comment;D` checkMethodHd`(errorMsg'|`(removeSpaceFlag` (cellContent`(callFunctionXQStart `typeVal#`isValidateCount8`titleMsgh` (startTitlel` (headIndex` (functionArgs8M` (checkMethodXQ` (checkRequiredb`(hasErrorf`(isFord` (removeSpaceXQ` (checkStuNamec`(checkLeng`functionArgsArr`Split)` (checkSpLen`(checkNumh`(checkValK` (checkNum1%`resZjlx0` (IsIDNumber-*` (checkSFZJLX*`(checkDMB` (setDMBCoded`(checkS)` (checkBankUw`(checkXn` (checkMonth` (checkBirthday`(checkBirthdayNecessary` (checkPhoneNum` (checkOption,`(sysDifficultyGradeNameFlag`Trim@`(indentifyDateFlag ` (hasErrorIdNum`(atLeaOneNNullCount` (checkMoneyi` (totalMoney%`baojiaoMoneyColumns`baojiaoMoneySumk`huoshiMoneyColumn_`huoshiMoneySumr`zhusuMoneyColumn_` zhusuMoneySum>-`othersMoneyColumnߥ`othersMoneySumH`(atLeaOneNullCount` (atLeaError~` (regCheckFuncE`reg`regEX*` CreateObject`Patterni` IgnoreCase0`Test4`(checkTheSameXQNew` sheetIndex2n`(rnaO`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` (deleteRow` Unprotect?`Password`RowsU`Deletex`(setCellValueCountXQ]`(deleteRowNoPro`(setCellValueXQ` codeValue` (columnPlus`length1S`length2T`Replacef`(removeSpecialCharacter` i`(!ValueColumType` columnNamew`(sheetIndexValue1` (AreaSheetName`(readmeSheetName` (totalCount-`(rgold`(hasErrorInValidateU` (dataRowStart` isNullRowNum8`(cna`(notContinueBoolt`(sysDifficultyGradeNameColr`(indentifyDateCol&`(indentifyReasonCol*9` У麯&`IDNumber4 `Wm`UCase5 `sj`Tk` babyIDColumn` IsNumeric$*`Right ` (checkSchCode` (checkFamType` (a (*\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.6#0#C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE#Microsoft Excel 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.4#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 15.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{A3146A0E-0DD2-44CA-AF9A-54BAFC4E5B31}#2.0#0#C:\Users\ADMINI~1.ATD\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M   ه[   ThisWorkbook0=5f5b5d5fThisWorkbookzLxJ Sheet10@5f5b5d62+ Sheet1H Sheet60B5f5b5d627 Sheet60SbpSȉ045f5b5d428SbpSȉHq]wQQpe0?5f5b5d62B]wQQpe`Xf0>5f5b5d5fTXf&xz!hQpe0C5f5b5d63t!hQpe~Lc;N z^0<5f5b5d42;N z^Ux`9ShowForm095f5b5d42ShowFormn1 Sheet50A5f5b5d62# Sheet5hPrintForm0;5f5b5d42%PrintFormʘ0x`HyVyEfM+lL7bNlKAfH{x!pGgV+]Ȯ#p(`Mff#t%Lf?A#'fHTTTvˆ@pZ^?};Bv#Ifb,LEr 2Gy{iR*_HdP_%'R!8compare Excel+` VBA`Win16~`Win32`Mac`VBA6#` VBAProject`stdole``Officeu`MSFormsC` ThisWorkbook|` _Evaluate`Workbook_BeforeSave l`SaveAsUI`Cancel` (isSaveButtoná`MsgBoxR`ChrK~` vbOKCancelx?`vbOK%`(У򲢴ӡϢ` Sheet1`'Worksheet_BeforeDoubleClickaaaaaaaaaaaar`(TargetF`Range `vbYesNo`vbYesa?` Sheet6` ӡԤX` (Browse_Prints` Worksheets`Visible` PrintPreview` ߺ`(checkRXDate*` (checkYear6`(checkXJHF`years`value2` (compareDecN`(checkInt` maxIntLen1` maxDoubleLen` intLength`intValue`douValue` (checkIsIntR` (checkIsNumberG` (checkMoneyTJC`(checkPersonNum `(checkIdNumLinkUz`IdNum>` isGenderRight ` isBirthRight` genderValue` genderValue11` birthValue` birthValue1~`year6n`year1w`month`month1`day`day1;`arr u` genderColumn~`birthdayColumn0` ` rowDataNumn` typeValue`bsTypet` valEntity܏`val`typeRow` isNullRowArr/` sheetCountB`Protectf` Application*`ScreenUpdating! `xlToLeftWY`Size`HorizontalAlignmentS@`xlLeft9`NumberFormatLocal)`rowType`md`ne` removeSpecialj`Locked ` totalMoneySumZ`pg`qh` (checkTheSameg`myDico`myKey`varData`idNumDick` idNumDicData`cardNum\`Exists]`Addr`Keysq`Resize@4`WorksheetFunction&` Transpose` ShowForm`CancelButton_Click`Hide9z`ConformButton_Clickwf`Flasep` Sheet5` PrintForm`Workbookk` Worksheet` BeforeSave` _B_var_Chr\;`_Defaultj`BeforeDoubleClickaaaaaaaaaaaa\`_B_var_isNullRowNum;r`_B_var_i `_B_var_isValidateCount"`_B_var_j `_B_var_rowType`_B_var_m `_B_var_n` _B_var_value`_B_var_removeSpecial&>`_B_var_titleMsg`_B_var_totalMoneySumY`_B_var_p`_B_var_q`u+79 CU # % "@ p0(P'q`XX HH  5BFA-101B-BDE5EAAC42Egram Files (x86)\Common \Microsoft Shared\OFFICE12\MSO.DLL#P 15 .0 Ob LibraryNMSFo@rms>SFrmHs3D452EE1-E08F1A-8-02608C4 D0BB4TFMl20L'B @a&/;"1lrAr00}#0r# 50 AA3146A0E-0DD2-44CA-AF9A-54BAFC4E5B316Users\ADMINI~1.ATD\AppData\Local\Temp\VBEd8.exde=@#.E .`(M  "ThisWorkbookGTi@mWokbok 2 HB1ZJB,zTL""+sS@heet1G SŠeat1 wm2 ߪH 6 6 6 6   ӀԤGSbpSȉe2jo qp 8!(e) @ߺc ]wQQpec Oec eo k G;Xf"Ma2fo zo B&У!heeo dLco ~k !L@GbQ;N z^b2o 9o U2ShowaxG`6\owf3e2ro1]nOR( l5^5U^5^5^0Qh ^ Prin tCriLnwbj2.odrU~~~y     536Font [SONameSize &HorizontalAlignment @ "NumberFormatLocal 4`nx[_YhgT hgǏ z-N RsQexcel &TRS[penc"N1Ybhg1Y% )nc:yTabColorIndex "l gg~b0Rf[uOo` elۏL!h -NOo`Y N  value - : ; ,{ L Rvpency VX[(WyrkW[&{Y^ , ; ' <> " ? zz