邢唷 > 3 2
! " # $ % & ' ( ) * + , - . / 0 1 > 5 6 7 8 9 : ; < = ? A @ R o o t E n t r y F 囿4 W o r k b o o k 揰 _ V B A _ P R O J E C T _ C U R "
0塺囿 V B A 0塺
衫 \ p * B a = ThisWorkbook = ;98 X@ " 1 vA r i a l 1 vA r i a l 1 vA r i a l 1 vA r i a l 1 vA r i a l 1 唙媅SO1 唙媅SO1 , 唙媅SO1 vT a h o m a 1 唙媅SO1 . vT i m e s N e w R o m a n 1 . vT i m e s N e w R o m a n 1 , 唙媅SO1 唙媅SO1 ! 唙媅SO1 . ! vT i m e s N e w R o m a n 1 . vT i m e s N e w R o m a n 1 唙媅SO1 vA r i a l 1 唙媅SO1 唙媅SO + " " # , # # 0 ; " " \ - # , # # 0 5 " " # , # # 0 ; [ R e d ] " " \ - # , # # 0 7 " " # , # # 0 . 0 0 ; " " \ - # , # # 0 . 0 0 A " " # , # # 0 . 0 0 ; [ R e d ] " " \ - # , # # 0 . 0 0 i * 2 _ " " * # , # # 0 _ ; _ " " * \ - # , # # 0 _ ; _ " " * " - " _ ; _ @ _ . ) ) _ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ y , : _ " " * # , # # 0 . 0 0 _ ; _ " " * \ - # , # # 0 . 0 0 _ ; _ " " * " - " ? ? _ ; _ @ _ 6 + 1 _ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\) \$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\) % \$#,##0.00_);[Red]\(\$#,##0.00\) + " " # , # # 0 ; \ - " " # , # # 0 5 " " # , # # 0 ; [ R e d ] \ - " " # , # # 0 7 " " # , # # 0 . 0 0 ; \ - " " # , # # 0 . 0 0 A " " # , # # 0 . 0 0 ; [ R e d ] \ - " " # , # # 0 . 0 0 e 0 _ - " " * # , # # 0 _ - ; \ - " " * # , # # 0 _ - ; _ - " " * " - " _ - ; _ - @ _ - , ' _-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_- u 8 _ - " " * # , # # 0 . 0 0 _ - ; \ - " " * # , # # 0 . 0 0 _ - ; _ - " " * " - " ? ? _ - ; _ - @ _ - 4 / _-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- "$"#,##0_);\("$"#,##0\) ! "$"#,##0_);[Red]\("$"#,##0\) " "$"#,##0.00_);\("$"#,##0.00\) ' " "$"#,##0.00_);[Red]\("$"#,##0.00\) 7 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 = 8 _ "$"\ * #,##0_ ;_ "$"\ * \-#,##0_ ;_ "$"\ * "-"_ ;_ @_ E @ _ "$"\ * #,##0.00_ ;_ "$"\ * \-#,##0.00_ ;_ "$"\ * "-"??_ ;_ @_ #,##0.0_);\(#,##0.0\) C > _ "$"\ * #,##0.0_ ;_ "$"\ * \-#,##0.0_ ;_ "$"\ * "-"??_ ;_ @_ ? : _ "$"\ * #,##0_ ;_ "$"\ * \-#,##0_ ;_ "$"\ * "-"??_ ;_ @_ 4 / _ * #,##0.0_ ;_ * \-#,##0.0_ ;_ * "-"??_ ;_ @_ 0 + _ * #,##0_ ;_ * \-#,##0_ ;_ * "-"??_ ;_ @_ , * + ) "
1 @ @
1 @ @
"
"
@ @
@
@
1 `
@ @
1 @ 1 @
a
1 1
@ @
@ @
@
@
@
1 @
a @ a
a a
a a
a @
a
a
a " a @ a a
1 @
1 @
@ @
1 @
1 @ @
@ @
@ @
@
1 @ @
1 @
1 @ @
1
1
a @ a
1 @
@
1 " a @
1 @
1 @ a @ @ a @
@ @
@
@ 1 @ @ 1 @
1 @ @
1 @
1 @
1 @ @
1 @
1 @ @
@ @
@
@
a @
a
a
a
a 1 a @ @ 1 a @ 1 a @
@
@ 1 @ @
1 @
1 @ 8@ @ 8 @ 8 @ 1 @
1 @
1 @ @
1 @
@
@
1 @ @
1 @
1 @ 1 @ @ 1 @ 1 @
1 @ 1 @
1 @
1 !@ 1 @ @
1 @ 1 @ @ 1 @
@ 1
1 1 1 1 @ 1 @ 1 @ @
1 @ @
1 !@ @ 1 @ 1 @
"
@ @
1 @ @
1 @ 1 @ @
1 @
@ @
@ ! " * #
1 "
1 @
@ @
@
@
@ " @
1 @ @
1 @ @
@
1 @ @ 1 @
a % Normal_WCS Overdue report format € € € € € €
7h_ 1 ` "7 (W!h u3u鲖 V V ; 3 " b 餤 3 A @ @
k m 鹹≧5u輯 qQ T P>k篘酧o` 1\f[酧o` 3u鲖7>k臽礠 f[ u~{W[ Dkf[ u0qQ T P>k篘臽礠^\瀃 Ta╟P0 7 F 燫講lQ鄗 7 魦f * P>kf[ u覻
T * '`+R * 鶴 ut^g * 7bM|@b(W0W * 皊鎷苸OO@W * 禰璣5u輯 * qQ T P>k篘覻
T * 禰璣鎷苸0W@W * 錧\OUSMO * L€ * 貧!h
T饄 * NN * f[!h{|+R1 * f[!h{|+R2 * 3u7崯S郪 * 3u鲖f[t^ * w/ 陙籰:S/ 魐枏^ 7 * :S/ 縎 7 * 3u鲖{|媁 7 * ^/ 陙籰轢 7 * 珟齆翄鱏x 7 t^ 7 g 7 * 7bM|@b(W0W 7
w/ 陙籰:S/ 魐枏^ 7 ^/ 陙籰轢 7 :S/ 縎 7 w/ 陙籰:S/ 魐枏^ 7 :S/ 縎 7 * 異?ex 7 * 翄鯪{|媁 7 %E\l珟齆翄 %決篘珟齆翄 %fkf嫬廄N翄 7 * t^ 7 * f[6Rt^ 7 * @b^\w齆 7 %-N.Y钀^\貧!h %w^\b!h %0W^b!h 7 鎷苸烻郪 7
* 3u鲖7>k褢潣CQ 7 * 3u鲖 gPt^ 7 髞 7 f[t^ 7 錯 7 P>k篘~{W[ 7 P>k篘~{W[nx 7 F 燫講lQ鄗 7 * 翄鯪鱏x 7 * 縖
5u輯 7 異?ex 7 貧!h亯Bl0R錯 g 7 錱a翂 7 , P>kf[ u&{T u恘0W酧(u㏑f[7>k3u鲖ag鯪 蟸D崺R-N胈畫 TavQ3u鲖7>k0 7 (W!h u3u鲖 7 f 蟸濺篘~{W[ 7
錱钀钑縎^0:S D崺R-N胈
7 誯N-Nf[ 7 錯 7 ,g篘軴翄
N饛臽礠^\瀃0 7 蟸濺篘~{W[ 7
~{W[錯 g 7 鹹≧5u輯 7 t^ 7 %nf愗!h %貧I{L€Nf[!h 7 . %郪舥魜餠 %郪~p魜餠
%砇≧汻\ 鄀3z歔6eeQ %vQ僛 7 ~{W[錯 g 7 P>k篘酧o` 7 ^/ 陙籰轢 7 * N P>k篘sQ鹼 7 , %7 t^ %8 t^ %9 t^ %1 0 t^ %1 1 t^ %1 2 t^ %1 3 t^ %1 4 t^ 7 € 1 . h g * 剉pency:N臺kXy0 7 A 2 . ,gh/f&{Tag鯪剉禰璣蟸Nm餠緰剉nf愗!h癳 u eQf[MR(W7bM|@b(W0WT齎禰 _裇鰯L3u鲖㏑f[7>k剉3u鲖h03u鲖f[ u{槀Y瀃kX橯T{|酧o`0 7 v 3 . P>kf[ u7bM|@b(W0W擽ND崺R-N胈@b(W0W N魜 P>k篘臺{/f騗珗齎禰Ye瞼;N钀钑歔剉nf愗!hb貧I{L€Nf[!hck_U_諷 v^諷梍 w瀃0T誰0 gHe剉U_諷愬wfN剉f[ u P>kf[ u禰璣nx瀃:N蟸Nm餠緰禰璣 P>kf[ u 椱嫗[圼酧0u惇~圼誰0鄀輳誰輳獈皨U_0 7 x 4 . qQ T P>k篘;N亯/fc P>kf[ u6r蚹0vQ諲褟睳^\b€vQ諲陙?aN P>kf[ uqQ Tb舃貜>k#嶜N剉wQY孾hQl婲L:N齹汻剉陙6q篘0俌 P>k篘:Nd[?Q 擽蜰T$N{|-N 愰bqQ T P>k篘
N齹衏汷qQ T P>k篘剉 蟸S_0W>m鶴@b鶴wQ翄fTfNb楓:ywYe瞼钀钑 Ta_N颯3u鲖7>k0 7 5 . N P>k篘sQ鹼擽 愰b6r/ 蚹/ 褟睳^\/ vQ諲0 7 6 . f[!h{|+R9hncU_諷b!h剉'`(R+R(W{|+R1 0{|+R2 -NT 愰b Ny0 7 ) 7 . 3u鲖7>k褢潣:N1 0 0 0 0R6 0 0 0 KN魰剉1 0 0 剉tepe
P, S+T1 0 0 0 孴6 0 0 0 0 7 g 8 . P>kf[ u擽9hnc(W!ht^P 愰b3u鲖7>k剉 gP03u鲖7>k gP杽v
NP= f[6R- t^+ 1 + 1 0 v^ g
N厤菑1 4 t^0俌 f[6R踁t^剉'Yf[孨t^(W!h u3u鲖,{ Nf[t^㏑f[7>k cgqMR饛膲R vQ3u鲖剉7>k gP杽v
NP:N1 2 t^0 7 # 9 . 貧!h膲歔0R錯 g/fc P>kf[ uU_諷b!h
0U_諷愬wfN 0膲歔剉0R錯 g0 7 ' 1 0 . Qg訷OE\訷O 0aNGW圫 l?e钀钑錱a翂 {樝~濺篘~{W[v^燫講lQ鄗0 7 * 1 1 . ,gh N_$N齆 蟸濺D崺R-N胈X[ N齆 _裇鰯L圶[ N齆 1u蟸濺D崺R-N胈邁 N裇>et0 7 u恘0W酧(u㏑f[7>k3u鲖h( (u嶯(W!h u) 7
Dkf[ u0qQ T P>k篘臽礠^\瀃 Ta╟P0 7 F 燫講lQ鄗 7 f 蟸濺篘~{W[ 7 蟸濺篘~{W[ 7
~{W[錯 g 7 t^ 7 g 7 錯 7
Dk篘~{
T 7 ~{W[錯 g 7 t^ 7 g 7 錯 7 塠絖w齎禰 _裇鰯L 7 r , p P F! & @" Z# : $ D& $ x( X &* ,
1 3 5 c c
衫 6 9 扠 闟
d 褚MbP?_ * + € % & 殭櫃櫃?' {瓽醶?( ffffff?) 333333?M n M i c r o s o f t O f f i c e D o c u m e n t I m a g / d X X L e t t e r widm " F XX 呺Q肝?q=
祝p? U } m } } } } }
}
} $ }
} I } } I } } } 6 € +
+
X X X X X J , ; h ; : J : Y :
l 4
X 4 6
R W
Q
A
@ @
< 6
I
V
! U
!
" w
%
& ! E
€ " €
# $ w
%
& $
J '
& %
b
& ( w
% ? & d g g g g g g g g g g g g g g h
8 ( x
%
% a b b b b c
7
a b b b b b b b (
l
%
'
k (
\ \ \ \ ]
6
z z
a K
F F N w
%
& ! E
€ " €
# $ w
%
* $
" +
* %
& (
w
%
d g g g g g g g h
b
b c d z z z z z z z { ( x
%
D
F F F F F F F F N (
l
%
d e
% f g g g h
J ) K L L
a * c I H
i + i f g j , x
-
k F \ \ \ \ \ \ ]
M
f ,
g g g g g g g g g g j .
l
%
k G \ \ \ \ \ \ ]
P - y z z z z z z z z z z { ( w
% . d e
P /
| L
} } } } } } } } } } ~ ( x
/
2 0
€ €
1 1 K L L
G 9
2 3
2 3
0 @ 4
l 3
t 4 0 u u u u u u u u u u u u u u u u u u u u v m
o A 0 p p p p p p p p p p p p p p p p p p p p q m 5 6 6 7 6 8 8 6 6
7 6 6 6
H 6 r r
7 i 7
7 j 7
) k 5 6 6 7 6 8 8
g
h 6
7 i 9
7 j 9
) k
l
^ Y 0 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ X m
B Z 0 C C C C C C C C C C C C C C C C C C C C D m
o [ 0 p p p p p p p p p p p p p p p p p p p p q m
o \ 0 p p p p p p p p p p p p p p p p p p p p q m
; ] 7 7 7 7 7 7 7 7
7 ^ 7 7 7
7 _ : r r
7 ` 7
7 a 7
) b m
^ c 0 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ X m
B : 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 ) m
o 0 p p p p p p p p p p p p p p p p p p p p q D lF F : : d z d d | t p P L P L L L L T Y : ! h : " # $ % & ' ( ) * + g , g - . / 0 g 1 2 3 4 5 €> m
o 0 p p p p p p p p p p p p p p p p p p p p q ! m
! ; d ! 7 7 7 7 7 7 7 7
! 7 e ! 7 7 7
! 7 f
! r r
! 7 ` ! 7
! 7 a ! 7
! ) b " m
" ^ > 2 " _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ X ( # m
# B : 2 # C C C C C C C C C C C C C C C C C C C C D ( $ m
$ o ; 2 $ p p p p p p p p p p p p p p p p p p p p q ( % m
% o 5 2 % p p p p p p p p p p p p p p p p p p p p q ( & n
& S = & < < < < < < < <
& < B & < < <
& < C & T s s
& < E & <
& < & <
& = 2 & ( 6 ' O 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 # # 7 # 7 # ? (
( [ 4 ( [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ ,
) Y M 4 ) Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y ,
* Y N 4 * Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y ,
+ Y O 4 + Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y $
, Y P 4 , Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y $
- ` Q 2 - ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `
. ` R 2 . ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `
/ ` S 2 / ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `
0 Z T 2 0 Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z
1 ` U 2 1 ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `
2 ` V 2 2 ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `
3 ` W 2 3 ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` 0 L N N N N : F F F F F D D D D D D D 痿 疖 (
館 B
c $ D @ ] ` t f 館 B
c $ D @ v Q ] ` P f 館 B
c $ D @
' ] ` r 餵 B
0 € D @ ? ] ` h f 館 B
c $ D @ b ] `
f 館 B
c $ D @ ( ] `
f 館 B
c $ D @
' ] ` f 館 B
c $ D @ @ ] ` f 館 B
c $ D @ b y ]
` 4 f 館 B
c $ D @
] ` r 餵 B
0 € D @ ? P ] ` L
f 館 B
c $ D @ ] `
f 館 B
c $ D @ G ] ` t f 館 B
c $ D @
8 ] ` > @ d
:g
$ $ % % & & ( ( ) ) * * & ! ! 2 2 + + , , - - . . 0 0 1 1 3 3
" " / / 7 Sheet4g g
T h i s W o r k b o o k S h e e t 4 _ V B A _ P R O J E C T d i r E
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D F G H I J K L O P Q R S T V W X Z [ \ ] _ 奥 # x ME ( SL S S < N 0 { 0 0 0 2 0 8 1 9 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } 8 € ( % H x 鞍 Attribut e VB_Nam e = "Thi sWorkbook"
孊as0{00020P819- 0C $0046}
|GlobalSpac扚alse dCreatabl Pred恊cla Id Tru
BExpose Templ ateDeriv払ustomizD2 奥鵇 # x ME ( SL S S < N 0 { 0 0 0 2 0 8 2 0 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } 8 € ( % H x ò Attribut e VB_Nam e = "She@et4"
鐱ast0{00020820- C $0046}
|Global!腟pac扚alse dCreatabl Pre decla Id 玊ru
BExpose Temp lateDeriv$払ustom izD2 蘟y * \ G { 0 0 0 2 0 4 E F - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 4 . 0 # 9 # C : \ P R O G R A ~ 1 \ C O M M O N ~ 1 \ M I C R O S ~ 1 \ V B A \ V B A 6 \ V B E 6 . D L L # V i s u a l B a s i c F o r A p p l i c a t i o n s * \ G { 0 0 0 2 0 8 1 3 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 1 . 5 # 0 # C : \ P r o g r a m F i l e s \ M i c r o s o f t O f f i c e \ O F F I C E 1 1 \ E X C E L . E X E # M i c r o s o f t E x c e l 1 1 . 0 O b j e c t L i b r a r y * \ G { 0 0 0 2 0 4 3 0 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 2 . 0 # 0 # C : \ W I N D O W S \ s y s t e m 3 2 \ s t d o l e 2 . t l b # O L E A u t o m a t i o n (* \ G { 2 D F 8 D 0 4 C - 5 B F A - 1 0 1 B - B D E 5 - 0 0 A A 0 0 4 4 D E 5 2 } # 2 . 3 # 0 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ O F F I C E 1 1 \ M S O . D L L # M i c r o s o f t O f f i c e 1 1 . 0 O b j e c t L i b r a r y
sI 奥 T h i s W o r k b o o k 0 1 4 c 0 5 2 9 f 9 T h i s W o r k b o o k % S h e e t 4 0 2 4 c 0 5 2 9 f 9 S h e e t 4 鵇 % 8 M洋0嗜"H#券UK F籂崍&.F壎費趎 H €
% Excel€+` VBA麾` Win16羱` Win32` Mac巢` VBA6#`
VBAProject究` stdole揱` Officeu` ThisWorkbook|鉦 € _evalsuate賎 Sheet4` Workbookk` T
$ € 0* pH d
VBAProje坈t 4 @j
=
r sI J<
r€stdole> s t d o €l e
h %^ *\G{00€020430- C
004 6}#2.0#0 #C:\WIND OWS\syst em32\e2. tlb#OLE Automati on ` 僂OffDic凟O f€ i c侲瀫攢丒 2DF8D04C -5BFA-10€1B-BDE5€E訟A€C4€2圗€ gram Fil es\CommonMicros oft Shar ed\OFFIC E11\MSO.0DLL#僊 1@1.0 Ob伭 €Library KE 傇 偍ThisW orkbookG €T€玦 s W€硆 k bUo 2 Q HB1Bx% B,!"B+BB|€Sheet4G
S@#e@Xt 4 H2N鵇B ThisWorkbook T h i s W o r k b o o k Sheet4 S h e e t 4 ID="{E8D5AFA5-A797-41CA-8AC2-0D6FF124F337}"
Document=ThisWorkbook/&H00000000
Document=Sheet4/&H00000000
Name="VBAProject"
HeP R O J E C T w m M > P R O J E C T N S u m m a r y I n f o r m a t i o n ( U D o c u m e n t S u m m a r y I n f o r m a t i o n 8 Y @ lpContextID="0"
VersionCompatible32="393222000"
CMG="EBE9E51CD420D420D420D420"
DPB="D6D4D809281F1220122012"
GC="C1C3CFD0D0D0D02F"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000
[Workspace]
ThisWorkbook=0, 0, 0, 0, C
Sheet3=0, 0, 0, 0, C
Sheet4=0, 0, 0, 0, C
鄥燆鵒h珣 +'迟0 H P ` l
scoly * Microsoft Excel @ €+鹂@ €4u
迦@ # 胀諟.摋 +,0 P X |
Deloitte Touche Tohmatsu 在校生申请 在校生申请!Print_Area 工作表 命名范围
F Microsoft Office Excel 工作表 Biff8 Excel.Sheet.8 9瞦 C o m p O b j ^ j