ࡱ; n \pѐwZ Ba= ThisWorkbook=9ZKx-8X@"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[SO1 r[SO1r[SO10r[SO1r[SO1r[SO1 r[SO1r[SO1r[SO1r[SO1r[SO1 r[SO1>r[SO1r[SO1 r[SO1r[SO1r[SO14r[SO1 r[SO1r[SO1 r[SO14r[SO1<r[SO1?r[SO1>r[SO1r[SO1r[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  2    @ @ @ @  @ @ 1  1 1 1@  1 1@ @  1 1@  1@ @ 1@ @  1 1@  1@  1 1 1  x@ @ 7  x@ @ , 1@ @ 1 #1@ @  #1 #1@ @  1@ @  x@ @ , #1 1 1 1@@  1 1@ @ 1@ @  ""@ @ !""@ @  !@ @ !@ @ !!@ @ 1@ @  @ @ 1@ @ 1@ @  1 1 1@ @ 1@ @ 1 "1<@ @ 1 1 1 1@  !@ @  1@ @   1 1 1 1@  487 58 687 78 887 98 :87 ;8 <87 =8 >87 ?8 @87 A8 B87 C8 ||bO}-} 00_)}-} 00_)}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}-} 00_)}A} 00_)L[$ -}A} 00_)L[$ -}-} 00_)}A} 00_)L[$ -}-} 00_)}-} 00_)}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}-}%?_)}A}( ?_)[$ -}-}) ?_)}-}* ?_)}-}+ ?_)}-}, ?_)}-}/ ?_)}-}1 ?_)}(}3  ?_)}A}4 a?_)[$ -}-}5 ?_)}}}8 }?_)[$ -##0.  }}9 ?_)[$ -???##0.??? ??? ???}-}: ?_)}-}; ?_)}A}< }?_)[$ -}-}? ?_)}A}@ ?_)[$ -}A}A ?_)[$ -}-}B ?_)}A}C ?_)[$ -}A}D ?_) [$ -}A}E e?_)[$ -}}}F ????_)???[$ -???##0. ??? ???}}G ??v?_)̙[$ -##0.  }(}H  ?_)}x}I?_)̙[$##  }-}L ?_)}-}N ?_)}-}P ?_)}-}Q ?_)}-}S ?_)}-}T ?_)}-}U ?_)}-}W ?_)}-}[ ?_)}-}\ ?_)}-}] ?_)}-}a ?_)}-}b ?_)}-}c ?_)}-}d ?_)}-}g ?_)}-}j ?_)}-}n ?_)}-}q ?_)}-}u ?_)}-}x ?_)}-}z ?_)}-}} ?_)}-} ?_)}-} ?_)}-} ?_)}-} ?_)}-} ?_)}-} ?_)}-} ?_)}-} ?_)}-} ?_)}-} ?_)!20% - :_eW[r 1O20% - :_eW[r 1 ef %!20% - :_eW[r 2O"20% - :_eW[r 2 ef %!20% - :_eW[r 3O&20% - :_eW[r 3 ef %!20% - :_eW[r 4O*20% - :_eW[r 4 ef %!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 3O'40% - :_eW[r 3 L %!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 3O(60% - :_eW[r 3 23֚ %!60% - :_eW[r 4O,60% - :_eW[r 4 23 %! 60% - :_eW[r 5O060% - :_eW[r 5 23 %!!60% - :_eW[r 6O460% - :_eW[r 6  23 %"~vRk #hh $h 1h 1 %h 21h 2%? &h 3h 3 'h 4h 4(]5]  %+8^ĉ %)8^ĉ 1218^ĉ 12 % *8^ĉ 2/8^ĉ 2 %+8^ĉ 2 238^ĉ 2 2 %,8^ĉ 2 338^ĉ 2 3 % -8^ĉ 3 .8^ĉ 4 /8^ĉ 5/8^ĉ 5 % 08^ĉ 6 18^ĉ 7/8^ĉ 7 %2 8^ĉ_hQVL?e:SRNx3(c  4}Y5}Y  a% 5Gl;`+Gl;` %6'^7 '^[0] 8{c{ }% 9hgUSCQ$CSMOR[0]?:_eW[r 17:_eW[r 1 %@:_eW[r 2C!:_eW[r 2 PM %A:_eW[r 3C%:_eW[r 3 Y %B:_eW[r 47):_eW[r 4 %C:_eW[r 5C-:_eW[r 5 K %D:_eW[r 6C1:_eW[r 6  F % E-N7-N  e% FQcQ ???%????????? ??? GeQoeQ ̙ ??v% H 0 ]vc   Ilʑ^ lʑ  XTableStyleMedium9PivotStyleLight1683ffff̙̙3f3fff3f3f33333f33333\`f[^~NmOo`ǑƖYNxh Oo`VV!  =" ku~+R;MP" ku{|+R;.1- KmՋ@b g!hĉRv^SbpSOo`" 6rkt^;pq" 6rkeS;gh" 6rkLN;km 7bM|;|~, [^bXT`͑'Yuu;bd, [^NGWt^6eeQV;VW* [^6eeQegn{|W;3:& [^(Wf[Npe;" [^DN;SS" a{QN;xy  /fT&T;2 zSaYNNwQSO`Qc;^_& f[90OO[9;tu. 6q~p[wQSO`Qc;Z[f~fhH@F>xMOS AA@A@   familyMembers suortMembersfamilyYearIncomedisasterDescribefamilyDebtAmountfamilyDebtReason checkDiffName[V~+R Ty checkSqyyCode3ut1uxkuNOO checkSqyyName3ut1u Ty checkYesNo/f [^;N6eeQegn{|WfamilyIncomeTypeNamecheckFamilyIncomeTypeƉRku,TRkuzfRkuvQNku]D0VYё0%m40e4TvQNRR6eeQyOё0W,g{Qё0W,gu;m901YNOiё~b0cS`N0QybQ.U[^"N_v6eeQ a{Q90b(vb){Q9 LN6eeQ vQN^S_eQ[^v6eeQ checkNamecheckXfcheckDisableTypecheckDisableLevel checkInt0,1,2checkSuortMembersDescribecheckParentJobscheckParentCulturecheckParentAgecheckInSchoolCountcheckFamilyDiseaseDescribe checkNum0,6,2checkLen0,1,60checkFamilyYearIncomeRangecheckFamilyDisasterTimecheckLen0,1,100 checkFamilyBurstTimecheckLen0,1,100checkFamilyProperty  [^~NmOo`ǑƖ1xmsfzjhjtcysyrsldlrk burstDescribeisLowIncomeFamily isCyzdshbzisFiledPoorFamilyisTkzgjtisOrphan isJlsyfzl isDisabilitystuDisabilityLevelisAloneParentssuortMembersDescribe parentAgeisFamilyDiseasefamilyDiseaseDescribeisParentsLaborisParentsDisabilityisFamilyDisasterfamilyDisasterTime isFamilyBurstY TNNSf[90OO[9 WaNgNOu;mO7b/f&T^chzaS[^yrVL]P[sY/f&Td[?Qf[u,gN/f&Tkuku{|+RkuI{~a{QNSpea{QN[^bXT1YNNpe6rkLN6rkeS6rkt^RRRNS[^NS[^(Wf[Npe [-N/f&T g'Yu`[^bXT`͑'Yuu `Q N+Tku /f&T6rk1YNb'N1YRRR/f&TkuNP[sY6rNkuI{~kNkuI{~[^ k:Pё k:PSV[^NGWt^6eeQ [^NGWt^6eeQV [^/f&TmS6q~p[ [^mS6q~p[e 6q~p[wQSO`Qc [^/f&TmSzSaY [^mSzSaYe zSaYNNwQSO`Qc[^DN7bM|Sgqf[u@b(WNN0f[!hvf[9SOO[9Sgq 03uh 0f[uW,g`QhvWGNO6eeQV[^Sgq 03uh 0f[uW,g`QhvWaNgNOu;mO7bSgq 03uh 0f[uW,g`QhvyrVL]P[sYSgq 03uh 0f[uW,g`Qhvd[?QSgq 03uh 0vf[uW,g`QhvkuISkX ƉRku 0 ,TRku 0 zfRku 0 vQNku 0 N(W ,gN/f&Tku -NkXQ &T (W,gRkXQwQSOvku{|+R Lhg0^_kXySgq 03uh 0vf[uW,g`QhvkuI{~"Sgq 03uh 0[^bXTS;N>yOsQ|`Qh t^'YN70sS:Na{QNS Sgq a{QNSpe W[k,Sgq 03uh 0[^bXTS;N>yOsQ|`Qh ]\Of[`N USMOTLN:N e e h:y1YNSgq 03uh 0[^bXTS;N>yOsQ|`QhvNf[usQ|0LN Sgq 03uh 0[^bXTS;N>yOsQ|`QhvNf[usQ|0eS z^Sgq 03uh 0[^bXTS;N>yOsQ|`QhvNf[usQ|0t^.Sgq 03uh 0[^bXTS;N>yOsQ|`Qh t^:N20-60 NeP^rQ:N eP^ sS:NRRRSgq 03uh 0[^bXTS;N>yOsQ|`Qh[^bXTvpeϑ&Sgq 03uh 0[^bXTS;N>yOsQ|`Qh LN:N f[u v^Nt^(W35N NSgq 03uh 0[^bXTS;N>yOsQ|`QhveP^rQ\Sgq 03uh 0[^bXTS;N>yOsQ|`Qh Nf[usQ|:N 6rN b kN t^:N70N N b` g͑'Yuu bkuI{~:N2~N NsSƉ:N'N1YRRR1YNagNSgq [^bXT1YNNpe chSgq 03uh 0q_T[^~NmrQ gsQOo`hv[^ k:P`Q(Sgq 03uh 0q_T[^~NmrQ gsQOo`hv[^NGWg6eeQ XNN120USMO:N CQ Sgq 03uh 0q_T[^~NmrQ gsQOo`hv[^;N6eeQegnSgq 03uh 0q_T[^~NmrQ gsQOo`hv[^mS6q~p[`Q傡l gmS6q~p[ N_kXQdky=Sgq 03uh 0q_T[^~NmrQ gsQOo`hv[^mS6q~p[`Q Q[ NǏ100*NW[&{ 傡l gmS6q~p[ N_kXQdkySgq 03uh 0q_T[^~NmrQ gsQOo`hv[^mSzSaYNN傡l gmSzSaY N_kXQdky=Sgq 03uh 0q_T[^~NmrQ gsQOo`hv[^mSzSaYNN Q[ NǏ100*NW[&{ 傡l gmSzSaY N_kXQdkySgq 03uh 0[^Oo`hvOO?b`Q0/f&T]-n}lfel T^S/f Ty{|W&T checkGendersY'`+RsY7u'`+R7uyr+RVVN,V NVeUSNd[?QpXP[sYQQgNOVuV~pvQNmQNN[^6eeQegn{|W checkYearNt^~t^~2Nt^~3 Nt^~4 Nt^~SN N5Vt^~6Vt^~SN N7Nt^~8Nt^~SN N9mQt^~10mQt^~SN NN~kuku~+RN~ku N~kuV~kucheckFamilyPropertye?bNe}lf7b1\f[!h@b(W0WgNOu;mO~ N1\f[!h@b(W0WgNOu;mO~ N2 PNQNt^Q[^mS͑'Y6q~p[ S~p%N͑Nt^Q [^mS͑'Y6q~p[ S~p%N͑Nt^N N$Nt^NQ Nt^Q[^m͑'YzSaYNN N+T6q~p[ Nt^Q [^m͑'YzSaYNN N+T6q~p[ Nt^N N$Nt^NQ checkFamilyDiseaseDescribe6rkGW`͑'Yuu( N+Tku [^bXT`͑'Yuu6rkNe`͑'Yuu N+Tku vQN[^bXT+Tf[u,gN `͑'Yuu N+Tku 6rkGW:NR-NSN NeS z^6rkNe:NR-NSN NeS z^6rkGWl g]\O N+TQQgy i7bb{Qk7b 6rkNel g]\O N+TQQgy i7bb{Qk7b QQg*NSO\Wy i7bb*NSO\W{Qk7bb$NGW/f 6rkGW:N60hT\N N+T60hT\ 6rkNe:N60hT\N N+T60hT\ checkXfcheckHjV[8h[v680*N+VS:S 680*N+VSNYvi}T:S^Nwvb+_S͑pS N+Ti}T:S 2N+T,gN N N(W Nf[2NN N(W Nf[familyInfoEntry 7xfdisabilityCategoryCode parentJobs parentCulture inschoolCountfatherDisabilityLevelmotherDisabilityLevelfamilyIncomeTypeCodefamilyBurstTimefamilyProperty/f&TyrVO{QNXT 7f[90OO[9(W9501CQ20000CQ 7f[90OO[9(W20001CQN N 7X[>kS)Ro` gN8RS~)R0hy0ZSi_6eeQ 7~FU0RSNSNNy iN0{Q iN0R]Ncbd_b,gTv6eeQ 7a{Q$NMON NN70hT\N N  7a{Q$NMO+T$NMO SN NN70hT\N N  7 isSupport 7 checkInt0,1,2 7 checkInt0,1,6 7Sgq 03uh 0f[uW,g`QhvyrVO{Q`Q 7Sgq 03uh 0f[uW,g`Qhv^chzaS7b 7/f&T6rkNeb{Q 7Sgq 03uh 0vf[uW,g`Qhv/f&T6rkNeb{Q 76rkNN`Q 7 /f&TWGNO6eeQV[^ 7/f&TOb[a 7 checkZjlxNN{|WQ[XuQeLr^yO /nyr:Sbgq/Nf oyr:Sbgq/Nf S~nE\leg_'YFLXY8lENE\OOAbgqB7bSZ1 7NN{|W 7 kXQf[uNN{|W _kXy  7 zjlx! 7 checkZjlx 7 checkSfzjh 7" _{:NIlW[SNS+T ^'YNI{N1 N NǏ20*NIlW[ _kXy 7 kXQf[uE\lNNS v^N^ NǏ18*NW[&{ _kXy 7 checkYesNo 7 6rk Ne\Lb{QINRv?Qz 7 /f&TVlQzrrrf[P[sY 7+Sgq 03uh 0f[uW,g`QhvNSV[[gbd`eRvOb[aP[sY,+TpX0zrrrQNN^\ 7Sgq 03uh 0f[uW,g`Qhv6rk Ne\Lb{QINRv?Qz 7Sgq 03uh 0f[uW,g`QhvVlQzrrrf[P[sY 7isSupportObligations 7isPoliceOffspring 7 4144013902E\lN 7FAILURE 7 4144010822 4144011106 4144012623"$G GHHuI]7JJJK2K^LFL=M%MeNM1OP 9S! UV$W dWLWW3XXZH[0\\^_`vaacdccB4c =_MA   ֆ  dMbP?_*+%{&ffffff?'ffffff?(?)?MvMicrosoft XPS Document Writer 4dXXA4GIS4DINU" |r  SMTJ{0F4130DD-19C7-7ab6-99A1-980F03B2EE4E}InputBinFORMSOURCERESDLLUniresDLLInterleavingOFFImageTypeJPEGMedOrientationPORTRAITCollateOFFResolutionOption1PaperSizeLETTERColorMode24bppV4DM" d333333?333333?&<3cAU} P} } P} P} P}  P} P} P} P} P} P} } P} P}  P} P} `P} P} `'P}  P} P} P} P} P}  P} @"P}  P} P}  P} !P} ""P} ##@"P} $$@P} %%P} &&P} ''P} ((@P} ))P} **P} +d P} eiP} jj} krP} st} uP}  P NNQNNNO+R{@ {@ {@ {@ V ~ x W S S S S S S S u  u  S l W S d! S" e! S# S$ W% e! | S& d S' W S W W d( !d) "{ #e $d %W+ &W, 'b (W- )W. *j/+TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTX @*XTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTUYU Z0"UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU,TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTaTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT [1  [1 [1 [1 [1 [1 [1 [1  [1  [1      [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1 [1  [1 ![1 "[1 #[1 $[1 %[1 &[1 '[1 ([1 )[1 *T1+TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT \2 \3"]hi]i]iiiiik]i c] c4 ]]] c5 c]i]ii]]  g !g "c #c $i\% &c 'i\( )g6*aTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT]ha[h i}j] k] ly m]7 ni8 oi9 pi: qk; r\< s t ui= v] wc> x]?yc z]@{] |] }c ~cA ]i ] iB iC \D \E g g cch i \F cGi \H gT a ^I ^ ^J _K _ _ _L _M _N  _O  _  f   _   _P _Q _R _ _S _T _U _ _W _X _Y _Z _[ _\ f] f^ __ _` _a  _b !_c "_d #_ $_f %_g &_h '_i (_j )_k *_lbeRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR `   `  `n ` `o `p ` `q  `r  `  `  `  `s mt `u ` `v `w `x `y `z `{ `| `} `~ ` ` ` ` ` `  ` !` "` #` $` %` &` '` (` )` *`zz B zz*ikru~ zz B * i kr u~   zz B * i kr ux z |~   zz B * i kr ux z |~  4@F04ZFv.(   vj NqX?M1]4v6@q /nB 3r3( <kXQf[uvY T<~~  <ЀqCC@],@Ѐq Tqq9 $< _Yhg<~~ i <(qCC@>],5@(qTqq9 $<_ Y h g<ZR v C Q ]F>! d d v6admin>@dinjn7>7  /f&T +  #&TK  #&T c  #&T ''+  #&T;  #&T+  #&T+  #&T+  #&T+  #&T+  # &T+  # &T+  # &T##+  #&T$$+  #&T%%+  #&T((+  # &T**1  ; Sheet1ggD   =OE  dMbP?_*+%&ffffff?'ffffff?(?)?MFoxit Reader PDF Printer_ 4dXXA4" dXX333333?333333?&<3U} M} K} @+K} !K}  L}  L}  L}  L @ , , , , , ,,,,, o p p o nnn qnnnnnnn JJJJ L JJ? r Jnnnn JJ J Jnnnnnnsnnnnn JJ@ r Jnnnn JJ? r JnnnnJJJJ nnstnnnn J J? r t nnnn J J5@ r t nnnn J J6@ r t nnnn J J@ s t nnnnnnstnnnnnnstnnnnnnstnnst J JJ J J JJ? J J JJ@ J J J J@ J J J J@ J J JJ@ J J JJ@ J J JJ@ J J JJ @ J J JJ"@ J J JJ$@ J JJJJ J J J J J J? J J DH lV& NNNNNNNN<<<<<<<<<<<< !"#$%&'()*+,-./012 @34:5:67:8Y@9:;=>?@ J  J@ J J !J !J@ !J !J "J "J@ "J "J #J #J@ #J #J $J $J@ $J $J %J %J@ %J %J &J &J @ &J &J 'J 'J"@ 'J 'J (J (J$@ (J (J )J )J@ )J )J *J *J @ *J *J +J +J"@ +J +J ,J ,J$@ ,J ,J -J .u.J? .J .JQ /u/J@ /J /JQ 0u0J@ 0J 0JQ 1u1J"@ 1J 1JQ2nnnn 3J3J? 3J 3J 4J4J@ 4v 4J 5J5J@ 5v 5J 6J6J@ 6v 6J 7J7J@ 7v 7J 8J8J@ 8J 8J 9J9J@ 9J 9J :J:J @ :J :J;J=nwnn>nwnn?nwnn@nwnnDl<<<<<<<<<<<<< <<<<<<<<<<<< ABCDEFGHIJKMNOPSVWZ[^_bcdghklmpq AJ Aw1 Aw AJ BJ Bw Bw BJ CJ Cw Cw CJ DJ Dw Dw DJ EJ Ew Ew EJ FJ Fw Fw FJ GJ Gw Gw GJ HJ Hw Hw HJ IJ Iw Iw IJ JJ Jw Jw JJKnwnn MJ MJ? MJ MJ NJ NJ@ NJ NJ OJ OJ@ OJ OJ PJ PJ@ PJ PJ SJSJ? SJ SJl VJ*VJ? VJ VJe WJ*WJ@ WJ WJe Zx+ZJ? ZJ ZJh [x+[J@ [J [Jh ^J-^J? ^J ^Jk _J-_J@ _J _Jk bJbJ? bJ bJ cJcJ@ cJ cJ dJdJ@ dJ dJ gu$gJ? gJ gJW hu$hJ@ hJ hJW kJ#kJ? kJ kJV lJ#lJ@ lJ lJV mJ#mJ@ mJ mJV pu%pJ? pJ pJX qu%qJ@ qJ qJXD l8888888888<<<<<<<<<<<<<<<<<<<<tuxy|}~,,,,,,,,,,,, tJtJ? tJ tJK uJuJ@ uJ uJK xu"xJ? xJ xJT yu"yJ@ yJ yJT |J|J? |J |Jm }J}J@ }J }Jm ~J~J@ ~J ~Jm u&J? J J[ u&J@ J J[ JJ? r t JJ@  t JJ@ s t JJ@ s t JJ@ s t JJ@ s t JJ@ s t JJ @ s t JJ"@ s t J J s t J J s t J J s t.<<<<<<<<<<<<<<<<<<88PH  0(   >@ 7 Sheet5ggD    dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3Ud PH00(  >@ 7 Sheet6ggD 6  t&xRRME (@V006 <VhH0jjhX\P`H`@ʘxBʀ @ʀ4 @ꀆD @.L @%Ϣ˵%ꀞ@V  @Z  @dh\  @fBhX@‐@ʀd @x@jz@ʘ0BlH~ @LXhB!ʘpB#%@&@%Z(BVHpH^pHʀ @$ @b8Hh @ꀘP @T @X  @ꀚ^ @0Bꀈ` @Xt@ꀠ| @8 BʘnpB"ʘrB$pHPxh p(08H0X@X T0'=02[*\R1*#222$*\Rffff*0a5b76b3a7(*\Rffff*0a5b76b3a7\077    08  @ ` Dp 8 0 P0pD084P. ..(8(`>"$(@>`R^FX `*0$`  $  ^(^^^0p@һṹҳ]$H=Public Const sheetNameValueTJ As String = "2ʵͳ"]$Ϣ(2Public Const IntroSheetName As String = "˵"]$H]$˵P] p ¼ܵУX]$¼ͷ] x"ִ һǿУ ĵԪĿ] 6ִ һǿУ ĵԪΪϹĿ] ÿһкϼеֵ] "һǿУʱ¼Ԫ] Ϣ] %---ģУ¼ĸԪ ] 8---ģУ¼ĵԪ]  Уʱ洢ַ] ¼ʱرհť ]  ¼ܵУǷвϹ] @ ¼ܵУǷظ] #¼ܵУǷظ] %/¼ЧǰǷдϢ ״̬] h#У鷽ķֵ]$)¼ʼк8]$)ѧ֤ſʼλ]D0¼ΪյĿ]X"/ǷΪЧ ͳ 5ֶΪյĸ] "C¼ȥոִнȥ˿ո򷵻true򷵻false] PcellԭʼĵݣϵͳûнԶûĴ֮ǰcell] 7ϴдϢʱڵ,ӦĿʼʱʼֵһ] ] ] RڸݱʶòͬķʱжǷforѭ Cell_SelectionChangeҪõñ]$¼ʡصȼ¼ڵ ]$0+sheet±Ƿ]  ]$hH)е]$X,϶]$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~| KI 9)  1 a 9Yq x !  !QIa 8IxXaa  9a  ya D0)$  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 :W  !'0'P:"Ntt:#:$^6 tP0;:%p(%$  dp)p=(%p(%$  dpW%C&)p5 u+'t'':'N 6tz ;:%p(%$  dp)pzRp(%$  dpW(:)`, */,)p6 u ( uDh (+ (, (- ./ :.0 (uz1z2(uDht M(% @p(%$  dp A3h)p5z4h:.]@ 3:5Nh, 6X/,53:7Nh, 6/,5X5Ip,X5ILiX5Iih|I @X:7N, 6H/,6(%H( (3H(%H:8N, 68/,6&85ILil85IihL<l @8Hq(l 9-H6 l~LW ~|~ u4kH(%X:8N, 68/,6&85ILil85Iih(k<l @8Hq(l 9-H6 l~($ 5Ia (%( (3\ H(%:8N, 68/,6&85ILil85Iih\ <l @8Hq(l 9-H6 l~  H(%X:8N, 68/,6&85ILil85Iih <l @8Hq(l 9-H6 l~ Mf% @ @p(%$  dp C:)p5 ~s",(]<,+/' 7:;:<0:=t`/6tz/ *5( -(]3 U@"@(@&v iv ih Mv i%p: %$  dp>?)p5 ~d v i"{ u1z ~(@(hx~ "pz(]3C zM@( @ 6q ,kzD(t @ 6t ~x @(]t Z'H'h'0:A@:B  !t:CP 6tP0hHu +'t'':DN 6t=(%p(%$  dpW%C&)p51p: %$  dpE)pxzF( G6 uF+'t'':HN 6t=(%p(%$  dpW%C&)p51:INtt(((P 6 tP]%:%p(%$  dp>AUz)p6,M@(((t 6tv+'t'':JN 6t=(%p(%$  dpW%C&)p51p: %$  dpE)p;:%p(%$  dp)p;:%p(%$  dp)p;:%p(%$  dp)p409# |\L8(xXlhH8(@< H,ptP0hH0   fK*   rU~~~~~~~~~~#~~~~~~~~~~ +U!EJ  a 1  a 1 a 1 ) Aa P1a!QAaaa 1  (Qq!Aa9Yy 1 Y a aa 1    VBAProject ThisWorkbookSheet1Sheet6ӡԤߺУ麯ShowFormSheet5 PrintFormF9C:\Program Files (x86)\Microsoft Office\Office12\VBE6.DLLVBA ) Q0F:C:\Program Files (x86)\Microsoft Office\OFFICE12\EXCEL.EXEExcel 9a@0FC:\Windows\SysWOW64\stdole2.tlbstdole aPL-[DREC:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLLOffice Ai`.E .`M C:\Windows\SysWOW64\FM20.DLLMSForms qqp0c[HS֋4C:\Users\ADMINI~1\AppData\Local\Temp\VBE\MSForms.exd QqyУ򲢴ӡϢ checkTheSame  Browse_PrintF@:F9.F?dO0+) DFWorkbookWorkbook_BeforeSave @ .`/f&Tnx\OX[excel YOX[ pQ nx[ , &|~\ۏLhg!h Y NOX[ pQ Sm ? Oo` Nxh f , 00 $4DHLPdVBE6.DLL  `   S 0FF F 0]\Ohpev Ncknx N}ge!jgT QۏLdk!h 1qazPasswordProtectUnprotect CellsClearContentsF A65530 RangeEndRowcheckedRequiredStartwriteLoggetCellValueCountXQ writeLogRedaddCommentXQStartclearCommentsXQStartbeginCheck_commentcallFunctionXQStart regCheckFunccheckTheSameXQNewGetRowOrColIndexcheckDMB deleteRowsetCellValueCountXQdeleteRowNoProsetCellValueXQ setDMBCode removeSpaceXQ IV5FEGYF8T? FHC gHn0`DF Worksheet 'Worksheet_BeforeDoubleClickaaaaaaaaaaaaFF FAILURE 4`nx[_YhgT hgǏ z-N RsQexcel &TRS[penc"N1Ybhg1Y% )nc:yTabColorIndex "l gg~b0Rf[uOo` elۏL!hName -NOo`Y N  value - : ; Locked ,{ Lvpency -N\ gN*NkXQcknxhgRows Delete dk!k!h-N RdN ,LeHepencY T0f[M|S0NNS0'`+R0 6Queg-N g4*NS4*NN NR!h1Y%sS9eL:NeHepenc * gOo` g w Oo` h ۏLOck Select !hǏ! SUCCESS * g͑ Ypenc g w Oo` h ۏLOck    )M(]9HjsK b#AGCEs AN88փ checkRequired checkStuName removeEnter checkBirthdaycheckBirthdayNecessary IsIDNumber checkSFZJLX checkSchCode checkFamType checkRXDate checkYear checkMonthcheckXJH checkPhoneNum checkBankcheckXn checkOptioncompare compareDeccheckLencheckIntcheckValcheckNum checkIsInt checkIsNumber checkMoney checkMoneyTJcheckPersonNumcheckIdNumLink checkSpLencheckSia (*\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{BD63AF30-5BFC-48A4-87DA-1E53D61FD68B}#2.0#0#C:\Users\ADMINI~1\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M   02[   ThisWorkbook0`5b76b3a7ThisWorkbookzLxJ Sheet10c5b76b3a8+ Sheet1H Sheet60e5b76b3a87 Sheet60SbpSȉ0_5b76b1e18SbpSȉH]wQQpe0b5b76b3a8B]wQQpe`Xf0a5b76b3a7TXf&xz!hQpe0f5b76b3a9t!hQpe~T];N z^0]5b76b1a1;N z^Ux`J.ShowForm0Y5b76b1a1ShowFormn1 Sheet50d5b76b3a8 Sheet5hPrintForm0[5b76b1a1PrintFormʘ`Hx0)GLaZ Jiatp<?+XsM,l_h7Io˸/?cU+թvBcY}eAUuMٓ4 `K*KJ?)MJm/zyl@wOl6h)#JҤ!P!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` ߺ`(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` (removeEnter` (checkStuNamec`(checkLeng`functionArgsArr`Split)` (checkSpLen`(checkNumh`(checkValK`(checkInt`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` i`(!ValueColumType` columnNamew`(sheetIndexValue1` (AreaSheetName`(readmeSheetName` (totalCount-`(rgold`(hasErrorInValidateU` (dataRowStart` isNullRowNum8`(cna`(notContinueBoolt`(sysDifficultyGradeNameColr`(indentifyDateCol&`(indentifyReasonCol*9` У麯&`addr`vbBinaryCompare̝` Application*`WorksheetFunction&`Clean`IDNumber4 `Wm`UCase5 `sj`Tk` babyIDColumn` IsNumeric$*`Right ` (checkSchCode` (checkFamType` (checkRXDate*` (checkYear6`(checkXJHF`years`value2` (compareDecN` 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`ScreenUpdating! `xlToLeftWY`rowType`md`ne`Locked ` totalMoneySumZ`pg`qh` (checkTheSameg`myDico`myKey`varData`idNumDick` idNumDicData`cardNum\`Exists]`Addr`Keysq`Resize@4` 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_totalMoneySumY`_B_var_p`_B_var_q`u+79  CU  "@ p0(P'q`XX HH   (d D.UxME<6 LL L "L<8 ( `HkPz@h Ŀ@X x@H @8 @@( @ ` ` ` ǿ` ` ǿ %hXXPP< VTXz@ @ @ @0 @H @` @x @ @ @t @p D*jH@ ` @8P @h@ &"$P@0 9@, @  @ [2@ 02 d@ @ @@ 9X;@ 8@;(@ @p 8@ C@| 8CT @l @(\ P[@IT @L Bh(Ie@H (x(KM@8 Q@( Q8ST @ (Ze@H (8Z`\@p XH`@ p`8pbT @f@ e@h @ (t@p 8tHvz@ @ p|@x |:@ h @X @H  02[$*\Rffff*0]5b76b1a1*\R1*#33b*\R1*#10d*\R1*#101*\R0*#14$*\Rffff*0a5b76b3a7*\R1*#fc*\R1*#42$*\Rffff*0b5b76b3a8$*\Rffff*0c5b76b3a8*\R1*#109*\R1*#222*\R0*#2*\R0*#f*\R0*#1 h"hp:x.6" "H.p )  :+ ;8@;H;h;>;" : "P,`$>;,],( @$UX ~P1 Pp W 0;8X `h.=p  ,+; * *RP %0 %D % (% 0%0 8% h%,%& #6M$J0 $" (,3 (P3 (`( (,L, 4JI <(( <? P D6H` D0& HB< D  @ , ,0 0 48H@ 40&x 8 < 4 0 )" <( <<0 ( H6HX H0& PB< H <(",8H@,0&x0 <, ($$M  < "P(L7h(&( ( )$ 0 >8,x, (,&40M, , ,0 8 @P(X *+$,  Z 4+=1 ( 04 @ $x+=P1,] ,P h4+p=1  ; ; ; @ xH" 2$ @H6 * :@HP  X h, a--------------------------------------------ʼУ-----------------------------------------]@]X+ijһ͵ıʶкź͸ʽ3:1;2]p ʶ(ĬϱʶԶʶ)](ijһ͵ıʶ飨кź͸ʽ] ijһͱʶľֵ]ԶʶЌ]%Ѽ¼ΪյкŷŽ] <!4'"ȡĿ (0ĿȷģٽдУA@ `1qaz>$<B@|k1qaz>$<B@<1qaz>$<B@<1qaz>$<B@< V$T!NB@ -$ÿοʼʱѴϢsheet,'XϢ¼ʼ'.ôУУ¼Ƿд֣׶ϢУH z('#Ĭ϶ѼδͨУ'Ĭ϶δͨУд V$T!NB@ -$ÿοʼʱѴϢsheet, A65530$<%0%!'  A@D ȡ IV5 *%0%!,'j xcna = Worksheets(1).Range("1:1").Find(What:="*", After:=[a1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).ColumnFAILUREA@H&+ȡǷУɹ־Ԫ񣬲ֵʼΪ0'hռ¼ʼΪ0  &" ʱִ d ʼУ鰴ť¼ʱִ.ȷʼ Уر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@}ݱʶֵöӦķ k  $;$'Pȡıʶв   WԱʶб $   A@0k( eJ ʽ3:25p $'QԶʶ  Pʶеڵǰ$;$'eԶʶ͵ľֵ   kԱʶб $   A@ݱʶֵöӦķkd-ֻĬУʽ14$;$'Hȡıʶв   OԱʶб $   A@0k(k   $<%N(  6ִ һǿУ ĵԪΪϹĿ     е һдȷ' '8УʱдϢ A@P  'd   'Tÿһкϼеֵk <,һؼֶȫ򽫸ɾ  h+ h 'h,"ϢеĸдϢɾ  X  X X  V$T%@B@Br Ѹɾ  X  'X d'k k  h 6 ɾЧ $'  A@:B Ѹɾd8   A@:H Ѹɾk  h ˴Уɾ h,Чݣѧš֤šԱ $"444УʧܼΪЧݣA@ kH *дϢ鿴ϢA@ $<!b(j V$TB@Hd 'A@ '%ִУظݷ,ûظǷҪɾЧ Уͨ!A@ .$<!b(jSUCCESSA@H:+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 A65530$<%0%!' A@Dd *ظݣ鿴ϢA@ $<!b(j V$TB@Hk( k 1qaz>$<B@1qaz>$<B@1qaz>$<B@o q-------------------------------------------------ظijһ------------------------------------------------ ]`x] A65535 L%0%!'2Scripting.Dictionary$.O8O  L%0!`'>ȡѧ  %"ѧ໤֤ݽб   %-֤Ų  B@ &#addһΪkeyڶΪvaluekk ! 'Sheet2$<G:G70B@   z!|% !4G170,q0.o Attribute 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`ذť¼) ("`ȷr hexcel" & Chr(1`& "ܵݶʧʧ`1Can`@&ܰʾ") c"ŝ@ ? ST9TKTab@clor I:x -4142AiҳǩΪɫ d35startTitle +K d eûҵѧI޷模dQ%aQ!%gg`9QhXXXQ1writepLog + V`'"2\£?-> ׉}Fdi2 ToR atLeaOnefNэ= P>: һǿձ BOГH΀a?totalMoneyw&eyF "? %}"UR}ijs0ki`}eH[15/InE 'ǰQC0??9dcbԍԱ}-j 1,pu=9"b(j).@˵һc'%_is = $жfor@ѭ callFunc!XQSV S51/Zw 0p&QZ@ ' /T= St(o -o'14-3:25P޿ ":cQε#䄷AdP?IUBPd(S) 00s"ּϵQQ0͵U5O  "For m = LBound(bsType) + 1 To U *'+1ΪеһΪĬУ # %val@EntitySplit(m), ":") 'ȡıʶвкXź7HtRLowDJ(0? Զ=3v4"If iÀSXThen)'@>bGA1b;bBľn@F)H'ǀ8=callFunctionXQStar$t (n>1, i, j@sValidateCt 'C$ֵöӦķ&&NextEnd If!e! mi/aAYsA?= False YM5WCw"W? U U rSoSQ MKEG=?row<> 0?kʽ3:25_eǺ v `W) 'еڵǰa3E?_ʶo?_?4__?6_ i_____9?:X'()B914'YY//O$O$O$O"O"M" ?oWorksheets(1).Cells().LockedJz 3= j}' !ŷǿq ĵԪΪ ϱpĿUatLeaOneNullsfA0|= 6?merrorMsgP@"" && "0\ݰArE"дȷ8"hasC= True@ 'eдϢOOwriteLo|g =S=^T+ /~!OntotalMo`neySu+ 'ÿһ@ϼO4?Q},c= 4$Aؼֶȫ򽫸ɾ isNullRowArr(`Num) = i $ |z + 1+'Ϣеĸɾ+PFor p@curMsg - isValidateCount To ,YSheets(msgName).8s(=).Delete '`Ѹq+pN`ext p$=J> F+hasErr[= InZEnd If :q0|Aʭ- 1 '_ ЧО+rowDataIDq)If D!hlen^ dŠ1 , )Elsehq V 3;qw&j6> 8>(~Box "˴Уbl" &ĠA8& "?ݣѧšaԱChr(10) " 4ЁʧHܼ|ΪF "wn%lT榣%Works1).Tab.ColorInhdexi67ҡSyXctQ `S ` Fa3VcheckXQNew (1po'NotAE n 'ִ#Aظ!>,0ք'ǷҪ<ą;3Bͨ8!/ʱ/-41427 setCell@ueXQ 2,A8, "SUCCESS" 'ȡ! ɹ־ԪֵʼΪ01=rnap"Range("A65@530").-(xlUp"qI y N !Ona%FW2_2_2_2_2_2?@]2NAProtect Password:=`"1qaz '2).A3 Sub '-g!8һT  A(rADim myDic As Obj",KeyVarianIB4, var~|s/@Active.Y/5]/ '*Set idg = CreS ("Scripting.tionary"'Me" = "O48"p>O1j@ ).0valu0>ѧmEac h cara IFn 'Ա ໤pdP pV<> "" !W!Ye .Exisː) 'Xe1Add, | 'add#һΪkey?K4sSmyձ"=C$.srWith 4"!F2W!G:G!ClearContentc0 &1Resize(+PwApplica1!.Fun@(on.Transposa #1 O 'c0= `hP& !: 4xME(6 LL D` @ IF `IH `J P` iR Z` 8 I\ XIF xI^  b`   iR l` 8 !I\ XIF xIH In  xX`   (I\ IF 8IH  8`  3I\ I IF IH 8I  ` x HI I\ %IF IH I  ` X I xXI` `  `  I 8+ ` P I\ pI i ` p  `  )I` (I. HI0 r@2  : `  GI\  I6  D ` k@ MI\0  `IF I^ I`@  F@ ` TI\  I6  H `@k XI\  IF  I^  I`    ` @ ]I` ` I\  IF  I^ @2 @J @J ` H zI\ h IF  I^ `.`N`P@  X8 B %` ( 0 h H @Dl X 0 <@ h @ X @ H @D @ 4 @$ @ @ 0H@Hl <@xh @`X @H @D @4 @$ @ @  `  02[$*\Rffff*0b5b76b3a8*\R1*#33b*\R1*#10d*\R1*#101 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  x  0   6  0@6X 8 6 P`(x  0(0  f8  >&8 ` Xp h `*x* j&  ` X*h*  H(xH H( H(p H`( @ &H p ` (@ H H`( H@( H@( H(`  & @PXx n    88(p H((p   &(  P ` h  b   !(!@!H!`!&! " , "P"X"x" f" " ##0# 8# 8P#(# 60$(h$ % &% 8%H%P%p% fx% %(% & T0& && &&& $& &'$X0'$&'$ '$' '' ' '$t'$&p($ ( ( $(( (( ^( H)"`))@)&) )* *0*8*X* b`* *** z+ &+ + ++++ f+ `,p,, t, &- (- 8-H-P-p- bx- - ..(.0.&. . ,. /(/H/ ^P// //@/&00 X0h0 p0000 ^0  1 @1P1`1Xh1&1 1 ,1(202P2 ^X2 2 223T3&`3 3 ,3333 n3 h4 44"44&h5 5 ,5555 j6 p6 66"66&x7 7777 n7 P8 p88"88&X9 99999 P9 :8:H:P:&: ; .;H;P;p; Rx;;;<X<&`< < ,<<<< b< `=$x==@=&=> >(>$0>,X>>>>>>>> j> H?h?"x??&0@ X@h@p@Hx@ @L@ A A (A &A A B BB B(BHB ZPB BBB@B&(C PC`ChCCCC jC "(DPD`DxD dD &D E Eb(E hE ,E (F &F F FG G &G G HHHH8H ^@H H&HH@H&(I PI`I&hIIII ZI  J&8J`J@hJ&J JJ&JKK8K Z@K K,KK@K&8L `LpL,xLLLL |L XM$pMM(M@M&N 0N@NPN"XNNNN |N 0O HOhO@pO&O OO OPP8P |@P P$PQ@Q&HQ pQQ$QQQQ dQ HR `R@R&R RR2S8S V@S SSS@S&T 8THTPTpTxTT ZT U( UHU@PU&U UU(UUV V Z(V V&VV@V&W 8WHW&PWxWWW ZW "X00X`X@hX&X XX0XY Y@Y ZHY Y&YY@Y&0Z XZhZ&pZZZZ ZZ ([(H[p[@x[&[ [[([ \(\H\ ZP\ \$\\@\&8] `]p]$x]]]] Z] "0^0X^^@^&^ ^_0_@_H_h_ Zp_  "_0_(`@0`&p` ``0```a Va haxaa@a&a bb b@bHbhb Zpb b.b c@(c&hc cc.cccd Vd `d*dd@d&d e0e*8ehepee Ze e*fHf@Pf&f ff*fgg(g Z0g g(gg@g& h HhXh(`hhhh xh 0i6Pi.iii( i2i( i1j( j2 j( 0j1@jPjXjJpjjjjjj fjB  `k hk<pkk kk$l$0lXl`l hl \m B  pm,m 0m@m"0n ^Xn 6nno(oHo0hoHoopppp p (p "p p .qB  @q Hq$XqBq q q q q r rr r (r r r r sB  (s"0s Xspsxs sss s8ss2s0t Ht htxt tt tt Ftuu u u *0u`u hu v  vB  8v@v*`v 4vv vB `w<hw Jww w Px hxB  x*xx xB Py<Xy Jxyy yB  Pz Xz "pz z8z2z({ @{`{ p{x{ { {{"{0{ |(0|X|`|h|(x||&||| || |B  }}V}~ 8(~ `~ ~:~4~$0"Hpx -----------------------------------------УУдϢʾ ע-----------------------------------------------------------K Ԫ] F H L%N'JL J'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@lk1 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 HA@>ȥسķ F H \$<%N!`'` `$'  F е ;дȷΪ֣ȴ1ܳ20ַ''%УʱдϢ A@P  'k0 \  F H A@'Z================================= ִеijУ==========================================checkLenKT \ F HA@Hȥոķ \ F HA@Fȥسķ ` $'  ,$'$ ` ΪDZΪ̶ȶ F е .дȷΪաд򳤶ȱΪ$ λ'$ ed ΪDZΪȷΧ F е 4дȷΪաд򳤶ȱڵ$ λҲ$ λ'$ ed ΪDZΪ̶ȶ F е &дȷΪգҳȱΪ$ λ'$ ed ΪDZΪȷΧ F е ,дȷΪգҳȱڵ$ λҲ$ λ'k '0УʱдϢ A@Pkx \  F H A@'Z================================= ִеijУ========================================== checkSpLenKT ` $'  ,$'$ ` ΪDZΪ̶ȶ F е .дȷΪաд򳤶ȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ F е 4дȷΪաд򳤶ȱڵ$ λҲ$&λֻΪַ֣'$ ed ΪDZΪ̶ȶ F е &дȷΪգҳȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ F е ,дȷΪգҳȱڵ$ λҲ$&λֻΪַ֣'k'0УʱдϢ A@Pk \  F H A@'h================================= ִеijУ飨Numberͣ==========================================checkNumKT ` $'  ,$'$@ ΪDZΪ̶ȶ F е GдȷΪգдΪ֣0λȲ$λСλ$ λ'$ ed ΪDZΪ̶ȶ F е ?дȷΪգұΪ֣0λȲ$λСλ$ λ'k'0УʱдϢ A@Pk \  F H A@'[=================================ִֵΧУ==========================================ѴϢдбcheckValKT ` $'  ,$' F е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@P& isValidateCount = isValidateCount + 1k \  F H A@'_=================================ִеΪֵУ==========================================ѴϢдб"checkIntKT ` $'  ,$'$@ ΪDZΪ̶ȶ F е 8дȷΪգдΪڵ$ҳȲ$ λ'$eEΪΪ̶ F е 0дȷΪգұΪڵ$ҳȲ$ λ'k '0УʱдϢ A@Pk \  F H A@'`================================= ִе֤У========================================== checkSfzjhKT \ F$Z'S ȡд  F е &дȷ֤Ϊգ''0УʱдϢ A@Pd8  ֤ ` H$'O ֤У :֤У F е *дȷΪѧ֤ţ''4УʱдϢ A@P  'k(d  `$'  F е EдȷΪգҳȱڵ1λҲ18λ''4УʱдϢ A@PkPkHk@ \  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@P  'k0 \  F H A@'`================================= ִѧϢIDУ==========================================checkXJHKT `$'  F е EдȷΪգҳȱڵ1λҲ50λ''0УʱдϢ A@P  'k \  F H A@'[=================================ִпУ==========================================ѴϢдб checkBankKT `$'  F е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@P%isValidateCount = isValidateCount + 1k \  F H A@'W=================================ִ꼶У========================================== checkYearKT checkYear `$'  F е дȷ''(УʱдϢ A@Pd checkYear \ F HA@kh \  F H A@'W=================================ִѧУ==========================================ѴϢдбcheckXnKT `$'  F е )дȷʽ2012-2013ȣ''-УʱдϢ A@P%isValidateCount = isValidateCount + 1k \  F H A@'W=================================ִ·У==========================================ѴϢдб checkMonthKT `$'  F е &дȷʽ0112ȣ''-УʱдϢ A@P%isValidateCount = isValidateCount + 1k0 \  F H A@'g=================================3 ִеУ(DZ)==========================================ѴϢдб checkDateKT `$' 2Уʧ F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-02-21''-УʱдϢ A@P%isValidateCount = isValidateCount + 1k( \  F H A@'c=================================ִеУ飨==========================================ѴϢдбcheckDateNecessaryKT& `$' 2Уʧ F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-12-21''-УʱдϢ A@PkH \  F H A@'g=================================ִеijУ飨==========================================ѴϢдб checkBirthdayKT! `$' 2Уʧ F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-12-21''-УʱдϢ A@P  'kX \  F H A@'J=================================10 У绰====================== checkPhoneKT `$'  F е дȷдʽΪ"$"-̶绰 ֻ"$" ''%УʱдϢ A@P' isValidateCount = isValidateCount + 1k \  F H A@'L=================================checkOption У鱸ע ====================== checkOptionKT `B$'  F е )дȷȲܳ200ַ''%УʱдϢ A@P%isValidateCount = isValidateCount + 1k0 \  F H A@'\================================= ִ϶ѼУ================================== checkDiffNameKT checkDiffName ` $'  F е дȷ''(УʱдϢ' A@Pd checkDiffName \ F HA@ `$1ͨУֵΪ'dh'kXkP \  F H A@'d================================= ִ϶У(DZ)==========================================checkIdentityDateKT% `$' 2Уʧ F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-02-21''-УʱдϢ A@P'd  `$X$϶ȼΪգ϶Ϊլ'  `$e](϶ȼƲΪգ϶ڲΪ'd F е vдȷ롰Ѽ϶ơͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơǷͨУ''0УʱдϢ' A@P'kk \  F H A@'T================================= ִУ==================================checkMZKTcheckMZ `$'  F е дȷ''(УʱдϢ A@PdcheckMZ \ F HA@kp \  F H A@'d================================= ִ϶ԭУ(DZ)==========================================checkIdentityReasonKT'0,1,30' ` $'  F е 5дȷȱڵ1λҲ30λ''0УʱдϢ A@Pd   `$r1϶ȼΪգ϶Ϊ,϶ԭΪ   `$ew8϶ȼƲΪգ϶ڲΪգ϶ԭΪ   `$e F е dдȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬''0УʱдϢ A@P'dD F е дȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơ϶ʱ䡱ǷͨУ''0УʱдϢ A@P'kCkC \  F H A@'X================================= ִ֤У==================================checkIDCardTypeKTcheckIDCardType ` $'  F е дȷ''(УʱдϢ A@PdBcheckIDCardType \ F HA@khB \  F H A@'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType ` $'  F е дȷ''(УʱдϢ A@PdAcheckDisableType \ F HA@k@ \  F H A@'T================================= ִвмУ==================================checkFamilyIncomeTypeKTcheckFamilyIncomeType ` $'  F е дȷ''(УʱдϢ A@Pd?checkFamilyIncomeType \ F HA@kP? \  F H A@'v=================================14 checkGender ִǷΪСŮУ--================================== checkGenderKT checkGender `1$' '-ԱдУ֤Ŷ F е дȷ''(УʱдϢ A@P  'd= checkGender \ F HA@kx= \  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@Pdx: checkSqyyName \ F HA@kH: \  F H A@']=================================checkTerm ִѧУ--================================== checkTermKT checkTerm ` $ F е дȷ''(УʱдϢ A@Pk9 \ checkTerm ` $ F H A@'P================================= ִѧУ==================================checkXfKTcheckXf ` $'  F е дȷ''(УʱдϢ A@Pd7checkXf \ F HA@k7 \  F H A@'T================================= ִвмУ==================================checkDisableLevelKTcheckDisableLevel ` $'  F е дȷ''(УʱдϢ A@Pd06checkDisableLevel \ F HA@k6 \  F H A@'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType ` $'  F е дȷ''(УʱдϢ A@Pd4checkDisableType \ F HA@k4 \  F H A@'T================================= ִУ==================================checkSuortMembersDescribeKTcheckSuortMembersDescribe ` $'  F е дȷ''(УʱдϢ A@Pd3checkSuortMembersDescribe \ F HA@k2 \  F H A@'T================================= ִиĸְҵУ==================================checkParentJobsKTcheckParentJobs ` $'  F е дȷ''(УʱдϢ A@Pd1checkParentJobs \ F HA@k`1 \  F H A@'T================================= ִиĸĻУ==================================checkParentCultureKTcheckParentCulture ` $'  F е дȷ''(УʱдϢ A@Pd0checkParentCulture \ F HA@k/ \  F H A@'T================================= ִиĸУ==================================checkParentAgeKTcheckParentAge ` $'  F е дȷ''(УʱдϢ A@Pd.checkParentAge \ F HA@kX. \  F H A@'T================================= ִд󲡻У==================================checkFamilyDiseaseDescribeKTcheckFamilyDiseaseDescribe ` $'  F е дȷ''(УʱдϢ A@Pd,checkFamilyDiseaseDescribe \ F HA@k, \  F H A@'T================================= ִ뷶ΧУ==================================checkFamilyYearIncomeRangeKTcheckFamilyYearIncomeRange ` $'  F е дȷ''(УʱдϢ A@PdP+checkFamilyYearIncomeRange \ F HA@k+ \  F H A@'P================================= ִлУ==================================checkHjKTcheckHj ` $'  F е дȷ''"УʱдϢ A@Pd)checkHj \ F HA@k) \  F H A@'T================================= ִȻֺУ==================================checkFamilyDisasterTimeKTcheckFamilyDisasterTime ` $'  F е дȷ''(УʱдϢ A@PdX(checkFamilyDisasterTime \ F HA@k ( \  F H A@'P================================= ִУ==================================checkFamilyBurstTimeKTcheckFamilyBurstTime ` $'  F е дȷ''(УʱдϢ A@Pd&checkFamilyBurstTime \ F HA@k& \  F H A@'T================================= ִмͥʲУ==================================checkFamilyPropertyKTcheckFamilyProperty ` $'  F е дȷ''(УʱдϢ A@Pd0%checkFamilyProperty \ F HA@k$ \  F H A@'T================================= ִмͥʲУ==================================checkInSchoolCountKTcheckInSchoolCount ` $'  F е дȷ''(УʱдϢ A@Pd#checkInSchoolCount \ F HA@kp# \  F H A@'r=================================checkAtLeastOneNNull ִһΪǿ--==================================checkAtLeastOneNNullKT  'A"ִ һǿУ ĵԪĿ `$ `=Ϲ  ` ' H KTF  ` ' KTF  ` ' KTF  ` ' KTF  ` 'n!dϹ  'F6ִ һǿУ ĵԪΪϹĿ    'k !'n!i!_--------------------------------------------ʽ-------------------------------------]VBSCRIPT.REGEXP$.7RegExΪʽ (4 ȫֿvba\ת  (.ʽ (5ǷִСд ` %'3 ִ.i-----------------------------------------------------------° Уظ˵Ѿûиʽ------------------------------------------------------------V-----------------------------------------------------------1ѧ׶ڱڲ(sheetѧ׶ A65535 $T%0%!'*cna = getTotalColumnCount(sheetIndexValue) V$T!NB@ 1&ÿУظʱʱѴϢsheet,'XϢ¼ʼX==============================ѧ׶ڱڲ==================================0ðÿԪغ֮ǰнбȽ      $T%N'      $T%N'  .ѧͬ˵ظݶ  еݺ͵ ֤ظ!!!!' A@P*ѴϢ'ki-----------------------------------------------------------һ ֵȡֵ------------------------------------------------------------ֵҵֵڵлkeyWord ҵĹؼ'kbn л ֵΪ rowrow']the find result object " &$ *( A1:A65535 \$<%0% .  row !'d !,'kki------------------------------------------------------ ִڹУ(Ϊ)-------------------------------------------------------------value value1 cellУ鲻ȷfalseУȷtrue 00˵ΪDZ .$'zkxkp]h'4ijһļ¼ A65535 8$T%0%!'6B' 8 `row$'2=ȡ  2 6  8$T%N ` 4 '4dyxkp   2 2 4   8$T%NX .X LжϹǷcell'yk #ʱcountĿΪùеĿi------------------------------------------------------ ִɾijһвexcelܱģ-------------------------------------------------------------sheetIndex rowNum к1qaz> \$<B@< 6 \$<%@B@B/ Ѹɾ- Worksheets(sheetIndex).Protect Password:=123i0------------------------------------------------------ ָcellֵ-------------------------------------------------------------1qaz> \$<B@< ` F ^ \$<%N(`iP------------------------------------------------------ ִɾijһвexcelûб-------------------------------------------------------------sheetIndex rowNum к 6 \$<%@B@B/ Ѹɾi@------------------------------------------------------ ָcellֵ-------------------------------------------------------------@ 1qaz> \$<B@< ` F ^ \$<%N(`i`------------------------------------------------------ ݴеֵǰʱѾͨУ飩------------------------------------------------------------- ]   F ^ \$T%N!`X 'J'4ijһļ¼ A65535 8$T%0%!'6F 8 `row$'2Aȡ  2 6  8$T%N ` 4 '4dykx   2 2 4   8$T%N!`X '. . JX 1жϹǷcell  8$T%N!`'J JX F ^ L \$T%N(`yd .0 F ^ L \$T%N(`dX F ^ L \$T%N(`k(k  i------------------------------------------------------ ȥcellеĿո------------------------------------------------------------- ] Ԫ]  3Blength1ʾcellԭijȣlength2ʾִȥոַ'ĬΪûȥո2 Worksheets(sheetIndex).Unprotect Password:="1qaz" F ^ \$<%N!`'. .'N NGzj*"ԪΪգȥո . 'P%length2Ϊոһγֵλ Pַո . $R'. .X F ^ \$<%N(`'k ix p 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?WorksHEQ.vA` %G rGúɫ<僀?H)0HRedHnLen EKKRR.Characters(1, ).F@].Color7=3Vx_1&a ʼGs+` errafoaddComm@wXQUy,  0'4UUnprotect Password:="1q|az`e].rA ( Iarior#=<6@5535 '1ɫ>% d/.Visxibl$ƿ?""9clear s!, GyEqo!A}).o!o!rPI.C `u !/2Recp)Nu8m A:ffTotal`?B D .&UE15l XOOO`M.ExlNon(_L%AK Ƿ4*õķ8o)beginCq_c#LvMethod?*L@wLNot '焹aWʧ|?u$6 Is hing$жρ<Ϊ/T\ \w LAOAa'ȥǰq¡$ Drt_ z 'L aqp/ !.<' PBox "" &gD& "h*tt$ɹ3!0гqѕ&ʱđ .8MCq+remoPpaceFla(/Qո,ʾ:sW@УȀַChr(34)%C& w"րа ϵͳԶΪa%ˬ A ]!q?L b- '#PݱʶöӦķ(ʼУ)",{#-%BѴϢдб Functio@n callXQStart(typeVal, sheetIndex, row@columnisidateCount) value = Work$s(').Cells(*"titleMsg#s\T, O) 'ȡA=ͷ Ƈ(If "" Then 'ϲеıͷ 7/%0 - 1 &GElse"EB@:headW#!HW@End Iff!DArgs!"0"JÅ Like "checkLen*MGĄD Mid9& #EH%O 1H&Num, bernm &@flֵ?&?2 Inta9?%9- 'W9Term1L"ǡ"@ΪL">1 6K YesNo -k2 ? DiffNameѼa?%D~ CodslA! 'HBIDC0ardTpM֤ xo(/  kSqyyԭ _ _ "] e? ? kYearZ?MA_ _ ]  :iSpiiBE\ V11j BLvSelect Case =Q)1 ִǿ1?OC 3~N8ulldxMethodXQ7Required No '=q ִ}INumberͣ^ECase "4wJ=@- (valPue, ɔ)^I f NotP Txhen L S plit(, x","!(0)@0" 'ΪDZâΪ̶A`+E A   aΪv0λ7~С?AE ElseU,1 AUBoundj7A01_0_0&_0_/_/Ƿ_/CFt+aֵΧ<ġ]!ulдЌ XValXWiWgsPP9WWRLWW] yP&P7`]p_O6 3oo  o3x' isidateCStP+ 1O/57?7BO62sΪl6666Int657p7775p7XQnX777]`OwOOa@Iu" ?)@v8O"rEom;SToM"Co OIoWoWoWW dS sheetIndex, checkMethodX@Q, rowolumn0errorMsg isFor = True '= ִе֤У5 Case "Sfzjh"resZjlxVgetCellValueCou`ntXQ(2) 'ȡ̀дݛ0If 2"" TxhenKL"`" &" title JȷΪգ` h8asEz Ar 'fʱдϢ3writeLog ElsAKVC;Xʻ@9IsIDNumber(vA@?|C_<@'No&t  'O0σU<ACΪѧEC1_D_D Disvpidat#w`9-+ 1+End I>f?SMKSFZJLXcK)HO_AD?DbҳF1λ18e?H?H ?H>G{/? $  beginC_comment _a_G /|x"|CDf!M/{?{1y/j 5PDMLB(C, \"1"6b5XQyE55?y& ?y2y1:/1ww\o0!LsetCod%7&,U--*z,υO-*B-ѧŵ>--4XJH-U --Len"0, 1, 50O-% l O..OM!c#cλcc50c 22222F`0000oz0-0ID/1/1/1{?101SO]],_0_0_0_0돓/ //// writeLog error@Msg isValidateCount =" "+ 1End If>beginCheck_ commeasheetIndex, cMethodXQ, rowolumn AisForTrue '=ִУ.ѴϢдBб틁C ase "oBaxnk"|\(value)@If Not ThenQ"" &F["е titleȷΪ֣ڵfunctionArgsArr(0)A1IF=hasEA0Az 'oʱpЅfCn'@b+_b꼶b`-]0Year9^DMLB(#e", `, 1t`_F__>TSS?SEls@set*Codd+fټ_Xck_X==YѧY% Y' ]XnO]\Xn=[ -sg]ʽ2012-@3?//Y$s%* Y-O-  c_ 0 (,·,_@,Month--O-ZXQߊL ߊ+ߊߊՊC-0112----??[---7---oZ ---) 3 q-ڑ-()/...D" V'oHS |=Birthday.Oet.. 'ʧܟo]5{_0& ?M2Q0ΪChr(34bx-xx  Ѵ!`-0`1 ﹊ O3O3O3O3O3[O3O3O37O3O3O3O3O3﹏.22۩3K= 'ѴϢ,б Case "checkDateNecessary" ' P h\Method XQ = Bi@rthdayB(@value)FI`f Not=MThen 'УʧHMerrorMsgG"" & rowIndex"е title& "дȷ@ʽΪC@hr(34) x1-xx 2013-12-21@"WhasEXWTrue 'u±(Ѕޜ$writeLog E@ End IfbeginC_comment sheetO,Kh,Uolu mnD isFoNr:^ִkoo?y??2__"__ __ _ i@sValid@Cou\=.+ 1h hckEh*A hb10 ఺ 'PhoneҾNum^,ň ̵@-̶# ֻ$ϺX}XWa?'Vt O+^*^*ex^v_*'b%Option+ע /**d*p, 66r q+YȲ200ַ߄#UO(_4 BO(Gr'SO(O(S/SO(3 K(!' /% q϶Ѽ1T )DiffNamTS/UMB($ , ´, func2Args+BW@+S,,,,R9***LsysAicultyGradeFla0 ..ElseOEsetDMBCodFJSoce Tri5to"CGͨa(ǀֵΪuq2_ /@ O_Ojj6j>&B(Ǒ)o{BIdpityqg c[heckMethodXQ = cBirthday(value) If N othThen 'Уʧ_errorMsg"" & rowIndex "е@title-& "дȷ Ϊ%Chr((34)@x-xx  2013-02-21"WhasEXWTrue 'Pu(дϢ$writ`eLog intifyDateFla00Else(qsysDifficultyGradeNam1 And Trimh" Gz϶ȼ調PAwA41 5].2!N.<> ". /C/2/?롰Ѽfjͬʱa aͨZbqǷf`=ggAFbFa]_n neNEfIf<b eginCA_comment sPheet,,olumnAisForĖ  '= ִ́A>=kCase "C5Z4D 9DMB(, , 1TҀ70kΣ_^_^ V#Pset*Cod(2,%Uw$/,#QO,O,;O,O,,),O,(DZ)o{ -Id`:ityReason" 'u functi@onArgst0,1,301v1PLenx, 1f10A| 62agڵ@1λ304/55?5f`ߔޔd= =ϊu,-|_  = G#    ? 4 (` 0 Or O )% /_4_4_4\4Ϝ!Üʱ|䯝H O7O7O7nO7O7Pߞ  moO/ w True 'Уд writeLog er@rorMsgdcheckMethodXQ = False6End If#beginCo_comment sheetIndex, , row `olumnli0sFor` '= ִ֤́={@Case "]IDCardTyp.B@.XQVr.&V.VM!.9_/ex𬿲I ?^_/_/_/J_/_/_/_/Q/_/?/\DTyp O/O/le?/?/?/?/t?/?/OOO?/?/?/* ]?/?/CJ//////G////////6////],^>ˏ^//uortMembersDescrib// //Se"O0O0O0O0tA0|rMsg = "" & ro@wIndexP"еltitle& "дȷ" has ErrorTrue 'Уʱд@ϢDwriteLog eJ*ElseEsetDMBCode "checkSuortMembersDescribe",@ sheet,, column 1End If beginC9_comment2FMetho(dXQ:,~is&FB'= иĸXҵe^ =7CDasSPar5JobsT 9d(c, value, functionArgs)KIf Not Then  +A 0 Then 'ϹOctotal7T +X}1ѧ׶ڱڲ8 -B}{SameXQNew( sheetrt2) 'w(na Ss:.Range("A655 35").P(xlUp).Row 'cgetT1wVG(msgNP ).Cells.ClearContents 'ÿʱʱAϢB ,curK P 1 '¼ʼ'=?ocO'ðÿԪغ֮ǰнбȽϧ1Ti0 startT!YX2 To rnag4carpdID1Ia2(i, co3YOdAjO@ip - 1oq32exj$iv eר+ ͬq:a1;ݏ eenl= "" & j0"С1rݺCiC֤@!_pf writeLog '*0 has;rNv Next?nGFһ ֵֵo` #ҵCлkeyWord Ĺؼabn"# ֵΪ rowǀHQGet@ODl0(ByH 1, cStrfs IHgerm--1c׃ '@ fires ult o_ c{@@k XVtX1 :XF(What:= Look@In:=xlVs, A xlWhole>6t@Is TuR$(Pnk3`"1  c baQI-0q.'' ְauqf(Ϊ)@+cq11 cell '鲻falseTLtruHFunction checkDMB(value,  1, fla g) If = "0" Then '˵ΪDZ'+/TrimQ1)76 &*}#T Exit  ?End IfDim rowDataCount00 'ijļ¼NumSheets(AreasIndex).Range("A65535").7(xlUp ow '{%iFgH0GetRowOrCol.5, "") 'XYFor i'EToA=@1/b3Cs(i, g|vN+ 1Eg CjorhN`ext iA.jN.k + -A2CStr(3j, 3) C)жρQ@Ƿȇ,3_I< B=j' ʱc@ĿΪÁ#˘A A '-2 ִ ɾ]exܱxģ 8@c p Qah к e delete ^(',$UWorksh).Unprotect Password:="1qaz"*@ s(c).D 'ѸC"b' P.1232)  ָNֵ8H,setyVgXQ-", cd/V!}0XC1l).Í=C͟+$ W^ûЁ^_^ _^O^NoIM1`d^X (O((((Q+?(AxC@@(et).(w(jE ݴ!]ư>ǰ1Ѿͨ)CodeWbW  Bde2sWB2p|y9C= QS]___YB= ???Q~a*0es?R_ǴQ?Q ?9CL"ݵ"қaY)?qt(I c2,o%b% 2$C$o0pxumnPlusH4V ϶O"/مs T䄟 ue ? #T9"$js%}uqaX ȥSո^removڱeSpaceXQ(sheetIndex, rowHcol$)  Dim value1 As String 'Ԫ݁ ^length`Integer, &2D ''ʾcellԭȣ0ִȥոַ&w remov = False 'ĬΪû@' Wor ks).Unprotect Password:="1qaz"+7=!Cgs(=.$XLeLn(+If10 Then Exit Function 'Ϊ衅62 Inr, " ")c2һγπֵλ$2 <> %!fjG Ã7@Repl}!"> hWC7True+End If Z N]~xME(6 << <X `@ I\ `IF IH H`J 0`  I`  @ `p  I\ %IF I^  H` I` ¼@  `  I` @ +` i Уi^`HǷ`H`` `д 0`  I` @ `p  I`  @  `  I` @  `` I` @ 0 ` I` I @  `p I` @   ` I` @  `` I` @ `  I` @ `P I` @ @  ` I.  I  D ``  I.  I   `  I.  I   `` I`  I   ` I`  I   `` I`  I   ` &&I`  I   ``  I` @  `  I`  p `8  I` @  `  I` @ ``(  I` @ P` ""I IF I^ ` ` `P````@ ` @ ` @ lls` u`@ ` ` ""I` coI wri@ ` `(  I` ment@ Colo0P 0   `   H p 0 |`tH%  /`02[$*\Rffff*0f5b76b3a9  B       (  B " 08@HP XB px    B    8HPX`h pB  n P hB ,$"H( p x "   "0 X ` 4p  0 P B h p *x         B          (   B   6 ( 8 @ H P X |`  B  0(Xhpx x  (B @ H Xx x p B  |  B $ (0 |8  B fhx |   @B X`h  H hB :  ( 08@HPX `  B 0 8HP X `p x   .0B ` h x   .`B   B x &D4@x  B  &   (( PXD`4 8@HPX `B   (0 8X "`  <  B     & !!! ! (! H!"P! x!! $! "! ! ! ! !"("H"P"X" `">x" "4" # # # (#0# 8# # #B #$$ $0$8$@$H$P$ X$ $ %B  %(% 0% @%H%P% X% % &B  &(& 0&P&`&h&p&x&& &  ' @'B X'`'h''''''' ' P( p(B ((((((((( ( ) )B ) &) $* 0* P*&`***"*$*+((+P+p+++++ + 2+0,"P,x,,  ,,,8, -(- 0-B ---&-. .& .H.P.X.`.Dh.4.../// / /(/H/h/x//////// / @0 `0B x0000000000-----------------------------------------1 ,дϢʾ Ϣsheet--------------------------------------- ʱ0 Ϊʱ1 Ԫ] F H \$<%N'J J'd'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseʽȷtrue]^[\u4e00-\ue863]{1,20}$'  `$'d'kiȥǴӡַ0 F ^$N'v v $" x  MsgBox addr v z!|%~'v MsgBox addr v F ^+Nki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)--------------------------------------- `$'zHk@]0reg = "^((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]))))$'  `$'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]))))$'  `$'dx'khi`h-----------------------------------------4 У֤---------------------------------------Ϲ򷵻trueϹ򷵻false]79058421637905842@0Ȩ] 10X98765432X0У $$''ȥո]p ^  6)׶֤Ϊ,ΪͨУ'zk Gzj $$Gzj *[0-9X]Gzj   $' G 'j   $  '   ' $   $G'jiz-----------------------------------------У֤ -------------------------------------------------------------ʽȷfalseʽȷtrue]"^[\u4e00-\ue863a-z|A-Z|0-9]{1,18}$'  `$'d'ki----------------------------------------5 -УѧУѧУʶ 42λһλΪֻx-------------------------------------------------------------ʽȷfalseʽȷtrue0]^[1-9]\d{40}[\dx]$'  `$'dp'k`iXz----------------------------------------6 -У黧 -------------------------------------------------------------ʽȷfalseʽȷtrue].^(\u519c\u6751)|(\u53bf\u9547)|(\u57ce\u5e02)$'  `$'d8'k(i u-----------------------------------------7 Уѧʱ-------------------------------------------------------------ʽȷfalseʽȷtrue ]'^(((19)|(20))\d{2})((0[0-9])|(1[0-2]))$'  `$'d'kiq-----------------------------------------7 У-------------------------------------------------------------ʽȷfalseʽȷtrue ` ,ΪDZ'kzk]^((19\d{2})|(2\d{3}))$'  `$'d'kiq-----------------------------------------7 У·-------------------------------------------------------------ʽȷfalseʽȷtrue0]^((0[0-9])|(1[0-2]))$'  `$'d'kiv-----------------------------------------9 Уѧ-------------------------------------------------------------ʽȷfalseʽȷtrue]^\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'  `$'dx 'kh i` v-----------------------------------------11 Уп-------------------------------------------------------------ʽȷfalseʽȷtrue]^[1-9]\d{14,20}$'  `$'d` 'kP iH -----------------------------------------checkXn Уѧ磨2012-2013-------------------------------------------------------------ʽȷfalseʽȷtrue]p]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 'kp ih ------------------------------------------------------ȽϴС(Сڵڷtrue)----------------------------------------------------------------'value1value2false 򷵻true .X'. X' .  'DdX'DkHi@------------------------------------------------------ȽϴС(Сڵڷtrue)-dec---------------------------------------------------------------'value1value2false 򷵻true .$4'. $4' .  'd('ki}------------------------------------------------------У鳤--------------------------------------------------------------- ,$'' `$/ΪDZ'kzk ,-±0ʼֵΪָάõ± `$$4 `$$4'zxkpd ˵У̶ `$$4'z kki}------------------------------------------------------У--------------------------------------------------------------- ,$'' `$/ΪDZ'kzk `$& Ϊz `.e+Сzk ,-±0ʼֵΪָάõ± `$$4 `$$4'zkd ˵У̶ `$$4'zkki------------------------------------------------------УֵΧ--------------------------------------------------------------- ,$'' `'zk `$) Ϊz `$4e) С0zpkh `$4$$4 `$4$$4'zki------------------------------------------------------Уֳ(Number,ΪҲΪСС0)--------------------------------------------------------------- ,$'' `$/ΪDZ'k z k `$% Ϊz `$4e% С0дz kx $'+󳤶$'.Сλ λ `.''' "˵ûС `$4'Ϊ $$4ݷ'zkd С ` `. $'DԪֵλ ` `. $' $$4 $$4Ϣ'zkki-----------------------------------------checkIsInt У鲻С0-------------------------------------------------------------ʽȷfalsechecʽȷtrue' ] ^0|[1-9]\d*$'  `$'d'ki-----------------------------------------checkIsNumber УΪNumber-------------------------------------------------------------& iʽȷfalseeCountʽȷtrue ' `$'ki-----------------------------------------checkMoney У0-9999-------------------------------------------------------------'ʽȷfalse$ʽȷtrue ]X ^(([1-9](\d{0,3})|0)|0)$'  `$'d'kix-----------------------------------------checkMoneyTJ У0-9999Сһλ-------------------------------------------------------------Ϊʽȷfalseʽȷtruep ] ^([1-9]\d{0,7})$'  `$'d`'kPiH-----------------------------------------checkPersonNum У׶԰һ------------------------------------------------------------====ʽȷfalse֤ʽȷtrue== ]H^(([1-9]\d{0,3}))$'  `$'d('ki-----------------------------------------checkIdNumLink У֤ԱͳûдǷһ------------------------------------------------------------ʽȷfalse֤ʽȷtrue` If colIndex = jhrIDColumn Then checkIdNumLink = TrueΪѧ Exit Function End If]%Ա֤ǷӦ]$ں֤ǷӦ]0ڵһγֵ±E]H"Ա,Ԫ֮ڵ]`$ݺŽȡ]x!,Ԫ֮ڵ]"ݺŽȡ]# H]%·X==] ==]8 $' $'==  (ڶλΪΪjlx  F  Z$T,NdڶλΪżΪŮŮ F  Z$T,Nk` $' $' $' -  -  F  Z$T,N'i}------------------------------------------------------У鳤---------------------------------------------------------------P ,$']^[\u4e00-\ue863]{1,66}$'Ϊ' `Ǭ$/ΪDZ'kzk ,-±0ʼֵΪָάõ± `$$4 `$$4ѧ  `$'d'kzkd ˵У̶Ț `$$4  `$'dx'khz`kXkPiH-----------------------------------------У鿼šѧšѧ -------------------------------------------------------------ʽȷfalse=====ʽȷtrue==]H^[a-z|A-Z|0-9]{1,40}$'  `$'d8'k(i mAttribute VB_Name = "У麯" '-%1 ,дϢ ʾ sh`eet$ʱ0! Ϊ1 Function checkRequired(bIndex, row coluDmn ) 'ԪDim cellValu@e As Sng= Work5s8).C s(;If2" Then0K gFalseE{Trund If E-2"ѧ ҪΪ8& !ʽȷuf7'At1wStu(vgDplreh @"^[\u4e00-\ue863]{1,20}$5@_@ CA(, aBW Wa ka@@ǴӀַremoveEnterEaddr@&E@;In(1, A , C@hr(10) 0( 'MsgBoxcO Applicao.f`e5.Clean(Al@VW' _O$3WKΪ2012-05-0@9() "4"CBirt0hday*R-Trimd"{ vExit */Ay#a_'X ^((19)|(20))\@d{2}-(0?[13578] 1[02]))-9a[12][0c3[01 (( 46"11Y 0?2q )))p;[1[Oh8 cEAJ9?PބV](]--..Necess@CJ/oX "((P&|(j( 3-?`PPx:Q9yM;42!z֤0!xv'Ity5H IsI DNumbpiBy , g)BooaLConst W' "7905842163"2'Ȩ өc10X98765432Cɒ '' = UCase(Z )) 'yո-sIyger, i=TC= babyIDC| A4a ׶e:,ͨ1  dd c! Len( <> 18B 0 Notp er@ic(Mid, 17@4 f%Like d"*gX]_  For= 1 To 17CTqW0TנC 1@đ1sps + ; Bi! * TNexts Mpod 1RPight)c,+)3 '~^; "@ё?Q?'SFZJLX`/)a-z|A-LZ|18ckkVqOw~kVXX//5ˡ3-ѧP0ʶ 42λ0һ Aӻ~x?ckSchCodeOeg~ reg = "^[1-9]\d{40}[@\dx]$"If Check Func(0, value) TXhenJcFS@chCodeTrue8Els LFaEnd 0If ktiRo^'-$6] -У黧 %< 'ʽȷfV tsW FamType(Dim(\u519c\u6751)|3bf\ u95477cee02)ȄEȇ dS7 AcѧʱY%6cRXDat!b((19]20))2})((X0[012])5a `F `FU`eZ/CcqaYeara, f zArgsArr)a@e#""cz 0 'ΪDZ raGŏiaExit j{| "^II|(23}GԪpdG;dGGz GtGMontht*D-?-"-9Ja ׺ŏ8--XJHeg5%k,4}P*7т337}ik@1b;#_10i绰O_؟QckPhon0eNum?<\bD(([38h4[57]p5`L35jk8} 050p2@j-["2\d*[3{2}g)\bN; A?p_11п2OB8ank 314,20_2,p"04oo 7n8I瀣2012-@3_pXn_Uxy s[K(20K/t019t99 00o_\2Split , "-"4LpR(1) - t0)01= ۊholkXn""s Op#ע#СR2_#OP#200yٷYVck 1$22 14h ELe-@">2!VL ?#Q checkOption = True End If !Func  '-2ȽϴС(Сڵڷtu)3O5value1 2[false j  com pare(, ) CInVt 2 2I"f(1 >- TxhenC$FWE^ OdeckykDec!l l9llC m_У鳤>hdALen., fĀArgFsH+Arr"S plit(, ","h@ (Eg9 ""f`(0 )0 'ΪDZh"o?2aejExxit e$g `UBound #2±0ʼֵΪָõx F4)` >= C Mm(`1)) A H,  InStrY".@") <> yСoK.) KsKKKK Bp:Kg1K_=Kb=KKIK-/  KK_G-qK൷ΧKValϋϋ01@.0DKKKKK'G_=A`#/Fe/F,FoQ2+ R7IFQ0E/A z)?@3@0]`q/2Uy_ U q'//*t/(0bber,dΪQ|Ҳ\1unction checkNum(value, fArgs)  XArr = Split( ., ","fAXFalseI f "" Txhenq# t(0)00/ 'ΪDZ?GTrudEnd IfExit< F QNot Iseri c)PΪ 1/)CDe$<= x`С0%lmaxIntLen1) '󳤶 @@Double2СPλiBgthInStrE". Af VA@ ;douTMIM˵ûC&K$^ ?( ) h S TP}E@˦AMid31, 5 - EԪ֒[āGλ6H + &?/ @(1)) A 442*a5,51ep '-#bIs} У>48ʽȷf#'etb%ĈJDĀDim reg=}"^0|[1-9]\d*$"#>C! (, l= _C 3s.?.e% ber.Ϊ8*_.0s.#. = 8ly G{+?/Money 0-9E_+_ck + +((+(\d{0,3})|0!_,k_,*H_,,V,_,o_TJ=#tλϟ`TJDD7})??+`j__p0_ --Pers on <׶԰һooo`v O101c}k] OIdLink֤ͳдǷһ?ooo` (, rowIndex, col'`fxjhrIDColumnt' F0`!voCisGe rRight As BooleanL 'CEϡӦ Birth/+hlen@2e g|'qһγֵ±[gb ɣ` ingS ,tڵݟer1J @Žȡom bqe?aʳthValue1 As String 'ŽȡĀ Dim year,Variant ' Zmonth,  ^ ^day,  + arrgender= Mid(IdNum, 417)) binr 28If 2Mod 2 = 1 Then 'ڶλΪΪ"Sheets(sI]x]).Cells(row ,9Column)6""'Else<ż<$Ů<ŮInd IfF"$G@,bZ@c, 4d 5, 2 Q kI &V$V++ "-" +C 5check!BLink$Tr ue E@DFunction '-2У鳘sF E" B+SpLen("vA, f)ArgsWArr@Split(,0 ","hregg#"^[\u4e00-\ue863]{1,66}$HFaYG m "blghS`(0d0cr'ΪjC9 A;]Epxit g>UBoundj)`,A2D±0ʼֵΪָõx3 <) >= CDecm(1)) A`UHstdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-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 ABD63AF@@hC-48A 4-87DjE53D61FD68B6Users\ADMINI~1\AppData\Local\Temp\VBEc7.exdd<@".E .`M  ThisWorkbookGTi@l"Wnkbok 2 HB1JB,zL""+BsShePet1G Seq@at1 w2 H *6 6 6 6!   ӡ GSbpSȉ-e2jo p !(e) c ]wQQpec ec eo k G;`Xf"a2fo zo &У!h>eeo T]o ~k !LGbQ;N z^b2)o J.o U2ShowaxG`6\ow3e2ro1]nO( Tl5^5^5^5^0Qh^ PrintCrinwEbj2odʘrU , `//( `00 ` 1///( `08! `Q////0I ` ///<q `q/////< `/////, `//( `/0 ` 9Q09 ` ay///,a `//8 `1////, `//8 `1////8 `1////0) ` 1///nrU h 14Y 0  XrU @4 `\#nrU   4Y`rU~|   I 1aa0  0   0   0   0   0   0 X  0 8  0   0   0 $  0   0   <:4%DX%h$ h dD)hDJ$%DX%h$ h dDC)hD5x(9lhD0   <:4%DX%h$ h dD)hDJ$%DX%h$ h dDC)hD5x(9lhD0   0         8/=H#<EGYF8T? FHC gHn0`xHC gHn0`EGYF8T?ME PSLSS006"<<<N0{00020820-0000-0000-C000-000000000046}( ,` @\ ).`h %i x%%*%@`\02[*\R1*#222$*\Rffff*0c5b76b3a84  "  &  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 @nt6DD zL#<@:F9.F?dO0+) x?dO0+) @:F9.ME(SLSS6"  <,<0<4<8<<<N0{00020819-0000-0000-C000-000000000046}` `k@ i `i % % %`@"$ &(f^ @l @\ @0L ownW@x< @H, \@` M@ Layo@ eDow@ onWW@ eWWW@ @8 lWWW@ @  @P @| @hl T@\ Actu@L @< @, @ T@ @( @@ @ @ @02[$*\Rffff*0`5b76b3a7*\R0*#f*\R0*#1*\R0*#14$*\Rffff*0a5b76b3a7*\R0*#2$*\Rffff*0]5b76b1a14 "      )ǷȷϽҪexcel籣棬"$"ȷ"$", $"&ϵͳҪмУ飬粻棬"$"ȡ"$"? $$ '  &ArA@(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 <jx#<#AGCEs F AN88փx AN88փ#AGCEsME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` %6 %`h8@\\002[$*\Rffff*0e5b76b3a84xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2<jxh#<)M(] F9HjsK bx9HjsK b)M(]ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@\\002[$*\Rffff*0d5b76b3a84 xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 L+nxME(SPSSS0{EC1CCD73-32D4-44CD-9DE7-A6739D2E2EA0}{81C678E2-1AC8-4E08-9BE5-67AE817A519C} @ % %@@02[ " 0 8"HP Xh xȡ------'l B@------oHȷ------@ 'l B@-----oRAttribute VB_Name = "ShowForm"  Bas|0{EC1CCD73-32D4-44CD-9DE7-A6739D2E2EA0}{81C678E2-1AC8-4E08-9BE5-67AE817A519C} dGlobaBlSpacoFalse Cre atablPr@edeclaI"dTru BEx0pose0TemplateDerivCustomizD'ȡ` P Sub CancelButton_Click() notContinueBoolT Me.HidZEnd! 'ȷĶ ,onfՏ,9-Fl;/HLOʘxME(SPSSS0{74312E55-C162-47CA-BB01-52C39B364B89}{B9A02D18-FC52-4FF3-AFC5-BFEFA0DEDE52}p0(%X0 %0`02[xAttribute VB_Name = "PrintForm" " Bas0{74312E55-C162-47CA-BB01-52C39B364B89}{B9A02D18-FC5JFF3-A-BFEFA0DEDE52} d@GlobalSpacoFalse CreatablPredeHclaIdTru BExpose0TemplateDerivCustomizDrU $`$`nrU~| krU $`nrU~|      RrU @nrU 1 Y4Y`rU~~~y        SaveAsUICancelrowIndex columnIndexcontent sheetIndexcolIndex errorInfo checkMethoderrorMsgtypeValisValidateCountregvalue sheetIndex2keyWordkbnvalue1flagrowNum Y (TargetIDNumberfunctionArgsArrvalue2 functionArgsIdNum rU  Q Y y ) A i  $4 a  ` x"l "   " "\ ''' :\lL:<, :::|l\L:<,^z6$lL, l\L, u  $9 TlL, l\L, 4XrU @,`#nrU~| prU ' nrU 0` ///(`/0` 1///(`/(!`/,I`1(q`/(`/(`/( `/, `!//(9 `/(a `/( `/(`/(`/,`aI//,)`aI//,Q`aI//,y`a//,`a//,`a//, `a//(1`/(Y`/(`/(`/(`/0` 1///,!`a//(I`/nxME(6 << <x :`8p%H@02[$*\Rffff*0_5b76b1e1"  ( HhxѧϢӡģ$<(>ѧϢӡģ$<B@@ѧϢӡģ$<(>oAttribute VB_Name = "Ԥ" Sub Browse_Print () Worksheets("ѧϢlģ").VisiblaTrue"d^P@review2cEnd ThisWorkbookThisWorkbookSheet1Sheet1ߺ]wQQpeXfУ麯!hQpe;N z^ShowFormShowFormӡԤSbpSȉPrintFormPrintFormSheet5Sheet5Sheet6Sheet6 F#Microsoft Office Excel 2003 Biff8Excel.Sheet.89qOh+'0@HTl AdministratorMicrosoft Excel@&@my՜.+,0HP X`hp x  ͥϢɼ Ϣ м м ĸ ĸĻ ĸְҵͥԱش󼲲ͥ˾뷶ΧͥԴ ͥѧ ͥʲ Ǻͷͻ¼ ѧѡס޷Ȼֺ  Χ !"#$%&'()*+,-./013456789:;<=>?@ABCDFGHIKLNOPRSTUVWXYZ[\]^_`abcdefghiklmnopqrstuvwxyz{|}~     "#$%&'()*+-./012345678:<>?ABCDEFGHIJKLMNOPQRSTUVWXY[\]^_`abcdefghijkmnoqstuwxyz{|}~  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\^_`abcdefghijlmnopqrstuwxyz{|}~      !"#$%&'()*+,-./012456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmopqrstuvwxyz|}~