Giải toán trên EXCEL doc
Bạn đang xem bản rút gọn của tài liệu. Xem và tải ngay bản đầy đủ của tài liệu tại đây (439.71 KB, 16 trang )
Giải toán trên
6.1. ĐẠI SỐ MA TRẬN
Transpose Matrix
!"#$% !"&
'(#$%&$)*+'(&
!,(-./,$0"&
1%(#$%)*+,+$'234-)5
!*&*+
'6"78
/01&$Inverse Matrix&
2
!,(-,9)$0//&
1%(34567,$)*'$8/: ;'))(2!39
$<!(3$+*+234-)5
=>?
!%@9,$:;&)"2
(" 2
Lưu ýA"("
5,)B0
$0 //& C @3
# 5 DE =
4=F
G=
2H//,
) 4
G=
-8!"#@3
F
G=
$IDEI
4& J 9K L # 9K
;L@3$9M.
8 ! "#
///<&2'7-97+=/<9<N'(,$>(+2
'6"78
5?multiply&$@AA
!,(-$0/B&
1%( 33C $)* '$8 /: ;'))(2! 39
$<!(33C234-)5
=OP
!%@9,$ !"&)" Q!%@
9,$= D&)"/
(" 2
Lưu ýA"(" 5,)B0$0/B&C@3#5DE
=4=F2H//,)4-8!"#@3
F$IDEI4R3-I@IS3-T@I&J9KL#9K;L@32
'7-97+=/<9<N'(,$>(+2
'6"78
<E0F$Matrix determinant&G!+
!,9,U$0=H&
1%(3!73$)*'$8/: ;'))(2!39
$<!(3!73234-)5
!%@9,$:;&)"2
(" 2
=O=
6.2. GIẢI HỆ PHƯƠNG TRÌNH TUYẾN TÍNH
1%(,&'+)3+&&'*FV@W(2X7)N:-)3+&&'*
6(.)
1%(&&'*I##24*Y
34-)5DDGZ
• '$8![,&'+##2$2
• '$8\ 2
')]W'))(^@3(A)(W2
6E#J_-`R.7
=+−
−=++
=++
=++
=TIIa
b>
>I
aa
zyx
zyx
zyx
zyx
KL@L@$&MNL1EO+'
=Oa
=V=bb(DE;9c2
a>(#F@Qa>(#F.a>(#Fd2
e=P(;f#2
e=P(,9KFf#2A"@)%.(F
-`R`Uf#2
4M$9/#2
41$$VaV>&(,7-F-`R2
L MLP$1$L@$&M
Bước 1
HD3"#4M$$!/!"2
1%(M33C/"Q:;$)*'$8/:
;'))(2!39$<!(33C+=/<3g:--
'(,$>(+2
Bước 2
("4)0!/2
_!,&'+LW&&'*X-#)hg,&'+++*
=OI
Set Target Cell1)\9/09,,5!/;^/,R!R/2X79\-
+@9,C.9#.2
Equal To("49D36'+&>+)";5,(/$R\
-))7;i7;-&2
Subject to the ConstraintsHM.(`@9,9c"49/)j
);$9c"()4,4i,4-&2("\##
@34-)5##&*$*-)#
(" 9/(54-,&'+)++*2
A"9)#F4-)5,&'+'$8)\!,&'+2
X7"78#V@W(0)(kfound a solutionl
mj.!.++,&'+,&'$&9/("78;$7!7+*&+-$$'
6'+*^n"78A)(WLR9:(5,"94F7&2
=OT
o78;
XR;3.,)4M$i9\,)4
1$248S$0T9j.9gp,Upf#2q.F
-`R(@r=Q.rGadra2
6.3. QUI HOẠCH TUYẾN TÍNH
)5.7()R/$.95&F4.7s$@&
;-:-1⊂t
9:@9,4-`Ru)*3-`R
.7)2
A@$&MUDVWM
'R7#@
=
@
a
222@
))
s$@&r
∑
=
n
j
jj
xc
=
→$.@& $O2=&
Bj9c"
∑
=
n
j
jij
xa
=
≤
r=222
=
$O2a&
∑
=
n
j
jij
xa
=
≥
r
=
v=222
=
v
a
$O2I&
∑
=
n
j
jij
xa
=
r
r
=
v
a
v=222 $O2T&
@
w
≥Pwr=222
=
@
w
≤Pwr
=
v=222
=
v
a
≤2 $O2>&
'));
s!(hm mc tiêupU$O2a&G$O2>&!(4rng buc2
H/@r$@
=
@
a
222@
&∈t
Bj!4!(4phương !n2
'-:-3-`!(mi"n rng buc2
]4-`)j$O2=&!(phương !n t#i ưu.4l$i gi%iF)
9j)2
=O>
/X$1$L@$&MUDLYO+'
1%(,&'+)3+&&'*FV@W(2
AZ4-[5\).]D-^D,_5C`
]4@-D9,@3()5-f(A
=
A
a
2H/(9:49`,
A
=
KT9`,(q
=
>9`,(q
a
2H/(9:=9`,A
a
KI9`,q
=
a
9`,q
a
2_49`,A
=
(>P
9<49`,A
a
(IP9<2
mB@-;@3);
9`,-fA
=
A
a
9/g-(
(37i@-C6=aPP
9`,(q
=
=PeP9`,(
q
a
2
3GK&Ma
_!@
=
@
a
(K(:(#9`,-fA
=
A
a
K@32A#9`,(q
=
K
6(T@
=
vI@
a
21)@-C6=aPP9`,(q
=
;@
=
@
a
-Bj
T@
=
vI@
a
≤=aPP2
'`#9`,(q
a
K6(>@
=
va@
a
R7@
=
@
a
-)j
>@
=
va@
a
≤=PeP2
'3;E-6@
=
≥P@
a
≥P2
'g-F@-$K(95&^(sr>P@
=
vIP@
a
$9<&2
q.)9*9:-/'R7#@
=
@
a
))
sr>P@
=
vIP@
a
→@
9c"
T@
=
vI@
a
≤=aPP
>@
=
va@
a
≤=PeP
@
=
≥P@
a
≥P2
X$1$ML1E
H/9:4)8.)5.79K;-@M.D0R
))2.-/+7#9K)57
4F7#962
APM.D0R@3;-)4--9K3"x
=OO
'-)4
-- 9K $A=Aa& r
$=P=P&2X-(K(:,
=P)0a1a2o78
)3.g -F
-- @3 . 95
ePP $tuy nhiên vẫn
chưa sử dng hết vật liệu
trong kho&2
AP/'#)2
_!,&'+LW&&'*2X-)[;4F))hg
,&'+++*
Tóm tắt tham s# yêu cầu của Solver
=Ob
@b,&'+ *c@& 5Y&G
= AW'WW(( m[; ?
a V8(') ]@]q(W)s
$()5)&
]@
I .W(( 7 a1a
T AwW)W) 4 VOVbOb
A"9)#F4-)5A)(W'$8)\!,&'+9/V@W(J
9K)2
.dW1K0eSK*
LAZ4-[5[fg5D.DhC)Di5Djk5
]4@-y0K()5Uyg:-'
=
'
a
)\C(
77="'
=
UI9`,DDz1
=
$3)&=9`,DDz1
a
$m.9
)&=9`,DDz1
I
${)W&Q="'
a
U=9`,1
=
=9`,1
a
a9`
,1
I
2]p|y)\K#/OP9`,1
=
TP9`,1
a
OP9`,1
I
2
mB @ - K
);"'
=
'
a
)p|
y))L9)#D
Dz)| yF \
L9/g#cU
y(B32)7="'
=
aP9<="'
a
=>
9<2
3GK&Ma
=Oe
_!@
=
@
a
(K(:(#"Uy'
=
'
a
K)p|y2A#9`,31
=
6)p|y(I@
=
v@
a
R7@
=
@
a
KBj
I@
=
v@
a
≥OP
'`9/9-UKc31
a
1
I
)p|y@
=
@
a
KBj
@
=
v@
a
≥TP
@
=
va@
a
≥OP
'3;}9EB
@
=
≥P@
a
≥P2
A#cUy$K(/&israP@
=
v=>@
a
$9<&2
q.);;9:-/'R7#@
=
@
a
))
sraP@
=
v=>@
a
→
9c"
I@
=
v@
a
≥OP
@
=
v@
a
≥TP
@
=
va@
a
≥OP
@
=
≥P@
a
≥P2
LX$1$ML1E
APM.D0R);-)4--9K3"x
'-)4--9K$'='a&r$aPaP&2o78)3.g#c
UyF--.95bPP2
AP/'#)2
=O?
_!,&'+LW&&'*2X-)[;4F))
hg,&'+++*
o78R9:R
=bP
AZ4-[5)Dl6\4mC
')7N-J|(D$-#y3.222&
694D)|9)5J`#(:39,9/hD[2X;J
7))#(3~
6E#J{M@-F0.@M.(J--@M.DL'M-'
X.;-[[K@M.(J-0R2'-9:3-DD5L
cD(aP2
'W).;KF4-@M.D{M@--3-=>P9)5-
D>aPP9)5-DbIPP9)5-D?2H/.;K.{M
@-Jp-aP(c9)5)6cD)*>)*b
)*?2qJ.^9/(5•-L"0/hD[26O-`
J9:R.)
mB-M@K-c);-aPJW)-`)9/
-L(32
3GK&Ma_!@
w
$wr=YO&(#-$DaP&KJW)-`w2
);^9:-/'R7#@
=
@
a
@
I
@
T
@
>
@
O
))
s$g#-L&rT@
=
vI@
a
v@
I
v@
>
va@
O
→
9c"
a@
a
va@
I
vT@
T
v@
>
r=>P2
@
=
v@
a
va@
>
raPP
@
=
v@
I
va@
O
rIPP
@
w
≥Pwr=YO2
LX$1$ML1E
APM.D0R);-)4--9K3"x
=b=
AP/'#)2
_!,&'+LW&&'*2X-)[;4F))
hg,&'+++*
o78R9:R
=ba
AZ4\)
A@$'R./,F
&
−
−
=
OI=a
Ta>=
Ia=a
A
&
−
−
=
aTI
=Ta
aaT
=Ia
B
A@$/'R,9)$76&F
&
=
?I=
Ta=
===
A
Q &
−
−
−
=
T=a
==a
P=I
B
Q
A@$ 'R$"\9:@9,&
&
−
−
=
==PP
a=TI
aP==
A
−
−
=
=a=
a=a
P=a
==P
B
&
=
aP=I
>Ta=
A
−
=
I
=
a
=
B
&
−
=
a
=
A
−
=
=P
a=
B
D&
−
−
=
TI
P=
=a
A
−−
=
PTI
>a=
B
A@$<'9,U
&
IIa
aP=
TaI
−
−
−
Q &
Q
I===
=I==
==I=
===I
&
Ia=T
a=TI
=TIa
TIa=
2
A@$"_-`R.7
&
=++
=−+
−=+−
aIa
Oaa
a
zyx
zyx
zyx
&
=−+
=−−−
=++
=++
=TIIa
b>
aa
>I
zyx
zyx
zyx
zyx
A@$ ]4@-969K96()5=PPj(>Pj(2
')@-6()5:8.79,(:"7)52':€6aPPP0
=bI
:J6IPPP0:46=>PP02H,U()94)p()59:
))
H,U•)5
()94
•)5:
=PPj( >Pj(
':J$IPPP&
':€$aPPP&
':4$=>PP&
=>P
=aP
eP
bP
>P
TP
$0u-f&
mB@-;96p()5);9/95g#j()3~
A@$B]4@-6/hD[#9>=PN.IOPN.=>PN
.9/75)()5-f2H/75)49`,-fK?N
.>N.IN.Q49`,-fKIN.TN
.Q49`,-fK>N.IN.aN.2]p
-f,Te9<p-f,=O9<p-f,
ab9<2
q39c9*(@-K75));9`,-fp()59/g#
,-f@-9:((39c""0D%8#N6
Fp()5.
A@$:]4@(hJ6|-D=aKJe9)5DT
>9)5D>I9)5Db26>•J
]•=I9)5T"0L2
]•a=9)5T=9)5>LI2
]•I=9)5T=9)5bL=2
]•Ta9)5>La2
]•>=9)5>=9)5b"0L2
q39c9*F@(R•J7"3~
=bT
