ࡱ; ERoot Entry F .D0F[WorkbookSummaryInformation(DocumentSummaryInformation8  !"#$%&'()*+,-./0123456789:;<=>?@ABCDkGHIJKLWNOPQRSTUVXYZf\]^_`abcdeghijl mnopqrstuvxyz{|}~ \plhy Ba= ThisWorkbook=$E8X@"1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1Arial1@[SO1[SO1[SO1 [SO1[SO10[SO1 Courier New1[SO1 [SO1[SO1 [SO1h>[SO1[SO1,>[SO1>[SO1>[SO1>[SO1?[SO15[SO1 [SO15[SO1[SO1[SO1[SO1[SO1 [SO1Arial1 [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\)c/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-u8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-S'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-e0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-                              P P     /    ff7 `  a !* "- #+ $1   $1 $  / $ $  * $ $6   $ $1   $, $  / $/             % x @ @  ""@ @ ""@ @   @ @  !@ @  @ @  !@ @ 1 1@   1  1 1 1@ @ 1<@ @ 1@ @  1 1 1@  1@ 1 1 1   1|@ @ 7  1@ @ 1@ @  1  1 1 @  1 ||kV}-}}(} }(} }x}  }-}}-}}-}?}}  ̙??v}}}  ??? ????????????}}}!  }}}" ??? ?????????}A}#}}-}$}A}%a}A}&}A}'e}-}(}A})ef}-}*}-}+}A},}A}-ef}A}.L}A}/23}A}0}A}1ef}A}2L}A}323}-}4}A}5ef}-}6}A}723}A}8}A}9ef}A}:L}A};23}A}< }A}=ef }-}>}A}?23 }-}@}-}A}-}B}-}C}-}F}-}H}-}}-}J}-}L}-}O}-}T}-}U}-}X}-}[}-}\}-}^}-}`}-}a}-}b}(}c}(}f}-}g}-}h}-}i}-}j8^ĉ  lʑ lʑfJTe,g fJTe,g hhʑ'`e,g 5ʑ'`e,gh 1h 1h 2h 2h 3h 3h 4h 4 eQeQ QQ !{{"hgUSCQ40% - :_eW[r 62340% - :_eW[r 6!?60% - :_eW[r 62460% - :_eW[r 6@8^ĉ 12A8^ĉ 2B8^ĉ 2 2C8^ĉ 2 3D8^ĉ 3E8^ĉ 4F8^ĉ 5G8^ĉ 6H8^ĉ 7I 8^ĉ_hQVL?e:SRNxccPK N@theme/PK N@ theme/theme/PKN@ky}theme/theme/themeManager.xmlM @}w7c(EbˮCAǠҟ7՛KY,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.%j@_5V<Y|slukހ,~m߿ZkxMڡ~NL8۩|(24 Ou]K](<\_V4Ej ! ؙC\L T;x?Ðsz_|3GϏp--oN#w᫯?oϾzjt?O?~ZTK<I|K ҄Ht}n0d$.bcJ#STCߞa+p[RR1} ũ4jJHvc≹ppDRThwRϮ4\B)`Zi!y4_CˬJ@g{YGBV`V!0ό7Tᤊ'5-*!3T0zc"e՚;u~Lw,Bу*0.rtcdUMc<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>fPO:܌X/(ՁLHelCL!Rʿ^|RC0cR}גɄu3mg_RʧA<>B#6ܯCS "6S~qΓν038;Y-2M27G<ЭRvU1)Ia?SE'p!:X`3pbU(iB׿0Aw 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Ӻ&݈Э56?$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`(*V,gNyR_VYf[ёDRNRTUS3ueNxhJOo`VV5p-MOLC 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; !! =B checkName checkZjlx checkSfzjh checkGord checkClass checkPmlx checkYesNoA checkSNumYN checkSNumYNscheckBirthdayAcheckLen0,1,50checkBirthdayBcheckBirthdayCcheckSpLen1,120,200checkDateNecessarycheckSpLen1,60,200 checkYXYJV[R_VYf[ёDRNRTUS3u1xmzjlxsfzjh pmTotalCountpmmc bxkPassCountbxkCountpmTypeisSynthesizePmMcsynthesizePmmcsynthesizePmCountachievementOneTimeachievementOneNameachievementOneBjdwachievementTwoTimeachievementTwoNameachievementTwoBjdwachievementThreeTimeachievementThreeNameachievementThreeBjdw applyReasonsqtbrqtjlytjlyrqyxyjyxtbrqYTNN{|WNNSb~cT;`NpecTT!k_OSkS)Ro` gN8RS~)R0hy0ZSi_6eeQ~FU0RSNSNNyiN0{QiN0R]Ncbd_b,gTv6eeQ a{Q90b(vb){Q9 LN6eeQ vQN^S_eQ[^v6eeQe6eeQcheckXff[90OO[9(W9501CQ20000CQf[90OO[9f[90OO[9(W20001CQN N cNN ct^~ cs~ ceT 4144010564C CxD'EE2F~FG~jG HJLTM M. N N( Nq O PHQ/kR SST7BU  Fa dMbP?_*+%z&ffffff?'ffffff?(?)?" d333333?333333?& cAU} X} *X}  X} -X} X} &X} X} )X} X} *X} WX} X XT0TUTTTV+W Y Z [ \ T T \ T T T T g g g h h h h h g \ h \ h \ h] @] ^_ijjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj `` a a a T T T T T T  T  T  T  T T T T T T T T T \ \ \ \ \ b ` b c \ T T T T  T  T  T  T T T! T" T# T$ T% T& T' T( T) T* T+ T, d- d. d/ d0 d1 d2 d3 d4 d5  d6  d7  d8  d9 d: d; d< d= d> d? d@ dA dB dC dD dE dF eG eH fI fJ fK fL fM fN fO  fP  fQ  fR  fS fT fU fS fT fU fS fT fV fW fX fY fZ f[ l6lllij(    P 9CCButton 19],@A9$< _Yhg< i V 9CCButton 13801@],5@A9$<_ Y h g<'>@<d  PE\lNQ[XuQeLr^yO/nyr:Sbgq/Nfoyr:Sbgq/NfS~nE\leg_'YFLXY8lENE\OObgq7bSvQNO ! cNN ceT ct^~ cs~ggDSheet1   qmp;y! dMbP?_*+%8&ffffff?'ffffff?(?)?" dXX333333?333333?& U} K} K} FK} !K}  L}  L}  L} L}  L}  L}  Lq@888888@8 8 8 8 88888888888888888888 M\ N] N^ M_  O` KaK? Pb Qc Ld PaP Pe Pc L PgP? Ph Pi PgP@ Pj Pi PgP@ Pk Pi PgP"@ Pl PiPPPPPPPP Pm P? Pn P. Pm P@ Po P. Pm P@ Pp P. Pm P@ Pq P. PmP@ Pr P. PmP@ Ps P. PmP@ Pt P. PmP @ Pu P. PmP"@ Pv P. Pm Pw Px P. Pm Py Pz P. Pm 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+9@,8-8.8/80818283?@4?@586J7J8J9J:J;J<J=J>J?J 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(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<<<<<<<<<<<<<<<<<<<<<<@JAJB5JCJDJEJFJG8H8I8J8K8L8M8N8O8P8Q8R8S8T8U8V8W8X8Y8Z8[8\8]8^8_8 @P @P@P@ @P AP APAP@ AP BP BPBP@ BP CP CPCP@ CP DP DPDP@ DP EP EPEP @ EP FP FPFP FPGPPPP HPHP? HP HP IPIP@ IP IPJPPPP KPKK? KP KQ4 LPLK@ LP LQ4 MPMK@ MP MQ4 NPNK@ NP NQ4 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@>6@<dNNN ggDSheet5   dMbP?_*+% &ffffff?'ffffff?(?)?" d333333?333333?& U>@<d:::- ggDSheet6   !"#$%&'()*+,-.013456789:;<=>?@ABCDEFGHIJKLMNOPRSUVXZ[\]^`acdefghijklmnoqstuvwxyz{|}~ Oh+'0HPXl boboalenovo@=i@ݴ.Microsoft Excel ՜.+,D՜.+,H(0 8@ 08|KSOProductBuildVerICV2052-12.1.0.22529$8F4BC20CBF6B4476BDCA0C41EA74F1EB_13 Microsoft Forms 2.0 Embedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} ShowForm Caption = "UserForm1" ClientHeight = 3180 ClientLeft = 45 ClientTop = 375 ClientWidth = 4710 StartUpPosition = 1 ' End  }t  Microsoft Forms 2.0 Embedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} PrintForm Caption = "UserForm1" ClientHeight = 3180 ClientLeft = 45 ClientTop = 375 ClientWidth = 4710 StartUpPosition = 1 ' End  }t ThisWorkbookThisWorkbookSheet1Sheet1ߺ]wQQpeXfУ麯!hQpe;N z^ShowFormShowFormӡԤSbpSȉPrintFormPrintFormSheet5Sheet5Sheet6Sheet6ID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=ߺ Module= Module=У麯 Module= Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} BaseClass=ShowForm Module=ӡԤ BaseClass=PrintForm Document=Sheet5/&H00000000 Document=Sheet6/&H00000000 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="F2F05E300E340E340A380A38" DPB="9E9C32E4723C03590359FCA70459D3384517889F75234EDA55871AA2FCBF23899111D5D51108B8" GC="4A48E658935993596C" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C ߺ=76, 76, 1728, 1015, =0, 0, 0, 0, C У麯=114, 114, 1766, 1053, =0, 0, 0, 0, C ShowForm=0, 0, 0, 0, C, 32, 32, 2346, 1177, C ӡԤ=38, 38, 1690, 977, PrintForm=0, 0, 0, 0, C, 64, 64, 2378, 1209, C Sheet5=0, 0, 0, 0, C Sheet6=0, 0, 0, 0, C rU ' nrU 0` a///(`/0` a///(`/(!`/(I`/(q`rU~| %% aYvu |ky|{{|Y{Y}~ ~Y 0   H :L\l\<  <5<4 cLl@ fLl @H,/l\<,,h$XhHXh5X H H8((]t6H8GXFH%h$h8@`FX)h6H8-X @h$Xhhh,/lX hH80   xl\ \:L ]35\/ cLl :L,l,\  \5\c cLlo fLl Px,/l,\<H :L\l\<  <5<4 cLl@ fLl @H,/l\<0 8  H :L\l\<  <5<4 cLl@ fLl @H,/l\< l CtlCp+tM`@P P@ @`1t6P@(lpF`](/Plt 0'@5kpzltJ/(PtM`@@ @ 6P@lt ~<cZ.(@k<:`NPP Up:6P@ k: p:?k>D(Pk<tM`@@ @k:DUp>6P@  p:LtM`@P  P(k::N@@ 36@Ppz 0/pt( P@0   0   0 0  0   0   0   0 0  0   0   0   0    0  0  0  $6:HN88\X( (/X58 f\lH:\ ]3(\%8(]358} c\l :\l8  858 c\l f\l5Ifp\8(H%( -Vp(% -pI`'P6(pa c\l7\8(H%( -36( c\l,0/l< X8(p`P| f\lL:\ ]3. c\l :\,l,<  <5<b c\lt f\l P|,/l,<0 0  0  0 H  0   0 H  0   0   0   0   0   D6:HN88\X( (/X58 :\ f\lH:\ ]3(\%8(]358 c\l5IWp\8(H%( -Vp(% -pI`'P6(pRl8  858> c\lJ f\l7\8(H%( -36(l8  858 c\l f\l2,0/l< X8(p`P0        !"#$4/(`/,`Q, `q//( `/(9 `/(a `/(`/,`//(`/(`/()`/(Q`/(y`/,` //,` //, ` //,1`//(Y`/,`//,`//,`//,`//(!`/(I`/(q`/( `/(!`/0"` a///,#`//(9$`/nrU $`$`nrU~|  0  krU $ rU~| J a  1QT !9  QYPYY  a0`\ !9ayaAyiX)$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@"@(@&vivih Mvi%p: %$dp>?)p5 ~d vi"{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)pzF( G6 uF+'t'':HN 6t=(%p(%$dpW%C&)p51:INtt(((P 6 tP]%:%p(%$dp>AUz)p6,M@(((t 6t+'t'':HN 6t=(%p(%$dpW%C&)p51:INtt(((P 6 tP]%:%p(%$dp>AUz)p6,M@(((t 6t;:%p(%$dp)p;:%p(%$dp)p;:%p(%$dp)p4/# |\L8(xXlhH8(@< H,ptP0hH0   f`nrU yQ4 0  XrU @4 `dAY!#nrU @ Yi!P 1Y/4q ` x"l "   " "\ ''' :\lL:<, :::|l\L:<,^z6$lL, l\L, u  $/ TlL, l\L, 4XrU @,`8Y#nL+nxME(SPSSS0{D63927FE-0D1F-4BE3-8DFA-799CB6BEA093}{FE339F34-188F-4096-B1B6-91380978DB35} P@ T% %@@>i " 0 8"HP Xh xȡ' B@RoHȷ@ V' B@RoQAttribute VB_Name = "ShowForm"  Bas|0{D63927FE-0D1F-4BE3-8DFA-799CB6BEA093}{FE339F34-188J096-B1B6-91380978DB35}dGlobalSpacoFalse CreatablPredeclaIdTruBExpo se0TemplateDerivCustomizD'ȡ P Sub CancelButton_Click() notContinueBoolT Me.HDidZEnd! 'ȷq ,onfՏ,-Fl;/HLOʘxME(SPSSS0{0CC52A2F-AA1C-4BDB-8384-5C643F4A1897}{21C39ACE-F73C-44DC-9D3B-0B4736B6FF95}p0(%X0 %0`>ixAttribute VB_Name = "PrintForm"" Bas0{0CC52A2F-AA1C-4BDB-8384-5C643F4A1897}{21C39ACE-F73J4DC-9D3B-0B4736B6FF95}dGlobal!SpacoFalse CreatablPre declaIdTruBExpose0TemplateDerivCustomizDt6DD zL#<3kGdw FNWqAvxNWqAv3kGdw ME(SLSS6"  <,<0<4<8<<<N0{00020819-0000-0000-C000-000000000046}` $`k@8 i& `[@i( VYf[% %  %`@.0,*24@l @\ @0L @x< @H, @` @ @ @ @ @ @8 @ @  @P @| @hl @\ @L @< @, @ @ @( @@ @ @ @<8>i$*\Rffff*0X6af090c4*\R0*#f*\R0*#1*\R0*#17$*\Rffff*0S6af0908f*\R0*#2$*\Rffff*0U6af0908f4 "      )ǷȷϽҪexcel籣棬"$.ȷ"$., $.&ϵͳҪмУ飬粻棬"$.ȡ"$.? 0$,'* * 2A@4dP'(k@o80Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046}|GlobalSpacFalse dCreatablPredeclaIdTruBExposeTemplateDerivBustomizD2 P Sub _BeforeSave(ByVal AsUI As Boolean, _ Cancel)isButtonmMsgBox("ȷϽҪÄex " & Chr(34)"ȷJ ,10ͳУA?", vbOKcC63If L4 0ThenBD@A򲢴z EŠPP= gEnd Irf AiAm rU~| prU ,`a//(`00` a///(`08!`aa (*\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7\VBE7.DLL#Visual Basic For Applications8*\G{45541000-5750-5300-4B49-4E47534F4655}#3.0#0#D:\Software\WPS\WPS Office\12.1.0.22529\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:\Software\WPS\WPS Office\12.1.0.22529\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{6BAA67D4-C853-401B-BACE-2739AD4EE77B}#2.0#0#C:\Users\lenovo\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E.`M  >i  ThisWorkbook0X6af090c4!ThisWorkbookzLxJ  Sheet10W6af0909f7 Sheet1H Sheet60I6af0908fC Sheet60-SbpSȉ0V6af0908fDSbpSȉH]wQQpe0R6af0908fN]wQQpex`ʗXf0S6af0908fXf&xz!hQpe0T6af0908f!hQpe~`p;N z^0U6af0908f;N z^Ux`.ShowForm0O6af0908fOShowFormn1 Sheet50P6af0908fY Sheet5hEPrintForm0Q6af0908f[PrintFormʘH`x0 0sdC# v< J9HN̞N7E\OX-Du%I'|-Kڅ)TFq$hF8aW]IV㿶O>h{YDm#ntIFlAPv*MB2Bb^)Х+L<;ec\!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` (checkGord`resultur`result1`IsEmpty `result2`(checkBirthdayA ` (checkYXYJ ` currentDate;` currentYear( `year6n`month`GetCurrentAcademicYear`(checkS)` (checkBankUw`(checkXn` (checkMonth`(checkBirthday`(checkBirthdayNecessary`(checkPhoneNum` (checkOption,`(sysDifficultyGradeNameFlag`Trim@`(indentifyDateFlag `(checkFamilyIncomeTypel` (checkSqly`aX`(hasErrorIdNum`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` (checkClassU`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~`year1w`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` _B_var_value`_B_var_titleMsg` _B_var_Midp`_B_var_value1J`_B_var_functionArgsArrOj`_B_var_resZjlx`_B_var_result`_B_var_result1`_B_var_result2` _B_var_Datev`_B_var_currentDate`_B_var_currentYear`_B_var_GetCurrentAcademicYear` _B_var_TrimmT`_B_var_a`_B_var_result3`_B_var_result4`_B_var_result5`_B_var_result6`_B_var_result7`_B_var_result8`_B_var_result9`_B_var_result10'`_B_var_result11'`_B_var_baojiaoMoneyColumn<`_B_var_baojiaoMoneySum`_B_var_huoshiMoneyColumn`_B_var_huoshiMoneySum`_B_var_zhusuMoneyColumn`_B_var_zhusuMoneySum`_B_var_othersMoneyColumnk`_B_var_othersMoneySum{` _B_var_addr%]`_B_var_sheet2RecordNum`_B_var_ffTotalNumColumn}#` _B_var_Count:`_B_var_rowNum` _B_var_UCasea`_B_var_babyIDColumnZT` _B_var_Right9`! O7Y [ CE O"@ p0(P'q`XX   ////0I` a///<q`a9/////<`Yaq/////,`//( `/0 ` 09 `  !///,a `9//8`a////,`9//8`a////8`a////0)` a///nrU~~~y     rU~| G a1 y H k !9!q!!!"Q""""!#a## $Y$$$I%%%!&Y&&&day'0TqI')'' (1(((I))*I*** )+++ ,,,---... 00A1i112I223a33 4494!5Y5I56 tY667Y7q7/ 8a889Y9!9Y9:i::: ;Y; <Y<<<YyttYu)=a==>>>9 @@Q@yAAA9BqBB)C?7) DYDDDu1EEFFGIG HH!JyJJQKKKKKGG? L\ILLM PRMAORO TT9UiUUUVIW XQXX)YY)ZqZZQ[[ \ ]Q]Q^^_i_ ``9aaa1bb1cqc dd1eefffIgggcc_[OS+'; hQhhh)iqiijIjjj9k lllAmmnann pp q9qqrrrAsqs9v!w xqwwwsyx!IhxxpxQyyy !yzzIzizzz}}}0  \E @(4%F%T:X %h$hdT)hTv {  x\(/lhTTIDX%h$hdD4A$l)hD54nXT(/lhD4$0   DN$%DX%h$hdDD)hD5V4%DX%h$hdD=6CE)hD6Rf4%DX%h$hdD=-CF)hD6i(/lhDt$GDX%h$hdD$5)hD5$%X/4H/$'S(%DX%h$hdD4=$6C7)hD64$V%DX%h$hdD4=$6C7)hD64$$0/l hD4$t\LR4\%H$Hd4LA$-qc)H46L$l lllL .5LlllL /5Ll lllL .5LllllL /5Lu0h:\+8L:1$:2" |3" |:t4d``P 0/`6L$dPj,t(/lD`H4L$dPL@DX%h$hdD$4)hDB(%DX%h$hdD$)hD:X ]3B(%DX%h$hdD$)hD:H(X]3:N(%H(X$%D%h$hdD)hD  H:X}$$'$ l `6$ :X0H:X}$$'$ l `6$ :X0H:X}$$'$ l `6$ :X0H:X}$e$'$ l `6$ :X0H:X}$  :X0H:X}$  :X0H:X}$  :X0H:X}$  :X0H:X }$F  :X!0H:X"}$s  :X#0H:X$}$  :X%0H:X&}$$'$ l `6$ :X'0X:X(]3lll$ )$Vz*5$ u*{::X+H$:,:-`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:X3]3lll$ 45$lll$ 55$IDX%h$hdD$A4)hD5$(%DX%h$hdD$A:6]/(l%|%$d|A<:L7]/,)hD|6$<4:X ]3z*4$ 8$Vz*5$04$ 8$Vz*5$ u*::X+H$:,:9`.6$z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z2:X]3lll$ 45$lll$ 55$ MX@4$ : $Vz*5$ :X V(%DX%h$hdD$A:;]3)hD6$L(%DX%h$hdD$A:<]<|%$d|A<:l ]<,')hD|6$<Jz* :X= V(%DX%h$hdD$A:>]3)hD6$a (%DX%h$hdD$A:<]<|%$d|A<:l ]<,')hD|6$<_ z* :X? V(%DX%h$hdD$A:@]3)hD6$v (!%DX%h$hdD$A:<]<|%$d|A<:l ]<,')hD|6$<t z* :XA V(%DX%h$hdD$A:B]3)hD6$ (2%DX%h$hdD$A: ]<|%$d|A<:l ]/,')hD|6$< z* :XC  u*,:XDN$$v E5$?(X%$(]/5I'6$t p:X+H$:,:F(%<,:G :lH`.6$<,?(X%$(]/5I'6$H:X+H$:,:I(%<,:J(l%:LG :H`.6$<,?(X%$(]/5I'6$p:X+H$:,:K(%<,:G :lH`.6$<,?(X%$(]/5I'6$:X+H$:,:L(%<,:J(l%:LG :H`.6$<,z/.$ 05$&.MH@ll*MX @l$ 15$z2:X']3 MX@4$ M $Vz*5$ u*M,:XDN$$v E5$?(X%$(]/5I'6$\:X+H$:,:F(%<,:N`.6$<,4?(X%$(]/5I'6$~:X+H$:,:I(%<,:J(l%:LN`.6$<,4?(X%$(]/5I'6$w\:X+H$:,:K(%<,:N`.6$<,4?(X%$(]/5I'6$4~:X+H$:,:L(%<,:J(l%:LN`.6$<,z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]3 MX@4$ O $Vz*5$ u*,:XDN$$v E5$(X%$(]35$~:X+H$:,:P(%<,:Q(l%:LR`.6$<,?(X%$(]/5I'6$D~:X+H$:,:S(%<,:Q(l%:LR`.6$<,::X+H$:,:T`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]3 MX@4$ U $Vz*5$ u*,:XDN$$v E5$~:X+H$:,:V(%<,:W(l%:LX`.6$<,z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]3 MX@4$ Y $Vz*5$ u*,:XDN$$v E5$(X%$(]35$~:X+H$:,:Z(%<,:[(l%:LR`.6$<,(X%$(]35$~:X+H$:,:\(%<,:[(l%:LR`.6$<,z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]]3($ll ^5$:X ]3w::X+H$:,:_`.6$z/.$ 05$:X`]3"X4 az*2 u*::X+H$:,:b`.6$z/.$ 05$ H(X$b 4$ c$Vz*5$ u*::X+H$:,:d`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:Xe]34:HN4:XeN$$ fVz*6$ u*i::X+H$:,:g`.6$z/.$ 05$%lll:XeN$$ h6$&.MH@ll*MX @l$ 15$z2:Xi]34:HN4:XiN$$ fVz*6$ u*c::X+H$:,:g`.6$z/.$ 05$%lll:XiN$$ h6$&.MH@ll*MX @l$ 15$z2:Xj]34$ k$Vz*5$($ll ^t5$($ll ^d5$dEtE<z*YdEdEtEYz* u*::X+H$:,:l`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:Xm]34$ k$Vz*5$($ll ^t5$($ll ^d5$d nt njz*dEtEz* u*::X+H$:,:o`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:Xp]34:HN4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:Xq]3P!4$ k$Vz*5$B( %DX%h$hdD$t)hDB( %DX%h$hdD$d)hDB( %DX%h$hdD$T)hDt:Xr]3; d nz*9 z*::X+H$:,:s`.6$t:X<]3 dETE z*::X+H$:,:t`.6$ z*d n z*::X+H$:,:u`.6$ u*!z/.$ 05$&.MH@ll*MX @l$ 15$z2:Xv]3y#4$ k$Vz*5$B( %DX%h$hdD$t)hD($ ll ^d5$($ ll ^T5$t:Xr]3d"T n"z*b"z*::X+H$:,:w`.6$t:X<]3%#dETE"z*::X+H$:,:t`.6$"z*T n##z*::X+H$:,:x`.6$ u*G#z/.$ 05$&.MH@ll*MX @l$ 15$z2:Xy]3$4$ z$Vz*5$($ ll ^t5$t n#z* u*$:X+H$:,:{"< |<,:}" |:~`.6$<,z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z2:X]3%z*($ ll ^t5$($ll ^d5$($ll ^T5$t n_%d nT n]%z* u*%::X+H$:,:g`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]3P'z*($ll ^t5$($ll ^d5$($ll ^T5$t n&d nT n&z*&d nT n&z*&z* u*'::X+H$:,:g`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]3(z*($ll ^t5$($ll ^d5$($ll ^T5$t n(d nT n'z*d nT n(z* (z* u*|(::X+H$:,:g`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]3)4$ z$Vz*5$ u*):X+H$:,:{"< |<,:}" |:`.6$<,z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z2:X]3*4$ z$Vz*5$ u**:X+H$:,:{"< |<,:" |:`.6$<,z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z2:X]3,4$ $Vz*5$$ $DD$ $4D$ $(X ]Z5$r+:4K#*#4(X$K#0*F 206$$+34(X$K#*#4K#0*F 204 n+:X $:H45$z* u*N,::X+H$:,:`.6$z/.$ 05$ H(X$b ,34h$Xh$Ch5$&.MH@ll*MX @l$ 15$z2:X]3-':XN$$4 : Vz*6$ u*Z-::X+H$:,:`.6$z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z2:X]3T.4$ $Vz*5$ u*".::X+H$:,:`.6$z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z2:X]3L/4$ $Vz*5$ u*/~:X+H$:,:V(%<,:W(l%:LX`.6$<,z/.$ 05$&.MH@ll*MX @l$ 15$z2:X%]3@0.(4:X%N$$ fVz*6$ u*/::X+H$:,:g`.6$z/.$ 05$0%lll:X%N$$ h6$&.MH@ll*MX @l$ 15$z2:X]304$ $Vz*5$ u*0::X+H$:,:`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]314$ $Vz*5$ u*v1::X+H$:,:`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]324$ $Vz*5$ u*p2:X+H$:,:{"< |<,:" |:`.6$<,z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]3t44$ $Vz*5$ u*V3:X+H$:,:{"< |<,:" |:`.6$<, 4($ll ^t5$($ll ^d5$($ll ^T5$(tNdNtNTNdNTN4z*::X+H$:,:`.6$ u*B4z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]354$ $Vz*5$ u*P5:X+H$:,:{"< |<,:" |:`.6$<,z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z2:X]3|64$ $Vz*5$ u*J6:X+H$:,:{"< |<,:" |:`.6$<,z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]397!($B4 Vz*6$ u*7::X+H$:,:`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z2:X]3h8/MH@4:XN$$ fVz*6$ u*7::X+H$:,:g`.6$z/z.$ 05$68%lll:XN$$ h6$4$ $:X ]35$+8z48z&.MH@ll*MX @l$ 15$z2:X]3M:4$ $Vz*5$ u*:9:X+H$:,:{"< |<,:" |:`.6$<,z/.$ 05$z:4uH4$ $:X ]/'6$Hz9z:4uH4$ $:X ]<'6$H9z:::X+H$:,:`.6$z/z*.$ 05$z&.MH@ll*MX @l$ 15$z2:X]3A;.(4:XN$$ fVz*6$ u*:::X+H$:,:g`.6$z/.$ 05$;%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3y=  MX@4$ : $Vz*5$ u*;::X+H$:,:`.6$z/.$ 05$G=;uuH4$ $:X ]/'6$H<E=;uuH4$ $:X ]<'6$HU<E=;uuH4$ $:X ]/'6$H<::X+H$:,:`.6$z/.$ 05$z*E=::X+H$:,:`.6$z/.$ 05$z*&.MH@ll*MX @l$ 15$z2:X!]3n>/MH@4:X!N$$ fVz*6$ u*>::X+H$:,:g`.6$z/.$ 05$<>%lll:X!N$$ h6$&.MH@ll*MX @l$ 15$z2:X]3c?/MH@4:XN$$ fVz*6$ u* ?::X+H$:,:g`.6$z/.$ 05$1?%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3+@':XN$$4 Vz*6$ u*?::X+H$:,:g`.6$z/.$ 05$?&.MH@ll*MX @l$ 15$z2:X]3B4:X ]3U@z*r@4$ $Vz*5$ u*"A(X]3@::X+H$:,:`.6$A::X+H$:,:g`.6$z/.$ 05$A4:X ]/$4:H]/4:]/<4:]/,4:]/4:]/4:]/4:l]/4:\]/A%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3.C4:HN4:XN$$ fVz*6$ u*Bz::X+H$:,:g`.6$z/.$ 05$ H(X$b B%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3(D4:H N4:XN$$ fVz*6$ u*C::X+H$:,:g`.6$z/.$ 05$C%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3F4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDB( %DX%h$hdD$T)hDB(%DX%h$hdD$)hDt:X<]3Ed:X<]3Ez*T:X<]3Ez*:X<]3Ez* u*,F::X+H$:,:`.6$z/.$ 05$SF%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3K4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDB(%DX%h$hdD$T)hDB(%DX%h$hdD$)hDB(%DX%h$hdD$)hDB(%DX%h$hdD$)hDB($%DX%h$hdD$)hDB(%%DX%h$hdD$p)hDB()%DX%h$hdD$`)hDB(*%DX%h$hdD$P)hDB(+%DX%h$hdD$@)hDB(,%DX%h$hdD$0)hDt:X<]3Kd:X<]3Jz*T:X<]3Jz*:X<]38Jz*:X<]3QJz*:X<]3jJz*:X<]3Jz*p:X<]3Jz*`:X<]3Jz*P:X<]3Jz*@:X<]3Jz*0:X<]3Kz* u*aK::X+H$:,:`.6$z/.$ 05$K%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3N4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDB( %DX%h$hdD$T)hDB( %DX%h$hdD$)hDB(%DX%h$hdD$)hDB($%DX%h$hdD$)hDt:X<]3Nd:X<]3Mz*T:X<]3Mz*:X<]3Mz*:X<]3Mz*:X<]3Nz* u*tN::X+H$:,:`.6$z/.$ 05$N%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3P4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDB(%DX%h$hdD$T)hDt:X<]3Pd:X<]3Oz*T:X<]3Pz* u*vP::X+H$:,:`.6$z/.$ 05$P%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3R4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDB( %DX%h$hdD$T)hDt:X<]3Rd:X<]3Qz*T:X<]3Rz* u*xR::X+H$:,:`.6$z/.$ 05$R%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3X4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDL(%DX%h$hdD$:]3)hD5$ Ta(%DX%h$hdD$:<]<t: ]<')hD5$ Tz*L(%DX%h$hdD$:]3)hD5$-Ua(%DX%h$hdD$:<]<t: ]<')hD5$Tz*a(%DX%h$hdD$:<]/t: ]/')hD5$+Uz*L(%DX%h$hdD$:]3)hD5$OVa(%DX%h$hdD$:<]<t: ]<')hD5$Uz*a(%DX%h$hdD$:<]/t: ]/')hD5$MVz* u*XL(%DX%h$hdD$:]3)hD5$V::X+H$:,:`.6$z/.$ 05$XL(%DX%h$hdD$:]3)hD5$W::X+H$:,:`.6$z/.$ 05$XL(%DX%h$hdD$:]3)hD5$:X::X+H$:,:`.6$z/.$ 05$X::X+H$:,:g`.6$z/.$ 05$X%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3Z4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDt:X<]3Yd:X<]3Yz* u*9Z::X+H$:,:`.6$z/.$ 05$`Z%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]39\4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDt:X<]3[d:X<]3[z* u*[::X+H$:,:`.6$z/.$ 05$\%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3=^4:H N4:XN$$ fVz*6$V(%DX%h$hdD$A:]3)hD6$](%DX%h$hdD$A:<]<|%$d|A<:l ]<,')hD|6$<]z* u*]::X+H$:,:`.6$z/.$ 05$ ^%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3A`4:H N4:XN$$ fVz*6$V(%DX%h$hdD$A:]3)hD6$_(!%DX%h$hdD$A:<]<|%$d|A<:l ]<,')hD|6$<_z* u*_::X+H$:,:g`.6$z/.$ 05$`%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3Cb4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDB(%%DX%h$hdD$T)hDt:X<]3ad:X<]3paz*T:X<]3az* u*a::X+H$:,:`.6$z/.$ 05$b%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3Ed4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDB($%DX%h$hdD$T)hDt:X<]3cd:X<]3rcz*T:X<]3cz* u*c::X+H$:,:`.6$z/.$ 05$d%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3?e4:HN4:XN$$ fVz*6$ u*d::X+H$:,:g`.6$z/.$ 05$e%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3g4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDd:X<]3`ft:X]3,fz*t:X]3Efz*t:X]3^fz* u*f::X+H$:,:`.6$z/.$ 05$f%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3h4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDd:X<]3 ht:X]3hz*t:X]3hz* u*h::X+H$:,:`.6$z/.$ 05$h%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3j4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDd:X<]3it:X]3iz*t:X]3iz* u*?j::X+H$:,:`.6$z/.$ 05$fj%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3Xl4:H N4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDd:X<]3kt:X]3kz*t:X]3kz* u*k::X+H$:,:`.6$z/.$ 05$&l%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3Rm4:H N4:XN$$ fVz*6$ u*l::X+H$:,:g`.6$z/.$ 05$ m%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3Ln4:HN4:XN$$ fVz*6$ u*m::X+H$:,:g`.6$z/.$ 05$n%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]36p4:X ]3vnz*~o4:X]/$4:H]/4:]/<4:]/,4:]/4:]/4:]/4:l]/4:\]/4:L]/ 4:]/4:]/4:]/4:]/p`soz*|oz* u*o::X+H$:,:g`.6$z/.$ 05$p%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3+q/MH@4:XN$$ fVz*6$ u*p::X+H$:,:g`.6$z/.$ 05$p%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3 r/MH@4:XN$$ fVz*6$ u*q::X+H$:,:g`.6$z/.$ 05$q%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3s/MH@4:XN$$ fVz*6$ u*r::X+H$:,:g`.6$z/.$ 05$r%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3 t/MH@4:XN$$ fVz*6$ u*s::X+H$:,:g`.6$z/.$ 05$s%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3t/MH@4:XN$$ fVz*6$ u*t::X+H$:,:g`.6$z/.$ 05$t%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3u/MH@4:XN$$ fVz*6$ u*u::X+H$:,:g`.6$z/.$ 05$u%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X ]3v/MH@4:XN$$ fVz*6$ u*v::X+H$:,:g`.6$z/.$ 05$v%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X ]3w/MH@4:XN$$ fVz*6$ u*w::X+H$:,:g`.6$z/.$ 05$w%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X#]3x/MH@4:X#N$$ fVz*6$ u*zx::X+H$:,:g`.6$z/.$ 05$x%lll:X#N$$ h6$&.MH@ll*MX @l$ 15$z2:X]3y3MH@4:XN$$ fĔ6$gy::X+H$:,:g`.6$z/.$ 05$EMH@4:XN$$ f.M@lll 16$z2:X ]3z.(4:XN$$ fVz*6$ u*Sz::X+H$:,: `.6$z/.$ 05$zz%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3{/MH@4:XN$$ fVz*6$ u*H{::X+H$:,:g`.6$z/.$ 05$o{%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3|/MH@4:XN$$ fVz*6$ u*=|::X+H$:,:g`.6$z/.$ 05$d|%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3}/MH@4:XN$$ fVz*6$ u*2}::X+H$:,:g`.6$z/.$ 05$Y}%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3~/MH@4:XN$$ fVz*6$ u*'~::X+H$:,:g`.6$z/.$ 05$N~%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3u/MH@4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$C%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3j/MH@4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$8%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3%/MH@4:XN$$ fVz*6$@DX%h$hdD$t)hDB( %DX%h$hdD$d)hDd:X<]3mt:X]3Rz*t:X]3kz* u*́::X+H$:,:`.6$z/.$ 05$%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3/MH@4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3/MH@4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$݃%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3/MH@4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$҄%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3/MH@4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$Dž%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3/MH@4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3/MH@4:XN$$ fVz*6$ u*::X+H$:,:g`.6$z/.$ 05$%lll:XN$$ h6$&.MH@ll*MX @l$ 15$z2:X]3 (X$ )4$ !$4(X]<'5$̈"4$"XPP@3j04$0LjP 34$LjP34$LjP3Lj4$#(X$#$$:X%$5$z28/ lP @p4`tP 4@00Dd T"0hD|$<, p`l 'X ( X4h5XcH%h)8%h*fH%h+hX,lchTl,/lhX0   ( hXl,CTpzoX @%%:8>%HhL$LdH9 ?@AB4P)LH6lPclT<0PW;Upz5PWCUpz5(4/ThXP LHtL:\ ]3Dl< <:\ ]35<B c\l (\ [%:L8%(\%$d<9>,:A;)6<, f\l<L%(\% =$Dh\N @(%(\%$d<3)5<H (\< O\ ~$t <(\,5:A;)86<%((% =$D\\hd`N @(%((%8$8d3)85L((S` ~d$\T\((5h4{VT @(%((%8$8dAKF$)86$kXQNcknx_{:NIlW[ ^'YN1 NǏ20*NW[&{ hg [^mSu`c /f $[^*gmSu`N_kXQmSu`c0 [^mS͑'Y6q~p[c ,[^*gmS6q~p[N_kXQmS6q~p[c0 [^mS͑'YzSaYc [^*gmSaYN_kXQaYc0  k:PSV &[^ k:PёN:Nzze k:PSV_{kXQ0 .kXQNcknx ySN:Nzz0kXQ R^_{:N MO hg 2,3,1 4kXQNcknx ySN:Nzz0kXQ R^_{'YNI{N MO NNǏ &kXQNcknx yN:Nzz N^_{:N ,kXQNcknx yN:Nzz N^_{'YNI{N &MONS:NIlW[ NS+TyrkW[&{hg HkXQNcknx ySN:Nzz kXQ R_{:NpeW[ 'YN0 tepeMO^NǏ MO N\peMONǏ MOhg @kXQNcknx yN:Nzz N_{:NpeW[ 'YN0 tepeMO^NǏ .kXQNcknx~TċT!kNǏ~Tċ;`T!k `kXQNcknx yN:Nzz N_{:NpeW[ 'YN0 tepeMO^NǏ6MO N\peMONǏ2MOhg $kXQNcknx y_{:NpeW[ 'YNI{N NNǏ hg 8kXQNcknx ySN:Nzz kXQ R_{:Ntepe 'YNI{N  N^NǏ 0kXQNcknx yN:Nzz N_{:Ntepe 'YNI{N checkSfzjh &kXQNcknx VNN{|W:Nzzhg E\lN *kXQNcknx y_{:Nf[uNShg HkXQNcknx yN:Nzz N^_{'YNI{N1MO NNǏ18MOhg checkZjlx kXQNcknxhg checkPmlx checkGord 8kXQNcknxcTT!kNǏcT;`Npev~vRKNNAShg checkClass 4kXQNcknx_OS?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_acdefghijklmnopqrstuvwxyz{|}~/f&Td[?QN[eNb{Q hg checkXf (checkfamilyHouseType $checkfamilyCarType 1,2,3 2,3 checkYesNo10 checkYesNo11 checkYesNo12 checkYesNo13 checkYesNo14 checkYesNo15 checkYesNo16 checkYesNo17 checkXf1 kXQNcknxyN:Nzzhg $checkDisableLevel1 "checkDisableType19x  4checkSuortMembersDescribe1 checkParentJobs1 &checkParentCulture1 checkParentAge1 4checkFamilyDiseaseDescribe 6rkGW`͑'YuuN+Tku 6rkNe`͑'YuuN+Tku $ kXQNcknxkXQ6rk/f&T`͑'Yuuhv ]R d[?Q RhvN b6rkGW`͑'YuuN+Tku T6rkNe`͑'YuuN+Tku hg 6checkFamilyYearIncomeRange1 4checkFamilyYearIncomeRange checkHj 0checkFamilyDisasterTime1 *checkFamilyBurstTime1 (checkFamilyProperty1 &checkFamilyProperty &checkInSchoolCount1 (checkAtLeastOneNNull  Test9. 9b 9) @9! `9 9  0^[\u4e00-\ue863]{1,20}$ VBSCRIPT.REGEXP GlobalPatternIgnoreCase9 Comment L ,{ R `eQvW[&{ "-NS+TNzzixAttribute VB_Name = "She@et6" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTempl     !"#$%&'()*+,-/0123456789:;<=>?ABCDEFGHIJKLMNOPQSTUWXYZ[\^_`abcdefghijkateDeriv$Bustom izD2?h#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0>i xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2 8/=H#<jXO=~& FpaDet[WzxpaDet[WzjXO=~&ME PSLSS0<6"<<<N0{00020820-0000-0000-C000-000000000046}( 8` @d ):`h %i( x%%6%@hd>i*\R1*#119$*\Rffff*0W6af0909f4  "  &  HX`p xڵԪʱT Continue? >Hi$, @61A@,4k 123A@4i@oxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2'ڵԪʱ P$( Sub Works_BeforeDoueClicka(ByVal Target As Range, @CancelBoolean) If MsgBox("Continue?", vbYesNo, "Hi") Then3  " End If CDec23n@48C'((j~xME,6 LL <0<4<8<<<0% ` @ Ih `[@IR IT `V 0`0`J<`:  ` ` ,,Il I @2 0 `  Il @2  ` p Il @2   `  Il @2 ` ` Il @2 0`  Il I @2 ` p  Il @2  `   Il @2  ` `  Il @2  `  Il @2  ` P )Il @2 @  ` ;I  I  D ` `  II  I   `  TI  I   ``Pk` ^Il  I @2 0`#,k |Il @2, ` p Il I @2 H`  Il (I  `  Il I  H`  &&Il (I  `   Il @2  `   Il  ` `  Il @2  `  Il @2 !` P ! $Il @2 x"`  """0I IR Ij ` ` `````@ ` @ ` @  `  @ #` Pk #""RIl I @2 $` P $ tIl @2 800 H   0  H H0x(  %p88pP@l `8Z.@h @X @H @8 @( @ @ 8 @l @L 0@< P(0`z @`th(`jpHP79058421637905842 10X98765432@` @P @@ @( @ @X p0@ X@ @ @ @ X@  @l @L 0@< 0@l 0@H\ @L @< `  hP8@l (04@\ @X @H @8 @( @ @@ @ @( @X @p @ @ @ @ @ @p @ ` @P ! ! !P!! @l  40@8!\ @X @!H @h!8 @!( @ @! @p" @! @" @(" @X" @@" @ @" @ @"p @"` @P p###p###@l #p#@L 0@< $$$$%$@l $$@$\ @L @< 0%%h8>i$*\Rffff*0T6af0908f*\R1*#3cb*\R1*#30d*\R1*#119*\R0*#f*\R0*#9*\R1*#118*\R1*#2c8$*\Rffff*0R6af0908f*\R0*#14*\R0*#10}  B       (  B "   08 @HP XB p,x 5 G - B     8HPX`h pB     (0 8&  ( 08@ H  B  ( 8@ HPX `   B   ( 8 @ H P X h x     B ( 0  8       n   B  , $ "+ @ H(X       "2  .0H"?`  4S h B     p    ( H PX`h x   08@H P  B  *HX`hpx  ( HB  `hp  H hB  6 |  B  0 ( x0  B     (08@`px x  0B  HPXx | 0 PB  hp$x | X xB  f (08 |@  B   08@HP X  B  (0:8x     B           ( 0 8 . B  ! ! ! (!8!@!H!P!X! `! ."B  0"8"H" X"h"p"x""" "B #6 # 8# @#&P# x#####: ##  ##  $ $$D$4p`$ $ $$$7$ $$%%% B % % (%  8% @%H% P%: X%%  %%  % %% % %B  `&h&& &&&&&&&&:&(' 8'@' H' P'X'`' h'B  ''( (&((P(X(`(h( p( ((( ((D(4)P) X)`)h))))))) )B  X*`*x* **** ** "** + <+H+P+ X+`+ h+B  , ,8, @,&P,x,,,, , ,", ,, $, " - H- X- `- h------ ->- (.4H. . .. .. . 0/ P/B  h/p/x/////// / X0 x0B  00 0 000 0 X1 x1B  11 1111111 1 2 2B  22223333 3 (3 3 3B  344(484@4H4P4X4 `4 5 05B  H5 &P5 $x5 5 5&5*5"(6$P6x6(6667 70787 P7 2h77"778  8(8@88X888 8B (9609H9& P9 x9 9&9 9999D94p :X: h:p: x:: :::7:: :: :;;;; ; (; ; ;B  ;;;<(<0<8<@<H<X<-----------------------------------------1 ,дϢʾ Ϣsheet--------------------------------------- ʱ0Ϊʱ1 Ԫ] R T h$H%Z'V V'd'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseʽȷtrue]^[\u4e00-\ue863]{1,20}$'2 2 l$0'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]))))$'2 2 l$0'd'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------H l$'zk]reg = "^((19)|(20))\d{2}-((((0?[13578])|(1[02]))-((0?[1-9])|([12][0-9])|(3[01])))|(((0?[469])|(11))-((0?[1-9])|([12][0-9])|(30)))|((0?2)-((0?[1-9])|([12][0-9]))))$"^(19|20)\d{2}-(0[1-9]|1[0-2])$'2 2 l$0'd'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseʽȷtrue] ^\d+$'2 2 l$0'd8'k(i -----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseʽȷtrue8 'z8k0]^\d+$'2 2 l$0'd'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------]^((19)|(20))\d{2}-((((0[13578])|(1[02]))-((0[1-9])|([12][0-9])|(3[01])))|(((0[469])|(11))-((0[1-9])|([12][0-9])|(30)))|((02)-((0[1-9])|([12][0-9]))))$'2 2 l$0'd'kxiph-----------------------------------------4 У֤---------------------------------------Ϲ򷵻trueϹ򷵻false(]790584216379058420Ȩ] 10X987654320У $$''ȥո] j  6)׶֤Ϊ,ΪͨУ'zk Gzj $$Gzj *[0-9X]Gzj J  J$' G 'j   J$  '  ' $ \  $G'ji-----------------------------------------2 У ҪΪĸ-------------------------------------------------------------ʽȷfalseʽȷtrue  l$'zk] 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}$'2 2 l$0' l' J  l$ J$' J ,'zk J  ,'zkd ,'zxkpkh P J  l$ P$'   ,''zk P Jd'kiz-----------------------------------------У֤ -------------------------------------------------------------ʽȷfalseʽȷtrue]"^[\u4e00-\ue863a-z|A-Z|0-9]{1,18}$'2 2 l$0'd'ki----------------------------------------5 -УѧУѧУʶ 42λһλΪֻx-------------------------------------------------------------ʽȷfalseʽȷtrue0]^[1-9]\d{40}[\dx]$'2 2 l$0'dP 'k@ i8 z----------------------------------------6 -У黧 -------------------------------------------------------------ʽȷfalseʽȷtrue].^(\u519c\u6751)|(\u53bf\u9547)|(\u57ce\u5e02)$'2 2 l$0'd 'k i u-----------------------------------------7 Уѧʱ-------------------------------------------------------------ʽȷfalseʽȷtrue ]'^(((19)|(20))\d{2})((0[0-9])|(1[0-2]))$'2 2 l$0'd 'k i q-----------------------------------------7 У-------------------------------------------------------------ʽȷfalseʽȷtrue l ,ΪDZ'kzk]^((19\d{2})|(2\d{3}))$'2 2 l$0'd'kpihq-----------------------------------------7 У·-------------------------------------------------------------ʽȷfalseʽȷtrue0]^((0[0-9])|(1[0-2]))$'2 2 l$0'dh'kXiPv-----------------------------------------9 Уѧ-------------------------------------------------------------ʽȷfalseʽȷtrue] ^\d{4}[0-7]\d{3}[0-3]\d{7}$'2 2 l$0'd@'k0i(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'2 2 l$0'd'kiv-----------------------------------------11 Уп-------------------------------------------------------------ʽȷfalseʽȷtrue ] ^[1-9]\d{14,20}$'2 2 l$0'd'ki-----------------------------------------checkXn Уѧ磨2012-2013-------------------------------------------------------------ʽȷfalseʽȷtrue ]p ] 1^(20\d{2}-20\d{2})|(19\d{2}-19\d{2})|(1999-2000)$'2 2 l$0 l-$'$$ 'd0'k d'ki-----------------------------------------checkOption У鱸ע磨Сvalue2-------------------------------------------------------------ȲС200false 򷵻true 'zk   'd'ki------------------------------------------------------ȽϴС(Сڵڷtrue)----------------------------------------------------------------'value1value2false 򷵻true X' X'   'Dd 'Dk i ------------------------------------------------------ȽϴС(Сڵڷtrue)-dec---------------------------------------------------------------'value1value2false 򷵻true $4' $4'   'd'kxip}------------------------------------------------------У鳤--------------------------------------------------------------- ,$'' l$/ΪDZ'kxzpkh] 1^[\u4e00-\ue863a-z|A-Z|0-9(),.]{1,200}$'2 2 l$0'd'zk ,-±0ʼֵΪָάõ± l$$4 l$$4'zXkPd˵У̶ l$$4'zkki ' l'zk]2^[\u4e00-\ue863a-z|A-Z|0-9(),.-]{1,300}$'2 2 l$0'dH'z8k0i(}------------------------------------------------------У鳤---------------------------------------------------------------0 ,$'' l$/ΪDZ'k0z(k ]1^[\u4e00-\ue863a-z|A-Z|0-9(),.]{1,200}$'2 2 l$0'd'zki}------------------------------------------------------У--------------------------------------------------------------- ,$'' l$/ΪDZ'kzk l$& Ϊzh l.e+Сz8k0 ,-±0ʼֵΪָάõ± l$$4 l$$4'zkd˵У̶ l$$4'zHk@k8i0------------------------------------------------------УֵΧ---------------------------------------------------------------H ,$'' l'z`kX l$) Ϊz0 l$4e) С0zk l$4$$4 l$4$$4'zki------------------------------------------------------Уֳ(Number,ΪҲΪСС0)--------------------------------------------------------------- ,$'' l$/ΪDZ'kxzpkh l$% Ϊz@ l$4e% С0zk$'+󳤶$'.Сλ l.''' "˵ûС l$4' $$4'z8k0d С l l. $'DԪֵλ l l. $' $$4 $$4'zpkhk`iX-----------------------------------------checkIsInt У鲻С0-------------------------------------------------------------ʽȷfalseʽȷtrueH] ^0|[1-9]\d*$'2 2 l$0'dP'k@i8-----------------------------------------checkIsNumber УΪNumber-------------------------------------------------------------ʽȷfalseʽȷtrue' l$'k@i8-----------------------------------------checkMoney У0-9999-------------------------------------------------------------ʽȷfalseʽȷtrue ]^(([1-9](\d{0,3})|0)|0)$'2 2 l$0'd 'ki-----------------------------------------checkMoneyTJ У0-9999Сһλ-------------------------------------------------------------ʽȷfalseʽȷtrue]^([1-9]\d{0,7})$'2 2 l$0'd'ki-----------------------------------------checkPersonNum У׶԰һ------------------------------------------------------------ʽȷfalseʽȷtrue]p^(([1-9]\d{0,3}))$'2 2 l$0'd'ki-----------------------------------------checkIdNumLink У֤ԱͳûдǷһ------------------------------------------------------------ʽȷfalseʽȷtrue If colIndex = jhrIDColumn Then checkIdNumLink = True Exit Function End If](%Ա֤ǷӦ]@$ں֤ǷӦ]Xڵһγֵ±]p"Ա,Ԫ֮ڵ]$ݺŽȡ]!,Ԫ֮ڵ]"ݺŽȡ]#]%·]0H]` $' $' (ڶλΪΪ R  $`,ZdڶλΪżΪŮŮ R  $`,Zk $' $' $'  -  -  R  $`,Z'i` }------------------------------------------------------У鳤---------------------------------------------------------------x ,$']^[\u4e00-\ue863]{1,300}$'2' l$/ΪDZ'k8z0k( ,-±0ʼֵΪָάõ± l$$4 l$$4 2 l$0'd'kxzpkhd˵У̶ l$$4 2 l$0'd'kzkki-----------------------------------------У鿼šѧšѧ -------------------------------------------------------------ʽȷfalseʽȷtrue]p^[a-z|A-Z|0-9]{1,40}$'2 2 l$0'd'kiAttribute 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( 'MsgBoxcOApplicao.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"11Y0?2q )))p;[1[Oh8 cEAJ9P߄W]]..A..l*.AJ,1..^...?|(.R2.(2.).^9V|`9T90|8-8ik?i?i''\V!@[QgGord:*O "^\d+??2>{4/ckClass#j`Sai*? 5?#egZuS ZoZF/Zq,ZZNecess_0ς/xSS/x?{3/x/x1NOS  24-2a֤<Ϲa#88'Iu IsIDNumb4ByP , Index As String)Boolean Const W = "790584216 3$"T '@Ȩ tc t10X987605432h9 '@У8 IDNumberkUCase(Trim()) 'ȥ1Dim shIntegerh, i T1I@f colI= babyIDColumn And@"" Then9׶֤Ϊ,Ϊͨa0!l IsgTrue Exit Functio:E@fVLen <> 18KNot<eric(Mid, 17jaLike "*[0-9X]C#*For^= 1 To 17mBTs!Wf )7G+0310Gss + 0Bi * T NextCs M`od 11CRPightI@)#c, TAD)PkOc hv'-%2B ҪΪ0ĸ& 'ʽȷfals@Bt2 checkSqly(value, a21mB$_c)G(F#_ECZ !vrdeg '  "^(([1-8])|[,]{1}Udz _ _ )@$";0A.,15}e CCFAH(, DA#<K`:yCscn}^L"ji"|2_ #``n",`VSV( "=! Y pac E)߿} )Q:jiPq[ mPj[$ mbs0  ayDZ Q^ j#i*IDG!%PPSTB[ ~ /[/[؃/[ [FZJLXC[dtTT[\u4e00-\ue863a-z|A-ZF|P|@U,18=ck==kSU6/O-5!3- ѧP0ʶ 42λһΪֻx???auchCodeO$oG1-9]\d{40}[\dx]VOVkS_6 d1fo o-6(ʟ1___PFamTyp_jC, p\u519c\`u6751І3bf\u95477ce@e02)k?g?7  2ѧʱ?RXDat!((19@20))02})((0a12])OJJ3?;V?//$CYearG, fArgsA rrDc{vaZlue = "" Then  If functionArgs(Arr0 'ΪxcheckYea!nTrueJEnd Ifxit F| .Dimp reg ^((19\d{2 })|(23}p))$"$&C Z( , va)\ElsayFaQ`'-%7 У`·ݦ 'ʽȷnfQ te) 4Month(EMJZMZ0[0-9]Y12]YGZ ZK9[ѧQQ[XJH[d4}@Y7]@3A7}\C-?$$10#[఺8- ^[PhoneN$um~.\b@(([38 -\4[57]5/5_)`1*80 0@2[D\d`-[2\d*@0[3b)\b?1}7O80$118пe 8!8Bankf[1A.14,20deA]-d,! XnC瀣2012-3? 8. _wby`~sb&b20 22}p r0y-Gz199900ozckioz2Split , "-")s]0R(1) - 0)01 6= ۊhp= " ߂?-- Op!C#ע#Сڂ|~2_#P#"200Vck z12Q2 1@4h >E5Len4 ) >2!rL ?#rD? '+! q `OȽ С()s &¦  !*compa!m(B) >= CDec(1)) Ap < 2 ތ TN ͍g '˵У̶PB 8Ca8,87DՁ=ax e BYXYJ<&h-I}-3'{{{-{3{{$!+{d{S!i6'-0Z!Z:mFFamilyIncomeTypeG, )g8l(Split, ","hH QQ!,,_%3A9A^g//u A /o!_q@q 0 /0?+-!0-0Int_/gs_/eP_/_//@,G..K-k w@ Not IsNumericSC㤲 D"1(A InStr".") <> 9Сo/ m Ѱk @p( |]3M-KoFrKֵΧKVal2qKKKKK`K'G=A/Fe/F,FoQ2F" @F=JFС0=/'# )?@=0D"2@hen checkVal @= True Exit Functio End` If B'-2Уֳ(Number,ΪҲ СС0)3i Z :(value, fxArgs)# ArrSplit( , ","-FalbsIf 7 "8" TԀ :(0 )0 'ΪDZH zr~ (Not IsPericQ)H(Ϊw'GICDeF<|= EJe a.Mid31, 5 - EԪ[āGλ6H + &?/ @(1)) A 442*a5,51e %bIs} ƃ4e0ʽȷf#'etK̂JDDim 8reg=N"^0|[1-9]\pd*$"#>CA! (,l /Jhi?A?t`{Bª_/???ckrij = 8lyu??_Money 0-9E_?__ ++((+(\d{0,3})|0!_,k_,*H_,,V,TJ=#tһλ??TJDD7})??+`j__/Pers on@D׶԰һooo`v O101ck]OIdLink֤ͳдǷһOooo` (, rowIndex, col'fxjhrIDColumnt' F0+voJ!isGe rRight As Boolean &'CEϡ Ӧ BirthUAs Boolean 'ں֤ǷӦ Dim length2 Integer 'rһγֵ± jgenderValuerString 'Ա,֮ڵ91 tŽȡ6birthos9V8year , Variant kmonth,  day,  arr1 = Mid(IdNum, 17)GI= @ 8E If J Mod 21 Then 'ڶΪΪESheets(sIxn1).CellsP(rowB,C@olumn)@""ElseILżEŮr HŮInd IfF"$G@,bZq@c, 4d 5, 2 Q kI &VB` + "-" +UAcheckKLink`True E "Function '-0У鳤Lȟ: % SpLen(v, fArgFs+ArrS plit(, ","hregg#"^[\u4e00-\ue863]{1,300}$HFaYg n" "lghS`(0d0r'Ϊjc9 a;]Epxit >UBound),A2Dȴ0ʼֵΪָάõf <) >@= CDecm(`1)) AUH<}T2@'=CKaa (, B6)b?/! Ab]I?.?~bY'˵=̶Q= {s"bgm=.^.;q:Z/U!šѧsŁ?`bʽȷfP'Q5teu ?\\XYX08R^[a-z|A-Z|0-9W4wW_"_"3WQkxME(6 << <x F` Dp%H@>i$*\Rffff*0V6af0908f"   ( HhxѧϢӡģ$H(JѧϢӡģ$HB@LѧϢӡģ$H(JoAttribute VB_Name = "Ԥ" Sub Browse_Print () Worksheets("ѧϢlģ").VisiblaTrue"d^P@review2cEnd t1(2ėxME<> LL  <. P` @ IR `\OIT L`V \`k i^ f`p+$k8 Ih XIR xIj  n`   i^ x`,k8 !Ih XIR xIT- Iz  X`x k  (Ih IR 8IT  8`Pk 3Ih I IR IT I  `kx HI Ih IR IT I@  0`X(kX I2 xIl `4h > `  I@ +V `%kP Ih pIX iZ,`\P  `p"Lk Il (I HIl# @n v `  Ih Ir  ` k@ %Ih0 `IR Ij Il@  @ ` ,Ih  Ir   `@k 0Ih  IR  Ij  Il    `((k@ 5Il ` Ih@   IR  Ij @n\ @L @V < `kH RIh h IRH  Ij `h`f`H d@  X8 N %`(0hH@l X0H@h @X @H @D @4 @$ @ @ 0H@l H@xh @`X @H @D @4 @$ @ @ @\l db`@h @(X @T @@D @X4 @p$ @ @ 0(HXp(`x@X@l h@H@h @X @ H @8D @l4 @$ @8 @h @ @ @ @h @ @ .@ @ x\@P @| @l @\ @L @< @, @@ @ f@ @X @p @ @ @ @  @ @ @ .Z@t @d @T @D Z@P4 @0 @ @ @8 @P @h @ @ ,.@ @ @ @ x @ p @0` @P @@ @0 @ @ @ @ @0 @ @H @x @` @ @ @p @` @P q@@ @x0 @ ` @" @$@ @&H @( @* h H`@l pH@T H@P @(@ @< @, @ @@ @ xXH`0@0l  6@X @xH @8 @( HH H`@l pH@\ @L Hx.\@H @(8 @4 @X$ @@ @p @ @ @ @ @ @ @ @0 @t @` d @` @P "!8!h!!!!P!0!@l @!!H@!h @!X @@"H @D @!4 @("$ @ @ @ @X" @ $$hHP$`%#x#H#$##(#@l 8##$@`#\ @$L @#< Dt`V@h$, @p @# @ @ $ @8$ @ @r @ @J# @$ $$ @% $$ (%$@P(t @8%d P%%@T %8%@x%P @L 8%&x&@&&''8'@&&X&`Vzh&@&&@hh &x&@XX &&`ZT&dhH@ 'L @H @P'8 @h'( @' @' @' @' @ @' @( @ 8*+ ` ( *)x)0)P*()(@l ((h*`DtV@`)8 @H)( @) @ @) @) @ @p @) @* @0+ @r @J) @x*t *P*@*d *x**x* @PT @*D +*@4 `+*@*$ @H+ @ *x,8X`,,x,,H,(,@fl 8,,H@,h @,X @H @D @,4 @$ 8xX-.----@xl --H@(.h @.X @@.H @D @X.4 @p.$ @ @. @ @ `  >i$*\Rffff*0R6af0908f*\R1*#3cb*\R1*#30d*\R1*#268$*\Rffff*0S6af0908f*\R0*#f$*\Rffff*0T6af0908f*\R0*#14*\R0*#13*\R1*#119*\R0*#17*\R1*#0*\R1*#31*\R1*#35*\R1*#4eb B       B E B h Ip B  ( 0@2` p  B 8 8@ $Nx 8V "R pB x 8G%$S$V HP xXB 4R(0*X$ 8BP0h!  ( 0 8 @  B  @ 4B $H  "Bp    "N   . $  0 0@ $p  * $  . $  8.H x 0  6 0 @6X  8  6 P `(x   0$ ( 0  f8   >:&8 ` Xp& h `*x* IX P`hp j:&  HXh&p ` **8 h 4VJ  , HP <VXJ  4 (0  <V8Jx  (    ,VH8  .     , H?(p0 HB( HB(|p HBp( X  &` & ` ( @ X ,` H?x(\ HBX(~ HBX(\ HB0 (~x  (! &0! X!h!&p!! n! " " 0" ,8" 8P"(~" HB@#(~# 8$(:@$ $ &$ %%&%8% b@% % % % %,%~&&& & ,&'&'(' f0' ' ' ' ' ,' 8((~8( 6"((~) ) &) ))&* * f(* *(* * T:* &8+ `+p+x+ $"+ & +$X:+$&8,$ `,$p, ,, ,  ,$t:,$& -$ H- X- $`-h- &p-- ^- -"4. 8.@:@.&. .. %..&./  ^/ p/"4/ /@:/&/  000 %80X0&`00 ^0 01 1(1 @1P1X1p1x1  1f:1&1 2(2&02P2 ^X2 2222  3(303 83H3 P3  X3b:`3&3 34&4(4 ^04 4"44 4@:4&5 @5 P5&X5x5 ^5 55 B6B(6BH6h6 x66 66N:666  77 7\:(7777 77N:7 88   8 8&8 88&89 ^9 p99 B9999 9: ::P: :p:x: :::\::;;; ;0;P:8;;;     ; &; ;;&;< n< x< << < <<<  " =(=&= ===&> >     (>8> @>X>p> >>>>>   >@:>&? @? P?&X?x? ?? ??? ??@@   @(@H@P@X@`@ h@     p@@:x@&@ @ @&@A   A0A 8APAhA AAAA AAA AAB   B@:B&PB xB B&BB nB (C HChC " xCC&HD pDDD&DD nD 0E PEpE " EE&8F `FpFF&FF   dF G0G @GXG  `GxG  LGG 2G :(HHH 4PH 3HH  H8HH I  " I:0I&I IIJ 4J3HJ`J&hJJ bJ J'K (K z:0K &K K KK&L L f(L LL L t:L &0M XM hM xM&MM bM N 0NHN XN~`N&N O , OPO&XOxO ^OO .O P@: P&`P PP %PP&PP ^P PQ pQQ QX:Q&Q R ,(RXR&`RR ^R R S S 0ST:8S&S S ,SS&T T n(T T TT" TU&U U ,UV&V(V j0V V VV VV WWWW0(W X :XXX   " X &X YY&Y8Y n@Y Y YY" Z(Z&Z ZZ[&[([ P0[[[ [[&@\ h\ .x\\&\\ R\0]!H] `]X:h]&] ] ,](^&0^P^ bX^ ^$/^ _@:_&H_p_ x__$%_,____``&`0` j8` ``" `a&a aaaH4a  bL7(b xbb :b &0c Xc `c pcxcc&cc Zc d. d @d@:Hd&d dd%dd&de je "e e e e d:e &Hf pffb;f h>f ,>Xg :g & h Hh Xh`h :hh &(i Pi `ihipi&xii ^i j&/j @j@:Hj&j jj&%jj&jk Z k k&/k k@:k&l 0l@l&%Hlpl&xll Zl m' m  8m@:@m&m mm Lmn&n8n   j@n nnnnno  o oF:(opo@:xoo&o oo~p<%ppp&pp |p xq$4q q(q@:q&(r Pr`rpr"%xrr&rr |r Ps"4hs s@:s&s tt %t8t&@t`t   |ht t"4u@(uBHuBhuBuuuu u uu u uv vv  v:(v&v vw %w0w&8wXw   |`w w "4w 2 x @Xx BxxBxBxBxBxByB8yBXyBxyByBy yyy z zz  z (z8z @z HzXz `z hzxz z zz z zz z zz z zz {{{  { ({8{ @{H{  P{n:X{&| |} %}(}&0}P}   |X} }"4}  ~@0~ BP~Bp~B~B~B~ ~    0 8 @P X `p x     :&  %Ȁ& | "4 @؁ BB( H  X h p x     :&@ hx %&ȃ   |Ѓ P"4h  @  BBЄ           0 8 @    H:P&  % @&Hh   |p *4 @@ ,L` .aȇЇ ,L؇ .a8@ .aHx  ,L .a .a08 @   H ,LP:& 0,O@:p&  ,O0:`&  @:(&h  (%،&   |"4 @ȍ  B       ( 0  8  @j:H&  %& @   |H ȏ"4@  B(    H  X h p  x  j:&  0 %8X&`   | 04( <VXJ   `:&h .%ؓ& | ,4 :VؔJ hpx  @:&ȕ *%8&@`  |h "4 @(  BHBh       ȗ З  ؗ   :& Ș %И&  |  "4 @  BB @  P` h p    :&H p %&Л  |؛ X*4x @:& ((%0X&` | (4 @H  Bh   4О ؞ 6  <(h p x  ~:& 0@&%Hp&x  |  *4@ @p  B   &  ( ( 0  8z:@& (%(&0P |X أ&4 @  B8 X   h  " Ȥ Ф  ؤz:&` $%ȥ&Х  | "x24 @ئ  B   2(` h 2p    z:ȧ&H p0%& | h 4x @:& % @&Hh  |p ,4 @@:H& *%ȫ&  |( ȬجЭح   @:&@ hx(%&Ю |خX /p @:&د  %8&@`   |h / @:(&h  %ȱ&б   |x / @:&  0 %8X&`   | /  @@:H&  %ȴ&   | / е@:ص& @P %Xx&   |( /@ `@:h& з %&0   |8 /и @:&8 `p %x&  |ȹ H /` @:&Ⱥ  %(&0P |X ػ$/ @: &` $%ȼ&м d ` 3x@:&ؽ 2EP VX .   N:&8 `p%x& Zȿ ((/H p@:x& (% &(H ZP &/ @:&@ hx&%& Z "80/` @:& 0%H&Pp Zx &/ @: &` &%& Z X(/x @:&  (%(P&Xx Z $/ @:(&h $%& Z "`0/  @B (0 8 *@p x   :&H p0%& Z  $H0/p @:&  0%(X&` V / @:&X %& Z H./h @:& .% P&Xx V */ (@:0&p *%& Z p*/ @:& 0@*%Hx& Z (/( P@:X& (%&( x0 6.)0 @( H2X( h1x( 2( 1J8PX`h fpB  <( H`$$ \ B  , 08@h" ^ 60h0HXx "@ h .B  $Bo @ P ` p x  8 P h B "    8[0 h2p N   $ F_8   *  B  * 4@ HB < J (  B  *0 8B < J B   "R 8[02h N   $"V00X M(^(Y&Y HP Xh pB V( 8 M :4H$ ""J  -----------------------------------------УУдϢʾ ע----------------------------------------------------------- Ԫ] 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@'X================================= ִ֤У================================== checkPmlxKT checkPmlx l1$'  R е дȷ''(УʱдϢ A@\d checkPmlx h R TA@k h  R T A@'X================================= ִ֤У================================== checkGordKT l$' h R$f' h R$f' X X ' X X X e'k  R е 8дȷβܳİٷ֮ʮ''(УʱдϢ A@\k h  R T A@'X================================= ִ֤У================================== checkClassKT l$' h R$f' h R$f' $ $'k X X 'k  R е 3дȷ޿μܳ޿ ''(УʱдϢ A@\k h  R T A@'X================================= ִ֤У================================== checkYesNoAKT checkYesNo l1$'  R е дȷ''(УʱдϢ A@\k h  R T A@'X================================= ִ֤У================================== checkSNumYNKT l$' R h$H%Z' R h$H%Z' R h$H%Z'  $'dh' R е  дȷۺϿαΪ'kk  X X ' R е .дȷۺϿβܳۺϿ'dp'k` $' R е  дȷۺϿβΪ'kk errorMsg = "" & rowIndex & "е" & titleMsg & "дȷҪдۺϿۺϿβܳۺϿ"'(УʱдϢ A@\k h  R T A@'X================================= ִ֤У================================== checkSNumYNsKT l$' R h$H%Z' h R $f' h R $f'  $'d ' R е "дȷۺϿαΪ'k k  X X ' R е .дȷۺϿβܳۺϿ'd 'k $' R е "дȷۺϿβΪ'kp kh '(УʱдϢ A@\k h  R T A@'g=================================ִеijУ飨==========================================ѴϢдбcheckBirthdayAKT" l$' h R $f' $'k 2Уʧ R е дȷдʽΪ"$.xxxx-xx"$. 2013-12''-УʱдϢ A@\  'k h  R T A@'checkLSKT' h R $f' h R$f' h R$f' $ $ $'k8k0  R е дȷ''(УʱдϢ A@\k h  R T A@'checkLSAKT' h R$f' h R$f' h R$f' $ $ $'kd $ $'d'kk  R е дȷ''(УʱдϢ A@\k h  R T A@'checkLSBKT' h R$f' h R$f' h R$f' $ $ $'k@ $ $'kd'k  R е дȷ''(УʱдϢ A@\kp h  R T A@'g=================================ִеijУ飨==========================================ѴϢдбcheckBirthdayBKT" l$' 2Уʧ R е дȷдʽΪ"$.xxxx-xx"$.4 2013-12ֻߡƺͻ񽱵λδд''-УʱдϢ A@\  'kh h  R T A@'g=================================ִеijУ飨==========================================ѴϢдбcheckBirthdayCKT" l$' 2Уʧ R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-12-21''-УʱдϢ A@\  'kxE h  R T A@'^================================= ִԺϵУ========================================== checkYXYJKT l$' ȡǰ Z' ȡǰ $'F жǷѧϰ꣨911231գ°꣨11831գ $ + ǰ·9»֮ѧ꿪ʼڵ9 X -  X 'dC- ǰ·8»֮ǰѧ꿪ʼһ9  X - X 'kPC l$ͬƼͬѧ ѧ־ѧ'l'kB 2Уʧ R е [дȷд150ڻд ͬƼͬѧ XXXX-XXXX ѧ־ѧ''-УʱдϢ A@\  'dA.set "value", sheetIndex, rowIndex, columnIndex l R T$Z(lkA 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@k8; h  R T A@'W=================================ִѧУ==========================================ѴϢдбcheckXnKT l$'  R е )дȷʽ2012-2013ȣ''-УʱдϢ A@\%isValidateCount = isValidateCount + 1k9 h  R T A@'W=================================ִ·У==========================================ѴϢдб checkMonthKT l$'  R е &дȷʽ0112ȣ''-УʱдϢ A@\%isValidateCount = isValidateCount + 1k8 h  R T A@'g=================================3 ִеУ(DZ)==========================================ѴϢдб checkDateKT l$' 2Уʧ R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-02-21''-УʱдϢ A@\%isValidateCount = isValidateCount + 1k5 h  R T A@'c=================================ִеУ飨==========================================ѴϢдбcheckDateNecessaryKT& l$'  R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-12-21'dp4 h R$f' h R$f' h R$f' X X X X X X' R е ^дȷʱ䡢ƼɡԺϵʱ䲻Ϊͬһ죬ʱСƼʱСԺϵʱ'kX3kP3 2Уʧ'-УʱдϢ A@\k2 h  R T A@'g=================================ִеijУ飨==========================================ѴϢдбcheckBirthdayKT! l$' 2Уʧ R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-12-21''-УʱдϢ A@\  'k0 h  R T A@'J=================================10 У绰====================== checkPhoneKT l$'  R е дȷдʽΪ"$.-̶绰 ֻ"$. ''%УʱдϢ A@\' isValidateCount = isValidateCount + 1kP/ h  R T A@'L=================================checkOption У鱸ע ====================== checkOptionKT lB$'  R е )дȷȲܳ200ַ''%УʱдϢ A@\%isValidateCount = isValidateCount + 1k- h  R T A@'\================================= ִ϶ѼУ==================================checkDiffNameKTcheckDiffName l $'  R е дȷ''(УʱдϢ' A@\dp,checkDiffName h R TA@ l$1ͨУֵΪ'd,'k+k+ h  R T A@'d================================= ִ϶У(DZ)==========================================checkIdentityDateKT% l$' 2Уʧ R е дȷдʽΪ"$. xxxx-xx-xx"$. 2013-02-21''-УʱдϢ A@\'d(*  l$X$϶ȼΪգ϶Ϊլ'  l$e](϶ȼƲΪգ϶ڲΪ'dx) R е vдȷ롰Ѽ϶ơͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơǷͨУ''0УʱдϢ' A@\'k(kx( h  R T A@'T================================= ִУ==================================checkMZKTcheckMZ l$'  R е дȷ''(УʱдϢ A@\d8'checkMZ h R TA@k' h  R T A@'d================================= ִ϶ԭУ(DZ)==========================================checkIdentityReasonKT'0,1,30' l $'  R е 5дȷȱڵ1λҲ30λ''0УʱдϢ A@\dx%   l$r1϶ȼΪգ϶Ϊ,϶ԭΪ   l$ew8϶ȼƲΪգ϶ڲΪգ϶ԭΪ   l$e R е dдȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬''0УʱдϢ A@\'d# R е дȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơ϶ʱ䡱ǷͨУ''0УʱдϢ A@\'k"k" h  R T A@'X================================= ִ֤У==================================checkIDCardTypeKTcheckIDCardType l $'  R е дȷ''(УʱдϢ A@\d8!checkIDCardType h R TA@k! h  R T A@'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType l $'  R е дȷ''(УʱдϢ A@\dcheckDisableType h R TA@k h  R T A@'T================================= ִвмУ==================================checkFamilyIncomeType3KT l1$'  R е дȷ''(УʱдϢ A@\d@EsetDMBCode "checkFamilyIncomeType", sheetIndex, rowIndex, columnIndexk h  R T A@'d=================================14 checkSQLY ɵУ--==================================checkFamilyIncomeTypeKT l0'd l $'k   R е дظ¼룡'd R е дȷ'k@'(УʱдϢ A@\d l0 l1 l2 l3 l4 l5 l6 l7 l8checkFamilyIncomeType h R TA@b У'k8k0 h  R T A@'v=================================14 checkGender ִǷΪСŮУ--================================== checkGenderKT checkGender l1$' '-ԱдУ֤Ŷ R е дȷ''(УʱдϢ A@\  'd checkGender h R TA@kX h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoKT checkYesNo l0$'  R е дȷ''(УʱдϢ A@\d checkYesNo h R TA@k 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'  'k( 'k 'kk  R е wдȷѹѡԱܹѡ3ǷְŮǷϻǷѼͥ''(УʱдϢ A@\d checkYesNo h R TA@k 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 'k 'k 'kx 'kX 'k8 'k 'k 'k 'kk  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 'k 'k 'k 'k` kX  R е дȷѹѡǷְŮܹѡ5ǷԱǷϻǷѼͥǷ¶ǷĸиĶͯ''(УʱдϢ A@\d8 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'  'k 'kh k`  R е eдȷѹѡϻܹѡ2ǷְŮǷѼͥ''(УʱдϢ A@\d checkYesNo h R TA@kX h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkYesNoTS5KT checkYesNo l0$' R T h$H%Z' R h$H%Z' R h$H%Z'  'k 'kk  R е aдȷѹѡǷѼܹͥѡ2ְŮϻ''(УʱдϢ A@\d checkYesNo h R TA@k h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkDisableLevelKTcheckDisableLevel l0$' R T h$H%Z' T h$H%Z ѧмȼ R h$H%Z 'k0k( T h$H%Z ײмȼ R h$H%Z 'k R h$H%Z 'kxkp T h$H%Z ĸײмȼ R h$H%Z 'k R h$H%Z 'kk  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@\ds R е дȷ'',УʱдϢ A@\kXsdPscheckDisableLevel h R TA@k s h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkYesNoTS6KT checkYesNo l0$' R T h$H%Z' R h$H%Z'  'kqkq  R е ;дȷѹѡΪмˣܹѡ1¶''(УʱдϢ A@\dq checkYesNo h R TA@kp h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkYesNoTS7KT checkYesNo l0$' R T h$H%Z' R h$H%Z'  'koko  R е ;дȷѹѡĸΪмˣܹѡ1¶''(УʱдϢ A@\dn checkYesNo h R TA@kn 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'kmkm  R е 2дȷûȻֺд''(УʱдϢ A@\dXlcheckFamilyDisasterTime h R TA@k l 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'kjkj  R е дȷ''(УʱдϢ A@\dicheckFamilyBurstTime h R TA@ki h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkYesNoTS8KT checkYesNo l0$' R T h$H%Z' R h$H%Z' R% h$H%Z'  'kHh 'k(hk h  R е sдȷѹѡǷĸиĶܹͯѡ2Ƿ¶ʵ˸Ƿĸһ''(УʱдϢ A@\d0g checkYesNo h R TA@kg h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkYesNoTS9KT checkYesNo l0$' R T h$H%Z' R h$H%Z' R$ h$H%Z'  'ke 'kpekhe  R е sдȷѹѡǷĸһܹѡ2Ƿ¶ʵ˸ǷĸиĶͯ''(УʱдϢ A@\dxd checkYesNo h R TA@kPd h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkInSchoolCountKTcheckInSchoolCount l1$'  R е дȷ''(УʱдϢ A@\dbcheckInSchoolCount h R TA@kb h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkParentJobsKTcheckParentJobs l0$' R T h$H%Z' R h$H%Z'  (ĸûйũֲֳ'k a *ĸһûйũֲֳ'k` 0ũСֲСֳ߾ǣ'k`k`  R е Oдȷѹѡĸҵܹѡ1Ƿ¶ʵ˸''(УʱдϢ A@\d_checkParentJobs h R TA@k_ h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkParentCultureKTcheckParentCulture l0$' R T h$H%Z' R h$H%Z'  ĸΪмĻ̶'k^ ĸһΪмĻ̶'k]k]      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoqrstuvwxyz{|}~ R е KдȷѹѡĸĻܹѡ1Ƿ¶ʵ˸''(УʱдϢ A@\d]checkParentCulture h R TA@k\ h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkParentAgeKTcheckParentAge l0$' R T h$H%Z' R h$H%Z'  ĸΪ60꼰'kh[ ĸһΪ60꼰'k0[k([  R е Kдȷѹѡĸ䣬ܹѡ1Ƿ¶ʵ˸''(УʱдϢ A@\d`ZcheckParentAge h R TA@k0Z h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkSuortMembersDescribeKTcheckSuortMembersDescribe l0$' R T h$H%Z' R h$H%Z'  &˿λˣ70ϣ'kX &˿λˣ70ϣ'kHXk@X  R е Kдȷѹѡˣܹѡ1Ƿ¶ʵ˸''(УʱдϢ A@\dxWcheckSuortMembersDescribe h R TA@k@W h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkXfKTcheckXf l0$'  R е дȷ''(УʱдϢ A@\dUcheckXf h R TA@kU h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkfamilyHouseTypeKTcheckfamilyHouseType l1$'  R е дȷ''(УʱдϢ A@\d8TcheckfamilyHouseType h R TA@kT h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkfamilyCarTypeKT l0'dS 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'd R'kRkR  R е дȷ''(УʱдϢ A@\dQcheckfamilyCarType h R TA@kPQ h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo10KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dO checkYesNo h R TA@kO h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo11KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dXN checkYesNo h R TA@k0N h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo12KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dL checkYesNo h R TA@kL h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo13KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\d8K checkYesNo h R TA@kK h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo14KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dI checkYesNo h R TA@kI h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo15KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dH checkYesNo h R TA@kG h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo16KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dF checkYesNo h R TA@k`F h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNo17KT checkYesNo l $'  R е дȷ''(УʱдϢ A@\dD checkYesNo h R TA@kD h  R T A@'u=================================14 checkYesNo ִǷΪǡУ--==================================checkSqyyNameKTcheckSqyyName l $'  R е дȷ''(УʱдϢ A@\d`CcheckSqyyName h R TA@k0C h  R T A@']=================================checkTerm ִѧУ--================================== checkTermKT checkTerm l $ R е дȷ''(УʱдϢ A@\kA h checkTerm l $ R T A@'P================================= ִѧУ==================================checkXf1KTcheckXf l$'  R е  дȷΪգ''(УʱдϢ A@\d@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@\d=checkDisableType h R TA@kP= h  R T A@'T================================= ִУ==================================checkSuortMembersDescribe1KTcheckSuortMembersDescribe l $'  R е дȷ''(УʱдϢ A@\d;checkSuortMembersDescribe h R TA@k; h  R T A@'T================================= ִиĸְҵУ==================================checkParentJobs1KTcheckParentJobs l $'  R е дȷ''(УʱдϢ A@\d`:checkParentJobs h R TA@k0: h  R T A@'T================================= ִиĸĻУ==================================checkParentCulture1KTcheckParentCulture l $'  R е дȷ''(УʱдϢ A@\d8checkParentCulture h R TA@k8 h  R T A@'T================================= ִиĸУ==================================checkParentAge1KTcheckParentAge l $'  R е дȷ''(УʱдϢ A@\dX7checkParentAge h R TA@k(7 h  R T A@'T================================= ִд󲡻У==================================checkFamilyDiseaseDescribeKTcheckFamilyDiseaseDescribe l $' R T h$H%Z' R h$H%Z'  ĸش󼲲м'k5 ĸһش󼲲м'k5kx5  R е дȷдĸǷش󼲲Ŀѹѡ¶Ŀѡĸش󼲲м͸ĸһش󼲲м''(УʱдϢ A@\dx4checkFamilyDiseaseDescribe h R TA@k@4 h  R T A@'T================================= ִ뷶ΧУ==================================checkFamilyYearIncomeRange1KTcheckFamilyYearIncomeRange l $'  R е дȷ''(УʱдϢ A@\d2checkFamilyYearIncomeRange h R TA@k2 h  R T A@'P================================= ִлУ==================================checkHjKTcheckHj l $'  R е дȷ''"УʱдϢ A@\dh1checkHj h R TA@k@1 h  R T A@'T================================= ִȻֺУ==================================checkFamilyDisasterTime1KTcheckFamilyDisasterTime l $'  R е дȷ''(УʱдϢ A@\d/checkFamilyDisasterTime h R TA@k/ h  R T A@'P================================= ִУ==================================checkFamilyBurstTime1KTcheckFamilyBurstTime l $'  R е дȷ''(УʱдϢ A@\dP.checkFamilyBurstTime h R TA@k. h  R T A@'T================================= ִмͥʲУ==================================checkFamilyProperty1KTcheckFamilyProperty l $'  R е дȷ''(УʱдϢ A@\d,checkFamilyProperty h R TA@k, h  R T A@'T================================= ִмͥʲУ==================================checkInSchoolCount1KTcheckInSchoolCount l $'  R е дȷ''(УʱдϢ A@\d(+checkInSchoolCount h R TA@k* h  R T A@'r=================================checkAtLeastOneNNull ִһΪǿ--==================================checkAtLeastOneNNullKT  'A"ִ һǿУ ĵԪĿ l$ l=Ϲ  l ' T KTF  l ' KTF " l '" $KTF & l '& (KTF * l '*n0)dϹ , ',F6ִ һǿУ ĵԪΪϹĿ .   '.k('n(i(_--------------------------------------------ʽ-------------------------------------]VBSCRIPT.REGEXP$6.47RegExΪʽ 4(4 ȫֿvba\ת 2 4(8.ʽ 4(:5ǷִСд l 4%<'03 ִ.4i '-----------------------------------------------------------° Уظ˵Ѿûиʽ------------------------------------------------------------V-----------------------------------------------------------1ѧ׶ڱڲ(sheetѧ׶ DA65535 @$`%<%!F'B*cna = getTotalColumnCount(sheetIndexValue) b$`!ZB@H1&ÿУظʱʱѴϢsheet,'dϢ¼ʼX==============================ѧ׶ڱڲ==================================0ðÿԪغ֮ǰнбȽ J  B J N @$`%Z'L P  J P N @$`%Z'R L R.ѧͬ˵ظݶ P еݺ͵ J֤ظ!!!!' A@\*ѴϢ'Tkx#p#h#i`#-----------------------------------------------------------һ ֵȡֵ------------------------------------------------------------ֵҵֵڵлkeyWord ҵĹؼ'kbn л ֵΪ rowrow'V]the find result object X` db hf A1:A65535 h$H%<%^.\ \ Zrow \!F'Vd! \!j'Vkp!kh!i`!------------------------------------------------------ ִڹУ(Ϊ)-------------------------------------------------------------value value1 cellУ鲻ȷfalseУȷtrue l0˵ΪDZ $'z k k]h'pijһļ¼ DA65535 t$`%<%!F'rB' t lrow$V'n=ȡ J n r J t$`%Z l p 'pdyk J P n n p  P t$`%ZX X LжϹǷcell'ypkh P#ʱcountĿΪùеĿi ------------------------------------------------------ ִɾijһвexcelܱģ-------------------------------------------------------------sheetIndex rowNum к1qazz h$HB@x r h$H%|B@~/ Ѹɾ- Worksheets(sheetIndex).Protect Password:=123i------------------------------------------------------ ָcellֵ-------------------------------------------------------------1qazz h$HB@x l R j h$H%Z(li------------------------------------------------------ ִɾijһвexcelûб-------------------------------------------------------------sheetIndex rowNum к r h$H%|B@~/ Ѹɾi------------------------------------------------------ ָcellֵ-------------------------------------------------------------@ 1qazz h$HB@x l R j h$H%Z(li------------------------------------------------------ ݴеֵǰʱѾͨУ飩------------------------------------------------------------- ]   R j h$`%Z!lX 'V'pijһļ¼ DA65535 t$`%<%!F'rF t lrow$V'nAȡ J n r J t$`%Z l p 'pdyk J P n n p  P t$`%Z!lX '  VX 1жϹǷcell P t$`%Z!l' X R j  h$`%Z(ly(d  0 R j  h$`%Z(ld R j  h$`%Z(lkk Pi------------------------------------------------------ ȥcellеĿո------------------------------------------------------------- ] Ԫ]  3Blength1ʾcellԭijȣlength2ʾִȥոַ'ĬΪûȥո2 Worksheets(sheetIndex).Unprotect Password:="1qaz" R j h$H%Z!l' ' Gzj*"ԪΪգȥո  '%length2Ϊոһγֵλ ַո  $' X R j h$H%Z(l'kiAttribute 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ֵ?&?2Inta9?%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 _5zV> '= ">ش׀Ȼֺ??, 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ϙoFTOIoWW 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:__ra_Pm_)_"_ܟ,$_ʣ___//I//ex//'/J6JO/Ia},/o/_-=*_-py,_-D]GordO]2 O]ߒCOqresul1getCellŀusXQ(4Ob1_}C5 a`hCInt() > ) DmFaߩ.+1Ϧa/` ϯ5IA1İٷʮ?_LLO|m wEEuEEE?BEE/ϢEClassE M*?E 8o?nt/D46o?=, 7233IsEmptyDOr ;DrJ?E'_ P NCase "BYesN,oAbˎ= 2\__Y55%< z0"+?4K>_-  _-_-( Ooo5'((((ҪQ)5)i L| w5I,oo/K#nsOBR mMG*vw=(getVQCountXQ} 1߄7!G߄WP_f-XM_WWW&߄{Ba End If| 0h^ result = "" Th enTaIf CInt(31) > 2)> checkMethodXQrFalsen errorMsg" & rowIndex"еAtitle& "дȷϿβܳ ܁ "AEPjTruiсIsEmpty V VVQAWΪStRh<[NotS hasE 'УʱϢwriteLog HbeginC!m_comment sheejtf,,joplumnCisFor `$'=ִu@"wA 'ѥ(aбCase "sBirthdayA" '6mxK(value)7getCellV! Coun0tXQ(2, 128 ˃~ ?ˤ%  l 'bBʧ £@ʽΪAC@hr(34)xQ-xx Ax2013-12鸜w sUisp&idate&:+ 1oEEE}EEt[E/'BLSoM4/vbAQ@@E@@ 41poEoE`E3oEg 2/J4 a?KRBO` AD_Pg_0?_QD 5O??M9L9KߌߌLK_!QQ3HHH, cOsgAHWDAD(DbA_QDDpD5_;DOH6D7ZRAAoFOD?*X-_ ,ɳ Else HIf Not IsEmpty(result1) Or.2) 0ThencheckMethodXQ = FaGPTruEnd IfQ  err orMsg"" & row Index"еtitleA & "ȷ"S0A\hasEA[ 'ʱд ϢwriteLog - dbeginC_comment sheetiB, T,FHo0lumnD [%is8For?(iCase "%LSB^-getCellValueCountXQ(#EF, 148)X 1 +19My 2 h 20s ߲}p]A/?f-8qmU aO*s4 ['eS( X%yO7XX?XX X'=ִo jбA 'ѵmбK]BirthdayB" ' -A(vZ2O/%** '!yʧ܏ropYQ ʽΪChr(34)x(-xx\ у2013-12ֻߡƺ͑λδo  _yis vpidatSv+ 1o%6555, cߍsg5055o5@55yC5%p5Ǐ55o5o5Eo5Evo53/o5Pd555-213 3333'[333633333RO#3_P/o1 6ϵ>đk?+Case "checkYXYJ" ' MethodXQ = (value)r' ȡǰVcurrentDateOa11Year1y(D>жѧϰ91Հ123 @ƒ18&If month6 >= 9 Then!ssǀ5 BʼڵC GetCAcademicp0CStr9 ) `& "-" + 1Else'HlHǰHһ$ -@%$nd IfC%&ALYIsEmpt~yĔLW "ͬƼZIVQc־ѧx"W&ATruYAECUWINotC$  'AУʧerrorHMsg(ځ&rowIndex:еatit le@(дȷa150@ڻ H2 X- o0|1 hasE0 'D дwriteLog isValidCount-@qwsq?@'set "Z", sheet1, 2, columnCells().egXnw beginC_comm/@e,.isLFol'= ִѧŵAA>kCaXJH7QLen, "0, 1, 50"=vy1ww@Ϊՠ3ȱ j1λ50:::::;;1UZo0o0UZo02MethodXQ = DMB(9, value, 1)DIf N ot;KThen.errorMsgr"" & rowIndex "еAtitle& "дȷ0m3ha sE43True@ 'дUwriteLog ZEls"e"setCod, shee t|,, co0lumnEnd IfbeginCA~_compmentJ|,A;isForDU0 'ަѧD-'хhбK>XnσJ<@-Xn(µ0?[ʽ2012-3^ __# _'isValid@ateCou@O= -+ 1Wa[ٟZckZ  ZYY·Y)ceY iMonth?Z#\aZ#Z?Z0112?Ze?Z?Zc ?Ze?Z ?ZP?Z-exaoZ -?Z3 q-@ڑ-(DZ).u[[DBx" 'A -= 1) Or.2.@l0/FaO?ʱ䡢ƼԺϵqͬһ¬СԺCϵʱ@" End If>r1If Not checkMethodXQ Then 'УʧbhasError = True '-7дϢ$writeLog e'Msg@beginC{_comment sheetIndex,, row olumn?isF: '=ִе[8@!PдGCase "}Birthd`ay" 'P=GENecessary(valu|e)?^@"`" &i"ASO`titleдʽΪA Chr(34) x-xx  2013-12-21@~ ___$ isValidatPeCou\=.+ 16hhhnhb10 绰 '`PhoneP82_Num?^],_Y_YXY-̶# ֻ$/[{YX}XWaW'Vt VUUUU'b%Option+ע ?*z*kkQ*, 66/Zr+E+rSWWWȲܳ200ַUFO(__9O(~'SO(O( //EO(/SVSao=& q϶Ѽ1T!TDiffNa>mT ")ĄDMLB(, , func2Args+BWd+C ,& Rt***Lsysaicult@yGradeFlag 0?.Ï.ElseOEsetCod%/oe T,ri5tQ"ͨa(ֵuq2_ /@ /B/B/B_Oc=&B(Ǒ>)o{BIdpityDgmA_>_\o/BIndex & "е@"titleMsglдȷ,ΪChr((34)Hx-xx 0 2013-02-21@" hasError = True 'УʱPдϢIwriteLog\ eO/intifyDatePFlagA0Else(If sysDifficultyGradeNam.1 Andrim(value)8"" Then '϶ΪՀҁ ځ?i15E].2N.<> ./C/2/A\Arow.롰Ѽfjͬʱ> =ͨEǷ ]z?FdcheckMethodXQ$Fa]!_n/ nNEfIf<beginC!_comment sheet>d, j, Bo0lumnisBFƖ '= ִ́A>=k@Case "Z4D9DMB( , , 1)S*Not#5kΣ_^Ŏ VPset*Cod(2,KIS(\XwXx,),Oԭ,(DZ)o{-Id`:ityReaso0n" ' functionArgs."0,p1,301-=Lenx, 1f1 SA| 62U"gڵ@1λ304/55&5f`ߔޔd= =ϊu,-|_  = G#   ?4(` 0 Or O)% ?_4_46Ϝ!Üʱ䯝SϽ O7O7O7O7O7ϬMߞ  moO/ /_#ѳ End If  @|beginCheck_comment sheetInd ex, c2MethodXQ, row0olumnerrorMsg~isFor = True '= ִ֤У 5= ]&?nظ¼>?-_III;/yOyR_"-Or.1" U2345678_5) /ToTIT 'C'5 VVVV_6NS4GerǷΪСŮUU3oT M7?R@J9XQ Then hasErrorIdNum = True 'ԱдУ֤eMsg"" & rowIndex "еtitle-& "дȷ"ʱ ϢDwriteLog ZisValidateCount;+ 1Else,setDMBCode "ch eckGer", sheet,, colu mn 7nd IfbeginCA_comme2IMethodXQ,KisFLorDe!'=14YesNoִǷΪǡHAx--=?CasEWԕ?70g(f, value, "80")@.If Not [Ϳff^^+^ҘE^`k^^^#%SEdddgf+mdTSd=\d."resul!Work>s(?).Cells( n# 1 w_ , 11: 2? k# 2: 3? & 34 F&""z!J= Faok:#8i_6 q? Y? ? j? i_6 ? Y? ? j? g ?k?kg v-ѹѡ𛲻Q3!ְ@ϻwѼͥ契  ï老[qbqiq?jIq J*OBq o R'qo  4r2s}@_otϦF'@l 17 210809 36004042 4304a_QftsyhkR?s?{Ϗ?{r ϓ?{+17 8 w?{2C 3 4PEoox, 28;? 8 529; result6 = Worksheets(Index).Cells(row<, 36) W 7(7I8'I41I9(I2$T10(%3%1(%4%If ɀ3"" Then  A%^ checkMet hodXQFa8lse EndU,27?,A<,3?,#J<,4_B` FB5  n`  `  `  a`  5"p ? bj Ki_ ?m   g_q Not\?}#SerrorMsgP" & u"еtitle& "дȷѹѡǷ¶ʵ˸ 11ְŮΪмˡĸش ĸһ$ͥԱѧˣ?3 CQ Б ĶxqSҵĻQ䡢 "?hasEq@True 'Уʱд ϢOEwriteLog %E+psetDMBCode "/YesNo", ,#, columnba-Q3beginC1_commen~tZ7O isForT g_S'=147ִݱ"Ϊǡ񡱱--Cas:TS3$@ NU2 P(value, "<0"ra'9D ^ 12p3~ qOOx# w[9 10A/ѵ?aӳex, 36) lIf result = "" Then,1 FcheckMet hodXQ6Fa8lseb5Enpd If ]2o]  ]3].4.N?t5.?.L3bNot ktXerr orMsg"" & rowIndex@"atitle& "дȷѹѡְŮ! 5E@Ա!ϻѼͥ!¶#ĸ иĶͯ0"%/ha sE True 'УʱдϢwriteLog (SEsetDMB@Code "b7YesNo", sPheet1,2, columnتbeginC_commen.t JG,isFor* '=9141ִ@aCǡ 3--E^ =#Cas*T|S4B 3(2value, x"0"42fWHork;s(7).Cells(8"'11 13O%sQ?11ρx 13? Fp// /-$ i`9 i L: / 7qqg &N`@"qqqwqmq2qsmpmi mmmLm? mymmmoqmmemtm{mo qPOp-lOpOpOppp5pr ]?ppGu_qqqrd@qtqr/qԜvrowIndex, 12) Olh2 6If result = "" Then0Mk818checkMethodXQFalseTEnd If2h2h }4SBiJNot r[errorMsgV" & р"еAtitleA & "дȷѡǷѼͥA2ְ Ů ϻ">hasE.@-True 'УʱдϢwrit`eLog e SEasetDMBC ode ".YesNo", sheet'col8umnXfbeginCu_co`mment >,)8, ,is8For*'=914`7$ִ@!Gǡ 񡱁9--E^ =Cas0DisableLevelH%@`9(8*, value, "0"T˅" ǿWorkBs(gC).Cells(2Du 7jA)"ѧмȼ޶ӕ8 C5) <>cA`]AA6/Wa5?>"׏?OWw$17`P ߋԝԔ$$zs?S_s%"%OCQ/#21%%OOJ=%%sS_Q+hrEO& !1ڡo YS2E\Oj  Ϫ>djo 1uSSvȳ hasError = True 'ʱд΀Ϣ writeLogD eMsg\ElseIf Worksheets(Index).Cells(7, column"ĸײмȼ" Then;" & row'"еtitle[дȷڡ>ǷΪAˡЁڱ ąU"V?ÿPP?@?End If@S setDMBCode "checkDisableLevel", =,ƣʺ*beginC_co`mmentJB!MethodXQ,visFfd'=143YesNoִ n0ǡmA--^ = Cas3TS64s&`;@;(:9value, "0")V Nresult ڠ%7a1, <10bbWM_aȱ_a 5__aetI_arZp_VZAE_aI ` _a"_ak>?9_aXQ/Wu&& Sa_a_a_' _a_a_a_a_a_aD_aaB:_a  End If  "" AZ,c.Aa()MaFalsB5YfNot\WEAh" &܀"е titleȷûС;%;a Wa!hasEazv 'gʱдϢ7Ewri@teLog ۃE2setgCod}p,JGY:ckD,͟I#Burst?@2ߜ AQcߜ = Ĝͻ͞⟜_!L33$ŲTsX_/ON/dg @""ONONONANOL9OLOLOLLOLo OLyOLy1{_IwLL,[c M]HMoo]+MTS8p =5}"LIresult/_ ByMQ_1g10 237O w_I_Ig Քqm&q:@/ 9FA  O) W_1o_&q & ѹѡĸиĶܹͯѡ2Ƿ¶ʵ˸dĸһL뼀" hasError = True 'УʱдϢDwrit@eLog eJMsg*ElseDsetDMBCode "checkYesNo", sheetIndex, rowcolumnA6nd Ifb eginC2_comment2?MethodXQ:,visFB '=14 Eִ|ΪǡRo--= %Cas]TS9T G@n(Kmvalue, "0")K/resultWork~s(G).Cells(ҁSA%C1107C22g36WIf #"" Then Xz i$!$_!*`-FFa E{ _3_ __wY$ FNot FEaL" &f@"еݡatitleaдȷ٭_Pܡ"7oexOBBooo, Xvoo o]kooooXoInSchoolCoun~to ?o+,: %p1/po8XQ?[To8po8& o8c8_2J oooL_2o _2yn]ǁIQ 22222orT20=,000]G0-ParJobso0 R`g070o_p_xJ@_d_o?/ 7{ûйֲֳ) ߝ_:9/9O^ )2 pIf result = "ũСրֲֳ߾ǣ" Then checkMethodXQfFalse4End If#Notd}errorMsg" & rowIndex"е@title& "дȷѹѡĸҵ܁ 1 Ƿ¶˸첄"BhasE)(True 'ʱдϢwriteLog E< E}setDMBCode "‹ParentJobs", sPheetN,FQ, columnXbeginCA_commJ ʬ,\sDMB($, value, "0")+ result!@Workƒs().Cells(SA;C110T@If G"" Then  4"˿ˣ70^#AJ MFals 1 xe;+ɫ¿ 7y%`#Not6N)" &@"е atitleaȷѹѡaOA/!01ʵ˸ôA$hasEA 'ʱдϢ7)write(LogE[sebt Cod?x=?ck??܄, ؝mxlXf!3;Wkp?jI?3XQZj?3j?3& ?333/J ///L/ /y/7{_I.A...,  v/*/oo]/-familyHouseTyp p<0M11ϛ11V11dd1l111L11 1y1_2i_2_2_2_2_26_2*o2.o2o2?o2]o2.CarO2 -21@_^R5?"qI1,2,3" Orq0J1 1=3,33pO,22,?mLO checkMethodXQ = True  Els:jFabEnd Ifo51If Not NThenerrorMsg"" & rowIndex"еtitle& "дȷ@"3hasE4 'Уд"writeL8og Z[osetDMBCode "JfamilyCarType", sheetB@,B, col8umnTxbeginC_commentJk,=isForDWI('=14űYesNoִǷΪǡj--=SF CasE[10JBw@3k(jhvalue, functionArgs)?bK?b?b?b ?b?b ?bb?b*b,?a2?aǴ?a,a;SEf߿ffhf1fff +ffff _3_3)~d_3,Iuc_3cōOBcs_3 o P'a_3ffo f2_3R2(_3NoffcPf8ߗ_3ߗߗߗofߗߗfW_3S_3`fex_f'_3_3_3J_3_3_3_3.=_3_3_3_3 ^33$_3_3_3V_3_3_3_3?˿_3_3_3*fg_3y_3_3ʿf5_3_3_3_3_3R_3qPf.E=14 checkYesNoִǷΪǡУ-d-= C ase "14"T"Metho dXQ =DMB(<", value, functionArgs)PIf NotGWThen.]errorMsg?"" & rowIndex"еʀ title& "дȷs3hasE43True 'ʱϢUwriteLo g ZElse"setXCodhYsheetB>,@, colu mnTnd IfbeginCA_commen\t I,;ipsForDU!V'O^͏# N5aWpfff ;ff ffMBfef Ef`ffffgf͍ sf16f `,gfffff _3$`_3@&ff_3A_3 ff5_3߁_3p'11o  _c f7_3PI8S_3ћof_3_3_3S_3_3!_3sQ_3_3_3 n[31-111]/SqyyName!B //OO@/0/0t/0/0/0/0Oʊ/0/0/0* O)/0y.0ex_0'_0_0_0_0?_0+'Te rm/ѧ?. "checkTerm" If Not DMB(, value, functionArgs) ThenerrorMsg = "" & rowIndex "title-& "дȷf0hasEifTrue 'Уʱд@ϢUwriteLog ZEnd IfbeginC_comment@ sheetx,(,olumn!MisForP'= ִѧK^ B=K=CaseX f1gMeth0odXQ&Xf2"0)Av ?U_ΪCas Culture1" tVpDMB( Ä!value, functionArgs),If N ot' ThenG!"" &{"title_дȷ0;hasEnf 'Zʱд@Ϣ*writeLog܀p ElssetZCodl?@F'""mE  "a}ش󼲲pzlt= Fae ?h һ hV6 /  _pI_]5,& s1!#ǷwPѹ¶q0ѡ&&(ߓdߓߓLd]!dޓKPÓ"ee, H ea9e뷶Χe 2@YearIn`eRanOU m=//X88///jO1O1O1* /LO1O1<pvI2qO1O1O1O1J1ȳ, errorM sg isFor = Tr$ue'= лЈZ= zCase "checkHj"MethodXQDMB(1, value, functio@nArgs)GI@f Not NTxhen<7"" & ro@wIndex"еtit leдȷh0phasE0 'ʱϢOwriteLogEls7setCod\, sheet7,F:, colu mn!End IfMbeginCr_comme|ntJ^W׀Ȼֺ LȦFamilyDisasterTime1v ̘="&* Y ZZ_[\\.^__`ck_`"'ޭ`a {`Burst?`1_c+_C_ __ __MB/./ex/_X//_/J_O`/0/ͥʲ//sProperty` K`dE/cP/@_/Y /* //_///G////_6//,///InSchoolCount/s /pǏ:////////////*///// /G/////6/o/CM,R(AtLeOneNNull!һΪǿ-->0O1D1L/B a3O + 1 :'a u  Qk ĵԪĿ"@ 27 oney(R) Aڢ <> 0 b ڶ'Ϲ totalMoney = 0+ valuexSelect Case columnIndex4 9baoPjiaoCE:'AM FSumgiOhuoshiN"M 3Mzhu|suC&3&others|&C& &End ӔEl'˲catLeaOneNullCount@+ 1 'ִ һǿУ Ԫ@Ϊ`ĿE0rror+ titleMsg + " "!DIfsisF Tr~ (aFunction '-&ʽ  e re@gCheck(,)DimEX As ObjSet= Create#("VBSCRIPT.REGEXP")'RegExΪ EX.Global0&Ɇj'ȫ@ֿG'vba\@תm Pattern `Cp ʽI gnore= ,Fa[ ִСдj -cTest($ \X').Nwipng G?HD° iظ˵Ѿûиʽ}91ѧڲ ([cZTheSameXQNew(sheetp2) 'H4n*a 3Ssj.Range("A65535").P(xlUp).R$ow'cgetT1wMVAh6msgNP ).Cells.ClearContents 'ʱʱAςB,curK PS¼ʼ'=?ocO'ðÿԪغ֮ǰнбȽϧ1Ti0 startT!YX2 To rnagE9carpdID1Ia2(i, co3YOdAjO@ip - 1oq32exj$i6t@Is Tu q6$(Pk3-`"1  c baQI-0q.' auqf(Ϊ)@+rB q1 cnā0!ȷfіT5tť ~DMBcT1, flagd'`%"0 'ASΪDZ+Trim1) = "" Then checkDMB = TrueExit Functio ~End Ifd Dim ro wData8Counta0 'һļ¼F"/Num#Sheets(Areas Index).Range("A65535").o(xlUpow ' JFalsH0GetRowOrCol.5, value, "") 'ȡX@YF0or i',TozbIf gCells(i, 1)!8+ 1-El orNextl iA.jN.k 4+ -2CStr(3j, 3>)4 B57A 'жρQǷc@ȇ,3Iֵǰ ʱ1ͨУ)Code(b6|, WbW8T 󈓡BdeErQL2p|y9HC=  S]___YB= ???~*0es?R_ǴQ?Q?9B(1L"ݵ"қa!() c2,o%b% 2$C$o0pxumnPlusH4V ϶O"/مsO T䄟 ue "0 ? 9"s%)}uqaX` ȥ*`ո^removeSpacev^a^4As @ing 'Ԫ87.le@ngth1 Integer, %328 'tʾԭijȣlength2ʾִոַ" removeSpaceXQ = False 'ĬΪûd' Worksh eets( Index).Unprotect Password:="1qaz"nvalue1gCCells(rowS, col]9HILen(EV)If 0 Then Exit Function 'Ԫգ腗62[InStr7, " ") '42#һγ@λÐI2p <> JC̰Շo>pReplԉ?B"| WC7True+End` If Z  (f.UxME<6 LL L "L<8 4 `HkPz`@h @X x@H @8 @ @( "@$ 6` `8 `: `\ `< %hXXPPH,b`d@ @ @ @0 @H @` @x @ @ @t @p DB*6@ ` @8P @@ *2.0\,@0 @, @J @ 2@ 02 .@ @P @@ X;@ @;@, @p @ C@| C@l @(\ @I@L h(I@H x(KM@8 Q@( QS@ (Z@H 8Z`\@p H`@ p`pb@f@0 @2h @ (t@p 8tHvz@4 @ p|@x |vT>@ h @X @H  >i$*\Rffff*0U6af0908f*\R1*#3cb*\R1*#30d*\R1*#268*\R0*#17$*\Rffff*0S6af0908f*\R1*#118*\R1*#31$*\Rffff*0R6af0908f$*\Rffff*0W6af0909f*\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(H6HXH0&PB<H <(",8H@,0&x0 <, ($$M  < "P(L7h(&( ( )$ 0 >8,x, (,&40M, , ,0 8 @P(X *+$,  Z 4+=1 ( 04 @ $x+=P1,] ,P h+p=P1,], 8 @ ;H ;h ; x" (0@2P$@6 (*8 :h   ,08@ Pa--------------------------------------------ʼУ-----------------------------------------]@]X+ijһ͵ıʶкź͸ʽ3:1;2]p ʶ(ĬϱʶԶʶ)](ijһ͵ıʶ飨кź͸ʽ] ijһͱʶľֵ]Զʶ]%Ѽ¼ΪյкŷŽ] H!p'$"ȡĿ $0ĿȷģٽдУA@,1qazz$HB@&|k1qazz$HB@x1qazz$HB@x1qazz$HB@x b$`!ZB@H-$ÿοʼʱѴϢsheet,'dϢ¼ʼ'.ôУУ¼Ƿд֣׶ϢУ (('#Ĭ϶ѼδͨУ'Ĭ϶δͨУ b$`!ZB@H-$ÿοʼʱѴϢsheet, DA65530$H%<%!F'B BA@ ȡ *IV5 6%<%!j'xcna = Worksheets(1).Range("1:1").Find(What:="*", After:=[a1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).ColumnFAILUREA@&+ȡǷУɹ־Ԫ񣬲ֵʼΪ0'ռ¼ʼΪ0 * 2" ʱִd ʼУ鰴ť¼ʱִ.ȷʼ Уرexcel $.ܵݶʧʧ 0ܰʾ$, 2d1qazz$HB@&|kk.$H!b(v)ҳǩΪɫ B  "ûвҵѧϢ޷У飡A@,'*1qazz$HB@&|k'ôУУ¼Ƿд$H!дϢ£A@\ B  J  B'<"ִ һǿУ ĵԪĿ',;6ִ һǿУ ĵԪΪϹĿ'''.5"һǿУʱ¼Ԫ'9ǷΪЧ¼ 'C¼УǰǷд';¼ԱǷд P  P$H%Z!l'Oһбʶֵ'2=жforѭǷcallFunctionXQStart ûִĬϷ <ʶΪ -$'Gʽ14-3:25 :$',H6ʽ3:25ȡıʶвֳ֣кź͹ DJҪּϵҪУ飨ĬУ͵ԶУ   Y&+1ΪеһԪΪĬУ $:$'V*ȡıʶвֳ֣кź͹$' SԶʶ J $;$'cԶʶ͵ľֵ   gԱʶб $ J P A@}ݱʶֵöӦķk  $;$'Pȡıʶв   WԱʶб $ J P A@0k( ,eJ ʽ3:25$,' QԶʶ J Pʶеڵǰ$,;$'eԶʶ͵ľֵ   kԱʶб $ J P A@ݱʶֵöӦķkd-ֻĬУʽ14$;$'Hȡıʶв   OԱʶб $ J P A@0k(k  J P$H%Z(. P 6ִ һǿУ ĵԪΪϹĿ , ,  J е .һдȷ''8УʱдϢ A@\  'd 0  '0Tÿһкϼеֵk <,һؼֶȫ򽫸ɾ J +"  ',"ϢеĸдϢɾ 2 d  d d  b$`%|B@~r Ѹɾ 2 d  'd 'k Jk 4  6 ɾЧ 4$"' 4 A@vB Ѹɾd8  4 A@vH Ѹɾk 4  ˴Уɾ ,Чݣѧš֤šԱ $.444УʧܼΪЧݣA@,kH *дϢ鿴ϢA@,$H!b(v b$`B@Hd 'TA@> T'%ִУظݷ,ûظǷҪɾЧ Уͨ!A@,.$H!b(vSUCCESSA@:+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 DA65530$H%<%!F'B BA@d Уͨ!A@,.$H!b(vSUCCESSA@:+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 DA65530$H%<%!F'B BA@k k 1qazz$HB@&1qazz$HB@&1qazz$HB@&oP q-------------------------------------------------ظijһ------------------------------------------------ ]`x] DA65535 X%<%!F'B2Scripting.Dictionary$6.>O8O B X%<!l'@>ȡѧ B @%"ѧ໤֤ݽб B B >%D-֤Ų B >B@F&#addһΪkeyڶΪvaluekPkH@ 8!H':Sheet2$HG:G7<B@H : !%L 8!pG17<,Jq.8oAttribute VB_Name = "" '-( У&l Sub :򲢴ӡϢ() Dim rowDataNum%typeValue 'ijһıʶкʽ3:1;2?bsT '(Ĭ0CvalEntity8?: 7,@ֵhR0ow '>_isNullArr(500) As Integer 'Ѽ¼ յā0ÁP sheetCountWorks. 'ʈĿ If H<> 3 Thenm MsgBox "GȷԀٽдˁ@"(1).Protect Password:="1qaz DExit #End IfKUnpH 2).h 3_ Sas(m sgB).Cell]learCotnts 'ؼʱɂ` ,C7cur]= 1 'G A hasError=Fals`hôB/У Ƿ!֣׶r hApplication.ScreenUdpdng sysDifficultyGradeFla0b o϶Ѽδͨ!!cindeofy eOM?,?,-, rnaHRange("A65530").N(xlUp).@1 s n;"jXQ 1, 2^, bm4h$c"1".DIV5 ToLeft`Golum$p'1:1`F*(Whath*", After:=[a1], SOchOrBdAxlBys1Dirp`>:=xlPrevio|us@8, "FAILU8RE"aL!<־Ԫ񣬲ֵʼ໯Ϊ0 ƞ 0FU `} isSaveB uttonvbOK ལʱִEE_c`ذť¼) ("`ȷ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/Zw0p&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 rSoSQMKEG=?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().LockedJz3= 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!/ʱ/-41427setCell@ueXQ 2,A8, "SUCCESS" 'ȡ! ɹ־ԪֵʼΪ01=rnap"Range("A65@530").-(xlUp"qI y N !Ona%FoO0J0oro oooooooIoQ oKkProtect Password:="1qaz02).J3 Subp '-ABijһN  K(BKDim myDic As (Obj,KeyVarianSB4, var| ActiTveX.)95-9 'S0Set idPq `= CreS ("Scripting.tionpary"We" =B "O8"@HOt@ ).valuCHѧwEach cabra In 'Ա໤zQnZ @V<> "|" `be .Exis`) 'beP1Add , 'add#һΪkeyK4ђSsSmy"=C$.srWithj 4"!2W!G:G!ClearContentc 0&1Resixze(+ PԑA@pplica1!.Fun@(on.Transposa #1 'c0= `hP& !: T0* pHd VBAProject4@j = r >i J< rstdole>stdoleh%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5ETAAC42E2ED:\Software\WPS 2\12.1.0.22529\o<6\ksoapi.dll#Micros 16.0 Ob LibrarFyHMSForms>BSFr@ms3D452EE@1-E08F]A-8-02608C4D0BB4%QwQowQFM20.DLLH'BF ^&/;"1?Ci pAp00}#0p# 5h0 A6BAA67D4-@C853-4eACE-2739AD4EE77B6Users\lenovo\AppData\Local\Temp\VBE\T.exd i*\R1*#119$*\Rffff*0S6af0908f(*\Rffff*0S6af0908f\077    08  @ ` Dp 8 0 P0pD084P. ..(8(`>"$(@>`R^FX `*0$`  $  ^(^_^7_^0p@һṹҳi@]$Hi@=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*_'_%__Sschemas.openxmlformats.org/spreadsheetml/2006/main" hasInvisiblePropRange="0"> ^9Jk A.  A.  A. _VBA_PROJECT_CUR"/ShowForm CompObj aVBFrameo f&PrintForm CompObj aVBFrameof&PROJECTwmPROJECTVBA__SRP_5!/__SRP_6M__SRP_72__SRP_8[__SRP_9Q__SRP_aT__SRP_bWg__SRP_cYL__SRP_d___SRP_ebL__SRP_fpyShowFormrPrintFormThisWorkbook / _VBA_PROJECTw)__SRP_4"J__SRP_3#__SRP_2$__SRP_1%__SRP_0&_BSheet6'Sheet5(Sheet1)3!hQpe *SbpSȉ +.v]wQQpe ,b;N z^-p@Adir.@XXfMsoDataStore30CustomXmlParts_Item(1).1Properties2RItem VETExtData]