邢唷 F> 1 0 3
羳 \ p g x x c B a = = €p08 X@ " 1 媅SO1 媅SO1 媅SO1 媅SO1 " N媅_ G B 2 3 1 2 1 @ 褳SO1 筫ck\h媅€{SO1 " N媅_ G B 2 3 1 2 1 "
N媅_ G B 2 3 1 2 1 筫ck\h媅€{SO1 媅SO1 媅SO1 媅SO1 6 媅SO1 媅SO1 媅SO1 媅SO1 6 媅SO1 , 6 媅SO1 5 媅SO1 媅SO1 ? 媅SO1
媅SO1 媅SO1 媅SO1 h 6 媅SO1 媅SO1 媅SO1 媅SO1 5 媅SO1 > 媅SO1 "
N媅_ G B 2 3 1 2 + " " # , # # 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 _ ; _ " " * " - " _ ; _ @ _ W ) ) _ * # , # # 0 _ ; _ * \ - # , # # 0 _ ; _ * " - " _ ; _ @ _ y , : _ " " * # , # # 0 . 0 0 _ ; _ " " * \ - # , # # 0 . 0 0 _ ; _ " " * " - " ? ? _ ; _ @ _ g + 1 _ * # , # # 0 . 0 0 _ ; _ * \ - # , # # 0 . 0 0 _ ; _ * " - " ? ? _ ; _ @ _ / \ $ # , # # 0 _ ) ; \ ( \ $ # , # # 0 \ ) 9 \ $ # , # # 0 _ ) ; [ R e d ] \ ( \ $ # , # # 0 \ ) ; \ $ # , # # 0 . 0 0 _ ) ; \ ( \ $ # , # # 0 . 0 0 \ ) E \ $ # , # # 0 . 0 0 _ ) ; [ R e d ] \ ( \ $ # , # # 0 . 0 0 \ )
* 攆f 7 - @ @ @ @
)
6 @ @ a@ 0
9 +
+ `@ @
*
/ *
+ 0 / , 5 / , 7
/
3
@
P
8 8@ @ 8@ @ 8@ @ 8@ @ 8@ @
8 8@ @
8@ @ 8@ @
| | \ 欬}A } 23
}A } ef
} } ???
??? ??? ??? 蝌
??? } } ???
??? ??? ??? ゥ
}A } 俏
}A }
}- }
}A }
}A } 蘈
}A } 蘈
}- }
}A }
}A } ?
}U }
}A } ef
}A } 蘈
}A } !
}- } #
}- } $
€ € }A } % 蘈
}A } & €
鷠 }- } '
}A } ( ef
}- } *
}A } + 蘈
}} } , 膊
膊 膊 膊 }A } - 23
}A } . 骑
a }A } / ef
}A } 0 霚
渆 } } 1
蝌
鷠 }A } 2
}A } 3 23
}A } 4 23
}A } 5
}A } 6 23
}A } 8 23
}A } :
}A } ; ef
} } <
虣
??v }A } = 蘈
}A } >
}A } ? ef
}( } @ }( } A }( } E
}( } F
}( } H
}( } K
}( } L
}( } M
}( } N
}- } P
}( } T
}( } U
}( } V
}( } W
}( } X
}( } Z
}( } [
€ 8^膲 ! 6 0 % - :_寚eW[湗r 6 2 4 6 0 % - :_寚eW[湗r 6 ! 2 0 % - :_寚eW[湗r 6 2 2 2 0 % - :_寚eW[湗r 6 搹鶴 搹鶴 纇錱USCQ :_寚eW[湗r 4 & ) :_寚eW[湗r 4 ! ? 2 0 % - :_寚eW[湗r 4 2 * 2 0 % - :_寚eW[湗r 4 c c 哣 X T a b l e S t y l e M e d i u m 2 P i v o t S t y l e L i g h t 1 6 ` " &6
1 . 篘錧zf齹罷╟P僄l;`h垍 " =
2 . 俉魐啒遅!j媁╟P僄l;`h垍 0 麯 3 . 篘錧zf齹+ 6R xQ媁Hh婳╟P僄l;`h垍 覮 陙籰:Szf齹6R :Wofc_ V V 4 @ 8 !
C A @ 6R N;
!
; D x D桍N2 X X ^ 篘錧zf齹+ 6R 罷╟P僄l;`h ╟P僓SMOpe蠎 廭鱏 3uUSMO
T饄 b藌鰁魰 USMO@b(W0W c N蒪軆US 恲 鑜孮/ 濺lQ0W@W USMO€{薔 篘錧zf齹罷
T饄
擽(uLN c N蒪軆US 恲
罷{|+R c N蒪軆US 恲 罷€{薔 蟸Nm孴>yOHe蕍 鍂茓Cg孴D(峜儔 T€鹼篘 T€鹼5u輯 kXUSMO kX篘 T€鹼5u輯 * 梟x@b衏匭筟颯(u嶯lQ _裇^蔛 O0 X X ^ 篘錧zf齹+ 6R 俉魐啒遅!j媁╟P僄l;`h 俉魐啒遅!j媁
T饄
!j媁{|媁 c N蒪軆US 恲 鶺@x!j媁eg恘 c N蒪軆US 恲 !j媁
g筫_ c N蒪軆US 恲 !j媁€{薔 X X ^ 篘錧zf齹+ 6R xQ媁Hh婳╟P僄l;`h xQ媁Hh婳
T饄 y橆v@b(W0W c N蒪軆US 恲
擽(u筫T c N蒪軆US 恲 xQ媁Hh婳薔蛜 擽(u筫T USMO@b(W0W 罷{|+R 6R N !j媁{|媁 鶺@x!j媁eg恘 !j媁
g筫_ 錧係緥 WS乕^ 篘錧zf齹瘋Gr 謡 韹 !j媁 _恘 A P P 罷x裇 骻轢^ O ahV 輸 茐蓧!j媁 FUN Qu 錧z偩嫛 Bh梘^ :O
ghV :g癶艌Y Y!j`!j媁 陙x A P I 鉙 R對^ 轢^ zf齹QT€}lf 翑 vQ諲 u\ON Swm^ zf齹袕}忓]wQ gr傃慯\ 覰≒M 2栁W/n^ zf齹:ghV篘 }lf (嵪憽{ 轢^ zf齹禰E\ 體SS錧 緥Yt 5/n^ zfga;S梪 邩罷燫錧 塠hQ 塻梘^ zf齹颯z4b緥Y 貧飠~r偠[E\ 齹恘t ~vr^ Z嗊b皊瀃/ 瀀:_皊瀃緥Y {忓]簙莮 痵軴 :嵽]^ 愥O葉飠緥Y6R 癳 N鉔酧o`€b/g % 暋{t 砽`l^ 梴:gte:g6R 癳齹恘}lf .UT
g eg綶^ 梴:g茐蓧o忲N 癳齹恘蔛≒齹 汷擽t ]鎉^ zf齹韹髼Yto忲N uir;So !j_R癳 陙6q韹 t銐o忲N 癳Pg檈 Q軂9e uiryr乢茓+Ro忲N 篘錧zf齹 s^餝擽(u Z嗊b皊瀃/ 瀀:_皊瀃o忲N CQ嘯橻 塠hQ軴湒 ub_篘錧zf齹o忲N u}T褃f[ vQ諲鲖鑜fwQSO{|+R 駇wmzz)Y vQ諲鲖鑜fwQSOLN
x .
羳 % f;
d 褚MbP?_ * + € % J & ffffff?' ffffff?( ?) ? " d XX333333?333333? & U } U R }
S } S } S } S } @S } jS } S }
@S } *S 0 P 6 O C C C C C €C €Q
T
U $ U U U U U U U U U U U U U [ [ V V V V V Z Z Z Z Z Z
Z Z Z Z V
H
H
H
H
H
H
H
H
H
H
H
H
H
H ~
W ? M M M M X M M M M M M X X
~
W @ X X X X X X M X X X X X X
~
W @ X X X X X X M X X X X X X
~
W @ X X X X X X M X X X X X X
~
W @ X X X X X X M X X X X X X
Y
C
C
C
K r 6 R 2 2 2 2 2 4 饻 t 饎 (
t 餖
t
3 ] F ! d H > @ < Q d *
1 ; 8
" 1 ;
1 ; g g D
羳 % SC
d 褚MbP?_ * + € % J & ?' ?( ?) ? " d ? ? & U } U R }
S } S } S }
S }
@S }
jS } S } @S } *S 0 P 6 O C C C C C €C €Q
T
U ( U U U U U U U U U U U U U U U [ [ V V V V V Z Z Z Z Z Z Z Z
Z Z Z Z V
H
H
H
H
H
H
H
H
H
H
H
H
H
H
H
H ~
W ? $ M M M M X M M M M M M M M X X ~
W @ $ X X X X X X M M M M X X X X X ~
W @ $ X X X X X X M M M M X X X X X ~
W @ $ X X X X X X M M M M X X X X X ~
W @ $ X X X X X X M M M M X X X X X Y
C
C
C
K : V 6 6 6 6 6 4 > @ d *
1 ; 1 ;
1 ;
1 ; 1 ; g g D
羳 % eJ
d 褚MbP?_ * + € % & ?' ?( ?) ? " + XX ? ? & U } C } C } C }
*C } C }
C } D } C } D ;`昩DNCQ 0 @ 0 B @ @ @ @ @
E
F F F F F F F F F F F F F F
F F F F F F F F F F F
L L L N C
G
G
H
H
H
H
G
G
H
G
G
G
G
G O ~
I ? J J J J J J J M J J J J J
~
I @ J J J J J J J M J J J J J
~
I @ J J J J J J J M J J J J J
~
I @ J J J J J J J M J J J J J
~
I @ J J J J J J J M J J J J J
C
C
C
K D D D D D D D D D D D D D
D 2 H 2 2 2 2 2 * 饻 l 饎 (
P 餖
l
3
] F ! d H > @ d X d
9 ; 1 ;
9 ; 1 ; g g D
羳 % 裈
d 褚MbP?_ * + € % J & ?' ?( ?) ? " d 禶 禶? 禶 禶? & U }
} } 9 } J J J J J J J J J J
J J J
J J J J J J J J
@
@ !
@ "
A #
@ $
@ %
@ &
'
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
?
@
@
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
[
\
]
^
_
`
a
b
c
d
e
f
g
h
i
@
j
k
l
m
n
o
p
q
r
s
t
u
v
w . b b b b T 8 8 8 8 8 8 8 8 8 8 8 * * * > @ d g g D
贇衆 罙 . 罙 . . 罙 罙 .
闄勪欢2锛2025骞寸涓夋壒骞胯タ鈥滀汉宸ユ櫤鑳+鍒堕€犫€濅骇鍝佸拰鍏稿瀷搴旂敤鍦烘櫙妗堜緥鎺ㄨ崘姹囨€昏〃.xls
1
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then 'H5
If Target.Value = "鍏朵粬锛堣娉ㄦ槑鍏蜂綋琛屼笟锛" Then
With Target.Validation
.Delete
.Add Type:=xlValidateInputOnly
End With
Else
With Target.Validation
.Delete
.Add Type:=xlValidateList, Formula1:=",閫夐」2,鍏朵粬"
End With
End If
End If
End Sub
鄥燆鵒h珣 +'迟0 H P ` t
€ € m y g g x x c @ 勢 誑@ € & W P S O f f i c e 胀諟.摋 +,D 胀諟.摋 +, H ( 0 8 €@ 0 t | € K S O P r o d u c t B u i l d V e r I C V 2 0 5 2 - 1 1 . 8 . 2 . 1 0 3 3 7 $ 0 8 7 4 0 E 9 9 9 4 A 8 4 7 E F 9 F 3 1 A 9 9 E 9 9 3 5 5 8 1 3 _ 1 3
! " # $ % & R o o t E n t r y F + W o r k b o o k QU E T E x t D a t a B J D E D a t a v S u m m a r y I n f o r m a t i o n ( 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
! " # $ % & ' ( ) * , - . / 2