ࡱ; YRoot Entry F ZfWorkbookBSummaryInformation(DocumentSummaryInformation8  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXu[\]^_`abcdefgsijklmnopqrtvwxyz{|}~  \p YIBAN-XSC Ba= ThisWorkbook=`W$8X@"1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1Arial1@[SO1[SO1[SO1 [SO10[SO1[SO1[SO1[SO1>[SO1[SO1 [SO1 [SO1[SO1>[SO1 [SO1h>[SO1[SO1,>[SO1>[SO1?[SO15[SO1 [SO1Arial15[SO1[SO1[SO1[SO1 [SO1 [SO1 [SO1[SO+""#,##0;""\-#,##05""#,##0;[Red]""\-#,##07""#,##0.00;""\-#,##0.00A""#,##0.00;[Red]""\-#,##0.00i*2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ W))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ y,:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ g+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ /\$#,##0_);\(\$#,##0\)9\$#,##0_);[Red]\(\$#,##0\);\$#,##0.00_);\(\$#,##0.00\)E \$#,##0.00_);[Red]\(\$#,##0.00\)e0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-u8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-c/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-S'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-                    /     * -                    P P 1        ff7 !   "` #a $* %+  1    /  6   1   ,   / /        x @ @  ""@ @ ""@ @   @ @  !@ @  @ @  !@ @ 1 1@   1  1Q 1 1@ @  1!<@ @ 1@ @  1 1@  1@  1  1 1 1 1  1|@ @ 7  1|@ @ ,  1Q@ @ 1Q@ @  1 1  1 1@ @  1 1 1@ @  1 1@ @  x 1@ @  1 1 x@ @  ||v}$n}-} }A}ef }}  ̙ ??v}A}L }A} }A}23 }(}  }(}  }x}  }A}23 }-}  }-}" }-}# }-}%?}-}& }A}(23 }}}) ??? ????????? ???}}}*   }}}+ ??? ????????? }A}-ef }A}. }A}/ }}-}0 }A}1 a}A}2 e}A}3ef }-}4 }A}5ef }-}6 }A}7ef }A}8L }A}9 }-}: }A};ef }-}< }A}= }-}> }A}?L }A}@23 }A}A }-}B }-}C }A}D23 }-}E }-}H }-}I }-} }-}J }-}L }-}O }-}T }-}U }-}X }-}[ }-}^ }-}_ }-}b }-}c }-}i }-}k }-}l }-}m }-}n }-}o }-}p }-}q }-}r }-}s }-}t }-}u 8^ĉ!20% - :_eW[r 32&20% - :_eW[r 3 eQeQ!40% - :_eW[r 32'40% - :_eW[r 3]]!60% - :_eW[r 32(60% - :_eW[r 3  8^ĉ 6 lʑ lʑ!60% - :_eW[r 22$60% - :_eW[r 2 h 4h 4 fJTe,g fJTe,g !hh"8^ĉ 12#ʑ'`e,g 5ʑ'`e,g $h 1h 1 %h 2h 2!&60% - :_eW[r 12 60% - :_eW[r 1 'h 3h 3!(60% - :_eW[r 42,60% - :_eW[r 4 )QQ *{{+hgUSCQ8^ĉ 2 2!?40% - :_eW[r 52/40% - :_eW[r 5!@60% - :_eW[r 52060% - :_eW[r 5A:_eW[r 6&1:_eW[r 6B8^ĉ 2 3!C40% - :_eW[r 62340% - :_eW[r 6!D60% - :_eW[r 62460% - :_eW[r 6 E8^ĉ 2 F8^ĉ 3 G8^ĉ 4 H8^ĉ 5 I8^ĉ 7cc PK N@theme/PK N@ theme/theme/PKN@ky}theme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PKN@<=theme/theme/theme1.xmlYOo5#MvlM6Цۢ7&jHH q Jĥ|@_g{fNHB#@=$3{~\0aIyWj"i4ai=@RtOI;\|kxC$!֧rXlcyY0&\$X݄-jk iR; IY1*B&(h\]Zkfr&LC!yİT0j,o^["NY_._0>X1.֚w.t:V.%ᰪ寭5V<Y|slukހ,~m߿ZkxMڡ~NL8۩|(24 Ou]K](<\_V4Ej ! ؙC\L T;x?Ðsz_|3GϏp--oN#w᫯?oϾzjt?O?~Z TK<I|K ҄Ht}n0d$.bcJ#STCߞa+p[RR1} ũ4j̡≹DZpٸ颐TɟRϮ4)`ܾ!4CˬJ𷲵ݵóەGո!0ό7¦'5-*!3T0z"՚;u~L۷,у*0.ٳdѳ<h*.3DpzQjpFH3SQ{; &@uB?ݶȿf[_U율اN.c/xȌŽm~[|>-/61Tjߊ26P3FnIӎK؎}̡,GE5HpU uG2'Iq gI3\I[3〲'Ѧ>"c;HIHohU8/ի9Q0kͭnD3VMlN`R5, }Gz@QmR\$c<&ދ>'>Wa5[K}nqˮq {o" /LGRtZ͕fB 1REp*ad6Y>fPƻ:܌ݻ/(ՁLᵍL!Rʿ^败鬮0גɄʳܶ3mRʧ<>B#6ܯCS "6S~qΓν038;Y-2M27G<ЭRvU1)Ia?SE'p!:X`3pbU(iB׿0 Aw 9Kä5+>XeDeI(G\YG䐰kzoP nI^ dy"Ur9ww>6A))fyy(4f0l-+DVk+ւ+B80X6D\+!?*Bf? u"A@T/iG8AL+nՊRڨ J'\%;/h9yx-ڎjjIq11_O^| /Sm@PK N@_rels/PKN@֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK N@theme/theme/_rels/PKN@ ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PKN@ $[Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,x\vTU^hd}㨫)*1P'^ח0)T9l#$> `?Cs]7zb$xu-lV{9>DVNj,5(Bȥszҕhhs0U~,}2ToF0,į*=댬o[gv; 9'33y ; oOPKN@ $  [Content_Types].xmlPK N@_rels/PKN@֧6  _rels/.relsPK N@theme/PK N@ $theme/theme/PK N@theme/theme/_rels/PKN@ ѐ'  theme/theme/_rels/themeManager.xml.relsPKN@<= theme/theme/theme1.xmlPKN@ky} Ntheme/theme/themeManager.xmlPK ?. XTableStyleMedium9PivotStyleLight16`l[^~NmOo`ǑƖNxhOo`VV4PH #MOC A@" ku~+R;" ku{|+R;-KmՋ@b g!hĉRv^SbpSOo`" 6rkt^;01" 6rkeS;-." 6rkLN;)+ 7bM|=, [^bXT`͑'Yuu=, [^NGWt^6eeQV=* [^6eeQegn{|W=& [^(Wf[Npe;&'" [^DN=" a{QN;34  /fT&T=2 zSaYNNwQSO`Qc;#$& f[90OO[9;HI. 6q~p[wQSO`Qc; !!  ;   checkName checkZjlx checkSfzjh checkYesNo checkYesNoTS checkYesNoTS2 checkYesNoTS3 checkYesNoTS4 checkYesNoTS5 checkDisableLevel checkYesNoTS6checkLen0,1,18 checkYesNoTS7 checkLen0,1,100 checkFamilyDiseaseDescribecheckFamilyDisasterTimecheckFamilyBurstTime checkYesNoTS8 checkYesNoTS9 checkInSchoolCountcheckParentJobscheckParentCulturecheckParentAgecheckSuortMembersDescribecheckXfcheckfamilyHouseType checkfamilyCarType checkInt1,1,2 checkNum0,6,2 checkNum0,8,2checkLen0,1,200checkFamilyIncomeType[^~NmOo`ǑƖ zjlxisFiledPoorFamilyisZcjYfpisZcjYzpisTfyzknisGdJdlk isSupportisOrphanisTkzgjt isCyzdshbzisLowIncomeFamily isJlsyfzl isDisabilitystuDisabilityLevelisFatherDisabilityfatherDisabilityLevelisMotherDisabilitymotherDisabilityLevelisFamilyEpidemicisStudentDiseasefamilyDiseaseDescribeisOtherDiseaseisFamilyDisasterfamilyDisasterTime isFamilyBurstfamilyBurstTimeisSupportObligationsisAloneParentssfncxs inschoolCount parentJobs parentCulture parentAgesuortMembersDescribexffamilyHouseCode familyCarName familyIncomeTypeName1xmsfzjh fatherName fatherSfzjh motherName motherSfzjhfamilyEpidemicDescribedisasterDescribe burstDescribeotherfamilyHouseName familyCarCode familyMembersfamilyYearIncomefamilyDebtAmountfamilyDebtReasonfamilyIncomeTypeCodeY TNN{|WNNS/f&T1+[^f[u /f&T1+ N3z[[^f[u /f&Tf+[^f[u /f&TzS%N͑V7bf[u/f&TS^Nw7bM|^chzaS[^f[u/f&TyrVO{QNXT /f&Td[?QN[eNb{Q /f&TyrVL]P[sY /f&TWaNgNOu;mO7b!/f&TWaNNO6eeQV[^NOONOO4NLu 0/eQWV[^f[u (/f&TNSV[[gbd`eRvOb[a+TpXP[sY0zrrrQNP[sY 0VlQzrrrf[P[sYf[u,gN/f&Tkuf[ukuI{~W/N/f&T:Nku/6rNkuI{~6rNY T 6rNQ0WE\lNSxkN/f&T:NkuNkNkuI{~kNY T kNQ0WE\lNSx[^/f&TmSu`[^mSu`c f[u,gN/f&T`͑'Yuu 6rk/f&T`͑'YuuvQN[^bXT N+Tf[u,gN /f&T`͑'Yuu N+Tku [^/f&TmS͑'Y6q~p[ [^mS͑'Y6q~p[e [^mS͑'Y6q~p[c [^/f&TmS͑'YaY [^m͑'YzSaYe [^mS͑'YzSaYc/f&T6rk Ne\Lb{QINRv?Qz/f&T6rkNeb{QvQN/f&TQQg7bM|[^(Wf[Npe6rkNN`Q6rkeS6rkt^a{QNf[90OO[9[^OO?b-f`Q[^NSpe [^NGWt^6eeQ(CQ) [^ k:Pё(CQ) k:PSV [^;N6eeQegn{|W" _{:NIlW[SNS+T ^'YNI{N1 N NǏ20*NIlW[ _kXy& kXQf[uNN{|W _kXy & kXQf[uE\lNNS v^N^ NǏ18*NW[&{ _kXy&kXQ/f&T1+[^f[u SAQkXQ/fb&T ^_kXkXQ/f&T1+ N3z[[^f[u SAQkXQ/fb&T ^_kXkXQ/f&Tf+[^f[u SAQkXQ/fb&T ^_kXkXQ/f&TzS%N͑V7bf[u SAQkXQ/fb&T ^_kX kXQ/f&TS^Nw7bM|^chzaS[^f[u SAQkXQ/fb&T ^_kXGkXQ/f&TyrVO{QNXT SAQkXQ/fb&T N/f&TyrVL]P[sY0/f&TWaNgNOu;mO7b0/f&TWaNNO6eeQV[^Ne kXQvQNy_{:Nzz0^_kXkXQ/f&Td[?QN[eNb{Q SAQkXQ/fb&T N/f&TyrVL]P[sY06rN:NkuN0kN:NkuN06rkGW`͑'Yuu N+Tku 06rkNe`͑'Yuu N+Tku 0vQN[^bXT N+Tf[u,gN `͑'Yuu N+Tku 0/f&T6rk Ne\Lb{QINRv?Qz0/f&T6rkNeb{Q06rkNN`Q06rkeS06rkt^0a{QNNe kXQvQNy_{:Nzz ^_kX\kXQ/f&TyrVL]P[sY SAQkXQ/fb&T N/f&TyrVO{QNXT0/f&TWaNgNOu;mO7b0/f&TWaNNO6eeQV[^0/f&Td[?Q0/f&T6rk Ne\Lb{QINRv?QzNe kXQvQNy_{:Nzz ^_kX>kXQ/f&TWaNgNOu;mO7b SAQkXQ/fb&T N/f&TyrVL]P[sY0/f&TWaNNO6eeQV[^Ne kXQvQNy_{:Nzz ^_kX>kXQ/f&TWaNNO6eeQV[^ SAQkXQ/fb&T N/f&TyrVL]P[sY0/f&TWaNgNOu;mO7bNe kXQvQNy_{:Nzz ^_kX8kXQ/f&TNSV[[gbd`eRvOb[a+TpXP[sY0zrrrQNP[sY 0VlQzrrrf[P[sY SAQkXQ/fb&T ^_kXkXQf[u,gN/f&Tku SAQkXQ/fb&T ^_kX@kXQf[ukuI{~ SgqNxh-NkuI{~h N(W f[u,gN/f&Tku -NkXQ &T (W,gRkXQwQSOvkuI{~ Lhg0^_kX6kXQW/N/f&T:Nku/ SAQkXQ/fb&T N/f&Td[?QN[eNb{Q Ne kXQR/f&Td[?Qy_{:Nzz ^_kX@kXQ6rNkuI{~ SgqNxh-NkuI{~h N(W 6rN/f&T:NkuN -NkXQ &T (W,gRkXQwQSOvkuI{~ Lhg0^_kX) kXQ6rNY T _{:NIlW[SNS+T ^'YNI{N1 N NǏ20*NIlW[ ^_kX ! kXQ6rNQ0WE\lNSx v^N^ NǏ18*NW[&{ ^_kXy6kXQkN/f&T:NkuN SAQkXQ/fb&T N/f&Td[?QN[eNb{Q Ne kXQR/f&Td[?Qy_{:Nzz ^_kX@kXQkNkuI{~ SgqNxh-NkuI{~h N(W kN/f&T:NkuN -NkXQ &T (W,gRkXQwQSOvkuI{~ Lhg0^_kX"kXQkNY T _{:NIlW[SNS+T ^ NǏ20*NIlW[ ^_kX kXQkNQ0WE\lNSx v^N^ NǏ18*NW[&{ ^_kXykXQ[^/f&TmSu` SAQkXQ/fb&T ^_kX3kXQ[^mSu`c N+T gyrk&{SN^ NǏ100*NW[&{ ^_kX0傡l gmSu` N_kXQdkykXQf[u,gN/f&T`͑'Yuu SAQkXQ/fb&T ^_kX>kXQ6rk/f&T`͑'Yuu SgqNxh-N6rk/f&T`͑'Yuuh N/f&Td[?QN[eNb{Q Ne kXQR/f&Td[?Qy_{:Nzz ^_kX+kXQvQN[^bXT N+Tf[u,gN /f&T`͑'Yuu N+Tku SAQkXQ/fb&T ^_kXkXQ[^/f&TmS͑'Y6q~p[ SAQkXQ/fb&T ^_kX7kXQ[^mS͑'Y6q~p[e,SgqNxh-N[^mS͑'Y6q~p[eh ^_kX0傡l gmS6q~p[ N_kXQdky9kXQ[^mS͑'Y6q~p[c N+T gyrk&{SN^ NǏ100*NW[&{ ^_kX0傡l gmS6q~p[ N_kXQdkykXQ[^/f&TmS͑'YaY SAQkXQ/fb&T ^_kX3kXQ[^m͑'YzSaYe,SgqNxh-N[^m͑'YzSaYeh ^_kX0傡l gmSaY N_kXQdky7kXQ[^mS͑'YzSaYc N+T gyrk&{SN^ NǏ100*NW[&{ ^_kX0傡l gmSaY N_kXQdkyDkXQ/f&T6rk Ne\Lb{QINRv?Qz SAQkXQ/fb&T N/f&Td[?QN[eNb{Q 0/f&T6rkNeb{QNe kXQRvQNy_{:Nzz ^_kXDkXQ/f&T6rkNeb{Q SAQkXQ/fb&T N/f&Td[?QN[eNb{Q 0/f&T6rk Ne\Lb{QINRv?QzNe kXQRvQNy_{:Nzz ^_kXCkXQvQN N+T gyrk&{SN^ NǏ100*NW[&{ MRb/f&Ty:N&T gvQN`QekXQdky MRb/f&TykXQN/fRdky N_kXQ ^_kXkXQ/f&TQQg7bM| SAQkXQ/fb&T ^_kX kXQ[^(Wf[Npe,SgqNxh-N[^(Wf[Npeh _kXy&3kXQ6rkNN`Q,SgqNxh-N6rkNN`Qh Nd[?QN[eNb{Q Ne kXQd[?Qy_{:Nzz ^_kX/kXQ6rkeS,SgqNxh-N6rkeSh Nd[?QN[eNb{Q Ne kXQd[?Qy_{:Nzz ^_kX/kXQ6rkt^,SgqNxh-N6rkt^h Nd[?QN[eNb{Q Ne kXQd[?Qy_{:Nzz ^_kX/kXQa{QN,SgqNxh-Na{QNh Nd[?QN[eNb{Q Ne kXQd[?Qy_{:Nzz ^_kXkXQf[90OO[9,SgqNxh-Nf[90OO[9h ^_kX kXQ[^OO?b,SgqNxh-N[^OO?bh _kXy&9 kXQ-f`Q,SgqNxh-N-f`Qh b ef RvQN yy 0kXQxkS)Ro` gN8RS~)R0hy0ZSi_6eeQ~FU0RSNSNNy iN0{Q iN0R]Ncbd_b,gTv6eeQ a{Q90b(vb){Q9 LN6eeQ vQN^S_eQ[^v6eeQe6eeQf[90OO[9(W9501CQ20000CQf[90OO[9(W20001CQN N 4144010577 4144013929 4144016401 4144013657 4144014759 4144014427 4144010822 4144013810 4144013656`E EF=7GG}0HHOLII[JJmPKKMMFfN "O O6 bP SXW,:Z ]R`b^d`d diMeem f!g"hi#iG$yj%%     dMbP?_*+%z&ffffff?'ffffff?(?)?" d333333?333333?& cAU} X} X}  X} X} X} X} X} X} U#X} 0X} q!X} qX} "X} q/X} X} X} X} 8X} X} X} 8X} qX} X} $X} X} "X} qX} qX} q&X} X} X} U"X} X} !!X} ""X} ##qX} $$X} %&X} ''X} ((X} ))X} **qX} ++8X} ,,UX} --UX} ..qX} //qX} 00X} 11X} 22X} 33 X} 44X} 56qX} 77X} 888"X} 99qX} :j X} kkX} llqX} mmX} nnUX} ooX} ppqX} qqX} rrX} ssUX} tX}  X>T> T>U>T>TTV>,W Y Z [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ k k [ [ k [ [ k [ k [ [ n P [ p ![ "[ #[ $[ %[ &[ '[ ([ )[ *k +[ ,[ -[ .[ /b 0s 1b 2s 3b4bbbbbbbbbb=\ @\$/ooooooooooooooo=] ^ ]!$/bbbbbbbbbbbbbbb= _"_ `# a$ a% a& a' `(  h)  `*  `+  _,  c- `. i/ l0 l1 mm l2 l3 mm m4m i5 i6 i7 c8 o9`  c: !l; #c< $_=%_ &_> '_? (_@ )oA *oB +_C ,_D -qE .qF/qqqq2 3qG4oooooooooo= bH bH bH bH bH bH bH bH bH  bH  bH  bH  bH  bH bH bH bH bH bH bH bH bH bH bH bH bH bH bH bH bH bH bH  bH !bH "bH #bH $bH %bH &bH 'bH (bH )bH *bH +bH ,bH -bH .bH /bH 0bH 1bH 2bH 3bH4bbbbbbbbbb= cI_ cJ$`aaaaj`__```___ mK _L __ _M _N_ _O___`c iP  `c! "mQ #``$ %`R&j______, -_S ._T /oU 0iV 1oW 2iX 3iY4oooooooooo= i_"j_ k`# la$ ma% na& oa' p`( qh) r`* s`+ t_, uc- v`. wi/ xl0 yl1 zmm{ |l2 }l3 ~mm m4m i5 i6 i7 c8 o9` c: l; c< _=_ _> _? _@ oA oB _C _D qE qFqqqq qG dZ d[ d\ e] e^ e_ e` ea eb  ec  ed  ee  ef  eg eh ei ej ek el em en eo ep eq er es et eu ev ew ex ey  ez !e{ "e| #e} $e~ %e &e 'e (e )e *e +e ,e -e .e /e 0e 1e 2e 3e4tttttttttt=`tWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW f f f f g g g g g  g  g  g  g  g g g g g f f g g f f g g g g g g g g  g !g "g #g $g %g &g 'g (g )g *g +g ,g -g .g /r 0u 1u 2u 3u4oooooooooo=DNZ(  L  3  ]FC! dH  P 9CCButton 19],@A9 $< _Yhg< i V 9CCButton 13801>],5@A9 $<_ Y h g<)> @<d   C3 # ''''  /f&T    &&#$ PE\lNQ[XuQeLr^yO/nyr:Sbgq/Nfoyr:Sbgq/NfS~nE\leg_'YFLXY8lENE\OObgq7bSvQN; #e ?6rkGW`͑'Yuu N+Tku 6rkNe`͑'Yuu N+Tku + #+ #44+ #!!+ #((+ #))+ # +++ #**3 #,,55C  [^OO?b g[^OO?byA--+ # 88+ # 99ggDSheet1    q~Lz  dMbP?_*+%8&ffffff?'ffffff?(?)?" dXX333333?333333?& U} K} K} FK} !K}  L}  L}  L} L}  L}  L}  Lq@888888 @8 8 8 8 8 8888888888888888888 M N N M  O KK? P Q L PP P P L PP? P P PP@ P P PP@ P P PP"@ P PPPPPPPPP P P? P P[ P P@ P P[ P P@ P P[ P P@ P P[ P P@ P P[ PP@ P P[ PP@ P P[ PP @ P P[ PP"@ P P[ P P P P[ P P P P[ P P P P[PPPPPPPPPPPP P P? P P P P@ P P P P@ P P P P@ P PPPPP PP? P P PP@ P PPPPPD lVJJ<<<<<<<<<<<<<888<<<<<< 8!8"8#8$8%8&8'8(8)8*8+8@,8-8.8/80818283@@4@@586J7J8J9J:J;J<J=J>J?J P P? P Px !P!P@ !P !Px"PPPP #P#P? #P #P $P$P@ $P $P%PPPP &P&P? &P &P 'P'P@ 'P 'P(PPPP )P)P? )P )P *P*P@ *P *P +P+P@ +P +P,PPPP -P-P? -P -P .P.P@ .P .P/PPPP 0P0P? 0P 0P 1P1P@ 1P 1P2PPPP 3P3P? 3P 3P 4P4P@ 4P 4P5PPPP 6P6P? 6P 6P 7P7P@ 7P 7P8KKRS 9P 9P9P 9P :P :P:P? :P ;P ;P;P@ ;P <P <P<P@ <P=PPPP >P >P>P? >P ?P ?P?P@ ?PDl<<<<<<<<<<<<<<<<<<<<<<@JAJB4JCJDJEJFJG8H8I8J8K8L8M8N8O8P8Q8R8S8T8U8V8W8X8Y8Z8[8\8]8^8_8 @P @P@P@ @P AP APAP@ AP BP BPBP@ BP CP CP CP@ CP DP DP DP@ DP EP EP EP @ EP FP FP FP FPGPPPP HPHP? HP  HP IPIP@ IP IPJPPPP KPS LPS MPS NPS ORS PRS QPS RPS SPS TPS UPS VPS WRS XRS YPS ZPS [PS \PS ]PS ^PS _RSDl<<<<<<<<<`8a8b8c8d8e8f8g8h8i8j8k8l8m8n8o8p8 `RS aPS bPS cPS dPS ePS fPS gRS hRS iPS jPS kPS lPS mPS nPS oRS pRS&B@>(<d!!! ggDSheet5     dMbP?_*+% &ffffff?'ffffff?(?)?" d333333?333333?& U><d8 ggDSheet6   !"#$%&'()*+,-.013456789:;<=>?@ABCDEFGHIJKLMNOPQRSUVWXYZ[\]^_`abcdefghijklmnoqrtuwyz{|} Oh+'0HPXl boboaname@=i@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)p40\# |\L8(xXlhH8(@< H,ptP0hH0   frU $`$`nrU~|  0  krU $ `nrU 49a 0  XrU @4 `dAY!#nrU @ 9Aa PIq!/4q ` x"l "   " "\ ''' :\lL:<, :::|l\L:<,^z6$lL, l\L, u  $\ TlL, l\L, 4XrU @,`8Y#nL+nxME(SPSSS0{1A9ADC7B-D054-4E58-819D-F1B9A2FDB842}{154F29EF-2269-4340-B7D3-51C15CE9E997} @@ D% %@@`c " 0 8"HP Xh xȡ------' B@B------oHȷ------@ F' B@B-----oRAttribute VB_Name = "ShowForm"  Bas|0{1A9ADC7B-D054-4E58-819D-F1B9A2FDB842}{154F29EF-2269-4340-B7D3-51C15CE9E997} dGlobaBlSpacoFalse Cre atablPr@edeclaI"dTru BEx0pose0TemplateDerivCustomizD'ȡ` P Sub CancelButton_Click() notContinueBoolT Me.HidZEnd! 'ȷĶ ,onfՏ,9-Fl;/HLOʘxME(SPSSS0{CC15DC87-22F0-47AE-B4F8-DC07F86A1206}{CDE8F261-4F87-4D47-A2C0-3C0E767F6734}p0(%X0 %0``cxAttribute VB_Name = "PrintForm" " Bas0{CC15DC87-22F0-47AE-B4F8-DC07F86A1206}{CDE8F261-47-4D47-A2C0-3C0E767F6734} dGlobal!SpacoFalse CreatablPre declaIdTru BExpose0TemplateDerivCustomizDt6DD zL#<9wJ JZFDTWCF 8xDTWCF 89wJ JZME(SLSS6"  <,<0<4<8<<<N0{00020819-0000-0000-C000-000000000046}` $`k@8 i& `73i( 1% %  %`@.0,*24@l @\ @0L @x< @H, @` @ @ @ @ @ @8 @ @  @P @| @hl @\ @L @< @, @ @ @( @@ @ @ @<8`c$*\Rffff*2L651852b1*\R0*#f*\R0*#1*\R0*#17$*\Rffff*2D651850a3*\R0*#2$*\Rffff*2F651850a34 "      )ǷȷϽҪexcel籣棬"$.ȷ"$., $.&ϵͳҪмУ飬粻棬"$.ȡ"$.? 0$,'* * 2A@4dP'(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 a (*\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7\VBE7.DLL#Visual Basic For Applications:*\G{45541000-5750-5300-4B49-4E47534F4655}#3.0#0#D:\oN\WPS Office\WPS Office\11.1.0.12313\office6\etapi.dll#Upgrade WPS Spreadsheets 3.0 Object Library (Beta)*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation"*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#63.1#0#D:\oN\WPS Office\WPS Office\11.1.0.12313\office6\ksoapi.dll#Microsoft Office 16.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\SysWow64\FM20.DLL#Microsoft Forms 2.0 Object Library *\G{D4F6FAD4-FDC0-40C5-A5E3-7CB1B39F3A90}#2.0#0#C:\Users\huawei\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M  `c  ThisWorkbook2L651852b1!ThisWorkbookzLxJ Sheet12K651852a67 Sheet1H Sheet62:651850a2C Sheet60-SbpSȉ2G651850a3DSbpSȉH]wQQpe2C651850a3N]wQQpe`gXf2D651850a3~Xf&xz!hQpe2E651850a3!hQpe~h;N z^2F651850a3;N z^Ux`L.ShowForm2@651850a2?ShowFormn1 Sheet52A651850a2I Sheet5hEPrintForm2B651850a2KPrintFormʘHx`0pZF̃u55̧/ALDegpiI"{ڴStkIpAuvnN?)ھ'Oٮ(?DNp)LR_-׊530T!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` (removeEnter` (checkStuNamec`(checkLeng`value1`functionArgsArr`Split)` (checkSpLen`(checkNumh`(checkValK`(checkInt`resZjlx0` (IsIDNumber-*` (checkSFZJLX*`(checkDMB` (setDMBCoded`(checkS)` (checkBankUw`(checkXn` (checkMonth` (checkBirthday`(checkBirthdayNecessary` (checkPhoneNum` (checkOption,`(sysDifficultyGradeNameFlag`Trim@`(indentifyDateFlag `(checkFamilyIncomeTypel` (checkSqly`aX` (hasErrorIdNum`resultur`result1`result2`result3`result4`result5`result6`result7`result8`result9`result10P`result11P`(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`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 `ne`LCase:`md` (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`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`BeforeDoubleClickaaaaaaaaaaaa\` BeforeSave` _B_var_Chr\;`_Defaultj`_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`!? I K 7CE O"@ p0(P'q`XX H  rU~| prU ,`a//(`00` a///(`08!`a////0I` a///<q`a9/////<`Yaq/////,`//( `/0 ` 09 `  !///,a `9//8 `a      !"#$%&'(*+,-./012345678:;<=>?@ABCDEFGHJKLMNOPQRSTUVWXYZ[\]^_`abcdeghijklmnopqrstuvwyz{|}~////,`9//8`a////8`a////0)` a///nrU~|  1a0  0   0   0   0   0   0 X  0 8  0   0   0 $  0   0   <:4%DX%h$ h dD)hDJ$%DX%h$ h dDC)hD5:x(\lhD0   <:4%DX%h$ h dD)hDJ$%DX%h$ h dDC)hD5px(\lhD0   0         rU~~~y     rowIndex columnIndexcontent sheetIndexcolIndex errorInfo checkMethoderrorMsgtypeValisValidateCountregvalue sheetIndex2keyWordkbnvalue1flagrowNumIDNumberafunctionArgsArrvalue2 functionArgsIdNum !9 !TargetCancel !(SaveAsUI '#xME (SLSS<N0{00020K*rU~~~~~~~~#~~~~~~~~~~$ օDC  a  a  )a a qAa a a 9 q ) Y y  9 aa 1 a a ! 1 i 9Yy1Qq 1Qya a I  !! VBAProject ThisWorkbookSheet1Sheet6ӡԤߺУ麯ShowFormSheet5 PrintFormFFC:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7\VBE7.DLLVBA ) Q0TEPWSKINGSOFU<D:\\WPS Office\WPS Office\11.1.0.12313\office6\etapi.dllExcel Qy @0FC:\Windows\SysWOW64\stdole2.tlbstdole yPL-[DR=D:\\WPS Office\WPS Office\11.1.0.12313\office6\ksoapi.dllOffice Yc `.E .`M C:\WINDOWS\SysWow64\FM20.DLLMSForms yyp@|: 2C:\Users\huawei\AppData\Local\Temp\VBE\MSForms.exd ; YycheckedRequiredStartwriteLoggetCellValueCountXQ writeLogRedaddCommentXQStartclearCommentsXQStartbeginCheck_commentcallFunctionXQStart regCheckFunccheckTheSameXQNewGetRowOrColIndexcheckDMB deleteRowsetCellValueCountXQdeleteRowNoProsetCellValueXQ setDMBCode removeSpaceXQ  Oo` Nxh f checkIsInt , 00 $4DHLPd checkRequired checkStuName removeEnter checkBirthdaycheckBirthdayNecessary IsIDNumber checkSqly checkSFZJLX checkSchCode checkFamType checkRXDate checkYear checkMonthcheckXJH checkPhoneNum checkBankcheckXn checkOptioncompare compareDeccheckLencheckFamilyIncomeTypecheckIntcheckValcheckNum checkIsNumber checkMoney checkMoneyTJcheckPersonNumcheckIdNumLink checkSpLencheckSУ򲢴ӡϢ checkTheSame Browse_PrintFb`2AET簢 F;Bpb$DF Worksheet 'Worksheet_BeforeDoubleClickaaaaaaaaaaaaFF @F9wJ JZFDTWCF 8DFWorkbookWorkbook_BeforeSave .`/f&Tnx\OX[excel YOX[ pQ nx[ , &|~\ۏLhg!h Y NOX[ pQ Sm ?VBE7.DLL y` p yS FFyF 0]\Ohpev Ncknx N}ge!jgT QۏLdk!h 1qazPassword :ProtectUnprotect CellsClearContentsF A65530 RangeEndRow IV5 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 ۏLOcky  y q820-0000-0000-C000-000000000046}@(%H@0`cxAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2?h#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0`c xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 8/=H#<b`2AET簢 F;Bpb$x;Bpb$b`2AET簢ME PSLSS0<6"<<<N0{00020820-0000-0000-C000-000000000046}( 8` @d ):`hnp %i( x%%6%@hd`c*\R1*#119$*\Rffff*2K651852a64  "  &  HX`p xڵԪʱ Continue? >Hi$, @1A@,77k 123A@48oxAttribute 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@48Ch!~xME(6 << < ` @ Ih `IR 1IT `V 0`  Il @  ` p  Ih IR Ij  H`  'Il @  `   6Il @  +`  Ci ij`H`JH``8` P`  ,,\Il I @  `   Il @  @`   Il @   `  Il @  0 `  Il @   ` p Il I @  @ `  Il @   `  Il @  0`   Il @  ` p  Il @  8 `  Il @  @  ` x  I  I  D8 `  I  I   ` x  %I  I  P ` /Il  I @   ` MIl  I @  h ` ( bIl H I   ` }Il  I  h ` ( &&Il H I   `  Il @  @`   Il  `   Il @  0`   Il @  ` p  Il @  `  ""I IR (Ij ` ` `z````@ ` @ ` @ ` @ 0`  ""Il I @   ` p 2Il @  0 P @@8 0P08 0 h h 0@H%X !!0p2`c$*\Rffff*2E651850a3;  B       (  B  " 08@HP XB  px    B     8HPX`h pB   n P hB  ,$"H( p x "   "0 X ` 4p  8 X B  p x        @ X h  p               ( 0 8  H  P X ` h            B  *(08@H P  B  08@`px   8B  PX6` | P pB  0 x x B    0@HPX` xh  B   (HX`hpx |   B  8@$Hp | ( HB  `hfp |  B    (  B  :HXp    h B         .B      ( 0 .B   (8@HPX `B   & HPX`h:p   D40 h  p x        B  p!x!! !&!!!!!!:!8" H"P" X" `"h"p" x"B  ## # (#&8#`#h#p#x# # #(# ##D#4($`$ h$p$x$$$$$$$ $B  h%p%% %%%% %% "%& & <&X&`& h&p& x&B  ('0'H' P'&`''''' ' '"' '( $( "0( X( h( p( x(((((( (>( 8)4X) ) )) )) ) @* `*B  x********* * h+ +B  ++ + +++ + h, ,B  ,, ,,,,,,- - - -B  ---... .(.0. 8. . .B  ///8/H/P/X/`/h/ p/  0 @0B  X0 &`0 $0 0 0&0*1"81$`11(111202@2H2 `2 2x22"223   383P38h333 3B  84@4X4&`44 4&44444D4405h5x5555 5555556666 6(606 86 6 6B  677(787@7H7P7X7h7-----------------------------------------1 ,дϢʾ Ϣsheet--------------------------------------- ʱ0 Ϊʱ1 Ԫ] R T h$H%Z'V V'd'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseʽȷtrue]^[\u4e00-\ue863]{1,20}$'   l$'d'kiȥǴӡַ0 R j$Z'  $.   MsgBox addr  !%' MsgBox addr  R j+Zki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)--------------------------------------- l$'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]))))$'   l$'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]))))$'   l$'dx'khi`h-----------------------------------------4 У֤---------------------------------------Ϲ򷵻trueϹ򷵻false]79058421637905842@0Ȩ] 10X98765432X0У $$''ȥո]p j  6)׶֤Ϊ,ΪͨУ'zk Gzj $$Gzj *[0-9X]Gzj 8  8$' G 'j   8$  '   ' $ J  $G'ji-----------------------------------------2 У ҪΪĸ-------------------------------------------------------------ʽȷfalseʽȷtrue l$'zk]8 reg = "^(([1-8])|([1-8][,]{1}[1-8])|([1-8][,]{1}[1-8][,]{1}[1-8])|([1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8])|([1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8])|([1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8]) |([1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8]) |([1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8][,]{1}[1-8])) $"^[1-8,]{1,15}$'   l$' l' 8  l$ 8$' 8  ,'zk 8  ,'zXkPdH ,'z(k k > 8  l$ >$'   ,''zk > 8dx'khi`z-----------------------------------------У֤ -------------------------------------------------------------ʽȷfalseʽȷtrueP]"^[\u4e00-\ue863a-z|A-Z|0-9]{1,18}$'   l$'dH'k8i0----------------------------------------5 -УѧУѧУʶ 42λһλΪֻx-------------------------------------------------------------ʽȷfalseʽȷtrue](^[1-9]\d{40}[\dx]$'   l$'d'kpihz----------------------------------------6 -У黧 -------------------------------------------------------------ʽȷfalseʽȷtrue@].^(\u519c\u6751)|(\u53bf\u9547)|(\u57ce\u5e02)$'   l$'dH'k8i0u-----------------------------------------7 Уѧʱ-------------------------------------------------------------ʽȷfalseʽȷtrue]'^(((19)|(20))\d{2})((0[0-9])|(1[0-2]))$'   l$'d'kiq-----------------------------------------7 У-------------------------------------------------------------ʽȷfalseʽȷtrue0 l ,ΪDZ'k z k ]^((19\d{2})|(2\d{3}))$'   l$'d 'k i q-----------------------------------------7 У·-------------------------------------------------------------ʽȷfalseʽȷtrue](^((0[0-9])|(1[0-2]))$'   l$'d 'k i v-----------------------------------------9 Уѧ-------------------------------------------------------------ʽȷfalseʽȷtrue@]^\d{4}[0-7]\d{3}[0-3]\d{7}$'   l$'dp 'k` iX v-----------------------------------------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'   l$'d 'kiv-----------------------------------------11 Уп-------------------------------------------------------------ʽȷfalseʽȷtrue0]^[1-9]\d{14,20}$'   l$'d'ki-----------------------------------------checkXn Уѧ磨2012-2013-------------------------------------------------------------ʽȷfalseʽȷtrue] ] 1^(20\d{2}-20\d{2})|(19\d{2}-19\d{2})|(1999-2000)$'   l$ l-$'$$ 'd`'kPdH'k8i0-----------------------------------------checkOption У鱸ע磨Сvalue2-------------------------------------------------------------ȲС200false 򷵻true8 'z8k0   'd'ki------------------------------------------------------ȽϴС(Сڵڷtrue)----------------------------------------------------------------'value1value2false 򷵻true X' X'   'Dd'Dki------------------------------------------------------ȽϴС(Сڵڷtrue)-dec---------------------------------------------------------------'value1value2false 򷵻true8 $4' $4'   'd'ki}------------------------------------------------------У鳤--------------------------------------------------------------- ,$'' l$/ΪDZ'kzk]8 1^[\u4e00-\ue863a-z|A-Z|0-9(),.]{1,200}$'   l$'d0'z k ,-±0ʼֵΪָάõ± l$$4 l$$4'zkd ˵У̶ l$$4'z0k(k i}------------------------------------------------------У鳤---------------------------------------------------------------P ,$'' l$/ΪDZ'k z k ] 1^[\u4e00-\ue863a-z|A-Z|0-9(),.]{1,200}$'   l$'d'zki}------------------------------------------------------У--------------------------------------------------------------- ,$'' l$/ΪDZ'kzk l$& ΪzX l.e+Сz(k  ,-±0ʼֵΪָάõ± l$$4 l$$4'zkd ˵У̶ l$$4'z8k0k(i ------------------------------------------------------УֵΧ---------------------------------------------------------------h ,$'' l'zPkH l$) Ϊz  l$4e) С0zk l$4$$4 l$4$$4'zki------------------------------------------------------Уֳ(Number,ΪҲΪСС0)--------------------------------------------------------------- ,$'' l$/ΪDZ'khz`kX l$% Ϊz0 l$4e% С0zk$'+󳤶$'.Сλ l.''' "˵ûС l$4' $$4'z(k d С l l. $'DԪֵλ l l. $' $$4 $$4'z`kXkPiH-----------------------------------------checkIsInt У鲻С0-------------------------------------------------------------ʽȷfalseʽȷtrueh ] ^0|[1-9]\d*$'   l$'d@'k0i(-----------------------------------------checkIsNumber УΪNumber-------------------------------------------------------------ʽȷfalseʽȷtrue ' l$'k0i(-----------------------------------------checkMoney У0-9999-------------------------------------------------------------ʽȷfalseʽȷtrue@]^(([1-9](\d{0,3})|0)|0)$'   l$'d'ki-----------------------------------------checkMoneyTJ У0-9999Сһλ-------------------------------------------------------------ʽȷfalseʽȷtrue]^([1-9]\d{0,7})$'   l$'d'ki-----------------------------------------checkPersonNum У׶԰һ------------------------------------------------------------ʽȷfalseʽȷtrue0]^(([1-9]\d{0,3}))$'   l$'d'ki-----------------------------------------checkIdNumLink У֤ԱͳûдǷһ------------------------------------------------------------ʽȷfalseʽȷtrue If colIndex = jhrIDColumn Then checkIdNumLink = True Exit Function End If]H%Ա֤ǷӦ]`$ں֤ǷӦ]xڵһγֵ±]"Ա,Ԫ֮ڵ]$ݺŽȡ]!,Ԫ֮ڵ]"ݺŽȡ]#] 8%·]Ph] $' $'  (ڶλΪΪ R  $`,ZdڶλΪżΪŮŮ R  $`,Zk $' $' $' -  -  R  $`,Z'iP}------------------------------------------------------У鳤--------------------------------------------------------------- ,$']^[\u4e00-\ue863]{1,66}$' ' l$/ΪDZ'k( z k ,-±0ʼֵΪָάõ± l$$4 l$$4  l$'dx 'kh z` kX d ˵У̶ l$$4  l$'d 'k z k k i -----------------------------------------У鿼šѧšѧ -------------------------------------------------------------ʽȷfalseʽȷtrue0]^[a-z|A-Z|0-9]{1,40}$'   l$'d 'k i WAttribute 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 /~4/`<ĸ?BQSql@jPS@SO%+x- h'6((0fr[,@}/#](1- X ?<9 |S OO{1 [,]{1}[1-8 ]) |([,?P)) $"  reg = "^,15"}6If CheckFunc( , value) ThenAEBc#SqlyKT(rues Le n(2For i1 To snMid(LCase-, i0, 1)Di Mod 20= n <> "," J KFalsKX ExiDt ktioeEnd If;<= s A SP3E Lg3A9I3AajRi + IbX m@bjb uG ABmD^]a@1W`I) N`ext j i?Lyy'-%У֤T& 'ʽfäBtdFZJLXhDims!s+x\u4e00-\ue863a-z|A-Z|0-9`,18{{ G{0(m_0-*5A.c-1ѧ`ʶ 42λһλֻxZ 46r4chC\odŗ2411\d{40}[\dx] 22 '#6H2 8..FamTyp.^(\u519c\u6751)|3bf\u95D477ce`e02)?222d=2?2/7 2ѧʱ_oJ/0ckRXDatIkJ(((19@20))02})((0[aJ@12])OO~Rg3?Žq+[/ b --$0Year3b, fqArgsArrw"ߒS=3 'ΪDZScWpcYUa9Up@"^$$|(23}#OO"k:E_9"%RѐkO?XJNH,4}P7]"-37oQQck@ #O?10i绰OPhoneNum? <\bD(([38h4[57]5p55pk8} 00p2@j(-[2b*[3{2}g)\b2ao  checkPhoneNum = True qEls$4 Fa2@oFe}G04Ƚ С(76) ;@7eMa uCompareBBhCIn{1F2EJ'J9c 87:52+X5dec/52؝c,g= Cue1 r@??!oo-W!Rϯ >ӎI, f$ArgsiArrppy@q,IqGO3wX" 0@(u0"S 'ΪDZ X$ pK55v]J\u4e00-\ue863a-z|A-Z|0-9(),.]{1!Pߣb!1*b UBound(!l '±0ʼֵΪָάõtF)8) >$=<Ж) VA <s#2))=h?#< ^}# '@˵!=̶a=P(1o  D#qF0aG/O-OFamilyIn[eTypTO'EOO}\rmP0/PPbr3 End If xit Functionx Dim reg@ = "^[\u4e00-\ue863a-z|A-Z|0-9(),.]{1,200}$" BIfRChec k(R, value) The c'amilyIncomeTypeTrue1SEls Fa=ET  '-2У` F Int(, fArgs)GGArr@O@Split(, ","  Lo@""PlA_Q (0) 0 'ΪDZG*H {  Not IsNumericCQ(Ϊ< (Ջ=InStrd".") <> =СLUBoundouW2+±0ʼֵΪ@ָĠάõ( Lene">= CDecm(1)) A HW@ "rb=С0,/ $,?@gspG]3@]`B/2Uy_ u0/?*Ss/qA(0bber,2Q|Ҳ\)O1P1}0! /}11}0]}}i?6Ir7bN10 7}U %6 PnI}6c maxPf3 '&p{_jD`ouble92) 'λ"{Aintgth΋QuEdouEwûГ k pEE`P (%QHrrH%u*_#_&(o hMDid@1, - 1ԪHС#ξ_!h+pC rbL(_?q0Uqg\ Is> edcC_@ʅȷfalse 'ʽtruHFunction checkIsInt(value)  Dim reg = "^0|[1-9]\d*$"2IfJC(R, G Then%PgJTE  $FEnd pIf -%+Number УΪ&#g@ T= Iseric KZPckMoney BP0-9Qp$P R((B(\d{0,3})|0tA= Z VTJ`Сһ?18Yq1C1"17})0)1 0ey%*i;(0Personl#1׶԰໸˻001beb_1eR1'!1 b'$1IBd@1Link1֤ԱͳûǷ 744(", rowIndex, col"$'jhrIDColumnlc'a1LvExit s'u 52 B QUisGe rRight As BooleanL 'CEϡӦBirth/+length2)eg|'qһγ@±[g b VፑStringS ,Ԫ֮ڵĐݟer1J Žom bqe?"a" year, QBVariantD '1l month, bday, @arr"1*MidU.17h, 1- 7Y= (8АZMod 211 ,qڶΪΪ@GSheets(sa7).Ceplls(9#7)"ЄE żŮ7A*1Ů w! , 4"!, 5, 2x _, Y 2O" 0 + "-" +*ppw NKgM'\³ȟ SpLDeny, fArgsiArrSplit(y, ","8C"^[\u4e00-\ue863]{1,66}嗑# Pz6{b"Lg4l ( 0Q2039'ΪDZg q:)il UBound0 2 1d0ʼֵ@Ϊָ@άfqpf) >= CDec=(1)X) A;<s (2;4kFunc(reg, value) Then  checkSpLen = TruebEls: OFa2End If Exit tio JV '˵У̶ 6If (= CD0ec(f9ArgsArr(1)#Cd?d?DvcDzir'-%p@ѧ%& 'ʽfìBt- TĊDim }"^[a-z|A-Z|0-9]{1,40}$" gma-xME(6 << <x F` Dp%H@`c$*\Rffff*2G651850a3"   ( HhxѧϢӡģ$H(JѧϢӡģ$HB@LѧϢӡģ$H(JoAttribute VB_Name = "Ԥ" Sub Browse_Print () Worksheets("ѧϢlģ").VisiblaTrue"d^P@review2cEnd 4gxME(6 LL P` @ IR `amIT 1`V \` i^ f` 8 Ih XIR xIj  n`   i^ x` 8 !Ih XIR xIT Iz  X`   (Ih IR 8IT  8`  3Ih I IR IT I  ` x ..HI Ih IR IT I  ` X vI  xIl `" , `  I. +D ` P Ih pIF iH`J  `  Il (I HIZ @\ d `  Ih I`  n ` k@ Ih0  `IR Ij Il@  p@ ` Ih  I`  r `@k Ih  IR  Ij  Il    ` @ Il ` Ih  IR  Ij @\ @t @V ` H Ih h IR  Ij ``x`z@  X8 N %` ( 0 h H @nl X 0 H@ h @ X @ H @D @ 4 @$ @ @ 0H@rl H@xh @`X @H @D @4 @$ @ @  `       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ `c$*\Rffff*2C651850a3*\R1*#3cb*\R1*#30d*\R1*#268  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* X P`hpj&  HXhp ` **8h4J  ,HP <XJ  4(0  <8Jx  (   ,H8  .    H(0 H( H(| Hp( X  &`  ` (@X ` Hx( HX( HX( H0 (x  (! &0! X!h!p!! n! ""0" 8" 8P"(" H@#(# 8$(@$ $ &$ %%%8% b@% % %%%%&&& & ,&''(' f0' ' ''' ' 8((8( 6(() ) &) ))* * f(* *(* * T* &8+ `+p+x+ $+ &+$X+$&8,$ `,$p, ,, , ,$t,$& -$ H- X- $`-h- p-- ^- -".8.@@.&. .. .../ b/ x/// z/ &00 X0 h0x000 f0 1 101 t81 &1 1 112 2 b(2 2 2222&h3 3 ,3333 ^4`4 x44@4&4 55 5@5H5h5 ^p5 5 566X6&p6 6 ,6667 ^7 h7 777T7&8 88 ,H8x888 n8 9 89P9"`99&: @: ,P:::: j:  ; @;`;"p;;&(< P<`<h<< n< =  =@="P=x=&> 0>@>P>X>x> P>>>>?&? ? .??@ @ R(@@@@X@&A 8A ,HAxAAA bA B$(BPB@XB&BB BB$B,C8C@CHCPCXC`CC jC CD"(DPD&D EE EH(E pELxE EE E &F F F FFFFF ZG `GpGG@G&G HHH8H@H`H jhH "HII(I d0I &I IIbI h@J ,J J &pK K KK K &xL L LLLLL ^L PM&hMM@M&M NN&N@NHNhN ZpN N&NO@O&XO OO&OOOO ZO PPpP P@P&P PQ LQ`QhQQ   jQ R R0R8R@RXR `R hRFxRR@RS&S 8SHS~PS<STT T@T |HT T$TU(U@8U&xU UUU"UUUV | V V"VV@V&(W PW`W hWWWW   |W 8X"PXxXXXXXYY  Y (Y8Y @Y HYXY `YhY pYxY& Z HZXZ `ZZZZ   |Z 0[ "H[ 2p[ [ [[\(\H\h\\\\\] (]8]H] P] X]h] p] x]] ] ]] ] ]] ] ]] ] ]^ ^ ^(^ 0^ 8^H^ P^X^h^ p^ x^^ ^^ ^n^&` @`P` X`x```   |` (a"@a  haa aaab b @b Pb`b hb pbb b bb b bb b bb b b bc&c dd d8d@d`d |hd d"e (e He Xexe e  e e e e e e e ee&f ff fffg   | g g"g  g  h h    @h  Ph `h hh ph h h h   hh&0i Xihi piiii   |i @j*`j j ,j .jkk k ,(k .Xkkk .kkk k ,k .l@lHl .Plll l  l ,ll&Xm m,mm&Hn pn,nn&8o `opo@xo&o oo o(p(p0pPp   |Xpp"p q  8q    Xq  hq xq q  q qjq&r 0r@r Hrhrprr   |r s"0sXs  xs    s  s s s  s sjs&Ht ptt tttt   |t Xu0xu <uJu 8v@vHv Pv`Xv&v vv.v(w0wPw |Xw w,w :(xJhx xxx x@x&y @yPy*Xyyyy  |y 8z"Pz xz  zz   z  zz { {{  {  ({  0{8{&{ || |@|H|h|  |p| |"} 0}  P}p} }  }} } }} }  }}}&~ ~~ ~~   |( *@&@ hx(Ѐ |؀ X(p    ؁  4 ( 60h p <x  Ȃ Ђ~؂&X &ȃ  | p*      &8 @ (Hp x  z& 8H(Px | (&@ h      ؇  "   (z0& ؈$ @  |H "ȉ2 (  H h  2x  2   z& Ћ0؋0 |8  Ȍ@&0 Xhp  | @,`@&؎ *HPp  |x (08 (08 @ H@P& ȑ(Б |( @&( P` h   |8 Pp@x&   @   |Hȕ @&H p Ж   |ؖX p@&ؗ  8@`   |h  @(&h  șЙ   |x @& 0 8X`   | @@H&  Ȝ  |  Н@؝& @P Xx | ($@h@p& ؟$ @ dH  Ƞ@&( P`2h V   0N8& Ȣ Z x(@ȣ& 0@(Hpx Z & H@P& ȥ&Х Z( "0@&( P`0h Zȧ (&@h@p& ب& @ ZH (ȩ@&8 `p(xȪ ZЪ 0$Hp@x& $ (H ZP "0ج  ( H(X  * ȭ Э ح& Ю0خ0 Z8  $0@&8 `p0xа Vذ 0@`@h& б0 Z8 .@&0 Xh.pȳ Vг (*Hx@& *08X Z` *@&X *ȶж Z X(x@&  ((PXx x 6.P( 2( 1ȹ( ع2( 1 J8 fB  ( 0<8x $л$ ( 0 \ؼ B  8,X 0@" ^ 6о00H`ȿпؿ "  .B   $ BH          B  "  8@ HPX `82  0@ HP Xh F  *( 0  B  *( 4X B (<0 JPp x  0B  H*P B <  J@` hB     "8 `82 ( 8@ H P`"0 ( (0(@h&p  B  PXVx 8 ( H:X4$"8@H X-----------------------------------------УУдϢʾ ע----------------------------------------------------------- Ԫ] R T X%Z'V V'Pd('Pki--------------------------------------------д־ ¼ϢʾһϢ-------------------------------------------- ^ d b$`,Z d 'diX------------------------------------------------------ ȡָcellֵ------------------------------------------------------------- R j h$H%Z!l'fi--------------------------------------------д־ ¼ϢúɫʾϢ-------------------------------------------- ^'p ^ d b$`,Z p d b$`%Z%r!t(v d 'dii--------------------------------------------עʼУ飩-------------------------------------errorInfoע 1Worksheets(sheetIndex).Unprotect Password:="1qaz" z R T h$H%ZB@| R T h$H%Z!~(W ӻɫ R T h$H%Z!(Jii--------------------------------------------ɾעʼУ飩-------------------------------------1Worksheets(sheetIndex).Unprotect Password:="1qaz" R T h$H%ZB@ R  T  R T h$H%Z!~(vd  R T h$H%Z!~(vkpihr---------------------------------------------ʼУ Ƿӻɾעõķ----------------------------X  Уʧ R T h$H%Z!d жעΪ h R T A@xV עd"Ϊգȥǰע h R TA@N ע h R T A@xk1 MsgBox "" & rowIndex & "" & errorMsgd :УɹжǷעУʧʱעȥ h R TA@ ,#ȥո,ʾ RУ TУַ"$. "$."а˿ոϵͳԶΪA@\d`kXkPiH----------------------------------------------------------------------------------------------------------------------------------y--------------------------------------------ݱʶöӦķ(ʼУ)-----------------------------------------------------------------------------------------------------------------------------------------------------------------------ѴϢдб8 R T h$H%Z'l  T h$H%Z'Iȡбͷ Ϊϲеıͷ  T h$H%Z' R e  T h$H%Z'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 h R T$'  R е Ϊգ'')УʱдϢ A@\RMsgBox "" & rgold.Row & "е" & Chr(10) & titleMsg & "Ϊգ"k0 h  R T A@'a=================================2 ִѧУ========================================== checkNameKT h R TA@@ȥոķ h R TA@>ȥسķ R T h$H%Z!l'l T h$H%Z!l T h$H%Z!lĸ l'd l$'kxdp l$'kX  R е ;дȷΪ֣ȴ1ܳ20ַ''%УʱдϢ A@\  'k h  R T A@'Z================================= ִеijУ==========================================checkLenKT h R TA@Hȥոķ h R TA@Fȥسķ l $'' T h$H%Z!lͥ R h$H%Z!l R T h$H%Z!l'$ͥδ鲻д'k k  T h$H%Z!lͥشȻֺ R h$H%Z!l R T h$H%Z!l',ͥδȻֺдȻֺ'k k  T h$H%Z!lͥشͻ R! h$H%Z!l R T h$H%Z!l' ͥδⲻд'k k  T h$H%Z!lǷծԭ R2 h$H%Z!l R T h$H%Z!l'&ͥǷծΪʱǷծԭд'k@ k8  ,$'$ ` ΪDZΪ̶ȶ R е .дȷΪաд򳤶ȱΪ$λ '$ ed ΪDZΪȷΧ R е 4дȷΪաд򳤶ȱڵ$ λҲ$λ '$ ed ΪDZΪ̶ȶ R е &дȷΪգҳȱΪ$λ '$ ed ΪDZΪȷΧ R е ,дȷΪգҳȱڵ$ λҲ$λ 'k'0УʱдϢ A@\k` h  R T A@'Z================================= ִеijУ========================================== checkSpLenKT l $'  ,$'$ ` ΪDZΪ̶ȶ R е .дȷΪաд򳤶ȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ R е 4дȷΪաд򳤶ȱڵ$ λҲ$&λֻΪַ֣'$ ed ΪDZΪ̶ȶ R е &дȷΪգҳȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ R е ,дȷΪգҳȱڵ$ λҲ$&λֻΪַ֣'k'0УʱдϢ A@\k h  R T A@'h================================= ִеijУ飨Numberͣ==========================================checkNumKT l $'  ,$'$@ ΪDZΪ̶ȶ R е GдȷΪգдΪ֣0λȲ$λСλ$ λ'$ ed ΪDZΪ̶ȶ R е ?дȷΪգұΪ֣0λȲ$λСλ$ λ'd! R е ]дȷΪգұΪ֣0λȲ6λСλ2λ'k(!'0УʱдϢ A@\k h  R T A@'[=================================ִֵΧУ==========================================ѴϢдбcheckValKT l $'  ,$' R е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@\& isValidateCount = isValidateCount + 1k h  R T A@'_=================================ִеΪֵУ==========================================ѴϢдбcheckIntKT l $'  ,$'$@ ΪDZΪ̶ȶ R е 8дȷΪգдΪڵ$ҳȲ$ λ'$eEΪΪ̶ R е 0дȷΪգұΪڵ$ҳȲ$ λ'k@'0УʱдϢ A@\k h  R T A@'`================================= ִе֤У========================================== checkSfzjhKT h R$f'S ȡд  R е &дȷ֤Ϊգ''0УʱдϢ A@\d  ֤ l T$'O ֤У :֤У R е *дȷΪѧ֤ţ''4УʱдϢ A@\  'kxdp l$'  R е EдȷΪգҳȱڵ1λҲ18λ''4УʱдϢ A@\kkk h  R T A@'X================================= ִ֤У================================== checkZjlxKT checkZjlx l1$'  R е дȷ''(УʱдϢ A@\d@ checkZjlx h R TA@k h  R T A@'\================================= ִѧŵУ==========================================checkXJHKT l0, 1, 50$'  R е KдȷΪգΪճȱڵ1λҲ50λ''0УʱдϢ A@\  'k h  R T A@'`================================= ִѧϢIDУ==========================================checkXJHKT l$'  R е EдȷΪգҳȱڵ1λҲ50λ''0УʱдϢ A@\  'k h  R T A@'[=================================ִпУ==========================================ѴϢдб checkBankKT l$'  R е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@\%isValidateCount = isValidateCount + 1k( h  R T A@'W=================================ִ꼶У========================================== checkYearKT checkYear l$'  R е дȷ''(УʱдϢ A@\d checkYear h R TA@k h  R T A@'W=================================ִѧУ==========================================ѴϢдбcheckXnKT l$'  R е )дȷʽ2012-2013ȣ''-УʱдϢ A@\%isValidateCount = isValidateCount + 1k  h  R T A@'W=================================ִ·У==========================================ѴϢдб checkMonthKT l$'  R е &дȷʽ0112ȣ''-УʱдϢ A@\%isValidateCount = isValidateCount + 1k h  R T A@'g=================================3 ִеУ(DZ)==========================================ѴϢдб checkDateKT l$' 2Уʧ R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-02-21''-УʱдϢ A@\%isValidateCount = isValidateCount + 1kx h  R T A@'c=================================ִеУ飨==========================================ѴϢдбcheckDateNecessaryKT& l$' 2Уʧ R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-12-21''-УʱдϢ A@\k h  R T A@'g=================================ִеijУ飨==========================================ѴϢдб checkBirthdayKT! l$' 2Уʧ R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-12-21''-УʱдϢ A@\  'k h  R T A@'J=================================10 У绰====================== checkPhoneKT l$'  R е дȷдʽΪ"$.-̶绰 ֻ"$. ''%УʱдϢ A@\' isValidateCount = isValidateCount + 1k h  R T A@'L=================================checkOption У鱸ע ====================== checkOptionKT lB$'  R е )дȷȲܳ200ַ''%УʱдϢ A@\%isValidateCount = isValidateCount + 1k h  R T A@'\================================= ִ϶ѼУ================================== checkDiffNameKT checkDiffName l $'  R е дȷ''(УʱдϢ' A@\d  checkDiffName h R TA@ l$1ͨУֵΪ'd'kk h  R T A@'d================================= ִ϶У(DZ)==========================================checkIdentityDateKT% l$' 2Уʧ R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-02-21''-УʱдϢ A@\'d  l$X$϶ȼΪգ϶Ϊլ'  l$e](϶ȼƲΪգ϶ڲΪ'd( R е vдȷ롰Ѽ϶ơͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơǷͨУ''0УʱдϢ' A@\'k0Ek(E h  R T A@'T================================= ִУ==================================checkMZKTcheckMZ l$'  R е дȷ''(УʱдϢ A@\dCcheckMZ h R TA@kC h  R T A@'d================================= ִ϶ԭУ(DZ)==========================================checkIdentityReasonKT'0,1,30' l $'  R е 5дȷȱڵ1λҲ30λ''0УʱдϢ A@\d(B   l$r1϶ȼΪգ϶Ϊ,϶ԭΪ   l$ew8϶ȼƲΪգ϶ڲΪգ϶ԭΪ   l$e R е dдȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬''0УʱдϢ A@\'dH@ R е дȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơ϶ʱ䡱ǷͨУ''0УʱдϢ A@\'k@?k8? h  R T A@'X================================= ִ֤У==================================checkIDCardTypeKTcheckIDCardType l $'  R е дȷ''(УʱдϢ A@\d=checkIDCardType h R TA@k= h  R T A@'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType l $'  R е дȷ''(УʱдϢ A@\dh<checkDisableType h R TA@k8< h  R T A@'T================================= ִвмУ==================================checkFamilyIncomeType3KT l1$'  R е дȷ''(УʱдϢ A@\d:EsetDMBCode "checkFamilyIncomeType", sheetIndex, rowIndex, columnIndexk: h  R T A@'d=================================14 checkSQLY ɵУ--==================================checkFamilyIncomeTypeKT l0'd9 l $'k9   R е дظ¼룡'd89 R е дȷ'k8'(УʱдϢ A@\d8 l0 l1 l2 l3 l4 l5 l6 l7 l8checkFamilyIncomeType h R TA@b У'k7k7 h  R T A@'v=================================14 checkGender ִǷΪСŮУ--================================== checkGenderKT checkGender l1$' '-ԱдУ֤Ŷ R е дȷ''(УʱдϢ A@\  'd86 checkGender h R TA@k6 h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoKT checkYesNo l0$'  R е дȷ''(УʱдϢ A@\d4 checkYesNo h R TA@kp4 h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTSKT checkYesNo l0$' R T h$H%Z' R h$H%Z' R h$H%Z' R h$H%Z'  'k2 'k2 'k2k2  R е wдȷѹѡԱܹѡ3ǷְŮǷϻǷѼͥ''(УʱдϢ A@\d1 checkYesNo h R TA@kx1 h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTS2KT checkYesNo l0$'+ 11 17 21 28 29 36 37 41 42 43 44 R T h$H%Z' R h$H%Z' R h$H%Z' R h$H%Z' R h$H%Z' R h$H%Z' R$ h$H%Z' R% h$H%Z' R) h$H%Z' R* h$H%Z' R+ h$H%Z' R, h$H%Z'  'k. 'k. 'kh. 'kH. 'k(. 'k. 'k- 'k- 'k- 'k- 'kh-k`-  R е @дȷѹѡǷ¶ʵ˸ܹѡ11ǷְŮΪмˡĸΪмˡĸش󼲲мĸһش󼲲мͥԱѧˣش󼲲мǷĸиĶͯǷĸһĸҵĸĻĸ䡢''(УʱдϢ A@\d+ checkYesNo h R TA@k+ h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTS3KT checkYesNo l0$'9 10 12 13 36 R T h$H%Z' R h$H%Z' R h$H%Z' R h$H%Z' R h$H%Z' R$ h$H%Z'  'k) 'kp) 'kP) 'k0) 'k)k)  R е дȷѹѡǷְŮܹѡ5ǷԱǷϻǷѼͥǷ¶ǷĸиĶͯ''(УʱдϢ A@\d' checkYesNo h R TA@k' h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTS4KT checkYesNo l0$' R T h$H%Z'11 13 R h$H%Z' R h$H%Z'  'k8& 'k&k&  R е eдȷѹѡϻܹѡ2ǷְŮǷѼͥ''(УʱдϢ A@\d0% checkYesNo h R TA@k% h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTS5KT checkYesNo l0$' R T h$H%Z' R h$H%Z' R h$H%Z'  'k# 'kp#kh#  R е aдȷѹѡǷѼܹͥѡ2ְŮϻ''(УʱдϢ A@\d" checkYesNo h R TA@kh" h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkDisableLevelKTcheckDisableLevel l0$' R T h$H%Z' T h$H%Z ѧмȼ R h$H%Z 'k k  T h$H%Z ײмȼ R h$H%Z 'kh R h$H%Z 'k( k  T h$H%Z ĸײмȼ R h$H%Z 'k R h$H%Z 'kpkh  T h$H%Z ѧмȼ R е TдȷڡѧǷмд񡱣ڱдIJмȼ'',УʱдϢ A@\ T h$H%Z ײмȼe R е TдȷڡǷΪмˡд񡱣ڱдIJмȼ'',УʱдϢ A@\ T h$H%Z ĸײмȼe R е TдȷڡĸǷΪмˡд񡱣ڱдIJмȼ'',УʱдϢ A@\d R е дȷ'',УʱдϢ A@\kdcheckDisableLevel h R TA@k h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTS6KT checkYesNo l0$' R T h$H%Z' R h$H%Z'  'kxkp  R е ;дȷѹѡΪмˣܹѡ1¶''(УʱдϢ A@\d checkYesNo h R TA@k h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTS7KT checkYesNo l0$' R T h$H%Z' R h$H%Z'  'k8k0  R е ;дȷѹѡĸΪмˣܹѡ1¶''(УʱдϢ A@\dx checkYesNo h R TA@kP h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkFamilyDisasterTimeKTcheckFamilyDisasterTime l0$' T h$H%Z!lͥشȻֺʱ R h$H%Z!l R T h$H%Z!l'kk  R е 2дȷûȻֺд''(УʱдϢ A@\dcheckFamilyDisasterTime h R TA@k h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkFamilyBurstTimeKTcheckFamilyBurstTime l0$' T h$H%Z!lͥشͻʱ R! h$H%Z!l R T h$H%Z!l'k8k0  R е дȷ''(УʱдϢ A@\dcheckFamilyBurstTime h R TA@kp h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTS8KT checkYesNo l0$' R T h$H%Z' R h$H%Z' R% h$H%Z'  'k 'kk  R е sдȷѹѡǷĸиĶܹͯѡ2Ƿ¶ʵ˸Ƿĸһ''(УʱдϢ A@\d checkYesNo h R TA@k h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoTS9KT checkYesNo l0$' R T h$H%Z' R h$H%Z' R$ h$H%Z'  'k@ 'k k  R е sдȷѹѡǷĸһܹѡ2Ƿ¶ʵ˸ǷĸиĶͯ''(УʱдϢ A@\d( checkYesNo h R TA@k h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkInSchoolCountKTcheckInSchoolCount l1$'  R е дȷ''(УʱдϢ A@\d checkInSchoolCount h R TA@kP h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkParentJobsKTcheckParentJobs l0$' R T h$H%Z' R h$H%Z'  (ĸûйũֲֳ'k *ĸһûйũֲֳ'k 0ũСֲСֳ߾ǣ'k8 k0  R е Oдȷѹѡĸҵܹѡ1Ƿ¶ʵ˸''(УʱдϢ A@\dhcheckParentJobs h R TA@k8 h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkParentCultureKTcheckParentCulture l0$' R T h$H%Z' R h$H%Z'  ĸΪмĻ̶'k ĸһΪмĻ̶'kkx  R е KдȷѹѡĸĻܹѡ1Ƿ¶ʵ˸''(УʱдϢ A@\dcheckParentCulture h R TA@k h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkParentAgeKTcheckParentAge l0$' R T h$H%Z' R h$H%Z'  ĸΪ60꼰'k ĸһΪ60꼰'kk  R е Kдȷѹѡĸ䣬ܹѡ1Ƿ¶ʵ˸''(УʱдϢ A@\dcheckParentAge h R TA@k h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkSuortMembersDescribeKTcheckSuortMembersDescribe l0$' R T h$H%Z' R h$H%Z'  &˿λˣ70ϣ'k@ &˿λˣ70ϣ'kk  R е Kдȷѹѡˣܹѡ1Ƿ¶ʵ˸''(УʱдϢ A@\d(checkSuortMembersDescribe h R TA@ks h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkXfKTcheckXf l0$'  R е дȷ''(УʱдϢ A@\drcheckXf h R TA@khr h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkfamilyHouseTypeKTcheckfamilyHouseType l1$'  R е дȷ''(УʱдϢ A@\dpcheckfamilyHouseType h R TA@kp h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkfamilyCarTypeKT l0'do l1,2,3 l2,3 l1,2 l2,1 l1,3 l3,1 l3,2,1 l1,3,2 l2,3,1 l2,1,3 l3,2 l1 l2 l3'dn'knkn  R е дȷ''(УʱдϢ A@\d0ncheckfamilyCarType h R TA@kn h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo10KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dl checkYesNo h R TA@kpl h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo11KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dk checkYesNo h R TA@kj h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo12KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dxi checkYesNo h R TA@kPi h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo13KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dg checkYesNo h R TA@kg h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo14KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dXf checkYesNo h R TA@k0f h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo15KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dd checkYesNo h R TA@kd h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo16KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\d8c checkYesNo h R TA@kc h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo17KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\da checkYesNo h R TA@ka h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkSqyyNameKT checkSqyyName l $'  R е дȷ''(УʱдϢ A@\d` checkSqyyName h R TA@k_ h  R T A@']=================================checkTerm ִѧУ--================================== checkTermKT checkTerm l $ R е дȷ''(УʱдϢ A@\k^ h checkTerm l $ R T A@'P================================= ִѧУ==================================checkXf1KTcheckXf l$'  R е  дȷΪգ''(УʱдϢ A@\d8]checkXf h R TA@k] h  R T A@'T================================= ִвмУ==================================checkDisableLevel1KTcheckDisableLevel l $'  R е дȷ''(УʱдϢ A@\d[checkDisableLevel h R TA@k[ h  R T A@'T================================= ִвмУ==================================checkDisableType1KTcheckDisableType l $'  R е дȷ''(УʱдϢ A@\d0ZcheckDisableType h R TA@kZ h  R T A@'T================================= ִУ==================================checkSuortMembersDescribe1KTcheckSuortMembersDescribe l $'  R е дȷ''(УʱдϢ A@\dXcheckSuortMembersDescribe h R TA@k`X h  R T A@'T================================= ִиĸְҵУ==================================checkParentJobs1KTcheckParentJobs l $'  R е дȷ''(УʱдϢ A@\dWcheckParentJobs h R TA@kV h  R T A@'T================================= ִиĸĻУ==================================checkParentCulture1KTcheckParentCulture l $'  R е дȷ''(УʱдϢ A@\dUcheckParentCulture h R TA@kXU h  R T A@'T================================= ִиĸУ==================================checkParentAge1KTcheckParentAge l $'  R е дȷ''(УʱдϢ A@\dTcheckParentAge h R TA@kS h  R T A@'T================================= ִд󲡻У==================================checkFamilyDiseaseDescribeKTcheckFamilyDiseaseDescribe l $' R T h$H%Z' R h$H%Z'  ĸش󼲲м'kpR ĸһش󼲲м'k0Rk(R  R е дȷдĸǷش󼲲Ŀѹѡ¶Ŀѡĸش󼲲м͸ĸһش󼲲м''(УʱдϢ A@\d(QcheckFamilyDiseaseDescribe h R TA@kP h  R T A@'T================================= ִ뷶ΧУ==================================checkFamilyYearIncomeRange1KTcheckFamilyYearIncomeRange l $'  R е дȷ''(УʱдϢ A@\dOcheckFamilyYearIncomeRange h R TA@kPO h  R T A@'P================================= ִлУ==================================checkHjKTcheckHj l $'  R е дȷ''"УʱдϢ A@\dNcheckHj h R TA@kM h  R T A@'T================================= ִȻֺУ==================================checkFamilyDisasterTime1KTcheckFamilyDisasterTime l $'  R е дȷ''(УʱдϢ A@\dLcheckFamilyDisasterTime h R TA@kXL h  R T A@'P================================= ִУ==================================checkFamilyBurstTime1KTcheckFamilyBurstTime l $'  R е дȷ''(УʱдϢ A@\dKcheckFamilyBurstTime h R TA@kJ h  R T A@'T================================= ִмͥʲУ==================================checkFamilyProperty1KTcheckFamilyProperty l $'  R е дȷ''(УʱдϢ A@\dhIcheckFamilyProperty h R TA@k0I h  R T A@'T================================= ִмͥʲУ==================================checkInSchoolCount1KTcheckInSchoolCount l $'  R е дȷ''(УʱдϢ A@\dGcheckInSchoolCount h R TA@kG h  R T A@'r=================================checkAtLeastOneNNull ִһΪǿ--==================================checkAtLeastOneNNullKT  'A"ִ һǿУ ĵԪĿ l$ l=Ϲ  l ' T KTF  l '  KTF  l ' KTF  l ' KTF  l 'nEdϹ  'F6ִ һǿУ ĵԪΪϹĿ    'kXE'nHEi@E_--------------------------------------------ʽ-------------------------------------]VBSCRIPT.REGEXP$$."7RegExΪʽ "(4 ȫֿvba\ת  "(&.ʽ "((5ǷִСд l "%*'3 ִ."iC-----------------------------------------------------------° Уظ˵Ѿûиʽ------------------------------------------------------------V-----------------------------------------------------------1ѧ׶ڱڲ(sheetѧ׶ 2A65535 .$`%<%!4'0*cna = getTotalColumnCount(sheetIndexValue) b$`!ZB@61&ÿУظʱʱѴϢsheet,'dϢ¼ʼX==============================ѧ׶ڱڲ==================================0ðÿԪغ֮ǰнбȽ 8  0 8 < .$`%Z': >  8 > < .$`%Z'@ : @.ѧͬ˵ظݶ > еݺ͵ 8֤ظ!!!!' A@\*ѴϢ'Bk(@ @@i@-----------------------------------------------------------һ ֵȡֵ------------------------------------------------------------ֵҵֵڵлkeyWord ҵĹؼ'kbn л ֵΪ rowrow'D]the find result object FN RP VT A1:A65535 h$H%<%L.J J Hrow J!4'Dd8> J!X'Dk >k>i>------------------------------------------------------ ִڹУ(Ϊ)-------------------------------------------------------------value value1 cellУ鲻ȷfalseУȷtrue Z0˵ΪDZ $'z<k<k<]h'^ijһļ¼ 2A65535 b$`%<%!4'`B' b lrow$D'\=ȡ 8 \ ` 8 b$`%Z l ^ '^d;y;k; 8 > \ \ ^  > b$`%ZX X LжϹǷcell'y ;k; >#ʱcountĿΪùеĿi:------------------------------------------------------ ִɾijһвexcelܱģ-------------------------------------------------------------sheetIndex rowNum к1qazh h$HB@f ` h$H%jB@l/ Ѹɾ- Worksheets(sheetIndex).Protect Password:=123ih9------------------------------------------------------ ָcellֵ-------------------------------------------------------------1qazh h$HB@f l R j h$H%Z(li8------------------------------------------------------ ִɾijһвexcelûб-------------------------------------------------------------sheetIndex rowNum к ` h$H%jB@l/ Ѹɾix7------------------------------------------------------ ָcellֵ-------------------------------------------------------------@ 1qazh h$HB@f l R j h$H%Z(li6------------------------------------------------------ ݴеֵǰʱѾͨУ飩------------------------------------------------------------- ]   R j h$`%Z!lX 'V'^ijһļ¼ 2A65535 b$`%<%!4'`F b lrow$D'\Aȡ 8 \ ` 8 b$`%Z l ^ '^d4y4k4 8 > \ \ ^  > b$`%Z!lX '  VX 1жϹǷcell > b$`%Z!l't tX R j v h$`%Z(ly3d3 0 R j v h$`%Z(ld3 R j v h$`%Z(lk`3kX3 >i@3------------------------------------------------------ ȥcellеĿո------------------------------------------------------------- ] Ԫ]  3Blength1ʾcellԭijȣlength2ʾִȥոַ'ĬΪûȥո2 Worksheets(sheetIndex).Unprotect Password:="1qaz" R j h$H%Z!l' 'x xGzj*"ԪΪգȥո  'z%length2Ϊոһγֵλ zַո  $|' X R j h$H%Z(l'k0i00Attribute 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?Lb- '#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: 'ȥո𷽷=A@Enter س] d=4@|, functionArgs}k!13"x$sWHork"s().Cells(7J$). a ǀ" yO` 225E <> "" And :cWg?/FaZ & -A#δ#̱؁%X2 _5z V> '= ">ش׀Ȼֺ??, 30?ET?_S??$?I L  _b@xu!ͻ!e{OK33!?ARk!?- E?A_ !?A?ASe!  O?u?"?X"Ƿծԭo- Ъ^s'i!5:Cb&o!o!rC _!_!\!1Ϊ5qc!,   OyًArS plit(y, x","`(0)0UB@.d1 'ѻΪ azહ̶q>*& Bԡ  3!Ϊ=1)1λho Q= 2 1?߿ҲFr(21q{ó ElseIf functionArgsArr(0) = 1 And UBound( B>Then 'ΪΪ̶  errorMsg}"" & rowIndex "е@title-& "дȷΪգΪu1)-λvalue1"3^2 ]$ΧPڵfVR\@[23[@IfD_ha sEATrue 'У@ʱAдwriteLXog  E\0beginCheck_comment sheetB, cAMeth`odXQ,o0lumnD !isFord'= ִAsAU'Case "BSpLenoՇ(w,)W Not)rWŕl_ASplit,p ","e 02EFB 􁳣Gaւ@ɻַ߲dٲ=+߲߲*?+_C9+߳nYY__?:_rr _1,&Δ. -,:->/,G,,{. dbe/=,Numberͣ ( = gs|fXQ0%????ϞEmp患a@0<λQJyAС?WWWm////.A" & titleMsgP"ȷΪգұΪ֣0λȲfunctionArgsArr(1)dλС^V2+" Else%DerrorA= "WrowIndexRеӌ62 snd If!thasEr = True 'УдwriteLXog M E'beginCheck_comment sheet_, cAMethodXQ, Ee`olumnD !isFor> '=ִֵΧAI @хRдBбHC ase "7Val >.E (value, )_@If NotQ Then abu@Split(, ","X3j:t,(0B]lA ?g?g f' is`CidateCou c=.8+ 179uonck?nDmiamΪֵmm)mIntn n6n,Zo=6 d= b0b '!DZΪ̶{>/tυuͅ Å?"C?Y?߇ه`G1 L6oϙoFT OIoWW dSS OTkO ST֤|_RSpfzjhRe rr@esZjlxp0g@etCellPku1#kXQ(5,, A8'ȡ>xݟ)p7G""6?4?4?4 =4EI._,_,_,_,_,/?rIsIDNum(bersc) ')= ᫁V#.OMO!!!Ui /"/"/"/o"o"ƳidateCount = isVal+ 1  End If!NElsecheckMethodXQSFZJLX(value)CIf Not JThen:serrorMsg>"" & rowIndex"еʀ title& "дȷΪգҳȱڵ1λ 18첄"RhasETRTrue 'Уд#(writeLog ? }E[" WbeginCA_commeAsheetv, ,F|olumnD FisFor!d '= ր́p^ =9Case "»ZjlxTB=&"?j 4jwc_b_b `ۙsDet +Cod2, INjLXc[[RZ+VZѧ஺ŵZ[XJH7R[LenCƠY0, 1, 50Za:[#?\C_CƿCȘ!50?d22#ͅ(o00 7Z"0?^0/0xID/1/1^/1 ?1SO9_0pϓ\_0A/ /OO/////(//////,!𿨺`eд0б?141Bankb000<00,00001Ϊ֣%0qfunctionArgsArr(0)'?r(13 222 ?.'22ov2111?? 1-q1꼶?1pYear.?O/@/ʳue, 1)  If Not checkMethodXQ ThenerrorMsg = "" & rowIndex"е 6title-& "д첄"fhasEifTrue 'УдDwriteLog ZElse"setDMB@Code "Year", sh(eet|,, column )@End If b eginC_comment2:,visForDU '=ִѧOA_ @хhбK>䲹Uݲσ<@-Xn(valueA0?2012-3A ?e'isValidateC$ou@O= -+ 1Wa[ZZ ZYY·Y]Y(YMonth?Z#\aZ ??Z0112?Z?Z_c ?Ze?Z ?ZP?Z?Zش?Z)S==3 Z![(DZ)+.u[.DB" 'AU-u=sBirthday.et?\ĉ 'ʧo_01y]эChr(34)Ax-xx M !`-0`1z O3 O3yO3o`o`o`O35o`IgO3.2죨2P_33 3Necessary3 3&/4(/4/4C/4 Kp/4/455'4є/4 /4/4/4/4gFe/////E :YO=,/)T0=000 0_/ /ѕ////ccca/u///q<3-/ /m True 'Уд writeLog er@rorMsg^isValidateCount =" + 1CEnd IfbeginCheck_ commeYsheetIndex, cMethodXQ, rowolumnaisForU '=10 `dC ase "TPhone"rbFNum(value)If Not ThenzEA"" &K"еtitle}дȷΪA Chr(34) -̶F ֻH 첆B)hasE)' $?? HOption"Vע U?UCUCPU, 66?Vv?Vsg?VaL5VȲܳ200ַPϟPP] '?2P??+A ִ϶ѼaQkhDiffNam?ѩb_GDMLB(#, «, func!eArgsPWa j_oz sysaicultyGradeFla70Oe.ElseOEsetCodr ~poe XTri5tqD"G B'ͨa(ǀֵΪuq2_ /@ O OO cOc>!&B1(DZ)o'{BId`ityD" 'OCpBirthd| AoEcEnȼQnaE01oF? =Ӌq K\2 <> "Q +`/ oLZoM?O1O1/3)̸롰ՈAȬʱC<ұcU1?Ƿu^ 333nL>XQ = Fal se writeLog errorMsgindentifyDateFla g0lEnd If#beginCheck_commv sheetIx, cMethodX@Q, rowo0lumnlisFor^Tru'= ִPУ=yC ase "[Z" jNDMB(, value, 1)!If NotG Then I"" &FS"titleдȷ06hasE] 'ARʱдϢ*"EZset@UCodHd,ғ%?U2϶ԭ/()Z% [ItyReason" '3&functionArgsO0,1,30GrcLen(b tccrdd1λҲ30_i_j_j?F_kFk,sysDifficultyGradeNam1 AC#Trim#;)eC"B 'aWȼա'a,[Pw;!}2v#i<> "!%%q4 (` 0 Or )/_fiϴ_4Vf& ff롰Ѽ!ʱ䡱6ͬʱ SұͨAPPk O7llO7oPߞ  ?!m}ÿǷdNn?, ?o@_ /֤,iDCardTy|peowIXpay/6/6/6-69---L/-/-!Eݕj'_K"?c....?P./+.f.Disab le.  checkMethodXQ =xDMB("DisableType", value, functionAr`gs) I f Not Th en\?errorMsg"" & rowIndex "title-& "дȷ"f0hasEifTrue 'Уʱд@Ϣ"writeLog CZElse"setCode Asheet,, column ,End If beginC_commen\t I , "" A_GDm mFa EXԽu----H, 17-e*--??#=.H Hh;KKğKx21K00?K, %%o  I  s?S_QNotU`/$3unhhhr՚k`" &敠"еtit leдȷڡaoYqS@ڱ2 E\0υ hasEѥ ! '屍ʱдϢOϪϪ?j  A& {SSY  d0"\ 00'0д0д00 Ldq/b///-(9(/UboY~ҧ.IQOBϺV* sg isFor = TrLueT'=14checkYesNo ִǷΪǡР--R= Case "alTS6"+MethodXQ}!DMB(", value, 0"0")# r esult+Worksheets(Index).Cells(row, column%4=>1'?107V W IfN"" Then Z7AK# ͏Fals Z2End |If[ wY #N ot[2errorMsgO"0" & \@"еatitle& "ȷѹѡΪмˣĂܡ1¶ |.hasEA 'ʱдϢ7+writeLog S"E@set Codj',%j EbeginC_comment W,'^ƿƍ o7xſ¿!ZhK/_arZp_VZAE_aI X_a_aAo<[O/ 9_ap1_ag D_a_a_aWa_ab_a_a _a_a_a _a`_a@&_aa_a¡_a'_a_aE_a/p _aDZ?%S 'oaoaoHaFamilyDisasterTimea B@ŢGO727!).b!7ͥȻʱ'Ot _30%<> ´A  /x ue Q  WW2`OQgOQûNᴴ hasError = True 'ʱд΀Ϣ  writeLog eMsgTElseDsetDMBCode "checkFamilyDisasterTime", sheetIndex, row column znd If beginC8_comment2EMethodXQ:,|isFB'=14A=YesNoǷΪǡR--)=?CasYBurstY A@l( k, value, "0")SSIf Workys({).Cells(7, H{).#"ͥشͻʱ" Th "" A+-Aa(A* `FaӁ EXy63Not +3" &fv@"е@at0itleaдȷ>"8!* bGZ?C5?ck?z-(D3???mKChTS8Gmj_Rresult`_ +-71Et10Z 2xYR7O w_\ RY_Igߐ 0qm&[ I@/9FA  _h) W_1o_&qo1o& ooѹѡ1ĸиĶ0ͯqq2t¶ʵ!һ1uI uLS uyY/uTq"/uO/uO/u _up_u][_u9_u2 =B_u_uH ^ou`thou(5ouToupouI3|36ouO Kresult = "" Th`en h A6 If 1$checkMethodXQ8Falseh xEndCe2?eed H?No t f[errorMsgAK" & rowIndex"еtitleA & "дȷѹѡǷĸһA2¶ʵb  Ķͯ "Eha sE21True 'УʱдϢwriteLog EE EڹsetDMB@Code "BbYesNo", sPheetV,Y, columnTxbbeginCp_commen.t A,isxFor*'r=14`g#րݡ@Ϊǡ@a8--^ =iCas/InSchoolCountG$@`8(7K, value, "1")Dpg$ppdddddd,e2٣eٿee?a?a00G0-ParAJobso0R|g0700?0~b!Works().Cells(hQ68@7o10_o?ewPK"wûйũֲֳ L= ߝ__:9/9O/?:/':*E߾ǯo )&POg f37ҵ[1_Wz ___Lzk zy^`7\sI_'zjOB'vO|o Case "checkParentCulture"  MethodXQ = DMB(, value, "0")0 res_Worksheets(Index).Cells(row, column%hzw>r1'?10o&3Ifs4"" Then  5i"Ϊм΀Ļ̶^ 3 |ȀFalse&A End([N8һ8{Ź8 8YSF@DN otLk[errorMsgD" & El@"atitle& "дȷѹѡLJ!!M1Ƿʵ˸4HhasEATrue 'УʱϢEwriteLo,g SEZse"tCod, =,(ꔴabeginC!_comm` J,`isFor+'2=14@3YesNoִ<ΪǡHa5--^ =Ӊ#.Agd? $HI/ӥyTi wii60i/i/+Z_:W/ 9f Bw#i o IO) 5 _hhg Jhhhhhhhi hhhho hyhNhexh/'hhhRhhu&ieiii/j1iSuortMembersDescribjs -=wԟOk=7OkrA@OkOkEVOkG I˿λCkˣ7blϣol ]!ol_?:<2  HIf result = "˿ˣ70ϣ" Then checkMethodXQ\`False4End If#cNotd}errorMsg" & ro@wIndex"е title& "дȷѹѡƂ܁1Ƿ¶˸첄"hasE('True 'УдwriteLXog E; E|setDMBCode "ŠSuortMembersDescribe", sheetBP,R, col8umn؊beginC_commentJJ,>isForY '=14AYesNoր݁zΪǡ@񡱁k--= #Cas,|XfC``4(3, value, "0").f`Kff________b__J_B+]ٚ]G] ] ;_==__ b_familyHouseTypealac1cɝɏ1\?a?a?aL1" 1y>a_2ex`I_2'_2`_22h`_2 *_b--o2_b?_b]o2.CarO2 ^`ba_:Rᇹ?"I1,2,3" |Orsiq01 1=3,3pO,22,mL OBu6 5- _Go!߸g 6!߸߸߸ѸT9TTTLTT yTne<ߴS)'SSSJSSR-NRRR?]_)C 10?}5$functionArgs11+ errorMsg = "" & rowIndex("6titleZ& "дȷ"  hasEifTrue 'УдDwriteLog *ElseDsetDMBCode "checkYesNo", sheet|,, column 6nd If beginC2_comme nt2?MethPodXQ:,vipsForB 'r=14sIǷΪǡRs--=# CasJd11/JM@>t(svalue, functionArgs)If Not Then* d͗̀lͻfxfEEf@sffRf2f_ffhf2fXQfff=C fb fͿfnfsU_3 o*P_3._3ff] f3_3;a=3bfff_38fS_3ћof_3W_3Sf!_3sQ:_3_3_3 _3._3_3_3]_ ^34$_3|_3_3_3_3_3V_3_3_3_3͊_3_3_3*fg_3y_3_3_3_35_3_3_3_3_3_3qP_3._3_3_3]c ^35_3_3_3`_3_3[3`thodXQ T@hen errorMsg = "" & rowIndex("еʀ6 titleZ& "дȷ"hasEifTrue 'УʱдϢDwrit`eLog *ElseDsetDMBCode "checkYesNo", sheet|,, c`olumn 6nd If beginC2_com0ment2?Me :,visFoNrBV'=14@IִǷΪǡ@s- -=# CasJd16JM@>t(svalue, functionArgs)If Not { @6f ff$f Ef@sff2f@Eccc-fsTf7f`=]ffefffftf1_3Ifs[31,1?cc]0HcSqyyName/ ]/, cccVpkc/0cT /0yexc_0'J_0_0+'Term/ѧϒ?. S. ^-]_[rE/+/ /+/+/+/+/+$Q$$oϦ)OVOVg[% _V" C%>A%/%$%Xf>1b S7XfTS0? ;2_dOUOUe****`Ϊ, ]**1?V>VstheetInde@x, rowc olumn`  End IflbeginCheck_comment sc2MethodXQ, errorMsgbisFor = True !'= ִвмУ1= >@Case "_DisableLevel1" s#UMB(!", value, function Args)+If Not /ThI\_ck_~_[b_ͥʲ_kI_Property_|__-_2__ _._vޟ__O-_InSchoolCount/Y=Z_:/_SP/XQ _/U~_& _///(!/~//I/o_/o_, H//=,R(AtLeOneN0NullQһΪǿ--O1L a3`aO + 1 'a  u  Qk ĵԪ>"@ 27oney(2) And <> 03 'ѸϹ5qtotalMAP +Select Bt&baojiaoBC:oiSum ? _ huoshi H   zhusu G  others H   Mc*?%1Wd '23 >pG>6>>>րΪ@KE+Gnp+ " Jb^P isFor = True End Sel ect ,Function '-("p k re@gCheck( , valueB) Dim&EX As Obj#Set= @Create!("VBSCRIPT.REGEXP")'RegExΪZ6@EX.Glo8bal4'ȫֿ!'vba\-Pattxern.5-*ʽ Igno@reCaseF,al ִСд[;Test(]'ִGI\Nothing͏ľ° ظ˵Ѿûиʀ '1׶ڱĤڲ+ HcTheSameXQNew(sheetIndex28) 'Bhna@fS s .Range("A65@535").@(xlUp).Row'cBgetTotalColumnCount Vl msg"N).Cells.ClearContents 'ÿ3ʱ@ʱс2Ϣ,curMsg# 1 'E¼ʼ'=.'ÿԪغǰнбXȽGai`startTitle + 2 To0 rna%hcardID1D+b#I?#+(i, /c4ji - 1c 2Zj^! If Zn 'WͬtavA erroB"" & j`"е̓i ֤b@!" writeLog & 'TWhas$v'AeIfNex`aٚһ ֵȡֵ` #CлkeyWord Ĺؐabn"# ֵΪ row0ǀHQGe*t@ODl0(ByH 1, GStrf)ŁIHgerCm--1c׃ '@the firesult o_ c@@k XV)tX1:XF(W hat:= LookIn:=xlQVs, A xlWholY6t@Is Tu q6K&EPk= "`"g' c baEQI-0?q.( auf(Ϊ)@+r q1 cn ȰK'!ȷfіQ5t ~DMBcT1, flagd]`%$"0 'ASΪDZC+Trim1)q/A 0_K!Exit wSSbowDatm0 '@ijһ1q||P)Num0$oA=3'ƀ®߳ @*(,2REJU}|owP Q PQ|%_;s+Y{_8oMMy1e i +  C@T( 3)&R q 'жaq2Qƺq3a 5)ARY5vRj@'ʱcʀĿΪ1;Q?o!bHɾ.exܱ~ E1 p14кňsdeleteP2(, EjsheetIndex).Unprotect Password:="1qaz" B Works( Rows(rowNum).Delete 'ѸɾRv' xPq123 End Function '-2 ָcellֵ3F H setC*ValueCo untXQ, , colv)IČ=).= = Eִwijвex[û@['G кcdNob]5@BST?~XQQi{ ݴրе`}ֵǰ ʱaͨpУS/DMBCode(, V1H DiBmaDataAde"@G- xCStr(S!+/H 0 'wļ¼#g Area).Range("A65535").e(xlUp ow ' a GetQuOrC(+ ,C, "~") 'ȡAG#For i` @9 To'If &i, 1)8 Theς G&+ 1K Else+aExit l IfgNext ij+ -{ 1D6#j, 3Y)Q0 () 'A Ƿ!pȇ fcߠ2, 2 ?$Y) p +xumnPlusV OOÕ""O%;r . ㄟ ue "0z? :sY.e}/j_XA ȥ(Ŀո?^removeSpacev&x$#a^4As [ing 'Ԫ47.length1 IntegPer, 328 B'tʾijȣњaַA4 LenSx1`80K< 'ΪգW2Inqxc j jaһγλG6 2 <> D b3VRepl(@"%xEQo "Truo>q  (f F.UxME<6 LL L "L<8 4 `HkPz77@h 08@ X x@ H @8 @@( @ &` `( `* `J `, %hXXPPH,b`d@ @ @ @0 @H @` @x @ @ @t @p 20n6r@ ` @8P @@ *2.0\@0 @, @8 @ 2@ 02 @ @> @@ X;@ @;@ @p @ C@| C@l @(\ @I@L h(I@H x(KM@8 Q@( QS@ (Z@H 8Z`\@p H`@ p`pb@f@  @"h @ (t@p 8tHvz@$ @ p|@x |dB,@ h @X @H  `c$*\Rffff*2F651850a3*\R1*#3cb*\R1*#30d*\R1*#268*\R0*#17$*\Rffff*2D651850a3*\R1*#118*\R1*#31$*\Rffff*2C651850a3$*\Rffff*2K651852a6*\R1*#1be*\R1*#119*\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һͱʶľֵ]Զʶ]%Ѽ¼ΪյкŷŽ] H!^'"ȡĿ 0ĿȷģٽдУA@,1qazh$HB@|k1qazh$HB@f1qazh$HB@f1qazh$HB@f b$`!ZB@6-$ÿοʼʱѴϢsheet,'dϢ¼ʼ'.ôУУ¼Ƿд֣׶ϢУ ('#Ĭ϶ѼδͨУ'Ĭ϶δͨУ b$`!ZB@6-$ÿοʼʱѴϢsheet, 2A65530$H%<%!4'0 0A@n ȡ IV5 6%<%!X'xcna = Worksheets(1).Range("1:1").Find(What:="*", After:=[a1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).ColumnFAILUREA@r&+ȡǷУɹ־Ԫ񣬲ֵʼΪ0'ռ¼ʼΪ0 * 2" ʱִd ʼУ鰴ť¼ʱִ.ȷʼ Уرexcel $.ܵݶʧʧ 0ܰʾ$, 2d1qazh$HB@|kk.$H!b(v)ҳǩΪɫ 0  "ûвҵѧϢ޷У飡A@,'*1qazh$HB@|k'ôУУ¼Ƿд$H!дϢ£A@\ 0  8  0'<"ִ һǿУ ĵԪĿ';6ִ һǿУ ĵԪΪϹĿ'''5"һǿУʱ¼Ԫ'9ǷΪЧ¼ 'C¼УǰǷд';¼ԱǷд >  >$H%Z!l'Oһбʶֵ'2=жforѭǷcallFunctionXQStart ûִĬϷ <ʶΪ -$' Gʽ14-3:25 :$'H6ʽ3:25ȡıʶвֳ֣кź͹ DJҪּϵҪУ飨ĬУ͵ԶУ   Y&+1ΪеһԪΪĬУ $ :$' V*ȡıʶвֳ֣кź͹$ 'SԶʶ 8 $ ;$'cԶʶ͵ľֵ   gԱʶб $ 8 > A@}ݱʶֵöӦķk  $ ;$'Pȡıʶв   WԱʶб $ 8 > A@0k( eJ ʽ3:25$'QԶʶ 8 Pʶеڵǰ$;$'eԶʶ͵ľֵ   kԱʶб $ 8 > A@ݱʶֵöӦķkd-ֻĬУʽ14$ ;$'Hȡıʶв   OԱʶб $ 8 > A@0k(k  8 >$H%Z( > 6ִ һǿУ ĵԪΪϹĿ    8 е һдȷ''8УʱдϢ A@\  'd   ' Tÿһкϼеֵk <,һؼֶȫ򽫸ɾ 8 +  ',"ϢеĸдϢɾ " d  d d  b$`%jB@lr Ѹɾ " d  'd 'k 8k $  6 ɾЧ $$' $ A@dB Ѹɾd8  $ A@dH Ѹɾk $  ˴Уɾ ,Чݣѧš֤šԱ $.444УʧܼΪЧݣA@,kH *дϢ鿴ϢA@,$H!b(v b$`B@Hd 'BA@, B'%ִУظݷ,ûظǷҪɾЧ Уͨ!A@,.$H!b(vSUCCESSA@r:+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 2A65530$H%<%!4'0 0A@nd *ظݣ鿴ϢA@,$H!b(v b$`B@Hk( k 1qazh$HB@1qazh$HB@1qazh$HB@o q-------------------------------------------------ظijһ------------------------------------------------ ]`x] 2A65535 X%<%!4'02Scripting.Dictionary$$..O8O 0 X%<!l'0>ȡѧ 2 0%"ѧ໤֤ݽб 2 2 .%4-֤Ų 2 .B@6&#addһΪkeyڶΪvaluekk (!8'*Sheet2$HG:G7<B@6 * !%< (!^G17<,: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& !: [0* pHd VBAProject4@j = r `c J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5ETAAC42E2ED:\`\WPS . 11.1.0.12 313\o>6\ksoapi.dll#Microsoft 16 .0 Ob LibraryJMSFo@rms>SFrmHs3D452EE1-E08F_A-8-02608C4 D0BB4RINDOWSRowRFM20.DLLH'B @_&/;"1jpAp00}#0p# 50 AD4F6FAD4-FDC0-40C5-A5E3-7CB1B390F3A9@FUsers\huawei\AppData\Local\Temp\VBE\T.exd <!.E .`M  ThisWorkbooPkGTiEkWBnkboPk 2 QHB1J-@B,!zL*"B+rSheet1G Se`t1 u62 ` HU 6 6 6 6B -  ӡ@ԤGSbpSȉ[e2jo p !(e) ߺc ]wQQpec eGc eo gk `G;Xf"Ma2fo zo&B&У!heeo f3~k !L@GbQ;N z^b2o L.U2ShowG`6\ow3e2ro1]nOR( l5^5U^5^5^E0Qh ^ Prin tCriLnEj2.od 0v6  t&xRRME (@0<6 <hT0fkhovꐆP`Hꀊ@ʘxBʀ @ʀ4 @ꀒD @:L @%Ϣ˵%ꀪ@V  @Z  @ꀎh\  @ꘐB‒X@“@ʀd @0x@ꀔz@ʘ0BꀖH~ @vXhB!ʘB#%@&@%ꘄ(BbHpHꐈpHʀ @$ @8Hh @ꀤP @*T @BX  @ꀦ^ @<0Bꀔ` @dt@ꀬ| @b BʘpB"ʘB$pHPxh p(08H0X@X~0'=`c*\R1*#119$*\Rffff*2D651850a3(*\Rffff*2D651850a3\077    08  @ ` Dp 8 0 P0pD084P. ..(8(`>"$(@>`R^FX `*0$`  $  ^(^p^fk^0p@һṹҳP]$Hq=Public Const sheetNameValueTJ As String = "2ʵͳ"]$Ϣ(2Public Const IntroSheetName As String = "˵"]$H]$˵P] p ¼ܵУ]$¼ͷ] x"ִ һǿУ ĵԪĿ] 6ִ һǿУ ĵԪΪϹĿ] ÿһкϼеֵ] "һǿУʱ¼Ԫ] Ϣ] %---ģУ¼ĸԪ] 8---ģУ¼ĵԪ]  Уʱ洢ַ] ¼ʱرհť]  ¼ܵУǷвϹ] @ ¼ܵУǷظ] #¼ܵУǷظ] %/¼ЧǰǷдϢ ״̬] h#У鷽ķֵ]$)¼ʼк]$)ѧ֤ſʼλ]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*_'_% __S A.  A.  A. _VBA_PROJECT_CUR"/ShowForm CompObj aVBFrame o f&PrintForm CompObj aVBFrameof&PROJECTwmPROJECTVBA__SRP_5!/__SRP_62L__SRP_7T__SRP_8h2__SRP_9p__SRP_as__SRP_bvg__SRP_cxL__SRP_d~__SRP_eL__SRP_fyShowFormPrintFormThisWorkbook / _VBA_PROJECTz$__SRP_4"J__SRP_3#__SRP_2$.__SRP_1%__SRP_0&Sheet6')Sheet5(9Sheet1)I3!hQpe *SbpSȉ +fv]wQQpe ,f;N z^-@dir.x_Xf ETExtData