ࡱ> BWF  !"#$%&'()*+,-./0123456789:;<=>?@AJDEUHIJKLMNOPQRSTVYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FCaWorkbook3~ETExtData_VBA_PROJECT_CUR"#'!dd  \p Administrator Ba= ThisWorkbook=p.8X@"1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1Arial1 [SO1 [SO1[SO10[SO1[SO1@[SO1@[SO1[SO1[SO1[SO1 [SO1[SO1 [SO1h>[SO1[SO1,>[SO1>[SO1>[SO1>[SO1?[SO14[SO1*[SO14[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\)                + ,   ) * @ @ @ @       P P     /    ff7  ` !a "* #- $+ %1   %1 % -  % %9 *  % %6 .  %$ %1  , %1 %5 / / %4   & ""@ @ !""@ @ @ @ @ @ !@ @  !@ @  !!@ @ 1@ @ @ @ 1@ @ 1 1 1 1 1 1 1 1 1 1 1  1  1 1 1  1@   1|@   1@  1@  1@  1 1 1 1 17 1|@ @ 7 1|7 1@ @ 1<@ @ 1@ @ 1@ @ @ @  |@ @  @ @  1 1 1@  1 1@  1 1 1 @ @  @ @  ||y#'L}-} }-} }}l}}m}-}n }}w}-}x 8^ĉ  lʑ lʑ fJTe,g fJTe,g hhʑ'`e,g 5ʑ'`e,g h 1h 1 h 2h 2 h 3h 3 h 4h 4 eQeQ QQ !{{"hgUSCQ40% - :_eW[r 62340% - :_eW[r 6!?60% - :_eW[r 62460% - :_eW[r 6@8^ĉ 12 A8^ĉ 2B 8^ĉ_hQVL?e:SRNxcc PK N@theme/PK N@ theme/theme/PKN@ky}theme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PKN@4qtheme/theme/theme1.xmlYOo5#MvlM6Цۢ7&jHH q Jĥ|@_g{fvuHB#=$3{~\0aIyWj"i4ai=@RtOI;\|kxC$!֧rXlcyY0&\$X݄-jk iR; IY1*B&(qh\]Zkfr&LC!yİT0j,o^["NY[Y7|]`|bxhT2%}`jzIpV*F)hV@qv֬5\|̭NlXd Zck7V 7`KȄ/|>GA4qYLxd$(^bF!Р?H°)RLp!/М;ʅ!PL3 1ŷ_O@HD/?/ox[!MD f JNFb+1 m鞊f>\ƻ'7Y*|3N.Å7543*nC.NR#ٍ#éIBz>]wi(Sk!94_C' ڱ=̧69ty*HqªUr0aד <QoL#@ߊoB})=Ѽ9"A7IhWQw!S}g4rD /o`&*ݩ Mllz9QO K6{bqz[V?_O˯R UZ76-xvx7 Ԍ[tq5s%,Q4rpf \}@U*ܢZ<_d${Gu"Vz`3Vd߀yTe8]7RgO#KRtZ͕fB 1REp *ad6Y>fPM:\X/(ԁLHelCL!Rʿ^jt>)V!1)kdBBUuveDξ楔Ox|Fl*1_*3>LE/pcm']8fYrSd 7Z`*n^ٍrWŤ%R *z?ˈձ@#) sBYLþi*69mY&LiHł=(K& V.KLDUĕ{D ꦚeNƟg(MN5ߜJV6&3(a/E4r;,/ު"zbf58WV="\pkAf!xqQc, !_C:P[| l lt#h &Mwjf})m%.В4vٜ\LcvlmN55xdФ8ǘh/]| /Sm@PK N@_rels/PKN@֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK N@theme/theme/_rels/PKN@ ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PKN@ $[Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,x\vTU^hd}㨫)*1P'^ח0)T9l#$> `?Cs]7zb$xu-lV{9>DVNj,5(Bȥszҕhhs0U~,}2ToF0,į*=댬o[gv; 9'33y ; oOPKN@ $ [Content_Types].xmlPK N@_rels/PKN@֧6  _rels/.relsPK N@theme/PK N@ $theme/theme/PK N@theme/theme/_rels/PKN@ ѐ'  theme/theme/_rels/themeManager.xml.relsPKN@4q theme/theme/theme1.xmlPKN@ky} Ntheme/theme/themeManager.xmlPK ?# XTableStyleMedium2PivotStyleLight16`"C ؚ!h,gNyVf[u[{t5dNxh|Oo`VV5X( C A@-KmՋ@b g!hĉRv^SbpSOo`rE checkName checkZjlx checkSfzjhcheckDiffName1checkDateNecessary checkLen1,1,30  checkLen0,1,33 laRte!jgv'. SkXQ[vVI{~  yr+RV  V  N,V  NV -NvvQ-NN*N _kXy+' kXQVI{~[veg f341524200402283618\gf[341402200312101813l=N341221200012155842X m341225200308086052skV130824200405113514Ngёm341221200306105496N_j341222200309152999ׂs341324200311162465 [̑kNuu ~NmVNg130424200407170721 [^NSY RRR\yg34082620040114143X1g`i130281200401261522N,V闅h341623200207306748n[A341221200309074111?gim130434200403137513b3403222002031930174TwZwZ342622200204272401NgZS1306332004100460166rkeV[6eeQTh`341623200506104425m_HQs341503200411102717ROe130826200309025023NNd341524200511170217]oy`34012120050526002XS#k9340121200310254009Nj411628200602263856sqQR130129200410132115l)P130982200411106520s#kga130225200509247123Nςga342422200409017147vSfZ130581200401051863 _d_d_341224200404182128R債m130434200501304426sP[341422200302046510ؚ薵m341222200405156826ёh340827200510013265epg341302200209056414el T^S/f Ty{|W levelAffirmFAILURE checkTerm%fc[f[gf[g 4134014133yc[f[g checkYesNo/f&T checkGendersY'`+RsY7u'`+R7u checkDiffName NV checkSqyyCodee3ut1uxUSNd[?QkuNOOpXP[sYQQgNOVuV~pvQNmQNN checkSqyyName3ut1u TycheckDisableTypeƉRkuku{|+R,TRkuzfRkuvQNkucheckFamilyIncomeType]D0VYё0%m40e4TvQNRR6eeQ[^6eeQegn{|WyOё0W,g{Qё0W,gu;m901YNOiё~b0cS`N0QybQ.U[^"N_v6eeQX[>kS)Ro` gN8RS~)R0hy0ZSi_6eeQ~FU0RSNSNNy iN0{QkN0R]Ncbd_b,gTv6eeQ a{Q90b(vb){Q9 LN6eeQ vQN^S_eQ[^v6eeQ checkYearNt^~t^~2Nt^~3 Nt^~4 Nt^~SN N5Vt^~6Vt^~SN N7Nt^~8Nt^~SN N9mQt^~10mQt^~SN N checkZjlxQ[XuQeLr^yO /nyr:Sbgq/Nf oyr:Sbgq/Nf S~nE\leg_'YFLXY8lENE\OOAbgqB7bSZ A0   0%1Ya  dMbP?_*+%{&ffffff?'ffffff?(?)?" dXX333333?333333?& cAU} P} Q} @P} `P} P} R} R} R} P}  P}  P} K P} LL@P} MS P} T P0mmMmJNmOmJNmNmNmNmBNm{@ m{@ m{@ m{@ m{@ m{@m{@m{@{@{@{@{@{@{@{@{@{@{@{@{@{@{@{@{@ S T U V W W W WoooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooroVR4TooooooVVVVVVVVVVVVooVoVj~ X @YZ[[[[[ppp[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[R4T[[[[[[[[[[[[[[[[[[[[[[[j \ ]^ _````qqq`````````````````````````````````````````````````````````````````````s``R4T```````````````````````jZaZ[[[[[ppp[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[R4T[[[[[[[[[[[[[[[[[[[[[[[j b a b [ [ [ [ [ c d c [ [ [ [ [*W[[[[[[[[[t[[[[[u[vh iNjv kvl[ e f g e e e e e h i j k k k k! k" l# l$ w% l& R' l( R) R) l* l$ w+ l, R' l- R) R) l. m$ w/ l, R' l0 R) R) l1 m$ w2 l, R' l3 R) R) l4 m$ l5 l& R' l6 R) R) l7 m$ w8 l& R' l6 R) R) l9 m$ w: l& R' l6 R) R) l; m$ l< l& R' l6 R) R) l= m$ w> l& R' l6 R) R) l? m$ l@ l& R' l6 R) R) lA m$ lB l& R' l6 R) R) lC m$ wD l& R' l6 R) R) lE m$ wF l, R' lG R) R) lH m$ lI l, R' lJ R) R) lK m$ lL l, R' lJ R) R) lM m$ lN lO R' lJ R) R) lP m$ lQ lO R' lJ R) R) lR m$ lS lO R' lJ R) R) lT m$ lU lO R' lJ R) R) lV m$ lW lO R' lJ R) R) lX m$ lY lO R' lJ R) R) lZ m$ l[ lO R' l\ R) R) l] m$ l^ l& R' l6 R) R) l_ m$ w` l& R' l6 R) R)D:l: pppppppppppppppppppppppppp {@!{@"{@#{@${@%{@&{@'{@({@){@*{@+{@,{@-{@.{@/{@ la m$ lb l, R' l\ R) R) !lc !m$ !wd !l, !R' !l\ !R) !R) "le "m$ "lf "l& "R' "l\ "R) "R) #lg #m$ #wh #l, #R' #l\ #R) #R) $li $m$ $wj $l, $R' $l\ $R) $R) %lk %m$ %wl %l, %R' %l\ %R) %R) &lm &m$ &wn &l, &R' &l\ &R) &R) 'lo 'm$ 'xp 'l, 'R' 'l\ 'R) 'R) (lq (m$ (wr (l, (R' (l\ (R) (R) )ls )m$ )wt )l, )R' )l\ )R) )R) *lu *m$ *wv *l, *R' *l\ *R) *R) +lw +m$ +wx +l, +R' +l\ +R) +R) ,ly ,m$ ,wz ,l& ,R' ,l6 ,R) ,R) -l{ -m$ -w| -l& -R' -l6 -R) -R) .l} .m$ .w~ .l& .R' .l6 .R) .R) /l /m$ /w /l& /R' /l6 /R) /R)$@,ppppppppppppppp(    T 9CCButton 1C],@A9 $<_ Y h g<(>@<d  ggDh4hk:SW2h@h/,:SW2_1Sheet1   Q%nv{  dMbP?_*+%&ffffff?'ffffff?(?)?" d333333?333333?& U} @}  } @} } Q,,   , , ,,,,,, C D D C EEEE  E~ E? F E  E~ E@ F EEEEE E~ E? G E E~ E E EEEHE E~ E@ G E E~ E? G E EEEE EEHI E~ E? G& I E~ E5@ G, I E~ E6@ GO I E~ E@ H IEEHIEEHIEEHI E E~ E E E E~ E? E E E~ E@ E E E~ E@ E E E~ E@ E E E~ E@ E E E~ E@ E E E~ E@ E E E~ E @ E E E~ E"@ E E E~ E$@ EEEEE E~ E E EDTlF F88888888888888888888 !"#$%&'()*+,-./01:2:3:4W567:;<=>? E~ E? E E !E~ !E@ !E !E "E~ "E@ "E "E #E~ #E@ #E #E $E~ $E@ $E $E %E~ %E@ %E %E &E~ &E@ &E &E 'E~ 'E @ 'E 'E (E~ (E"@ (E (E )E~ )E$@ )E )E*EEEE +J~ +E? +E +E ,J~ ,E@ ,E ,E -J~ -E@ -E -E .J~ .E@ .E .E/EEEE 0E~ 0E? 0E 0E 1E~ 1E@ 1K 1E 2E~ 2E@ 2K 2E 3E~ 3E@ 3K 3E 4E~ 4E@ 4K 4E 5E~ 5E@ 5E 5E 6E~ 6E@ 6E 6E 7E~ 7E @ 7E 7E :E :L :L :E ;E ;L ;L ;E <E <L <L <E =E =L =L =E >E >L >L >E ?E ?L ?L ?E@D888888888888888888888888888@ABCE,F,G,H,I,J,K,L,M,N,O,P, @E @L @L @E AE AL AL AE BE BL BL BE CE CL CL CE EE~ EE? EG$ EI FE~ FE@ FG FI GE~ GE@ GH GI HE~ HE@ HH HI IE~ IE@ IH II JE~ JE@ JH JI KE~ KE@ KH KI LE~ LE @ LH LI ME~ ME"@ MH MI NE NE NH NI OE OE OH OI PE PE PH PI$,888888888888888>*@<d444ggDSheet2   %  dMbP?_*+%&ffffff?'ffffff?(?)?" d333333?333333?& U>@<dggDSheet3   "#$%&'()*+,-./012356789:;<=>?@ABCDEFHIJKLMNOPQRSTUVWXY[\]^_`abcdefghjklnopqrstuvwxyz{|}~ y A.  A.  A. ų0* pHd VBAProject4@j = r  [ J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\Syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE15\MSO.0DLL#M 1@5.0 Ob LibraryKMSForms>SFrms3D452EE1-E08F`A-8-02608C@4D0BVBA ddXfGdir;N z^X7R > CfxRRME(@V06 <`VhH0hX\H`H@ʀx @8 @ꀊh @dx @%Ϣ%ꀢh  @  @ꀞ @ B—(@ʀX @@ꀤ @6BJhB!rB#˵%ZBVHpH^xHʘBʀ @ʀP @b8ph @ꀜ8 @0 @  @f  @h BjP@ꀌ @X@l@ʘBn@ @ppB"H8h(XPpx x8@HT$p(8H [*\R1*#278$*\Rffff*0;5c7c0e46(*\Rffff*0;5c7c0e46\044    08  @ ` Dp 8 0 P0pD084P. ..(8(`>"$$@>`R^FX `*0$`   ^^0p@һṹҳ]$H=Public Const sheetNameValueTJ As String = "2ʵͳ"]$Ϣ2Public Const IntroSheetName As String = "˵"]$H]$˵] x ¼ܵУ]$H¼ͷ] "ִ һǿУ ĵԪĿ] x6ִ һǿУ ĵԪΪϹĿ] ÿһкϼеֵ] "һǿУʱ¼Ԫ] Ϣ] %---ģУ¼ĸԪ] 8---ģУ¼ĵԪ]  Уʱ洢ַ] 8¼ʱرհť]  ¼ܵУǷвϹ] h ¼ܵУǷظ] #¼ܵУǷظ] %/¼ЧǰǷдϢ ״̬] #У鷽ķֵ]$)¼ʼк]$ )ѧѧſʼλ]D¼ΪյĿ]P"/ǷΪЧ ͳ 5ֶΪյĸ] ("C¼ȥոִнȥ˿ո򷵻true򷵻false] PcellԭʼĵݣϵͳûнԶûĴ֮ǰcell] X7ϴдϢʱڵ,ӦĿʼʱʼֵһ] ] ] RڸݱʶòͬķʱжǷforѭ Cell_SelectionChangeҪõñ]$¼ʡصȼ¼ڵ]$+sheet±Ƿ] ]$h@)е]$) Ա]$p+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!xbabyID"J8= 3 'ѧɀѧλ Dim isay)i Ϊ%n%ArЂ>ΠЧ ! 5ֶc &removeSpaceFlal:ȥոy`ǀa$ˡ*tr@uefalse3e@ac2)!t`ûнԶûao?֮Csc ur @*)Long 'ϴxдF!8,ӦĿʼʱֵһF rna A',c1^isFO).ڸݱʶòͬ0)CA жϑ;forѭ C_Sele BFChMҪõW^,headIb'+ʡصȱ& SqsV9= 2 'q± "nottinueQ$AqJ1Plu"S6104 '!crge r6Ա s birthday= B4SsaSFM20L'B _&/;"1jIqAHq00}t#0Bq# 504 A34FC7FC0-6A2F-4A08-B602-807CF6FDDB986Users\yxq\AppData\Local\Temp\VBEaB6.exdbU;!.E .@`M Cf»ThisWorkbookGU T@ikWmkbok 2 HB1\B,!("B+qSheet1*G Se_tn1 u2 S@ 2 2e 2 2 ~ 3 3 3 3 )g *ߺG]wQQpee2j!om)(!6e7Gb^":  4P,`$>^,J( @ ~X$PV Pp >|  "n  "8`  h   \0 8@.dH x,L \ * *(X(p%0%D% % %0 %@ %,` %&  ( #6z $J  $"X (,V (PV (`" (,LF` 4Jv <($ <? ( D6v8 D0>p HBj Hl " G$0 H@ M4lH N~ N&N80N h ,xI D@,  ,0 48v40>8 jH8lh "G$HM4lN~N&N8N  ,I( 4008)"(@<($h <<0H6vH0>PBj(Plp "G$HM4lN~N&N8N  ,I0 H8<@(" H,8vp,0>0 j0l "G$@HPM4lXN~N&N8@N x ,I ,($$x  < 6H(LZ`(&( (   )$ ( >0,p,  (,>40x, ,",( 0 8H(2Px *4 +$N  `^p x4LdN   &4 $8d`PVxL 4Ld N8H P \X \x \ x"8@P2`$@6 8*H :x   ,@HP `a--------------------------------------------ʼУ-----------------------------------------]X]p+ijһ͵ıʶкź͸ʽ3:1;2] ʶ(ĬϱʶԶʶ)](ijһ͵ıʶ飨кź͸ʽ] ijһͱʶľֵ]Զʶ]%Ѽ¼ΪյкŷŽ]( `!2'"ȡĿ 0ĿȷģٽдУA@21qaz<$`B@|k1qaz<$`B@:1qaz<$`B@:1qaz<$`B@: V$T!NB@-$ÿοʼʱѴϢsheet,'XϢ¼ʼ'.ôУУ¼Ƿд֣׶ϢУ ('#Ĭ϶ѼδͨУ'Ĭ϶δͨУ V$T!NB@-$ÿοʼʱѴϢsheet, A65530$`%%!' A@B ȡxcna = Worksheets(1).Range("1:1").Find(What:="*", After:=[a1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Column IV5 <%%!('lFAILUREA@F&+ȡǷУɹ־Ԫ񣬲ֵʼΪ0'jռ¼ʼΪ0 0 8" ʱִ A9:IV65536$`%!j1ͺ9 9q A9:IV65536$`% 9(@9#ıʽqd ʼУ鰴ť¼ʱִ.ȷʼ Уرexcel $4ܵݶʧʧ 6ܰʾ$2 8d1qaz<$`B@|kk.$`!b(l)ҳǩΪɫ   "ûвҵѧϢ޷У飡A@2'01qaz<$`B@|k'ôУУ¼Ƿд$`!дϢ£A@P      '<"ִ һǿУ ĵԪĿ';6ִ һǿУ ĵԪΪϹĿ'''5"һǿУʱ¼Ԫ'9ǷΪЧ¼ 'fC¼УǰǷд';¼ԱǷд  l $`%N!b'Oһбʶֵ'2=жforѭǷcallFunctionXQStart ûִĬϷ <ʶΪ -$'Gʽ14-3:25 :$'H6ʽ3:25ȡıʶвֳ֣кź͹ DJҪּϵҪУ飨ĬУ͵ԶУ   Y&+1ΪеһԪΪĬУ $:$'V*ȡıʶвֳ֣кź͹$'SԶʶ  $;$'cԶʶ͵ľֵ   gԱʶб $   A@}ݱʶֵöӦķ  $`%N'bHȥַķ b$R'   $`%N'{ȡбͷ   е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  $`%N!t(v ӻɫ A@PN%isValidateCount = isValidateCount + 1kPHk@  $;$'Pȡıʶв   WԱʶб $   A@  $`%N'bHȥַķ b$R'   $`%N'{ȡбͷ   е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  $`%N!t(v ӻɫ A@PN%isValidateCount = isValidateCount + 1kk eJ ʽ3:25$'QԶʶ  Pʶеڵǰ$;$'eԶʶ͵ľֵ   kԱʶб $   A@ݱʶֵöӦķ  $`%N'bHȥַķ b$R'   $`%N'{ȡбͷ   е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  $`%N!t(v ӻɫ A@PN%isValidateCount = isValidateCount + 1k  k d-ֻĬУʽ14$;$'Hȡıʶв   OԱʶб $   A@  $`%N'bHȥַķ b$R'   $`%N'{ȡбͷ   е Fַ^ , ; ' <> " ? ո س뷨Ϊȫͣ飡''^УʱдϢ  $`%N!t(v ӻɫ A@PN%isValidateCount = isValidateCount + 1k@ 8 k0 k(  $`%N(  6ִ һǿУ ĵԪΪϹĿ     е һдȷ''8УʱдϢ A@P  'd   'Tÿһкϼеֵk  <,һؼֶȫ򽫸ɾ  j+ j 'j,"ϢеĸдϢɾ  X  X X  V$T%>B@@r Ѹɾ  X  'X f'k k  j 6 ɾЧ $'  A@8B Ѹɾd@   A@8H Ѹɾk  j ˴Уɾ j:Чݣ֤жУʧܼΪЧݣA@2k *дϢ鿴ϢA@2$`!b(l V$TB@Hd'A@ '%ִУظݷ,ûظǷҪɾЧ.$`!b(lSUCCESSA@F2+ȡǷУɹ־Ԫ񣬲ֵʼΪ0 Уͨ!A@2d*ظݣ鿴ϢA@2$`!b(l V$TB@Hkk1qaz<$`B@1qaz<$`B@1qaz<$`B@o@q-------------------------------------------------ظijһ------------------------------------------------@]] A65535 L%%!'2Scripting.Dictionary$.O8O  L%!b'>ȡѧ  %"ѧ໤֤ݽб   %-֤Ų  B@&#addһΪkeyڶΪvaluek@k80 ! 'Sheet2$`G:G7B@  !% !2G17, q.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^, bm4(Dc71: 1 F`#(Whatb*", After:=[a1], S@IchOrdAxlBy@bsDirj7:=xlPreviousPolum'dyB)1.IV5ToLeftki`@8, "FAILURE"cAL<ɹ־Ԫ񣬲ֵʼΪ0 0F4T @} isSaveButtonvbOK“ ʱִ% With :9:IV!;6A-rͺţ.a["!h.Siz11c' h@.Horiz@alAlignm e xlA3 IberFormatLoc$al @"ZĜQts DFЀť¼Yca("ȷAM ̡Hرexcel" & Chr(1Po& "ܵݶʧ0ʧܠ0Can'ܰʾ")06!$ E b{!ohohjh3 hKTabwlorIpOx -4142!}ҳǩ'Ϊpɫ PIstartTitle +p`yt`3 "ûвҵѧQ^޷Ay:?vQl6:8?|?|k|49!hlïll writeLong|@<&p£?!H> )8 i2 Tog  p&QZ ' A/#= S@t(+o-o'c14-3:25  $rowType = Split(tValue, ":") 'ʽȡıʶв кź͹'If UBound(bs) <> 0 Then 'ҪּϵУ飨Ĭ x͵Զr 'HFPor mLa+ 1 Tol'+1ΪеԪa@valE`ntityrT(|m)roRow"%(0e3;{@i)E,'@>kGA1b;BľֵRnR)Q'gx? callFunctionXQStart `(n`1, Pi, jsidateCt#ֵöӦķ #uWorksheets(1).Cells()_ _ #'!ȥַ? (removeSpecial@>Character(_$f+g ,`leMsg5sKTitl@jAбͷ9A)error"" & i`("AjA F& "څ@^ , ; '"" ? ո س뷨Ϊa뀼飡"_ hasE `Tr1'!sʱxϢoT8.InP+ior.Colv= 65535 'ɫwriteLog uO'iLO= p_End If /Next5 _ m ss= False2ooV4T0_S~~~ }}} RkBzzz;s= zzozʕzȡzzzzzzzzz zzд@Ϣ JWorksheets(1).Cells(i, j).Interior.Color = 65535 'ӻ MwriteLog errorMsgM`'isValidateCount#k+ 1:En@d If 3)N8ext&ElseIf UBDd(rowType) <> 0 Then 'ʽ3:2,52#tRow^(0) 'Զʶp{@Ci(+A(еڵǰ;jvalSplitcs , ";"N%ֵ) yF}nLA0) ToC' б+callFunctionXQStart `(n), 1, Ay'$4öӦ𷽷+|ue %v__#'@!8ַ? (removeSpeciBPCharac`()#?m+m (tiXtle5sLTaa 'ȡбͷ)%"" & i`"A jA0A& & "E ^ , ; '!["" ? ո سΪȫU飡"_ _ ahasE{P Tr1'ЀʱS_8_ ߍ 'ֻĬq)Í140pPsp.szbs1ezB1Dħr//xxxvv% ?bc::// rrKk= rr rrrrrrsgtrrrr_ rr5Ϣ JWorksheets(1).Cells(i, j).Interior.Color = 65535 'ӻ@ɫMwriteLog errorMsgM`'isValidateCounFtk+ 1:End If +)Next! ׆LockedO`False_*3 j 'ִ һǿУ ĵԪϹIf atLeaOneNull~<> 0 Ah= ThenEa@I" " & i",EA?Ё?ȷ"has = True ')ʱ繀д_? sjn+ 5EMtotalMoneySLum1+  'ÿһкϼ@4ֵicO> 1 II '!2ؼֶȫɾ&_isAWRo wArr(Num) !i r E ) `'yeO-%Vi FpcFua  - -.To  fSCmsg"Name$).s(x). Deletpܸ_9/p" =OhEInu3 )?; rq 0 i/@!1 '%Ч  rowData,/4q)@?T_cd"A,1,)'#oROs- q qURtK!zw ; Box "˴AnRRwJ& xݣ֤Brܼ:Ϊwvn?p 2 y鿴EQ`+TabӻIndezx016MMS}(c%0SP0/#checkdXQNew Not (0n ظA,asD0,Ҫrf -4142setԐQueXQ 2,!8, "SUCCESS" `'ȡA ɹ־cֵʼΪ0 #Aͨ!! Oq'E'''''6Protect Password:="1qaz2).3 Sub '-!.ijһ[-, Sub checkTheSame() Dim myDic As O@bject, Key VariantPH&, v@arData 'rna = ActiveSheet.Range("A65535").End(xlUp).Row '@b Set idNum= Create("Scripting.tionaryz"b I@O8", "O" & R).value 'ȡѧ ӀFGFor Eac h carK IFnO4'ԁ໤@֤ б$ If"<> h"" nNo~.Exists(<) '3 GA.AddE, Null 'addһ ΪkeyCh,IN$exƒ Cmy=.sWith WorksAsp2GmG:G@ClearConten.t41@Re size(B.C ount)AppPlica.FFunon.Transpos '?D4'*= eah@ @ ]wQQpe  K!hQpe PnSheet1 !Sheet24Cf(xME(6 LLH D` X IF xIH `J P(`  iR Z`  I\ IF I^  dX` 8  iR n0`   I\ IF IH Ip  |`   'I\ IF IH  ` @ 2I\ `I IF IH I  ` 8 GI XI\ xIF IH I  ` 0 I PIb `  `  I + ` X I\ xI i`  ` ( Ib HI* hI, @0 88 `  4I\  I4  B `Hk :I\  IF  I^  Ib (  D ` h AI\  I4  F `Hk EI\  IF @ I^ ` Ib (   ` JIb  I\  IF 8 I^ @0 @H @J  ` cI\  IF 8 I^ `*`L`N R`  sIb @   0(  8 XB% x@B `@ @ @0 @ @H @`x @` @H @ ` 0(0hH@F X0`@ @ @ @ @ @x @` @H  0 [$*\Rffff*0<5c7c0e47*\R1*#3c7*\R1*#12d*\R1*#121} B       B  B h p B ( 0@2` p  B 8 8@ $x 8 " pB x 8  $ $  HP xXB 4(0*X$ 8BP0h!  ( 0 8 @  B   4 $H  "p   "   .  0 0@ p  *   .  8 .H  x  0   6  0@6X 8 6 P`(x   f @ `x>&  Xhp h * Hhxj& (8@` `h   H(xX H( H(p Hp( P &X  n 0@X ` 8x( Hh( ` &h  b 8 Xh&( P ,` f ( HXp x 8( 8p( H &P x f  (8  `  Tp  &  !! $ ! &H!$|p!$&!$ "$(" 8"@" H" X"$t`"$&"$ # # $# # (#H# ^P# #"##@#&8$ `$p$ x$$$$ ^$(% @%`%@h%&% %% %&&0& b8& &&& t& &P' x' ''' b'  ( @(X(h(p(&( ) 0)8)@)`) ^h) ) )**X *&x* **** ^* @+ `+p++X+&+ , , ,(,H, ^P, , ,,,T-&X- - ---- n- 8. X.p."..&8/ `/ p/x/// j/ 0 80X0"h00&1 @1P1X1x1 P11112&2 2 2222 R3X3p33X3&3 4  4(404P4 bX4 4$45@5&H5 p55$5555 ^5 @6&X6 6@6&6 67&70787X7 Z`7 7&78@8&H8 p88&8888 f8 H9,h99@9&9 ::, :P:X:x: |: ;$;@;(H;@p;&; ; ;";< <@< |H< < <=@=&H= p== ==== |= X>$p>>@>&> ??$ ?H?P?p? dx? ? ?@@&X@ @@2@@ x@ PA6pA.AAA( A2B( B1 B( 0B2@B( PB1`BpBxBJBBBCCC fCB C C<CC CD$(D$PDxDD D \0E B E,E 0E@F"PF ^xF 6FG(GHGhG0GDGH H(H0H8H@H HH "H I .0IB `I hI$xIBI I I J J J 0J8J@J HJ J J K 0KB HK"PK xKKK KKK K8KL2LPL hL LL LL LL FL(M0M 8M @M *PMM M (N @NB XN`N*N 4NN NB O^O vO O O pP PB P*PP PB pQ^xQ vQ Q QB pR xR "R R8R2SHS `SS SS S SS"S0T 0T(PTxTT&TT TT TB `UhUVUU 8V 8V XV:hV4V$VW" WHWPWXW `WB WW6X8XHXPXXX`XhX xX-----------------------------------------УУдϢʾ ע----------------------------------------------------------- Ԫ] F H L%N'J J'Dd('Dki--------------------------------------------д־ ¼ϢʾһϢ-------------------------------------------- R X V$T,N X 'XiX------------------------------------------------------ ȡָcellֵ-------------------------------------------------------------( F ^ \$`%N!b'Zi--------------------------------------------д־ ¼ϢúɫʾϢ-------------------------------------------- R'f R X V$T,N f X V$T%N%h!j(l X 'Xii--------------------------------------------עʼУ飩-------------------------------------errorInfoעX 1Worksheets(sheetIndex).Unprotect Password:="1qaz" p F H \$`%NB@r F H \$`%N!t(vW ӻɫ F H \$`%N!x(zii--------------------------------------------ɾעʼУ飩-------------------------------------01Worksheets(sheetIndex).Unprotect Password:="1qaz" F H \$`%NB@~ F  H  F H \$`%N!t(ld  F H \$`%N!t(lkpihr---------------------------------------------ʼУ Ƿӻɾעõķ----------------------------  Уʧ F H \$`%N!xd жעΪ \ F H A@nV עd"Ϊգȥǰע \ F HA@|N ע \ F H A@nk1 MsgBox "" & rowIndex & "" & errorMsgd :УɹжǷעУʧʱעȥ \ F HA@| ,#ȥո,ʾ FУ HУַ"$4 "$4"а˿ոϵͳԶΪA@Pd`kXkPiH----------------------------------------------------------------------------------------------------------------------------------y--------------------------------------------ݱʶöӦķ(ʼУ)-----------------------------------------------------------------------------------------------------------------------------------------------------------------------ѴϢдб F H \$`%N'b  H \$`%N'Iȡбͷ Ϊϲеıͷ  H \$`%N' F e  H \$`%N'k0'  checkLen*)ΪУ  $'checkLen'  checkNum*e-ΪNumberУ  $'checkNum'  checkVal*e-ΪֵУ  $'checkVal'  checkInt*e-ΪֵУ  $'checkInt'  checkTerm1e-"ǡ"Ϊ1' checkTerm'  checkYesNo1e/"ǡ"Ϊ1' checkYesNo' checkDiffName1e2ѼΪ1' checkDiffName' checkDiffCode1e2ѼΪ1' checkDiffCode' checkIDCardType1e4֤Ϊ1'checkIDCardType' checkSqyyName1e2ԭΪ1' checkSqyyName'  checkYear1e. У1' checkYear'k _=================================1 ִеķǿУ==========================================ѴϢдб checkNullKT \ F H$'  F е Ϊգ'')УʱдϢ A@PRMsgBox "" & rgold.Row & "е" & Chr(10) & titleMsg & "Ϊգ"k \  F H A@'a=================================2 ִѧУ========================================== checkNameKT \ F HA@@ȥոķ F H \$`%N!b'b b$'  F е ;дȷΪ֣ȴ1ܳ20ַ''%УʱдϢ A@P  'k \  F H A@'Z================================= ִеijУ==========================================checkLenKT b $'  ,$'$ ` ΪDZΪ̶ȹ F е .дȷΪաд򳤶ȱΪ$ λ'$ ed ΪDZΪȷΧ F е 4дȷΪաд򳤶ȱڵ$ λҲ$ λ'$ ed ΪDZΪ̶ȹ F е &дȷΪգҳȱΪ$ λ'$ ed ΪDZΪȷΧ F е ,дȷΪգҳȱڵ$ λҲ$ λ'k '0УʱдϢ A@Pkh \  F H A@'h================================= ִеijУ飨Numberͣ==========================================checkNumKT b $'  ,$'$@ ΪDZΪ̶ȹ F е GдȷΪգдΪ֣0λȲ$λСλ$ λ'$ ed ΪDZΪ̶ȹ F е ?дȷΪգұΪ֣0λȲ$λСλ$ λ'k'0УʱдϢ A@PkX \  F H A@'[=================================ִֵΧУ==========================================ѴϢдбcheckValKT b $'  ,$' F е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@P& isValidateCount = isValidateCount + 1kh \  F H A@'_=================================ִеΪֵУ==========================================ѴϢдбcheckIntKT b $'  ,$'$@ ΪDZΪ̶ȹ F е 8дȷΪգдΪڵ$ҳȲ$ λ'$eD ΪDZΪ̶ȹ F е 0дȷΪգұΪڵ$ҳȲ$ λ'k'0УʱдϢ A@Pkp \  F H A@'`================================= ִе֤У========================================== checkSfzjhKT \ F$Z'S ȡд  F е &дȷ֤Ϊգ''0УʱдϢ A@Pd  ֤ b H$'O ֤У :֤У F е MдȷΪѧ֤ţһλΪĸXıд''4УʱдϢ A@P  'kd b$'  F е EдȷΪգҳȱڵ1λҲ18λ''4УʱдϢ A@Pk"k"k" \  F H A@'X================================= ִ֤У================================== checkZjlxKT checkZjlx b1$'  F е дȷ''(УʱдϢ A@Pd! checkZjlx \ F HA@k`! \  F H A@'W=================================ִ꼶У========================================== checkYearKT checkYear b$'  F е дȷ''(УʱдϢ A@Pd checkYear \ F HA@k \  F H A@'\================================= ִѧŵУ==========================================checkXJHKT b1, 1, 50$'  F е EдȷΪգҳȱڵ1λҲ50λ''0УʱдϢ A@Pkp \  F H A@'[=================================ִпУ==========================================ѴϢдб checkBankKT b$'  F е $дȷΪ֣ڵ$ Ҳ$''-УʱдϢ A@Pk \  F H A@'W=================================ִУ==========================================ѴϢдб checkYearKT b $'  F е *дȷʽ20122002ȣ''-УʱдϢ A@PkH \  F H A@'W=================================ִѧУ==========================================ѴϢдбcheckXnKT b$'  F е )дȷʽ2012-2013ȣ''-УʱдϢ A@Pk \  F H A@'W=================================ִ·У==========================================ѴϢдб checkMonthKT b$'  F е &дȷʽ0112ȣ''-УʱдϢ A@Pk` \  F H A@'g=================================3 ִеУ(DZ)==========================================ѴϢдб checkDateKT b$' 2Уʧ F е дȷдʽΪ"$4 xxxx-xx-xx"$4 2013-02-21''-УʱдϢ A@Pk \  F H A@'c=================================ִеУ飨==========================================ѴϢдбcheckDateNecessaryKT& b$' 2Уʧ F е дȷдʽΪ"$4xxxxxxxx"$4 20131221''-УʱдϢ A@Pk \  F H A@'J=================================10 У绰====================== checkPhoneKT b$'  F е дȷдʽΪ"$4-̶绰 ֻ"$4 ''%УʱдϢ A@Pk( \  F H A@'L=================================checkOption У鱸ע ====================== checkOptionKT bB$'  F е )дȷȲܳ200ַ''%УʱдϢ A@Pk \  F H A@'\================================= ִ϶ѼУ================================== checkDiffNameKT checkDiffName b $'  F е дȷ''(УʱдϢ A@Pdx checkDiffName \ F HA@kH \  F H A@'X================================= ִ֤У==================================checkIDCardTypeKTcheckIDCardType b $'  F е дȷ''(УʱдϢ A@PdcheckIDCardType \ F HA@k \  F H A@'T================================= ִвмУ==================================checkDisableTypeKTcheckDisableType b $'  F е дȷ''(УʱдϢ A@Pdx checkDisableType \ F HA@kH \  F H A@'`================================= ִмͥԴУ==================================checkFamilyIncomeTypeKTcheckFamilyIncomeType b $'  F е дȷ''(УʱдϢ A@Pd checkFamilyIncomeType \ F HA@k \  F H A@'v=================================14 checkGender ִǷΪСŮУ--================================== checkGenderKT checkGender b1$' '-ԱдУ֤Ź F е дȷ''(УʱдϢ A@Pd checkGender \ F HA@k \  F H A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkYesNoKT checkYesNo b $'  F е дȷ''(УʱдϢ A@Pdx checkYesNo \ F HA@kP \  F H A@'u=================================14 checkYesNo ִǷΪǡУ--================================== checkSqyyNameKT checkSqyyName b $'  F е дȷ''(УʱдϢ A@Pd checkSqyyName \ F HA@k \  F H A@']=================================checkTerm ִѧУ--================================== checkTermKT checkTerm b $ F е дȷ''(УʱдϢ A@Pkh \ checkTerm b $ F H A@'r=================================checkAtLeastOneNNull ִһΪǿ--==================================checkAtLeastOneNNullKT  'A"ִ һǿУ ĵԪĿ b$ b=Ϲ  b ' H KTF  b ' KTF  b ' KTF  b ' KTF  b 'ndϹ  'F6ִ һǿУ ĵԪΪϹĿ    'k'ni_--------------------------------------------ʽ-------------------------------------]pVBSCRIPT.REGEXP$.7RegExΪʽ (4 ȫֿvba\ת  (.ʽ (5ǷִСд b %'3 ִ.ix-----------------------------------------------------------° Уظ˵Ѿûиʽ------------------------------------------------------------V-----------------------------------------------------------1ѧ׶ڱڲ(sheetѧ׶ A65535 $T%%!'*cna = getTotalColumnCount(sheetIndexValue) V$T!NB@1&ÿУظʱʱѴϢsheet,'XϢ¼ʼX==============================ѧ׶ڱڲ==================================0ðÿԪغ֮ǰнбȽ      $T%N'       $T%N'  .ѧͬ˵ظݹ  еݺ͵ ظ!!!!' A@P*ѴϢ'kCCCiC-----------------------------------------------------------һ ֵȡֵ------------------------------------------------------------ֵҵֵڵлkeyWord ҵĹؼ'kbn л ֵΪ rowrow']the find result object  "  &$ A1:A65535 \$`%%.  row !'dA !('kAkAiA------------------------------------------------------ ִڹУ(Ϊ)-------------------------------------------------------------value value1 cellУ鲻ȷfalseУȷtrue ,0˵ΪDZ *$.'z`@kX@kP@]'2ijһļ¼ A65535 6$T%%!'4B' 6 brow$'0=ȡ  0 4  6$T%N b 2 '2d`?yX?kP?   0 0 2   6$T%NX *X LжϹǷcell'y>k> #ʱcountĿΪùеĿix>------------------------------------------------------ ִɾijһвexcelܱģ-------------------------------------------------------------sheetIndex rowNum к1qaz< \$`B@: 4 \$`%>B@@/ Ѹɾ- Worksheets(sheetIndex).Protect Password:=123i=------------------------------------------------------ ָcellֵ-------------------------------------------------------------8 1qaz< \$`B@: b F ^ \$`%N(bi0<------------------------------------------------------ ִɾijһвexcelûб-------------------------------------------------------------sheetIndex rowNum к 4 \$`%>B@@/ Ѹɾi ;------------------------------------------------------ ָcellֵ------------------------------------------------------------- 1qaz< \$`B@: b F ^ \$`%N(bi@:------------------------------------------------------ ݴеֵǰʱѾͨУ飩------------------------------------------------------------- ]X p  F ^ \$T%N!bX 'J'2ijһļ¼ A65535 6$T%%!'4F 6 brow$'0Aȡ  0 4  6$T%N b 2 '2dh8y`8kX8   0 0 2   6$T%N!bX '* * JX 1жϹǷcell  6$T%N!b'H HX F ^ J \$T%N(by7dx7 F ^ J \$T%N(bkH7 i07------------------------------------------------------ ȥcellеĿո------------------------------------------------------------- ]X Ԫ]p  3Blength1ʾcellԭijȣlength2ʾִȥոַ'ĬΪûȥո2 Worksheets(sheetIndex).Unprotect Password:="1qaz" F ^ \$`%N!b'* *'L LGzj*"ԪΪգȥո * 'N%length2Ϊոһγֵλ Nַո * $P'* *X F ^ \$`%N(b'k4i4------------------------------------------------------ ȥַ------------------------------------------------------------- ]-[\uFF00-\uFF06][\uFF09-\uFFFF]|[\s,;'<> "?^]+'  b$'Rd3'Rk3i33Attribute VB_Name = "ߺ"  '-%УдϢʾ &( Function checkedRequiredStart(rowIndex, c olumn )  { 'Ԫ@Dim cellValue As rSng= A;veShePet.Cs6If-" Then*F_Fal4seETrund If < E)[д־ ooһkqmwriteLog(content]iX`s(msgB)[curMsgRow, 1)JCK + 1:D ȡ AֵLJpHDgetBCountXQ(sADʴ A?WorksHEQy.vA`%2GúɫCG3 GRedVHnLen EKzKRcR.Characters(1, ).F].Color73?VJxx&!ʼs+#` errafoåaddCommwXQCVUů,  0™'TUnprotect Password:="1qa>z e\N.A ( I0rior#=<65 535 '1ɫ>% d/.Visid3"@"" &Ǝ"xtitleдȷ"ΪաB"`ΪA<1)λ0+El4seuO2]OA+dΧOexA6OAOڵBgPҲг1-2?-%,q?-= 1T`jT?-TTTĚT &S "SeS&SS &&&R`'R?,%IE IfGhasE 'aʱдϢ writpeLog*WbeginC?|}?z }Numberͣ{}]v} }}F a}}|UP#}}j}oQ{o>h& {{1{{֣>0޻qSf(v}?Сi?VsQ?VD//i0cW7MWWWW  dW____ԧWR}Կڄulд0бXtValXWWWWgWBWWW] ߎ̿g387߷g5G& "NP? 33^д writeLog er@rorMsg' isValidateCountD ="+ 1E nd IfbeginCheck@_commeYsheetIndex, cMethodXQ, rowolumn isForUTrue '=ִеֵУ0дб{Case "mInt" ~b(value, functionArg s)"] NotR Then E IArRSplit(, ","3If ,(0 )@50" 'DZΪ̶ȟ+Ń@"" &"Ax title@ȷ"Ϊ@գCڵF K(1)AA/, 2 λ7 ElseS1))& ))))(gsD((hHBhasEJ! 'aʱ CVf _Fck>k è़ߨ  }ASfzjhcr@esZjlx 5g@etCelluqcXQ(iˇ p'ȡ!|;o ""m;9hh*"i$_,_,߃|_,(KO<? sIsID@Number%scg) ') = tqtk #.OM!)djjj#Uѧ Ctһλ!vΪĸXдgO _$_$_$/$$/V?++? =SFZJLX'On?&XQF$$Q&Oz"Î10vP18w $$$O$$o _<??_5_~ ?? N,_~[}sR~sFh_~=={}a{}b ]0DMB(SԒ, d"155V5555/z\ /1/1/1\a0سeLog errorMsg aElsehsetDMBCode "checkZjlx", sheetInde@x, rowc`olumnE nd IfbeginCc_co`mment e}MethodXQt,isFor = Truy'=ִУoCasYear"x iK(, value, 1)"If Not %ThenE"" &p"titleдȷ06hasE\ 'Rʱд@Ϣ*writV:_쭱 XрŵY)] 3ZXJHX?QB=SLen(Y"1Z, 50"Z?A*?[ /?\?\Ϊգȱڵ1λ50bcc&dF7ny\ck \T==a\п\k\'!%дaЄ_Bank_^A^?] {!1\9_.sg|\R.Q-Ϊ֣-_functionArgsArr(0)G/?r(130! >0ObOb O0y'/0/0///, x/E //+.!/p. ../ .quE^#/o^XQ //u!*OO@/ʽ20122002ύ++++ߺV))))))O&)ѧ)))nX))Xԇ(P((((a*(-(3(((((([oT*******'*oT?_***Month*** G**  errorMsg = "" & rowIndex("6titleZ& "дȷʽ0112ȣ`" hasETrue 'ʱд ϢIwriteLog /'End IfbeginCheck_comment sheDet, c MethodXQ, olumnAOisFor  '=3 ִ(DZ̜)@Xдб?Case "8Date" O B4Birthday(valu e)OWʼnIf NotKS Then 'E;ʧ[!M7ΪC@hr(34)Ax-xx  2013-02-21E,a.yacka$8ga\+aa a"'laNecessaryb!bFccc?c߿Σc!duc12?ce??c ?e ???k?_X!10 绰\G68,Phon6ezX=Num*D[XQ[>/(W/(Z-̶ ?)Z$ b''X_(TWW_(O%b~Option(ע /x(((c(, 660(`((((Ȳܳ200ַg%%%9%%%%t%%%%%%!?#϶ѼqO .x'DiffNam/PR ''DMB(԰, , funcA0Args_)BORORV))))?Nl(((L(( Else[ysetPCodvǗiez'o|.....6U_*.81~.==.heckIDCardType"  cMethodXQ = d 0Z ' Ϲ &Btotal @|+CgSelect tޘ%"baojiao5C:1 Sum-, huoshic _ Bzhusu?L?# others H   E 2Oc*?%| '23 =pG>6>>>Ϊѐ@KEŎ+ ֓+ " JbXC Ft-Ԁʽo-  regB(})8DimaEX A`s ObjISet= Create("VBSCRIPT.REGEXP")a'RegExΪpG EX.GlobalpF"n'ȫֿ''vba\תPatter.n RʽIgnoreB8= FaǷִСд<3TestgGB.hing #$O ° 4ظѾ(ptᾣ 1ѧ׶ڱڲ -B}0S XQNew(W2) 'w(TnaS!s:.Range("A65535").P(xlUp).HRow'cgxetT1wMVh6msg).Cells.ClearCont@s 'ÿʱqذ5AB ,cuq P 1 '¼ʼ/ocJ'ðÿԪغ֮ǰнбȽϧi0 startT + 2 To0 rnag4babyID1I2(i,a3YOdAjO@i - 1oq2exj$`N If bab@yID1 =H2 Then 'ѧͬظ  errorMsg"" & j"еp(iS !"\writ eLog e'Ѵ :haBsSameTrueEnd If Next Functi@on '-7һ ֵȡֵи+-K)ҵ*лЀkeyWord Ĺؼցbn ֵΪ row$ @ GetRowOrColIndex(ByVal sheet, CD@As Str ing) Integer[@o-1GbDim c Object 'the fi@qresult o# Set = %=k&s(().Range("A1:A65535").F@(What:=.LookIn:=xl8ues, AAxlWhole)GNoIs }h9G@ k@B= "U" Cc.@]ElsP5umW eM`]U ִУ(Ϊ)?]8Vvalue 1 cellP'Aȷfa%et[checkDM$B( , 1, flag<7I`S"0c7 'DZB=Trim# 1>)U>`Exit 2598f!LDataCount 0 ' һa(¼C(Num`Szs(pAreagf (xlUp@jow `'E HF/ -Ul $0,#e) '>C`For i % To @7C`Fs(i, 3b>r'+ (p=#5o2a i'j.5 + c V-i DC(jp, 3)M,)r 'жaq2Ƿq35)^j'ʱc(ĿΪqӰB P ._w/B-bHɾ.вexܱoG1` ' кňsdeleteP\h,*Ejv).UnprotaoPassw`|:="1qazO$obs().D p6!'rA}).P123_ ָc'ֵ?(setΣǀʱ1Ѿͨ)?Code%bW8i<, c 2QL2p|?y,HC=  S]__"A65535").End(xlUp).Row '  rowData = GetOrColIndex(Area sheet, value, "d") 'Ѐ`For iS]To Num"PIf S`s k).Cells(i0, 1)Fy Then ?CCount#+ 1 "ElseExi t Rnd If Next i;jj5j+ ]?-?Q_1QStr(xj, 3).)<"U%cV) 'жǷ́code('2'WtǎsNĒ"c + umnPlusDJF%PBA.qB}AD89'""O?j  Functio@'-2 ȥCrĿո&  removeSpaceXQ(G",u#l50DimÁ1 As Zing 'ԪP$@lengthInteger, Mc2d 'ʾ#ԭijȣִ"!ַ<JFa C 'Ĭ0ûF' PWork!s!).Unprotect Password:="1qazhAst`Njd Len( /;'0CaM '1Ϊգ%$c r2 In! ἤγֵ`λÇf2p <> 3A5'q ReplQ"E+,AbX  ETru%|?zs- 2a$?8zecialCharacterq!9regp"[\uFF00-)b6]9FF]|[\s,;'""?^]+s/`CheckAE(#i `Fz "?@ABCDEFGHO_LMNP[QRSTUVWXYZ\^]`nabcdefghijklmpqrstuvwxyz{|}~pXCfxME(6 <<<@ `X I\ xIF IH `J ``(  Ib @ ` Ib @ `H  Ib @ +` ivi^`xH`H`z``|  `  Ib @ `x  Ib @ @`  Ib @ `  Ib @  `( Ib HI @  ` Ib @  `h Ib @ 0 ` Ib @  ` Ib @ h ` Ib @ @  ` I*  I  D `X  I* x I  0 `  I*  I   ` Ib  I  ` ` Ib @ I   ` Ib  I   `P --Ib p I   `  Ib @ `x  Ib  (`  Ib @ `  Ib @ H`  Ib @ ` !!I IF I^ ` ` `N````@ ` @ ` @ ` @ (` @0 H0 ` h   t0% H+P [$*\Rffff*0@5c7c0e49  B       (  B H- ( 0B    HX`hpx B  n ` xB ,$H0 x  "  "8`h4x  8 X B p x 4         B        ( 0 8   B   6 8 H P X ` h |p   B ( 0 08 h x     x  8B P X h x  B  |   B $ (08@ |H  B fx | 0 PB hpx  X xB : 08 @HPX`h p  (B @ HX` h p    .@B p x    .pB   B  &D4P  B  &  0(8 `"h D4  (08Xx B (0H P`hp x "  <  (0 8B  D X  p x    &       !" ! H!P! $X! "! ! ! ! !!!" "(" 0">H" "4" " "" "# # # #B ####$$$$ $ ($ $ $B $$ % %% % (% % %B %% & &0&8&@&H&P& X& & 'B ('0'8'P'`'h'p'x'' '  ( @(B X(`(h((((((( ( p) )B ) &) $) *  *&0**X*"*$**(* +@+`++++ + 2+," ,H,h,  p,,,8,,,P------------------------------------------1 ,дϢʾ Ϣsheet--------------------------------------- ʱ0 Ϊʱ1 Ԫ] F H \$`%N'J J'd'ki-----------------------------------------2 Уѧ ҪΪ-------------------------------------------------------------ʽȷfalseʽȷtrue]H  b$'d@'k0i(|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------` b$.'zpkh]reg = "^((19)|(20))\d{2}-((((0?[13578])|(1[02]))-((0?[1-9])|([12][0-9])|(3[01])))|(((0?[469])|(11))-((0?[1-9])|([12][0-9])|(30)))|((0?2)-((0?[1-9])|([12][0-9]))))$"^((19)|(20))\d{2}-((((0[13578])|(1[02]))-((0[1-9])|([12][0-9])|(3[01])))|(((0[469])|(11))-((0[1-9])|([12][0-9])|(30)))|((02)-((0[1-9])|([12][0-9]))))$'  b$'d'ki|-----------------------------------------3 УڸʽΪ2012-05-09(Ϊ)---------------------------------------]h^((19)|(20))\d{2}((((0[13578])|(1[02]))((0[1-9])|([12][0-9])|(3[01])))|(((0[469])|(11))((0[1-9])|([12][0-9])|(30)))|((02)((0[1-9])|([12][0-9]))))$'  b$'d'kih-----------------------------------------4 У֤---------------------------------------Ϲ򷵻trueϹ򷵻false]790584216379058420Ȩ] 10X9876543200У v$.'v ȥո]H`x ^  v6)׶֤Ϊ,ΪͨУ ~'z0k( vGzj v$$Gzj v*[0-9X]Gzj  x $'| |G '|j z v $ | 'zP z '| v$  | $G'jiz-----------------------------------------У֤ -------------------------------------------------------------ʽȷfalseʽȷtrue],^[\u4e00-\ue863a-z|A-Z|0-9|()|]{1,18}$'  b$'d'ki----------------------------------------5 -УѧУѧУʶ 42λһλΪֻx-------------------------------------------------------------ʽȷfalseʽȷtrue ]^[1-9]\d{40}[\dx]$'  b$'d'kiz----------------------------------------6 -У黧 -------------------------------------------------------------ʽȷfalseʽȷtrue](.^(\u519c\u6751)|(\u53bf\u9547)|(\u57ce\u5e02)$'  b$'d`'kPiHu-----------------------------------------7 Уѧʱ-------------------------------------------------------------ʽȷfalseʽȷtrue@]'^(((19)|(20))\d{2})((0[0-9])|(1[0-2]))$'  b$'d0'k iq-----------------------------------------7 У-------------------------------------------------------------ʽȷfalseʽȷtrue b ,ΪDZ'k zk]h^((19\d{2})|(2\d{3}))$'  b$'d'kiq-----------------------------------------7 У·-------------------------------------------------------------ʽȷfalseʽȷtrue]^((0[0-9])|(1[0-2]))$'  b$'d0'k iv-----------------------------------------9 Уѧ-------------------------------------------------------------ʽȷfalseʽȷtrue]^\d{4}[0-7]\d{3}[0-3]\d{7}$'  b$'d'kiv-----------------------------------------10 У绰-------------------------------------------------------------ʽȷfalseʽȷtrue]^\b((1(([38]\d)|(4[57])|(5[0-35-9]))\d{8})|(0((10)|(2[\d]))-[2-9]\d*)|(0[3-9]\d{2}-[2-9]\d*))\b'  b$'d 'k i v-----------------------------------------11 Уп-------------------------------------------------------------ʽȷfalseʽȷtrue0]^[1-9]\d{14,20}$'  b$'d 'kx ip -----------------------------------------checkXn Уѧ磨2012-2013-------------------------------------------------------------ʽȷfalseʽȷtrue]8 ]P 1^(20\d{2}-20\d{2})|(19\d{2}-19\d{2})|(1999-2000)$'  b$ b-$'$$ 'd 'k d 'k i -----------------------------------------checkOption У鱸ע磨Сvalue2-------------------------------------------------------------ȲС200false 򷵻trueh *'z k *  'd 'k i ------------------------------------------------------ȽϴС(Сڵڷtrue)----------------------------------------------------------------'value1value2false 򷵻true *X'* X' *  'Dd'Dkpih------------------------------------------------------ȽϴС(Сڵڷtrue)-dec---------------------------------------------------------------'value1value2false 򷵻true *$4'* $4' *  'dP'k@i8}------------------------------------------------------У鳤---------------------------------------------------------------0 ,$'' b$/ΪDZ'k@z8k0 ,-±0ʼֵΪָάõ± b$$4 b$$4'zkd ˵У̶ b$$4'zHk@k8i0}------------------------------------------------------У--------------------------------------------------------------- ,$'' b$/ΪDZ'k8z0k( b$& Ϊz b.e+Сz b$4e% С0zk ,-±0ʼֵΪָάõ± b$$4 b$$4'zkd ˵У̶ b$$4'zkki------------------------------------------------------УֵΧ---------------------------------------------------------------` ,$'' b'zk b$) Ϊz b$4e) С0zhk` b$4$$4 b$4$$4'zki------------------------------------------------------Уֳ(Number,ΪҲΪСС0)--------------------------------------------------------------- ֲɼӷ<^(([1-9][0-9]*)|(([0]\.\d{1,2}|[1-9][0-9]*\.\d{1,2}))|0{1})$'  b$z k ,$'' b$/ΪDZ'kP zH k@ b$% Ϊz b$4e% С0zk$'+󳤶$'.Сλ b.''' "˵ûС b$4' $$4'zkd С b b. $'DԪֵλ b b. $' $$4 $$4'zHk@k8i0-----------------------------------------checkIsInt У鲻С0-------------------------------------------------------------ʽȷfalseʽȷtrue ] ^0|[1-9]\d*$'  b$'d('ki-----------------------------------------checkIsNumber УΪNumber-------------------------------------------------------------ʽȷfalseʽȷtrue ' b$'ki-----------------------------------------checkMoney У0-9999-------------------------------------------------------------ʽȷfalseʽȷtrue]^(([1-9](\d{0,3})|0)|0)$'  b$'d'ki-----------------------------------------checkMoneyTJ У0-9999Сһλ-------------------------------------------------------------ʽȷfalseʽȷtrue(]^([1-9]\d{0,7})$'  b$'d'ki-----------------------------------------checkPersonNum У׶԰һ------------------------------------------------------------ʽȷfalseʽȷtrue]0^(([1-9]\d{0,3}))$'  b$'d'kix-----------------------------------------checkIdNumLink У֤ԱͳûдǷһ------------------------------------------------------------ʽȷfalseʽȷtrueH If colIndex = jhrIDColumn Then checkIdNumLink = True Exit Function End If]%Ա֤ǷӦ]$ں֤ǷӦ]0ڵһγֵ±]H"Ա,Ԫ֮ڵ]`$ݺŽȡ]x!,Ԫ֮ڵ]"ݺŽȡ]#]%·] ]8 $' $'  (ڶλΪΪ F p Z$T,NdڶλΪżΪŮŮ F p Z$T,Nk $' $' $' -  -  F r Z$T,N'i8%^([\u2E80-\uFE4Fo]|[a-zA-Z]){1,20}$'3޸ģУƧEAttribute VB_Name = "У麯" '-%1 ,дϢ ʾ sh`eet$ʱ0! Ϊ1 Function checkRequired(bIndex, row coluDmn ) 'ԪDim cellValu@e As Sng= Work5s8).C s(;If2" Then0K gFalseE{Trund If E-2"ѧ ҪΪ8& !ʽȷuf7'At1wStu(vgDplreh @"^([\u2E80-\uFE4Fo]|[a-zA-Z]){1,20}$" '޸ģԁ9ƸYhC (, j`D&_i si3iQΪ2012-05-09(4)mjBirthday*/@$Trimd.X ##Exit =/AVWa <'`1 ^((19)|(20))\d{2}-(0?[13578] 1[02])&)-9a[12][0c3[0&1 (( 469"11Y 0?2 )))$ ;[1[Oh?]!aW9?PH>]R$](8]'u]Necessar^Ӎ QP;`Lr5P;g;2_; )%:?k=  hW/h4' Y֤0af#e'IgG IsIDNumber(4ByP ǀ, /)Boolea|Con0st W'K7905842163h'ȨCPc10X98765X432C'fS& = Z) oȥո,sInteger, iTBv= b@abyIDCr Ala` '׶9,րΪͨ 7A Flnac 8c Len(<> 18/  Not eric(Mid, 1 7)3 f5Like "*f,X]_ For= 1 To 17CTq~Wt0 1 1spPs + ; i! * TNexts Mod 1pRigh t)c, T3 S}O; "?@1QSFZJLXj`4e0e863|A-Z||()|]18ueSrwqYkVoXlX53- ѧP0ʶ 42λһxckSchCode x@40}[\dx]OgoC_qloooQ--6R " - 'ȷfalse#TLtruHFunction checkFamType(valu e) Di`m reg = "^(\u519c\u6751)|3bf\ u95477ce#e02)$"i;IfGCgu( K, i Then%r nTE  &Fr End If p7 Уѧʱ/ RXDat((1920))\d{2})((0[0-9]12])5a `F `FP`QU!_Year, fDArgsArrDG""_A @ 0 'ΪDZǿ" IiaExit _j{s {II|(23}G, 0xG>$dG|Gz G`Montht*D-?-"9Jaѧŏ8--XJH-Y4}7]BZ 3!7})Q[.C-&$10绰__-ckPhoneNu&m?l\bi(([38h4[5j7Ai55jk8*}00p2[D\dj-[2\d*[3mg)\boNoRq*I Ap'11п2O`Bank=[1c14,20_2Т_^4oo Xn@I瀣2012-@3_pXn_Uxy sc20J2}p r019t9900o_L2Split , "-"4q30R(1) - 0)01= ۊholkp= "" OpR9ע#СR2_#P#200yٷVck 122 1@4h gELe-@">c2!VL ?#Q5  qg`OȽ С()s &B  !omparq![alue2) v1 = `CInt(h x2 x zIf >2 TheǹcompareFalse E .Tru -nd If EFu nctiol'-2Ƚϴ(СڵȀڷt7`)-dec) 'ڂ 2/f~ 6 d Dec,9lC m_У鳤#]heckLDen], fDArgsVArrESplit(, "," cQ@""T ((0) 0 'ΪO݁H eemaiajxit lDp`UBound #Á '±0ʼֵΪάõ qF4) > Mm(`1)) A H(< E3'. '@˵\X̶\s! H!? * FGJRy#% c&b+@ v,Z onj5((Not IsNumerikB)8JΪ>,InStrY".") <> OСoKv 6`CQCr= a0-p?Ps?P?P?PRkr@pX??Pg1?Pd?P|O$$?P?PI?P?P3Ps:_2 > ?PK1PֵΧ}PVal$IL0PP'=A`#JeJJoQ2E KE/# )L?@3@0tB/2Ey_ 5q)Ss/ֱ(fber,2Ҳaa)1P11H['oɼӷ7reg0"^(([1-9][0@*)|0]\.\d{10,2}|F))|0{1})$"T-@C!ǁ(- Exit Function  End If <$fArgsArr = Split( ., ",")fcheckNumXFalse2If value"" TCau! (, l= _C 3s.?.e% ber.Ϊ8*_.0s.#. = 8ly G{+?/Money 0-9E__+_cNk ++((+(\d{0,3})|0!_,k_,*H_,,V,_,g_TJ=#tһλ?TJDD7})??+`j__'0_--Pe0rson <԰һ˿ooo`v O101ck=] Id!Link֤ԱͳûдǷһ?ooo` (, rowIndex, col'pfxjhrIDC`olumnt' F0`!voisGe rRight As Boole0an 'CEaӦ B0irthͣ/+len@2)eg|'qһγ@±[gb ` ingS ,tڵHݟer1J Žȡom bqe?1 Dim birthValue1 As String 'ݺŽȡ year,  hVariant ' ZmonthL,  ^ /dpay,  + arrgender= Mid(IdNum, 17)) F8If 2Mod 2 = 1 Then 'ڶλΪΪ "SheePts(sI]x]).CellsP(row ,9C@olumn)6""'ElseI<ż<Ů<łInd IfF"$G@,bZ@c, 4d 5, 2 Q kI &V$V++ "-"| +C 5checkBLink$True E@DFunction N0{00020820-0000-0000-C000-000000000046} 0%@p%<%Hx@x8 [$*\Rffff*0=5c7c0e47`xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ZCf~#pP#=AEu FdSKY Kn asxdSKY Kn asP#=AEuME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0%@p%>%Hx@x8 [$*\Rffff*0>5c7c0e47`xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ZCfg#Sheet3G__SRP_0"M__SRP_1 Z__SRP_23+pm1M@-т: Fm. O:Rxm. O:Rȫm1M@-т:ME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0%@p%@%Hx@x8 [$*\Rffff*0?5c7c0e47`xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU@@@~~v     SaveAsUICancelrowIndex columnIndexcontent K* rU@@~~~~~~~~ ~~~2~~~ ~~ ~ ~~L"Q|L bF) a A a a a a Aq!a1q A q a A  pq1112A2q222313a333++43A4q444515a5555!6aa Q a VBAProject ThisWorkbookSheet1Sheet2Sheet3ߺУ麯F6C:\Program Files\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLLVBA  aPF  D:\office2013\Office15\EXCEL.EXEExcel Ap0FC:\Windows\System32\stdole2.tlbstdole QL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLLOffice AMSForms.E .`M C:\Windows\system32\FM20.DLL A4/jJ|ۘ /C:\Users\yxq\AppData\Local\Temp\VBE\MSForms.exd ! Q У򲢴ӡϢ checkTheSame Fߝ~4@;}+=yF$+A( zeDFWorkbookWorkbook_BeforeSave x .`/f&Tnx\OX[excel YOX[ pQVBE7.DLLA `  a nx[ , &|~\ۏLhg!h Y NOX[ pQ Sm ?A S (~ Oo` Nxh f , JJ  8PhpxFFsetCellValueXQq&mF&m 0]\Ohpev Ncknx N}ge!jgT QۏLdk!h 1qazdeleteRowNoPro @.PasswordProtectUnprotect CellsClearContentsFcheckTheSameXQNewGetRowOrColIndexcheckDMB deleteRowsetCellValueCountXQ&t  A65530 RangeEndRowcheckedRequiredStartwriteLoggetCellValueCountXQ writeLogRedaddCommentXQStartclearCommentsXQStartbeginCheck_commentcallFunctionXQStart regCheckFunc setDMBCode removeSpaceXQremoveSpecialCharacter IV5F*bQD FsuԲE%XDF Worksheet: FF FAILURE A9:IV65536Font [SONameSize &HorizontalAlignment "NumberFormatLocal 4`nx[_YhgT hgǏ z-N RsQexcel &TRS[penc"N1Ybhg1Y% )nc:yTabColorIndex "l gg~b0Rf[uOo` elۏL!h -NOo`Y N  value -A  A)p(~ : ; ,{ L Rvpency SUCCESS !hǏ! checkBankcheckXn VX[(WyrkW[&{Y^ , ; ' <> " ? zz gLp4I(pg p&g\h8Z8h8hg{gg pgh8Z8h*5O`  8hgxg( xkHg6g7g8g9:g9;g0g<g p=g($k2gz @h8Z8h>8hg p?g9\gV@Ia (gVAIa (g"qnP.gFqmlqnlgv @AIa (g$gxKvgvBIa (g>qmlpqnl@vgjp @E800x0 08glx @ @h8Z8h8hg$ glZgl @h8Z8h8hg~CxODOOEOpOFO`: pggx @ @h8Z8hGH8hg: ggp@ ggF g?p>"gvBIa (g>qmlpqnl"gjp @E800x0 08glx @ @h8Z8h8hg$ glgl @h8Z8h8hg~CxODOOEOpOFO`: pggx @ @h8Z8hGH8hg: ggpZgg"qnPg$gxK gvBIa (g>qmlpqnl gjp @E800x0 08glx @ @h8Z8h8hg$ glgl @h8Z8h8hg~CxODOOEOpOFO`: pggx @ @h8Z8hGH8hg: ggpBgggvBIa (g>qmlpqnlXgjp @E800x0 08glx @ @h8Z8h8hg$ gl|gl @h8Z8h8hg~CxODOOEOpOFO`: pggx @ @h8Z8hGH8hg: ggpXgggxx @ @h8Z8hI8hg g67T76C7lgZCxOJO;OKOp`:pgg: g 004gg@8@gg0gx`Ag g>l0(lbgxl0h8Zp8hLM8hg(g"l0g<ggxH gg2g`!gKZg4@ ggNkp pgggF g^pNOOO( pgg`!gLpPI(pgdh8Z8h238hgNh8Zp8hQ8h#gg pRg&gR "gdh8Z8h238hgVSIpp( pgLpTI(p#ggLpUI(pgdh8Z8h238hgNh8Zp8hQ8hggg\h8Z8h8hg\h8Z8h8hg\h8Z8h8hg{P$xR*`HX@pXx8@p(@0P`P 88hpHi@ aS S__SRP_3i__SRP_4m__SRP_5__SRP_6~0A q  /`   `ihggZ""p ""PxOOpOX@O(OOOOhPO8 O( $xpX(hP8g ?g gggg8pX(hP8x`$h $h XrU@@@xP`p8!CbrU@@@@~xbrU@@@$qbrU@@@~x  a0Aq(Hi__SRP_7__SRP_8 __SRP_9__SRP_aHiHi( HiHiX(Hi0 Hi0Hi0HiHiHi8Hi HiJgg^Zgv(x ZHHg0@&HHi Jgg^Zgv(x ZHHg0@&HHi (Hi Hi  a$h  "a &o "a  *~  &o  .  . $h   "a  0   &o  $h  *~ $h  *~ !*~ $ &o %"a$rU@@@P`AqOO@`PX1` AOOO@`P`1 `Aq!OOOOX ` AqOOOhQ `QAqOOOOOhA`AqOOOOOP`!OO@1 `AOX1 ` qX1 ` !OOOPQ `OO` `A!OOOOPq`OO``A!OOOO`q!`!AOOOOXA#` AOOO@Q%`!ObrU@@@8 !A!q! `!!DrU@@@ xbrU@@@8 0A!0 `!!__SRP_bj__SRP_c__SRP_dj__SRP_eDrU@@@ xbrU@@@81A!A1 `!!DrU@@@xbrU@@@~x__SRP_fj__SRP_10__SRP_11 ThisWorkbook 0<       !"#$%&'()*+,-./123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`bcdefghijklnoqrstuvwyz{}~ a&o "a "a "a  "a   "a  "a "a "a  $h  "a  "a  "a  "a "a  $h !$h $$h %$h ($h )$h ,$h -"a 0"a 1"a 4"a 5"a 8&oVrU@@@X` AqOOO@`!O@1`!O@`!OP1 `Q@ `!O@1 `!O@`!O@1`!OP `!OO@A `!O@ `!O@1 `!O@ `!O@1`!OP`OOPA!`OOP"`OOPA%`!OOP&`!OOPA)`!OOP*`!OO@A-`!O@.`!O@11`!O@2`!O@15`!OX6` AOOOblzV Cf(#pߝ~4@;}+=yF$+A( zex$+A( zeߝ~4@;}+=yMEPSLSS6"  5c7c0e47? Sheet2~0 Sheet30?5c7c0e47A Sheet3gH]wQQpe0<5c7c0e47B]wQQpe(`Xf0;5c7c0e46TXfx!hQpe0@5c7c0e49t!hQpevX;N z^095c7c0dfb;N z^րx`9H`0جVTA:z<v_J̤Gk E%:B?\PZ}K)ke͢P0@f]X{Лق=NGb(^>|K}aAxt|eKzpUN8X!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` Sheet2` Sheet3` ߺ`(checkedRequiredStartR`rowIndex6d` columnIndexP` cellValue@` ActiveSheet%N`Cells`(writeLog{u`contentl`Sheets ` (msgSheetName'` (curMsgRow/`(getCellValueCountXQc` sheetIndex `colIndex` Worksheets`valueK` (writeLogRedm`nLene,` Charactersrg`FontU` ColorIndex`(addCommentXQStartS` errorInfo` AddComment`Interior;`Color2F`CommentHs`Visible`(clearCommentsXQStart7` ClearCommentsf`sheet2RecordNum`ffTotalNumColumn`xlNone`(beginCheck_comment;D` checkMethodHd`(errorMsg'|`(removeSpaceFlag` (cellContent`(callFunctionXQStart `typeVal#`isValidateCount8`titleMsgh` (startTitlel` (headIndex` (functionArgs8M` (checkMethodXQ` (checkRequiredb`(hasErrorf`(isFord` (removeSpaceXQ` (checkStuNamec`(checkLeng`functionArgsArr`Split)`(checkNumh`(checkValK`(checkInt`resZjlx0` (IsIDNumber-*` (checkSFZJLX*`(checkDMB` (setDMBCoded` (checkBankUw` (checkYear6`(checkXn` (checkMonth` (checkBirthday`(checkBirthdayNecessary` (checkPhoneNum` (checkOption,` (hasErrorIdNum`(atLeaOneNNullCount` (checkMoneyi` (totalMoney%`baojiaoMoneyColumns`baojiaoMoneySumk`huoshiMoneyColumn_`huoshiMoneySumr`zhusuMoneyColumn_` zhusuMoneySum>-`othersMoneyColumnߥ`othersMoneySumH`(atLeaOneNullCount` (atLeaError~` (regCheckFuncE`reg`regEX*` CreateObject`Patterni` IgnoreCase0`Test4`(checkTheSameXQNew` sheetIndex2n`(rnaO`Range `xlUp`Row` ClearContents{`i``babyID1` (babyIDColumn`ja`babyID2` (hasTheSame`(GetRowOrColIndexf`keyWordF`kbn1`cZ`Findn`WhatC`LookInP`xlValueso`LookAtO`xlWhole`Columni`value1`flag`Trim@`rowData1`Count0v`rowNummR`(AreasheetIndexH` (deleteRow` Unprotect?`Password`RowsU`Deletex`(setCellValueCountXQ]`(deleteRowNoPro`(setCellValueXQ` codeValue` (columnPlus`length1S`length2T`Replacef`(removeSpecialCharacter` i`(!ValueColumType` columnNamew`(sheetIndexValue1` (AreaSheetName`(readmeSheetName` (totalCount-`(rgold`(TargetF`(hasErrorInValidateU` (dataRowStart` isNullRowNum8`(cna`(notContinueBoolt` (genderColumn~`(birthdayColumn0` У麯&`IDNumber4 `Wm`sj`Tk`Flasep` IsNumeric$*`Right ` (checkSchCode` (checkFamType` (checkRXDate*`(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` ` rowDataNumn` typeValue`bsTypet` valEntity܏`val`typeRow` isNullRowArr/` sheetCountB`Protectf` Application*`ScreenUpdating! `sysDifficultyGradeNameFlag`indentifyDateFlag `xlToLeftWY`Size`HorizontalAlignmentS@`xlLeft9`NumberFormatLocal)`rowType`md`ne` removeSpecialj`Locked ` totalMoneySumZ`pg`qh` (checkTheSameg`myDico`myKey`varData`idNumDick` idNumDicData`cardNum\`Exists]`Addr`Keysq`Resize@4`WorksheetFunction&` Transpose`Workbookk` BeforeSave` _B_var_Chr\;`_Defaultj`!_B_var_sysDifficultyGradeNameFlag_`_B_var_indentifyDateFlagE` Worksheet`_B_var_isNullRowNum;r`_B_var_i `_B_var_isValidateCount"`_B_var_j `_B_var_rowType`_B_var_m `_B_var_n` _B_var_value`_B_var_removeSpecial&>`_B_var_titleMsg`_B_var_totalMoneySumY`_B_var_p`_B_var_q`=?ACU "u $' @ p0(P7q YX HH  ender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=22, 22, 709, 654, C Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C ߺ=88, 88, 1078, 720, Z =198, 198, 885, 830, У麯=220, 220, 907, 852, =248, 207, 935, 839, ThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3ߺ]wQQpeXfУ麯!hQpe;N z^CustomXmlParts_Item(1).%dItem &pPropertiesxSummaryInformation((| Oh+'0HPXh | ReyRen0@"B^@ۖMicrosoft ExcelDocumentSummaryInformation8 ՜.+,D՜.+,t8@H dl sinosoft 0t|ICVKSOProductBuildVer$1B85DD49419C4F04B8F30BF3059AC068_132052-12.1.0.16729