. , , (. 8.1).
. 8.1 Excel
, .
.
, . 8.2. UserForm1 ComboBox1 , , Label1. . TextBox1 , Label2 .
. 8.2
, 1, :
Sub CommandButton1_Click()
I=4
Do Until Worksheets(1).Cells(I,1)=
I=I+1
Loop
J=I-1
UserForm1.ComboBox1.RowSource = "1!b4:b & J
UserForm1.Show
End Sub
. J . RowSource ComboBox1 b4:bJ. Show .
:
Sub CommandButton1_Click()
n = UserForm1.ComboBox1.ListIndex + 1
s = 0
For i = 1 To 4
b = Worksheets("1").Cells(n + 3, i + 2).Value
s = s + b
Next
a = s / 4
UserForm1.TextBox1.Text = a
End Sub
ListIndex, . TextBox1 .
1. Excel , , . .
2. , ..
3. Excel. , , , , .
MATHCAD
Mathcad , .
, , .
, 9 : ; ; ; ; , , , ; () ; Mathcad; ; .
|
|
/ . , , . .
. / . , , . Enter. .
, . / .
.
. . .
, . / .
Mathcad , , X .
:=, .
.
, x 1 2 0,1, : x:=1,1.1..2. .. (;) , .
, , .
. Mathcad . : () ( e); ln(x), log(x) ; log(x,n) n; sin(x), cos(x), tan(x), cot(x), sec(x), csc(x) , , , , ; asin(x), acos(x), atan(x), acot(x), asec(x), acsc(x) .
if(cond, x, y). cond , x, y.
:
- "" |
|
|
, f(x ) / , . . , . .
. , . : f(x,y):=x2+y2
, .
. / . .
(Variables) (Constants). / , Variables Constants. .
. : / / .
. / (/) .
. , , / / .
/.
. , , / ( Ctrl + M).
, .
0. Mathcad . n ([). , , . <> .
Mathcad (XY , ) ( , , , , ).
. 16 .
( ) ( ). , / X-Y .
( ). , . 8.1 , 3 2 0,1:
x:= 3, 2.9.. 2
y1(x):= cos(x) y2(x):= sin(x)
. 9.1 Mathcad
, , .
.
|
|
1. .
2. , .
3. x=-5, x=0,3, x=4.
4. :
= = =
D=AC, F=A-1B, AT .
5. y = k×x3+2×x25×x2. k . .