ࡱ;  ɀ\psssstrator Ba= ThisWorkbook=ZKx-8X@"1r[SO1r[SO1r[SO1r[SO1r[SO1r[SO1r[SO1rArial1r[SO1h>r[SO1,>r[SO1>r[SO1@r[SO1r[SO10r[SO1r[SO1r[SO1r[SO1rArial1Qr[SO1r[SO1r[SO1r[SO1r[SO1 r[SO1 r[SO1r[SO10r[SO1r[SO1 r[SO1>r[SO1r[SO1 r[SO1r[SO1r[SO14r[SO1 r[SO1r[SO1 r[SO14r[SO1<r[SO1?r[SO1>r[SO1r[SO1r[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO1@[SO1[SO""#,##0;""\-#,##0""#,##0;[Red]""\-#,##0""#,##0.00;""\-#,##0.00#""#,##0.00;[Red]""\-#,##0.007*2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ?,:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\)""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)0_);[Red]\(0\)0.00_);[Red]\(0.00\)0_  0.0_                                        P P                 ! " #a   $  %ff & ' (`         ) * +  ,    @ @ @ @  @ @ 1 1 1 1@  1 1@ @  1 1@  1@ @ 1@ @  1 1@  1@  1 1 1 x@ @ 7 x@ @ , 1@ @ 1 1@ @  1 1@ @  1@ @ x@ @ , 1 1 1 1 1@@  1 1@ @ 1@ @   ""@ @ ""@ @  @ @ @ @ !@ @ 1@ @  @ @ 1@ @ 1@ @  1 1 1@ @  1@ @ .87 /8 087 18 287 38 487 58 687 78 ||~ #}}-}00_)}-}00_)}A}00_)ef[$ -}A}00_)ef[$ -}A}00_)ef[$ -}A}00_)ef[$ -}A}00_)ef[$ -}A}00_)ef [$ -}-}00_)}A}00_)L[$ -}A}00_)L[$ -}-}00_)}A}00_)L[$ -}-}00_)}-}00_)}A}00_)23[$ -}A}00_)23[$ -}A}00_)23[$ -}A} 00_)23[$ -}A}!00_)23 [$ -}-}%?_)}A}(?_)[$ -}-})?_)}-}*?_)}-}+?_)}-}.?_)}-}0?_)}(}2 ?_)}A}3a?_)[$ -}-}4?_)}}}7}?_)[$ -##0.  }}8?_)[$ -???##0.??? ??? ???}-}9?_)}-}:?_)}A};}?_)[$ -}-}>?_)}A}??_)[$ -}A}@?_)[$ -}-}A?_)}A}B?_)[$ -}A}C?_) [$ -}A}De?_)[$ -}}}E????_)???[$ -???##0. ??? ???}}F??v?_)̙[$ -##0.  }(}G ?_)}x}H?_)̙[$##  }-}K?_)}-}M?_)}-}O?_)}-}P?_)}-}R?_)}-}S?_)}-}T?_)}-}V?_)}-}Z?_)}-}[?_)}-}\?_)}-}`?_)}-}a?_)}-}b?_)}-}c?_)}-}f?_)}-}g?_)}-}j?_)}-}n?_)}-}o?_)}-}r?_)}-}v?_)}-}y?_)}-}{?_)}-}|?_)!20% - :_eW[r 1O20% - :_eW[r 1 ef %!20% - :_eW[r 2O"20% - :_eW[r 2 ef %!20% - :_eW[r 3O&20% - :_eW[r 3 ef %!20% - :_eW[r 4O*20% - :_eW[r 4 ef %!20% - :_eW[r 5O.20% - :_eW[r 5 ef %!20% - :_eW[r 6O220% - :_eW[r 6  ef %!40% - :_eW[r 1C40% - :_eW[r 1 %!40% - :_eW[r 2O#40% - :_eW[r 2 L湸 %!40% - :_eW[r 3O'40% - :_eW[r 3 L %!40% - :_eW[r 4C+40% - :_eW[r 4 %!40% - :_eW[r 5O/40% - :_eW[r 5 L %!40% - :_eW[r 6C340% - :_eW[r 6 %!60% - :_eW[r 1C 60% - :_eW[r 1 %!60% - :_eW[r 2O$60% - :_eW[r 2 23ٗ %!60% - :_eW[r 3O(60% - :_eW[r 3 23֚ %!60% - :_eW[r 4O,60% - :_eW[r 4 23 %! 60% - :_eW[r 5O060% - :_eW[r 5 23 %!!60% - :_eW[r 6O460% - :_eW[r 6  23 %"~vRk #hh$h 1h 1%h 21h 2%?&h 3h 3'h 4h 4(]5]  %+8^ĉ %)8^ĉ 2/8^ĉ 2 %*8^ĉ 2 238^ĉ 2 2 %+8^ĉ 2 338^ĉ 2 3 %,8^ĉ 3-8^ĉ 4.8^ĉ 5/8^ĉ 5 %/8^ĉ 608^ĉ 7/8^ĉ 7 %1 8^ĉ_hQVL?e:SRNx2(c  3}Y5}Y  a% 4Gl;`+Gl;` %5'^6 '^[0] 7{c{ }% 8hgUSCQ:_eW[r 17:_eW[r 1 %?:_eW[r 2C!:_eW[r 2 PM %@:_eW[r 3C%:_eW[r 3 Y %A:_eW[r 47):_eW[r 4 %B:_eW[r 5C-:_eW[r 5 K %C:_eW[r 6C1:_eW[r 6  F % D-N7-N  e% EQcQ ???%????????? ??? FeQoeQ ̙ ??v% G 0 ]vc   Hlʑ^ lʑ  XTableStyleMedium9PivotStyleLight1683ffff̙̙3f3fff3f3f33333f33333\`][^~NmOo`ǑƖNxhOo`VV! =" ku~+R;MP" ku{|+R;.1- KmՋ@b g!hĉRv^SbpSOo`" 6rkt^;pq" 6rkeS;gh" 6rkLN;km 7bM|;|~, [^bXT`͑'Yuu;bd, [^NGWt^6eeQV;VW* [^6eeQegn{|W;3:& [^(Wf[Npe;" [^DN;SS" a{QN;xy  /fT&T;2 zSaYNNwQSO`Qc;^_& f[90OO[9;tu. 6q~p[wQSO`Qc;Z[F>xMOcS AA@A@ familyMembers suortMembersfamilyYearIncomedisasterDescribefamilyDebtAmountfamilyDebtReasoncheckDiffName[V~+RTycheckSqyyCode3ut1uxkuNOOcheckSqyyName3ut1uTy checkYesNo/f [^;N6eeQegn{|WfamilyIncomeTypeNamecheckFamilyIncomeTypeƉRku,TRkuzfRkuvQNku]D0VYё0%m40e4TvQNRR6eeQyOё0W,g{Qё0W,gu;m901YNOiё~b0cS`N0QybQ.U[^"N_v6eeQ a{Q90b(vb){Q9 LN6eeQ vQN^S_eQ[^v6eeQ checkNamecheckXfcheckDisableTypecheckDisableLevelcheckInt0,1,2checkSuortMembersDescribecheckParentJobscheckParentCulturecheckParentAgecheckInSchoolCountcheckFamilyDiseaseDescribecheckNum0,6,2checkLen0,1,60checkFamilyYearIncomeRangecheckFamilyDisasterTimecheckLen0,1,100 checkFamilyBurstTimecheckLen0,1,100checkFamilyProperty  [^~NmOo`ǑƖ1xmsfzjhjtcysyrsldlrkburstDescribeisLowIncomeFamily isCyzdshbzisFiledPoorFamilyisTkzgjtisOrphan isJlsyfzl isDisabilitystuDisabilityLevelisAloneParentssuortMembersDescribe parentAgeisFamilyDiseasefamilyDiseaseDescribeisParentsLaborisParentsDisabilityisFamilyDisasterfamilyDisasterTimeisFamilyBurstYTNNSf[90OO[9 WaNgNOu;mO7b/f&T^chzaS[^yrVL]P[sY/f&Td[?Qf[u,gN/f&Tkuku{|+RkuI{~a{QNSpea{QN[^bXT1YNNpe6rkLN6rkeS6rkt^RRRNS[^NS[^(Wf[Npe [-N/f&T g'Yu`[^bXT`͑'Yuu `QN+Tku /f&T6rk1YNb'N1YRRR/f&TkuNP[sY6rNkuI{~kNkuI{~[^ k:Pё k:PSV[^NGWt^6eeQ [^NGWt^6eeQV [^/f&TmS6q~p[ [^mS6q~p[e 6q~p[wQSO`Qc [^/f&TmSzSaY [^mSzSaYe zSaYNNwQSO`Qc[^DN7bM|" _{:NIlW[SNS+T ^'YNI{N1 NNǏ16*NIlW[ _kXy kXQf[uE\lNNS v^N^NǏ40*NW[&{ _kXySgqf[u@b(WNN0f[!hvf[9SOO[9Sgq 03uh 0f[uW,g`QhvWGNO6eeQV[^Sgq 03uh 0f[uW,g`QhvWaNgNOu;mO7bSgq 03uh 0f[uW,g`QhvyrVL]P[sYSgq 03uh 0f[uW,g`Qhvd[?QSgq 03uh 0vf[uW,g`QhvkuISkX ƉRku 0 ,TRku 0 zfRku 0 vQNku 0N(W ,gN/f&Tku -NkXQ &T (W,gRkXQwQSOvku{|+R Lhg0^_kXySgq 03uh 0vf[uW,g`QhvkuI{~"Sgq 03uh 0[^bXTS;N>yOsQ|`Qh t^'YN70sS:Na{QNS Sgq a{QNSpe W[k,Sgq 03uh 0[^bXTS;N>yOsQ|`Qh ]\Of[`N USMOTLN:N e e h:y1YNSgq 03uh 0[^bXTS;N>yOsQ|`QhvNf[usQ|0LN Sgq 03uh 0[^bXTS;N>yOsQ|`QhvNf[usQ|0eS z^Sgq 03uh 0[^bXTS;N>yOsQ|`QhvNf[usQ|0t^.Sgq 03uh 0[^bXTS;N>yOsQ|`Qh t^:N20-60 NeP^rQ:N eP^ sS:NRRRSgq 03uh 0[^bXTS;N>yOsQ|`Qh[^bXTvpeϑ&Sgq 03uh 0[^bXTS;N>yOsQ|`Qh LN:N f[u v^Nt^(W35N NSgq 03uh 0[^bXTS;N>yOsQ|`QhveP^rQ\Sgq 03uh 0[^bXTS;N>yOsQ|`Qh Nf[usQ|:N 6rN b kN t^:N70N N b` g͑'Yuu bkuI{~:N2~N NsSƉ:N'N1YRRR1YNagNSgq [^bXT1YNNpe chSgq 03uh 0q_T[^~NmrQ gsQOo`hv[^ k:P`Q(Sgq 03uh 0q_T[^~NmrQ gsQOo`hv[^NGWg6eeQ XNN120USMO:N CQ Sgq 03uh 0q_T[^~NmrQ gsQOo`hv[^;N6eeQegnSgq 03uh 0q_T[^~NmrQ gsQOo`hv[^mS6q~p[`Q傡l gmS6q~p[ N_kXQdky=Sgq 03uh 0q_T[^~NmrQ gsQOo`hv[^mS6q~p[`Q Q[NǏ100*NW[&{ 傡l gmS6q~p[ N_kXQdkySgq 03uh 0q_T[^~NmrQ gsQOo`hv[^mSzSaYNN傡l gmSzSaY N_kXQdky=Sgq 03uh 0q_T[^~NmrQ gsQOo`hv[^mSzSaYNN Q[NǏ100*NW[&{ 傡l gmSzSaY N_kXQdkySgq 03uh 0[^Oo`hvOO?b`Q0/f&T]-n}lfelT^S/fTy{|W&T checkGendersY'`+RsY7u'`+R7uyr+RVVN,VNVeUSNd[?QpXP[sYQQgNOVuV~pvQNmQNN[^6eeQegn{|W checkYearNt^~t^~2Nt^~3 Nt^~4 Nt^~SN N5Vt^~6Vt^~SN N7Nt^~8Nt^~SN N9mQt^~10mQt^~SN NN~kuku~+RN~ku N~kuV~kucheckFamilyPropertye?bNe}lf7b1\f[!h@b(W0WgNOu;mO~ N1\f[!h@b(W0WgNOu;mO~ N2PNQNt^Q[^mS͑'Y6q~p[ S~p%N͑Nt^Q [^mS͑'Y6q~p[ S~p%N͑Nt^N N$Nt^NQ Nt^Q[^m͑'YzSaYNNN+T6q~p[ Nt^Q [^m͑'YzSaYNNN+T6q~p[ Nt^N N$Nt^NQ checkFamilyDiseaseDescribe6rkGW`͑'Yuu(N+Tku [^bXT`͑'Yuu6rkNe`͑'YuuN+Tku vQN[^bXT+Tf[u,gN `͑'YuuN+Tku 6rkGW:NR-NSN NeS z^6rkNe:NR-NSN NeS z^6rkGWl g]\ON+TQQgyi7bb{Qk7b 6rkNel g]\ON+TQQgyi7bb{Qk7b QQg*NSO\Wyi7bb*NSO\W{Qk7bb$NGW/f 6rkGW:N60hT\N N+T60hT\ 6rkNe:N60hT\N N+T60hT\ checkXfcheckHjV[8h[v680*N+VS:S 680*N+VSNYvi}T:S^Nwvb+_S͑pSN+Ti}T:S 2N+T,gN N N(W Nf[2NN N(W Nf[familyInfoEntry 7 4144010576xfdisabilityCategoryCode parentJobsparentCultureinschoolCountfatherDisabilityLevelmotherDisabilityLevelfamilyIncomeTypeCodefamilyBurstTimefamilyProperty/f&TyrVO{QNXT 7f[90OO[9(W9501CQ20000CQ 7f[90OO[9(W20001CQN N 7X[>kS)Ro` gN8RS~)R0hy0ZSi_6eeQ 7~FU0RSNSNNyiN0{QiN0R]Ncbd_b,gTv6eeQ 7a{Q$NMON NN70hT\N N  7a{Q$NMO+T$NMO SN NN70hT\N N  7 isSupport 7checkInt0,1,2 7checkInt0,1,6 7 checkSfzjh  7Sgq 03uh 0f[uW,g`QhvyrVO{Q`Q 7Sgq 03uh 0f[uW,g`Qhv^chzaS7b 7/f&T6rkNeb{Q 7Sgq 03uh 0vf[uW,g`Qhv/f&T6rkNeb{Q 76rkNN`Q 7 /f&TWGNO6eeQV[^ 7/f&TOb[a 7'Sgq 03uh 0f[uW,g`QhvOb[a +TpX0zrrrQNN^\ VlQzrrrf[P[sY 7FAILURE 7 4144012572 4144013902 4144013657 4144011845A GBB>C D]DEE2WFFFhGG%nHHMIQK M- HPQK9R}RRSYFSSTNVjWdWX4Z[ ccB4c=_MA ɀ  |y dMbP?_*+%{&ffffff?'ffffff?(?)?MvMicrosoft XPS Document Writer 4dXXA4GIS4DINU" |r  SMTJ{0F4130DD-19C7-7ab6-99A1-980F03B2EE4E}InputBinFORMSOURCERESDLLUniresDLLInterleavingOFFImageTypeJPEGMedOrientationPORTRAITCollateOFFResolutionOption1PaperSizeLETTERColorMode24bppV4DM" d333333?333333?&<3cAU} O} O} O} O}  O} O} O} O} O} O} O} O} O} O} `O} O} `'O}  O} O} O} O} O}  O} @"O}  O} O}  O} O} O} @"O} !!@O} ""O} ##O} $$O} %%@O} &&O} ''O} (_ O} `a O} bO} O}  O MM7PMMM*N(Q'{@ {@ {@ {@ U y V R R R R R R R R l V R c! R" d! R# R$ V% d! } R& c R' V R V V c( c) | d !c "V+ #V, $a %V- &V. 'j/(SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSW @$SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS TXT Y0TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT&SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS`SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1  Z1  Z1  Z1  Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1 Z1  Z1 !Z1 "Z1 #Z1 $Z1 %Z1 &Z1 'S1(SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS [2 [3\hi\i\iiik\i b\ b4 \\\ b5 b\i\ii\\ g g b  b !i[" #b $i[% &g6'`SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS\h`Zfb\ii j\ kz l\7 mi8 ni9 oi: pk; q[< ri= s\ tb> u\?vb w\@x\ y\ zb {bA |\i} ~\ iB iC [D [E g g bbh i [F bGi [H gS ` ]I ]J ^K ^ ^ ^L ^M ^N ^O  ^  ^P  ^Q  ^R ^ ^S ^T ^U ^ ^W ^X ^Y ^Z ^[ ^\ e] ^^ ^_ ^` ^a ^b ^c ^d  ^ !^f "^g #^h $^i %^j &^k '^lbbQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQ _n _o _p _ _q _r _ _s _t  _  _u  mv  _w _ _x _y _z _{ _| _} _~ _ _ _ _ _ _ _ _ _ _ _  _ !_ "_ #_ $_ %_ &_ '_{#{&{ { { {. :@* 0 Fbv.(   vj N(X?KOG]4v6@( t/nB 3r3(<kXQf[uvYT<~~  <CC@],@tT7P9$< _Yhg<~~ i <АCC@7],5@АtT49$<_ Y h g<ZR bv C   K ]Fb>!@u v6admin> @dinjn  7b>1  ;SS''1  ;^_%%1  ;Z[""1  ;3:   ;$$!!   9  ;MP 1  ;bd1  ;1  ;pq1  ;gh9  ;km1  ;xy1  ;.1 1  ;tuf  t    Sheet1ggD ɀ   dMbP?_*+%&ffffff?'ffffff?(?)?MFoxit Reader PDF Printer_ 4dXXA4" dXX333333?333333?&<3U} L} J} @+J} !J}  K}  K}  K}  K@ , , , , ,,,,,, p q q p nnn rnnnnnnn oIIII K II? s Innnn II I Innnnnntnnnnn II@ s Innnn II? s InnnnIIII nntunnnn I I? s u nnnn I I5@ s u nnnn I I6@ s u nnnn II@ t unnnnnntunnnnnntunnnnnntunntu I II I I II? I I II@ I I I I@ I I I I@ I I II@ I I II@ I I II@ I I II @ I I II"@ I I II$@ I IIII I I I I I I? I IDH lV& NNNNNNNN<<<<<<<<<<<< !"#$%&'()*+,-./012@34:5:67:8Y@9:;=>?@ I  I@ I I !I !I@ !I !I "I "I@ "I "I #I #I@ #I #I $I $I@ $I $I %I %I@ %I %I &I &I @ &I &I 'I 'I"@ 'I 'I (I (I$@ (I (I )I )I@ )I )I *I *I @ *I *I +I +I"@ +I +I ,I ,I$@ ,I ,I-I .v.I? .I .IQ /v/I@ /I /IQ 0v0I@ 0I 0IQ 1v1I"@ 1I 1IQ2nnnn 3I3I? 3I 3I 4I4I@ 4w 4I 5I5I@ 5w 5I 6I6I@ 6w 6I 7I7I@ 7w 7I 8I8I@ 8I 8I 9I9I@ 9I 9I :I:I @ :I :I;I=nxnn>nxnn?nxnn@nxnnDl<<<<<<<<<<<<< <<<<<<<<<<<< ABCDEFGHIJKMNOPSVWZ[^_bcdghklmpq AI Ax1 Ax AI BI Bx Bx BI CI Cx Cx CI DI Dx Dx DI EI Ex Ex EI FI Fx Fx FI GI Gx Gx GI HI Hx Hx HI II Ix Ix II JI Jx Jx JIKnxnn MI MI? MI MI NI NI@ NI NI OI OI@ OI OI PI PI@ PI PI SISI? SI SIl VI*VI? VI VIe WI*WI@ WI WIe Zy+ZI? ZI ZIh [y+[I@ [I [Ih ^I-^I? ^I ^Ik _I-_I@ _I _Ik bIbI? bI bI cIcI@ cI cI dIdI@ dI dI gv$gI? gI gIW hv$hI@ hI hIW kI#kI? kI kIV lI#lI@ lI lIV mI#mI@ mI mIV pv%pI? pI pIX qv%qI@ qI qIXD l8888888888<<<<<<<<<<<<<<<<<<<<tuxy|}~ tItI? tI tIK uIuI@ uI uIK xv"xI? xI xIT yv"yI@ yI yIT |I|I? |I |Im }I}I@ }I }Im ~I~I@ ~I ~Im v&I? I I[ v&I@ I I[<<<<<<<<PH  0(   >@RRR 7 Sheet5ggD ɀ ަ dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3Unnnnnnd PH00(  >@ 7 Sheet6ggD K*   rU ~~~~~~~~#~~~~~~~~~~~~~~~~~~~~~~~~h zD-`N  a   a  a    ( a  x!Yy1a )Y1a  Qa  H 1JY)Ii )Aa)Iqia `q a  1 ThisWorkbookSheet1Sheet6ӡԤߺУ麯ShowFormSheet5 PrintForm VBAProjectF /C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  A`F:C:\Program Files (x86)\Microsoft Office\OFFICE12\EXCEL.EXEExcel A65530 9p0FC:\Windows\SysWOW64\stdole2.tlbstdole aL-[DREC:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLLOffice Ai.E.`M 9C:\Program Files (x86)\Microsoft Office\OFFICE12\FM20.DLLMSForms qqFeM.&LClearContentsEnd4C:\Users\ADMINI~1\AppData\Local\Temp\VBE\MSForms.exd q FfsAkFJTFKc(ldDFWorkbookWorkbook_BeforeSave @ .`/f&Tnx\OX[excel YOX[ pQ nx[ , &|~\ۏLhg!h YNOX[ pQ Sm ? Oo` Nxh f,F 00 $4DHLPdУ򲢴ӡϢ checkTheSame VBE6.DLL` S FF)F 0]\OhpevNcknx N}ge!jgT QۏLdk!h 1qazPasswordProtectUnprotect Cells RangeRowcheckedRequiredStartwriteLog writeLogRedaddCommentXQStartclearCommentsXQStartbeginCheck_commentcallFunctionXQStart regCheckFunccheckTheSameXQNewGetRowOrColIndexcheckDMB deleteRowsetCellValueCountXQdeleteRowNoProsetCellValueXQ setDMBCoderemoveSpaceXQ IV5Fg]lO#h8; FOa̰LDF Worksheet 'Worksheet_BeforeDoubleClickaaaaaaaaaaaaFF FAILURE 4`nx[_YhgT hgǏ z-N RsQexcel &TRS[penc"N1Ybhg1Y% )nc:yTabColorIndex "l gg~b0Rf[uOo` elۏL!hName -NOo`Y N  value - : ; Locked ,{ Lvpency -N\ gN*NkXQcknxhgRows Delete dk!k!h-N RdN ,LeHepencYT0f[M|S0NNS0'`+R0 6Queg-N g4*NS4*NN NR!h1Y%sS9eL:NeHepenc * gOo` g w Oo` h ۏLOck Select !hǏ! SUCCESS * g͑Ypenc g w Oo` h ۏLOck  M\7b:f`D-D JfL&&cʯmoK*Ǫ.@@᤽W$C=eQT|checkRequired checkStuNamecheckBirthdaycheckBirthdayNecessary IsIDNumber checkSchCode checkFamType checkRXDate checkYear checkMonthcheckXJHcheckPhoneNum checkBankcheckXn checkOptioncompare compareDeccheckLencheckIntcheckValcheckNum checkIsIntcheckIsNumber checkMoney checkMoneyTJcheckPersonNumcheckIdNumLink checkSpLencheckS Browse_Print 0 checkLen* checkLen checkNum* checkNum checkVal* checkVal checkInt* checkInt checkTerm1 1 checkTerm checkYesNo1 checkYesNo checkDiffName1 checkDiffName checkDiffCode1 checkDiffCode checkIDCardType1 checkIDCardType checkSqyyName1 checkSqyyName checkYear1 checkYear checkSpLen* checkSpLen checkNull N:Nzzhg checkName >kXQNcknx_{:NIlW[ ^'YN1 NǏ16*NW[&{ hg checkBirthday .kXQNcknx ySN:Nzz0kXQ R^_{:N MOhg 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Ǐ @kXQNcknx yN:Nzz N_{:NpeW[ 'YN0 tepeMO^NǏ $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 y_{:Nf[uNShg checkXJH 0, 1, 50 NkXQNcknx ySN:Nzz N:Nzz^_{'YNI{N1MO NNǏ50MOhg " Y2013-12-21 hg HkXQNcknx yN:Nzz N^_{'YNI{N1MO NNǏ50MOhg checkBank kXQNcknxhg checkXn 2kXQNcknx y  |&xRRME (@N006 <NhH0hPTP`HX@ʘxBʀ @ʀ4 @ꀀD @.L @%Ϣ˵%ꀚ@V  @Z  @\h\ @^B`X@ @ʀd @x@bz@ʘ0BdH~ @DXhB!ʘhB#%@&@%R(BVHpHVpHʀ @$ @Z8Hh @ꀔP@T @ X  @ꀖ^ @0Bꀂ` @Xt@ꀜ| @. BʘfpB"ʘjB$pHPxh p(08H0X@XL0'=:Z*\R1*#222$*\Rffff*1A5998191a(*\Rffff*1A5998191a\077    08  @ ` Dp 8 0 P0pD084P. ..(8(`>"$(@>`R^FX `*0$`  $  ^(^^^0p@һṹҳ]$H=Public Const sheetNameValueTJ As String = "2ʵͳ"]$Ϣ(2Public Const IntroSheetName As String = "˵"]$H]$˵P] p ¼ܵУ]$¼ͷ] x"ִ һǿУ ĵԪĿ] 6ִ һǿУ ĵԪΪϹĿ ] ÿһкϼеֵ] "һǿУʱ¼Ԫ] Ϣ] %---ģУ¼ĸԪ ] 8---ģУ¼ĵԪ]  Уʱ洢ַ] ¼ʱرհť ]  ¼ܵУǷвϹ] @ ¼ܵУǷظ] #¼ܵУǷظ] %/¼ЧǰǷдϢ ״̬] h#У鷽ķֵ]$)¼ʼк8]$)ѧ֤ſʼλ]D0¼ΪյĿ]X"/ǷΪЧ ͳ 5ֶΪյĸ] "C¼ȥոִнȥ˿ո򷵻true򷵻false] PcellԭʼĵݣϵͳûнԶûĴ֮ǰcell] 7ϴдϢʱڵ,ӦĿʼʱʼֵһ] ] ] RڸݱʶòͬķʱжǷforѭ Cell_SelectionChangeҪõñ]$¼ʡصȼ¼ڵ]$0+sheet±Ƿ]  ]$hH)е]$X,϶]$p#϶ʱ]$%϶ԭ] -Oʶ϶ǷͨУ 0-δͨУ 1-ͨУֵΪ 2-ͨУֵΪ] $Oʶ϶ʱǷͨУ 0-δͨУ 1-ͨУֵΪ 2-ͨУֵΪ>Attribute 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= 2 'ѧ֤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ҪÀñ^A,headI= 3D|ȑ,& Sqs79,2r0±P DnottinueQ$AqPJcPlubS7104 'Bd?sysDifficultyGradeq729 '϶hwtsintifyDG!s30 '1ʱ?6Rea(sonT1Sԭ\sO W6$1 ͨJ 0-δ 1B-ֵA< 2:Q6*_'_%__SrU~|  KQ)yqAQ l  a` ah!9YyH(xtq1Yq )9Qyp 1aD0)$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)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)p400# |\L8(xXlhH8(@hig< H,ptP0hH0   fa (*\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.6#0#C:\Program Files (x86)\Microsoft Office\OFFICE12\EXCEL.EXE#Microsoft Excel 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.4#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 12.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{9C659846-18DA-4DF8-B8EA-132E26DE4CC0}#2.0#0#C:\Users\ADMINI~1\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E.`M   :Z   ThisWorkbook1@5998191aThisWorkbookzLxJ Sheet11D5998191b+ Sheet1H Sheet61F5998191b7 Sheet60SbpSȉ0R599819798SbpSȉH]wQQpe1C5998191bB]wQQpex`AXf1A5998191aLXf&x!hQpe0S5ae1de49l!hQpe~`j;N z^1B5998191a;N z^Ux`J.ShowForm1<59981915ShowFormn1 Sheet51E5998191b Sheet5hPrintForm1?59981915PrintFormʘx0H`gS_k-@LfAF2D"njHH{A|}BGfI$D!)bZTӋuD2P^٠L>-\LDԾN26?fԙvdM+Xv]w(=TEyrq\'cf@#`N> nAJ}u9;U!8compare Excel+` VBA`Win16~`Win32`Mac`VBA6#` VBAProject`stdole``Officeu`MSFormsC` ThisWorkbook|` _Evaluate`Workbook_BeforeSave l`SaveAsUI`Cancel` (isSaveButtoná`MsgBoxR`ChrK~` vbOKCancelx?`vbOK%`(У򲢴ӡϢ` Sheet1`'Worksheet_BeforeDoubleClickaaaaaaaaaaaar`(TargetF`Range `vbYesNo`vbYesa?` Sheet6` ӡԤX` (Browse_Prints` Worksheets`Visible` PrintPreview` ߺ`(checkedRequiredStartR`rowIndex6d` columnIndexP` cellValue@` ActiveSheet%N`Cells`(writeLog{u`contentl`Sheets ` (msgSheetName'` (curMsgRow/` (writeLogRedm`nLene,` Charactersrg`FontU` ColorIndex`(addCommentXQStartS` sheetIndex ` errorInfo` AddComment`Interior;`Color2F`CommentHs`(clearCommentsXQStart7`ClearCommentsf`sheet2RecordNum`ffTotalNumColumn`xlNone`(beginCheck_comment;D` checkMethodHd`(errorMsg'|`(removeSpaceFlag` (cellContent`(callFunctionXQStart `typeVal#`isValidateCount8`valueK`titleMsgh` (startTitlel` (headIndex` (functionArgs8M`(checkMethodXQ`(checkRequiredb`(hasErrorf`(isFord`(removeSpaceXQ` (checkStuNamec`(checkLeng`functionArgsArr`Split)` (checkSpLen`(checkNumh`(checkValK`(checkInt` (IsIDNumber-*`(checkS)` (checkBankUw`(checkDMB` (setDMBCoded`(checkXn` (checkMonth`(checkBirthday`(checkBirthdayNecessary`(checkPhoneNum` (checkOption,`(sysDifficultyGradeNameFlag`Trim@`(indentifyDateFlag `(hasErrorIdNum`(atLeaOneNNullCount` (checkMoneyi` (totalMoney%`baojiaoMoneyColumns`baojiaoMoneySumk`huoshiMoneyColumn_`huoshiMoneySumr`zhusuMoneyColumn_`zhusuMoneySum>-`othersMoneyColumnߥ`othersMoneySumH`(atLeaOneNullCount` (atLeaError~` (regCheckFuncE`reg`regEX*` CreateObject`Patterni` IgnoreCase0`Test4`(checkTheSameXQNew` sheetIndex2n`(rnaO`xlUp`Row`ClearContents{`i``cardID1[?` (cardIDColumn-h`ja`cardID2\?` (hasTheSame`(GetRowOrColIndexf`keyWordF`kbn1`cZ`Findn`WhatC`LookInP`xlValueso`LookAtO`xlWhole`Columni`value1`flag`rowData1`Count0v`rowNummR`(AreasheetIndexH` (deleteRow` Unprotect?`Password`RowsU`Deletex`(setCellValueCountXQ]`colIndex`(deleteRowNoPro`(setCellValueXQ` codeValue` (columnPlus`length1S`length2T`Replacef` i`(!ValueColumType` columnNamew`(sheetIndexValue1`(AreaSheetName`(readmeSheetName` (totalCount-`(rgold`(hasErrorInValidateU` (dataRowStart` isNullRowNum8`(cna`(notContinueBoolt`(sysDifficultyGradeNameColr`(indentifyDateCol&`(indentifyReasonCol*9` У麯&`IDNumber4 `Wm`UCase5 `sj`Tk` babyIDColumn` IsNumeric$*`Right` (checkSchCode` (checkFamType` (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` Application*`ScreenUpdating! `xlToLeftWY`rowType`md`ne`Locked `totalMoneySumZ`pg`qh` (checkTheSameg`myDico`myKey`varData`idNumDick` idNumDicData`cardNum\`Exists]`Addr`Keysq`Resize@4`WorksheetFunction&` Transpose` ShowForm`CancelButton_Click`Hide9z`ConformButton_Clickwf`Flasep` Sheet5` PrintForm`Workbookk` Worksheet`_Defaultj`BeforeDoubleClickaaaaaaaaaaaa\`_B_var_isNullRowNum;r` _B_var_Chr\;`_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` BeforeSave` _B_var_value`_B_var_titleMsg` _B_var_Midp`_B_var_functionArgsArrOj` _B_var_TrimmT`_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_sheet2RecordNum`_B_var_ffTotalNumColumn}#` _B_var_UCasea`_B_var_babyIDColumnZT` _B_var_Right9` _B_var_Count:`_B_var_rowNum`_B_var_value1J`_B_var_maxIntLen`_B_var_maxDoubleLen`_B_var_intLength`_B_var_intValue\`_B_var_douValue`_B_var_cardID1^3`_B_var_cardID2_3` (removeEnter`addr`vbBinaryCompare̝`Clean` _B_var_addr%]`+   79 MC m "@ p0(P'q`XX HH  rU~| Q)yAQ 1 `I @ )!a!!! "I"a"""#i## $Q$$$I%%% &I&&|Yq&HlI&1'Q  (y((!)Q))!**)+a+ ,i,,y,A-q--I).../! 000!1Q11 2q22!2)33!/' 4aI4445YAq5566Y7 88q9:;i;t;7 <<<1==>>>!?? @i@Y(@AB DC)CQCCyD!DDDQEEJ9JYJG CC HHAHaHHHIIp0  \E @(4%F%T:X %h$hdT)hTv {  x\(0lhT0   DN$%DX%h$hdD)hD5V4%DX%h$hdD=C)hD6Rf4%DX%h$hdD=C)hD6(0lhDt$GDX%h$hdD$)hD5$%X/4H/$'S(%DX%h$hdD4=$C)hD64$V%DX%h$hdD4=$C)hD64$$00l hD4$t\LR4\%H$Hd4LA$qc)H46L$l lllL 5LlllL 5Ll lllL 5LllllL 5Luh:\+8L:$:" e" e:td``P 0/`6L$dPj,t(0lD`H4L$dP8$8@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$z28:X3]3lll$ 45$lll$ 55$IDX%h$hdD$A4)hD5$4$ 6$Vz*5$ u*::X+H$:,:7`.6$z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z28:X]3 lll$ 45$lll$ 55$ MX@4$ 8 $Vz*5$ u*M ,:X9N$$v :t5$?(X%t$(]/t5I'6$\:X+H$:,:;(%tdT:<D`.6$dTD4 ?(X%t$(]/t5I'6$~:X+H$:,:=(%tdT:>D(4%t:<`.6$dTD4 ?(X%t$(]/t5I'6$w\:X+H$:,:?(%tdT:<D`.6$dTD4 ?(X%t$(]/t5I'6$4 ~:X+H$:,:@(%tdT:>D(4%t:<`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:X']3 MX@4$ A $Vz*5$ u* ,:X9N$$v :t5$?(X%t$(]/t5I'6$ \:X+H$:,:;(%tdT:BD`.6$dTD ?(X%t$(]/t5I'6$B ~:X+H$:,:=(%tdT:>D(4%t:B`.6$dTD ?(X%t$(]/t5I'6$ \:X+H$:,:?(%tdT:BD`.6$dTD ?(X%t$(]/t5I'6$ ~:X+H$:,:@(%tdT:>D(4%t:B`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:X]3 MX@4$ C $Vz*5$ u*,:X9N$$v :t5$(X%t$(]35$~:X+H$:,:D(%tdT:ED(4%t:<`.6$dTD?(X%t$(]/t5I'6$~:X+H$:,:F(%tdT:ED(4%t:<`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:X]3! MX@4$ G $Vz*5$ u*,:X9N$$v :t5$~:X+H$:,:H(%tdT:ID(4%t:J`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:X]3 MX@4$ K $Vz*5$ u*,:X9N$$v :t5$(X%t$(]35$&~:X+H$:,:L(%tdT:MD(4%t:<`.6$dTD(X%t$(]35$~:X+H$:,:N(%tdT:MD(4%t:<`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:XO]3"X4 Pz*2 u*::X+H$:,:Q`.6$z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z28:XR]3':XSN$$4 8 Vz*6$ u*::X+H$:,:T`.6$z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z28:XR]34$ U$Vz*5$ u*R::X+H$:,:V`.6$z/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z28:XW]3|4$ X$Vz*5$ u*J~:X+H$:,:H(%tdT:ID(4%t:J`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:X%]3p.(4:X%N$$ YVz*6$ u*::X+H$:,:Z`.6$z/.$ 05$>%lll:X%N$$ [6$&.MH@ll*MX @l$ 15$z28:X\]3$4$ ]$Vz*5$ u*::X+H$:,:^`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z28:X_]34$ `$Vz*5$ u*::X+H$:,:a`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z28:Xb]34$ c$Vz*5$ u*:X+H$:,:d"d edT:fD" e:g`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:Xh]34$ i$Vz*5$ u*:X+H$:,:d"d edT:fD" e:j`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:Xk]34$ i$Vz*5$ u*:X+H$:,:d"d edT:fD" e:j`.6$dTDz/.$ 05$ H(X$b &.MH@ll*MX @l$ 15$z28:Xl]34$ m$Vz*5$ u*:X+H$:,:d"d edT:nD" e:o`.6$dTDz/.$ 05$&.MH@ll*MX @l$ 15$z28:Xp]3!($B4 q Vz*6$ u*_::X+H$:,:r`.6$z/.$ 05$&.MH@ll*MX @l$ 15$z28:X]3/MH@4:XN$$ YVz*6$ u*4::X+H$:,:Z`.6$z/zs.$ 05$%lll:XN$$ [6$4$ t$:X ]35$zszs&.MH@ll*MX @l$ 15$z28:Xu]34$ c$Vz*5$ u*:X+H$:,:d"d edT:fD" e:g`.6$dTDz/.$ 05$zvs4usH4$ t$:X ]/'6$Hzvq4usH4$ t$:X ]<'6$Hzvq::X+H$:,:w`.6$z/z*.$ 05$zv&.MH@ll*MX @l$ 15$z28:Xx]3 .(4:XxN$$ YVz*6$ u*@ ::X+H$:,:Z`.6$z/.$ 05$g %lll:XxN$$ [6$&.MH@ll*MX @l$ 15$z28:Xy]3" z MX@4$ 8 $Vz*5$ u*/!::X+H$:,:{`.6$z/.$ 05$";usuvH4$ t$:X ]/'6$Ho!";usuvH4$ t$:X ]<'6$H!";usuvH4$ t$:X ]/'6$HC"::X+H$:,:|`.6$z/.$ 05$z*"::X+H$:,:}`.6$z/.$ 05$z*&.MH@ll*MX @l$ 15$z28:X!]3#/MH@4:X!N$$ YVz*6$ u*m#::X+H$:,:Z`.6$z/.$ 05$#%lll:X!N$$ [6$&.MH@ll*MX @l$ 15$z28:X~]3$/MH@4:X~N$$ YVz*6$ u*b$::X+H$:,:Z`.6$z/.$ 05$$%lll:X~N$$ [6$&.MH@ll*MX @l$ 15$z28:X]3%/MH@4:XN$$ YVz*6$ u*W%::X+H$:,:Z`.6$z/.$ 05$~%%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]3&4:HN4:XN$$ YVz*6$ u*l&z::X+H$:,:Z`.6$z/.$ 05$ H(X$b &%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]3'/MH@4:XN$$ YVz*6$ u*a'::X+H$:,:Z`.6$z/.$ 05$'%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X#]3(/MH@4:X#N$$ YVz*6$ u*V(::X+H$:,:Z`.6$z/.$ 05$}(%lll:X#N$$ [6$&.MH@ll*MX @l$ 15$z28:X]3)3MH@4:XN$$ YĔ6$C)::X+H$:,:Z`.6$z/.$ 05$EMH@4:XN$$ Y.M@lll 16$z28:X]3*/MH@4:XN$$ YVz*6$ u*0*::X+H$:,:Z`.6$z/.$ 05$W*%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]3~+/MH@4:XN$$ YVz*6$ u*%+::X+H$:,:Z`.6$z/.$ 05$L+%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X~]3s,/MH@4:X~N$$ YVz*6$ u*,::X+H$:,:Z`.6$z/.$ 05$A,%lll:X~N$$ [6$&.MH@ll*MX @l$ 15$z28:X]3h-/MH@4:XN$$ YVz*6$ u*-::X+H$:,:Z`.6$z/.$ 05$6-%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]3]./MH@4:XN$$ YVz*6$ u*.::X+H$:,:Z`.6$z/.$ 05$+.%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]3R//MH@4:XN$$ YVz*6$ u*.::X+H$:,:Z`.6$z/.$ 05$ /%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]3G0/MH@4:XN$$ YVz*6$ u*/::X+H$:,:Z`.6$z/.$ 05$0%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]3<1/MH@4:XN$$ YVz*6$ u*0::X+H$:,:Z`.6$z/.$ 05$ 1%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]312/MH@4:XN$$ YVz*6$ u*1::X+H$:,:Z`.6$z/.$ 05$1%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]3&3/MH@4:XN$$ YVz*6$ u*2::X+H$:,:Z`.6$z/.$ 05$2%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]34/MH@4:XN$$ YVz*6$ u*3::X+H$:,:Z`.6$z/.$ 05$3%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]35/MH@4:XN$$ YVz*6$ u*4::X+H$:,:Z`.6$z/.$ 05$4%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]36/MH@4:XN$$ YVz*6$ u*5::X+H$:,:Z`.6$z/.$ 05$5%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]36/MH@4:XN$$ YVz*6$ u*6::X+H$:,:Z`.6$z/.$ 05$6%lll:XN$$ [6$&.MH@ll*MX @l$ 15$z28:X]38(X$)4$ $4(X]<'5$74$X374$7374$7|37l4$l7\37L4$L8(X$$:X5$z20$8\0Dl4|Ltl\DhD$dTD54pX X4h5XcH%h8%hfH%hhXlchTp,0lhXH^%:4%DX%h$hdD>AUz)hD6;D:X %h$hdDW)hD5 { (4 uDHhE @($%DX%h$hdD)hD(4 (XhdE @($%DX%h$hdDT)hDT37:X+:H:4D`.6D. 05z ~d ~H 8H00 ltdT$hDD( hXl,CTpzoX @%%:8%HhL$LdH 4P)LH6lPclT0PWUpz5PWUpz5(40ThXP LHtL:\ ]3Dl< t<:\ ]35<B c\l (\ [%:L%(\%$d<>,A)6<, f\lL%(\% $Dh\N @(%(\%$d<3)5<H (\< O\ ~$t <(\,5A)86%((% $D\\hd`N @(%((%8$8d3)85L((S` ~d$\T\((5h4{VT @(%((%8$8dAKF$)86$;" : "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 h4+p=1  ; ; ; @ xH" 2$ @H6 * :@HP  X h, a--------------------------------------------ʼУ-----------------------------------------]@]X+ijһ͵ıʶкź͸ʽ3:1;2]p ʶ(ĬϱʶԶʶ)](ijһ͵ıʶ飨кź͸ʽ] ijһͱʶľֵ]ԶʶЌ]%Ѽ¼ΪյкŷŽ] <!*'"ȡĿ 0ĿȷģٽдУA@  1qaz4$<B@|k1qaz4$<B@21qaz4$<B@21qaz4$<B@2 V$T!NB@-$ÿοʼʱѴϢsheet,'XϢ¼ʼ'.ôУУ¼Ƿд֣׶ϢУ ('#Ĭ϶ѼδͨУ'Ĭ϶δͨУ V$T!NB@-$ÿοʼʱѴϢsheet, A65530$<%0%!' A@: ȡ  IV5 *%0%!"'bxcna = Worksheets(1).Range("1:1").Find(What:="*", After:=[a1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).ColumnFAILUREA@@&+ȡǷУɹ־Ԫ񣬲ֵʼΪ0'`ռ¼ʼΪ0  &" ʱִРd ʼУ鰴ť¼ʱִ.ȷʼ Уرexcel $"ܵݶʧʧ $ܰʾ$  &d1qaz4$<B@ |kk.$<!b(b)ҳǩΪɫ    "ûвҵѧϢ޷У飡A@ '1qaz4$<B@|k'ôУУ¼Ƿд$<!дϢ£A@P     '<"ִ һǿУ ĵԪĿ';6ִ һǿУ ĵԪΪϹĿ'''5"һǿУʱ¼Ԫ'9ǷΪЧ¼ '\C¼УǰǷд ';¼ԱǷд  b  $<%N!'Oһбʶֵ'2=жforѭǷcallFunctionXQStart ûִĬϷ <ʶΪ -$'Gʽ14-3:25  :$'H6ʽ3:25ȡıʶвֳ֣кź͹ DJҪּϵҪУ飨ĬУ͵ԶУ   Y&+1ΪеһԪΪĬУ  $:$'V*ȡıʶвֳ֣кź͹$'SԶʶ  $;$'cԶʶ͵ľֵ   gԱʶб $   A@}ݱʶֵöӦķ k   $;$'Pȡıʶв   WԱʶб $   A@0k( eJ ʽ3:25 $'QԶʶ  Pʶеڵǰ$;$'eԶʶ͵ľֵ   kԱʶб $   A@ݱʶֵöӦķkd-ֻĬУʽ14$;$'Hȡıʶв   OԱʶб $   A@0k(k   $<%N(  6ִ һǿУ ĵԪΪϹĿ     е һдȷ''8УʱдϢ A@P  'd   'Tÿһкϼеֵk <,һؼֶȫ򽫸ɾ  `+ ` '`,"ϢеĸдϢɾ  X  X X  V$T%6B@8r Ѹɾ  X  'X \'k k  ` 6 ɾЧ $'  A@0B Ѹɾd8   A@0H Ѹɾk  ` ˴Уɾ `,Чݣѧš֤šԱ $"444УʧܼΪЧݣA@ kH *дϢ鿴ϢA@ $<!b(b V$TB@Hd ' A@ '%ִУظݷ,ûظǷҪɾЧ Уͨ!A@ .$<!b(bSUCCESSA@@:+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 A65530$<%0%!' A@:d *ظݣ鿴ϢA@ $<!b(b V$TB@Hk( k 1qaz4$<B@1qaz4$<B@1qaz4$<B@o q-------------------------------------------------ظijһ------------------------------------------------ ]`x] A65535 L%0%!'2Scripting.Dictionary$.O8O  L%0!'>ȡѧ  %"ѧ໤֤ݽб   %-֤Ų  B@&#addһΪkeyڶΪvaluekk !'Sheet2$<G:G70B@  !% !*G170,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".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%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 #1O 'c0= `hP& !: "(#j~xME,6 LL <0<4<8<<<p ` @ If `IF IH H`J 8``<ر`v: ~` X  \I У@  `   hI @  ` H  tI @  `  I I @  ` X I @   `  I @  ` H I @ `  I @@  ` 8 I `@ @ `  I$ I  D` H  I$ hI   `   I$ I   ``kH I h I   ``k I  I   ` H (I h I   `80k &&:I  I   ` H  `I @  `  lI  X `  uI @  `  I @ H`   I @ 8` ""I IF I< ` ` `H````@ ` @ ` @ ` @ ` x ""I I @ `   I Shee@ xl %( j0`Hkx  If IF I<  88    0  X H@jl N"n@h @lX 0@H @8 `ntp`<p79058421637905842 10X98765432@( @ @ H@l @L  @< xH0`z `nt`<prz| @` @`P @@ @x( @ @  @ X@@ @( @ @h p@  p X8@l H z4@\ @X @H @8 @0( @ @` @ @H @x @ @ @ @ @ @ @ @ p @` 0 H@p(@l z4@X\ @X @H @8 @`( @ @ @ @ @ @ @ @ @x @ @ @t @d @` @P @ @ @0 @l `8  H 8h X@8(P4==============@p\ ij@X ====@H ====@8 chec@( '@ @0 $@ @ @H @` @ д@x 0@ $@ λ@ λ@ $@p @` .:Z$*\Rffff*0S5ae1de49*\R0*#9*\R0*#f*\R1*#222*\R1*#10d*\R1*#33b*\R1*#fc*\R1*#221$*\Rffff*1C5998191b*\R0*#13*\R0*#10  B       (  B "   08 @HP .B /,/ 5(/ H/G`/ x/-/// XB     p B  08@ n  B ,$"+ HH(`   "2  .8P"?h  4S    B         ( 0   B   6 0 @ H P X ` |h   B  ( 00 ` p x    x  0B  H P ` x x B   |  B  $ (08 |@  B  fp | ( HB  `hp  P pB  : (0 8@HPX` h   B  8 @PX ` hx    .8B  h p    .hB    B 6  & D4pH  7  B 6  &   ((,0 X`Dh4p  7  @HPX` hB   (08 @` "h  <  B 6  &  ( 0 P"!X  $ "        40  P X `  h >I  D 4j   !  !(! 0!8! @! ! !B  """("8"@"H"P"X" `" " #B  (#0# 8# H#P#X# `# # $B  ($0$ 8$X$h$p$x$$$ $ (% H%B  `%h%p%%%%%%% % X& x&B  &&&&&&&&& & ' 'B  ' &' $( 8( X(&h(*("($()(0)X)x))))) ) 2*8*"X***  ***8*(+0+ 8+B  +++&+, ,&(,P,X,`,h,Dp,4,,----  -(-0-P-p--------- - H. h.B  ........./-----------------------------------------1 ,дϢʾ Ϣsheet--------------------------------------- ʱ0Ϊʱ1 Ԫ] F H f$<%N'J J'd'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalsel 1ʽȷtrueL]^[\u4e00-\ue863]{1,16}$'HK  $'d'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------LL#0 $For'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]))))$"\ST^((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]))))$'A  $'d'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)--------------------------------------- Li]^((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]))))$'s  $'d@'k0i(h-----------------------------------------4 У֤---------------------------------------6Ϲ򷵻trueAϹ򷵻falseDA1 ]790584216379058420Ȩ2\] 10X987654320Уso n$$r'n'ȥո Co] ( < x n6)׶֤Ϊ,ΪͨУ'zk nGzj00 n$$zGzj:\W n*[0-9X]Gzj2\ ocx p $'v vG 'vj t n $ v 't) t 'v n$|  v $G'j11i----------------------------------------5 -УѧУѧУʶ 42λһλΪֻx-------------------------------------------------------------ʽȷfalse ʽȷtrue5]x^[1-9]\d{40}[\dx]$'97D  $'~dh'~kXiPz----------------------------------------6 -У黧 -------------------------------------------------------------ʽȷfalse 8.ʽȷtruea].^(\u519c\u6751)|(\u53bf\u9547)|(\u57ce\u5e02)$'1  $'d0'k iu-----------------------------------------7 Уѧʱ-------------------------------------------------------------Liʽȷfalseʽȷtrue]h'^(((19)|(20))\d{2})((0[0-9])|(1[0-2]))$'  $'d'kiq-----------------------------------------7 У-------------------------------------------------------------ʽȷfalse8ʽȷtrue h ,ΪDZ'kzk]^((19\d{2})|(2\d{3}))$'  $'d'kiq-----------------------------------------7 У·-------------------------------------------------------------ʽȷfalse0-Cʽȷtrue0]x^((0[0-9])|(1[0-2]))$'S  $'d'kpihv-----------------------------------------9 Уѧ-------------------------------------------------------------44ʽȷfalse:\Pʽȷtrues]^\d{4}[0-7]\d{3}[0-3]\d{7}$'of  $'dX'kHi@v-----------------------------------------10 У绰-----------------------------------------------------------------ʽȷfalse------ʽȷtrue]h^\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'<  $'dp'k`iXv-----------------------------------------11 Уп-----------------------------------------------------------------ʽȷfalseʽȷtrue--]^[1-9]\d{14,20}$'  $'dX'kHi@-----------------------------------------checkXn Уѧ磨2012-2013-------------------------------------------------------------עʽȷfalsedʽȷtrue"]X]p1^(20\d{2}-20\d{2})|(19\d{2}-19\d{2})|(1999-2000)$'У  $ -$'A@r$$ 'd 'k d 'k i -----------------------------------------checkOption У鱸ע磨Сvalue2---------------------------------------------------------------ȲС200false---- 򷵻true------ $----'z k $  --'dx 'kh i` ------------------------------------------------------ȽϴС(Сڵڷtrue)------------------------------------------------------------------'value1value2false 򷵻true-- $X'$Ϣ X' $  H'DdP 'Dk@ i8 ------------------------------------------------------ȽϴС(Сڵڷtrue)-dec---------------------------------------------------------------$<'value1value2false 򷵻true  $$4'$ $4' $  ''d 'k i }------------------------------------------------------У鳤---------------------------------------------------------------' ,$' ' $/ΪDZ'kzk ,-±0ʼֵΪָάõ± $$4 $$41''zpkhd˵У̶ame1 $$4'zkki}------------------------------------------------------У--------------------------------------------------------------- ,$'' '$/ΪDZ'kzk $z& Ϊz .e+Сzk ,-±0ʼֵΪָάõ±' $$4 $$4_=='zkd˵У̶===== $$4======'zkki------------------------------------------------------УֵΧ--------------------------------------------------------------- ,$'A@P'  "ڷ'zk $z) Ϊz $4e) С0A@|zhk` $4$$4 $4$$4==='zki------------------------------------------------------Уֳ(Number,ΪҲΪСС0)--------------------------------------------------------------- ,$'ڷ' 뼬$/ΪDZ'kzk $z% Ϊz $4e% С0======zxkp$'+󳤶====$'.СλenKT .''' "˵ûС $4' $$4DZ'zkd С  . $'DԪֵλ  . $' $$4 $$4Ϊ'z k k i -----------------------------------------checkIsInt У鲻С0-------------------------------------------------------------ʽȷfalsed ʽȷtrueΪ ]h ^0|[1-9]\d*$'  $'d'ki-----------------------------------------checkIsNumber УΪNumber-------------------------------------------------------------дʽȷfalseʽȷtrueλ ' $zλ'ki-----------------------------------------checkMoney У0-9999-------------------------------------------------------------=== ʽȷfalse======ʽȷtrue== ]@ ^(([1-9](\d{0,3})|0)|0)$'  $'d'kxip-----------------------------------------checkMoneyTJ У0-9999Сһλ-------------------------------------------------------------&ʽȷfalseַʽȷtrueX ] ^([1-9]\d{0,7})$'  $'dX'kHi@-----------------------------------------checkPersonNum У׶԰һ------------------------------------------------------------'ʽȷfalseʽȷtrue ]0^(([1-9]\d{0,3}))$'  $'d 'ki-----------------------------------------checkIdNumLink У֤ԱͳûдǷһ------------------------------------------------------------ʽȷfalseʽȷtrueλH If colIndex = jhrIDColumn Then checkIdNumLink = True Exit FunctionϢ End If]%Ա֤ǷӦ]$ں֤ǷӦ===== ]ڵһγֵ±======]0"Ա,Ԫ֮ڵchec]H$ݺŽȡ]`!,Ԫ֮ڵ]x"ݺŽȡ]#ݶ ]%·ݲ]]  $' $'$ (ڶλΪΪ F  R$T,NdڶλΪżΪŮԲΪŮ F  R$T,NkX $' $' $' -  -  F  R$T,N'i}------------------------------------------------------У鳤---------------------------------------------------------------====8 ,$'=]^[\u4e00-\ue863]{1,66}$'' $/ΪDZ''kzk ,-±0ʼֵΪָάõ±Ϊ $$4 $$4  $'d'kzkd˵У̶ount = $$4  $'dp'k`zXkPkHi@-----------------------------------------У鿼šѧšѧ -------------------------------------------------------------ʽȷfalseʽȷtrue ]0^[a-z|A-Z|0-9]{1,40}$'  $'d0'k iȥǴӡַ8 F <$N'l ]  l $" n  MsgBox addr }U  l !%p'l  MsgBox addr l F <+N pS k0.i(. .oAttribute 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,16}$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 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 '~^;5e3-!ѧP0ʶ 42λһxBOQO7SchCodebN~40}[\dx]ߺkߺW&axkg__Y\Yo_6( _دckFamTyp_ , "^(\u519c\u6751)|3bf\u95D47p7cee02)$" If regCheckFunc(, value) ThenJRcFamType = True18Els&FaEnd IfF ktio^'-%7 Уѧʱ&7 'ʽȷ෵fS tqU RXD0ate(Dim"^(((1920))\d{2})((0[0-9] 12])5ƒAF `FP`݇QU_Year_, fArgsArr)`gAa" @ 0 'ΪDZ"I Exit G ʓA19|(23}0xdG>$dGGz GyQwMonth?wtc*D-?-"9Jaѧ<8--XJ&H-Y4}7]BZ 3!7}?.C-&$10ӵ绰8--Pho neNum?egCLi\bi(([ 38h4[575Ai55jk8}00p2[\"dj-[2\dr*[3mg)\boNo‡q*T Ap11п2OIckBanFk^[1c14,20_2_,p4oo3Xn@I磨2012-@3_`Xn_+Uxy s4^(20J2}p r0y-Gz1999|00o_\2Split , "<-"4q30R(1) - 0)01iqh?Իp= ?"" Op#ע#СR2_#P#D200:ck 12Q2 1@"!3W  X Le-@">c2!9U?# 3O@`OȽϴЄ(~) &r !*compar!F #!CIn=1h#2"Y%%  compare = False E 4TTru Znd If EFunction '-2ȽϴС(Сڵڷto)-dec3S5value1ڂ2/f~@ 6 d {Dec(, ) VC2 2I"f(1 >- The1%XУ鳤 >h]heckLen], fD0ArgsNArrESplit(A, "," cτQEb@""aQ (0) 0 'ΪDZLj sH e Exit H (UBoundA G*2±0ʼֵΪάõ F4) >= _#`1)) AH<}T2@s_,!>( 4'( '˵\̶֨\s! H!? * @2?z"#:鮡tInt"c&b+@ vZb onj5(,0InStr".") <> OСoK.) KsKKKKwp:Kg1(K KK=K+gKKsK5->K_FqKֵ|ΧKValKϋвKSqϋpK`K'=A/Fe/F,FoQo2F@F=JF0,/'# )?@=06Q=_ 5_q'/*-s/ (0bber,@ΪQ|҆\)o1P111Ͻͽ110]ϽϽi?6IrϽbo+0 77}7%=unction ElseIf CDec(value) <= 0 Then 'С 0nExit Fnd If TmaxIntL= fbArgsArr(1) '󳤶=Double@2@СB>λ >iygth = InStr, ".")V vxdou 0ˀûЃL 3 *3()#=checkNum@:True TzEP}ACAHMidEg1,Ok - ԪֵλS0mN +@j^AAii2)iVjcS268a'{8 '-#bIs} У鲻48ȷൻfaevtBY% J}Dim reg=``"^0|[1-9]\d*$"#[>Ce! (,> *= i_F0k.?.e%`yber.Ϊ8*_.0s.#. =& h @-Is@eriK,,C (BMoney "(0-9_%8(( ?W(("W(\d{0,3})|0AXGH_,6?_,TJ=#tһλ?D,ckTJ]Dђ7})?kD LB.N_Зs?rP`ersonp6׶԰һooov 01cO]k/1;] -- IdLink֤ԱͳûдǷһ?ooo` (, rowIndex, colw'f /jhrIDColumnl' Fj2!voisGe rRight As BooleaCEϡ0ӦG;Birth/+len@2eg|'q@γϰ±[gb c` Aing 'Q ,tڵڤݟer1J Žȡom bqe?Fa" 1Ayear, QBVariant "'1lmo`nth, bԂday, @carr1Ǡ'QT.17,Z7Y= (80АZMod 211 'ڶλΪ@GSheets(sa7/ue1).Cells(rowIndex, ge8rColumn) = "" Else 'λΪż@ TdShee0ts(s Val#Ů ynd If^g yearMid(birthh, 1, 4)&montBh'5, 2day7&oI)W+ "-" <+ JXcheckIdNumLinkITrue EFunction '-2У鳤LsF E" B+SpLen(vAz, f)Arg&sWArAnSplit(, "," Dim regFD"^[\u4e00-\ue863]{1,686}$H'@Fac@If ," The@U)-(0A0 'Ϊ rvExit | @)UBoundRX*2*±0ʼֵΪָάõ3 <) >= CDecm(1)) A`UHD(Pk<tM`@@ @k:DUp>6P@  p:LtM`@P  P(k::N@@ 36@Ppz 00pt( P@0   0   0   0   0   0   0   0   0   0   0   0   t6:HN88\X( (/X58 f\lH:\ ]3(\%8(]358} c\l5I p\8(H%( -V(% -Ip'`6( c\lj7\8(H%( -36(h c\lt,0l< X8(p`$6:HN88\X( (/X58 f\lH:\ ]3(\%8(]358} c\ll )H:\8(]@585Ihp\8(H%( -V(% -Ip'`6(c c\l7\8(H%( -36( c\l,0l< X8(p`0   6:HN88\X( (/X58 f\lH:\ ]3(\%8(]358} c\ll 8l 8(\]M58(\%8(\%8H:\8 (\ (\(\]38l 848(\%( -M6( c\lIH:\8((l 68D'H:\8(("l 68(j8(\%( -ItP(%d` -`PI@'06(dP c\lnL@0(l< `X8(tdP@00    0   0   0 X   0   0 H  0 8  0       W/0;xME@> ` ` 6If I,  @` `k :If  IF  I< @ I  h `"k ?I  If   IF  I< @(\ @BL @J8 < `k \If  IF  I< `$h`Ff`H dX`h xp ` (B % @:l  <@ h @X @8H @D @P4 @h$ @ @ @ 808pP@@l `8<@h @X @H @D @4 @$ @ @ @X(@Pl oUe=CXVTtemRot@ph s@X er@T \A@D al@4 C:@$ IN@ a\@ Up(P8@h(@l siRos@620<:@8h in@ X ng@H in@D ng@4 :\@$ ts@ ck@ fi@ X_@ SI@ R=@ q @P $1Tv@ (.@h @ P|j@Xt @d @T @@D @(4 @p$ @X @ @ @ @ @ "@ @ @ @ @ @| @l am@X\ 6)@L out\7.9.. 8 P@l @ T <J@8P @@ @< @h, @ @ @ D:PPh@l xP@X @H @8 @( X8x @|l @8\ @hL <dr"P@PH @8 @4 @$ @ @ @ @p @ @ @( @@ @X @ @t @d @` @P hPxp p@rl p<z@h @X @H @D @84 @$ @vX @x @ @ @ `h@dl h<\ @h @X @H @D @04 @H$ @ @x @ !"hp!" h !0 H @l X 0 (!@ \ @(!L @ < .TP@!, @* @! @ @@! @X! @ @, @ x@ @! !! D@0" "! H"!@t @X"d p"0" @T "X"@"P @L X"$& `#$#$#$`##x#@l #`#(%T.D @#8 @#( @p$ @ @($ @@$ @ @*P @$ @$ @& @, @X$ 0@%t 0%$@fh X%%@X %% `T@%d x@T `@%D %%@4 H&% @$%$ @0& @ %'0'&X''('&''`z '&H'@fh p'0'@X 'X'`T'H <)@'L @H @(8 @ (( @8( @P( @h( @( X@ @( @( @ *`+PH++)*)+),)@l ))* TVX@0*h @*X 8++(@H*H @D @`*4 @x*$ @* @ @* @* @+ @ @ + @x+ + + @ @ @+t +x+ @d (,+ @ )T H(@D )P (,+ ++h P :Z$*\Rffff*1C5998191b*\R1*#5f*\R1*#46*\R1*#42*\R1*#11*\R0*#14$*\Rffff*0S5ae1de49*\R0*#f$*\Rffff*1A5998191a*\R1*#101*\R1*#10d*\R1*#33bl B       B E B  h p2 p `B x 8 $N 8V "R@ pHB  8G%$S0X$V` xB 4R8(p*$ 8BH0!X`hp x  B ( @0 4BP $  "B    "N    .( $X  p 0 $  * $  .0 $`  x .   0   68 p 6  8 0 @6X  (   0$8 Ph p  fx   0>:8&x  X&0 h8 **{ I j: & & ` h*{*{ x  , H?(x\ HBp(~ HBX(p\ HB(~X  &  0&8X ``    , H?(\X HB(~8 HB(\8 HB(~  & &( n0    , 8(~  HB(~   & &8 b@    ,~ &   , !&!(! f0! ! ! ! ! ,! 8"(~8" 6""(~# # &# ##&$ $ f($ $ $"$& $ X:$ &P% x% %6% B%&  & &@& bH& &'& & z:& &h' ' ''&'' f' H(X( h( t:p( &( )  )0)&8)X) b`) ) )* *~*&* * ,*+&+0+ ^8++ .+ +@:+&, @,P, %X,x,&,, ^, - (-8- H-X:P-&- - ,-.&.8. ^@. . .. .T:.&H/ p/ ,//&// n/ P0 p00" 00&P1 x1 ,11&11 j1 X2 x22" 22&`3 33&33 n3 84 X4x4" 44&@5 h5x55&55 P56 6 0686&6 6 .707&87X7 R`77!7 7X:7&H8 p8 ,88&88 b8 H9$/`9 9@:9&99 ::$%:,@:p:x::::&:: j: 0;P;" `;;&< @<P<X<H4`< <L7< == := &= = = =>>&>0> Z8> >.> >@:>&? 8?H?%P?p?&x?? j? "@ 8@ H@ `@ d:h@ &@ @Ab;A h>xA ,>A :B &B B BB :B &C C CCC&D D ^(D D&/D D@:D&E 8EHE&%PExE&EE ZE F&/ F HF@:PF&F FF&%FF&G G Z(G G,/G G@:G& H HHXH,%`HH&HH |H @I$4XI I(I@:I&I J(J8J"%@JhJ&pJJ |J K /0K PK@:XK&K KK %KK&L L |(L L$/L L@:L&0M XMhM$%pMM&MM dM 0N 3HN@:hN&N NN2EN O V(O O/O O@:O&O  P0P%8PXP&`PP ZP P(/Q 0Q@:8Q&xQ QQ(%QQ&QR ZR pR&/R R@:R&R  S0S&%8S`S&hSS ZS "S0/T HT@:PT&T TT0%TU&U(U Z0U U&/U U@:U&V @VPV&%XVV&VV ZV W(/0W XW@:`W&W WW(%WX&X0X Z8X X$/X X@:X& Y HYXY$%`YY&YY ZY "Z0/@Z pZ@:xZ&Z ZZ0%Z([&0[P[ ZX[  "[0/[ \@:\&X\ \\0%\\&\\ V\ P]/`] ]@:]&] ]^%^(^&0^P^ ZX^ ^./^ _@:_&P_ x__.%__&__ V_ H`*/h` `@:`&` aa*% aPa&Xaxa Za a*/b 0b@:8b&xb bb*%bb&bc Zc xc(/c c@:c&d 0d@d(%Hdpd&xdd xd e68e.)ee pe( e2e( e1e( f2f(  f10f@fHfJ`ffffff ffB Pg Xg<`gg gg$g$ hHhPh Xh \i B `i,^i 0i@;i" j ^Hj 6jjEjkE8k0XkH7kkkk l ll l "l l .mB 0m 8m$HmBopm m m m m m nnn n n n n oB o" o Ho `oho poxoo o8[o o2o p N8p Xphp ppxp p$p F_p pq q q * qPq Xq q rB  (r0r*Pr 4rr rB Ps<Xs Jxss s @t XtB  pt*xtt tB @u<Hu Jhuu uB @v Hv "R`v v8[v2vw N0wPw `whw pw xw$w"Vw0w Mx(^ xHxPxXx(Yhxx&Yxxx xx xB xyyVy y 8z MPz pz:z4z$ z" {"J8{ `{h{p{  |-----------------------------------------УУдϢʾ ע----------------------------------------------------------- Ԫ] F H L%N'J J'Ddd'Dkxdipd--------------------------------------------д־ ¼ϢʾһϢ-------------------------------------------- R X V$T,N X 'Xic--------------------------------------------д־ ¼ϢúɫʾϢ-------------------------------------------- R'\ R X V$T,N \ X V$T%N%^!`(b X 'Xibi--------------------------------------------עʼУ飩-------------------------------------errorInfoעX 1Worksheets(sheetIndex).Unprotect Password:="1qaz" h F H f$<%NB@j F H f$<%N!l(nW ӻɫ F H f$<%N!p(>i0ai--------------------------------------------ɾעʼУ飩-------------------------------------1Worksheets(sheetIndex).Unprotect Password:="1qaz" F H f$<%NB@t F v H x F H f$<%N!l(bd` z F H f$<%N!l(bk_i_r---------------------------------------------ʼУ Ƿӻɾעõķ---------------------------- ~ Уʧ F H f$<%N!pd жעΪ f F H A@dV עd"Ϊգȥǰע f F HA@rN ע f F H A@dkh^1 MsgBox "" & rowIndex & "" & errorMsgd:УɹжǷעУʧʱעȥ f F HA@r ,#ȥո,ʾ FУ HУַ"$" "$""а˿ոϵͳԶΪA@Pd]k]k]i]----------------------------------------------------------------------------------------------------------------------------------y--------------------------------------------ݱʶöӦķ(ʼУ)-----------------------------------------------------------------------------------------------------------------------------------------------------------------------ѴϢдб F H f$<%N'  H f$<%N'Iȡбͷ Ϊϲеıͷ  H f$<%N' F e  H f$<%N'k`Z0'  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'kV _=================================1 ִеķǿУ==========================================ѴϢдб checkNullKT f F H$'  F е Ϊգ'')УʱдϢ A@PRMsgBox "" & rgold.Row & "е" & Chr(10) & titleMsg & "Ϊգ"khT f  F H A@|'a=================================2 ִѧУ========================================== checkNameKT f F HA@@ȥոķ F H f$<%N!' $'  F е ;дȷΪ֣ȴ1ܳ16ַ''%УʱдϢ A@P  'kR f  F H A@|'Z================================= ִеijУ==========================================checkLenKT  $'  ,$'$ ` ΪDZΪ̶ȶ F е .дȷΪաд򳤶ȱΪ$ λ'$ ed ΪDZΪȷΧ F е 4дȷΪաд򳤶ȱڵ$ λҲ$ λ'$ ed ΪDZΪ̶ȶ F е &дȷΪգҳȱΪ$ λ'$ ed ΪDZΪȷΧ F е ,дȷΪգҳȱڵ$ λҲ$ λ'kN'0УʱдϢ A@Pk@N f  F H A@|'Z================================= ִеijУ========================================== checkSpLenKT  $'  ,$'$ ` ΪDZΪ̶ȶ F е .дȷΪաд򳤶ȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ F е 4дȷΪաд򳤶ȱڵ$ λҲ$&λֻΪַ֣'$ ed ΪDZΪ̶ȶ F е &дȷΪգҳȱΪ$&λֻΪַ֣'$ ed ΪDZΪȷΧ F е ,дȷΪգҳȱڵ$ λҲ$&λֻΪַ֣'kI'0УʱдϢ A@PkpI f  F H A@|'h================================= ִеijУ飨Numberͣ==========================================checkNumKT  $'  ,$'$@ ΪDZΪ̶ȶ F е GдȷΪգдΪ֣0λȲ$λСλ$ λ'$ ed ΪDZΪ̶ȶ F е ?дȷΪգұΪ֣0λȲ$λСλ$ λ'kF'0УʱдϢ A@Pk`F f  F H A@|'[=================================ִֵΧУ==========================================ѴϢдбcheckValKT  $'  ,$' F е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@P& isValidateCount = isValidateCount + 1kpD f  F H A@|'_=================================ִеΪֵУ==========================================ѴϢдбcheckIntKT  $'  ,$'$@ ΪDZΪ̶ȶ F е 8дȷΪգдΪڵ$ҳȲ$ λ'$eEΪΪ̶ F е 0дȷΪգұΪڵ$ҳȲ$ λ'kA'0УʱдϢ A@PkxA f  F H A@|'`================================= ִе֤У========================================== checkSfzjhKT  H$'K ֤У 7֤У F е *дȷΪѧ֤ţ''0УʱдϢ A@P  'd!.֤ͨУ飬ԶɳںԱ <checkMethodXQ = checkIdNumLink(value, rowIndex, columnIndex)======kX? f  F H A@|JHKT'\================================= ִѧŵУ==========================================ΪcheckXJHKT 0, 1, 50$''  F е KдȷΪգΪճȱڵ1λҲ50λ'`'0УʱдϢ A@P====  '==k= f  F H A@|JHKT'`================================= ִѧϢIDУ==========================================checkXJHKT $'  F е EдȷΪգҳȱڵ1λҲ50λ'`'0УʱдϢп A@P======  '==k@< f  F H A@|Ϣ'[=================================ִпУ==========================================дѴϢдб checkBankKT $'  F е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ== A@P======%isValidateCount = isValidateCount + 1====kh: f  F H A@|'W=================================ִ꼶У========================================== checkYearKTʱ checkYear $'  F е дȷ''(УʱдϢ== A@P=====d 9 checkYear f F HA@k8 f  F H A@|'W=================================ִѧУ==========================================ѴϢдб'checkXnKT $'  F е )дȷʽ2012-2013ȣ''-УʱдϢ== A@P======%isValidateCount = isValidateCount + 1====k`7 f  F H A@|'W=================================ִ·У==========================================ѴϢдб checkMonthKT $'  F е &дȷʽ0112ȣ' H'-УʱдϢ== A@P======%isValidateCount = isValidateCount + 1====k5 f  F H A@|'g=================================3 ִеУ(DZ)========================================== ѴϢдб checkDateKT $'x- 2Уʧ1뼶 F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-02-21'F H'-УʱдϢ== A@P======%isValidateCount = isValidateCount + 1====k3 f  F H A@|'c=================================ִеУ飨==========================================ѴϢдбcheckDateNecessaryKT& $'x- 2Уʧ1뼶 F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-12-21'======'-УʱдϢ A@P======k1 f  F H A@|'g=================================ִеijУ飨==========================================ѴϢдбcheckBirthdayKT!$" $'x- 2Уʧ1뼶 F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-12-21'H'-УʱдϢУ A@P======  '==k/ f  F H A@|''J=================================10 У绰====================== checkPhoneKTֻ $'  F е дȷдʽΪ"$"-̶绰 ֻ"$" ' H'%УʱдϢ== A@P======' isValidateCount = isValidateCount + 1==k@. f  F H A@|'L=================================checkOption У鱸ע ======================0ַ checkOptionKT B$'д  F е )дȷȲܳ200ַ''%УʱдϢ== A@P======%isValidateCount = isValidateCount + 1====k, f  F H A@|iffNam'\================================= ִ϶ѼУ==================================checkDiffNameKTcheckDiffName  $'  F е дȷ''(УʱдϢ' A@Pd`+checkDiffName f F HA@ $1ͨУֵΪ϶'d*'k*k* f  F H A@|'d================================= ִ϶У(DZ)==========================================checkIdentityDateKT% $'x- 2Уʧ1뼶 F е дȷдʽΪ"$" xxxx-xx-xx"$" 2013-02-21'Ϊշ'-УʱдϢ$ A@Pe'd)  $X$϶ȼΪգ϶Ϊլ'  $e](϶ȼƲΪգ϶ڲΪʱͨ'dh( F е vдȷ롰Ѽ϶ơͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơǷͨУ''0УʱдϢ= ' A@P======'kp'kh' f  F H A@|'T================================= ִУ==================================' checkMZKTcheckMZ $'  F е дȷ''(УʱдϢ== A@P===== d(&checkMZ f F HA@==k& f  F H A@| 'd================================= ִ϶ԭУ(DZ)==========================================5checkIdentityReasonKT'Ҳ0,1,30'  $'  F е 5дȷȱڵ1λҲ30λ'Ʒ'0УʱдϢ A@P dh$   $r1϶ȼΪգ϶Ϊ,϶ԭΪ   $ew8϶ȼƲΪգ϶ڲΪգ϶ԭΪ   $eͨ F е dдȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬''0УʱдϢ A@Pͬʱ'd" F е дȷ롰Ѽ϶ơ϶ʱ䡱ͬʱΪգͬʱΪͬʱͨУ飬顰Ѽ϶ơ϶ʱ䡱ǷͨУ''0УʱдϢ A@P===='k!kx! f  F H A@|eKT'X================================= ִ֤У==================================checkIDCardTypeKTcheckIDCardType  $'  F е дȷ''(УʱдϢ== A@P======d( checkIDCardType f F HA@==k f  F H A@|peKT'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType  $'  F е дȷ''(УʱдϢ== A@P======dcheckDisableType f F HA@==kx f  F H A@|omeTyp'T================================= ִвмУ==================================checkFamilyIncomeTypeKTcheckFamilyIncomeType  $'  F е дȷ''(УʱдϢ A@P======dcheckFamilyIncomeType f F HA@k f  F H A@|======'v=================================14 checkGender ִǷΪСŮУ--================================== checkGenderKT checkGender 1$' '-ԱдУ֤Ŷ F е дȷ''(УʱдϢ A@P======  '==d8 checkGender f F HA@ǡk f  F H A@|======'u=================================14 checkYesNo ִǷΪǡУ--==================================' checkYesNoKTʱ checkYesNo  $'  F е дȷ''(УʱдϢ== A@P=====1d checkYesNo f F HA@kx f  F H A@|======'u=================================14 checkYesNo ִǷΪǡУ--==================================checkSqyyNameKTcheckSqyyName  $'  F е дȷ''(УʱдϢ== A@P======dcheckSqyyName f F HA@====k f  F H A@|ermK']=================================checkTerm ִѧУ--================================== checkTermKTд checkTerm  $ F е дȷ''(УʱдϢ=c A@PtOneNNk f checkTerm  $ F H A@|======'P================================= ִѧУ==================================checkXfKTcheckXf  $'  F е дȷ''(УʱдϢ A@Pd@checkXf f F HA@k f  F H A@|һ'T================================= ִвмУ==================================checkDisableLevelKT------checkDisableLevel  $'  F е дȷ''(УʱдϢ A@P4 dcheckDisableLevel f F HA@k f  F H A@|5'T================================= ִвмУ==================================------checkDisableTypeKTcheckDisableType  $'  F е дȷ''(УʱдϢ-- A@P------d@checkDisableType f F HA@k f  F H A@|('T================================= ִУ==================================!NB@checkSuortMembersDescribeKTϢshcheckSuortMembersDescribe  $'  F е дȷ''(УʱдϢ A@PغdcheckSuortMembersDescribe f F HA@kp f  F H A@|'T================================= ִиĸְҵУ==================================@checkParentJobsKTcheckParentJobs  $'  F е дȷ''(УʱдϢ-- A@P------d checkParentJobs f F HA@--k f  F H A@|------'T================================= ִиĸĻУ==================================checkParentCultureKTrowcheckParentCulture  $'  F е дȷ''(УʱдϢ A@PwdcheckParentCulture f F HA@kh f  F H A@|------'T================================= ִиĸУ==================================------checkParentAgeKTcheckParentAge  $' cel  F е дȷ''(УʱдϢ A@Pd checkParentAge f F HA@k f  F H A@|0'T================================= ִд󲡻У==================================ڶcheckFamilyDiseaseDescribeKTcheckFamilyDiseaseDescribe  $'  F е дȷ''(УʱдϢ A@Pcelld checkFamilyDiseaseDescribe f F HA@kH f  F H A@|'T================================= ִ뷶ΧУ==================================ģcheckFamilyYearIncomeRangeKT------checkFamilyYearIncomeRange  $'  F е дȷ''(УʱдϢ A@PksheetdcheckFamilyYearIncomeRange f F HA@k f  F H A@|------'P================================= ִлУ==================================checkHjKTcheckHj  $'  F е дȷ''"УʱдϢ A@PdpcheckHj f F HA@--kH f  F H A@|tIndex'T================================= ִȻֺУ==================================checkFamilyDisasterTimeKTcheckFamilyDisasterTime  $'--  F е дȷ''(УʱдϢf A@P(dcheckFamilyDisasterTime f F HA@--k f  F H A@|ֵǷ'P================================= ִУ==================================checkFamilyBurstTimeKT checkFamilyBurstTime  $'ij  F е дȷ''(УʱдϢ A@PdXcheckFamilyBurstTime f F HA@k  f  F H A@|'T================================= ִмͥʲУ==================================checkFamilyPropertyKTȶcheckFamilyProperty  $' <  F е дȷ''(УʱдϢ A@P f$dcheckFamilyProperty f F HA@k f  F H A@|------'T================================= ִмͥʲУ==================================checkInSchoolCountKTcheckInSchoolCount  $'  F е дȷ''(УʱдϢtI A@Potect d0checkInSchoolCount f F HA@k f  F H A@|*"'r=================================checkAtLeastOneNNull ִһΪǿ--==================================checkAtLeastOneNNullKT'$  'A"ִ һǿУ ĵԪĿ H& $ =Ϲ   ' KTF   ' KTF   ' KTF   ' KTF   'nddϹ  'F6ִ һǿУ ĵԪΪϹĿ    'k0d'n did_--------------------------------------------ʽ-------------------------------------x]VBSCRIPT.REGEXP$.7RegExΪʽ (4 ȫֿvba\ת  (.ʽ (5ǷִСд  %'3 ִ.ib-----------------------------------------------------------° Уظ˵Ѿûиʽ------------------------------------------------------------V-----------------------------------------------------------1ѧ׶ڱڲ(sheetѧ׶ A65535 $T%0%!'*cna = getTotalColumnCount(sheetIndexValue) V$T!NB@1&ÿУظʱʱѴϢsheet,'XϢ¼ʼX==============================ѧ׶ڱڲ==================================0ðÿԪغ֮ǰнбȽ      $T%N'      $T%N'   .ѧͬ˵ظݶ  еݺ͵ ֤ظ!!!!' A@P*ѴϢ' k_^^i^-----------------------------------------------------------һ ֵȡֵ------------------------------------------------------------ֵҵֵڵлkeyWord ҵĹؼ'kbn л ֵΪ rowrowp']the find result object    A1:A65535 f$<%0%.  row !'d] !"'k\k\i\------------------------------------------------------ ִڹУ(Ϊ)-------------------------------------------------------------value value1 cellУ鲻ȷfalseУȷtrue( &0˵ΪDZ $$'z[k[k[]'*ijһļ¼ A65535 .$T%0%!',B' . row$'(=ȡ  ( ,  .$T%N  * '*dZyZkZ   ( ( *   .$T%NX $X LжϹǷcell'yYkY #ʱcountĿΪùеĿiY------------------------------------------------------ ִɾijһвexcelܱģ-------------------------------------------------------------sheetIndex rowNum к1qaz4 f$<B@2 , f$<%6B@8/ Ѹɾ- Worksheets(sheetIndex).Protect Password:=123i@X------------------------------------------------------ ָcellֵ-------------------------------------------------------------`1qaz4 f$<B@2  F < f$<%N(i`W------------------------------------------------------ ִɾijһвexcelûб-------------------------------------------------------------sheetIndex rowNum к  , f$<%6B@8/ ѸɾiPV------------------------------------------------------ ָcellֵ-------------------------------------------------------------1qaz4 f$<B@2  F < f$<%N(ipU------------------------------------------------------ ݴеֵǰʱѾͨУ飩-------------------------------------------------------------` ] 8 P F < f$T%N!X 'J'*ijһļ¼ A65535 .$T%0%!',F . row$'(Aȡ  ( ,  .$T%N  * '*dSySkS   ( ( *   .$T%N!X '$ $ JX 1жϹǷcell  .$T%N!'B BX F < D f$T%N(yRdR $0 F < D f$T%N(dhR F < D f$T%N(k8Rk0R iR------------------------------------------------------ ȥcellеĿո-------------------------------------------------------------h ] Ԫ] 8 3Blength1ʾcellԭijȣlength2ʾִȥոַ'ĬΪûȥո2 Worksheets(sheetIndex).Unprotect Password:="1qaz" F < f$<%N!'$ $'F FGzj*"ԪΪգȥո $ 'H%length2Ϊոһγֵλ Hַո $ $J'$ $X F < f$<%N('kOiOO f F HA@j>ȥسķH{ f F HA@Hȥոķ f F HA@jFȥسķP{zAttribute 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?DDúɫCE ERedVFnLen7@LZ.Characters(1, ).F7.Colorl=31*SS  ʼG`errafoaddCHommQXQ#s|", ,  0t'Work s().Unprotect Password:="1qazOey.A N( ..Itrior#=<65535 '1૱>%  d/.VisiblĠ_?ɾElearsCk΅"BB ?+0+ 5`&[!*2Recp)Nu8m A:HtffTotal`?um u\4&UE15l lqXOO .ExlNondu(u_L?%K Ƿ4*õķo)beginC_c#LHGpMethod?LLuwLЋNot3 '焹aWʧ|?u$6 Is hing$жρ<Ϊ/T\ W| LAOAa'ȥǰq¡$ cDt_ ʫ 'L alw/ !. <' "Box @"" &gD& "h'tt$ɹ3!0гѕ&ʱđ rCq+remopaceFla(/Qո,ʾ:sW@УȀַChr(34)%QC& w"րа ϵͳԶΪa%ˬ A ]!qO?L?Y/ݱʶC 0XӦsX([)O-O?@!дccallFunctionXQStart(typeVal, sheetIndex, row$colHumn0isRidateCoun t) value = Wo$rks().Cells(DtitleMsgGsT,, ) 'ȡбͷ If `"" Then 'ϲеn/J - 1 L(ElseDÅtheadG=! ;CEnd( IffArgs!"0"JÅ Like "checkLen*MУGĄD Mid9& #EH%O 1H&NumL&@ber&& &@&&ֵLC&M%@b%Inta9?~nE9- 'W9Term1L""ΪL"1 7 YesNo-kk ? DiffNameѼa?%D~#CodslA!`IDCardT*'րͶ;:`._Sqyy;ԭ;Q0] e? WYearZ?M`?:]  :iSpii :M11j N`BLvSelect CaseLp '=Q)1 ִǿ1?ѴϢGq 3~Null0xMethodXQ7Required Not ! cerror"" &"! & "Ϊգ/ahasE`TrP'qʱ% fwriteLog E ' Box 5gol d.RowO& Chr(10){Tb eginC_comment,?isFor.o+.2.ѧ/_Ky-sO removeSpxacep-'˟ 'ȥոķCEntbeginCheck_comment sheetIndex, cMethodXQ, row`olumn isF '= ִеijNumber{Case "i'"z(value, functionArgs)#@If Not pThen ~IArASplit(, ","!(0)@50" 'ΪDZΪ̶A`+@"" &F"Attitle@дȷ"ΪΪ֣0λ) ;1)λС 2 !Sf!eд 81Bankb0@0z/"0OOOA֣%`functionArgsArr8(0)a?r(132L222ݯ bj'22ϡ6211u111-q1꼶.Year.O/@/0DMB(, 41/aBO$/@////?*u)))\?\?\!#setpCode W5ʷ/o/t/,/,"qk,),,]3].Xn._.ecųkXn(valu e) If Not checkMethodXQ ThenerrorMsg = "" & rowIndex"еtitle-& "дȷʽ@2012-3ȣ" hasETrue 'УʱдϢ$writ`eLog j'isValidateCount@+ 1"End IfbeginC_comme,sheet,, olu mnaisFoBrDK '=ր·T' @^дб;@Case "onthO{=? ??ÅNH?0112gM{J ?Z ?Z?Z?ZXc?Z?ZV3 Z![(DZ|)+?\b+(\D1 " '0r]Birthday]u 'ᠳpʧ|A`_&AΪChr(34)ax-xx@  A-0@1,5 fft O3.22}_?3py/a 3Necessary3p33&/4(od/4/4 vdߑ& ߑґ/4/4/43-є/4 /4 /4FeOO OOc5L/_+/)T0000%,/cR//rc//r////////o ///^c_y___444444/110 ఺:h0Phone`V0Num^4 ..B__a.X,,-̶ ֻ-$b?,2,cʱдϢ writeLog errorMsg' isValidateC@ount ="+ 1xEnd IfbeginCheck_commeQsheetIndex, cMethodX@Q, rowo0lumn isForQTrue0 '=7Option У鱸ע e@Case ""sdH(value, 66)If Not Then1"" &L"е@t0itle{дȷȲܳ200ַP7hasE[ 'Q?'?J?%A ִ϶ѼS]==KSDif`fName8RTDMB(C[, Vfunc!eArgsPWWj?X?X|[UU]sys"icult@yGrade+Flag`0Tt ElsBset3Cod?(4iw@6Trim)"" 'ͨPֵΪ!#ĥ> 2a y_ckyթFa2(DZ<)_{BId!xityDp~" >'1OC|Birthday4$AXQ&ʧ܏rC/o& ooqpʽΪrChr(34)bx-xx  12013-02-21rZ HrsO DOyintifJ-8p>P1 AoEpcEnȼQnaE01oF?=q K\2 <> Q +`/ oLZoMO1O1. 8롰ՈAͬʱCұcU1?Ƿuω^333nLFaOw/7/]*= ?ZiK7j __ c_՟1jOgjÀ͑jiMZ"Bߟhhp1ߪ"@ֲD5555ߪ9//////P writeLog error`Msg 8Elseh@setDMBCode "checkMZ", sheetIndex, rowcolumn PEnd IfbeginCa_comment e{ethodXQt,uisFor = Tru x'= ִ϶ԭУ()uHCasIdpityReason" 'functionArgs^"0,1,3<0"J@ Len(value, )If Not KThen ++" &F"еtitleдȷȱڵ1λҲ30@0BE$hasE@$ 'tʱдϢ7[A'YsysDifficultyGradeNa@meFlag+1 Ainti fyDatKTrimCv)"" A4 'aaWȼΪա'a,[;!}2v#i<> !%%`(40 Or 4!)R4hh롰0!$Bʱ䡱!mͬʱ#+a(aͨf.n[ nn# nFK= Fazu?3?3?3?313ǷS:SSn, ooMo ?o/"֤|8/EiDCardType_oR (ӟI, sR0TD/6/& /")---\/-/-!E//....,.E.+.м.==.Disable... .и..XQR f.. .)...\..!.....G....6.+...FamilyIncomeType" checkMethodXQ = isFoBrDX '=14fGe@|r@ִǷΪСŮk--=K?CasYsx"1";ŦIdNumԱ?Sxiiiv ii i#isValidateCou W= -+ 1"qMBq&=_pҫ_p_p!_pKp ppYesLNo-mpapps+1hpB _pCEcg$gggg g3/bhe/exh/'hhhJhhc///?/t~SqyyNam3 x``/0  q/0>ddOQ/0S.0_0_0_0G_0_0_0_0R&E_0+&Term/ѧ?.." Y.--/+rE/+/+/+/+?j/+/+/+*_[g/$w$$oaO?IOV%/" C%A%/%$%Xf% ,E3Sp%OS@OSq(((((YZhдϢ writeLog errorMsgElsesetDMBCode "checkXf", sheetIndex , row co0lumn PEnd IfbeginCa_com0ment e{Me@thodXQ:,uisFor = Trux'= ִвмУъ=oCasDisableLevel" sU( , value, functionArgs)If Not Then @!"" &Fz"еtitleдȷT;hasEe 'Zʱ캌[ #? p|^OZ^^ I^Type^XQ@^^G,^g$^^^ ^ ^d^-_^v_^T^V^SuortMembersDescrib_o_2 O0_-v_ ?_qO0%~_& __O0_OO0(!O0Nooo0`oo, Ho0o0`ĸְҵ00ParМJobs_ [=SG//"@_e/q/////Y_///1/Q5/_......6..,.Ļ>...Culturo_c //-/%_/_/_/_/t_/_/_/_/_/^^^* O[_/_/"J// ?/G////or@Msg isFor = THrue'= ִиĸУb= Case "checkParentAge" "$MethodXQDMB(>, value, functionArgs)TIf Not a-ThenEe0rrorA"" & row Index"еtitle& "ȷu3hasE43@ 'дUwriteLog ZElsG|setYCodj, sheet?,B, c`olumnE nd IfbeginC_comm@J k,\<6󲡻asterTi~m_ +0+",,,b`,q,,,,YY-Y1-Q5YUYY/e 0000r֫(E00-r0?0?0:0Burst0V00yG//ω//ٴ= "" & rowIndexP"еʀltitleMsglдȷ뼀" hasError = True 'УʱдϢDwriteLog eJ!*ElseEsetDMBCode "checkFamilyBurstTime",@ sheet,, column .End IfbeginC7_comment2DMetho(dXQ:,{is&FB'= мͥXʲc^ =7CasQProperty :@c(b, value, functionArgs)K EIf Not Then ő!??+?A<\_|___v~_[_nk 02 b 'Ϲ5qtotalMA;P +Select bDυbaojiaoBC":oiSum ?_ huoshi H   zhusu G   others H   a}c*?%1W '23 =pG>6>>>@K+ + " Jb_/ Fᄬ '-ʽo-  reg;(ąDimaEX As ObjISet= Create("VBSCRIPT.REG EXP")1'RegExΪG EX.GlobalpFq?_Ȁֿ''vba\תPatterno 'QIgnoreB8= FaǷִСд3TestgGB.pPhing #$O ° 4ظ˵Ѿûиʽ -8 '8z1׶ڱڲ Function checkTheSameXQNew(sheetIndex2) 'G rna = S,s 3.Range("A65535").End(xlUp).Row  'c getTotalColumnCount'Value)7(msgNZ).Cells.ClearContents 'ÿУрwʀʱϢj,,curMsFgPj1 '¼ʼ'=][A#'ðÿԪغ֮ǰнȽχFor i0startTitle + 2 To @l qcardID1 VFICV(i, hcEji - 12jAIf(1n '˵ʈ&aerro@'"" & j@"е i֤ @!" writeLog &'TbWhas$vTrueSn IfoNextaeһ ֵȡֵ7C ҵ лke@yWord @ؼbnBCa ֵΪ rowGetOl"a((By Gc, #$ As String) @Iger- 7-hcDim cObject 'the find result FoG7Set=z kb 1 :FF (What:=FLook@In:=xls, !A@xlWholɯmNoIs h lgqk != "*n"!c ġEls[r+M`]U ִЄ(Ϊ|)@+vo q1 cn ȰK'!ȷfawR5tA~DHMB(, b1, flagd] )"0 'ASΪDZTrim1)q/ 0_Kxit wS?SA3P&Datas 0 '@ijһ1q||Num0$oArea=3'ƀF  @*(,2REJSU}|owP A PQ|2O9 s+Y{_8zEoMI1e i pu C@T( 3.)&,)r '0жaq2q3a 5)ARY5vRj@'ʱcʀĿΪ1;Q 1.@obHɾ.вexܱ𻤵G1 C14кňsd`eleteP2(, Ej2UnprotaoPassw`|:="1qaz$obs(.D p6!'r).P123_ ָc'ֵ?(setβz3XQ2oӋDFQ+??"؁).F=f///%/A///o////n&/NoPro(sheetIndex, rowNum) Wor kps).Rows(.Delete 'Ѹɾ End Function '-2 ָcellɘֵ3F5  setCTVa`lueXQ~ctolvUnprotect Password:="1qaz>"F=).1= = ūݴе@Wֵǰ@ʱѾͨУ飩_A_DMBCode(B5, AO DimData, cps OCStr<(SA ^}Count@0 'һļ¼?w Ar ea7@ange("A65535").(xlUp 'G:Get@OTrC(K,C, "@ ") 'ȡ(@ЇFFpor i BTo~'If &i, 1)8 The@}a i&+ 1K Else+Exit 'l`IfgNext ij+ -1D6#j, 3drHCa%k &P)# 'ж2ǷA \`22 e:RA Lo +llumnPlus$ %0!?!8">!)("|"JAa!?ex4"0 S&?')5\E;!_j?¿ (Ŀ|_vremoveSpazcvw&x$a^4As [ing 'Ԫp47.length1 Integer,J 328 'tʾԭijȣִaַA4 LenSx1`80K<$@ 'գW2Inqxc j jaһγπֵλG6 2 <> D b3VRepl(@"%%Qo "Truo>q Root Entryx@WWorkbookCompObjo_VBA_PROJECT_CUR"3-PrintForm,f&CompObjaoVBFrameVBA__SRP_0)TE(Xfi__SRP_1 __SRP_4J__SRP_5PrintForm__SRP_2 -y__SRP_3/ __SRP_8<__SRP_9*w2_VBA_PROJECT&__SRP_6?p__SRP_7`Sdir QUSbpSȉ "cv;N z^@ShowFormuThisWorkbook/ !hQpe (__SRP_106__SRP_11#__SRP_12 T__SRP_13g__SRP_fB]wQQpe ,X__SRP_b$__SRP_c&Sheet1;__SRP_d'B__SRP_e!Sheet5% Sheet6(~__SRP_a#/,PROJECT 4PROJECTwmDShowForm+/fH&CompObj01Iao.VBFrameKDocumentSummaryInformation8P SummaryInformation(2Y F#Microsoft Office Excel 2003 Biff8Excel.Sheet.89q }t  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} PrintForm Caption = "UserForm1" ClientHeight = 3180 ClientLeft = 45 ClientTop = 375 ClientWidth = 4710 StartUpPosition = 1 ' End rU~~~y         y SaveAsUICancelrowIndex columnIndexcontent sheetIndex errorInfo checkMethoderrorMsgtypeValisValidateCountregvalue sheetIndex2keyWordkbnvalue1flagrowNumcolIndex  a(TargetIDNumberfunctionArgsArrvalue2 functionArgsIdNum rU~| prU ' nHLOʘxME(SPSSS0{74869BE0-98D9-41C3-A78F-6C47D4C35078}{364AF006-8B7C-462B-9D84-A19F1226A26C}p0(%X0 %0`:ZxAttribute VB_Name = "PrintForm"" Bas0{74869BE0-98D9-41C3-A78F-6C47D4C35078}{364AF006-8B7C-462B-9D84-A19F1226A26C}dGlobalSpaco False Cr@eatablPredeclaDIdTruBE`xpose0TemplateDerivCus tomizDrU @,`#nrU  !  9 h  ) Q $4y a  ` x"l "   " "\ ''' :\lL:<, :::|l\L:<,^z6$lL, l\L, u  $0 TlL, l\L, 4XrU $ `$ `nrU ,`//(`0(`08`1////0!` ///<I`Qq/////<q`/////,`//(`/0 ` 10 ` AY///,9 `q//8a `////,`q//8`////8`////0` ///nQ0* pHd VBAProject4@j = r :Z J< rstdole>stdoleh%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files (x86)\Common \Microsoft Shared\OFFICE12\MSO.DLL#P 1t Ob Lib0raryNMSForms>SFrms3D452EE1-E08"F1A-8-02608C4D0BB4TFM20L'B &/;"~1lrAr00}#0r# ў50 A9C659846-18DA-4k-B8Ej32E26DE4CC@)CUsers\ADMINI~1\AppData\Local\Temp\VBEc7.exdd<@".E.`M  ThisWorkbookGTi@l"Wnkbok 2 HB1JB,zL""+BsShePet1GSeq@at1 w2¢H*6666!ӡ GSbpSȉ-e2jop!(e) c]wQQpececeoAkG;`Xf"a2fo o &У!h>eeojo~k!LGbQ;N z^b2)o J.o U2ShowaxG`6\ow3e2ro1]nO( Tl5^5^5^5^0Qh^ PrintCrinwEbj2odʘxME(6 << <x :`8p%H@:Z$*\Rffff*0R59981979"  ( HhxѧϢӡģ$<(>ѧϢӡģ$<B@@ѧϢӡģ$<(>oAttribute VB_Name = "Ԥ" Sub Browse_Print () Worksheets("ѧϢlģ").VisiblaTrue"d^P@review2cEnd L+nxME(SPSSS0{53023099-55CC-4FEA-9772-AECE38C94FE2}{B035A91A-4DD6-49FC-9DDF-FF44B51A6CF9} @  % %@@:Z " 0 8"HP Xh xȡ------'d B@------oHȷ------@ 'd B@-----oQAttribute VB_Name = "ShowForm"  Bas|0{53023099-55CC-4FEA-9772-AECE38C9"2}{B035A91A-4DD6-49FC-9DDF-FF44B51A6CF9}dGlobalSpacoFalse CreatablPredeclaIdTruBExpo se0TemplateDerivCustomizD'ȡ P Sub CancelButton_Click() notContinueBoolT Me.HDidZEnd! 'ȷq ,onfՏ,-Fl;/t6DD zL#<fsAkFJTFKc(ldxJTFKc(ldfsAkME(SLSS6"  <,<0<4<8<<<N0{00020819-0000-0000-C000-000000000046}` `k@ i `i % % %`@"$ &(@l @\ %@0L @x< @H, @` @ @ @ %@ @ @8 @ @  x@P @| @hl @\ @L @< %@, @ @ @( @@ &@ @ @:Z$*\Rffff*1@5998191a$*\Rffff*1B5998191a*\R0*#2$*\Rffff*1A5998191a*\R0*#14*\R0*#1*\R0*#f4 "      r)ǷȷϽҪexcel籣棬"$"ȷ"$", $"&ϵͳҪмУ飬粻棬"$"ȡ"$"? $$ '  &A@(dP'k@o80Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046}|GlobalSpacFalse dCreatablPredeclaIdTruBExposeTemplateDerivBustomizD2 P Sub _BeforeSave(ByVal AsUI As Boolean, _ Cancel)isButtonmMsgBox("ȷϽҪÄex " & Chr(34)"ȷJ ,10ͳУA?", vbOKcC63If L4 0ThenBD@A򲢴z EŠPP= gEnd Irf AiAm rU 0` ///(`/0` ///(`/(!`/,I`(q`/(`/(`/, `!//( `/(9 `/(a `/(`/(`/,`AI//,`AI//,)`AI//,Q`a//,y`a//,`a//,`a//( `/(1`/(Y`/(`/(`/0` ///,`a//(!`/rU~| krU $`nrU @nrU @4 `\#nrU Qay4`87EH#<g]lO#h8; FOa̰LxOa̰Lg]lO#h8;ME PSLSS006"<<<N0{00020820-0000-0000-C000-000000000046}0 ,` @\ ).`h %i x%%*% @`\:Z*\R1*#222$*\Rffff*1D5998191b4  "  &  HX`p xڵԪʱ Continue? 2Hi$  41A@ k 123A@4oxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2'ڵԪʱ P$( Sub Works_BeforeDoueClicka(ByVal Target As Range, @CancelBoolean) If MsgBox("Continue?", vbYesNo, "Hi") Then3  " End If CDec23n@48CrU @nrU a4`<jxh#< M\7b F:f`D-D JfL&&x:f`D-D JfL&& M\7bME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%` % %`h8@\\0:Z$*\Rffff*1E5998191b4 xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2 <jx#<cʯmoK*Ǫ.@ F@᤽W$C=eQT|x@᤽W$C=eQT|cʯmoK*Ǫ.@ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%` %6 %`h8@\\0:Z$*\Rffff*1F5998191b4xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046}|Global!SpacFalse dCreatablPre declaIdTruBExposeTemplateDeriv$Bustom izD2rU P9a4 0  XID="{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="888A2432283228362C362C" DPB="1012BCA3D9A3D95C27A4D973B82597681F55A36E5A7507FA22DC3FC30931917555B18858" GC="989A3447354735B8" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=154, 154, 1053, 556, ߺ=75, 75, 932, 523, =150, 150, 661, 582, У麯=125, 125, 982, 573, =50, 50, 907, 498, Z ShowForm=0, 0, 0, 0, C, 26, 26, 841, 442, C ӡԤ=0, 0, 0, 0, C PrintForm=0, 0, 0, 0, C, 52, 52, 867, 468, C Sheet5=0, 0, 0, 0, C Sheet6=0, 0, 0, 0, C ThisWorkbookThisWorkbookSheet1Sheet1ߺ]wQQpeXfУ麯!hQpe;N z^ShowFormShowFormӡԤSbpSȉPrintFormPrintFormSheet5Sheet5Sheet6Sheet6 }t  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} ShowForm Caption = "UserForm1" ClientHeight = 3180 ClientLeft = 45 ClientTop = 375 ClientWidth = 4710 StartUpPosition = 1 ' End ՜.+,0HP X`hpx  ͥϢɼ Ϣ м м ĸ ĸĻ ĸְҵͥԱش󼲲ͥ˾뷶ΧͥԴͥѧ ͥʲ Ǻͷͻ¼ѧѡס޷Ȼֺ  ΧOh+'0@HTl AdministratorMicrosoft Excel@&@'â  !"#$%&'()*+,.0123456789:;=>@ABCDEFGHIJKLMNOPRSTUVWXYZ[\]^_`abdefghijklmnopqrstvwxyz{|}~    !"#$%&'()*+,-.012356789:;<=>?@ABCEFGJLMNOQRSTUVWXZ[\  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSUVWXYZ[\]^_`abcdefghjklmnopqrstuvxyz{|}~     !"$%&'()*+-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~