ࡱ;  T8\pyxq Ba= ThisWorkbook=98X@"1[SO1[SO1[SO1[SO1[SO1[SO1[SO1Arial1[SO1h>[SO1,>[SO1>[SO1@[SO1[SO10[SO1[SO1[SO1[SO1Arial1Q[SO1[SO1[SO1[SO1[SO1 [SO1[SO1 [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@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[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_                 ! ! ! ! ! ! ! ! ! ! ! ! " " " " " "      P #P      $ ! !  % & 'a   (  )ff * + ,`   - . /  0 " " " " " "    ""@ @ @ @ @ @ @ @ @ @ !@ @ ""@ @  @ @  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@ @ 11@  @ @ 1@ @  1 1 1 287 38 487 58 687 78 887 98 :87 ;8 <87 =8 >87 ?8 @87 A8 B87 C8 D87 E8 F87 G8 H87 I8 J87 K8 L87 M8 N87 O8 P87 Q8 R87 S8 T87 U8 V87 W8 X87 Y8 Z87 [8 \87 ]8 ^87 _8 `87 a8 b87 c8 d87 e8 f87 g8 h87 i8 j87 k8 ||~8ƺL}-}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}?_)[$ -}A}8e?_)[$ -}}}9????_)???[$ -???##0. ??? ???}}:??v?_)̙[$ -##0.  }(}; ?_)}-}<?_)}A}=?_)[$ -}A}>?_)[$ -}-}??_)}A}@?_)[$ -}A}A?_) [$ -}x}B?_) [$##  }-}J?_)}-}L?_)}-}M?_)}-}N?_)}-}O?_)}-}P?_)}-}Q?_)}-}S?_)}-}T?_)}-}U?_)}-}Y?_)}-}[?_)}-}\?_)}-}_?_)}-}a?_)}-}i?_)}-}j?_)}-}n?_)}-}o?_)}-}r?_)}-}s?_)}-}x?_)}-}z?_)}-}{?_)}-}|?_)}-}}?_) 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^ĉ 1218^ĉ 12 %*8^ĉ 2/8^ĉ 2 %+ 8^ĉ_hQVL?e:SRNx,(c  -}Y5}Y  a% .Gl;`+Gl;` %/'^0 '^[0] 1{c{ }% 2hgUSCQ@wr 3;%@wr 3 Y %?@wr 4/)@wr 4 %@@wr 5;-@wr 5 K %A@wr 6;1@wr 6  F % Blʑ^ lʑ  XTableStyleMedium9PivotStyleLight1683ffff̙̙3f3fff3f3f33333f33333\`"kؚ!h,gNy[^~NmOo`U_eQNxh Oo`VV! =- KmՋ@b g!hĉRv^SbpSOo`f6f x@F>xMOhS AA@A@  1 71 xm 7sfzjh 7familyMembers suortMembersfamilyYearIncomedisasterDescribeburstDescribe 7poorStudentEntryfamilyDebtAmountfamilyDebtReasoncheckDiffName[V~+RTycheckSqyyCode3ut1uxkuNOOcheckSqyyName3ut1uTy checkYesNo 7 checkGender 7 checkYesNo checkSfzjhelT 7^S/f 7Ty 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 7checkNum0,6,2 YT 71 7[e[SVclassIdentifyReasongradeIdentifyReasons~[at^~[acheckLen0,1,33[V~+RTy 7sysDifficultyGradeName 7indentifyDate 7indentifyReason 7checkDiffName 7yr+RV 7V 7N,V 7NV 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 7isFamilyBurst 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 RyNkXQ0^_kXy 7#pek ^_kXy 7%kXQf[u[^NSpe 'YN0 NNSpeNǏ99 OYSkXQ 6 ^_kXy  7(kXQf[u[^RRRNSpe 'YN0 NNSpeNǏ99 OYSkXQ 2 ^_kXy"# 7'kXQf[u[^1YNNSpe 'YN0 NNSpeNǏ99 OYSkXQ 2 ^_kXy!" 7'kXQf[u[^a{QNSpe 'YN0 NNSpeNǏ99 OYSkXQ 4 ^_kXy 7*kXQt^~[a Q[NǏ33*NW[&{ OY [^`Qc^\[ ~N[ ^_kXy 7PyYgkXQ R [V~+RTy 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 4135012711checkInt0,2,0 DyYgkXQ R [V~+RTy 0 [SV _N_{ TekXQN TeǏ!h0kXQVI{~[veg  7FAILURE 7 4111010037 4144011845 4144011349 4144010566 4144012572 4144013712 4144010822 4144010560 4144012954 4144014509E zFGUGgHEI1JmJ1LMO@ }P JQ VR ]S7TsUTVY_WX#Z_[_Sb2dne?*ff Vg!i$=jy$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 {} {}  { $OJOYO$OO$R&`{@ 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 N0QX?>]4v6@/nB 3r3(<kXQf[uvYT<~~  <HCC@],@Ҿ9$< _Yhg<~~ i <ICC@8],5@Ⱦ9$<_ Y h g<v6admin>@dinjn7 Sheet1ggDh8hj:SW2_1 T8 TGA+ 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> HDDGHDDGHDDGHDDGH 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 ?Dn @Df @bs @bt @DnDl<<<<<<<<< <<<< <<<<<<<< 888ABCDEFGH,I,J,K,L,M,N,O,P,Q,R,S, 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*h888888<<<<<<<<<88PH  0(   >*@555 7 Sheet5ggD T8  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3UPH00(  >@ 7 Sheet6ggD   &xRRME(@h0B6 < hhZ0hjn`Hr@ʀ @8 @ꀘ h @@Px @%Ϣ%ꀰ  @  @ꀬ @ @B•p@ʀ @@ꀲ @H0B\`hB!ʘB#%@˵%hl0BhHpHpxHʘBʀ @ʀP @t8ph @ꀪ@0 @&  @v @x BzP@ꀚ @j@|@ʘB~@ @ʘpB"ʘB$&@pH Pp` 0x08@@`Pf'=ه[*\R1*#278$*\Rffff*0?5c7c0e98(*\Rffff*0?5c7c0e98\077    08  @ ` Dp 8 0 P0pD084P. ..(8(`>"$(@>`R^FX `*0$`  $  ^(^^l^0p@һṹҳ]$H=Public Const sheetNameValueTJ As String = "2ʵͳ"]$Ϣ02Public Const IntroSheetName As String = "˵"]$H]$˵`] x ¼ܵУ]$¼ͷ] "ִ һǿУ ĵԪĿ] 6ִ һǿУ ĵԪΪϹĿ] ÿһкϼеֵ] "һǿУʱ¼Ԫ] Ϣ]  %---ģУ¼ĸԪ] 8---ģУ¼ĵԪ] P Уʱ洢ַ] ¼ʱرհť]  ¼ܵУǷвϹ]  ¼ܵУǷظ] #¼ܵУǷظ] %/¼ЧǰǷдϢ ״̬] #У鷽ķֵ]$)¼ʼк]$ )ѧ֤ſʼλ]D@¼ΪյĿ]P"/ǷΪЧ ͳ 5ֶΪյĸ] p"C¼ȥոִнȥ˿ո򷵻true򷵻false] PcellԭʼĵݣϵͳûнԶûĴ֮ǰcell] 7ϴдϢʱڵ,ӦĿʼʱʼֵһ] ] ] RڸݱʶòͬķʱжǷforѭ Cell_SelectionChangeҪõñ]$¼ʡصȼ¼ڵ]$+sheet±Ƿ] 0]$h@)е]$`,϶]$p#϶ʱ]$%϶ԭ] -Oʶ϶ǷͨУ 0-δͨУ 1-ͨУֵΪ 2-ͨУֵΪ] $Oʶ϶ʱǷͨУ 0-δͨУ 1-ͨУֵΪ 2-ͨУֵΪAAttribute 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 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*_'_%__SrU@@@@~xXq $ 1 )A Q% Q 1 1!Q!QdQ!` 1#%`1&&&&'A''q(a#(#((A)` pl))+++,1,q,A----!....!/00h00!1h'%ggD08Z8`0l@8g@\gLpI(pg\h8Z8h8hg{gg\h8Z8h8hg\h8Z8h8hg\h8Z8h8hg^h8Zp8h8hgg pg4p 8Z888g pg pg^h8Zp8h8hgh8Z8h !8hgJ!@p(pg8"#Z$ 8V%hh&8hgV'Ipp8( p8g g(?>gg|)h8Z8h*H8hg+,g -ggn)h8Z8hH8hg.g/0gg 81Ipp2O3O(? p8Rgg\h8Z8h8hg{gggdh8Z8h458hg!x>gLp6I(pg p(g\h8Z8h8hg{gg pgh8Z8h,7O`  8hg!xg( !kxg8g9g:g;<g;=g`g>g p?g(H&k"gzH @h8Z8h@8hg pAg;\gVBIa (gVCIa (g"qnPgFqmlqnlgv @CIa (g$gKfgvDIa (g>qmlqnlpfgj @Eh``H` 0hgl @H @h8Z8hH8hg$H 0g0lJglH @h8Z8h8hg~EOFOHOGOpO8HO`< p8gg @H @h8Z8hIJ8hg< ggpgg6 gAp>gvDIa (g>qmlqnlgj @Eh``H` 0hgl @H @h8Z8hH8hg$H 0g0lglH @h8Z8h8hg~EOFOHOGOpO8HO`< p8gg @H @h8Z8hIJ8hg< ggJgg"qnPg$gKgvDIa (g>qmlqnlgj @Eh``H` 0hgl @H @h8Z8hH8hg$H 0g0lglH @h8Z8h8hg~EOFOHOGOpO8HO`< p8gg @H @h8Z8hIJ8hg< gg2gggvDIa (g>qmlqnlgj @Eh``H` 0hgl @H @h8Z8hH8hg$H 0g0llglH @h8Z8h8hg~EOFOHOGOpO8HO`< p8gg @H @h8Z8hIJ8hg< gggggx @H @h8Z8hK8hgH~ g69T98C7lgZEOLO=OMOp`<pgg< g ``$ggp:pgg`g `Ag   g>l`Xl(Rgxl`h8Zp8hNO8hgX(g"l`g>ggx gg2 g`!gKJg4@ggNkppggg 6 g^8pP OQO( p8ggP!gLpRI(pgdh8Z8h458hgNh8Zp8hS8h$gg pTg&gT #gLpUI(pgdh8Z8h458hgVVIpp8( p8gh8Z8h !8hgJ!@p(p$ggLpWI(pgdh8Z8h458hgNh8Zp8hS8hggg\h8Z8h8hg\h8Z8h8hg\h8Z8h8hg{ %lF(x0p@(H@HX0p` `P h8hp8Hi@ aS SK*   rU@@~~~~~~~~~ ~~~6~~ ~~~ ~ ~~B"Q;5E&ft  aAa A"aAaa @ a a !QA A !A!!aPQ a 2223Q3333//4A4q4444!5A5q555616a6666!7Q777qaa  1 aAQ!  VBAProject ThisWorkbookSheet1Sheet6ӡԤߺУ麯ShowFormSheet5 PrintFormF6C:\Program Files\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLLVBA A qPF  D:\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 4/jJ|ۘ /C:\Users\yxq\AppData\Local\Temp\VBE\MSForms.exd  У򲢴ӡϢ checkTheSame Browse_PrintF"_KCyc ?F.> GD >ʾDFWorkbookWorkbook_BeforeSavex .`/f&Tnx\OX[excel YOX[ pQVBE7.DLL`  a nx[ , &|~\ۏLhg!h YNOX[ pQ Sm ?S Q(~ Oo` Nxh f,GetRowOrColIndexcheckDMB @JJ  8PhpxFF&mFUnprotect CellsClearContentsFcheckTheSameXQNew&m 0]\OhpevNcknx N}ge!jgT QۏLdk!h 1qaz.PasswordProtectEnd&t  A65530 RangeRowcheckedRequiredStartwriteLoggetCellValueCountXQ writeLogRedaddCommentXQStartclearCommentsXQStartbeginCheck_commentcallFunctionXQStart regCheckFunc  deleteRowsetCellValueCountXQdeleteRowNoProsetCellValueXQ setDMBCoderemoveSpaceXQremoveSpecialCharacter IV5Fq.aCҋ F  A C.LizDF Worksheet 'Worksheet_BeforeDoubleClickaaaaaaaaaaaaFF 4`nx[_YhgT hgǏ z-N RsQexcel Tab:! FAILURE A9:IV65536Font [SONameSize &HorizontalAlignment "NumberFormatLocal &TRS[penc"N1Ybhg1Y% )nc:yColorIndex "l gg~b0Rf[uOo` elۏL!h -NOo`Y N value - Q*(~ : ; ,{ L Rvpency VX[(WyrkW[&{Y^ , ; ' <> " ? zzL"VD-O~]A!*]~wN7r(tcheckRequired checkStuNamecheckBirthdaycheckBirthdayNecessary IsIDNumber checkSFZJLX checkSchCode checkFamType checkMonthcheckXJHcheckPhoneNum checkBankcheckXn checkOptioncompare compareDeccheckLencheckInt checkNum1checkValcheckNum checkIsIntcheckIsNumber checkMoney checkMoneyTJcheckPersonNumcheckIdNumLink checkSpLencheckSa *\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\Program Files\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.8#0#D:\office2013\Office15\EXCEL.EXE#Microsoft Excel 15.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\System32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.7#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLL#Microsoft Office 15.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{34FC7FC0-6A2F-4A08-B602-807CF6FDDB98}#2.0#0#C:\Users\yxq\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E.`M ه[  ThisWorkbook0>5c7c0e98'ThisWorkbookzLx Sheet10A5c7c0e98= Sheet1H Sheet60C5c7c0e98I Sheet60SbpSȉ0=5c7c0e7dJSbpSȉH]wQQpe0@5c7c0e98T]wQQpe`Xf0?5c7c0e98fXf&x!hQpe0D5c7c0e99!hQpe~e;N z^0<5c7c0e79;N z^Ux`9ShowForm095c7c0e79)ShowFormnw Sheet50B5c7c0e983 Sheet5h PrintForm0;5c7c0e795PrintFormʘ0`xH Ov[dpn9v̳qJo]P_Jp#AsGmx^N"m ?D BQNJ2 W}i>O}*[95OM:@LSLhBQ9KO*db=Dfը&H=q -([!8compare Excel+` VBA`Win16~`Win32`Win64x`Mac`VBA6#`VBA7#` 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` ߺ`(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`sj`Tk` babyIDColumn` IsNumeric$*`Right` (checkSchCode` (checkFamType` (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` BeforeSave` _B_var_Chr\;`_Defaultj` Worksheet`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` "$' =I K)Ug3 5 "@ p0(P'q`XX HH   (w9UxME6 LL L "L0 :@`@kP@ @ @ @ @X ` @@ ` ` ` `. ` @8%H(x(  pHH0@(`x0N2hfj@8 @0 @X @p @ @ @ @ @ @0p @h T<|X@P @8 @z 0846b@ x#@`#@` (@`x(@ @ @ @ `=@x =`v@` @"H @ 0 8F@x  F@ @ @ xN@ N@ @ T@p TdJ&@h @` @r`H @0 @ bd@ h@@ 0hXv@h @}@ h}h@ @@   X @p @ HX @h @ @ @ ( h h @  @  @  @ه[$*\Rffff*0<5c7c0e79*\R1*#3c7*\R1*#12d*\R1*#121*\R0*#17$*\Rffff*0?5c7c0e98*\R1*#11c*\R1*#42$*\Rffff*0@5c7c0e98$*\Rffff*0A5c7c0e98*\R1*#129*\R1*#278*\R0*#2*\R1*#11*\R0*#f*\R0*#1 h"hp:x.6" "H.p D  :L \8@\H\h\>^":  4P, `$ >^,J( @$X ~PV Pp  >|  "n 8 "X    \0 8@.dH x,L \ * *(X(p%0%D% % %0 %@ %,` %&  ( #6z $J  $"X (,V (PV (`" (,LF` 4Jv <($ <? ( D6v8 D0>p HBj Hl "G$0H@M4lHN~N&N80N h ,xI D@,  ,0 48v40>8 jH8lh "G$HM4lN~N&N8N  ,I( 4008)"(@<($h <<0H6vH0>PBj(Plp "G$HM4lN~N&N8N  ,I0 H8<@(" H,8vp,0>0 j0l "G$@HPM4lXN~N&N8@N x ,I ,($$x  < 6H(LZ`(&( (   )$ ( >0,p,  (,>40x, ,",( 0 8H(2Px *4 +$N  `^p x4LdN   &4 $8L`dxPV,J  (4L0dhN  \ \ \ x"2$@6H * :   (@,X a--------------------------------------------ʼУ-----------------------------------------]X]p+ijһ͵ıʶкź͸ʽ3:1;2] ʶ(ĬϱʶԶʶ)](ijһ͵ıʶ飨кź͸ʽ] ijһͱʶľֵ]Զʶ]%Ѽ¼ΪյкŷŽ]( N!D'"ȡĿ 0ĿȷģٽдУA@21qazN$NB@|k1qazN$NB@L1qazN$NB@L1qazN$NB@L h$f!`B@-$ÿοʼʱѴϢsheet,'jϢ¼ʼ'.ôУУ¼Ƿд֣׶ϢУ ('#Ĭ϶ѼδͨУ'Ĭ϶δͨУ h$f!`B@-$ÿοʼʱѴϢsheet, A65530$N%B%!' A@T ȡ IV5 <%B%!<'|xcna = Worksheets(1).Range("1:1").Find(What:="*", After:=[a1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).ColumnFAILUREA@X&+ȡǷУɹ־Ԫ񣬲ֵʼΪ0'zռ¼ʼΪ0 0 8" ʱִd ʼУ鰴ť¼ʱִ A9:IV65536$N%B!z1ͺ9 9q A9:IV65536$N%B 9(@9#ıʽqx.ȷʼ Уرexcel $4ܵݶʧʧ 6ܰʾ$2 8d1qazN$NB@|kk.$N!b(|)ҳǩΪɫ   "ûвҵѧϢ޷У飡A@2'01qazN$NB@|k'ôУУ¼Ƿд$N!дϢ£A@b      '<"ִ һǿУ ĵԪĿ';6ִ һǿУ ĵԪΪϹĿ'''5"һǿУʱ¼Ԫ'9ǷΪЧ¼ 'vC¼УǰǷд';¼ԱǷд " | "$N%`!r'Oһбʶֵ'2=жforѭǷcallFunctionXQStart ûִĬϷ <ʶΪ -$'Gʽ14-3:25 :$'H6ʽ3:25ȡıʶвֳ֣кź͹ DJҪּϵҪУ飨ĬУ͵ԶУ   Y&+1ΪеһԪΪĬУ $:$'V*ȡıʶвֳ֣кź͹$'SԶʶ  $;$'cԶʶ͵ľֵ   gԱʶб $  " A@}ݱʶֵöӦķ  "$N%`'rHȥַķ r$d'   "$N%`'{ȡбͷ  " е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  "$N%`!( ӻɫ A@bN%isValidateCount = isValidateCount + 1kPHk@  $;$'Pȡıʶв   WԱʶб $  " A@  "$N%`'rHȥַķ r$d'   "$N%`'{ȡбͷ  " е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  "$N%`!( ӻɫ A@bN%isValidateCount = isValidateCount + 1kk eJ ʽ3:25$'QԶʶ  Pʶеڵǰ$;$'eԶʶ͵ľֵ   kԱʶб $  " A@ݱʶֵöӦķ  "$N%`'rHȥַķ r$d'   "$N%`'{ȡбͷ  " е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  "$N%`!( ӻɫ A@bN%isValidateCount = isValidateCount + 1k  k d-ֻĬУʽ14$;$'Hȡıʶв   OԱʶб $  " A@  "$N%`'rHȥַķ r$d'   "$N%`'{ȡбͷ  " е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  "$N%`!( ӻɫ A@bN%isValidateCount = isValidateCount + 1k@ 8 k0 k(  "$N%`( " 6ִ һǿУ ĵԪΪϹĿ     е һдȷ''8УʱдϢ A@b  'd   'Tÿһкϼеֵk  <,һؼֶȫ򽫸ɾ  z+ z 'z,"ϢеĸдϢɾ  j  j j  h$f%PB@Rr Ѹɾ  j  'j v'k k  z 6 ɾЧ $'  A@JB Ѹɾd@   A@JH Ѹɾk  z ˴Уɾ z:Чݣ֤У鶼ʧܼΪЧݣA@2k *дϢ鿴ϢA@2$N!b(| h$fB@Hd'&A@ &'%ִУظݷ,ûظǷҪɾЧ Уͨ!A@2.$N!b(|SUCCESSA@X:+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 A65530$N%B%!' A@Td*ظݣ鿴ϢA@2$N!b(| h$fB@Hkhk`1qazN$NB@1qazN$NB@1qazN$NB@oq-------------------------------------------------ظijһ------------------------------------------------@]] A65535 ^%B%!'2Scripting.Dictionary$.O8O  ^%B!r'>ȡѧ  %"ѧ໤֤ݽб   %-֤Ų  B@&#addһΪkeyڶΪvaluekk ! 'Sheet2$NG:G7BB@  !$%& !DG17B,"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".DIV5 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{PTr1'У@ʱ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 xME(6 LLH V` X IX xIZ `\ b(`  id l`  In IX Ip  tX` 8  id ~0`   In IX IZ I  `   'In IX IZ  ` @ 2In `I IX IZ I  ` 8 GI XIn xIX IZ I  ` 0 EI PIr `  `  SI +( ` X jIn xI* i,`.  ` ( {Ir HI> hI@ @B J8 `  In  IF  T `Hk In  IX  Ip  Ir (  V ` h In  IF  X `Hk In  IX @ Ip ` Ir (   ` Ir  In  IX 8 Ip @B @Z @\ ` In IX 8Ip `>`^`` d`  Ir @   0(  8 XT% x@T N@ @ @0 @ @H @`x @` @H @ ` 0(0hH@X X0N@ @ @ @ @ @x @` @H 0ه[$*\Rffff*0@5c7c0e98*\R1*#3c7*\R1*#12d*\R1*#121 B       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 x0 6 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&$|&$&'$ @'$P' `'h' p' '$t'$&($ (( 8( $@(H( P(p( ^x( ("()@ )&`) )) )))) b) X*h** z* &+ 8+ H+P+p+ fx+ ++, t, &, , ,,, b, P- p----&(. P. `.h.p.. ^.. /0/@8/&x/ // ///0 ^0 h0 000X0&1 01 @1H1P1p1 ^x1 1 12 2T(2&2 2 2222 n2 `3 33"33&`4 4 4444 j4 @5 `55"55&H6 p6666 n6  7 @7`7"p77&(8 P8 `8h88 P88899&9 9 999: R:h:::X:&: ; 0;8;@;`; bh; ;$;<@<&X<< <<$<,<<==== =@= jH= =="=>&> >>>H> (?L0? ?? ? &8@ `@ h@ x@@@@@ Z@ A(AHA@PA&A AAAAAB j B "BBBB dB &PC xCCbC hC ,`D D &(E PE `EhE pE &0F XF hFpFxFFF ^F G& GHG@PG&G GG&GGH H Z(H H&HH@H&I 8IHI&PIxIII ZI J,(JXJ@`J&J JJ,JKK8K |@K K$KL(L@0L&pL L L"LLLM |M M MM@M&N 0N@N HNhNpNN |N O$0OXO@`O&O OO$OPP0P d8P P P@P&Q @QPQ2XQQ xQ R60R.hRRR( R2R( R1R( R2S( S1 S0S8SJPSSSSSS fSB @T HT<PTT TT$T$U8U@U HU \U B PV,pV 0V@V"W ^8W 6WWWX(X0HXHxXXXXXXY Y "Y Y .YB  Z (Z$8ZB`Z Z Z Z Z Z ZZ[ [ [ [ [ [B \"\ 8\P\X\ `\h\p\ x\8\\2\] (] H]X] `]h] p]] F]]] ] ^ *^@^ H^ ^ _B _ _*@_ 4p__ _B @`^H` vh` ` ` 0a HaB `a*haa aB 0b^8b vXb xb bB 0c 8c "Pc xc8c2cd d@d PdXd `d hdxd"d0d d(e8e@eHe LXee&eee ee fB ffVfg 80g hg g:g4g$h8h"Phxhhh hB  i(i60ihixiiiii i-----------------------------------------УУдϢʾ ע----------------------------------------------------------- Ԫ] X Z ^%`'\ \'Vd('Vki--------------------------------------------д־ ¼ϢʾһϢ-------------------------------------------- d j h$f,` j 'jiX------------------------------------------------------ ȡָcellֵ-------------------------------------------------------------( X p n$N%`!r'li--------------------------------------------д־ ¼ϢúɫʾϢ-------------------------------------------- d'v d j h$f,` v j h$f%`%x!z(| j 'jii--------------------------------------------עʼУ飩-------------------------------------errorInfoעX 1Worksheets(sheetIndex).Unprotect Password:="1qaz"  X Z n$N%`B@ X Z n$N%`!(W ӻɫ X Z n$N%`!(Pii--------------------------------------------ɾעʼУ飩-------------------------------------01Worksheets(sheetIndex).Unprotect Password:="1qaz" X Z n$N%`B@ X  Z  X Z n$N%`!(|d  X Z n$N%`!(|kpihr---------------------------------------------ʼУ Ƿӻɾעõķ----------------------------  Уʧ X Z n$N%`!d жעΪ n X Z A@~V עd"Ϊգȥǰע n X ZA@N ע n X Z A@~k1 MsgBox "" & rowIndex & "" & errorMsgd:УɹжǷעУʧʱעȥ n X ZA@ ,#ȥո,ʾ XУ ZУַ"$4 "$4"а˿ոϵͳԶΪA@bd`kXkPiH----------------------------------------------------------------------------------------------------------------------------------y--------------------------------------------ݱʶöӦķ(ʼУ)-----------------------------------------------------------------------------------------------------------------------------------------------------------------------ѴϢдб X Z n$N%`'r  Z n$N%`'Iȡбͷ Ϊϲеıͷ  Z n$N%`' X e  Z n$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 n X Z$'  X е Ϊգ'')УʱдϢ A@bRMsgBox "" & rgold.Row & "е" & Chr(10) & titleMsg & "Ϊգ"k0 n  X Z A@'a=================================2 ִѧУ========================================== checkNameKT n X ZA@@ȥոķ X Z n$N%`!r'r r$'  X е ;дȷΪ֣ȴ1ܳ20ַ''%УʱдϢ A@b  'k` n  X Z A@'Z================================= ִеijУ==========================================checkLenKT r $'  ,$'$ ` ΪDZΪ̶ȹ X е .дȷΪաд򳤶ȱΪ$ λ'$ ed ΪDZΪȷΧ X е 4дȷΪաд򳤶ȱڵ$ λҲ$ λ'$ ed ΪDZΪ̶ȹ X е &дȷΪգҳȱΪ$ λ'$ ed ΪDZΪȷΧ X е ,дȷΪգҳȱڵ$ λҲ$ λ'kH '0УʱдϢ A@bk n  X Z A@'Z================================= ִеijУ========================================== checkSpLenKT r $'  ,$'$ ` ΪDZΪ̶ȹ X е .дȷΪաд򳤶ȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ X е 4дȷΪաд򳤶ȱڵ$ λҲ$&λֻΪַ֣'$ ed ΪDZΪ̶ȹ X е &дȷΪգҳȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ X е ,дȷΪգҳȱڵ$ λҲ$&λֻΪַ֣'kx'0УʱдϢ A@bk8 n  X Z A@'h================================= ִеijУ飨Numberͣ==========================================checkNumKT r $'  ,$'$@ ΪDZΪ̶ȹ X е GдȷΪգдΪ֣0λȲ$λСλ$ λ'$ ed ΪDZΪ̶ȹ X е ?дȷΪգұΪ֣0λȲ$λСλ$ λ'kh'0УʱдϢ A@bk( n  X Z A@'[=================================ִֵΧУ==========================================ѴϢдбcheckValKT r $'  ,$' X е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@b& isValidateCount = isValidateCount + 1k8 n  X Z A@'_=================================ִеΪֵУ==========================================ѴϢдбcheckIntKT r $'  ,$'$@ ΪDZΪ̶ȹ X е 4дȷΪգдΪ$ҳȲ$ λ'$eEΪΪ̶ X е 0дȷΪգұΪڵ$ҳȲ$ λ'k!'0УʱдϢ A@bkH! n  X Z A@'`================================= ִе֤У========================================== checkSfzjhKT n X$l'S ȡд  X е &дȷ֤Ϊգ''0УʱдϢ A@bd  ֤ r Z$'O ֤У :֤У X е MдȷΪѧ֤ţһλΪĸXıд''4УʱдϢ A@b  'kd r$'  X е EдȷΪգҳȱڵ1λҲ18λ''4УʱдϢ A@bkkk n  X Z A@'X================================= ִ֤У================================== checkZjlxKT checkZjlx r1$'  X е дȷ''(УʱдϢ A@bd` checkZjlx n X ZA@k8 n  X Z A@'\================================= ִѧŵУ==========================================checkXJHKT r0, 1, 50$'  X е KдȷΪգΪճȱڵ1λҲ50λ''0УʱдϢ A@bk n  X Z A@'`================================= ִѧϢIDУ==========================================checkXJHKT r$'  X е EдȷΪգҳȱڵ1λҲ50λ''0УʱдϢ A@bk@ n  X Z A@'[=================================ִпУ==========================================ѴϢдб checkBankKT r$'  X е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@bk n  X Z A@'W=================================ִ꼶У========================================== checkYearKT checkYear r$'  X е дȷ''(УʱдϢ A@bdH checkYear n X ZA@k  n  X Z A@'W=================================ִѧУ==========================================ѴϢдбcheckXnKT r$'  X е )дȷʽ2012-2013ȣ''-УʱдϢ A@bk n  X Z A@'W=================================ִ·У==========================================ѴϢдб checkMonthKT r$'  X е &дȷʽ0112ȣ''-УʱдϢ A@bk8 n  X Z A@'g=================================3 ִеУ(DZ)==========================================ѴϢдб checkDateKT r$' 2Уʧ X е дȷдʽΪ"$4 xxxx-xx-xx"$4 2013-02-21''-УʱдϢ A@bkX n  X Z A@'c=================================ִеУ飨==========================================ѴϢдбcheckDateNecessaryKT& r$' 2Уʧ X е дȷдʽΪ"$4 xxxx-xx-xx"$4 2013-12-21''-УʱдϢ A@bkx n  X Z A@'g=================================ִеijУ飨==========================================ѴϢдбcheckBirthdayKT! r$' 2Уʧ X е дȷдʽΪ"$4 xxxx-xx-xx"$4 2013-12-21''-УʱдϢ A@bk n  X Z A@'J=================================10 У绰====================== checkPhoneKT r$'  X е дȷдʽΪ"$4-̶绰 ֻ"$4 ''%УʱдϢ A@bk n  X Z A@'L=================================checkOption У鱸ע ====================== checkOptionKT rB$'  X е )дȷȲܳ200ַ''%УʱдϢ A@bk n  X Z A@'\================================= ִ϶ѼУ==================================checkDiffNameKTcheckDiffName r $'  X е дȷ''(УʱдϢ' A@bd` checkDiffName n X ZA@ r$1ͨУֵΪ'd'kk n  X Z A@'d================================= ִ϶У(DZ)==========================================checkIdentityDateKT% r$' 2Уʧ X е дȷдʽΪ"$4xxxxxxxx"$4 20130221''-УʱдϢ A@b'd   r$X$϶ȼΪգ϶Ϊլ'  r$e](϶ȼƲΪգ϶ڲΪ'dp X е vдȷ롰Ѽ϶ơͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơǷͨУ''0УʱдϢ' A@b'kxkp n  X Z A@'T================================= ִУ==================================checkMZKTcheckMZ r$'  X е дȷ''(УʱдϢ A@bd0checkMZ n X ZA@k n  X Z A@'d================================= ִ϶ԭУ(DZ)==========================================checkIdentityReasonKT'0,1,30' r $'  X е 5дȷȱڵ1λҲ30λ''0УʱдϢ A@bdp   r$r1϶ȼΪգ϶Ϊ,϶ԭΪ   r$ew8϶ȼƲΪգ϶ڲΪգ϶ԭΪ   r$e X е dдȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬''0УʱдϢ A@b'd X е дȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơ϶ʱ䡱ǷͨУ''0УʱдϢ A@b'kEkE n  X Z A@'X================================= ִ֤У==================================checkIDCardTypeKTcheckIDCardType r $'  X е дȷ''(УʱдϢ A@bd0DcheckIDCardType n X ZA@kD n  X Z A@'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType r $'  X е дȷ''(УʱдϢ A@bdBcheckDisableType n X ZA@kB n  X Z A@'T================================= ִвмУ==================================checkFamilyIncomeTypeKTcheckFamilyIncomeType r $'  X е дȷ''(УʱдϢ A@bd AcheckFamilyIncomeType n X ZA@k@ n  X Z A@'v=================================14 checkGender ִǷΪСŮУ--================================== checkGenderKT checkGender r1$' '-ԱдУ֤Ź X е дȷ''(УʱдϢ A@bdP? checkGender n X ZA@k ? n  X Z A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoKT checkYesNo r $'  X е дȷ''(УʱдϢ A@bd= checkYesNo n X ZA@k= n  X Z A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkSqyyNameKTcheckSqyyName r $'  X е дȷ''(УʱдϢ A@bd <checkSqyyName n X ZA@k; n  X Z A@']=================================checkTerm ִѧУ--================================== checkTermKT checkTerm r $ X е дȷ''(УʱдϢ A@bk: n checkTerm r $ X Z A@'r=================================checkAtLeastOneNNull ִһΪǿ--==================================checkAtLeastOneNNullKT  'A"ִ һǿУ ĵԪĿ r$ r=Ϲ  r ' Z KTF  r ' KTF  r ' KTF  r ' KTF  r 'n8dϹ  'F6ִ һǿУ ĵԪΪϹĿ    'k@8'n08i(8_--------------------------------------------ʽ-------------------------------------]pVBSCRIPT.REGEXP$.7RegExΪʽ (4 ȫֿvba\ת  ( .ʽ ( 5ǷִСд r %'3 ִ.i6-----------------------------------------------------------° Уظ˵Ѿûиʽ------------------------------------------------------------V-----------------------------------------------------------1ѧ׶ڱڲ(sheetѧ׶ A65535 $f%B%!'*cna = getTotalColumnCount(sheetIndexValue) h$f!`B@1&ÿУظʱʱѴϢsheet,'jϢ¼ʼX==============================ѧ׶ڱڲ==================================0ðÿԪغ֮ǰнбȽ      $f%`' "   "  $f%`'$  $.ѧͬ˵ظݹ " еݺ͵ ֤ظ!!!!' A@b*ѴϢ'&k333i2-----------------------------------------------------------һ ֵȡֵ------------------------------------------------------------ֵҵֵڵлkeyWord ҵĹؼ'kbn л ֵΪ rowrow'(]the find result object *2 64 :8 A1:A65535 n$N%B%0.. . ,row .!'(d 1 .!<'(k1k1i0------------------------------------------------------ ִڹУ(Ϊ)-------------------------------------------------------------value value1 cellУ鲻ȷfalseУȷtrue @0˵ΪDZ >$'z/k/k/]'Dijһļ¼ A65535 H$f%B%!'FB' H rrow$('B=ȡ  B F  H$f%` r D 'Dd.y.k.  " B B D  " H$f%`X >X LжϹǷcell'y.k. "#ʱcountĿΪùеĿi------------------------------------------------------- ִɾijһвexcelܱģ-------------------------------------------------------------sheetIndex rowNum к1qazN n$NB@L F n$N%PB@R/ Ѹɾ- Worksheets(sheetIndex).Protect Password:=123iP,------------------------------------------------------ ָcellֵ-------------------------------------------------------------8 1qazN n$NB@L r X p n$N%`(rip+------------------------------------------------------ ִɾijһвexcelûб-------------------------------------------------------------sheetIndex rowNum к F n$N%PB@R/ Ѹɾi`*------------------------------------------------------ ָcellֵ------------------------------------------------------------- 1qazN n$NB@L r X p n$N%`(ri)------------------------------------------------------ ݴеֵǰʱѾͨУ飩------------------------------------------------------------- ]X p  X p n$f%`!rX '\'Dijһļ¼ A65535 H$f%B%!'FF H rrow$('BAȡ  B F  H$f%` r D 'Dd'y'k'  " B B D  " H$f%`!rX '> > \X 1жϹǷcell " H$f%`!r'Z ZX X p \ n$f%`(ry&d& >ESheets(sheetIndex).Cells(rowIndex, colIndex + columnPlus).value = "0"dP& X p \ n$f%`(rk &k& "i&------------------------------------------------------ ȥcellеĿո------------------------------------------------------------- ]XԪ]p3Blength1ʾcellԭijȣlength2ʾִȥոַ'ĬΪûȥո2 Worksheets(sheetIndex).Unprotect Password:="1qaz" X p n$N%`!r'> >'^ ^Gzj*"ԪΪգȥո > '`%length2Ϊոһγֵλ `ַո > $b'> >X X p n$N%`(r'kx#ip#------------------------------------------------------ ȥַ-------------------------------------------------------------]-[\uFF00-\uFF06][\uFF09-\uFFFF]|[\s,;'<> "?^]+'  r$'ddx"'dkh"i`"X"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='/TgBQooo_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λ)Ϊ ĸX дhA+AlEisValidateCount#{M+ 1`En~d ;WOSFZJLXO)vL_A!I‹ȃEڵ1λ18e?H ?H>G{/?   beginCa_comme]sheet/Nڈ,ߴ i0sForha '= ִ/ѡ=Case "B!JC@DMB((, d"1"4mkGϔ5eo{& o{b{1}/1yy\o0G!LsetCodz, )'8&,U-ZZ-/qO-*B-ѧŵ- -XJH-EJ-Len"0, 1, 50O-% ../y!c#ccc50c 22222%]_._.E_._..*.ID..d\. . S9[.\....??- ---/-------j؟+-)п== 'ѴϢ,б Case "checkBpank" :P4MethodXQ = T(valu e)`\If N ot0@Then2;errorMsgk"" & rowIndex "еAtitle& "дȷΪ֣ ڵӂ'functionArgsArr(0),ҲX+1zahasEcaTrue 'Уʱ writeLXog 'E nd IfbeginCA_comment sheet\,o,columnD 'isForBִ>K 5Ye arhҳDMB(B, ¶, 1H@B?O?OßN]ElseI set*Codd+KE{IS W_XckE_X X Y==YѧOY\ ]XnO]\Xn"[cʽ2012-3ȣ^"__C__JUU8/W&*·ݟ**І*Month**Ј߲*l? ?\X?& ?7*0112*}*PJ*K *V*U?R *O'3 !+A+(DZ)+++Date"> CPo,Airthday,v'/එ, 'ʧYOO/H .Ϊ!Chr(34rx-xx  ᭁ[-0\10 000 j0000000g?,00ѩ_00 0NecessaryO1r CO1H1&1(11@1 _V__$1113-1 11;дϢ writeLog errorMsgEnd If>beginCheck_comment sheetIndex, cMethodXQ, rowolumn ~isFor = True '=ִеij飨4хдбCase "qBirthday" ' jNecessary(value)#If Not The0n 'Ȁ ?ʧ<%^#"" &i"ASPOt0itleдȷʽA Chr(34) x-xx  2013-12-21"+hasE+ 'yʱ?k&10 %绰Sb'(\Phone3ZNum?vYvX,TTT-̶# ֻ$VTS}!SP???LEO ptionBQע P&CQãP, 66Ъ_QK_Q_QȲܳ200KK}% %, c %! _# a϶ѼqO&GODiffNam/PSoP DMB(, }, funcA0Args_)B)XQ~ORC |x|||?N?t(_x/Lsysaiculty GradeFlag 0?R_qEls E}setCod? p  TriuoQ"ͨa(ֵΪi 1Y2/@ A /B/B/B/B?Foh>&Bu(ǁ)oO{BId`ityDatexOC@CĿAA?ComsgQE"q1S02?> GGG DDyiPntifJ-808i> A/EQnȼn!E?϶Ϊ indentifyDateFlag = 1lElseIf sysDifficultyGra deNam2 And Trim(value) <> "" Then 'ȼƲ32_,errorMs"" @& rowIx"е@title& "дȷ롰0zxͬʱ|zҁͨУA!(Ƿ"iha sEA5@xTrue@ 'dд@ϢcheckMethodXQ@Fa@writeLo\g W Q0EIfbeginCA6_comm sheeti}, <,o0lumnD W6isForD_ '= ִj^ =_g$_߼߼ ߼߼ ߼_ʼP.__,yck_==14Ge}r_ǷΪСŮ`--0113P Z=`0"1"_/0xXQ _D)I0dNum9s𱇣֤4___U4__4O-6bF5exe'55Jϯe ϔ05YesNo@555~55"/# 5Ax5f@_6_6t1111Ċf* f//y/e///G/////*///? /SqyyName/2e/0/0@/0/0t/0/0/0/0/0/0/0,0, writeLog error Msg  0ElsedZsetDMBCode "checkSqyyName", sheetIndex, row column pnd If@beginCg_comment eMethodX Qt,wisFor = Tru{ '=9TermִѧƀУ--b= rCas'"If Not ;(, value, functionArgs) Then%ApE<"" &j"еtitleдȷ,hasEDV 'IʱдϢ*|UAtLeastOneNNu llTһΪǿ: 9aACou@p= + 1 :' !A> ĵԪ8Ŀ=\"\Money(Z) A:B <> 0Z 'aG 0GPtotal Q+CgSelect tޘm"baoPjiaoC:1 Sum-, huoshic _ Bzhusu?L# others?l# _ E@dTsJ| '23 =pG>6>>>Ϊe@K'c+ h+ " Jb~/3Ft '-ʽo- a regB(})8DimaEX As ObFjISet= Create("VBSCRIPT.REGEXP")q'RegExΪG EX.GlobalpF~'ȫ ֿ''vba\ תPatternB RʽI gnoreB8= `Exit 2@e%7iCfLDataCount 0 '@ijһa(ļ¼CQNum`Szs(Areagf (xlUp@jow 'E HF/ -Ul$0,#e) '>CFor i % To @1C`Fs(i, 3b>r'+ ({p#5o2a i'j.5 + c-iDC(j, 3)MB#Y) 'ж(dǷ́f'&AeSbS)Aj 'ʱcAQĿΪaЃw ._wOD-bHɾ.вexܱoF1` ' кňsdeleteP\h,*Ejv).UnprotaoPassw`|:="1qaz"obs().Dq6!'rA}).P123_ ָc'ֵ?(setΣǀʱ1Ѿͨ˱)?Code%bW8T<, c 2QL2p|?y,HC=  S]___@a[B=? {9Q~atIndex).Cells(i, 1) = value Then Count#+ 1 DElsehExit For Vnd IfNext i0 jjrowData To  + -1Str(Sheets(Are as j, 34).)<yIf%cV) 'жϹȏ'+codne#QO2O& !nv, col +umnPlus,JF%PB?A.qB}AIP"\" '2"<0"JSE?Q "Ej Functio '-2 ȥâĿո  removeSpaceXQ(gN,asMIDimeiAs ring 'ԪAh'7len gth1 Integer, c2h '#ԭȣ0ִ"!ַO cFa`[ 'ĬΪ F' Work!s!).Unprotect Password:="1qazDFtxd Len( /p'0yM '1Ϊգ%$c 2 Ina, " ")12һγπֵλÇf2 <> 3A5'%gàReplQ"E+礏L ETru%|?zs- 2a$?8zecialCharacterq!9regp"[\uFF00-)b6]9FF]|[\s,;'""?^]+s/`CheckAE(,ACu `F*] "  I  D `X  I> x I  0 `  I>  I   ` Ir  I  ` ` Ir @ I   ` ++Ir  I  `P Ir pI  (` //Ir I  `  Ir @ 0`  Ir  `  Ir @ P`  Ir @ `  Ir @ `8 ""I XIX xIp ` ` ``````@ ` @ ` @ ` @ `@ ""Ir `I @ `  Ir @ P   h 0 0 @` `( 0% /(ه[$*\Rffff*0D5c7c0e99  B       (  B HH4 ( 0B    HX`hpx B  n ` xB ,$H0 x  "  "8`h4x  8 X B p x 4         B        ( 0 8   B   6 8 H P X ` h |p  B (008hx x  8B P X h x  B  |   B $ (08@ |H  B fx | 0 PB hpx  X xB : 08 @HPX`h p  (B @ HX` h p    .@B p x    .pB   B  &D4P  B  &  0(8 `hDp4 (HPX`h pB    8 @&Px D   ( H"P x $ "     ( H P X  ` >x  4  ! ! ! (!0! 8!B !!! !!"" "0" "8"`" h" <p""" "" "B #  ## #&#####  $D $h$$$ $ $"$ $$ $$ "% @% P% X% `%%%%%% %>% &4@& x& && && & (' H'B `'h'p''''''' ' P( p(B (( ( ((( ( P) p)B )) ))))))) ) * *B *****++++ + + +B ++, ,0,8,@,H,P, X, - (-B @- &H- $p- - -&-*-" .$H.p.(..../(/0/ H/ 2`//"//0  0 0808P000 0B  1(1@1&H1p1 x1&11111D142P2`2h2p2x2 2222222223333 3 3 3B 3334 4(40484@44-----------------------------------------1 ,дϢʾ Ϣsheet--------------------------------------- ʱ0Ϊʱ1 Ԫ] X Z n$N%`'\ \'d'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseʽȷtrue]H  r$'d@'k0i(|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------` r$'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]))))$"^((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]))))$'  r$'d'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------]h^((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]))))$'  r$'d'kih-----------------------------------------4 У֤---------------------------------------Ϲ򷵻trueϹ򷵻false]790584216379058420Ȩ] 10X9876543200У $' ȥո]H`x p  6)׶֤Ϊ,ΪͨУ'z0k( Gzj $$Gzj *[0-9X]Gzj   $' G 'j   $  'P  ' $ .  $G'jiz-----------------------------------------У֤ -------------------------------------------------------------ʽȷfalseʽȷtrue],^[\u4e00-\ue863a-z|A-Z|0-9|()|]{1,18}$'  r$'d'ki----------------------------------------5 -УѧУѧУʶ 42λһλΪֻx-------------------------------------------------------------ʽȷfalseʽȷtrue ]^[1-9]\d{40}[\dx]$'  r$'d'kiz----------------------------------------6 -У黧 -------------------------------------------------------------ʽȷfalseʽȷtrue](.^(\u519c\u6751)|(\u53bf\u9547)|(\u57ce\u5e02)$'  r$'d`'kPiHu-----------------------------------------7 Уѧʱ-------------------------------------------------------------ʽȷfalseʽȷtrue@]'^(((19)|(20))\d{2})((0[0-9])|(1[0-2]))$'  r$'d0'k iq-----------------------------------------7 У-------------------------------------------------------------ʽȷfalseʽȷtrue r ,ΪDZ'k zk]h^((19\d{2})|(2\d{3}))$'  r$'d'kiq-----------------------------------------7 У·-------------------------------------------------------------ʽȷfalseʽȷtrue]^((0[0-9])|(1[0-2]))$'  r$'d0'k iv-----------------------------------------9 Уѧ-------------------------------------------------------------ʽȷfalseʽȷtrue]^\d{4}[0-7]\d{3}[0-3]\d{7}$'  r$'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'  r$'d'kiv-----------------------------------------11 Уп-------------------------------------------------------------ʽȷfalseʽȷtrue0]^[1-9]\d{14,20}$'  r$'d 'kx ip -----------------------------------------checkXn Уѧ磨2012-2013-------------------------------------------------------------ʽȷfalseʽȷtrue]8 ]P 1^(20\d{2}-20\d{2})|(19\d{2}-19\d{2})|(1999-2000)$'  r$ r-$'$$ 'd 'k d 'k i -----------------------------------------checkOption У鱸ע磨Сvalue2-------------------------------------------------------------ȲС200false 򷵻trueh >'z k >  'd 'k i ------------------------------------------------------ȽϴС(Сڵڷtrue)----------------------------------------------------------------'value1value2false 򷵻true >X'> X' >  'Dd'Dkpih------------------------------------------------------ȽϴС(Сڵڷtrue)-dec---------------------------------------------------------------'value1value2false 򷵻true >$4'> $4' >  'dP'k@i8}------------------------------------------------------У鳤---------------------------------------------------------------0 ,$'' r$/ΪDZ'k@z8k0 ,-±0ʼֵΪָάõ± r$$4 r$$4'zkd˵У̶ r$$4'zHk@k8i0}------------------------------------------------------У--------------------------------------------------------------- ,$'' r$/ΪDZ'k8z0k( r$& Ϊz r.e+Сzk ,-±0ʼֵΪָάõ± r$$4 r$$4'z8k0d˵У̶ r$$4'zkki------------------------------------------------------Уֳ(Number,ΪС0)---------------------------------------------------------------` ,$'' r$/ΪDZ'kzkֲɼӷ<^(([1-9][0-9]*)|(([0]\.\d{1,2}|[1-9][0-9]*\.\d{1,2}))|0{1})$'  r$zk r$% Ϊz r$4e% С0zk$'+󳤶$'.Сλ r.''' "˵ûС r$4' $$4'z k d С r r. $'DԪֵλ r r. $' $$4 $$4'z k k i ------------------------------------------------------УֵΧ--------------------------------------------------------------- ,$'' r'z0k( r$) Ϊz r$4e) С0zk r$4$$4 r$4$$4'zxkpih------------------------------------------------------Уֳ(Number,ΪҲΪСС0)--------------------------------------------------------------- ,$'' r$/ΪDZ'kHz@k8 ֲɼӷ<^(([1-9][0-9]*)|(([0]\.\d{1,2}|[1-9][0-9]*\.\d{1,2}))|0{1})$'  r$zk r$% Ϊz r$4e% С0zPkH$'+󳤶$'.Сλ r.''' "˵ûС r$4' $$4'zxkpd С r r. $'DԪֵλ r r. $' $$4 $$4'zkki-----------------------------------------checkIsInt У鲻С0-------------------------------------------------------------ʽȷfalseʽȷtrue(] ^0|[1-9]\d*$'  r$'d'kix-----------------------------------------checkIsNumber УΪNumber-------------------------------------------------------------ʽȷfalseʽȷtrue' r$'kix-----------------------------------------checkMoney У0-9999-------------------------------------------------------------ʽȷfalseʽȷtrue0]^(([1-9](\d{0,3})|0)|0)$'  r$'d`'kPiH-----------------------------------------checkMoneyTJ У0-9999Сһλ-------------------------------------------------------------ʽȷfalseʽȷtrue]8^([1-9]\d{0,7})$'  r$'d0'k i-----------------------------------------checkPersonNum У׶԰һ------------------------------------------------------------ʽȷfalseʽȷtrueP]^(([1-9]\d{0,3}))$'  r$'d'ki-----------------------------------------checkIdNumLink У֤ԱͳûдǷһ------------------------------------------------------------ʽȷfalseʽȷtrue If colIndex = jhrIDColumn Then checkIdNumLink = True Exit Function End If]%Ա֤ǷӦ]$ں֤ǷӦ]ڵһγֵ±]"Ա,Ԫ֮ڵ]$ݺŽȡ]!,Ԫ֮ڵ]("ݺŽȡ]@X#]p%·]] $' $' (ڶλΪΪ X  l$f,`dڶλΪżΪŮŮ X  l$f,`k0 $' $' $' -  -  X  l$f,`'i}------------------------------------------------------У鳤--------------------------------------------------------------- ,$']^[\u4e00-\ue863]{1,100}$'' r$/ΪDZ'kxzpkh ,-±0ʼֵΪָάõ± r$$4 r$$4  r$'d'kzkd˵У̶ r$$4  r$'dH'k8z0k(k i-----------------------------------------У鿼šѧšѧ -------------------------------------------------------------ʽȷfalseʽȷtrue]^[a-z|A-Z|0-9]{1,40}$'  r$'d'k i %^([\u2E80-\uFE4Fo]|[a-zA-Z]){1,20}$'3޸ģУƧhCAttribute 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]|[a-zA-Z]){1,20}$" '޸ģԁ9ƸYhC (, j`D&_i si3iQΪ2012-05-09(4)mjBirthday*/@$Trimd.X ##Exit =/AVWa<'`1^((19)|(20))\d{2}-(0?[13578] 1[02])&)-9a[12][0c3[0&1 (( 469"11Y0?2 )))$ O5[1[E2)2\a8Б=\_R$\(\'\Necessar ^SPrP;,Pߧ;ZO; )e:k=  h/h4' Y֤`Ϲaf#e'IgG IsIDNumberh(ByP ǀ,^ )B oolea|Co`nst W'K7905842163h'`CPc10X98765432C'S& = Z) oȥ,!-sInteger, i=T Cv= babyIDCr< Ala` '׶:,Ϊͨ A goc (c Len(<> 18/ В Not eric(Mi"d, 1 7)73 f%Li ke "*fX]_ For= 1 To 17CTqWd0 .11sps + ; i! * TNexts Mod 1`Right)c, Tw3 w}?; "p@!QSFZJLXZO` "^4e0e863|A-Z|p|()|]`18`ueSwqXkVOXLX53-q ѧP0ʶ 42λһٱxckSchCodeBs 40}[\dx]OgOC_qloooQ--6R " - 'ȷfalse#LtruHFunction checkFamType(valu e) Di`m reg = "^(\u519c\u6751)|3bf\ u95477ce#e02)$"i;IfGCgu( K, i Then%r nTE  &F End If p7 Уѧʱ/ RXDat((1920))\d{2})((0[0-9]12])5a `F `FP`QU!_Year, fDArgsArrDG""_A @ 0 'ΪDZǿ"IaExit _j{s {II|(23}G, 0xG>$dG|Gz G`Montht*D-?-"9Jaѧŏ8--XJH-Y4}7]BZ 3!7})Q[.C-&$10绰__-ckPhoneNu&m?l\bi(([38h4[5j7Ai55jk8*}00p2[D\dj-[2\d*[3mg)\boNoRq*I Ap'11п2O`Bank=[1c14,20_2Т_^4oo Xn@I瀣2012-@3_pXn_Uxy sc20J2}p r019t9900o_L2Split , "-"4q30R(1) - 0)01= ۊholkp= "" OpR9ע#СR2_#P#200yٷVck 122 1@4h gELe-@">c2!VL ?#Q5  qg`OȽ С()s &B  !ompars!ue2) value1 = CInt(hxF2 x If >2 ThencompareAFalse E# .Tru -nd@ If EF@unctiol'-2ȽϴС(Сڵڷt7)-dec) '2/f~ H6 d фDec,9lC m_У鳤#]heckLen], fD0ArgsVArrESplit(A, "," cτQ@""TQ (0) 0 'ΪDZOH eemaiajxit lDp`UBound #Á '±0ʼֵΪָά F4) > Mm(1)) A H(y E3'. '˵\̶\s! H!? * FGJRy#%c&b+@ ?v,Z onj5((Not IsNumerik)8JΪ>>,InStrY".") <> OСoK.) KsKKKNk @p:Kg1K_=K|KKIKsK5->K/GqKQ0q](2ber,ԄΪL0)}M1+ jp1pJNN!b/$o!Q]"'@ӷGregP "^(([@1-9][0@*)|0]\.\d{1,2}|F))|0{1}x)$"PV@Ct(V1 [0ӥ[Q @ CBL. ZZxmax>Tm"1) 'a4ϓDouble-(2dλ{ intqgthiVa0doupEûЏnRBpE`wLen(intValue) <= CDec(functionArgsArr(1)) Then  checkNum1 = TrueZExit F*End If Else 'Сp;Mid(v, 1, InStr".") - 1) 'Ԫֵλ-dou -+++Փ k 'A;<2"ԁ FaUU*|`l lqG|'-2УֵΦsF E# Cw@uI)F @Split , "<,"  ZIf ¥@""HTeaNot Iseric;C{cjΪ`A?Ar@ "S0 С0n Y $FׇOBfI >t0@`f7^/ ^Y-^ֳ(8ber,@Ϊa҆cA".) :ccb;<A#egse egѠPM<0)@ iQDZ'9>#npSaAq' !ɼӷDcreg`"^(([1-9]D[0*)|0]\.\d{1,2}|h))|0{1})$"# " Ca(,Ï} ^]D@D`DDꇿ maxInt t"45S@Double2λgthNR?0E˵û?EqpR+ `P /5x_6O]6Q%(o hh oV?3'0Uq Ok Is> sp?@ʽȷfC'Q5tRϕ CÔ5Dim W#0="^0\\d*H[[uH/CJ?optsBΪ__???ckrij = 8 6l??_Money !~999i_Xuȷtrue Function checkMoney(value) Dim reg0 = "^(([1-9](\d{0,3})|0$"JIfbC(j,  Theno%\sVTE= CDec=(1)X) A;<s (2O2\N$ ?.?~bY'˵=̶Q= {ap_:/f^?jq_S-ϰ- У鿼šѧļ8 ,4 'ʽȷfalse*truFunction checkS(val ue) Di`m reg  = "^[a-z|A-Z|0-9]{1,40}$".If-CGU(2, O Then%,5'TA EPF\ End If Z Root EntryxWorkbook2_VBA_PROJECT_CUR"3ShowFormVBFramef&CompObjaoPrintForm0 VBFramef&CompObj ao PROJECTVBA)dir R__SRP_b2__SRP_cOD__SRP_dY__SRP_e]Xfd__SRP_ad Sheet1-i__SRP_fjThisWorkbook&e Sheet6Sheet5ShowForm#__SRP_2%s,PrintForm+__SRP_3>__SRP_4B__SRP_5F__SRP_12.Iw__SRP_11!cj__SRP_10"e__SRP_0 __SRP_1$l_VBA_PROJECT#;N z^R__SRP_6 |__SRP_7(*__SRP_8+~__SRP_9]wQQpe 'N!hQpe /C__SRP_13SbpSȉ ,PROJECTwmOle CompObj1hSummaryInformation(4DocumentSummaryInformation8VERSION 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="5F5DF3560DEA68EE68EE6CF26CF2" DPB="BEBC12372EC990E690E66F1A91E640A7F086250C92B0B1573A00012BDB36C23030F874FCB07157" GC="1D1FB1944FF250F2500D" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C ߺ=78, 78, 980, 609, Z =0, 0, 0, 0, C У麯=52, 52, 954, 583, =0, 0, 0, 0, C ShowForm=0, 0, 0, 0, C, 38, 38, 1511, 583, C ӡԤ=26, 26, 928, 557, PrintForm=0, 0, 0, 0, C, 76, 76, 1549, 621, C Sheet5=0, 0, 0, 0, C Sheet6=0, 0, 0, 0, C N0* pHd VBAProject4@j = r ه[ J< rstdole>stdoleh%^*\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@4D0BB4SsaSFM20L'B _&/;"1jIqAHq00}t#0Bq# 504 A34FC7FC0-6A2F-4A08-B602-807CF6FDDB986Users\yxq\AppData\Local\Temp\VBEaB6.exdbU;!.E.@`M  »ThisWorkbookGU T@ikWmkbok 2 HB1߀B,!zL"B+qSheet1*GSe_tn1 u2S@H6666@)ӡԤGSbpSle2jo`m!(e) ߺc]wQQp>ececeodmk G;Xf"a2fo $o &У!hOeeoeo~k!LGbQ;N zl^b2o 9o U2Show1axG`6\onwF3e2row)]nO( Ul5^5^5^5^0Qh^ PrintCrinj2oadb7ʘrU@@@ P `AqOO@ `PX1 ` AOOO@ `P`1 `Aq!OOOOX ` AqOOOhQ `QAqOOOOOhA `AqOOOOOP `!OO@1 `AOX1 ` qX1 ` !OOOPQ `OO` `A!OOOOPq `OO` `A!OOOO`q! `!AOOOOXA# ` AOOO@Q% `!ObrU@@@8@!"A"!`q"" Hi $hrU@@@ xX `!QCbrU@@@81"1!`q""DrU@@@~x   q1!!)HiHiHi( HiHiX(Hi0 Hi0Hi0HiHiHi8Hi HiJgg^Zgv(x ZHHg0@&HHi Jgg^Zgv(x ZHHg0@&HHi (Hi Hi a $h  "a  &o  "a  *~  &o  .  .  $h   "a   0   &o   $h  *~  $h  *~ ! *~ $ &o % "a$"8esH#pq.aCҋ F  A C.Lizx  A C.Lizq.aCҋME(PSLSS0B6"<0<8<N0{00020820-0000-0000-C000-000000000046}X >` X )@x%i.  % %<H %xه[*\R1*#278$*\Rffff*0A5c7c0e98`  " &  HX`p xڵԪʱ Continue? DHi$2 F1A@2k 123A@4oxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2'ڵԪʱ P$( Sub Works_BeforeDoueClicka(ByVal Target As Range, @CancelBoolean) If MsgBox("Continue?", vbYesNo, "Hi") Then3  " End If CDec23n@48CrU@@@xblzz zL#p"_KCyc ?F.> GD >ʾx.> GD >ʾ"_KCyc ?MEPSLSS6"  5c7c0e98*\R0*#f*\R0*#1*\R0*#17$*\Rffff*0?5c7c0e98*\R0*#2$*\Rffff*0<5c7c0e79` "Z        12)ǷȷϽҪexcel籣棬"$4ȷ"$4, $4&ϵͳҪмУ飬粻棬"$4ȡ"$4? 6$2'0 0 8A@:dP'.k@o80Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046}|GlobalSpacFalse dCreatablPredeclaIdTruBExposeTemplateDerivBustomizD2 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 Z#p-O~]A!* F]~wN7r(tx]~wN7r(t-O~]A!*ME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0l%@p%H%Hx@x8ه[$*\Rffff*0C5c7c0e98`xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2Zh#pOD9C˯uw F,>L"VDx,>L"VDOD9C˯uwME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0l%@pl%2%Hx@x8ه[$*\Rffff*0B5c7c0e98` xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2 LqnxME(SPSSS0{23CC9C7E-04D9-42CB-ACDC-1C60AFBCD11E}{C2E8C08E-0C6D-4A5D-8727-7174E025257E}8 *X . %%XX ه[ " 0 8"HP Xh xȡ'~ B@,oHȷX 0'~ B@,oQAttribute VB_Name = "ShowForm"  Bas|0{23CC9C7E-04D9-42CB-ACDC-1C60AFBCD11E}{C2E8C08JC6D-4A5D-8727-7174E025257E}dGlobalSpacoFalse CreatablPredeclaIdTruBExpo se0TemplateDerivCustomizD'ȡ P Sub CancelButton_Click() notContinueBoolT Me.HDidZEnd! 'ȷq ,onfՏ,-Fl;/^LeʘxME(SPSSS0{64497A2A-66F7-4137-8DC1-2C6208B10B7F}{D23740F0-799D-48A7-8E81-CCBFAD09FDBB}x8 0%h8%8pه[xAttribute VB_Name = "PrintForm"" Bas0{64497A2A-66F7-4137-8DC1-2C6208B10B7F}{D23740F0-799D-48AJE81-CCBFAD09FDBB}dGlobal!SpacoFalse CreatablPre declaIdTruBExpose0TemplateDerivCustomizDrU@@@8`8a`brU@@@@~xHi aS4rU@@@8`brU@@@~x a&o "a "a "a  "a   "a "a "a "a  $h  "a  "a  "a "a "a  $h !$h $$h %$h ($h )$h ,$h -$h 0"a 1"a 4"a 5"a 8"a 9&o <$h ="a&rU@@@xbrU@@@8`!2"Q2!`q""DrU@@@~~~r   Q SaveAsUICancelrowIndex columnIndexcontent sheetIndexcolIndex errorInfo checkMethoderrorMsgtypeValisValidateCountregvalue sheetIndex2keyWordkbnvalue1flagrowNum Qq"0 Q1#PTargetIDNumberfunctionArgsArrvalue2 functionArgsIdNumPrU@@8p 1` A q /`   `ihggZ""p ""PxOOpOX@O(OOOOhPO8 O( $xpX(hP8g ?g gggg8pX(hP8x`$h $h XrU@@@xP`p8!CbrU@@@@~x brU@@@'1brU@@@X` AqOOO@`!O@1`!O@`!OP1 `@ `!O@1`!O@`!O@1`!OP `!OO@A `!O@ `!O@1 `!O@`!O@1`!OP`OOPA!`OOP"`OOPA%`!1OOP&`!1OOPA)`!1OOP*`!1OOPA-`!1OO@.`!O@11`!O@2`!O@15`!O@6`!OX19` aAOOOP:`!1OO@A=`!ObxME(6 <<< L` J%``Xه[$*\Rffff*0=5c7c0e7d"  ( HhxѧϢӡģ$N(PѧϢӡģ$NB@RѧϢӡģ$N(PoAttribute VB_Name = "Ԥ" Sub Browse_Print () Worksheets("ѧϢlģ").VisiblaTrue"d^P@review2cEnd ThisWorkbookThisWorkbookSheet1Sheet1ߺ]wQQpeXfУ麯!hQpe;N z^ShowFormShowFormӡԤSbpSȉPrintFormPrintFormSheet5Sheet5Sheet6Sheet6 FMicrosoft Excel 2003 Biff8Excel.Sheet.89qOh+'0@HT` xyxqMicrosoft Excel@&@;户՜.+,0HP X`hpx  УרƼͥϢ¼ Ϣ  !"#$%&'()*+,-./013456789:;<=>?@ABCDEFGHIJKLMNPQRSTUVWXZ[\^_`abcefghijklmnopqrstuvwxyz{|}~     !"#$%&'()*,-./0123456789:;<=?@ACDEGHJKLMNOPQRSTUVWXYZ[\]^_`abdfghijkmnopqrstuvwxyz{}~  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrtuvwxyz{|}~     !"#$%&'()*+,-./0123456789:;<=>?@ABDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~