$B%(%/%;%k(B $B%j%9%H(B05
$B%(%/%;%k$NM}2r%7%j!<%:(B
$B#5!%%G!<%?$NF~NO5,B'$N%j%9%H$G!V85$NCM!W$K;HMQ$9$k4X?t$rM}2r$9$k(B
$B#5!]#7!%!H%o%s%;%C%H4X?t!I$N(BVLOOKUP$B4X?t$H$NJ#9g!J%M%9%H!K(B
$B#O#F#F#S#E#T4X?t$H#C#O#U#N#T#A4X?t$r%M%9%H$7$?(B
$B#O#F#F#S#E#T!J%;%kHVCO!$#0!$#0!$#C#O#U#N#T#A!J%;%kHO0O!K!]#1!$#1!K(B
$B$r(B$B!H%o%s%;%C%HHO0O;2>H4X?t!I(B$B$HL?L>$7$^$7$?!#(B
$B$=$7$F(B
$B!H(B$B%o%s%;%C%H4X?t(B$B!I$O4X?t$J$N$G$9$,!"(B
$B!H(B$B%;%k$^$?$O%;%kHO0O(B$B!I!a;2>H(B$BHO0O$r(B$BI=$9$b$N$@$H8@$$$^$7$?!#(B
$B$H8@$&$3$H$O!"(B$BB>$N4X?t$N0z?t(B$B$K!V(B$BHO0O(B$B!W$H$$$&(B$B0z?t(B$B$,$"$l$P!"(B
$B$=$3$K$O!"!H(B$B%o%s%;%C%H4X?t(B$B!I$r;H$C$F$bNI$$$H$$$&$3$H$G$9!#(B
$B!T(B$B$3$3$,%]%$%s%H(B$B!U(B
$B:FEY!"8!:w4X?t$r8+$F$_$^$7$g$&!#(B
$BFCDj$N%;%kHO0O$G%G!<%?$r8!:w$9$kJ}K!(B
$B6LG,$NG/Np$r8!:w$9$kJ}K!(B
|
|
A |
B |
C |
D |
E |
|
1 |
$BL>A0(B |
$BIt=p(B |
$BG/Np(B |
|
$B8!:w$9$kCM(B |
|
2 |
$B;30*(B |
$B1D6H(B |
28 |
|
$B6LG,(B |
|
3 |
$B@8U*(B |
$BAmL3(B |
19 |
|
|
|
4 |
$B6LG,(B |
$B7PM}(B |
22 |
|
|
|
5 |
$B>.>>:Z(B |
$B3+H/(B |
29 |
|
|
|
|
$B4X?t$N9=J8!J=q<0!K(B |
|
$B=D(B |
=VLOOKUP(E2,A2:C5,3,FALSE) |
$B>e$NI=$r>/$7!":n$jJQ$($F$_$^$9!#(B
$BM}M3$O!"8!:w$9$k%j%9%H$N$9$02#$K%G!<%?$,$"$k$H8mF0:n$N85$K$J$k(B
$B$H$$$&$3$H$J$N$G!#(B
|
1. |
|
$B:8?^$N$h$&$JI=$r:n$j$^$9!#(B |
|
|
$B:8B&$N%j%9%H$+$i!"1&B&$N8!:wMs$N!VL>A0!W$K!H6LG,!I$HF~NO$9$k$H!"(B |
|
|
|
|
|
|
2. |
$B#F#3%;%k$K!"!H6LG,!I$NIt=p$rI=<($5$;$?$$$N$G!"(B |
|
|
|
|
|
|
|
|
$B:G8e$N3g8LJD$8$k!H!K!I$rF~NO$7!"(B |
|
3. |
|
$B#F#3%;%k$K$O#B#4%;%k$NCM!"It=pMs$N(B |
|
|
|
|
|
4. |
$B |
|
|
|
|
|
|
|
|
$B:G8e$N3g8LJD$8$k!H!K!I$rF~NO$7!"(B |
|
5. |
|
$B#F#4%;%k$K$O#C#4%;%k$NCM!"G/NpMs$N(B |
|
|
$B$3$l$G!":8B&$N%j%9%H$+$i!"1&B&$N8!:wMs$N!VL>A0!W$KC/$NL>A0$rF~NO$7$F$b!"=V;~$K$=$N?M$N!VIt=p!W$H!VG/Np!W$,I=<($5$l$^$9!#(B |
|
|
|
|
|
|
6. |
=VLOOKUP($B8!:wCM(B,$BHO0O(B,$BNsHV9f(B,$B8!:w$N7?(B) |
|
|
|
$B#F#3%;%k$K(B |
|
|
|
|
|
|
|
|
$B:G8e$N3g8LJD$8$k!H!K!I$rF~NO$7!"(B |
|
7. |
|
$B>e$HF1$8$h$&$K!"(B |
|
|
$B#F#4%;%k$N?t<0$N!V#A#2!'#C#5!W$r(B |
|
|
|
|
|
|
8. |
|
|
|
|
$B#A#6%;%k$K!"!V?M;2!W!"(B |
|
|
$B"((B |
$B#V#L#O#O#K#U#P4X?t$N0z?t$N!VHO0O!W$r!"(B$B!H(B$B%o%s%;%C%H4X?t(B$B!I(B$B$K(B |
||
|
|
|
||
|
|
|||
|
|
|||
|
|
|
|
|