5-1. $BEE;R%a!<%k$N3hMQ(B
$BEE;R%a!<%k$N%a%C%;!<%8(B
$BEE;R%a!<%k$N%a%C%;!<%8$NDj5A$O(B RFC822 $B$GDj5A$5$l$F$$$k!#(B
RFC822 $B$NMWE@(B
- $BEE;R%a!<%k$N%a%C%;!<%8$O%X%C%@$H%\%G%#$KJ,$l$k!#(B
- $B3FJ8;z$O(B 7bit $B$GI=$5$J$$$H$$$1$J$$!#(B($B4pK\E*$K$O1Q?t;z$H5-9f$7$+5v$5$l$J$$(B)
($B;29M(B: $B2hA|%U%!%$%k$d%o!<%I%W%m%;%C%5$N%U%!%$%k$J$I$O(B 8bt $B$GI=8=$5$l$k$?$a!"$=$N$^$^$G$OAw$k$3$H$,$G$-$J$$(B)
- $B%X%C%@$O5!3#$,FI$s$G=hM}$r9T$&!#(B
- $B%X%C%@$O(B
$B9`L\L>(B: $BFbMF(B$B$H$$$&7A$K$J$C$F$$$k!#(B - $B9`L\L>$NBgJ8;z>.J8;z$O6hJL$5$l$J$$!#(B
- $B%\%G%$$O4pK\E*$K%F%-%9%H%U%!%$%k$rAw$k$h$&$K:n$i$l$F$$$k!#(B
$B
- To
- $B08@h(B
- From
- $B:9=P?M(B
- Subject
- $BBjL>!#$3$N9`L\$O8e$G8!:w$J$I$KMxMQ$9$k$N$G!"
$r$D$1$k!#(B
- Date
- $BF|IU!#1Q8l$G5-=R$7!";~:9$NI=<($r$9$k!#F|K\$@$C$?$i(B +0900$B!#(B
- Reply-to
- $BJV;v$NAwIU@h(B
- CC
- $B%+!<%\%s%3%T!BCC
- $B%V%i%$%s%I%+!<%\%s%3%T!Sender
- $BAw?.
Receipt-to
- $BAj
l9g$,B?$$$N$G!"B?MQ$7$F$O$$$1$J$$(B)
- Message-id
- $B$3$N%a!<%k$r<1JL$9$kHV9f(B(MTA)$B$,IU$1$k(B
- Received
- $B%a!<%kE>Aw%(!<%8%'%s%H(B(MTA)$B$,IU$1$k(B
- In-Reply-to
- $BJV;v$NBP>]$H$J$C$?%a!<%k$N(B message-id
$BEE;R%a!<%k$NAw$i$l$k;EAH(B
SMTP(Simple Mail Transfer Protocol(RFC821))
$B%a!<%k%5!<%P!<$X%a!<%k$rE>Aw$9$k%W%m%H%3%k!#(B
$B%a!<%k%5!<%P!Aw$,9T$($k!#(B
$B%a!<%kAw?.$NNc(B
sender.com TCP #25 receiver.com
HELO sender.com
$B"*(B
$B"+(B
250 receiver.com Hello [email protected], pleased to meet you
MAIL FROM:<[email protected]>
$B"*(B
$B"+(B
250 <[email protected]>... Sender ok
RCPT TO:<[email protected]>
$B"*(B
$B"+(B
250 <[email protected]>... Recipient ok
DATA
$B"*(B
$B"+(B
354 Enter mail, end with "." on a line by itself
From: <[email protected]>
To: <[email protected]>
Date: Tue, 15 May 2001 13:30:00 +0900
Subject: Test
This is a test message.
.
$B"*(B
$B"+(B
250 UAA22330 Message accepted for delivery
quit
$B"*(B
$B"+(B
221 receiver.com closing connection
POP(Post Office Protocol(RFC1255))
$B%a!<%k%5!<%P!<$+$i%a!<%k$r%3%T!<$9$k%W%m%H%3%k(B
$B%Q%=%3%s$J$I!">o$K%M%C%H%o!<%/$H@\B3$;$:!"%a!<%k%5!<%P!<$N5!G=$r;}$?$J$$%3%s%T%e!<%?$,!"%a!<%k%5!<%P!<$HDL?.$r$9$k$?$a$N%W%m%H%3%k!#(B
$B%M%C%H%o!<%/>e$G;HMQ$G$-$k5-9f(B
$B%\%G%#(B($BK\J8(B)
$BEE;R%a!<%k$rAw$k:]!"F|K\8l$NJ8;z$H$7$F;HMQ$G$-$kJ8;z$O(B iso-2022-jp(RFC1468)$B$H$$$&5,3J$G7h$a$i$l$F$$$k!#(B
$B!V(BCJK Character Tables$B!W(B(http://www.kudpc.kyoto-u.ac.jp/~yasuoka/CJK.html)$B$K;HMQ$G$-$k4A;z$N0lMw$N;qNA$,$"$k!#(B
$BDL>o%Q%=%3%s$GI=<(2DG=$JJ8;z$O!"(Biso-2022-jp $B$GI=<(2DG=$JJ8;z$K!"3HD%J8;z$r2C$($F$"$k!#(B
$BMWE@(B
- $BFCJL$J%+%?%+%J(B($B$7$P$7$PI}$,H>J,$GI=<($5$l$k(B)$B$O;HMQ$G$-$J$$!#(B
- $B!{$D$-?t;z$d%m!<%^?t;z$O;HMQ$G$-$J$$!#(B
$BAw?.2DG=$G$J$$J8;z$rF~NO$G$-$k%a!<%i!<$OB?$$$,!"Aw$C$F$bAj$N%a!<%k$bGK2u$9$k2DG=@-$,$"$k!#(B
$B%F%-%9%H%U%!%$%k$OJ8;z$NI}$r;XDj$G$-$J$$!#(B
$BJ8;z$NI}$rJQ$($?J8>O$rAw$k$K$O!"(B HTML 4.01 $B$H(B CSS $B$r;HMQ$9$l$PNI$$!#(B
$B%X%C%@(B
From $B$d(B Subject $B$K$b4A;z$,;HMQ$G$-$k$h$&$K3HD%$9$k5,3J$,$"$k(B(MIME-HEADER RFC2047)$B$?$a!"0lIt$N%a!<%i!<$G;HMQ$G$-$k!#(B($BAjZ$O$J$$(B)
From $B$K;HMQ$9$kJ8;z$O$5$i$K8B$i$l$F$$$k!#(B
()"\, $B$J$I$OFC
$B0zMQ$N$7$+$?!"=pL>(B
$BEE;R%a!<%k$N%^%J!<$O!"4pK\E*$K$ODL>o$N
Subject $BMs$O%3%s%T%e!<%?$KFI$^$;!"=hM}$9$k$N$K;HMQ$9$k$N$G!"FC$K%a!<%k$NFbMF$KBjL>$rIU$1$?$$>l9g$O!"K\J8$G:FEYL@<($7$?J}$,NI$$!#(B
$B!V7oL>!W$H$$$&8@MU$O%^%$%/%m%=%U%H$,FH<+$K;HMQ$7$F$$$k8@MU$G!"DL>o$OBjL>$d(B Subject $B$r;X$9!#(B
Re $B$O(B Respect to $B$N0UL#$G!"F|K\8l$G$O!V!A$K$D$$$F!W$HF1$8!#(B
RFC $B$NITHw$d!"%a!<%i!<$NIT=PMh$K$h$j!"!V(BRe: Re: Re: ...$B!W$H=E$J$C$F$7$^$&$3$H$,$7$P$7$P$"$k!#$7$+$7!"$3$l$ODL>o(B 1 $B$D$"$l$P==J,$J$N$G!"!V(BRe^3$B!W$J$I$HI=5-$9$k$N$O8m$j!#(B
$B:G6a!"JV?.%a!<%k$N:G8e$K!"Aw$C$?%a!<%k$rA4J8$D$1$FAw$jJV$9?M$,B?$/$J$C$?$,!"4pK\E*$K$OL5BL$J9T0Y!#(B($BI,MW$,$"$l$P$d$C$F$b$h$$(B)
$B$^$?!"DL>o!";aL>$dO"Mm@h$r%a!<%k$N:G8e$KE:IU$9$k$3$H$,9T$o$l$F$$$k!#$3$l$r!V=pL>!W$H8F$V$3$H$b$"$k$,!"K\Mh!V=pL>!W$N;}$D5!G=$G$"$k!"=q$$$?FbMF$rJ]>Z$7$FCx$,I,MW$J$i$P!"(BPGP $B$J$I$rMxMQ$7$FEE;R=pL>$r$9$kI,MW$,$"$k!#(B
$BC"$7!"$[$H$s$I$NEE;R%a!<%k$O=pL>$rI,MW$H$7$J$$$N$b3N$+$G$"$k!#(B
$BE:IU%U%!%$%k(B
MIME (RFC2045)$B$rMxMQ$9$k$H%F%-%9%H%U%!%$%k0J30$rEE;R%a!<%k$GAw$k$3$H$,$G$-$k!#(B
$BC"$7!"A4$F$N%a!<%i!<$,(B MIME $B$KBP1~$7$F$$$k$o$1$G$O$J$$$N$G!"Aj
$BCm0UE@(B
- $B%F%-%9%H%U%!%$%k$OE:IU$7$J$$!#(B($BMU=q$rIuE{$KF~$l$FAw$k$h$&$J$b$N(B)
- $B%^%$%/%m%=%U%H$N%a!<%i!<$O!"K\J8$HF1$8FbMF$r%G%?%i%a$J;H$$J}$N(B HTML $B$GE:IU$7$FAw?.$9$k!#(B
- $BAw$k%U%!%$%k$N%5%$%:$K5$$rIU$1$k!#Aj
e$N%G!<%?$rE:IU$7$J$$$h$&$K$9$k!#(B
$BEE;R%a!<%k$N0E9f2=(B
$B4pK\E*$KEE;R%a!<%k$O%M%C%H%o!<%/>e$rAGDL$j$9$k$?$a!"EpD0$,2DG=$G$"$k!#(B
$BEE;R%a!<%k$r0E9f2=$7$F!"B>?M$KFI$a$J$/$9$k5;=Q$b3+H/$5$l$F$$$k!#(B
PGP(Pretty Good Privacy)$B$O$=$NCf$G$bM-L>$J%Q%C%1!<%8$G$"$k!#(B
PGP $B$K$O0E9f2=$NB>$K!"=q$$$??M4V$rFCDj$72~cb$,$J$$$3$H$rJ]>Z$G$-$kEE;R=pL>$b2DG=$G$"$k!#(B
$B1i=,(B
$B%3%s%T%e!<%?%W%m%0%i%`$N%l%]!<%H$rEE;R%a!<%k$GDs=P$9$k$K$O$I$&$$$&J}K!$,K>$^$7$$$+(B?
$BDs=PJ}K!$N%^%K%e%"%k$r=q$-$J$5$$!#(B
5-2. $B%^%$%/%m%=%U%H%(%/%;%k(B
$BI=7W;;$H$O(B
$B%;%k$H8F$P$l$k$b$N$,=D2#$KJB$s$G$$$F!"$=$3$K%G!<%?$,F~$l$i$l$k$h$&$K$J$C(B
$B$F$$$k!#%G!<%?$rF~$l$FI=$r40@.$5$;!"=PNO$9$k$N$,L\E*$G$"$k$,!"I=$NCf$K(B
$B7W;;<0$rF~$l$k$3$H$,$G$-!"=87W$J$I$KMxMQ$G$-$k5!G=$r;}$D!#(B
$B%^%$%/%m%=%U%H%(%/%;%k$O$5$i$K%0%i%U$N:n?^$b$G$-$k$h$&$K$J$C$F$$$k!#(B
$B%;%k$KF~$l$i$l$k$b$N(B
- $B?tCM(B
- $BJ8;zNs(B
- $BF|IU(B
- $B?t<0(B(=$B$G;O$a$k(B)$B!#!V!_!W$O!V(B*$B!W!"!V!`!W$O!V(B/$B!W$GI=$9!#(B
$BA`:n$N4pK\(B
- $BD{@5(B
- $B0\F0(B
- $B%3%T!<(B
- $B%+%C%H%P%C%U%!(B
- $B%U%#%k%O%s%I%k(B
$B;OE@$H=*E@$NCM$r;XDj$7$?NN0h$KBP$7$F!"!VJT=8!W"*!V%U%#%k!W"*!VO"B3%G!<%?$N:n@.!W$r9T$&$H!"Cf4V$NCM$rKd$a$F$/$l$k!#(B
$B1i=,(B1
$B
A B C D
1 $B1Q8l(B $B?t3X(B $B9q8l(B
2 $B=E$_(B 0.5 1.2 1
3 $BF|IU(B $B1Q8l(B $B?t3X(B $B9q8l(B
4 2001/5/1 75 50 85
5 2001/5/2 80 60 80
6 2001/5/3 60 55 75
7 2001/5/4 90 80 90
8 2001/5/5 85 75 85
$B;2>H(B
$B?t<0$G%;%k$NNN0h$r;XDj$G$-$k!#(B
$B=D2#$r;XDj$9$k$H0l$D$N%;%k!"=D2#$NAH$_$r!V(B:($B%3%m%s(B)$B!W$G6h@Z$k$H6k7A$r;XDj$G$-$k!#(B
$B;XDjJ}K!(B
- $B%-!
$B%+!<%=%k%-!<$K$h$k;XDj(B
- $B%]%$%s%?$NA`:n$K$h$k;XDj(B
$BAjBP@dBP(B
F4$B%-!<$G@Z$j49$($k!#@dBP;2>H$O!"0LCV$NA0$K!V(B$$B!W5-9f$r$D$1$k!#(B
- $BAjBP;2>H(B
- $B;XDj$7$?;2>H$r%3%T!<$9$k$H0\F0NL$K1~$8$F<+F0E*$K;XDj$9$k0LCV$,$:$l$k(B
- $B@dBP;2>H(B
- $B;XDj$7$?;2>H$r%3%T!<$7$F$b0LCV$,JQ2=$7$J$$(B
$B?t<0$G;HMQ$G$-$k4X?t(B
$BK\F|;HMQ$9$k4X?t(B
- SUM
- $B;XDjNN0h$NB-$7;;(B
- AVERAGE(X)
- $BJ?6Q(B
- STDEV(X)
- $BI8=`JP:9(B
- LARGE(X,Y)
- $BNN0h(BX$B$NCf$G>e0L(B Y $BHVL\$NCM$rJV$9!#(B
- IF(X,Y,Z)
- $B>r7o(B X $B$,??$J$i(B Y$B!"56$J$i(B Z $B$rJV$9!#(B
- SIN(X)
- $B;03Q4X?t$N0l$D!"@5894X?t!#(B
- LINEST(X,Y,Z,U)
- $B:G>.Fs>hK!$N78?t$r5a$a$k!#(BZ=FALSE $B$J$i(B y $B@ZJR$,(B0 $B$G$"$k$3$H$r;XDj$9$k!#(B
U=TRUE $B$J$i(B $B79$-$H@ZJR$NB>$K!"3FJd@5CM$,F@$i$l$k!#C1=c$K79$-$H@ZJR$r5a$a$?$$>l9g$O(B Z=TRUE, U=FALSE $B$H$9$k!#(B
- MAX,MIN
- $BNN0hFb$N:GBgCM!":G>.CM$r5a$a$k!#(B
- LOG
- $B>oMQBP?t(B
- DAVERAGE(X,Y,Z)
- $B%G!<%?%Y!<%94X?t!"%G!<%?%Y!<%9(B X $B$NNN0h(B Y $B$r>r7o(B Z $B$K1h$C$FJ?6Q$r5a$a$k!#(B
$B1i=,(B
- B4 $B$+$i(B D8 $B$HF1$8$b$N$r(B B10 $B$+$i(B D14 $B$K:n$k!#(B
- E3 $B$K!V9g7W!W$N8+=P$7$r:n$j!"(BB4, C4, D4 $B$N9g7W$r(B E4$B$K!"(BB5-D5 $B$N9g7W$r(B E5 $B$K!"(B... B8-D8 $B$N9g7W$r(B E8 $B$K:n$k!#(B
- F3 $B$K!V=E$_$D$-9g7W!W$N8+=P$7$r:n$j!"(B B4*B2+C4*C2+D4*D2 $B$r(B F4 $B$K!"(B...
B8*B2+C8*C2+D8*D2 $B$r(B F8 $B$K:n$k!#(B
- $BI=$r@07A$9$k(B
A B C D E F
1 $B1Q8l(B $B?t3X(B $B9q8l(B
2 $B=E$_(B 0.5 1.2 1
3 $BF|IU(B $B1Q8l(B $B?t3X(B $B9q8l(B $B9g7W(B $B=E$_$D$-9g7W(B
4 2001/5/1 75 50 85 =SUM($B4:$D4) =B4*B$2+C4*C$2+D4*D$2
5 2001/5/2 80 60 80 =SUM($B5:$D5) =B5*B$2+C5*C$2+D5*D$2
6 2001/5/3 60 55 75 =SUM($B6:$D6) =B6*B$2+C6*C$2+D6*D$2
7 2001/5/4 90 80 90 =SUM($B7:$D7) =B7*B$2+C7*C$2+D7*D$2
8 2001/5/5 85 75 85 =SUM($B8:$D8) =B8*B$2+C8*C$2+D8*D$2
9
10 =B4 =C4 =D4
11 =B5 =C5 =D5
12 =B6 =C6 =D6
13 =B7 =C7 =D7
14 =B8 =C8 =D8
$B%F%-%9%H%U%!%$%k$H$NO"7H(B
$B%F%-%9%H%U%!%$%k$rFI$_9~$_!"=hM}$r9T$C$?$"$H!":F$S%F%-%9%H%U%!%$%k$H$7$F=PNO$9$k!#(B
- $B@.@S%U%!%$%k(B$B$+$i!"@.@S%7!<%H$r:n$k!#(B
- $B9g7WE@!"I8=`JP:9$r7W;;$7!"JP:9CM$NI=$r:n$k!#(B
$BJP:9CM(B=($BAGE@(B - $BJ?6QE@(B)*10/($BI8=`JP:9(B) + 50
- $B9g3J
$B9g3J$B9gH]$NI=<($r$9$k!#(B
- $B%F%-%9%H%U%!%$%k$K$9$k!#(B
$B%G!<%?%Y!<%9A`:n(B
$B8!:w>r7o$r;XDj$7$F!"=87W$r9T$&!#(B
- $B!V1Q8l!W!V?t3X!W!V9g7W!W!VJP:9CM!W!V9gH]!W$NMs$r%3%T!<$9$k(B
- $B%G!<%?%Y!<%94X?t$r@_Dj$9$k!#(B
- $Br7o$r;XDj$7!"J?6QE@$r5a$a$k!#(B
- $B9g3J
$B?t3X$,(B 50 $BE@0J>e$N?M$N9g7WE@$NJ?6Q(B
$B%0%i%U:[email protected]!G=(B
$B%0%i%U:[email protected]!G=$r;H$&(B
- $B@.@S%7!<%H$+$iK@%0%i%U$r:n$k!#(B
- $B;03Q4X?t$N%0%i%U$r:n$k!#&H$,(B 0 $B$+$i(B 2$B&P$^$G$N(B sin($B&H(B)$B$N%0%i%U$r:n$k!#(B
$B%+%C%H%P%C%U%!$N3hMQ(B
$B%^%k%A%&%#%s%I%&$N%7%'%k$G%+%C%H%P%C%U%!$rDs6!$9$k$b$N$,$"$k!#(B
($B%^%$%/%m%=%U%H%&%#%s%I%&%:$bDs6!$7$F$$$k(B)
$B$3$l$rMxMQ$9$k$H%"%W%j%1!<%7%g%s%=%U%H%&%'%"F1;N$G>pJs$N$d$j
- Ctrl-X
- $B%+%C%H(B
- Ctrl-C
- $B%3%T!<(B
- Ctrl-V
- $B%Z!<%9%H(B
- $B@hDx:n@.$7$?%0%i%U$r%^%$%/%m%=%U%H%o!<%I$KE=$jIU$1$J$5$$!#(B
$B:G>.Fs>hK!(B
x,y $B$NAH$NJ#?t$NCM$,M?$($i$l$?$H$9$k!#(B
$B$3$N%G!<%?$,!"(By=ax+b $B$H$$$&4X78$r$b$D$H2>Dj$7$F!"(B a $B$H(B b $B$NCM$r5a$a$k(B
$BLd(B1
$B%G!<%?(B2$B$O(B y=ax+b $B$H$$$&4X78$r;}$C$F$$$k!#(B
- $B%G!<%?(B2 $B$r%0%i%U$KI=$7$J$5$$!#(B
- a $B$H(B b $B$NCM$r5a$a$J$5$$!#(B
- a $B$H(B b $B$NCM$rMQ$$$F!"%0%i%U$K@~$r0z$-$J$5$$!#(B
$BLd(B2
$B%G!<%?(B3$B$O(B y=b x^a (b$B$+$1$k(B x $B$N(B a $B>h(B)$B$H$$$&4X78$r;}$C$F$$$k!#(B
- $B%G!<%?(B3 $B$r%0%i%U$KI=$7$J$5$$!#(B
- a $B$H(B b $B$NCM$r5a$a$J$5$$!#(B
- a $B$H(B b $B$NCM$rMQ$$$F!"%0%i%U$K@~$r0z$-$J$5$$!#(B
5-3. $B;29MJ88%(B
- $B2CF#900l!VEEG>
$B:dK\D>;V(B [email protected]
- To
- $B08@h(B
- From
- $B:9=P?M(B
- Subject
- $BBjL>!#$3$N9`L\$O8e$G8!:w$J$I$KMxMQ$9$k$N$G!"
- Date
- $BF|IU!#1Q8l$G5-=R$7!";~:9$NI=<($r$9$k!#F|K\$@$C$?$i(B +0900$B!#(B
- Reply-to
- $BJV;v$NAwIU@h(B
- CC
- $B%+!<%\%s%3%T!BCC
- $B%V%i%$%s%I%+!<%\%s%3%T!Sender
- $BAw?.
Receipt-to - $BAj
- Message-id
- $B$3$N%a!<%k$r<1JL$9$kHV9f(B(MTA)$B$,IU$1$k(B
- Received
- $B%a!<%kE>Aw%(!<%8%'%s%H(B(MTA)$B$,IU$1$k(B
- In-Reply-to
- $BJV;v$NBP>]$H$J$C$?%a!<%k$N(B message-id
$BEE;R%a!<%k$NAw$i$l$k;EAH(B
SMTP(Simple Mail Transfer Protocol(RFC821))
$B%a!<%k%5!<%P!<$X%a!<%k$rE>Aw$9$k%W%m%H%3%k!#(B
$B%a!<%k%5!<%P!
| sender.com | TCP #25 | receiver.com |
|---|---|---|
| HELO sender.com | $B"*(B | |
| $B"+(B | 250 receiver.com Hello [email protected], pleased to meet you | |
| MAIL FROM:<[email protected]> | $B"*(B | |
| $B"+(B | 250 <[email protected]>... Sender ok | |
| RCPT TO:<[email protected]> | $B"*(B | |
| $B"+(B | 250 <[email protected]>... Recipient ok | |
| DATA | $B"*(B | |
| $B"+(B | 354 Enter mail, end with "." on a line by itself | |
|
From: <[email protected]> To: <[email protected]> Date: Tue, 15 May 2001 13:30:00 +0900 Subject: Test This is a test message. . | $B"*(B | |
| $B"+(B | 250 UAA22330 Message accepted for delivery | |
| quit | $B"*(B | |
| $B"+(B | 221 receiver.com closing connection |
POP(Post Office Protocol(RFC1255))
$B%a!<%k%5!<%P!<$+$i%a!<%k$r%3%T!<$9$k%W%m%H%3%k(B $B%Q%=%3%s$J$I!">o$K%M%C%H%o!<%/$H@\B3$;$:!"%a!<%k%5!<%P!<$N5!G=$r;}$?$J$$%3%s%T%e!<%?$,!"%a!<%k%5!<%P!<$HDL?.$r$9$k$?$a$N%W%m%H%3%k!#(B
$B%M%C%H%o!<%/>e$G;HMQ$G$-$k5-9f(B
$B%\%G%#(B($BK\J8(B)
$BEE;R%a!<%k$rAw$k:]!"F|K\8l$NJ8;z$H$7$F;HMQ$G$-$kJ8;z$O(B iso-2022-jp(RFC1468)$B$H$$$&5,3J$G7h$a$i$l$F$$$k!#(B
$B!V(BCJK Character Tables$B!W(B(http://www.kudpc.kyoto-u.ac.jp/~yasuoka/CJK.html)$B$K;HMQ$G$-$k4A;z$N0lMw$N;qNA$,$"$k!#(B
$BDL>o%Q%=%3%s$GI=<(2DG=$JJ8;z$O!"(Biso-2022-jp $B$GI=<(2DG=$JJ8;z$K!"3HD%J8;z$r2C$($F$"$k!#(B
$BMWE@(B
- $BFCJL$J%+%?%+%J(B($B$7$P$7$PI}$,H>J,$GI=<($5$l$k(B)$B$O;HMQ$G$-$J$$!#(B
- $B!{$D$-?t;z$d%m!<%^?t;z$O;HMQ$G$-$J$$!#(B
$BAw?.2DG=$G$J$$J8;z$rF~NO$G$-$k%a!<%i!<$OB?$$$,!"Aw$C$F$bAj
$B%F%-%9%H%U%!%$%k$OJ8;z$NI}$r;XDj$G$-$J$$!#(B $BJ8;z$NI}$rJQ$($?J8>O$rAw$k$K$O!"(B HTML 4.01 $B$H(B CSS $B$r;HMQ$9$l$PNI$$!#(B
$B%X%C%@(B
From $B$d(B Subject $B$K$b4A;z$,;HMQ$G$-$k$h$&$K3HD%$9$k5,3J$,$"$k(B(MIME-HEADER RFC2047)$B$?$a!"0lIt$N%a!<%i!<$G;HMQ$G$-$k!#(B($BAj
MIME (RFC2045)$B$rMxMQ$9$k$H%F%-%9%H%U%!%$%k0J30$rEE;R%a!<%k$GAw$k$3$H$,$G$-$k!#(B
$BC"$7!"A4$F$N%a!<%i!<$,(B MIME $B$KBP1~$7$F$$$k$o$1$G$O$J$$$N$G!"Aj
$B%;%k$H8F$P$l$k$b$N$,=D2#$KJB$s$G$$$F!"$=$3$K%G!<%?$,F~$l$i$l$k$h$&$K$J$C(B
$B$F$$$k!#%G!<%?$rF~$l$FI=$r40@.$5$;!"=PNO$9$k$N$,L\E*$G$"$k$,!"I=$NCf$K(B
$B7W;;<0$rF~$l$k$3$H$,$G$-!"=87W$J$I$KMxMQ$G$-$k5!G=$r;}$D!#(B
$B%^%$%/%m%=%U%H%(%/%;%k$O$5$i$K%0%i%U$N:n?^$b$G$-$k$h$&$K$J$C$F$$$k!#(B
$B
$B?t<0$G%;%k$NNN0h$r;XDj$G$-$k!#(B $B=D2#$r;XDj$9$k$H0l$D$N%;%k!"=D2#$NAH$_$r!V(B:($B%3%m%s(B)$B!W$G6h@Z$k$H6k7A$r;XDj$G$-$k!#(B
$BK\F|;HMQ$9$k4X?t(B
$B%F%-%9%H%U%!%$%k$rFI$_9~$_!"=hM}$r9T$C$?$"$H!":F$S%F%-%9%H%U%!%$%k$H$7$F=PNO$9$k!#(B
$B8!:w>r7o$r;XDj$7$F!"=87W$r9T$&!#(B
$B%0%i%U:[email protected]!G=$r;H$&(B
$B%^%k%A%&%#%s%I%&$N%7%'%k$G%+%C%H%P%C%U%!$rDs6!$9$k$b$N$,$"$k!#(B
($B%^%$%/%m%=%U%H%&%#%s%I%&%:$bDs6!$7$F$$$k(B)
$B$3$l$rMxMQ$9$k$H%"%W%j%1!<%7%g%s%=%U%H%&%'%"F1;N$G>pJs$N$d$j
x,y $B$NAH$NJ#?t$NCM$,M?$($i$l$?$H$9$k!#(B
$B$3$N%G!<%?$,!"(By=ax+b $B$H$$$&4X78$r$b$D$H2>Dj$7$F!"(B a $B$H(B b $B$NCM$r5a$a$k(B
$B%G!<%?(B3$B$O(B y=b x^a (b$B$+$1$k(B x $B$N(B a $B>h(B)$B$H$$$&4X78$r;}$C$F$$$k!#(B
$B0zMQ$N$7$+$?!"=pL>(B
$BEE;R%a!<%k$N%^%J!<$O!"4pK\E*$K$ODL>o$N$BE:IU%U%!%$%k(B
$BCm0UE@(B
$BEE;R%a!<%k$N0E9f2=(B
$B4pK\E*$KEE;R%a!<%k$O%M%C%H%o!<%/>e$rAGDL$j$9$k$?$a!"EpD0$,2DG=$G$"$k!#(B
$BEE;R%a!<%k$r0E9f2=$7$F!"B>?M$KFI$a$J$/$9$k5;=Q$b3+H/$5$l$F$$$k!#(B
PGP(Pretty Good Privacy)$B$O$=$NCf$G$bM-L>$J%Q%C%1!<%8$G$"$k!#(B
PGP $B$K$O0E9f2=$NB>$K!"=q$$$??M4V$rFCDj$72~cb$,$J$$$3$H$rJ]>Z$G$-$kEE;R=pL>$b2DG=$G$"$k!#(B
$B1i=,(B
$B%3%s%T%e!<%?%W%m%0%i%`$N%l%]!<%H$rEE;R%a!<%k$GDs=P$9$k$K$O$I$&$$$&J}K!$,K>$^$7$$$+(B?
$BDs=PJ}K!$N%^%K%e%"%k$r=q$-$J$5$$!#(B
5-2. $B%^%$%/%m%=%U%H%(%/%;%k(B
$BI=7W;;$H$O(B
$B%;%k$KF~$l$i$l$k$b$N(B
$BA`:n$N4pK\(B
$B;OE@$H=*E@$NCM$r;XDj$7$?NN0h$KBP$7$F!"!VJT=8!W"*!V%U%#%k!W"*!VO"B3%G!<%?$N:n@.!W$r9T$&$H!"Cf4V$NCM$rKd$a$F$/$l$k!#(B
$B1i=,(B1
A B C D
1 $B1Q8l(B $B?t3X(B $B9q8l(B
2 $B=E$_(B 0.5 1.2 1
3 $BF|IU(B $B1Q8l(B $B?t3X(B $B9q8l(B
4 2001/5/1 75 50 85
5 2001/5/2 80 60 80
6 2001/5/3 60 55 75
7 2001/5/4 90 80 90
8 2001/5/5 85 75 85
$B;2>H(B
$B;XDjJ}K!(B
$BAjBP@dBP(B
F4$B%-!<$G@Z$j49$($k!#@dBP;2>H$O!"0LCV$NA0$K!V(B$$B!W5-9f$r$D$1$k!#(B
$B?t<0$G;HMQ$G$-$k4X?t(B
$B1i=,(B
A B C D E F
1 $B1Q8l(B $B?t3X(B $B9q8l(B
2 $B=E$_(B 0.5 1.2 1
3 $BF|IU(B $B1Q8l(B $B?t3X(B $B9q8l(B $B9g7W(B $B=E$_$D$-9g7W(B
4 2001/5/1 75 50 85 =SUM($B4:$D4) =B4*B$2+C4*C$2+D4*D$2
5 2001/5/2 80 60 80 =SUM($B5:$D5) =B5*B$2+C5*C$2+D5*D$2
6 2001/5/3 60 55 75 =SUM($B6:$D6) =B6*B$2+C6*C$2+D6*D$2
7 2001/5/4 90 80 90 =SUM($B7:$D7) =B7*B$2+C7*C$2+D7*D$2
8 2001/5/5 85 75 85 =SUM($B8:$D8) =B8*B$2+C8*C$2+D8*D$2
9
10 =B4 =C4 =D4
11 =B5 =C5 =D5
12 =B6 =C6 =D6
13 =B7 =C7 =D7
14 =B8 =C8 =D8
$B%F%-%9%H%U%!%$%k$H$NO"7H(B
$BJP:9CM(B=($BAGE@(B - $BJ?6QE@(B)*10/($BI8=`JP:9(B) + 50
$B%G!<%?%Y!<%9A`:n(B
$B%0%i%U:[email protected]!G=(B
$B%+%C%H%P%C%U%!$N3hMQ(B
$B:G>.Fs>hK!(B
$BLd(B1
$B%G!<%?(B2$B$O(B y=ax+b $B$H$$$&4X78$r;}$C$F$$$k!#(B
$BLd(B2
5-3. $B;29MJ88%(B
$B:dK\D>;V(B [email protected]